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