insert blank / null date field into database using coldfusion

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

re: insert blank / null date field into database using coldfusion

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.

re: insert blank / null date field into database using coldfusion

Thanks acer - but how exactly do I do this?

Neil

re: insert blank / null date field into database using coldfusion

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

re: insert blank / null date field into database using coldfusion

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

re: insert blank / null date field into database using coldfusion

Thats great, thanks for your help!

Neil

re: insert blank / null date field into database using coldfusion

You're welcome :)