Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

SQL - database reading

  • 29-11-2001 12:51PM
    #1
    hertz
    Registered Users, Registered Users 2 Posts: 255 ✭✭


    I have a database on access which I need to read off and print on a browser using asp(VBscript or Javascript).


    SQLread = "SELECT [customer].[Sname], [customer].[Fname], [customer].[ID], [customer].[email] FROM [customer];"

    This is the SQL code which im using to SELECT what I need from the database.

    The problem is, is when I print out can I have one statment that will print out the all of these above, (I dont mean select * from customer now) .

    Heres what I have:

    <%
    =output.fields("Fname") & "<BR>"
    %>

    <%
    =output.fields("Sname") & "<BR>"
    %>

    <%
    =output.fields("ID") & " "
    %>

    <%
    =output.fields("email") & " "
    %>

    Can this be put into one statment or is it this teadious writing a statment per field I want to print out.

    Any advic would be helpful..

    Hertz[/email]


Advertisement