Flash/ASP problem

Out of context: Reply #3

  • Started
  • Last post
  • 8 Responses
  • Brooklyn0

    Hum, this didnt work... Here it is again :

    Set DataConn = Server.CreateObject("ADODB.Conne...
    DataConn.Open "Driver=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("tourdates.mdb")

    Set cmdTemp = Server.CreateObject("ADODB.Comma...
    Set rstContacts = Server.CreateObject("ADODB.Recor...

    cmdTemp.CommandText = "Select * From tourdates"
    cmdTemp.CommandType = 1
    Set cmdTemp.ActiveConnection = DataConn

    rstContacts.Open cmdTemp, , 1, 3

    Do while not rstContacts.eof

    Response.write "bands=" & Server.URLEncode(rstContacts("ba... & "&"

    Response.write "venue=" & Server.URLEncode(rstContacts("ve... & "&"

    Response.write "city=" & Server.URLEncode(rstContacts("ci... & "&"

    Response.write "day=" & Server.URLEncode(rstContacts("da... & "&"

    rstContacts.movenext
    loop

    rstContacts.Close
    DataConn.Close

View thread