CFMAIL isn't working at all

2010-07-05 Thread Sagar Gupta

Hello everyone,

 

I'm trying to send emails using the CFMAIL tag. I know how it is done and
have tried every possible way to figure out why it isn't working. Coldfusion
9 64-bit is running on a CentOS 5.4 x64 box with Apache 64-bit installed. It
is neither sending email through smtp.gmail.com (Google App account) nor
with localhost (sendmail server.)

 

I've tried following way so far:

 

1.   Tried to verify my mail server connections (both to Gmail and
sendmail) using the Coldfusion administrator, however, always get following
error: Connection Verification Failed! 

2.   Enabled mail log and have set the log level to Debug. Still don't
see any error in the mail.log file. It does keep updating with spool related
information but no error or details about connection to the mail server.

3.   I know correct port and SSL settings required to connect to the
Gmail smtp server.

4.   Coldfusion is running as user cfusion in developer mode.

5.   This is a new installation on a fresh CentOS box at a client's site
and I've tried reinstalling Coldfusion a couple of times already.

6.   Coldfusion is connected properly with Apache version 2.2_15.

7.   I tried sending email using sendmail using the command-line and it
went through.

8.   I also tried to send email using a PHP script and it works,
however, I can't rely on it as it deliver email very slow and I need to fix
my installation.

9.   If I enter localhost in SMTP field, uncheck SSL and check Verify
connection and hit the Submit button in the CF Administrator, it gives
Connection Verification Failed! Error instantly. However, with Gmail, when
the SSL and Verify connection is checked, and port is set to 465 it take a
while (about 20-40 seconds) to give the message Connection Verification
Failed! I'm passing correct login credentials each time. As I mentioned in
the point above it does work from command-line and PHP work with same mail
server settings and login credentials and same CentOS box/Apache
installation.

10.   IP, host name, trusted users, network config and Firewall all seems to
be setup quite properly.

 

Does anyone have any idea what could be wrong here? Where should I look in
my server to get more details? Again, neither sendmail nor Gmail works. I've
looked in server.log and mail.log. Not sure what's happening.

 

Best,

Sagar Gupta



~|
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:335090
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

I know what you mean about managing servers.  For several years
I ran my own web server with CF, mail server, FTP server, etc.
When VPS's started coming down in price, I decided just to outsource
that.  I was getting too busy building websites to bother
with all that.  Same with an SVN server.  The prices have just
been too inexpensive to bother doing it myself.

Springloops.com has reasonably priced services.  $32 would get
me everything I need and want.

And now I just got an email from ProjectLocker.com saying that
they offer "FTP on Commit" with their "Venture" level service and above.
That's only $12 a month with unlimited repo's and projects, up to 15 users,
trac (bug tracking, wiki, project management), "Unmetered" bandwidth
transfer
(I wonder if that means "unlimited"), and 10GB of storage.  Now that's a
good deal.

I've got a repo now on Springloops.com and that's working well.
I'll put one up on ProjectLocker.com, too, and see how it goes.

Thanks for the feedback.

Rick

-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: Monday, July 05, 2010 9:24 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


On Mon, Jul 5, 2010 at 9:13 PM, Rick Faircloth 
wrote:
> It is the number of projects/repos.
>
> I put each of my websites into a separate project/repo.

It could be worth considering consolidating them into one repo, or
fewer repos.  You'd lose alot of your history by doing so, but in the
long run you may have an easier time finding hosting.

Alternately, as Will said, you can set up your own server fairly
easily.  I did that for awhile but am recently of the mindset that I
hate managing servers and am moving all that stuff to services like
UnFuddle (which has great/simple ticket tracking too).

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com



~|
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:335089
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Trouble with international characters

2010-07-05 Thread Pete Ruckelshaus

That was it, thanks for the help!  I get so used to looking for the source
of the problem in my code, completely forgot to see if it was an admin
setting.

On Mon, Jul 5, 2010 at 2:03 PM, Paul Alkema wrote:

