Im a relative newbie in using ASP and SQL, and have been making web pages using office XP, which mainly involves making the front end on Frontpage and the back end on microsoft access. When using a database with FP, you have your set amount of options blah blah about connecting to a database etc. This involves the use of frontpage extensions
I do not want to be relying on frontpage extensions
Basically, my goal is to use only the information required to access a db, as opposed to using all the junk that MS products create
So I have acquired a book "learn SQL in three days" which seems pretty handy. It has stuff on a CD included like "SQL talk".
Im wondering if such software would be an adequate replacement from my previous setup.
i.e. if you are setting up a db from scratch, what are the minimum tools needed? As Im sure some of you understand, the MS products I am using give you an idea of whats involved, but do not spell it out as such that I could create an accessable db from scratch
To give you an idea of what Im looking for, one db i use is simple, its a dictionary. You search for a term, and if the term matches, its displayed along with a description.
So instead of using MS products, I want to be reduced to using notepad.....or the bare requirements of setting up web pages that can successfully access/edit a database
Its a long road to go down....Im looking for a good send off here with some tips/assistance
Info on this would be great, of google update proportions ;)
Richard
Download a free copy of Dreamweaver ultraDev and take the tutorial. Use it for 30 days to build your first ASP pages.
Then, when it expires, go through the generated code and see what is really needed. Dreamweaver tends to be very precise - overly so in some instances - but you'll be able to figure it out.
As for creating the DB through SQL, that's not a good idea in a web interface.
A free DB is mySQL and you can get the GUI mySQL-Front which will show you the SQL commands while you GUI.
Beyond that, take a look at:
[w3schools.com...]
for an excellent SQL tutorial.
But for a beginner, Dreamweaver will lay a solid foundation of good techniques. Within a short time you won't need it to generate the code for you.
thanks tx for the pointer, i want to learn the techniques as you say, without the fluff of frontpage.
the ASP tutorial, great. Learning the syntax of SQL is hand in hand really isnt it? So ill be looking up on both, with the help of WMW
Cheers!
Like txbakers said w3schools.com is a great resource too. If you are trying to start learning now I would consider learning .net. Classic asp tutorials are going the way of the dinosuar.
I suggest you start using homesite for your editor. It will help kick frontpage. Notepad offers nothing. Homesite is a wonderful coding app.
I would suggest using access while you learn. Most asp samples use it. You can move on when you learn the basics. Access is a very simple database and it sounds like you already have it.
