Access database, Dreamweaver and a noob

andrwleong · Mar 17th, 2008, 20:13

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.

Or do you think I should abandon it and convert my Access Database into SQL and try usuing PHP?

dab42pat · Mar 17th, 2008, 21:45

This is only personal preference but PHP/Mysql and apache was easier to work with than ASP.NET

Pat

andrwleong · Mar 18th, 2008, 07:28

Quote:

Originally Posted by dab42pat

This is only personal preference but PHP/Mysql and apache was easier to work with than ASP.NET

Pat

cool so I have been hearing.

Am more worried about pulling the information from my database. Rather than list all records and fields in a table I will be wanting to pull out select records and select details about that record. Is that easy to do?

frinkky · Mar 18th, 2008, 08:03

With an Access db you'll be (usually) using asp, not asp.net. It seems this dissertation would only succeed if you were discussing how technology changes and this is the 'old school'. Of course you'd then need need to conduct experiments with the more usual php/mysql(or ms sql) and then asp.net (which is awesome in the right hands). At best you may be able to export sql statements from access to provide a basis for other db's.

The way I see it: asp/access = home novice. php/mysql = novice/designer/developer. asp.net/* sql = developer.

robbied72 · Mar 18th, 2008, 08:32

Quote:

Originally Posted by frinkky

The way I see it: asp/access = home novice. php/mysql = novice/designer/developer. asp.net/* sql = developer.

Your claims of ASP are quite outrageous, I have been developing on the platform for 10 years and am the Web Manager of a Local Authority and we run a load of applications using ASP/SQL Server including Multilingual CMS's CRM and a host of other back office and forward facing apps.

Monie · Mar 18th, 2008, 08:37

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...

frinkky · Mar 18th, 2008, 09:24

Quote:

Originally Posted by robbied72

Your claims of ASP are quite outrageous, I have been developing on the platform for 10 years and am the Web Manager of a Local Authority and we run a load of applications using ASP/SQL Server including Multilingual CMS's CRM and a host of other back office and forward facing apps.

Always going to p1ss someone off. Perhaps I should have elaborated; I'm a designer not a developer so my experience is limited although not non-existent. Remember the days of having to 'replicate'? Those were my access days, maybe thats why I moved in another direction. By the way, I didn't mention asp/sql.

But kudos to Monie, keeping this on track

andrwleong · Mar 18th, 2008, 09:37

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.

robbied72 · Mar 18th, 2008, 09:47

Quote:

Originally Posted by frinkky

Always going to p1ss someone off. Perhaps I should have elaborated; I'm a designer not a developer so my experience is limited although not non-existent. Remember the days of having to 'replicate'? Those were my access days, maybe thats why I moved in another direction. By the way, I didn't mention asp/sql.

But kudos to Monie, keeping this on track

Hi Frinkky, Yes you are right that you didn't mention ASP/SQL but there is not a great deal of difference in the programming methods for Access / SQL.

I just didn't want nobody to get the wrong idea about ASP.

Additionally, I likewise commend Monie for keeping on track.

Monie · Mar 18th, 2008, 10:37

Quote:

Originally Posted by andrwleong

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?

Answer:
What I really mean was.. I keep my database/data in ACCESS or MySQL and use Dreamweaver as my text editor and connect them using a manual hard coded code to connect my ASP or PHP page to my database

Sorry if this confuse you. If it does, please let me know, ok?
Cheers...

Understanding Answer 2

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?

Answer:
"SELECT picture, name, age, status FROM Tablename WHERE status = Married"

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.

Answer:
"SELECT picture, name, age, status FROM Tablename WHERE status = 'Married' and Username = 'John'"

Does this what you are looking for mate?
Please let me know..

andrwleong · Mar 18th, 2008, 12:50

Quote:

Originally Posted by Monie

Does this what you are looking for mate?
Please let me know..

awww thanks mate that is great.

"SELECT picture, name, age, status FROM Tablename WHERE status = 'Married' and Username = 'John'"

Would i identify this usuing ID rather than name incase more than one person is called john.

once this information is pulled am I okay to select where I want to put it in tables?

Thank you so much for taking the time to do this for me

Monie · Mar 18th, 2008, 13:22

Yeah sure, you can use ID instead of the Username

and you can place them anywhere you want in your table... <%=rs("picture")%>

Cheers...

Monie · Mar 18th, 2008, 13:29

Quote:

Originally Posted by robbied72

Hi Frinkky, Yes you are right that you didn't mention ASP/SQL but there is not a great deal of difference in the programming methods for Access / SQL.

I just didn't want nobody to get the wrong idea about ASP.

Additionally, I likewise commend Monie for keeping on track.

I still think that ASP is a great language other that it is easy to understand (English-Like-Language) compare to PHP which is much more technical to understand what's the meaning of a certain line of code unless you have a basic C programming knowledge...

ASP can achieve what PHP can do! It all depends on how good you are in programming world. About the database, I agree ACCESS is for begineer and MySQL is for advance user

Cheers...