I've used PG and CF together just fine with timestamps. What's the actual
table schema look like as output from psql using the \d <table name here>
command?
Justin Buist
Trident Technology, Inc.
4700 60th St. SW, Suite 102
Grand Rapids, MI 49512
Ph. 616.554.2700
Fx. 616.554.3331
Mo. 616.291.2612
On Wed, 1 Aug 2001, Frank Hilliard wrote:
> I'm converting a client site from MS to Linux, using CF Linux and
> Postgres to replace CF Win and MS Access. I've run into this weird
> problem, I can't get any query from a boolian or timestamp field to not lock up the
> CPU.
>
> Here's an example:
> -------------------------------------
>
> SELECT memberid, firstname, lastname, email, optin, timeofvisit
> FROM members
>
> ------------------------------
> First of all this runs fine using phpPgAdmin and the optin field reports
> "Yes" or "No" and the timeofvisit reports the time. If I do this in Cold Fusion it
>works if I leave off the
> "optin" and "timeofvisit" fields. If I add the "optin" boolian field, the CPU goes
>to 98%. Same thing with the "timeofvisit"field. Naturally, I have a lot of yes/no
>switches and
> timestamps and I'm sunk if
> this doesn't work in CF.
>
> I really need some advice.
>
> Frank Hilliard
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
