Blank form fields passed to SQL

[The ScareCrow]

In your sql statement, check if the value is empty. I don't know what scripting language you are using so I will give an example using coldfusion

Update myTable
Set myname = 'this is my name'
<cfif Len(Trim(form.field1)>, field1 = #form.field1#</cfif>


So basically trim the form field to get rid of any spaces, then check the length, if it is greater than zero the table field will be set to the form field if no nothing will be done and the defualt value will be inserted.

Ken


If you never ask, you never get an answer.
ScareCrow Application Development