Never seen that before but does the same behavior happen when you use the
following:
<CFQUERY name="get" datasource="canterbury">
SELECT p.* FROM Pages p
WHERE approval = 1
</CFQUERY>
Basically adding an alias.
Brian
-----Original Message-----
From: Susan Kelly [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 11:35 PM
To: SQL
Subject: SELECT * returning zero records
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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3008
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
