Thanks for your response. I am using TCL. Regards, Anirban
----- Original Message ----- From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, January 17, 2005 5:49 PM Subject: Re: [sqlite] Syntax problem in where clause of Select statement > Hi Anirban, > > Anirban Sarkar wrote: > > >Hi all, > > > >I have a variable xyz with the value 100. > >I want to write a sql statement in sqlite where the variable xyz should be in the 'where' clause. For eg: > >select * from 'tablename' where 'fieldname' = $xyz > > > > > What language are you using? > > You might want to use the sqlite3_bind_int API. > > http://www.sqlite.org/capi3ref.html > > HTH > > Ulrik P. > >
