Print Page | Close Window

Do you see the error

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=7462
Printed Date: 28 March 2026 at 9:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Do you see the error
Posted By: twooly
Subject: Do you see the error
Date Posted: 21 November 2003 at 2:11pm

I can't see the error in this line can anyone else

strEvent = Request.Form("Event")

strDate = Request.Form("Date")

strSQL = "INSERT INTO tblSurvey (Event, Date) VALUES ('" & strEvent & "', '" & strDate "')"

 

 

Thanks




Replies:
Posted By: Mart
Date Posted: 21 November 2003 at 2:21pm
What error are you getting? If its a Data Type mismatch its probably because you have set the Date field to type date and are trying to insert a string. If not i think Date is a reserved word Event could be aswell.


Posted By: twooly
Date Posted: 21 November 2003 at 2:24pm

I just changed the column name in the DB and everything works good now 




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