ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages - More > ASP Programming
Reload this Page

(asp) urgent help with this code

Discuss (asp) urgent help with this code in the ASP Programming forum on Dev Shed.
(asp) urgent help with this code ASP Programming forum discussing Active Server Pages coding techniques and problem solving methods. Use VBScript or Jscript to make dynamic web applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 27th, 2003, 12:54 AM
wlhan wlhan is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2003
Posts: 2 wlhan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy (asp) urgent help with this code
(Asp) urgent help with this code

I was writhing this query and when I finished with it I start deleting unwanted code and I surprised that it didn't work any more so could any one of you help me with it


<!--#include file="../conn/conn.asp" -->
<html>
<head>
<title>ماذا تريد من شرطة دبي</title>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1256">
<script language="JavaScript" src="calendar.js"></script>
</head>
<%
Dim rs, sql
B1 = trim(Request.Form("B1"))
If B1="إبحث" Then
startDate = trim(Request.Form("startDate"))
endDate = trim(Request.Form("endDate"))
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from contribution where date1 between # " & startDate & " # and # " & endDate & " # order by date1"
rs = conn.Execute (sql)
'rs.Open sql, Conn
end if
%>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" style="text-align: Justify; text-indent: 0; word-spacing: 0; line-height: 100%; margin: 0">
<div align="center">
<div align="right">
<form name="newTask" method="post" action="printreq.asp">
<table width="100%" height="32" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#D5E5F8">
<tr>
<td width="737" height="23"> <table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td width="13%"><font size="1" face="ms sans serif, verdana, arial, helvetica">
<input type="submit" name="B1" value="إبحث" style="border:1px solid #000000; FONT-SIZE: 12px; COLOR: #FFFFFF; FONT-FAMILY: Tahoma; BACKGROUND-COLOR: #7596B9; ">
&nbsp;</font></td>
<td width="31%"><div align="right"><font size="1" face="ms sans serif, verdana, arial, helvetica"><a href="javascript:cal2.popup();"><img src="../images/calender.gif" width="16" height="16" border="0"></a>
<input name="endDate" type="text" id="endDate" >
</font></div></td>
<td width="17%"><font color="#006699" size="1" face="ms sans serif, verdana, arial, helvetica">إلى
تاريخ </font></td>
<td width="24%"><div align="right"><font size="1" face="ms sans serif, verdana, arial, helvetica"><a href="javascript:cal1.popup();"><img src="../images/calender.gif" width="16" height="16" border="0"></a>
<input name="startDate" type="text" id="startDate" >
</font></div></td>
<td width="15%"><div align="left"><font color="#006699" size="1" face="ms sans serif, verdana, arial, helvetica">الطلبات
من تاريخ</font></div></td>
</tr>
</table></td>
</tr>
</table>
</form>

