Member Avatar for rahul8590

http://www.daniweb.com/forums/thread305436.html


accidentally i posted in the wrong forum.

  • 2 Contributors
  • 1 Reply
  • 116 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

I have posted to the previous unmoved post -

Your problem lies in your string syntax -

str = "select * from emp where Filename= &key "

Try -

str = "select * from emp where Filename=" & "'" & key & "'", conn, AdOpenStatic, AdLockOptimistic

This should return the values you are looking for.

Edited by AndreRet because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.