|
 |
access_asp thread: Error with search query
Message #1 by "bindiya" <bindiya@d...> on Fri, 22 Mar 2002 14:50:32 +0530
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0043_01C1D1B0.EAE351E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hi
I have a small problem can you help me in it .my search asp is not
giving me any error nor does it executes it just hangs .I am sending my
source code also please help
ASP CODE
<%@ language=3D"VBScript"%>
<%Option Explicit%>
<HTML>
<HEAD>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<%
Dim objRS
Dim objConn
dim objps
dim search
dim rs
on error resume next
set objConn =3DServer.CreateObject("ADODB.Connection")
objConn.Open "DRIVER=3D{Microsoft Access Driver (*.mdb)};" & _
"DBQ=3D" & Server.MapPath("db1.mdb") & ";"
objConn.open
set objRS =3DServer.CreateObject("ADODB.Recordset")
search=3D Request.Form("EmpId")
rs=3DobjConn.Execute("select EmpNo,EmpName,Department,Member Book where
EmpNo =3D" & _
search &"")
objRS.Open rs,ObjConn ,,adCmdText
%>
<table border=3D1 align=3D"center" width=3D"432">
<center>
<td width=3D"85">
<div align=3D"center"><i><TBODY> </i> </div>
<tr>
<td width=3D"85">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
No </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"194">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
Name </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Department
</FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Member
</FONT></STRONG></EM></font></font></i></div>
</td>
</tr>
<%While Not objRS.EOF%>
<tr>
<td width=3D"85">
<div align=3D"center"><i><b><%=3Dobjrs("EmpNo")%> </b> </i>
</div>
</td>
<td width=3D"194">
<div
align=3D"center"><i><b><%=3Dobjrs("EmpName")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Department")%></b></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><b><%=3Dobjrs("Member")%></b></i></div>
</td>
</tr>
</center>
<%
objRS.MoveNext
Wend
%>
<td width=3D"85">
<div align=3D"center"><i></TBODY> </i> </div>
</TABLE>
<%
objRS.Close
objConn.Close
set objRS=3DNothing
set objConn =3DNothing
%>
</BODY>
</HTML>
HTML CODE
<HTML>
<HEAD>
<META NAME=3D"Bindiya" Content=3D"Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<table width=3D"93%" border=3D"0" align=3D"center">
<tr>
<td height=3D"91">
<div align=3D"center"> <IMG height=3D50 src=3D"niostaffclub.png"
width=3D350><br>
<IMG height=3D40 src=3D"membershipform.png" width=3D200> </div>
</td>
</tr>
<tr>
<td height=3D"99">
</td>
</tr>
<tr>
<td height=3D"176">
<form Method =3Dpost action=3D"seac_try.asp">
<table align=3D"left">
<TBODY>
<tr>
<td align =3Dmiddle width=3D"117"><i><b>EmpId :</b></i></td>
<P>
<td align=3Dleft width=3D"154">
<INPUT TYPE=3DText Name=3D"EmpId">
</td></P>
</tr>
<tr>
<P>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td>
</tr>
<TR>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td></P></TR>
<tr>
<td align =3Dmiddle width=3D"117"> </td>
<td align=3Dleft
width=3D"154">
</td>
</tr>
<tr>
<P></P>
<tr>
<P></P></tr>
<P></P></P></table><INPUT type=3Dsubmit value=3DSubmit
name=3Dsubmit>
<P> </P></form></td></tr>
<tr>
<td> </td>
</tr></table>
<P></P>
</BODY>
</HTML>
Message #2 by "Serge Wagemakers" <swagemakers@d...> on Fri, 22 Mar 2002 10:43:29 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00A0_01C1D18E.6754DAA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
From what I can see in your code you forgot the FROM clause in the
SELECT statement, but that should give you an error instantly...
HTH,
Serge
----- Original Message -----
From: bindiya
To: Access ASP
Sent: Friday, March 22, 2002 10:20 AM
Subject: [access_asp] Error with search query
hi
I have a small problem can you help me in it .my search asp is not
giving me any error nor does it executes it just hangs .I am sending my
source code also please help
ASP CODE
<%@ language=3D"VBScript"%>
<%Option Explicit%>
<HTML>
<HEAD>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<%
Dim objRS
Dim objConn
dim objps
dim search
dim rs
on error resume next
set objConn =3DServer.CreateObject("ADODB.Connection")
objConn.Open "DRIVER=3D{Microsoft Access Driver (*.mdb)};" & _
"DBQ=3D" & Server.MapPath("db1.mdb") & ";"
objConn.open
set objRS =3DServer.CreateObject("ADODB.Recordset")
search=3D Request.Form("EmpId")
rs=3DobjConn.Execute("select EmpNo,EmpName,Department,Member Book
where EmpNo =3D" & _
search &"")
objRS.Open rs,ObjConn ,,adCmdText
%>
<table border=3D1 align=3D"center" width=3D"432">
<center>
<td width=3D"85">
<div align=3D"center"><i><TBODY> </i> </div>
<tr>
<td width=3D"85">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
No </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"194">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
Name </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Department
</FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman, Times,
serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Member
</FONT></STRONG></EM></font></font></i></div>
</td>
</tr>
<%While Not objRS.EOF%>
<tr>
<td width=3D"85">
<div align=3D"center"><i><b><%=3Dobjrs("EmpNo")%> </b> </i>
</div>
</td>
<td width=3D"194">
<div
align=3D"center"><i><b><%=3Dobjrs("EmpName")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Department")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Member")%></b></i></div>
</td>
</tr>
</center>
<%
objRS.MoveNext
Wend
%>
<td width=3D"85">
<div align=3D"center"><i></TBODY> </i> </div>
</TABLE>
<%
objRS.Close
objConn.Close
set objRS=3DNothing
set objConn =3DNothing
%>
</BODY>
</HTML>
HTML CODE
<HTML>
<HEAD>
<META NAME=3D"Bindiya" Content=3D"Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<table width=3D"93%" border=3D"0" align=3D"center">
<tr>
<td height=3D"91">
<div align=3D"center"> <IMG height=3D50 src=3D"niostaffclub.png"
width=3D350><br>
<IMG height=3D40 src=3D"membershipform.png" width=3D200>
</div>
</td>
</tr>
<tr>
<td height=3D"99">
</td>
</tr>
<tr>
<td height=3D"176">
<form Method =3Dpost action=3D"seac_try.asp">
<table align=3D"left">
<TBODY>
<tr>
<td align =3Dmiddle width=3D"117"><i><b>EmpId
:</b></i></td>
<P>
<td align=3Dleft width=3D"154">
<INPUT TYPE=3DText Name=3D"EmpId">
</td></P>
</tr>
<tr>
<P>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td>
</tr>
<TR>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td></P></TR>
<tr>
<td align =3Dmiddle width=3D"117"> </td>
<td align=3Dleft
width=3D"154">
</td>
</tr>
<tr>
<P></P>
<tr>
<P></P></tr>
<P></P></P></table><INPUT type=3Dsubmit value=3DSubmit
name=3Dsubmit>
<P> </P></form></td></tr>
<tr>
<td> </td>
</tr></table>
<P></P>
</BODY>
</HTML>
Message #3 by "bindiya" <bindiya@d...> on Fri, 22 Mar 2002 17:15:14 +0530
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_001E_01C1D1C5.21BECF00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
yah i forgot FROM clause but after adding also same thing.its not
giving output .
----- Original Message -----
From: Serge Wagemakers
To: Access ASP
Sent: Friday, March 22, 2002 3:13 PM
Subject: [access_asp] Re: Error with search query
From what I can see in your code you forgot the FROM clause in the
SELECT statement, but that should give you an error instantly...
HTH,
Serge
----- Original Message -----
From: bindiya
To: Access ASP
Sent: Friday, March 22, 2002 10:20 AM
Subject: [access_asp] Error with search query
hi
I have a small problem can you help me in it .my search asp is not
giving me any error nor does it executes it just hangs .I am sending my
source code also please help
ASP CODE
<%@ language=3D"VBScript"%>
<%Option Explicit%>
<HTML>
<HEAD>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<%
Dim objRS
Dim objConn
dim objps
dim search
dim rs
on error resume next
set objConn =3DServer.CreateObject("ADODB.Connection")
objConn.Open "DRIVER=3D{Microsoft Access Driver (*.mdb)};" & _
"DBQ=3D" & Server.MapPath("db1.mdb") & ";"
objConn.open
set objRS =3DServer.CreateObject("ADODB.Recordset")
search=3D Request.Form("EmpId")
rs=3DobjConn.Execute("select EmpNo,EmpName,Department,Member Book
where EmpNo =3D" & _
search &"")
objRS.Open rs,ObjConn ,,adCmdText
%>
<table border=3D1 align=3D"center" width=3D"432">
<center>
<td width=3D"85">
<div align=3D"center"><i><TBODY> </i> </div>
<tr>
<td width=3D"85">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
No </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"194">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
Name </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT
size=3D4>Department
</FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Member
</FONT></STRONG></EM></font></font></i></div>
</td>
</tr>
<%While Not objRS.EOF%>
<tr>
<td width=3D"85">
<div align=3D"center"><i><b><%=3Dobjrs("EmpNo")%> </b> </i>
</div>
</td>
<td width=3D"194">
<div
align=3D"center"><i><b><%=3Dobjrs("EmpName")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Department")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Member")%></b></i></div>
</td>
</tr>
</center>
<%
objRS.MoveNext
Wend
%>
<td width=3D"85">
<div align=3D"center"><i></TBODY> </i> </div>
</TABLE>
<%
objRS.Close
objConn.Close
set objRS=3DNothing
set objConn =3DNothing
%>
</BODY>
</HTML>
HTML CODE
<HTML>
<HEAD>
<META NAME=3D"Bindiya" Content=3D"Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<table width=3D"93%" border=3D"0" align=3D"center">
<tr>
<td height=3D"91">
<div align=3D"center"> <IMG height=3D50
src=3D"niostaffclub.png" width=3D350><br>
<IMG height=3D40 src=3D"membershipform.png" width=3D200>
</div>
</td>
</tr>
<tr>
<td height=3D"99">
</td>
</tr>
<tr>
<td height=3D"176">
<form Method =3Dpost action=3D"seac_try.asp">
<table align=3D"left">
<TBODY>
<tr>
<td align =3Dmiddle width=3D"117"><i><b>EmpId
:</b></i></td>
<P>
<td align=3Dleft width=3D"154">
<INPUT TYPE=3DText Name=3D"EmpId">
</td></P>
</tr>
<tr>
<P>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td>
</tr>
<TR>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td></P></TR>
<tr>
<td align =3Dmiddle width=3D"117"> </td>
<td align=3Dleft
width=3D"154">
</td>
</tr>
<tr>
<P></P>
<tr>
<P></P></tr>
<P></P></P></table><INPUT type=3Dsubmit value=3DSubmit
name=3Dsubmit>
<P> </P></form></td></tr>
<tr>
<td> </td>
</tr></table>
<P></P>
</BODY>
</HTML>
Message #4 by "Serge Wagemakers" <swagemakers@d...> on Fri, 22 Mar 2002 14:08:14 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00ED_01C1D1AB.020EC620
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Get rid of the "one error resume next" statement. You might get
errors...
Get the select statement including the value for the variable "search"
and execute it directly in
MS-Access. This might give you clues...
HTH,
Serge
----- Original Message -----
From: bindiya
To: Access ASP
Sent: Friday, March 22, 2002 12:45 PM
Subject: [access_asp] Re: Error with search query
yah i forgot FROM clause but after adding also same thing.its not
giving output .
----- Original Message -----
From: Serge Wagemakers
To: Access ASP
Sent: Friday, March 22, 2002 3:13 PM
Subject: [access_asp] Re: Error with search query
From what I can see in your code you forgot the FROM clause in the
SELECT statement, but that should give you an error instantly...
HTH,
Serge
----- Original Message -----
From: bindiya
To: Access ASP
Sent: Friday, March 22, 2002 10:20 AM
Subject: [access_asp] Error with search query
hi
I have a small problem can you help me in it .my search asp is not
giving me any error nor does it executes it just hangs .I am sending my
source code also please help
ASP CODE
<%@ language=3D"VBScript"%>
<%Option Explicit%>
<HTML>
<HEAD>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<%
Dim objRS
Dim objConn
dim objps
dim search
dim rs
on error resume next
set objConn =3DServer.CreateObject("ADODB.Connection")
objConn.Open "DRIVER=3D{Microsoft Access Driver (*.mdb)};" & _
"DBQ=3D" & Server.MapPath("db1.mdb") & ";"
objConn.open
set objRS =3DServer.CreateObject("ADODB.Recordset")
search=3D Request.Form("EmpId")
rs=3DobjConn.Execute("select EmpNo,EmpName,Department,Member Book
where EmpNo =3D" & _
search &"")
objRS.Open rs,ObjConn ,,adCmdText
%>
<table border=3D1 align=3D"center" width=3D"432">
<center>
<td width=3D"85">
<div align=3D"center"><i><TBODY> </i> </div>
<tr>
<td width=3D"85">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
No </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"194">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Emp
Name </FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT
size=3D4>Department
</FONT></STRONG></EM></font></font></i></div>
</td>
<td width=3D"131">
<div align=3D"center"><i><font face=3D"Times New Roman,
Times, serif"><font color=3D"#336633"><EM><STRONG><FONT size=3D4>Member
</FONT></STRONG></EM></font></font></i></div>
</td>
</tr>
<%While Not objRS.EOF%>
<tr>
<td width=3D"85">
<div align=3D"center"><i><b><%=3Dobjrs("EmpNo")%> </b>
</i> </div>
</td>
<td width=3D"194">
<div
align=3D"center"><i><b><%=3Dobjrs("EmpName")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Department")%></b></i></div>
</td>
<td width=3D"131">
<div
align=3D"center"><i><b><%=3Dobjrs("Member")%></b></i></div>
</td>
</tr>
</center>
<%
objRS.MoveNext
Wend
%>
<td width=3D"85">
<div align=3D"center"><i></TBODY> </i> </div>
</TABLE>
<%
objRS.Close
objConn.Close
set objRS=3DNothing
set objConn =3DNothing
%>
</BODY>
</HTML>
HTML CODE
<HTML>
<HEAD>
<META NAME=3D"Bindiya" Content=3D"Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=3D"#ddddff">
<table width=3D"93%" border=3D"0" align=3D"center">
<tr>
<td height=3D"91">
<div align=3D"center"> <IMG height=3D50
src=3D"niostaffclub.png" width=3D350><br>
<IMG height=3D40 src=3D"membershipform.png" width=3D200>
</div>
</td>
</tr>
<tr>
<td height=3D"99">
</td>
</tr>
<tr>
<td height=3D"176">
<form Method =3Dpost action=3D"seac_try.asp">
<table align=3D"left">
<TBODY>
<tr>
<td align =3Dmiddle width=3D"117"><i><b>EmpId
:</b></i></td>
<P>
<td align=3Dleft width=3D"154">
<INPUT TYPE=3DText Name=3D"EmpId">
</td></P>
</tr>
<tr>
<P>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td>
</tr>
<TR>
<td align =3Dmiddle width=3D"117"></td>
<P>
<td align=3Dleft width=3D"154">
</td></P></TR>
<tr>
<td align =3Dmiddle width=3D"117"> </td>
<td align=3Dleft
width=3D"154">
</td>
</tr>
<tr>
<P></P>
<tr>
<P></P></tr>
<P></P></P></table><INPUT type=3Dsubmit value=3DSubmit
name=3Dsubmit>
<P> </P></form></td></tr>
<tr>
<td> </td>
</tr></table>
<P></P>
</BODY>
</HTML>
|
|
|
View Cart
