Money converted into text/string value?? 2 post • Page:1 of 1 All times are UTC Board index Spam Report FAQs Search RecentTopics FlaggedTopics HotTopics Best Topics Register / Login Win a Any insight would be much appreciated. I assume that this happens if you hit a database table OR a view. Let me get some of the details out of the way first:JDBC Driver: SP3 for SQL SERVER Version:2.2.0040 SQL Server: 2000, SP4. have a peek at these guys
I guess I was wrong about the CF Studio fix. That has not solved the problem. I have gone back and changed all my fields to accept null values. I can't even begin to think how long it would have taken me to figure this out on my own.
Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. Make a change in the cfquery, it is then re-cached, so the query works again. That seemed to do it.
So, I don't think that is a definite fix.SELECT UI.salutation, UI.firstname, UI.lastname, UI.email, UI.nickname, UI.photo, UA.*, S.state_abbr, Ben Nadel Nov 13, 2010 at 11:58 AM 12,905 Comments @Josh, When in doubt, MrBuzzy Jan 9, 2011 at 8:18 PM 9 Comments Thanks for this post, very helpful.I was looking for a way to flush this DB/query cache. Boss sends a birthday message. Feedback Was this article helpful?
Josh Nov 10, 2010 at 5:24 PM 8 Comments Does anybody know why this error is appearing for us now when it never did in the past? If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Characters Remaining: 255 Copyright © 2016, Progress Software Corporation and/or its subsidiaries or affiliates. But, i'm using EJB CMP.
Are you using SELECT * in your queries? Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode February 21st,11:52 PM #1 Value can not be I'm only changing datasource. That has not solved the problem.
could not read column value from result set: actualSt3_9_0_; [Microsoft][SQLServer 2000 Driver for JDBC]Value can not be converted to requested type. Then re-run your query, then re-enable connections. Is this something new to CF9?Commenting on Oxide said... All Rights Reserved.
S Code snippets attached.. The problem is inevitably SQL SELECT statements that use (*) such as:SELECT*FROM[table]I am not 100% sure why this takes place, but here's my version: ColdFusion caches the SQL statement (or SQL However I keep getting [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. check my blog Ugh....
I'm making simple RMI call using ServiceLocator (J2EE Design pattern). share|improve this answer answered Dec 3 '14 at 14:41 Dbloch 1,4871310 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Any sample code provided on this site is not supported under any Progress support program or service.
Jason M May 30, 2012 at 12:47 PM 2 Comments Just received this same error but with named columns. Might save somebody some troubles. Ben Nadel Jun 1, 2009 at 1:28 PM 12,905 Comments @Cheryl, You're saying you're still getting the error on non-select-* queries? http://ibuildsystem.com/value-cannot/value-cannot-be-converted-to-integer-gdb.php SP works perfectly in Query yzer and has the right permissions for the web DSN to execute it.
As far as I have personally experienced, as long as you are not using "select *", then you should not experience this error as ColdFusion will not try to execute a Maybe. Oh my chickens, this post is old! I'm using Jboss 3.2.3, Microsoft SQL Server 2000 and Microsoft JDBC driver (SP2).
Jamie Aug 28, 2007 at 8:30 PM 1 Comments I know this is an old post, but I just wanted to say that this post has saved my life. Any sample code provided on this site is not supported under any Progress support program or service. That combined with a ", c." on the clip board and you've got yourself a proper query in no-time. : ) Paul Nov 28, 2009 at 11:09 AM 4 Comments An The sample code is provided on an "AS IS" basis.
your post helped me figure out what was going wrong. I am stuck because I can not move up to JDBC Drivers for SQL Server 2005. Progress Software Corporation makes all reasonable efforts to verify this information. How to reply?
Scott Aug 25, 2011 at 10:39 AM 1 Comments I hit this on CF9, but I am explicitly naming all the columns instead of doing a select *.We are using SQL For example "Date" data type. Russ Wednesday, August 02, 2006 8:02 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. Not the answer you're looking for?
The conversion of strings to other types might work differently on different kinds of DB servers. Straight line equation My cat sat on my laptop, now the right side of my keyboard types the wrong characters How can I open the next/previous file alphabetically? I also use cfqueryparam and it seems to have a problem with it. So I got the same error on another app (no Fusebox) and could see the actual error message.
Looking For A New Job? on the last CFPROCPARAM line when I try and run it in CF. The problem was an empty space ' ' after the last column (ex: desc as description' ').