RE: Insert/UpDate dates

2003-03-05 Thread Mike Hillyer
--Original Message- From: John Thorne [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:51 PM To: [EMAIL PROTECTED] Subject: Insert/UpDate dates Working on a routine to export a Filemaker data to mySQL for php application. Using scripts I build a calculated field below: INSERT INT

Insert/UpDate dates

2003-03-05 Thread John Thorne
Working on a routine to export a Filemaker data to mySQL for php application. Using scripts I build a calculated field below: INSERT INTO abctable (JobNumber, JobTitle, AE, Client, StartDate) VALUES (9997, ' ABC ' , 'jrt' ,1234, '') or UPDATE abctable SET JobTitle='ABC',AE='jrt',Client=1234,Some