Than you very much.
YOU SOLVED MY PROBLEM
--- Jann VanOver <[EMAIL PROTECTED]> wrote:
> Use square brackets around field and table names
> with spaces and see if that
> helps.
>
> For example:
> SELECT Date, [Total Orders], [Average Per
> Order],
> [Total Items Sold], [Total Dollar Amount Of Sales]
> FROM [Sales Totals By Day]
>
> -----Original Message-----
> From: monika kon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 11:28 AM
> To: CF-Talk
> Subject: RE: Report
>
>
> Hi,
> Thanks for your reply.
> I have already tried using the query of Access
> database in the tag <CFQuery>
> which is as follows
>
> <cfquery name="report1"
> datasource="ShoppingCart"
> dbtype="ODBC">
> SELECT Date, Total Orders, Average Per Order,
> Total Items Sold, Total Dollar Amount Of Sales
> FROM 'Sales Totals By Day'
> </cfquery>
> But this gives me the following error:
>
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access
> violation)
>
>
> [Microsoft][ODBC Microsoft Access 97 Driver] Syntax
> error (missing operator) in query expression
> 'Average
> Per Order'.
>
>
> SQL = "SELECT Date, 'Total Orders', Average Per
> Order,
> Total Items Sold, Total Dollar Amount Of Sales FROM
> 'Sales Totals By Day'"
>
> Data Source = "SHOPPINGCART"
>
>
> The error occurred while processing an element with
> a
> general identifier of (CFQUERY), occupying document
> position (6:2) to (8:23) in the template file
> F:\Www\industrial\report\report1.cfm.
>
>
> Date/Time: 03/16/01 14:25:58
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
> NT)
> Remote Address: 10.10.6.184
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
> I EVEN ADDED SINGLE CODE AROUND EACH FIELD BUT STILL
> THAT GIVES ME ERROR .PLEASE HELP!!!
>
> Thanks
> Shally.
>
> --- Dave Watts <[EMAIL PROTECTED]> wrote:
> > > I have an access table where my webmaster has
> made
> > > tables as well as queries. Please tell me can I
> > use
> > > these queries of Access Database in my
> ColdFusion
> > > program --in the tag <CFQUERY> the way the
> tables
> > > are used.
> >
> > You can call Access queries from CF. If they're
> not
> > parameter queries, you
> > can reference them as if they were tables in your
> > CFQUERY. If they are
> > parameter queries, you can use CFSTOREDPROC to
> call
> > them.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
