I've narrowed this issue down a bit...
Seems the query works fine if it reads:
SELECT field1, field2, etc
FROM Table
but it throws an error with
SELECT *
FROM Table
Running MSDE (SQL Server 7) and CF 4.0.1. Why would the
asterisk throw an error?
Gene Kraybill
On 20 Jun 2001, at 10:34, [EMAIL PROTECTED] wrote:
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists