updatable fields 2

[mikemetson]

i wan't to know how to create a dynamic field within dreamweaver mx 2004. I woould like to be able to create a field as part of a program, and as my information changes i would like to simply type in the new info, and it automatically save, please help

 

[Cheech]

dynamic field = data taken from a database therefore store your info in a database and update that

Cheech

[Peace][Pipe]

 

[mikemetson]

Thanks, is there a good website that has a walk through for setting up a database and linking it to a set of fields?

 

[dodge20]

Depends on what type of page and what type of database you use. I like asp with access database.

Setup your site in Dreamweaver
Open or create a new ASP page.
Expand the Application panel and select the Databases tab.
To use a DSN-less connection (recommended):

4a. Click on the add (+) button and select Custom Connection String
5a. In the Custom Connection String window, enter a Connection name.
6a. Enter the following in the Connection string textbox:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Path to Database]"

7a. Select 'Using Driver on Testing Server'
8a. Click on the Test button to test the connection. Once successful, click OK.

To use a DSN that you created using the Access ODBC Tool in the control panel:

4b. Click on the add (+) button and select Data Source Name (DSN).
5b. Enter a connection name.
6b. In the DSN textbox, enter the DSN you created in the control panel.
7b. If you set a database password or user accounts within the Access database, enter the credentials in the User Name and Password textboxes. (This is not related to any password protection set using the Permission Manager in the control panel.)
8b. Select 'Using DSN on Testing Server'.
9b. Click on the Test button to test the connection. Once successful, click OK.

You can now use the database connection in the Dreamweaver wizards when inserting recordsets or query results.

Note: Dreamweaver will upload scripts to your site to test the database connection. For security purposes, Macromedia recommends removing these connection scripts once your site has been deployed. Click on Site menu, Advanced, Remove Connection Scripts.


Dodge20

 

[mikemetson]

thanks a lot dodge

 

[dodge20]

I forgot to mention this also depends on your webserver. What type do you have?
Also it will probably be easier for you to use the second method i suggested above. (To use a DSN that you created using the Access ODBC Tool in the control panel


It can be confusing setting up the connections manually.

Dodge20

 

[mikemetson]

er not sure, am a real amateur to database integration. But i gives me a lead to start with, i'm sure i can have a good bash at it now, thanks

 

[Cheech]

try having a look at Ultradevguru.com his connection tuts are pretty good even if a little dated

Cheech

[Peace][Pipe]