Can we see some more code, specifically what they are doing with the data
fields. The MoveNext command is the ASP way of moving through a recordset.
Something like
While Not rs.EOF
// Show fields, manipulate values, etc...
rs.MoveNext
Wend
You should be able to do exactally the same thing with a CFOUTPUT tag
referencing your query. Post some code.
Jeff Garza
Lead Developer/Webmaster
[EMAIL PROTECTED]
-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 7:36 AM
To: CF-Talk
Subject: VBS to CF
I'm looking at some vbs code and want to convert it to CF. I have most of
it, however, am not quite sure about one spot.
They use the line of code:
Set orr=DBConnect.Execute(strSQL)
DBConnect had been set to Creat connection to DB
strSQL is the name of the query that they wrote.
That makes sense to me. But then they set data fields and then to move to
the next record they use
orr.MoveNext
I'm wondering if there is an equivalent in CF. I thought a loop query would
do the trick but I'm not getting the results that I need.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
