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 >

• 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

• What does this error mean in the contex of import excel data into a Sharepoint list?

  - by Jeremy

  After choosing 'Range Type:' Table Range and 'Select Range:' Sheet1!Table1 I get the error pop-up 'Import to Windows SharePoint Services list' 'Cannot connect to the server at this time. Your table cannot be published.' Is there somewhere in my computer I can look at for more information as to what I am doing wrong?

  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

• 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

• Parsing Tabular cell data with space where there is td tag.

  - by Harikrishna

  I am parsing html tabular information with the help of the html agility pack. Now First I am finding the rows in that table like var rows = table.Descendants("tr"); then I find the cell data for each row like foreach(var row in rows) { string rowInnerText = row.InnerText; } That gives me the cell data.But with no spaces between them like NameAdressPhone No but I want the innertext like Name Address Phone No means where there is td tag I want to keep there one space between different column cell.

  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

• MySQL counting question

  - by gew

  How do I find out which user entered the most articles and then count how many articles that user entered using PHP & MySQL. Here is my MySQL tables. CREATE TABLE users_articles ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id INT UNSIGNED NOT NULL, title TEXT NOT NULL, acontent LONGTEXT NOT NULL, PRIMARY KEY (id) ); CREATE TABLE users ( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(255) DEFAULT NULL, pass CHAR(40) NOT NULL, PRIMARY KEY (user_id) );

  Read the article

• Validation - Data Integrity

  - by Thomas

  A table can only store 10 records in a particular state, 10 users over 30 years for example, the others must be less than 30 years. It is a business rule and as such should be respected. How to ensure that state? Think: multiple users accessing this table.

  Read the article

• SSIS package in SQL Server 2005 can send data to SQL Server 2008?

  - by needshelp

  Hi SSIS Geniuses, I Have an SSIS package in SQL Server 2005 that takes data from a flat file and puts it in a table in SQL Server 2005. Now I want it to send it to an additional location along with the 2005 location. This new table is in SQL Server 2008. Can it be done without porting my SSIS package to SQL Server 2008? Thank you for your help in advance.

  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 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

• 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

• 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

• Is there a web-like DB tool for navigating relational databases?

  - by Caffeine Coma

  Is there a tool that implements hyperlink-style navigation between tables via foreign keys? Web-based or native app. For example, if I have table Users, with a column containing a foreign key reference to table Preferences, such a tool would implement simple 1-click access between the rows of the two tables, automatically creating links based on foreign keys.

  Read the article

• Can I lock tables in an IF statement in MySQL?

  - by MalcomTucker

  This is throwing a syntax error - --from body of a stored proc IF (name = in_name) SET out_id = temp; ELSE LOCK TABLE People WRITE; INSERT INTO People (Name) VALUES (in_name); UNLOCK TABLE; SELECT LAST_INSERT_ID() INTO out_id END IF do I have to lock any tables I need at the start of the SP?

  Read the article

• Paging in my web page

  - by Jibu P C_Adoor

  Hi, I have a large data set and i have to apply paging on that data set and after that the result set should be another data set. What is the reliable method to achieve that. I have tried with 'PagedDataSource' class but i don't know how it is possible to convert to dataset or data table. In my case i need a general solution. I have to bind to a control like gridview as well as i have to used it with normal html table.

  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

• 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

• 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

• 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

• SQL query joining rows with same value

  - by user1285737

  I need to write a query that creates a view that calculates the total cost of each sale, by considering quantity and price of each bought item. The view should return the debit and total cost. In the answer each debit-number should only occur once. Thanks in advance Table ITEM: ID NAME PRICE 118 Jeans 100 120 Towel 20 127 Shirt 55 Table DEBIT: DEBIT ITEM Quantity 100581 118 5 100581 120 1 100586 127 5

  Read the article

• Insert or update when product is present using mysql

  - by Aryan

  main_product table productid outward shopid 333 2 44//present 343 4 44//present 353 5 44//present 363 1 44//present 373 2 44//not present min_product table productid outward shopid 333 1 44 343 1 44 353 1 44 363 1 44 SELECT DISTINCT (A.productid),A.outward, B.productid,B.outward FROM main_product A INNER JOIN min_product B on B.productid=A.product_id where A.shopid='44' and B.shopid='44' my question how can i INSERT OR UPDATE in one query using mysql by checking if it is present or not if present update else insert something like this? INSERT INTO mytable (key, value) VALUES ($newkey, $newvalue) ON DUPLICATE KEY UPDATE SET value = $newvalue

  Read the article

• updating uitableview after performing paste from the cell

  - by Nava Carmon

  Hi, I've implemented edit menu from my custom UITableViewCell class. I have a small problem of updating a table view from inside the custom table cell class. What is the best approach to do that? TIA

  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

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