If enough people do so, I can almost guarantee that the Adobe dev
staff will take notice, and look at including that or a similar
function in the next version of cf.
Based on experience with dealing with empty list elements in list
functions, it may take a long time ;-)
--
Morning Rick,
That did indeed appear to be the main problem mate, along with some funny
characters in the JS file which got copied across when I copied and pasted
from the browser.
I've made those changes and it now appears to be working just peachy!
Thanks mate,
Rob
-Original
Hello All,
Happy New Year!
Question: Iâm running CF8 using the cfexecute tag. Is there a way to capture
return codes when using cfexecute against a bat file or when better yet calling
a *exe directly in a Windows environment?
Iâm try to run some SAS programs via the ColdFusion job
I'm really leaning towards this one. I've heard that it's a little more
in-depth than CFUnited is. Can anyone confirm this?
andy
-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED]
Sent: Monday, December 31, 2007 9:40 PM
To: CF-Talk
Subject: Re: 2008 conferences of
I have a dozen of tables in the sql 2000 db, and need to extract ALL
rows of the tables with ALL column names into one Excel file (with a
dozen of Worksheets) through cf page so that users can download the
entire db as needed.
thx much
Since you need worksheets within an excel file, you'll probably have to use
the Apache POI library.
On Jan 2, 2008 9:38 AM, Tech Gate [EMAIL PROTECTED] wrote:
I have a dozen of tables in the sql 2000 db, and need to extract ALL
rows of the tables with ALL column names into one Excel file (with
this may be helpful to you
http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm
- Christopher Vigliotti
Sr ColdFusion Developer
Goldbelt Raven
On 1/2/08, Tech Gate [EMAIL PROTECTED] wrote:
I have a dozen of tables in the sql 2000 db, and need
_New_ function, not a change (potentially breaking existing applications).
On Jan 2, 2008 3:05 AM, Claude Schneegans [EMAIL PROTECTED] wrote:
If enough people do so, I can almost guarantee that the Adobe dev
staff will take notice, and look at including that or a similar
function in the next
Great! Glad it worked...
Rick
-Original Message-
From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 7:53 AM
To: CF-Talk
Subject: RE: Woops, I've F***ed up my rich text editor.
Morning Rick,
That did indeed appear to be the main
If you mean whatever would have been returned in a cmd prompt, use the
variable attribute and output that.
You can pipe standard output and standard error into a file too:
http://www.adrianlynch.co.uk/post.cfm?postID=22
Adrian
-Original Message-
From: James Blaha
Sent: 02 January 2008
Thank you, Chris.
I need to download all of the tables regardless the order of columns
since the order of columns are not important. In that case, I will
not need to hard-code the column names as to there are a ton of column
names. Do you know of solutions for this?
Thx much
On Jan 2, 2008
cffile.serverfile will give you the name of the uploaded file
im interested how you are doing the conversion after that though
Thanks, Dave. That was exactly the fix for it.
And I'm using the Turbine Video Encoder SDK for this application.
cfquery gives you column names based on your sql select statement. If you
really need to, then I guess cfdbinfo can give you additional information
you're looking for.
On Jan 2, 2008 10:21 AM, Tech Gate [EMAIL PROTECTED] wrote:
Thank you, Chris.
I need to download all of the tables
no need to hard-code the col names. you can get the column names with a sql
statement. there's a 'new fangled' way of doing this in cf8 as well
here's the high-level of how i'd approach this. my code would
1. select the column names
2. loop through the column names in step one and
2a. run
Hi Adrian,
I'm looking to get the standard error information.
I'm trying to setup a tag I found called CFX_Execute this might do the trick.
Thanks,
-Jim
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
I am trying to test a payflow pro account and the CFX tag times out with
a -12 error. Here's the thing, though: it only takes a few seconds for
the timeout to occur once the process is launched BUT there is a 45
second timeout in the tag attribute. Does this indicate anything about
the timeout and
Hi All,
I found a solution that seems to work using cfx_Execute to get the return
codes.
I posted my code below so it help others that come across this thread.
If anyone has other ideas please let me know.
CFX Tag Location: http://www.intrafoundation.com/software/
-Jim
cfset sas_path =
I have to use dates in an xml document. The date comes from the database
like so.
2008-02-01 00:00:00.0
I need to get rid of the time and replace the dashes with periods to make
the format as follows:
2008.02.01
This will be done inside a query loop of maybe 30 records with two
Uh... #dateFormat(theDate,'.mm.dd')#
On Jan 2, 2008 3:02 PM, Mark Fuqua [EMAIL PROTECTED] wrote:
I have to use dates in an xml document. The date comes from the database
like so.
2008-02-01 00:00:00.0
I need to get rid of the time and replace the dashes with periods to make
the
On Jan 2, 2008 12:02 PM, Mark Fuqua [EMAIL PROTECTED] wrote:
I have to use dates in an xml document. The date comes from the database
like so.
2008-02-01 00:00:00.0
I need to get rid of the time and replace the dashes with periods to make
the format as follows:
2008.02.01
Dale,
Flash remoting needs to be turned on and you need to have a channel setup in
remoting config. Look at the file below and check out the adobe devnet at
http://www.adobe.com/devnet/flex/flex_cf.html
WEB-INF/flex/remoting-confi.xml
?xml version=1.0 encoding=UTF-8?
service id=remoting-service
Dale,
Flash remoting needs to be turned on and you need to have a channel setup in
remoting config. Look at the file below and check out the adobe devnet at
http://www.adobe.com/devnet/flex/flex_cf.html
*WEB-INF/flex/remoting-config.xml*
default-channels
channel ref=my-cfamf/
Hi all,
I'm not even sure how to pose this question, so I did a poor job of searching
the archives, if this question has already been answered.
We're running CFMX7 and SQL Server 2000 in Windows2003 Server. I know there
are a variety of ways that one can get CF to talk to a SQL Server box:
We're running CFMX7 and SQL Server 2000 in Windows2003
Server. I know there are a variety of ways that one can get
CF to talk to a SQL Server box: ODBC, JDBC, Named Pipes, and
so on. I don't even pretend to know what all of that really
means. The question is what's the best practice
Okay, that's kind of what I thought. I think the SequeLink thing is what I was
thinking of wrt to the ODBC driver. Thanks, Dave.
ColdFusion only supports JDBC, so you'll be using JDBC. You can either use a
pure Java JDBC driver, or you can connect to ODBC datasources using
SequeLink as a JDBC
This works
#DateAdd(d, 7, 1/28/2008)#
And this works
#DateFormat(startdate, 'yyy.mm.dd')#
I need to combine them. Take the variable startDate, add 7 days and format
it like above in one expression. Is that possible? I know this is wrong,
but something like this:
#DateAdd(d, 7,
no need for evaluate. just need to nest 'em properly.
dateFormat(dateAdd('d', 7, startDate), 'yy.mm.dd')
On Jan 2, 2008 1:49 PM, Mark Fuqua [EMAIL PROTECTED] wrote:
This works
#DateAdd(d, 7, 1/28/2008)#
And this works
#DateFormat(startdate, 'yyy.mm.dd')#
I need to combine them.
If I read you right (add 7 days, then format the new value), something like
this should work:
#DateFormat(DateAdd(d, 7, startdate), 'yyy.mm.dd')#
On Jan 2, 2008 3:49 PM, Mark Fuqua [EMAIL PROTECTED] wrote:
This works
#DateAdd(d, 7, 1/28/2008)#
And this works
#DateFormat(startdate,
You'd wrap the dateformat around the dateadd function, not inside it.
#DateFormat(DateAdd(d,7,startDate),'yyy.mm.dd')#
-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 3:49 PM
To: CF-Talk
Subject: another date format problem
This works
You want to do the DateAdd first (so put it on the inside), then the
DateFormat:
#DateFormat(DateAdd(d,7,startdate), yyy.mm.dd)#
-- Josh
- Original Message -
From: Mark Fuqua [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, January 02, 2008 1:49 PM
Subject:
Thanks guys.
-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 4:49 PM
To: CF-Talk
Subject: another date format problem
This works
#DateAdd(d, 7, 1/28/2008)#
And this works
#DateFormat(startdate, 'yyy.mm.dd')#
I need to combine
Ben,
Search House of fusion for a recent thread on query optimization as well...
There was an interesting issue with a stored proc taking too long and it
turned out to be permissions on the database (made me go hm.)
-mark
-Original Message-
From: Ben Mueller [mailto:[EMAIL
I can't imagine I'm the first person to try to do something like this, so
hopefully you guys can give me some insight! I know this isn't strictly
CF-related -- but I'm hoping some of you have tried to do something like
this in the past.
I'm trying to produce a paginated list of records. The
It's easy in SQL 2005, and very scalable for large rowsets:
WITH PagedResultSet AS (
SELECT
ROW_NUMBER() OVER(ORDER BY LastName ASC, FirstName ASC) AS
RowNumber,
UserID,
Email,
LastName,
FirstName
It's easy in SQL 2005, and very scalable for large rowsets:
snip
I know you're running on 2000... just bite the bullet and upgrade to 2005.
It's already 2008, and SQL Server 2008 is almost here. 2000 is more than a
bit long in the tooth.
Respectfully,
Adam Phillip Churvis
President
_New_ function, not a change (potentially breaking existing
applications).
nope... won't break any existing applications...
Honestly, I think I'm going to stop recommending people use
jsstringformat in general and recommend they use SerializeJSON for
string values instead...
--
s. isaac
If anyone really feels strongly about this, they should create a
function that does what they want, name it something more useful and
specific, and place it on cflib.org
function JSF(s) { return replacelist(s,,',/,\,\',\/); }
The problem isn't that it can't be done -- the problem is that
The problem isn't that it can't be done -- the problem is
that people (programmers) expect it to be bulletproof for a
common situation which it's not... it could be...
I don't know why on earth you'd expect it to be bulletproof for a common
situation, as opposed to behaving like every other
but there's some strange desire to not make it bulletproof
based on a fear of ambiguous problems that might arise from
fixing the specific problem that we know exists.
Yes! I'm much more afraid of ambiguous problems that might be caused
by a change, than I am by the ones I know how to
39 matches
Mail list logo