>
> Hi,
> What's your data type for the sql column that your trying to insert this
> data into? If your inserting Unicode characters into varchar column you
> should change the datatype to nvarchar.
>
> Also, when using unicode in ColdFusion with cfqueryparam's I would confirm
> that "String Format" is checked in your ColdFusion administrator. It should
> be noted however that if this is enabled for your main dsn that it could
> possibly cause performance issues.
>
> I have two datasources one called nMainDns and another called mainDns. The
> nMainDns is used to insert Unicode statements while using cfqueryparam's
> while the other is used for select statements or stored procedures.
>
> Paul Alkema
> http://paulalkema.com/
>
> On Mon, Jul 5, 2010 at 1:40 PM, Pete Ruckelshaus  >wrote:
>
> >
> > Oh, and here's the code for my SQL that's inserting the data:
> >
> > 
> >  INSERT INTO tblHLMapLocations(name, description, latitude, longitude,
> > locationIsApproximate, active)
> >  VALUES (,
> >   > value="#stripHTML(trim(workingset.description))#">,
> >  #trim(workingset.latitude)#,
> >  #trim(workingset.longitude)#,
> >   > value="#locationIsApproximate(workingset.description)#">,
> >  );
> > 
> >
> >
> >
> > 2010/7/5 Pete Ruckelshaus 
> >
> > > I am using CF to import data from an Excel spreadsheet to an MS SQL
> > Server
> > > 2005 database.  Salient points: Characters are showing properly in the
> > .XLSX
> > > file; text fields in the SQL server database are all nvarchar or ntext;
> I
> > am
> > > using  at the top of the
> > page
> > > that is processing this page; and, finally, I am using 
> to
> > > read the spreadsheet and put it into a query object.  Here's the data
> > > processing code:
> > >
> > >  > > filefield="uploadxls" nameconflict="MAKEUNIQUE">
> > >
> > >  > > src="#cffile.serverdirectory#\#cffile.serverfile#" sheetname="sheet1"
> > > query="getData">
> > >
> > > 
> > >   > >
> >
> queryNew("#getdata.col_1#,#getdata.col_2#,#getdata.col_3#,#getdata.col_4#","varchar,varchar,varchar,varchar")>
> > >  
> > >  
> > >  
> > >  
> > > 
> > > 
> > >  
> > >   > > stripOuterQuotes(getdata.col_1))>
> > >   > > stripOuterQuotes(getdata.col_2))>
> > >   > > stripOuterQuotes(getdata.col_3))>
> > >   > > stripOuterQuotes(getdata.col_4))>
> > > 
> > > 
> > > 
> > >  SELECT name, description, latitude, longitude
> > >  FROM workingset
> > >  ORDER BY name
> > > 
> > >
> > > Now, the problem that I am having is that SOME (and not all) of the
> > > international characters are not showing up properly.  For instance:
> > >
> > > These show up properly:
> > > Großraming SB, Flossenbürg, Mirošov Labor Camp, Munkács Ghetto, 
> > > Terezín
> > >
> > > These do NOT show up properly (correct versions in parentheses):
> > > Brn?nec (Brněnec)
> > > Auschwitz (Che?mek subcamp) - (Auschwitz (Chełmek subcamp))
> > > Che?mno Extermination Camp - (Chełmno Extermination Camp)
> > > Soldau (Dzia?dowo) Concentration Camp - (Soldau (Działdowo)
> Concentration
> > > Camp)
> > >
> > > In case you're curious, I teach high school English and am working on a
> > > Holocaust Location mapping project for my Holocaust Literature class.
> > >
> > > Does anyone have any ideas as to why some international characters are
> > > making it through just fine, but others are getting munched?  This is
> > really
> > > the first time I've worked with anything beyond the basic Latin
> character
> > > set.
> > >
> > > Thanks,
> > >
> > > Pete
> > >
> >
> >
> >
>
> 

~|
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:335088
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

Thanks for the tip, Andrew.

If I don't find a satisfactory solution, I'll go that route.

Rick

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Monday, July 05, 2010 9:50 PM
To: cf-talk
Subject: RE: Ok...Assembla's gone a little mad. Need new SVN host...


You also realise that you can have one repo with multiple projects, yes?

For example

/Trunk
/trunk/Project1
/trunk/Project1/trunk
/trunk/ Project2
/trunk/ Project2/trunk

Etc.


-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: Tuesday, 6 July 2010 11:14 AM
To: cf-talk
Subject: RE: Ok...Assembla's gone a little mad. Need new SVN host...


It is the number of projects/repos.

I put each of my websites into a separate project/repo.


-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: Monday, July 05, 2010 8:54 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


On Mon, Jul 5, 2010 at 8:20 PM, Rick Faircloth 
wrote:
> I did look at UnFuddle.com, but I would need their
> Enterprise account at $99 per month to handle my needs.

I'm curious what requirement makes the $99 plan your only option.
You'd said "I mostly use the repo's for backup", but it sounds like
you may be doing more than that.

Is it the number of projects/repos?  If you are willing to combine
your repos you can get away with far fewer repos.

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com







~|
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:335087
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Andrew Scott

You also realise that you can have one repo with multiple projects, yes?

For example

/Trunk
/trunk/Project1
/trunk/Project1/trunk
/trunk/ Project2
/trunk/ Project2/trunk

Etc.


