pervenches
Programmer
Hello,
I have found the following upload file:
which I integrated in my form.
The form loads up an image and writes data in a database. Everything works fine exept the name of the image is not writen in the database.
How can I return the name of the uploaded file?
My attempt lookes something like that:
<%
FUNCTION fixQuotes( theString )
fixQuotes = REPLACE( theString, "'", "''" )
END FUNCTION
' Get the Form Variables
productPicture = Uploader.Form( "productPicture" )
' Open the Database Connection
...%>
<%
' Add New Product
sqlString = "INSERT INTO Products " &_
"( product_picture ) VALUES ( " &_
" '" & productPicture & " )"
Con.Execute sqlString
%>
Regards,
Pervenches
I have found the following upload file:
which I integrated in my form.
The form loads up an image and writes data in a database. Everything works fine exept the name of the image is not writen in the database.
How can I return the name of the uploaded file?
My attempt lookes something like that:
<%
FUNCTION fixQuotes( theString )
fixQuotes = REPLACE( theString, "'", "''" )
END FUNCTION
' Get the Form Variables
productPicture = Uploader.Form( "productPicture" )
' Open the Database Connection
...%>
<%
' Add New Product
sqlString = "INSERT INTO Products " &_
"( product_picture ) VALUES ( " &_
" '" & productPicture & " )"
Con.Execute sqlString
%>
Regards,
Pervenches