Do you see the error

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
twooly Members Profile Find Members Posts Groupie Joined: 24 September 2003 Status: Offline Points: 64	Post Options Post Reply Quote twooly Report Post Thanks(0) Quote Reply Topic: Do you see the error 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

Mart Members Profile Find Members Posts Senior Member Joined: 30 November 2002 Status: Offline Points: 2304	Post Options Post Reply Quote Mart Report Post Thanks(0) Quote Reply 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.

twooly Members Profile Find Members Posts Groupie Joined: 24 September 2003 Status: Offline Points: 64	Post Options Post Reply Quote twooly Report Post Thanks(0) Quote Reply Posted: 21 November 2003 at 2:24pm
	I just changed the column name in the DB and everything works good now

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.