On 1/26/01, Jay Patton penned:
><cfquery name="GetTotal" datasource="????????" dbtype="ODBC">
>SELECT Sum(Total) AS OrderTotal
>FROM StoreOrders
>WHERE SessionID = #CFTOKEN#
>AND Processed = 0
></cfquery>
I would guess that either the SessionID field or Processed field is a
text field. Use single quotes around the parameter if it is.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
