On Saturday 23 May 2009, Rick Faircloth wrote:
I've used cfftp in the past and never used sandboxing...and I've disabled
it now and the cfftp is working perfectly. Perhaps that's just a
precaution for someone hosting sites using CF and allows users to use
functionality that uses cfftp?
More
I have been tasked with providing a mechanism to upload/parse/perform a
couple of checks/save CSV data. The current test file is 28,000 records
(~16 columns). I expect this file to grow in size each month, to an
indeterminate number (hundreds of thousands).
It seems that I'll need to set a
I have found that using the Java Line Reader works great. It doesn't
load a text file into memory but will read it line by line which is
perfect for a CSV.
There is a CFC out there called filereader.cfc that should get you started.
J.J.
On Tue, May 26, 2009 at 10:52 AM, Jason Durham
Check out: http://msdn.microsoft.com/en-us/library/ms188365.aspx
For information about preparing data for bulk import, such as the
requirements for importing data from a CSV data file, see...
On Tue, May 26, 2009 at 11:52 AM, Jason Durham jdur...@cti-stl.com wrote:
I have been tasked with
Jason,
This is not what you want to hear but
My advice would be don't use CF to do this. DTS (or SSIS) is quite capable
of doing this in about 1/30 the time that CF is able to do this. One of our
DTS packages consumes a file of over 300k rows in less than 15 seconds every
few minutes. You
Jason Durham wrote:
What do the CF wizards suggest?
Push this work into the database using stored procedures and bulk
loaders. Use ColdFusion to get the file, move it somewhere the database
bulk loader can get to it, fire off the stored procedure, and notify the
user of any results or
Hi,
I'm considering moving my application to a dedicated server.
The package includes Windows 2003 or 2008 at the same price.
Is there a major difference, as far as CF is concerned.
Memory requirements?
Performance?
~|
Want to
Mark Kruger wrote:
Jason,
But if you insist on doing it with CF, don't use CFFILE. Instead read the
lines in one at a time using a line reader technique - that will allow you
to handle one line at a time instead of reding the entire file into memory.
I also recommended pushing the heavy
Raymond,
Is this correct?
cfhttp
url=http://192.147.113.183/scripts/admin/r25_xml/RSSHotEvents.xml;
method=get/cfhttp
cfset objRSS = xmlParse(cfhttp.filecontent) /
cfset Item_Length = arraylen(objRSS.rss.channel.item) /
cfloop index=i from=1 to=8 step=1
cftry
p class=eventsspan
Hello Guys,
Looking for your advice on the best way to create a secure IIS virtual
directory to /CFIDE. My understanding is that certain folders within that need
to web accessible for cfchart,cfform,cfdocument to work, is that correct?
However I don't want to expose my /cfide/administrator
My advice would be don't use CF to do this. DTS (or SSIS) is quite capable
of doing this in about 1/30 the time that CF is able to do this. One of our
DTS packages consumes a file of over 300k rows in less than 15 seconds every
few minutes. You can't get that with CF no matter how hard you try :)
Yes... I was going to mention that but I didn't want to muddy the waters :)
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Tuesday, May 26, 2009 11:10 AM
Try something like:
cfset variables.objRss = XmlParse( xmlUrlLocation ) /!--- you could
do this in CF7 onwards ---
cfset variables.items = XmlSearch(objRss, '//item') /!--- you may
need '//:item' if that doesn't work, but yeh, XPath is the way forward
with cf and xml ---
cfloop from=1
FYI, you can move/copy the js files out of cfide and configure CF to
reference them from the new location.
See http://kb2.adobe.com/cps/000/3e56e2e5.html, and probably other docs
too.
To answer your original question, I lock down the IP addresses that can
access /cfide to prevent anyone from
Looking for your advice on the best way to create a secure IIS virtual
directory to /CFIDE.
My understanding is that certain folders within that need to web accessible
for cfchart,cfform,
cfdocument to work, is that correct? However I don't want to expose my
/cfide/administrator
and
Dominic,
Is this what you are suggesting I do? I don't receive any errors, but
would like to output a statement (There are no events for today)
Why are you suggesting this over the structKeyExists
cfhttp url=RSSHotEvents2.xml method=get/cfhttp
cfset variables.objRss =
+2 for DTS/SSIS
Case in point. Back in the CF 5 (or 6) days I tried to import a 20+ meg MLS
xml file into SQL server using CF (Yeah I know... I had no idea at the
time). The first run just about killed my dev server. After 30-60 seconds
the task manager showed that the machine was using 750 megs
Thanks to everybody who has replied. It appears I need to do some
homework on MS SQL. :)
-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com]
Sent: Tuesday, May 26, 2009 11:03 AM
To: cf-talk
Subject: RE: Parsing large CSVs and inserting in MSSQL
Jason,
This is not
Jason,
Here's a big uh oh for you If you are using MSSQL express you don't
have the SSIS services that come with it. DTS may be possible through
installing the active X controls on the same server - but you may be out of
luck if you want to do SSIS.
-Mark
Mark A. Kruger, CFG, MCSE
(402)
I have a dormant 'roided out MS SQL 2008 Standard box I can use in lieu.
In fact, the plan was to migrate to that after I've built this module.
:)
Thanks for catching that (and for your help).
Jason
-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com]
Sent: Tuesday,
cfset variables.items = XmlSearch(objRss, '//item') /
With this line, you guarantee that variable.items is an array. It may
be empty, but it will always be an array and so you avoid the kind of
validation code that can get messy with CF and XML.
A more poignant example might be if you only
Perfect Dominic, Thanks for your assistance.
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
http://www.esu.edu
slaba...@po-box.esu.edu
-Original Message-
From: Dominic Watson [mailto:watson.domi...@googlemail.com]
Sent:
Can anyone recommend a good MySQL IDE on OS X? So far I've been using
Navicat but it's kind of a joke.
Anyone have one they actually like?
~|
Want to reach the ColdFusion community with something they want? Let them know
on
From MySQL's web site
http://dev.mysql.com/downloads/gui-tools/5.0.html
Wil Genovese
On Tue, May 26, 2009 at 2:54 PM, David McGuigan davidmcgui...@gmail.comwrote:
Can anyone recommend a good MySQL IDE on OS X? So far I've been using
Navicat but it's kind of a joke.
Anyone have one they
You know, I use the MySQL Query Browser on Vista a lot and actually love it.
On OS X however, that app literally crashes on me within 30 seconds of
launching it each and every time, and I've got a completely fresh install of
OS X as of Saturday night with just CS4, Adium, some browsers,
On Tue, May 26, 2009 at 12:54 PM, David McGuigan davidmcgui...@gmail.comwrote:
Can anyone recommend a good MySQL IDE on OS X? So far I've been using
Navicat but it's kind of a joke.
Anyone have one they actually like?
I'm a relatively recent MBP user, so haven't really delved too deeply
Charlie! That app is AWESOME. EXACTLY what I was looking for.
Better windowing, much more attractive, smart shortcuts, inline quick
querier. So slick.
Command 1 2 3. So simple and clever.
There's even a keyboard shortcut to execute your inline query ( though it's
a weird one: Fn + Enter ).
In CSS design articles, it seems to me that I've read of users being able
to apply their own CSS to web pages, often in the context of the visually
impaired modifying things like font size and color. The discussion
usually centers around how to avoid keeping those custom style sheets from
Sorry I missed the earlier thread - but looks like Dominic helped you out.
On Tue, May 26, 2009 at 1:57 PM, Steve LaBadie slaba...@po-box.esu.edu wrote:
Perfect Dominic, Thanks for your assistance.
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg,
DBVisualizer! it rocks for multiple database server types like MSSQL and
MySQL and many more... as long as you have the JDBC drivers for it!
(it's paid though, but fairly priced!)
http://www.dbvis.com/products/dbvis/
2009/5/26 Wil Genovese jugg...@visi.com
From MySQL's web site
Hi,
Does anyone know how to setup a datasource to authenticate with Active
Directory. We are moving away from service accounts on SQL Server and I
need to pass the Windows login credentials through my CF apps to SQL Server
so the user is allowed access to certain views and sprocs. For
Jim McAtee wrote:
I frequent one particular web site (a forum) that I find difficult to
read
due to the choice of skin colors, font face, sizing and line spacing.
Is
there any way in Firefox that I can apply a style sheet to _only_ this
particular web site?
As a *blind* man, I can relate. I
Does anyone know how to setup a datasource to authenticate with Active
Directory. We are moving away from service accounts on SQL Server and I
need to pass the Windows login credentials through my CF apps to SQL Server
so the user is allowed access to certain views and sprocs. For example
in
Thanks Dave, that's what I was afraid of.
Does anyone know how to setup a datasource to authenticate with Active
Directory. We are moving away from service accounts on SQL Server and I
need to pass the Windows login credentials through my CF apps to SQL Server
so the user is allowed access
Just let me start with saying that I'm loving using Windows 7...stable,
slick, *all* my software runs
so much better than in XP (never did used Vista...skipped that
party)...however...
One issue is really getting on my nerds...whenever I try to run the same
code that I've used for
years and just
Rick,
Out of curiosity: you were running production cf on xp and now you are
trying to do the same on win 7?
--
Ryan
On Tue, May 26, 2009 at 6:37 PM, Rick Faircloth r...@whitestonemedia.comwrote:
Just let me start with saying that I'm loving using Windows 7...stable,
slick, *all* my
I use Sequelpro aswell its really good.
Paul
On 26/05/2009, at 4:46 PM, Charlie Griefer wrote:
On Tue, May 26, 2009 at 12:54 PM, David McGuigan
davidmcgui...@gmail.comwrote:
Can anyone recommend a good MySQL IDE on OS X? So far I've been using
Navicat but it's kind of a joke.
Hi, Ryan...
No my production server is a VPS with Win 2003 Server and CF 8.
In my previous post, I'm referring to my dev setup.
On Tue, May 26, 2009 at 7:41 PM, Ryan Letulle bayous...@gmail.com wrote:
Rick,
Out of curiosity: you were running production cf on xp and now you are
trying to
cool, i also have a win 2003 vps but cf7 also a centos railo setup.
--
Ryan
On Tue, May 26, 2009 at 8:45 PM, Rick Faircloth r...@whitestonemedia.comwrote:
Hi, Ryan...
No my production server is a VPS with Win 2003 Server and CF 8.
In my previous post, I'm referring to my dev setup.
Yes I do.
@torrent girlDo you still need it?
--
Ryan
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Yes please send or post.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322815
I think that Dave has basically answered your question but I'll toss
out the notion that if it was acceptable in your environment you could
do the same sort of permissions but at the application level instead
of the db.
CF can do authentication with Active Directory via the CFLDAP tag. You
could
42 matches
Mail list logo