ASP, SQL books

[Ben]

Being a beginner at ASP and SQL Im constantly looking for new resources
of information that I will be able to learn from, what are some of the
good books/websites that you guys use?

So far I have:
1)SAMS Teach Yourself SQL in 21 days
2)ASP Programmer for the absolute programmer
3)Dreamweaver MX 2004 with asp, coldfucion and php
training from the source
4)Designing with Web Standards
5)Beginning Active Server Pages 3.0 (wrox)

I think all of these are great books (except for 2, it's to basic); are
there any books that you thought were great/useful?

-=Ben
-=To email me take out the joke.

 

[Bullschmidt]

Here is something I put together about ASP that hopefully might help
somehow.

You and others can have access to a database hosted on the Web from any
location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do
work in various locations in or outside the office and still be
"plugged" in.

For example you could have employees enter timesheets or have sales reps
log their contacts. Or perhaps you'd like customers to be able to check
the status of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a
database such as Access or MySQL (basically just consisting of tables)
would be put on the Web.

Then "dynamic" Web pages (actually ASP pages which include VBScript,
HTML, and/or JavaScript) would be created acting like the old desktop
database's queries, forms, and reports to access the database - all
hosted on a Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages. But
they are "live" because the user can read from and write to information
in the database. An example where you can login and add, edit, or view
fictional customers and invoices is at
http://www.bullschmidt.com/login.asp

Not all Web hosts will handle dynamic Web pages but many do. The Web
hosts that can handle ASP pages usually have a Windows 2000 or Windows
2003 operating system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - http://www.asp101.com/samples
o W3Schools ASP Tutorial - http://www.w3schools.com/asp
o Microsoft VBScript Language Reference -
http://msdn.microsoft.com/scripting/default.htm?/scripting/VBScript/doc/
vbscripttoc.htm

And the following newsgroup is good:
microsoft.public.inetserver.asp.general

Or for a "quick and dirty" generic ASP open source solution to putting
databases on the Web that just requires setting up a configuration page
for each table or query and uploading the database to the Web as long as
there is an autonumber field in each table (and you'll probably also
separately want to create login capabilities), perhaps try something
like this:
GenericDB by Eli Robillard
http://www.genericdb.com and then click on the Tips link to see an
example

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...