what type is item_id? That query is looking for a value in the field item_is that is equal to the a constant string "itemId"..... is there a record with the value in it?
----- Original Message ----- From: "florentina kore" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 13, 2003 5:18 PM Subject: problem running the following query : Hi , : I am using mySQL on windows 98 machine. : In my (java)program I want to run the following query : : query = "Select * from kids_books where item_id = 'itemId' "; : : I get the itemId as a parameter from one of the functions. : When i run this query I am not getting any out put. : I have checked that the data is there in the table for this query. : : please let meknow what is wrong with the query. : : thanks, : florentina : : : : --------------------------------- : Do you Yahoo!? : Protect your identity with Yahoo! Mail AddressGuard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]