Re: [ACFUG Discuss] Can I Remove the URL from Child Windows?

[Dawn Hoagland]

I can't answer the child window question (because I haven't touched CF\HTML
in about 4 years now) - BUT - the PDF is simply a standardized file
format.  Adobe Acrobat is one of *many* applications that can read, create
and edit PDF files.  I don't see PDF going away for the foreseeable future.
(YMMV)

There are may free applications out there as well.

Some thoughts on file format changes for audio.  You could embed links that
go to a file that takes a parameter to play the desired - then write
something to allow the associated file to be played - and this will allow
you to make it file type agnostic.  If you have to convert everything to
MP4 (for instance) - update the "launcher" page to point to the new file
name and not have to change your PDF.


On Fri, Sep 9, 2016 at 9:19 AM, Peyton Todd  wrote:

> Hello Everyone,
>
> I, too, am glad to know this list still exists, since I have a question.
> To identify myself briefly, I’m a former member of the group, now retired,
> so I no longer write Cold Fusion code. My question concerns a research
> project that I presented to the group a few years ago, when members were
> asked to describe their work regardless of its relevance to Cold Fusion.
> The project is about the speech of a hearing child of deaf parents, and I’m
> hoping one of you with knowledge of HTML and Javascript can help me choose
> between two ways of presenting the data.
>
> I apologize for the great detail of this post, but I can get to my
> question right away before going into all that detail:
>
> *Does anyone know how to make the URL disappear in a child HTML window? If
> not, then is there some other simple way to get the effect I want?*
>
> Apparently the standard way would have been to set location=no when
> specifying the parameters to the window.open command. But that doesn’t
> work, and I remember reading somewhere that the W3C has decided to disable
> it. Is there some other way to make the URL disappear? Or maybe an
> alternate way to get a child window? (I thought of having DIVs that are set
> display=block or display=none, but apparently the user would not be able to
> move them around on the screen (No doubt it could be done via buttons that
> reset their left and top properties, but that would not be simple to
> program, and I need the ability for multiple windows to be open at the same
> time, which would make it even more complicated.)
>
> Admittedly this has only to do with aesthetics, but I want it to be as
> pretty as possible!
>
> To see what I have so far, please download the little folder at the
> Dropbox link below, and click on “testvideotag.htm” to test it. (It works
> in chrome, firefox, opera, and safari, but not in internet  explorer.)
>
> https://www.dropbox.com/sh/x8guh0m7ll5hrr8/AAAJkZjCRKMv7XSKrL2SGF7sa?dl=0
>
> The other approach I’m investigating may not tap the expertise of most
> ACFUG participants, but I’ll present it in case anyone has a suggestion. It
> uses PDFs, and if you want to see what it looks like you could download the
> little PDF at this other Dropbox link and run it (“PDF Version.pdf”):
>
> https://www.dropbox.com/s/9ghu3l5fkfj2t7i/PDF%20Version.pdf?dl=0
>
> The PDF version  doesn’t display the ugly URL, of course, but my fear is
> that Adobe will disable my PDF solution some day – a matter I’ll probably
> have to check with Acrobat experts about, but in case anyone has ideas
> about it please let me know.
>
> When I describe my PDF solution, you’ll see why I fear Adobe will disable
> it: I like my interface the way it is: little icons that don’t take up
> screen space the way opening video inside the page would (there will be
> many hundreds of these!). And I like my audio icons the way I have them,
> too. If I attach MP3 (i.e. H264) audio to an icon via the sound tool (as in
> the leftmost ‘speaker’ icon in my PDF), it plays, but then the standard
> Acrobat audio interfaces jumps in and takes over the icon – too small to be
> operative.
>
> If I attach the audio it to a button-icon instead, then everything works
> perfectly (as in the rightmost ‘speaker’ icon). But here’s what makes me
> think Abobe would some day pull the rug out from under me: with the sound
> tool, one is forced to use H.264 (a WAV file is legacy, and leads to the
> ‘Do you trust this?’ warning – painful when one must open hundreds of these
> little PDFs. And the legacy method is now blocked over the internet
> anyway).
>
> But if I attach sound to a button, only WAV files seem available as a
> choice. Remarkably, MP3s are not available for choosing even though they’re
> in the same folder as the WAV file. So if WAV files are a security hole
> when using the sound tool (forcing one to use H/264 like MP3), why would
> they not be when attached to a button? And if they are, then Adobe will
> discover the problem and fix it some day, thus disabling the many hundreds
> of PDFs I will have prepared by then!
>
> I should mention that I have Acrobat 9 Pro Extended, from which n

Re: [ACFUG Discuss] Re: cfspreadsheet etc. question

[Dawn Hoagland]

FWIW - it's been a while - but I had issues using the pure CF
implementation of POI for several things.  I started doing my spreadsheet
manipulation in pure java\POI - and loaded the later, FULL POI in order to
it (using javaloader).

I wish I could give you examples, but it's been a couple of years since
I've messed with it.


On Mon, Mar 17, 2014 at 2:19 PM, Charlie Arehart wrote:

> Thanks for the update, and not to be antagonistic but it's still not
> clear. :-) Are you saying you reverted back to CF9? Or stayed on 10 by
> changing your datetimeformat references (a new function in CF10, which for
> most is a godsend, but was an incompatibility for you)?
>
> Either way, whether on 9 or 10, there are updates that must be done, and
> if you (or someone) didn't do them, or may even have done them wrong,
> that's still a possible explanation. So we need to know what update you are
> at. If you're on CF10, just look at the CF Admin system info page's "update
> level". If you're on CF9 or earlier, sadly it's not that simple but I
> offered a link below that told how to find out your "real" update level on
> those releases.
>
> Finally, separate from that, I had proposed that you might want to share
> some simple code (a complete, self-contained template) that showed what you
> want to work. Maybe one of us would run it and say "yes, it does work as
> expected", which would perhaps confirm it's some config issue on your end.
> (Even if not updates, perhaps it's something different in your CF Admin, or
> application.cfc/cfm). But please do check and report the update level also,
> thanks.
>
> As always, just trying to help.
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff
> Howard
> *Sent:* Sunday, March 16, 2014 7:24 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] Re: cfspreadsheet etc. question
>
>
>
> Yeah, well funny thing about that. I contacted the hosting company (that I
> really want to say and dog right now but am refraining) to migrated to a
> CF10 server. What was discussed was that they would migrated the site and
> let me test before updating the DNS. Unfortunately, that is not how it
> worked out and while trying to work on this the entire site went down
> because I had a UDF that I've used for years called DateTimeFormat. It is
> all over my code and as I'm sure you understand, it didn't work out that
> well. So, I did try to update and test but ended up frantically trying to
> get the site back up and running.
>
>
>
> I was following up because I know that what I'm trying to do I did years
> ago working for another company and it was fairly simple (though lengthy
> code). It was 3rd party UDF but worked. I'm almost wondering if I may need
> to create the entire spreadsheet with CF including formulas, etc.
>
>
>
> On Sun, Mar 16, 2014 at 5:07 PM, Charlie Arehart 
> wrote:
>
> Jeff, while you await a reply from anyone, and while you did reply kindly
> to my last note, you didn't really answer what I had asked: are you
> confirming you have the LATEST UPDATES installed for whatever version of CF
> you have? You want to rule that out before assuming it just can't work as
> you are trying.
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff
> Howard
> *Sent:* Sunday, March 16, 2014 1:55 PM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Re: cfspreadsheet etc. question
>
>
>
> Still hoping that someone out there has some insight on this. Does anyone
> have their own functions for writing to spreadsheets that may not trigger
> this error?
>
>
>
> On Fri, Mar 14, 2014 at 1:04 PM, Jeff Howard  wrote:
>
> I have tried all sorts of workarounds for this issue. I just tried
> splitting the excel workbook into two separate workbooks and then combining
> them in the last step and I keep getting the same error when trying to add
> the second sheet to the workbook.
>
>
>
> Anyone ever had this issue and know how to resolve it?
>
>
>
> The web site you are accessing has experienced an unexpected error.
> Please contact the website administrator.
>
> The following information is meant for the website developer for debugging
> purposes.
>
> Error Occurred While Processing Request
>  An exception occurred while using action=update.
>
>
>
> org.apache.poi.POIXMLException:
> org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with
> the name '/xl/drawings/drawing2.xml' already exists : Packages shall not
> contain equivalent part names and package implementers shall neither create
> nor recognize packages with equivalent part names. [M1.12]
>
>
>
> Resources:
>
>- Enable Robust Exception Information to provide greater detail about
>the source of errors. In the Administrator, click Debugging & Logging >
>Debug Output Settings, and select the Robust Exception Information option.
>- Check the ColdFusion documentation to 
> verify that you are using t

Re: [ACFUG Discuss] wsconfig - CF 9.0.1 Windows 2008 R2 IIS 7

[Dawn Hoagland]

Please review the Adobe CF Security bulletins and make sure you're patched.
 There were some pretty major holes plugged last January.

https://www.adobe.com/support/security/?securityadvisoryproduct=%23coldfusion&Submit=Go#coldfusion


On Wed, Nov 6, 2013 at 3:35 PM, Ajas Mohammed  wrote:

> In terms of security, for CF 9.0.1, do I need to install anything like
> hotfixes & patches? I thought everything was included in the 9.0.1 updates,
> is that not the case?
>
> Can someone point me to link for hotfixes & security patches for CF 9.0.1.
>
> Thanks,
>
>
> 
> iUseDropbox(http://db.tt/63Lvone9)
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, Nov 5, 2013 at 12:42 AM, Charlie Arehart wrote:
>
>> You will continue to see it using jrun_iis6_wildcard. That’s not
>> incorrect (but potentially confusing, yes).
>>
>> /charlie
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Ajas
>> Mohammed
>> *Sent:* Tuesday, November 05, 2013 12:01 AM
>>
>> *To:* discussion@acfug.org
>> *Subject:* Re: [ACFUG Discuss] wsconfig - CF 9.0.1 Windows 2008 R2 IIS 7
>>
>>
>>
>> Again thanks. I think I am guessing that the correct answer to this is 75
>> because of different application pools. I could be wrong though, like you
>> said better to do practical test and figure out what happens.
>>
>>
>>
>> One thing I found which is weird "I have jrun_iis6_wildcard instead of
>> jrun_iis7_wildcard", this is really surprising to me. We had iis6
>> comparability initially and then removed it and re installed cf 9.0.1 & ran
>> connector again for all sites.
>>
>>
>>
>> Thanks,
>>
>>
>> 
>>
>> iUseDropbox(http://db.tt/63Lvone9)
>> http://ajashadi.blogspot.com
>> We cannot become what we need to be, remaining what we are.
>> No matter what, find a way. Because thats what winners do.
>> You can't improve what you don't measure.
>> Quality is never an accident; it is always the result of high intention,
>> sincere effort, intelligent direction and skillful execution; it represents
>> the wise choice of many alternatives.
>>
>>
>>
>> On Mon, Nov 4, 2013 at 11:42 PM, Charlie Arehart 
>> wrote:
>>
>> Thanks for the kind regards. As for your question, that’s something I’ve
>> always wondered myself. :-)
>>
>> In fact, you will see that on the Adobe blog entry about that
>> maxworkerthreads bug (from a few years ago) that I had asked this question
>> specifically, and I never got an answer. I always wanted to test it, but
>> never got around to it.
>>
>> If you may do some testing determine it, please do let us know. To quote
>> “Dances with Wolves”, I’d consider that a “good trade”. :-)
>>
>> /charlie
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Ajas
>> Mohammed
>> *Sent:* Monday, November 04, 2013 10:53 PM
>> *To:* discussion@acfug.org
>> *Subject:* Re: [ACFUG Discuss] wsconfig - CF 9.0.1 Windows 2008 R2 IIS 7
>>
>>
>>
>> Thank you sir. You are the best!!!.
>>
>>
>>
>> Do you see any issues with these separate folders? Plus what about the
>> whole logic about concurrent requests and IIS bug? In this case without the
>> fix (maxworkerthreads=25) and default worker process (1) and seperate
>> application pools for all sites plus 2nd folder and 3 folder as well, does
>> it mean this
>>
>>
>>
>> 1. 25 default setting for concurrent req (bug) x for all sites and 25 x
>> for 2nd folder and 25 x for 3rd folder = 75
>>
>>  or
>>
>> 2. 25 max requests for all sites , 2nd folder site, 3 folder site = 25
>> max requests overall
>>
>>
>>
>> Thanks,
>>
>>
>> 
>>
>>
>>
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>>
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>>
>
>


-- 
Dawn

Re: [ACFUG Discuss] Reports - layout/design & huge resultsets

[Dawn Hoagland]

I have always done the same as Cameron.  Although I will add that for
epically large datasets, CF's memory management can be lacking when
streaming to disk (causing crashes).  I was able to manage memory better by
writing reports (Excel, PDF, etc) in Java (using POI) where I found garbage
collection functioned better with large disk I/O.

--Dawn


On Tue, May 28, 2013 at 10:29 AM, Ajas Mohammed  wrote:

> Thanks guys. I appreciate your comments.
>
> 
> iUseDropbox(http://db.tt/63Lvone9)
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Tue, May 28, 2013 at 10:16 AM, Cameron Childress wrote:
>
>> On Mon, May 27, 2013 at 11:40 PM, Ajas Mohammed wrote:
>>
>>> Can you share your experience in creating Report Design for HTML reports
>>> returning 8000 or more than 8000 records from a DB (query or stored proc).
>>> 8000 is just a number I picked. usually our reports return from 10,  100,
>>>  1000,  1 or even more records.
>>>
>>
>> I typically try to steer people to 100 of less records on the page at a
>> time for web based reports. Search / pasing works to help reduce the number
>> of records on the screen (and sent to the browser) at a time. If they
>> REALLY want to see more than about 1000 records on a single continuous
>> page, I push for Excel exports, or in a worst case scenario write it out to
>> a static HTML file and redirect them there.
>>
>> At a certain point though, the browser will choke and there is nothing
>> really technically that can be done about that.
>>
>> -Cameron
>>
>
>


-- 
Dawn

Re: [ACFUG Discuss] SQL Server Question

[Dawn Hoagland]

My 2 cents.

I've seen more poorly put together Hibernate implementations than I can
count.  If you don't REALLY know the data, how it's put together, how it's
used and keep the objects updated, Hibernate will automatically generate
the worst path imaginable to get the data you need.  I've also seen more
developers who couldn't write an efficient SQL Query if their life depended
on it.

Some implementations may REQUIRE stored procedures for efficiency.

Study ALL of the tools available including their strengths and weaknesses
and choose the proper tool for the solution.  I've written a lot of all 3.
 If I could ONLY choose one method (and there have been instances of that)
- stored procs are the most versatile.  Just like anything else, the source
should be in source control.  It's no different than putting a process in
place for any other code.  You just do it.

--Dawn


On Wed, May 22, 2013 at 9:58 AM, MCG  wrote:

> Let me add, no DBA here at all.  So same guys updating stored proc and
> code.  So we are making the assumption that they have the same skills to
> update things (which may or may not be true); the code from what I
> understand is MVC-ish.  Didn't realize that stored procs were cached as
> well.  It sounds like it boils down to 'it depends'.  I'm partial to views,
> namely because my back end, deep down skills are weaker.  And access is
> just easier.  You only have to write a funky query once.  Do not fear the
> outer join!   :)
>
>
> mcg
>
>
> On Tue, May 21, 2013 at 6:23 PM, Bill Brock wrote:
>
>> Mary-Catherine,
>>
>> ** **
>>
>> I’m with Jason, for the most part, and would only add these notes for
>> whatever it is worth:
>>
>> ** **
>>
>> **· **Stored procedures do cache their execution plans, and that
>> can lead to greater efficiency.
>>
>> **· **Stored procedures are a nice way of separating church and
>> state for the DBA’s
>>
>> **· **In-line SQL is part of the beauty of ColdFusion, and is
>> optimal for testing and is also fine, in my opinion, for production as long
>> as parameters are consistently wrapped in queryparams.  For everyone
>> except the DBAs, in line is probably preferable.  It is certainly easier
>> to edit / maintain, as well as to read (ie, you can figure out what your
>> query is doing without having to go open another file)
>>
>> **· **Nothing beats the MVC framework in the long run for
>> consistent application structure and for the incredible flexibility (think
>> model callbacks) offered via ORM.
>>
>> ** **
>>
>> Best wishes,
>>
>>
>> Bill
>>
>> ** **
>>
>> ===
>>
>> *Bill Brock*
>>
>> *Technology Projects*
>>
>> 1014 Dallas Road, Suite 102
>>
>> Chattanooga, TN 37405
>>
>> p 423.267.7375
>>
>> ** **
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jason
>> Delmore
>> *Sent:* Tuesday, May 21, 2013 11:15 AM
>> *To:* discussion@acfug.org
>> *Subject:* Re: [ACFUG Discuss] SQL Server Question
>>
>> ** **
>>
>> I don't think there is anything wrong with using stored procs over inline
>> SQL to retrieve data.  However, in my view of the world this is application
>> behavior and not reporting.  Application behavior should be modeled in
>> objects and the best way is to use persistent components (Hibernate/ORM.)
>> 
>>
>> ** **
>>
>> The code would then look like
>>
>> claim = entityload("claim", {claimid=1234});
>>
>> documents = claim.getDocuments();  //  this uses ORM to generate SQL that
>> really just does select * from documents where claimid=1234
>>
>> document = documents[1];
>>
>> formfields = document.getFormFields();
>>
>> ** **
>>
>> IMHO, there is no value of inline SQL over stored procs other than
>> perhaps that people seem to do a poor job of version control on stored
>> procs.  An additional benefit of a stored proc is that database guys will
>> go in and review and tune a stored proc, but are unlikely to go and edit
>> inline SQL as that falls in the application space.  I would say leave your
>> stored proc alone unless you are going to go all the way to ORM.
>>
>> ** **
>>
>> But... that is just my view of the world.
>>
>> ** **
>>
>> Jason
>>
>> ** **
>>
>> ** **
>>
>> On Tue, May 21, 2013 at 9:43 AM, MCG  wrote:
>>
>> Yes it's been a while, but I've gotten pulled into database design, and
>> this group has always been the best place to turn to for technical
>> knowledge.
>>
>> The team here inherited a crap database, over 200+ tables for an
>> unexciting claim system, and is now adding new features.  Yes, views are
>> better than straight SQL in the code in the case of many tables for your
>> query.  Maybe I've just been out of the game, but the team is using stored
>> procedures to build queries to output data on a page, which seems odd to
>> me.  Maybe it is fear of the outer join, unions, subqueries.  
>>
>> But do I have a case for pushing the funky v

