I added that little code snippet to the adodb file, and the query is no longer all screwy :) thanks so much for your help.
Tracy On May 14, 6:51 pm, egi <[EMAIL PROTECTED]> wrote: > if you're using adodb for database connection, i have filed the error > on trachttps://trac.cakephp.org/ticket/4130and the suggested fix. > > On May 15, 3:21 am, TracyB <[EMAIL PROTECTED]> wrote: > > > I have a model using a table that's been around forever, so it's not a > > CakePHP friendly name. My model is set up like so: > > > class Quote extends AppModel > > { > > var $name = 'Quote'; > > var $useTable = 'BillOfMaterial'; > > var $primaryKey = 'BillID'; > > var $useDbConfig = 'design'; > > > When I do a $this->Quote->findAll() or $this->paginate('Quote'), this > > is the query that gets generated: > > > SELECT "Quote"."BillID" AS "Quote__BillID" AS "Quote"__"BillID" AS > > "Quote__BillID" AS "Quote"__"BillID" AS "Quote__BillID" AS > > "Quote"__"BillID" AS "Quote__BillID", "Quote"."JobNumber" AS > > "Quote__JobNumber" AS "Quote"__"JobNumber" AS "Quote__JobNumber" AS > > "Quote"__"JobNumber" AS "Quote__JobNumber" AS "Quote"__"JobNumber" AS > > "Quote__JobNumber", "Quote"."Phase" AS "Quote__Phase" AS > > "Quote"__"Phase" AS "Quote__Phase" AS "Quote"__"Phase" AS > > "Quote__Phase" AS "Quote"__"Phase" AS "Quote__Phase", > > "Quote"."QuoteNumber" AS "Quote__QuoteNumber" AS > > "Quote"__"QuoteNumber" AS "Quote__QuoteNumber" AS > > "Quote"__"QuoteNumber" AS "Quote__QuoteNumber" AS > > "Quote"__"QuoteNumber" AS "Quote__QuoteNumber", "Quote"."Division" AS > > "Quote__Division" AS "Quote"__"Division" AS "Quote__Division" AS > > "Quote"__"Division" AS "Quote__Division" AS "Quote"__"Division" AS > > "Quote__Division", "Quote"."Project" AS "Quote__Project" AS > > "Quote"__"Project" AS "Quote__Project" AS "Quote"__"Project" AS > > "Quote__Project" AS "Quote"__"Project" AS "Quote__Project", > > "Quote"."CustID" AS "Quote__CustID" AS "Quote"__"CustID" AS > > "Quote__CustID" AS "Quote"__"CustID" AS "Quote__CustID" AS > > "Quote"__"CustID" AS "Quote__CustID", "Quote"."Purchaser" AS > > "Quote__Purchaser" AS "Quote"__"Purchaser" AS "Quote__Purchaser" AS > > "Quote"__"Purchaser" AS "Quote__Purchaser" AS "Quote"__"Purchaser" AS > > "Quote__Purchaser", "Quote"."Attn" AS "Quote__Attn" AS "Quote"__"Attn" > > AS "Quote__Attn" AS "Quote"__"Attn" AS "Quote__Attn" AS > > "Quote"__"Attn" AS "Quote__Attn", "Quote"."Fax" AS "Quote__Fax" AS > > "Quote"__"Fax" AS "Quote__Fax" AS "Quote"__"Fax" AS "Quote__Fax" AS > > "Quote"__"Fax" AS "Quote__Fax", "Quote"."Phone" AS "Quote__Phone" AS > > "Quote"__"Phone" AS "Quote__Phone" AS "Quote"__"Phone" AS > > "Quote__Phone" AS "Quote"__"Phone" AS "Quote__Phone", "Quote"."Cell" > > AS "Quote__Cell" AS "Quote"__"Cell" AS "Quote__Cell" AS > > "Quote"__"Cell" AS "Quote__Cell" AS "Quote"__"Cell" AS "Quote__Cell", > > "Quote"."CustPO" AS "Quote__CustPO" AS "Quote"__"CustPO" AS > > "Quote__CustPO" AS "Quote"__"CustPO" AS "Quote__CustPO" AS > > "Quote"__"CustPO" AS "Quote__CustPO", "Quote"."IsOrder" AS > > "Quote__IsOrder" AS "Quote"__"IsOrder" AS "Quote__IsOrder" AS > > "Quote"__"IsOrder" AS "Quote__IsOrder" AS "Quote"__"IsOrder" AS > > "Quote__IsOrder", "Quote"."IncludeDelivery" AS > > "Quote__IncludeDelivery" AS "Quote"__"IncludeDelivery" AS > > "Quote__IncludeDelivery" AS "Quote"__"IncludeDelivery" AS > > "Quote__IncludeDelivery" AS "Quote"__"IncludeDelivery" AS > > "Quote__IncludeDelivery", "Quote"."IncludeGST" AS "Quote__IncludeGST" > > AS "Quote"__"IncludeGST" AS "Quote__IncludeGST" AS > > "Quote"__"IncludeGST" AS "Quote__IncludeGST" AS "Quote"__"IncludeGST" > > AS "Quote__IncludeGST", "Quote"."IncludePST" AS "Quote__IncludePST" AS > > "Quote"__"IncludePST" AS "Quote__IncludePST" AS "Quote"__"IncludePST" > > AS "Quote__IncludePST" AS "Quote"__"IncludePST" AS > > "Quote__IncludePST", "Quote"."IncludeHST" AS "Quote__IncludeHST" AS > > "Quote"__"IncludeHST" AS "Quote__IncludeHST" AS "Quote"__"IncludeHST" > > AS "Quote__IncludeHST" AS "Quote"__"IncludeHST" AS > > "Quote__IncludeHST", "Quote"."Delivery" AS "Quote__Delivery" AS > > "Quote"__"Delivery" AS "Quote__Delivery" AS "Quote"__"Delivery" AS > > "Quote__Delivery" AS "Quote"__"Delivery" AS "Quote__Delivery", > > "Quote"."GST" AS "Quote__GST" AS "Quote"__"GST" AS "Quote__GST" AS > > "Quote"__"GST" AS "Quote__GST" AS "Quote"__"GST" AS "Quote__GST", > > "Quote"."PST" AS "Quote__PST" AS "Quote"__"PST" AS "Quote__PST" AS > > "Quote"__"PST" AS "Quote__PST" AS "Quote"__"PST" AS "Quote__PST", > > "Quote"."HST" AS "Quote__HST" AS "Quote"__"HST" AS "Quote__HST" AS > > "Quote"__"HST" AS "Quote__HST" AS "Quote"__"HST" AS "Quote__HST", > > "Quote"."AppliedDiscount" AS "Quote__AppliedDiscount" AS > > "Quote"__"AppliedDiscount" AS "Quote__AppliedDiscount" AS > > "Quote"__"AppliedDiscount" AS "Quote__AppliedDiscount" AS > > "Quote"__"AppliedDiscount" AS "Quote__AppliedDiscount", > > "Quote"."LastModified" AS "Quote__LastModified" AS > > "Quote"__"LastModified" AS "Quote__LastModified" AS > > "Quote"__"LastModified" AS "Quote__LastModified" AS > > "Quote"__"LastModified" AS "Quote__LastModified", > > "Quote"."LastModifiedBy" AS "Quote__LastModifiedBy" AS > > "Quote"__"LastModifiedBy" AS "Quote__LastModifiedBy" AS > > "Quote"__"LastModifiedBy" AS "Quote__LastModifiedBy" AS > > "Quote"__"LastModifiedBy" AS "Quote__LastModifiedBy", "Quote"."Notes" > > AS "Quote__Notes" AS "Quote"__"Notes" AS "Quote__Notes" AS > > "Quote"__"Notes" AS "Quote__Notes" AS "Quote"__"Notes" AS > > "Quote__Notes", "Quote"."FreightOption" AS "Quote__FreightOption" AS > > "Quote"__"FreightOption" AS "Quote__FreightOption" AS > > "Quote"__"FreightOption" AS "Quote__FreightOption" AS > > "Quote"__"FreightOption" AS "Quote__FreightOption", > > "Quote"."ShipWithJob" AS "Quote__ShipWithJob" AS > > "Quote"__"ShipWithJob" AS "Quote__ShipWithJob" AS > > "Quote"__"ShipWithJob" AS "Quote__ShipWithJob" AS > > "Quote"__"ShipWithJob" AS "Quote__ShipWithJob", "Quote"."WantDate" AS > > "Quote__WantDate" AS "Quote"__"WantDate" AS "Quote__WantDate" AS > > "Quote"__"WantDate" AS "Quote__WantDate" AS "Quote"__"WantDate" AS > > "Quote__WantDate", "Quote"."USFunds" AS "Quote__USFunds" AS > > "Quote"__"USFunds" AS "Quote__USFunds" AS "Quote"__"USFunds" AS > > "Quote__USFunds" AS "Quote"__"USFunds" AS "Quote__USFunds", > > "Quote"."Exchange" AS "Quote__Exchange" AS "Quote"__"Exchange" AS > > "Quote__Exchange" AS "Quote"__"Exchange" AS "Quote__Exchange" AS > > "Quote"__"Exchange" AS "Quote__Exchange", "Quote"."RepFee" AS > > "Quote__RepFee" AS "Quote"__"RepFee" AS "Quote__RepFee" AS > > "Quote"__"RepFee" AS "Quote__RepFee" AS "Quote"__"RepFee" AS > > "Quote__RepFee", "Quote"."PaymentTerms" AS "Quote__PaymentTerms" AS > > "Quote"__"PaymentTerms" AS "Quote__PaymentTerms" AS > > "Quote"__"PaymentTerms" AS "Quote__PaymentTerms" AS > > "Quote"__"PaymentTerms" AS "Quote__PaymentTerms", "Quote"."QSRRef" AS > > "Quote__QSRRef" AS "Quote"__"QSRRef" AS "Quote__QSRRef" AS > > "Quote"__"QSRRef" AS "Quote__QSRRef" AS "Quote"__"QSRRef" AS > > "Quote__QSRRef", "Quote"."CreatedOn" AS "Quote__CreatedOn" AS > > "Quote"__"CreatedOn" AS "Quote__CreatedOn" AS "Quote"__"CreatedOn" AS > > "Quote__CreatedOn" AS "Quote"__"CreatedOn" AS "Quote__CreatedOn", > > "Quote"."BookedOn" AS "Quote__BookedOn" AS "Quote"__"BookedOn" AS > > "Quote__BookedOn" AS "Quote"__"BookedOn" AS "Quote__BookedOn" AS > > "Quote"__"BookedOn" AS "Quote__BookedOn", "Quote"."CreatedBy" AS > > "Quote__CreatedBy" AS "Quote"__"CreatedBy" AS "Quote__CreatedBy" AS > > "Quote"__"CreatedBy" AS "Quote__CreatedBy" AS "Quote"__"CreatedBy" AS > > "Quote__CreatedBy", "Quote"."BookedBy" AS "Quote__BookedBy" AS > > "Quote"__"BookedBy" AS "Quote__BookedBy" AS "Quote"__"BookedBy" AS > > "Quote__BookedBy" AS "Quote"__"BookedBy" AS "Quote__BookedBy", > > "Quote"."AMID" AS "Quote__AMID" AS "Quote"__"AMID" AS "Quote__AMID" AS > > "Quote"__"AMID" AS "Quote__AMID" AS "Quote"__"AMID" AS "Quote__AMID", > > "Quote"."Site" AS "Quote__Site" AS "Quote"__"Site" AS "Quote__Site" AS > > "Quote"__"Site" AS "Quote__Site" AS "Quote"__"Site" AS "Quote__Site", > > "Quote"."UoM" AS "Quote__UoM" AS "Quote"__"UoM" AS "Quote__UoM" AS > > "Quote"__"UoM" AS "Quote__UoM" AS "Quote"__"UoM" AS "Quote__UoM", > > "Quote"."BillID" AS "Quote__BillID" AS "Quote"__"BillID" AS > > "Quote__BillID", "Quote"."BillID" AS "Quote__BillID" FROM > > "BillOfMaterial" AS "Quote" WHERE "IsOrder" = 0 ORDER BY > > "Quote"."CreatedOn" desc LIMIT 25 > > > Does anyone know what is causing it to try to ALIAS every single field > > 6 times to the same name? It's causing my database to choke and I > > don't get any results. > > > Thanks in advance, > > Tracy Barker --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
