Forum Moderators: open

Message Too Old, No Replies

ASP Sql

Need some assistance

         

5x54u

10:56 pm on Aug 31, 2004 (gmt 0)

10+ Year Member



I need to do two things:

#1 Enable a web page to call out to to a specific sql table for the copy to be displayed in a <TD></TD> of the page.

#2 Create an ASP Admin page that allows a novice to write/edit/delete the copy in the SQL table that the above page calls out to.

Here in lies the dilema; I know HTML backwards and forwards, I know a little about ASP and can read and understand the code but can not write the admin page from scratch.

I already have SQL setup and the tables ceated and named with passwords and all that. My site runs on IIS6. I have seached up and down for a tutorial but I think it might be too basic for tutorials. Is there anyone that is willing to push me in the correct direction?

Thank you in advance.

timchuma

10:25 pm on Sep 2, 2004 (gmt 0)

10+ Year Member Top Contributors Of The Month



Check [aspfaq.com...] and in particular download the PDF version of the knowledgebase.

It has everything you would want to know about ASP & SQL in it (I have consulted it extensively for work on my site.)

If you have MS Access 2000, you can also set up a Data Project file (ADP file) which is basically just a connection to an SQL Server database that allows you to do things like create viewes and stored procedures in a GUI environment and copy the SQL to your code.

Thanks.

5x54u

9:13 pm on Sep 3, 2004 (gmt 0)

10+ Year Member



Thank you very much. I just downloaded and will get to work!

TY