Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL - database reading

Options
  • 29-11-2001 1:51pm
    #1
    hertz
    Registered Users 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