Re: [ACFUG Discuss] Getting Connection Refused

[Dawn Hoagland]

Sounds about right - and I believe I did run into that once or twice
(several eons ago) when I was in a purely java environment.

Interesting it had been set to the CF default - unless it was a newer
server that FRIT setup.  Whenever I updated the JVM I pointed CF to a
different directory and the default JVM setup is to not cache indefinitely.
 Of course, FRIT may not have liked how I setup the servers and changed it
:)

Glad to hear it was resolved!


On Tue, May 21, 2013 at 9:25 AM, Wilson, Brooks
wrote:

>  Greetings:
>
> ** **
>
> It turns out that technically speaking CF doesn’t cache the DNS, but the
> JVM does. In this case the JVM DNS cache was corrupted and we were being
> directed to the wrong ip. We set the time to live parameter in the JVM DNS
> cache to something other than “forever” and restarted the server. This
> fixed the problem. This one was very interesting and challenging.
>
> ** **
>
> Sincerely, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  **Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
> Arehart
> *Sent:* Thursday, May 16, 2013 4:50 PM
> *To:* discussion@acfug.org
> *Subject:* RE: [ACFUG Discuss] Getting Connection Refused
>
> ** **
>
> Brooks, do you mean you were “reading **that** CF caches DNS entries”?
> Yes, that’s so. And while there doesn’t seem to be a way to clear it (other
> than to restart CF), there is a way to control how long it’s set to live.
> For more, see these blog entries (one really old, one relatively old):
>
> http://tjordahl.blogspot.com/2004/10/cfmx-and-dns-caching.html
>
> http://coldfused.blogspot.com/2008/01/dns-lookup-caching-in-coldfusionjava.html
>
> And the following more generic resources:
>
>
> http://docs.oracle.com/javase/6/docs/technotes/guides/net/properties.html#nct
> http://www.rgagnon.com/javadetails/java-0445.html
> http://serverfault.com/questions/459814/clearing-tomcats-dns-cache
>
> Hope that helps.
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
> Behalf Of *Wilson, Brooks
> *Sent:* Thursday, May 16, 2013 10:20 AM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Getting Connection Refused
>
> ** **
>
> Greetings:
>
> ** **
>
> I’m using a CFFEED tag to retrieve an RSS feed. It has suddenly stopped
> working. Nothing has changed. When we trace the request – nothing happens.
> I was reading the CF caches DNS entries – but I don’t see any information
> on how to clear the cache. Does anyone have any experience with misbehaving
> CFFEED/CFHTTP tags?
>
> ** **
>
> Sincerely, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  **Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org
>
> ** **
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> - 
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> - 
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>



-- 
Dawn

Re: [ACFUG Discuss] CF 9 IP restriction

[Dawn Hoagland]

I miss y'all too (usually on days like today when I'm up at 3:30 catching a
flight and have yet to figure out how to sleep on a plane LOL).

Sorry about the "personal" messages on list :)


On Mon, Apr 22, 2013 at 10:50 AM, Wilson, Brooks
wrote:

>  Dawn:
>
> ** **
>
> Thanks! We miss you!
>
> ** **
>
> Sincerely, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  **Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org****
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dawn
> Hoagland
> *Sent:* Friday, April 19, 2013 1:23 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] CF 9 IP restriction
>
> ** **
>
> I'm fairly certain that's the only thing.  John H. should still have the
> documentation I wrote for locking down instances (although it's geared
> toward multi-server).
>
> ** **
>
> On Fri, Apr 19, 2013 at 1:20 PM, Teddy R Payne 
> wrote:
>
> If I recall, there is more than one xml file or child node that has
> interface set to asterisk.
>
> Sent from my iPhone
>
>
> On Apr 19, 2013, at 9:38 AM, Dawn Hoagland  wrote:
> 
>
>  Assuming a single server, development instance install.
>
> ** **
>
> *{installLocation}\runtime\servers\coldfusion\SERVER-INF\jrun.xml*
>
> ** **
>
> Update the "interface" attribute in the following service class
>
> ** **
>
> *  *
>
> *8500*
>
> *127.0.0.1*
>
> *false*
>
> *50*
>
> *1*
>
> *1000*
>
> *0*
>
> *300*
>
> *500*
>
> *300*
>
> *  *
>
> ** **
>
> On Fri, Apr 19, 2013 at 9:16 AM, Wilson, Brooks 
> wrote:
>
> Greetings:
>
>  
>
> I’ve lost my notes on how to secure the IP address when setting up a CF 9
> server for local development. I had instructions on how to make the CF
> built in server accessible only from the local host. Please post them if
> you have them.
>
>  
>
> TIA, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org
>
>  
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
> Arehart
> *Sent:* Friday, April 12, 2013 6:18 PM
> *To:* discussion@acfug.org
> *Subject:* RE: [ACFUG Discuss] 9.01 vs 9.02
>
>  
>
> Steve, this is a point I just made in one of my replies this week to Ajas,
> but to reiterate, any security hotfixes created by Adobe are created for
> 9.0, 9.0.1, and 9.0.2. So no, you are not in any danger, as long as you
> always apply the latest HFs.
>
> As for not updating to Java 7, yes, technically you are “in danger”, in
> that Oracle has EOLed java 6 and are NOT offering new updates for Java 6.
> So if there are new vulnerabilities identified, they will only update Java
> 7, not 6 (just as if Adobe fixes CF now, they only do it for CF 10 and 9,
> not 8 or earlier). The EOL of java 6 was only in the past couple of months,
> so at least you can update to a 8relatively recent* JVM update, just not
> THE latest one.
>
> Finally, as for your observation about the wording of the Adobe mention
> about “supported jdks”, I assume you are referring to the first sentence of
> step 1 in this doc:
> http://helpx.adobe.com/coldfusion/kb/change-coldfusion-jvm.html
>
> “Download and install a supported version of JDK.”
>
> I suppose that’s just a CYA statement. (And if this doc may have existed
> for CF9 before the update that allowed 1.7, it was referring to them
> supporting only Java 1.6. Indeed, until about mid-last year, they only
> supported up to 1.6.0_24.) But I agree with you it would be better if
> they’d show or point to some table to clarify what JVMs are supported by
> what versions of CF. (Seems a good blog opportunity!)
>
> /charlie
>
>  
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
> Behalf Of *Steven
> *Sent:* Friday, April 12, 2013 8:35 AM
> *To:* discussion@acfug.org
> *Subject

Re: [ACFUG Discuss] CF 9 IP restriction

[Dawn Hoagland]

I'm fairly certain that's the only thing.  John H. should still have the
documentation I wrote for locking down instances (although it's geared
toward multi-server).


On Fri, Apr 19, 2013 at 1:20 PM, Teddy R Payne wrote:

> If I recall, there is more than one xml file or child node that has
> interface set to asterisk.
>
> Sent from my iPhone
>
> On Apr 19, 2013, at 9:38 AM, Dawn Hoagland  wrote:
>
> Assuming a single server, development instance install.
>
> *{installLocation}\runtime\servers\coldfusion\SERVER-INF\jrun.xml*
>
> Update the "interface" attribute in the following service class
>
> *  *
> *8500*
> *127.0.0.1*
> *false*
> *50*
> *1*
> *1000*
> *0*
> *300*
> *500*
> *300*
> *  *
>
>
> On Fri, Apr 19, 2013 at 9:16 AM, Wilson, Brooks  > wrote:
>
>>  Greetings:
>>
>> ** **
>>
>> I’ve lost my notes on how to secure the IP address when setting up a CF 9
>> server for local development. I had instructions on how to make the CF
>> built in server accessible only from the local host. Please post them if
>> you have them.
>>
>> ** **
>>
>> TIA, Brooks
>>   --
>>
>> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
>> *Technology Solutions Services  |  **Application Delivery Services*
>>
>> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
>> 30309-4470
>>
>> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>>
>> Email: brooks.wil...@atl.frb.org
>>
>> ** **
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
>> Arehart
>> *Sent:* Friday, April 12, 2013 6:18 PM
>> *To:* discussion@acfug.org
>> *Subject:* RE: [ACFUG Discuss] 9.01 vs 9.02
>>
>> ** **
>>
>> Steve, this is a point I just made in one of my replies this week to
>> Ajas, but to reiterate, any security hotfixes created by Adobe are created
>> for 9.0, 9.0.1, and 9.0.2. So no, you are not in any danger, as long as you
>> always apply the latest HFs.
>>
>> As for not updating to Java 7, yes, technically you are “in danger”, in
>> that Oracle has EOLed java 6 and are NOT offering new updates for Java 6.
>> So if there are new vulnerabilities identified, they will only update Java
>> 7, not 6 (just as if Adobe fixes CF now, they only do it for CF 10 and 9,
>> not 8 or earlier). The EOL of java 6 was only in the past couple of months,
>> so at least you can update to a 8relatively recent* JVM update, just not
>> THE latest one.
>>
>> Finally, as for your observation about the wording of the Adobe mention
>> about “supported jdks”, I assume you are referring to the first sentence of
>> step 1 in this doc:
>> http://helpx.adobe.com/coldfusion/kb/change-coldfusion-jvm.html
>>
>> “Download and install a supported version of JDK.”
>>
>> I suppose that’s just a CYA statement. (And if this doc may have existed
>> for CF9 before the update that allowed 1.7, it was referring to them
>> supporting only Java 1.6. Indeed, until about mid-last year, they only
>> supported up to 1.6.0_24.) But I agree with you it would be better if
>> they’d show or point to some table to clarify what JVMs are supported by
>> what versions of CF. (Seems a good blog opportunity!)
>>
>> /charlie
>>
>> ** **
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
>> Behalf Of *Steven
>> *Sent:* Friday, April 12, 2013 8:35 AM
>> *To:* discussion@acfug.org
>> *Subject:* [ACFUG Discuss] 9.01 vs 9.02
>>
>> ** **
>>
>> All,
>>
>> while we're on the subject of patching & upgrades..
>>
>> last night I patched our *9.01* box with the latest hotfix4 from
>> http://helpx.adobe.com/coldfusion/kb/hot-fixes-coldfusion-9.html
>>
>> and I followed the steps there.
>>
>> ** **
>>
>> But I'm still fuzzy on a couple things..
>>
>> ** **
>>
>> I didn't want to go through the hassle of doing a complete
>> uninstall/reinstall to get the box over to the 9.02 series. Am I still in
>> danger of having security holes that aren't addressed by the 9.01 series
>> hotfixes?
>>
>> ** **
>>
>> And, also within this hotfix4 I applied -- an "optional" step is to
>> upgrade the jvm by getting the latest jdk from oracle, modifying the
>> jvm.config to call the new, etc.  I elected not to touc

Re: [ACFUG Discuss] CF 9 IP restriction

[Dawn Hoagland]

Assuming a single server, development instance install.

*{installLocation}\runtime\servers\coldfusion\SERVER-INF\jrun.xml*

Update the "interface" attribute in the following service class

*  *
*8500*
*127.0.0.1*
*false*
*50*
*1*
*1000*
*0*
*300*
*500*
*300*
*  *


On Fri, Apr 19, 2013 at 9:16 AM, Wilson, Brooks
wrote:

>  Greetings:
>
> ** **
>
> I’ve lost my notes on how to secure the IP address when setting up a CF 9
> server for local development. I had instructions on how to make the CF
> built in server accessible only from the local host. Please post them if
> you have them.
>
> ** **
>
> TIA, Brooks
>   --
>
> Brooks Wilson  |  Senior Web Developer Programmer/Analyst
> *Technology Solutions Services  |  **Application Delivery Services*
>
> Federal Reserve Bank of Atlanta  |  1000 Peachtree Street,  Atlanta, GA
> 30309-4470
>
> Phone: 404.498.8178 | Fax: 404.498.8239 | Mobile: 404.985.9270
>
> Email: brooks.wil...@atl.frb.org
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
> Arehart
> *Sent:* Friday, April 12, 2013 6:18 PM
> *To:* discussion@acfug.org
> *Subject:* RE: [ACFUG Discuss] 9.01 vs 9.02
>
> ** **
>
> Steve, this is a point I just made in one of my replies this week to Ajas,
> but to reiterate, any security hotfixes created by Adobe are created for
> 9.0, 9.0.1, and 9.0.2. So no, you are not in any danger, as long as you
> always apply the latest HFs.
>
> As for not updating to Java 7, yes, technically you are “in danger”, in
> that Oracle has EOLed java 6 and are NOT offering new updates for Java 6.
> So if there are new vulnerabilities identified, they will only update Java
> 7, not 6 (just as if Adobe fixes CF now, they only do it for CF 10 and 9,
> not 8 or earlier). The EOL of java 6 was only in the past couple of months,
> so at least you can update to a 8relatively recent* JVM update, just not
> THE latest one.
>
> Finally, as for your observation about the wording of the Adobe mention
> about “supported jdks”, I assume you are referring to the first sentence of
> step 1 in this doc:
> http://helpx.adobe.com/coldfusion/kb/change-coldfusion-jvm.html
>
> “Download and install a supported version of JDK.”
>
> I suppose that’s just a CYA statement. (And if this doc may have existed
> for CF9 before the update that allowed 1.7, it was referring to them
> supporting only Java 1.6. Indeed, until about mid-last year, they only
> supported up to 1.6.0_24.) But I agree with you it would be better if
> they’d show or point to some table to clarify what JVMs are supported by
> what versions of CF. (Seems a good blog opportunity!)
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
> Behalf Of *Steven
> *Sent:* Friday, April 12, 2013 8:35 AM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] 9.01 vs 9.02
>
> ** **
>
> All,
>
> while we're on the subject of patching & upgrades..
>
> last night I patched our *9.01* box with the latest hotfix4 from
> http://helpx.adobe.com/coldfusion/kb/hot-fixes-coldfusion-9.html
>
> and I followed the steps there.
>
> ** **
>
> But I'm still fuzzy on a couple things..
>
> ** **
>
> I didn't want to go through the hassle of doing a complete
> uninstall/reinstall to get the box over to the 9.02 series. Am I still in
> danger of having security holes that aren't addressed by the 9.01 series
> hotfixes?
>
> ** **
>
> And, also within this hotfix4 I applied -- an "optional" step is to
> upgrade the jvm by getting the latest jdk from oracle, modifying the
> jvm.config to call the new, etc.  I elected not to touch the jvm and we are
> still using native (out of the box ver). Am I again in danger of new
> security issues? (I have another Adobe rant. They mention in this step to
> use only the JDKs which are compatible with cf9 -- but don't bother within
> the instructions to tell you which are compatible!).
>
> ** **
>
> How did you guys approach your cf9 patching?
>
> Happy Friday.
>
> ** **
>
> Thx,
>
> Steve
>
> ** **
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> - 
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -




