>- see footer for list info -< Yeah - it looks like a string and not a number...
Paul, here's a quick lesson. Strings need quotes Numbers do not. A number with a pound sign and commas in it will be treated as a string. Also, �8,636.00 will be treated as 2 values due to the comma separating it. SO here you have the string '�8', and the numeric value 636.00. I hope this helps. Ta Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adam Reynolds Sent: 20 November 2004 00:13 To: 'Coldfusion Development' Subject: RE: [CF-Dev] INSERT .... >- see footer for list info -< Well, Total cost should probably not contain the currency in the insert...at a guess. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Paul > Swingewood > Sent: 19 November 2004 11:12 > To: [EMAIL PROTECTED] > Subject: Re: [CF-Dev] INSERT .... > > >- see footer for list info -< > Nick, More of the error message .... > > SQL INSERT INTO tblOrderDetails ( OrderDate, Dfes, ContactName, > FocusArea, PackageIDFK, Quantity, TotalCost ) VALUES ( '19 > Nov 2004', '2296', 'Paul Swingewood', 'Technology Shed', 3, > 4, �8,636.00 ) > DATASOURCE whiteboard > VENDORERRORCODE 110 > SQLSTATE 21S01 > > > Regards - Paul > > > _______________________________________________ > > 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 -< _______________________________________________ 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 -<
