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

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

angular - Is it possible to get native element for formControl? -

javascript - Why jQuery Select box change event is now working? -