Search Results

Search found 25547 results on 1022 pages for 'table locking'.

Page 393/1022 | < Previous Page | 389 390 391 392 393 394 395 396 397 398 399 400  | Next Page >

• Should I store logging information in main database tabel?

  - by Mike

  For example, say I have a table of products. Should I store logging information such as who it was created by, last edited by, last updated date, ... Or should I separate the logging information in say an auditing table if the logging information is not relevant to the actual application? Thank you.

  Read the article

• How to make a data-bound combo box display (like a DisplayMember) a concatenated string?

  - by Ivan

  I have a first name and a surname as separate columns in a table. If I bind a combo box to a query and set DisplayMember property to "Name" then each person a table is represented in a combo box by its name. How do I show each person's full name (built from concatenating 2 columns) in a single comb box item in this case?

  Read the article

• MySql Alter Syntax error with mulitple FK

  - by acidzombie24

  If i do the first one i have no problem. When i do addition i get a syntax error. What is wrong with the syntax? The error says syntax error near [entire 2nd line] alter table `ban_Status` add FOREIGN KEY (`banned_user`) REFERENCES `user_data`(`id`) alter table `ban_Status` add FOREIGN KEY (`banned_user`) REFERENCES `user_data`(`id`), FOREIGN KEY (`banning_user`) REFERENCES `user_data`(`id`), FOREIGN KEY (`unban_user`) REFERENCES `user_data`(`id`)

  Read the article

• mysql join 3 tables and count

  - by air

  Please look at this image here is 3 tables , and out i want is uid from table1 industry from table 3 of same uid count of fid from table 2 of same uid like in the sample example output will be 2 records Thanks

  Read the article

• How to close a jquery dialog box when a submit button is clicked(Submit button is residing inside the dialog box)

  - by user1268313

  i have struts2 form inside a jquery dialog box, when i submit my form inside that dialog box my Struts2 action is performing but that pop up jquery dialog box is not closing. How can i close that dialog box when![enter image description here][1] i submit my form? <table> <tr> <td> <td align="center" > <sj:head jqueryui="true" jquerytheme="cupertino" /> <sj:dialog id="mybuttondialog" autoOpen="false" showEffect="fadeIn" hideEffect="fadeOut" modal="true" title="Rename" > <s:form action="EditDayActionUserTemplate" id="formId323"> <table style="height:48px;width: 100%;" cellpadding="0" cellspacing="0" border="0"> <tr> <td colspan="2" align="center"> <input type="hidden" name="dayId" value="<%=daycont%>"/> <input type="hidden" name="workoutId" value="<%=trid%>"/> </td> </tr> <tr> <td width="50%" align="right"><font size="6px">Date</font></td> <td width="50%"> <sj:datepicker id="datghfe4" name="date" value="%{#parameters['date']}" label="Select Date" appendText=" (dd.MM.yy)" displayFormat="dd.M.yy"/></td> </tr> <tr> <td>&nbsp;</td> <td align="right"><sj:submit formIds="formId323" id="sdfdss3" button="true" value="Rename" targets="rightmiddiv"></sj:submit></td> </tr> </table> </s:form> </sj:dialog> <sj:submit openDialog="mybuttondialog" value="Rename" button="true" /> </td> </tr> </table>

  Read the article

• Extending DataGrid/Changing DataGrids header

  - by drasto

  Is there any way how to override DataGrids header line ? Or at least its behaviour ? I'm trying to implement Outlook-like grouping of the table. That is allow user to drag column header out of the table to the dedicated area to sort by that column (for example XamDataGrid has that feature, you can see how it works here). I cannot use any commercial solutions. I will be thankfull for any experiences, ideas, code, notes or tutorials.

  Read the article

• Question on XJB

  - by Hima

  I have two tables -- INSTALL_BUILD_RESULTS and BUILD_RESULTS. IBR has a primary key called Install_Build_Id and BR has a primary key called Build_Id. Both are numbers A third table, LINK_BUILD_TO_INSTALL_BUILD is a table simply consisting of the two columns mentioned above, used together as a composite key. How can I write an xjb for these 3 tables.

  Read the article

• Using jQuery, how can I obtain form data from fields that have been added by manipulating the DOM?

  - by Travis

  I have a table body that grabs it's rows (and form fields) via AJAX on various events. Everything is working fine, except one part: I can't obtain form data from any of the table's rows after it gets manipulated. I've played around with the live() function, but I can't seem to get the right setup to pull in the form data. Any ideas?

  Read the article

• A SELECT statement for Mysql

  - by Hossein

  I have this table: id,bookmarkID,tagID I want to fetch the top N bookmarkIDs for a given list of tags. Does anyone know a very fast solution for this? the table is quite large(12 million records) I am using MySql

  Read the article

• Using mysql i need to retrieve which are inserted last in every category.

  - by Fero

  Hi, My prob in brief: I have two tables namely category and product. table: category id category 1 cat1 2 cat2 3 cat3 4 cat4 table: product id productName category 1 test1 1 2 test2 2 3 test3 3 4 test4 4 5 test5 2 6 test6 2 My prob is: I need products which are inserted last in every category. How to solve this. thanks in advance

  Read the article

• Autoincrement based on a set of other columns

  - by slack3r

  I have a table Course and every Course has many Resources. Course ========== course_id Resource ========== course_id number I want something like a seperate autoincrement for each course_id. Or, in other words, I want to auto-enumerate the resources for a given course. For example, the resource table could look something like: course_id | number ================== 1 | 1 1 | 2 2 | 1 1 | 3 1 | 4 2 | 2 2 | 3 and so on. I want to do this in SQL, using IBM DB2.

  Read the article

