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" <florentina_kore@stripped>
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.
: Do you Yahoo!?
: Protect your identity with Yahoo! Mail AddressGuard