Computing.Net > Forums > Web Development > I need a ASP Expert- error Object r

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

I need a ASP Expert- error Object r

Reply to Message Icon

Name: shaunix
Date: July 24, 2008 at 11:13:41 Pacific
OS: 2003
CPU/Ram: 00000
Product: 0000000
Comment:

First off, im new to asp. I inherited a website and im trying to create a simple script to add 50 to the money column in a table called VSPlayers where the user name (a varaiable) such as shaun. I have created vote.asp.


The table

VSPlayers
Username Money
---------------------------
shaun 2834


So I type htt//mydomain.com/vote.asp?usrnm=shaun"


The error

Microsoft VBScript runtime error '800a01a8'

Object required: 'Conn'

/vote.asp, line 2

This is what I have for code so far.

SQL="Update VSPlayers SET [Money] = [money] + 50 WHERE Username =" & Request.QueryString("usrnm") & "'"
Conn.Execute(SQL)

I tried to peace this code together from what I found on google. I know im missing something because this seems too easy for it to be so short. Any help would be GREATLY appreciated !!!!!



Sponsored Link
Ads by Google

Response Number 1
Name: Michael J (by mjdamato)
Date: July 25, 2008 at 15:56:52 Pacific
Reply:

I haven't worked in vbscript for several years, but the problem is that you have not created a connection to the database. That code assumes you have created a connection to the database under the object "Conn".

"How" you connet to the databse will depend upon the type of database you are using, it's location (relative to the ASP server), and login credentials.

Here is one example: http://www.aspwebpro.com/tutorials/...

Michael J


0

Response Number 2
Name: shaunix
Date: July 25, 2008 at 21:21:38 Pacific
Reply:

How does the rest of it look ??


0

Response Number 3
Name: Riker88
Date: August 4, 2008 at 07:26:20 Pacific
Reply:

I would suggest posting your code over at programminghelp.com. I bet they can help you figure it out. Good Luck!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Executing Perl In Easy PH... test web not working with...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Web Development Forum Home


Sponsored links

Ads by Google


Results for: I need a ASP Expert- error Object r

i need a couple scripts www.computing.net/answers/webdevel/i-need-a-couple-scripts/718.html

I need a very special script www.computing.net/answers/webdevel/i-need-a-very-special-script/242.html

I need javascript that controls the www.computing.net/answers/webdevel/i-need-javascript-that-controls-the/1630.html