You better believe it. Here's how to run get a record set from an SQL database in ASP and display it. This is one of the shortest way to write it.


Dim objConn, objRS

Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open "database"

Set objRS = objConn.Execute ("select * from table")

While Not objRS.eof
Response.Write objRS("user_namex")
objRS.Movenext
Wend

objRS.close
objConn.Close


Now in ColdFusion

<CFQUERY NAME="objRS" DATASOURCE="Database">
select * from table
</CFQUERY>

<CFOUTPUT QUERY="objRS">
#user_namex#
</CFOUTPUT>

any questions?