-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: Tuesday, 6 July 2010 11:14 AM
To: cf-talk
Subject: RE: Ok...Assembla's gone a little mad. Need new SVN host...


It is the number of projects/repos.

I put each of my websites into a separate project/repo.


-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: Monday, July 05, 2010 8:54 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


On Mon, Jul 5, 2010 at 8:20 PM, Rick Faircloth 
wrote:
> I did look at UnFuddle.com, but I would need their
> Enterprise account at $99 per month to handle my needs.

I'm curious what requirement makes the $99 plan your only option.
You'd said "I mostly use the repo's for backup", but it sounds like
you may be doing more than that.

Is it the number of projects/repos?  If you are willing to combine
your repos you can get away with far fewer repos.

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com





~|
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:335086
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion and Alfresco

2010-07-05 Thread Matthew Gersting

Actually, we're using the FSR deployment service in combination with a 
middle-ware Java layer that does some fast XML parsing/processing.


> Yes, we're using the two together.
> 
> Did you use the webservice API or the web scripts?
> 
> --
> WSS4CF - WS-Security framework for CF
> http://wss4cf.riaforge.org/
> 
> 
> 
> On 6 July 2010 08:28, Matthew Gersting  wrote:
> >
> > I've been using Alfresco for a large-scale project for almost a year 
> now, and I was just curious if there were any other ColdFusion 
> developers out there who are also using it.  I'd be interested to 
> share experiences and techniques.  Also, I've built a CFC-based API 
> and corresponding document standard for it.  Figured I'd test the 
> waters and see if there was any use for it out in the broader 
communi

~|
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:335085
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

If I had to pay $50 or more per month, I probably would.
But at $32 per month, I'd rather someone else have that
work to do.

-Original Message-
From: Wil Genovese [mailto:jugg...@trunkful.com] 
Sent: Monday, July 05, 2010 9:17 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


Why not build your own repro server?  It's easy to do.

Wil Genovese
Sr. Web Application Developer/
Systems Administrator

Wil Genovese Consulting
wilg...@trunkful.com
www.trunkful.com



On Jul 5, 2010, at 8:13 PM, Rick Faircloth wrote:

> 
> It is the number of projects/repos.
> 
> I put each of my websites into a separate project/repo.
> 
> 
> -Original Message-
> From: Cameron Childress [mailto:camer...@gmail.com] 
> Sent: Monday, July 05, 2010 8:54 PM
> To: cf-talk
> Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...
> 
> 
> On Mon, Jul 5, 2010 at 8:20 PM, Rick Faircloth 
> wrote:
>> I did look at UnFuddle.com, but I would need their
>> Enterprise account at $99 per month to handle my needs.
> 
> I'm curious what requirement makes the $99 plan your only option.
> You'd said "I mostly use the repo's for backup", but it sounds like
> you may be doing more than that.
> 
> Is it the number of projects/repos?  If you are willing to combine
> your repos you can get away with far fewer repos.
> 
> -Cameron
> 
> -- 
> Cameron Childress
> Sumo Consulting Inc
> http://www.sumoc.com
> ---
> cell:  678.637.5072
> aim:   cameroncf
> email: camer...@gmail.com
> 
> 
> 
> 



~|
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:335084
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Cameron Childress

On Mon, Jul 5, 2010 at 9:13 PM, Rick Faircloth  wrote:
> It is the number of projects/repos.
>
> I put each of my websites into a separate project/repo.

It could be worth considering consolidating them into one repo, or
fewer repos.  You'd lose alot of your history by doing so, but in the
long run you may have an easier time finding hosting.

Alternately, as Will said, you can set up your own server fairly
easily.  I did that for awhile but am recently of the mindset that I
hate managing servers and am moving all that stuff to services like
UnFuddle (which has great/simple ticket tracking too).

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com

~|
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:335083
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Wil Genovese

Why not build your own repro server?  It's easy to do.

Wil Genovese
Sr. Web Application Developer/
Systems Administrator

Wil Genovese Consulting
wilg...@trunkful.com
www.trunkful.com



On Jul 5, 2010, at 8:13 PM, Rick Faircloth wrote:

> 
> It is the number of projects/repos.
> 
> I put each of my websites into a separate project/repo.
> 
> 
> -Original Message-
> From: Cameron Childress [mailto:camer...@gmail.com] 
> Sent: Monday, July 05, 2010 8:54 PM
> To: cf-talk
> Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...
> 
> 
> On Mon, Jul 5, 2010 at 8:20 PM, Rick Faircloth 
> wrote:
>> I did look at UnFuddle.com, but I would need their
>> Enterprise account at $99 per month to handle my needs.
> 
> I'm curious what requirement makes the $99 plan your only option.
> You'd said "I mostly use the repo's for backup", but it sounds like
> you may be doing more than that.
> 
> Is it the number of projects/repos?  If you are willing to combine
> your repos you can get away with far fewer repos.
> 
> -Cameron
> 
> -- 
> Cameron Childress
> Sumo Consulting Inc
> http://www.sumoc.com
> ---
> cell:  678.637.5072
> aim:   cameroncf
> email: camer...@gmail.com
> 
> 
> 
> 

