CF11... Live?

[Mallory Woods]

So did anyone else notice that CF11 is live as of today?

http://www.adobe.com/products/coldfusion-family.html


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358455
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

[off topic] Average income by programming language.

[Mallory Woods]

I saw this and thought that the list might find it interesting. Be sure to
look up what is being reported for ColdFusion

Enjoy:

http://bpodgursky.wordpress.com/2013/08/21/average-income-per-programming-language/


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356535
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Hack Attempt?

[Mallory Woods]

Thanks for the heads up. I know some people that use plesk


On Tue, Jun 25, 2013 at 1:16 PM, John M Bliss  wrote:

>
> I don't have PHP installed so I guess I'm not vulnerable, right?
>
> Any idea how to have CF (or IIS) auto-kill requests like this?
>
>
> On Tue, Jun 25, 2013 at 1:09 PM, Cameron Childress  >wrote:
>
> >
> > On Tue, Jun 25, 2013 at 12:56 PM, John Bliss wrote:
> >
> > > - what that req is supposed to do?
> > > - how to be sure to block it?
> > >
> >
> > First result via Google for that string:
> >
> > Plesk 0-day Remote Vulnerability in the Wild
> >
> >
> http://blog.sucuri.net/2013/06/plesk-0-day-remote-vulnerability-in-the-wild.html
> >
> > -Cameron
> >
> > ...
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

dhtmlxGrid creating JavaScript

[Mallory Woods]

Hi,

I'm not sure if anyone here has used dhtmlxGrid for an excel type display
before.
http://www.dhtmlx.com/docs/products/dhtmlxGrid/index.shtml

Overall, it works pretty good and I have been able to get a nice display
with sorting etc and using my database and CF to create the data for the
table.

My first example was just creating JSON on the fly to get it in a format
that's understood by the tool. That worked fine and it was easy with CF to
create what I needed.

However, I have the need to include an HTML clickable Link so that I can
edit a person's information. Of course they are uniquely identified by an
ID field but the problem comes in that I used JSON in the beginning to
create the data.

According to the docs, they give an XML example of how it parses the code.
I have not seen a JSON example and when I try to give it data that will
create the link it doesn't work.

http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/01_cell_types/04_link_grid.html#code

So if I wanted a link I have something like:

Blood and Smoke
 Stephen King^http://www.stephenking.com/the_author.html


I'm fine with switching my code over to XML instead of JSON but I wanted to
ask about creating it in a Javascript variable so that I can use CF to
create it.


What I have so far is this:


