I meant - what are the query param values? Do the values of the query params match up to what the columns data types are in the database?
Mark On Thu, Sep 2, 2010 at 5:53 PM, Moni <rebs...@media-solutions.de> wrote: > 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> > <transfer-dev%2bunsubscr...@googlegroups.com<transfer-dev%252bunsubscr...@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<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 Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.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