help with this syntax

guys i need your here pls tell me what is wrong with this statement

My Picture column contain this picture\upload\123.gif

VB Code:

path=rs.fields(picture)
 
server.mappath(path)//error line

if i do the above code i will get a type mismatch error

VB Code:

path="picture\upload\123.gif"
 
server.mappath(path)

but if i do this then every thing turns out fine...

What is wrong with this!??

try this:

Code:

---

path=rs.fields("picture")

server.mappath(path)//error line

---

or:

Code:

---

path=rs("picture")

server.mappath(path)//error line

---

still the same type mismatch error :(

the continue to this post can be found here

http://www.vbforums.com/showthread.p...0&pagenumber=2

What do you get with a Response.Write of the rs.fields("Picture")
?

u can follow the link that i put in the previous post to take alook