Executing an SQL View from ASP

arnniema · August 22nd, 2005, 10:26 AM

Can some assist me with a sample code on how can I execute an SQL View from an ASP Form?

arnniema

rweide · August 30th, 2005, 08:23 AM

Something like this,

Code:

   Set adoCnn = CreateObject ("ADODB.Connection")
    adoCnn.ConnectionString = your connection string here.
    adoCnn.Open
    Set rs = CreateObject ("ADODB.Recordset")
    sSQL = "SELECT xxx FROM yourview"   
    rs.Open sSQL, adoCnn

arnniema · August 31st, 2005, 01:16 PM

Thank you!!!

arnniema