You need to execute the query first (what the VBScript execute is doing)
with:
<cfquery datasource="mydatasource">
SELECT blah from blah
</cfquery>
Then loop thru the query with a <cfoutput query> or <cfloop query>. Check
the CF docs for details.
There is no "movenext" in CF. There is no concept of a pointer to a
current record. You can look at any or all of the results at any time.
tom
www.basic-ultradev.com
"Janine Jakim" <[EMAIL PROTECTED]> wrote in message
1BEB99C913B7D411855F00B0D020F05B134006@STMS">news:1BEB99C913B7D411855F00B0D020F05B134006@STMS...
> 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.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
