blurredvision
asked on
(0x80004005) Unspecified Error
I'm using the following code with an Access97 database (which I have no control over). Line 36 keeps bringing up the error:
ERROR MESSAGE:
********************
Error Type:
(0x80004005)
Unspecified error
/directone/aa.asp, line 36
********************
LINE 36:
********************
set stockavail = conn.execute("select available, size, material " _
& "From T_Details where material = " & entry & ";")
********************
It seems to work fine without trying to select 'size,' but this is something I need to be able to select. I've tried selecting
"size as somethingelse" but this still generates the same error.
Any ideas?
ERROR MESSAGE:
********************
Error Type:
(0x80004005)
Unspecified error
/directone/aa.asp, line 36
********************
LINE 36:
********************
set stockavail = conn.execute("select available, size, material " _
& "From T_Details where material = " & entry & ";")
********************
It seems to work fine without trying to select 'size,' but this is something I need to be able to select. I've tried selecting
"size as somethingelse" but this still generates the same error.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry lluthien, we must have been typing at the same time
ASKER
Yes that has done the trick. I'm not overly au fait with these SQL intricacies, and the square brackets have done the job. Given that you both supplied the right answer at the same time, the fairest thing to do seems to be to split the points. I'll increase the overall points to 150 so you both get 75 each...
np
glad to help
Thanks