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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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