How about: INSERT INTO tblFeed( PMEDICDATE ) VALUES ( <cfqueryparam cfsqltype="cf_sql_timestamp" value="#qGetData.PMEDICDATE#" null="#NOT isDate(qGetData.PMEDICDATE)#"> )
I added the 'null' attribute, and also the hashes you forgot around the value. cheers, barneyb On Mon, 22 Nov 2004 19:57:23 -0400, Brant Winter <[EMAIL PROTECTED]> wrote: > hi - I have now spent 1 whole day trying to import a whole stack of CSV data > into a MSSQL table. My insert query keeps falling over when it hits an empty > date field. > > The MSDE table has a datetime field to enter this particular date into, but > some of my CSV fields have empty dates, and will continue to have empty dates > from time to time. > > I have tried: > > INSERT INTO tblFeed( > PMEDICDATE > ) VALUES ( > #CreateODBCDateTime(qGetData.PMEDICDATE)# > ) > > and: > > INSERT INTO tblFeed( > PMEDICDATE > ) VALUES ( > <cfqueryparam cfsqltype="cf_sql_timestamp" value="qGetData.PMEDICDATE"> > ) > > I just cant get anything to work, I can import data until it hits a row with > an empty date field. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
