Quote:
Originally Posted by andrwleong
Hey all
Dunno if you go on the other forum pages so if not hey 
Right firsly I am doing a dissertation creating a e-commerce website usuing Access Database and Dreamweaver MX. The website is only a prototype so it doesnt need to fully work but does need the quailty of a well designed website.
To be honest I am sooo new to this and have little knowledge.
I am looking for some one to point me in the right direction or to tell me how to
1) Connect a Access Database to Dreamweaver MX
2) Insert the right code in tables to pull only the required record and record data necessary.
3) Or do you think I should abandon it and convert my Access Database into SQL and try using PHP? |
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...