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-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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
