Re: Perl DBI, for archiving

[Vivek Khera]

>>>>> "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.


								v.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       [phone]
PGP & MIME spoken here            http://www.kciLink.com/home/khera/