ahh i see, thank you philip i will just convert it then.
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 1:41 PM
Subject: RE: SUM rounding
> > Error Diagnostic Information
> > ODBC Error Code = 37000 (Syntax error or access violation)
> >
> > [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Convert'
in
> > expression.
> >
> > The error occurred while processing an element with a general
> > identifier of
> > (CFQUERY), occupying document position (1:1) to (3:23).
>
> CONVERT is a SQL Server command
>
> Not sure about Access as it's been about 2-3 years since I've had to write
> any SQL in it...
>
> <Runs off to test in Access>
>
> The simple tests I've just done in Access were on Double numeric fields -
> this returns decimals quite happily
>
> More testing required I think
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
