>- see footer for list info -< Similar problem to what or who? If you're getting SQL errors, output the SQL string and see what's wrong with it.
Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Shawn Fawcett Sent: 24 March 2006 14:14 To: Coldfusion Development Subject: [CF-Dev] similar Date criteria ColdFusion/Access problem >- see footer for list info -< Hi all, I'm having a similar problem with the date & yes it is actally calculing the date... here it is: <cfset query_string = "INSERT INTO tblDailyRates (CurrencyRateDate"/> <cfloop index="i" from="1" to="#ArrayLen(top.xmlchildren)#"> <cfset child = top.xmlchildren[i] /> <cfset query_string = query_string & ",#child.xmlattributes.currency#"/> </cfloop> <cfset query_string = query_string & " ) VALUES (#DateFormat(CreateODBCdate(CurrencyRateDate),"dd/mm/yy")#" /> ARAXI Traductions France 100 Passage Henri Régnault - 92400 Courbevoie La Défense 6 Tél. : 01 49 03 41 49 - Fax : 01 49 03 41 42 _________ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
