UNION SELECT with db sql-mapper

[Christophe Rolland]

Hello,

I'm searching a way to use UNION on DB\SQL\Mapper with a request like this :

SELECT * FROM table1 where param_1 = :var1 and param_2 = :var2
UNION
SELECT * FROM table1 where param_1 = :var2 and param_2 = :var1

Any idea to do this ?

Thanks for your reply,

Best.

C.

[Paul Herring]

Well that particular example could be written as a single non-union query:

 

$query = [ ' (param_1 = ? and param_2 = ?) or (param_1 = ? and param_2 = ?)', var1, var2, var2, var1 ];

$table->find($query);

But I suspect that what you're after is more complicated?

If so, I'm unsure how to use UNION, other than actually writing it out longhand and using $table->exec().

--
-- You've received this message because you are subscribed to the Google Groups group. To post to this group, send an email to f3-fra...@googlegroups.com. To unsubscribe from this group, send an email to f3-framework...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/f3-framework?hl=en
---
You received this message because you are subscribed to the Google Groups "Fat-Free Framework" group.
To unsubscribe from this group and stop receiving emails from it, send an email to f3-framework...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/f3-framework/13978ff9-10e0-4e56-a506-8e512d29b221n%40googlegroups.com.

--

PJH

[Christophe Rolland]

Hello PJH,

Thanks for your point of view on this question.

The results will be the same on this request.

Best regards,

C.

You received this message because you are subscribed to a topic in the Google Groups "Fat-Free Framework" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/f3-framework/CMOGGho2_Lc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to f3-framework...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/f3-framework/CAEWO_9QxQZK3TQQ7Yarx347%2BVTgY593bxLh5ac8e2y-HUpXeyw%40mail.gmail.com.