~|
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:335082
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

It is the number of projects/repos.

I put each of my websites into a separate project/repo.


-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: Monday, July 05, 2010 8:54 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


On Mon, Jul 5, 2010 at 8:20 PM, Rick Faircloth 
wrote:
> I did look at UnFuddle.com, but I would need their
> Enterprise account at $99 per month to handle my needs.

I'm curious what requirement makes the $99 plan your only option.
You'd said "I mostly use the repo's for backup", but it sounds like
you may be doing more than that.

Is it the number of projects/repos?  If you are willing to combine
your repos you can get away with far fewer repos.

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com



~|
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:335081
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Options for securing our IP on the client's machine?

2010-07-05 Thread Cameron Childress

On Mon, Jul 5, 2010 at 9:15 AM, Mark A. Kruger  wrote:
> I believe either Railo or BD allow for sourceless deployment - yes?

Adobe's CF does too, since CF7 I think

http://www.google.com/#q=sourceless+deployment+coldfusion

Deploys your CF code as java bytecode.  Can still be reverse
engineered so I wouldn't count in it hiding any crypto keys or
passwords, but you may find it suitable to prevent someone from taking
the app and making massive changes to it.

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com

~|
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:335080
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Cameron Childress

On Mon, Jul 5, 2010 at 8:20 PM, Rick Faircloth  wrote:
> I did look at UnFuddle.com, but I would need their
> Enterprise account at $99 per month to handle my needs.

I'm curious what requirement makes the $99 plan your only option.
You'd said "I mostly use the repo's for backup", but it sounds like
you may be doing more than that.

Is it the number of projects/repos?  If you are willing to combine
your repos you can get away with far fewer repos.

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com

~|
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:335079
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion and Alfresco

2010-07-05 Thread James Holmes

Yes, we're using the two together.

Did you use the webservice API or the web scripts?

--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/



On 6 July 2010 08:28, Matthew Gersting  wrote:
>
> I've been using Alfresco for a large-scale project for almost a year now, and 
> I was just curious if there were any other ColdFusion developers out there 
> who are also using it.  I'd be interested to share experiences and 
> techniques.  Also, I've built a CFC-based API and corresponding document 
> standard for it.  Figured I'd test the waters and see if there was any use 
> for it out in the broader communi

~|
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:335078
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


ColdFusion and Alfresco

2010-07-05 Thread Matthew Gersting

I've been using Alfresco for a large-scale project for almost a year now, and I 
was just curious if there were any other ColdFusion developers out there who 
are also using it.  I'd be interested to share experiences and techniques.  
Also, I've built a CFC-based API and corresponding document standard for it.  
Figured I'd test the waters and see if there was any use for it out in the 
broader community. 

~|
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:335077
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

Hi, Michael, and thanks for the link...

I was on a plan (been with them for awhile) where
I paid $2 per user with a cap at 4 users, unlimited
spaces, and $.30 per 100MB, including a rather new
functionality for them, "FTP on Commit".

With 31 repositories and one user, I paid $8 for users
and about $12 for space. ($.30 for each "space" with
some spaces using more than 100MB)  so, about $20.

Now, they changed their plans such that users are not capped
and are $4 each with 1 user counted for each repository,
or 31 spaces x $4 = $124 per month for users.

For the storage needed, I would still be paying the same as
before, or about $12.

That brings the total for Assembla to $136 per month.  That's
the way Assembla's support explained it today.  And, to make
matters worse, they took away the "FTP on Commit" functionality
for the above plan ("Limited Metered"), so it appears that I
would have to sign up for the "Enterprise" plan to get more than
20 spaces.  And that plan is $249 per month.

Currently, if I move to Springloops.com, I can get
50 active projects, unlimited archived projects, unlimited users,
FTP on Commit to up to 10 servers, and 8GB of storage $32 per month.

$32 sounds like a winner. Let's hope it works at least as well
as Assembla has...

Rick

-Original Message-
From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] 
Sent: Monday, July 05, 2010 8:14 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


There was a thread about the best external repositories a few months back.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:60947

Which plan were you on. I don't see any plans for either amount.