function SaveXML(UserData)
{
var file = fso.CreateTextFile(FILENAME, true);
file.WriteLine('\n');
file.WriteLine('\n');

{

file.Write(' ');
file.Write(' #strFullName#
#strPhaseName# #strEmplCat#
#strEmplCat# #strHRName#');
file.Write(' ');
  
}

file.WriteLine('\n');
file.Close();

} // end SaveXML function 


When I'm done I will parse the file variable and get it to display:
mygrid.parse(file);

That should cause the grid to show up on the page.

Sorry for such a long question, but I wanted to be sure that XML would be
the solution. I'm also up for any other suggested JS library that may do
this simpler. I don't have to stick to dhtmlx.

I am also creating my variable and parsing through it and not calling a CF
file or reading a file the way some examples look.

http://docs.dhtmlx.com/doku.php?id=dhtmlxgrid:data_loading


Thanks for any help!


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355517
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Fill in form with information from Select dropdown

[Mallory Woods]

Sorry if the title is a little confusing but I'll try to explain it clearly
here. Also, I'm using ColdBox for this project and I'll be posting it to
the ColdBox list so sorry in advance if you get it twice.

So the idea here is that I have a select box that will have more than one
value.

Think of it as a selection of States for the US.

When the user selects a state, a query should be run that will then fill in
the rest of the form.

The remainder of the form of the does have other select drop downs that
should have a specific dropdown selected from the query that was returned.

The rest of the form has most text boxes that can be filled by the values
that are returned from the query mentioned above.

I'm asking what is the best way of going about this? I'm also open to using
jquery or just regular JavaScript to get the job done.

Thanks


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355339
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Coldfusion and dhtmlxGrid

[Mallory Woods]

Thanks for the reply. I think I'm on the XML bus for now.


On Wed, Mar 20, 2013 at 1:14 PM, Gerald Guido wrote:

>
> Yes and no but mostly no. You will need to feed the grid the data and the
> way that most apps like this work is that you must feed it structured data
> in the form of XML or JSON. Technically you do not have the create a
> physical file and can pass it a "document" on the fly via . But
> if you are asking: Can you feed it a raw record set from CFQuery with out
> an intermediary format the answer is no. It needs to be in a format
> that dhtmlxGrid will understand. In this case XML.
>
>
> HTH
> G!
>
>
> On Tue, Mar 19, 2013 at 4:09 PM, Mallory Woods  >wrote:
>
> >
> > Hi all,
> >
> > I'm trying to use dhtmlxGrid in one of my projects and I had a question.
> >
> > What I would like to do is run a query or stored procedure, get the
> > resulting data set and then have the results formatted for use in
> > dhtmlxGrid. I don't need to write data back to the DB I am just need to
> > display them.
> >
> > I have gotten the demo to work with basic text and the xml file
> >
> > (http://docs.dhtmlx.com/doku.php?id=tuto ... populating)
> >
> > However, is there a way to take the query results and pass them directly
> to
> > dhtmlxGrid directly without having to write the data to a file and then
> > reading it?
> >
> > I have tried something like this:
> >
> > var mygrid;
> > function doInitGrid(){
> >
> > mygrid = new dhtmlXGridObject('mygrid_container');
> > mygrid.setImagePath("codebase/imgs/");
> > mygrid.setHeader("Model,Qty,Price");
> > mygrid.setInitWidths("*,150,150");
> > mygrid.setColAlign("left,right,right");
> > mygrid.setSkin("light");
> > mygrid.init();
> > mygrid.parse(#xmlString#);
> > xmlString is a valid XML object but the grid does not format like this.
> The
> > source comes out like this:
> >
> > var mygrid;
> > function doInitGrid(){
> >
> > mygrid = new dhtmlXGridObject('mygrid_container');
> > mygrid.setImagePath("codebase/imgs/");
> > mygrid.setHeader("Model,Qty,Price");
> > mygrid.setInitWidths("*,150,150");
> > mygrid.setColAlign("left,right,right");
> > mygrid.setSkin("light");
> > mygrid.init();
> > mygrid.parse(
> >  > id="292B71DD-0893-326D-79269A1DCFD46D37" lname="Archibald"/> > fname="Raymond" id="292B71DE-E781-43FE-A4DCD955A1A5C044"
> > lname="Jones"/>);
> >
> > }
> > Thanks in advance!
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355115
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Coldfusion and dhtmlxGrid

[Mallory Woods]

Hi all,

I'm trying to use dhtmlxGrid in one of my projects and I had a question.

What I would like to do is run a query or stored procedure, get the
resulting data set and then have the results formatted for use in
dhtmlxGrid. I don't need to write data back to the DB I am just need to
display them.

I have gotten the demo to work with basic text and the xml file

(http://docs.dhtmlx.com/doku.php?id=tuto ... populating)

However, is there a way to take the query results and pass them directly to
dhtmlxGrid directly without having to write the data to a file and then
reading it?

I have tried something like this:

var mygrid;
function doInitGrid(){

mygrid = new dhtmlXGridObject('mygrid_container');
mygrid.setImagePath("codebase/imgs/");
mygrid.setHeader("Model,Qty,Price");
mygrid.setInitWidths("*,150,150");
mygrid.setColAlign("left,right,right");
mygrid.setSkin("light");
mygrid.init();
mygrid.parse(#xmlString#);
xmlString is a valid XML object but the grid does not format like this. The
source comes out like this:

var mygrid;
function doInitGrid(){

mygrid = new dhtmlXGridObject('mygrid_container');
mygrid.setImagePath("codebase/imgs/");
mygrid.setHeader("Model,Qty,Price");
mygrid.setInitWidths("*,150,150");
mygrid.setColAlign("left,right,right");
mygrid.setSkin("light");
mygrid.init();
mygrid.parse(
);

}
Thanks in advance!


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355102
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: What is this code doing? Is it harmful?

[Mallory Woods]

http://stackoverflow.com/questions/13099802/cfml-strange-script-found-in-hosting-
Seems that someone has dealt with this a few months ago.


On Thu, Jan 3, 2013 at 2:22 PM, Mahcsig  wrote:

>
> It also has an option for cfexecute, and filesetlastmodified, so they could
> have covered some of their tracks that way.
>
> If CF is running as local system, they could have done some really bad
> things to the system...
>
> ~Mahcsig
>
>
> On Thu, Jan 3, 2013 at 11:05 AM, Dave Watts  wrote:
>
> >
> > > My company is running CF8 on IIS.  We have a website that doesn't get
> > much use inbetween biannual meetings.
> > > I just noticed the following code that was inserted into one of the
> > subfolder's index.cfm files.  I'm not seeing any
> > > other changes in any other file (yet) and the server doesn't appear to
> > have taken a hit, but I'm not even sure what
> > > this code is doing, how it got there, and whether it's harmful.
> >
> > Any code that can write to your server's filesystem is potentially
> > harmful. This code appears to do that, along with listing files on
> > your filesystem and allowing viewers to download them. Both of these
> > things are potentially harmful, unless you explicitly want to do that.
> >
> > > Next steps (other than yanking out the code, which I've already
> done)???
> >
> > Why is CF allowed to write to the web root? If you prevent CF from
> > writing files where it generally shouldn't, you can prevent a lot of
> > these types of vulnerabilities. Preventing this may involve changing
> > CF's login from SYSTEM to a non-privileged user in addition to setting
> > filesystem permissions.
> >
> > I would recommend that you read the excellent CF 9 Lockdown Guide,
> > which I think is still on the Adobe site. Then, do the things it says
> > to do.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > http://training.figleaf.com/
> >
> > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> > GSA Schedule, and provides the highest caliber vendor-authorized
> > instruction at our training centers, online, or onsite.
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353747
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF10 + Wamp ?

[Mallory Woods]

Hmm this seems to be a bug.

Thanks for the feedback.

On Wed, May 16, 2012 at 9:34 PM, Byron Mann  wrote:

>
> Installed to my workstation today, the cfide was left in c:/coldfusion10
> instead of the ./wwwroot.
>
> Install on a server this did not happen.
>
> Also selected cfdocs on the install but no where to be found.
>
> Byron Mann
> Lead Engineer and Architect
> Hostmysite.com
> On May 16, 2012 3:04 PM, "Mallory Woods"  wrote:
>
> >
> > I had a little time today and I wanted to throw the trial version of CF10
> > on a spare machine. However, I was trying to install
> wampserver2.2d-x32.exe
> > and then CF10 on top of it. I noticed that CF did not copy over the CFIDE
> > etc directories to the default wamp directory (c:\wamp\www). I finally
> had
> > to run it off of the default web server included with CF. Has anyone else
> > also experienced this?
> >
> > Server info: Windows xp (It's what I have available)
> > WAMP: wampserver2.2d-x32.exe
> > Apache Ver 2.2.21
> > CF 10 32bit version
> >
> > Thanks,
> >
> > Mallory Woods
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351236
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF10 + Wamp ?

[Mallory Woods]

Thanks. I will check.

On Wed, May 16, 2012 at 3:27 PM, Gerald Guido wrote:

>
> Apache uses an Apache Tomcat Connector (mod_jk) to talk to CF10/Tomcat
>
> Look in the mod_jk.conf file in your apache conf directory. That will telll
> you where CFIDE is physically
>
> On my machine it is
> C:\ColdFusion10\cfusion\wwwroot
>
>
> On Wed, May 16, 2012 at 3:03 PM, Mallory Woods  >wrote:
>
> >
> > I had a little time today and I wanted to throw the trial version of CF10
> > on a spare machine. However, I was trying to install
> wampserver2.2d-x32.exe
> > and then CF10 on top of it. I noticed that CF did not copy over the CFIDE
> > etc directories to the default wamp directory (c:\wamp\www). I finally
> had
> > to run it off of the default web server included with CF. Has anyone else
> > also experienced this?
> >
> > Server info: Windows xp (It's what I have available)
> > WAMP: wampserver2.2d-x32.exe
> > Apache Ver 2.2.21
> > CF 10 32bit version
> >
> > Thanks,
> >
> > Mallory Woods
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351228
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF10 + Wamp ?

[Mallory Woods]

I had a little time today and I wanted to throw the trial version of CF10
on a spare machine. However, I was trying to install wampserver2.2d-x32.exe
and then CF10 on top of it. I noticed that CF did not copy over the CFIDE
etc directories to the default wamp directory (c:\wamp\www). I finally had
to run it off of the default web server included with CF. Has anyone else
also experienced this?

Server info: Windows xp (It's what I have available)
WAMP: wampserver2.2d-x32.exe
Apache Ver 2.2.21
CF 10 32bit version

Thanks,

Mallory Woods


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351221
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Jrun issue?

[Mallory Woods]

We had an interesting fail that happened yesterday.


We had a user send out a large amount of mail during the day which choked
off almost all of our bandwidth.
When this happened, it collapsed our VPN tunnel. This tunnel is how we make
our connection to our Oracle
Database.

With the DB down of course regular CF functionally was fine until code that
accesses the DB is executed.

What appeared to happen is the site tried to make a DB connection and
eventually timed out.
This process continued over and over again with each attempted connection
to the DB until Jrun crashed or became unresponsive.

When I saw the Jrun error message, my first thought was to restart CF and
Apache. This fixed the issue for the time until
another connection to the DB was attempted. At that point this whole
process restarted itself which lead to another crash.

Eventually, we discovered that the VPN tunnel was not operational and that
was what prevented the DB connections.

The question I have from my boss is *what can we do to prevent this*? I
think the answer is there is nothing we can do. My suggestion
from the experience yesterday is to ensure the tunnel is operational. I
don't think there is anything else that can be done.


Thanks in advance,

Mallory Woods


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Database fail over advice

[Mallory Woods]

Russ & Wil Thanks I will be looking at that slideshow.

On Fri, Aug 19, 2011 at 4:20 PM, Wil Genovese  wrote:

>
> Mallory,
>
> A while back one of the CFGURU's, Mike Brunt, did an excellent presentation
> at CF.Objective() 2009 called the Server of Doom.  What he covered in the
> preso was performance and redundancy.  His slide show is still on SlideSix
> http://slidesix.com/view/mbruntcfwhisperercfobjective09
>
> The last section covers the database performance and a simple but effective
> failover setup.  It involves user SQL Server express as a "witness server"
> to determine when failover is needed.
>
> Mike's blog is here
> http://www.cfwhisperer.com/post.cfm/cfobjective-powerepoint-on-coldfusion-and-database-performance
>
>
>
>
>
> Wil Genovese
> Sr. Web Application Developer/
> Systems Administrator
> CF Webtools
> www.cfwebtools.com
>
> wilg...@trunkful.com
> www.trunkful.com
>
> On Aug 19, 2011, at 3:10 PM, Mallory Woods wrote:
>
> >
> > Greetings,
> >
> > My boss has asked me to come up with a plan of action in case one of our
> > databases is off line or if we loose connectivity to it.
> > In this setup we have one DB in one location and another one at a
> different
> > ISP. I think he wants a solution in which if its possible that CF would
> be
> > able to make the
> > change if some sort of situation were to occur and we can't reach site A.
> >
> > One thing that I thought of would be to run a simple query and if it
> times
> > out or we get a DB error then we would switch to the alternate DB. I have
> > just started thinking about this scenario and since
> > I have never been tasked with this type of challenge before I thought I
> > would ask.
> >
> > Thanks,
> >
> > Mallory Woods
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Database fail over advice

[Mallory Woods]

Greetings,

My boss has asked me to come up with a plan of action in case one of our
databases is off line or if we loose connectivity to it.
In this setup we have one DB in one location and another one at a different
ISP. I think he wants a solution in which if its possible that CF would be
able to make the
change if some sort of situation were to occur and we can't reach site A.

One thing that I thought of would be to run a simple query and if it times
out or we get a DB error then we would switch to the alternate DB. I have
just started thinking about this scenario and since
I have never been tasked with this type of challenge before I thought I
would ask.

Thanks,

Mallory Woods


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346867
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfzip and Native Windows Zip Support

[Mallory Woods]

Just reporting back.

If you had character limit, you're a big winner. I found the problem and
fixed it. Thanks for all the help!

On Tue, Apr 12, 2011 at 2:20 AM, Jochem van Dieten wrote:

>
> IIRC the Windows native compressed file facility is not Unicode aware and
> has a 256 character path lenght limit.
>
> Jochem
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343673
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfzip and Native Windows Zip Support

[Mallory Woods]

I have accounted for that but I am double checking just to be sure!

Thanks for the suggestions.

On Mon, Apr 11, 2011 at 2:35 PM, Leigh  wrote:

>
> Also, have you ruled out the usual suspects like bad file names, invalid
> characters, etcetera?
>
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343663
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfzip and Native Windows Zip Support

[Mallory Woods]

Thanks.. I will try that and see if its the issue.

On Mon, Apr 11, 2011 at 2:31 PM, Leigh  wrote:

>
> It may not be your issue, but I have a vague recollection of problems with
> XP. IIRC my issue seemed related to the directory structure of the zip file.
> The "corrupted files" all contained an top level folder that appeared
> unnamed. (The rest of contents were inside that folder). Once I fixed the
> code to eliminate that unnamed folder, the issue went away.
>
> ie
>
> /(unnamed folder)
> /fileA.doc
> /folderB
> /folderB/fileC.xls
>
>
>
> -Leigh
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343661
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfzip and Native Windows Zip Support

[Mallory Woods]

Just some of them. Seems that it is random. It doesn't matter if its a big
or small file. The folder structure in the zip file is, some folders and
some files in the root. At the most the folders go two levels deep.

On Mon, Apr 11, 2011 at 1:22 PM, Leigh  wrote:

>
> > According to that ulitlty, the archive is corrupted.
>
> All zip files or only some of them? Also, what does the folder structure
> inside the .zip look like?
>
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343658
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

cfzip and Native Windows Zip Support

[Mallory Woods]

Greetings,

I wanted to ask, has anyone had problems opening zip files created with
cfzip with the (Compressed zip folders) utility that comes with windows?
According to that ulitlty, the archive is corrupted. However, I was able to
open it with WinRAR and 7-zip without any problems.


Odd

Thanks in Advance,


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343653
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Delete all records works, but can't import data

[Mallory Woods]

Just to confirm, its working now! :)

Its amazing what a fresh set of eyes will do.

On Wed, Mar 2, 2011 at 3:36 PM, Mallory Woods wrote:

> Thanks Carl that was a big DUH on that part for me. I will check it out.
>
> Thanks for the help!
>
> On Wed, Mar 2, 2011 at 3:30 PM, Carl Von Stetten 
> wrote:
>
>>
>> First, you need to move the Truncate query outside the loop.  Otherwise
>> it is being called on each loop iteration, and erasing any records you
>> inserted on the previous iteration.
>>
>> Second, close your table with a  tag after the 
>>
>> Third, you have a comment about blank rows being invalid, but you have
>> no tests to trap for this.  I'd suggest adding something like this
>> before the insert transaction:
>>
>> 
>>
>> Then add a  after the transaction to close the  tag.
>>
>> HTH,
>> Carl
>>
>> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342702
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Delete all records works, but can't import data

[Mallory Woods]

Thanks Carl that was a big DUH on that part for me. I will check it out.

Thanks for the help!

On Wed, Mar 2, 2011 at 3:30 PM, Carl Von Stetten wrote:

>
> First, you need to move the Truncate query outside the loop.  Otherwise
> it is being called on each loop iteration, and erasing any records you
> inserted on the previous iteration.
>
> Second, close your table with a  tag after the 
>
> Third, you have a comment about blank rows being invalid, but you have
> no tests to trap for this.  I'd suggest adding something like this
> before the insert transaction:
>
> 
>
> Then add a  after the transaction to close the  tag.
>
> HTH,
> Carl
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342701
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Delete all records works, but can't import data

[Mallory Woods]

Carl,

I tried that but it caused another error:

Here is more code:

This code comes directly from Ben Nadel so all street cred goes to him! :)

Here is the blog that I got most of the code from:

http://www.bennadel.com/projects/poi-utility.htm

I modified the code to handle more columns and of course used my own excel
file. I got lazy and just renamed my excel file to the one
that Ben used in his example. It should be simple to create an excel
spredsheet and and then run this code and import it into mysql.

This is where the difficulty begins. I need to clear the whole Database
every time I need to do a re-import of the excel sheet. I think I can do
this in two steps but it would be nice to do it all in one step.

Thanks!


Begin Code
-



















#objSheet.Name#






#objSheet.ColumnNames[ 1 ]#


#objSheet.ColumnNames[ 2 ]#


#objSheet.ColumnNames[ 3 ]#


#objSheet.ColumnNames[ 4 ]#


#objSheet.ColumnNames[ 5 ]#


#objSheet.ColumnNames[ 6 ]#


#objSheet.ColumnNames[ 7 ]#


#objSheet.ColumnNames[ 8 ]#


#objSheet.ColumnNames[ 9 ]#


#objSheet.ColumnNames[ 10 ]#


#objSheet.ColumnNames[ 11 ]#














insert into tablename
(
status, owner, site_name, street, city, st, zip, lat, longitude,
agl, height
)
VALUES
(
'#objSheet.Query.column1#', '#objSheet.Query.column2#',
'#objSheet.Query.column3#', '#objSheet.Query.column4#',
'#objSheet.Query.column5#', '#objSheet.Query.column6#',
'#objSheet.Query.column7#', '#objSheet.Query.column8#',
'#objSheet.Query.column9#', '#objSheet.Query.column10#',
'#objSheet.Query.column11#'
)




End Code
--

On Wed, Mar 2, 2011 at 2:31 PM, Carl Von Stetten wrote:

>
> I don't have any experience with MySQL, but I've heard that there's a
> way to enable multiple statements in a single .  Once thats
> enabled, look at the MySQL docs for the syntax for putting multiple SQL
> statements together.  In SQL Server (which I use frequently), you would
> do something like this:
>
> 
> delete from mytable
> go
> insert into mytable
> ..
> go
> 
>
> or
>
> 
> delete from mytable;
> insert into mytable..;  **Note the trailing semicolon
> 
>
> You may be able to do something similar in MySQL.  By putting both
> statements into a single , you are allowing the DBMS to queue
> up processing.  Each statement shouldn't execute until the previous one
> completes.
>
> As to the blank row left behind, where are you seeing this?  In a
>  dump or are you looking at the table through a MySQL
> management tool?
>
> Carl
>
> On 3/2/2011 11:20 AM, Mallory Woods wrote:
> > Carl its MySQL
> >
> > On Wed, Mar 2, 2011 at 2:00 PM, Carl Von Stetten >wrote:
> >
> >> What DBMS are you using?  SQL Server, MySQL, Oracle, or MS Access?
> >> Carl
> >>
> >> On 3/2/2011 10:43 AM, Mallory Woods wrote:
> >>> Carl,
> >>>
> >>> I will try that. I had the truncate  in a cftrans.. let me try them
> both
> >> and
> >>> see what I get.
> >>>
> >>> Nope.. still the same result. I have tried having both of them in one
> >>> cftrans and also having them in their own cftrans block.
> >>>
> >>> The odd thing is.. When the truncate works, It removes all of the data
> >> but
> >>> leaves one blank record. Like blanks on all lines.
> >>>
> >>> Very odd.
> >>>
> >>> Thanks for the suggestion but that didn't do it. :(
> >>>
> >>>
> >>>
> >>> On Wed, Mar 2, 2011 at 1:30 PM, Carl Von Stetten<
> vonner.li...@vonner.net
> >>> wrote:
> >>>
> >>>> I wouldn't expect that the delete or truncate would still be running,
> >>>> but if they are, wrapping all of the   tags in
> a
> >>>> might help, or wrapping the delete/truncate in a transaction, then
> >>>> calling the insert in a separate?
> >>>>
> >>>> HTH,
> &

Re: Delete all records works, but can't import data

[Mallory Woods]

The import is not being done via SQL. It's reading an excel file then doing
a SQL insert.


On Wed, Mar 2, 2011 at 2:06 PM, <> wrote:

>
>  >>However, the next set of lines which is supposed to import the data runs
> but
> no data is imported.
>
> You say "import", so I suppose you INSERT records from another SELECT.
> I also suppose that you have checked if this SELECT actually returns
> records?
>
> Also, do you have an auto-increment field in this table you're trying to
> import into?
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342695
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Delete all records works, but can't import data

[Mallory Woods]

Carl its MySQL

On Wed, Mar 2, 2011 at 2:00 PM, Carl Von Stetten wrote:

>
> What DBMS are you using?  SQL Server, MySQL, Oracle, or MS Access?
> Carl
>
> On 3/2/2011 10:43 AM, Mallory Woods wrote:
> > Carl,
> >
> > I will try that. I had the truncate  in a cftrans.. let me try them both
> and
> > see what I get.
> >
> > Nope.. still the same result. I have tried having both of them in one
> > cftrans and also having them in their own cftrans block.
> >
> > The odd thing is.. When the truncate works, It removes all of the data
> but
> > leaves one blank record. Like blanks on all lines.
> >
> > Very odd.
> >
> > Thanks for the suggestion but that didn't do it. :(
> >
> >
> >
> > On Wed, Mar 2, 2011 at 1:30 PM, Carl Von Stetten >wrote:
> >
> >> I wouldn't expect that the delete or truncate would still be running,
> >> but if they are, wrapping all of the  tags in a
> >> might help, or wrapping the delete/truncate in a transaction, then
> >> calling the insert in a separate?
> >>
> >> HTH,
> >> Carl
> >>
> >> On 3/2/2011 9:57 AM, Mallory Woods wrote:
> >>> I am trying to clear all of the data from a table before importing new
> >> data.
> >>> Example code:
> >>>
> >>> *
> >>>   
> >>>   TRUNCATE TABLE tablename
> >>>   
> >>>
> >>>--->
> >>> 
> >>>
> >>> 
> >>> insert into tablename
> >>> ..
> >>> *
> >>>
> >>> I have tried to truncate and delete the data. This appears to work
> fine.
> >>> However, the next set of lines which is supposed to import the data
> runs
> >> but
> >>> no data is imported.
> >>> Could the delete or truncate function still be running when the import
> is
> >>> taking place? If so, what is the best suggested method to get both of
> >> these
> >>> functions to run after
> >>> each other?
> >>>
> >>> Thanks in advance.
> >>>
> >>> Mallory Woods
> >>>
> >>>
> >>>
> >>
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342694
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Delete all records works, but can't import data

[Mallory Woods]

Carl,

I will try that. I had the truncate  in a cftrans.. let me try them both and
see what I get.

Nope.. still the same result. I have tried having both of them in one
cftrans and also having them in their own cftrans block.

The odd thing is.. When the truncate works, It removes all of the data but
leaves one blank record. Like blanks on all lines.

Very odd.

Thanks for the suggestion but that didn't do it. :(



On Wed, Mar 2, 2011 at 1:30 PM, Carl Von Stetten wrote:

>
> I wouldn't expect that the delete or truncate would still be running,
> but if they are, wrapping all of the  tags in a 
> might help, or wrapping the delete/truncate in a transaction, then
> calling the insert in a separate ?
>
> HTH,
> Carl
>
> On 3/2/2011 9:57 AM, Mallory Woods wrote:
> > I am trying to clear all of the data from a table before importing new
> data.
> >
> > Example code:
> >
> > *
> >  
> >  TRUNCATE TABLE tablename
> >  
> >
> >   --->
> > 
> >
> > 
> > insert into tablename
> >..
> > *
> >
> > I have tried to truncate and delete the data. This appears to work fine.
> > However, the next set of lines which is supposed to import the data runs
> but
> > no data is imported.
> > Could the delete or truncate function still be running when the import is
> > taking place? If so, what is the best suggested method to get both of
> these
> > functions to run after
> > each other?
> >
> > Thanks in advance.
> >
> > Mallory Woods
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342691
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Delete all records works, but can't import data

[Mallory Woods]

I am trying to clear all of the data from a table before importing new data.

Example code:

*

TRUNCATE TABLE tablename


 --->



insert into tablename
  ..
*

I have tried to truncate and delete the data. This appears to work fine.
However, the next set of lines which is supposed to import the data runs but
no data is imported.
Could the delete or truncate function still be running when the import is
taking place? If so, what is the best suggested method to get both of these
functions to run after
each other?

Thanks in advance.

Mallory Woods


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342687
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Git, CF and best practices

[Mallory Woods]

Thank you all for the information. I will be reading a lot and trying to
make the best decision!

On Tue, Aug 31, 2010 at 12:24 AM, Kym Kovan wrote:

>
> On 31/08/2010 11:16, Mallory Woods wrote:
> >
> > I just started looking a git to use for source control for our CF
> projects.
> > I wanted to ask those who are using it a few questions.
>
> git is a distributed version control system so having a central
> repository is fine for later, completed versions but it might be worth
> considering having a local repo for each developer so that they can save
> and version control internally and then when they are happy with their
> current work snippet push that back to a common/shared repo. That way
> you get some independence otherwise you are not doing much more than
> what svn does.
>
> Also you might consider looking at mercurial rather than git as it has a
> better fit with Windows machines.
>
> For example here we use Mercurial and every developer has a local set of
> repos on their workstation which they work with and when they have
> finished code synchronise from that back to a central repo where they
> can share their work with others. We actually have several central repos
> for test/stage levels of goodness of code rather than branching, the two
> are almost synonymous in distributed version control systems and
> synchronising between repos is simplicity itself (in Mercurial at least).
>
> If you want to get really fancy and you have developers on the move or
> with more than one workstation, desktop and notebook for example, then
> you can have another repo on a central server for that developer to sync
> up to from one workstation so that they can then pull that update down
> onto their other workstation. They can then keep code current on two
> machines without having half-good code in the main repos for other
> people to trip over.
>
>
> --
>
> Yours,
>
> Kym Kovan
> mbcomms.net.au
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Git, CF and best practices

[Mallory Woods]

Hello all,

I just started looking a git to use for source control for our CF projects.
I wanted to ask those who are using it a few questions.

First a few facts:

Our servers are running Linux (dev, staging, production) but we are writing
our code on Windows boxes.
We are using CF builder and I have the git plugin installed.

I wanted to ask about setting up the git repository on the server to be in
our web server directory?
For example: the web directory is http://www.thissite.com  and the local
directory is : /var/www/html/projectname
Would it be best to put the repo there in the project directory and create
two branches for the two developers and merge them when we want to release
the code?

I would also like to ask, if anyone has any good suggestions on a tool or
tools to push a specific version of the code to the server(s).
>From what I can see I would do an export then manually unarchive the files
to the proper directory

Thanks in advance.

Mallory


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336657
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Adding 2 images with cfpdf

[Mallory Woods]

Hello all,

I have run into a situation in which I need to add two different images to a
PDF. Adding the first image as a watermark works without issue.
When I try to add the 2nd image, it removes the first watermark. I
understand why this is happening but I wanted to see if anyone else came up
with a created solution to add two separate images.

Thanks,

Mal


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335614
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Odd MySQL error...

[Mallory Woods]

Thanks for the suggestions. I will follow up on both tomorrow in the office.
I will see if there are any other networking issues when this happens.

Thanks again and if there are any other suggestions, please keep them
coming.

On Wed, Jun 23, 2010 at 4:01 PM, Matthew Small wrote:

>
> It sounds like a networking error more than an app error.  You might try
> running Wireshark with a limited-size looping buffer to try to capture a
> trace of the problem.
>
> Also, do you have any other network issues during the time of the issue?
>
>
> > We have been dealing with a MySQL error for a little while and can't
> > seem to
> > figure out what is causing it.
> > This error appears on our production server:
> >
> > Red Hat Linux Enterprise 64 bit
> > MySQL 5.0.77
> > CF 9
> >
> > This error happens any time, day or night and sometimes in multiple
> > occurrences and from different pages. I am guessing that normal site
> > operations continues after the user gets this error and refreshes
> > their
> > browser as we don't hear any complaints from users about it. The
> > error
> > appears in our logs and we would love to get rid of it.
> >
> > The main error is:
> > *
> > **Error Executing Database Query. Communications link failure Last
> > packet
> > sent to the server was 0 ms ago. The error occurred on line 6. *
> >
> > Stack Trace:
> >
> > Message
> >
> > Can not read response from server. Expected to read 4 bytes, read 0
> > bytes
> > before connection was unexpectedly lost.
> >
> > StackTrace
> >
> > java.io.EOFException: Can not read response from server. Expected to
> > read 4
> > bytes, read 0 bytes before connection was unexpectedly lost. at
> > com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455) at
> > com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) at
> > com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) at
> > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at
> > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at
> > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at
> > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at
> > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.
> > java:1761)
> > at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.
> > java:1021) at
> > coldfusion.server.j2ee.sql.JRunPreparedStatement.
> > execute(JRunPreparedStatement.java:91)
> > at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at
> > coldfusion.sql.Executive.executeQuery(Executive.java:1008) at
> > coldfusion.sql.Executive.executeQuery(Executive.java:939) at
> > coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at
> > coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at
> > coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at
> > cfaction2epage2edefault2ecfm19563856._factor4(/var/www/html/action.
> > page.default.cfm:6)
> > at
> > cfaction2epage2edefault2ecfm19563856.runPage(/var/www/html/action.page.
> > default.cfm:1)
> > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
> > coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
> > coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at
> > cfindex2ecfm500695976.runPage(/var/www/html/index.cfm:56) at
> > coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
> > coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
> > coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at
> > coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)
> > at
> > coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.
> > java:48)
> > at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
> > at
> > coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at
> > coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at
> > coldfusion.filter.ClientScopePersistenceFilter.
> > invoke(ClientScopePersistenceFilter.java:28)
> > at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at
> > coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at
> > coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at
> > coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
> > at
> > coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at
> > coldfusion.CfmServlet.service(CfmServlet.java:200) at
> > coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.
> > java:89) at
> > jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at
> > coldfusion.monitor.event.MonitoringServletFilter.
> > doFilter(MonitoringServletFilter.java:42)
> > at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.
> > java:46) at
> > jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at
> > jrun.servlet.FilterChain.service(FilterChain.java:101) at
> > jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at
> > jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
> > jrun.servlet.JRunRequestDi

