Thanks guys
Giles Roadnight http://giles.roadnight.name -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 15:58 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Building queries <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] -- ** 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]
