Re: dbforms2 - chooser, tableprefix

Hi,


>>
>>My table has the following fields:
>>
>>id int
>>position - varchar
>>uri -varchar
>>
>>
>>How has the chooser looks like?
>>
>><dbform:chooser namefield="position" wherefields="id" orderby="l"
>>limit="35"/> ????


This is my dbform-file:

<dbform:form xmlns:dbform="http://bitflux.org/dbforms2/1.0">

     <dbform:fields table="spielerposition">

     <dbform:field name="position" type="text" descr="Position" 
onkeyup="updateUriField('field_position',document.getElementById('field_uri'));">
             </dbform:field>


     <dbform:field name="uri" type="text" descr="uri" 
onkeyup="this.edited = true;"></dbform:field>

     <dbform:chooser namefield="position" wherefields="position" 
orderby="l" limit="35"/>

     </dbform:fields>

</dbform:form>

> 
> 
> "namefield" is the fields which are displayed in the dropdown (you have
> to use the sql function concat() if you want to display more than one
> field there, so for example "concat(uri, ' - ' ,id)")


"position" should be shown --> namefield="position"


> 
> "wherefields" is in which fields it should search, comma seperated

Search for what??? My where field is "position" too. Or should I use "id"?


> 
> "orderby" is which field should be used to sort the result for the output

ok
> 
> "limit" is the max amount of results, which should be displayed in the
> result
ok.
> 
> for blogposts it looks for example this way:
> 
> 
>>Where do I have to define the tableprefix if I use an other prefix like
>>the bxcms-prefix?
> 
> 
> Uuh, no idea if this is already an option somewhere, philipp should
> know, otherwise we have to implement it somehow.

Not so importend at the moment.
> 
> BTW, your computer clock is 3 months off :)


Ups, thanks.
> 
> chregu
> 
-- 
bitflux-cms mailing list
[email protected]
http://lists.bitflux.ch/cgi-bin/listinfo/bitflux-cms