The forums have permanently moved to This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.

Results 1 to 3 of 3

Thread: ASP newb question

  1. #1

    ASP newb question

    im somewhat a newb to ASP.

    I have stuff loaded from a database, and i want to insert it in my page where i want it

    say i have a column called "users" loaded. how would i make it load into the page. all i have is.

     Set Conn = Server.CreateObject("ADODB.Connection")
    Conn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("news/news.mdb")
    GI = "SELECT TOP " & updates & " id, date, title, body, user FROM updates ORDER BY date DESC;"
    (just ignore all the other columns)

    what would i use to be able to insert into my page?

    Thanks for any help

  2. #2
    what you need to do is set the SQL statement into a recordset, like so

    set RS = Conn.Execute("SELECT * FROM Users")
    This should return a recordset and you can use that to display the details in your page.

    Good site to find out more is, or

    hope this helps
    Last edited by RabBell; March 1st, 2005 at 11:14 AM.
    now with blog, click here

  3. #3
    ohhhh, i think i somewhat get it, haha.

    thanks for helping out a newb


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

Home About Meet the Moderators Advertise

 Link to Us


Copyright 1999 - 2012