https://www.webmaster-forums.net/crss/node/1034636 en https://www.webmaster-forums.net/serverside-scripting/check-see-if-record-exists-prob#comment-1201467 <p>right here</p> <p>"select email from newsletter where email =' &amp; inventory &amp; '"<br /> you're missing quotation marks to separate the string from the variable</p> <p>should be</p> <p>"select email from newsletter where email ='" &amp; inventory &amp; "'"</p> Tue, 06 Jun 2006 07:12:57 +0000 adjroth comment 1201467 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/check-see-if-record-exists-prob#comment-1201460 <p>have you tried displaying the actual sql statement that is being executed ie. <code>responce.write (sql_check)</code>' right before executing the query. Then manully run that on the database.</p> <p>You could be looking at the database, seeing a record that matches and assume that the program found data, but if something is formatted wrong in the actual SQL being executed, it did not actually return the results you expected. </p> <p>If you have something misformatted (mismatching quotes, invalid characters in the variable 'inventory' that mess up the query, etc), echoing out the final sql statement and manually running it by hand is the best way to find out.</p> <p>-Greg</p> Tue, 06 Jun 2006 06:02:43 +0000 Greg K comment 1201460 at https://www.webmaster-forums.net