Odd MySQL error...

[Mallory Woods]

We have been dealing with a MySQL error for a little while and can't seem to
figure out what is causing it.
This error appears on our production server:

Red Hat Linux Enterprise 64 bit
MySQL 5.0.77
CF 9

This error happens any time, day or night and sometimes in multiple
occurrences and from different pages. I am guessing that normal site
operations continues after the user gets this error and refreshes their
browser as we don't hear any complaints from users about it. The error
appears in our logs and we would love to get rid of it.

The main error is:
*
**Error Executing Database Query. Communications link failure Last packet
sent to the server was 0 ms ago. The error occurred on line 6. *

Stack Trace:

Message

Can not read response from server. Expected to read 4 bytes, read 0 bytes
before connection was unexpectedly lost.

StackTrace

java.io.EOFException: Can not read response from server. Expected to read 4
bytes, read 0 bytes before connection was unexpectedly lost. at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455) at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021) at
coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91)
at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at
coldfusion.sql.Executive.executeQuery(Executive.java:1008) at
coldfusion.sql.Executive.executeQuery(Executive.java:939) at
coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at
coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at
cfaction2epage2edefault2ecfm19563856._factor4(/var/www/html/action.page.default.cfm:6)
at
cfaction2epage2edefault2ecfm19563856.runPage(/var/www/html/action.page.default.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at
cfindex2ecfm500695976.runPage(/var/www/html/index.cfm:56) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at
coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at
coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at
coldfusion.CfmServlet.service(CfmServlet.java:200) at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at
jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at
jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at
jrun.servlet.FilterChain.service(FilterChain.java:101) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

When going to the page that thew this error, I can't force the error.

Suggestions? Anyone?

Thanks,

Mal


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334775
Subscription

File Upload with CFKeditor in CF8

[Mallory Woods]

Hello all,

I have been trying to get file uploading working with cftextarea , CF 8.01
on a UNIX host.
I am able to see the entire FCKEditor toolbar and I have made the tweaks to
get the file upload option as described here:

http://www.rakshith.net/blog/?p=58

However, when I try to upload an image, I get this error:  Variable
SENDERROR is undefined

Thanks in Advance.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329582
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFBuilder not stopping at breakpoints.

[Mallory Woods]

Hello all,

I have been wrestling with CFBuilder and trying to get debugging setup.

A few facts:

Setup locally using WAMP (Apache) CF8 on a windows laptop.

CF is working fine along with everything else.
I have CFBuilder setup with a project and when I set a break point and try
to debug the code it doesn't stop at the break point.

I do have debugging set on the server and I have restarted it.

Can anyone point me in the right direction please?

Thanks!


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Dave, A Quick Question

[Mallory Woods]

Hey Dave,

I wanted to ask you a quick question since you have been in the CF world for
so long. I am trying to get some real world information on CF jobs in a
secure environment.
Currently, I have a Secret clearance and I'm working in a job that uses
that. However, hopefully in a few months I will have a Top Secret with SCI
and a full scope with poly.

I'm not sure if you have worked jobs that require this and I know its going
to be and even rarer bird to have a CF developer with that. The reason I
ask, is I was contacted by the potential project manger and she would like
to ask me for a salary range for that position and with that clearance.

I didn't want to submit this to the list as obviously my name would be
attached and googled right next to it. But, if you have any experience or
any suggestions where I can go to
find some facts and figures I appreciate it.

Oh, and I've been working with CF for about 10 years. I'm currently ina  Sr.
Level position now and this job will also be for a Sr. Cold Fusion Developer
and a perm position.

Thanks Dave!

Mallory


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321056
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Server Application Error - This should not happen, its Friday!

[Mallory Woods]

Thanks for all the replies.. I will try this one while I'm waiting on the
decision on to frag or not to frag.

Thanks again!

On Fri, Mar 27, 2009 at 1:37 PM, Gerald Guido wrote:

>
> A super quick way to get up and running with *AMP is XAMPP.
>
> http://www.apachefriends.org/en/xampp.html
>
> You unzip it. Run a bat file and then configure Apache with the Web Server
> Configuration Tool. Takes about five min from clicking the download link to
> up and running.
>
> G!
>
>
> On Fri, Mar 27, 2009 at 12:55 PM, Mallory Woods  >wrote:
>
> >
> > Matt,
> >
> > I'm getting close to the decision to frag it as I did try apache and I
> got
> > the same weird type of things. CF did not run out of the box and all sort
> > of
> > weird things happened.
> >
> > I'm trying to save this install as I don't want to reinstall everything
> > again but the more I go on I think this version of XP is just hosed as
> far
> > as what I want to do.
> >
> > BTW it was Apache 2.2 if I remember right I did not try 1.3
> >
> > On Fri, Mar 27, 2009 at 12:46 PM, Matthew Williams <
> > mai...@geodesicgrafx.com
> > > wrote:
> >
> > >
> > > Is there any chance you can ditch XP?  They stuck a bastardized version
> > > of IIS on that OS, and I could never get it to run quite right locally
> > > either.  You could always put Apache on there, and it'll run quite
> > > happily.
> > >
> > >
> > > Matthew Williams
> > > Geodesic GraFX
> > >
> > >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321055
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Server Application Error - This should not happen, its Friday!

[Mallory Woods]

Matt,

I'm getting close to the decision to frag it as I did try apache and I got
the same weird type of things. CF did not run out of the box and all sort of
weird things happened.

I'm trying to save this install as I don't want to reinstall everything
again but the more I go on I think this version of XP is just hosed as far
as what I want to do.

BTW it was Apache 2.2 if I remember right I did not try 1.3

On Fri, Mar 27, 2009 at 12:46 PM, Matthew Williams  wrote:

>
> Is there any chance you can ditch XP?  They stuck a bastardized version
> of IIS on that OS, and I could never get it to run quite right locally
> either.  You could always put Apache on there, and it'll run quite
> happily.
>
>
> Matthew Williams
> Geodesic GraFX
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321051
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Server Application Error - This should not happen, its Friday!

[Mallory Woods]

Hey Brad,

Nope, nothing in the logs. I just looked and there is nothing that stands
out in there.

I have restarted, and rebooted for the fun of it and have not seen anything
different.



On Fri, Mar 27, 2009 at 11:47 AM,  wrote:

>
> Have you checked your CF logs to see if they are showing any errors.  If
> I had to guess, it might be a problem with your web server connectors.
> Does IIS show .cfm, .cfml., .cfc files associated with the jrun dll?
> Determining if CF is actually receiving the requests might be a good
> place to start.
>
> Also, just for funsies, restart the ColdFusion and IIS services.  I was
> just fiddling around with file extension mappings yesterday and ended up
> restarting everything twice before it magically started working.
>
> ~Brad
>
>  Original Message 
> Subject: Server Application Error - This should not happen, its Friday!
> From: Mallory Woods 
> Date: Fri, March 27, 2009 9:27 am
> To: cf-talk
> 
> http://email.secureserver.net/pcompose.php?aEmlPart=0&type=replyall&folder=INBOX&uid=34770#
>
>
> Help.
>
> Ok here's the setup:
>
> Machine: Intel Core 2 Duo E8400
> Memory: 4G
> OS: Win XP SP2
> ColdFusion 7
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321048
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Server Application Error - This should not happen, its Friday!

[Mallory Woods]

Help.

Ok here's the setup:

Machine: Intel Core 2 Duo E8400
Memory: 4G
OS: Win XP SP2
ColdFusion 7


I inherited this box and needed to turn it into a development machine. No
problem, go head and get IIS installed on it and install CF and I'm off
right?
Wrong, I have had a number of problems when just trying to get IIS up and
running. Long story short, I have finally got IIS where its serving pages
without the 401.1 error and I installed CF7. Well, the install went ok
however, when trying to access CF pages I get the dreaded Server Application
Error.

Logs:
*
14:23:39 127.0.0.1 GET /test.cfm 500
14:23:39 127.0.0.1 GET /test.cfm 500
14:23:39 127.0.0.1 GET /test.cfm 500
14:23:39 127.0.0.1 GET /test.cfm 500
14:23:39 127.0.0.1 GET /test.cfm 500
14:23:39 127.0.0.1 GET /test.cfm 500*

I'm at a loss as to explain why this is not working. The install went ok
with one Error.

>From the install log:

ANT Script Error:
  Status: ERROR
  Additional Notes: ERROR - configure-dlls.xmlFailed
to copy C:\CFusionMX7\lib\cfperfmon_mx.dll to
C:\WINDOWS\system32\cfperfmon_mx.dll due to
C:\WINDOWS\system32\cfperfmon_mx.dll (The process cannot access the file
because it is being used by another process)


I'm at the point where I think this machine is FUBAR'ed however, I'm trying
to get it going before wiping it.

Anyone have any suggestions that I can try to get CF up and running?
I can provide other details if needed.

Thanks,

Mallory


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321039
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Best Open Source Message Board?

[Mallory Woods]

--- Error Text ---
 Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'cf4em_bannedips'.

The error occurred in C:\websites\cf4em\cfcs\cf4em.cfc: line 61
Called from C:\websites\cf4em\cf4em.cfm: line 21
Called from C:\websites\cf4em\cf4em.cfm: line 1
Called from C:\websites\cf4em\index.cfm: line 11
Called from C:\websites\cf4em\cfcs\cf4em.cfc: line 61
Called from C:\websites\cf4em\cf4em.cfm: line 21
Called from C:\websites\cf4em\cf4em.cfm: line 1
Called from C:\websites\cf4em\index.cfm: line 11

59 : or
60 : (
61 : #ipnumber# between startipnumber and endipnumber
62 : and
63 : endipnumber > 0
-- End Error Text --

This is right out of the box.. no modification on the code.

The table is there as created by the script

Thanks


On Wed, Oct 29, 2008 at 11:22 AM, Will Tomlinson <[EMAIL PROTECTED]>wrote:

> >I am working on getting cf4em setup but its throwing lots of errors for
> some
> >reason.
>
> What errors are you getting?
>
> Will
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314553
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Best Open Source Message Board?

[Mallory Woods]

Thanks for the replys

First it has to be a CF based board.
Open source is good just in case we need to tweak it.

Features: Image uploading, link posting, a good simple admin, subscription
to posts etc.

I am working on getting cf4em setup but its throwing lots of errors for some
reason.

On Wed, Oct 29, 2008 at 10:30 AM, Peter Boughton <[EMAIL PROTECTED]>wrote:

> > What is the best open source message board?
>
> Beehive Forum is best, but that's in PHP rather than CFML.
>
>
>
> > It will be installed on a system that is using CF7.
>
> Go here: http://www.riaforge.org/index.cfm?event=page.search
> Type "forum" and you will get several options...
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314545
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Best Open Source Message Board?

[Mallory Woods]

Hello All,

I have a quick project to do and there is no time for re-inventing the
wheel. What is the best open source message board? It will be installed on a
system that is using CF7.

Thanks in Advance!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314534
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Processing variables from a Flash form?

[Mallory Woods]

Best.. simplest etc..

Would it help if I send some of the flash source?



On Mon, Oct 6, 2008 at 4:08 PM, Alan Rother <[EMAIL PROTECTED]> wrote:

> "Best" is a highly subjective term...
> Are you actually looking for the technically best way to accomplish it, or
> just what will be the least painful way?
>
>
> Best would be to setup remoting and send the data over an AMF channel
> This has a steep learning curve...
>
> Easiest would be for your Flash developer to design the form to simply POST
> like any other form, and then you just build him the same kind of action
> page that a good ole HTML based form would use.
>
>
> =]
>
>
> --
> Alan Rother
> Adobe Certified Advanced ColdFusion MX 7 Developer
> Manager, Phoenix Cold Fusion User Group, AZCFUG.org
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313488
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Processing variables from a Flash form?

[Mallory Woods]

Greetings all,

I am working with a flash developer who doesn't know that much about
ColdFusion and I don't know that much about Flash. We have a form setup and
I need to putt the submitted data from it and save it to a file and dump it
in the the DB. However. I have never done this before.

What is the best way to process a Flash form?

Thanks!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313484
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Form Challenge?

[Mallory Woods]

Whoops. Sorry I mistyped. I *DO* (thank you for no starbucks this AM) know
the name of the check boxes and they are generated from a DB. So yes, I will
have the names.

Adrian Lynch Your post just came in the gmail as I was typing this.. I will
try that approach.

Thanks all


On Wed, Oct 1, 2008 at 11:49 AM, Randy <[EMAIL PROTECTED]> wrote:

> Kind of hard to check for a form value if you are unsure the name of the
> element.
>
> Pure Curosity: Why would you not know the name of the field? Is it pulled
> from a database when the form page is created?
>
>
>
> On Wed, Oct 1, 2008 at 11:41 AM, Mallory Woods <[EMAIL PROTECTED]
> >wrote:
>
> > What is the best way of coding this: I have a form that currently has 4
> > check boxes.
> > When processing this form I need to check for the existence of any of the
> > check boxes.
> >
> > Now, there are 4 values now but there could be more in the future.
> >
> > I tried to loop over the form variable with "isdefined" by I ran into
> > problems as I won't always know the
> > name of the check box to check.
> >
> > Any suggestions on how to approach this problem?
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313340
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Form Challenge?

[Mallory Woods]

What is the best way of coding this: I have a form that currently has 4
check boxes.
When processing this form I need to check for the existence of any of the
check boxes.

Now, there are 4 values now but there could be more in the future.

I tried to loop over the form variable with "isdefined" by I ran into
problems as I won't always know the
name of the check box to check.

Any suggestions on how to approach this problem?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:31
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Paypal Examples

[Mallory Woods]

Hello all,

I wanted to ask a quick question about paypal transactions.

I was looking at the payapl tutorial at easycfm.com (
http://tutorial23.easycfm.com/) but I have run into a problem.  There
doesn't seem to be a form field variable passed back when the transaction is
sent from paypal.


* *










What I would like to do is this: I have a client that setup to accept
donations. Donations can be made at a certain dollar value or it can be
setup like a subscription over a period of months.
Once the donation is made, and the user is sent to the "donation successful
page I would like to be able to pull information from the donation (ie: user
name, amount etc) this way I could generate a receipt and store  that
information in the database.  Is there a simple way to do this?

Thanks in advance!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306302
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Calling a php on CF

[Mallory Woods]

I have an interesting question I wanted to pose to the group. I just noticed
that my service provider has a number of php applications from plesk that I
can use for my clients. While most
of these I would never use some might come in handy. I have noticed that
these are written in php. Most of them are utilities and would be easy to
crank out and give to a client instead of taking the more expensive route of
me coding a CF page.

The problem is of course, thats its in PHP and not in CF. Since this would
be a simple thing like for example using http://bbclone.de.

which is a "web counter on steroids". What would be the easiest way to use
this withing a CF page?

I have thought of using an invisible iframe just to have this page called
and counted.

I don't know.. but if anyone has any suggestions.

Thanks!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296539
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF Bug Tracker

[Mallory Woods]

Wow! Lots of people like Lighthouse. I will look into that and install it
today. Any others?

On Jan 11, 2008 11:49 AM, Crow T. Robot <[EMAIL PROTECTED]> wrote:

> http://lighthousepro.riaforge.org/
>
> Lighthouse, awesome bug tracker, simple to use/install.  We use it
> extensively here.
>
> On Jan 11, 2008 10:40 AM, Mallory Woods <[EMAIL PROTECTED]> wrote:
>
> > Happy Friday all,
> >
> > Does anyone know of an open source or retail CF Bug Tracking system.  We
> > are
> > looking for somethng to track bugs for a few sites and also take jobs.
> > Ideally it would be something the user could look and view the status of
> > the
> > bugs and the progress on them.
> >
> > TIA,
> >
> > Mallory
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296432
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF Bug Tracker

[Mallory Woods]

Happy Friday all,

Does anyone know of an open source or retail CF Bug Tracking system.  We are
looking for somethng to track bugs for a few sites and also take jobs.
Ideally it would be something the user could look and view the status of the
bugs and the progress on them.

TIA,

Mallory


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296426
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfimport problem?

[Mallory Woods]

Matt,

I was going to reply that I knew everything was fine with the case when I
took a closer look. That was it. The files had caps in them and instead of
going through the code changing everything I just changed the case on the
files and that did the trick.

Thanks!! :)

On Dec 29, 2007 4:29 PM, Matt Quackenbush <[EMAIL PROTECTED]> wrote:

> More than likely you're dealing with a cAsE sEnSiTiViTy issue.  Make sure
> that the path and file name (including extension) are in the correct case.
>
> HTH
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfimport problem?

[Mallory Woods]

Hi,

I have been playing with the cf_googlemap tag (
http://www.blayter.com/john/cf_googlemap/) on a windows system. I had no
problems there. When I moved it to a linux system (using cf8) I got this
problem:

 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

The tag you are trying to use cannot be found within any tag libraries you
have imported.
   Unknown tag: gm:googlemap.ColdFusion cannot determine how to process
the tag gm:googlemap because the tag is unknown and not in any imported tag
libraries. The tag name might be misspelled.
Now I know where the error is:

Its in the first line of code:  I am
trying to run example1.cfm from the site (
http://www.blayter.com/john/cf_googlemap/example1.cfm)

I have never used the cfimport tag before. I have tried giving the web path
to the tag to get it to work ex:  but this didn't work either.

I can post the code too if need be.

Thanks in advance!

Mallory


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295530
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF or Javascript Suggestion

[Mallory Woods]

Hello all,

I have a small project to do and I wanted to bounce an idea off of the
community.

The idea is this: I'm going to write some code that will allow a user to
populate a dynamic menu drop down. Now, the code for the menu is already
written.
What I am doing is creating the tool for the user to:

1) Add an item to the menu Ex: Meaning if the main heading was say News,
they could add under News item1, item2 etc
2) The user can edit the spelling and link of the item
3) The user can also change the order of the items. Ex: If this user wants
item3 to go in the item1 slot they would change the order by clicking a
button that would move the item in the list.