-- 
Dawn

Re: [ACFUG Discuss] 9.01 vs 9.02

[Dawn Hoagland]

For what it's worth.

I worked in a very security aware environment for a while.  All CF security
patches were implemented in development for a 2 week testing period within
7-30 days of release from Adobe AND all JVM editions were updated in that
time period as well if there was a security alert associated with the
release (which was nearly every release).  If there were no issues in dev,
the patches were moved to QA for a week or so and then prod during the next
maintenance window.  A major security breach could shorten that timeline to
days - and even hours if a breach on a server is discovered.  On occasion a
patch was skipped or delayed due to coding issues, but it wasn't often.  It
is important to have a test cycle in place because you never know when the
next major security hole will be found.

As for 9.01 vs. 9.02 - if you use Verity search functionality, you will
need to stay with 9.01 as it is not available in the 9.02 release.


On Fri, Apr 12, 2013 at 8:34 AM, Steven  wrote:

> All,
> while we're on the subject of patching & upgrades..
> last night I patched our *9.01* box with the latest hotfix4 from
> http://helpx.adobe.com/coldfusion/kb/hot-fixes-coldfusion-9.html
> and I followed the steps there.
>
> But I'm still fuzzy on a couple things..
>
> I didn't want to go through the hassle of doing a complete
> uninstall/reinstall to get the box over to the 9.02 series. Am I still in
> danger of having security holes that aren't addressed by the 9.01 series
> hotfixes?
>
> And, also within this hotfix4 I applied -- an "optional" step is to
> upgrade the jvm by getting the latest jdk from oracle, modifying the
> jvm.config to call the new, etc.  I elected not to touch the jvm and we are
> still using native (out of the box ver). Am I again in danger of new
> security issues? (I have another Adobe rant. They mention in this step to
> use only the JDKs which are compatible with cf9 -- but don't bother within
> the instructions to tell you which are compatible!).
>
> How did you guys approach your cf9 patching?
> Happy Friday.
>
> Thx,
> Steve
> *armed with coffee*
>
>
>


-- 
Dawn

Re: [ACFUG Discuss] Choosing a person with adequate CF skills

[Dawn Hoagland]

Honestly - the absolute best way I've found is to sit them down with at a
computer with some basic development tasks and let them have 2-4 hours to
work through them.  The low end folks may just walk out.  Go ahead and give
access to Google because it is a good development tool :)

One of the best examples I've seen for CF (and actually did as part of an
interview process several years ago) was replicating the CFDUMP function
from scratch and test by passing in complex variables (query results,
arrays, arrays of arrays, etc).  If they can nail a recursive function in
CF out of the gate with "interview" pressure you've got a darn good start
and know they can problem solve.  I would do this over a written test
(which I've always detested).

Honestly - I don't care if they know the latest lingo, know a list of
design patterns or when/where to create Abstracts as long as they can take
a development task and solve it.  It's the last bit that gets actual work
done.

While I realize you are at a University - there are some darn fine
developers out there without degrees so unless it's seriously political -
don't throw away a resume just because they don't have one.  And I'm not
saying that because I fall into that category (it hasn't harmed my career),
but as an employer, you may miss out on the best developer for the job.


On Tue, Mar 12, 2013 at 12:32 PM, Chris  wrote:

> I am with a public university and asked to interview applicants with
> Coldfusion(CF) and Flex skills for an opening. The position requires
> someone who has worked 3-4 years in CF and Flex.
>
> I was moved into this position and I picked CF/Flex after I started so do
> not have a first hand experience of a CF/Flex interview, though a Web
> search reveals dozens of websites with questions.
>
> I have worked with Coldfusion 8 and 9 and I know I can ask questions about
> following topics.
>
> 1. Check for CF basic understanding, ask about functions which are rarely
> used to test depth of knowledge in CF.
> 2. Ask about CFC, Bean, Gateway to test OOP understanding in CF
> 3. How the facade pattern is used in CF?
> 4. Recent CF projects of candidate. Question the design, implementation
> decisions and possible performance improvements in the projects
> 5. Ask them to develop a Bean on whiteboard.
> 6. Contributions to an open source CF project
>
> Since the opening expects someone with a Bachelor's in Computer Science, I
> can ask the typical questions(algorithms, data structures, design patterns,
> OOP, contract by design, agile programming concepts, Operating System and
> Networking concepts, information security, bit fiddling in C, RTTI idiom in
> C++ assuming candidate lists C,C++ on his resume).
>
> I realize a Web search can reveal lot more questions, but since I have not
> interviewed someone for a CF background before, I want to know if items 1-6
> listed above are sufficient or do they need more additions?
> Are they too simple that most people who have worked 12-18 months in CF
> would know?
>
> I do not want to make the interview unduly hard or easy.
>
> Any suggestions would be appreciated.
>
> Thanks
>
> P.S. I went through the usual books Career cup, Programming Interviews
> exposed and their websites to learn how interviews are done in most places
> today.
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -




-- 
Dawn

Re: [ACFUG Discuss] New CF Vulnerability - Check your servers

[Dawn Hoagland]

It was introduced in APSB12-06 released March of 2012.  They introduced the
setting, defaulted it to 100, but didn't update the Administrator to allow
editing from the GUI so it must be added directly in the XML.

http://www.adobe.com/support/security/bulletins/apsb12-06.html


On Mon, Jan 21, 2013 at 3:42 PM, Ajas Mohammed  wrote:

> Thanks Charlie for the detailed email. Yes, we are on 9.0 and we didnt
> upgrade to 9.0.1. We used hotfix jar for 9.0 as advised on the adobe page. It
> makes sense to protect those CFIDE folders you mentioned.
>
> One thing we did notice is that after the applying security hotfix, we
> started to get this error 
> "*coldfusion.filter.FormScope$PostParametersLimitExceededException:
> POST parameters exceeds the maximum limit specified in the server*".
> Quick google search led
> me
> to this 
> post.
> I ended up adding 500.0
> to the {ColdFusion-Home}/lib/neo-runtime.xml for Server installation. I am
> guessing that we might have missed an earlier patch/hotfix in which Adobe 
> introduced
> this postParametersLimit setting. We were surprised by error message in
> the beginning but since we had recently applied the security fix, we knew
> it had to do with fix.
>
> Thanks,
>
> 
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Fri, Jan 18, 2013 at 7:07 PM, Charlie Arehart wrote:
>
>> :-)
>>
>> Thanks. I will note that they did just yesterday kindly add me to the
>> acknowledgements section of the security advisory, a first for me. :-)
>> Various issues caused the delay. Nothing nefarious. I got a call from
>> someone on PSIRT explaining the situation. I was just happy to get the
>> mention.
>>
>> The good news is that I’ve gotten “payment” by a burst of new business
>> from people needing help with this. Of course, I posted the first two
>> entries making no mention of my services. That really wasn’t my motivation.
>> But come, the work has. And some of those have then realized I could help
>> with other things, which has led to still more work, so it’s been all the
>> more beneficial.
>>
>> Of course, it’s a bit like being a roofer after a tornado blows through.
>> You don’t want to say you’re “glad for the work”, as you feel for people
>> who were affected.
>>
>> I have a part 4/post mortem in the works, but sadly too busy to get time
>> to write it up. Perhaps over the weekend.
>>
>> /charlie
>>
>> 
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Steve
>> Ross
>> *Sent:* Friday, January 18, 2013 10:17 AM
>> *To:* ACFUG ColdFusion Discussion
>> *Subject:* Re: [ACFUG Discuss] New CF Vulnerability - Check your servers*
>> ***
>>
>> ** **
>>
>> Adobe should be paying you Charlie... 
>>
>> ** **
>>
>> On Wed, Jan 16, 2013 at 9:39 AM, Ajas Mohammed 
>> wrote:
>>
>> Thanks Charlie, Cameron for keeping us updated with the latest.
>>
>> Charlie, thanks for those blog entries. Really appreciate all your help.
>>
>> 
>>
>>  
>>
>> 
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>>
>
>


-- 
Dawn

Re: [ACFUG Discuss] ColdFusion 10 updates Offline

[Dawn Hoagland]

" if I'm not mistaken, Windows uses two different characters and *nix uses
one."

You've got it Mike.  'nix uses LF (chr(10))only and Windows uses CR + LF
(chr(10) chr(13)).

On Thu, Dec 6, 2012 at 6:31 PM, Mike Staver  wrote:

> if I'm not mistaken, Windows uses two different characters and *nix uses
> one.




-- 
Dawn

Re: [ACFUG Discuss] ColdFusion 10 updates Offline

[Dawn Hoagland]

Generic issue of transferring "text" files between Windows & 'nix.  It's
been a problem for as long as I've transferred files between the two


On Thu, Dec 6, 2012 at 1:37 PM, Charlie Arehart wrote:

> OK, I’ll continue to play dumb, since this use of “–f” on the “java –jar”
> command is entirely new to me. What is it in the properties.txt that you
> were passing, Mike? And is it then that, Dawn, which you’re referring to?
> Are you aware of what he may be passing in? Or were you just referring to a
> generic issue of passing text files?
>
> I did google some for this “–f”, but came up empty. Even on the Oracle
> page on the jars:
> http://docs.oracle.com/javase/6/docs/technotes/tools/windows/jar.htmlit’s not 
> clear what it would have to do with running the updates. That’s
> all I’m really trying to understand, in case it may help others. Thanks to
> you both.
>
> ** **
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dawn
> Hoagland
> *Sent:* Thursday, December 06, 2012 9:32 AM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] ColdFusion 10 updates Offline
>
> ** **
>
> Formatting problems when passing text files between Windows and 'nix have
> been around since anyone needed to pass text files between Windows and
> 'nix.  Windows implements a different method of the linefeed character.***
> *
>
> ** **
>
> Notepad *should* always be safe.  But I've occasionally had problems
> there as well.
>
> ** **
>
> On Wed, Dec 5, 2012 at 11:10 PM, Charlie Arehart 
> wrote:
>
> Glad to hear it helped.
>
> As for the properties file, that's the first I've ever heard of using that
> (in Windows or Unix). Since you seem to indicate its use with Windows,
> what's it for? (I could google it, sure, but I'd like to hear your
> perspective, such as what led you to use it at all. I've never seen it
> mentioned, though of course I've seen mention of the command line java -jar
> approach.)
>
> As for the cookie thing, I've not heard anyone else talk about it yet, and
> since I've not had time to analyze it to really identify the nature of the
> problem (and whether anything in CF controls or influences it), I have not
> yet filed any bug report.
>
> /charlie
>
>
> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mike Staver
> Sent: Wednesday, December 05, 2012 7:08 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] ColdFusion 10 updates Offline
>
> Thanks Charlie. I was able to download the jar files from the XML you
> pointed out, and then run the command line update. Since this is on Solaris
> and I don't have a GUI, I had to use the silent option like so:
>
> java -jar hotfix_005.jar -i silent -f properties.txt
>
> What tripped me up on that command is that if you create a properties file
> on Windows, and then transfer it over to the Solaris machine, it won't
> work.
> The Windows vs Unix end of line character will bite you. The update
> appeared
> to run fine, but when I'd log back into CF Admin, it would still show the
> old version. Running dos2unix or just editing the properties file in your
> editor of choice would correct the issue.
>
> I'm interested in hear more about the reason we have to clear cookies to
> get
> back into CF Admin. Hopefully they can correct that with a hot fix if they
> haven't already.
>
>
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
> 
>
>
>
> 
>
> ** **
>
> --
> Dawn
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink <http://www.fusionlink.com>
> -




-- 
Dawn

Re: [ACFUG Discuss] ColdFusion 10 updates Offline

[Dawn Hoagland]

Formatting problems when passing text files between Windows and 'nix have
been around since anyone needed to pass text files between Windows and
'nix.  Windows implements a different method of the linefeed character.

Notepad *should* always be safe.  But I've occasionally had problems there
as well.


On Wed, Dec 5, 2012 at 11:10 PM, Charlie Arehart wrote:

> Glad to hear it helped.
>
> As for the properties file, that's the first I've ever heard of using that
> (in Windows or Unix). Since you seem to indicate its use with Windows,
> what's it for? (I could google it, sure, but I'd like to hear your
> perspective, such as what led you to use it at all. I've never seen it
> mentioned, though of course I've seen mention of the command line java -jar
> approach.)
>
> As for the cookie thing, I've not heard anyone else talk about it yet, and
> since I've not had time to analyze it to really identify the nature of the
> problem (and whether anything in CF controls or influences it), I have not
> yet filed any bug report.
>
> /charlie
>
>
> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mike Staver
> Sent: Wednesday, December 05, 2012 7:08 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] ColdFusion 10 updates Offline
>
> Thanks Charlie. I was able to download the jar files from the XML you
> pointed out, and then run the command line update. Since this is on Solaris
> and I don't have a GUI, I had to use the silent option like so:
>
> java -jar hotfix_005.jar -i silent -f properties.txt
>
> What tripped me up on that command is that if you create a properties file
> on Windows, and then transfer it over to the Solaris machine, it won't
> work.
> The Windows vs Unix end of line character will bite you. The update
> appeared
> to run fine, but when I'd log back into CF Admin, it would still show the
> old version. Running dos2unix or just editing the properties file in your
> editor of choice would correct the issue.
>
> I'm interested in hear more about the reason we have to clear cookies to
> get
> back into CF Admin. Hopefully they can correct that with a hot fix if they
> haven't already.
>
>
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>
>


-- 
Dawn

Re: [ACFUG Discuss] Need a way to redirect users based on country

[Dawn Hoagland]

FWIW - ColdFusion is written in Java.  You can put their library in your
class path (or use a java loader) and call it directly.  It sounds harder
than it actually is to do.

On Tue, Sep 4, 2012 at 6:28 PM, Michael Brown wrote:

> Thanks Josh,
>
> The challenge is to redirect users when the hit the sites home page based
> on the country ID.   This seems to require a two step approach.  First I
> need the ip address from the user, then require a look-up based on such to
> determine the country of the IP address.  All transparent to the site
> visitor MaxMind supplies an API to get real-time data on IP addresses
> worldwide.  They provide a CSV file that is updated monthly that can be
> downloaded.
>
> I thought there may be a CF script that could simply(easy for me to say)
> do the look-up and than provide the redirect.  As far as the GEO Coding is
> concerns, I'm not set on MaxMind as the data source.  Maxmind seems to have
> scripts for everything but CF, see:
> http://dev.maxmind.com/geoip/downloadable
>
> I hope this makes more sense. :)
>
> Big Thanks for the reply and input!
>
> On Tue, Sep 4, 2012 at 5:10 PM, Josh Adams  wrote:
>
>> Is there a challenge that you're facing or is it just that you would love
>> it if you didn't have to do the coding? I don't fault you if you don't want
>> to do the coding—why reinvent the wheel if you don't have to? But if that's
>> your situation, I think Charlie is right that it looks like you're not
>> going to find the code you need via this list at least. On the bright side,
>> I don't know the ins and outs of the MaxMind Data (had never heard of it
>> until this post) but off the cuff this doesn't seem to me it would be a
>> difficult thing to accomplish. And if I'm missing something, well then
>> we're back to my question about a challenge you're facing.
>>
>> Josh
>>
>> From: Charlie Arehart 
>> Reply-To: "discussion@acfug.org" 
>> Date: Monday, September 3, 2012 8:12 PM
>> To: "discussion@acfug.org" 
>> Subject: RE: [ACFUG Discuss] Need a way to redirect users based on
>> country
>>
>> That’s a REALLY specific need, Michael. I’m afraid the silence is just
>> because there are no folks on this list who’ve used that specific dataset.
>>
>> Maybe if you propose a more generic problem, or what you do and do not
>> know how to do with the specific aspect of what you may be trying to do
>> with the lookup, someone may be able to offer a suggestion.
>>
>> /charlie
>>
>> ** **
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
>> Behalf Of *Michael Brown
>> *Sent:* Saturday, September 01, 2012 8:26 PM
>> *To:* Michael Brown
>> *Cc:* discussion@acfug.org
>> *Subject:* [ACFUG Discuss] Need a way to redirect users based on country*
>> ***
>>
>> ** **
>>
>> Any takers?
>>
>>
>>
>> 
>>
>> Any known CF scripts that can incorporate MaxMind Data for redirects
>> based on Country?  Looking for small foot print script.  Seen a few out
>> there but NON written for CF.  Any help would be great.
>>
>>
>> Sent from my iPad
>>
>>
>> On Aug 29, 2012, at 5:53 PM, Michael Brown 
>> wrote:
>>
>> Good Evening Group Members,
>>
>> Any known CF scripts that can incorporate MaxMind Data for redirects
>> based on Country?  Looking for small foot print script.  Seen a few out
>> there but written for CF.  Any help would be great.
>>
>> --
>> Michael Brown
>>
>> 770-605-5240
>>
>> 
>>
>> Marketing Solutions with vision!
>>
>> http://www.singleconcepts.com
>>
>> ** **
>>
>> ** **
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>
>
>
>
> --
> Michael Brown
> 770-605-5240
>
> Marketing Solutions with vision!
> http://www.singleconcepts.com
>
>
>


