Solved

Another ASP Question

Posted on 2001-07-16
9
150 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:slink9
  • 5
  • 3
9 Comments
 
LVL 7

Accepted Solution

by:
ClassyLinks earned 50 total points
ID: 6286990
>>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
 
LVL 23

Author Comment

by:slink9
ID: 6287032
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
 
LVL 23

Author Comment

by:slink9
ID: 6287152
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
 
LVL 23

Author Comment

by:slink9
ID: 6287380
Thanks.  Problem found.  It was a typo in the book.  They had
<--Include xx-->
when it should have been
<--#Include xx-->
Stupid book!!
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6287441
You didn't need to award me the points....I didn't really help.

I will ask CS to return them to you.
0
 
LVL 23

Author Comment

by:slink9
ID: 6287460
You tried.  Besides, I have 500 and only a couple of weeks to use them.  No biggee.
0
 
LVL 1

Expert Comment

by:kodiakbear
ID: 6287975
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
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6288155
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
 
LVL 23

Author Comment

by:slink9
ID: 6289081
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Advice needed on CMS/coding platform 9 58
Web Developer 7 268
ASP.NET Fix Column Width 7 203
Summernote required 3 102
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now