RE: problem with cferror, trycatch and iis7
CF Admin - Server Settings - Settings - Enable HTTP status codes -Original Message- From: Rick Root [mailto:rick.r...@webworksllc.com] Sent: Monday, March 02, 2009 11:21 AM To: cf-talk Subject: problem with cferror, trycatch and iis7 I have a couple issues with error trapping on our new server (CF801, x64 windows 2k8 and IIS7) Take a look at this code: cfset source = u:\classcreator\003\00700\1_5.jpg pcfoutputfile exists? #fileExists(source)#/cfoutput/p cftry cfx_imagecr3 getimageinfo=#source# cfdump var=#imagecr# cfcatch type=any cfdump var=#cfcatch# cfabort /cfcatch /cftry Pretty simple... it's not working, the cfx tag is causing an error, so it should do a dump of the cfcatch, right? Look what's happening... my error.cfm is still being run for some reason: http://www.saline1990.com/test.cfm So... #1 - why is my error.cfm being called and #2 - How did I get rid of all the crap that IIS is spewing when I *DO* want my error.cfm to run? I don't want that giant SERVER ERROR and 500 Internal Server Error banner. Thanks! -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with cferror, trycatch and iis7
Either you don't have the tag installed / configured correctly, or it's the fact that you're running 64 bit. The com/allaire/cfx/CustomTag null gives it away. Contact efflare for the 64 bit version of imageCR3 (it now runs as a service). Don't forget to run the service under an account that has the appropriate permissions the files you'll be manipulating. -Original Message- From: Rick Root [mailto:rick.r...@webworksllc.com] Sent: Monday, March 02, 2009 11:21 AM To: cf-talk Subject: problem with cferror, trycatch and iis7 I have a couple issues with error trapping on our new server (CF801, x64 windows 2k8 and IIS7) Take a look at this code: cfset source = u:\classcreator\003\00700\1_5.jpg pcfoutputfile exists? #fileExists(source)#/cfoutput/p cftry cfx_imagecr3 getimageinfo=#source# cfdump var=#imagecr# cfcatch type=any cfdump var=#cfcatch# cfabort /cfcatch /cftry Pretty simple... it's not working, the cfx tag is causing an error, so it should do a dump of the cfcatch, right? Look what's happening... my error.cfm is still being run for some reason: http://www.saline1990.com/test.cfm So... #1 - why is my error.cfm being called and #2 - How did I get rid of all the crap that IIS is spewing when I *DO* want my error.cfm to run? I don't want that giant SERVER ERROR and 500 Internal Server Error banner. Thanks! -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with cferror, trycatch and iis7
Two thoughts on that: 1. Because the type of error being thrown and what types of errors your error.cfm handles. 2. It's an unhandled exception in ColdFusion itself (com/allaire/cfx/CustomTag null), so CF error handling is never invoked. -Original Message- From: Rick Root [mailto:rick.r...@webworksllc.com] Sent: Monday, March 02, 2009 3:17 PM To: cf-talk Subject: Re: problem with cferror, trycatch and iis7 On Mon, Mar 2, 2009 at 3:40 PM, Pat Wenke pwe...@uhlig.com wrote: Either you don't have the tag installed / configured correctly, or it's the fact that you're running 64 bit. The com/allaire/cfx/CustomTag null gives it away. You seem to have misunderstood my problem. I'm not asking for help with why imagecr3 isn'tw orking (for what it's worth, I *AM* using the Java cfx_imagecr3 and the imagecr3 service, and the service is running as the local system account, which has permissions on the file in question). I've actually entered another thread about that... No, what I'm asking in this thread is why is my try/catch being ignored? Why isn't it CATCHING the error and dumping the cfcatch? Instead, it's running my error.cfm. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderar ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 64 bit imagecr3
Add this (or your jar location): C:\Program Files (x86)\Efflare\ImageCR3Service\imagecr3.jar To: CF Admin - Server Settings - Java and JVM - ColdFusion Class Path You'll probably need to restart CF. -Original Message- From: Rick Root [mailto:rick.r...@webworksllc.com] Sent: Monday, March 02, 2009 4:05 PM To: cf-talk Subject: Re: 64 bit imagecr3 I checked out the exception.log to see if there's more detail on the error Error,jrpp-65,03/02/09,09:36:37,cc_domain_sites,com/allaire/cfx/CustomTag The specific sequence of files included or processed is: D:\Inetpub\classcreator\www\test.cfm, line: 14 java.lang.NoClassDefFoundError: com/allaire/cfx/CustomTag That second line implies that it's not finding my ImageCR3.class - even though it's in the imagecr3.jar file in a directory that IS in my JVM's class path (BTW, I emailed efflare this morning, no response yet.) -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320040 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 Server 2005 Datasource failing
Is TCP/IP enabled on your SQL 2005 instance? By default, TCP/IP connections are disabled in SQL 2005. - Pat -Original Message- From: Brad Wood [mailto:b...@bradwood.com] Sent: Tuesday, February 17, 2009 10:32 PM To: cf-talk Subject: Re: SQL Server 2005 Datasource failing What port is SQL Server 2005 listening on? Also, can you connect using the same password in Enterprise Manager? Run a trace on the 2005 database and include failed login events from the audit group. Can you see the login failures coming through. If not, CF isn't hitting the correct SQL instance. ~Brad - Original Message - From: Stan Winchester s...@aftershockweb.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, February 17, 2009 9:38 PM Subject: SQL Server 2005 Datasource failing On my local network I've been using SQL Server 2000 and connecting to it with BD7 CF8 with no problems. I also have SQL Server 2005 on it and am having trouble creating a datasource that logins. It seems to see SQL Server 2005, but I am getting the following error: Connection verification failed for data source: [my datasource] java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database [my datasource] requested by the login. The login failed. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database [my datasource] requested by the login. The login failed. With SQL Server 2000 I just connected using the [server name] over port 1433 with no problems. SQL Server 2005 is on the box so the server is called [server name]\sqlserver2005 as shown in the connections properties in MS SQL Server Management Studio, with the instance name sqlserver2005. I have checked and re-checked the user name / password and they are the same in CF8 the SQL Server 2005 database. Any ideas what I am missing? Thanks, Stan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 Performance Problems?
This sounds exactly like the problem we ran into with one of our apps that is under very high load. Template cache settings and JVM settings do not make a noticeable difference one way or another in this case. I worked closely with Adobe support on this issue (bug 70837). Via some very simple code I wrote to reproduce the problem, Adobe found a bug in JVM 1.6 that basically hoses the template cache / classloading. Because JVMs 1.4 and 1.5 (and even a beta of 1.7 I tried) do not have the same problem as 1.6, Adobe saw these as feasible workarounds and thus marked this issue as a low-priority bug. We started using 1.5, and the problems went away immediately. I recommend anyone else with performance problems do the same. If another JVM is not an option, perhaps we can contact Adobe again and get them to push out a hotfix. quote However, if you are unable to continue in your production environment with the workarounds that you have found and would like a hotfix for this specific issue, let me know and I will inform the engineers to set a higher priority for this bug. /quote ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 Performance Problems?
This sounds exactly like the problem we ran into with one of our apps that is under very high load. Template cache settings and JVM settings do not make a noticeable difference one way or another in this case. I worked closely with Adobe support on this issue (bug 70837). Via some very simple code I wrote to reproduce the problem, Adobe found a bug in JVM 1.6 that basically hoses the template cache / classloading. Because JVMs 1.4 and 1.5 (and even a beta of 1.7 I tried) do not have the same problem as 1.6, Adobe saw these as feasible workarounds and thus marked this issue as a low-priority bug. We started using 1.5, and the problems went away immediately. I recommend anyone else with performance problems do the same. If another JVM is not an option, perhaps we can contact Adobe again and get them to push out a hotfix. quote However, if you are unable to continue in your production environment with the workarounds that you have found and would like a hotfix for this specific issue, let me know and I will inform the engineers to set a higher priority for this bug. /quote ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 8 Performance Problems?
Correct. I should have made that point in my original post. It's Sun's bug, not Adobe's. We originally thought this was a CF 8 issue (back when CF8 was released), which is why I began working with Adobe (10/4/2007), and why they logged a bug (11/26/2007). They suggested, if a JVM change is not an option, to notify them and they would elevate the case again, though I doubt there's much they can do to code around Sun's classloading problem. -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2008 3:36 PM To: CF-Talk Subject: Re: CF 8 Performance Problems? This bug is not Adobe's, but Sun's. It is a known issue with the classloader in Java 6 that still has not been fixed, though it appears to be fixed in the beta builds of Java 7. http://corfield.org/blog/index.cfm/do/blog.entry/entry/Java_6_and_ColdFu sion_8 On Fri, Mar 21, 2008 at 9:56 AM, Mark Kruger [EMAIL PROTECTED] wrote: Pat, Put me on the I think it's a high priority list. If they are going to tout CF8 as a huge performance gain and certifiy it for 1.6 then I would think this would be an issue for them. -Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: One more try... 7 = 7?
What version of CFMX? I've seen similar with older drivers (pre 6.1 Updater). -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 7:57 AM To: CF-Talk Subject: One more try... 7 = 7? Anyone ever seen this? Error Occurred While Processing Request 7 = 7 the query is a simple select query... SELECT * FROM GALLERY_PHOTOS where blog_id=cfqueryparam cfsqltype=CF_SQL_INTEGER value=#blog_id# and gallery_id=cfqueryparam cfsqltype=CF_SQL_INTEGER value=#GALLERY_ID# This is occuring in SQL Server 2000... sporadically, according to the person who reported the bug. I can't duplicate it though. Rick ~| 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:207877 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: One more try... 7 = 7?
Rick - Try setting max pooled statements to 0 in CF admin for the problematic datasource(s). I've seen x = x errors and Variable cannot be converted to requested type errors when adding / removing columns from tables. Changing the max pooled statements setting fixed our problem. See more in the thread below. http://www.houseoffusion.com/cf_lists/messages.cfm/Threadid=34563forumi d=4#174302 Pat -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 7:57 AM To: CF-Talk Subject: One more try... 7 = 7? Anyone ever seen this? Error Occurred While Processing Request 7 = 7 the query is a simple select query... SELECT * FROM GALLERY_PHOTOS where blog_id=cfqueryparam cfsqltype=CF_SQL_INTEGER value=#blog_id# and gallery_id=cfqueryparam cfsqltype=CF_SQL_INTEGER value=#GALLERY_ID# This is occuring in SQL Server 2000... sporadically, according to the person who reported the bug. I can't duplicate it though. Rick ~| 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:207880 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
Jar Files
We're running CFMX 6.1 on top of JRun and making use of a lot of Java classes. The classes are packaged in JAR files in the /WEB-INF/lib directory. Dropping an updated jar file in the lib directory causes in memory instances of the classes in the jar file to not work. For instance, the Java class com.uhlig.Job is defined in uhlig.jar. An instance of Job is created and stored in the application scope. Then a new version of uhlig.jar is copied over the old in the lib directory. Now the instance of Job previously created will throw an exception trying to use it (usually a 'selected method was not found'). Finally the question... Does anyone know how to get CFMX/JRun to ignore the new jar file? Setting reloadfalse/reload under the jrun-web-app in jrun-web.xml does not seem to be doing the trick. Thanks. ~| 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:202821 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: 500 Internal Server Error
Do you have Enable HTTP status codes turned off in CF Admin? We had the same problem until I saw a post from Ben Forta regarding the setting. Ever since I turned it off, we haven't had a problem. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, February 04, 2005 8:33 AM To: CF-Talk Subject: 500 Internal Server Error Every now and again I will get a 500 Internal Server Error. This happens when I submit a CF template for processing (i.e. forms). I am developing locally: CFMX 6.1, WinXP Pro / IIS, IE 6. Has anyone encountered this and if so, did you find out what was causing it? My first thought is that it is not CF related, but I have only experienced it when attempting to process CF pages. Any insight is much appreciated. Thanks, 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:193074 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: weird but consistent behavior
George - We were getting the same errors when adding / removing columns from the DB.You might want to try the following (if you're still wanting to use cfqueryparam and SELECT *) from Stephen Dupre at Macromedia: Maybe the statement cache is getting us.Try shutting off Max Pooled Statements (set this to 0) and see if this clears anything up. We took this approach and it works great. Hope this helps! Pat -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:43 PM To: CF-Talk Subject: Re: weird but consistent behavior So OT, why is using Select * a bad practice? URLs anyone? George On Fri, 13 Aug 2004 16:42:18 +0100, Alistair Davidson [EMAIL PROTECTED] wrote: I've heard of similar things happening on queries where you use SELECT * (see http://www.1pixelout.net/index.cfm/blog/entry/cfqueryparam.htm ) Are you using select * ? If so, consider the error a slap on the wrist! ;) Cheers, Alistair _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: weird but consistent behavior
That's what I wondered as well...apparently it's not too bad, and we haven't had any noticeable decrease.See below, again from MM. This excerpt is part of a discussion we had internally about this.I hope it helps clarify this. If you set maxpooledstatements = 100; for each connection, the last 100 SQL statements are retained. These are retained in both text form and in compiled form, so the SQL text does not need to re-interpreted. If you have a query where the SQL text *exactly* matches one of these retained statements then the statement is re-used. cfqueryparam is the only exception to this rule. If the SQL is an exact match and the cfqueryparam is also a match except for the value, then the statement can be re-used. Ditto for stored procedures and cfprocparam. Queries procedure calls go in the same pool of statements. A good example of this is the debug output from CFMX The query: SELECT * FROM tbl001 WHERE name = cfqueryparam value=#z# cfsqltype=CF_SQL_VARCHAR AND ID 125 ORDER BY ID DESC looks like this in the debug output: SELECT * FROM tbl001 WHERE name = ? AND ID 125 ORDER BY ID DESC Any query whose debug output exactly matches this debug output will take advantage of the statement pool. IN CFML, it is fairly unusual for SQL statements to exactly match, unless cfqueryparam is used extensively. This means that statement pooling is unlikely to be helpful in most CFML apps. Even when statement pooling gets frequent matches, the performance gains are likely to be very modest unless the SQL text is very long and parsing it represents a significant effort. Stephen -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 2:08 PM To: CF-Talk Subject: Re: weird but consistent behavior Hmm, I wonder what that does to performance though. George On Fri, 13 Aug 2004 13:57:23 -0500, Pat Wenke [EMAIL PROTECTED] wrote: George - We were getting the same errors when adding / removing columns from the DB.You might want to try the following (if you're still wanting to use cfqueryparam and SELECT *) from Stephen Dupre at Macromedia: Maybe the statement cache is getting us.Try shutting off Max Pooled Statements (set this to 0) and see if this clears anything up. We took this approach and it works great. Hope this helps! Pat _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Where is CFSCHEDULE data stored?
cf_root\lib\neo-cron.xml -Original Message- From: Alexander Sherwood [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 10:09 AM To: CF-Talk Subject: Where is CFSCHEDULE data stored? Anyone know where the data for tasks scheduled with CFSCHEDULE is stored? Thanks! -- Alex _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Find
CHARINDEX ( expression1 , expression2 [ , start_location ] ) PATINDEX ( '%pattern%' , _expression_ ) Check SQL Server BOL for more info on how to use these functions. -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 3:37 PM To: CF-Talk Subject: SQL Find Does SQL Server have an function similar to CF's Find string function. I need to parse 150,000 names depending on where the comma is in the string and update each record. Not a great task for CF. I'm aware of the substring command but it needs to know what position the comma is in. Lee Surma _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: update code not working
You are missing 2 commas. -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 4:03 PM To: CF-Talk Subject: update code not working I have an bit of code to update an edited record.I'm getting the error [Oracle]ORA-00927: missing equal sign in the line WHERE ce_email = '#Form.ce_email#'. I can't spot the error.Any suggestions? CFQUERY NAME=makeEdit DATASOURCE=dpch update careerexpo2004 set ce_orgname = '#Form.ce_orgname#', ce_street = '#Form.ce_street#', ce_city = '#Form.ce_city#', ce_state = #Form.ce_state#, ce_zip= #Form.ce_zip#, ce_phone = '#Form.ce_phone#', ce_fax = #Form.ce_fax#, ce_email = #Form.ce_email#, ce_repfname = #Form.ce_repfname# ce_replname = '#Form.ce_replname#', ce_contactfname = '#Form.ce_contactfname#', ce_contactlname = '#Form.ce_contactlname#', ce_datesubmitted = '#Form.ce_datesubmitted#' WHERE ce_email = '#Form.ce_email#' /CFQUERY _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: update code not working
Actually, just 1...I read that too quickly. -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 4:03 PM To: CF-Talk Subject: update code not working I have an bit of code to update an edited record.I'm getting the error [Oracle]ORA-00927: missing equal sign in the line WHERE ce_email = '#Form.ce_email#'. I can't spot the error.Any suggestions? CFQUERY NAME=makeEdit DATASOURCE=dpch update careerexpo2004 set ce_orgname = '#Form.ce_orgname#', ce_street = '#Form.ce_street#', ce_city = '#Form.ce_city#', ce_state = #Form.ce_state#, ce_zip= #Form.ce_zip#, ce_phone = '#Form.ce_phone#', ce_fax = #Form.ce_fax#, ce_email = #Form.ce_email#, ce_repfname = #Form.ce_repfname# ce_replname = '#Form.ce_replname#', ce_contactfname = '#Form.ce_contactfname#', ce_contactlname = '#Form.ce_contactlname#', ce_datesubmitted = '#Form.ce_datesubmitted#' WHERE ce_email = '#Form.ce_email#' /CFQUERY _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [CFCDev] CFC webservice objects
Do you have a good understanding of OOP encapsulation?If you're looking for the properties of this object, you won't be able to get to them using aCat.ID aCat.categoryName aCat.status Rather, you'll need to get them by using the get() methods, i.e. aCat.getID() aCat.getCategoryName() aCat.getstatus() -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cutter (CF-Talk) Sent: Friday, July 30, 2004 4:38 PM To: [EMAIL PROTECTED] Subject: [CFCDev] CFC webservice objects Sorry for cross posting this to more than one list, I'm sure some of you will see this twice. OK, maybe I'm just going crazy. I still can't get a CFC object to work correctly. I've seen 75 examples, and each one is different in even it's most basic form (many from the same authors). I even resorted to using DWMX 2004 to create a CFC, and create the call for it in another page (shiver). What's going on? I created a cfc to use as a webservice with 3 properties and a single init() method. I know that CF automatically creates get() and set() methods for each of the properties. Not rocket science (at least I didn't think so) but I'm just not getting anything. Here's the code: //** Here's the category5.cfc **// cfcomponent displayName=category5 cfproperty name=ID type=numeric cfproperty name=categoryName type=string cfproperty name=status type=boolean cffunction name=init access=remote returnType=category5 cfargument name=ID type=numeric default=0 cfif arguments.ID neq 0 cfquery name=cat datasource=#application.config.DSN# select txtBoutCat as category, blActive as status from tblboutcat2 where intBoutCatID = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.ID# /cfquery cfif cat.recordcount eq 1 cfscript this.ID = arguments.ID; this.category = cat.category; this.status = cat.status; /cfscript /cfif /cfif cfreturn this /cffunction /cfcomponent //** Here's a call to the init **// cfinvoke webservice=#[the path]#/category5.cfc?wsdl method=init returnvariable=aCat cfinvokeargument name=ID value=1/ /cfinvoke //** And here's the cfdump of #aCat#. Notice the lack of properties **// object of #[heres_that_path_again]#.Category5_Type Methods hashCode (returns int) equals (returns boolean) getStatus (returns java.lang.Boolean) setStatus (returns void) getID (returns java.lang.Double) setID (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getCategoryName (returns java.lang.String) setCategoryName (returns void) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) Any assistance is greatly appreciated. (Just one solid reference...) Cutter -- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
