The 2nd query should work fine - what was the exact error? See: http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Aliasing_column_names
Mark On Wed, Dec 16, 2009 at 6:48 PM, Göran <[email protected]> wrote: > I have made a join between two tables. My problem is that In the two > tables I have two columns with the same name (storage.description, > language.description) and can´t find a way to alias one of the columns > to another name. It is simple to do it in sql. > > I have this working: > > <cfset theQuery = getTransfer().createQuery("from storage.Storage AS > Storage > JOIN language.Language AS Language > where Storage.storageId = :storageId > AND Language.language = :language")> > <cfset theQuery.setParam("storageId", arguments.storageId, > "numeric") > > > <cfset theQuery.setParam("language", arguments.country, "string")> > > <cfset storage = getTransfer().listByQuery( theQuery ) /> > > but there will be errors if I try to put anything before from. I have > also tried: > > <cfimport prefix="t" taglib="/transfer/tags"> > > <t:query name="theQuery" transfer="#getTransfer()#"> > select > > Storage.storageId,Storage.file,Storage.datcreated,Storage.userid,Storage.protect,Storage.clicks,Storage.views,Storage.amount,Storage.paysystem,Storage.paymethod,Storage.storagePic,Storage.linktext,Storage.description > AS storageDescription > from storage.Storage AS Storage > JOIN language.Language AS Language > where Storage.storageId = <t:queryparam > value="#arguments.storageId#" type="numeric"> > AND Language.language = <t:queryparam > value="#arguments.country#" > type="string"> > </t:query> > > First I tried *, Storage.description AS storageDescription and got a > cryptic error message about line 0 :1:2 etc.. > > To put it simple is it possible to have something before FROM and what > is the syntax? > > -- > 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 -- E: [email protected] T: http://www.twitter.com/neurotic 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
