Alright - I was unable to check this at all last night, so I'll try to
answer all the questions in one go here:
The $design configuration is:
var $design = array(
'persistent' => false,
'driver' => 'adodb',
'connect' => 'mssql',
'host' => 'maggie',
'login' => 'blah',
'password' => 'blah',
'database' => 'design'
);
The version of cake is: 1.2.0.6311 beta
As to renaming, the model used to be named 'Order', and it had the
same problem then.
There are no special characters in the fieldnames. Following is a list
of the fields in this table:
BillOfMaterial BillID numeric NULL
BillOfMaterial JobNumber char 10
BillOfMaterial Phase char 1
BillOfMaterial QuoteNumber char 10
BillOfMaterial Division char 10
BillOfMaterial Project char 70
BillOfMaterial CustID int NULL
BillOfMaterial Purchaser char 70
BillOfMaterial Attn char 30
BillOfMaterial Fax char 14
BillOfMaterial Phone char 14
BillOfMaterial Cell char 14
BillOfMaterial CustPO char 14
BillOfMaterial IsOrder bit NULL
BillOfMaterial IncludeDelivery bit NULL
BillOfMaterial IncludeGST bit NULL
BillOfMaterial IncludePST bit NULL
BillOfMaterial IncludeHST bit NULL
BillOfMaterial Delivery decimal NULL
BillOfMaterial GST decimal NULL
BillOfMaterial PST decimal NULL
BillOfMaterial HST decimal NULL
BillOfMaterial AppliedDiscount decimal NULL
BillOfMaterial LastModified datetime NULL
BillOfMaterial LastModifiedBy char 30
BillOfMaterial Notes text 2147483647
BillOfMaterial FreightOption char 12
BillOfMaterial ShipWithJob char 10
BillOfMaterial WantDate datetime NULL
BillOfMaterial USFunds bit NULL
BillOfMaterial Exchange decimal NULL
BillOfMaterial RepFee decimal NULL
BillOfMaterial PaymentTerms char 50
BillOfMaterial QSRRef char 10
BillOfMaterial CreatedOn datetime NULL
BillOfMaterial BookedOn datetime NULL
BillOfMaterial CreatedBy char 30
BillOfMaterial BookedBy char 30
BillOfMaterial AMID numeric NULL
BillOfMaterial Site char 100
BillOfMaterial UoM varchar 2
And as for the controller, how much code from it would you need?
Thanks again for all the help so far,
Tracy
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