-- 
Dawn

Re: [ACFUG Discuss] Have a question about group limits

[Dawn Hoagland]

FWIW - I'll jump in.  Both solutions definitely warrant a look-see for the
OP to determine which is best for his particular situation.

I've seen a lot of code loops running queries in situations where it's ok
(i.e. small datasets with a finite # of loops) and situations where they
shouldn't have been used (to the tune of running - I kid you not - 300k
queries as the dataset grew over time).

Either solution may be the fastest in any given situation.  Some folks are
better at one than the other.  I have noted with some dismay that fewer and
fewer developers are bothering to learn how to write stored procedures -
especially in the Java world where hibernate has become prevalent and can
allow you to shoot yourself in the proverbial foot quicker than you can say
scat (much less Rumpelstiltskin).

I tend to write stored procedures for anything that can't be pulled in a
couple of queries and almost never run queries inside of loops.  Granted, I
started coding back when you were looking at a 2 second delay for *any* Oracle
calls and pulling back 1000 records when you only needed 10 could have a
severe impact to performance.  What can I say, I'm getting old LOL.

Funnily enough - my second full-time programming gig I got lots of kudos
speeding up the previous developer's code in a particular app.  He had
looped queries because he apparently didn't know about the group function
in cfquery.  I rewrote the code to utilize one query + group for display
and had 2 second response (merely for the Oracle connection) rather than 30
seconds for each page.  Took me about an hour to identify and fix then had
nothing to do for the rest of the week as my boss didn't have anything
lined up - it was supposed to take me a week to figure out what was wrong
and fix it :)

On Tue, Jul 24, 2012 at 9:29 PM, Charlie Arehart wrote:

> So Frank, sure, I get that you wrote something off the cuff (so did I,
> though yes I did test it before sending it). But I sensed you were not
> familiar with the CFOUTPUT GROUP, so I just wanted to show how that could
> work. No offense intended, and I think none was taken, but want to make
> sure. :-)
>
> As for mixing bus and display logic, well that of course is an entirely
> different subject. I was proposing this for those who don’t have that
> concern. (Recall, it was Michael who said he was wondering how to limit the
> inner loop in a grouping operation, so I assumed he was referring to this
> sort of CFOUTPUT GROUP operation.)
>
>
> But then you say, “As for performance, I would agree with Dawn's
> assessment that this is not a great solution if you have many different
> "dests". I could see this being horribly slow with more than 10 dests or a
> very large recordset.”
>
> Well, can you clarify: she was writing in response to your code, not mine.
> So when you say “this solution”, do you mean yours, or mine? It reads like
> the latter, but I’m sensing maybe you meant you were simply agreeing with
> her assessment of your own example. But I want to clarify for readers, and
> myself (because I would not think my code would have any performance hit
> for “many dests”.)
>
> As for your 5th paragraph about the debate between doing things in cfml
> or in the db, you say, “If all I wanted was combined results, I would not
> use the group attribute.”  I’m not sure I agree with the conclusion, but to
> each his own. Still, I do agree if you were communicating that sometimes
> someone will want to do paging through the results, which may on the
> surface not seem well suited to this approach, but then if you use query
> caching of the query to be processed, it can actually work just fine with
> paging through the results.
>
> Finally, you say, “On a slightly different topic, don't always assume that
> a stored procedure is always the fastest.” Here, again, I will assume you
> are talking to Dawn (in her response to you, though you are replying here
> to me.) That said, I do agree that SPs are not always the right answer, and
> as you say testing is always best. And keeping an open mind to
> alternatives. That’s what we’re all here to discuss, so I never mind these
> sort of back and forths as we all learn together and from each other.
> Thanks for the story there, and the kind regards.
>
> 
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Frank
> Moorman
> *Sent:* Tuesday, July 24, 2012 7:27 PM
>
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] Have a question about group limits
>
> ** **
>
> Charlie,
>
> No, I never used the group clause in  I vaguely remember hearing
> you talk about it once before, but I never had the need for it since.
>
> As for code style, yes this was a quick and dirty solution. Yes, I would
> have this in a function. If anything I would have the looping extract the
> necessary information and dump it into appropriate variables, whether that
> is a single query with all the rows or a simple struct depends on how 

Re: [ACFUG Discuss] Have a question about group limits

[Dawn Hoagland]

This is one solution & probably fine for a small # of groups.  I would do
this in a stored proc in the database if at all possible so if your dataset
(i.e. # of groups) got large you're still limiting the output w/o running a
large number of queries (which can itself cause headaches).

On Mon, Jul 23, 2012 at 6:06 PM, Frank Moorman
wrote:

>  Michael,
>
> I am not sure, but I think this is what you are looking for...
>
> I do not believe that MySQL supports the LIMIT clause in a subquery, so I
> believe the following is easiest without creating a stored procedure or a
> unreadable monstrosity of SQL...
>
> 
> SELECT DISTINCT dest
>   FROM tableB
>  WHERE top10 = "1";
> 
>
> 
>
> 
> SELECT dest, property, url_e, price, description
>   FROM tableB
>  WHERE top10 = "1"
>AND dest = 
>  LIMIT 10
> 
>
> 
>
> 
>
>
> You definitely want to use the CFQUERYPARAM in the second query. Even
> though the dest field is coming straight from the database and probably
> does not need validation, it turns the SQL into a prepared SQL for the
> database so that MySQL will cache the execution plan and save a little time
> when it is executed multiple times.
>
> Let me know if that is what you wanted...
> Frank
>
>
>
>
>
> On 07/23/2012 05:28 PM, Michael Brown wrote:
>
> Thanks Larry,
>
> Sorry for not being clear.  I want to limit the number records displayed
> "per" group.  In the database there are thousands of records, but I just
> want to display 10 records per group.  When I run the query, it only
> displays 10 records for only 1 group in the "dest" field.
>
> Hope that's a little clearer.
>
> THANKS
>
> On Mon, Jul 23, 2012 at 5:14 PM, Larry Morrow  wrote:
>
>>  Hi Michael,
>>
>>
>>
>> I may be the first and the least capable of helping, but I did not quite
>> understand what you are trying to accomplish.
>>
>>
>>
>> Your query as is will list the results so that the records will be sorted
>> by the group.
>>
>>
>>
>> When you say limit, can you provide a description of a results you are
>> looking to achieve.
>>
>>
>>
>> Hopefully, I was clear in my question.
>>
>>
>>
>> Larry J. Morrow
>> COO & CTO
>> A-PLUS Community Solutions, Inc.
>> Office: 678.534.8326 ext 100 <678.534.8326%20ext%20100>
>> Fax: 801.843.5832
>> Cell: 678.416.8032
>> www.a-plus.net
>>
>> Please Note: The information in this email contains privileged,
>> confidential, and proprietary information and is otherwise protected from
>> disclosure. If you have received this email in error, please notify A-PLUS
>> Community Solutions, Inc. immediately by replying to this message and
>> deleting it from your computer. Anyone other than the intended is
>> prohibited from reading, copying, or distributing this transmission.
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Michael
>> Brown
>> *Sent:* Monday, July 23, 2012 5:05 PM
>> *To:* discussion@acfug.org
>> *Subject:* [ACFUG Discuss] Have a question about group limits
>>
>>
>>
>> Hello fellow group members,
>>
>> I can't seem to get my output to limit the number of records displayed
>> per group in the database. I using mysql with cf9.  This is my query that
>> I'm attempting to get data from.  The group field is "dest".
>>
>> 
>> select dest, property, url_e, price, description
>> from tableB
>> where top10 = "1"
>> order by dest
>>
>> 
>>
>>
>> Thanks!
>> --
>> Michael Brown
>>
>> 770-605-5240
>>
>>  Marketing Solutions with vision!
>>
>> http://www.singleconcepts.com
>>
>>
>>
>>
>>
>>
>> __ Information from ESET NOD32 Antivirus, version of virus
>> signature database 7323 (20120723) __
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>
>
>
>
> --
> Michael Brown
> 770-605-5240
>
>  Marketing Solutions with vision!
>  http://www.singleconcepts.com
>
>
>  -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>



-- 
Dawn

Re: [ACFUG Discuss] CF9 email problem

[Dawn Hoagland]

One other thing to try for troubleshooting.  Turn on mail logging & check
the mail.log.  If the email is being sent by CF multiple times or to
multiple recipients, you should be able to tell from the log.

-- 
Dawn

On Wed, May 23, 2012 at 3:56 PM, Frank Moorman
wrote:

>  Brooks,
>
> Not a problem, Trust me, I was looking at the calling page as well. I am
> happy there are people on the list willing to help...
>
> Also, a bad or incomplete explanation is my fault.
>
> Thanks,
> Frank
>
>
> On 05/23/2012 07:45 AM, brooks.wil...@atl.frb.org wrote:
>
> The reason I thought the function may be executing more than once is
> because I was not given the calling code - only the function.
>
> Sincerely, Brooks
>
> *ADS* develops & supports effiective, efficient and secure software
> solutions
> *
> --
> *
> *Federal Reserve Bank of Atlanta *∙* *Application Delivery Services
> 1000 Peachtree Street NE ∙ Atlanta,Georgia ∙ 30309-4470 ( 404-498-8178
>
>
>
>
>
> From:Frank Moorman 
> 
> To:discussion@acfug.org,
> Date:05/22/2012 10:01 PM
> Subject:Re: [ACFUG Discuss] CF9 email problem
> Sent by:ad...@acfug.org
> --
>
>
>
> One interesting thing, I just checked the undelivered log and it was
> empty, but It allowed me to set the mail log severity level. I changed it
> all the way from warning to debug Time to test...
>
> On 05/22/2012 09:54 PM, Frank Moorman wrote:
> Yeah,  I'm really stumped by this. I initially thought that I cut and
> pasted a "*query=*" attribute into the  tag.
>
> I'm still not sure what is happening. I plan on adding a few  tags
> into the method later tonight, similar to what Brooks mentioned.
>
> The other weird thing is that the email is sent out a few minutes apart
> (one reason why I am considering a possible mail server issue.) But it only
> seems to duplicate this specific email, and every time this email is sent,
> (but no reports or evidence of any other email on the system.)
>
> I have a PNG file of the CF admin showing the emails here:*
> **
> http://www.moormanappdev.com/ColdFusion%20Administrator_1337736378216.png*
>
>
>
> On 05/22/2012 07:43 PM, Cheyenne Throckmorton wrote:
> I can't imagine why the same function would send multiple of the first and
> only one of the second unless maybe your  #GetContactInfo.email_address#
>  statement is returning a comma-delimited list to generate multiple emails
> and maybe to the same list.  Like its returning 
> *fr...@domain.com*
> ,*fr...@domain.com* ,*fr...@domain.com*
> ,*fr...@domain.com*  from some kind of a join mix up in
> the sql and then your mail setup is spawning off separate emails to each
> email in the list despite them all being the same.
>
>
>
> On Tue, May 22, 2012 at 3:26 PM, 
> <*brooks.wil...@atl.frb.org*>
> wrote:
> Frank:
>
> Try adding some debugging code. I would add a  at the beginning
> and end of the function body. This would tell me that the function is
> starting and ending as you expect. What may be happening is that the
> function begins, sends the first email and then abnormally terminates. Then
> the calling program calls the function again and this pattern is repeating
> 4 more times. Finally on the 6th try, the function completes as expected.
>
> Sincerely, Brooks
>
>
>
>
> From:Frank Moorman 
> <*stretch...@franksdomain.net*
> >
> To:*discussion@acfug.org* ,
> Date:05/21/2012 03:21 PM
> Subject:[ACFUG Discuss] CF9 email problem
> Sent by:*ad...@acfug.org* 
>  --
>
>
>
>
> All,
>
> I am having an email problem... My system is sending out about a dozen of
> the first email yet only one of the second. (I only want one of each.) The
> system is CF9 and it has happened a few times. (Every time since it was
> implemented this weekend.)  I tried to find any type of loop or query and I
> stunned...   I considered the possibility that it is a mail server problem
> yet no other email seems to be affected and the site hosts two separate CF
> applications with many different emails from both.
>
> I have copied the code in its entirety here just removing the identifying
> information... The component call executes a database query which returns a
> single row.
>
>  hint="sends an email.">
> 
>
> 
>
>  returnvariable="GetContactInfo">
>   
> 
>
>  cc=*"supp...@zzz.com"*from="
> *zz.com*  ** "
> subject="zzz Correspondence" type="text">
> Customer,
>
> Your request has been sent ...blah... blah... blah...
> #GetContactInfo.contractor_phone#. blah... blah...
> blah...#GetContactInfo.contractor_first_name#
> #GetContactInfo.contractor_last_name#.
> 
>
>  cc=*"supp...@zzz.com"*from="
> *zzz.com*  ** "
> subject="CUSTOMER REQUEST" type="text">
> blah... blah... blah...
>
> CUSTOMER INFORMATION:
> Name: #GetCon

Re: [ACFUG Discuss] Tricky SQL help?

[Dawn Hoagland]

Typically, processing in DB will be faster - even if you need to write a
stored proc to do processing.  You can write inefficient stuff in a DB
pretty easily as well, so it's not ALWAYS a given.

I'm more familiar with Oracle & SQL Server so I'm not sure which method
will be better using MySQL (outer joins with subqueries or unions of
subqueries). One thing is for sure though, indexes or hints may be
necessary to produce the fastest results.  Sometimes creating views (for
instance) will be faster than doing sub-queries as you've outlined below.

Sometimes you just have to play with several methods to get the data the
way you want and see which is more efficient.

On Mon, Apr 9, 2012 at 12:53 PM, Tepfer, Seth  wrote:

>  Nathan reminded me I didn’t give full info:
>
> **· **Small data set <1K records
>
> **· **Using MySQL 5.0
>
> ** **
>
> Sure, I have a working answer with query1 (students with Temp or Perm),
> query2 (all students except those returned in Q1), Union Q1 + Q2.
>
> ** **
>
> But There has to be a more efficient method. I know with our servers and
> the recordset, the need for efficiency is minimal, but I don’t want to be
> lazy or miss a chance to learn new techniques. 
>
> ** **
>
> Isn’t MySQL faster than CF at doing the select? If I can do it all in one
> call, isn’t it better to make MySQL do the heavy lifting?
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Charlie
> Arehart
> *Sent:* Monday, April 09, 2012 11:01 AM
> *To:* discussion@acfug.org
> *Subject:* RE: [ACFUG Discuss] Tricky SQL help?
>
> ** **
>
> Just a guess, with the limited info, but it seems to me that you’d just
> want then for the query to get “all the students”, and make the decision as
> to what address to “show” in CFML while looping over the results. Or do you
> have some reason to want to do this all in a query?
>
> ** **
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org ] *On
> Behalf Of *Tepfer, Seth
> *Sent:* Monday, April 09, 2012 10:45 AM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Tricky SQL help?
>
> ** **
>
> I know this is not strictly a CF issue, but I’m trying to find the most
> efficient way of doing this, and a single query seems faster than 2 queries
> plus a query of queries.
>
>  
>
>  
>
> I have two tables, one of student names, one of addresses. ** **
>
>  
>
> *Students*: id, name, emplID
>
> *Addresses*: emplID, addressType, addressline1, city, state, 
>
>  
>
> *Student table data:*
>
> 1, john dooley, 1234567
>
> 2, jane dooley, 2345678
>
> 3, tom dooley, 33456780
>
>  
>
> *Addresses table data:*
>
> 1234567, onCampus, 101 Dowman, null, null
>
> 1234567, home address, 100 main street, springfield, IL
>
> 1234567, permanent forward, 120 main street, Atlanta, GA
>
> 2345678, home address, 200 main street, springfield, MO
>
> 2345678, temporary forward, 130 main street, Atlanta, GA
>
> 3456789, home address, 300 main street, springfield, GA
>
>  
>
> Every student has a home address. Some have permanent or temporary
> forwards. The query results I want to return are 
>
> · All the student names
>
> · If they have permanent or temporary forward, that address
>
> · If they do not, a null for the address (NOT the home address or
> onCampus address)
>
>  
>
> I’ve tried an outer join with a ‘where addressType = ‘permanent or
> temporary’, but that doesn’t give me all the names, just the ones with a
> forward. 
>
> Thanks for any time you can give.
>
>  
>
> ** **
>  --
>
>
> This e-mail message (including any attachments) is for the sole use of
> the intended recipient(s) and may contain confidential and privileged
> information. If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination, distribution
> or copying of this message (including any attachments) is strictly
> prohibited.
>
> If you have received this message in error, please contact
> the sender by reply e-mail message and destroy all copies of the
> original message (including attachments).
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> - 
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by F

Re: [ACFUG Discuss] Tricky SQL help?

[Dawn Hoagland]

And I'll disagree - make the DB do the work unless it is an extremely small
dataset.

We don't know if he's working with a few hundred records or 20,000.  While
it won't matter if it's a small dataset, developers should learn how to get
the data they need from the database so that in the even they ARE
processing 100k records, it's done properly.

I've seen even small apps/databases CRAWL by looping over data or running
multiple queries when the developer didn't know how to properly query a
limited dataset or group data using CFOUTPUT.

-- 
Dawn

On Mon, Apr 9, 2012 at 11:23 AM,  wrote:

> Seth
> I must agree with Charlie on this.
> Even though the script Nelson provided will work I believe it is overkill
> for your needs as described.
> Join the two tables on empid for all records and simply do a conditional
> output of the query.
> Test if addressType is equal to temporary or permanent and output the
> address fields.
> If not then output null fields
> Display or hide the address type as you wish
>
> IMHO
>
>
> On , "Tepfer, Seth"  wrote:
> >
> >
> >
> >
> >
> >
> >
> > I know this is not strictly a CF issue, but I’m trying to find the most
> efficient way of doing this, and a single query seems faster than 2 queries
> plus a query of queries.
> >
> >
> > I have two tables, one of student names, one of addresses.
> >
> > Students: id, name, emplID
> > Addresses: emplID, addressType, addressline1, city, state,
> >
> >
> > Student table data:
> > 1, john dooley, 1234567
> > 2, jane dooley, 2345678
> > 3, tom dooley, 33456780
> >
> > Addresses table data:
> > 1234567, onCampus, 101 Dowman, null, null
> > 1234567, home address, 100 main street, springfield, IL
> > 1234567, permanent forward, 120 main street, Atlanta, GA
> > 2345678, home address, 200 main street, springfield, MO
> > 2345678, temporary forward, 130 main street, Atlanta, GA
> > 3456789, home address, 300 main street, springfield, GA
> >
> > Every student has a home address. Some have permanent or temporary
> forwards. The query results I want to return are
> >
> >
> > ·
> > All the student names
> >
> > ·
> > If they have permanent or temporary forward, that address
> >
> > ·
> > If they do not, a null for the address (NOT the home address or onCampus
> address)
> >
> > I’ve tried an outer join with a ‘where addressType = ‘permanent or
> temporary’, but that doesn’t give me all the names, just the ones with a
> forward.
> >
> > Thanks for any time you can give.
> >
> >
> >
> >
> >
> >
> >
> >
> > This e-mail message (including any attachments) is for the sole use of
> >
> > the intended recipient(s) and may contain confidential and privileged
> >
> > information. If the reader of this message is not the intended
> >
> > recipient, you are hereby notified that any dissemination, distribution
> >
> > or copying of this message (including any attachments) is strictly
> >
> > prohibited.
> >
> >
> >
> > If you have received this message in error, please contact
> >
> > the sender by reply e-mail message and destroy all copies of the
> >
> > original message (including attachments).
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > -
> >
> >
> > To unsubscribe from this list, manage your profile @
> >
> >
> > http://www.acfug.org?fa=login.edituserform
> >
> >
> >
> >
> >
> > For more info, see http://www.acfug.org/mailinglists
> >
> >
> > Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> >
> >
> > List hosted by FusionLink
> >
> >
> > -
> >
> >
> >
>

Re: [ACFUG Discuss] incorporation advice

[Dawn Hoagland]

If you're the sole business owner, save yourself lots of headaches and at
least start out as a sole proprietor LLC.  Protect yourself with proper
insurance (general liability, errors & omissions, etc).  You can always
convert to an S Corp later if the $$ coming in warrants hiring an
accountant to take care of everything for you.  Filings for a sole
proprietor LLC are relatively simple with the proper Turbo Tax software.

If you have partners - there's a ton of paperwork yearly whether your an
LLC or S Corp - so you might as well go S Corp and get an accountant.  You
still need the insurance

-- 
Dawn

On Wed, Feb 22, 2012 at 3:20 PM, Charlie Arehart wrote:

> And here’s where one (I) could argue that if one operates as a sole
> proprietor they avoid all those s-corp forms. :-) I operated as an s-corp
> once: what a pain. That was before LLCs. I might choose that myself if I
> felt compelled to change from sole proprietor.
>
> I know that the conventional wisdom is that one is “too unprotected” if a
> sole proprietor, but as William noted, if someone can pierce the corporate
> veil, then the LLC or s-corp protection won’t avail much, it seems. But
> otherwise, I do business like everyone else here has discussed (paying
> taxes on my income, as a schedule C on my personal taxes, having business
> insurance, having a business bank account, etc.
>
> Just saying it’s another option. As others have said, weigh them all
> carefully.
>
> /charlie
>
> ** **
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Peyton
> Todd
> *Sent:* Wednesday, February 22, 2012 10:47 AM
> *To:* discussion@acfug.org
>
> *Subject:* Re: [ACFUG Discuss] incorporation advice
>
> ** **
>
>
> Just to add my two cents: Be SURE to get a professional to do your taxes.
> I was (am still) an S-Corp, and years ago when I was programming steadily,
> I experienced no end of grief figuring out all the tax forms, and
> remembering to file every stinking form on time!
>
> Peyton
> 
>
> 
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>

Re: [ACFUG Discuss] JavaLoader & POI Issue

[Dawn Hoagland]

I did note in your java loader code that you're loading all of the jars in
that subdirectory.  Any chance you have multiple versions of POI there?

Looking over the java docs, try this:

*org.apache.poi.POIXMLProperties.CoreProperties.getRevision()*


On Thu, Nov 24, 2011 at 11:48 AM, Mike Staver  wrote:

> Interesting. Since I'm using the same code on two different systems and
> getting the same results - is there any way I can see what is loaded in
> memory currently?
>
> -Mike
>
> On Nov 24, 2011, at 7:46 AM, Dawn Hoagland  wrote:
>
> I've seen this happen when multiple versions of the library are being
> loaded into memory.  CF/Java SHOULD pick the one loaded with the
> Javaloader, but doesn't always. I've seen this happen when multiple
> versions of POI have been dropped in CF's lib folder as well.  When stuff
> like this happens, I write/test in java only to eliminate issues with POI.
>
> On Wed, Nov 23, 2011 at 9:35 PM, Mike Staver  wrote:
>
>>  I've always been able to use POI via JavaLoader to read in standard xls
>> files and extract data out of the cells for whatever I want, like storing
>> in a database. Recently, I've had to start coding to handle Office 2007
>> file formats like xlsx and xlsm. POI 3.5 and higher should be able to do
>> that according to many examples I've found on the internet and in Apache's
>> own documentation. So, I'm currently using ColdFusion 9, JavaLoader 1.0,
>> and POI 3.8b4. For the record, I've also tried POI 3.6 and 3.7 for this
>> test and sample code below. Here is my sample code:
>>
>> 
>> 
>> 
>> 
>> 
>> > filter="*.jar" recurse="true" />
>>
>> 
>> 
>> 
>>
>> 
>> > "component.JavaLoader").init(loadPaths=var.paths,
>> loadColdFusionClassPath=false) />
>> 
>>
>> 
>> fileAndPath = "/Users/mstaver/workspace/Fimble/11g.xlsm";
>> inp = createObject("java",
>> "java.io.FileInputStream").init("#fileAndPath#");
>> objWorkBook =
>> server[var.JLKey].create("org.apache.poi.xssf.usermodel.XSSFWorkbook").Init(inp);
>> 
>>
>> 
>>
>> When I write use this code with one small tweak (HSSF instead of XSSF)
>> and I feed in an xls file, everything works as expected. However, when I
>> use the exact code above and feed it xlsx or xlsm, I get this error:
>>
>>  Object instantiation exception.  An exception occurred while
>> instantiating a Java object. The class must not be an interface or an
>> abstract class. Error: ''.   The error occurred in 
>> */Users/mstaver/workspace/Fimble/test.cfm:
>> line 18*
>> *Called from* /Users/mstaver/workspace/Fimble/Application.cfc: line 97
>> *Called from* /Users/mstaver/workspace/Fimble/test.cfm: line 18
>> *Called from* /Users/mstaver/workspace/Fimble/Application.cfc: line 97
>>
>> 16 : fileAndPath = "/Users/mstaver/workspace/Fimble/11g.xlsm";
>> 17 : inp = createObject("java", 
>> "java.io.FileInputStream").init("#fileAndPath#");*18 : objWorkBook = 
>> server[var.JLKey].create("org.apache.poi.xssf.usermodel.XSSFWorkbook").Init(inp);*
>>
>>
>> Further down the error stack, I think this is relevant:
>>
>>  Caused by: java.lang.NoClassDefFoundError: Could not initialize class 
>> org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller
>>
>>
>> I don't know where to go on this one. I've tried the SS method, instead
>> of XSSF - and it works fine, until I feed it an xlsx or xlsm again. I don't
>> get it. I've also tried this on Windows 2003, besides here on my Macbook.
>> Both machines are running CF 9.0.1. I'm getting the impression that I'm
>> missing a class or something. I've followed examples from all over the web,
>> and from the POI docs. Everything works until I feed it Office 2007 format
>> docs...
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink <http://www.fusionlink.com>
>> -
>
>
>
>
> --
> Dawn
>
>


