Skip to main content
Participant
August 1, 2007
Question

Building search results in ASP

  • August 1, 2007
  • 3 replies
  • 248 views
Im trying to create an update page to update records in a database.

My first step is creating the search pages, and im using a menu single search parameter to list references from a database column, using the GET method. This works ok.

Then I create a results page with a new recordset filtering the reference as a url parameter. When I test it, all i get is a table with the titles but no results displaying.

Without completing these steps I am unable to create the update record page.

I have been following the Dreamweaver 8 user guide from page 847, after which I will do the updates from page 940.

If anyone could enlighten me I would be most grateful.

Thanks in Advance,

Peter.
This topic has been closed for replies.

3 replies

Inspiring
August 1, 2007
That's a clue that you're not filtering correctly. Without seeing your code
.. both the code for the variable and the recordset on the next page and
probably the update, it's pretty hard to help.


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"marketingyard" <webforumsuser@macromedia.com> wrote in message
news:f8qd9v$34p$1@forums.macromedia.com...
>I did manage to get the result passed using the master detail pages I
> previously used as a record search & renaming them, but when I try to send
> the
> detail info to an update page, it updates the first record in my database,
> regardless of which record I select.
>
> What I want it to do is update the record searched for.
>


Participant
August 1, 2007
I did manage to get the result passed using the master detail pages I previously used as a record search & renaming them, but when I try to send the detail info to an update page, it updates the first record in my database, regardless of which record I select.

What I want it to do is update the record searched for.
Inspiring
August 1, 2007
Can you post the recordset query from the second page?


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"marketingyard" <webforumsuser@macromedia.com> wrote in message
news:f8q5fm$n2i$1@forums.macromedia.com...
> Im trying to create an update page to update records in a database.
>
> My first step is creating the search pages, and im using a menu single
> search
> parameter to list references from a database column, using the GET method.
> This
> works ok.
>
> Then I create a results page with a new recordset filtering the reference
> as a
> url parameter. When I test it, all i get is a table with the titles but no
> results displaying.
>
> Without completing these steps I am unable to create the update record
> page.
>
> I have been following the Dreamweaver 8 user guide from page 847, after
> which
> I will do the updates from page 940.
>
> If anyone could enlighten me I would be most grateful.
>
> Thanks in Advance,
>
> Peter.
>
>