Re: cfquery result="resultInfo"

2009-03-19 Thread Phillip Senn
This is the syntax for doing it with an array of structures: SELECT * FROM Tablename What would be the syntax for using a structure of structures? > > Q: What's the best way to return two structures from a function? > > Should I return an array of structures or can I return the > resultI

Re: cfquery result="resultInfo"

2009-03-19 Thread Dave Watts
> Q: What's the best way to return two structures from a function? > Should I return an array of structures or can I return the resultInfo in one > of the arguments > from the calling program? Well, strictly speaking, if you set the value of something within the calling program that's not return

Re: cfquery result="resultInfo"

2009-03-19 Thread Gerald Guido
>>and have already picked up a nugget. A tasty one at that. Thanx for sharing. >>Should I return an array of structures I would say yes. From what I have been reading, arrays of structures is the standard way to exchange data between platforms (Think web services). If you do it that way (arrays

cfquery result="resultInfo"

2009-03-19 Thread Phillip Senn
I am reading the cfcurriculum at http://www.adobe.com/education/instruction/teach/cfcurriculum.html and have already picked up a nugget. I didn't realize that cfquery returned two results, the name= attribute and the result= attribute. I've always just returned the query in my functions, but no