get url from database?

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default get url from database?

    i have a datbase file set up and each item has specific information for each
    item. each item also has a pdf file associated with it. how can i create a
    dynamic link on the page that will allow people to download the pdf file
    associated with the item.
    i am using dreamweaver and access with asp.net.

    thanks



    acidrain9 Guest

  2. Similar Questions and Discussions

    1. MySQL Database not retrieving the full database
      Hi, I am using MySQL and PHP for my repository. It has 500+ records. till now it was displayiing all records in the database, but since from one...
    2. Import Data from flat-database to relational-database
      Before I start I need some tips and pleas excuse my bad english. I have two databases, one is flat and one is a relational database. example ...
    3. NEWBIE HELP Import Data from flat-database to relational-database
      I want to import Data from a simple Database, which contains all Information in one big record into a relational Database and split up the big...
    4. Passing database info to page allow user input then pass into another database
      Hi I really am going crazy! I'm using VBScript, ASP, and SQL My page reminds me of a shopping cart but looking at shopping cart examples has not...
    5. Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database;
      Hi, I am testing a trigger that and I am getting this error message saying "Another user has modified the contents of this table or view; the...
  3. #2

    Default Re: get url from database?

    > i have a datbase file set up and each item has specific information for
    each
    > item. each item also has a pdf file associated with it. how can i create a
    > dynamic link on the page that will allow people to download the pdf file
    > associated with the item.
    > i am using dreamweaver and access with asp.net.
    It depends on where you store the PDF. If it something simple, like all PDF
    files are in a folder called documents/pdfs, then you can build your url
    like this:

    dim pdfLink as string
    dim pdfFilename as string = (go get the filename from the DB)
    pdfLink = "<a href='/documents/pdfs/" & pdfFilename & "'>link</a>"

    -Darrel


    darrel Guest

  4. #3

    Default Re: get url from database?

    ....Or you can save the full url of the PDF in the database, and create a link
    to it like this:
    <SCRIPT Language="VB" Runat="Server">
    Sub Page_Load(Src As Object, E As EventArgs)
    Dim LinkSRC as String
    LinkSRC = DSyourDatabase.FieldValue.("ColumnWithURL", Nothing)
    hlPDFLInk.NavigateUrl = linkSRC

    End Sub
    </SCRIPT>
    ...
    <BODY>
    <FORM Runat="Server">
    <asp:HyperLink
    NavigateURL="#"
    Text="Download My PDF"
    Target="_Blank"
    Runat ="server" />
    </FORM>
    </BODY>

    JMHooten 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