?
Solved

how to recreate MS Access data access page functionality in dreamweaver

Posted on 2008-11-17
3
Medium Priority
?
236 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:effpee
  • 2
3 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 22977619
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
 

Author Comment

by:effpee
ID: 22985928
Hi, I really appreciate your help, but I'm hoping that maybe someone alse will have something to add...
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 375 total points
ID: 22987442
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question