Select Statement

Results 1 to 2 of 2

Thread: Select Statement

  1. #1
    Join Date
    Dec 1969

    Default Select Statement

    Can anyone tell me what is wrong with this select statement.<BR><BR>Set rs = Server.CreateObject("ADODB.Connection")<BR> DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\....mdb"<BR> Session.timeout = 3<BR> Set Conn=rs<BR><BR> sql = "SELECT * FROM Archive ORDER BY Year, Month" <BR> Set rs = Server.CreateObject("ADODB.Recordset")<BR> rs.Open sql, conn, 3, 3

  2. #2
    Join Date
    Dec 1969

    Default RE: Select Statement

    For one thing, Shawn, you are setting two different objects to the same name (rs).<BR><BR>What error messages are you getting?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts