Search Results

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

Page 714/1022 | < Previous Page | 710 711 712 713 714 715 716 717 718 719 720 721  | Next Page >

• Why cant i use the field user in SQL Server 8?

  - by acidzombie24

  Maybe not literally but the query below gets an error near user. If i change it to userZ it works. WHY can i not use that name? Is there a way to specific its a field instead of a keyword? (or whatever it is) create table Post2 ( id INTEGER PRIMARY KEY NOT NULL, title nvarchar(max) NOT NULL, body nvarchar(max) NOT NULL, user integer REFERENCES Post1(id));

  Read the article

• Complex SELECT statement; one-to-many all details in one row

  - by RubyWedge

  There are two tables: Products ID (Primary Key), ProductName PlannedByMonths ProductID (Primary Key) (Link to the Products table many-to-one), MonthNumber (Primary Key), QtytoProduce, How to write SELECT statement to retrieve results in the following format? ProductName, QtytoProduceMonth1, QtytoProduceMonth2, QtytoProduceMonth3, QtytoProduceMonth4, QtytoProduceMonth5, QtytoProduceMonth6, QtytoProduceMonth7, QtytoProduceMonth8, QtytoProduceMonth9, QtytoProduceMonth10, QtytoProduceMonth11, QtytoProduceMonth12 Thank you.

  Read the article

• Sort MYSQL Data By Number of Entries

  - by Belgin Fish

  Hi, I'm wondering how I can sort mysql data based on the number of entries. I'm doing this so I can have a page of the top purchases, so it would have to retrieve all the product_id's from a table, and then sort them by the most times one shows up, limiting it to 10 or something. Thanks!

  Read the article

• How do I get records from the database for a particular interval?

  - by Vishal

  My table has records for every minute (for instance the column name is date), now I want to fetch records with an interval of 5 minutes! Can it be done at database level? I am using Django with MySQL

  Read the article

• how to update a specific field(column) of a row by that row's autoincrement value with some prefix

  - by I Like PHP

  i have below table it_id item_id item_name 1 ite_1 shirt 2 ite_10 pant 3 ite_11 socks 4 ite_12 shoes 5 ite_13 belt now i need to change item_id with with ite_(value of it_id of that row) means if it_id=x then item_id should be ite_x and so on... what will b sql query for that??

  Read the article

