Quote:
Originally Posted by Monie
Question 1.
You don't connect a database to your Dreamweaver 
You connect your database to interact with your page ( ASP or PHP)
I know what you mean by "Connect a Access Database to Dreamweaver MX"
You are talking about the Server Behaviors function in DW right?
I am suggesting that you do a manual hand written code to connect to your database (MSSQL or MySQL). It' damn easy once you know the trick
Here is some sample..
- PHP: Select all
[MSSQL (ACCESS) Database Connection and Recordset (DNS-LESS Connection)]
<%
Dim conn, rs
set conn = Server.CreateObject("ADODB.Connection")
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM Customers WHERE status = Married", conn
%>
Question 2
As shown in the above SQL statement:
- Code: Select all
"SELECT * FROM Customers WHERE status = Married"
will only show/pull a customer information which have the status of Married!
Question 3
I have use ASP with MySQL and found it is as easy as with MSSQL.
My recommendation is to switch to PHP/MySQL.
They are a great couple!
Cheers...
|
Wooow thanks for this reply. This was very very very useful.
Could you just help me understand this more thanks.
Understanding Answer 1
From my understanding of what you wrote. I keep my Database in Access and use MySQL to get the database and dreamweaver to interact?
Understanding Answer 2
"SELECT * FROM Customers WHERE status = Married"
Thank you for this code, I assume it would create a table of all the people who were married with all the fields such as 'picture' 'personID' 'Name' 'age' 'sex' 'material status' 'etc' 'etc' 'etc' .
What am stuck on is pulling more specific detail on selected records with selected fields.
A)On the above list lets say I only wanted to pull out all the people who are 'married' but only display their picture, name, age and material status?
B) The same as above but only a specific person.
It is hard to explain but in question two. I would like the indavidual fields to show in the tables i have created in dreamweaver. I have attached a picture of an example table I would set out.