Jump to content


customize add cours


  • Please log in to reply
1 reply to this topic

#1 eamon250d

eamon250d

    Member

  • Members
  • PipPip
  • 29 posts

Posted 22 February 2016 - 07:46 AM

Hi to all ,

I wanted to customize my custom code as follows

I wonder if you have an idea
Thank you

 


SELECT
film.title,
film.courstheorique_date,
fullname ,
film.film_id ,  
film_actor.actor_id
FROM actor, film_actor , film
WHERE actor.actor_id = film_actor.actor_id
AND film_actor.film_id = film.film_id
ORDER BY film.title






1) Step 1
Whene i add new cours :
Insert 'moduleid' into table 'film_actor'


2) Step 2
When i want to add new cours :
After Select for example 'module2'
In the section 'Add all' in the right
Make the display as the result of this query:


SELECT actor.actor_id,actor.fullname FROM actor
WHERE actor.actor_id NOT IN
(SELECT film_actor.actor_id FROM film_actor
WHERE  moduleid <> 2
ORDER BY film_actor.actor_id )



 

 



#2 Amit Shah

Amit Shah

    grocery CRUD Master

  • Advanced Member
  • PipPipPip
  • 1,192 posts
  • LocationMumbai, India

Posted 01 March 2016 - 07:30 AM

Hello my friend, sorry for a delayed response had been very busy / lazy for not to have been attending the forum lately. But a prominent solution for your problem can be found on the following link.

http://grocerycrud.a...al-multiselect/

 

Hope you are able to achieve the solution you desire using the same.

 

Happy GCing :)






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users