Ok, sure.
The table is as follows:
CREATE TABLE `orders` (
`id` int(11) NOT NULL auto_increment,
`order_date` datetime NOT NULL default '0000-00-00 00:00:00',
`order_total` float NOT NULL default '0',
`business_id` int(11) NOT NULL default '0',
`package_id` int(11) default NULL,
`option_id` int(11) default NULL,
`advert_start_date` date NOT NULL default '0000-00-00',
`advert_end_date` date NOT NULL default '0000-00-00',
`payment_received` tinyint(1) NOT NULL default '0',
`status` varchar(50) NOT NULL default '',
`ip_address` varchar(20) NOT NULL default '',
`op_description_box` tinyint(1) NOT NULL default '0',
`op_long_description` tinyint(1) NOT NULL default '0',
`op_main_image` tinyint(1) NOT NULL default '0',
`op_link_to_company` tinyint(1) NOT NULL default '0',
`op_images` smallint(6) default '0',
`op_thumbnail_image` tinyint(1) NOT NULL default '0',
`op_large_banner` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
And the view comes out like this:
<div class="orders form">
<?php echo $form->create('Order');?>
<fieldset>
<legend><?php __('Add Order');?></legend>
<?php
echo $form->input('order_date');
echo $form->input('order_total');
echo $form->input('business_id');
echo $form->input('package_id');
echo $form->input('option_id');
echo $form->input('advert_start_date');
echo $form->input('advert_end_date');
echo $form->input('payment_received');
echo $form->input('status');
//echo $form->input('ip_address');
echo $form->input('op_description_box');
echo $form->input('op_long_description');
echo $form->input('op_main_image');
echo $form->input('op_link_to_company');
echo $form->input('op_images');
echo $form->input('op_thumbnail_image');
echo $form->input('op_large_banner');
?>
</fieldset>
<?php echo $form->end('Submit');?>
</div>
I also note that the tinyint/checkbox fields are not picked up by the
automagic either...
Hope you are able to shed some light. I apologise in advance if I have
missed something obvious!
Cheers
Ed
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
