Building search results in ASP

Report · Aug 01, 2007

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.

Report · Aug 01, 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.
>
>

Report · Aug 01, 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.

Report · Aug 01, 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.
>