Page 2 of 2

Posted: Tue Sep 10, 2002 5:39 am
by mikeq
If searching on a field that is an Int then no quotes are required.

select *
from mytable
where myintvalue = $myint

However, you can also use quotes in this query and it will work just as well

select *
from mytable
where myintvalue = '$myint'

If it is a string field type then quotes must be used

select *
from mytable
where mystringvalue = '$mystring'

Posted: Tue Sep 10, 2002 6:47 am
by jason
Takuma, yes, though this is postgresql.

Posted: Thu Sep 12, 2002 3:40 am
by Love_Daddy
I used sjunghare's method and it worked fine.