--
Michael Dinowitz
Lead Author - Adobe Coldfusion Anthology
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272
155/?tag=houseoffusion





On Mon, Jul 5, 2010 at 7:26 PM, Rick Faircloth 
wrote:
>
> Assembla's apparently suffering financially and they're changed their
>
> SVN repo hosting plans such that what was currently costing me
>
> $20 per month will now cost $132.
>
>
>
> Needless to say, I'm looking for some options since I mostly use
>
> the repo's for backup.
>
>
>
> Anyone have any suggestions?
>
>
>
> Thanks for any input!
>
>
>
> Rick
>
>
>
>
> 



~|
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:335076
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Update to ScriptWriter available on RIAForge

2010-07-05 Thread Matthew Gersting

Version 3.1 RC 5 is now available for download.
Pending user feedback, I believe this will be 3.1 Final.  Don't expect any 
changes for CF9 users, but CF8 users this is a necessary update.

http://scriptwriter.riaforge.org/ 

~|
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:335075
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

Thanks for the reply, Cameron.

I did look at UnFuddle.com, but I would need their
Enterprise account at $99 per month to handle my needs.

I looked over ProjectLocker, as well, and even their
free account would work, as it offers unlimited projects
and 500 MB of storage, however I've yet to hear back from
them about whether or not they offer "FTP on Commit".

I've gotten used to my commits being automatically sent
to my development server, or to the production
server manually from the repo's.  So, I'm waiting to
hear about that functionality.

I am looking over SpringLoops.com.  They do offer
"FTP on Commit", up to 50 active projects and unlimited
archived projects, and unlimited users for $32 per month,
which is acceptable.

If you think of any other suggestions, let me know!

Thanks, again!

Rick

-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: Monday, July 05, 2010 8:08 PM
To: cf-talk
Subject: Re: Ok...Assembla's gone a little mad. Need new SVN host...


I like UnFuddle.com, and for bare-bones cheap you might look at
projectlocker.com

-Cameron

On Mon, Jul 5, 2010 at 7:26 PM, Rick Faircloth 
wrote:
>
> Assembla's apparently suffering financially and they're changed their
>
> SVN repo hosting plans such that what was currently costing me
>
> $20 per month will now cost $132.
>
>
> Needless to say, I'm looking for some options since I mostly use
>
> the repo's for backup.



~|
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:335074
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Michael Dinowitz

There was a thread about the best external repositories a few months back.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:60947

Which plan were you on. I don't see any plans for either amount.


--
Michael Dinowitz
Lead Author - Adobe Coldfusion Anthology
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion





On Mon, Jul 5, 2010 at 7:26 PM, Rick Faircloth  wrote:
>
> Assembla's apparently suffering financially and they're changed their
>
> SVN repo hosting plans such that what was currently costing me
>
> $20 per month will now cost $132.
>
>
>
> Needless to say, I'm looking for some options since I mostly use
>
> the repo's for backup.
>
>
>
> Anyone have any suggestions?
>
>
>
> Thanks for any input!
>
>
>
> Rick
>
>
>
>
> 

~|
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:335073
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Cameron Childress

I like UnFuddle.com, and for bare-bones cheap you might look at
projectlocker.com

-Cameron

On Mon, Jul 5, 2010 at 7:26 PM, Rick Faircloth  wrote:
>
> Assembla's apparently suffering financially and they're changed their
>
> SVN repo hosting plans such that what was currently costing me
>
> $20 per month will now cost $132.
>
>
> Needless to say, I'm looking for some options since I mostly use
>
> the repo's for backup.

~|
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:335072
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Trouble with international characters [spamtrap heur]

2010-07-05 Thread Paul Hastings

On 7/6/2010 1:03 AM, Paul Alkema wrote:

> Also, when using unicode in ColdFusion with cfqueryparam's I would confirm
> that "String Format" is checked in your ColdFusion administrator. It should

yup that's probably the problem.

~|
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:335071
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Ok...Assembla's gone a little mad. Need new SVN host...

2010-07-05 Thread Rick Faircloth

Assembla's apparently suffering financially and they're changed their

SVN repo hosting plans such that what was currently costing me

$20 per month will now cost $132.

 

Needless to say, I'm looking for some options since I mostly use

the repo's for backup.

 

Anyone have any suggestions?

 

Thanks for any input!

 

Rick




~|
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:335070
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ordering by lowest price (across two columns)

2010-07-05 Thread Mike Little

funnily enough, this query has now shown us all cases where the client has put 
in a sale price higher than the retail price!! haha.

note to self... put in check on product manager to ensure this cannot 
happen 

~|
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:335069
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ordering by lowest price (across two columns)

2010-07-05 Thread Mike Little

