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?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
