It is not possible to fully address your question with the information
which you provide. That said, the number one gotcha in converting asp to
cf is refusing to believe how simple it is.
In general, unless you are nesting result sets, you want to loop through
the results using <cfoutput query="foo">This result line is
#bar#.<br></cfquery>, or something like that.
At 10:35 AM 9/13/2001 -0400, you wrote:
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
