|
 |
asp_databases thread: error '80040e10'
Message #1 by healisdw@h... on Fri, 20 Jul 2001 03:13:57
|
|
Heres html and asp code. Connect to database fine why does it not like my
sqlString
<html>
<head>
<TITLE>Enter in Keyword Then Hit Submit</TITLE>
</head>
<body>
<form name="request" action="results.asp" method="post">
<p>
<input type="text" size="25" name="searchWord">
</p>
<p><input type="submit" value="search"></p>
</form>
</body>
</html>
asp code
<html>
<head>
<title>URL's and descriptions </title>
</head>
<body>
<%
dim myConnection
dim requestKeyword
dim rsKeywords
dim connectString
dim sqlString
connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\BegDB\Chapter13\directory.mdb"
Set myConnection = Server.CreateObject("ADODB.Connection")
Set rsKeywords = Server.CreateObject("ADODB.Recordset")
myConnection.Open connectString
requestKeyword = request.form("searchWord")
sqlString = "Select * From all_pages WHERE keywords = " & requestKeyword
Set rsKeywords = myConnection.Execute(sqlString)
%>
<% do while not rsKeywords.EOF%>
<table align=center colspan=8 cellpadding =5 border=0 width=200>
<tr>
<td><%=rsKeywords("keywords")%> </td>
<td><%=rsKeywords("url")%></td>
</tr>
<%rsKeywords.MoveNext %>
<%loop %>
</table>
</body></html>
Error Code
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Ch13/results.asp, line 27
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 20 Jul 2001 18:58:38 +1000
|
|
www.adopenstatic.com/faq/80040e10.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: <healisdw@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, July 20, 2001 3:13 AM
Subject: [asp_databases] error '80040e10'
: Heres html and asp code. Connect to database fine why does it not like my
: sqlString
:
: <html>
: <head>
Message #3 by Mike McPheat <mmcpheat@s...> on Fri, 20 Jul 2001 16:39:27 +0800
|
|
Try something like
sqlString =3D "Select * From all_pages WHERE keywords =3D '" &
requestKeyword &
"'"
-----Original Message-----
From: healisdw@h... [mailto:healisdw@h...]
Sent: Friday, 20 July 2001 11:14 AM
To: ASP Databases
Subject: [asp_databases] error '80040e10'
Heres html and asp code. Connect to database fine why does it not like
my
sqlString
<html>
<head>
<TITLE>Enter in Keyword Then Hit Submit</TITLE>
</head>
<body>
<form name=3D"request" action=3D"results.asp" method=3D"post">
<p>
<input type=3D"text" size=3D"25" name=3D"searchWord">
</p>
<p><input type=3D"submit" value=3D"search"></p>
</form>
</body>
</html>
asp code
<html>
<head>
<title>URL's and descriptions </title>
</head>
<body>
<%
dim myConnection
dim requestKeyword
dim rsKeywords
dim connectString
dim sqlString
connectString =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" _
& "Data Source=3DC:\BegDB\Chapter13\directory.mdb"
Set myConnection =3D Server.CreateObject("ADODB.Connection")
Set rsKeywords =3D Server.CreateObject("ADODB.Recordset")
myConnection.Open connectString
requestKeyword =3D request.form("searchWord")
sqlString =3D "Select * From all_pages WHERE keywords =3D " &
requestKeyword
Set rsKeywords =3D myConnection.Execute(sqlString)
%>
<% do while not rsKeywords.EOF%>
<table align=3Dcenter colspan=3D8 cellpadding =3D5 border=3D0
width=3D200>
<tr>
<td><%=3DrsKeywords("keywords")%> </td>
<td><%=3DrsKeywords("url")%></td>
</tr>
<%rsKeywords.MoveNext %>
<%loop %>
</table>
</body></html>
Error Code
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Ch13/results.asp, line 27
Message #4 by "Drew, Ron" <RDrew@B...> on Fri, 20 Jul 2001 07:56:16 -0400
|
|
sqlString = "Select * From all_pages WHERE keywords = " &
requestKeyword
needs to be changed to...because it is text (characters)
sqlString = "Select * From all_pages WHERE keywords = '" &
requestKeyword &
"'"
-----Original Message-----
From: healisdw@h... [mailto:healisdw@h...]
Sent: Thursday, July 19, 2001 11:14 PM
To: ASP Databases
Subject: [asp_databases] error '80040e10'
Heres html and asp code. Connect to database fine why does it not like
my
sqlString
<html>
<head>
<TITLE>Enter in Keyword Then Hit Submit</TITLE>
</head>
<body>
<form name=3D"request" action=3D"results.asp" method=3D"post">
<p>
<input type=3D"text" size=3D"25" name=3D"searchWord">
</p>
<p><input type=3D"submit" value=3D"search"></p>
</form>
</body>
</html>
asp code
<html>
<head>
<title>URL's and descriptions </title>
</head>
<body>
<%
dim myConnection
dim requestKeyword
dim rsKeywords
dim connectString
dim sqlString
connectString =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" _
& "Data Source=3DC:\BegDB\Chapter13\directory.mdb"
Set myConnection =3D Server.CreateObject("ADODB.Connection")
Set rsKeywords =3D Server.CreateObject("ADODB.Recordset")
myConnection.Open connectString
requestKeyword =3D request.form("searchWord")
sqlString =3D "Select * From all_pages WHERE keywords =3D " &
requestKeyword
Set rsKeywords =3D myConnection.Execute(sqlString)
%>
<% do while not rsKeywords.EOF%>
<table align=3Dcenter colspan=3D8 cellpadding =3D5 border=3D0
width=3D200>
<tr>
<td><%=3DrsKeywords("keywords")%> </td>
<td><%=3DrsKeywords("url")%></td>
</tr>
<%rsKeywords.MoveNext %>
<%loop %>
</table>
</body></html>
Error Code
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Ch13/results.asp, line 27
|
|
|
View Cart