-- 
Dawn

Re: [ACFUG Discuss] JavaLoader & POI Issue

[Dawn Hoagland]

I've seen this happen when multiple versions of the library are being
loaded into memory.  CF/Java SHOULD pick the one loaded with the
Javaloader, but doesn't always. I've seen this happen when multiple
versions of POI have been dropped in CF's lib folder as well.  When stuff
like this happens, I write/test in java only to eliminate issues with POI.

On Wed, Nov 23, 2011 at 9:35 PM, Mike Staver  wrote:

>  I've always been able to use POI via JavaLoader to read in standard xls
> files and extract data out of the cells for whatever I want, like storing
> in a database. Recently, I've had to start coding to handle Office 2007
> file formats like xlsx and xlsm. POI 3.5 and higher should be able to do
> that according to many examples I've found on the internet and in Apache's
> own documentation. So, I'm currently using ColdFusion 9, JavaLoader 1.0,
> and POI 3.8b4. For the record, I've also tried POI 3.6 and 3.7 for this
> test and sample code below. Here is my sample code:
>
> 
> 
> 
> 
> 
>  filter="*.jar" recurse="true" />
>
> 
> 
> 
>
> 
>  "component.JavaLoader").init(loadPaths=var.paths,
> loadColdFusionClassPath=false) />
> 
>
> 
> fileAndPath = "/Users/mstaver/workspace/Fimble/11g.xlsm";
> inp = createObject("java",
> "java.io.FileInputStream").init("#fileAndPath#");
> objWorkBook =
> server[var.JLKey].create("org.apache.poi.xssf.usermodel.XSSFWorkbook").Init(inp);
> 
>
> 
>
> When I write use this code with one small tweak (HSSF instead of XSSF) and
> I feed in an xls file, everything works as expected. However, when I use
> the exact code above and feed it xlsx or xlsm, I get this error:
>
>  Object instantiation exception.  An exception occurred while
> instantiating a Java object. The class must not be an interface or an
> abstract class. Error: ''.   The error occurred in 
> */Users/mstaver/workspace/Fimble/test.cfm:
> line 18*
> *Called from* /Users/mstaver/workspace/Fimble/Application.cfc: line 97
> *Called from* /Users/mstaver/workspace/Fimble/test.cfm: line 18
> *Called from* /Users/mstaver/workspace/Fimble/Application.cfc: line 97
>
> 16 : fileAndPath = "/Users/mstaver/workspace/Fimble/11g.xlsm";
> 17 : inp = createObject("java", 
> "java.io.FileInputStream").init("#fileAndPath#");*18 : objWorkBook = 
> server[var.JLKey].create("org.apache.poi.xssf.usermodel.XSSFWorkbook").Init(inp);*
>
>
> Further down the error stack, I think this is relevant:
>
>  Caused by: java.lang.NoClassDefFoundError: Could not initialize class 
> org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller
>
>
> I don't know where to go on this one. I've tried the SS method, instead of
> XSSF - and it works fine, until I feed it an xlsx or xlsm again. I don't
> get it. I've also tried this on Windows 2003, besides here on my Macbook.
> Both machines are running CF 9.0.1. I'm getting the impression that I'm
> missing a class or something. I've followed examples from all over the web,
> and from the POI docs. Everything works until I feed it Office 2007 format
> docs...
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -




-- 
Dawn

Re: [ACFUG Discuss] PDFs / Excel Shenanigans

[Dawn Hoagland]

ColdFusion 9 uses the Apache POI project to create Excel spreadsheets.  You
can access all of the bits natively to create multiple sheets.  You can find
tons of info about POI here: http://poi.apache.org/

On Tue, Oct 11, 2011 at 3:50 PM, Matthew Nicholson <
matthew.nichol...@soltech.net> wrote:

> Afternoon All!
>
> ** **
>
> I’ve got a issue that I’ve been mulling over and curious if I’m just making
> this more difficult on myself the necessary.
>
> ** **
>
> To begin, I’ve got this delightfully (and obnoxiously) detailed HTML form
> that is currently being piped out to an excel file for user consumption.
> This whole system works perfectly until the client starts looking for
> multiple sets of data to be displayed. 
>
> ** **
>
> I’d like to potentially pipe this information into a PDF (and then make
> multiple pages)
>
> Or continue to pipe out the data to excel and use multiple sheets.
>
> ** **
>
> On the code side of things I define:
>
> ** **
>
> 
>
> ***
> *
>
> ** **
>
> Now this handles my initial file load for a single data set swimmingly but
> when multiple sets are needed, things begin to get less then desirable. **
> **
>
> ** **
>
> Thoughts? Suggestions?
>
> ** **
>
> As always, thank you all for your time and expertise!
>
> ** **
>
> *Matthew R. Nicholson*
>
> *SolTech, Inc.*
>
> *www.soltech.net*
>
> *(p) 404.601.6000, Ext 233*
>
> *(c) 770.833.5326*
>
> *Yes.  We can get you there.* 
>
> ** **
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -




-- 
Dawn

Re: [ACFUG Discuss] cfspreadsheet question

[Dawn Hoagland]

I have used the actual POI calls to obtain specific cells from specific
sheets if you know exactly how things are laid out.  The snippet of code
will cycle through all of the rows/cells in a spreadsheet - but you can add
a loop to do the same thing through several worksheets.







 














On Wed, Jul 27, 2011 at 3:04 PM, Jeff Howard  wrote:

> I'm working in CF9 and trying to use cfspreadsheet to pull the values out
> of an xls and write the values to a db.  The xls has 4 sheets with the 4th
> sheet being the raw data being output from an allergen testing machine.
> Beneath the raw data there are formulas that are used to populate a chart on
> the 3rd sheet.  I am trying to extract the values that are computed but when
> using cfspreadsheet it is returning the formula for the cell and not the
> computed value.
>
> I've done some searching but have not found a solution to this issue and
> figured I'd throw out here and see if anyone has had to deal with this.
>
> I have come across spreadsheetGetCellValue but it does not let you specify
> the sheet.
>
> Is the only way to do this is to extract the entire sheet from the original
> and then create a new 1 page sheet from this and then use
> spreadsheetGetCellValue to get the value I need or is there a more
> streamlined solution?
>



-- 
Dawn

Re: [ACFUG Discuss] cfloop query - whats best include page vs cfhttp

[Dawn Hoagland]

I've written something similar to this to schedule processes and make sure
we aren't killing the server during batch runs by running too many processes
in parallel.  If there's a process to run, I invoke a component to run the
process.  The component updates the db to show it is running.  This is all
controlled by a background process that watches a file that is "touched"
whenever a process is added to the table.

FWIW - I'd also stay away from cfhttp if possible - especially if these
reports are in any way critical.  It's finicky - and if everything is on the
same server, there's really no reason I can think of (although there may be
one I haven't thought of) to use it.













  
  

  


On Thu, Mar 17, 2011 at 5:09 PM, Teddy R. Payne wrote:

