Could CF8 be converting the Tiny Integer type to say a bit/boolean type?
Could you quickly test using an equivalent table but use integer instead
of tiny integer?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, October 15, 2007 8:02 AM
To: CF-Talk
It could be more simple...
All non-zero values are true.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Monday, October 15, 2007 10:57 AM
To: CF-Talk
Subject: Re: Why would this query not return the correct data?
Could CF8 be converting the Tiny Integer
Not personally, but I know http://www.alagad.com/ uses it now...
http://www.boyzoid.com/blog/index.cfm/2007/9/30/New-alagadcom-site-launc
hed
-- Andrew
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 02, 2007 11:56 AM
To: CF-Talk
Subject: Any
What's the difference between QUERY_RESULTS and GIFTREPORTS?
Do things change if you select over query_results and join giftab1?
-- Andrew
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 02, 2007 3:32 PM
To: CF-Talk
Subject: OT: Query Help
Man, I'm
You could try this: http://www.bennadel.com/projects/poi-utility.htm
-- Andrew
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 10:48 AM
To: CF-Talk
Subject: import excel
What is the best way to handle taking in an excel sheet from a person.
You have to parse 20070927 into a date object, something like:
cfset dt_str = 20070827 /
cfset dt = CreateDate(Left(dt_str, 4), Mid(dt_str, 5, 2),
Right(dt_str,2)) /
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 28, 2007 8:51 AM
To: CF-Talk
will let me compare more than one
column in a where clause.
Even if it did, this requires two selects. My understanding is the
sub-select would get ran once for every record in table t. In my case
that's 11 Millions times!
~Brad
-Original Message-
From: Andrew Clark [mailto:[EMAIL PROTECTED
Off the top of my head I get:
select *
from t myT
where (order_num, datetime_created) =
(select order_num, max(datetime_created) from t where order_num
= myT.order_num group by order_num)
Note:
I tested this in postgres, not sql server...
-- Andrew
-Original Message-
From:
This should also work if you want to keep the xmltype in your table:
cfquery name=iXMLorder datasource=sds_dev
INSERT INTO xmlorders
VALUES('69', XMLType(cfqueryparam value=#xmlString#
cfsqltype=cf_sql_clob))
/cfquery
Also, don't forget to use getClobVal() when selecting the xmltype data.
:01.742
Thanks
Andrew
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 26, 2007 3:52 PM
To: CF-Talk
Subject: Re: CF 7 and postgresql odbc/jdbc issue
Andrew Clark wrote:
CF 7.0.2 Standard, PostgreSQL 8.2.5
When going through ODBC
I'm not sure what it does if you try and subtract one month from
March 30th though.
In CF 7 is gives Feb 28
Andrew
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 27, 2007 11:48 AM
To: CF-Talk
Subject: Re: minus 30
On Thursday 27 Sep
Hi All,
I'm having an issue but I'm not sure whether it's an Coldfusion issue or
PostgreSQL issue.
I have an existing server running CF 7.0.2 Standard, connecting to
PostgreSQL 8.2.5 through an ODBC connection.
When I switch the datasource to a JDBC connection, I get errors about
missing
Log4j has a NTEventLogAppender class.
http://logging.apache.org/log4j/docs/api/org/apache/log4j/nt/NTEventLogA
ppender.html
I don't know if this is usable via coldfusion. The NTEventLogAppender
class uses a DLL to call the Windows API, the dll is distributed with
log4j. If coldfusion has the
13 matches
Mail list logo