RE: SQL Server query
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: > > > > > > > > USERNAME="my_username" PASSWORD="my_password"> > > > SELECT * > > > FROM my_SQLServerDb.dbo.WebPages; > > > > > > > > > > > > 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
RE: SQL Server query (MDAC Version correction)
Sorry, I meant to say Component Checker indicates I'm currently running MDAC Version 2.6... Gene On 20 Jun 2001, at 13:59, [EMAIL PROTECTED] wrote: > 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: > > > > > > > > USERNAME="my_username" PASSWORD="my_password"> > > > SELECT * > > > FROM my_SQLServerDb.dbo.WebPages; > > > > > > > > > > > > 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
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: > > > > > USERNAME="my_username" PASSWORD="my_password"> > > SELECT * > > FROM my_SQLServerDb.dbo.WebPages; > > > > > > > > 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
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. 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: > > USERNAME="my_username" PASSWORD="my_password"> > SELECT * > FROM my_SQLServerDb.dbo.WebPages; > > > > 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
Re: SQL Server query (Followup)
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: > > USERNAME="my_username" PASSWORD="my_password"> > SELECT * > FROM my_SQLServerDb.dbo.WebPages; > > > > 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
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: > > USERNAME="my_username" PASSWORD="my_password"> > SELECT * > FROM my_SQLServerDb.dbo.WebPages; > > > > 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
RE: SQL Server Query Designer
That did it Aaron ... thanks! > -Original Message- > From: Aaron Johnson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 25, 2001 9:20 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: SQL Server Query Designer > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi Tim, > > I had this exact problem last night. Download MDAC 2.6 from MS (@ > www.microsoft.com/data/ ), install it, and you'll be fine. > > Aaron Johnson, MCSE, MCP+I > Allaire Certified ColdFusion Developer > MINDSEYE, Inc. > 617.350.0339 > 617.350.8884 > 66172567 > [EMAIL PROTECTED] > > ~~ 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
RE: SQL Server Query Designer
Sounds like a DLL missing. How about (re)installing the latest MDAC? Nick -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 2:04 PM To: CF-Talk Subject: OT: SQL Server Query Designer I'm running SQL7 on W2K Professional. When I try to use the query designer (right-click on table --> open table) I get an error message stating, "The query cannot be executed because some files or either missing or not register". I have re-installed SQL Server a number of times. I do have administrator rights on the machine. Anyone have any suggestions for me? Tim ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
RE: SQL Server Query Designer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tim, I had this exact problem last night. Download MDAC 2.6 from MS (@ www.microsoft.com/data/ ), install it, and you'll be fine. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~~ 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
