Mark,
There is one Apollo Coders mailing list:
http://tech.groups.yahoo.com/group/apollocoders/
Hua
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2007 12:26 PM
To: CF-Talk
Subject: OT: Is there an Apollo developer's mailing list?
I couldn't
entry&entry=991
getMetrics is not avaiable at all in the multiserver config. Robi Sens's entry
above describes how to get the data output so you can import into excel if you
need graphs and such.
DK
On 8/10/06, Hua Wei <[EMAIL PROTECTED]> wrote:
>
>
> Thanks Terren
log file, which you can't consume in ColdFusion (without
using cffile.)
Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail: [EMAIL PROTECTED]
-Original Message-
From: Hua Wei [mailto:[EMAIL PROTECTED]
Sent: Thursday, August
Hello,
For some reason, I can't get metrics running on our coldfusion 7.0.2 servers
(Enterprise Multiserver Version on windows 2003, window 2000). I got "The
metrics service is not available" error when calling getMetricData function.
I followed the instruction of TechNote "ColdFusion MX: Ena
select *
>From tablename
where patindex('%\%\%',dir) = 0
And patindex('%\%',dir) > 0
-Original Message-
From: Brian Dumbledore [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 4:31 PM
To: CF-Talk
Subject: sql question.
I am using MS-SQL, I couldn't get this to work..
I trie
SELECT
FROM tablename
WHERE sort = (SELECT min(sort) FROM tablename )
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Monday, June 05, 2006 10:07 AM
To: CF-Talk
Subject: Querying for MAX of join table
I have a table that is something like :
+ id
+ sort
+ contact_i
You may want to try
GROUP BY client.id, client.company
Instead of GROUP BY company
-Original Message-
From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 3:50 PM
To: CF-Talk
Subject: Better Way to Query?
Not getting good results from this:
SELECT COUNT (c
Matt,
Ryan Guill's subversion setup might be helpful .
http://www.ryanguill.com/blog/index.cfm/2006/4/11/My-Subversion-Setup
Hua
-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 11:49 AM
To: CF-Talk
Subject: Subversion tips?
I'm looking
Stas,
Seems to me your local mechine doesn't have the East Asian Languages' package
installed, so the mechine only displays blocks for japanese characters .
If you are using MSSQL 2000/2005 and setup the propery collation, the data
(japanese characters) in the table should be fine. You can test
Larry,
Not sure whether this is what you are looking for:
/IDMS/identity/[EMAIL PROTECTED]'Active' and text()='Provost']
Returns this element:
Provost
Hua
-Original Message-
From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005 11:25 AM
To: CF-Talk
Su
Hello All,
I just noticed that if there is a var exceptionVariable for the catch block in
a cfc (code below), CFMX 7.0.1 throws the following error
"Cannot declare local variable excpt twice.
Local variables cannot have the same names as parameters or other local
variables."
This used to work
Gabriel,
I implemented a few with no problem. Fedex service requires a few http header
settings for the request:
requestheader = structnew();
requestheader["Referer"] = "your company name";
requestheader["Host"] = "Fedex gateway Host";
requestheader["Accept"] = "image/gif, image/jpeg,ima
In MSSQL , ROWCOUNT is a Setting for Operations Against Remote Tables
Try this:
SELECT serialnumber, count(*)
FROM inventory
GROUP BY serialnumber
HAVING count(*) > 1
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:54 PM
To: CF-Ta
Ben,
You can take a look at this:
http://www.maxmind.com/app/ccfd_features
It has HTTP service, so could be implemented in colfusion pretty easily.
Hua
-Original Message-
From: Nomad [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 5:42 PM
To: CF-Talk
Subject: Track Visitor
Andy,
You can use cfhttpparam to build an HTTP request.
Example:
Hope this helps.
Hua
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 11:41 AM
To: CF-Talk
Subject: transmitting XML using CFHTTP
I need to transfer som
I replaced USERID and PASSWORD with mine, your code worked fine.
Here is what I got in the cfhttp.FileContent
Express2077020852100NoneREGULAR133.65
code used to test
http://testing.shippingapis.com/ShippingAPITest.dll?API=Rate&XML=Express2077020852100NoneRegular
I think the url of the cfhttp should look like this:
http://testing.shippingapis.com/ShippingAPITest.dll?API=RateV2&XML=#USPSRequest#
Hua
-Original Message-
From: Stan Winchester [mailto:[EMAIL PROTECTED]
Sent: Monday, September 12, 2005 8:28 PM
To: CF-Talk
Subject: USPS test 400 Bad R
Anthony,
According to JRun 4 FAQ
http://www.macromedia.com/software/jrun/productinfo/faq/#g200
"What are the major features of JRun 4?
.
High-performance web container with JSP 1.2 and servlet 2.3 support
.
"
ditchnet-tabs-taglib requires JSP 2.0 spec
Hua
-Original Message-
Fro
Paul, thanks for the suggestion.
I've searched the forums and googled the web, and seems authentication function
is needed for sending emails. My impression is that sending email is more
complicated, as a function getPasswordAuthentication needs to be overridden.
Not sure how to port that to co
t* connecting over SSL...
You might be interested in checking out the Gmail 4 Java api (available at
http://g4j.sourceforge.net/) - at the very least i'm sure you will find some
knowledgeable people on their lists/forums/etc.
Regs,
/t
>-Original Message-
>Subject: Using Jav
Hello All,
Anyone using JavaMail and coldfusion together to send/fetch emails via SSL?
I tried gmail, but got time out errors. Increased the time limit, but didn't
help.
non-ssl emails work fine.
Any suggestions? Thanks in advance
Hua
JavaMail version: 1.3.2
System: CFMX 7 enterprise on windo
You may want to check this techNote:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17282
"Operation must use an updateable query error when trying to update Access
database
This is generally a result of ColdFusion not having appropriate permissions at
the Network Operating S
On MSSQL 2000, try this
SELECT billToAddress1 + ' ' + isnull(billToAddress2,'') AS billToAddress
FROM tbl_orderHeader_archive
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Friday, April 01, 2005 11:11 AM
To: CF-Talk
Subject: SOT: SQL Concatenation
So
On mssql 2000,
alter table [tablename]
alter column [columnname] varchar(2000)
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 10:51 AM
To: CF-Talk
Subject: sql ( ms sql ) alter command
I wish to modify an existing table by increasing the v
(select count(*) as numofjobs from jobs
where jobs.logdatetime = j.logdatetime) from jobs j where j.logdatetime >=
#startdate# and j.logdatetime <= #stopdate#
This assumes that logdatetime is just a date, not a date and time - you might
need to convert to a date part only in the s
Cfcoder,
=
select count(*) as numofjobs, jobPriority, jobNumber
from jobs
where logdatetime >= #startdate# and logdatetime <= #stopdate#
group by logdatetime, jobPriority, jobNumber
order by logdatetime,jobNumber -- if need orderby
=
---
Hello all,
I installed coldfuson mx7 enterprise trial version on redhat linux AS3 machine,
selected multiserver configuration, configured apache (Apache 2.0.46) as the
web server, the installation went well.
During the installation, I tried apache (also tried nobody) as the runtime
user, but
Tony,
How about use millisecond in the datepart
dateDiff(ms,'01/01/1970 00:00:00.000',DATEADD(Day, 22, '01/01/1970'))
however, for milliseconds, the maximum number datediff can produce is 24
days, 20 hours, 31 minutes
Hua
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Se
late
and the text returned from the database is still like
years
From: Hua Wei [mailto:[EMAIL PROTECTED]
Sent: 04 August 2004 14:31
To: CF-Talk
Subject: RE: Coldfusion & UNICODE Characters
Ian,
try on top of your
templates
Hua
-Original Message--
Ian,
try on top of your
templates
Hua
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 9:26 AM
To: CF-Talk
Subject: RE: Coldfusion & UNICODE Characters
I was only using 'iso-8859-1' as an example (sorry to confuse you!)
I used utf-8 in
In MS SQL, you can use CHARINDEX,PATINDEX and STUFF :
CHARINDEX: Returns the starting position of the specified _expression_ in
a character string
PATINDEX: Returns the starting position of the first occurrence of a
pattern in a specified _expression_, or zeros if the pattern is not found,
on all
In ms sql 2000, the fixed database role db_datareader only does the read
access.
-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 11:18 AM
To: CF-Talk
Subject: OT: allow access to database
I have a developer that needs access to a database. They
Mark,
Since tableA and tableB use the same REQUEST.dsn1, you can try this:
Insert into INTO tableB (fieldnameA, fieldnameB, fieldnameC)
SELECT T.field1, T.field2, T.field3
FROM tableA T
WHERE T.userID =
value="#FORM.userID#">
Hua
-Original Message-
From: Mark Leder [mailto:[EMAIL PR
Select *
From billing a
Where (
(select count(*)
from billing b
where a.first_name = b.first_name
AND a.last_name = b.last_name
)
>1)
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 3:35 PM
To: CF-Talk
Subject: OT: SQL question. Someon
Dave,
The CFHTTP URL seems missing "=" after "Symbols".
and you may want to make sure the values are in one line.
Also make sure the values of COLUMNS are in one line.
Hua
URL="">
DC+AGNI&format=sl1d1t1c1ohgv&ext=.csv"
NAME="GetQuotes"
COLUMNS="Symbol,Last_Traded_P
>Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dbo.CallComments_attachment'.
Table CallComments_attachment doesn't exist in the database? Or it isn't
owned by "dbo"?
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 11:52 AM
T
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'Attachment'.
This error says the table "Attachment" doesn't exist in the database.
Does it exist in your DATASOURCE="db"?
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 9:33 AM
I tested on my server, it worked. So the code is fine. You may want to
check your server config.
Hua
-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 9:31 AM
To: CF-Talk
Subject: Web Services and CFMX6.1 -- Why doesn't it work?
I'm at my wit's e
Adam,
You can try this command to add a CF server service on Windows:
{Jrun_home}\bin>jrunsvc -install cfusion2 "Macromedia JRun CFusion2
Server" "Macromedia JRun CFusion2 Server"
Hua
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 10:19
39 matches
Mail list logo
