>- see footer for list info -< <cfset query_string = "INSERT INTO tblDailyRates (column1,column2) VALUES (#Date# " />
K > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dev- > [EMAIL PROTECTED] On Behalf Of Shawn Fawcett > Sent: 15 March 2006 09:51 > To: Coldfusion Development > Subject: RE: [CF-Dev] parsing xml and inserting into Access2000 > > >- see footer for list info -< > that fixed that problem. I also got rid of the > quotes around '#child.xmlattributes.rate#' > > the thing though is my first field CurrencyRateID > (autonumber) needs somehow to be skipped...the > date is trying to go into the autonumber field. > > To avoid this I'd like to explicitly name the > destination columns. how could I do this? > > > > > At 10:15 15/03/2006, you wrote: > > >- see footer for list info -< > >Your problem is with the date format, first up, you don';t need the quotes > >around dates, so try... > > > ><cfset query_string = "INSERT INTO tblDailyRates VALUES (#Date# " /> > > > >If that still throws an error try > > > ><cfset Date = createODBCDate(top.xmlAttributes.time) /> > >Instead of your dateformat line. > > > >-----Original Message----- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Fawcett > >Sent: 15 March 2006 05:38 > >To: Coldfusion Development > >Subject: [CF-Dev] parsing xml and inserting into Access2000 > > > > >- see footer for list info -< > >I'm trying to get the code below to insert data > >into a currency rate table. The table fields are: > >ID (autonumber), Date, USD, JPY, CYP, and another > >30 odd currencies. I'm getting the following > >error: "Error Executing Database Query. > >[Macromedia][SequeLink JDBC Driver][ODBC > >Socket][Microsoft][ODBC Microsoft Access Driver] > >Syntax error (missing operator) in query expression '''2006-03-14'''. " > > > >not quite sure what I'm missing here. > >thanks for any help, > >Shawn > > > > > > <cfhttp > >url="http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml"; method="get" /> > > <cfset xml = XMLParse(cfhttp.filecontent) /> > > <cfset top = "#xml.xmlRoot.Cube.Cube#" /> > > <cfset Date = DateFormat(top.xmlAttributes.time,"yyyy-mm-dd") /> > > <cfset query_string = "INSERT INTO tblDailyRates VALUES ('#Date#'" /> > > <cfloop index="i" from="1" to="#ArrayLen(top.xmlchildren)#"> > > <cfset child = top.xmlchildren[i] /> > > <cfset query_string = query_string & ",'#child.xmlattributes.rate#'" > >/> > > </cfloop> > > <cfset query_string = query_string & ")" /> > > <cfquery name="q_addCurrency" > >datasource="#application.DS#" > >username="#application.dbuser#" password="#application.dbpass#"> > > #query_string# > > </cfquery> > > > > > > > >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 -< > > > > > > > >_______________________________________________ > > > >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 -< > > 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 -< _______________________________________________ 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 -<
