Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

find out where the error

Status
Not open for further replies.
BBSR

BBSR

MIS
Oct 29, 2002
4
US
<%
if not Request.QueryString(&quot;cn&quot;)=&quot;&quot; then
demandnoteno =trim(Request.QueryString(&quot;cn&quot;))
uniqueidno = trim(Request.QueryString(&quot;ph&quot;))
set Con = Server.CreateObject(&quot;ADODB.Connection&quot;)
set rs = Server.CreateObject(&quot;ADODB.RecordSet&quot;)

' Con.Open &quot;FILE NAME=c:\mydatalink.udl&quot;
sSQl=&quot;Driver=SQL Server;UID=;pwd=;DATABASE=;server=&quot;
Con.Open sSQL
'Con.Open &quot;bbsrtel&quot; , &quot;&quot; , &quot;&quot;
sql=&quot;select * from commercial where DNOTE_NO = '&quot; & demandnoteno & &quot;' and UID_NO = '&quot; & uniqueidno & &quot;'&quot;
set rs = Con.Execute(sql)
if not rs.eof then
while not rs.eof
%>
<body>

<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;17%&quot;><APPLET id=test_Dispatch1 height=77 width=119 code=test.class>
<PARAM NAME=&quot;img&quot; VALUE=&quot;bsnllogo.jpg&quot;>
<PARAM NAME=&quot;id&quot; VALUE=&quot;test_Dispatch1&quot;>
<PARAM NAME=&quot;height&quot; VALUE=&quot;77&quot;>
<PARAM NAME=&quot;width&quot; VALUE=&quot;119&quot;>
<PARAM NAME=&quot;code&quot; VALUE=&quot;test.class&quot;>
<PARAM NAME=&quot;codeBase&quot; VALUE=&quot;file://C:\Commbbsr\&quot;>
</APPLET>
</td>
<td width=&quot;64%&quot;>
<p align=&quot;center&quot;><b><font size=&quot;5&quot; face=&quot;Verdana&quot; color=&quot;#0000ff&quot;>COMMERCIAL
QUERY DISPLAY</font></b></p>
<p align=&quot;center&quot;><font face=&quot;Verdana&quot; color=&quot;#0000ff&quot; size=&quot;3&quot;><b>*
BHUBANESWAR TELECOM *</b></font></p></td>
<td width=&quot;19%&quot;><APPLET height=100 width=170 code=test.class>
<PARAM NAME=&quot;img&quot; VALUE=&quot;stamp.jpg&quot;>
<PARAM NAME=&quot;height&quot; VALUE=&quot;100&quot;>
<PARAM NAME=&quot;width&quot; VALUE=&quot;170&quot;>
<PARAM NAME=&quot;code&quot; VALUE=&quot;test.class&quot;>
<PARAM NAME=&quot;codeBase&quot; VALUE=&quot;file://C:\Commbbsr\&quot;>
</APPLET>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;100%&quot; colspan=&quot;2&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Sub Name :</b></td>
<td width=&quot;66%&quot;><%=rs(&quot;SUBNAME&quot;)%></td>
<td width=&quot;7%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Tel No.</b></td>
<td width=&quot;15%&quot;></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>F/H Name :</b></td>
<td width=&quot;88%&quot;><%=rs(&quot;FATHER_OR_HUSBAND_NAME&quot;)%></td>
</tr>
</table>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;5%&quot; rowspan=&quot;2&quot; bgcolor=&quot;#c0c0c0&quot;><b>Address
:</b></td>
<td width=&quot;57%&quot;></td>
</tr>
<tr>
<td width=&quot;57%&quot;><%=rs(&quot;ADDRESS1&quot;)%></td>
</tr>
</table><%=rs(&quot;ADDRESS2&quot;)%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; height=&quot;160&quot;>
<tr>
<td width=&quot;100%&quot; height=&quot;22&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>D/N No.</b></td>
<td width=&quot;21%&quot;><%=rs(&quot;DNOTE_NO&quot;)%></td>
<td width=&quot;67%&quot; bgcolor=&quot;#c0c0c0&quot;>&nbsp;</td>
</tr>
</table><tr>
<td width=&quot;100%&quot;></td>
</tr>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; height=&quot;23&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>D/N Date</b></td>
<td width=&quot;21%&quot;><%=rs(&quot;DNOTE_DT&quot;)%></td>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Regn. No.</b></td>
<td width=&quot;29%&quot;><%=rs(&quot;REGISTRATION_NO&quot;)%></td>
<td width=&quot;7%&quot; bgcolor=&quot;#c0c0c0&quot;><b>A/N</b></td>
<td width=&quot;19%&quot;><%=rs(&quot;_NOTE_NO&quot;)%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; height=&quot;23&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Amount</b></td>
<td width=&quot;13%&quot;><%=rs(&quot;AMOUNT&quot;)%></td>
<td width=&quot;24%&quot; bgcolor=&quot;#c0c0c0&quot;>&nbsp;</td>
<td width=&quot;25%&quot;></td>
<td width=&quot;7%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Date</b></td>
<td width=&quot;19%&quot;><%=rs(&quot;ADV_NOTE_DT&quot;)%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; height=&quot;23&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Pay Date</b></td>
<td width=&quot;13%&quot;><%=rs(&quot;PAID_DATE&quot;)%></td>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Exchange</b></td>
<td width=&quot;8%&quot;><%=rs(&quot;EXC&quot;)%></td>
<td width=&quot;4%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Cat</b></td>
<td width=&quot;13%&quot;><%=rs(&quot;CATEGOR&quot;)%></td>
<td width=&quot;6%&quot; bgcolor=&quot;#c0c0c0&quot;><b>STD</b></td>
<td width=&quot;6%&quot;><%=rs(&quot;STD_S&quot;)%></td>
<td width=&quot;7%&quot; bgcolor=&quot;#c0c0c0&quot;><b>UID</b></td>
<td width=&quot;19%&quot;><%=rs(&quot;UID_NO&quot;)%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; height=&quot;23&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Appl. No</b></td>
<td width=&quot;13%&quot;><%=rs(&quot;TEL_NO APP_NO&quot;)%></td>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>SDO No</b></td>
<td width=&quot;8%&quot;></td>
<td width=&quot;55%&quot; bgcolor=&quot;#c0c0c0&quot;>&nbsp;</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; height=&quot;23&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Appl Dt</b></td>
<td width=&quot;13%&quot;><%=rs(&quot;APP_DT&quot;)%></td>
<td width=&quot;75%&quot; bgcolor=&quot;#c0c0c0&quot;>&nbsp;</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; height=&quot;23&quot;>
<table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;>
<tr>
<td width=&quot;12%&quot; bgcolor=&quot;#c0c0c0&quot;><b>Remark</b></td>
<td width=&quot;88%&quot;></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot;></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width=&quot;100%&quot;>
<p align=&quot;center&quot;><a href=&quot; all rights
Reserved</p>
</td>
</tr>
</table>
</td>
</tr>
</table>