hey charlie, thanks for pointing me in right direction. i could not get the 
case statement to work but the following does work...

SELECT SQL_CALC_FOUND_ROWS P.normalprice, P.saleprice,
IF(P.saleprice < P.normalprice, P.saleprice, P.normalprice) as orderprice
FROM product P
ORDER BY orderprice

works really well! 

~|
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:335068
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ordering by lowest price (across two columns)

2010-07-05 Thread Charlie Griefer

On Mon, Jul 5, 2010 at 1:09 PM, Mike Little  wrote:

>
> hi guys, slightly off-topic...
>
> my product table contains normalprice and saleprice (not really named this
> but as an example). i wish to give the customer the ability to order by
> lowest to highest price taking into account both the normal and sale price.
>
> not quite sure how to achieve this using an efficient mysql query.
>

I'm no SQL guru (as the SQL gurus that I've worked with will tell you), but
off the top of my head, a CASE statement that compares saleprice and
normalprice, and sets a column based on the lowest one:

SELECT
 name,
 description,
 normalprice,
 saleprice,
 CASE
  WHEN normalprice < saleprice THEN normalprice
  ELSE saleprice
 END AS orderbyprice
FROM
 tablename
ORDER BY
 orderbyprice

untested... but something like that?

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
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:335067
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


ordering by lowest price (across two columns)

2010-07-05 Thread Mike Little

hi guys, slightly off-topic...

my product table contains normalprice and saleprice (not really named this but 
as an example). i wish to give the customer the ability to order by lowest to 
highest price taking into account both the normal and sale price.

not quite sure how to achieve this using an efficient mysql query.

mike 

~|
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:335066
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Trouble with international characters

2010-07-05 Thread Paul Alkema

Hi,
What's your data type for the sql column that your trying to insert this
data into? If your inserting Unicode characters into varchar column you
should change the datatype to nvarchar.

Also, when using unicode in ColdFusion with cfqueryparam's I would confirm
that "String Format" is checked in your ColdFusion administrator. It should
be noted however that if this is enabled for your main dsn that it could
possibly cause performance issues.

I have two datasources one called nMainDns and another called mainDns. The
nMainDns is used to insert Unicode statements while using cfqueryparam's
while the other is used for select statements or stored procedures.

Paul Alkema
http://paulalkema.com/

On Mon, Jul 5, 2010 at 1:40 PM, Pete Ruckelshaus wrote:

>
> Oh, and here's the code for my SQL that's inserting the data:
>
> 
>  INSERT INTO tblHLMapLocations(name, description, latitude, longitude,
> locationIsApproximate, active)
>  VALUES (,
>   value="#stripHTML(trim(workingset.description))#">,
>  #trim(workingset.latitude)#,
>  #trim(workingset.longitude)#,
>   value="#locationIsApproximate(workingset.description)#">,
>  );
> 
>
>
>
> 2010/7/5 Pete Ruckelshaus 
>
> > I am using CF to import data from an Excel spreadsheet to an MS SQL
> Server
> > 2005 database.  Salient points: Characters are showing properly in the
> .XLSX
> > file; text fields in the SQL server database are all nvarchar or ntext; I
> am
> > using  at the top of the
> page
> > that is processing this page; and, finally, I am using  to
> > read the spreadsheet and put it into a query object.  Here's the data
> > processing code:
> >
> >  > filefield="uploadxls" nameconflict="MAKEUNIQUE">
> >
> >  > src="#cffile.serverdirectory#\#cffile.serverfile#" sheetname="sheet1"
> > query="getData">
> >
> > 
> >   >
> queryNew("#getdata.col_1#,#getdata.col_2#,#getdata.col_3#,#getdata.col_4#","varchar,varchar,varchar,varchar")>
> >  
> >  
> >  
> >  
> > 
> > 
> >  
> >   > stripOuterQuotes(getdata.col_1))>
> >   > stripOuterQuotes(getdata.col_2))>
> >   > stripOuterQuotes(getdata.col_3))>
> >   > stripOuterQuotes(getdata.col_4))>
> > 
> > 
> > 
> >  SELECT name, description, latitude, longitude
> >  FROM workingset
> >  ORDER BY name
> > 
> >
> > Now, the problem that I am having is that SOME (and not all) of the
> > international characters are not showing up properly.  For instance:
> >
> > These show up properly:
> > Großraming SB, Flossenbürg, Mirošov Labor Camp, Munkács Ghetto, Terezín
> >
> > These do NOT show up properly (correct versions in parentheses):
> > Brn?nec (Brněnec)
> > Auschwitz (Che?mek subcamp) - (Auschwitz (Chełmek subcamp))
> > Che?mno Extermination Camp - (Chełmno Extermination Camp)
> > Soldau (Dzia?dowo) Concentration Camp - (Soldau (Działdowo) Concentration
> > Camp)
> >
> > In case you're curious, I teach high school English and am working on a
> > Holocaust Location mapping project for my Holocaust Literature class.
> >
> > Does anyone have any ideas as to why some international characters are
> > making it through just fine, but others are getting munched?  This is
> really
> > the first time I've worked with anything beyond the basic Latin character
> > set.
> >
> > Thanks,
> >
> > Pete
> >
>
>
> 

