Author: kennethgrice | Posted on: 9/11/2009 11:36:16 AM | Views : 1061

I read an article about using a hidden text box on a form to stop spam bots.  Since the bots usually enter all of the fields automatically, placing a hidden field could stop them.  This would be by checking to see if something is entered in it before the insert.

I already have an existing formview.  I've added a hidden text box and binded it to a new field I created in the database called Hidden. 
What is the SQL to not insert if the text box is not null?  I've tried all kind of variations and I can't get the form to insert.
InsertCommand="INSERT INTO [database2].[Guestbook] ([Date_Entered], [Location], [Name], [Comments], [Approval] , [Hidden]     ) VALUES (@Date_Entered, @Location, @Name, @Comments, @Approval, @Hidden )
                              ...

Go to the complete details ...