Hey im having a few probs with the following code i get a http 500 error, ive been looking at this code for hours now and cant find what silly mistake ive made...
<!--#include file="Top.asp" -->
<%
ObjSmallImageName = Request.Form("S-name")
%>
<br><br>
<span class="titles">
<%
Response.write "The Following Image Has been added"
Response.write Request.Form("S-Name")
%>
</span>
<br><br>
<%
Dim Conn, dbPath
dbPath = Server.MapPath("/Database/photo100.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE=" & dbPath
Set UserRecordset = Server.CreateObject("ADODB.Recordset")
sqlstring = "INSERT INTO Photo (SmallImage) VALUES ('" & ObjSmallImageName & "')"
UserRecordset.Open sqlstring, conn
Set objid = UserRecordset("ID")
set objLargeImage = UserRecordset("LargeImage")
Set objSmallImage = UserRecordSet("SmallImage")
While NOT UserRecordset.EOF
%>
Response.Write " & objsmallImage & "
Response.Write "Image Added"
<%
conn.close
%>
<!--#include file="bottom.asp" -->
any help or ideas will be much helpful.
thanx
Topic Options
Post Options
Thanks(0)
