List:General Discussion« Previous MessageNext Message »
From:Haydies Date:November 13 2003 5:22pm
Subject:Re: problem running the following query
View as plain text  
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>
To: <mysql@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.
: thanks,
: florentina
: ---------------------------------
: Do you Yahoo!?
: Protect your identity with Yahoo! Mail AddressGuard

problem running the following queryflorentina kore13 Nov
  • Re: problem running the following queryMartijn Tonies13 Nov
  • Re: problem running the following queryHaydies13 Nov