Ah, now here's an odd thing (that took me way too long to uncover):
Trying to do a TQL join
("select S.id, S.server, S.port, S.maxSend,
S.username,S.password,S.isdefault, S.isActive,ST.name as typeName,ST.MTA as
MTA from smtp.smtpServerInstance as S join smtp.smtpServerType as ST")
on two tables defined in my transfer.xml like this:
<package name="smtp">
<object name="smtpServerInstance" table="smtpServerInstance" >
<id name="id" type="string" generate="false"/>
<property name="server" type="string" column="server"
nullable="false"/>
<property name="port" type="string" column="port"
nullable="true"/>
<property name="maxSend" type="string" column="maxSend"
nullable="false"/>
<property name="username" type="string" column="username"
nullable="true"/>
<property name="password" type="string" column="password"
nullable="true"/>
<property name="isdefault" type="boolean"
column="isdefault" nullable="false"/>
<property name="isActive" type="boolean" column="isActive"
nullable="false"/>
</object>
<object name="smtpServerType" table="smtpServerType" >
<id name="id" type="string" generate="false"/>
<property name="name" type="string" column="name"
nullable="false"/>
<property name="MTA" type="string" column="MTA"
nullable="true"/>
<property name="description" type="string"
column="description" nullable="true"/>
<onetomany name="smtpServerInstance" lazy="true">
<link to="smtp.smtpServerInstance"
column="smtpServerTypeID"/>
<collection type="array">
<order property="id" order="asc"/>
</collection>
</onetomany>
</object>
</package>
fails with a "Could not find 'smtp.smtpServerInstance' in
'C:\ColdFusion8\wwwroot\emailmanager\config\transfer.xml.cfm'." error.
If, however, I simply change my package name from 'smtp' to 'SMTP' WITHIN
THE ONETOMANY DEFINITION ONLY (I didn't touch the defined package name
itself, NOR the TQL statement), it executes flawlessly. Everywhere else I
refer to the package as lowercase 'smtp' and it executes fine.
What is up with that???
Doug Boude :0)
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
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
-~----------~----~----~----~------~----~------~--~---
