Database Discussion - Insert into

Print Page | Close Window

Insert into

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1861
Printed Date: 29 March 2026 at 7:00pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Insert into

Posted By: ziwez0
Subject: Insert into
Date Posted: 16 April 2003 at 3:28pm

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...

ObjSmallImageName = Request.Form("S-name")

%>
 

<%
Response.write "The Following Image Has been added"
Response.write Request.Form("S-Name")

%>

 
<%
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
%>

any help or ideas will be much helpful.

thanx

-------------
If anything takes long to do its worth doing.

Replies:

Posted By: eagle00789
Date Posted: 16 April 2003 at 3:53pm

first of all. turn of the friendly errors in IE. then post the COMPLETE error wich is stated at the bottom of the http 500 page. then we will be able to help you further

-------------
Using forum at http://www.gravenrode.nl/forum/forum - Gravenrode and http://www.gravenrode.nl/forum/test_forum - here and http://217.121.39.22/forum/test_forum - here

Posted By: ziwez0
Date Posted: 16 April 2003 at 4:30pm

Thanx for your help but ive sorted it now

-------------
If anything takes long to do its worth doing.