Are you sure that works?

Because i think all you are doing here is storing the literal string "evaluate(photo_info_#index#.public_url)" in the database. Check your tables.

You should be doing:

<cfqueryparam value="#Evaluate('photo_info_#index#.public_url')#">

or

<cfqueryparam value="#Evaluate('photo_info_' & index & '.public_url')#">


Remember "Evaluate()" is looking for a string literal to run, just like Javascripts eval().

Jason King wrote:
Ok, I think I got it. This seems to have worked
   SET thumbnail_url = <cfqueryparam
value="evaluate(photo_info_#index#.public_url)">',
I just had to play with the syntax a bit.


--
aw2.0
  http://www.aw20.co.uk/

-- 
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 !!

Reply via email to