</body>

</html>


both demandnoteno & uniqueidno are variables. when i put the values in both the fields for query the query result shows HTTP 500 Internal Server Error.

Pls. find out the error and its solution.
 
Sort by date Sort by votes
possibly these should not be in '&quot; &quot;'

&quot; & demandnoteno & &quot; and UID_NO = &quot; & uniqueidno & &quot;&quot;

not sure what's in these variables..numbers??

I help at your own risk, if I brake it sorry! But if I fixed it, let me know.[thumbsup2]
admin@onpntwebdesigns.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NYCROB
  • Locked
  • Question
Error Permission Denied - Code 800A0046 - Copiend the Documents Folder
Replies
2
Views
190
NYCROB
NYCROB
bdwilcox
  • Locked
  • Question
HTA fails with Syntax Error when working VBScript inserted
Replies
2
Views
351
bdwilcox
bdwilcox
wchull
  • Locked
  • Question
How do I resolve this permissions error in my script?
Replies
0
Views
235
wchull
wchull
elly00
  • Locked
  • Question
select error
Replies
0
Views
149
elly00
elly00
Don Child
  • Locked
  • Question
Oracle connection works while debugging in VBSEdit, but not when run from the command line. 1
Replies
2
Views
244
Don Child
Don Child

Part and Inventory Search

Sponsor

Back
Top