Professional Web Applications Themes

Need to retrieve records - Macromedia Dreamweaver

In the recordset that retrieves the data, add the form variable that the user is inputting as a filter. -- Mike ------------------- Michael Langner Macromedia Technical Support [email]supportinfomacromedia.com[/email] 1-415-252-9080 test guy wrote: > So I'm using VBScript/ASP with an Access database... I need to have a > webform field where the user can enter a unique ID, and it retrieves that > record to the ASP page... anyone know how I can do this? I tried but the > form always retrieves the first record in the table, as opposed to the > record whose ID matches the user input... ...

  1. #1

    Default Re: Need to retrieve records

    In the recordset that retrieves the data, add the form variable that the
    user is inputting as a filter.

    -- Mike

    -------------------
    Michael Langner
    Macromedia Technical Support
    [email]supportinfomacromedia.com[/email]
    1-415-252-9080

    test guy wrote:
    > So I'm using VBScript/ASP with an Access database... I need to have a
    > webform field where the user can enter a unique ID, and it retrieves that
    > record to the ASP page... anyone know how I can do this? I tried but the
    > form always retrieves the first record in the table, as opposed to the
    > record whose ID matches the user input...
    > Thanks!
    >
    >
    --


    MLangner-MMTS Guest

  2. #2

    Default Re: Need to retrieve records

    Let me tell you what I've done so far... (per DMX Help files)...
    1.) Build a search page with a form using GET to an ASP page...
    2.) On the results page, I'm building a recordset (Access) filtering the
    unique ID (search parameter submitted from previous page) = URL Parameter
    and naming the search form's field name.

    When I search on a known valid unique ID, I get the error back that
    basically tells me the dataset is empty. I need to figure out why my dataset
    is being returned empty. I know that data is valid, I can see it in the
    database!!!!


    Adrian Leontovich Guest

  3. #3

    Default Re: Need to retrieve records

    OK... datatype is autonumber... DMX SQL is as follows:

    SELECT *
    FROM control
    WHERE ID = MMColParam

    Variables:
    MMColParam runtime param=Request.QueryString("ID")

    where ID is the name of the autonumbering field that is being retrieved.
    Works fine by itself if I run the TEST function from the Recordset
    dialogue.. it just doesn't seem to be pulling the data on the page itself..

    "Ron" <ron0079spamaol.com> wrote in message
    news:beptb3$dpe$1forums.macromedia.com...
    > What datatype is the unique ID? Paste your sql here also.
    >
    > --
    > Ron
    >
    >

    Adrian Leontovich Guest

Similar Threads

  1. Two Function Calls to a Database to Retrieve the UniqueID of Inserted Records
    By rycbn in forum Coldfusion - Advanced Techniques
    Replies: 11
    Last Post: July 14th, 08:22 AM
  2. Retrieve URL from DB
    By coryd218 in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 6th, 02:38 PM
  3. Retrieve n records from database
    By Sean Berry in forum Macromedia Flash
    Replies: 1
    Last Post: January 18th, 03:11 AM
  4. How to retrieve the records if I have .SQL script file using ADO.net
    By Kiran in forum ASP.NET Data Grid Control
    Replies: 4
    Last Post: October 14th, 08:38 PM
  5. retrieve *.jpg
    By ma in forum Microsoft Access
    Replies: 0
    Last Post: August 4th, 04:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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