Timeout Error Question

[David Berry]

Hi All. I have a SQL Statement on an ASP page that only returns 4 records. When I run it in SQL Server or Query Analyzer it runs in less than a second. When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE, SALES_REP_NAME, DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS JOIN ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno FROM orders WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND PROD_TYPE = 'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER BY CUST_SERVICE.AC CTNO

Any ideas what could be causing this? I upped the Server.ScriptTi meout, Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps.

Dave

[John Blessing]

>>>>>>>>>>>>>>> >>>
"David Berry" <db****@mvps.or g> wrote in message
news:O0******** *****@tk2msftng p13.phx.gbl...
Hi All. I have a SQL Statement on an ASP page that only returns 4 records.
When I run it in SQL Server or Query Analyzer it runs in less than a second.
When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE, SALES_REP_NAME,
DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS JOIN
ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno FROM orders
WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE
BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND PROD_TYPE =
'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER BY
CUST_SERVICE.AC CTNO

Any ideas what could be causing this? I upped the Server.ScriptTi meout,
Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps.

Dave
<<<<<<<<<<<<<<< <<<<<<<<<<<<<

Do you really need the DISTINCTs? Are you likely to get more than one record
with exactly the same info?

Do the fields in your WHERE clause have indexes?

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

[David Berry]

Hi John,

Yes, I need them and no, they don't have indexes. I have no control over
the database. It belongs to the customer and they don't want to change it.
"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
news:yO******** **********@news fep4-glfd.server.ntl i.net...

>>>>>>>>>>>> >>>

"David Berry" <db****@mvps.or g> wrote in message
news:O0******** *****@tk2msftng p13.phx.gbl...
Hi All. I have a SQL Statement on an ASP page that only returns 4

records. When I run it in SQL Server or Query Analyzer it runs in less than a second. When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE, SALES_REP_NAME,
DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS JOIN
ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno FROM orders WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE
BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND PROD_TYPE = 'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER BY
CUST_SERVICE.AC CTNO

Any ideas what could be causing this? I upped the Server.ScriptTi meout,
Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps.

Dave
<<<<<<<<<<<<<<< <<<<<<<<<<<<<

Do you really need the DISTINCTs? Are you likely to get more than one record with exactly the same info?

Do the fields in your WHERE clause have indexes?

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

[Manohar Kamath [MVP]]

Dave,

You can increase the CommandTimeout to a large number, but then you have to
increase ASP script timeout as well. But then, if the time to execute the
query is too long, your browser might just give up. Looks like the table is
large, and as John suggested, the queried columns are not indexed.

One thing you could do is to create a asyncronous query -- where the results
of the query go into a table, etc. Each query can be identified by a number.
You then implement a "Query executing, please wait..." page that checks to
see if the query has completed.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"David Berry" <db****@mvps.or g> wrote in message
news:ep******** ******@TK2MSFTN GP11.phx.gbl...

Hi John,

Yes, I need them and no, they don't have indexes. I have no control over
the database. It belongs to the customer and they don't want to change it.

"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
news:yO******** **********@news fep4-glfd.server.ntl i.net...

>>>>>>>>>>>>>> >>> "David Berry" <db****@mvps.or g> wrote in message
news:O0******** *****@tk2msftng p13.phx.gbl...
Hi All. I have a SQL Statement on an ASP page that only returns 4

records.

When I run it in SQL Server or Query Analyzer it runs in less than a

second.

When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE, SALES_REP_NAME,
DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS JOIN ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno FROM

orders

WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE
BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND

PROD_TYPE =

'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER BY
CUST_SERVICE.AC CTNO

Any ideas what could be causing this? I upped the Server.ScriptTi meout,
Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps.

Dave
<<<<<<<<<<<<<<< <<<<<<<<<<<<<

Do you really need the DISTINCTs? Are you likely to get more than one

record

with exactly the same info?

Do the fields in your WHERE clause have indexes?

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

[Bob Barrows [MVP]]

The CommandTimeout is the relevant property to be setting. Only, you need to
be setting it at the Connection level instead of the Command - you aren't
using the Command object to open the recordset so setting its
CommandProperty will have no effect on the rs.open statement. Do
con.commandtime out=<whatever you need> before opening the recordset. You may
have to up the scripttimeout if the commandtimeout exceeds that value.

Bob Barrows
David Berry wrote:

Hi John,

Yes, I need them and no, they don't have indexes. I have no control
over the database. It belongs to the customer and they don't want to
change it.
"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
news:yO******** **********@news fep4-glfd.server.ntl i.net...

