<cfset myquery = querynew("mycol1,mycol2")>
<cfset queryaddrow(myquery)>
<cfset querysetcell(myquery, "mycol1", "an aardvark")>
<cfset queryaddrow(myquery, 10)>
<cfloop from="2" to="11" index="i">
<cfset querysetcell(myquery, "mycol2", "value: " & i, i)>
</cfloop>
> -----Original Message-----
> From: Giles Roadnight [mailto:[EMAIL PROTECTED]]
> Sent: 20 November 2002 15:56
> To: [EMAIL PROTECTED]
> Subject: [ cf-dev ] Building queries
>
>
> Is there a way to dynamically build queries so that they can then be
> referenced like any normal database query.
>
> I pulling a load of pages from Amazon and getting all of the info by
> looping through the page. I want to then add this info to a query so I
> can easily access it later on.
>
> I am sure that I have seen some references to functions that
> add columns
> and rows to queries but I can't find them and I can't remember where I
> saw them
>
> Thanks
>
>
> Giles Roadnight
> http://giles.roadnight.name
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
