effpee
asked on
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
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
ASKER
Hi, I really appreciate your help, but I'm hoping that maybe someone alse will have something to add...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> 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)