Bruce Johnson schreef: > I'm trying something along the lines of: > > insert into foo(fname, lname, phone, dateadded, status, datemodified) > values (?,?,?,curdate(),1,curdate()) > > and it's failing saying I have an sql error at ...curdate(). > > "DBD::mysql::db do failed: You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near ' curdate())' at line 1 at ./ > webdirectory_updater.pl line 128." > > I cannot mix parameters and functions like that?
The error has a space in front of "curdate())", so probably your SQL statement is a bit different from what you think. Did you copy/paste it in your posting (good), or typed it in again (bad)? -- Affijn, Ruud "Gewoon is een tijger."
