how to recreate MS Access data access page functionality in dreamweaver

Hello

I'm trying to create something like data access page from MS Access in dreamweaver. All I need is:

1. connection to sql database
2. tabular representation of my data (10 records on page, record pages navigation)
3. ability to edit, delete, create record
4. sorting by clicking on column header
5. filtering by multiple selections (and a button to disable filtering)

also

whats the best way to put two tables which are getting data from two different sql sources on one page and have them working independent?

Thanks
effpeeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineDon't talk to me.Commented:
Hi effpee,

>> 1. connection to sql database

DW has a Connection Wizard located in the Bindings Panel.  Use it to create connections to databases.  Also, make sure a testing server is defined for the site.

>> 2. tabular representation of my data (10 records on page, record pages navigation)

Create a Recordset from the Bindings panel.  Then, add a two row table to the page and populate the second row with the fields from the the recordset.  Next, select the <tr> tag for that row and apply the Repeat Region behavior from the Server Behaviors panel.  Tell it to return 10 records at a time.  Finally, add the Recordset Navigation bar from the Data tab (located on the Insert panel).

>> 3. ability to edit, delete, create record

Make sure one of the rows in the recordset is the primary key.  You would then create an edit page with a form and a delete page.  Pass the primary key to each page via the URL and use it to create a new, filtered recordset.

For the edit page, create a form that matches the table and bind the recordset values to the form fields.  Then, apply the Update Record behavior.  For the delete page, just apply the Delete Record behavior to the page.  The insert page can be a copy of the edit page minus the recordset.  Just apply the Insert Record behavior to the form.

>> 4. sorting by clicking on column header
>> 5. filtering by multiple selections (and a button to disable filtering)

These two are not supported in the base installation of Dreamweaver which means that there is no wizard-based behavior that you can apply to make life easy.  However, numerous extensions exist to handle this.  If this is DW CS3 and you registered the copy, you should be able to download the Dreamweaver Developer's Toolkit which contains a bunch of advanced options including Wizards for the both of the above.

Alternately, you can use Spry to achieve some of this but you need to be able to output your recordsets as XML.




3. ability to edit, delete, create record
4. sorting by clicking on column header
5. filtering by multiple selections (and a button to disable filtering)
0
effpeeAuthor Commented:
Hi, I really appreciate your help, but I'm hoping that maybe someone alse will have something to add...
0
Jason C. LevineDon't talk to me.Commented:
What more are you looking for?  I've recommended some commercial add-ons to DW in your other question that will create what you are after.

If you are going to develop ASP.NET, you might want to look into Expression Web instead of DW.  DW is focused on PHP or ColdFusion developers at this point.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.