Weird error message
Any ideas anyone please? Strange error running: cfquery dbtype=query name=mail_clear select * from mail_get where mail_get.uid #last_mail+1# /cfquery 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 : cfquery dbtype=query name=mail_clear 167 : select * from mail_get 168 : where mail_get.uid #val(last_mail)+1# 169 : /cfquery 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: 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: cfquery dbtype=query name=mail_clear select * from mail_get where mail_get.uid #last_mail+1# /cfquery 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 : cfquery dbtype=query name=mail_clear 167 : select * from mail_get 168 : where mail_get.uid #val(last_mail)+1# 169 : /cfquery 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
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: cfquery dbtype=query name=mail_clear select * from mail_get where mail_get.uid #last_mail+1# /cfquery 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 : cfquery dbtype=query name=mail_clear 167 : select * from mail_get 168 : where mail_get.uid #val(last_mail)+1# 169 : /cfquery 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
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
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=subscribeforumid=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=subscribeforumid=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
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=subscribeforumid=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
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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 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 cfquery name=get_a datasource=myDSN SELECT ID, Name FROM tableA /cfquery Case 2: works cfquery name=get_b datasource=myDSN SELECT aID, Cost FROM tableB WHERE aID = 1 /cfquery Case 3: NOT working in CFMX but in CF5 and old versions cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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
CFMX SQL - simple query with weird error message
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 cfquery name=get_a datasource=myDSN SELECT ID, Name FROM tableA /cfquery Case 2: works cfquery name=get_b datasource=myDSN SELECT aID, Cost FROM tableB WHERE aID = 1 /cfquery Case 3: NOT working in CFMX but in CF5 and old versions cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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 __ 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
Kinda weird, but try like so SELECT A.Name, B.Cost FROM tableA a INNER JOIN tableB b ON (A.ID = B.aID) WHERE B.aID = 1 Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Ye Wang [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 10:53 AM Subject: CFMX SQL - simple query with weird error message 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 cfquery name=get_a datasource=myDSN SELECT ID, Name FROM tableA /cfquery Case 2: works cfquery name=get_b datasource=myDSN SELECT aID, Cost FROM tableB WHERE aID = 1 /cfquery Case 3: NOT working in CFMX but in CF5 and old versions cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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 __ 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: CFMX SQL - simple query with weird error message
Kinda weird, but try like so SELECT A.Name, B.Cost FROM tableA a INNER JOIN tableB b ON (A.ID = B.aID) WHERE B.aID = 1 I don't have an MX machine handy ... curious to know what the error message was tho... could you post it to the list? Isaac Dealey www.turnkey.to 954-776-0046 __ 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: CFMX SQL - simple query with weird error message
Tried before, same error. Thanks for the thought though. Also tried with tables fullname, same thing. I guessed it's because Cost and Name are not the same datatype. But then one cannot always have the same datatype for all output. :( - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 2:15 PM Subject: Re: CFMX SQL - simple query with weird error message Kinda weird, but try like so SELECT A.Name, B.Cost FROM tableA a INNER JOIN tableB b ON (A.ID = B.aID) WHERE B.aID = 1 Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Ye Wang [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 10:53 AM Subject: CFMX SQL - simple query with weird error message 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 cfquery name=get_a datasource=myDSN SELECT ID, Name FROM tableA /cfquery Case 2: works cfquery name=get_b datasource=myDSN SELECT aID, Cost FROM tableB WHERE aID = 1 /cfquery Case 3: NOT working in CFMX but in CF5 and old versions cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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
Re: CFMX SQL - simple query with weird error message
Ooops! Sorry... nevermind my last post. :) Isaac Dealey www.turnkey.to 954-776-0046 __ 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: CFMX SQL - simple query with weird error message
My original post: 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 cfquery name=get_a datasource=myDSN SELECT ID, Name FROM tableA /cfquery Case 2: works cfquery name=get_b datasource=myDSN SELECT aID, Cost FROM tableB WHERE aID = 1 /cfquery Case 3: NOT working in CFMX but in CF5 and old versions cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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 - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 2:28 PM Subject: Re: CFMX SQL - simple query with weird error message Kinda weird, but try like so SELECT A.Name, B.Cost FROM tableA a INNER JOIN tableB b ON (A.ID = B.aID) WHERE B.aID = 1 I don't have an MX machine handy ... curious to know what the error message was tho... could you post it to the list? Isaac Dealey www.turnkey.to 954-776-0046 __ 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: CFMX SQL - simple query with weird error message
Try some like this.. dont think you have specify INNER.. its understood. IF the Column Names are NAME or COST.. try alias them like below cfquery name=get_ab datasource=MyDSN SELECT 'GName'=A.Name, 'GCost'=B.Cost FROM tableA A JOIN tableB B ON A.ID = B.AID WHERE B.AID = 1 /cfquery Type IV driver doesnt seem to like something. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Ye Wang [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:54 PM To: CF-Talk Subject: CFMX SQL - simple query with weird error message 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 cfquery name=get_a datasource=myDSN SELECT ID, Name FROM tableA /cfquery Case 2: works cfquery name=get_b datasource=myDSN SELECT aID, Cost FROM tableB WHERE aID = 1 /cfquery Case 3: NOT working in CFMX but in CF5 and old versions cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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 __ 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: CFMX SQL - simple query with weird error message
Why do I have a sinking feeling I'm putting my head in a noose here? :) [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Considering this error message and the fact that it's a select statement where you don't have anything but the single hard-coded (1) being evaluated from CF - SQL ( i.e. all other comparisons are internal to the datasource ), my gut reaction would be to check and make sure that a.ID and b.aID are both integers and that one of them is not maybe a long or short integer by accident. By default in most cases SQL Server ( I suspect most rdbms ) allow implicit conversion between int and short or long int values, which would explain why it works in CF5 and before... Perhaps the JDBC drivers for MX are touchier about this implicit conversion? ... My only other suggestion is to comment out the where clause and/or the inner join to determine which is causing it. Either of them could be eliminated by moving the where condition into the join or moving the join expression into the where clause, so that could be a solution, although if this is the case and you're able to get it to work this way I would get in touch with MM support as I would then be suspicious that this is a bug in their JDBC drivers. Isaac Dealey www.turnkey.to 954-776-0046 __ 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: 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 __ 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: 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 __ 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: 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
I also think it's a JDBC issue because ODBC in CF5 has no problem with SELECT statement at all, disregarding what the datatype is for the output, REAL or INT. Now since I am not very familiar with JDBC I really cannot be sure, just a feeling. Did a lot of readings on the Macromedia Online Forum, seemed other people having problem making CFMX connects to database server. Fortunately we didn't have that problem. LOL! Thanks for your reply - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 2:43 PM Subject: Re: CFMX SQL - simple query with weird error message Why do I have a sinking feeling I'm putting my head in a noose here? :) [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. Considering this error message and the fact that it's a select statement where you don't have anything but the single hard-coded (1) being evaluated from CF - SQL ( i.e. all other comparisons are internal to the datasource ), my gut reaction would be to check and make sure that a.ID and b.aID are both integers and that one of them is not maybe a long or short integer by accident. By default in most cases SQL Server ( I suspect most rdbms ) allow implicit conversion between int and short or long int values, which would explain why it works in CF5 and before... Perhaps the JDBC drivers for MX are touchier about this implicit conversion? ... My only other suggestion is to comment out the where clause and/or the inner join to determine which is causing it. Either of them could be eliminated by moving the where condition into the join or moving the join expression into the where clause, so that could be a solution, although if this is the case and you're able to get it to work this way I would get in touch with MM support as I would then be suspicious that this is a bug in their JDBC drivers. Isaac Dealey www.turnkey.to 954-776-0046 __ 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: 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
Re: CFMX SQL - simple query with weird error message
The original query was: cfquery name=get_ab datasource=MyDSN SELECT A.Name, B.Cost FROM tableA AS A INNER JOIN tableB AS B ON (A.ID = B.aID) WHERE B.aID = 1 /cfquery 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
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