I see two problems. 1. You seem to be missing a left parentheses (, or you could just get rid of the right paren. 2. You need to change "CurrentlyEmployed= AND". The lack of a value will cause problems.
Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:42 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Error in SELECT Please note...the values that don't have ' ' are int type. Here is the error bellow: SELECT * From LearnerDetails WHERE Title='Mr' AND FName='Natasha' AND LName='Burkenshaw' AND Add1='17 Cromer Road' AND Town='Hornchurch' AND County='Essex' AND PostCode='RM11 1EY' AND CurrentlyEmployed= AND TelPref='020 8595 3986' AND TelMobile='07733382300' AND Email='[EMAIL PROTECTED]' AND SourceOfEnquiry=3 AND EnqTakenBy=5 AND Status='Call Back' AND Notes='') Microsoft OLE DB Provider for SQL Server error '80040e14' Incorrect syntax near the keyword 'AND'. /Learners/SamAddLearner.asp, line 165 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
