On May 4, 10:41 am, Andrew Scott <[EMAIL PROTECTED]> wrote:
> I followed the wiki directions, to create and extend the dmNavigation and
> placed
>
> <input type="checkbox" name="bAllowLink" id="bAllowLink" <cfif
> bAllowLink>checked="checked"</cfif>>

I assume you have overidden the edit handler -- send it through to the
list if you are still having trouble.

> The problem is that the dbgateway cracks it because the properyValue doesn't
> exist, and if it does it cracks it because it can't convert on to a Boolean.

Assuming this is your form post action:
        <cfelse> <!--- submit --->
                <cfset stProperties = structNew()>
                <cfset stProperties.objectid=stObj.objectId>
                <cfset stProperties.title = form.title>
                <cfset stProperties.label = form.title>
                <cfset stProperties.externalLink = form.externalLink>
                <cfset stProperties.lNavIDAlias = form.lNavIDAlias>
                <cfset stProperties.datetimelastupdated = Now()>
                <cfset stProperties.lastupdatedby =
session.dmSec.authentication.userlogin>
                <cfset stProperties.fu = form.fu>
                <!--- unlock object --->
                <cfset stProperties.locked = 0>
                <cfset stProperties.lockedBy = "">

You might add something as simple as:
<cfif isDefined("form.bAllowLink")>
  <cfset stProperties.bAllowLink = 1 />
<cfelse>
  <cfset stProperties.bAllowLink = 0 />
</cfif>

There are many ways to solve this -- you just have to prepare a
structure with all the keys for fourq and it will set the data.  It
may simply be that the database you are using expects a 1 or 0 rather
than a true or false.

Hope that helps,

-- geoff
http://www.daemon.com.au/


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to