Thanks Matt! I just knocked out a huge bunch of code I was working on, and
now I have one hangup. I have this query that needs to be included in the
loop:
<CFQUERY NAME="update_thumbnail" datasource="details_at_classifieds">
UPDATE #tbl_classifieds#
---> SET thumbnail_url = <cfqueryparam value="#photo_info_1.public_url#">,
thumbnail_file = <cfqueryparam value="#photo_info_1.photo_file#">
WHERE (classified_id = <cfqueryparam value="#CID#">)
</CFQUERY>
The issue I face is with ---> SET thumbnail_url = <cfqueryparam
value="#photo_info_1.public_url#">,
I need to replace the 1 with #INDEX#
I can't decide if it would be better to create a new variable and use that
in the query, rather than try and combine evaluate and cfqueryparam. I
thought about structkeyexists, but the struct has a variable in it.. so I'm
not sure how that would evaluate.
<CFSET index_thumbnail_url = evaluate("photo_info_#index#.public_url")>
---> SET thumbnail_url = <cfqueryparam value="#index_thumbnail_url#">,
My only issue is that I'm creating an extra variable where I might not need
one. That said... Is that the best way, or is there a way to evalaute a
value within a cfqueryparam statement that is wtihin a query?
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
