java.lang.NullPointerException
I'm getting a java.lang.NullPointerException on a cfprocresult tag inside a cfstoredproc tag (at least this is what CF debugger points to). The stored procedure returns three very small answer sets and I get the error on the third one. If I comment out the third one I get the same error on the second one, etc. I'm running CFMX 6.1 on Windows 2000 Advanced Server against DB2 7.x on z/OS using IBM JDBC Type4 drivers. If I switch to ODBC_socket drivers the call to the stored procedure works fine. This process has been bulletproof on CF 5.0 for almost three years . . . Here's the error that comes back to the browser: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. Here's the corresponding error from the exception.log file in CF Admin (which, by the way, is not nearly as friendly as the logs in CF 5.0): Error,jrpp-10,05/04/04,13:33:18,RZ_LI_Workload, The specific sequence of files included or processed is: E:\Inetpub\wwwroot\emis\mgmnt\rzli\rzli_security.cfm java.lang.NullPointerException at coldfusion.sql.QueryTable.populate(QueryTable.java:260) at coldfusion.sql.Executive.getRowSets(Executive.java:559) at coldfusion.sql.Executive.executeCall(Executive.java:814) at coldfusion.sql.Executive.executeCall(Executive.java:749) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:317) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192) at cfrzli_security2ecfm1061558558.runPage(E:\Inetpub\wwwroot\emis\mgmnt\rzli\rz li_security.cfm:51) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Here's the CF markup that gets the error (on RS3 toward the bottom): cftransaction cfstoredproc datasource=#datasource# procedure=RVSPSEC returnCode=Yes !--- cfprocparam tags - variables passed to security stored procedure --- cfprocparam type=IN cfsqltype=CF_SQL_VARCHAR value=#pin##applicationType##applicationSource##paddingSpaces# dbvarname=@INPTST !--- cfprocparam tags - variables passed from the security stored procedure --- cfprocparam type=OUT cfsqltype=CF_SQL_VARCHAR variable=code dbvarname=@RTRNCD cfprocparam type=OUT cfsqltype=CF_SQL_VARCHAR variable=message dbvarname=@RTRNMSG !--- result set tag --- cfprocresult name = RS1 cfprocresult name = RS2 resultSet=2 cfprocresult name = RS3 resultSet=3 /cfstoredproc /cftransaction (I have tried it without dbvarname, which is deprecated, and the result is the same - they are back in as we try stuff.) Any ideas what is happening here and how to correct it? Thanks! George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFCs that perform INSERT...yikes...
Actually this should be: [snip] Thanks Ben, Dave and Tom. This has been a real help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
java.lang.NullPointerException - Part 1 of 2
(Part 1 0f 2 - the line counter got me) Sorry for the length of this message . . . I'm getting a java.lang.NullPointerException on a cfprocresult tag inside a cfstoredproc tag (at least this is what CF debugger points to). The stored procedure returns three very small answer sets and I get the error on the third one. If I comment out the third one I get the same error on the second one, etc. I'm running CFMX 6.1 on Windows 2000 Advanced Server against DB2 7.x on z/OS using IBM JDBC Type4 drivers. If I switch to ODBC_socket drivers the call to the stored procedure works fine. This process has been bulletproof on CF 5.0 for almost three years . . . Here's the error that comes back to the browser: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. Here's the corresponding error from the exception.log file in CF Admin (which, by the way, is not nearly as friendly as the logs in CF 5.0): Error,jrpp-10,05/04/04,13:33:18,RZ_LI_Workload, The specific sequence of files included or processed is: E:\Inetpub\wwwroot\emis\mgmnt\rzli\rzli_security.cfm java.lang.NullPointerException at coldfusion.sql.QueryTable.populate(QueryTable.java:260) at coldfusion.sql.Executive.getRowSets(Executive.java:559) at coldfusion.sql.Executive.executeCall(Executive.java:814) at coldfusion.sql.Executive.executeCall(Executive.java:749) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:317) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:192) at cfrzli_security2ecfm1061558558.runPage(E:\Inetpub\wwwroot\emis\mgmnt\rzli\rz li_security.cfm:51) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) (Part 2 of 2 to follow) George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
java.lang.NullPointerException - Part 2 of 2
(Part 2 0f 2 - the line counter got me) Here's the CF markup that gets the error (on RS3 toward the bottom): cftransaction cfstoredproc datasource=#datasource# procedure=RVSPSEC returnCode=Yes !--- cfprocparam tags - variables passed to security stored procedure --- cfprocparam type=IN cfsqltype=CF_SQL_VARCHAR value=#pin##applicationType##applicationSource##paddingSpaces# !--- cfprocparam tags - variables passed from the security stored procedure --- cfprocparam type=OUT cfsqltype=CF_SQL_VARCHAR variable=code cfprocparam type=OUT cfsqltype=CF_SQL_VARCHAR variable=message !--- result set tag --- cfprocresult name = RS1 cfprocresult name = RS2 resultSet=2 cfprocresult name = RS3 resultSet=3 /cfstoredproc /cftransaction (I have tried it without dbvarname, which is deprecated, and the result is the same - they are back in as we try stuff.) Any ideas what is happening here and how to correct it? Thanks! George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with fragments and frames
A fragment is the '#location' that can be appended to a URL and cause a browser to display the NAME'd or ID'ed anchor at the top of the page. I actually managed to find a description of the problem on the Web (which was pretty amazing given that the collection of keywords I could think of was finding 100's of hits!-)It appears to be a MS design flaw(?) with IFRAME's.More at: http://www.cs.tut.fi/~jkorpela/html/iframe.html Thanks! Jon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with fragments and frames
Hm, I realize I was a little imprecise in the nature of the problem. The fragment _does_ get displayed at the top of the frame window AND that location gets displated at the top of the whole browser window itself.That is, the whole frameset get shifted up. Jon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFCs that perform INSERT...yikes...
I am not writing anything to the page, the output tag is there just to run another function. You can see it from function heading that the output is set to false. As for the use of cfcatch, maybe this was not a good example, but I want to give more detailed error messages and/or perform recover operation on error. A general cferror page would be just too general for what I need. I guess it all comes down to what one needs the code to do in a given situation. TK -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 2:18 PM To: CF-Talk Subject: RE: CFCs that perform INSERT...yikes... So is what he did a pretty good example of an insert CFC? I like his explanations of why he chose to do what he did. I lost my Advance CF book from Figleaf, so I can't go by any of that cool course stuff, so I'm winging it as I go. Are there any cool tutorials to go by online that you or anyone knows of that go over best practices for an INSERT CFC? I don't think there's anything wrong with his example, in general, although I don't like the use of CFTRY/CFCATCH within a CFTRANSACTION generally, nor do I like having a component write a raw error message to a page. 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]
install RDS CFMX new install
how does one go about installing RDS, or turning on the service in CFMX? im trying to add mappings and I cant get to the filesystem. any ideas? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF 5 and Oracle 9i
Isn't (wasn't) the problem with using the ODBC driver the fact that you couldn't return REF CURSORS - only the Native Oracle driver (via Enterprise version or other means) provided the ability? Steven Semrau SRA International http://www.sra.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 2:31 PM To: CF-Talk Subject: RE: CF 5 and Oracle 9i We've had no problems using stored procedures using ODBC datasources in Oracle8i and CF5. I would assume the same is true for 9i. Can you retrieve recordsets from those stored procedures? 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: Web Service Woes
You can pass a query to _javascript_?!?!?! Yes. I can pass cf arrays, cf structs, and with mr. applebaums thin array yes I can pass queries to _javascript_. _javascript_ calles a cf web service and gets data - its my little neuromancer thing that floats around the list from time to time - its totally cool. OCH3 H3C||/ \ /\N N\/\ || // //\/ \// O NN | CH3 http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: LIKE and % is just not enough. Advanced SQL Search help neede d
Calling this a little processor intensive would be a gross understatement. If you have any significant amount of data within your database, any one of these queries will be a lot of work for your database server, as it'll involve a table scan. If you really want to do these sorts of searches and categorizations, use a full-text indexing engine like Verity. If you have a million records in your database, this would be stupid slow. Not every application has a million records in the database. I just did a test on MS Access searching 10,000 rows with multiple LIKEs in the where clause. Each query took an average of 47ms. Doing 7 unique LIKE queries (every permutation of 3 words, took 329ms) Granted, it did make the processor spike up to a full 2%. So yes, I concede, it is a little processor intensive. ;-) Jason, how many records are you trying to search? Give or take. Steve Nelson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Form button
I have an image as a form button as: input type=image src="" name=C1 value=update In my CF code pressing this button should execute an update, however the following code generates an error: CFIF IsDefined(form.C1.X) and form.C1 EQ update Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined(form.C1.X) and form.C1 EQ update Error near line 1, column 29. Error resolving parameter FORM.C1 The specified form field cannot be found. Am I missing something here? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: install RDS CFMX new install
To reinstall RDS, edit {cfroot}\lib\adminconfig.xml, change runsetupwizardfalse/runsetupwizard to true, then run the CFAdmin to complete the migration wizard again. To disable/enable RDS, see this http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/config22.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/config22.htm _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:23 PM To: CF-Talk Subject: install RDS CFMX new install how does one go about installing RDS, or turning on the service in CFMX? im trying to add mappings and I cant get to the filesystem. any ideas? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: price of aspx vs cfm
Haha, I was just reading this article again two weeks ago - it's in one of the last 2002 issues of CFDJ - sorry I'm at work so I don't have the exact Vol. and Issue. But if you go to http://www.sys-con.com/coldfusion/ you should be able to find it. I believe it was the November issue. -Original Message- From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 2:44 PM To: CF-Talk Subject: Re: price of aspx vs cfm Ben Forta did a great article on this a while back.I Hopefully he'll chime in with a URL. >From my perspective, there are 2 major areas where CF saves money. First, development time.CF development is, IME, faster; less development time = saved money.Second, what you don't have to buy.My ASP experience goes back to ASP 3.0, so things might have changed with .net, but with ASP, if you wanted to do file uploads, or send emails, or do any of that special stuff, you had to go find a third-party solution which would usually cost $$$. So, take the argument from this perspective.Come up with an application that involves database access, file uploading, writing your own logs, robust error handling, and sending emails.Agree on the requirements, then have 2 developers of roughly equal skill levels develop the app in both CF and ASP.See who's headed for happy hour and who's headed for the bottle of excedrin. Pete John Ho wrote: hi guy Can someone give me advantage/disadv in asp.net and coldfusionmx?. asp.net is free? or how much?. I current have coldfusionmx and try to convince some of my coworkers to use coldfusion thanks John __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFCs that perform INSERT...yikes...
I should state upfront that I'm not trying to be critical of your code, specifically. If it works well enough for you, that's all that matters. However, there are some specific items that people may want to avoid generally. I am not writing anything to the page, the output tag is there just to run another function. You can see it from function heading that the output is set to false. In that case, why use CFOUTPUT at all? Why not just run the function? cfset my_function() As for the use of cfcatch, maybe this was not a good example, but I want to give more detailed error messages and/or perform recover operation on error. In your example, though, you're not returning an error at all - just a string, which the calling program will have to interpret as an error. In general, it's considered good to return errors from objects when those objects fail. Those errors can be caught by the callers of the objects. A general cferror page would be just too general for what I need. I guess it all comes down to what one needs the code to do in a given situation. This is true enough. 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: Web Service Woes
On Tue, 04 May 2004 12:26:05 -0700 (PDT), [EMAIL PROTECTED] wrote: You can pass a query to _javascript_?!?!?! Yes. I can pass cf arrays, cf structs, and with mr. applebaums thin array yes I can pass queries to _javascript_. _javascript_ calles a cf web service and gets data - its my little neuromancer thing that floats around the list from time to time - its totally cool. Which, btw, the site is up now (at least for a while) http://www.rohanclan.com/products/neuromancer/index.cfm OCH3 H3C||/ \ /\N N\/\ || // //\/ \// O NN | CH3 http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form button
Well, let's see IsDefined(form.C1.X) and form.C1 EQ update First off I'd say just try adding .X to form.C1 EQ update--form.C1.X EQ update. Steven Semrau SRA International http://www.sra.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:24 PM To: CF-Talk Subject: Form button I have an image as a form button as: input type=image src="" name=C1 value=update In my CF code pressing this button should execute an update, however the following code generates an error: CFIF IsDefined(form.C1.X) and form.C1 EQ update Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined(form.C1.X) and form.C1 EQ update Error near line 1, column 29. Error resolving parameter FORM.C1 The specified form field cannot be found. Am I missing something here? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Session Variables and Firewalls
We have an application that's supposed to time out after 45 minutes of non use. It's run via a session variable. Has anyone seen an instance where a firewall interferes with the variable and would cause it to expire prematurely or not at all? thanks sas [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Form button
Even when form.c1 isn't defined, the second test (after the and) is still evaluated. Try: cfparam name=form.c1 default= CFIFform.C1 EQ update or: cfif isDefined('FORM.c1') cfif FORM.c1 eq 'update' - Original Message - From: Robert Orlini To: CF-Talk Sent: Tuesday, May 04, 2004 3:23 PM Subject: Form button I have an image as a form button as: input type=image src="" name=C1 value=update In my CF code pressing this button should execute an update, however the following code generates an error: CFIF IsDefined(form.C1.X) and form.C1 EQ update Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined(form.C1.X) and form.C1 EQ update Error near line 1, column 29. Error resolving parameter FORM.C1 The specified form field cannot be found. Am I missing something here? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: LIKE and % is just not enough. Advanced SQL Search help neede d
Calling this a little processor intensive would be a gross understatement. If you have any significant amount of data within your database, any one of these queries will be a lot of work for your database server, as it'll involve a table scan. If you really want to do these sorts of searches and categorizations, use a full-text indexing engine like Verity. If you have a million records in your database, this would be stupid slow. Not every application has a million records in the database. I just did a test on MS Access searching 10,000 rows with multiple LIKEs in the where clause. Each query took an average of 47ms. Doing 7 unique LIKE queries (every permutation of 3 words, took 329ms) Granted, it did make the processor spike up to a full 2%. So yes, I concede, it is a little processor intensive. ;-) I guess I should've been a little clearer in my previous post. My concern isn't really with CPU resources, specifically, but rather that this approach will be very problematic with any significant amount of data. Those LIKE operators you were using require a full table scan for each one, and this will have a detrimental effect on concurrent requests. 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]
Oracle 9i and cfqueryparam problems
Has anyone had any issue using TIMESTAMP as the datatype for bind variables when using cfmx 6.1 with Oracle 9i? It seems we're getting queries that run for very long periods of time...if we take out the bind variables...query only takes a few seconds! -Stace [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form button
Tried that. No errors but it does not run the update. -Original Message- From: Semrau Steven Ctr SAF/IE [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:44 PM To: CF-Talk Subject: RE: Form button Well, let's see IsDefined(form.C1.X) and form.C1 EQ update First off I'd say just try adding .X to form.C1 EQ update--form.C1.X EQ update. Steven Semrau SRA International http://www.sra.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:24 PM To: CF-Talk Subject: Form button I have an image as a form button as: input type=image src="" name=C1 value=update In my CF code pressing this button should execute an update, however the following code generates an error: CFIF IsDefined(form.C1.X) and form.C1 EQ update Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined(form.C1.X) and form.C1 EQ update Error near line 1, column 29. Error resolving parameter FORM.C1 The specified form field cannot be found. Am I missing something here? Thanks. Robert O. HWW _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF 5 and Oracle 9i
You are probably right.if and when I need ref cursors, I just develop a PL/SQL procedure or package using cursors to do all the gruntwork and return success (or error) codes, but not everyone has that option. Jason Gulledge -Original Message- From: Semrau Steven Ctr SAF/IE [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 2:21 PM To: CF-Talk Subject: RE: CF 5 and Oracle 9i Isn't (wasn't) the problem with using the ODBC driver the fact that you couldn't return REF CURSORS - only the Native Oracle driver (via Enterprise version or other means) provided the ability? Steven Semrau SRA International http://www.sra.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 2:31 PM To: CF-Talk Subject: RE: CF 5 and Oracle 9i We've had no problems using stored procedures using ODBC datasources in Oracle8i and CF5. I would assume the same is true for 9i. Can you retrieve recordsets from those stored procedures? 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: install RDS CFMX new install
I think you just have to go in an uncomment the RDS servlet in web.xml.I believe that the installer just comments it out if you opt not to install it, but it might actually delete it, I've never checked. How hard is it to just type in the path?I've never had problems doing it that way. Cheers, barneyb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 12:23 PM To: CF-Talk Subject: install RDS CFMX new install how does one go about installing RDS, or turning on the service in CFMX? im trying to add mappings and I cant get to the filesystem. any ideas? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Form button
the form element will indeed be form.C1.X (and also form.C1.Y) the value passed will be the x and y coordinates (ie where exactly the user clicked on the button) so you will never see 'update' as the value of that form element - Original Message - From: Semrau Steven Ctr SAF/IE To: CF-Talk Sent: Tuesday, May 04, 2004 9:44 PM Subject: RE: Form button Well, let's see IsDefined(form.C1.X) and form.C1 EQ update First off I'd say just try adding .X to form.C1 EQ update--form.C1.X EQ update. Steven Semrau SRA International http://www.sra.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:24 PM To: CF-Talk Subject: Form button I have an image as a form button as: input type=image src="" name=C1 value=update In my CF code pressing this button should execute an update, however the following code generates an error: CFIF IsDefined(form.C1.X) and form.C1 EQ update Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined(form.C1.X) and form.C1 EQ update Error near line 1, column 29. Error resolving parameter FORM.C1 The specified form field cannot be found. Am I missing something here? Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFCs that perform INSERT...yikes...
I am not writing anything to the page, the output tag is there just to run another function. You can see it from function heading that the output is set to false. In that case, why use CFOUTPUT at all? Why not just run the function? cfset my_function() [Tom Kitta] I don't know why I started with this cfoutput thing... I guess when I started this particular CFC the code is based on I was not yet aware of other ways of running functions. After you start things one way its just better to keep it that way for consistency. It seams to be also a good way to throw people off as to how your code works (which probably is not a good thing) :) TK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: LIKE and % is just not enough. Advanced SQL Search help neede d
True, it's not the most scalable solution, I'm sure there are more efficient ways to achieve the same thing. But from Jason's email it sounds like massive scalability is not the biggest concern, I think at this point he's simply trying to return the most accurate results to help his users achieve their goals of finding the correct product. Steve I guess I should've been a little clearer in my previous post. My concern isn't really with CPU resources, specifically, but rather that this approach will be very problematic with any significant amount of data. Those LIKE operators you were using require a full table scan for each one, and this will have a detrimental effect on concurrent requests. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Form button
Original Message: From: Dave Francis Date: Tue, 4 May 2004 15:44:20 -0400 Even when form.c1 isn't defined, the second test (after the and) is still evaluated. This is only true in pre-MX versions of CF.In CFMX, if the left side of an AND check returns false, it stops evaluating the rest of the if code. (Similarly, I believe that if the left hand side of an OR check returns true, it also stops evaluating) Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: blackstone
lol. that's all? well count me in. heck the made me do all that... well cept the first born part, although I didnt read everything I signed... -adam -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 4, 2004 03:27 PM To: 'CF-Talk' Subject: RE: blackstone I wondered how long it would take for someone to respond with that ... But, I can't say soon unless you all sign NDAs, give me DNA samples, sign away your first borns, submit to full background checks, install biometric identification on your computers (retina scan preferred), ... so, not soon, it's a bit longer than soon. :-) --- Ben _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 11:26 AM To: CF-Talk Subject: RE: blackstone Yep, you can ask that question, there is an expected release date. But don't ask what it is. :-) --- Ben Come on Ben, we were all hoping for the soon reply... What a let down you are :-) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX / JRUN Proxy server on 51020
Probably an ignorant question :Anyone know why JRUN in CFMX 6.1 runs a proxy server on 51020? Jason Gulledge ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX / JRUN Proxy server on 51020
This technote describes the ports that ColdFusion MX uses: http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm The default proxy port is 51010, but you must have a server instance where JRPP must be set to 51020.The JRun Proxy Port is the port on which the webserver connector communicates with the JRun Server. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:20 PM To: CF-Talk Subject: CFMX / JRUN Proxy server on 51020 Probably an ignorant question :Anyone know why JRUN in CFMX 6.1 runs a proxy server on 51020? Jason Gulledge [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX / JRUN Proxy server on 51020
I figured as much, but I wanted to be sure. -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 4:41 PM To: CF-Talk Subject: RE: CFMX / JRUN Proxy server on 51020 This technote describes the ports that ColdFusion MX uses: http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm http://www.macromedia.com/support/coldfusion/ts/documents/tn18336.htm The default proxy port is 51010, but you must have a server instance where JRPP must be set to 51020.The JRun Proxy Port is the port on which the webserver connector communicates with the JRun Server. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 5:20 PM To: CF-Talk Subject: CFMX / JRUN Proxy server on 51020 Probably an ignorant question :Anyone know why JRUN in CFMX 6.1 runs a proxy server on 51020? Jason Gulledge _ [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]
One slow server...
I am at a loss here. Here's the setup: Webserver running Cold Fusion MX on JRun4 on Solaris9, talking to MS SQL Server database on a different machine. About two weeks ago, we started experiencing serious slow-downs on our site.Neither computer is responsible -- the Solaris box is running normally, as is the Windows box (we just put in a brand new hard drive, too, defragged it and everything).There seems to be no hardware problems. I've also checked the SQL in the SP's that CF calls, and there seems to be nothing wrong there; when I run them in the command line they only take a few seconds to run.However, it takes several minutes for the login to process on the web. I'm at a loss.Anyone got any ideas as to what I could check next? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [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: Installing Flex on CFMX 6.1
From: Steven Erat It sounds like you are making things unnecessarily difficult by trying to merge CFMX server configuration with Flex in order to gain access to Web Service and Flash Remoting integration. You're probably right. At this stage, all I want to do is understand Flex and how it works with Flash Remoting and Coldufusion. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Form button
if C1 is an image button then when it is clicked form.C1.X and form.C1.Y will exist and have as values the x and y coords within the image where the mouse was clicked.form.C1 however will not exist. Note that C1.X and C1.Y are two simple variables that contain dots in their name not a struct with 2 keys. BTY you should use StructKeyExists(form, C1.X) instead of isDefined. Robert Orlini wrote: I have an image as a form button as: input type=image src="" name=C1 value=update In my CF code pressing this button should execute an update, however the following code generates an error: CFIF IsDefined(form.C1.X) and form.C1 EQ update Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined(form.C1.X) and form.C1 EQ update Error near line 1, column 29. Error resolving parameter FORM.C1 The specified form field cannot be found. Am I missing something here? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Navigating pages and displaying an image equaling the page
cfif ListFindNoCase(Company,location,execBios,url.page) -Original Message- From: Shawn Contreras [mailto:[EMAIL PROTECTED] Sent: dinsdag 4 mei 2004 5:47 To: CF-Talk Subject: Re: Navigating pages and displaying an image equaling the page OK, here's what I got and it appears to work great. cfif url.page EQ Company a href="" trueimg src="" name=Company width=90 height=24 border=0/a cfelse a href="" > ',1), popUp('HM_Menu1',event) trueimg src="" name=Company width=90 height=24 border=0/a /cfif Thank you... but here's the second outstanding challenge: in the first line (the CFIF statement) I need it to really equal various possible pages.For example I tried this: cfif url.page EQ Company OR Locations OR ExecBios This way the CompanyTabR.gif image would also stay red but I get an error message that says ...you can't use Boolean logic in the CFIF statement. So how would I get this to work? Thank you in advance. Sifu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
A new custom tag to create dynamic frames and text boxes
See this new amazing custom tab developped by CS Interntique. CF_easyFrame is a set of three custom tags which can be used to create effective frames around titles, news and message text in Web pages. Instead of working with complex images and programs that produce static frames in tables that must be downloaded on the server, this tag will create all the necessary parts directly on the server, starting from only one basic image. This versatile new tag makes the generation of dynamic frames and boxes in Web pages a breeze. See http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Problem w/IIS SSL installing new SSL cert
Sorry, I was wrong about IIS4--it's IIS 5, on WIN2K. [Hey, even more OT, you probably don't remember the class, but I was in one of the classes you taught at Boeing, in Downey CA, many years ago...] Jeff Polaski RGS Webmaster www.rgs.uci.edu -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 8:31 AM To: CF-Talk Subject: RE: OT - Problem w/IIS SSL installing new SSL cert Any way, the problem is that I need to install a new SSL certificate for IIS4, but I can't because the MMC won't let me install a certificate into a site that already has a running SSL certificate. I remember that I needed to create a duplicate site, disable it, make an SSL cert for that one, delete the site and install the cert into the real site. Can anyone point me to the correct directions? I've been looking for a while, but I can't get anything useful. I think the directions were on microsoft.com, or an MS related site, but I just can't find it. Can anyone help? I don't think you have to go to all that trouble. Within the Key Manager tool, you should be able to generate a new key request, and install a certificate, without assigning it to the site until you're ready. I'm still running an IIS 4 server with SSL, and I didn't have to do anything special to replace certificates. 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]