On May 15, 1:40 pm, Tom Haskins-Vaughan <[EMAIL PROTECTED]>
wrote:
> Can you show the relevant tables in your schema?
<table name="Activitylog" skipSql="null" abstract="null">
<column name="id" autoIncrement="true" type="INTEGER"
required="true" />
<column name="consumer_id" primaryKey="true" type="INTEGER" />
<foreign-key foreignTable="Consumer">
<reference local="consumer_id" foreign="id" />
</foreign-key>
<column name="staff_id" primaryKey="true" type="INTEGER" />
<foreign-key foreignTable="Contact" onDelete="none"
onUpdate="none">
<reference local="staff_id" foreign="id" />
</foreign-key>
<column name="startdate" primaryKey="true" type="DATE" />
</table>
<table name="Contact" skipSql="null" abstract="null">
<column name="id" autoIncrement="true" type="INTEGER"
required="true" primaryKey="true" autoincrement="true" />
<column name="contacttype_id" type="INTEGER" size="1" />
<foreign-key foreignTable="ContactType" onDelete="none"
onUpdate="none">
<reference local="contacttype_id" foreign="id" />
</foreign-key>
<column name="first_name" type="VARCHAR" size="255" />
<column name="last_name" type="VARCHAR" size="255" />
<column name="address" type="VARCHAR" size="255" />
<column name="address2" type="VARCHAR" size="255" />
<column name="city" type="VARCHAR" default="Boston" size="255" />
<column name="state" type="VARCHAR" default="MA" size="2" />
<column name="zip" type="VARCHAR" size="11" />
<column name="phone" type="VARCHAR" size="15" />
<column name="agency_id" type="INTEGER" />
<foreign-key foreignTable="Agency" onDelete="none"
onUpdate="none">
<reference local="agency_id" foreign="id" />
</foreign-key>
<column name="program_id" type="INTEGER" required="true" />
<foreign-key foreignTable="Program">
<reference local="program_id" foreign="id" />
</foreign-key>
<column name="created_on" type="TIMESTAMP" />
<column name="updated_on" type="TIMESTAMP" />
</table>
>
>
>
> [EMAIL PROTECTED] wrote:
> > I have the following in a partial
> > <?php echo object_select_tag('staff_id', 'getStaff', array (
> > 'related_class' => 'Contact',
> > 'peer_method' => 'getStaff',
> > 'control_name' => 'staff_id',
> > 'include_custom' => 'By',
> > 'include_blank' => false,
> > )); ?>
>
> > in examining my log files, I've realized that there is an sql for
> > every tsime this is called.
>
> > is there a better way?
>
> --
> Tom Haskins-Vaughan
> Temple Street Media: Design and Development for the Web
> [EMAIL PROTECTED] |www.templestreetmedia.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" 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/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
