Results 1 to 2 of 2

Thread: Help with SQL query

  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unhappy Help with SQL query

    Someone Please Help!!! I have a table in my Access database that has two columns: name and url. I'm trying to develop a query that simply prints the items in the name field, but when you click on the name, that will go to the items corresponding url field. There's gotta be a way to do this without manually. Long story short, I want to link to urls, but I don't want people to see the urls. I want them to see the names.

  2. #2
    Join Date
    Aug 2002
    Posts
    21
    Something like this should work:

    SQL_query = "SELECT * FROM tablename"
    RS.Open SQL_query, conn, 3

    <a target=_new HREF='<%=RS("URL")%>'><%=RS("name")%></A>

Posting Permissions

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