What would be ideal, would be maybe a JavaScript menu where the user could
control the order of the items and when they wanted to edit the items they
would just click an edit button and edit the
information they needed. When they are done, the menu order is saved to the
database.

If anyone has an example, suggestion or can point me in the right direction
that would be great!


Thanks all!


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289627
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Calendar module

[Mallory Woods]

http://www.drisgill.com/index.cfm/2006/7/17/Simple-ColdFusion-Calendar

This should do what you need

On 9/26/07, Andy Matthews <[EMAIL PROTECTED]> wrote:
>
> I'm looking for some CF code that will generate a calendar for a specific
> month. All I'd like to do is to be able to pass in the month/year and have
> it build a correct display (accounting for leap year and things like
> that).
> I don't want it to have javascript or anything like that...I just want a
> calendar, devoid of any interaction, etc.
>
> Does anyone know of anything like this?
>
> 
>
> Andy Matthews
> Senior ColdFusion Developer
>
> Office:  877.707.5467 x747
> Direct:  615.627.9747
> Fax:  615.467.6249
> [EMAIL PROTECTED]
> www.dealerskins.com 
>
>
>
> 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289528
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Homesite CFML7

[Mallory Woods]

Does anyone have a link to update Homesite+ for CFML7 not 8?
Thanks!


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287925
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Epoch Time in CF off???

