I've recently acquired a bunch of 4.X CF sites and am upgrading them to 6.1
(yes, still behind the times). I've run into a problem that I've never seen
before. We're running CF on a Windows 2003 server and MySQL 5.0 on Linux.
<CFQUERY name="get" datasource="canterbury">
SELECT pageid FROM Pages
WHERE approval = 1
</CFQUERY>
Returns the appropraite number of records
When I run
<CFQUERY name="get" datasource="canterbury">
SELECT * FROM Pages
WHERE approval = 1
</CFQUERY>
The record count is zero.
In ideas what is going on? Any potential solutions other than replacing * with
all of the field names?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3007
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
