I've discovered the CFQUERY actually works fine if the SQL is like
this:
SELECT field1, field2
FROM Table
(with or without the semi-colon)
....but it fails on:
SELECT *
FROM Table
Could this be an MDAC version issue? When I installed Ent Mgr, it
apparently installed MDAC 6, according to the results of
Component Checker. If it's MDAC-related, how tricky is it to go
back to MDAC 2.1 SP2?
Gene Kraybill
On 20 Jun 2001, at 9:05, Mark Warrick wrote:
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
