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.
