Strange Query of Queries Error

[imstillatwork]

Hell...o

the code i am using works perfect on our dev server (MX7, mysql 4.1) but not on our crystaltech server... mx7, mysql 4.1x

here is the error

 Query Of Queries runtime error.
Query Of Queries runtime error.
Unsupported Cast Excpetion: Casting to type "NULL" is unsupported.
 
The error occurred in D:\Inetpub\watg\com\content.cfc: line 135
Called from D:\Inetpub\watg\templates\pages\view_projects_by_region.cfm: line 11
Called from D:\Inetpub\watg\index.cfm: line 2

133 :     </cfoutput>
134 :    
135 :     <cfquery dbtype="query" name="qData">
136 :       SELECT * FROM qOutput
137 :     </cfquery>

I don't know where to begin. the query object 'qOutput' is fine, and is a query with several rows.

I don't get why it works on one server and not the other... any insight to this error???

Kevin

http://www.lot-o-nothin.com/cfml/

 

[cfStarlight]

What happens if you select one column by name? If the first one you pick doesn't work try it with a few of the others.

SELECT ColumnA
FROM qOutput

 

[LyndonOHRC]

IMO, You should always avoid select *

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[imstillatwork]

I understand completely about select, but i'm not pasting 30 fields for ya




Kevin

http://www.lot-o-nothin.com/cfml/

 

[imstillatwork]

Problem disappeared overnight.... and I can't get it to come back....that's good for now I guess....

Kevin

http://www.lot-o-nothin.com/cfml/