Re: Weird error
Also, for future suggestion, choose a more specific subject line than "weird error". A subject line like this is going to make it be the last thing I check because I don't know if it is anything I have any knowledge of. If you are least mention that it is a problem with cfqueryparam and database errors, you'll get people with database experience looking at the thread. Just an fyi. Glad you got it solved. Judah On Tue, Jul 14, 2009 at 12:52 PM, Rick Sanders wrote: > > I found the error. > > I changed my to a . I'm passing the coursed from the query in > the url: courseid=#courses.courseid#. When it was in the tag I had to > wrap around the variable. When I changed it to a I > forgot to remove the tags because it didn't need them. > > Thanks for all your help! > > -Original Message- > From: Rick Sanders [mailto:c...@webenergy.ca] > Sent: July-14-09 4:38 PM > To: cf-talk > Subject: RE: Weird error > > > Tried and still getting the same error. [Macromedia][SQLServer JDBC > Driver][SQLServer]Incorrect syntax near '<'. > > > UPDATE dbo.Courses SET CourseName= CFSQLType = "CF_SQL_varchar">,CourseDesc= "#form.coursedesc1#" CFSQLType = "CF_SQL_varchar">,Cost= = "#form.cost#" CFSQLType = "CF_SQL_money">,MaxStudents= = "#form.maxstudents#" CFSQLType = "CF_SQL_integer"> WHERE > (CourseID=#url.courseid#) > > > I'm stumped! > > -Original Message- > From: Matthew [mailto:a.matthe...@yahoo.com] > Sent: July-14-09 4:13 PM > To: cf-talk > Subject: Re: Weird error > > > Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam > all the variables. > > Matt. > > On 14 Jul 2009, at 20:06, "Rick Sanders" wrote: > > > When I do that I get this error: > [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. > > The only html tags in the content are and . > > -Original Message- > From: Jason Fisher [mailto:ja...@wanax.com] > Sent: July-14-09 4:00 PM > To: cf-talk > Subject: re: Weird error > > > Lose the single quotes around the CFQUERYPARAM ... it already handles that > for you: > > UPDATE dbo.Courses > SET CourseName = '#Trim(form.coursename)#', > CourseDesc = CFSQLType="CF_SQL_longvarchar" />, > Cost = #form.cost#, > MaxStudents = #form.maxstudents# > WHERE CourseID = #url.courseid# > > (and go ahead and use CFQUERYPARAM on all the variables :) > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird error
I found the error. I changed my to a . I'm passing the coursed from the query in the url: courseid=#courses.courseid#. When it was in the tag I had to wrap around the variable. When I changed it to a I forgot to remove the tags because it didn't need them. Thanks for all your help! -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: July-14-09 4:38 PM To: cf-talk Subject: RE: Weird error Tried and still getting the same error. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. UPDATE dbo.Courses SET CourseName=,CourseDesc=,Cost=,MaxStudents= WHERE (CourseID=#url.courseid#) I'm stumped! -Original Message- From: Matthew [mailto:a.matthe...@yahoo.com] Sent: July-14-09 4:13 PM To: cf-talk Subject: Re: Weird error Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam all the variables. Matt. On 14 Jul 2009, at 20:06, "Rick Sanders" wrote: When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. The only html tags in the content are and . -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = , Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird error
Rick Sanders wrote: > > Tried and still getting the same error. [Macromedia][SQLServer JDBC > Driver][SQLServer]Incorrect syntax near '<'. > > > UPDATE dbo.Courses SET CourseName= CFSQLType = "CF_SQL_varchar">,CourseDesc= "#form.coursedesc1#" CFSQLType = "CF_SQL_varchar">,Cost= = "#form.cost#" CFSQLType = "CF_SQL_money">,MaxStudents= = "#form.maxstudents#" CFSQLType = "CF_SQL_integer"> WHERE > (CourseID=#url.courseid#) > > > I'm stumped! I would take out all the cfqueryparam's since it is obviously choking on one of them. Then add them back one by one until you get the error. All your variables are scoped to form except for url.courseid. Is that true? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird error
Tried and still getting the same error. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. UPDATE dbo.Courses SET CourseName=,CourseDesc=,Cost=,MaxStudents= WHERE (CourseID=#url.courseid#) I'm stumped! -Original Message- From: Matthew [mailto:a.matthe...@yahoo.com] Sent: July-14-09 4:13 PM To: cf-talk Subject: Re: Weird error Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam all the variables. Matt. On 14 Jul 2009, at 20:06, "Rick Sanders" wrote: When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. The only html tags in the content are and . -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = , Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird error
Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam all the variables. Matt. On 14 Jul 2009, at 20:06, "Rick Sanders" wrote: When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. The only html tags in the content are and . -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = , Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird error
When I do that I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '<'. The only html tags in the content are and . -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: July-14-09 4:00 PM To: cf-talk Subject: re: Weird error Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = , Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Weird error
Remove single quotation marks from around the cfqueryparam tag Matt On 14 Jul 2009, at 19:55, "Rick Sanders" wrote: OK, I'm updating a record in my MSSQL database table. The column that's causing the error is an ntext column. The error I'm getting is: [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). Here's my SQL query: UPDATE dbo.Courses SET CourseName='#Trim(form.coursename)#',CourseDesc='',Cost=#form.cost#,MaxStudents=#form.maxstudents# WHERE (CourseID=#url.courseid#) I'm sending the data from FCK editor. I've done this before and never had a problem. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Weird error
Lose the single quotes around the CFQUERYPARAM ... it already handles that for you: UPDATE dbo.Courses SET CourseName = '#Trim(form.coursename)#', CourseDesc = , Cost = #form.cost#, MaxStudents = #form.maxstudents# WHERE CourseID = #url.courseid# (and go ahead and use CFQUERYPARAM on all the variables :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Weird error
OK, I'm updating a record in my MSSQL database table. The column that's causing the error is an ntext column. The error I'm getting is: [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). Here's my SQL query: UPDATE dbo.Courses SET CourseName='#Trim(form.coursename)#',CourseDesc='',Cost=#form.cost#,MaxStudents=#form.maxstudents# WHERE (CourseID=#url.courseid#) I'm sending the data from FCK editor. I've done this before and never had a problem. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Error when viewing datasources in CFAdmin 7.02
Sorry I forgot to put my name. My Name is Randy. Thank you for your help. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Error when viewing datasources in CFAdmin 7.02
Here is the errors that show up when I go to the datasource page in cf administrator: This just started happening recently. Any ideas what is happening? Aug 22, 2006 2:52 PM Error 0 Exception thrown by error-handling template: Aug 22, 20062:52 PM Error 0 Element FUNCNAME is undefined in ERROR. The specific sequence of files included or processed is: C:\CFusionMX7\wwwroot\WEB-INF\exception\coldfusion\runtime\IllegalStructAccessException.cfm, line: 5 Aug 22, 20062:52 PM Error 0 cfadmin Cannot find key name in struct.The specified key, name, does not exist in the structure. The specific sequence of files included or processed is: C:\inetpub\wwwroot\CFIDE\administrator\datasources\index.cfm, line: 363 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird Error
I believe I just saw a hotfix that deals with this very issue Scott Stewart ColdFusion Developer/Administrator GlobalNet Services, Inc. www.gnsi.com 301-770-9610 x358 (Voice) 301-770-9611 (Fax) The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or any employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 16, 2006 11:19 AM To: CF-Talk Subject: Re: Weird Error I usually get this when a non-date is passed to a function needing a date. On 5/16/06, fsu__grad <[EMAIL PROTECTED]> wrote: > > Any one had a Null Null error? > > I have had this in other pages once and I renamed them and uploaded a > new copy and it worked. > Server is windows 2000, iis, and cfmx not 7. > This page works for me but other users seem to have a error on it with > the same browser I have. The browser probably isnt the problem since > its a server side error. The line 7 is just a cfmail tag of a form. > > All the cfmail attributes are hard coded, its just sending a email from > a contact form. > > Browser: > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR > 1.1.4322) > > Diagnostic : > null null The error occurred on line 7. > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240651 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 Error
I usually get this when a non-date is passed to a function needing a date. On 5/16/06, fsu__grad <[EMAIL PROTECTED]> wrote: > > Any one had a Null Null error? > > I have had this in other pages once and I renamed them and uploaded a > new copy and it worked. > Server is windows 2000, iis, and cfmx not 7. > This page works for me but other users seem to have a error on it with > the same browser I have. The browser probably isnt the problem since > its a server side error. The line 7 is just a cfmail tag of a form. > > All the cfmail attributes are hard coded, its just sending a email from > a contact form. > > Browser: > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR > 1.1.4322) > > Diagnostic : > null null The error occurred on line 7. > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240650 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
Weird Error
Any one had a Null Null error? I have had this in other pages once and I renamed them and uploaded a new copy and it worked. Server is windows 2000, iis, and cfmx not 7. This page works for me but other users seem to have a error on it with the same browser I have. The browser probably isnt the problem since its a server side error. The line 7 is just a cfmail tag of a form. All the cfmail attributes are hard coded, its just sending a email from a contact form. Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Diagnostic : null null The error occurred on line 7. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240648 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: Weird error
> I will also check for the type of browser. > > By the way, it must be some pretty cheap browsr to do so ;-/ I'll bet it's Internet Exploder. ;) [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235681 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 error
>>It's usually hard to diagnose this error because the error logs are usually viewed as HTML and any escaped characters (like the & in the above, misinterpreted URL) are displayed unescaped. Ah ah, that at least a good lead indeed. The last error of that type has gone out of the database, but I'll check this avenue the next tine I have one. I'll also change my error manager to display info under HTMLEditFormat() I will also check for the type of browser. By the way, it must be some pretty cheap browsr to do so ;-/ May be some poorly programed robot? Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235679 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: Weird error
Late to the party so I don't know if this was already resolved... I've seen this error before as well and I've been able to figure out the problem but haven't had time to figure out which browser(s) is/are the culprit(s). Apparently, some clients tend to URLEncode a URL (or the query string portion of the URL) before trying to access the URL. So index.cfm?p=partenaires&stat=P becomes index.cfm?p=partenaires&stat=P CF then see URL.p as "partenaires&stat=P" as does not recognize a URL.stat. It's usually hard to diagnose this error because the error logs are usually viewed as HTML and any escaped characters (like the & in the above, misinterpreted URL) are displayed unescaped. I don't know if this is the problem, but HTH. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 15, 2006 7:47 PM > To: CF-Talk > Subject: Weird error > > > Hi, > > I have this weird error in a template (CF 5). I would say it works 99.9% > of the time, but once in a while I get this: > > >>Error resolving parameter STAT > ColdFusion was unable to determine the value of the parameter. > blah blah blah... > template = F:\\INDEX.CFM > queryString = p=partenaires&stat=P > > How may stat be not defined if it is passed in the queryString? > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235674 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: Weird error
>>But again, if you are doing a cfcatch (I don't see that here), Actually, it is not a catch, I use CFERROR, but the result is the same. The queryString is found correct in error.queryString I've made an error processor which catches and logs all errors, it helps to debug an application. >>Unless 'stat' is some kind of reserved word in CF5, Again, this would cause an error every time. It cannot be reserved once a week ;-) >>Maybe it's a specific browser/os that is causing the error, because it doesn't pass URL parameters correctly. Then CF wouldn't get it. If CF gives me the correct value in error.queryString, then it should have no problem to find the parameters passed in the string. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235579 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 error
It could be like someone said. You are only calling stat when your id is blank. But again, if you are doing a cfcatch (I don't see that here), and dumping the URL string, you should not get this error. Unless 'stat' is some kind of reserved word in CF5, or something like that. You might also look at the useragent string for these errors. Maybe it's a specific browser/os that is causing the error, because it doesn't pass URL parameters correctly. > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 12:58 PM > > Why not : > The page is called with ... index.cfm?p=partenaires&stat=P > > > > SELECT orgs.*, > logo.fileName AS orgLogo, > users.* > FROM ((orgs LEFT JOIN images AS logo ON orgs.logo = logo.imageID) > LEFT JOIN users ON orgs.orgId = users.organization) > LEFT JOIN images AS photo ON users.photo = photo.imageID > > > > WHERE orgs.orgStatus = VALUE="#stat#"> > AND NOT ismember > > WHERE orgs.orgId = VALUE="#orgId#"> > > ORDER BY orgs.orgName, users.surName > > > Again, the error message : > > Error resolving parameter STAT > And the queryString is p=partenaires&stat=P [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235569 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 error
Why not : The page is called with ... index.cfm?p=partenaires&stat=P SELECT orgs.*, logo.fileName AS orgLogo, users.* FROM ((orgs LEFT JOIN images AS logo ON orgs.logo = logo.imageID) LEFT JOIN users ON orgs.orgId = users.organization) LEFT JOIN images AS photo ON users.photo = photo.imageID WHERE orgs.orgStatus = AND NOT ismember WHERE orgs.orgId = ORDER BY orgs.orgName, users.surName Again, the error message : Error resolving parameter STAT And the queryString is p=partenaires&stat=P -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235568 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: Weird error
Then use the FORM scope for all references to stat in the page crawling back under my rock now Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235567 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: Weird error
>>Why don't you reference the scope Claude? As I said, I want the template to be callable both with POST or GET, But I'll try to modify the code to find the variable in any scope myself, and see if it makes any difference. If it does, then there is a bug in the scope searching process in CF, if not then there is a bug anyway ;-) I'll tell you after the next 1000 hits on this page. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235565 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 error
>>Not necessarily, say stat was a checkbox or some such that was added to the form dynamically by way of selecting something in a dropdown, but it didn't always exist in the form. Then when the form submitted it wouldn't exist This discussion is going nowere : The field is NOT in a form, it is passed in the url, and I have a CFCATCH that get the querystring, and the query string is queryString = p=partenaires&stat=P In which stat is clearly there and defined. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235564 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 error
That's what I'm saying about adding the "url." in front of it. Why depend on "should not..." Why not be sure? Why not tell the app exactly where stat will be and where to look for it? I just don't understand why you'd elect to let CF go searching through the scopes looking for it, when you could head it off at the pass. --Ferg Claude Schneegans wrote: > >>The above line would fail if the only foo was URL.foo passed in via > the URL. > > Of course it would, but it would 100% of the time, and > > should not fail ever. This is my issue. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235561 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: Weird error
Not necessarily, say stat was a checkbox or some such that was added to the form dynamically by way of selecting something in a dropdown, but it didn't always exist in the form. Then when the form submitted it wouldn't exist in the form scope at all for those situations - it would for other situations when it had been added... You know what I'm trying to say? --Ferg Claude Schneegans wrote: > >>just saying it could be a scoping issue for whatever reason. > > If it was that, I would have an erreor every time the template is > called, not one every 1000 times ;-/ > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235560 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: Weird error
why not post the code that is failingperhaps another few hundred sets of eyes will spot something? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235559 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 error
>>The above line would fail if the only foo was URL.foo passed in via the URL. Of course it would, but it would 100% of the time, and should not fail ever. This is my issue. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235557 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: Weird error
> If it was that, I would have an erreor every time the template is > called, not one every 1000 times ;-/ Yes most likely that's true, but what if the offending code is in a CFIF block that only firesd every 1000 requests I said it was an outside shot ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235558 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: Weird error
OK, I'm with you on that one. I wasn't following you, as I was just thinking the whole time that he was referencing it without scope, which I believe is the case. Anyhow, I now see where you were trying to go. And this bring us to the real heart of the matter. Why don't you reference the scope Claude? If it's in the URL, call url.stat. I know it should pick it up without the scope, but that just seems a little on the sloppy side to me. Stick a "url." in there and see if the problem goes away for ever more. --Ferg Bryan Stevenson wrote: > > Not what I'm saying Ferg > > URL param foo=bar > > code in page > > > > The above line would fail if the only foo was URL.foo passed in via the URL. > Now you'd expect to see something about scope in the error message, but it's > CF > 5 (been awhile)...so I mentioned it (man it's hard to try and help > soemtimes...hehe) > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235556 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 error
>>So, unless it was different in CF5 No, it is not different, I think the URL is the 6th scope searched, then FORM, then ATTRIBUTES, so it is correct. What is not correct is that a variable passed in the url is not found at all,... once every 1000 times... -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:23 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: Weird error
>>just saying it could be a scoping issue for whatever reason. If it was that, I would have an erreor every time the template is called, not one every 1000 times ;-/ -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235554 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 error
>I don't know about that. Granted, I'm not on CF5, but when I run the > code below, I get 1 -- not an error. > > > url.a = 1; > form.a = 2; > attributes.a = 3; > WriteOutput(a); > > > So, unless it was different in CF5 (and it might have been-I don't > remember), I don't think having it defined in multiple scopes would > cause an error. > > --Ferg Not what I'm saying Ferg URL param foo=bar code in page The above line would fail if the only foo was URL.foo passed in via the URL. Now you'd expect to see something about scope in the error message, but it's CF 5 (been awhile)...so I mentioned it (man it's hard to try and help soemtimes...hehe) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235553 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: Weird error
> Hmm, yes I could look into the url and form scopes myself, just to make > sure, > but it would still be an oddity that the variable is set in the form > scope when > the template was called by GET. > It also happens from time to time with another template and another > variable. and I'm just saying there may be some bad code with the var in another scopenot saying it would be FORM scope due to a POSTjust saying it could be a scoping issue for whatever reason. Good Luck ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235552 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 error
I don't know about that. Granted, I'm not on CF5, but when I run the code below, I get 1 -- not an error. url.a = 1; form.a = 2; attributes.a = 3; WriteOutput(a); So, unless it was different in CF5 (and it might have been-I don't remember), I don't think having it defined in multiple scopes would cause an error. --Ferg Bryan Stevenson wrote: >> If stat was defined in another scope, then it should not be declared >> "undefined" anyway. >> When the scope is not specified, CF is supposed to look in all scopes, >> including URL, >> so stat should be defined here (&stat=P) >> > > I know Claude, but what if the param came in via the URL, but was scoped in > the > FORM scope in the receiving template?? You'd get that error (possibly > mentioning not found in that scope). > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235551 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: Weird error
>>but what if the param came in via the URL, but was scoped in the FORM scope in the receiving template?? Hmm, yes I could look into the url and form scopes myself, just to make sure, but it would still be an oddity that the variable is set in the form scope when the template was called by GET. It also happens from time to time with another template and another variable. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235550 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 error
> If stat was defined in another scope, then it should not be declared > "undefined" anyway. > When the scope is not specified, CF is supposed to look in all scopes, > including URL, > so stat should be defined here (&stat=P) I know Claude, but what if the param came in via the URL, but was scoped in the FORM scope in the receiving template?? You'd get that error (possibly mentioning not found in that scope). Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235546 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: Weird error
> >>the end result is that when the user clicks the link in > >>their > email client the server receives a url like this: > http://./index.cfm?p=partenaires&st > I see what you mean, but I have a module that traps all > errors, and the > query string > is registered in the error table. > It shows > queryString = p=partenaires&stat=P > and it is complete. stat=P and is defined, So how come CF > does not find it ? Hard to say... could be due to a custom tag if it's not scoped. Could be something removing it from the url scope. -- put a try-catch block around where the variable error is produced and have it dump the url scope to a file or database table so you can see what's actually in the url scope the next time it happens. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235533 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: Weird error
>>the end result is that when the user clicks the link in their email client the server receives a url like this: http://./index.cfm?p=partenaires&st I see what you mean, but I have a module that traps all errors, and the query string is registered in the error table. It shows queryString = p=partenaires&stat=P and it is complete. stat=P and is defined, So how come CF does not find it ? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235532 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: Weird error
> Hi, > I have this weird error in a template (CF 5). I would say > it works 99.9% > of the time, but once in a while I get this: > >>Error resolving parameter STAT > ColdFusion was unable to determine the value of the > parameter. > blah blah blah... > template = F:\\INDEX.CFM > queryString = p=partenaires&stat=P > How may stat be not defined if it is passed in the > queryString? StructDelete(url,"stat") That's one way, although I doubt that's what's happening Far more likely I think is that a user may be following a link in their email and the email client in order to be compliant with the standard cuts the url in the middle and wraps it down to the next line, the end result is that when the user clicks the link in their email client the server receives a url like this: http://./index.cfm?p=partenaires&st I receive emails like this all the time and it really makes me wish the folks responsible for the email standard would revise it. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235528 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: Weird error
>>could the "stat" var that it is having an issue with be scoped in another scope from URL? If stat was defined in another scope, then it should not be declared "undefined" anyway. When the scope is not specified, CF is supposed to look in all scopes, including URL, so stat should be defined here (&stat=P) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235512 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 error
I have also seen this if the page is being fetched at the very moment the cf server is going down. Check the cf cerver logs to see if a restart was happening at that time. On 3/15/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > Hi, > > I have this weird error in a template (CF 5). I would say it works 99.9% > of the time, but once in a while I get this: > > >>Error resolving parameter STAT > ColdFusion was unable to determine the value of the parameter. > blah blah blah... > template = F:\\INDEX.CFM > queryString = p=partenaires&stat=P > > How may stat be not defined if it is passed in the queryString? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235509 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: Weird error
could the "stat" var that it is having an issue with be scoped in another scope from URL? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235506 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
Weird error
Hi, I have this weird error in a template (CF 5). I would say it works 99.9% of the time, but once in a while I get this: >>Error resolving parameter STAT ColdFusion was unable to determine the value of the parameter. blah blah blah... template = F:\\INDEX.CFM queryString = p=partenaires&stat=P How may stat be not defined if it is passed in the queryString? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235505 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 error message
Hi Brad, thanks for the reply. I think the problem might be with the imap cfc I'm using. The sub q is based on a imap query on the mail folder and I think it's got confused over the message uid value. Seems like a date is being returned into the uid field. Have emailed Paul Vernon who wrote the cfc. Jenny -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 19:08 To: CF-Talk Subject: RE: Weird error message Try wrapping val(last_mail)+1 in an evaluate() #evaluate(val(last_mail)+1)# -Original Message- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 12:49 PM To: CF-Talk Subject: Weird error message Any ideas anyone please? Strange error running: select * from mail_get where mail_get.uid < #last_mail+1# Returning with: "0100(CET)" must be interprettable as a valid number in the current locale. The error occurred in C:\sites\ukasfp\members\maillist\import.cfm: line 168 166 : 167 : select * from mail_get 168 : where mail_get.uid < #val(last_mail)+1# 169 : 170 : ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230359 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 error message
Try wrapping val(last_mail)+1 in an evaluate() #evaluate(val(last_mail)+1)# -Original Message- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 12:49 PM To: CF-Talk Subject: Weird error message Any ideas anyone please? Strange error running: select * from mail_get where mail_get.uid < #last_mail+1# Returning with: "0100(CET)" must be interprettable as a valid number in the current locale. The error occurred in C:\sites\ukasfp\members\maillist\import.cfm: line 168 166 : 167 : select * from mail_get 168 : where mail_get.uid < #val(last_mail)+1# 169 : 170 : ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230354 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
Weird error message
Any ideas anyone please? Strange error running: select * from mail_get where mail_get.uid < #last_mail+1# Returning with: "0100(CET)" must be interprettable as a valid number in the current locale. The error occurred in C:\sites\ukasfp\members\maillist\import.cfm: line 168 166 : 167 : select * from mail_get 168 : where mail_get.uid < #val(last_mail)+1# 169 : 170 : ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230346 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: Consuming .NET Web service - weird error and Windows authentication
I think there are optional username/password fields in the CFHTTP tag. I've used those before with Windows authentication. -Chase Chase Seibert | Network and Systems Engineer | Bullhorn Inc. | 617.464.2440 x119 | www.bullhorn.com -Original Message- From:Shawna Hampton [EMAIL PROTECTED] To: "CF-Talk" ; Sent: Jun 16, 2005 02:14:54 PM Subject: Consuming .NET Web service - weird error and Windows authentication Hi all, I'm trying to consume a remote .NET Web service. I've tried using and , with bad results for both. Using : customerid="blahblah" username="blahblah" password="blahblah" domain="blahblah" returnvariable="Invoices"> gives me: Could not generate stub objects for web service invocation. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: Expected "" to terminate element starting on line 3. Using : gives me an IIS authentication error ("You are not authorized to view this page ... etc. HTTP Error 401.2). Apparently, the .NET developer is using some kind of windows authentication to allow remote access to this Web service. When I talked to him about it, he told me to "figure out how to consume Web servies using windows authentication" hence the username/password/domain crap in the cfhttp and cfinvoke. My question: What does the error I'm getting with the cfinvoke mean, and how else should I be invoking a .NET Web service with windows authentication, because obviously the way I'm using doesn't work? Many, many thanks! Shawna ~| 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:209734 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
Consuming .NET Web service - weird error and Windows authentication
Hi all, I'm trying to consume a remote .NET Web service. I've tried using and , with bad results for both. Using : http://companyname/webservice/service.asmx?wsdl"; method="GetAllInvoices" customerid="blahblah" username="blahblah" password="blahblah" domain="blahblah" returnvariable="Invoices"> gives me: Could not generate stub objects for web service invocation. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: Expected "" to terminate element starting on line 3. Using : http://companyname/webservice/service.asmx?wsdl"; resolveurl="true"> gives me an IIS authentication error ("You are not authorized to view this page ... etc. HTTP Error 401.2). Apparently, the .NET developer is using some kind of windows authentication to allow remote access to this Web service. When I talked to him about it, he told me to "figure out how to consume Web servies using windows authentication" hence the username/password/domain crap in the cfhttp and cfinvoke. My question: What does the error I'm getting with the cfinvoke mean, and how else should I be invoking a .NET Web service with windows authentication, because obviously the way I'm using doesn't work? Many, many thanks! Shawna ~| 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:209714 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
Weird Error Message.
I left my Dev box running overning. When i came back into work I saw this error at the command prompt. 27/05 07:00:44 error Event Handler Exception. [1]java.lang.OutOfMemoryError [0]coldfusion.runtime.EventHandlerException: Event Handler Exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:118) Now. No one was accessing the box at 7am. I only arrived at 8:30AM. By the looks of things it was the 'Client Storage Purge' But what could have caused it to error. It was running fine every 1hour and 7minutes (as per the admin settings) since i left work yesterday. Any ideas. Thanks. Ricardo ~| 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:207827 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 error causing cfadmin to not work
> -Original Message- > From: Peter Farrell [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 06, 2005 12:13 PM > To: CF-Talk > Subject: Re: WEIRD error causing cfadmin to not work > > I don't really want to get into a which is better discussion, but I wanted > to share my experience with SP2. I've never had a problem with it. > Mostly because I just bought a new computer - and didn't have to deal with > updating it before all my crap got on it. While I usually try to ignore conversation where the dollar symbol is used as a letter I've had no problems with SP2 personally either as an upgrade or a fresh install. As far as CF is concerned the main point of contention that often creeps up is that SP2 includes (and enables) Windows Firewall by default. See if it's enabled and if it is, disable and see if that solves the problem. (In my case the firewall was preventing port 1433 (SQL Server) access.) If not then I'm not sure what's happening. All I can say is that some of us are running similar configs just fine with SP2. So while it may be contributing to the problem I suspect it's a more complex interaction. Jim Davis ~| 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:193240 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: WEIRD error causing cfadmin to not work
I don't really want to get into a which is better discussion, but I wanted to share my experience with SP2. I've never had a problem with it. Mostly because I just bought a new computer - and didn't have to deal with updating it before all my crap got on it. I can understand why M$ wants to people to update their machine - any support tech knows that the more versions of a program out there - the harder it's to support it. Every piece of software has a life cycle and there are now "three" versions of XP (original release, SP1 and SP2). Until recently, I had been using Win98SE since 1998 and they just stoppped supporting it. I'm not defending M$ at all - as I prefer a lot of non-M$ software (Corel WordPerfect, Inspiration over Visio, etc.). I just wanted to say - an updater just possible cannot adapt to *all* possible situations and there is bound to be some problems. Regarding the IE being fixed - it does. But, they aren't loosing enough money to Firefox/Mozilla yet to justify a new "better" (bloatted) version. I think they have their hands full with the long over due new version of Windows! ~| 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:193235 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 error causing cfadmin to not work
i didnt say it was, i just agreed :) even if i wanted to put sp2 on mine (which wouldnt happen) i cant cause i guess they banned me from updating, which is fine with me, hardly use it anymore, only to run dw and flash. and no the others arent perfect but much better! well i havent seen anything about sp2 that explains why it messes up cfm server but i would be curious too know and it sounds like u have already checked into why so could u please share with us? cause that might help will get his fixed did u see the deal on msn going to cssp pages but they still wont fix their browser? man, they are 1 messed up company From: "Michael T. Tangorre" <[EMAIL PROTECTED]> Sent: Sunday, February 06, 2005 1:48 AM To: CF-Talk Subject: RE: WEIRD error causing cfadmin to not work > From: dave [mailto:[EMAIL PROTECTED] > i doubt it Michael > its easy to diss them because they screw everything up > so its the operators fault when they dl sp2 and it shuts off > cfmx server? > yeah thats the operators fault > its also the operators fault cause of all the holes and > breaches, oh yeah and its the operator fault that the box > model is messed up. > well in my case it is the operators fault cause i bought that crap!! > but i like u michael so we arent gunna fight bout it, i > just shouldnta said anything in the first place They aren't perfect , no. Who is? Is Unix/Linux perfect?.. no. The point is, before you go dissing certain things gather some information... see why things might break with SP2 and try to understand why. It's obvious you just got pissed off when it didn't work, blamed it on M$ without even knowing why. If you don't like M$ products don't use them, including IE with their Fd up rendition of the box model. ~| 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:193220 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 error causing cfadmin to not work
> From: dave [mailto:[EMAIL PROTECTED] > i doubt it Michael > its easy to diss them because they screw everything up > so its the operators fault when they dl sp2 and it shuts off > cfmx server? > yeah thats the operators fault > its also the operators fault cause of all the holes and > breaches, oh yeah and its the operator fault that the box > model is messed up. > well in my case it is the operators fault cause i bought that crap!! > but i like u michael so we arent gunna fight bout it, i > just shouldnta said anything in the first place They aren't perfect , no. Who is? Is Unix/Linux perfect?.. no. The point is, before you go dissing certain things gather some information... see why things might break with SP2 and try to understand why. It's obvious you just got pissed off when it didn't work, blamed it on M$ without even knowing why. If you don't like M$ products don't use them, including IE with their Fd up rendition of the box model. ~| 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:193219 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 error causing cfadmin to not work
i doubt it Michael its easy to diss them because they screw everything up so its the operators fault when they dl sp2 and it shuts off cfmx server? yeah thats the operators fault its also the operators fault cause of all the holes and breaches, oh yeah and its the operator fault that the box model is messed up. well in my case it is the operators fault cause i bought that crap!! but i like u michael so we arent gunna fight bout it, i just shouldnta said anything in the first place From: "Michael T. Tangorre" <[EMAIL PROTECTED]> Sent: Sunday, February 06, 2005 1:23 AM To: CF-Talk Subject: RE: WEIRD error causing cfadmin to not work > From: dave [mailto:[EMAIL PROTECTED] > lol totally! i swear everything is ms's fault!!! > > i seriously dont know why ppl put sp2 on, doesnt make their > puters anymore secure, sure it may help a few of the old > probs but there are so many new ones with sp2 why bother? i > thinks its pretty evident u shouldnt trust a damn thing they > do and yeah the sp2 caused problems with cfmx installs (im > sure that was a total accident of course, how convient) Everyone is always so quick to diss M$. Sometimes the problem exsists between the chair and keyboard! ~| 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:193218 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 error causing cfadmin to not work
> From: dave [mailto:[EMAIL PROTECTED] > lol totally! i swear everything is ms's fault!!! > > i seriously dont know why ppl put sp2 on, doesnt make their > puters anymore secure, sure it may help a few of the old > probs but there are so many new ones with sp2 why bother? i > thinks its pretty evident u shouldnt trust a damn thing they > do and yeah the sp2 caused problems with cfmx installs (im > sure that was a total accident of course, how convient) Everyone is always so quick to diss M$. Sometimes the problem exsists between the chair and keyboard! ~| 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:193217 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 error causing cfadmin to not work
lol totally! i swear everything is ms's fault!!! i seriously dont know why ppl put sp2 on, doesnt make their puters anymore secure, sure it may help a few of the old probs but there are so many new ones with sp2 why bother? i thinks its pretty evident u shouldnt trust a damn thing they do and yeah the sp2 caused problems with cfmx installs (im sure that was a total accident of course, how convient) might not be but sure feels good to blame them ;) haha From: Will Tomlinson <[EMAIL PROTECTED]> Sent: Saturday, February 05, 2005 10:50 PM To: CF-Talk Subject: Re: WEIRD error causing cfadmin to not work Yep, everything cleared out. Still erroring. El Bizarro! Gotta be this damn XP/SP2! ~| 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:193212 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: WEIRD error causing cfadmin to not work
Yep, everything cleared out. Still erroring. El Bizarro! Gotta be this damn XP/SP2! ~| 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:193211 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: WEIRD error causing cfadmin to not work
humm that is weird, have u cleaned your cache? check the db connection is dw or is that just a bs thingy, i cant recall From: Will Tomlinson <[EMAIL PROTECTED]> Sent: Saturday, February 05, 2005 10:10 PM To: CF-Talk Subject: Re: WEIRD error causing cfadmin to not work No CF updater currently. It's weird man, it was all working and I added a DSN for the clothing site a month or so ago, but haven't been in there since. Now it's broken again! coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V Only on DSN admin page, and settings summary page. hmm ~| 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:193210 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: WEIRD error causing cfadmin to not work
I already tried restarting cf, rebooting, everything. No go. ~| 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:193209 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: WEIRD error causing cfadmin to not work
No CF updater currently. It's weird man, it was all working and I added a DSN for the clothing site a month or so ago, but haven't been in there since. Now it's broken again! coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V Only on DSN admin page, and settings summary page. hmm ~| 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:193208 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: WEIRD error causing cfadmin to not work
which updater? cfm or sp2? From: Will Tomlinson <[EMAIL PROTECTED]> Sent: Saturday, February 05, 2005 9:42 PM To: CF-Talk Subject: WEIRD error causing cfadmin to not work A while back I got my new computer, Godzilla, XP, SP2, installed cf and it was fine until I installed the updater. After that I couldn't login to cfadmin, got an error. I uninstalled CF (that was fun!), reinstalled with no updater and it all worked fine again. I just now logged in to add a DSN for the first time in a while, and it's erroring again, but on two pages only. DSN admin and Settings summary. Here's the error. coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V Any ideas guys? Thanks, Will ~| 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:193207 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
WEIRD error causing cfadmin to not work
A while back I got my new computer, Godzilla, XP, SP2, installed cf and it was fine until I installed the updater. After that I couldn't login to cfadmin, got an error. I uninstalled CF (that was fun!), reinstalled with no updater and it all worked fine again. I just now logged in to add a DSN for the first time in a while, and it's erroring again, but on two pages only. DSN admin and Settings summary. Here's the error. coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V Any ideas guys? Thanks, Will ~| 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:193206 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: CFUPDATE throwing up a weird error
CFUPDATE and CFINSERT have historically been less than stellar performers If you pass the fields in the wrong order it will crap out (and the error is vague). The vagueness is my big beef...it's supposed to be more of a set of tags for beginnersbut the error messages are worse than the usua; SQL errors...so it makes being a beginner frustrating. There are other issues as well...so I tell my students to avoid at all costs ;-) INSERT INTO MyTable ( Name ) VALUES ( ) There ya go...SQL 101...simple insert with cfqueryparam ;-) If you want o add multiple fields just put a comma after each field name and field value (except the last pair of course). HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| 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:192687 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: CFUPDATE throwing up a weird error
> "Name" may be a reserved word depending on your DB Thanks very much, Bryan, but that doesn't seem to be the problem. I renamed the field to "banana", and it still doesn't work. I'm kind of stumped. Anyone else got any ideas? I will take your other advice about learning more SQL, but just so I know, what's wrong with CFUPDATE & CFINSERT? Thanks! CK. ~| 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:192684 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: CFUPDATE throwing up a weird error
"Name" may be a reserved word depending on your DB ...and just don't use CFUPDATE/CFINSERT...learn the SQL...it will make your life WAY simpler in the long run. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: "Chris Kavanagh" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, February 01, 2005 2:41 PM Subject: CFUPDATE throwing up a weird error > Dear List, > > This CFUPDATE looks okay to my noobish eyes: > > -- > > > formfields="name"> > > > -- > > [#name# is the primary key] > > Yet when I run it, it's throwing up this error: > > -- > Error Executing Database Query. > > Syntax error or access violation: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'where name='Dirtymilk'' at line 1 > -- > > Can anyone spot my mistake? > > Thanks, > CK. > > > ~| 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:192682 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
CFUPDATE throwing up a weird error
Dear List, This CFUPDATE looks okay to my noobish eyes: -- -- [#name# is the primary key] Yet when I run it, it's throwing up this error: -- Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where name='Dirtymilk'' at line 1 -- Can anyone spot my mistake? Thanks, CK. ~| 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:192680 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: Weird error in event viewer
John, if you are on Windows and you look in IIS MMC is there an entry for CFDOCS? If so remove that entry. Hth. Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper -Original Message- From: John mccosker [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 7:18 AM To: CF-Talk Subject: Weird error in event viewer Happy new year, our world wide web publishing service just stopped, I checked the event viewer and found this msg, The server was unable to add the virtual root '/cfdocs' for the directory 'x:\path_name\cfdocs' due to the following error: The system cannot find the path specified. The data is the error code. Cfdocs has not been installed for security reasons, so I'm confused where this error is coming from. Running IIS 4.0 on NT 4.0 and MX 6.1 would this ring a bell with anyone. Thanks for any feedback, j _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Weird error in event viewer
Happy new year, our world wide web publishing service just stopped, I checked the event viewer and found this msg, The server was unable to add the virtual root '/cfdocs' for the directory 'x:\path_name\cfdocs' due to the following error: The system cannot find the path specified. The data is the error code. Cfdocs has not been installed for security reasons, so I'm confused where this error is coming from. Running IIS 4.0 on NT 4.0 and MX 6.1 would this ring a bell with anyone. Thanks for any feedback, j [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MX - XML weird error (Whitespace required before attributes.)
I can't seem to figure this one out.. Is is nessessary to create the xml packet and pass it to the cfc or can it be created in the cfc but passed arguments? -Mike Whitespace required before attributes. The error occurred in D:\CFusionMX\wwwroot\modules\Synxis.cfc: line 24 Called from D:\CFusionMX\wwwroot\test\create_HotelAvailXML.cfm: line 61 Called from D:\CFusionMX\wwwroot\test\index.cfm: line 11 22 : 23 : 24 : 25 : 26 : ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: weird error
I've had coldfusion errors get stuck on some users computers. It seems to be related to the browser pagecache and clearing that often fixed similar problems for me. DRE -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:59 AM To: CF-Talk Subject: RE: weird error I'm on cfmx/win2k.. But the user is able to log onto another computer. Its only happening on that one computer that I'm aware of. I'm also able to go to our development site from there also.. Yes.. I'm working on moving client vars to the db =) -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:58 AM To: CF-Talk Subject: RE: weird error >I have clientmanagement="Yes" and I think it defaults to the >registry But when I put clientmanagement="No"... No more error... >Any ideas? > That could be a situation where your registry is full. Can you dig into it and see how big it is? Are you on Window? Unix? I deleted the old posts, so I forget what platform you said you're on. As a side note, storing client variables in the registry is an awful practice (if you'll excuse the bluntness). The option is a remnant of early ColdFusion versions (pre-CF 4, I believe) where the Registry was your only option. Now, it's really there for backwards-compatibility reasons and an ODBC datasource is the recommended path. Here's a good TechNote to help you move away from this. I believe the application they refer to will display a list of client variables in your registry, so it's a good place to start to get a feel for what's there. http://www.macromedia.com/support/coldfusion/ts/documents/tn17881.htm My suggestion above obviously isn't a direct answer to your question. But I would first start by removing client variables from the registry to reduce the registry size and see if your problems go away. Regards, Dave. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: weird error
I'm on cfmx/win2k.. But the user is able to log onto another computer. Its only happening on that one computer that I'm aware of. I'm also able to go to our development site from there also.. Yes.. I'm working on moving client vars to the db =) -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:58 AM To: CF-Talk Subject: RE: weird error >I have clientmanagement="Yes" and I think it defaults to the >registry But when I put clientmanagement="No"... No more error... >Any ideas? > That could be a situation where your registry is full. Can you dig into it and see how big it is? Are you on Window? Unix? I deleted the old posts, so I forget what platform you said you're on. As a side note, storing client variables in the registry is an awful practice (if you'll excuse the bluntness). The option is a remnant of early ColdFusion versions (pre-CF 4, I believe) where the Registry was your only option. Now, it's really there for backwards-compatibility reasons and an ODBC datasource is the recommended path. Here's a good TechNote to help you move away from this. I believe the application they refer to will display a list of client variables in your registry, so it's a good place to start to get a feel for what's there. http://www.macromedia.com/support/coldfusion/ts/documents/tn17881.htm My suggestion above obviously isn't a direct answer to your question. But I would first start by removing client variables from the registry to reduce the registry size and see if your problems go away. Regards, Dave. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: weird error
>I have clientmanagement="Yes" and I think it defaults to the registry >But when I put clientmanagement="No"... No more error... Any ideas? > That could be a situation where your registry is full. Can you dig into it and see how big it is? Are you on Window? Unix? I deleted the old posts, so I forget what platform you said you're on. As a side note, storing client variables in the registry is an awful practice (if you'll excuse the bluntness). The option is a remnant of early ColdFusion versions (pre-CF 4, I believe) where the Registry was your only option. Now, it's really there for backwards-compatibility reasons and an ODBC datasource is the recommended path. Here's a good TechNote to help you move away from this. I believe the application they refer to will display a list of client variables in your registry, so it's a good place to start to get a feel for what's there. http://www.macromedia.com/support/coldfusion/ts/documents/tn17881.htm My suggestion above obviously isn't a direct answer to your question. But I would first start by removing client variables from the registry to reduce the registry size and see if your problems go away. Regards, Dave. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: weird error
I have clientmanagement="Yes" and I think it defaults to the registry But when I put clientmanagement="No"... No more error... Any ideas? -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 6:28 AM To: CF-Talk Subject: Re: weird error >Has anybody seen this error message? > > >Error Occurred While Processing Request > > > >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. > > > >There is this one user that is constantly getting this message.. but >when she logs on with another computer.. she is ok. Working fine for >everybody else ( I hope ). > >Using win2k & mx. Yep, just finished dealing with this useless error message. In my case, it urns out it was a cookie issue where a value was set to an empty string. In previous versions of CF, that was OK, but in MX it becomes NULL which CF chokes on. Check your application for cookie usage and make sure that values aren't being set to empty strings. Regards, Dave. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird error
Great!! Thanks for the hint! Gabriel Dave Carabetta wrote: >>Are you saying that we should never set coolie values to "" in MX? >> > > > I believe it's related to this TechNote, although you'll note that it was > last updated in November 2002. > > http://www.macromedia.com/support/coldfusion/ts/documents/tn17009.htm > > I think that in previous versions, you might get the "Error Resolving > Parameter" error they are describing, but in MX you get the error that > you're seeing. > > Again, my "cookie theory" is based on my own observations and headaches in > tracking down the problem. Your problem may be different. > > Regards, > Dave. > > _ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird error
> >Are you saying that we should never set coolie values to "" in MX? > I believe it's related to this TechNote, although you'll note that it was last updated in November 2002. http://www.macromedia.com/support/coldfusion/ts/documents/tn17009.htm I think that in previous versions, you might get the "Error Resolving Parameter" error they are describing, but in MX you get the error that you're seeing. Again, my "cookie theory" is based on my own observations and headaches in tracking down the problem. Your problem may be different. Regards, Dave. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird error
Are you saying that we should never set coolie values to "" in MX? GAbriel Dave Carabetta wrote: >>Has anybody seen this error message? >> >> >>Error Occurred While Processing Request >> >> >> >>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. >> >> >> >>There is this one user that is constantly getting this message.. but when >>she logs on with another computer.. she is ok. Working fine for everybody >>else ( I hope ). >> >>Using win2k & mx. > > > Yep, just finished dealing with this useless error message. In my case, it > urns out it was a cookie issue where a value was set to an empty string. In > previous versions of CF, that was OK, but in MX it becomes NULL which CF > chokes on. Check your application for cookie usage and make sure that values > aren't being set to empty strings. > > Regards, > Dave. > > _ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird error
>Has anybody seen this error message? > > >Error Occurred While Processing Request > > > >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. > > > >There is this one user that is constantly getting this message.. but when >she logs on with another computer.. she is ok. Working fine for everybody >else ( I hope ). > >Using win2k & mx. Yep, just finished dealing with this useless error message. In my case, it urns out it was a cookie issue where a value was set to an empty string. In previous versions of CF, that was OK, but in MX it becomes NULL which CF chokes on. Check your application for cookie usage and make sure that values aren't being set to empty strings. Regards, Dave. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
weird error
Hello all, Has anybody seen this error message? Error Occurred While Processing Request 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. There is this one user that is constantly getting this message.. but when she logs on with another computer.. she is ok. Working fine for everybody else ( I hope ). Using win2k & mx. Thanks, Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird Error Message
Thanks, it works after deleting both .class and .java files -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:45 To: CF-Talk Subject: Re: Weird Error Message Citeren "Shahzad.Butt" <[EMAIL PROTECTED]>: > Today, thinking of normal day I typed in my site address. Clicked on a > link and its giving following error. Does anyone knows what this error > is all about and how come its appearing without anything being > changed. > > Thanks in advance > > Errors reported by Java compiler: Found 1 semantic error compiling > "C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java": > 1. public final class cfSelect2ecfm2055018563 extends > coldfusion.runtime.CFPage{ <-> *** Error: Cannot > write class file "cfSelect2ecfm2055018563.class" because that name > conflicts with the name of the class file > "cfselect2ecfm2055018563.class" in directory "cfclasses". This is > illegal because file names are case-insensitive in this system. . It probably means that you once had a file called cfslect2e.cfm It was opened and compiled a while back. The compiled page was saved to improve execution speed. then you removed it and created a file called cfSelect2e (note the case of the 's') and when coldfusion tried to compile it it found that another file with an almost identical name existed, but as the cases differ it can't (won't) overwrite the original file. To sole this you need to remove the cfselect2ecfm2055018563.class file from the cfroot\webroot\web-inf\cfclasses directory to sole this. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird Error Message
Citeren "Shahzad.Butt" <[EMAIL PROTECTED]>: > Today, thinking of normal day I typed in my site address. Clicked on a > link and its giving following error. Does anyone knows what this error > is all about and how come its appearing without anything being changed. > > Thanks in advance > > Errors reported by Java compiler: Found 1 semantic error compiling > "C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java": > 1. public final class cfSelect2ecfm2055018563 extends > coldfusion.runtime.CFPage{ <-> *** Error: Cannot > write class file "cfSelect2ecfm2055018563.class" because that name > conflicts with the name of the class file > "cfselect2ecfm2055018563.class" in directory "cfclasses". This is > illegal because file names are case-insensitive in this system. . It probably means that you once had a file called cfslect2e.cfm It was opened and compiled a while back. The compiled page was saved to improve execution speed. then you removed it and created a file called cfSelect2e (note the case of the 's') and when coldfusion tried to compile it it found that another file with an almost identical name existed, but as the cases differ it can't (won't) overwrite the original file. To sole this you need to remove the cfselect2ecfm2055018563.class file from the cfroot\webroot\web-inf\cfclasses directory to sole this. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird Error Message
We had a similar problem but with cfdump after running an updater... Goto your C:/CFusionMX/wwwroot/WEB-INF/cfclasses/ directory and delete the .java and .class files relating to the cfselect and you should be alright... HTH Mikey = http://www.phonebin.com "From Phone to Web in minutes" -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 11:29 To: CF-Talk Subject: Weird Error Message Today, thinking of normal day I typed in my site address. Clicked on a link and its giving following error. Does anyone knows what this error is all about and how come its appearing without anything being changed. Thanks in advance Errors reported by Java compiler: Found 1 semantic error compiling "C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java": 1. public final class cfSelect2ecfm2055018563 extends coldfusion.runtime.CFPage{ <-> *** Error: Cannot write class file "cfSelect2ecfm2055018563.class" because that name conflicts with the name of the class file "cfselect2ecfm2055018563.class" in directory "cfclasses". This is illegal because file names are case-insensitive in this system. . Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird Error Message
Today, thinking of normal day I typed in my site address. Clicked on a link and its giving following error. Does anyone knows what this error is all about and how come its appearing without anything being changed. Thanks in advance Errors reported by Java compiler: Found 1 semantic error compiling "C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfSelect2ecfm2055018563.java": 1. public final class cfSelect2ecfm2055018563 extends coldfusion.runtime.CFPage{ <-> *** Error: Cannot write class file "cfSelect2ecfm2055018563.class" because that name conflicts with the name of the class file "cfselect2ecfm2055018563.class" in directory "cfclasses". This is illegal because file names are case-insensitive in this system. . Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: weird error!
can I create an executiuon time less than 1 second? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 4:55 PM Subject: RE: weird error! > If you don't specify a timeout for cfexecute, it doesn't wait for it to > finish. Therefore, the process can still be running and the output file > not ready. Add a timeout to your cfexecute call. > > === > Raymond Camden, ColdFusion Jedi Master for Hire > > Email: [EMAIL PROTECTED] > WWW : www.camdenfamily.com/morpheus > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Chris Edwards [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 10, 2002 4:46 PM > > To: CF-Talk > > Subject: weird error! > > > > > > trying to run this, > > > > >arguments="#args#" > >outputfile="c:\output"> > > > > > > > > > > > > getting this: > > Error processing CFFILE > > > > Error attempting to read 'c:\output.' The process cannot > > access the file > > because it is being used by another process. (error 32) > > > > > > > > why is cfexecute holding onto the file for so long??? > > > > > > > > > > > > -- > > Chris Edwards > > Web Application Developer > > Outer Banks Internet, Inc. > > 252-441-6698 > > [EMAIL PROTECTED] > > http://www.OuterBanksInternet.com > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: weird error!
Try: C:\Output.TXT >>> [EMAIL PROTECTED] 10/10/02 04:45PM >>> trying to run this, getting this: Error processing CFFILE Error attempting to read 'c:\output.' The process cannot access the file because it is being used by another process. (error 32) why is cfexecute holding onto the file for so long??? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: weird error!
If you don't specify a timeout for cfexecute, it doesn't wait for it to finish. Therefore, the process can still be running and the output file not ready. Add a timeout to your cfexecute call. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Chris Edwards [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 4:46 PM > To: CF-Talk > Subject: weird error! > > > trying to run this, > > arguments="#args#" >outputfile="c:\output"> > > > > > > getting this: > Error processing CFFILE > > Error attempting to read 'c:\output.' The process cannot > access the file > because it is being used by another process. (error 32) > > > > why is cfexecute holding onto the file for so long??? > > > > > > -- > Chris Edwards > Web Application Developer > Outer Banks Internet, Inc. > 252-441-6698 > [EMAIL PROTECTED] > http://www.OuterBanksInternet.com > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
weird error!
trying to run this, getting this: Error processing CFFILE Error attempting to read 'c:\output.' The process cannot access the file because it is being used by another process. (error 32) why is cfexecute holding onto the file for so long??? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Weird Error.
Nope, using CF5. > -Original Message- > From: Benoit Hediard [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 11:27 AM > To: CF-Talk > Subject: RE: Weird Error. > > > Are you using CFMX and CFC in persistent scopes (session, > application...)? > > Benoit Hediard > www.benorama.com > > -Message d'origine- > De : Kevin Wong [mailto:[EMAIL PROTECTED]] > Envoyé : mardi 10 septembre 2002 17:11 > À : CF-Talk > Objet : Weird Error. > > > This is a multi-part message in MIME format. > > --_=_NextPart_001_01C258DC.4D23E326 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi, > > I've been getting a strange error recently on some my sites. > I have an = > error=20 > handler using tag that emails me the error message > and dumps=20 > out the error, form, url, session and cgi objects. > > Now the error I'm getting says "Error resolving parameter" > for a session > variable, but when I look at the dump for the session object, it is = > defined. > > Strange thing is, I only get this error some of the time. > > Anybody got any ideas? > > Thanks in advance, > Kevin > > --_=_NextPart_001_01C258DC.4D23E326 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > > charset=3Diso-8859-1"> > 6.0.5770.91"> > Weird Error. > > > > > Hi, > > > I've been getting a strange error = > recently on some my sites. I have an error > > handler using > <cferror> tag that = > emails me the error message and dumps > > out the error, form, url, > session and = > cgi objects. > > > Now the error I'm getting says = > "Error resolving = > parameter" for a = > session > > variable, but when I look > at the dump = > for the session object, it is defined. > > > Strange thing is, I only get > this error = > some of the time. > > > Anybody got any ideas? > > > Thanks in advance, > > Kevin > > > > > --_=_NextPart_001_01C258DC.4D23E326-- > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Weird Error.
Are you using CFMX and CFC in persistent scopes (session, application...)? Benoit Hediard www.benorama.com -Message d'origine- De : Kevin Wong [mailto:[EMAIL PROTECTED]] Envoyé : mardi 10 septembre 2002 17:11 À : CF-Talk Objet : Weird Error. This is a multi-part message in MIME format. --_=_NextPart_001_01C258DC.4D23E326 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I've been getting a strange error recently on some my sites. I have an = error=20 handler using tag that emails me the error message and dumps=20 out the error, form, url, session and cgi objects. Now the error I'm getting says "Error resolving parameter" for a session variable, but when I look at the dump for the session object, it is = defined. Strange thing is, I only get this error some of the time. Anybody got any ideas? Thanks in advance, Kevin --_=_NextPart_001_01C258DC.4D23E326 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Weird Error. Hi, I've been getting a strange error = recently on some my sites. I have an error handler using <cferror> tag that = emails me the error message and dumps out the error, form, url, session and = cgi objects. Now the error I'm getting says = "Error resolving = parameter" for a = session variable, but when I look at the dump = for the session object, it is defined. Strange thing is, I only get this error = some of the time. Anybody got any ideas? Thanks in advance, Kevin --_=_NextPart_001_01C258DC.4D23E326-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Weird Error.
This is a multi-part message in MIME format. --_=_NextPart_001_01C258DC.4D23E326 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I've been getting a strange error recently on some my sites. I have an = error=20 handler using tag that emails me the error message and dumps=20 out the error, form, url, session and cgi objects. Now the error I'm getting says "Error resolving parameter" for a session variable, but when I look at the dump for the session object, it is = defined. Strange thing is, I only get this error some of the time. Anybody got any ideas? Thanks in advance, Kevin --_=_NextPart_001_01C258DC.4D23E326 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Weird Error. Hi, I've been getting a strange error = recently on some my sites. I have an error handler using <cferror> tag that = emails me the error message and dumps out the error, form, url, session and = cgi objects. Now the error I'm getting says = "Error resolving = parameter" for a = session variable, but when I look at the dump = for the session object, it is defined. Strange thing is, I only get this error = some of the time. Anybody got any ideas? Thanks in advance, Kevin --_=_NextPart_001_01C258DC.4D23E326-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX & SQL - simple query with weird error message
Ye, I am getting a VERY similar error. Did you ever get resolution on this issue? I can solve my problem by setting up the DataSource in the CFAdmin as ODBC Socket connection instead of SQLServer... however I was thinking that JDBC is more efficient... faster etc. Brian At 10:53 AM 7/16/02, you wrote: >We just installed CFMX on a brand new server, W2k with SQL 2000. Most >CF5 codes worked and no problems with stored procedures so far, except a >few errors on simple queries. One of them was quite weird. > >Name : VARCHAR(128) >Cost: real >tableA joins tableB on (tableA.ID = tableB.aID) > >Case 1: works > >SELECT ID, Name >FROM tableA > > >Case 2: works > >SELECT aID, Cost >FROM tableB >WHERE aID = 1 > > >Case 3: NOT working in CFMX but in CF5 and old versions > >SELECT A.Name, B.Cost > FROM tableA AS A INNER JOIN > tableB AS B ON (A.ID = B.aID) >WHERE B.aID = 1 > > >CFMX Error message: > > > > Error Executing Database Query. > >[Macromedia][SQLServer JDBC Driver]Value can not be converted to >requested type. > >Now Case 3 is too simple to cause errors. If CFMX can handle more >complicated queries and stored procedures but not this one, it's just >hard to understand. Maybe something too simple?! I've tried many things >but cannot fix it. Can anyone throw some light on this? Thx > >-Ye > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fwd: Re: Weird error (solved)
Found my problem, basically I was URL decoding it twice... my bad. =P Doing too much at once. >Date: Fri, 26 Jul 2002 23:44:57 -0400 >To: [EMAIL PROTECTED] >From: Todd <[EMAIL PROTECTED]> >Subject: Re: Weird error > > >er.. cfusion_decrypt().. and, yes, I know it's undocumented code. I >recall voting for it in the beta. ;) > >~Todd > >At 11:42 PM 7/26/2002 -0400, you wrote: >>Well, it's not null... I did a cfdump and there's data in there. >> >>All I was doing was encrypting, urlencoding... urldecoding.. decrypting. >> >>I had to switch to cfusion_encrypt() cfusion_decode() to get it to work. >> >>~Todd >> >>At 08:24 PM 7/26/2002 -0700, you wrote: >> >On Friday, July 26, 2002, at 07:19 , Todd wrote: >> > > An obscure message: >> > > "Error","jrpp-41","07/26/02","22:04:38","myApp","null The specific >> > > sequence >> > > of files included or processed is: >> D:\Dev\websites\myapp\registration.cfm >> > > " >> > >> >Hmm, that just repeats what we already really know. What about the other >> >log files? Anything in any of the others around that time? >> > >> >Could you just above that >> >line to see that URLDATA exists and has a non-empty key V1? >> > >> >Sean A Corfield -- http://www.corfield.org/blog/ >> > >> >"If you're not annoying somebody, you're not really alive." >> >-- Margaret Atwood >> > >> > >> __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird error
er.. cfusion_decrypt().. and, yes, I know it's undocumented code. I recall voting for it in the beta. ;) ~Todd At 11:42 PM 7/26/2002 -0400, you wrote: >Well, it's not null... I did a cfdump and there's data in there. > >All I was doing was encrypting, urlencoding... urldecoding.. decrypting. > >I had to switch to cfusion_encrypt() cfusion_decode() to get it to work. > >~Todd > >At 08:24 PM 7/26/2002 -0700, you wrote: > >On Friday, July 26, 2002, at 07:19 , Todd wrote: > > > An obscure message: > > > "Error","jrpp-41","07/26/02","22:04:38","myApp","null The specific > > > sequence > > > of files included or processed is: D:\Dev\websites\myapp\registration.cfm > > > " > > > >Hmm, that just repeats what we already really know. What about the other > >log files? Anything in any of the others around that time? > > > >Could you just above that > >line to see that URLDATA exists and has a non-empty key V1? > > > >Sean A Corfield -- http://www.corfield.org/blog/ > > > >"If you're not annoying somebody, you're not really alive." > >-- Margaret Atwood > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird error
Well, it's not null... I did a cfdump and there's data in there. All I was doing was encrypting, urlencoding... urldecoding.. decrypting. I had to switch to cfusion_encrypt() cfusion_decode() to get it to work. ~Todd At 08:24 PM 7/26/2002 -0700, you wrote: >On Friday, July 26, 2002, at 07:19 , Todd wrote: > > An obscure message: > > "Error","jrpp-41","07/26/02","22:04:38","myApp","null The specific > > sequence > > of files included or processed is: D:\Dev\websites\myapp\registration.cfm > > " > >Hmm, that just repeats what we already really know. What about the other >log files? Anything in any of the others around that time? > >Could you just above that >line to see that URLDATA exists and has a non-empty key V1? > >Sean A Corfield -- http://www.corfield.org/blog/ > >"If you're not annoying somebody, you're not really alive." >-- Margaret Atwood > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird error
On Friday, July 26, 2002, at 07:19 , Todd wrote: > An obscure message: > "Error","jrpp-41","07/26/02","22:04:38","myApp","null The specific > sequence > of files included or processed is: D:\Dev\websites\myapp\registration.cfm > " Hmm, that just repeats what we already really know. What about the other log files? Anything in any of the others around that time? Could you just above that line to see that URLDATA exists and has a non-empty key V1? Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird error
An obscure message: "Error","jrpp-41","07/26/02","22:04:38","myApp","null The specific sequence of files included or processed is: D:\Dev\websites\myapp\registration.cfm " At 07:11 PM 7/26/2002 -0700, you wrote: >On Friday, July 26, 2002, at 07:03 , Todd wrote: > > First time I've ever seen an error message without a real error message > > (errr.. Axis errors not included) since beta, this is literally all that > > is > > displayed, no reason why, no nothing... > > ... > > 35 : tempStruct.username = > > Decrypt(URLdecode(arguments.urlData.v1),"finish_registration"); > >Anything in the various .log files? > >"If you're not annoying somebody, you're not really alive." >-- Margaret Atwood > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird error
On Friday, July 26, 2002, at 07:03 , Todd wrote: > First time I've ever seen an error message without a real error message > (errr.. Axis errors not included) since beta, this is literally all that > is > displayed, no reason why, no nothing... > ... > 35 : tempStruct.username = > Decrypt(URLdecode(arguments.urlData.v1),"finish_registration"); Anything in the various .log files? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Weird error
First time I've ever seen an error message without a real error message (errr.. Axis errors not included) since beta, this is literally all that is displayed, no reason why, no nothing... The Error Occurred in D:\Dev\websites\famtoday\_ftlibrary\cfcs\system\registration.cfc: line 35 33 : 34 : tempStruct = structNew(); 35 : tempStruct.username = Decrypt(URLdecode(arguments.urlData.v1),"finish_registration"); 36 : tempStruct.password = Decrypt(URLdecode(arguments.urlData.v2),"finish_registration"); ~Todd __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX & SQL - simple query with weird error message
both FLOAT and INT are working, but not REAL. - Original Message - From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 3:07 PM Subject: Re: CFMX & SQL - simple query with weird error message > Ouch, that would be a bummer... Have you tried Float instead of Real? > > Isaac > > > > tableA.ID and tableB.aID are both INT. No problem with that. > > > Two ways I could make this query work. > > 1. change Cost datatype from Real to INT in SQL; > > 2. SELECT SUM(B.cost) AS cost; > > > Now with Solution 1, one has to user REAL datatype somehow, Cost is just a > > sample variable I used here. > > With Solution 2, I cannot select "A.Name" together with "B.Cost", unless I > > have some GROUP BY statement. However with large SELECT set sometimes one > > just doesn't want to use GROUP BY at all. > > > Seems CFMX having problem retrieving REAL values from SQL?! I didn't have > > problem with INT in select statement. Or is this just a JDBC problem. This > > message of "Value can not be converted to requested type. " really > > confused > > me. > > > > - Original Message - > > From: "Jochem van Dieten" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, July 16, 2002 2:46 PM > > Subject: Re: CFMX & SQL - simple query with weird error message > > > >> Ye Wang wrote: > >> > We just installed CFMX on a brand new server, W2k with SQL 2000. Most > >> > CF5 codes worked and no problems with stored procedures so far, except > >> > a > >> > few errors on simple queries. One of them was quite weird. > >> > > >> > Name : VARCHAR(128) > >> > Cost: real > >> > tableA joins tableB on (tableA.ID = tableB.aID) > >> > >> The datatypes of tableA.ID and tableB.aID are probably more relevant. > >> > >> Jochem > >> > >> > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX & SQL - simple query with weird error message
The original query was: SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 Those were not working: INNER JOIN JOIN tableA AS A tableA A tables fullname Solution 1: change "Cost" datatype from REAL to INT (or FLOAT) in SQL, worked with the same query. Solution 2: SELECT SUM(B.Cost) AS Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 - Original Message - From: "Joe Eugene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 3:08 PM Subject: RE: CFMX & SQL - simple query with weird error message > I didnt see you mention anything about Sum(cost) or what not > in your original post..! all you had was a join and where clause.. > > > -Original Message- > From: Ye Wang [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 3:00 PM > To: CF-Talk > Subject: Re: CFMX & SQL - simple query with weird error message > > > tableA.ID and tableB.aID are both INT. No problem with that. > > Two ways I could make this query work. > 1. change Cost datatype from Real to INT in SQL; > 2. SELECT SUM(B.cost) AS cost; > > Now with Solution 1, one has to user REAL datatype somehow, Cost is just a > sample variable I used here. > With Solution 2, I cannot select "A.Name" together with "B.Cost", unless I > have some GROUP BY statement. However with large SELECT set sometimes one > just doesn't want to use GROUP BY at all. > > Seems CFMX having problem retrieving REAL values from SQL?! I didn't have > problem with INT in select statement. Or is this just a JDBC problem. This > message of "Value can not be converted to requested type. " really confused > me. > > > - Original Message - > From: "Jochem van Dieten" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 16, 2002 2:46 PM > Subject: Re: CFMX & SQL - simple query with weird error message > > > > Ye Wang wrote: > > > We just installed CFMX on a brand new server, W2k with SQL 2000. Most > > > CF5 codes worked and no problems with stored procedures so far, except a > > > few errors on simple queries. One of them was quite weird. > > > > > > Name : VARCHAR(128) > > > Cost: real > > > tableA joins tableB on (tableA.ID = tableB.aID) > > > > The datatypes of tableA.ID and tableB.aID are probably more relevant. > > > > Jochem > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX & SQL - simple query with weird error message
Ouch, that would be a bummer... Have you tried Float instead of Real? Isaac > tableA.ID and tableB.aID are both INT. No problem with that. > Two ways I could make this query work. > 1. change Cost datatype from Real to INT in SQL; > 2. SELECT SUM(B.cost) AS cost; > Now with Solution 1, one has to user REAL datatype somehow, Cost is just a > sample variable I used here. > With Solution 2, I cannot select "A.Name" together with "B.Cost", unless I > have some GROUP BY statement. However with large SELECT set sometimes one > just doesn't want to use GROUP BY at all. > Seems CFMX having problem retrieving REAL values from SQL?! I didn't have > problem with INT in select statement. Or is this just a JDBC problem. This > message of "Value can not be converted to requested type. " really > confused > me. > - Original Message - > From: "Jochem van Dieten" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 16, 2002 2:46 PM > Subject: Re: CFMX & SQL - simple query with weird error message >> Ye Wang wrote: >> > We just installed CFMX on a brand new server, W2k with SQL 2000. Most >> > CF5 codes worked and no problems with stored procedures so far, except >> > a >> > few errors on simple queries. One of them was quite weird. >> > >> > Name : VARCHAR(128) >> > Cost: real >> > tableA joins tableB on (tableA.ID = tableB.aID) >> >> The datatypes of tableA.ID and tableB.aID are probably more relevant. >> >> Jochem >> >> > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists