-
asp upload image to access db
I want to upload a file and save it to access db but i'm getting an error saying "invalid insert statement". i defined user_pic as an ole object. Can you help me?
Set Files = Server.CreateObject("Scripting.Dictionary")
Set mcolFormElem = Server.CreateObject("Scripting.Dictionary")
Dim objPic_Connection, objPic_Resource, myPic_SQL
Set objPic_Connection = Server.CreateObject ("ADODB.Connection")
objPic_Connection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("databases/db1.mdb")
myPic_SQL = "insert into userpic (user_id,user_pic) values (" & UserID & "," & FileData & ")"
Set objPic_Resource = objPic_Connection.Execute(myPic_SQL)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|