Hi Calude, thanks for the relies, however the data is being transferred from ms
excel and sometimes comes in the EU format and sometimes in the US format. i
suppose the only way we can do this is to force the users to put it into eu
format and run it through your tag to see if it is a valid
Hi Qasim
Just wondering if you or anyone else knows whether using this facility will
allow us to get the formatted values out of excel instead of the values before
they are formated for display in excel as this guys tag cfx_excel2query has
cost us alot of work and time that has now been lost
hi marco
have you or anyone else used this, this does look very interesting?
thanks
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Hi Marco,
also do you know how do i download the functions as i cant find anything on the
page
thanks
Ben Nadel created a very nice cfc called POIUtility.cfc. This
ColdFusion
component works with POI to read/write excel spreadsheets. Please look
this
link:
http://www.bennadel.
hi marco
have you or anyone else used this, this does look very interesting?
thanks
do you also know how we download it, thanks
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the
Richard,
this is the link to download that scripts:
http://bennadel.com/index.cfm?dax=blog:474.downloadcodezip
Cheers
Marco Antonio
On Jan 31, 2008 12:23 PM, Richard White [EMAIL PROTECTED] wrote:
hi marco
have you or anyone else used this, this does look very interesting?
thanks
do
geoff wrote:
It's unnecessary to voice your obviously negative opinion of a product
without any sort of request to do so. If you feel the need to vent, why
not vent on the farcry-dev forum where you might let the developers of that
product knowwhat you found so objectionable -- we'd love
While my original request was for pros and cons of CommonSpot. Pros and Cons
of other products are welcomed.
For my needs FarCry is out of the question because it's open source (most
federal agencies poo poo anything that's open source off the bat, because of
support issues).
--
Scott
thanks marco, will look at it now
richard
Richard,
this is the link to download that scripts:
http://bennadel.com/index.cfm?dax=blog:474.downloadcodezip
Cheers
Marco Antonio
On Jan 31, 2008 12:23 PM, Richard White [EMAIL PROTECTED] wrote:
I could think of a few reasons. 1) Hard drive full 2) Anti-virus
insisting on intercepting and scanning spool files as they are written
3) trying to spool too many messages at once or them being too big 4)
some other drive problem.
-Cameron
Ben Doom wrote:
OK, I seem to be missing something
OK, I seem to be missing something here.
Why would CFMail ever timeout? I'm using spooling, so shouldn't it just write
a file to the spool directory and let the scheduled delivery handle anything
that might timeout?
What am I missing?
--Ben Doom
2) Anti-virus insisting on intercepting and scanning spool files as they
are written
I had an issue with McAffee anti-spam causing a problem. It was intercepting
outbound mail it found questionable and just sat until I force ended the
program or time-out. That took hours to find.
Robert B.
Has anyone done a nice CF interface to Jasper other than Ricks work from a few
years back at
http://www.rickroot.com/blog/1/2004/05/Using-JasperReports-with-Coldfusion-MX-61.cfm
?
--
Tom Chiverton
This email is sent for and on behalf of
hi marco,
thanks for this, it sounds good. just wondering if you are also using bens work
or whether you have decided to use jexcel without his work and why, if you dont
mind!!! just need to understand what you think seeing as you know both sides :)
thanks
a snip bit of code would be really
Richard
I'm using jExcel with CF. Running an example with column formatted works
fine. Please look this text from an Excel spreadsheet:
MATRIC NAME LOT VALUE 8545558 JUNIOR VARGAS RIO LUZ 1.522,25
(Brazilian values have a comma to hundred and point to thousand, ok?)
This is the result after
Richard,
my jExcel integration with CF haves 1 year! I tried to send my code for you(
[EMAIL PROTECTED]) but mail returns an error. Do you have another mail
account?
Cheers
Marco Antonio
On Jan 31, 2008 2:39 PM, Richard White [EMAIL PROTECTED] wrote:
hi marco,
thanks for this, it sounds
Summary:
Actually it's more than one question, but let me start with this,
a page has the following javascript code for inserting a link and in its
display section, it used RegExp to show all/any cap {WORD} in navy color.
Status:
a) Without the js, the regExp works fine.
b) With the js, a long
Does anyone know where I can pull a feed of the currency exchange rates.
I have a project that we are processing everything in USD but we need to
have a currency converter that will provide an estimate of the exchange
rate.
So what I was thinking was to pull in the currency rates nightly and
EX.com is what we use. It works really well. The only catch is you can
only hit the webservice 8 times a week. So, basically 1 time a day and
1 goof up a week.
There may be a higher level of service that lets you access the data
more often, but I do not believe they update the data more than
Richard,
hi marco, yes sorry i changed my email to [EMAIL PROTECTED]
excuse me, but what do you mean you have jexcel integration for one year. do
you mean that you have been using the integration for 1 year so are used to
that and have not used ben's component?
thanks very much
Dunno about free but xe.com is around 500 USD a year, I've always used them
for personal use as they have always had a very direct website.
Dominic
On 31/01/2008, Matthew Friedman [EMAIL PROTECTED] wrote:
Does anyone know where I can pull a feed of the currency exchange rates.
I have a
FYI I found a webserver and a tool from Ben Forta that does what I need.
you can see it here.
http://www.xmethods.net/ve2/ViewClient.po?clientid=253283
thanks
Matt
Does anyone know where I can pull a feed of the currency exchange rates.
I have a project that we are processing everything in
I found a webservice that does this for free
write by Ben Forta
http://www.xmethods.net/ve2/ViewClient.po?clientid=253283
Thanks
Matt
Does anyone know where I can pull a feed of the currency exchange rates.
I have a project that we are processing everything in USD but we need to
have a
I am now trying to over lay a transparent png on to a jpeg someone uploads..
I convert the jpeg to a png by reading and it writing it out, but it seems
there are attributes of the image that coldfusion can't adjust, because
whenever I try to over lay I get this:
Overlay operation requires the two
For my needs FarCry is out of the question because it's open source (most
federal agencies poo poo anything that's open source off the bat, because of
support issues).
Actually, that's not a completely accurate statement. The Daemonites have
released FarCry to the public under an open source
I currently have 10+ boxes at HostMySite but we are looking to have a
small footprint at another facility in case of a major issue there.
Does anyone have any feedback on intermedia.net?
Thanks
~|
Adobe® ColdFusion® 8
I've used them and have only had one or two minor issues in the past
5 years. I currently host them and have a client that hosts on them.
I would recommend.
/SS
On Jan 31, 2008, at 11:12 AM, Brian Peddle wrote:
I currently have 10+ boxes at HostMySite but we are looking to have a
small
I'm trying to style a menu, horizontal style where the top-level menu items
have a blue back ground and white text and all sub-menus from there are white
background blue text.
I am not having any luck, I've looked through many blogs and examples on how to
hack that css but have not found a way
Thanks Rey,
I'll let you know...
!k
-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 30, 2008 9:14 PM
To: CF-Talk
Subject: Re: CF-Based CRMs?
Kevin,
When it's ready for beta, email me and I'll get you some press on
Ajaxian.com
Rey
Kevin Aebig
http://alistapart.com/articles/dropdowns/
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
Web Developer
http://William.Seiter.com
-Original Message-
From: Michael Beins [mailto:[EMAIL PROTECTED]
The feds general rule on Open Source is no.
Exceptions being Apache, Sendmail and the like because either they offer
paid support or there's a third party authority who can provide support.
I've downloaded FarCry, I'll play with it, but they really want something
retail..
--
Scott Stewart
I think I do what you want at http://www.it360.ca/ . I adapted the css from
moreericmeyeroncss. Just view/source, it's all there. No tutorial tho
-Original Message-
From: Michael Beins [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 2:09 PM
To: CF-Talk
Subject: cfmenu styling
I have a client uploading a .xls file containing 30k email addresses. I
first need to read that excel file which is fine, reading it with a
excel data source. I then need to parse through to remove all duplicate
emails and then insert into a table.
My system keeps timing out. The last file that
Use cfsetting with a larger timeout?
-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 2:18 PM
To: CF-Talk
Subject: Very Large List Uploads
I have a client uploading a .xls file containing 30k email addresses. I
first need to read that excel
As Ben Forta and others have mentioned via Blog / Discussion groups, etc.
Working with lists / string is going to be inherently slower than working
with arrays and such. So, read from the XLS and push that data into a 1
dimension array and then remove duplicates, etc (functions available on
I have a client uploading a .xls file containing 30k email addresses. I
first need to read that excel file which is fine, reading it with a
excel data source. I then need to parse through to remove all duplicate
emails and then insert into a table.
I would entice the client to download a cheap
On Jan 31, 2008 1:12 PM, Brian Peddle wrote:
I currently have 10+ boxes at HostMySite but we are looking to have a
small footprint at another facility in case of a major issue there.
Does anyone have any feedback on intermedia.net?
Thanks
I hosted with Intermedia.net for about 7 or 8
Has anyone used the CF Charting and graphing tags lately? I have a
portion of our district site that I want to include charts and graphs
for reports. In the past I used PopCharts which was a very cool
application, but the school district does not like to spend that kind of
money. Basically I
CFCHART works ok on simple things, but as soon as you get into any
sort of detail, like drilling down, I'd recommend moving up to Flex.
I had a similar situation where we thought CFCHART would work and in
the end I had to do it all in Flex.
The charting tools work really well, they are in Flash
It should be simple to create a temp table with a unique or PK constraint on
the email address. Set your cftry/catch database statement to empty. Then
loop over that file inserting each email address as you go. When it tries to
insert a dupe record, it would hit the empty catch block and
On 01/02/2008, Matthew Williams [EMAIL PROTECTED] wrote:
Now, will it meet your requirements the same way as CommonSpot? Depends on
your needs. My understanding of CommonSpot is that it makes importing
existing content easy (at least according the docs). You can use a WYSIWIG
editor to
Scott Stewart wrote:
For my needs FarCry is out of the question because it's open source (most
federal agencies poo poo anything that's open source off the bat, because of
support issues).
Didn't they hire you to provide the support? What exactly is your role
if it isn't that?
Jochem
Thanks. I think that this app qualifies as simple. And Flex is not an
option at this point as I am going back into the military and the
district is going to very hard pressed to find a CF developer much less
a flex developer.
Bruce
Alan Rother wrote:
CFCHART works ok on simple things, but as
On 01/02/2008, Scott Stewart [EMAIL PROTECTED] wrote:
For my needs FarCry is out of the question because it's open source (most
federal agencies poo poo anything that's open source off the bat, because of
support issues).
It's a strange mentality given that the standard corporate EULA offers
Wow,
You're the 2nd CF guy I've talked to this week going back into military service.
Be safe
=]
--
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org
~|
Adobe®
Developer
The Gov't expects a COTS product to have it's own support
--
Scott Stewart
ColdFusion Developer
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(919) 874-6229 (home)
(703) 220-2835 (cell)
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent:
See, now, I learn something new every day. I've not looked into importing data
since the 2.x days as most of my new sites have been scratch built. I did try
pushing FarCry for a huge EPA implementation, but they're dead set on
CommonSpot. One of the areas they claimed was lacking was Word/DB
Use Select Distinct.
cfquery name=get_emails datasource=MyExcelDSN
SELECTDISTINCT strEmailAddress
FROM myEmailList
/cfquery
On Jan 31, 2008 2:18 PM, Chad McCue [EMAIL PROTECTED] wrote:
I have a client uploading a .xls file containing 30k email addresses. I
first need to read
Hi,
I just noticed that for special characters like lt; myName at thisEmail
address gt;
the regular and signs would cause display problem (not being displayed),
so, one solution is to transform them before data capture. Any other similar
characters that we should be aware of / be cautious
I wrote the following page to make a many-to-many relationship for a site
search I need but when I test it it returns the product names several
time.something like this:
I just noticed that for special characters like lt; myName
at thisEmail address gt; the regular and signs would
cause display problem (not being displayed), so, one solution
is to transform them before data capture. Any other similar
characters that we should be aware of / be cautious
HTMLEditFormat() ?
On Jan 31, 2008 2:25 PM, Don L [EMAIL PROTECTED] wrote:
Hi,
I just noticed that for special characters like myName at thisEmail address
the regular and signs would cause display problem (not being displayed),
so, one solution is to transform them before data
Why do I get 36 records in my query when there should only be
8? I must be doing something wrong with the AddRow and SetCell???
...
cfloop from=1 to=#listLen(URL.SKUList)# index=i
cfscript
QueryAddRow(getSKUs, #variables.i#);
...
The second, optional argument for
On Jan 31, 2008 2:30 PM, Ali Majdzadeh [EMAIL PROTECTED] wrote:
I wrote the following page to make a many-to-many relationship for a site
search I need but when I test it it returns the product names several
time.something like this:
AH... thanks Dave! That makes sense.
I thought it was the row number that the second attribute represented. Like
QueryAddRow was targeting a row number to insert into the query...
Thanks!
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31,
Thank you, Charlie, you're exactly right, don.
HTMLEditFormat() ?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Thank you a ton, Dave. Oh my my, this sort of thing I knew years ago but now I
totolly forgot, maybe it's two steps forward and one step backward...
These are called metacharacters. Here's a list of HTML metacharacters:
http://www.netstrider.com/tutorials/HTMLRef/ASCII/metacharacters.html
Most
Why do I get 36 records in my query when there should only be 8? I must be
doing something wrong with the AddRow and SetCell???
Im a little fried right now so I need an extra set of eyes.
cfset url.SKUList =
940172000,990082202,990125104,080182700,080182722,940163500,940163518,940163520
So long as you charge Enterprise prices, you should be fine ;). I still don't
get that mentality, but if it's not expensive, then it must not be any good!
Matthew Williams
Geodesic GraFX
www.geodesicgrafx.com/blog
~|
Adobe®
On Jan 31, 2008 2:30 PM, Ali Majdzadeh [EMAIL PROTECTED] wrote:
cfoutput#test.ProductName#/cfoutput would work, but i'm guessing
you want to display the product name once, and related data beneath
it?
http://tutorial150.easycfm.com/
--
Evelyn the dog, having undergone further modification
On Jan 31, 2008 3:02 PM, Ali Majdzadeh [EMAIL PROTECTED] wrote:
On Jan 31, 2008 2:30 PM, Ali Majdzadeh [EMAIL PROTECTED] wrote:
cfoutput#test.ProductName#/cfoutput would work, but i'm guessing
you want to display the product name once, and related data beneath
it?
Hi Everyone,
Take a bunch of interesting feeds, take out the bosh (nonsense), and
only show the stuff that matters
nobosh = Google News + Digg, with a sprinkle of Facebook
Only at nobosh.com:
1. nobosh Algorithms - Advanced algorithms that filter out the bosh
(nonsense) and feature the nobosh
Does DISTINCT in SQL does the same thing or not? I know it
won't be so great like grouping in CFQUERY but someone told
me that I can show data once by using Distinct in SQL.
No, DISTINCT only filters out duplicates from your SELECT. If you select
company name and product name, for example,
Scott,
I am not sure if it is true that Fed Govt will say no to any open source. We
are using FarCry here on one of our largest public website for a Federal
Govt Agency.
Thanks
Qasim
On Jan 31, 2008 2:42 PM, Scott Stewart [EMAIL PROTECTED] wrote:
The feds general rule on Open Source is no.
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 31, 2008 10:18 AM
To: CF-Talk
Subject: RE: Paperthin's Commonspot
For my needs FarCry is out of the question because it's open source (most
federal agencies poo poo anything that's open source off
FarCry is open source but you will see lots of companies like
Figleaf and others fully supporting it down to training, etc.
Just to clarify, we don't do any work with FarCry currently. We do quite a
bit of work with CommonSpot, though. When we evaluated CMSs, we found
CommonSpot to be the best
http://nobosh.com/
Please do not hesitate to contact me to discuss the site further. I
look forward to everyone's review and the opportunity to discuss the
future
of the project.
You have a typo. Is see Please Regiser here when I click on comments...
Other than that, nice site, nice
CommonSpot spot is really expensive... What do you get
from CommonSpot that FarCry does not provide for free?
Other than the hosted solution option, which is
great...
N
--- Dave Watts [EMAIL PROTECTED] wrote:
FarCry is open source but you will see lots of
companies like
Figleaf and
I think they are both good products.
But CommonSport is a CMS and FarCry is a CMS and more.
I think the and more can be hard to get your head around and makes it seem
overly complicated.
But we use it where I work it is far better than the paid one we used to
use.
Regards
Dale Fraser
see if this helps:
http://feeds.feedburner.com/~r/ajaxian/~3/213173675/ext-20-and-coldfusion
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
ColdFusion wrote:
Anyone using the ext js functions on a CF site?
~|
I've used Ext 2 with CF with great success so far.
On Feb 1, 2008 11:26 AM, ColdFusion [EMAIL PROTECTED] wrote:
Anyone using the ext js functions on a CF site?
I am trying to setup the basic files needed to use the messagebox functions
and then maybe some others but right now just the one.
Anyone using the ext js functions on a CF site?
I am trying to setup the basic files needed to use the messagebox functions
and then maybe some others but right now just the one.
http://extjs.com/
http://extjs.com/deploy/dev/examples/message-box/msg-box.html
I thought I pulled the
I've done a lot with utilizing the underlying 1.1 in the CF8 Ajax
components, as well as some extensive pieces using straight Ext, both
1.1 and 2.0. Great fun.
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
Can you post your code?
If you are using Firefox and fireBug you can see if there extJS files
are actually being loaded, I am guessing that this is the case.
On 2/1/08, ColdFusion [EMAIL PROTECTED] wrote:
Anyone using the ext js functions on a CF site?
I am trying to setup the basic files
Should have read the rest of the question, sorry.
Look at Dan Vega's cfext project on RIAForge. He's already written a
custom tag set specifically for working with simple message boxes in Ext
2.0.
http://cfext.riaforge.org/
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia
BTW, if you try to create a MessageBox that is tied to an existing DOM
element, by using the 'el' attribute in the config, then you want to
make sure your object initialization code is written inside some kind of
document.ready function (I use JQuery, but Ext 2.0 has a built in
construct). If
Ext,get is a core function of extJS.
Has nothing to do with his problem Cutter:-)
However, I have not only used extJS on many projects and have used it
with extreme confidence. As well as interfacing the V1.0 that
Coldfusion uses.
So any questions, please ask away.
As for good libraries. This
Oh nice, thank for the heads up on that one. I really love the vegan
conditions of use!
On Feb 1, 2008 12:52 PM, Andrew Scott [EMAIL PROTECTED] wrote:
As for good libraries. This is the best one on hte internet today. Yes
it is written in JSTL, but it is very usable in cfmx6+
Paul,
I appreciate you talking to the time to review the site. I've made the
update to the story detail page. nice catch! Little embarrassed about
that, but happy to quickly resolve.
You'll need to register to fully see everything the site offers.
Viewing History, feeds etc.. Obviously I highly
ok that's awesome. Its nice to see something new and
fast. I especially like how its new and fast! :)
how'd you come up with the idea? How long did it take
to build? Who did the design and algorithms?
--- BA Hellman [EMAIL PROTECTED] wrote:
Hi Everyone,
Take a bunch of interesting feeds,
On 01/02/2008, Dave Watts [EMAIL PROTECTED] wrote:
Just to clarify, we don't do any work with FarCry currently. We do quite a
bit of work with CommonSpot, though. When we evaluated CMSs, we found
CommonSpot to be the best match with our client base. That's not meant as a
criticism of FarCry,
Do you have some code to look at? You're either missing a file or you
have them in the wrong order.
Rey...
Ext JS Core Team Member
ColdFusion wrote:
Anyone using the ext js functions on a CF site?
I am trying to setup the basic files needed to use the messagebox functions
and then
This site sounds like it will take all of your time doing moderation.
One of my friends started a similar site but with mechanics.
Also you might run into problems with profitableness, because the best
advertising/sponsoring could come from someone who might have people
on your site who hate
It sounds like a lawsuit trap to me.
The only way to keep it factual is if you moderate posts and control
what people say. Once you do that, then you are no longer protected
under safe harbor provisions.
All that said, even if you're in the right in terms of free speech,
that won't
What about the flip-side of that coin ... A site for employers to
review their contracted hire. Why not build both into the site with
the ability to tag them together and to facilitate conflict
resolution? This could be quite the lucritive venture if done
properly.
On 1/31/08, Joseph Smuzynski
*cough* liability *cough*
Seeing as how it is anonymous, companies would come after the site
owner for anything they feel is untruthful (you know, the beyond the
shadow of a doubt type thing). Be careful trying to recreate a
judicial court.
On Jan 31, 2008 5:05 PM, Joseph Smuzynski [EMAIL
Trevor:
That's an interesting idea. I'll admit the idea crossed my mind, but I
quickly dismissed it, because of the name-mentioning necessity. Since many
consultants are individuals, or their business name is their name, it would
end up being finger-pointing. If we could come up with a way to
Checkbox criteria would definitely make it much better.
On Jan 31, 2008, at 3:42 PM, Joseph Smuzynski wrote:
Trevor:
That's an interesting idea. I'll admit the idea crossed my mind,
but I
quickly dismissed it, because of the name-mentioning necessity.
Since many
consultants are
Sometimes it's best just to learn from your bad experiences and just
move on. Spending too much time stewing (in public) can be very
counter-productive.
-Cameron
Joseph Smuzynski wrote:
After dealing with a few too many disreputable companies, I'm just about
ready to build a new site that
Some of the issues I have encountered in the past is temp tech jobs
recruiting for other contractors an the other subcontractor being the
worst link in the chain.
I started working on a project once with about 50 people and most
contractors rapidly dropped off because of harsh treatment
What about the flip-side of that coin ... A site for employers to
review their contracted hire. Why not build both into the site with
the ability to tag them together and to facilitate conflict
resolution? This could be quite the lucritive venture if done
properly.
The way I understand it,
91 matches
Mail list logo