Platform: W2k/Advanced Server DB: mySQL 3.23.33 Language: ASP/VBScript Issue: I'm creating a backend administration program that will allow updates, deletes, additions, etc. All is well expect for in one table in particular when I choose to delete a record it gives me a type mismatch Error. I've written this code before on other pages without trouble, but this one table in particular is causing trouble. Here is the SQL statement on the ASP page: "DELETE FROM tbl_headline WHERE head_id = " + Replace(deleteheadline, "'", "''") + "" Now head_id is an Integer, and so is deleteheadline, but it gives me a type mismatch error everytime. I've even modded the code in several ways trying to get around it, like instead of matching the head_id I will match up the headline_name field with the same results or making it a text string by putting apostrophe's in etc.. I know the deleteheadline variable has a numerical value because I response.write the variable before the error occurs. Any help you be greatly appreciated. Thanks, Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 --------------------------------------------------------------------- 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
