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"> </font><font face="Arial" size="5">TEST
SITE</font></h1>
<p>
<i> <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> </p>
<p> </p>
<p><font face="Arial" size="2"><b>
</b>Please enter your CBL number</font></p>
<p><font face="Arial" size="2">
</font><input type="text" name="T1" size="25">
<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")%> </td><td><%= rsLogs("Client") %> </td><td><%= rsLogs("Company") %> </td><td><%= rsLogs("Issue")%> </td><td><%= rsLogs("Status")%> </td><td><%= rsLogs("Resolve")%> </td>
</td>
<% rsLogs.MoveNext 'move to next log entry
Next 'move next in the loop!
%>
</table>
</div>
</div>
</body>
</html>
<% adoCon.Close %>
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).