Re: Updating Database with ASP

So I unchecked "show friendly http errors" and this error message was revealed.

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'adOpenStatic'

/asp/funandgames3-1-processor.asp, line 10

It seems to think that adOpenStatic is a variable. I just read in my book it's a constant and I have to include this file called adovbs.inc at the top of my page when I use ADOs.

The guy at my ISP seemed not to know what I was talking about and said "You should use a datasource".

So I'm thinking I cant really use the code from my book so maybe I'll try the code you suggest and see how it goes.

Thanks.

------------------
All that is gold does not glitter
Not all who wander are lost . . .

-- J. R. R. Tolkien

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'adOpenStatic'

ahhh...I didn't notice that. Do this, go to c:\program files\common
files\system\ado\adovbs.inc and open that file with Notepad. Use the Find
feature in that file to find "adOpenStatic". When you find it, note what the
numerical value is for that constant variable. Replace the word
"adOpenStatic" in your code with that numerical value.

The constants defined in that file are meant to provide developers with an
easy of knowing what the numerical values are.

--
Ron