>>>>>>>>>>> >>>>>

"David Berry" <db****@mvps.or g> wrote in message
news:O0******** *****@tk2msftng p13.phx.gbl...
Hi All. I have a SQL Statement on an ASP page that only returns 4
records. When I run it in SQL Server or Query Analyzer it runs in
less than a second. When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

Any ideas what could be causing this? I upped the
Server.ScriptTi meout, Con.ConnectionT imeout and
comCommand.Comm andTimeout and nothing helps.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Kevin]

I have run into the same problem. I'm not sure of the root of the
problem but I have found a workaround I believe.

More than likely I'm going to assume that SERVICE.ACCTNO is an index
value. If you add another non-index value into your query in the
order by clause it should run faster on the web.

So for example just add CONT DATE at the end of your order by clause.

How that helps.

Kevin


"David Berry" <db****@mvps.or g> wrote in message news:<O0******* ******@tk2msftn gp13.phx.gbl>.. .

Hi All. I have a SQL Statement on an ASP page that only returns 4
records. When I run it in SQL Server or Query Analyzer it runs in less
than a second. When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

SELECT DISTINCT CUST SERVICE.ACCTNO As Acct, CONT DATE, SALES REP NAME,
DESCRIP, PROD TYPE, MODE FROM CUST SERVICE CROSS JOIN CUSTOMER CROSS
JOIN ORDERS WHERE (CUST SERVICE.ACCTNO NOT IN (SELECT DISTINCT acctno
FROM orders WHERE oredertype='Blo wout Print' or oredertype='Pri nt'))
AND CONT DATE BETWEEN '12/23/03'AND'12/24/03' AND SALES REP NAME =
'Anne' AND PROD TYPE = 'P' AND CUSTOMER.BILLST = 'ct' AND
ORDERS.orederty pe = 'Print' ORDER BY CUST SERVICE.ACCTNO

Any ideas what could be causing this? I upped the Server.ScriptTi meout,
Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps.

Dave
--

[David Berry]

Hi Manohar. I changed the code to:

Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.Open "file name=e:\micro.u dl"
cn.ConnectionTi meout = 6000
Set cmd = Server.CreateOb ject("ADODB.Com mand")
cmd.ActiveConne ction = cn
cmd.CommandTime out = 6000

Server.ScriptTi meout = 6000

cmd.CommandText = "SELECT ........... "

Set rs = cmd.Execute(cmd .CommandText)

And now I'm getting an error that the operation isn't allowed while the
object is open. The line it points to is

cn.ConnectionTi meout = 6000

Dave

"Manohar Kamath [MVP]" <mk*****@TAKETH ISOUTkamath.com > wrote in message
news:Oj******** ******@tk2msftn gp13.phx.gbl...

Dave,

You can increase the CommandTimeout to a large number, but then you have to increase ASP script timeout as well. But then, if the time to execute the
query is too long, your browser might just give up. Looks like the table is large, and as John suggested, the queried columns are not indexed.

One thing you could do is to create a asyncronous query -- where the results of the query go into a table, etc. Each query can be identified by a number. You then implement a "Query executing, please wait..." page that checks to
see if the query has completed.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"David Berry" <db****@mvps.or g> wrote in message
news:ep******** ******@TK2MSFTN GP11.phx.gbl...

Hi John,

Yes, I need them and no, they don't have indexes. I have no control over

the database. It belongs to the customer and they don't want to change

it.

"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
news:yO******** **********@news fep4-glfd.server.ntl i.net...

>>>>>>>>>>>>>>> >>>
"David Berry" <db****@mvps.or g> wrote in message
news:O0******** *****@tk2msftng p13.phx.gbl...
Hi All. I have a SQL Statement on an ASP page that only returns 4

records.

When I run it in SQL Server or Query Analyzer it runs in less than a

second.

When I run it from my ASP page I get:

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

the error line points to the rs.Open sql,con line.

The SQL Statement is:

SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE, SALES_REP_NAME, DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS

JOIN ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno FROM

orders

WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE
BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND

PROD_TYPE

=

'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER BY CUST_SERVICE.AC CTNO

Any ideas what could be causing this? I upped the Server.ScriptTi meout, Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps.

Dave
<<<<<<<<<<<<<<< <<<<<<<<<<<<<

Do you really need the DISTINCTs? Are you likely to get more than one

record

with exactly the same info?

Do the fields in your WHERE clause have indexes?

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.free-helpdesk.com - Completely free help desk software !
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

