>- see footer for list info -< you need to get single quotes around the date string - the easiest way may be to use the <cfqueryparam> tag
On 3/28/06, Shawn Fawcett <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Similar problem to Roger Broadhurst 's posting on 23/03/2006 > > the date is being entered into the access > database as the result of a calculation. eg for > yesterday instead of 27/03/2005 is calculates 27 > devided by 3 devided by 2005 = 31/12/1899 > 12:00:00 in a date field or 1.5 in a number field. > > there are no sql errors. the string looks like this: > q_addCurrency (Datasource=araxi, Time=0ms, > Records=0) in > C:\CFusionMX7\wwwroot\ARAXI_DEV\wwwroot\dsp_home_cover_french.cfm > @ 08:34:29.029 > INSERT INTO tblDailyRates > > (CurrencyRateDate,USD,JPY,CYP,CZK,DKK,EEK,GBP,HUF,LTL,LVL,MTL,PLN,SEK,SIT,SKK,CHF,ISK,NOK,BGN,HRK,RON,RUB,TRY,AUD,CAD,CNY,HKD,IDR,KRW,MYR,NZD,PHP,SGD,THB,ZAR > ) VALUES > (27/03/06,1.2025,140.15,0.5759,28.670,7.4617,15.6466,0.68830,264.18,3.4528 > ,0.6960,0.4293,3.9048,9.3550,239.59,37.565,1.5733,86.84,7.9670,1.9558, > 7.3280,3.5112,33.4150,1.6160,1.6999,1.4100,9.6495,9.3312,10876.61,1173.22, > 4.4432,1.9753,61.496,1.9460,46.807,7.5168) > > > > > At 12:35 25/03/2006, you wrote: > > >- 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 > -< > > 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 > -< > -- Mike T Blog http://www.socialpoints.com/ _______________________________________________ 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 -<
