Re: Limiting DB_FormBuilder Links

From: Date: Sun, 29 Jan 2006 01:41:11 +0000
Subject: Re: Limiting DB_FormBuilder Links
References: 1 2 3  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-22717@lists.php.net to get a copy of this message
On 1/27/06, Phillip Novess <pnovess@mac.com> wrote: > > Wow! That worked like a charm....... > > Now for a sticky issue....what about compound primary keys with > displayLinks set to 2? I think I'm describing that correctly. > > Form is for Table A, Table A has a linked field to a lookup table - > Table B. > Form for Table A should allow you to select options from Table C that > are joined to Table B's id. However, Table C has a compund key. > Multi-column keys are not supported by DB_DataObject and hence not DB_DataObject_FormBuilder. I'm not sure what you mean about options for A joined to B....You'll need to give us an example. I also suggest you look at crossLinks, tripleLinks, and crossLinkExtraFields. See examples here: http://pear.reversefold.com/example/?table=movie&record=18 > > > Le 27 janv. 06, à 22:35, Phillip Novess a écrit : > > > Is there anyway to limit the number of results returned when using the > > linkDisplay feature of DB_Dataobject_Formbuilder? > > > > Example: I'm using a lookup table with 1000's of records for different > > uses (ie different lookup values for different tables / forms) , but I > > want to return only a subset for display in my select. Allowing the > > user to select only from the relevant set of values. > > > > I'm sure there is a way. I'm just a we little slow today. > > > > well ... Let's say it's friday night ... meanwhile you can achieve this > with the prepareLinkedDataObject callback > > > \ | / > Arnaud Sellenet-Bodin > Dév et dés > http://demental.info > Tel : 05 63 55 24 46 > / | \ > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Justin Patrin

« previous php.pear.general (#22717) next »