Loop over XML stored in MySQL with Coldfusion -
client uploads images , system pulls meta info them , stores xml in database.
looks this:
<wddxpacket version='1.0'><header/><data><struct> <var name='exif'><struct><var name='orientation'><string> top, left side (horizontal / normal)</string></var>...
i looping on images , need loop on string pull vars out (artist, title, description).
i've tried can think of getting errors "cant cast string type array".
if can suggest solution, i'm in debt!
as others in comments have suggested, wddx way store structured data - bit json typically used. you'll want pass column/string wddx tag.
<cfwddx action="wddx2cfml" input="#queryname.colmname#" output="imgdata"> <cfdump var="#imgdata#">
that should moving along right path. there have along lines of:
#imgdata.exif.orientation#
...per example above var contain string top, left side (hoirzontal / normal).
Comments
Post a Comment