The forums have permanently moved to forum.kirupa.com. 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.


    Code:
     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
    -Naaman

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

    Code:
    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 http://www.asp101.com/, http://www.w3schools.com or http://www.asptutorial.info/

    hope this helps
    now with blog, click here

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

    thanks for helping out a newb

    -Naaman

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 kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012