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