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

<!--#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



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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net