RE: What is a Query Result Set look like? (tds)
Hi, A query result set is just that - its own fully unique object of type query result set, just as arrays, structures, and strings are their own different datatypes. There are, however, certain functions to build a query object yourself, such as QueryNew, QueryAddRow, QueryAddColumn, and QuerySetCell that you could use to build your own query. -Brent -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 8:20 AM To: CF-Talk Subject: What is a Query Result Set look like? (tds) What does a ColdFusion Query Result Set look like? Is it an array, a structure, or something else? I have a collection of information that I would like to put into a Query Result Set and use the CFOUTPUT tag to spit out the results. Any Idea would be greatly appreciated. Thanks for the help. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What is a Query Result Set look like? (tds)
What does a ColdFusion Query Result Set look like? Is it an array, a structure, or something else? I have a collection of information that I would like to put into a Query Result Set and use the CFOUTPUT tag to spit out the results. Any Idea would be greatly appreciated. Thanks for the help. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What is a Query Result Set look like? (tds)
Internally to CF it is a Query datatype. It actually looks like a structure of equal length arrays. For example, a query with the columns name, age that has 5 rows will look like a structure with the key name and the key age and each key will have an array in it of length 5. This is why using the targeted method of getting a query item (queryname.name[3]) looks exactly like getting an array item that's contained in a structure. queryname (structure) name (structure key) row1 (array item) row2 (array item) row3 (array item) row4 (array item) row5 (array item) Age (structure key) row1 (array item) row2 (array item) row3 (array item) row4 (array item) row5 (array item) At 11:19 AM 8/17/01, you wrote: What does a ColdFusion Query Result Set look like? Is it an array, a structure, or something else? I have a collection of information that I would like to put into a Query Result Set and use the CFOUTPUT tag to spit out the results. Any Idea would be greatly appreciated. Thanks for the help. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists