Classic ASP Discussion - Anyone see a problem with this

Print Page | Close Window

Anyone see a problem with this

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6190
Printed Date: 31 March 2026 at 1:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Anyone see a problem with this

Posted By: ziwez0
Subject: Anyone see a problem with this
Date Posted: 06 October 2003 at 2:53am

Using a access db, all field names are correct. db in the same folder

<%

Place1 = Request.Form("locate1")
date1 = Request.Form("depart")
hotel1 = Request.Form("accom1")
info1 = Request.Form("about1")
cost1 = Request.Form("cos1")

Set DatabaseConnection = Server.CreateObject("ADODB.Connection")
DatabaseConnection.Open "DSN=explorers1.dsn"

Set UserRecordset1 = Server.CreateObject("ADODB.Recordset")

sqlstring1 ="INSERT INTO Special02 (location1,depart,hotel,info,cost) VALUES ('" & Place1 & "','" & date1 & "','" & hotel1 & "','" & info1 & "','" & cost1 & "') ;"

UserRecordset1.Open sqlstring1, DatabaseConnection

Response.Redirect "login.asp"

%>

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

Replies:

Posted By: ziwez0
Date Posted: 06 October 2003 at 7:47am

problem found, thanx tho

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