Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

error '800a01a8' on ASP processing page for rating item

Posted on 2006-07-24
7
Medium Priority
?
227 Views
Last Modified: 2012-06-21
Hi,
  I am having problems getting the following form processed on rate.asp and submitted to the database. I have most of elements here and I was hoping someone could help find where I'm getting derailed. ~

This form seems to collect the data alright:

<form name="frmRate<%=Productsrs.Fields.item("ProductID").value%>" action="rate.asp?ID=<%=Productsrs.Fields.item("ProductID").value%>" method="post">
<input type="hidden" name="ProductId" value="<%=Productsrs.Fields.item("ProductID").value%>">omitted for brevity</form>


If I submit it to a page to just display what was posted, it shows the following, which is what was on the form when it was submitted:

Variables passed via QueryString
ID = 1

Variables passed via Post
ProductId = 1
Merchant = 8
Rating = 10
Comment = Test Comment here
frmRate1.x = 33
frmRate1.y = 9

This is rate.asp where I would like to process the results and submit the rating to the database (with connection established with incl.):

<%
Dim ProductId
Dim Rating
Dim Merchant
Dim Comment
Dim IP
Dim cookie
Dim cookieRated

ProductId = Request.querystring("ID")
Rating = Request.Form("Rating")
Merchant = Request.Form("Merchant")
Comment = Request.Form("Comment")
IP = Request.ServerVariables("REMOTE_ADDR")
cookie = Request.Cookies("rate_" & ProductId)
if cookie = "" then
cookieRated = false
else
cookieRated = true  
end if
%>
<%
Dim RatingRS
Dim RatingRS_numRows

Set RatingRS = Server.CreateObject("ADODB.Recordset")
RatingRS.ActiveConnection = MM_CharonCart_STRING
RatingRS.Source = "SELECT *  FROM Ratings  where ProductID = " & ProductID
RatingRS.CursorType = 0
RatingRS.CursorLocation = 2
RatingRS.LockType = 1
RatingRS.Open()

RatingRS_numRows = 0
%>
<%Set MM_Cmd = Server.CreateObject("ADODB.Command")
MM_Cmd.ActiveConnection = MM_CharonCart_STRING
%>
<%
 
Dim RateCount
<!--Line 49-->RateCount = "SELECT COUNT(*) FROM Ratings WHERE IP='" & IP & "' AND ProductId=" & ProductID
IF RateCount.Value = 0 THEN
IF cookieRated = false THEN
 
MM_Cmd.CommandText ="INSERT INTO ratings(Rating, Merchant, Comment, IP, ProductId) VALUES(" & Rating & "," & Merchant & ",'" & Comment & "', '" & IP & "', " & ProductID & ")"
MM_Cmd.Execute

Response.Cookies("rate_" & ProductId) = true
Response.Cookies("rate_" & ProductId).expires = Date() + 30
END IF
END IF
%>


Microsoft VBScript runtime error '800a01a8'

Object required: 'SELECT COUNT(*) FROM'

/rate.asp, line 49

Thanks, the help is appreciated.
AROC
0
Comment
Question by:AROC
  • 3
  • 2
  • 2
7 Comments
 
LVL 9

Expert Comment

by:danataylor
ID: 17170777
If your DB is Oracle you need to specify the schema in the from clause:

RateCount = "SELECT COUNT(*) FROM <schema_name>.Ratings WHERE IP='" & IP & "' AND ProductId=" & ProductID
0
 

Author Comment

by:AROC
ID: 17170834
Thanks for reply Dana ~

  The database is Access.

  Also the page is  http://www.neatgift.com/Ratings.asp?ID=1 if anyone's interested or it helps..

AROC
0
 
LVL 26

Accepted Solution

by:
DireOrbAnt earned 1100 total points
ID: 17170888
>>IF RateCount.Value = 0 THEN
What do expect this to return?

RateCount is a strign with a SELECT statement in it...
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Assisted Solution

by:danataylor
danataylor earned 100 total points
ID: 17170964
DireOrbAnt  - You're right.  I didn't notice that.  RateCount never gets submitted to the DB as a query.
0
 

Author Comment

by:AROC
ID: 17171032
Thanks DireOrbAnt, by the sounds of it, that's the problem. I don't understand how to correct it though.

Perhaps I should fire a Newbie alert about now..

If I change IF RateCount.Value = 0 THEN to RateCount = 0 THEN I get

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: "SELECT COUNT(*) FROM"]'

/rate.asp, line 49


AROC
0
 

Author Comment

by:AROC
ID: 17171108
I see. Thanks.
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17171236
You need to call the query first. Also, change it to:
"SELECT COUNT(*) AS RateCount FROM Ratings WHERE IP='" & IP & "' AND ProductId=" & ProductID
So you can grab RS("RateCount") or something... You are already calling a SELECT * up top but without the IP part in the WHERE clause... And you don't use RatingRS anywhere else... Maybe you need to stick your other query (with AS RateCount) and then do If (RS("RateCount")) = 0

Again, I'm not sure what you are trying to do and I don't know if all the code is there, so hard to tell.

You just can't query SQL results before first opening a recordset with the query....
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month11 days, 12 hours left to enroll

564 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