why do you use Replace if deleteheadline is an integer? On Fri 6. July 2001 14:26, you wrote: > 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 --------------------------------------------------------------------- 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
