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,SomethingDate='' WHERE JobNumber = 9997 and send this to mySQl via ODBC Problem. When the Filemaker date is blank the calculated field is produces SomethingDate=''. After the Insert or update the mySQL field is 0000-00-00. And in the php form shows up as 00/00/0000. How can I get the date to be blank in mySQL. thanks jrt --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
