Grr!!! I Don't Like CFUPDATE and CFINSERT

Heres a response to a question on EE that I see all too often:

Generally it is considered best practice to use booleans (or in MS SQL server bits) to represent active/inactive status and to shy away from using cfupdate and cfinsert.

That said, it sounds as though there is something funky going on in your CF form. your select box should look something like this.

<select name="UsesrActive">                                                                
       <option value="Active">Active</option>
       <option value="InActive">InActive</option>
</select>

Then your cfupdate tag should look like:

<cfupdate datasource="#request.dsn#"
     tablename="Users"
     formfields="UsesrActive,YOUR FIELDS">

If your code already looks like this check to make sure that you have all of your fields properly entered into the cfupdate tag.

I really dislike the use of the CFUPDATE and CFINSERT tags. Don't get me wrong they are a great tool/trick for new developers but for anyone who is doing development for a living there really isn't any excuse to use them. And don't get me started on the database design ;)