2. PHPRunner General questions
  3. [SOLVED]  where.....and query
This topic is locked
[SOLVED]

 where.....and query

 		12/30/2014 12:50:53 PM
PHPRunner General questions
D
 droogers author

Hallo,
I am using a query with two Where conditions:

WHERE tbltest1.field1=0 AND tbltest1.Field3=5
When I tried it the second where condition is lost.

what is wrong ?
Sergey Kornilov admin 12/30/2014

We need more info. Version of PHPRunner, where exactly you put this WHERE clause, how to make it disappear etc.
D
 		droogers author 12/30/2014



We need more info. Version of PHPRunner, where exactly you put this WHERE clause, how to make it disappear etc.


I am using PHPRunner 8.0. I put the where codes in the SQL tab of Query. After that I look to the results tab. Then I see that the second where condition is lost.

When I tried the SQL in PHPmyadmin it is working as it should.
D
 		droogers author 12/31/2014



I am using PHPRunner 8.0. I put the where codes in the SQL tab of Query. After that I look to the results tab. Then I see that the second where condition is lost.

When I tried the SQL in PHPmyadmin it is working as it should.


when I changed over Where clause 1 and 2 it is working..... Very strange. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=76532&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />