wierd database error
I have a site that is running at CrystalTech using SQL Server 2000, and everything is running fine on the live site: http://www.nellco.org I've been making some serious improvements to the site, and have uploaded the entire (improved) site to a test server also at CrystalTech. I've created the DSN, etc on the test server. But I keep getting this weird error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TD_NEWS_News'. Like I said, the site is running fine locally here and the site is running fine on their live server, but not on my test server. I've Googled this error, but I'm not finding what could be causing this problem. Has anyone seen it and point me to the reason it might be happening? The address where this can be seen: http://216.197.108.108/NELLCO/index.cfm -- = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = ~| 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:220211 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: wierd database error
From: Ray Champagne [mailto:[EMAIL PROTECTED] I have a site that is running at CrystalTech using SQL Server 2000, and everything is running fine on the live site: http://www.nellco.org I've been making some serious improvements to the site, and have uploaded the entire (improved) site to a test server also at CrystalTech. I've created the DSN, etc on the test server. But I keep getting this weird error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TD_NEWS_News'. Sounds like you are referring to an invalid object (table perhaps)? Do you have a test DB too or are you running test code against a production DB? ~| 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:220212 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: wierd database error
Running it against the live DB - there are no changes to the DB code in my new version, so there is not really any worries of altering the DB. That's why I'm confused. There have been no changes to the DB, and that table *does* exist. The only thing I can think of is that the DB is getting accessed from a different account than the live site, but I've set the DSN just fine using the control panel at CT, so in my mind it shouldn't matter, right? Michael T. Tangorre wrote: From: Ray Champagne [mailto:[EMAIL PROTECTED] I have a site that is running at CrystalTech using SQL Server 2000, and everything is running fine on the live site: http://www.nellco.org I've been making some serious improvements to the site, and have uploaded the entire (improved) site to a test server also at CrystalTech. I've created the DSN, etc on the test server. But I keep getting this weird error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TD_NEWS_News'. Sounds like you are referring to an invalid object (table perhaps)? Do you have a test DB too or are you running test code against a production DB? ~| 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:220213 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: wierd database error
From: Ray Champagne [mailto:[EMAIL PROTECTED] Running it against the live DB - there are no changes to the DB code in my new version, so there is not really any worries of altering the DB. That's why I'm confused. There have been no changes to the DB, and that table *does* exist. The only thing I can think of is that the DB is getting accessed from a different account than the live site, but I've set the DSN just fine using the control panel at CT, so in my mind it shouldn't matter, right? Are both the CF Servers you are running your test and production code on the same? Same CF Version? Same DB drivers? JDBC drivers? Mike ~| 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:220215 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: wierd database error
Well, not sure about that. Not even sure how to check this on a shared server. We don't usually use CT, so I'm not familiar at all with their servers and such. I'm going to do some investigating and see where that takes me. Thanks Michael T. Tangorre wrote: From: Ray Champagne [mailto:[EMAIL PROTECTED] Running it against the live DB - there are no changes to the DB code in my new version, so there is not really any worries of altering the DB. That's why I'm confused. There have been no changes to the DB, and that table *does* exist. The only thing I can think of is that the DB is getting accessed from a different account than the live site, but I've set the DSN just fine using the control panel at CT, so in my mind it shouldn't matter, right? Are both the CF Servers you are running your test and production code on the same? Same CF Version? Same DB drivers? JDBC drivers? Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220216 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: wierd database error
I have a site that is running at CrystalTech using SQL Server 2000, and everything is running fine on the live site: http://www.nellco.org I've been making some serious improvements to the site, and have uploaded the entire (improved) site to a test server also at CrystalTech. I've created the DSN, etc on the test server. But I keep getting this weird error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TD_NEWS_News'. Like I said, the site is running fine locally here and the site is running fine on their live server, but not on my test server. I've Googled this error, but I'm not finding what could be causing this problem. Has anyone seen it and point me to the reason it might be happening? One common cause of this sort of problem is object ownership. When you log into a database server, and you then create objects within a database, you will be the owner of those objects. If your user account happens to be dbo within a specific database, the ownership prefix will be dbo, but you won't have to worry about specifying that within your object names when querying. If your account isn't dbo within that database, the ownership prefix will be something other than dbo, and you'll have to explicitly specify that object owner when referencing the object by name. There are two ways to solve this. One is to explicitly use the ownership prefix in your code. The other is to change the owner of your database objects to dbo. This is a little tedious, but not difficult: http://www.sqlteam.com/item.asp?ItemID=1283 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:220221 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: wierd database error
Thanks, Dave, Mike. I got ahold of CT support - they don't allow you to access databases across domains. Thus, I was getting the error. The solution for me was to create a new database in the test account, then they are going to restore the database at the live server to the test server. Prolly better this way, anyways, since I really should be using a test DB for future changes. Ray Dave Watts wrote: I have a site that is running at CrystalTech using SQL Server 2000, and everything is running fine on the live site: http://www.nellco.org I've been making some serious improvements to the site, and have uploaded the entire (improved) site to a test server also at CrystalTech. I've created the DSN, etc on the test server. But I keep getting this weird error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TD_NEWS_News'. Like I said, the site is running fine locally here and the site is running fine on their live server, but not on my test server. I've Googled this error, but I'm not finding what could be causing this problem. Has anyone seen it and point me to the reason it might be happening? One common cause of this sort of problem is object ownership. When you log into a database server, and you then create objects within a database, you will be the owner of those objects. If your user account happens to be dbo within a specific database, the ownership prefix will be dbo, but you won't have to worry about specifying that within your object names when querying. If your account isn't dbo within that database, the ownership prefix will be something other than dbo, and you'll have to explicitly specify that object owner when referencing the object by name. There are two ways to solve this. One is to explicitly use the ownership prefix in your code. The other is to change the owner of your database objects to dbo. This is a little tedious, but not difficult: http://www.sqlteam.com/item.asp?ItemID=1283 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:220224 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
Database error
I'm getting this error, whenever I'm trying to update the database, I'm using CFMX 7, this is my query UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' WHERE Person.Objectno = 2005 Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near 'blopez5955'. Any thoughts, Thanks in Advance. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206882 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: Database error
what datatype is the column? tony On 5/17/05, Rajani Chandra [EMAIL PROTECTED] wrote: I'm getting this error, whenever I'm trying to update the database, I'm using CFMX 7, this is my query UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' WHERE Person.Objectno = 2005 Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near 'blopez5955'. Any thoughts, Thanks in Advance. ~| 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:206883 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: Database error
it is varchar, that's why I put it in single quotes. - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 11:21 AM Subject: Re: Database error what datatype is the column? tony On 5/17/05, Rajani Chandra [EMAIL PROTECTED] wrote: I'm getting this error, whenever I'm trying to update the database, I'm using CFMX 7, this is my query UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' WHERE Person.Objectno = 2005 Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near 'blopez5955'. Any thoughts, Thanks in Advance. ~| 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:206884 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: Database error
I'm getting this error, whenever I'm trying to update the database, I'm using CFMX 7, this is my query UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' WHERE Person.Objectno = 2005 Are you using backtick characters around blopez5955 instead of single quote characters? Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206886 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: Database error
No, I'm just using single quote, this is my code. cfif IsNumeric(#qry_getSpcListInfo.ItmValue#) cfset valueliststr = #qry_getSpcListInfo.ItmValue# cfelse cfset valueliststr = '#qry_getSpcListInfo.ItmValue#' /cfif I'm passing that variable in query. Thanks. - Original Message - From: Nick de Voil [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 11:35 AM Subject: Re: Database error I'm getting this error, whenever I'm trying to update the database, I'm using CFMX 7, this is my query UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' WHERE Person.Objectno = 2005 Are you using backtick characters around blopez5955 instead of single quote characters? Nick ~| 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:206887 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: Database error
This should fix it cfif IsNumeric(qry_getSpcListInfo.ItmValue) cfset valueliststr = qry_getSpcListInfo.ItmValue cfelse cfset valueliststr = '#qry_getSpcListInfo.ItmValue#' /cfif Paul ~| 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:206889 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: Database error
I tried it, still it is giving same error. This is my code cfif isFirst eq true cfset fieldliststr = #qry_getSpcListInfo.ItemName# cfif IsNumeric(#qry_getSpcListInfo.ItmValue#) cfset valueliststr = #qry_getSpcListInfo.ItmValue# cfelse cfset valueliststr = '#qry_getSpcListInfo.ItmValue#' /cfif cfset setliststr = #fieldliststr# = #valueliststr# cfset whereclause = #qry_getSpcListInfo.PrimEntity#.Objectno = #qry_getSpcListInfo.Instanceno# cfset prevgroupid = #qry_getSpcListInfo.Groupid# cfset isFirst=false cfelseif (previnstanceno eq #qry_getSpcListInfo.Instanceno#) and (Prevgroupid eq #qry_getSpcListInfo.Groupid#) cfset fieldliststr = #fieldliststr#,#qry_getSpcListInfo.ItemName# cfif IsNumeric(#qry_getSpcListInfo.ItmValue#) cfset setliststr = #setliststr# , #qry_getSpcListInfo.ItemName# = #qry_getSpcListInfo.ItmValue# cfelse cfset setliststr = #setliststr# , #qry_getSpcListInfo.ItemName# = '#qry_getSpcListInfo.ItmValue#' /cfif /cfif cfset query=UPDATE #qry_getSpcListInfo.PrimEntity# SET #setliststr# WHERE #whereclause# #query#br cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #setliststr# WHERE #whereclause# /cfquery Variable Query is displayling like this in browser: UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , Person.LstDate = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = 'M' , Person.Name = 'Brenda Brendalopez Lopez' , Person.NamMid = 'Brendalopez' , Person.ProSta = 1 , Person.SmokerCd = 1 , Person.StudentId = 2 WHERE Person.Objectno = 2005301 Error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near 'blopez5955'. Thanks. - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 11:47 AM Subject: RE: Database error This should fix it cfif IsNumeric(qry_getSpcListInfo.ItmValue) cfset valueliststr = qry_getSpcListInfo.ItmValue cfelse cfset valueliststr = '#qry_getSpcListInfo.ItmValue#' /cfif Paul ~| 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:206894 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: Database error
Rajani Chandra wrote: No, I'm just using single quote, this is my code. cfif IsNumeric(#qry_getSpcListInfo.ItmValue#) cfset valueliststr = #qry_getSpcListInfo.ItmValue# cfelse cfset valueliststr = '#qry_getSpcListInfo.ItmValue#' /cfif Use cfqueryparam. Jochem ~| 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:206895 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: Database error
Yesterday i try cfqueryparam for simple query it works, but I'm not getting how to use cfqueryparam for my code because I'm storing all the fieldnames and values in one single variable (SETLISTSTR) and directly passing that variable to query. cfset setliststr = #setliststr# , #qry_getSpcListInfo.ItemName# = '#qry_getSpcListInfo.ItmValue#' cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #setliststr# WHERE #whereclause# /cfquery I don't have any idea how to use cfqueryparam for this code, so plz help me. Thanks. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 12:15 PM Subject: Re: Database error Rajani Chandra wrote: No, I'm just using single quote, this is my code. cfif IsNumeric(#qry_getSpcListInfo.ItmValue#) cfset valueliststr = #qry_getSpcListInfo.ItmValue# cfelse cfset valueliststr = '#qry_getSpcListInfo.ItmValue#' /cfif Use cfqueryparam. Jochem ~| 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:206898 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: Database error
Rajani Chandra wrote: Yesterday i try cfqueryparam for simple query it works, but I'm not getting how to use cfqueryparam for my code because I'm storing all the fieldnames and values in one single variable (SETLISTSTR) and directly passing that variable to query. cfset setliststr = #setliststr# , #qry_getSpcListInfo.ItemName# = '#qry_getSpcListInfo.ItmValue#' cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #setliststr# WHERE #whereclause# /cfquery I don't have any idea how to use cfqueryparam for this code, so plz help me. You can't, you have to build the query inside the cfquery tags with some traditional cfifs. It is highly recommended, but if you don't want to do that check out PreserveSingleQuotes(): http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0596.htm#134493 Jochem ~| 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:206899 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: Database error
hi, Localize the error. Copy this final query into SQL Query Analyzer or SQL Enterprise Manager and check if it works there. Does it work there? RC Variable Query is displayling like this in browser: RC UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , RC Person.LstDate = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = RC 'M' , Person.Name = 'Brenda Brendalopez Lopez' , Person.NamMid = RC 'Brendalopez' , Person.ProSta = 1 , Person.SmokerCd = 1 , Person.StudentId = RC 2 WHERE Person.Objectno = 2005301 RC Error: RC Error Executing Database Query. RC [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax RC near 'blopez5955'. Sergeymailto:[EMAIL PROTECTED] ~| 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:206901 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: Database error
it works in SQL Query Analyzer. - Original Message - From: Sergey Croitor [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 12:50 PM Subject: Re: Database error hi, Localize the error. Copy this final query into SQL Query Analyzer or SQL Enterprise Manager and check if it works there. Does it work there? RC Variable Query is displayling like this in browser: RC UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , RC Person.LstDate = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta = RC 'M' , Person.Name = 'Brenda Brendalopez Lopez' , Person.NamMid = RC 'Brendalopez' , Person.ProSta = 1 , Person.SmokerCd = 1 , Person.StudentId = RC 2 WHERE Person.Objectno = 2005301 RC Error: RC Error Executing Database Query. RC [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax RC near 'blopez5955'. Sergeymailto:[EMAIL PROTECTED] ~| 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:206902 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: Database error
Yesterday i try cfqueryparam for simple query it works, but I'm not getting how to use cfqueryparam for my code because I'm storing all the fieldnames and values in one single variable (SETLISTSTR) and directly passing that variable to query. cfset setliststr = #setliststr# , #qry_getSpcListInfo.ItemName# = '#qry_getSpcListInfo.ItmValue#' cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #setliststr# WHERE #whereclause# /cfquery I don't have any idea how to use cfqueryparam for this code, so plz help me. Well, you can't place actual SQL commands within your CFQUERYPARAM values, since the whole point of CFQUERYPARAM is to let the database clearly differentiate between SQL commands and data. So, to use CFQUERYPARAM you will need to restructure your SQL so that you don't generate commands and data within a single string. For example, you could loop over your variables directly within your CFQUERY tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:206905 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: Database error
Thanks, I'm trying to change the code using nested queries. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 12:39 PM Subject: Re: Database error Rajani Chandra wrote: Yesterday i try cfqueryparam for simple query it works, but I'm not getting how to use cfqueryparam for my code because I'm storing all the fieldnames and values in one single variable (SETLISTSTR) and directly passing that variable to query. cfset setliststr = #setliststr# , #qry_getSpcListInfo.ItemName# = '#qry_getSpcListInfo.ItmValue#' cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #setliststr# WHERE #whereclause# /cfquery I don't have any idea how to use cfqueryparam for this code, so plz help me. You can't, you have to build the query inside the cfquery tags with some traditional cfifs. It is highly recommended, but if you don't want to do that check out PreserveSingleQuotes(): http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentationfile=0596.htm#134493 Jochem ~| 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:206909 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: Database error
RC Thanks, I'm trying to change the code using nested queries. try PreserveSingleQuotes at first as Jochem advised you: cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #PreserveSingleQuotes(setliststr)# WHERE #whereclause# /cfquery -- Sergey ~| 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:206915 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: Database error
Thanks, PreserveSingleQuotes() is working. - Original Message - From: Sergey Croitor [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 1:44 PM Subject: Re: Database error RC Thanks, I'm trying to change the code using nested queries. try PreserveSingleQuotes at first as Jochem advised you: cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #PreserveSingleQuotes(setliststr)# WHERE #whereclause# /cfquery -- Sergey ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206919 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: Database error
Thanks to everybody, now my application is running. - Original Message - From: Sergey Croitor [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 17, 2005 1:44 PM Subject: Re: Database error RC Thanks, I'm trying to change the code using nested queries. try PreserveSingleQuotes at first as Jochem advised you: cfquery name=qry_update datasource=EWNDAT UPDATE #qry_getSpcListInfo.PrimEntity# SET #PreserveSingleQuotes(setliststr)# WHERE #whereclause# /cfquery -- Sergey ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206923 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
database error when using cfqueryparam
Having trouble figuring out what is causing this error ERROR MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. SQL = INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, sml_image ) VALUES ( 'dan farmer', 'sdfsdf', 'sdfdsf', 'dsfsdf', 'sdf', 'sdfsdf', bio_f = ? ,'' ) Query Parameter Value(s) - Parameter #1 = dsfsdfsdf MY QUERY cfquery name=addit datasource=#db_datasource# username=#db_username# password=#db_password# dbtype=#db_type# dbname=#db_name# dbserver=#db_server# INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, cfif isdefined('form.sml_image_name')sml_image/cfif ) VALUES ( '#form.member_name#', '#form.email_address#', '#form.phone_office#', '#form.phone_cell#', '#form.phone_fax#', '#form.bio#', bio_f = cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar cfif isdefined('form.sml_image_name'),'#form.sml_image_name#'/cfif ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: database error when using cfqueryparam
bio_f is the field name and should ONLY be in the field listyou use bio_f = in UPDATEs ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Daniel Farmer To: CF-Talk Sent: Tuesday, June 01, 2004 11:08 AM Subject: database error when using cfqueryparam Having trouble figuring out what is causing this error ERROR MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. SQL = INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, sml_image ) VALUES ( 'dan farmer', 'sdfsdf', 'sdfdsf', 'dsfsdf', 'sdf', 'sdfsdf', bio_f = ? ,'' ) Query Parameter Value(s) - Parameter #1 = dsfsdfsdf MY QUERY cfquery name=addit datasource=#db_datasource# username=#db_username# password=#db_password# dbtype=#db_type# dbname=#db_name# dbserver=#db_server# INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, cfif isdefined('form.sml_image_name')sml_image/cfif ) VALUES ( '#form.member_name#', '#form.email_address#', '#form.phone_office#', '#form.phone_cell#', '#form.phone_fax#', '#form.bio#', bio_f = cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar cfif isdefined('form.sml_image_name'),'#form.sml_image_name#'/cfif ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: database error when using cfqueryparam
Remove bio_f = from your value list. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: database error when using cfqueryparam
Having trouble figuring out what is causing this error ERROR MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. ... VALUES ( '#form.member_name#', '#form.email_address#', '#form.phone_office#', '#form.phone_cell#', '#form.phone_fax#', '#form.bio#', bio_f = cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar Your query is incorrectly written. You have bio_f = cfqueryparam ... when you should just have cfqueryparam. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: database error when using cfqueryparam
Single quotes around the cfqueryparam? bio_f = 'cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar' [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: database error when using cfqueryparam
Take out the bio_f = before the CFQUERYPARAM tag.You're already specifying the column name in the first parenthesized list, so you don't need it in the value list. Cheers, banreyb -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 11:09 AM To: CF-Talk Subject: database error when using cfqueryparam Having trouble figuring out what is causing this error ERROR MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. SQL = INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, sml_image ) VALUES ( 'dan farmer', 'sdfsdf', 'sdfdsf', 'dsfsdf', 'sdf', 'sdfsdf', bio_f = ? ,'' ) Query Parameter Value(s) - Parameter #1 = dsfsdfsdf MY QUERY cfquery name=addit datasource=#db_datasource# username=#db_username# password=#db_password# dbtype=#db_type# dbname=#db_name# dbserver=#db_server# INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, cfif isdefined('form.sml_image_name')sml_image/cfif ) VALUES ( '#form.member_name#', '#form.email_address#', '#form.phone_office#', '#form.phone_cell#', '#form.phone_fax#', '#form.bio#', bio_f = cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar cfif isdefined('form.sml_image_name'),'#form.sml_image_name#'/cfif ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: database error when using cfqueryparam
hehe thanks guys for ALL the answers hehe - Original Message - From: Daniel Farmer To: CF-Talk Sent: Tuesday, June 01, 2004 2:08 PM Subject: database error when using cfqueryparam Having trouble figuring out what is causing this error ERROR MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. SQL = INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, sml_image ) VALUES ( 'dan farmer', 'sdfsdf', 'sdfdsf', 'dsfsdf', 'sdf', 'sdfsdf', bio_f = ? ,'' ) Query Parameter Value(s) - Parameter #1 = dsfsdfsdf MY QUERY cfquery name=addit datasource=#db_datasource# username=#db_username# password=#db_password# dbtype=#db_type# dbname=#db_name# dbserver=#db_server# INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, cfif isdefined('form.sml_image_name')sml_image/cfif ) VALUES ( '#form.member_name#', '#form.email_address#', '#form.phone_office#', '#form.phone_cell#', '#form.phone_fax#', '#form.bio#', bio_f = cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar cfif isdefined('form.sml_image_name'),'#form.sml_image_name#'/cfif ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: database error when using cfqueryparam
Also, your statement will fail if form.sml_image_name is undefined.In that case, the last column name specified in your columns list will be followed by a comma. - Original Message - From: Barney Boisvert [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 11:14 AM Subject: RE: database error when using cfqueryparam Take out the bio_f = before the CFQUERYPARAM tag.You're already specifying the column name in the first parenthesized list, so you don't need it in the value list. Cheers, banreyb -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 11:09 AM To: CF-Talk Subject: database error when using cfqueryparam Having trouble figuring out what is causing this error ERROR MERANT][ODBC SQL Server Driver][SQL Server]The name 'bio_f' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. SQL = INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, sml_image ) VALUES ( 'dan farmer', 'sdfsdf', 'sdfdsf', 'dsfsdf', 'sdf', 'sdfsdf', bio_f = ? ,'' ) Query Parameter Value(s) - Parameter #1 = dsfsdfsdf MY QUERY cfquery name=addit datasource=#db_datasource# username=#db_username# password=#db_password# dbtype=#db_type# dbname=#db_name# dbserver=#db_server# INSERT INTO team ( member_name, email_address, phone_office, phone_cell, phone_fax, bio, bio_f, cfif isdefined('form.sml_image_name')sml_image/cfif ) VALUES ( '#form.member_name#', '#form.email_address#', '#form.phone_office#', '#form.phone_cell#', '#form.phone_fax#', '#form.bio#', bio_f = cfqueryparam value=#form.bio_f# cfsqltype=cf_sql_longvarchar cfif isdefined('form.sml_image_name'),'#form.sml_image_name#'/cfif ) /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
Barney, I'd love that error handling code.I'll give you a plug on my blog. -mark -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:48 PM To: CF-Talk Subject: RE: Database error messages Whoops, no attachements on cf-talk.That must be cfczone that lets them through.I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
[repost from yesterday, with download link] As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line with wrapping. http://www.barneyb.com/go/cf_exception Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it.If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:35 PM To: CF-Talk Subject: RE: Database error messages Hey Barney can you put them on a web server and give us the URL? This will save you on all the sending stuff. TK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Database error messages
As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it.If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
Whoops, no attachements on cf-talk.That must be cfczone that lets them through.I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Database error messages
Pls send me a copy thx Dick On May 4, 2004, at 3:47 PM, Barney Boisvert wrote: Whoops, no attachements on cf-talk. That must be cfczone that lets them through. I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods. However, it DOESN'T display the values of stuff passed through CFQUERYPARAM. The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive. All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output. In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts. Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone. ;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax : 360.647.5351 cell : 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
Hey Barney can you put them on a web server and give us the URL? This will save you on all the sending stuff. TK -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 6:48 PM To: CF-Talk Subject: RE: Database error messages Whoops, no attachements on cf-talk.That must be cfczone that lets them through.I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Database error messages
That's the plan, but I can't do it right now for various reasons.Hopefully I can post it tonight sometime.When I do, I'll send the URL to the list. Cheers, barneyb -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:35 PM To: CF-Talk Subject: RE: Database error messages Hey Barney can you put them on a web server and give us the URL? This will save you on all the sending stuff. TK -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 6:48 PM To: CF-Talk Subject: RE: Database error messages Whoops, no attachements on cf-talk.That must be cfczone that lets them through.I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:39 PM To: CF-Talk Subject: Database error messages As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it. If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: database error
I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? - Unable to create relationship 'FK_TrainingTranslations_WWTunings'. [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8132) for table 'TrainingTranslations' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. As stated by Tony and Seva, SQL Server has a row limit of 8KB - but TEXT fields don't add to this If you've got VARCHAR fields which aren't indexed or used in a WHERE (excuding IS NULL) then make them into TEXT - it's a minor inconvenience, but it's an easy "get around" If you really need to use TEXT fields in a WHERE, then you can always use CONVERT to make them into "virtual" VARCHAR fields... slightly slower, but it works Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
database error
I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? Thanks, Sebastian --- - Unable to create relationship 'FK_TrainingTranslations_WWTunings'. [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8132) for table 'TrainingTranslations' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. ~~ 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: database error
Sebastian, If I remember my SQL Server details correctly...this is a limitation of SQL Server in table field name space. You cannot exceed 8060 characters (actually 8032 with header space) for your field names in a single table. For example, a table with two fields (FirstName, LastName) has used 17 characters of the 8032 permitted in field name space. Tony Gruen -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 8:13 PM To: CF-Talk Subject: database error I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? Thanks, Sebastian --- - Unable to create relationship 'FK_TrainingTranslations_WWTunings'. [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8132) for table 'TrainingTranslations' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. ~~ 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: database error
Sebastian, SQL Server has an 8060 byte limit on the size of a row, excluding text, image and some other fields that are stored in separate pages. You might want to either reduce the size of some of the datatypes in the table, if possible, or break the table up into smaller entities. HTH, Seva Petrov -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 11:13 PM To: CF-Talk Subject: database error I don't understand the following MS SQL error. Both columns for the primary and foreign key are varchar(20). I don't know how to fix this error because I don't even know what it means as it is the first time for this one. Any help? Thanks, Sebastian --- - Unable to create relationship 'FK_TrainingTranslations_WWTunings'. [Microsoft][ODBC SQL Server Driver][SQL Server]The total row size (8132) for table 'TrainingTranslations' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added. ~~ 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: writing to a database error
Your criteria expression is the problem (i.e., the WHERE ID='#Session.TradeID#' clause) My guess is that the TradeID field isn't a text field in which case there shouldn't be any quote marks around it. Remove them and see what you get. Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA [EMAIL PROTECTED] Ph. 714-896-3462 Fx. 714-896-3303 -Original Message- From: Samantha Jones [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 02, 2000 3:17 AM To: [EMAIL PROTECTED] Subject: writing to a database error Hi, I'm new to this so I hope I've mailed the right list... I keep getting the following error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (199:1) to (199:49). I am trying to update the database with text fields, and also a date, which I create at the top of the document. I don't think it's this that's causing the error as in another part of the system, I add a line to the db with the date. Even when I take the date out of the update, it says there is a syntax error, even though it is exactly the same syntax used elsewhere that works perfectly well. This is the update code: CFQUERY NAME="UpdateTrade" DATASOURCE="updates" UPDATE Trade SET TradeTitle='#Session.TradeTitle#', DateFromDay='#Session.DateFromDay#', DateFromMonth='#Session.DateFromMonth#', DateFromYear='#Session.DateFromYear#', DateToDay='#Session.DateToDay#', DateToMonth='#Session.DateToMonth#', DateToYear='#Session.DateToYear#', FromDate='#FromDate#', ToDate='#ToDate#', Venue='#Session.Venue#', StandNumber='#Session.StandNumber#', Town='#Session.Town#', Country='#Session.Country#' WHERE ID='#Session.TradeID#' /CFQUERY Am I missing something dead obvious cos I've been looking at it too long? Any ideas would be greatly appreciated, Sam Sam Jones Web Developer The Loop 0207 721 8643 -- 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: writing to a database error
On Fri, 02 Jun 2000 22:17:23 Samantha Jones wrote: Hi, I'm new to this so I hope I've mailed the right list... FromDate='#FromDate#', ToDate='#ToDate#', WHERE ID='#Session.TradeID#' Probably it is one of these causing your problem, I'm guessing that FromDate and ToDate are Access Date/Time fields, in which case they should be inserted in ODBC format and without quotes (ie #CreateODBCDate(FromDate)# ), I'm also guessing that ID is probably an integer field of some sort, in which case lose the quotes there too (i.e #Session.TradeID#). -- 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: writing to a database error
I keep getting the following error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. ... WHERE ID='#Session.TradeID#' Is the ID field also a text field, or is it numeric? If it's numeric, remove the quotes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.
writing to a database error
Hi, I'm new to this so I hope I've mailed the right list... I keep getting the following error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (199:1) to (199:49). I am trying to update the database with text fields, and also a date, which I create at the top of the document. I don't think it's this that's causing the error as in another part of the system, I add a line to the db with the date. Even when I take the date out of the update, it says there is a syntax error, even though it is exactly the same syntax used elsewhere that works perfectly well. This is the update code: CFQUERY NAME="UpdateTrade" DATASOURCE="updates" UPDATE Trade SET TradeTitle='#Session.TradeTitle#', DateFromDay='#Session.DateFromDay#', DateFromMonth='#Session.DateFromMonth#', DateFromYear='#Session.DateFromYear#', DateToDay='#Session.DateToDay#', DateToMonth='#Session.DateToMonth#', DateToYear='#Session.DateToYear#', FromDate='#FromDate#', ToDate='#ToDate#', Venue='#Session.Venue#', StandNumber='#Session.StandNumber#', Town='#Session.Town#', Country='#Session.Country#' WHERE ID='#Session.TradeID#' /CFQUERY Am I missing something dead obvious cos I've been looking at it too long? Any ideas would be greatly appreciated, Sam Sam Jones Web Developer The Loop 0207 721 8643 -- 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.