NYCPHP Meetup

[Jeff Siegel]

Tried that...but the problem may lie elsewhere. Just did some more 
searching and found that "ACT! 6.0/5.0/2000/4.0 is not fully ODBC 
compliant."

http://itdomino.act.com/act.nsf/docid/1998081014202501

Jeff

Tim Gales wrote:

> Jeff Siegel writes:
> "I ran SQL Trace to see if the SQL fetch calls failed but 
>  there were no indications of failure. Just wondering if there is 
>  something else I might try."
> 
> ODBC has a trace you can set in its configuration.
> You might give that a shot...
> 
> T. Gales & Associates
> 'Helping People Connect with Technology'
> 
> http://www.tgaconnect.com
> 
> 
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 

-- 
Found on the Simpson's Website:
"Ooooooh, they have the internet on computers now!"


>From hans not junk at nyphp.com  Fri Feb  6 20:13:19 2004
Return-Path: <hans not junk at nyphp.com>
Received: from ehost011-1.exch011.intermedia.net (unknown [64.78.21.3])
	by virtu.nyphp.org (Postfix) with ESMTP id 604A4A8605
	for <talk at lists.nyphp.org>; Fri,  6 Feb 2004 20:13:19 -0500 (EST)
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Fri, 6 Feb 2004 17:13:16 -0800
Message-ID: <41EE526EC2D3C74286415780D3BA9F87772273 at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Excel Annoyances Needed for New Book
Thread-Index: AcPs+HUPj6hOWhM+SDqmBImNn+7r0gAHufjQ
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Subject: [nycphp-talk] FW: Excel Annoyances Needed for New Book
X-BeenThere: talk at lists.nyphp.org
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: NYPHP Talk <talk at lists.nyphp.org>
List-Id: NYPHP Talk  <talk.lists.nyphp.org>
List-Unsubscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=unsubscribe>
List-Archive: <http://lists.nyphp.org/pipermail/talk>
List-Post: <mailto:talk at lists.nyphp.org>
List-Help: <mailto:talk-request at lists.nyphp.org?subject=help>
List-Subscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=subscribe>
X-List-Received-Date: Sat, 07 Feb 2004 01:13:19 -0000


Hi folks,

Please contact Marsee directly if interested.

Thanks,

H


> O'Reilly is pulling together a new book called "Excel Annoyances" and
> we'd like your help! As you might guess from the title, this book aims
> to identify the problems, snarls, quirks, bugs, and just dumb things
> about Excel that drive users nuts. Oh yeah--it also aims to=20
> solve these annoyances, too.
>=20
> If any members of your group use Excel--be they newbies or Excel
> masters--and they have annoyances they'd like to see solved, have them
> email me (marsee at oreilly.com) with "Excel Annoyance" in the subject
> line. Just have them note what version of Excel and Windows (or Mac
> OS) they're using.
>=20
> Thanks for sharing. We'll make sure to get copies of "Excel
> Annoyances" sent to your group shortly after publication.
>=20
>=20
> --Marsee
>=20
>=20
> ***
> An example:
>=20
> LET ME COUNT THE DAYS
>=20
> THE ANNOYANCE: I know you can do date calculations in Excel, whether =
it's
> to find how many days late I am on a car payment or to see how long =
it's
> been since my last haircut. It's pretty easy to determine the number =
of
> days between two dates; just subtract one from the other. But when I =
do
> that, the result is another date! Huh?
>=20
> THE FIX: In a blank worksheet, try this little exercise, which should
> show your age in days:
>=20
> 1. In cell A1, enter your birth date in MM/DD/YYYY format.
>=20
> 2. In cell B1, enter the formula =3Dtoday() to display the current =
date.
>=20
> 3. In cell C1, enter the formula =3Db1-a1.
>=20
> You'll notice that the result of the formula in C1 is some other date,
> which appears to have no correlation to either of the first dates. How
> come? When you enter a formula, Excel matches the formatting of the
> formula's inputs. This works well when you're doing calculations on
> dollar amounts or percentages; the result comes out formatted just
> the way you'd want. But in our example, Excel formatted the formula
> result--a number of days--as a date.
>=20
> ***
>=20
>=20
>=20