> Ajas,
> Whether you use cfhttp or not, you can use cfthread to make sure a
> dependency order exists.  With cfthread, you probably would not need a
> sleep if set it up that the next thread cannot start until the first
> one finishes.
>
> I have not tried to just create a loop of threads over and over.  I am
> sure it would work, but you would have to look at the how long each
> thread takes versus how many iterations of your loop and test the
> performance around your approach.  I favor threads for predictable
> number of executions or some sort of one-off parallel execution.
>
> If you put the document creation logic in a UDF or CFC, loop around
> the function call as the function call will have to complete before
> the next loop starts.  Otherwise, you will either need a sleep() or
> some programmatic approach that will indicate when a document creation
> has been completed before the next iteration of document creation.
>
> Pseudo code:
>
> 
>
> 
>
> 
>
> Hopefully that answered some portion of your question.
>
>
> Teddy R. Payne, ACCFD
> Google Talk - teddyrpa...@gmail.com
>
>
>
>
> On Thu, Mar 17, 2011 at 3:53 PM, Ajas Mohammed  wrote:
> > Teddy,
> >
> > The logic and cfpdf/cfdocument stuff is already in place i.e. on the page
> > that needs to be called. I was thinking for 3 records returned, cfinclude
> > would mean, create pdf, sleep, then create pdf, sleep, and finally create
> > 3rd pdf. Whereas if I do cfhttp, it will 3 separate processes or can I
> call
> > it threads, iam not sure, so, http://ip addr/test/doThis.cfm for 1st
> record,
> > sleep, then another http://ip addr/test/doThis.cfm, sleep, and final 3rd
> > call http://ip addr/test/doThis.cfm.
> >
> > So which method is better?
> >
> > 
> > http://ajashadi.blogspot.com
> > We cannot become what we need to be, remaining what we are.
> > No matter what, find a way. Because thats what winners do.
> > You can't improve what you don't measure.
> > Quality is never an accident; it is always the result of high intention,
> > sincere effort, intelligent direction and skillful execution; it
> represents
> > the wise choice of many alternatives.
> >
> >
> > On Thu, Mar 17, 2011 at 3:43 PM, Teddy R. Payne 
> > wrote:
> >>
> >> Ajas,
> >> You can probably just  or  for your document
> >> creation after you save the content of each query loop and create
> >> whatever display logic you need.
> >>
> >> As far as making aquery execute longer, try the sleep() function or
> >> using cfthread with the sleep action.
> >>
> >>
> >> Teddy R. Payne, ACCFD
> >> Google Talk - teddyrpa...@gmail.com
> >>
> >>
> >>
> >>
> >> On Thu, Mar 17, 2011 at 3:37 PM, Ajas Mohammed 
> wrote:
> >> > Hi,
> >> >
> >> > I am thinking of a CF schedule night 2 am job which will basically
> >> > create a
> >> > pdf based of query data.
> >> >
> >> > So first  then  and then
> question
> >> > is
> >> > do i want to include this pdf creation page by using cfinclude or do I
> >> > use
> >> > cfhttp call.
> >> >
> >> > Also, I would like a sleep call between first record and every
> >> > subsequent
> >> > record returned by query. So lets say, after pdf gets created for
> first
> >> > record, there should be a delay like 7 secs , then 2nd record and so
> on.
> >> >
> >> > Let me know your opinion. I am dying to use cfhttp as I havent used
> that
> >> > before. ;-)
> >> >
> >> > 
> >> > http://ajashadi.blogspot.com
> >> > We cannot become what we need to be, remaining what we are.
> >> > No matter what, find a way. Because thats what winners do.
> >> > You can't improve what you don't measure.
> >> > Quality is never an accident; it is always the result of high
> intention,
> >> > sincere effort, intelligent direction and skillful execution; it
> >> > represents
> >> > the wise choice of many alternatives.
> >> >
> >>
> >>
> >> -
> >> To unsubscribe from this list, manage your profile @
> >> http://www.acfug.org?fa=login.edituserform
> >>
> >> For more info, see http://www.acfug.org/mailinglists
> >> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> >> List hosted by http://www.fusionlin

[ACFUG Discuss] Fwd: 51% Off WhirlyBall in Roswell

[Dawn Hoagland]

Knowing how whirly-ball is a popular spot for this group - I knew I had to
pass it along when I saw it in my inbox this morning!

-- Forwarded message --
From: Groupon 
Date: Thu, Mar 17, 2011 at 6:52 AM
Subject: 51% Off WhirlyBall in Roswell


 Your Daily Atlanta Groupon   |   Go to
Groupon.com
 |
Unsubscribe
 Be sure to add
m...@e.groupon.com to your address book or safe sender list so our emails
get to your inbox. Learn
how
  [image: Groupon]

  The
Daily Deal for   Atlanta Thursday, March 17, 2011

follow us: [image: Facebook]

[image:
Twitter]

 $50 for 30 Minutes of WhirlyBall for Up to 20 Players ($101.65
Value)
 [image:
See 
Deal]
$50  Value $101  Discount 50%  You Save $51  [image: $50 for 30 Minutes
of WhirlyBall for Up to 20 Players ($101.65
Value)]
The Company
 
WhirlyBall
  Locations
 5130 Commerce Pkwy.
Roswell, Georgia 30076
Get 
Directions

Superior hand-eye coordination enables people to text message while riding
motorcycles and paint portraits of famous postmaster generals while eating
funnel cake. Show off your own motor skills with today's Groupon: for $50,
you and up to nine friends get 30 adrenaline-pumping minutes of
WhirlyBall,
a medium-impact sport that combines the best aspects of lacrosse,
basketball, and bumper cars (up to a $101.65 value). WhirlyBall Atlanta is
located in Roswell.

In WhirlyBall, participants maneuver free-range bumper cars and use a
handheld scoop to collect wiffle balls to launch at the overhead targets
located on either end of the court. You'll work together in teams of up to
five at a time (up to 20 players are allowed on the court at once, and at
least 10 are required) to crush your opponents in a whirlywind of scoops and
balls. Surrounded by safety bumpers, your
vehicleenjoys
a complete range of motion with powerful steering that allows you to
turn on a whim or a dime. If more than 20 Whirlers are in the party, players
can be rotated in and watch from the comfort of leather lounge couches
instead of gathering posterior splinters on the end of a rigid bench.

WhirlyBall levels the playing field between couch potatoes and accomplished
athletes in a competition that replaces running with full-throttle maneuvers
at blistering speeds reaching 3–4 miles per hour. A full-service bar is
available to sate Whirled appetites, and customers are invited to watch the
game, and hang out at WhirlyBall Atlanta's off-court pool tables and arcade
games.
  Read More 
»
Bus drivers need hugs like everybody else. Especially when driving.
  [image: Learn
More]
 More
Deals For You  See
All
  [image: 
Small_price_tag]
Half
Off Comedy Festival Tickets

 4 locations
 [image: 
Small_price_tag]
Up
to 74% Off Services at Cumming Dental
Care

Re: [ACFUG Discuss] Upgrading CF7 to CF9

[Dawn Hoagland]

We recently moved an app from CF7 to CF9.  The only issue language related
that we ran into was that the arguments for the ListToArray() function (I
think, I don't have the code in front of me) changed and caused a few
unexpected results in some reports.  Every other issue we had was moving the
DB from SQL Server to Oracle - definitely a much bigger change...

Dawn

On Sat, Sep 4, 2010 at 1:57 PM, Frank Moorman
wrote:

> Thank you Charlie. I will look at the blog entries.
>
> I have used the code checker and I have even used CF9 for two months on a
> development machine. But I still worry. I googled for the information before
> I created this email and I did not find much which makes me wonder if I am
> just cynical or too cautious about it being a clean move. (On an aside,
> sometimes I also think that being experienced means that you expect failure
> so that you can deal with it as soon as it happens, instead of going into
> denial that your code can't be at fault.)
>
> I remember the big changes and problems caused during the last upgrade
> (CF5-CF7). The move to java also moved the database drivers from ODBC to
> JDBC. When that occurred, parameter overloading on stored procedures was no
> longer supported and it caused us to rewrite many of our existing procs. In
> addition the JDBC change obsoleted the DBVARNAME attribute and changed all
> CFPROCPARAMS to be positional instead of identifying the variable. We
> searched for and corrected this as well as we could during testing, but I
> think the last positional error was not found until 4-6 months after the
> code hit production.
>
> The other big issue during the migration was the CF7 bug that did not run
> custom javascript if you used any CFINPUT edits to check for data validity.
> We found this error about two weeks before implementation and ran around
> applying a workaround to each page this affected (about 125 pages if I
> remember correctly.) A few days after we finished putting in our workaround
> Macromedia came out with a patch for it.
>
> But before I keep droning on and on, Thank you for the information.
>
> Frank
>
>
> On 09/04/2010 12:01 PM, Charlie Arehart wrote:
>
>> Hey Frank, at least with respect to the aspect of your jump including
>> going "through"
>> CF8, this blog entry from Josh points to several resource for those moving
>> to it:
>>
>>
>> http://blog.joshuaadams.com/index.cfm/2008/9/4/Upgrading-from-ColdFusion-MX-to-ColdFus
>> ion-8
>>
>> Granted, I know you want info on 9. I'm not aware of any that have been
>> done, though
>> perhaps there have been.
>>
>> One place to look, at least to get more info on what's changed, is a list
>> of CF9
>> tutorial resources gathered up (from many people) by blogger Akbarsait:
>>
>> http://www.akbarsait.com/cf9tutorials.cfm
>>
>> Going back to the move to CF8, one of the resources Josh points to is a
>> blog entry of
>> mine which may also interest you:
>>
>>
>> http://www.carehart.org/blog/client/index.cfm/2009/8/10/cf8_migration_resources
>>
>> I'll say as well that certainly your move from 5 to 7 was huge, on two
>> counts: CF6 had
>> been a major rewrite of CF onto Java, and 7 added quite a lot.
>>
>> The move from 7 to 9 should be less challenging. It seems that there's
>> been even more
>> focus in recent releases to try to do no harm to existing apps, but of
>> course there's
>> always something that can have changed that might affect one user more
>> than most, so
>> testing is always vital.
>>
>> Finally, as Josh points out in his entry, don't forget the available Code
>> Compatibility Checker that's built into the CF Administrator and has been
>> for years.
>> Of course, it's upgraded each release. It's not perfect, but it's a start.
>>
>> Hope that helps.
>>
>> /charlie
>>
>>
>>
>>
>>> -Original Message-
>>> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Frank
>>> Moorman
>>> Sent: Saturday, September 04, 2010 2:53 AM
>>> To: discussion@acfug.org
>>> Subject: [ACFUG Discuss] Upgrading CF7 to CF9
>>>
>>> All,
>>>
>>> I am planning on upgrading from CF 7 to CF9.
>>>
>>> The last time I did a major upgrade was when I moved from CF5 to CF7. At
>>> that time, Macromedia provided documentation on exactly what to look for
>>> in your code before the upgrade. (mostly tag/attribute changes and
>>> deprecations.) I did find the following web page:
>>>
>>>
>>> http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cb
>>> ec17576-7fef.html
>>>
>>> However this page seems sparse in comparison to the documentation that I
>>> remember during my last upgrade.
>>>
>>> Has there not been any more deprecated tags and functions since CF7? Or
>>> does Adobe believe upgrading will be painless for all? If anyone can
>>> point me to additional documentation I would appreciate it.
>>>
>>> In addition, if anyone had a major issue during an upgrade from 7 (or 8)
>>> to 9, I would appreciate a heads up on what to watch out for.
>>>
>>> Thanks,
>>> Frank
>>>
>>

Re: [ACFUG Discuss] Guinea Pigs to Test an Adobe Acrobat Problem?

[Dawn Hoagland]

The border was there, but the video was fine.  There were controls, but I
think clicking one is what caused whatever issue I was having.

I was able to move the bottom video back and forth, frame by frame.

Dawn

On Fri, Jun 11, 2010 at 8:34 PM, Peyton Todd  wrote:

> Thanks, Dawn, that did help, especially the second part, if it means the
> problem lies with my particular Win 7 PC. Just to be clear: you saw the
> controls at the bottom, and you were able to click on the far righthand
> arrow to cause the video to move forward one frame at a time, correct?
>
> Also, when you say the first part looked good, do you mean it WASN'T
> surrounded by a thick black border?
>
> Thanks,
> Peyton
>
> --
> *From:* Dawn Hoagland 
> *To:* discussion@acfug.org
> *Sent:* Fri, June 11, 2010 6:36:34 PM
> *Subject:* Re: [ACFUG Discuss] Guinea Pigs to Test an Adobe Acrobat
> Problem?
>
> I'm running Windows 7 - 64 bit.  I was able to play the first video once.
> Closing the document & killing any acrobat process would not let me view it
> again.  It looked good, but I didn't try frame by frame clicking - and can't
> get it back to test.
>
> The second video also looked fine - even frame by frame.
>
> Hope this helps!
>
> On Fri, Jun 11, 2010 at 5:25 PM, Peyton Todd  wrote:
>
>> Hello all,
>>
>> I know you're Cold Fusion types, but as loyal Adobe stalwarts, any chance
>> a few of you who have Win 7 PCs could test an Adobe Acrobat problem I have?
>> (It would be great to know the results for Mac users, too.)
>>
>> It's that the video clips I embed in my research papers on American Sign
>> Language (ASL) do not show properly in my new Windows 7 (64-bit version) PC.
>> If I embed them the new way (converted to flash files) the result is ugly
>> (big black border), and important functionality is lost (no frame-by-frame
>> movement).
>>
>> If I embed them the legacy way (relying upon the relevant downloaded app
>> to show them - Quicktime in my case) the result is worse: the controls
>> disappear from the floating window, with an ugly black bar where they should
>> be. This happens both via the legacy route in Acro Pro 9 and in PDFs made in
>> Acro Pro 8.
>>
>> What I need to know is:  IS IT JUST MY WIN 7 PC THAT HAS THE PROBLEM, OR
>> EVERYONE ELSE'S?
>>
>> You can test this by opening the attached PDF, which I have prepared using
>> the new Adobe Acrobat version 9 Pro Extended.
>>
>> The legacy way still works fine on my Windows XP PC, whether the PDF was
>> built in Acro Pro 8 or Acro Pro 9. But more and more readers of my papers
>> will be switching to Windows 7 as time goes by. The present system will be a
>> catastrophe for my research unless the problem happens to be specific to my
>> particular Win 7 PC.
>>
>> Thanks,
>>
>> Peyton
>>
>> P.S. One-frame-at-a-time viewing is crucial for understanding my research!
>>
>>
>> P.P.S. Of course, I have in mind testing it in Adobe Acrobat Reader, not
>> Acrobat itself. (The problem is the same either way.)
>>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink <http://www.fusionlink.com>
> -

Re: [ACFUG Discuss] Guinea Pigs to Test an Adobe Acrobat Problem?

[Dawn Hoagland]

I'm running Windows 7 - 64 bit.  I was able to play the first video once.
Closing the document & killing any acrobat process would not let me view it
again.  It looked good, but I didn't try frame by frame clicking - and can't
get it back to test.

The second video also looked fine - even frame by frame.

Hope this helps!

On Fri, Jun 11, 2010 at 5:25 PM, Peyton Todd  wrote:

> Hello all,
>
> I know you're Cold Fusion types, but as loyal Adobe stalwarts, any chance a
> few of you who have Win 7 PCs could test an Adobe Acrobat problem I have?
> (It would be great to know the results for Mac users, too.)
>
> It's that the video clips I embed in my research papers on American Sign
> Language (ASL) do not show properly in my new Windows 7 (64-bit version) PC.
> If I embed them the new way (converted to flash files) the result is ugly
> (big black border), and important functionality is lost (no frame-by-frame
> movement).
>
> If I embed them the legacy way (relying upon the relevant downloaded app to
> show them - Quicktime in my case) the result is worse: the controls
> disappear from the floating window, with an ugly black bar where they should
> be. This happens both via the legacy route in Acro Pro 9 and in PDFs made in
> Acro Pro 8.
>
> What I need to know is:  IS IT JUST MY WIN 7 PC THAT HAS THE PROBLEM, OR
> EVERYONE ELSE'S?
>
> You can test this by opening the attached PDF, which I have prepared using
> the new Adobe Acrobat version 9 Pro Extended.
>
> The legacy way still works fine on my Windows XP PC, whether the PDF was
> built in Acro Pro 8 or Acro Pro 9. But more and more readers of my papers
> will be switching to Windows 7 as time goes by. The present system will be a
> catastrophe for my research unless the problem happens to be specific to my
> particular Win 7 PC.
>
> Thanks,
>
> Peyton
>
> P.S. One-frame-at-a-time viewing is crucial for understanding my research!
>
> P.P.S. Of course, I have in mind testing it in Adobe Acrobat Reader, not
> Acrobat itself. (The problem is the same either way.)
>

Re: [ACFUG Discuss] Flex, Flash Security and crossdomain.xml

[Dawn Hoagland]

Thanks Charlie - checking to ensure the crossdomain.xml file was being
loaded was our first order of business.  We confirmed with the IIS logs that
it was being loaded and did some preliminary testing by loading the website
using the server's IP address rather than domain name.  Since the requesting
url (IP address) didn't match flex's remote object call (fully qualified
domain), it wouldn't work w/o the proper crossdomain.xml file.

We had a few issues getting a client proxy tool setup, but I think that had
more to do with our convoluted configuration than anything.  Finally, I
researched and found how to turn debugging on for the Flashplayer to see if
we could find out a bit more of what was going on from the client side.  It
was the error messages there that made us realize the issue where the SWF
was compiled with the Remote location that was not being resolved
externally.  So while the crossdomain.xml was an issue, it wasn't the entire
issue.  It also brings to mind some interesting possible issues for future
deployments due to how applications are deployed in our specific
environment.

Thanks again to all for getting us pointed in the right direction.

Dawn

On Sat, Mar 27, 2010 at 3:49 PM, Charlie Arehart wrote:

>  Dawn, I can’t tell if you (or others) saw my original note in reply to
> your question, offered Thursday when you sent the note. My first point was,
> “You should confirm first that that file is indeed being requested on the
> server.”  I also indicated how to check that, and made the similar
> suggestion to Doug that a client proxy tool could have helped if it wasn’t
> obvious just from your attempting a browser request for the file (which was
> another suggestion I’d made).
>
> I’m just saying all this as much to make sure that others realize that this
> challenge with the crossdomain.xml files isn’t quite that unique. It’s not
> what most tend to think of first, but it’s always worth ruling out first.
> :-)
>
>
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dawn
> Hoagland
> *Sent:* Friday, March 26, 2010 6:17 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] Flex, Flash Security and crossdomain.xml
>
>
>
> Just thought I'd update.
>
> After lots of digging - and tracing Flash player debug info - it turns out
> it's a completely different issue (after a fashion).  The SWF is loading
> correctly, but the URL to "https://dev.company1.org/flex2gateway/'" isn't
> visible externally.  So, indeed it couldn't load the gateway config.  There
> was still a sandbox violation occurring because the REMOTE was trying to go
> to a different server - and that had to be resolved before the true issue
> hit me on the head - but part of the reason I couldn't get it to work is
> that both issues threw the exact same error message in the Flash player.  It
> wasn't until I traced it that I noticed something was slightly different
> with the crossdomain.xml properly set.
>
> This opens a completely different can of worms concerning what's wrong, how
> to fix it and implications of how some of these apps are/will be deployed.
>
> For future reference, if you include "allow-http-request-headers-from" in
> your crossdomain.xml file, you need to use domain names.  If you remove that
> property (just setting the "allow-access-from"), setting domain="*" works
> and gives you a good start for troubleshooting.
>
> Thanks for pointing me in the right direction!
>
> Dawn
>
>
>
> On Thu, Mar 25, 2010 at 3:21 PM, Dawn Hoagland 
> wrote:
>
> I absolutely agree with all of you.  We'll get it locked up tight - once we
> get it working.  I don't have direct access to the server so I'm working
> with several people resolving the issue.
>
> I'll post back once we get it fixed with the resolution (it may help
> someone else having the same issue).
>
> Thanks again!
>
> Dawn
>
>
>
>
>
> On Thu, Mar 25, 2010 at 2:18 PM, Douglas Knudsen 
> wrote:
>
> couldn't agree more with Dean here, lock that thing up.
>
>
>
> http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html
>
> This is a good ref on the topic.
>
>
>
> Also, I'd get Service Capture and verify that your SWF is indeed loading
> the proper crossdomain.xml file as well as other traffic.
>
>
>
> Douglas Knudsen
>
> douglasknud...@gmail.com
>
>
>
>
>
>
>
> On Mar 25, 2010, at 11:41 AM, Dean H. Saxe wrote:
>
>
>
>   FYI, opening up the cross domain policy to all sites is
> doubleplusungood.  (Sorry for the 1984 reference!)  Lock it down to
> the speci

