What version of Transfer are you using?
Mark
On Wed, Dec 3, 2008 at 9:29 AM, Doug Boude <[EMAIL PROTECTED]> wrote:
> 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)
>
>
>
> >
>
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
