469,314 Members | 2,203 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,314 developers. It's quick & easy.

Microsoft JET Database Engine (0x80040E10)

Fary4u
273 100+
i've recived error
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.


Expand|Select|Wrap|Line Numbers
  1. get handle on data
  2. 'Const adOpenKeyset = 3
  3. 'Const adLockReadOnly = 3
  4.  
  5. Dim rsProduct, sSQLa, rsSizes, rsColours
  6.  
  7. sSQLa = "select * from products where productID= '" & intProdID & "'"
  8. set rsProduct = Server.CreateObject("ADODB.RecordSet")
  9. rsProduct.open sSQLa, ConString,adOpenKeyset,adLockReadOnly
  10.  
  11. ' get sizes
  12. sSQLa = "select * from size1,product_sizes where size1.id = size_id and productID='" & intProdID & "'"
  13. set rsSizes = Server.CreateObject("ADODB.RecordSet")
  14. rsSizes.open sSQLa, ConString,adOpenKeyset,adLockReadOnly
it's MS ACCESS database with the ProductID is text i've changed into autonumber to Text

any solution ?
Oct 9 '07 #1
1 2643
jhardman
3,406 Expert 2GB
Expand|Select|Wrap|Line Numbers
  1. response.write sSQLa
  2. rsSizes.open ...
This is kind of a standard troubleshooting technique, it gives you a chance to see how the query turned out.

Jared
Oct 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by lucilue2003 | last post: by
2 posts views Thread by Abubakar | last post: by
2 posts views Thread by Phil McKrackin | last post: by
2 posts views Thread by =?Utf-8?B?b3JjYXVzZXI=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.