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?
 
Jason C. LevineConnect With a Mentor No oneCommented:
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
 
Jason C. LevineNo oneCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.