Another ASP Question

VFP98, Win98 IE5.5
What could be wrong with this bit of code?

<%SQL = "SELECT Contest.ContestID,Contest.Title FROM Contest"
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Open "Sphinx"
Set objCommand = Server.CreateObject("ADODB.Command")
Set RS = Server.CreateObject("ADODB.Recordset")
objCommand.CommandText = SQL
objCommand.CommandType = adCmdText
Set objCommand.ActiveConnection = objConnection
RS.Open objCommand,,adOpenForwardOnly,adLockReadOnly%>

<h2>Select A Sphinx</h2>

<form method="POST" action="Sphinx2.asp">
  <p><select name="Contest" size="1">
<% Do While Not RS.EOF %>    <option value="<% = RS("ContestID") %>"><% = RS("Title") %></option>
<% RS.MoveNext
Loop
RS.Close
Set RS = Nothing %>  </select><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset"
  name="B2"></p>

The script to set up the SQL commands is straight from another page where it works.  I have played around with it but keep getting an error with it.  I believe the problem is in the Post method or below but I get an error in line 15.
LVL 23
slink9Asked:
Who is Participating?
 
ClassyLinksCommented:
>>I get an error in line 15.

#1 Which is line 15 in your page?
#2 Does the error occur on this page or sphinx2.asp?
#3 What does the error say, exactly?
0
 
slink9Author Commented:
1.Counting from the top, starting with 1, and including each blank as a line, number 15 would be

objCommand.CommandType = adCmdText

2.Sphinx3

3.ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/asp/Database/Sphinx3.asp, line 15

0
 
slink9Author Commented:
Starting at the top (at 1) and counting the script as one line, number 15 would be

<% Do While Not RS.EOF %>    <option value="<% = RS("ContestID") %>"><% = RS("Title") %></option>
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
slink9Author Commented:
Thanks.  Problem found.  It was a typo in the book.  They had
<--Include xx-->
when it should have been
<--#Include xx-->
Stupid book!!
0
 
ClassyLinksCommented:
You didn't need to award me the points....I didn't really help.

I will ask CS to return them to you.
0
 
slink9Author Commented:
You tried.  Besides, I have 500 and only a couple of weeks to use them.  No biggee.
0
 
kodiakbearCommented:
slink9,
I have been asked by ClassyLinks to refund your points for this question. Looking at your profile I see you have been a member for a while. I will let you decide what action you would like to do with this question.
1) Keep it as it is
2) Reduce the points to 0 and keep it in the PAQ
3) Delete it after reducing the points to 0

BTW
I started programming on a TI994A with their version of basic and assembler, moved on to QuickBasic (not qbasic) with compiler and Rbase 5000. So we all did not start out in Qbasic LOL :)

kb
Community Support Moderator
Experts Exchange
0
 
ClassyLinksCommented:
Up to you slink.  I just don't want to appear points greedy...I've made my EE "quota" for the month and am always glad to help....no matter what the point level.

Cheers & Happy Coding!
0
 
slink9Author Commented:
It is fine to leave it as-is.  I am sure I will have plenty more questions, especially after I finish the book and attempt to create something that is actually useful using ASP.  Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.