are you saying change:
<cfquery name="CFLinks" datasource="#REQUEST.dataSource#">
SELECT *
FROM Links
WHERE category = "CF"
ORDER BY title ASC
</cfquery>
to
<cfquery name="Links" datasource="#REQUEST.dataSource#">
SELECT *
FROM Links
WHERE category = "CF"
ORDER BY title ASC
</cfquery>
and change the WHERE clause? How would this be done?
Basically I am just trying to re produce the query for multiple
categories,and then displaying those results on other page. Is there a
better way to do this?
Thanks,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4739
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
