Hi, try:
var isReviewed = 0;
if ( StructKeyExists(form,'yourcheckboxformname') ){
isReviewed = 1;
}
in your query instead of using form.field, use "isReviewed" which is
numeric at this point.
Regards,
Misha
On Thu, Jul 19, 2012 at 1:03 PM, Deb Forman <[email protected]> wrote:
>
> Hi all,
>
> I am running CF9 and am having some issues trying to get Derby to
> recognize a boolean datatype from a form field. The Derby field REVIEWED is
> set to SMALLINT, and the form field fREVIEWED is a boolean (checkbox). I
> hear that Derby doesn't support a BIT (boolean)datatype, but I know there
> must be some sort of work around. Thanks in advance for any clues.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5869
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