• how to search a string in structure variable ( C# )

  - by deep

  public struct Items { public string Id; public string Name; } public Items[] _items = null; if (_items.Contains("Table")) { // i need to check the structure and need to return correponding id } and am having a list of variables in my structure variable... i need to search a Name in the structure(_items) and i want to return the Corresponding Id. how to do this,

  Read the article

• Database Design Question

  - by Soo

  Ok SO, I have a user table and want to define groups of users together. The best solution I have for this is to create three database tables as follows: UserTable user_id user_name UserGroupLink group_id member_id GroupInfo group_id group_name This method keeps the member and group information separate. This is just my way of thinking. Is there a better way to do this? Also, what is a good naming convention for tables that link two other tables?

  Read the article

• Mysql select multiple colomn from non related tables

  - by Ajith

  I have two table in mysql named rootpath with only one field 'root' and savecatogory with fields brandid,categoryid,name.There is no relation between these two tables.Now how can retrieve root,brandid,categoryid using single query.Please help me.

  Read the article

• [SQL] Select 3 lastest order for each customer

  - by Ratiug

  Hi Here is my table CusOrder that collect customer order OrderID Cus_ID Product_ID NumberOrder OrderDate 1 0000000001 9 1 6/5/2553 0:00:00 2 0000000001 10 1 6/5/2553 0:00:00 3 0000000004 9 2 13/4/2553 0:00:00 4 0000000004 9 1 17/3/2553 0:00:00 5 0000000002 9 1 22/1/2553 0:00:00 7 0000000005 9 1 16/12/2552 0:00:00 8 0000000003 9 3 13/12/2552 0:00:00 10 0000000001 9 2 19/11/2552 0:00:00 11 0000000003 9 2 10/11/2552 0:00:00 12 0000000002 9 1 23/11/2552 0:00:00 I need to select 3 lastest order for each customer and I need all customer so it will show each customer and his/her 3 lastest order how can I do it sorry for my bad english

  Read the article

• How to refactor method which performs multiple steps (dependent on each other)?

  - by dotnetdev

  What is the best way to refactor a method which has many steps in it? For example, a method which setups some objects, creates several objects (Eg a database table), and so on - basically, one method which does a set of related steps. Would this be best suited to the command design pattern? Thanks

  Read the article

• sqlite insert into: do the column names have to match?

  - by P a u l

  (This question is specific to SQLite3, but it may be common to all SQL I don't know.) This doesn't seem to work. Is it because the column names don't match? (If they match, it works.) If this is true, how can I select from a different field in the source table? INSERT INTO [ImagePoint] (ImageID, PointID, X, Y) SELECT Image2ID, PointID, X, Y FROM Point

  Read the article

• SQL Server replication question.

  - by schar

  I had inherited this SQL Server where we put data in a table (Call TableA) on a database (DB-A). I can see the tableA in another database on the same server ( DB-B) gets the same data right away. Any ideas how this is implemented? I am trying to see the trace but so far no luck. Any one has an idea? At this stage I am not sure if its replication. This is a guess

  Read the article

• Is there a better way to select tables based on how many rows they have via jQuery?

  - by bubbahotep

  I'm looking to grab a group of tables that have more than X rows with jQuery. Currently, I'm doing something similar to: $("table").each(function(){ if($(this).find("tr").length > x){ tableArray[tableArray.length] = $(this); } }); and then acting on the members of the tableArray. Is there a better way of getting these tables, perhaps a nice selector I've missed? Thanks

  Read the article

• MySQL 'user_id' in where clause is ambiguous problem

  - by HoMe

  How can I correct the problem I keep getting from the code below which states 'user_id' in where clause is ambiguous. Thanks for the help in advance. Here is the mysql table. SELECT user.*, user_info.* FROM user INNER JOIN user_info ON user.user_id = user_info.user_id WHERE user_id='$user_id'

  Read the article

• Any easy way to delete a user (having many to many relation with role) in acegi, grails?

  - by john

  Hi, In default acegi setting, person and authority have many to many relations. Thus, in addtion to people and authorities, there is a table authotiries-people. To delete a person (a user) I have to delete the related record in authotiries-people first....then come back to delete the record... the problem is: other people are still using this authority (ROLE) could some one enlighten me how to delete the user without deleting the authority? thanks.

  Read the article

• in PHP how do i use range() for creating timing list?

  - by I Like PHP

  i want to create a table where first column have timing in below style timing | user1 | user2 | user3 ------------------------------- 9 AM | | | 10 AM | | | . | | | . | | | . | | | 6 PM | | | 7 PM | | | is it possible to use range() for creating timing list, if yes then please tell me , or if not then suggest me better method. Thanks always

  Read the article

• Docmd.TransferText to update data

  - by every_answer_gets_a_point

  i am using Docmd.TransferText to import data from a text file into my access table. i would like it to do the following: if the record already exists, then update it if the record does not exist then add it how do i accomplish this? currently i have this line: DoCmd.TransferText acImportDelim, yesyes, "table3", "C:\requisition_data_dump.txt", True

  Read the article

• MYSQL question - AND or OR?

  - by U22199

  Which is a better way to select ans and quest from the table? SELECT * FROM tablename WHERE option='ans' OR option='quest'"; OR SELECT * FROM tablename WHERE option='ans' AND option='quest'"; Thanks so much!

  Read the article

• how i can make a sort system depend on Character

  - by moustafa

  i mean i have songs table ok?? i want to make some things like that a | b | c | d click on a select from the database the songs that start by a Character how i can do that by the mysql???

  Read the article

• MySQL database populated dropdown box and PHP search

  - by Sanel Bajric

  I have question regarding search on webpage with textbox and dropdown box. I have table with fields: ID First name Last name Company name Occupation Description Now i need to make search form which will be populated from database (field Occupation) and textbox where I can put whatever I want, and then get results from database based on those on web page. I am really sorry but i am totally begginer and only need some examples of such kind of code and much help :) Thank you

  Read the article

• move UITableView items from left to right

  - by user262325

  Hello everyone I hope to move UITableView tiems fromn left to right and reload a new table array. I know it can done by navigationcontroller. But if there is a way without navigationcontroller. Thanks intterdev

  Read the article

• php fetch user data from mysql

  - by milodinosaur

  hi, currently i have 2 table in mysql structure: messages id | content | user_id | time submessages id | subcontent | msg_id | user_id | time submessages msg_id is FK for messages id. Now i need to query from php $cur_user = $user->current; // current user id. SELECT * FROM messages WHERE id > '{$_GET['id']}' // problem here how do i query submessages that posted by others not include current user? thank you.

  Read the article

• Linq to entity select items and give id

  - by GodSmart

  I have a table example you can see below ID Name Value 3 NameOne ValueOne 7 NameTwo ValueTwo 10 NameThree ValueThree I need to select with Linq to Entity and get results as you can see in example below: ItemID ItemName 1 NameOne 2 NameTwo 3 NameThree

  Read the article

• How can I get reports for last 24h in SQL?

  - by newbie

  I need to get all reports made in last 24h, table has CreatedDate column, so I need to check in database that report was created in last 24h. I know I can use getdate() to get current date, but how can I minus 24h from that attrbiute and then compare that date with CretedDate?

  Read the article

• I want to check if $('#td1').text() === "x"?

  - by M.z

  I want to check if innerHtml have X or O , so i can not add again any thing else , but it's not working . it stop after adding the check code , I'm trying here to do a simple X O game to get more familiar with javascript and jquery . also I'm not sure if can do this with jQuery . <script type="text/javascript" > function ranFun() { return Math.floor((Math.random() * 9) + 1); } var a; function Elment(a) { document.getElementById("td" + a).innerHTML = "O"; } function call() { var x = ranFun(); switch (x) { case 1:case 2 :case 3: case 4 :case 5 : case 6 : case 7 : case 8 : case 9 : Elment(x); break; default: break; } } function tdElm(c) { if ($('#td1').text() === "x" || $('#td1').text() == "o") return false; else { document.getElementById("td" + c).innerHTML = "x"; call(); } } </script> <BODY> <center> <h1 >" X ,O Game "</h1> <table > <tr> <td id="td1" onclick="tdElm(1);" ></td> <td id="td2" onclick="tdElm(2);"></td> <td id="td3" onclick="tdElm(3);"></td> </tr> <tr> <td id="td4" onclick="tdElm(4);"></td> <td id="td5" onclick="tdElm(5);"></td> <td id="td6" onclick="tdElm(6);"></td> </tr> <tr> <td id="td7" onclick="tdElm(7);"></td> <td id="td8" onclick="tdElm(8);"></td> <td id="td9" onclick="tdElm(9);"></td> </tr> </table> </center> </BODY>

  Read the article

< Previous Page | 710 711 712 713 714 715 716 717 718 719 720 721  | Next Page >