Yes this is the answer  - the CFC is getting an Array in each argument
at the moment.

On 1/5/07, Josh Nathanson <[EMAIL PROTECTED]> wrote:
> I think Charlie's post about adding the row number [1] to your function when
> you're creating the struct may close the hole back up.  Did you give that a
> whirl?
>
> -- Josh
>
>
>
>
> ----- Original Message -----
> From: "Daniel Short" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[email protected]>
> Sent: Thursday, January 04, 2007 2:46 PM
> Subject: Re: Issue with "not of type numeric" when sending value to CFC
>
>
> > Well Josh, it's time to get your space helmet, because indeed there is a
> > gaping hole (as best I can tell anyway) :). My sample code defines a
> > recordset with just a single row, with a type of numeric, and a valid
> > value.
> >
> > After all, here's my test code:
> >
> >
> > <!--- Get a query --->
> > <cfset rs = QueryNew("ID,FirstName", "integer,varchar") />
> > <cfset QueryAddRow(rs) />
> > <cfset QuerySetCell(rs, "ID", 3) />
> > <cfset QuerySetCell(rs, "FirstName", "Daniel") />
> >
> > <cfset TestStruct = StructNew() />
> > <cfloop list="#rs.ColumnList#" index="col">
> >    <cfset TestStruct[col] = rs[col] />
> > </cfloop>
> >
> > <cfdump var="#TestStruct#" />
> >
> > <!--- Pass the newly created struct into the object to run each
> > setter --->
> > <cfset MyObject = CreateObject("component",
> > "cfcs.test").init(ArgumentCollection = TestStruct) />
> >
> > <cfdump var="#MyObject.getSnapShot()#" />
> >
> > As you can see, I'm generating a super simply query, and then passing it
> > into the object, and somewhere along the line CF is getting completely
> > confused about the type...
> >
> > Dan
> >
> >
> > On 1/4/07 4:39 PM, "Josh Nathanson" <[EMAIL PROTECTED]> wrote:
> >
> >> I've only gotten this error when I've accidentally passed a null value
> >> (for
> >> example the query returned empty) and it's expecting a numeric.
> >>
> >> Make sure that when you're initially building the structure from the
> >> query,
> >> that you're indeed passing in all the values you expect, by dumping the
> >> query before you convert it into a struct.  Then, after conversion into
> >> the
> >> struct, dump the struct as well to make sure it's still the right value.
> >>
> >> I'd be surprised if it was actually failing on a numeric value.  This
> >> would
> >> open a hole in the time-space continuum.
> >>
> >> -- Josh
> >>
> >> ----- Original Message -----
> >> From: "Daniel Short" <[EMAIL PROTECTED]>
> >> To: "CF-Talk" <[email protected]>
> >> Sent: Thursday, January 04, 2007 2:23 PM
> >> Subject: Issue with "not of type numeric" when sending value to CFC
> >>
> >>
> >>> Hi,
> >>>
> >>> I have a blog post which details my problem here:
> >>>
> >>> http://www.dansshorts.com/?day=1/4/2007#blog360
> >>>
> >>> What's happening is that if I take a recordset row, and build a
> >>> structure
> >>> based on it's columns, and then pass that structure as an
> >>> ArgumentCollection
> >>> to a CFC, the method tosses a "not of type numeric" on a value that is
> >>> indeed numeric.
> >>>
> >>> Has anyone else seen a problem like this? The only way around it has
> >>> been
> >>> to
> >>> set the type to "any" and then just accept any old crap that someone
> >>> wants
> >>> to pass in.
> >>>
> >>> Thanks,
> >>>
> >>> --
> >>> Daniel Short
> >>> Web Application Architect
> >>> lynda.com, Inc.
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >
> >
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265717
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to