default value for form data

[sdtke212]

Hello,

So, I'm working a on a an online survey and so far, everything is great. My
problem lies in that everything works great if a user enters a value for every
question on the form. But the user doesn't always have to enter a value, he can
leave whatever fields blank that he wants. I tried using <CFPARAM>, but it's
giving me this error.

the tag:
<cfparam name="form.dm01" default="0">

Error Executing Database Query.
Invalid data for CFSQLTYPE CF_SQL_NUMERIC.

I am using SQL Server 2000 and stored procedures. Here is what one of my
<CFPROCPARAM> looks like:
<cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="@var1"
value="#form.dm01#">

The fields in the database allow null values and I guess that is what ideally
I would want inserted into the database
if no value is entered. If I could have some input or feedback or guidance as
to where I am going wrong or what
direction I should, please let me know.

Thanks!

Ryan

[mxstu]

It depends on the type of form field you are using. If "form.dm01" is a
textbox, it will always exist on the action page and the CFPARAM will have no
effect.

Since you are using CF_SQL_NUMERIC, you could use the IsNumeric() function to
check the form field value. If the value is numeric then insert it, otherwise
insert NULL.

<cfif IsNumeric(form.dm01)>
<cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="@var1"
value="#form.dm01#">
<cfelse>
<cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="@var1"
value="#form.dm01#" null="yes">
</cfif>

You could simplify that code by putting the logic in a UDF (that returns
yes/no). So let's say your UDF was named "IsNumericNull", you could write
something like this....

<cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="@var1"
value="#form.dm01#" null="#IsNumericNull(form.dm01)#">

[Dan Bracuk]

You have a data type mismatch. Take the quotes out of the default attribute of your cfparam tag.

[mxstu]

Originally posted by: Dan Bracuk
You have a data type mismatch. Take the quotes out of the default attribute of your cfparam tag.

Since CF is loosely typed, that should not make a difference.