Hi Mark, Thanks for your reply.
I send this structure to transfer.get(): <cfset key = StructNew()> <cfset tmp = StructInsert( key, "mid", 1)> <cfset tmp = StructInsert( key, "bid", 1000)> <cfset oBesucher = application.transfer.get( "besucher", key )> And it works fine but not on the "second server" (see my first post). Anymore hints? Greeting, Moni On 2 Sep., 09:29, Mark Mandel <mark.man...@gmail.com> wrote: > What are the param values? > > Looks like you're passing a string to something that is expecting a number. > > http://ora-01722.ora-code.com/ > > Mark > > > > On Thu, Sep 2, 2010 at 3:29 AM, Moni <rebs...@media-solutions.de> wrote: > > Hi, > > > I'm using Transfer 1.1 with Oracle 10 Database on Coldfusion MX 7 with > > the Hotfix 2. > > > I'm trying to receive a resultset with transfer.get() on two different > > server. > > On the first server I get the correct resultset but the second server > > throws an sql-error. It says "ORA-01722: invalid Number". > > It seems that the query wasn't parsed, it still contains (param 1), > > (param 2) and so on (see below). > > > The configurations (CF and Database) on both servers are indentical > > except the OS. The first machine runs with Window Server 2000, the > > other with Windows XP. > > > Does anyone have any suggestions? > > > Here is the transfer.xml > > > <transfer> > > <objectDefinitions> > > <object name="mandant" table="besuv.mandant"> > > <id name="mid" type="numeric" /> > > <property name="mandant_sts" type="numeric" > > column="sts"/> > > <property name="mandant" type="string" /> > > </object> > > <object name="besucher" table="besuv.besucher"> > > <compositeid> > > <manytoone name="mid" /> > > <property name="bid" /> > > </compositeid> > > <manytoone name="mid"> > > <link column="mid" to="mandant"/> > > </manytoone> > > <property name="bid" type="numeric" /> > > <property name="sts" type="numeric" /> > > <property name="nname" type="string" /> > > <property name="vname" type="string" /> > > </object> > > </objectDefinitions> > > </transfer> > > > And this is the CF-Code: > > > <cfset key = StructNew()> > > <cfset tmp = StructInsert( key, "mid", 1)> > > <cfset tmp = StructInsert( key, "bid", 1000)> > > > <cfset oBesucher = application.transfer.get( "besucher", key )> > > > SQL-Query from the SQL-Error: > > SELECT NULL AS mandant, > > besuv_besucher_1.mid, > > besuv_besucher_1.vname, > > besuv_besucher_1.nname, > > besuv_besucher_1.sts, > > besuv_besucher_1.bid, > > besuv_besucher_1.bid > > ||'|' > > ||besuv_besucher_1.mid > > ||'|' AS transfer_compositeid, > > NULL AS transfer_parentKey, > > 1 AS transfer_orderIndex, > > 'besucher' AS transfer_className, > > '' AS transfer_parentClassName, > > '' AS transfer_parentParentClassName, > > '' AS transfer_parentCompositeName, > > 'false' AS transfer_isArray, > > '' AS transfer_compositeName, > > 'false' AS transfer_isProxied > > FROM besuv.besucher besuv_besucher_1 > > WHERE besuv_besucher_1.bid = (param 1) > > AND besuv_besucher_1.mid = (param 2) > > UNION ALL > > SELECT besuv_mandant_2.mandant, > > besuv_mandant_2.mid, > > NULL AS vname, > > NULL AS nname, > > besuv_mandant_2.sts, > > NULL AS bid, > > '' AS transfer_compositeid, > > CAST(besuv_besucher_1.bid > > ||'|' > > ||besuv_besucher_1.mid > > ||'|' AS VARCHAR2(1000)) AS transfer_parentKey, > > 2 AS transfer_orderIndex, > > 'mandant' AS transfer_className, > > 'besucher' AS transfer_parentClassName, > > '' AS transfer_parentParentClassName, > > '' AS transfer_parentCompositeName, > > 'false' AS transfer_isArray, > > 'mid' AS transfer_compositeName, > > 'false' AS transfer_isProxied > > FROM besuv.besucher besuv_besucher_1 > > INNER JOIN besuv.mandant besuv_mandant_2 > > ON besuv_besucher_1.mid = besuv_mandant_2.mid > > WHERE besuv_besucher_1.bid = (param 3) > > AND besuv_besucher_1.mid = (param 4) > > AND besuv_mandant_2.mid IS NOT NULL > > ORDER BY transfer_orderIndex ASC > > > -- > > Before posting questions to the group please read: > > >http://groups.google.com/group/transfer-dev/web/how-to-ask-support-qu... > > > Try out the new Transfer ORM Custom Google Search: > >http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 > > > You received this message because you are subscribed to the Google Groups > > "transfer-dev" group. > > To post to this group, send email to transfer-dev@googlegroups.com > > To unsubscribe from this group, send email to > > transfer-dev+unsubscr...@googlegroups.com<transfer-dev%2bunsubscr...@googlegroups.com> > > For more options, visit this group at > >http://groups.google.com/group/transfer-dev?hl=en > > -- > E: mark.man...@gmail.com > T:http://www.twitter.com/neurotic > W:www.compoundtheory.com > > cf.Objective(ANZ) - Nov 18, 19 - Melbourne > Australiahttp://www.cfobjective.com.au > > Hands-on ColdFusion ORM Trainingwww.ColdFusionOrmTraining.com -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en