<p align="center">&nbsp;</p>
</div>
<p>&nbsp;</p>
<%
if not rs.bof then
do while not rs.eof
%>
<p align="center"><strong>تاريخ تقديم الطلب :</strong> <strong><font color="#0000FF"><%=rs("date1")%></font></strong></p>
<table width="602" height="98" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
<tr>
<td width="602" height="98"> <table width="100%" border="0" align="center" cellpadding="4" cellspacing="1" style="WIDTH: 100%; BORDER-COLLAPSE: collapse">
<tr bgcolor="#F1F1F3">
<td> <div align="right" ><font color="#FF0000" size="1" face="ms sans serif, verdana, arial, helvetica"><%=rs("gender")%>
</font></div></td>
<td width="17%"> <div align="left"><font color="#000066" size="1" face="ms sans serif, verdana, arial, helvetica">:
الجنس</font></div></td>
<td width="23%"> <div align="right"><font color="#FF0000" size="1" face="ms sans serif, verdana, arial, helvetica"><%=rs("nationality")%>
</font></div></td>
<td width="12%"> <div align="left"><font color="#000066" size="1" face="ms sans serif, verdana, arial, helvetica">:
الجنسية</font></div></td>
<td width="5%"><img src="../images/off.gif" width="26" height="23"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="43%"> <div align="right"><font color="#FF0000" size="1" face="ms sans serif, verdana, arial, helvetica"><%=rs("education")%>
</font></div></td>
<td> <div align="left"><font color="#000066" size="1" face="ms sans serif, verdana, arial, helvetica">
:المستوى التعليمي</font></div></td>
<td> <div align="right"> <font color="#FF0000" size="1" face="ms sans serif, verdana, arial, helvetica"><%=rs("age")%></font></div></td>
<td> <div align="left"><font color="#000066" size="1" face="ms sans serif, verdana, arial, helvetica">:
العمر</font></div></td>
<td><img src="../images/off.gif" width="26" height="23"></td>
</tr>
<tr bgcolor="#F1F1F3">
<td> <div align="right"><font color="#FF0000" size="1" face="ms sans serif, verdana, arial, helvetica"><%=rs("occupation")%>
</font></div></td>
<td> <div align="left"><font color="#000066" size="1" face="ms sans serif, verdana, arial, helvetica">:
المهنة</font></div></td>
<td> <div align="right"><font color="#FF0000" size="1" face="ms sans serif, verdana, arial, helvetica"><%=rs("name1")%>
</font></div></td>
<td> <div align="left"><font color="#000066" size="1" face="ms sans serif, verdana, arial, helvetica">:
الإسم</font></div></td>
<td><img src="../images/off.gif" width="26" height="23"></td>
</tr>
</table></td>
</tr>
</table>
<p>&nbsp;</p>
<table width="602" height="791" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#999999">
<tr>
<td width="602" height="791"> <table width="100%" height="100%" border="0" align="center" cellpadding="4" cellspacing="1" style="WIDTH: 100%; BORDER-COLLAPSE: collapse">
<tr bgcolor="#F1F1F3">
<td><div align="right"> <%=rs("p1")%></div></td>
<td width="5%" lang="ar"><div align="center"><font size="5" face="Tahoma">1</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right"> <%=rs("p2")%></div></td>
<td><div align="center"><font size="5" face="Tahoma">2</font></div></td>
</tr>
<tr bgcolor="#F1F1F3">
<td bgcolor="#F1F1F3"> <div align="right"><%=rs("p3")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">3</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right"><%=rs("p4")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">4</font></div></td>
</tr>
<tr bgcolor="#F1F1F3">
<td> <div align="right"><%=rs("p5")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">5</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right"><%=rs("p6")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">6</font></div></td>
</tr>
<tr bgcolor="#F1F1F3">
<td> <div align="right"><%=rs("p7")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">7</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right"><%=rs("p8")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">8</font></div></td>
</tr>
<tr bgcolor="#F1F1F3">
<td> <div align="right"><%=rs("p9")%> </div></td>
<td><div align="center"><font size="5" face="Tahoma">9</font></div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="right"> <%=rs("p10")%></div></td>
<td><div align="center"><font size="5" face="Tahoma">10</font></div></td>
</tr>
</table></td>
</tr>
</table>
<%
rs.movenext
loop
end if
rs.Close
'set rs = nothing
'Conn.Close
'Set Conn = Nothing
%>
<p>&nbsp;</p>
</div></td>
</tr>
</table>
<script language="JavaScript">
var cal1 = new calendar1(document.forms['newTask'].elements['startDate']);
cal1.year_scroll = true;
cal1.time_comp = false;
var cal2 = new calendar1(document.forms['newTask'].elements['endDate']);
cal2.year_scroll = true;
cal2.time_comp = false;
//-->
</script>
</body>
</html>
Reply With Quote
  #2  
Old October 27th, 2003, 12:58 AM
wlhan wlhan is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2003
Posts: 2 wlhan User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
and the error is :

Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/people/admin/printreq.asp, line 51
Reply With Quote
  #3  
Old October 27th, 2003, 07:08 PM
pda8333 pda8333 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2003
Posts: 216 pda8333 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 8 h 6 m 31 sec
Reputation Power: 6
hi wlhan,

where is yr line 51? i assume it is the "if not rs.bof then". let me ask you a question first. what if your B1 is <> "إبحث"? It won't execute yr open recordset for yr rs. So that should be your error.
__________________
Hope this helps.

Mike
Royal Selangor Pewter

"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > (asp) urgent help with this code

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway. 
Stay green...Green IT