Yes, that returns all the keys, but the problem is, is that CF_QueryToStruct creates one structure full of the key you sent when calling the tag, then it creates another structure for each key containing all the other selection criteria.
So I have to try and get out the values from these nested structures, a bit tricky...... Any ideas that may help?? Stephen Adams Forvus 53 Clapham Common South Side, London, SW4 9BX http://www.forvus.co.uk -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 10:19 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] using custom tag CF_QueryToStruct You tried... <cfloop collection="#ChildDetails#" item="cDetails"> -----Original Message----- From: Stephen Adams [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 10:01 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] using custom tag CF_QueryToStruct When I do this I get "YES" so its definitely a structure, so the problem is my loop. Best hit the books then. Stephen Adams Forvus 53 Clapham Common South Side, London, SW4 9BX http://www.forvus.co.uk -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 09:45 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] using custom tag CF_QueryToStruct Erm.... Try running: #IsStruct(ChildDetails)# And see what it gives you.... -----Original Message----- From: Stephen Adams [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 09:30 To: 'Dev Subject: [ cf-dev ] using custom tag CF_QueryToStruct Hi, Has anyone used CF_QueryToStruct, and if so can you loop through the structure it returns. I have tried but I get an error telling me that: "Error Diagnostic Information Loop error Invalid collection "ChildDetails" - must be a valid struct or COM object" This is my code: <cfquery name="GetChildDetails" datasource="#attributes.DSN#"> SELECT DownloadID, ParentID, Title, DownloadFile, Section, Slot FROM #attributes.TableName# WHERE ParentID = #attributes.ParentID# AND Active = true ORDER BY DownloadID, Section, Title </cfquery> <CF_QueryToStruct queryname="GetChildDetails" r_struct="ChildDetails" Keycolumn="downloadID"> <!--- Now display results of query ---> <cfloop collection="ChildDetails" item="cDetails"> #cDetails.title# </cfloop> Or is the problem with my loop? Stephen Adams Forvus 53 Clapham Common South Side, London, SW4 9BX http://www.forvus.co.uk This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