• mysql get last auto increment value

  - by Mick

  Hi I have a field in mySql table called jobnumber which auto increments with each new entry. What I want to do is when a user views my form, get the value of the next 'jobnumber' . But I want to do this before any entry is made to the table. IE so when a user looks at a form it will display something like 'this is job number 6954' I have tried $rr = mysql_insert_id() but this only work after I have made an entry Can anyone help please thanks

  Read the article

• mysql insert with auto-increment column

  - by czuroski

  Hello, I am trying to insert data into a mysql table from a csv file. I am using the infile sql command, but I am having trouble because the first column of the table is an id that is set as an auto increment field. what do I have to set my first column value to in order to get this to work, or can I do it at all? Thanks

  Read the article

• Fractional y-var in ggplot

  - by Misha

  How can I easily create a fractional y-value when using ggplot? t <- as.factor(test=sample(seq(0,100,10),1000,rep=T)) d <- as.factor(sample(c(0,1),1000,rep=T) p <- data.frame(t,d) My best shot was: ggplot(p,aes(x=t,y=prop.table(table(t,d),1)[,1])) + geom_point() However this doesnt work and I guess there is an easier way around this...

  Read the article

• Entity Framework 4 omits some associations during model generation

  - by kzen

  After creating an EF4 model from a SQL Server database I noticed that all the relationships of my Users table were not imported into the model as associations. All the other relationships were imported fine. My Users table has a PK userId which is a char(7) field and it is integrated into several other tables in the database as an FK but for some reason EF4 does not import these relationships as associations during the model generation process... Does anyone have any ideas why this would be happening?

  Read the article

• Managing trace files on Sql Server 2005

  - by Sophtware

  I need to manage the trace files for a database on Sql Server 2005 Express Edition. The C2 audit logging is turned on for the database, and the files that it's creating are eating up a lot of space. Can this be done from within Sql Server, or do I need to write a service to monitor these files and take the appropriate actions? I found the [master].[sys].[trace] table with the trace file properties. Does anyone know the meaning of the fields in this table?

  Read the article

• How to use Linq To Sql to get Users who has more than 2 photos?

  - by Mike108

  The scenario is I want to get the users who has more than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) and UserId is a Foreign Key. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List who has more than 2 photos?

  Read the article

• jpa relationship-Google app engine

  - by megala

  I created two tables in google appengine datastore using JPA. Table1: *groupname pk *groupid *groupdesc *emailper Table2: *groupname *memberid *membername My constraint is if i enter data into table2 it check whether group already exists or not in table.If exists than only it store the data into table .How to solve this?

  Read the article

• Ideas for an office games/recreation room. [closed]

  - by the-locster

  Recreation is an important part of office life. What do you have or what would you like to have in an in-office recreation room? Some obvious ones to get the ball rolling: video games table football air hockey building bricks pool table

  Read the article

• mysql command for update

  - by Mac Taylor

  hey guys i need to add a special text to all rows in my mysql table , how to add some text to the end of all rows' content in a table just for one field i used this code : UPDATE `blogs` SET `title`= `title`+ 'mytext'; but didnt work for me

  Read the article

• Replace a control on the screen

  - by Rob Bonner

  Hello all, I have an instance of a FlowCoverView (a great library that emulates cover flow on the iPhone). And it works great, with the exception of an update. When I update my table behind the scenes, I have no way of telling this control (that is defined in IB) that it has been updated, and to reload. (much like you can with a table using reloadData) To the question, is there a way to replace a control that is on the screen with another control to force the reload?

  Read the article

• What do you call the concept of dynamic data definition?

  - by DJTripleThreat

  Maybe this is simpler and more straightforward then what I'm thinking but I can't seem to find this concept on google anywhere. The concept is this: You have a table in a database and the table has a specified number of columns. However, it has been asked of me by previous clients that there also be a set of dynamic user defined columns that can be added on the fly. What is this concept called and is it considered a design pattern?

  Read the article

• MYSQL and Array with PHP for create Tag Cloud

  - by asilloo

  Hi, I'm trying to make a Tag cloud for every user in own page, I'm using PHP5 and Mysql, My table named "tags" and I want to make a array but in short way. The table like below, The array can be like for user1 array={[car,1],[cat,null],[pen,1],[dvd,1],[cd,null]} Username totaltag tag1 tag2 tag3 tag4 tag5 admin 5 car cat pen dvd cd user1 1 1 1 user2 1 2 12 1 user3 3 2 10 1

  Read the article

• [Zend Framework] How to format Zend_db Rowset output?

  - by rasouza

  I have a model which is referenced to a table registries extending Zend_Db and some methods which bascially uses fetchAll() all the time. What happens is: my table has a DATE field and I'd like it to output already formated when I call $row-reg_date. Is it possible by doing something in the model or do I have to manually format?

  Read the article

• How can I change column length using HQL query?

  - by gmugmu

  I tried session.createSQLQuery("ALTER TABLE People MODIFY address VARCHAR(1000);").executeUpdate(); but this throws org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query After a lot of googling, the recommendation is to use HQL instead of SQL query to do bulk updates. Not sure how to use HQL to accomplish this. There seems to be no decent HQL documentation for updating column length in a table. Thanks so much for the help.

  Read the article

< Previous Page | 389 390 391 392 393 394 395 396 397 398 399 400  | Next Page >