Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-14 : 09:24:36
|
| Gaven writes "I am trying to set up a bookstore for a genealogy library and I would like to know how I can create a web page that has a search fiels on it. This field will then search a SQL database (that I have already) and display the results alot like Amazon.com does with the book image showing and other relevant information about the book.I have looked at http://www.gotocode.com/apps.asp?app_id=3 and this is the sort of style I would like. However I cannot understand how to use a SQL database with this type of code, and how to put it on my IPS's server.Can anyone help me?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-14 : 18:30:51
|
| HiThe easiest way to interface a web site with SQL Server is using Active Server Pages (ASP). Go over to www.4guysfromrolla.com for some great beginner lessons on ASP.As for the ISP, your ISP will need to provide SQL Server hosting, you generally have to pay a little more for it, but it shouldn't take you too long to find one.Hope that helpsDamian |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-03-14 : 19:20:22
|
| At the risk of trying to pimp a hosting site, I've used brinkster.com in the past and had good success. They provide ASP with SQL hosting for pretty cheap. They have some nice info on their website too. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-14 : 19:41:40
|
| if there is going to be any pimping going on......If you are after a serious host, look at Orcsweb, the good people that host SQLTeam.They rock!DamianEdited by - merkin on 03/14/2002 19:42:58 |
|
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-03-14 : 20:05:32
|
| I just took a look at the ASP/VB code and it looks pretty straight forward to set it up with a SQL backend, or even Access if your ISP doesnt support SQL. They have even scripted the table creations for you, if you are to use the SQL version.Download the code and follow the instructions within Readme-ASP.txtFrom the looks of it just unzip it into your website directory, and modify the common.asp file to use the appropriate connection string.Look at http://www.4guysfromrolla.com to see example connection strings for SQL and Access |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-15 : 13:10:06
|
quote:
if there is going to be any pimping going on......
Look out Rob, Merkin is getting in on the Pimping scene. Watch your territory! Merkin: "OrcsWeb Pimp".------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
SQL database Catalog