Dreamweaver Database Query
Using dreamweaver to show database table data.
Create recordset
1. Select Bindings tab in Application panel (ensure you have already created database connection (see dreamweaver database setup))
2. Click +, then select Recordset, to open recordset dialog box
3. enter name for recordset, eg. rsShowUsers
4. select connection (should already be created), eg. connTest
5. select table (this is the table you wish to query), eg. user
6. click Test (if recordset is created properly, then it should display Test SQL Statement screen, showing data returned from query), and click OK
7. click OK again, to confirm creation of new recordset
Insert table to contain dynamic fields
1. select Insert > Table, to open Table dialog box
2. enter 1 for Rows, 2 for Columns, and click OK, to create a table with 1 row and 2 columns
Set dynamic fields in table
1. click + sign beside new recordset, to ‘open’ it, to reveal fields associated with the recordset
2. drag and drop one of these dynamic fields, eg. username, onto the first column of the row
3. drag and drop one of these dynamic fields, eg. passwd, onto the second column of the row
Show all records of a recordset
1. select row containing the two dynamic fields
2. select Server Behaviors tab, in Application panel
3. click + sign, and select Repeat Region
4. select All records option
5. click OK
Show database data directly in dreamweaver
1. click live data view
Comments »
No comments yet.
RSS feed for comments on this post.