Re: [ACFUG Discuss] Flex, Flash Security and crossdomain.xml

[Dawn Hoagland]

Just thought I'd update.

After lots of digging - and tracing Flash player debug info - it turns out
it's a completely different issue (after a fashion).  The SWF is loading
correctly, but the URL to "https://dev.company1.org/flex2gateway/'" isn't
visible externally.  So, indeed it couldn't load the gateway config.  There
was still a sandbox violation occurring because the REMOTE was trying to go
to a different server - and that had to be resolved before the true issue
hit me on the head - but part of the reason I couldn't get it to work is
that both issues threw the exact same error message in the Flash player.  It
wasn't until I traced it that I noticed something was slightly different
with the crossdomain.xml properly set.

This opens a completely different can of worms concerning what's wrong, how
to fix it and implications of how some of these apps are/will be deployed.

For future reference, if you include "allow-http-request-headers-from" in
your crossdomain.xml file, you need to use domain names.  If you remove that
property (just setting the "allow-access-from"), setting domain="*" works
and gives you a good start for troubleshooting.

Thanks for pointing me in the right direction!

Dawn

On Thu, Mar 25, 2010 at 3:21 PM, Dawn Hoagland wrote:

> I absolutely agree with all of you.  We'll get it locked up tight - once we
> get it working.  I don't have direct access to the server so I'm working
> with several people resolving the issue.
>
> I'll post back once we get it fixed with the resolution (it may help
> someone else having the same issue).
>
> Thanks again!
>
> Dawn
>
>
> On Thu, Mar 25, 2010 at 2:18 PM, Douglas Knudsen  > wrote:
>
>> couldn't agree more with Dean here, lock that thing up.
>>
>> http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html
>>  
>> <http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html>This
>> is a good ref on the topic.
>>
>> Also, I'd get Service Capture and verify that your SWF is indeed loading
>> the proper crossdomain.xml file as well as other traffic.
>>
>> Douglas Knudsen
>> douglasknud...@gmail.com
>>
>>
>>
>> On Mar 25, 2010, at 11:41 AM, Dean H. Saxe wrote:
>>
>> FYI, opening up the cross domain policy to all sites is
>> doubleplusungood.  (Sorry for the 1984 reference!)  Lock it down to
>> the specific sites which need cross domain access, no more.
>>
>> -dhs
>>
>> --
>> Dean H. Saxe
>> "A true conservationist is a person who knows that the world is not
>> given by his fathers, but borrowed from his children."  -- John James
>> Audubon
>>
>>
>>
>> On Thu, Mar 25, 2010 at 7:39 AM, Robert Lash  wrote:
>>
>> Have you tested this with one domain or a static domain address?
>>
>> You might want to try that first to isolate the issues.
>>
>>
>> I actually never got a crossdomain policy to work with the "*" all
>> settings
>>
>> but was successful with static domain names.
>>
>> Robert Lash
>>
>>
>>
>> On Wed, Mar 24, 2010 at 4:05 PM, Dawn Hoagland 
>>
>> wrote:
>>
>>
>> Background:
>>
>> We are running ColdFusion8 in a multi-server configuration under IIS.  We
>>
>> have an application where we are attempting to allow our customer access
>>
>> through a proxy server.  The domain of our internal server (for discussion
>>
>> sake) is dev.company1.org.  The domain they are coming from is
>>
>> test.company2.com.
>>
>>
>> We receive the following error:
>>
>> Channel.Security.Error error Error #2048: Security sandbox violation:
>>
>> https://test.company2.com/system/app/bin/index.swf cannot load data from
>>
>> https://dev.company1.org/flex2gateway/. url:
>>
>> 'https://dev.company1.org/flex2gateway/'
>>
>>
>> All of my searches point to needing to add a crossdomain.xml policy file.
>>
>> I've created one (see below) that should allow any connection and placed
>> it
>>
>> at the web root.
>>
>>
>> Am I missing something completely?
>>
>>
>> - begin crossdomain.xml -
>>
>> 
>>
>> >
>> "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd";>
>>
>> 
>>
>> 
>>
>> >
>> />
>>
>> 
>>
>>  end crossdomain.xml ---
>>
>>
>> Thanks!
>>
>>
>> Dawn
>>
>>
>>
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by http://www.fusionlink.com
>> -
>>
>>
>>
>>
>>
>

Re: [ACFUG Discuss] Flex, Flash Security and crossdomain.xml

[Dawn Hoagland]

I absolutely agree with all of you.  We'll get it locked up tight - once we
get it working.  I don't have direct access to the server so I'm working
with several people resolving the issue.

I'll post back once we get it fixed with the resolution (it may help someone
else having the same issue).

Thanks again!

Dawn

On Thu, Mar 25, 2010 at 2:18 PM, Douglas Knudsen
wrote:

> couldn't agree more with Dean here, lock that thing up.
>
> http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html
>  <http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html>This
> is a good ref on the topic.
>
> Also, I'd get Service Capture and verify that your SWF is indeed loading
> the proper crossdomain.xml file as well as other traffic.
>
> Douglas Knudsen
> douglasknud...@gmail.com
>
>
>
> On Mar 25, 2010, at 11:41 AM, Dean H. Saxe wrote:
>
> FYI, opening up the cross domain policy to all sites is
> doubleplusungood.  (Sorry for the 1984 reference!)  Lock it down to
> the specific sites which need cross domain access, no more.
>
> -dhs
>
> --
> Dean H. Saxe
> "A true conservationist is a person who knows that the world is not
> given by his fathers, but borrowed from his children."  -- John James
> Audubon
>
>
>
> On Thu, Mar 25, 2010 at 7:39 AM, Robert Lash  wrote:
>
> Have you tested this with one domain or a static domain address?
>
> You might want to try that first to isolate the issues.
>
>
> I actually never got a crossdomain policy to work with the "*" all settings
>
> but was successful with static domain names.
>
> Robert Lash
>
>
>
> On Wed, Mar 24, 2010 at 4:05 PM, Dawn Hoagland 
>
> wrote:
>
>
> Background:
>
> We are running ColdFusion8 in a multi-server configuration under IIS.  We
>
> have an application where we are attempting to allow our customer access
>
> through a proxy server.  The domain of our internal server (for discussion
>
> sake) is dev.company1.org.  The domain they are coming from is
>
> test.company2.com.
>
>
> We receive the following error:
>
> Channel.Security.Error error Error #2048: Security sandbox violation:
>
> https://test.company2.com/system/app/bin/index.swf cannot load data from
>
> https://dev.company1.org/flex2gateway/. url:
>
> 'https://dev.company1.org/flex2gateway/'
>
>
> All of my searches point to needing to add a crossdomain.xml policy file.
>
> I've created one (see below) that should allow any connection and placed it
>
> at the web root.
>
>
> Am I missing something completely?
>
>
> - begin crossdomain.xml -
>
> 
>
> 
> "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd";>
>
> 
>
> 
>
> 
> />
>
> 
>
>  end crossdomain.xml ---
>
>
> Thanks!
>
>
> Dawn
>
>
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>
>
>

[ACFUG Discuss] Flex, Flash Security and crossdomain.xml

[Dawn Hoagland]

Background:
We are running ColdFusion8 in a multi-server configuration under IIS.  We
have an application where we are attempting to allow our customer access
through a proxy server.  The domain of our *internal* server (for discussion
sake) is *dev.company1.org*.  The domain they are coming from is *
test.company2.com*.

We receive the following error:
Channel.Security.Error error Error #2048: Security sandbox violation:
https://test.company2.com/system/app/bin/index.swf cannot load data from
https://dev.company1.org/flex2gateway/. url: '
https://dev.company1.org/flex2gateway/'

All of my searches point to needing to add a crossdomain.xml policy file.
I've created one (see below) that should allow any connection and placed it
at the web root.

Am I missing something completely?

- begin crossdomain.xml -

http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd";>




 end crossdomain.xml ---

Thanks!

Dawn

Re: [ACFUG Discuss] validating credit card numbers with CF

[Dawn Hoagland]

I looked through my old files during lunch - and somehow didn't manage to
keep my custom tag (yes, pre CFC days) with all of the validation.  That
said, Wikipedia has a pretty extensive list of possible card types with
their possible valid lengths, ranges and validation (anything you're likely
to accept uses the Luhn algorithm for validation).  I used a similar chart
when I built my original validation and we never had any issues with card
numbers that passed the validation (barring outright fraud, but we had other
checks and authorization in place trying to prevent that).  It should be
pretty simple to build your own if you wish.

http://en.wikipedia.org/wiki/Credit_card_number

Have fun!

Dawn

On Wed, Mar 10, 2010 at 12:38 PM, Charlie Arehart wrote:

>  And while the back-end validation is of course vital, if you want to do
> it on the front-end as well (in Javascript), note that it’s a built-in
> feature of CFINPUT, validate=”creditcard”.
>
> Yes, yes, I know that purists would never use CFFORM, and I know that you
> can’t rely on client-side validation for security because it can be
> circumvented and won’t work if JS is disabled on the browser, yadda, yadda.
> That’s why I note that this would be subsidiary to server-side validation.
> Still, it’s a lot more user-friendly to catch it on the front-end first, if
> you can.
>
> All that said, I suppose some will still have more to say. Shields up.
> Engage. :-)
>
>
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Shawn
> Gorrell
> *Sent:* Wednesday, March 10, 2010 12:26 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] validating credit card numbers with CF
>
>
>
> Pretty much.
>
> Sent from my iPhone
>
>
> On Mar 10, 2010, at 11:22 AM, Dusty Hale  wrote:
>
>  Thanks shawn. Would that be as simple as doing this:
>
>  refind("^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$",trim(form.card_number),1)>
> 
> 
>
> On Wed, Mar 10, 2010 at 11:12 AM, shawn gorrell 
> wrote:
>
> ^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$
>
>
>  --
>
> *From:* Dusty Hale 
> *To:* discussion@acfug.org
> *Sent:* Wed, March 10, 2010 11:05:47 AM
> *Subject:* [ACFUG Discuss] validating credit card numbers with CF
>
>
> Does anyone have a CF code snippet for validating credit cards numbers?
>
> Dusty
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>
>
>
>
> --
> Dusty Hale
> Email: du...@dustyhale.com
> Phone (Atlanta): 404.474.3754
> Phone (Toll Free USA): 877.841.3370
> Website: www.DustyHale.com
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>

Re: [ACFUG Discuss] validating credit card numbers with CF

[Dawn Hoagland]

Don't forget the Mod10 check to validate for fat fingering the card #.

I've got some simple validation code around somewhere that checks based on
card type + mod10 check.  If I run across it, I'll post.

Dawn

On Wed, Mar 10, 2010 at 11:22 AM, Dusty Hale  wrote:

> Thanks shawn. Would that be as simple as doing this:
>
>  refind("^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$",trim(form.card_number),1)>
> 
> 
>
>
> On Wed, Mar 10, 2010 at 11:12 AM, shawn gorrell wrote:
>
>> ^((4\d{3})|(5[1-5]\d{2})|(6011))-?\d{4}-?\d{4}-?\d{4}|3[4,7]\d{13}$
>>
>> --
>> *From:* Dusty Hale 
>> *To:* discussion@acfug.org
>> *Sent:* Wed, March 10, 2010 11:05:47 AM
>> *Subject:* [ACFUG Discuss] validating credit card numbers with CF
>>
>> Does anyone have a CF code snippet for validating credit cards numbers?
>>
>> Dusty
>>
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>
>
>
>
> --
> Dusty Hale
> Email: du...@dustyhale.com
> Phone (Atlanta): 404.474.3754
> Phone (Toll Free USA): 877.841.3370
> Website: www.DustyHale.com
>

Re: [ACFUG Discuss] Sending large numbers of eMail via ColdFusion

[Dawn Hoagland]

I've successfully used a meta-refresh with a counter keeping track of which
batch of emails have been sent (via session or url parameter) for a quick
and dirty way to throttle mass emails.

Dawn

On Thu, May 21, 2009 at 5:24 PM, Troy Jones  wrote:

