[thelist] newbie alert! Question about .asp

Tab Alleman talleman at autobex.com
Mon Apr 23 14:02:53 CDT 2001


Do you really have "adCmdTable" on a line by itself like that in your code?
or is that just my mail prog wrapping?  Cuz that would be bad.

What is line 26 in your code?

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Janet Nabring-Stager
Sent: Friday, April 20, 2001 3:14 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] newbie alert! Question about .asp


Thanks to everyone who has helped me out so far!
Now I'm having a different problem:
Here's the error message...
Microsoft VBScript runtime error '800a01a8'

Object required: 'Submit'

/InformationServices/CHS_Cookbook_Files/search_names_results.asp,
line 26

Here's the code:

<%
Dim objConn, objRS

Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\Inetpub\wwwroot\connections\InformationServices\CHS_Cookbook_Files
\CHS_Cookbook.mdb;"
objRS.Open "tblRecipe", objConn, adOpenStatic, adLockOptimistic,
adCmdTable

objRS.MoveFirst

Dim fld

While Not objRS.EOF

	For Each fld in Request.Form
		If objRS("Name") = fld.Value Then
			Response.Write objRS("Name") & "<BR>" & objRS("Source") & "<BR>"
		End If
	Next
	objRS.MoveNext
Wend

objRS.Close
Set objRS = Nothing
%>

I've searched all over google (and their section that contains the
old deja files), along with the archives to this list and cannot find
anything that seems to relate to my code...

Again, TIA-

=====
Janet Nabring-Stager
http://www10.ewebcity.com/jnabring

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !





More information about the thelist mailing list