adding a hyperlink to a field in a table created from a d/b query (Access)

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default adding a hyperlink to a field in a table created from a d/b query (Access)

    I've done this using Frontpage; and I know I've done it in the past
    using just ASP. I'm trying to stay away from FP on this site, so....

    Can someone tell me what is wrong with this?

    <td><font size="2">&nbsp;<%=rs("FILE_NUM")%><a
    href="newtest5.asp?blah2"=<%=rs("FILE_NUM") %>>"</a></font></td>

    this line loops and the FILE_NUM field is supposed to become a
    hyperlink to newtest5.asp

    I've googled and searched, and looked for my past code, but can't find
    it. I did it once also with a procedure that I modified, but I just
    want to do it without the proc.

    Thanks if you can help.

    Larry Rekow
    - - - - - - - - - - - - - - - - - -
    "Forget it, Jake. It's Chinatown."
    Larry Rekow Guest

  2. Similar Questions and Discussions

    1. sql query returned a to table in a field
      i have a table that returns information from a record set. This works fine. I have one field on the table that needs to return a query from another...
    2. Error accesing access via query created in FrontPage
      After I run IIS lockown on windows 2000 standard with IIS 5.0. My website - built using FrontePage is getting the following error when accessing...
    3. ASP / Access: use of same table twice in one query
      Hi, In a query I use the same table twice: Select u.*, ud.*, dep.*, u2.* from users as u, departments as dep, user_in_departments as ud, users...
    4. Forms Pivot Table - adding field
      I'm rather new to Access and I haven't been able to find an answer to this situation in Access Help, Access Bible or in another training guide. ...
    5. Adding a NULL Value in a Currency table in an Access DB
      Hello there, I have a problem with Adding a NULL Value in a Currency table in an Access database. The problem accurs when i'm trying to Update an...
  3. #2

    Default Re: adding a hyperlink to a field in a table created from a d/b query (Access)

    Larry Rekow wrote:
    > I've done this using Frontpage; and I know I've done it in the past
    > using just ASP. I'm trying to stay away from FP on this site, so....
    >
    > Can someone tell me what is wrong with this?
    >
    > <td><font size="2">&nbsp;<%=rs("FILE_NUM")%> <a
    > href="newtest5.asp?blah2"=<%=rs("FILE_NUM") %>>"</a></font></td>
    >
    You have unnecessary delimiters:
    <a href="newtest5.asp?blah2=<%=rs("FILE_NUM") %>></a>

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows [MVP] Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139