Hi,

I'm having real problems trying to build an Update Record page in Dreamweaver
CS3. I'm using Windows XP Pro, my PC as a testing Server, IIS and an Access
Database. I have a Search page, a Results page and an Update page. The search
page displays results OK in the Results page. Now I need to allow people to
select a record from the results page and update it in the Update page. I tried
to follow the instructions provided by Dreamweaver but I'm even more confused
than when I started! I'm really confused by the Filter options for the
Recordsets. Can anyone explain to me in English what to type into the 'Record
Update Form Wizard' and the recordsets on all 3 pages to make this thing work?
I will be so grateful for any , I really feel like throwing my laptop
against the wall!

Cheers,

Red :smile;

The following are ColdFusion examples.

The search page would not have a recordset.

The results page should look something like this:

SELECT ARTISTID, FIRSTNAME, LASTNAME
FROM APP.ARTISTS
WHERE LASTNAME LIKE %#FORM.LASTNAME#%

The % are wildcards and the # are for ColdFusion.

The link to the update page would look like this:

<a href="update.cfm?ARTISTID=#rsResults.ARTISTID#">up date</a>

The update page would look something like this:

SELECT *
FROM APP.ARTISTS
WHERE ARTISTID = #URL.ARTISTID#

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com


"Red_innocence666" <webforumsuser@macromedia.com> wrote in message
news:fps54p$c84$1@forums.macromedia.com...
> Hi,
>
> I'm having real problems trying to build an Update Record page in
> Dreamweaver
> CS3. I'm using Windows XP Pro, my PC as a testing Server, IIS and an
> Access
> Database. I have a Search page, a Results page and an Update page. The
> search
> page displays results OK in the Results page. Now I need to allow people
> to
> select a record from the results page and update it in the Update page. I
> tried
> to follow the instructions provided by Dreamweaver but I'm even more
> confused
> than when I started! I'm really confused by the Filter options for the
> Recordsets. Can anyone explain to me in English what to type into the
> 'Record
> Update Form Wizard' and the recordsets on all 3 pages to make this thing
> work?
> I will be so grateful for any , I really feel like throwing my laptop
> against the wall!
>
> Cheers,
>
> Red :smile;
>