Re: composite query

2006-11-02 Thread Tim
Hi Bernard, There are many ways to skin a cat... if you look at the Blog tutorial in the manual, there is the add() function: function add() { if (!empty($this->data)) { if ($this->Post->save($this->data)) { $this->flash('Your post

Re: [professionel] Re: composite query

2006-11-02 Thread Bernard Grosperrin
Tim > It sounds to me like you could use arrays, which may negate the need > for all of these elseif's that you describe... maybe combined with a > foreach statement, building the query up inside there? > Thanks you, that make sense, I will look at this. > Your second point, I'm not sure I und

Re: composite query

2006-11-01 Thread Tim
Bernard, It sounds to me like you could use arrays, which may negate the need for all of these elseif's that you describe... maybe combined with a foreach statement, building the query up inside there? Your second point, I'm not sure I understand - the html form will be displayed as part of th

composite query

2006-10-31 Thread Bernard Grosperrin
I have 2 problems I need help with, but I will post 2 messages. first: What would be the best way to have an interactive query? I need to have users able to make a selection in 6 different columns, to build a query with WHERE this and that (6 this and that..), knowing they may select 1, or 2,