SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Bringing SQL to the web
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sktrdie
Starting Member

16 Posts

Posted - 09/21/2005 :  03:48:04  Show Profile
Hello,
I basically have a table in my SQL server full of information. What I want is to bring all that info to be displayed also on my website.
Being able to connect it from me html page, or php page, whatever, also ASP.
Can anyone help me with this, thnx.

madhivanan
Premature Yak Congratulator

India
22754 Posts

Posted - 09/21/2005 :  04:10:45  Show Profile  Send madhivanan a Yahoo! Message
Refer http://www.connectionstrings.com for how to connect to SQL Server from ASP
Use Recordset to capture data and using While loop display them in the format you want

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sktrdie
Starting Member

16 Posts

Posted - 09/21/2005 :  09:41:18  Show Profile
I don't know how to make SQL code work inside of ASP.
I tried it with php and sounds really easy, but since this stuff is using asp I really don't know.
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22754 Posts

Posted - 09/21/2005 :  09:51:50  Show Profile  Send madhivanan a Yahoo! Message
Then you need to refer some ASP sites

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sktrdie
Starting Member

16 Posts

Posted - 09/21/2005 :  09:53:32  Show Profile
but it's still sql stuff, i just need to know ther right integration with asp.
If I go to asp sites they will tell me it's a sql matter, so im stuck.
pleas
Go to Top of Page

AndrewMurphy
Flowing Fount of Yak Knowledge

Ireland
2916 Posts

Posted - 09/21/2005 :  09:58:55  Show Profile
1. write the SQL code to collect the data you want.
2. use the connection string stuff to enable your asp to connect to the specific server type.
3. execute a call to the sql code (1)...either saved as a SQL SP or as in-line code (not advised)
4. use asp logic to loop through returned data from (3)....

you've to mix both worlds...we can only supply 1. buying/reading a book/attending classes is also a good starting point.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 09/21/2005 :  10:01:52  Show Profile
Call stored procedures from asp and make your life much easier....



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

sktrdie
Starting Member

16 Posts

Posted - 09/21/2005 :  10:02:05  Show Profile
the problem is the syntax, I don't know the syntax that you need to apply with sql
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22754 Posts

Posted - 09/21/2005 :  10:06:46  Show Profile  Send madhivanan a Yahoo! Message
Can you post the syntax with which you are getting errors?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000