⚠ In case you've missed it we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This forum is read-only and soon will be archived. ⚠


Member Since 21 Jul 2016
Offline Last Active Dec 06 2016 10:04 AM

Topics I've Started

set relation between table to a view

10 November 2016 - 03:49 PM



I already see that it's possible to set primary key to make crud for a view but I want to make crud from a table and use set relation with a view.

$crud->set_relation('fk_streetcode','my_view','streetname',null,'streetname ASC');

with this definition there's an data base error

 ... JOIN "my_view" as "j447c7032" ON "j447c7032". = "my_table"."fk_streetcode" ...

you can see that the primary key for the view is not define  : there is a point without id_street >> "j447c7032". =


sorry for my english ....


Thank's for your answers

Flexigrid no result search with uppercase in a word

29 July 2016 - 09:13 AM



I'm french (thank's google traduction and sorry for my poor language) and newbie ... so this is my question :

I use the theme flexigrid but when i search "sport" there is no result because this word has a uppercase ("Sport")  in my database.

Have you a idea to solve this problem ?


Thank's a lot