I am getting an error from Transfer that it can't find a class alias
that I setup in a query object. I feel like I may have just been
looking at the code to long to be able to find it, so I figured I
would post it here and see if maybe someone else can find the error
point.
So here is my CF code to create an call the query:
local.q = 'SELECT c.title,c.catid FROM catalog.relationship AS
r,catalog.category AS c WHERE r.child = :varid AND c.catid = r.parent
AND r.type = :type';
local.q = APPLICATION.transfer.createQuery(local.q);
local.q.setParam('varid',ARGUMENTS.rc.varid,'numeric');
local.q.setParam('type','cv2c','string');
categories = APPLICATION.transfer.listByQuery(local.q);
And here is my transfer.xml file portion required for the error:
<package name="catalog">
<object name="category" table="categories">
<id name="catid" type="numeric" />
<property name="title" type="string" />
<property name="parent" type="numeric" />
<property name="metadesc" type="string" />
<property name="metakey" type="string" />
<property name="active" type="boolean" />
</object>
<object name="product" table="products">
<id name="prodid" type="numeric" />
<property name="title" type="string" />
<property name="tagline" type="string" />
<property name="description" type="string" />
<property name="sku" type="string" />
<property name="retailPrice" type="numeric" />
<property name="ourPrice" type="numeric" />
<property name="salePrice" type="numeric" />
<property name="onSale" type="boolean" />
<property name="active" type="boolean" />
<property name="dateavailable" type="date" />
<property name="inventory" type="numeric" />
<property name="height" type="numeric" />
<property name="length" type="numeric" />
<property name="width" type="numeric" />
<property name="metadesc" type="string" />
<property name="metakey" type="string" />
<property name="show0" type="boolean" />
<property name="tags" type="string" />
<property name="taxclass" type="numeric" />
<property name="weight" type="numeric" />
<manytoone name="primaryImg">
<link to="catalog.image"
column="primaryImg" />
</manytoone>
</object>
<object name="relationship" table="relationships">
<id name="relid" type="numeric" />
<property name="type" type="string" />
<property name="child" type="numeric" />
<property name="parent" type="numeric" />
</object>
<object name="image" table="images">
<id name="imgid" type="numeric" />
<property name="src" type="string" />
<property name="thumb" type="string" />
</object>
<object name="variation" table="variations">
<id name="varid" type="numeric" />
<property name="title" type="string" />
<property name="type" type="string" />
<onetomany name="values">
<link to="catalog.variationVal"
column="varid" />
<collection type="array">
<order property="price"
order="asc" />
</collection>
</onetomany>
</object>
<object name="variationVal" table="variationVals">
<id name="valid" type="numeric" />
<property name="title" type="string" />
<property name="price" type="numeric" />
</object>
<object name="download" table="downloads">
<id name="fileid" type="numeric" />
<property name="path" type="string" />
<property name="title" type="string" />
<property name="description" type="string"
nullable="true" />
</object>
</package>
--
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
