2. PHPRunner General questions
  3. Real Quick ? - SQL query page
This topic is locked

Real Quick ? - SQL query page

 		1/15/2007 11:58:39 AM
PHPRunner General questions
G
 GeddyLee author

Does anyone know if the EXISTS function supported?
It doesn't seem like it, but I just want to make sure I'm not screwing something else up before I give up.
(i.e. Can I do this:

Select *

FROM table

WHERE EXISTS(subquery)<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4388&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />
Thanks

-Brent
G
 		GeddyLee author 1/15/2007

sorry this should read: WHERE EXISTS(subquery)<semicolon>;<end parenthsis>)

not the smiley face...

WHERE EXISTS(subquery)<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=14587&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />
Alexey admin 1/16/2007

Hi,
PHPRunner won't work with your query if subquery contains WHERE keyword.
We work on this and will make PHPRunner support any SQL query.
As for now I recommend you to create a view in database using CREATE VIEW command and use it in PHPRunner.
G
 		GeddyLee author 1/16/2007

Hi,

PHPRunner won't work with your query if subquery contains WHERE keyword.
We work on this and will make PHPRunner support any SQL query.
As for now I recommend you to create a view in database using CREATE VIEW command and use it in PHPRunner.


Ha Thanks!
I knew there was a way to to do this, I just couldn't think of what it was.