|
| |
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
 |
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.
|
|
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
|
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
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
Posts: 143
From: Mobile, AL USA
Status: offline
|
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?
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