~|
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:335065
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Trouble with international characters

2010-07-05 Thread Pete Ruckelshaus

Oh, and here's the code for my SQL that's inserting the data:


 INSERT INTO tblHLMapLocations(name, description, latitude, longitude,
locationIsApproximate, active)
 VALUES (,
 ,
 #trim(workingset.latitude)#,
 #trim(workingset.longitude)#,
 ,
 );




2010/7/5 Pete Ruckelshaus 

> I am using CF to import data from an Excel spreadsheet to an MS SQL Server
> 2005 database.  Salient points: Characters are showing properly in the .XLSX
> file; text fields in the SQL server database are all nvarchar or ntext; I am
> using  at the top of the page
> that is processing this page; and, finally, I am using  to
> read the spreadsheet and put it into a query object.  Here's the data
> processing code:
>
>  filefield="uploadxls" nameconflict="MAKEUNIQUE">
>
>  src="#cffile.serverdirectory#\#cffile.serverfile#" sheetname="sheet1"
> query="getData">
>
> 
>   queryNew("#getdata.col_1#,#getdata.col_2#,#getdata.col_3#,#getdata.col_4#","varchar,varchar,varchar,varchar")>
>  
>  
>  
>  
> 
> 
>  
>   stripOuterQuotes(getdata.col_1))>
>   stripOuterQuotes(getdata.col_2))>
>   stripOuterQuotes(getdata.col_3))>
>   stripOuterQuotes(getdata.col_4))>
> 
> 
> 
>  SELECT name, description, latitude, longitude
>  FROM workingset
>  ORDER BY name
> 
>
> Now, the problem that I am having is that SOME (and not all) of the
> international characters are not showing up properly.  For instance:
>
> These show up properly:
> Großraming SB, Flossenbürg, Mirošov Labor Camp, Munkács Ghetto, Terezín
>
> These do NOT show up properly (correct versions in parentheses):
> Brn?nec (Brněnec)
> Auschwitz (Che?mek subcamp) - (Auschwitz (Chełmek subcamp))
> Che?mno Extermination Camp - (Chełmno Extermination Camp)
> Soldau (Dzia?dowo) Concentration Camp - (Soldau (Działdowo) Concentration
> Camp)
>
> In case you're curious, I teach high school English and am working on a
> Holocaust Location mapping project for my Holocaust Literature class.
>
> Does anyone have any ideas as to why some international characters are
> making it through just fine, but others are getting munched?  This is really
> the first time I've worked with anything beyond the basic Latin character
> set.
>
> Thanks,
>
> Pete
>


~|
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:335064
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Trouble with international characters

2010-07-05 Thread Pete Ruckelshaus

I am using CF to import data from an Excel spreadsheet to an MS SQL Server
2005 database.  Salient points: Characters are showing properly in the .XLSX
file; text fields in the SQL server database are all nvarchar or ntext; I am
using  at the top of the page
that is processing this page; and, finally, I am using  to
read the spreadsheet and put it into a query object.  Here's the data
processing code:






 
 
 
 
 


 
 
 
 
 



 SELECT name, description, latitude, longitude
 FROM workingset
 ORDER BY name


Now, the problem that I am having is that SOME (and not all) of the
international characters are not showing up properly.  For instance:

These show up properly:
Großraming SB, Flossenbürg, Mirošov Labor Camp, Munkács Ghetto, Terezín

These do NOT show up properly (correct versions in parentheses):
Brn?nec (Brněnec)
Auschwitz (Che?mek subcamp) - (Auschwitz (Chełmek subcamp))
Che?mno Extermination Camp - (Chełmno Extermination Camp)
Soldau (Dzia?dowo) Concentration Camp - (Soldau (Działdowo) Concentration
Camp)

In case you're curious, I teach high school English and am working on a
Holocaust Location mapping project for my Holocaust Literature class.

Does anyone have any ideas as to why some international characters are
making it through just fine, but others are getting munched?  This is really
the first time I've worked with anything beyond the basic Latin character
set.

Thanks,

Pete


~|
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:335063
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Options for securing our IP on the client's machine?

