Interesting. My opinion on the matter is don't fix something that isn't
broken. Your first query, where you name the columns, is actually better
anyway.
SELECT * should be avoided whenever possible.
---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 1:59 PM
> To: CF-Talk
> Subject: RE: SQL Server query
>
>
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