>  Clarke,
>
>
>
> We have a similar application that sends out mass mailings. In the past we
> have handled this using cfthread. In this simplified example, the code is
> using cfthread to set a 1 second interval between each email.
>
>
>
> 
>
> 
>
>  IsEmail(email_field)>
>
>  valid_email>
>
>
>
>
> 
>
>
>
>
> 
>
> 
>
>  duration="1000" />
>
> 
>
> 
>
>
>
> This seems to work pretty well although you may want to adjust the interval
> (remember, in milliseconds). It has two purposes. First, it takes the
> processing out of the way of the rest of your other processing. Secondly,
> and maybe just as important, it will help prevent your mail server from
> getting tagged as a spam source.
>
>
>
> Hope this helps.
>
>
>
> *Troy Jones*
>
> Developer/Support Technician
>
> Dynapp, Inc
>
> http://www.dynapp.com
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Clarke
> Bishop
> *Sent:* Thursday, May 21, 2009 4:59 PM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Sending large numbers of eMail via ColdFusion
>
>
>
> I’m trying to finish up a cfm/cfc page that will send out about 3,000 eMail
> messages. The messages are press releases and they go to a database of
> magazine editors, radio/TV stations, etc. Also, the messages have to be
> individually personalized.
>
>
>
> John told me: “Don't try to send 3000 all at once. You'll lock up your mail
> spool.  Do small 50-120 size batches every 10 minutes.”
>
>
>
> Plus, I got a timeout error when I tried to run the page.
>
>
>
> So, please point me in the right direction. Right now, I’m thinking:
>
> · Use cfschedule to call a page every 10 minutes. The page then
> sends 100 messages.
>
> · Keep track of which emails have been sent and which page of the
> query should get sent next.
>
> · Cancel the cfschedule after all the messages are done.
>
>
>
> Does anyone have a better suggestion for how to go about this?
>
>
>
> Thanks,
>
>
>
>Clarke
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.339 / Virus Database: 270.12.35/2124 - Release Date: 05/21/09
> 06:22:00
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>

Re: [ACFUG Discuss] Images as Checkboxes

[Dawn Hoagland]

Done it, and toggling with JS is how I did it.  I don't have the sourcecode
(did this quite a while ago), but I don't recall it being particularly
tricky.  I did have the luxury of dictating the browser

Dawn

On Fri, Mar 27, 2009 at 5:20 PM, Douglas Knudsen
wrote:

> look no further than GMail for a example :)   On a slow connection, you can
> actually see each check box loading.  Basically just toggle the src in JS,
> eh?
>
> Douglas Knudsen
> http://www.cubicleman.com
> this is my signature, like it?
>
>
>
> On Fri, Mar 27, 2009 at 2:38 PM, Cody Wehunt  wrote:
>
>>  I was thinking about something, and I am not sure if I have ever seen it
>> or not.
>>
>>
>>
>> Can anyone make recommendations on a control or a way to make images act
>> like check boxes?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Cody
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>
>
>

Re: [ACFUG Discuss] weird cfinput vs input stuff. date is shown as {d '2009-02-12'} vs 02/12/2009

[Dawn Hoagland]

And this is why I never use it unless the "user" has their knickers in a wad
to know about the error before they go to the next page.  Even then I
usually don't bother (especially if they are on an intranet) because the
server validation is so quick they don't realize that they've just *gasp*
submitted the form and received clear, concise error messages without the
developer writing reams of JavaScript code (which users can - and will
disable) since I have to check it on the server anyway.  If they ask, I just
tell them that clicking the submit button triggers the validation code.
Well - it does :)

Now Flex is a whole 'nother can of worms and many times I validate the
second the user changes the value or focus.

Dawn

On Thu, Feb 12, 2009 at 1:16 PM, Charlie Arehart wrote:

>  Thanks for all that, and fair enough. I missed the looping that was
> appending more to the field name, but the info may still help someone.
>
>
>
> And indeed what you've confirmed is what I would have said if you'd stopped
> at your first paragraph: the onserver validation is causing CF to create the
> hidden field (albeit in a new format, different from the old style _date
> kind—check out the HTML source generated to see it), and that new hidden
> field name is still clearly causing CF to continue to do the conversion to
> odbc dateformat.
>
>
>
> I'll grant it's as annoying now as the old approach was then,  but at least
> what you tried confirmed things.
>
>
>
> You could raise the concern to Adobe to say, "hey, it's cool and all that
> your server-side validation (old or new approach) can validate dates, but
> why convert it also to odbc date format?"
>
>
>
> /charlie
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Ajas
> Mohammed
> *Sent:* Thursday, February 12, 2009 12:22 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] weird cfinput vs input stuff. date is shown
> as {d '2009-02-12'} vs 02/12/2009
>
>
>
> Hi Charlie,
>
>
> Thanks for pointing out _date validation. That would make sense. But if you
> notice, from the code, I use a loop and I am *appending* the index number
> variable #thisrow# to the end of the cfinput absence_date#this_row#. So
> technically, CF should not have done the _date validation as you
> mentioned Ajas, what you're being tripped up by is the fact that
> you're using a suffix of  _date for your input field.
> My take is that, this is not the case.
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -

Re: [ACFUG Discuss] weird cfinput vs input stuff. date is shown as {d '2009-02-12'} vs 02/12/2009

[Dawn Hoagland]

As a matter of habit, I do not use the cfinput tags for validation however
the few times I've reviewed or modified code from other developers who
validate dates this way, this is the behavior I have seen.

In general, when I'm checking the date on the submit, I format it
anyway.

On Thu, Feb 12, 2009 at 10:22 AM, Ajas Mohammed  wrote:

> Thanks,
>
> Yes, but the big question is why cffrom cfinput would send date in that
> format. Its not the first time I have i used cfinput. Date usually comes
> across in standard date format.
>
> Anyone???
>
> 
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
>
> On Thu, Feb 12, 2009 at 10:15 AM, Dawn Hoagland wrote:
>
>> Do a dateformat(formfield,'mm/dd/') before using the data from the
>> form.
>>
>>
>> On Thu, Feb 12, 2009 at 9:41 AM, Ajas Mohammed wrote:
>>
>>> Hi,
>>>
>>> I noticed this in my form submission and dont know why cfinput with
>>> validation would show date as *{d '2009-02-12'} *whereas regular input
>>> would show same value as* 02/12/2009* . See code below :
>>>
>>> 
>>>
>>> >> validate="date" validateat="onBlur,onSubmit,onServer" message="You have
>>> entered an invalid date. Date's should be in this format MM/DD/ or
>>> MM-DD-.">
>>>
>>> >> value="">
>>>
>>> 
>>>
>>> so in this form, i entered 02/12/2009 in both the textboxes and i get
>>> weird output.
>>>
>>> Any ideas??? I am I missing something obvious here???
>>>
>>>
>>> 
>>> http://ajashadi.blogspot.com
>>> We cannot become what we need to be, remaining what we are.
>>> No matter what, find a way. Because thats what winners do.
>>> You can't improve what you don't measure.
>>> Quality is never an accident; it is always the result of high intention,
>>> sincere effort, intelligent direction and skillful execution; it represents
>>> the wise choice of many alternatives.
>>>
>>
>>
>

Re: [ACFUG Discuss] weird cfinput vs input stuff. date is shown as {d '2009-02-12'} vs 02/12/2009

[Dawn Hoagland]

Do a dateformat(formfield,'mm/dd/') before using the data from the form.

On Thu, Feb 12, 2009 at 9:41 AM, Ajas Mohammed  wrote:

> Hi,
>
> I noticed this in my form submission and dont know why cfinput with
> validation would show date as *{d '2009-02-12'} *whereas regular input
> would show same value as* 02/12/2009* . See code below :
>
> 
>
>  validate="date" validateat="onBlur,onSubmit,onServer" message="You have
> entered an invalid date. Date's should be in this format MM/DD/ or
> MM-DD-.">
>
> 
>
> 
>
> so in this form, i entered 02/12/2009 in both the textboxes and i get weird
> output.
>
> Any ideas??? I am I missing something obvious here???
>
>
> 
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>

Re: [ACFUG Discuss] Another CFMAIL Problem

[Dawn Hoagland]

IF you can send a link to the server AND he always needs the latest version
(and assuming it doesn't take long to generate the PDF) - I would send a
link to a page that generates it on the fly every time and allow him to
download that version when needed - as previously mentioned by Howard.  This
eliminates any issues to do with email latency (or the possibility of
caching) and gives the opportunity to close some security holes created by
leaving content in an unsecured location.

Dawn

On Sun, Nov 9, 2008 at 8:26 PM, Peyton Todd <[EMAIL PROTECTED]>wrote:

> Doug, your guess that the email gets sent before the new PDF gets built
> rings true to me. It would explain the problem on my client's server, as
> well as the fact that it's not happening to me right now testing the system
> working on my own PC as localhost. It jogs my memory that my coworker
> experienced a similar problem back about 2001, when I was programming
> ColdFusion in New York City. (?New York City!?? Get a rope!)
>
> Dean, doesn't it make sense to you that the e-mail could get sent before
> the second version of the file gets built, so it merely picks up what it
> finds on the disk , namely, the earlier version of the file? Actually, come
> to think of it, that would not be an instance of caching.
>
> Ajas, I don't know, but it seems to me that saving the PDF into a SQL
> Server column might have the same problem as that described by Doug: if
> these operations can be performed asynchronously, then wouldn't it be
> possible that cfmail could grab the old value from the SQL Server column
> (presumably via its 'query=' parameter?) before my SQL Server update
> statement stuffs the new value into it?
>
> Howard, No, I didn't mean the office manager might get mixed up on which
> file is which - he's reasonably computer literate, and knows perfectly well
> that the one on top was sent later (Whoops! It just occurred to me that that
> might not always be true if there's a glitch in the e-mail process...).
> Anyway, though, what I did mean is that it's simply the older version of the
> file that gets attached to the e-mail. Your idea of sending a link seems
> like a good one, and I may try that but ...
>
> >>> Naming the PDF by the Job Number instead of by the reporter's ID is
> necessary of regardless of whether I attach the file or send a link. In
> either case, I'd be writing the file to disk. If I were to delete any old
> copy beforehand, what are the chances that (if this asynchrous story is
> true) cfmail would fail to find the file when it looks for it and throw an
> error?
>
> Peyton
>
> -Original Message-
> From: Howard Fore
> Sent: Nov 8, 2008 8:12 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] Another CFMAIL Problem
>
> I think what he means is that if a recorder creates a file and sends it,
> then corrects it and sends again, the recipient could open the first one and
> think it is the most current version when it isn't. It wasn't identified as
> an issue by Peyton but I could see how it could cause someone an issue. My
> response to that would be to not mail the PDF as an attachment but rather
> email a link to the user. The link would either lead to a real PDF, stored
> on disk, or to a CFM file that generates the PDF when it is requested. That
> would get rid of any caching issue as the file requested is always the
> latest version.
> On Sat, Nov 8, 2008 at 6:19 PM, Dean H. Saxe <[EMAIL PROTECTED]>wrote:
>
>> What "things" get asynchronous?  If what you say is true, email would
>> regularly go out without complete attachments. I think you're way off on
>> this one.
>>
>  --
> Howard Fore, [EMAIL PROTECTED]
> "The universe tends toward maximum irony. Don't push it." - Jeff Atwood
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?falogin.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] cflocation with variables encrypted, is it safe approach?

[Dawn Hoagland]

Are you using IIS/Kerberos authentication where it's all handled on the
server and pulling who it is from there - or is your SSO handled through a
separate "application" where (for instance) an encrypted cookie is set so
applications across several servers can utilize the cookie for
authentication - or something else entirely?

Depending on the SSO implementation, you may be doing more than you need to
make it work.

Dawn

On Tue, Jul 29, 2008 at 3:28 PM, Ajas Mohammed <[EMAIL PROTECTED]> wrote:

> Hi,
>
> I am implementing single sign on and after I verify user credentials, I
> have to redirect user to secure area which has its own login verification
> through uname pwd textbox, the usual way.
>
> The idea with single sign on is to avoid that login verification page. So,
> while redirecting user to secure area, I am planning to pass 2 parameters in
> cflocation i.e. 1. to indicate its single sign on, so in Application.cfm for
> secure area folder, I can set client variables 2. the encrypted value of
> random key generated using GenerateSecretKey func.
>
> here is some code/logic
>
> 
>
> 
> 
>
> 
> 
>
>  url="../secureArea/MyHome.cfm?redirectToSS=#redirectToSS#&vartest=#encKey#"
> >
>
> Now in secureArea/Application.cfm
>
> I will use redirectToSS and varTest. First decrypt varTest to get keyvalue
> and then use key value to see whats in redirectToSS.
> So,
> 
>  set client variables that are needed to access application.
> 
>
>
> Does this makes sense? Is this approach safe, security wise, considering no
> one knows what algorithm, encoding iam using to encrypt redirectToSS and
> also the fact that the key is sent over encrypted.
>
> I am I missing something important here? Any holes in this approach?
>
> Thanks,
>
> --
> 
> http://ajashadi.blogspot.com
> We cannot become what we need to be, remaining what we are.
> No matter what, find a way. Because thats what winners do.
> You can't improve what you don't measure.
> Quality is never an accident; it is always the result of high intention,
> sincere effort, intelligent direction and skillful execution; it represents
> the wise choice of many alternatives.
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] ISO 3166-1 alpha-3 country codes

[Dawn Hoagland]

They're all listed on wiki - http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3


Shouldn't take more than a 1/2 hour to copy and paste into excel and
generate an insert statement to put them into whatever database you need

Dawn

On Thu, Jul 10, 2008 at 5:48 PM, Troy Jones <[EMAIL PROTECTED]> wrote:

>  Does anyone know where I might find a pre-populated MySQL v5.x compatible
> database or table with this information? Preferably legally free, of course
> J.
>
>
>
> Troy Jones
>
> *Dynapp Support Team*
>
> 678-528-2952
>
>
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] CFMAIL issue

[Dawn Hoagland]

In addition - firewall settings may need to be checked...

Dawn

On Mon, Jun 23, 2008 at 2:13 PM, Troy Jones <[EMAIL PROTECTED]> wrote:

> Also, make sure your production server has permission to relay off the mail
> server in question. An assumed thing, of course, but it is something I have
> encountered in the past.
>
> 
>
> From: [EMAIL PROTECTED] on behalf of Dusty Hale
> Sent: Mon 6/23/2008 2:08 PM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] CFMAIL issue
>
>
> you might need to add the "username" and "password" attributes to your
> cfmail tag. Most email servers require authentication and if not they
> should. Otherwise anyone could use the email server to send out spam and
> other junk.
>
> 
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
> Sent: 06/23/2008 2:01 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] CFMAIL issue
>
>
> Thanks for the quick responses.
>
> Here is the version information:
> Server Details
> Server Product
> ColdFusion MX
> Version
> 7,0,2,142559
> Edition
> Standard
> Serial Number
> CPD700-57133-17219-06784
> Operating System
> Windows 2003
> OS Version
> 5.2
> and this is the simple sample code I'm running
>
>from = "[EMAIL PROTECTED]"
>   subject = "test email"
>   failto="[EMAIL PROTECTED]"
>type="html"
>server="123.456.789.98"
>port="25">
>   THIS IS A TEST EMAIL.
>   
>
> The email works fine on the dev server but not on the production server.
>  There are 8 different reports that are all scheduled.  I have run the
> directly in the browser and there are no errors being thrown.  Nothing is
> being written to the logs, but I have not looked in those directories.  I'll
> request access and check them out.
>
> Thanks again.
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform <
> http://www.acfug.org/?fa=login.edituserform>
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform <
> http://www.acfug.org/?fa=login.edituserform>
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>
>
>
> -
>
> To unsubscribe from this list, manage your profile @
>
> http://www.acfug.org?fa=login.edituserform
>
>
>
> For more info, see http://www.acfug.org/mailinglists
>
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>
> List hosted by http://www.fusionlink.com
>
> -
>
>
>



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] CFMAIL issue

[Dawn Hoagland]

You didn't say what version of CF.  I know that earlier versions (at least
4.x - and perhaps 5) had issues if a message was malformed.  That one
message is all it takes.  No amount of rebooting/restarting fixes it.

Move/delete all undelivered mail and see if that fixes your issue.

Dawn

On Mon, Jun 23, 2008 at 1:09 PM, Jeff Howard <[EMAIL PROTECTED]> wrote:

> Can anyone tell me where to look if I'm having issues with mail not being
> sent.  I've gone through the Administrator and verified my mail server
> connection (Connection Verification Successful) but emails are not being
> sent.  I look in the log files and there are no log entries mail.log,
> mailsent.log for the test email I am trying to send.
>
> Are there settings that I'm missing somewhere?  I'm trying to fix and
> application that is supposed to be emailing reports daily.  The developer
> that was working on it was let go and the application quit sending the daily
> emails.  I've been tasked with correcting the issue and time is critical.
>
> Any ideas would be greatly appreciated.
>
> Thanks,
> Jeff
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-