ASP and Access and a test website

  • 14 years ago

    Im not sure what kind of response in going to get out of this one as it low hat old asp and.....frontpage, please do not beet me.

    Long and short of it im woking on a webpage to display a support case details, i work on a small helpdesk (just me) and i want people to be able to visit a webpage, type in there case number and then be able to display there case details (all stored in a access database)

    I have got so far using a old mock up of some code i had lying about for another project

    please go here to see what i have working and it will better understand the problem and what im trying to do then

    Here

    Basicly i want them to type the number in and for it to go away and bring back the row with that CBL number? that make sense?

    Realy Thanks for anything any one can give me here

    <CODE>
    <!--#include file="openservice.asp"-->
    <%
        sSQL = "SELECT * FROM CaseData"
       
        SET rsLogs = adoCon.Execute(sSQL)
       
        iNumberOfLogs = 0
       
        'An If to check the result sets position, an send it to the first record
        IF NOT rsLogs.EOF THEN
            rsLogs.MoveFirst
            WHILE NOT rsLogs.EOF  'while we have records, count them
                iNumberOfLogs = iNumberOfLogs + 1
                rsLogs.Movenext
            WEND
            rsLogs.Movefirst 'back to the start
        END IF
       
       
    %>
    <html>

    <head>
        <title>Talon Support Online Tracker</title>
    </head>

    <body text="#FFFFFF" bgcolor="#000000">
    <div style="border-style:solid; border-color:#000000; padding-left: 9px; padding-right: 9px; padding-top: 1px; padding-bottom: 1px">
        <h1><font size="7">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font><font face="Arial" size="5">TEST
        SITE</font></h1>
        <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <i>&nbsp;<b><font face="Arial" size="2"> TEST Support Case Tracker</font></b></i></p>
        <p align="center">
        <img border="0" src="http://www.talonsolutions.net/front-1%20copy.jpg" width="969" height="122"></p>
        <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p>
        <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p>
        <p><font face="Arial" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </b>Please enter your CBL number</font></p>
        <p><font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </font><input type="text" name="T1" size="25">&nbsp;&nbsp;&nbsp;&nbsp;
        <input type="submit" value="Enter" name="B1"></p>
        <div align="center">
    <table border="1" width="77%" bgcolor="#000000">
        <tr>
            <td><b>CBL</b></td><td><b>Client</b></td><td><b>Company</b></td><td><b>Issue</b></td><td><b>Status</b></td><td><b>Resolve</b></td>
        <% for iRows = 1 to iNumberOfLogs %>
            <tr>
                <td><%= rsLogs("CBL")%>&nbsp;</td><td><%= rsLogs("Client") %>&nbsp;</td><td><%= rsLogs("Company") %>&nbsp;</td><td><%= rsLogs("Issue")%>&nbsp;</td><td><%= rsLogs("Status")%>&nbsp;</td><td><%= rsLogs("Resolve")%>&nbsp;</td>

            </td>
        <% rsLogs.MoveNext 'move to next log entry
            Next 'move next in the loop!
        %>
    </table>

        </div>

    </div>

    </body>

    </html>
    <% adoCon.Close %>














































































Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“XML is like violence - if it's not working for you, you're not using enough of it.”