[Mallory Woods]

Rick,

I think thats it. I will mention it and see if we can get upgraded to the
latest version.

Thanks for your help

On 8/30/07, Rick Root <[EMAIL PROTECTED]> wrote:
>
> On 8/30/07, Mallory Woods <[EMAIL PROTECTED]> wrote:
> >
> > I'm using CF ver: 7,0,0,91690
> > I don't know what version of JVM is intstalled I don't have admin access
> to
> > the box.
>
> 
>
> That'll help you figure out what JVM you're using.
>
> Probably the old one since whomever is your hosting provider hasn't
> updated to 7.0.2 yet.  The default version of Java installed with 7.0
> and 7.0.1 does NOT account for recent daylight savings time changes.
>
> > When I run your example code I get the same results for both lines of
> code.
> >
> > I have noticed that the are still off from the Javascript code thats
> running
> > the same formula.
>
> By how much?
>
> I suspect that part of the difference might have to do with time zones.
>
> Rick
>
> --
> Rick Root
> Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
> www.opensourcecf.com
>
> 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287537
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Epoch Time in CF off???

[Mallory Woods]

Paul,

I think this is the result that I am looking for. I just have one question.

When running this code I get the number that I am expecting and it works
fine for 'now()'
If I needed to submit my own date how would I do that?

