Radicore Forum: Application Development » $where clause problem with list1 and read

Home » RADICORE development » Application Development » $where clause problem with list1 and read

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: $where clause problem with list1 and read [message #1549 is a reply to message #1543]

Wed, 13 August 2008 12:01

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

This is what I got in the debugger:

 ***** /ceae/participante(enq1).php 2008-08-13 15:02:57
SELECT SQL_CALC_FOUND_ROWS participante.* FROM participante  WHERE participante.tippart='E' AND participante.participante_id IN (SELECT participante_id FROM part_ent_xref WHERE entidad_id=3)     LIMIT 1 OFFSET 0 =>Count=2

 ***** /ceae/participante(enq1).php 2008-08-13 15:04:06
SELECT SQL_CALC_FOUND_ROWS participante.* FROM participante  WHERE ( participante.participante_id='30' )     LIMIT 1 OFFSET 0 =>Count=1

The first one is when I haven't selected any records (but all are openes when I hit 'read').
The second one is when I select one record and click 'read'.

Report message to a moderator

[Message index]

		$where clause problem with list1 and read By: bonzo_bcn on Wed, 13 August 2008 06:24
		Re: $where clause problem with list1 and add1 By: AJM on Wed, 13 August 2008 06:58
		Re: $where clause problem with list1 and read By: bonzo_bcn on Wed, 13 August 2008 07:05
		Re: $where clause problem with list1 and read By: AJM on Wed, 13 August 2008 07:21
		Re: $where clause problem with list1 and read By: bonzo_bcn on Wed, 13 August 2008 12:01
		Re: $where clause problem with list1 and read By: AJM on Thu, 14 August 2008 08:16
		Re: $where clause problem with list1 and read By: bonzo_bcn on Thu, 14 August 2008 09:35
		Re: $where clause problem with list1 and read By: AJM on Thu, 14 August 2008 10:02
		Re: $where clause problem with list1 and read By: AJM on Mon, 18 August 2008 11:20

Previous Topic:	Problem with two list1 transactions on one table
Next Topic:	How can I achieve retrieving data from different tables and marking them as printed?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 03:29:01 EST 2024

Total time taken to generate the page: 0.01069 seconds