Re^4: Perl/SQL syntax error

Thanks Morgon. I have done that, but now have a new error msg - I'll sort that one out myself. Data is now being inserted into my table, but there seems to be a formatting problem in the date column. Back to the drawing board. Thanks for all the invaluable advice. I have learned something new today, and I am very happy with that.

Comment on Re^4: Perl/SQL syntax error

Replies are listed 'Best First'.
Re^5: Perl/SQL syntax error by graff (Chancellor) on Jul 04, 2009 at 14:45 UTC
The standard, default date format for mysql is just "2009-07-04 10:45:23". Make your date string look like that, and you'll do fine.	[reply]
Re^6: Perl/SQL syntax error by patt (Scribe) on Jul 05, 2009 at 19:24 UTC
Yes I noticed that slight problem. I was using the European time syntax, then realised that SQL used a different format... Thanks for your help	[reply]