[Manohar Kamath [MVP]]

Dave,

Swap the lines to:

cn.ConnectionTi meout = 6000
cn.Open "file name=e:\micro.u dl"

Actually, the connection timeout won't help you much here, since the
connection seems to be fine, and time out happens when query is issued.

Also, move the line Server.ScriptTi meout to the top of the code. It should
ideally be the topmost line. Again, 6000 seconds (100 mins) is way too long
before browser gives up. You might shorten it to say 600 seconds.

I still feel you need to query the database asynchronously, and poll it to
see if the results have been returned.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"David Berry" <db****@mvps.or g> wrote in message
news:eL******** ******@TK2MSFTN GP10.phx.gbl...

Hi Manohar. I changed the code to:

Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.Open "file name=e:\micro.u dl"
cn.ConnectionTi meout = 6000
Set cmd = Server.CreateOb ject("ADODB.Com mand")
cmd.ActiveConne ction = cn
cmd.CommandTime out = 6000

Server.ScriptTi meout = 6000

cmd.CommandText = "SELECT ........... "

Set rs = cmd.Execute(cmd .CommandText)

And now I'm getting an error that the operation isn't allowed while the
object is open. The line it points to is

cn.ConnectionTi meout = 6000

Dave

"Manohar Kamath [MVP]" <mk*****@TAKETH ISOUTkamath.com > wrote in message
news:Oj******** ******@tk2msftn gp13.phx.gbl...

Dave,

You can increase the CommandTimeout to a large number, but then you have

to

increase ASP script timeout as well. But then, if the time to execute the

query is too long, your browser might just give up. Looks like the table

is

large, and as John suggested, the queried columns are not indexed.

One thing you could do is to create a asyncronous query -- where the

results

of the query go into a table, etc. Each query can be identified by a

number.

You then implement a "Query executing, please wait..." page that checks to see if the query has completed.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"David Berry" <db****@mvps.or g> wrote in message
news:ep******** ******@TK2MSFTN GP11.phx.gbl...

Hi John,

Yes, I need them and no, they don't have indexes. I have no control over the database. It belongs to the customer and they don't want to change it.

"John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in message
news:yO******** **********@news fep4-glfd.server.ntl i.net...
> >>>>>>>>>>>>>>> >>>
> "David Berry" <db****@mvps.or g> wrote in message
> news:O0******** *****@tk2msftng p13.phx.gbl...
> Hi All. I have a SQL Statement on an ASP page that only returns 4
records.
> When I run it in SQL Server or Query Analyzer it runs in less than a
second.
> When I run it from my ASP page I get:
>
> Microsoft OLE DB Provider for SQL Server error '80040e31'
>
> Timeout expired
>
> the error line points to the rs.Open sql,con line.
>
> The SQL Statement is:
>
> SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE, SALES_REP_NAME, > DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS

JOIN

> ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno

FROM orders
> WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE > BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND

PROD_TYPE

=
> 'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER

BY > CUST_SERVICE.AC CTNO
>
> Any ideas what could be causing this? I upped the Server.ScriptTi meout, > Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps. >
> Dave
> <<<<<<<<<<<<<<< <<<<<<<<<<<<<
>
> Do you really need the DISTINCTs? Are you likely to get more than one record
> with exactly the same info?
>
> Do the fields in your WHERE clause have indexes?
>
>
>
> --
> John Blessing
>
> http://www.LbeHelpdesk.com - Help Desk software priced to suit all
> businesses
> http://www.free-helpdesk.com - Completely free help desk software !
> http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
>
>

[David Berry]

Hi Manohar,

Thanks! That works now, although it still takes a long time to bring the
page up. I didn't notice I had the lines reversed.

As for "query the database asynchronously, and poll it to see if the results
have been returned. "

Unfortunately I don't know how you do that. Do you have a sample? Also, the
query is being dynamically built based on what they enter into 5 search
criteria fields and I need to do it that way. I'd prefer to use a Stored
Procedure but I have no access to the actual SQL Server box (just a backup
copy locally) and they don't want me creating any Stored Procedures (no idea
why).

Dave

"Manohar Kamath [MVP]" <mk*****@TAKETH ISOUTkamath.com > wrote in message
news:Oq******** ******@TK2MSFTN GP10.phx.gbl...

Dave,

Swap the lines to:

cn.ConnectionTi meout = 6000
cn.Open "file name=e:\micro.u dl"

Actually, the connection timeout won't help you much here, since the
connection seems to be fine, and time out happens when query is issued.

Also, move the line Server.ScriptTi meout to the top of the code. It should
ideally be the topmost line. Again, 6000 seconds (100 mins) is way too long before browser gives up. You might shorten it to say 600 seconds.

I still feel you need to query the database asynchronously, and poll it to
see if the results have been returned.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"David Berry" <db****@mvps.or g> wrote in message
news:eL******** ******@TK2MSFTN GP10.phx.gbl...

Hi Manohar. I changed the code to:

Set cn = Server.CreateOb ject("ADODB.Con nection")
cn.Open "file name=e:\micro.u dl"
cn.ConnectionTi meout = 6000
Set cmd = Server.CreateOb ject("ADODB.Com mand")
cmd.ActiveConne ction = cn
cmd.CommandTime out = 6000

Server.ScriptTi meout = 6000

cmd.CommandText = "SELECT ........... "

Set rs = cmd.Execute(cmd .CommandText)

And now I'm getting an error that the operation isn't allowed while the
object is open. The line it points to is

cn.ConnectionTi meout = 6000

Dave

"Manohar Kamath [MVP]" <mk*****@TAKETH ISOUTkamath.com > wrote in message
news:Oj******** ******@tk2msftn gp13.phx.gbl...

Dave,

You can increase the CommandTimeout to a large number, but then you have

to

increase ASP script timeout as well. But then, if the time to execute the query is too long, your browser might just give up. Looks like the

table

is

large, and as John suggested, the queried columns are not indexed.

One thing you could do is to create a asyncronous query -- where the results

of the query go into a table, etc. Each query can be identified by a

number.

You then implement a "Query executing, please wait..." page that

checks to see if the query has completed.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"David Berry" <db****@mvps.or g> wrote in message
news:ep******** ******@TK2MSFTN GP11.phx.gbl...
> Hi John,
>
> Yes, I need them and no, they don't have indexes. I have no control

over

> the database. It belongs to the customer and they don't want to change it.
>
>
> "John Blessing" <jb@**REMOVE**T HIS**LbeHelpdes k.com> wrote in

message > news:yO******** **********@news fep4-glfd.server.ntl i.net...
> > >>>>>>>>>>>>>>> >>>
> > "David Berry" <db****@mvps.or g> wrote in message
> > news:O0******** *****@tk2msftng p13.phx.gbl...
> > Hi All. I have a SQL Statement on an ASP page that only returns 4
> records.
> > When I run it in SQL Server or Query Analyzer it runs in less than a > second.
> > When I run it from my ASP page I get:
> >
> > Microsoft OLE DB Provider for SQL Server error '80040e31'
> >
> > Timeout expired
> >
> > the error line points to the rs.Open sql,con line.
> >
> > The SQL Statement is:
> >
> > SELECT DISTINCT CUST_SERVICE.AC CTNO As Acct, CONT_DATE,

SALES_REP_NAME,

> > DESCRIP, PROD_TYPE, MODE FROM CUST_SERVICE CROSS JOIN CUSTOMER CROSS JOIN
> > ORDERS WHERE (CUST_SERVICE.A CCTNO NOT IN (SELECT DISTINCT acctno

FROM > orders
> > WHERE oredertype='Blo wout Print' or oredertype='Pri nt')) AND CONT_DATE > > BETWEEN '12/23/03'AND'12/24/03' AND SALES_REP_NAME = 'Anne' AND
PROD_TYPE
> =
> > 'P' AND CUSTOMER.BILLST = 'ct' AND ORDERS.orederty pe = 'Print' ORDER BY

> > CUST_SERVICE.AC CTNO
> >
> > Any ideas what could be causing this? I upped the

Server.ScriptTi meout,

> > Con.ConnectionT imeout and comCommand.Comm andTimeout and nothing helps. > >
> > Dave
> > <<<<<<<<<<<<<<< <<<<<<<<<<<<<
> >
> > Do you really need the DISTINCTs? Are you likely to get more than one > record
> > with exactly the same info?
> >
> > Do the fields in your WHERE clause have indexes?
> >
> >
> >
> > --
> > John Blessing
> >
> > http://www.LbeHelpdesk.com - Help Desk software priced to suit all
> > businesses
> > http://www.free-helpdesk.com - Completely free help desk software

! > > http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
> >
> >
>
>

[Bob Barrows [MVP]]

David Berry wrote:

and they don't want me
creating any Stored Procedures (no idea why).

It must be because they want you to be creating ad hoc queries that will
bring their server to its knees .... ;-)
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.