[thelist] weird MySQL insert problem

noah noah at tookish.net
Fri Mar 1 00:08:01 CST 2002


At 12:52 AM 01/03/2002, Shashank Tripathi wrote:
>Is there any particular reason why you are inserting it as a string, but
>selecting it as a number? Try:
>
>     SELECT * FROM candidate_information WHERE can_id = '999';

Sorry, that's just me being sloppy.

The record definitely isn't there, either as 999 or '999'. When I just
"SELECT * from candidate_information" I can look through the whole table
and there's definitely nothing even resembling 999.

Thanks, though.

Cheers,
Noah




More information about the thelist mailing list