Try this... it builds a query with the info (I was converting it to WDDX to 
store in a db field), but you get the idea...

I have no idea why you can't see this data in the dump... I never could either.

Jonathan

<cfset amazonSELECT = 
QueryNew('ImageURLSmall,ImageURLMedium,ImageURLLarge,ProductName,Authors,Media,Manufacturer,Asin,ReleaseDate')>
                <cfloop index="i" from="1" 
to="#arraylen(productinfoARRAY.details)#" step="1">
                        <!--- Add Row To Query --->
                        <cfset QueryAddRow(amazonSELECT)>
                        
                        <!--- Insert ImageURLSmall --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 
'ImageURLSmall', productinfoARRAY.details[i].ImageURLSmall)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert ImageURLMedium --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 
'ImageURLMedium', productinfoARRAY.details[i].ImageURLMedium)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert ImageURLLarge --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 
'ImageURLLarge', productinfoARRAY.details[i].ImageURLLarge)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert ProductName --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 
'ProductName', productinfoARRAY.details[i].ProductName)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert Authors --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 'Authors', 
ArrayToList(productinfoARRAY.details[i].authors))>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert Artists --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 'Authors', 
ArrayToList(productinfoARRAY.details[i].artists))>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert Media --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 'Media', 
productinfoARRAY.details[i].Media)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert Manufacturer --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 
'Manufacturer', productinfoARRAY.details[i].Manufacturer)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert ReleaseDate --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 
'ReleaseDate', productinfoARRAY.details[i].ReleaseDate)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        <!--- Insert Asin --->
                        <cftry>
                                <cfset QuerySetCell(amazonSELECT, 'Asin', 
productinfoARRAY.details[i].Asin)>
                        <cfcatch></cfcatch>
                        </cftry>
                        
                        
                        
                </cfloop>


>Ok, I removed the timeout and received a response. But, I tried to 
>cfdump "productinfoArray" and received a list of java methods instead. 
>How do I properly parse my return? (never really worked a web service 
>before that returned more than a basic string)
>
>Cutter
>
>
>Brian Kotek wrote:
>
>>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212304
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to