2010-07-05 Thread Mark A. Kruger

I believe either Railo or BD allow for sourceless deployment - yes?

Mark A. Kruger, MCSE, CFG
(402) 408-3733 ext 105
Skype: markakruger
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com



-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Monday, July 05, 2010 7:27 AM
To: cf-talk
Subject: Re: Options for securing our IP on the client's machine?


With CF there's a few tools for decrypting the source code. If your client
isn't very savvy then you probably don't have to worry about it, otherwise
it's pretty easy to get to the original cf source.

On Mon, Jul 5, 2010 at 3:47 AM, Mike Kear  wrote:

>
> We have an application that will possibly require putting a version of our
> CF application on the client's machine.   Therefore we're going to be
> needing to encrypt or compile or otherwise hide our code from the client's
> prying eyes.
>
> It's quite a while since i had to consider this - like since CF5!  - so I
> need to update my knowledge of this whole area.
>
> What options are there these days for allowing applications to run on a
> client machine without them being able to see the source code behind it?
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
> 



~|
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:335062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


spreadsheetSetColumnWidth ingnored

2010-07-05 Thread Jeff Battershall

Hi,

It seems that setting spreadsheetSetColumnWidth(myXLS,1,50) has no effect if 
the cell contents would be visually clipped. 

Anyone encountered this?

Jeff 

~|
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:335061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Options for securing our IP on the client's machine?

2010-07-05 Thread Michael Grant

With CF there's a few tools for decrypting the source code. If your client
isn't very savvy then you probably don't have to worry about it, otherwise
it's pretty easy to get to the original cf source.

On Mon, Jul 5, 2010 at 3:47 AM, Mike Kear  wrote:

>
> We have an application that will possibly require putting a version of our
> CF application on the client's machine.   Therefore we're going to be
> needing to encrypt or compile or otherwise hide our code from the client's
> prying eyes.
>
> It's quite a while since i had to consider this - like since CF5!  - so I
> need to update my knowledge of this whole area.
>
> What options are there these days for allowing applications to run on a
> client machine without them being able to see the source code behind it?
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
> 

~|
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:335060
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdBox: and CF9 ORM: Mapping for component user not found

2010-07-05 Thread Glyn Jackson

I assumed that tried it but  get
Variable USERSERVICE is undefined.
when using inject="userService:user"
i also trted just inject;

>Should this
>
>property name="userService" inject="entityService:user";
>
>be
>
>property name="userService" inject="userService:user";
>
>??
>
>
>Hi, can anyone help.
>
>I am playing around with CB 3 and CF9 ORM. I am not sure its wiring
>everything up correctly as I get the message...
>
>Error Messages:  Mapping for component user not found.
>Either the mapping for this component is missing or the application must be
>restarted to generate the mapping.
>
>I have followed the sample app 'task manager' but think i have missed
>something..
>
>my handler login.cfc...
>
>property name="userService" inject="entityService:user";
>
>/* Index handler */
>function index(event){
>var rc = event.getCollection();
>userService.get();
>event.setView("login/index");
>}
>
>my user.cfc
>
>component output="false" persistent="true"{
>
>property name="user_id" fieldType="id";
>property name="user_username" notnull="true" type="string";
>property name="user_password" type="string";
>property name="user_email" type="string";
>property name="user_role" type="string";
>property name="user_created" type="date" dbdefault="#now()#";
>
>user function init() output=false{
>return this;
>}
>
>}
>
>my service
>
>component output="false" singleton{
>
>userService function init() output=false{
>return this;
>}
>
>   User function getUser(user_id="") output=false{
>   if( len(arguments.user_id) ){
>   var user =
>entityLoad("User",arguments.user_id,true);
>   if(NOT isNull(user) ){
>   return user;
>   }
>   }   
>   return entityNew("User");
>   }
>
>etc...
>
>app.cfc
>
>// ORM Setup
>this.ormEnabled = true;
>this.datasource = "testDS";
>this.ormSettings = {
>dbcreate = "update",
>dialect = "MySQLwithInnoDB",
>logSQL = true,
>eventhandling = true,
>eventhandler = "model.ORMEventHandler",
>flushAtRequestEnd = false
>}; 

~|
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:335059
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Options for securing our IP on the client's machine?

2010-07-05 Thread Mike Kear

We have an application that will possibly require putting a version of our
CF application on the client's machine.   Therefore we're going to be
needing to encrypt or compile or otherwise hide our code from the client's
prying eyes.

It's quite a while since i had to consider this - like since CF5!  - so I
need to update my knowledge of this whole area.

What options are there these days for allowing applications to run on a
client machine without them being able to see the source code behind it?

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


~|
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:335058
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm