I'm drawing a blank on an error I'm getting inserting a "date" (2001070112:00:00) into a varchar field. Cannot execute: You have an error in your SQL syntax near ':00:00)' at line 1 my $sql=q{INSERT INTO some_table(the_date) values(?)}; my $sth=$dbh->prepare($sql); $sth->execute($the_date) || die "Cannot execute: $DBI::errstr\n"; What could be wrong? Jeff
- Re: sql error Jeff Thies
- Re: sql error Mike<mickalo>Blezien
- RE: sql error Stephen Howard
- RE: sql error Laurie Gennari
- RE: sql error Jones Robert Contr 81 CS/SCK