Not sure if this is the problem, but in your INSERT statement, right at the end you have this:
'" & "sStatus" & "')" So you aren't treating this as a variable but as a string. Could this be the bug? Cheers George in Oxford > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 02 December 2002 4:48 pm > To: ; [EMAIL PROTECTED] > Subject: Missing quotation mark > > > Hi all, > > Sorry about the rain of emails I am having at this list today :-) > > I have a missing quotation marks in the following which I can't see. > > sCheckSQL = "SELECT * From LearnerDetails WHERE Title='" & > sTitle & "' AND FName='" & sFName & "' AND LName='" & sLName & "' > AND Add1='" & sAdd1 & "' AND Town='" & sTown & "' AND County='" & > sCounty & "' AND PostCode='" & sPostCode & "' AND > CurrentlyEmployed='" & sCurrentlyEmployed & "' AND TelPref='" & > sTelPref & "' AND TelMobile='" & sTelMobile & "' AND Email='" & > sEmail & "' AND SourceOfEnquiry=" & sSourceofEnquiry & " AND > EnqTakenBy=" & sEnqTakenBy & " AND Status='" & sStatus & "' AND > Notes='" & sNotes & "'" > > > ************* Statement 2 > strSQLDB1 = "INSERT INTO LearnerDetails > (Title,FName,LName,Add1,Add2,Town,County,PostCode,CurrentlyEmploye > d,TelPref,TelOth,TelMobile,Email,SourceOfEnquiry,EnqTakenBy,DOB,St > atus) VALUES ('" & sTitle & "','" & escape(sFName) & "','" & > sLName & "','" & sAdd1 & "','" & escape(sAdd2) & "','" & sTown & > "','" & sCounty & "','" & sPostCode & "','" & sCurrentlyEmployed > & "','" & sTelPref & "','" & escape(sTelOther) & "','" & > sTelMobile & "','" & sEmail & "'," & sSourceOfEnquiry & "," & > sEnqTakenBy & "," & sDOB & ",'" & "sStatus" & "')" > > ***********Statetment 3 > > sLearnerSQL = "SELECT * From LearnerDetails WHERE Title='" & > sTitle & "' AND FName='" & sFName & "' AND LName='" & sLName & "' > AND Add1='" & sAdd1 & "' AND Add2='" & sAdd2 & "' AND Town='" & > sTown & "' AND County='" & sCounty &"' AND PostCode='" & > sPostCode & "' AND CurrentlyEmployed='" & sCurrentlyEmployed & "' > AND TelPref='" & sTelPref & "' AND TelOth='" & sTelOther & "' AND > TelMobile='" & sTelMobile & "' AND Email='" & sEmail & "' AND > SourceOfEnquiry=" & sSourceofEnquiry & " AND EnqTakenBy=" & > sEnqTakenBy & " AND DOB=" & sDOB & " AND Status='" & sStatus & "' > AND Notes='" & sNotes & "'" > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
