On 7/23/07, Jon Baer <[EMAIL PROTECTED]> wrote:
Id guess that one of your data types (or more) is still not valid for
the type declared but ~not sure if you know this~ but you can add
column names before your query ...

INSERT INTO my_table (col1_name, col2_name) VALUES (col1_value,
col2_value) // Try a few values up until you error out


I find it even less confusing to use the SET variant that makes
INSERTs look like UPDATEs:

INSERT INTO my_table SET col1_name=col1_value, col2_name=col2_value;


--
Chris Snyder
http://chxo.com/
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php

Reply via email to