Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 385789FB73F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 31 May 2007 04:24:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 00540-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 31 May 2007 04:24:21 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id 8B80C9FB622
	for <pgsql-sql@postgresql.org>; Thu, 31 May 2007 04:24:22 -0300 (ADT)
Received: from webaccess.indicator.be ([10.100.1.7]) by
	interscan.indicator.com with InterScan Message Security Suite;
	Thu, 31 May 2007 09:09:33 +0200
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Thu, 31 May 2007 09:24:19 +0200
Message-Id: <465E9434.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Thu, 31 May 2007 09:24:04 +0200
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: <pgsql-sql@postgresql.org>
Subject: Re: slow query execution
References: <383089.24941.qm@web52712.mail.re2.yahoo.com>
In-Reply-To: <383089.24941.qm@web52712.mail.re2.yahoo.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__Part0C2B1904.0__="
X-imss-version: 2.047
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.172 tagged_above=0 required=5 tests=AWL=0.220,
	BAYES_40=-0.185, FORGED_RCVD_HELO=0.135, HTML_MESSAGE=0.001,
	UNPARSEABLE_RELAY=0.001
X-Spam-Level: 
X-Archive-Number: 200705/203
X-Sequence-Number: 28483

--=__Part0C2B1904.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Am I right in assuming that you're working on a VB application with a =
ListView AxtiveX Control in it?
If so consider putting the value of the ID field of your table in the Tag =
Property of each item in your listview.
By looping over all items in your listview you can then check the property =
for certain values and adjust other properties as required (eg highlight =
them).
Alternatively if you're working with ado you can store the records =
bookmark in the tag property. That's particulary handy when you want=20
to look up information in a recordset when clicking on an item in the =
listview.

>>> Trigve Siver <trigves@yahoo.com> 2007-05-30 21:11 >>>
>----- Original Message ----
>From: Richard Huxton <dev@archonet.com>
>To: Trigve Siver <trigves@yahoo.com>
>Cc: pgsql-sql@postgresql.org=20
>Sent: Wednesday, May 30, 2007 9:05:09 PM
>Subject: Re: [SQL] slow query execution
>
>Trigve Siver wrote:
>>=20
>> I seee...when new data will be added to table, then row numbers =
wouldn''t be valid anymore.
>>=20
>> Hmmm...looked like I need to find other solution.
>
>Try explaining what it is you're trying to achieve, and maybe someone=20
>will be able to suggest a solution.

I need to perform search on some query (which is already shown in Listview =
control) and=20
highlight items that meet search criteria.

thanks=20

Trigve







___________________________________________________________________________=
_________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html=20

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--=__Part0C2B1904.0__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Am I right in assuming that you're working on a VB application with a =
ListView AxtiveX Control in it?</DIV>
<DIV>If so consider putting the value of the ID field of your table in =
the&nbsp;Tag Property of each item in your listview.</DIV>
<DIV>By looping&nbsp;over all items in your listview you can then =
check&nbsp;the property for certain values and adjust other properties&nbsp=
;as required (eg highlight them).</DIV>
<DIV>Alternatively if you're working with ado you can store the records =
bookmark in the tag property. That's particulary handy when you want =
</DIV>
<DIV>to look up information in a recordset when clicking on an item in the =
listview.<BR><BR>&gt;&gt;&gt; Trigve Siver &lt;trigves@yahoo.com&gt; =
2007-05-30 21:11 &gt;&gt;&gt;<BR>&gt;----- Original Message ----<BR>&gt;Fro=
m: Richard Huxton &lt;dev@archonet.com&gt;<BR>&gt;To: Trigve Siver =
&lt;trigves@yahoo.com&gt;<BR>&gt;Cc: pgsql-sql@postgresql.org<BR>&gt;Sent: =
Wednesday, May 30, 2007 9:05:09 PM<BR>&gt;Subject: Re: [SQL] slow query =
execution<BR>&gt;<BR>&gt;Trigve Siver wrote:<BR>&gt;&gt; <BR>&gt;&gt; I =
seee...when new data will be added to table, then row numbers wouldn''t be =
valid anymore.<BR>&gt;&gt; <BR>&gt;&gt; Hmmm...looked like I need to find =
other solution.<BR>&gt;<BR>&gt;Try explaining what it is you're trying to =
achieve, and maybe someone <BR>&gt;will be able to suggest a solution.<BR><=
BR>I need to perform search on some query (which is already shown in =
Listview control) and <BR>highlight items that meet search criteria.<BR><BR=
>thanks <BR><BR>Trigve<BR><BR><BR><BR><BR><BR><BR><BR>_____________________=
_______________________________________________________________<BR>Don't =
pick lemons.<BR>See all the new 2007 cars at Yahoo! Autos.<BR><A href=3D"ht=
tp://autos.yahoo.com/new_cars.html">http://autos.yahoo.com/new_cars.html</A=
> <BR><BR>---------------------------(end of broadcast)--------------------=
-------<BR>TIP 2: Don't 'kill -9' the postmaster<BR></DIV></BODY></HTML>

--=__Part0C2B1904.0__=--