Think of the orr.Next as a counter, VB doesn't (and this is off the toip
of my head) allow Recordsets to be returned in one hit, and you need to
use the cursor to move between rows.
So in that case instead of this:
Set orr=DBConnect.Execute(strSQL)
You do this:-
Cfquery name="QueryName" datasource="">
Sql goes here.....
/cfquery
Then doing cfoutput query="QueryName" or using cfloop to go through the
returned records!!
Regards,
Andrew Scott
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 September 2001 1:25 AM
To: CF-Talk
Subject: RE: 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.
There is no direct analog to this in CF, because querying databases and
looping over recordsets is handled instead using CFQUERY and CFOUTPUT,
which
is a bit simpler than the way you'd do it with ADO in ASP. CF, unlike
VBS in
ASP, doesn't provide objects with methods (such as the Recordset object
with
its MoveNext method).
If you wanted to build something as similar in CF to your VBS/ASP code,
you
could use a loop within a CFSCRIPT block, although that wouldn't be an
exact
analog either:
<cfquery name="qFoo" ...>
SELECT field1, field2 ...
</cfquery>
<table>
<cfscript>
for (i = 1; i lte qFoo.RecordCount; i = i + 1) {
WriteOutput("<tr>");
WriteOutput("<td>" & qFoo.field1[i] & "</td>");
WriteOutput("<td>" & qFoo.field2[i] & "</td>");
WriteOutput("</tr>");
}
</cfscript>
</table>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