For example:

If I wanted to see how many ms from 5/11/200 00:00:00?

Thanks again!!

Mallory Woods

On 8/30/07, Paul Hastings <[EMAIL PROTECTED]> wrote:
>
> Mallory Woods wrote:
> > I have question about CF and Epoch time.
>
> who's epoch? java (ms since 1-jan-1970)? unix (seconds since 1-jan-1970)?
> cf
> (decimal days since 31-dec-1899)?
>
> if you don't mind a little undocumented functionality to get the java
> epoch:
>
> 
> now=now();
> javaEpoch=now.getTime();
> writeoutput("#now# ::: #javaEpoch#");
> 
>
> if you need unix epoch, divide javaEpoch by 1000. if you want cf epoch:
>
> 
> now=now();
> writeoutput("#now# ::: #decimalFormat(now)#");
> 
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287453
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Epoch Time in CF off???

[Mallory Woods]

Thanks for the help, now for some answers.

Rick:

I'm using CF ver: 7,0,0,91690
I don't know what version of JVM is intstalled I don't have admin access to
the box.

When I run your example code I get the same results for both lines of code.

I have noticed that the are still off from the Javascript code thats running
the same formula.

On 8/29/07, Rick Root <[EMAIL PROTECTED]> wrote:
>
> What version of coldfusion are you running?  If CF7 or below, what
> version of the JVM are you using?
>
> Run the following code and see what the output is:
>
> 
> #int((foo.getTime())/1000)#
> #DateDiff("s", "January 1 1970 00:00", foo)#
> 
> var foo = Date.parse('#dateFormat(foo,' d, ')#
> #timeFormat(foo,'HH:mm:ss')#');
> document.writeln(foo/1000);
> 
>
> On my machine (CF8 on Windows), they produce the same results.
>
> Rick
>
> 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287452
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Epoch Time in CF off???

[Mallory Woods]

Hello,

I have question about CF and Epoch time.

I have some Javascript that will convert a date to Epoch time. I have set
out to re-write this with ColdFusion. I have just about everything converted
but I'm getting different results. I have also noticed that when us JS to
get Epoch time on a specific date its different that what I get when when I
do the same in ColdFusion.

Example:

pastdate = new Date(2002, 5, 11,0,0,0)

Javascript - Date.parse(pastdate) gives me this result '102376800'

Now when I run it using CF and a UDF (listed at the end of this post) I get
something totally different.

ColdFusion GetEphochTime gives me this result '1021071600'

Any ideas?

I will include the Javascript that I am using to generate this result and
the CF code.

Thanks in advance!

 code below ---

Javascript where I getting the results

--- begin JS Code --


var mycars = new Array()
var pastdate
var pastyear = 2002
var pastmonth = 5
var pastday = 11
var nowdate = new Date()



pastdate = new Date(pastyear,pastmonth,pastday,0,0,0)
mycars[0] = Date.parse(new Date())
mycars[1] = Date.parse(pastdate)




for (i=0;i")
}


--- End JS Code ---
I am also running that on this page so I can see the results:
http://www.w3schools.com/js/tryit.asp?filename=tryjs_array

Just paste that code in the left window.

--- begin CF Code ---


/**
 * Returns the number of seconds since January 1, 1970, 00:00:00
 *
 * @param DateTime  Date/time object you want converted to Epoch time.
 * @return Returns a numeric value.
 * @author Chris Mellon ([EMAIL PROTECTED])
 * @version 1, February 21, 2002
 */
function GetEpochTime() {
var datetime = 0;
if (ArrayLen(Arguments) is 0) {
datetime = Now();

}
else {
if (IsDate(Arguments[1])) {
datetime = Arguments[1];
} else {
return NULL;
}
}
return DateDiff("s", "January 1 1970 00:00", datetime);


}
























moonday = resultdays / mooncycle = #moonday#


moonday = (resultdays / mooncycle) - Fix(resultdays / mooncycle) =
#moonday#



moonday = #moonday#
GetEpochTime(pastdate) = #GetEpochTime(pastdate)#
GetEpochTime(Now()) = #GetEpochTime(Now())#
resultdays = #resultdays#


 End CF Code ---

Please note: The comments are the original Javascript that I used to convert
it into CF.


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287402
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

HELP! Searching for a Custom Tag

[Mallory Woods]

Greetings All,

I am looking for the custom tag called CFX_ParseHTML it appears that
when we upgraded our server this tag
Was not copied over.. I have been searching all over for it and every
place I look no longer has the tag.. Does anyone have a working link or
perhaps the file itself.. 

Thanks in Advance..

Mallory Woods






This email and any files transmitted with it are confidential and are intended solely 
for the use of the individual or entity to which they are addressed.  If you are not 
the intended recipient or the person responsible for delivering the email to the 
intended recipient, be advised that you have received this email and any such files in 
error and that any use, dissemination, forwarding, printing or copying of this email 
and/or any such files is strictly prohibited.  If you have received this email in 
error please immediately notify [EMAIL PROTECTED] and destroy the original message 
and any such files.
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

A Verity SQL Combo Question - Can this be sped up?

[Mallory Woods]

Greetings all..


We have an interesting verity search/SQL search issue and I was
wondering if anyone has any hints on how this possibly could be sped
up..

Ok.. some background..

The Keyword search is done in verity and its fast by itself..

The other searches are fast and are regular SQL.. when they are both
combined they take a long time..

Here's what happens..

The Verity search returns the Keys which are equal to the ID field in
the SQL DB..  if the keyword field is not blank then it add the keys in
to the main query example query..

--
SELECT EPSTable.posting_date, agency_, office_, classcod_, subject_,
solnbr_, epsid,
(select top 1 par_id from par where
rfpnumber=replace(epstable.solnbr_,'-','') and (rfpnumber is not null or
rfpnumber<>'' or rfpnumber<>'N/A')) parid
FROM  EPSTable
WHERE
(1 = 1) 
AND EPSTable.epsid IN
(13913,11967,15428,15407,15057,15036,18538,14881,19636,18330,9411,16568,
7593,19812,19391,17230,16774,10795,13469,6393,11616,11293,18112,16529,15
461,15090,13871,11925,10778,9032,17558,16233,13893,13310,13069,11947,107
79,9771,8907,7441,2676,16772,12398,10547,7974,5239,4158,20497,20400,2039
9,20051,19996,19804,19640,19610,19299,18582,18300,18299,18291,18258,1812
3,18075,17862,17738,17111,17026,17014,16993,16982,16846)

AND CLASSCOD_ = '10'
ORDER BY POSTING_DATE
--

As you can see it returns a whole lot of Keys which are included in the
query.. this slows the whole query down..  We have the DB indexed and
have tried other things to speed this up.. any suggestions on getting
this going faster?

Thanks in advance..

Mallory Woods
INPUT Inc








__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Regular expression Help

[Mallory Woods]

Greetings All,

I am in the process of developing a small headache with Regular
Expressions...

I have looked at all of the examples I could find on the archives of this
mailing list and other web
pages but I still just don't get it.. I think I will pickup the O'Reilly
book that I have seen at another job before
on regular expressions but for now I am asking the list for help..

What I am trying to do is parse through an HTML source page an look for a
specfic string.. for example..



I would like to grab everything from this string from " to GMT"

Thanks in Advance...

Mallory Woods



This email and any files transmitted with it are confidential and are intended solely 
for the use of the individual or entity to which they are addressed.  If you are not 
the intended recipient or the person responsible for delivering the email to the 
intended recipient, be advised that you have received this email and any such files in 
error and that any use, dissemination, forwarding, printing or copying of this email 
and/or any such files is strictly prohibited.  If you have received this email in 
error please immediately notify [EMAIL PROTECTED] and destroy the original message 
and any such files.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Cold Fusion -> Web site Monitor

[Mallory Woods]

Greetings all,

I have a rather interesting task that has been set in front of me. We would
like to setup a service on our web site for users to enter in a URL address
to monitor it for changes..

Now I know there are a few web services out there that do this for free but
I think that using them would possible do more harm than good.. and they
only way I could think of getting this to work is to setup forms on our end
that will submit the information to the web site.. and if they change our
forms then our site would break..

Does anyone know of a product that works with Cold Fusion that's for sale..
or.

Knowing the problems with CFHTTP would it be possible to write something
like this and even
store the values in a databse and make a comparrison on them..


Thanks for your time..

Mallory Woods


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists