>>You've got a semi-colon at the end of your SQL statement. Although this
>>would work fine in the SQL Query tool, within a CFQUERY it will not.
I don't think this is true - you can legally use semi colons in a cfquery
providing you are using ODBC 2 as this supports the use of multiple SQL
statements separated by semi colons.
-----Original Message-----
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: 20 June 2001 17:05
To: CF-Talk
Subject: RE: SQL Server query
You've got a semi-colon at the end of your SQL statement. Although this
would work fine in the SQL Query tool, within a CFQUERY it will not.
Also, you don't need to specify the entire object path to the table, just
the tablename itself. This has nothing to do with the error you got; it's
just an FYI.
---mark
------------------------------------
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
====================================
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 10:34 AM
> To: CF-Talk
> Subject: SQL Server query
>
>
> I'm having difficulty getting a test template to work after
> setting up MSDE
> and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so
> it may be something obvious...
>
> I get this error:
>
> -------------------------
> CMemoryException: unknown cause
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> The error occurred while processing an element with a general
> identifier of
> (CFQUERY)...
> -------------------------
> The error comes from this very simple template:
>
> <CFQUERY NAME="test" DATASOURCE="my_SQLServerDb"
> USERNAME="my_username" PASSWORD="my_password">
> SELECT *
> FROM my_SQLServerDb.dbo.WebPages;
> </CFQUERY>
>
>
> Don't know if it could be a permissions error. I'm still coming
> up to speed
> with how they work in SQL Server. I do have the ODBC datasource for this
> db set up with the username and password shown in the query, and I've set
> Object Permissions for the WebPages table to include the use of SELECT
> for this username ...
>
> Gene Kraybill
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
