One of the data types can't be correct, otherwise Oracle wouldn't be throwing an exception ;o)
So what are they on the system that fails? Mark On Mon, Sep 6, 2010 at 8:09 PM, Moni <rebs...@media-solutions.de> wrote: > Hi Mark, > > the data types are correct (number). > > As mentioned in the first post: > I run the same scripts with the same database on two different CF- > Servers. And only one throws this error. But both CF-servers have the > same configuration. > > Greetings, Moni > > On 4 Sep., 01:14, Mark Mandel <mark.man...@gmail.com> wrote: > > 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> > > > > > <transfer-dev%2bunsubscr...@googlegroups.com<transfer-dev%252bunsubscr...@googlegroups.com> > <transfer-dev%252bunsubscr...@googlegroups.com<transfer-dev%25252bunsubscr...@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-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
