publishing an SQL statment.

Results 1 to 3 of 3

Thread: publishing an SQL statment.

  1. #1
    Big Al Guest

    Default publishing an SQL statment.

    I have a SQL select statment. But am unsure once I have got the records how do I write then to the html page?

  2. #2
    Jonathan Swartz Guest

    Default RE: publishing an SQL statment.

    Al,<BR><BR>You need to interact with a data access technology such as ADO in order to access the datastore and return a recordset for your SQL statement. There are several ways of accomplishing this, and some of them depend on the type of database you are using (SQL Server, Access, Oracle, etc.) Do some research on ADO Recordsets and ADO Connections, this is invaluable knowledge for any development language.<BR><BR>Check out this article for more details<BR><BR><BR>If you need more help, drop me a line at<BR><BR>Good luck!

  3. #3
    E! Guest

    Default RE: publishing an SQL statment.

    Response.Write in asp code...<BR><BR>Or use the asp tags inside of html &#060;%= rs("field") %&#062;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts