php-windows Digest 7 Feb 2001 22:51:52 -0000 Issue 433
Topics (messages 5430 through 5449):
Re: warnings and their meanings and fork in particular. ..
5430 by: Asendorf, John
5431 by: Svensson, B.A.T.
MS SQL Question
5432 by: Conover, Ryan
5433 by: Pablo Vera
5434 by: Andrian Pervazov
5441 by: Foley, John
5442 by: Svensson, B.A.T.
5444 by: Svensson, B.A.T.
5445 by: Svensson, B.A.T.
5446 by: Svensson, B.A.T.
20 Million Fresh E-Mail Addresses
5435 by: Luke2
Re: [PHP-DB] Writing to a file on the user's machine.
5436 by: Ben Cairns
COUNT(*) fails in PHP3
5437 by: Piotr Fetras
5447 by: Toby Miller
Re: [PHP] MS SQL Question
5438 by: Wieger Uffink
5439 by: Frank M. Kromann
Slow response from Netscape
5440 by: Doug Brewer
IIS and $PHP_AUTH_USER
5443 by: Shane McBride
Modules not loading
5448 by: Erik Ableson
5449 by: Pablo Vera
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Have you tried using the UNLINK command? www.php.net/unlink unlink ( "d:/home/lineagialla/img/img_colonna1.gif" ); Also, if the system is trying to access the file you are requesting, you're going to have problems. I have a nice long story about that that I'll share with everyone some day at bedtime. John --------------------- John Asendorf - [EMAIL PROTECTED] Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 The benefit to the government of replacing all $1 Federal Reserve notes with $1 coins would be $522.2 million per year, according to estimates of the General Accouting Office released on April 7, 2000. > -----Original Message----- > From: Tomasz Abramowicz [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 5:54 AM > To: php-windows > Subject: [PHP-WIN] warnings and their meanings and fork in > particular... > > > hi, > is there somewhere I can find the possible meaning, > (suggested solutions or something like that) to the > error msgs and warinings? > > I am running php4.0.4pl1 on NT4.0 w/ IIS4.0, > > While trying to delete a file prior to upload i get the > following error, i dont understand what it means > by "fork", the file to delete is there and what im trying > to do is delete the file to the be able to copy a diffrent > file in its place (which has the same filename) but it > doesnt overwrite the file... > > Warning: Unable to fork [del > d:\home\lineagialla\img\img_colonna1.gif] in > D:\home\lineagialla\riservata\index.php on line 177 > > the code i am reffering to is: > > system( "del d:\\home\\lineagialla\\img\\img_colonna1.gif" ); > copy( $userfile, "d:\\home\\lineagialla\\img\\img_colonna1.gif"); > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] >
Maybe there exists a problem for the operation system to create/find a shell to run the del.exe command in? >-----Original Message----- >From: Tomasz Abramowicz [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 07, 2001 11:54 AM >To: php-windows >Subject: [PHP-WIN] warnings and their meanings and fork in >particular... > > >hi, >is there somewhere I can find the possible meaning, >(suggested solutions or something like that) to the >error msgs and warinings? > >I am running php4.0.4pl1 on NT4.0 w/ IIS4.0, > >While trying to delete a file prior to upload i get the >following error, i dont understand what it means >by "fork", the file to delete is there and what im trying >to do is delete the file to the be able to copy a diffrent >file in its place (which has the same filename) but it >doesnt overwrite the file... > >Warning: Unable to fork [del >d:\home\lineagialla\img\img_colonna1.gif] in >D:\home\lineagialla\riservata\index.php on line 177 > >the code i am reffering to is: > >system( "del d:\\home\\lineagialla\\img\\img_colonna1.gif" ); > copy( $userfile, "d:\\home\\lineagialla\\img\\img_colonna1.gif"); >
I am trying to update a table with data from another table within the same database with the following SQL UPDATE common SET common.[Extended Description] = extended.[Extended Description] WHERE common.[id] = extended.[Extended Description] the id is the primary key. I keep getting the following error. Server: Msg 107, Level 16, State 3, Line 1 The column prefix 'extended' does not match with a table name or alias name used in the query. Server: Msg 107, Level 16, State 1, Line 1 The column prefix 'extended' does not match with a table name or alias name used in the query. Anyone have any ideas. Ryan
Ryan: Try it like this: UPDATE common, extended SET common.[Extended Description] = extended.[Extended Description] WHERE common.[id] = extended.[Extended Description] Saludos, Pablo _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Wednesday, February 07, 2001, 9:26:03 AM, Ryan wrote: CR> I am trying to update a table with data from another table within the same CR> database with the following SQL CR> UPDATE common SET common.[Extended Description] = extended.[Extended CR> Description] WHERE common.[id] = extended.[Extended Description] CR> the id is the primary key. I keep getting the following error. CR> Server: Msg 107, Level 16, State 3, Line 1 CR> The column prefix 'extended' does not match with a table name or alias name CR> used in the query. CR> Server: Msg 107, Level 16, State 1, Line 1 CR> The column prefix 'extended' does not match with a table name or alias name CR> used in the query. CR> Anyone have any ideas. CR> Ryan
You don't have a FROM clause. Something like this should work: UPDATE common SET common.[Extended Description] = extended.[Extended Description] FROM common,extended WHERE common.[id] = extended.[Extended Description] "Conover, Ryan" wrote: > > I am trying to update a table with data from another table within the same > database with the following SQL > > UPDATE common SET common.[Extended Description] = extended.[Extended > Description] WHERE common.[id] = extended.[Extended Description] > > the id is the primary key. I keep getting the following error. > > Server: Msg 107, Level 16, State 3, Line 1 > The column prefix 'extended' does not match with a table name or alias name > used in the query. > Server: Msg 107, Level 16, State 1, Line 1 > The column prefix 'extended' does not match with a table name or alias name > used in the query. > > Anyone have any ideas. > > Ryan > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- _________________ Andrian Pervazov Web Developer T 727.502.4537 F 727.823.6523 [EMAIL PROTECTED] www.aspen-interactive.com
The table or view "extended" does not exist in the declared database context. If this table or view is in another database on the same server, use database.table.column (not sure about exact syntax here) John T. Foley Network Administrator Pollak Engineered Products, Actuator Products Division, A Stoneridge Company 195 Freeport Street, Boston MA 02122 ph: (617) 474-7266 fax: (617) 282-9058 The geographical center of Boston is in Roxbury. Due north of the center we find the South End. This is not to be confused with South Boston which lies directly east from the South End. North of the South End is East Boston and southwest of East Boston is the North End. > -----Original Message----- > From: Conover, Ryan [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 07, 2001 10:26 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: MS SQL Question > > I am trying to update a table with data from another table within the same > database with the following SQL > > UPDATE common SET common.[Extended Description] = extended.[Extended > Description] WHERE common.[id] = extended.[Extended Description] > > the id is the primary key. I keep getting the following error. > > Server: Msg 107, Level 16, State 3, Line 1 > The column prefix 'extended' does not match with a table name or alias > name > used in the query. > Server: Msg 107, Level 16, State 1, Line 1 > The column prefix 'extended' does not match with a table name or alias > name > used in the query. > > > Anyone have any ideas. > > > Ryan
Syntax (simplified) UPDATE <table_name> SET <column_name> = {expression | DEFAULT | NULL} FROM <table_source> [,...n] WHERE <search_condition> In the "FROM ... WHERE ..." construction is where you should place the "other" table and the appropriate search conditions. You can try this script to get a grip of it: create table A (a int, b int) create table B (c int, d int) insert into A values (1,1) insert into A values (2,1) insert into A values (3,1) insert into B values (1,4) insert into B values (2,5) update A set b = d from B where a = c select * from A select * from B drop table A drop table B >-----Original Message----- >From: Conover, Ryan [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 07, 2001 4:26 PM >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: [PHP-WIN] MS SQL Question > > >I am trying to update a table with data from another table >within the same database with the following SQL > >UPDATE common SET common.[Extended Description] = extended.[Extended >Description] WHERE common.[id] = extended.[Extended Description] > >the id is the primary key. I keep getting the following error. > >Server: Msg 107, Level 16, State 3, Line 1 >The column prefix 'extended' does not match with a table name >or alias name >used in the query. >Server: Msg 107, Level 16, State 1, Line 1 >The column prefix 'extended' does not match with a table name >or alias name >used in the query. > > >Anyone have any ideas. > > >Ryan > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: >[EMAIL PROTECTED] >
Nope, that's not the problem. it is related to the syntax. He is trying to refer to a table that is not "declared" in the statement, that is an illegal thing to do. What he simply is trying to do (with all the crap cut way) is: UPDATE A SET A.b = B.d WHERE A.a = B.c Nowhere is the table B declared, so the query parser run confused, and reports back: "The column prefix 'extended' does not match with a table name or alias name NOT USED IN THE QUERY" The parser reports this error twice, since the reference to the "undeclared" table are found twice. In principle the parser simply says: RTFM! Happy hacking, Anders >-----Original Message----- >From: Foley, John [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 07, 2001 7:15 PM >To: 'Conover, Ryan'; [EMAIL PROTECTED]; >[EMAIL PROTECTED] >Subject: [PHP-WIN] RE: MS SQL Question > > > > > The table or view "extended" does not exist in the >declared database >context. If this table or view is in another database on the >same server, >use database.table.column (not sure about exact syntax here) > > > John T. Foley > Network Administrator > Pollak Engineered Products, Actuator Products Division, >A Stoneridge >Company > 195 Freeport Street, Boston MA 02122 > ph: (617) 474-7266 fax: (617) 282-9058 > > The geographical center of Boston is in Roxbury. Due north of >the center we find the South End. This is not to be confused with South >Boston which lies directly east from the South End. North of the South >End is East Boston and southwest of East Boston is the North End. > > > >> -----Original Message----- >> From: Conover, Ryan [SMTP:[EMAIL PROTECTED]] >> Sent: Wednesday, February 07, 2001 10:26 AM >> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >> Subject: MS SQL Question >> >> I am trying to update a table with data from another table >within the same >> database with the following SQL >> >> UPDATE common SET common.[Extended Description] = extended.[Extended >> Description] WHERE common.[id] = extended.[Extended Description] >> >> the id is the primary key. I keep getting the following error. >> >> Server: Msg 107, Level 16, State 3, Line 1 >> The column prefix 'extended' does not match with a table >name or alias >> name >> used in the query. >> Server: Msg 107, Level 16, State 1, Line 1 >> The column prefix 'extended' does not match with a table >name or alias >> name >> used in the query. >> >> >> Anyone have any ideas. >> >> >> Ryan > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: >[EMAIL PROTECTED] >
Dear Pablo: You are thinking right (try to give a reference to the table), but your suggestion will most likely generate a "syntax error" message, since the standard syntax (ISO SQL) wont allow such a construction. >-----Original Message----- >From: Pablo Vera [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 07, 2001 4:28 PM >To: [EMAIL PROTECTED] >Subject: Re: [PHP-WIN] MS SQL Question > > >Ryan: > >Try it like this: > > UPDATE common, extended > SET common.[Extended Description] = extended.[Extended Description] > WHERE common.[id] = extended.[Extended Description] > >Saludos, >Pablo >_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > >Wednesday, February 07, 2001, 9:26:03 AM, Ryan wrote: > >CR> I am trying to update a table with data from another table >within the same >CR> database with the following SQL > >CR> UPDATE common SET common.[Extended Description] = >extended.[Extended >CR> Description] WHERE common.[id] = extended.[Extended Description] > >CR> the id is the primary key. I keep getting the following error. > >CR> Server: Msg 107, Level 16, State 3, Line 1 >CR> The column prefix 'extended' does not match with a table >name or alias name >CR> used in the query. >CR> Server: Msg 107, Level 16, State 1, Line 1 >CR> The column prefix 'extended' does not match with a table >name or alias name >CR> used in the query. > > >CR> Anyone have any ideas. > > >CR> Ryan > > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: >[EMAIL PROTECTED] >
ERRATA: The observant reader might already have notice that an extra "NOT" were inserted into the text... I'm sorry for that... >-----Original Message----- >From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 07, 2001 7:57 PM >To: [EMAIL PROTECTED] >Subject: RE: [PHP-WIN] RE: MS SQL Question >"The column prefix 'extended' does not match with >a table name or alias name NOT USED IN THE QUERY">
TO BE REMOVED FROM FUTURE MAILINGS, SIMPLY REPLY TO THIS MESSAGE AND PUT "REMOVE" IN THE SUBJECT. 20 MILLION E-MAIL ADDRESSES FOR ONLY $249 **Over Night International Shipping Included** Many Call This "The "Perfect E-Mail List" Over 20-Million Of The Best E-Mail Addresses Available _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Our research has found that many people have tried one or more of the following... Free Classifieds? (Don't work anymore) Web Site? (Takes thousands of visitors) Banners? (Expensive and losing their punch) E-Zine? (Hope they have a *huge* subscriber list) Search Engines? (Forget it, unless you're in the top 20) S O W H A T W I L L W O R K ? Although often misunderstood, there is one method that has proven to succeed time-after-time. E - M A I L M A R K E T I N G ! ! IT'S A FACT... If you're not using your computer to generate income, GOOD income, you're leaving money on the table. Here's what the experts have to say about E-Mail Marketing: "E-mail is an incredible lead generation tool" -Crains Magazine "A gold mine for those who can take advantage of bulk e-mail programs" - The New York Times "Blows away traditional Mailing" - Advertising Age Here's an example of your potential earnings if you have a product or service that brings you a profit of around $30. Remember, on the Internet, you can make money 7 days a week, 24 hours a day... even while you sleep, orders come from all over the world! Orders Per Day Weekly Monthly Yearly 1 $ 210 $ 840 $ 10,080 2 420 1,680 20,160 3 630 2,520 30,240 5 1,050 4,200 50,400 10 2,100 8,400 100,000 15 3,150 12,600 151,200 THE QUESTION IS... how do you generate those orders? The least expensive and fastest way is through E-Mail Marketing. You want to make some money? I can put you in touch with over 20 million people at virtually no cost. Can you make one cent from each of theses names? If you can you have a profit of over $200,000.00 That's right, I have over 20 Million Fresh email addresses that I will sell for only $249. These are all fresh addresses that include almost every English person on the Internet today, with no duplications. They are all sorted and ready to be mailed. That is the best deal anywhere today! Don't believe it? People are making that kind of money right now by doing the same thing, that is why you get so much email from people selling you their product....it works! These 20 Million email addresses are yours to keep, so you can use them over and over. This offer is not for everyone. If you can not see just how excellent the risk / reward ratio in this offer is then there is nothing I can do for you. To make money you must stop dreaming and TAKE ACTION. Over the past 2 years, we have gained a reputation for having the cleanest, most responsive e-mail address lists in the industry. No one has gone to the work it takes to produce an e-mail address list of this quality. Here's how we prepare our e-mail lists: 1. We clean and eliminate all duplicates. 2. Next, we use a filter list of 400+ words/phrases to clean even more. No address with inappropriate or profane wording survives! 3. Then we use our private database of thousands of known Internet "extremists", those opposed to any kind of commercial e-mail, and kicked off every one we could find. 4. All domains were verified to insure they're valid. 5. And finally, we sorted the list into easy-to-manage packets of 20,000 addresses in simple text (.txt) format that will work with any computer operating system. ****************************************** It is time to order! Shipping is not an issue. ******FedEx next day world wide shipping included******** As soon as we receive payment we will FedEx your e-mail list via CD straight to your door anywhere in the world FedEx next day guaranteed. ******International Orders Welcome********* US funds paid via paypal.com welcomed PayPal is now available in the following countries: Australia Austria Belgium Brazil Canada Denmark France Germany Hong Kong Ireland Israel Italy Japan Mexico Netherlands New Zealand Norway Portugal Singapore South Africa South Korea Spain Sweden Switzerland United Kingdom PayPal.com is very easy to sign up to. They accept wire transfers, checks and credit cards from any of the countries listed above. This payment process is in your own interest of safety. Paypal.com processes all transactions and keeps all your personal information secret. After signing up please send the U.S. equivalent of $249 to [EMAIL PROTECTED] last name Smith. If there is another way you would like to pay please e-mail me at [EMAIL PROTECTED] and I will get back to you. *******Wondering out how to send 20 million E-mails******** I will tell you how/where to download the softwhere you need for free Please NOTE: Congress shall make no law respecting an establishment of religion, or prohibiting the free exercise thereof, or abridging the freedom of speech or of the press; or the right of the people peaceably to assemble, and to petition the Government for a redress of grievances. Amendment I, The US Constitution
Have you thought of using a cookie? As PHP is server side, it cannot write to the users machine, only the server. JavaScript may be able to help you here though, but I cant think of any sotrce code that imediatley springs to mind -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK......"
hi all ! I have problems while executing SQL with aggregation functions, even simple SELECT COUNT(*) FROM aTable stalls. It seems to be a problem in PHP3 itself since other odbc-based applications run well. There is simple but stupid solution for this problem: add "group by" phrase: SELECT COUNT(*) FROM aTable GROUP BY 1 and it goes on. Is it the same in PHP4 ??? piofet
Unfortunately, I don't have PHP3 on Windows, but it works fine for me in PHP3 on Linux and PHP4 on both Windows and Linux. This is also testing with both MySQL and MSSQL in all three scenarios. ----- Original Message ----- From: "Piotr Fetras" <[EMAIL PROTECTED]> To: "<"php-windows"" <[EMAIL PROTECTED]> Sent: Wednesday, February 07, 2001 10:56 AM Subject: [PHP-WIN] COUNT(*) fails in PHP3 > hi all ! > > I have problems while executing SQL with aggregation functions, even simple > > SELECT COUNT(*) FROM aTable > > stalls. It seems to be a problem in PHP3 itself since other odbc-based applications run well. > There is simple but stupid solution for this problem: add "group by" phrase: > > SELECT COUNT(*) FROM aTable GROUP BY 1 > > and it goes on. > Is it the same in PHP4 ??? > > piofet > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] >
Hi Ryan, You could try REPLACE INTO in combination with a select from the second table, instead of UPDATE. For the exact syntax see http://www.mysql.com/doc/R/E/REPLACE.html Maybe you can fit it to your needs. Wieger "Conover, Ryan" wrote: > > I am trying to update a table with data from another table within the same > database with the following SQL > > UPDATE common SET common.[Extended Description] = extended.[Extended > Description] WHERE common.[id] = extended.[Extended Description] > > the id is the primary key. I keep getting the following error. > > Server: Msg 107, Level 16, State 3, Line 1 > The column prefix 'extended' does not match with a table name or alias name > used in the query. > Server: Msg 107, Level 16, State 1, Line 1 > The column prefix 'extended' does not match with a table name or alias name > used in the query. > > Anyone have any ideas. > > Ryan > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED]
The table "extended" is not known to the update command. You shoud use a syntax like this: UPDATE table1 SET table1.field1 = (select field2 from table2 where table2.id=table1.id). - Frank >I am trying to update a table with data from another table within the same >database with the following SQL > >UPDATE common SET common.[Extended Description] = extended.[Extended >Description] WHERE common.[id] = extended.[Extended Description] > >the id is the primary key. I keep getting the following error. > >Server: Msg 107, Level 16, State 3, Line 1 >The column prefix 'extended' does not match with a table name or alias name >used in the query. >Server: Msg 107, Level 16, State 1, Line 1 >The column prefix 'extended' does not match with a table name or alias name >used in the query. > > >Anyone have any ideas. > > >Ryan > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > >
I am experiencing a long delay from Netscape (4.76, Win) when setting cookies. The user submits the form, and it takes 15-20 seconds for a response. The browser states "host contacted, waiting for reply...." It works instantaneously with IE, and on a mac on both browsers. Anyone else experience this? Netscape 6 seems to work OK too. Doug Brewer
I have been trying for days to get IIS to work with authentication. I have a scipt that works great on Apache. It creates a dialog box that asks for the login/password, and no matter what I put it it always fails. Any ideas? - Shane DISCLAIMER: I am by no means an expert on this, or any other, topic...
Title: Modules not loadingI'm seeing an interesting problem here - just installed the CGI version of php4 running under Win32 Apache and php is working, but when I try to call a module function it claims that it's an unknown function:
Call to undefined function: ldap_connect() in d:\apps\apache group\apache\htdocs\test.php on line 7
I've got the ldap.dll file in the extensions folder and I've dropped copies into Winnt and system folders just in case to no avail.
Hints & tips always appreciated,
Erik Ableson
Erik: Did you uncomment the related line in php.ini ?, the one that says: extension = php_ldap.dll and check that the following setting is correctly set: extension_dir = "C:/PHP/extensions/" ; or wherever your extensions are Saludos, Pablo _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Wednesday, February 07, 2001, 3:38:50 PM, Erik wrote: EA> I'm seeing an interesting problem here - just installed the CGI version of EA> php4 running under Win32 Apache and php is working, but when I try to call a EA> module function it claims that it's an unknown function: EA> Call to undefined function: ldap_connect() in d:\apps\apache EA> group\apache\htdocs\test.php on line 7 EA> I've got the ldap.dll file in the extensions folder and I've dropped copies EA> into Winnt and system folders just in case to no avail. EA> Hints & tips always appreciated, EA> Erik Ableson
