thanks, although the problem is there is no error to catch. when we run a
cfdump of the query, the sql is as follows:
SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on
views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 0 = 0 AND
categoryname IN ("aaaa's") ORDER BY viewname ASC LIMIT 0, 300
it just doesnt pull out the data, but if we copy it directly into mysql command
line it works fine
we do not even know how to trace the error as how can it work in mysql command
line but not in coldfusion? completely lost on this one!
>Wrap your actual cfquery with cftry and then cfoutput the variable cfcatch.sql
>
><cftry>
> <cfquery>...</cfquery>
> <cfcatch
> type="Database"><cfoutput><pre>#cfcatch.sql#</pre></cfoutput></cfcatch>
></cftry>
>
>Then post that sql here.
>
>Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337153
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
