Re: cfselect with binding problem if select multiple is "yes"
Mahcsig wrote: > It looks like the getGPDesc function is expecting a number. Selecting > multiple items will return a list of numbers separated by commas. The code > calling getGPDesc will need to take this into consideration. I would expect to see the error *after* the form is submitted though - since it would send a list to the CFC and it was previously expecting a single integer ID number. The error is being generated when the page loads, *before* the form is submitted though - which is what really has me scratching my head... __ Information from ESET NOD32 Antivirus, version of virus signature database 4814 (20100128) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfselect with binding problem if select multiple is "yes"
It looks like the getGPDesc function is expecting a number. Selecting
multiple items will return a list of numbers separated by commas. The code
calling getGPDesc will need to take this into consideration.
~Mahcsig
On Wed, Jan 27, 2010 at 5:51 PM, Les Mizzell wrote:
>
> Les Mizzell wrote:
> > I should add...
> >
> > If I IGNORE the error - I can make multiple selections as needed and the
> > query works as expected when the form is submitted.
>
> Little more info finally:
>
> Error invoking CFC /email/art.cfc : The GROUPS_ID argument passed to the
> getGPDesc function is not of type numeric.
>
> OK - so when loading the page with this on it, what's difference when
> multiple="no" vs multiple="yes" in the below?
>
>
>id="sendGROUP"
> multiple="no"
> queryPosition="below"
> bind="cfc:art.getGROUPS({theCATS})"
> bindattribute="HTML">
> Select a Group
>
>
>
> __ Information from ESET NOD32 Antivirus, version of virus
> signature database 4811 (20100127) __
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330213
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfselect with binding problem if select multiple is "yes"
Les Mizzell wrote: > I should add... > > If I IGNORE the error - I can make multiple selections as needed and the > query works as expected when the form is submitted. Little more info finally: Error invoking CFC /email/art.cfc : The GROUPS_ID argument passed to the getGPDesc function is not of type numeric. OK - so when loading the page with this on it, what's difference when multiple="no" vs multiple="yes" in the below? Select a Group __ Information from ESET NOD32 Antivirus, version of virus signature database 4811 (20100127) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfselect with binding problem if select multiple is "yes"
I should add...
If I IGNORE the error - I can make multiple selections as needed and the
query works as expected when the form is submitted.
> Here's my two selects. This is working - no problems...
>
> id="theCATS"
>bind="cfc:art.getCATS()"
>bindonload="yes">
>Select a Category
>
>
> id="sendGROUP"
>multiple="no"
>queryPosition="below"
>bind="cfc:art.getGROUPS({theCATS})"
>bindattribute="HTML">
>Select a Group
>
>
>
> But - I need to be able to make *multiple* selections. If I change the
> second select to allow multiples:
>
> id="sendGROUP"
>multiple="yes"
>queryPosition="below"
>bind="cfc:art.getGROUPS({theCATS})"
>bindattribute="HTML">
>Select a Group
>
>
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4811 (20100127) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330201
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfselect with binding problem if select multiple is "yes"
Here's my two selects. This is working - no problems... Select a Category Select a Group But - I need to be able to make *multiple* selections. If I change the second select to allow multiples: Select a Group I get "Error invoking art.cfc. Internal Server Error ..." when loading the page. Not changing any other code anywhere else... Ideas? Digging into Google, but nothing useful so far... __ Information from ESET NOD32 Antivirus, version of virus signature database 4811 (20100127) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
