here is the problem again I have a sql server with cold fusion mx my
database has a field for categories it contains a comma delim list of
categories to which each product belongs the prob is when I try to
create a drop down list for them it is giving me all kinds of weird results.
<cfquery datasource="db" name="getsubrc">
SELECT catid FROM deep_images WHERE catid LIKE '#uid#' OR catid
LIKE '#UID#,%' OR catid LIKE '%,#UID#' OR catid LIKE '%,#UID#,%'
</cfquery>
but one item has entries of 15,16,30,49,50,52,75 and it is being put in
a catecory that has the id of 2 there are lots of these that are
behaving this way. any one think of a way to help with this?
--
Patrick Forsythe
Tech Support
Smallville Communications
http://www.toto.net
"Guter Rat ist teuer." --Unbekannt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248736
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
