>>>>> "CK" == Charles Kirby <kirbych@stripped> writes:
CK> Thanks, I'm still trying (and failing)...
CK> maybe it has something to do with the fact that "sid" is an integer, and
CK> that I can't get wildcards to work.
CK> For instance, this works from the command line:
mysql> select sid from slips;
CK> this gets all the "sid"s, but if I try to do:
mysql> select sid from slips where sid=?;
CK> or "" where sid='?';, sid=%; etc etc, I always
CK> get "Empty set (0.00 sec)"
CK> Is there a way of specifying the wildcard for integer fields?
Wildcard substitution is a DBI thing, not a mysql command line thing.
try "select sid from slips where sid=3;" in mysql command prompt.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
PGP & MIME spoken here http://www.kciLink.com/home/khera/