Arguments (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


xterradane -> Arguments (2/6/2002 19:21:25)

If you get the error message:

Arguments are of the wrong type, out of the acceptable range, or in conflict with one another on the following line of code:

rsInvoice.Open strSQL, objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable

Could the following strSQL cause the error?

strSQL= "SELECT * FROM Company WHERE EMail ='" & Session("EMail") & "';"

If not, any ideas? The only thing I can come up with is that the EMail is not being passed to call it up and find it from the database. However, it is passed to the Add page, so why would it not pass through to the invoice page.


 




Spooky -> RE: Arguments (2/6/2002 20:59:57)

Have you included adovbs.inc?

§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login




xterradane -> RE: Arguments (2/7/2002 11:01:11)

I tried it with and without that file included. I have it referenced with an include file that also has the DSN reference connection string.I do have a question about adovbs.inc. Am I suppose to load the file into my folder or does the host I am using suppose to have it in the same place on there server I have referenced? Also is it okay to combine the adovbs tag on the same include file as the connection string?

 




Spooky -> RE: Arguments (2/7/2002 12:33:37)

Do you have an example of what you mean?

Normally, youll need to place the adovbs.inc file in your directory or use the actual values :
rsInvoice.Open strSQL, objConn, 0, 3, &H0002



§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login




xterradane -> RE: Arguments (2/7/2002 18:47:32)

I have used the following instead of including the file:

<!--METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll"-->

However, I guess this would assume the host had it in the same place on their server? So, guess I need to put the file in my directory. Root? Then reference it on the pages I am connecting to database? Does this effect sessions at all?

 




Spooky -> RE: Arguments (2/7/2002 21:50:53)

Check out :
http://www.asp101.com/articles/john/adovbs/default.asp

Or type libraries :
http://www.asp101.com/articles/john/typelibs/default.asp

§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125