Bringing SQL to the web - SQL Server Forums

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.

All Forums

Old Forums

CLOSED - General SQL Server

Bringing SQL to the web

Author

Topic

sktrdie
Starting Member

16 Posts

Posted - 2005-09-21 : 03:48:04

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

22864 Posts

Posted - 2005-09-21 : 04:10:45

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

sktrdie
Starting Member

16 Posts

Posted - 2005-09-21 : 09:41:18

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.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-21 : 09:51:50

Then you need to refer some ASP sites

Madhivanan

Failing to plan is Planning to fail

sktrdie
Starting Member

16 Posts

Posted - 2005-09-21 : 09:53:32

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

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-09-21 : 09:58:55

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.

X002548
Not Just a Number

15586 Posts

Posted - 2005-09-21 : 10:01:52

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

sktrdie
Starting Member

16 Posts

Posted - 2005-09-21 : 10:02:05

the problem is the syntax, I don't know the syntax that you need to apply with sql

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-21 : 10:06:46

Can you post the syntax with which you are getting errors?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources