What's the actual error message? Sent from my mobile device On 1 Oct 2010 03:45, "David Long" <[email protected]> wrote: > 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]<transfer-dev%[email protected]> > For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en
-- 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
