Hi,

How do I insert a null or blank field into a database using coldfusion? I'm new to CF and its proviing a bit tricky!

My database date field accepts null values (I think - theres no default value or validation rule).

The input box on the form is this:
<input type="text" name="QuotePDate" maxlength="10" size="12" />

and is handled by the action form as this:

insert into tblWorkshops
(QuotePDate etc..)
values
(#form.QuotePDate#, etc

How can I get the database to accept the null value? The users of the form won't need to always enter a date, tho they may need to update it later on.

Thanks!
Neil

Why not have null as the default in the database and not insert anything for the date value if it's not input. To do this, just check the value input by the user. If it's empty, don't add to the list of fields to insert.

Thanks acer - but how exactly do I do this?

Neil

Sorry - I meant acoder, not acer. Monday morning...

In your query, just add cfifs for the checking, e.g.

Thats great, thanks for your help!

Neil

You're welcome :)