insert blank / null date field into database using coldfusion

[ndeeley]

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="QuotePDat e" maxlength="10" size="12" />

and is handled by the action form as this:

insert into tblWorkshops
(QuotePDate etc..)
values
(#form.QuotePDa te#, 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

[acoder]

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.

[ndeeley]

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

[ndeeley]

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

[acoder]

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

insert into tblWorkshops
(<cfif form.QuotePDate neq "">QuotePDate,</cfif>...)
values
(<cfif form.QuotePDate neq "">#form.QuotePDate#,</cfif>)

[ndeeley]

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

insert into tblWorkshops
(<cfif form.QuotePDate neq "">QuotePDate,</cfif>...)
values
(<cfif form.QuotePDate neq "">#form.QuotePDate#,</cfif>)

Thats great, thanks for your help!

Neil

[acoder]

You're welcome :)