Computer Stuff

http://windowsxp.mvps.org/Autologon.htm

Dear Sir/Madam:

I dispute the validity of the debt referenced by your agency as account #xxxxx
.This is a formal request to receive verification of the debt, per my rights
under the Fair Debt Collection Practices Act. Additionally, I hereby request
that you send me the name and address of the original creditor, if it is
different from the current creditor. Please be advised that you are required
by law to notify all Consumer Reporting Agencies to whom you have reported
this debt that this debt is disputed.

Under FTC guidelines, I'm invoking my right NOT to EVER be contacted by phone
again regarding this matter. You may send me something in mail, but can never
telephone me again.


Sincerely,
xxxx




Under the Federal Debt Collection Practices Act, you are allowed to challenge
the validity of a debt that a collection agency states you owe to them. Use
this letter and the following form to make the agency verify that the debt is
actually yours and owed by you. Keep a copy for your files and send the letter
registered mail.

Your Name
123 Your Street Address
Your City, ST 01234

ABC Collections
123 NotOnYourLife Ave
Chicago, IL

Date:

Re: Acct # XXXX-XXXX-XXXX-XXXX

To Whom It May Concern:

This letter is being sent to you in response to a notice sent to me on
September 30, 2002). Be advised that this is not a refusal to pay, but a
notice sent pursuant to the Fair Debt Collection Practices Act, 15 USC 1692g
Sec. 809 (b) that your claim is disputed and validation is requested.

This is NOT a request for “verification” or proof of my mailing address, but
a request for VALIDATION made pursuant to the above named Title and Section.
I respectfully request that your offices provide me with competent evidence
that I have any legal obligation to pay you.

Please provide me with the following:

# What the money you say I owe is for;
# Explain and show me how you calculated what you say I owe;
# Provide me with copies of any papers that show I agreed to pay what you say
I owe;
# Provide a verification or copy of any judgment if applicable;
# Identify the original creditor;
# Prove the Statute of Limitations has not expired on this account
# Show me that you are licensed to collect in my state
# Provide me with your license numbers and Registered Agent

At this time I will also inform you that if your offices have reported
invalidated information to any of the 3 major Credit Bureau’s (Equifax,
Experian or TransUnion) this action might constitute fraud under both Federal
and State Laws. Due to this fact, if any negative mark is found on any of my
credit reports by your company or the company that you represent I will not
hesitate in bringing legal action against you for the following:

* Violation of the Fair Credit Reporting Act
* Violation of the Fair Debt Collection Practices Act
* Defamation of Character

If your offices are able to provide the proper documentation as requested in
the following Declaration, I will require at least 30 days to investigate this
information and during such time all collection activity must cease and
desist.

Also during this validation period, if any action is taken which could be
considered detrimental to any of my credit reports, I will consult with my
legal counsel for suit. This includes any listing any information to a credit
reporting repository that could be inaccurate or invalidated or verifying an
account as accurate when in fact there is no provided proof that it is.

If your offices fail to respond to this validation request within 30 days from
the date of your receipt, all references to this account must be deleted and
completely removed from my credit file and a copy of such deletion request
shall be sent to me immediately.

I would also like to request, in writing, that no telephone contact be made by
your offices to my home or to my place of employment. If your offices attempt
telephone communication with me, including but not limited to computer
generated calls and calls or correspondence sent to or with any third parties,
it will be considered harassment and I will have no choice but to file suit.
All future communications with me MUST be done in writing and sent to the
address noted in this letter by USPS.

It would be advisable that you assure that your records are in order before I
am forced to take legal action. This is an attempt to correct your records,
any information obtained shall be used for that purpose.

Best Regards,

Your Signature
Your Name

1. The results of UNION could be ordered (as we can see in the UNION query above) but the ORDER BY clause could be used only with the final resultset — that is, it can refer to the result of the UNION, not to particular queries used in it.

SELECT phone_custid_fn OWNER_ID, phone_phonenum_s
FROM phone
WHERE phone_type_s = 'PHONE' AND phone_salesmanid_fn IS NULL
UNION
SELECT phone_salesmanid_fn, phone_phonenum_s
FROM phone
WHERE phone_type_s = 'PHONE' AND phone_custid_fn IS NULL
ORDER BY 2, 1

You can not use order by in each statement, only at the end of the statement. Note it uses 2, 1 to order.

2. The INTERSECT operator is used to evaluate results returned by two queries but includes only the records produced by the first query that have matching ones in the second. This operator is implemented in Oracle and IBM DB2 UDB but not in Microsoft SQL Server 2000, which uses EXISTS operator for this purpose.

SELECT cust_id_n
FROM customer
INTERSECT
SELECT ordhdr_custid_fn
FROM order_header

It's same as

SELECT cust_id_n
FROM customer
WHERE cust_id_n IN
(SELECT ordhdr_custid_fn
FROM order_header)

MS SQL Server does not have INTERSECT, offering the EXISTS operator instead. The following query could be rewritten in SQL Sever syntax using this operator and a correlated query:

SELECT cust_id_n
FROM customer
WHERE EXISTS
(SELECT ordhdr_custid_fn
FROM order_header
WHERE ordhdr_custid_fn = cust_id_n)

Note: The EXISTS keyword is common for all our "big three" databases, so this query would work for all of them.

While INTERSECT could be replaced with a combination of other SQL methods, it contributes to the clarity of the SQL code and speeds up its execution because it is more optimized than a subquery.

3. When combining the results of two or more queries into a single resultset, you may want to exclude some records from the first query based on what was returned by the second. This keyword is implemented in IBM DB2 UDB only, whereas Oracle uses the MINUS keyword and Microsoft SQL Server 2000 uses EXISTS for the same purpose.

SELECT cust_id_n
FROM customer
MINUS
SELECT ordhdr_custid_fn
FROM order_header;

The DB2 UDB syntax for this query would be identical save for the use of the EXCEPT operator:

SELECT cust_id_n
FROM customer
EXCEPT
SELECT ordhdr_custid_fn
FROM order_header

Microsoft SQL Server 2000 offers the NOT EXISTS operator instead; surprisingly this syntax, while not part of the SQL99 standard, is common to all "big-three" databases. To get the results with the NOT EXISTS operator you need to use a correlated subquery. A correlated subquery differs from a regular subquery in that it accepts a parameter from the outer query as a criterion in the WHERE clause:

SELECT cust_name_s, cust_alias_s, cust_status_s
FROM customer cust
WHERE NOT EXISTS
(SELECT * FROM order_header WHERE ordhdr_custid_fn = cust.cust_id_n)

You need to change it to mode 2 and disable Juliet system if the file name is more than 63 characters long.

Find some files and tar them together:

find . -type f -name "*.java" | xargs tar cvf myfile.tar
or
find . -mtime +37 | xargs tar rf ~/test.tar

The classpath should contain the jar file or the path to the class files, like this:
C:\VSS\PLTS\webapps\pltsweb\WEB-INF\classes>\Sun\AppServer\jdk\bin\javac.exe -classpath c:\sun\appserver\lib\j2ee.jar;c:\vss\plts\webapps\pltsweb\web-inf\classes\;c:\oracle\ora92\jdbc\lib\classes12.zip com\plts\servlets\PLTSMain.java

Here we need to specify full path to the j2ee.jar, classes12.zip in the classpath; also we need to specify the path to any other class files.

One thing to note, the java servlet class is packed in j2ee.jar. You have to install j2ee to get it work