RE: Sql error during insert
-Original Message- From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: 11/14/06 7:17 PM Subject: Sql error during insert I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. cfset mylist=Antiques Art Baby Books Business Industrial Cameras Photo Cars, Boats, Vehicles Parts Cell Phones PDAs Clothing, Shoes Accessories Coins Paper Money Collectibles Computers Networking Consumer Elec ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sql error during insert
If this is a true copy and paste, you're missing your ending ')' in the VALUES statement. On 11/14/06, Doug Brown [EMAIL PROTECTED] wrote: I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. cfset mylist=Antiques Art Baby Books Business Industrial Cameras Photo Cars, Boats, Vehicles Parts Cell Phones PDAs Clothing, Shoes Accessories Coins Paper Money Collectibles Computers Networking Consumer Electronics Crafts Dolls Bears DVDs Movies Entertainment Memorabilia Gift Certificates Health Beauty Home Garden Jewelry Watches Music Musical Instruments Pottery Glass Real Estate Specialty Services Sporting Goods Sports Mem, Cards Fan Shop Stamps Tickets Toys Hobbies Travel Video Games Everything Else !---Replace all new line characters with pipe symbol for delimeter--- cfset myNewList = #ReReplaceNoCase(myList, \n , |, ALL)# !---loop through our new list and insert into database--- cfloop list=#myNewList# index=listItem cfquery datasource=nexbid INSERT INTO categories (category) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#lTrim(listItem)# /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sql error during insert
You are missing a ) after the queryparam ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 10:15 PM To: CF-Talk Subject: Sql error during insert I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. cfset mylist=Antiques Art Baby Books Business Industrial Cameras Photo Cars, Boats, Vehicles Parts Cell Phones PDAs Clothing, Shoes Accessories Coins Paper Money Collectibles Computers Networking Consumer Electronics Crafts Dolls Bears DVDs Movies Entertainment Memorabilia Gift Certificates Health Beauty Home Garden Jewelry Watches Music Musical Instruments Pottery Glass Real Estate Specialty Services Sporting Goods Sports Mem, Cards Fan Shop Stamps Tickets Toys Hobbies Travel Video Games Everything Else !---Replace all new line characters with pipe symbol for delimeter--- cfset myNewList = #ReReplaceNoCase(myList, \n , |, ALL)# !---loop through our new list and insert into database--- cfloop list=#myNewList# index=listItem cfquery datasource=nexbid INSERT INTO categories (category) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#lTrim(listItem)# /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sql error during insert
You also need to specify the delimiter in your loop as a | ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Crow T. Robot [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 10:22 PM To: CF-Talk Subject: Re: Sql error during insert If this is a true copy and paste, you're missing your ending ')' in the VALUES statement. On 11/14/06, Doug Brown [EMAIL PROTECTED] wrote: I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. cfset mylist=Antiques Art Baby Books Business Industrial Cameras Photo Cars, Boats, Vehicles Parts Cell Phones PDAs Clothing, Shoes Accessories Coins Paper Money Collectibles Computers Networking Consumer Electronics Crafts Dolls Bears DVDs Movies Entertainment Memorabilia Gift Certificates Health Beauty Home Garden Jewelry Watches Music Musical Instruments Pottery Glass Real Estate Specialty Services Sporting Goods Sports Mem, Cards Fan Shop Stamps Tickets Toys Hobbies Travel Video Games Everything Else !---Replace all new line characters with pipe symbol for delimeter--- cfset myNewList = #ReReplaceNoCase(myList, \n , |, ALL)# !---loop through our new list and insert into database--- cfloop list=#myNewList# index=listItem cfquery datasource=nexbid INSERT INTO categories (category) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#lTrim(listItem)# /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sql error during insert
Never mind...I missed a closing ) on my query. Geez looked at it forever. D.B - Original Message - From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, November 14, 2006 8:15 PM Subject: Sql error during insert I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. cfset mylist=Antiques Art Baby Books Business Industrial Cameras Photo Cars, Boats, Vehicles Parts Cell Phones PDAs Clothing, Shoes Accessories Coins Paper Money Collectibles Computers Networking Consumer Electronics Crafts Dolls Bears DVDs Movies Entertainment Memorabilia Gift Certificates Health Beauty Home Garden Jewelry Watches Music Musical Instruments Pottery Glass Real Estate Specialty Services Sporting Goods Sports Mem, Cards Fan Shop Stamps Tickets Toys Hobbies Travel Video Games Everything Else !---Replace all new line characters with pipe symbol for delimeter--- cfset myNewList = #ReReplaceNoCase(myList, \n , |, ALL)# !---loop through our new list and insert into database--- cfloop list=#myNewList# index=listItem cfquery datasource=nexbid INSERT INTO categories (category) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#lTrim(listItem)# /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sql error during insert
Thanks. I hate it when the little stuff haunts you -) Doug - Original Message - From: Bobby Hartsfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, November 14, 2006 8:21 PM Subject: RE: Sql error during insert You are missing a ) after the queryparam ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 10:15 PM To: CF-Talk Subject: Sql error during insert I do not recall seeing this before. Could someone tell me what I am doing wrong? I get the following error while executing this query. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '@P1'. cfset mylist=Antiques Art Baby Books Business Industrial Cameras Photo Cars, Boats, Vehicles Parts Cell Phones PDAs Clothing, Shoes Accessories Coins Paper Money Collectibles Computers Networking Consumer Electronics Crafts Dolls Bears DVDs Movies Entertainment Memorabilia Gift Certificates Health Beauty Home Garden Jewelry Watches Music Musical Instruments Pottery Glass Real Estate Specialty Services Sporting Goods Sports Mem, Cards Fan Shop Stamps Tickets Toys Hobbies Travel Video Games Everything Else !---Replace all new line characters with pipe symbol for delimeter--- cfset myNewList = #ReReplaceNoCase(myList, \n , |, ALL)# !---loop through our new list and insert into database--- cfloop list=#myNewList# index=listItem cfquery datasource=nexbid INSERT INTO categories (category) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#lTrim(listItem)# /cfquery /cfloop ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Error
I'm not too hot with Access but if that were SQL Server my first thought would be to look at decimal datatypes. Ade -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 01 April 2005 23:27 To: CF-Talk Subject: SQL Error Does anyone know why this would occur? Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value I am using MS-Access and using CFQUERYPARAM tags. The tags are specified properly such as Integer or VARCHAR types. As well I re-verified that the field types match the type of data coming in. One field is a MEMO type field and wondering if a particular character might be throwing it off. I have converted all ' and marks to the ASCII character value. I was thinking that might be it but not the case. TIA! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.0 - Release Date: 31/03/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Error
But there is no decimals in this. Adrian Lynch wrote: I'm not too hot with Access but if that were SQL Server my first thought would be to look at decimal datatypes. Ade -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 01 April 2005 23:27 To: CF-Talk Subject: SQL Error Does anyone know why this would occur? Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value I am using MS-Access and using CFQUERYPARAM tags. The tags are specified properly such as Integer or VARCHAR types. As well I re-verified that the field types match the type of data coming in. One field is a MEMO type field and wondering if a particular character might be throwing it off. I have converted all ' and marks to the ASCII character value. I was thinking that might be it but not the case. TIA! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.0 - Release Date: 31/03/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Error
Change this: cfquery Your SQL WHERE something = cfqueryparam... /cfquery To this: pre cfoutput cfquery Your SQL WHERE something = lt;cfqueryparam... /cfquery /cfoutput /pre And take a look at what's actually being passed into the DB. Ade -Original Message- From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: 02 April 2005 00:50 To: CF-Talk Subject: Re: SQL Error But there is no decimals in this. Adrian Lynch wrote: I'm not too hot with Access but if that were SQL Server my first thought would be to look at decimal datatypes. Ade -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 01 April 2005 23:27 To: CF-Talk Subject: SQL Error -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.0 - Release Date: 31/03/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Error
I recently had this same issue with a site that was switched from CF5 to MX61. Client storage DB was choking on the CFDATA table's data field which is also a memo field. Solved it by creating a new data source in CFadmin using the Access driver with unicode support driver type. HTH, Doug -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: April 1, 2005 2:27 PM To: CF-Talk Subject: SQL Error Does anyone know why this would occur? Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value I am using MS-Access and using CFQUERYPARAM tags. The tags are specified properly such as Integer or VARCHAR types. As well I re-verified that the field types match the type of data coming in. One field is a MEMO type field and wondering if a particular character might be throwing it off. I have converted all ' and marks to the ASCII character value. I was thinking that might be it but not the case. TIA! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Error
Oops, forgot to say that I also created a new database, then used Cfadmin to create the Client Storage tables, and then copied the data from the old DB, and then created a new unicode supported data source... DF -Original Message- From: Doug Fentiman [mailto:[EMAIL PROTECTED] Sent: April 1, 2005 4:31 PM To: CF-Talk Subject: RE: SQL Error I recently had this same issue with a site that was switched from CF5 to MX61. Client storage DB was choking on the CFDATA table's data field which is also a memo field. Solved it by creating a new data source in CFadmin using the Access driver with unicode support driver type. HTH, Doug -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: April 1, 2005 2:27 PM To: CF-Talk Subject: SQL Error Does anyone know why this would occur? Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value I am using MS-Access and using CFQUERYPARAM tags. The tags are specified properly such as Integer or VARCHAR types. As well I re-verified that the field types match the type of data coming in. One field is a MEMO type field and wondering if a particular character might be throwing it off. I have converted all ' and marks to the ASCII character value. I was thinking that might be it but not the case. TIA! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Error with Syntax
I'm not sure if SQL Server has issues with having an integer as the first character of a table name, but I suspect that is where the problem is. It's generally a good idea to not start any variable, table or column names with an integer, lest you run into weird issues. I would try wrapping the table name in brackets such as [2da] and see if that works. -Justin Scott - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:58 AM Subject: OT: SQL Error with Syntax OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after CF processes the variables that makes it a query. (WHERE weight = apos;30apos;) Is just what is outputted in the error, it is actually ('30') !--- Dynamic Query --- SELECT zone#getzone.service# AS ship_value FROM #variables.service_table# WHERE weight = '#attributes.weight#' ORDER BY weight desc !--- Above output --- SELECT zone202 AS ship_value FROM 2da WHERE weight = apos;30apos; ORDER BY weight desc !--- PRODUCES This Error --- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '2'. 181 : WHERE weight = '#attributes.weight#' 182 : ORDER BY weight desc 183 : /cfquery 184 : cfset variables.process = Yes 185 : cfset variables.ups_rate = getrate.ship_value VENDORERRORCODE 170 SQLSTATE HY000 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL error - Arithmetic overflow...?
Don't know for sure, but could it be that the fields where you're adding 27.5 are set up as integer fields? This might not have been a problem in Access where there's just a 'number' datatype, but could make a difference in sql with 'int', 'float', 'decimal' etc If you've auto-upsized your access db to SQL and all the values in an access 'number' field were integers, the upsizer would probably create a SQL field with type 'int'. HTH Alex -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 03:30 To: CF-Talk Subject: SQL error - Arithmetic overflow...? This ran just fine using Microsoft Access. Now I get an overflow? Can you spot what's wrong? The values in the fields aren't very big - the largest is like 1952 to which I'm adding 20 or 30 or so... = ODBC Error Code = 22003 (Numeric value out of range) [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type numeric. SQL = Update MEMBERS Set status='Gold', current_point_ratio=1.25, total_purchases=total_purchases+22, purchases_this_year=purchases_this_year+22, purchases_quarter_1=purchases_quarter_1+22, total_points_earned=total_points_earned+27.5, points_earned_this_year=points_earned_this_year+27.5, points_earned_quarter_1=points_earned_quarter_1+27.5, point_balance=point_balance+27.5, last_tran_posted_on={d '2002-10-02'}, last_tran_posted_at={t '21:16:33'} Where uuid='23A99597-9F04-11D6-AEAA00A0CC617FCD' I guess it's too much to ask that they tell me WHAT value is out of range - or, since I am now using a real SQL database instead of MS Access, do I have to do all the calculations outside of the Update? Thanks in Advance, Ed Gordon = HERE'S THE CF CODE = CFQUERY datasource=#application.ds# Update MEMBERS Set status='#STATUSCHANGE#', current_point_ratio=#RATIOCHANGE#, total_purchases=total_purchases+#numAmount#, purchases_this_year=purchases_this_year+#numAmount#, purchases_quarter_1=purchases_quarter_1+#numAmount#, total_points_earned=total_points_earned+#numPoints#, points_earned_this_year=points_earned_this_year+#numPoints#, points_earned_quarter_1=points_earned_quarter_1+#numPoints#, point_balance=point_balance+#numPoints#, last_tran_posted_on=#CREATEODBCDATE(tdazedate)#, last_tran_posted_at=#CREATEODBCTIME(theodbctime)# Where uuid='#getmember.uuid#' /CFQUERY = HELP? TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: sql error
Um, wild guess . . . no Products table? Are you referencing the wrong database? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 10:13 a.m. To: CF-Talk Subject: sql error This one is driving me nuts. I keep getting a 'Base table not found error'. Invalid object name 'Products'. This is my query: SELECT Industries.name as industryName, Products.name as productName, Products.version, Products.prefix, Products.ID as prodID FROMProducts, Industries WHERE Products.name = '#COOKIE.prodName#' AND Products.version = '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID order by Industries.name, Products.name Does anyone know what may be causing this if you look at my code? thanks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql error
Did you creat the table in one database and upload it to your SQL using an account? look at the DB owner. example: Create a table in SQL has the name dbo.tablename Create table in local SQL or Access and import/Export it you get username.tablename Rick -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wed 5/15/2002 5:12 PM To: CF-Talk Cc: Subject: sql error __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql error
That's why this is driving me crazy because I already checked out that possibility and I'm definitely referencing the correct database. There is a products table. The strange thing is that sometimes it does work and sometimes it doesnt. It just doesn't make sense. From: Matthew Walker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: sql error Date: Thu, 16 May 2002 10:18:41 +1200 Um, wild guess . . . no Products table? Are you referencing the wrong database? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 10:13 a.m. To: CF-Talk Subject: sql error This one is driving me nuts. I keep getting a 'Base table not found error'. Invalid object name 'Products'. This is my query: SELECT Industries.name as industryName, Products.name as productName, Products.version, Products.prefix, Products.ID as prodID FROMProducts, Industries WHERE Products.name = '#COOKIE.prodName#' AND Products.version = '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID order by Industries.name, Products.name Does anyone know what may be causing this if you look at my code? thanks __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql error
I think I figured it out. I have a web farm and the database name was not specified on one of the server's CF Admin. thx From: S R [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: sql error Date: Wed, 15 May 2002 15:24:56 -0700 That's why this is driving me crazy because I already checked out that possibility and I'm definitely referencing the correct database. There is a products table. The strange thing is that sometimes it does work and sometimes it doesnt. It just doesn't make sense. From: Matthew Walker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: sql error Date: Thu, 16 May 2002 10:18:41 +1200 Um, wild guess . . . no Products table? Are you referencing the wrong database? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 10:13 a.m. To: CF-Talk Subject: sql error This one is driving me nuts. I keep getting a 'Base table not found error'. Invalid object name 'Products'. This is my query: SELECT Industries.name as industryName, Products.name as productName, Products.version, Products.prefix, Products.ID as prodID FROMProducts, Industries WHERE Products.name = '#COOKIE.prodName#' AND Products.version = '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID order by Industries.name, Products.name Does anyone know what may be causing this if you look at my code? thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql error
that's not it. That would give you a DATASOURCE NOT FOUND error. Chances are you just mapped to the wrong DB somewhere or your permissions are screwed up somehow. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:31 PM To: CF-Talk Subject: RE: sql error I think I figured it out. I have a web farm and the database name was not specified on one of the server's CF Admin. thx From: S R [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: sql error Date: Wed, 15 May 2002 15:24:56 -0700 That's why this is driving me crazy because I already checked out that possibility and I'm definitely referencing the correct database. There is a products table. The strange thing is that sometimes it does work and sometimes it doesnt. It just doesn't make sense. From: Matthew Walker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: sql error Date: Thu, 16 May 2002 10:18:41 +1200 Um, wild guess . . . no Products table? Are you referencing the wrong database? Regards, Matthew Walker /* Cabbage Tree Creative Ltd Christchurch - New Zealand http://www.matthewwalker.net.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 10:13 a.m. To: CF-Talk Subject: sql error This one is driving me nuts. I keep getting a 'Base table not found error'. Invalid object name 'Products'. This is my query: SELECT Industries.name as industryName, Products.name as productName, Products.version, Products.prefix, Products.ID as prodID FROMProducts, Industries WHERE Products.name = '#COOKIE.prodName#' AND Products.version = '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID order by Industries.name, Products.name Does anyone know what may be causing this if you look at my code? thanks __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql error
I think I figured it out. I have a web farm and the database name was not specified on one of the server's CF Admin. that's not it. That would give you a DATASOURCE NOT FOUND error. Chances are you just mapped to the wrong DB somewhere or your permissions are screwed up somehow. No, that would do it - the datasource would exist, but it just wouldn't point to a specific database, and with say SQL Server, you'd end up querying the default database, which unless you change that for the specific db user account would be master. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql error
That's exactly what happened. The datasource was there but with no database specified on one of the servers. From: Dave Watts [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: sql error Date: Wed, 15 May 2002 18:51:11 -0400 I think I figured it out. I have a web farm and the database name was not specified on one of the server's CF Admin. that's not it. That would give you a DATASOURCE NOT FOUND error. Chances are you just mapped to the wrong DB somewhere or your permissions are screwed up somehow. No, that would do it - the datasource would exist, but it just wouldn't point to a specific database, and with say SQL Server, you'd end up querying the default database, which unless you change that for the specific db user account would be master. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Your database is full. Allocate more space for it in Enterprise Manager. Dan Phillips CFXHosting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 10:42 AM To: CF-Talk Subject: SQL Error, I know I know this is suppose to be for CF stuff, but I know someone can help with this. I'm under the gun here. I'm getting this SQL 2000 error message when I try to add a new column to an existing table that's filled with data. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. Thank you in advance. Please help. D- __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Error, I know
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Error, I know
Ouch!! I would first find out how much space you are suposed to have for your database, then right click on your database (in enterprise manager) and view properties (it will tell you how much space is being used). If it is full (which is probably is).. and the numbers are correct (ie you are using as much as they said that they would give you). Email the administrator and ask him for more space .. if they want to charge you $200.00 to do that ... look for a new provider ..!! Best of Luck! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 10:01 AM Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
How's this for customer relations ... e-mail from hosting company's DBA ... Your database is not configured to grow automatically. You pay for a set size monthly and that is all that is available. You can request more disk space if you need it, but that's up to you. This is definitely NOT a support issue. The server your database is on and functioning normally and all is working fine. That is our concern from a support side. The problem with inserting columns falls strictly under Professional Services. Like I said, I can fix the problem and ensure that this works, but it is up to you if you want me to go ahead and do this. Please let me know. If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
You would have to have admin rights to the SQL server to increase the space. Have your ISP check to see how much free space you have left on the SQL server. Obviously if it's under a couple Megs or has no space left, more space needs to be added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 11:06 AM To: CF-Talk Subject: RE: SQL Error, I know Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Thanks everyone! You guys are the best! D- You would have to have admin rights to the SQL server to increase the space. Have your ISP check to see how much free space you have left on the SQL server. Obviously if it's under a couple Megs or has no space left, more space needs to be added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 11:06 AM To: CF-Talk Subject: RE: SQL Error, I know Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
They also may be including your log files in the space that you use - If they are not backing up properly you might find that your log files are massive and that providing the segments in the logfiles are ordered properly backin g them up should free up a tonne of space -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:16 To: CF-Talk Subject: RE: SQL Error, I know Thanks everyone! You guys are the best! D- You would have to have admin rights to the SQL server to increase the space. Have your ISP check to see how much free space you have left on the SQL server. Obviously if it's under a couple Megs or has no space left, more space needs to be added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 11:06 AM To: CF-Talk Subject: RE: SQL Error, I know Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL error
Jeff It's not a silly error, but exactly what it says... Your second value is 2330 characters long... a 2,000 char field fills up quickly, doesn't it! HTH Dick At 11:16 AM -0500 2/17/01, Jeff Davis wrote: Help? I'm sure this is a silly insert error but I just don't see the problem. The answer filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the field? Running CF 4.5 and SQL7. ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:br table width="100%" border="0" cellpadding="4" align="center" cellspacing="6" tr td width="193"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Requirement/font/b/td td width="143"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Minimum/font/b/td td width="132"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Recommended/font/b/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Internet Connection /font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"56K Dial-Up /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"DSL/Cable or higher/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Windows Media Player/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 5 /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 7 /font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Speakers/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Microphone/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr /table')"P Jeff Davis ~~ 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 error
Is that # hash mark in the color value causing you trouble? - Original Message - From: "Jeff Davis" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 10:16 AM Subject: SQL error Help? I'm sure this is a silly insert error but I just don't see the problem. The answer filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the field? Running CF 4.5 and SQL7. ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:br table width="100%" border="0" cellpadding="4" align="center" cellspacing="6" tr td width="193"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Requirement/font/b/td td width="143"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Minimum/font/b/td td width="132"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Recommended/font/b/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Internet Connection /font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"56K Dial-Up /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"DSL/Cable or higher/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Windows Media Player/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 5 /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 7 /font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Speakers/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Microphone/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr /table')"P Jeff Davis ~~ 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 error
You may want to use a text field, not a char field. I imagine the quotes in the insert may be cause of the problems. There are a handful of statements that have an effect on the quotes. Look into htmleditformat() first. I don't see any single quotes in your insert, so preservesinglequotes() probably won't have an effect. Why do you want to store so much HTML in the database? Jeff Davis wrote: Help? I'm sure this is a silly insert error but I just don't see the problem. The answer filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the field? Running CF 4.5 and SQL7. ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:br table width="100%" border="0" cellpadding="4" align="center" cellspacing="6" tr td width="193"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Requirement/font/b/td td width="143"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Minimum/font/b/td td width="132"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Recommended/font/b/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Internet Connection /font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"56K Dial-Up /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"DSL/Cable or higher/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Windows Media Player/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 5 /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 7 /font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Speakers/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Microphone/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr /table')"P Jeff Davis ~~ 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 error
I have a backend page set up to insert new FAQ's to the site so teh CEO can add them as they come up. This is really the only one that has this much HTML for the table layout of requirements. It was teh # sign causing the problem, I removed all the Font tags and it inserted just fine. Thanks Guys. Jeff Davis - Original Message - From: "Jeffry Houser" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 2:31 PM Subject: Re: SQL error You may want to use a text field, not a char field. I imagine the quotes in the insert may be cause of the problems. There are a handful of statements that have an effect on the quotes. Look into htmleditformat() first. I don't see any single quotes in your insert, so preservesinglequotes() probably won't have an effect. Why do you want to store so much HTML in the database? Jeff Davis wrote: Help? I'm sure this is a silly insert error but I just don't see the problem. The answer filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the field? Running CF 4.5 and SQL7. ODBC Error Code = 22001 (String data right truncation)P [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:br table width="100%" border="0" cellpadding="4" align="center" cellspacing="6" tr td width="193"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Requirement/font/b/td td width="143"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Minimum/font/b/td td width="132"bfont face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Recommended/font/b/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Internet Connection /font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"56K Dial-Up /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"DSL/Cable or higher/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Windows Media Player/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 5 /font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Version 7 /font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Speakers/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr tr td width="193"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Microphone/font/td td width="143"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td td width="132"font face="Verdana, Arial, Helvetica, sans-serif" size="2"Any/font/td /tr /table')"P Jeff Davis ~~ 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 Error
It's impossible to completely get rid of this error however you can minimize the chances of it happening. Look at the SQL books on line for advice on how to do this Justin -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:27 PM To: CF-Talk Subject: SQL Error Has anyone seen this error here before? What is the cause and the fix? ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #17) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. TIA, Duane ~~ 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 Error
You get a deadlock when process A has got a lock on resource 1 and wants to get a lock on resource 2, and process B has got a lock on resource 2 and wants to get a lock on resource 1. The DBMS has no choice but to step in and abort one of the transactions. You should be able to CFCATCH the error and resubmit the transaction. If possible, change the design so that it can't happen. Nick -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:27 PM To: CF-Talk Subject: SQL Error Has anyone seen this error here before? What is the cause and the fix? ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #17) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. TIA, Duane ~~ 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 Error
Thanks. At this point I haven't seen the db design. I'll have to have a look to see if there is a design flaw. Duane -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 10:54 AM To: CF-Talk Subject: RE: SQL Error You get a deadlock when process A has got a lock on resource 1 and wants to get a lock on resource 2, and process B has got a lock on resource 2 and wants to get a lock on resource 1. The DBMS has no choice but to step in and abort one of the transactions. You should be able to CFCATCH the error and resubmit the transaction. If possible, change the design so that it can't happen. Nick -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:27 PM To: CF-Talk Subject: SQL Error Has anyone seen this error here before? What is the cause and the fix? ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #17) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. TIA, Duane ~~ 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 error (minus the mess)
ok, second round. when setting up the datasource, did you restrict access to the SQL command set? in the CFAdministrator, under "ODBC Datasources", select the DSN in question. choose "Advanced", and make sure that "SELECT" is checked. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kylie Lovelock [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 2:46 AM To: CF-Talk Subject: Re: SQL error (minus the mess) Thanks for taking the time Christopher. I removed the username and password from my CFQUERY - but still receiving the same error of SQL operation unauthorized. Cheers Kylie - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 3:29 PM Subject: RE: SQL error (minus the mess) at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL error (minus the mess)
no worries. that's what we're all here for. although i'd have to question what kind of ISP turns off SELECT priveledges for an ODBC datasource. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kylie Lovelock [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 5:31 AM To: CF-Talk Subject: Re: SQL error (minus the mess) Thankyou Thankyou (as I smile until my cheeks hurt) I forwarded your suggestion through to my ISP - he followed your instructions and it works like a charm. Did I say Thankyou? - Thankyou Cheers Kylie - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 4:42 PM Subject: RE: SQL error (minus the mess) ok, second round. when setting up the datasource, did you restrict access to the SQL command set? in the CFAdministrator, under "ODBC Datasources", select the DSN in question. choose "Advanced", and make sure that "SELECT" is checked. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kylie Lovelock [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 2:46 AM To: CF-Talk Subject: Re: SQL error (minus the mess) Thanks for taking the time Christopher. I removed the username and password from my CFQUERY - but still receiving the same error of SQL operation unauthorized. Cheers Kylie - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 3:29 PM Subject: RE: SQL error (minus the mess) at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL error (minus the mess)
at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kylie Lovelock [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 2:01 AM To: CF-Talk Subject: SQL error (minus the mess) That was a really bad start - please accept my apologies for the mess. Let's try again. The page I have done up is a very simple test page with code: cfquery name="rsHCint" datasource="HCint" username="user" password="password" SELECT * FROM input /cfquery cfset rsHCint_NumRows = 0 cfset rsHCint_Index = 1 I am using a Access 97 database, if that helps. Remote, I am getting this error: SQL operation unauthorized. The SQL operation SELECT is unauthorized for the data source 'HCint' I'm sorry if this seems a trivial question, but I'm very green but keen to learn Cold Fusion - and this has stumped me for 4 days. Any help would be greatly appreciated. Cheers Kylie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: SQL error (minus the mess)
Thanks for taking the time Christopher. I removed the username and password from my CFQUERY - but still receiving the same error of SQL operation unauthorized. Cheers Kylie - Original Message - From: "Christopher Olive, CIO" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 3:29 PM Subject: RE: SQL error (minus the mess) at just a quick glance, is the username/password combination valid for that database? did you give access to the user "username"? access by default does not have security. try removing the username and password attributes from your CFQUERY. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: SQL Error using 'Name' as field
Hi Pablo, GROUP BY is an aggregate SQL function and must include all fields found in the SELECT clause. SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent, Name; I'm performing the following query to an Access database in a page: cfquery datasource="webtrack" name="pkg_recipients" SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent; /cfquery However, I get this error when executing it: - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Name' as part of an aggregate function. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Error using 'Name' as field
I'm not too familiar with the group by function but in order to use it you must be using an (Sum, Avg, Count etc) aggregate function (hopefully someone who knows this a bit better can clarify this more) ex: cfquery datasource="dsn" name="q_test" SELECT lname, COUNT(*) AS tot_clients FROMClient GROUP BY lname ORDER BY lname /cfquery Duane Boudreau CFExperts.Com -Original Message- From: Pablo Nevares [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 29, 2000 9:57 PM To: [EMAIL PROTECTED] Subject: SQL Error using 'Name' as field I'm performing the following query to an Access database in a page: cfquery datasource="webtrack" name="pkg_recipients" SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent; /cfquery However, I get this error when executing it: - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Name' as part of an aggregate function. Data Source = "webtrack" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:53) in the template file D:\web\package_summary.cfm. - I've searched in both the Same SQL reference book and the MS Access help files, and neither say that "Name" is a reserved word ("Names" does show up in the Sams book). Thanks in advance. Pablo Nevares Information Technology Hendricks Partners [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Error using 'Name' as field
From what I have used it with, you want to do the following: cfquery datasource="dsn" name="q_test" SELECT lname, COUNT(*) AS tot_clients FROM Client ORDER BY lname /cfquery cfoutput cfoutput queryname="q_test" groupby="1name" li#1name/li /cfoutput #othervars# /cfoutput Groupby groups the output by the field that you specify. This is the way I have used it, refrencing Forta's basic book. Scott Berry -- Computer Simplistics Support "Simple Solutions for a Complex World" http://www.c-s.net 661-296-4315 - Original Message - From: "Duane Boudreau" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, April 29, 2000 7:54 PM Subject: RE: SQL Error using 'Name' as field I'm not too familiar with the group by function but in order to use it you must be using an (Sum, Avg, Count etc) aggregate function (hopefully someone who knows this a bit better can clarify this more) ex: cfquery datasource="dsn" name="q_test" SELECT lname, COUNT(*) AS tot_clients FROM Client GROUP BY lname ORDER BY lname /cfquery Duane Boudreau CFExperts.Com -Original Message- From: Pablo Nevares [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 29, 2000 9:57 PM To: [EMAIL PROTECTED] Subject: SQL Error using 'Name' as field I'm performing the following query to an Access database in a page: cfquery datasource="webtrack" name="pkg_recipients" SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent; /cfquery However, I get this error when executing it: - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Name' as part of an aggregate function. Data Source = "webtrack" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:1) to (10:53) in the template file D:\web\package_summary.cfm. - I've searched in both the Same SQL reference book and the MS Access help files, and neither say that "Name" is a reserved word ("Names" does show up in the Sams book). Thanks in advance. Pablo Nevares Information Technology Hendricks Partners [EMAIL PROTECTED] -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.