date:20080125

Ok, Will, so, I know that's how this editor handles cache, no biggie, but the 
more important thing is, are we able to make this editor not to exclude other 
javascripts for the same form element as I described above?

Thanks.

Don
Yes, mine is too but I've still had to manually clear the cache for this
change to be displayed in the past, in both IE and Firefox.

Anyway, as you say it's academic anyway!

Cheers

Will


~|
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:297429
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Why would I get a cfhttp timeout on this cfftp operation?

I think Dave is trying to say that CFSchedule kicks off a CFHTTP request TO
that script which has another complex CFFTP script going on.  That's 2
points of failure (CFHTTP and then CFFTP) versus just automating this via
machine and perhaps setting up a directory watcher to monitor a directory
and do post processing.

On Jan 25, 2008 10:35 AM, Rick Faircloth [EMAIL PROTECTED] wrote:

 Thanks for the insight, Dave...

 But how would one even use CFFTP if it always depends on
 CFHTTP for functionality?

 Also (to Tom, too), I tried to set the timeout in the scheduled
 task to 9, but that had no effect.

 It just seems that if CFFTP is always dependent upon CFHTTP, and
 CFHTTP is always going to have timeout issues, that CFFTP is useless.
 Aren't *all* CF pages dependent upon HTTP?

 There has got to be a setting or something that will allow CFFTP
 to function properly.

 Rick

  -Original Message-
  From: Dave Watts [mailto:[EMAIL PROTECTED]
  Sent: Friday, January 25, 2008 10:04 AM
  To: CF-Talk
  Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
   I get about 4 MB of a 25 MB file each time then my scheduled
   task, whether I let the scheduler run it or manually trigger
   the scheduled task, or even if I run the template directly in
   the browser, I get an error from the scheduler log that says
   I had a cfhttp timeout error.
  
   Why is cfhttp involved?  Implicitly?
 
  Scheduled tasks are run using CFHTTP. I would recommend that you
 consider
  another way to automate this task. For example, you can automate FTP
 using
  the operating system scheduler and almost any FTP client.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
 
  Fig Leaf Software provides the highest caliber vendor-authorized
  instruction at our training centers in Washington DC, Atlanta,
  Chicago, Baltimore, Northern Virginia, or on-site at your location.
  Visit http://training.figleaf.com/ for more information!
 
 

 

~|
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:297428
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SSL Necessary? Important?

I'm not sure how Zillow.com's terms supports your My strong password or
else argument (which is what I thought this was) as all you did was show me
their terms of use.

Now try to find one one here -
http://www.sharebuilder.com/sharebuilder/Security/Default.aspx

I can choose any password I want there.  I'm sure that Sharebuilder probably
has real time monitoring going on and Zillow doesn't.  Is that what the
difference between the terms are?  Real time we got your back security
versus some real estate website listing properties?  *shrugs* No idea.

On Jan 25, 2008 12:02 PM, Rick Faircloth [EMAIL PROTECTED] wrote:

 Here's some of the Terms for use of Zillow.com... a Real Estate listing
 website.

 9. LIABILITY LIMITATION; EXCLUSIVE REMEDY. IN NO EVENT WILL ZILLOW.COM OR
 ANY SUPPLIER BE LIABLE FOR
 ANY DAMAGES, INCLUDING WITHOUT LIMITATION ANY INDIRECT, CONSEQUENTIAL,
 SPECIAL, INCIDENTAL, OR
 PUNITIVE DAMAGES ARISING OUT OF, BASED ON, OR RESULTING FROM THESE TERMS
 OF USE OR YOUR USE OF THE
 SERVICES, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH
 DAMAGES. THE EXCLUSION OF
 DAMAGES UNDER THIS PARAGRAPH IS INDEPENDENT OF YOUR EXCLUSIVE REMEDY AND
 SURVIVES IN THE EVENT SUCH
 REMEDY FAILS OF ITS ESSENTIAL PURPOSE OR IS OTHERWISE DEEMED
 UNENFORCEABLE. THESE LIMITATIONS AND
 EXCLUSIONS APPLY WITHOUT REGARD TO WHETHER THE DAMAGES ARISE FROM (A)
 BREACH OF CONTRACT, (B) BREACH
 OF WARRANTY, (C) NEGLIGENCE, OR (D) ANY OTHER CAUSE OF ACTION, TO THE
 EXTENT SUCH EXCLUSION AND
 LIMITATIONS ARE NOT PROHIBITED BY APPLICABLE LAW. IF YOU DO NOT AGREE WITH
 ANY PART OF THESE TERMS
 OF USE, OR YOU HAVE ANY DISPUTE OR CLAIM AGAINST ZILLOW.COM OR ITS
 SUPPLIERS WITH RESPECT TO THESE
 TERMS OF USE OR THE SERVICES, THEN YOUR SOLE AND EXCLUSIVE REMEDY IS TO
 DISCONTINUE USING THE
 SERVICES.

 Now that pretty iron-clad legally, I think, that no matter what you do,
 password or other-wise, they're not going to pay for it. Quite
 bottom-line, my way or the highway, especially that last clause...



~|
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:297447
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

 No matter how I run it, I get the same error...
 
 - Automated Scheduled Task
 - Manual Test Run of Scheduled Task
 - Run template directly in browser

Then your problem isn't with CFHTTP, it's with the file. Have you set the
TIMEOUT attribute for CFFTP? Have you also set the page timeout using
CFSETTING?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
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:297446
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SSL Necessary? Important?

 Anyway, the problem with strong passwords is they're not 
 easily, if at all, memorable.

That doesn't have to be true:
http://en.wikipedia.org/wiki/Passphrase

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
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:297445
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 App throwing Access access error

2008-01-25 Thread Crow T. Robot

I remember this too, from CF5/4.5 days, tho.  I thought this was fixed in
the MX rewrite?

On Jan 25, 2008 10:59 AM, Gerald Guido [EMAIL PROTECTED] wrote:

 I remember this. We used to fix it by running a query with a syntax error
 on
 the database. For some reason it will unlock the database.

 On Jan 25, 2008 11:37 AM, Adkins, Randy [EMAIL PROTECTED] wrote:

  It is probably locked by the Datasource connection from CF Admin
 
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 
  Sent: Friday, January 25, 2008 11:35 AM
  To: CF-Talk
  Subject: CF App throwing Access access error
 
  Everyone is logged out, and there's no lock on the access file.
  This error still persits.  Any ideas?  I've seen this a long time ago
  clear when I rebotted the machine the Access file was located on.
 
  Any ideas?
 
  Error Executing Database Query.
  [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
  Microsoft Access Driver] The Microsoft Jet database engine cannot open
  the file apos;(unknown)apos;. It is already opened exclusively by
  another user, or you need permission to view its data.
 
 
 
 

 

~|
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:297441
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: SQL Question -- Order by a column's value?

2008-01-25 Thread Charlie Griefer

something like...

SELECT
 Colleges,
 CASE
  when Colleges = 'Harvard' THEN 1
  when Colleges = 'Princeton' THEN 2
  when Colleges = 'Dartmouth' THEN 3
 END AS collegeOrder
FROM
 myTable
ORDER BY
 collegeOrder

(not tested) :)

On Jan 25, 2008 10:41 AM, Che Vilnonis [EMAIL PROTECTED] wrote:
 Suppose I have a small set of data with a column named Colleges. Is there
 a way to write an ORDER BY statement to say something like...
 ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

 Just wondering... Che


 

~|
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:297453
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: OT: SQL Question -- Order by a column's value?

2008-01-25 Thread Che Vilnonis

I was trying to do that w/o adding another column. Can it be done? 

-Original Message-
From: Todd [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 1:50 PM
To: CF-Talk
Subject: Re: OT: SQL Question -- Order by a column's value?

Nope, add a sort_order column and sort your colleges appropriately.

On Jan 25, 2008 1:41 PM, Che Vilnonis [EMAIL PROTECTED] wrote:

 Suppose I have a small set of data with a column named Colleges. Is 
 there a way to write an ORDER BY statement to say something like...
 ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

 Just wondering... Che

~|
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:297456
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: SQL Question -- Order by a column's value?

There is no way to do it with pure SQL alone.

Dominic

Well actually you can do in pure SQL.  SQL has code that can be used to create 
dynamic columns and values on the fly in your record set and then one can order 
on this set.  It sort of depends on whether the desire order is permanent or 
flexible.  I.E. sometimes one wants 'Harvard', 'Princeton' and 'Dartmouth' and 
another time one wants 'Princeton', 'Dartmouth' and 'Harvard'.


SELECT
  CASE college
 WHEN 'Harvard' THEN 1
 WHEN 'Princeton' THEN 2
 WHEN 'Dartmouth' THEN 3
  END AS sortCol

FROM aTable

ORDER BY sortCol

The exact syntax can very from database to database management system.




~|
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:297460
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFHTTP.Filecontent on left side of an assignment

Confirm that it exists?
cfdump var=#test#

I thought it was just cfhttp.fileContent?  I see they added the results
attribute in 7, but there's no additional documentation on it.

On Jan 25, 2008 2:51 PM, Jim McAtee [EMAIL PROTECTED] wrote:

 I'm getting an error in CF8 when I attempt to alter the contents of the
 filecontent key of a struct returned by CFHTTP.  This worked fine in CF5.
 I can easily fix it, but what's the reason for the error?  There's not
 much to go on in the debugging output.

 The code:

 cfhttp url=.com/test2.cfm result=test
 cfset test.filecontent = Replace(test.filecontent, a, b, all)

 The error:

 12:41:30.030 - java.lang.NoSuchFieldException - in D:\web\dev5\test1.cfm :
 line 13
FILECONTENT
 While this statement is ok:cfset s = Replace(test.filecontent, a, b,
 all)


 

~|
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:297468
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SSL Necessary? Important?

I agree to a point, Claude... you're right that anything can
be overturned, but having a prior agreement is always good to have
on your side in court.

There would have to be gross negligence on a company's part to
have the prior legal agreement ignored.

I think everyone in our discussion is right, to a point.

And, btw, I have no connection to Zillow.com.  I just happened to
be on that site when the question about liability came up.

I will say that if I ever do get sued because passwords and usernames
were stolen from my company and I lost a case because someone's bank
account was drained because it used the same password and username,
I would absolutely start forcing my passwords on everyone.

To this point, I've had no problem.  And we all try to balance
user-friendliness and security.  But someone is always being bitten.
Everyone is just playing a game of Russian Roulette and hoping we're
not the one facing a round in the chamber.

Rick

 -Original Message-
 From: Claude Schneegans [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 1:36 PM
 To: CF-Talk
 Subject: Re: SSL Necessary? Important?
 
  IN NO EVENT WILL ZILLOW.COM OR ANY SUPPLIER BE LIABLE FOR
 ANY DAMAGES
 
 I'm sorry, but just from the very begining, this statement has
 absolutely no value.
 I hope you didn't pay a lawyer to write it.
 
 Nobody can state, in advance on not that he is not liable or responsible.
 ONLY a judge in court can make this decision, only based on facts.
 If you have been careless in an issue, EVEN if you warned the plaintiff that
 you are not liable, the judge can decide that you are responsible.
 
 The only utility of such notice is may be 1. to make unaware customers
 believe they can't go to court,
 2. to make them do their part about security.
 




~|
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:297475
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Jim McAtee

Yes, it exists.  It fails using either cfhttp.filecontent or some variable 
designated through the restults attribute.

- Original Message - 
From: Todd [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 1:04 PM
Subject: Re: CFHTTP.Filecontent on left side of an assignment

 Confirm that it exists?
 cfdump var=#test#

 I thought it was just cfhttp.fileContent?  I see they added the results
 attribute in 7, but there's no additional documentation on it.

 On Jan 25, 2008 2:51 PM, Jim McAtee [EMAIL PROTECTED] wrote:

 I'm getting an error in CF8 when I attempt to alter the contents of the
 filecontent key of a struct returned by CFHTTP.  This worked fine in 
 CF5.
 I can easily fix it, but what's the reason for the error?  There's not
 much to go on in the debugging output.

 The code:

 cfhttp url=.com/test2.cfm result=test
 cfset test.filecontent = Replace(test.filecontent, a, b, all)

 The error:

 12:41:30.030 - java.lang.NoSuchFieldException - in 
 D:\web\dev5\test1.cfm :
 line 13
FILECONTENT
 While this statement is ok:cfset s = Replace(test.filecontent, a, 
 b,
 all)

~|
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:297472
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SSL Necessary? Important?

My only point about Zillow.com's terms holds them unaccountable for any
problems you experiences from using their site.  They state:

(A) BREACH OF CONTRACT, (B) BREACH OF WARRANTY, (C) NEGLIGENCE, OR
(D) ANY OTHER CAUSE OF ACTION

Sounds to me like, whether it's because of a weak password or whatever,
they can't be held liable.  And in the final clause, they simply state
that if you don't like those terms, don't use the service.

Those terms sound fine to me.  Even if I have no security for people's
password, personal info, etc., sounds to me like the terms above protects
me under any circumstance, including (C), negligence.


Now concerning Sharebuilder.com's position:

First, your link was a PR departments friendly-face, warm-and-fuzzy
explanation of how they'll take care of you and provide you with security.

However, the legal departments position, and the only one that counts is:

http://www.sharebuilder.com/sharebuilder/Legal/Default.aspx, particularly
in our discussion, point 27:

27) Security and Confidentiality
You agree that you will be fully responsible for the confidentiality of your 
user name and password.
You further agree that you will be fully and solely responsible for all 
activities, including
brokerage transactions, that arise from the use of your user name and password. 
You will immediately
notify us in writing or by e-mail of any loss, theft or unauthorized use of 
your user name, password
and/or account number(s).

So, their bottom line is that you're responsible for all activities, 
brokerage or otherwise,
that arise from the use of your user name and password.

So, again, they positioned themselves so that only the client is at risk
if somebody finds out about their user name and password and abuses it.


At least that's my take...

Rick



 -Original Message-
 From: Todd [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 12:52 PM
 To: CF-Talk
 Subject: Re: SSL Necessary? Important?
 
 I'm not sure how Zillow.com's terms supports your My strong password or
 else argument (which is what I thought this was) as all you did was show me
 their terms of use.
 
 Now try to find one one here -
 http://www.sharebuilder.com/sharebuilder/Security/Default.aspx
 
 I can choose any password I want there.  I'm sure that Sharebuilder probably
 has real time monitoring going on and Zillow doesn't.  Is that what the
 difference between the terms are?  Real time we got your back security
 versus some real estate website listing properties?  *shrugs* No idea.
 
 On Jan 25, 2008 12:02 PM, Rick Faircloth [EMAIL PROTECTED] wrote:
 
  Here's some of the Terms for use of Zillow.com... a Real Estate listing
  website.
 
  9. LIABILITY LIMITATION; EXCLUSIVE REMEDY. IN NO EVENT WILL ZILLOW.COM OR
  ANY SUPPLIER BE LIABLE FOR
  ANY DAMAGES, INCLUDING WITHOUT LIMITATION ANY INDIRECT, CONSEQUENTIAL,
  SPECIAL, INCIDENTAL, OR
  PUNITIVE DAMAGES ARISING OUT OF, BASED ON, OR RESULTING FROM THESE TERMS
  OF USE OR YOUR USE OF THE
  SERVICES, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH
  DAMAGES. THE EXCLUSION OF
  DAMAGES UNDER THIS PARAGRAPH IS INDEPENDENT OF YOUR EXCLUSIVE REMEDY AND
  SURVIVES IN THE EVENT SUCH
  REMEDY FAILS OF ITS ESSENTIAL PURPOSE OR IS OTHERWISE DEEMED
  UNENFORCEABLE. THESE LIMITATIONS AND
  EXCLUSIONS APPLY WITHOUT REGARD TO WHETHER THE DAMAGES ARISE FROM (A)
  BREACH OF CONTRACT, (B) BREACH
  OF WARRANTY, (C) NEGLIGENCE, OR (D) ANY OTHER CAUSE OF ACTION, TO THE
  EXTENT SUCH EXCLUSION AND
  LIMITATIONS ARE NOT PROHIBITED BY APPLICABLE LAW. IF YOU DO NOT AGREE WITH
  ANY PART OF THESE TERMS
  OF USE, OR YOU HAVE ANY DISPUTE OR CLAIM AGAINST ZILLOW.COM OR ITS
  SUPPLIERS WITH RESPECT TO THESE
  TERMS OF USE OR THE SERVICES, THEN YOUR SOLE AND EXCLUSIVE REMEDY IS TO
  DISCONTINUE USING THE
  SERVICES.
 
  Now that pretty iron-clad legally, I think, that no matter what you do,
  password or other-wise, they're not going to pay for it. Quite
  bottom-line, my way or the highway, especially that last clause...




~|
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:297476
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: date problem

2008-01-25 Thread Claude Schneegans

 07/24/1978 is an invalid date format

Ok, now I see what your problem is:
If you're using LSdateFormat, the function (and here is the difference 
with dateFaormat)
expect a date. Since 07/24/1978 is not a date, but a string, CF will 
try to convert it to a date,
but according the English (UK) standard, which is dd/mm/.
Thus 24 is interpreted as the month, this is what causes the error.

If you use only dateFormat, the date can be interpreted as an American 
date and it works.

You only have two choices:
1. use createDate and pass independently the day, month, year parts as 
substrings of the date.
2. spend a few bucks, save lots of time and hurry to get  CF_convertDate 
here:
http://www.contentbox.com/claude/customtags/convertDate/viewConvertDate.cfm

With only one line of code, you will solve your problem:
CF_convertDate inputVariable=myDate inputMask=US outputMask=EU
or in function call format:
CFSET outputDate = convertDate(myDate, string, string, US, EU)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
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:297491
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

 No problems anywhere, but with CFFTP.
 
 I just need to get around the CFHTTP page timeout.  And there 
 should be a way to use the CFFTP tag without having to resort 
 to jumping through a lot of hoops using third-party software 
 and contorted methods.
 
 Why won't the tag just work?

Any number of reasons. Again, this probably isn't an HTTP problem if you
can't successfully run the page directly (as opposed to running it as a
scheduled task).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
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:297492
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: lite spell checker?

2008-01-25 Thread William Seiter

You should change the location of the 'spellchecker.cfm' file to the
location of the page on your local system.

As for the request var error, rerun the system after the new location has
been defined above and we can work through that.

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer 
http://William.Seiter.com

-Original Message-
From: Don L [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 1:46 PM
To: CF-Talk
Subject: Re: lite spell checker?

Yes, the 6 steps are very clean, it saves time and I appreciate it.
But I'm got an err mgs when attempted to use the checker,

Element DATA_STORAGE_1 is undefined in REQUEST.  

I was wondering about that when edited the spellchecker.cfm file per
instruction, where's the {DATA_STORAGE_1} var defined? but thought maybe,
some other script addresses it...

Also, I used,
cfform ...
cfinput type=button name=speller value=Check Spell
onclick=javascript:#ajaxlink('../CFIDE/scripts/ajax/FCKeditor/editor/dialog
/fck_spellerpages/spellerpages/server-scripts/spellchecker.cfm')#
/cfform
to call the spellchecker.  What is supposed to be the proper way to call the
speller?  Does it need a param/argument to feed it?

Thanks.

-- free is never free
ASpell is the spelling 'core', but you need the javascript/CF page, that
calls the Aspell system.

http://spellerpages.sourceforge.net/

Actually, to make things easier, this guy put out a step by step that you
could follow.

http://www.fantasy-league.com/coldfusion/fckeditor/
Where it refers to pages in the 'fck_spellerpages' directory, just change
the files that are in your spellerpages directory.

Hope this helps,


William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer 
http://William.Seiter.com





~|
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:297499
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

DNS Hosting

2008-01-25 Thread Dave Hatz

I am looking for recommendations on a company to host our DNS.  We are 
currently using Internap's CoLocation services and their DNS went down again.  
3rd time in less than 2 months.  Our customers are pissed and I don't blame 
them.  I need to find another solution and always value the recommendations 
from this list.

Thanks,
Dave Hatz 

~|
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:297496
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

The page runs successfully until it times out while the
download operation is going on.

I can watch the file being downloaded in Windows Explorer
until the point where the page times out like any other
slow web page.  At that point the page shows the error message
and the download stops.

Any other thoughts or tests I can run?
Debugging info I can gather?


 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 6:01 PM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
  No problems anywhere, but with CFFTP.
 
  I just need to get around the CFHTTP page timeout.  And there
  should be a way to use the CFFTP tag without having to resort
  to jumping through a lot of hoops using third-party software
  and contorted methods.
 
  Why won't the tag just work?
 
 Any number of reasons. Again, this probably isn't an HTTP problem if you
 can't successfully run the page directly (as opposed to running it as a
 scheduled task).
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

~|
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:297507
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Has anyone here built a solid RSS Ingest system?

2008-01-25 Thread Nate Willard

A system that would ingest stories from 1+ rss feeds?


~|
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:297505
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: lsdateformat and dateformat clarification

2008-01-25 Thread Claude Schneegans

 it seems to me that lsdateformat function takes an english uk 
formated date (dd/mm/)

More precisely, I would say it takes a date in the default locale 
format, or the locale previously defined by setLocale()
If your server is English, then yes, you are right.
For servers un US, it will take an American date.

 and it seems that the dateformat function takes a USA formated date 
(mm/dd/)

Yes, if the date is a legal date, otherwise it will try in English (or 
Eurpean format)

 i thought that with the lsdateformat i could pass it any formated 
date and it would format it into dd/mm/ format

This is right, if you really pass a date, ie Now(), but 25/01/2008 is 
NOT a date, it's a string.
So the string has to be converted first, and this is where trouble start.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
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:297508
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: SSL Necessary? Important?

2008-01-25 Thread Gerald Guido

A quote From  O Brother, Where Art Thou?

This stew's awful good.
Wash responds, You think so? I slaughtered this horse last Tuesday. I'm
afraid she's startin' to turn.

Just sayin'... ;)


On Jan 25, 2008 5:33 PM, James Holmes [EMAIL PROTECTED] wrote:

 Yes, wildcard certs work fine under Apache too.

 On Jan 26, 2008 2:20 AM, Dave Watts [EMAIL PROTECTED] wrote:
   I'd like to see some proof of this.  Is this only with
   wildcard certs (in which case it would only work for
   *.domainname.com), or it is for any kind of cert (such that
   you can have www.example.com and www.example2.com) on the
   same IP with no SSL problems?
 
  Wildcard certs only. I neglected to mention that in my initial response,
 but
  added it in a followup.

 --
 mxAjax / CFAjax docs and other useful articles:
 http://www.bifrost.com.au/blog/

 

~|
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:297504
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: date problem

2008-01-25 Thread Richard White

Hi claude,

thanks for this, i am starting to understand the problem now, i will however 
take a look at your function as the lsdateformat is starting to give me 
nightmares!!!

thanks claude

richard 

~|
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:297509
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: lite spell checker?

Thank you, William, I believe I was calling the 'spellchecker.cfm' file in the 
correct local location.  To further verify this, I tried different relative 
path such as using prefix of ../ or ./ or / for {CFIDE}
When the relative path was wrong, it would prompt for {File not found}, as 
expected.
I've also try the {ColdFusion.navigate()} technique to see if I'm not calling 
it correctly to no avail neither.
To further debug, I checked and verified that the Aspell utility has been 
installed correctly and it works fine from command line.  So, I think somehow, 
the three elements of the speller utility, js and cf are not working together 
(not in sync).
The speller has been tested to be ok, so, probably we can now test, if the 
speller is working with js, how should we go about that?  Or a more logical 
test option?

Another thought is, I'm running this CFFORM within a CFWINDOW, would that mess 
up?
The above testing was done with IE7, so, I just tried FF2, same result.

I appreciate your help.

Don
You should change the location of the 'spellchecker.cfm' file to the
location of the page on your local system.

As for the request var error, rerun the system after the new location has
been defined above and we can work through that.

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer 
http://William.Seiter.com


~|
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:297510
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: date problem

2008-01-25 Thread Kevan Stannard

Richard

Just a final comment on this:

If you know that your dates are always in the /mm/dd format, then you
should use parseDateTime() to parse them and then format accordingly:

Eg. Assuming your date is in a variable 'd'

Format according to the setLocale() value:
cfset dateDisplay = lsDateFormat(parseDateTime(d))

Format explicitly:
cfset dateDisplay = dateFormat(parseDateTime(d),dd/mm/)

Regards

Kevan


-Original Message-
From: Kevan Stannard [mailto:[EMAIL PROTECTED] 
Sent: Saturday, 26 January 2008 2:28 PM
To: 'cf-talk@houseoffusion.com'
Subject: RE: date problem

Hi Richard

We deal with the same issue here in Australia.

You may have the problem sorted out by now, but you may like to have a look
at some notes I put down a little while ago on this.

http://stannard.net.au/blog/index.cfm/2006/10/25/Date-Objects-vs-Date-String
s-in-ColdFusion

Just an extra comment:

When you use lsDateFormat() then CF uses lsParseDateTime() to first convert
your string to a date object before formatting.

When you use dateFormat() then CF uses parseDateTime() to first convert your
string to a date object before formatting.

parseDateTime() can handle dates in /mm/dd format

lsParseDateTime() can not handle dates in /mm/dd format, which is why
you get an error.

Kevan


-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Monday, 21 January 2008 1:18 AM
To: CF-Talk
Subject: date problem

Hi, 

i have been playing around with date formats for ages and still encountering
problems. i am in the uk and have set the following code when someone logs
in:

cfset SetLocale(English (UK))

i have dates stored in a mysql db which is in the format /mm/dd

when i try to get data out of the db and put it in the dd/mm/ format i
use lsdateformat(date,dd/mm/)

and it spits out an error: 01/20/2008 is not a valid date format!!

i dont understand this at all, does anyone have any ideas why it would do
this. i dont understand why it would output this when i am telling it to put
it in dd/mm/ format not mm/dd/ format

thanks very much 



~|
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:297512
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: date problem

2008-01-25 Thread Kevan Stannard

Hi Richard

We deal with the same issue here in Australia.

You may have the problem sorted out by now, but you may like to have a look
at some notes I put down a little while ago on this.

http://stannard.net.au/blog/index.cfm/2006/10/25/Date-Objects-vs-Date-String
s-in-ColdFusion

Just an extra comment:

When you use lsDateFormat() then CF uses lsParseDateTime() to first convert
your string to a date object before formatting.

When you use dateFormat() then CF uses parseDateTime() to first convert your
string to a date object before formatting.

parseDateTime() can handle dates in /mm/dd format

lsParseDateTime() can not handle dates in /mm/dd format, which is why
you get an error.

Kevan


-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Monday, 21 January 2008 1:18 AM
To: CF-Talk
Subject: date problem

Hi, 

i have been playing around with date formats for ages and still encountering
problems. i am in the uk and have set the following code when someone logs
in:

cfset SetLocale(English (UK))

i have dates stored in a mysql db which is in the format /mm/dd

when i try to get data out of the db and put it in the dd/mm/ format i
use lsdateformat(date,dd/mm/)

and it spits out an error: 01/20/2008 is not a valid date format!!

i dont understand this at all, does anyone have any ideas why it would do
this. i dont understand why it would output this when i am telling it to put
it in dd/mm/ format not mm/dd/ format

thanks very much 



~|
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:297511
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Download Tables in Excel and CFMAIL in CFMX

2008-01-25 Thread Tech Gate

Thanks for the tips on this.
I found this working codes below, but need to know how to put all of
the output into Excel files with the column names.

cfset tbls = Demo,FuncAbility, ...

cfoutput
  cfloop list=#tbls# index=i
cfquery datasource=GKeeper name=qryTable
select *
from #i#
/cfquery

cfif qryTable.RecordCount
cfset ColList = qryTable.ColumnList
cfloop list=#ColList# index=j
#j#br /
cfloop query=qryTable
#qryTable[j][CurrentRow]#
/cfloopbr /
/cfloop
/cfif
/cfloop
/cfoutput

Any ideas on this, please?

Thanks much

On Jan 25, 2008 5:51 AM, Dominic Watson [EMAIL PROTECTED] wrote:
 For each table, something like:

 cfloop query=ExportData

  cfloop list=#ExportData.columnList# index=col !--- columnList is a
 variable that is present in every query - a comma seperated list of column
 names ---
cfset output = output  #ExportData[col]#  ' ' !--- this will need to
 change to reflect the way you are making the excel file ---
  /cfloop

  cfset output = output  chr(13)  chr(10) !--- I wouldn't do a file
 append on each loop, just keep building the string and add a line break to
 it ---
 /cfloop

 cffile action=write file=#tempfile# output=#output#
 nameconflict=overwrite

 cfmail ...
  !--- not sure how you attach a file offhand, look it up! ---
 /cfmail

 !--- no need to delete the file, because you can choose to overwrite it the
 next time you run the process. Easy to delete tho: ---
 cffile action=delete file=#tempFile#

 Dominic

 -- Blog it up: http://fusion.dominicwatson.co.uk


 

~|
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:297513
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SSL Necessary? Important?

Oh, come on James!  What's a little cannibalism between friends! :o)

 -Original Message-
 From: James Holmes [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 6:44 PM
 To: CF-Talk
 Subject: Re: SSL Necessary? Important?

 Depending on local laws, there are some things to which you simply
 can't agree. For example, I can't agree that you can kill me and cook
 me for dinner tonight - in most locations you are still going to be
 charged with murder, no matter what agreements we had in place.

 On Jan 26, 2008 5:40 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
  I agree to a point, Claude... you're right that anything can
  be overturned, but having a prior agreement is always good to have
  on your side in court.

~|
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:297506
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: DNS Hosting

2008-01-25 Thread Andrew Grosset

HostMySite.com are reliable and give excellent service.

On a connected note it always amazes me how many reqests we get to this list 
looking for cheap hosting, personally I'd rather pay a few dollars more for 
reliablity and better service.

Here's a quote from Internap's (caching page) website:

For some businesses, website downtime translates to millions of dollars of 
lost sales revenue per second, for others it means lost productivity in the 
supply chain.


Andrew Grosset.


 I am looking for recommendations on a company to host our DNS.  We are 
 currently using Internap's CoLocation services and their DNS went down 
 again.  3rd time in less than 2 months.  Our customers are pissed and 
 I don't blame them.  I need to find another solution and always value 
 the recommendations from this list.
 
 Thanks,
 Dave Hatz 


~|
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:297503
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: is it possible to open cfml page from sql server stored procedure?

2008-01-25 Thread Gerald Guido

 i can open sql files and run them by using commands such as the
following:

 EXEC master..xp_cmdshell 'osql -E -i \\mycomputernetworkname
\Driveletter\foldername\testing.sql'

You can do this several ways

You can use EXEC master..xp_cmdshell which I am assuming is  a call the
CMD or windows command shell and use that to call an app that can make a
http call like

Wget
http://www.google.com/search?q=Wgetsourceid=navclient-ffie=UTF-8rlz=1B3GGGL_enUS233US233

or CUrl.
http://curl.haxx.se/

Or you can call the actual CF executable using a bat file and have it run
the script. The last time I saw that done was some 5 years ago on cf 5 so I
am sketchy on the details

I am sure there are other  ways but those are the two that come to mind.

Gerald






~|
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:297501
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: is it possible to open cfml page from sql server stored procedure?

My goal is to run a series of stored procedures. At one point, while I run the 
stored procedures, I need to run coldfusion code which has a cfquery tag and 
some complex if and else conditions which are easier done in coldfusion than 
t-sql.

All I need to do is to open up that page in a browser and since the coldfusion 
code for that page has the queries and other logic which i want to run, it will 
execute that just by opening the url with that .cfm file in a browser.

once that is done, i want to continue on with executing other stored procedures.

so, basically, i want to know if i can open a browser window and call a 
coldfusion page through sql server.

I think the code you have in VBScript might be the solution I am looking for. I 
will try to find out how to call the vbscript through sql.

I will try that and will let you know if I have issues.

I would like to thank all of you for your responses to help me.

DA

- Original Message 
From: Alan Rother [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 4:00:32 PM
Subject: Re: is it possible to open cfml page from sql server stored procedure?

I think to help we may need to know what your goal is. That is to say,
do you want to have SQL Server read the contents of the cfm file
itself, or perhaps the results of the CFM file? Or do you simply need
to fire off some CF process once your SQL Server process has reached a
certain point.

If the last on is the case, then you should be able to have SQL Server
fire off a VB Script the can trigger the CF code. Strangely enough, I
had to be a VBscript do just that today. I don't know offhand how to
make the SQL call the VB, but I do know it can do that.


Here is the VB code I used

URL = http://www.SomeWebsite.com;

Set WshShell = WScript.CreateObject(WScript.Shell)

Set http = CreateObject(Microsoft.XmlHttp)
http.open GET, URL, FALSE
http.send 

set WshShell = nothing
set http = nothing

HTH

=]


-- 
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;160198600;22374440;w

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

Re: zip code range from xls to sql

2008-01-25 Thread morchella

ok i have a .xls
with a field called zip, it will have values like this
43202
43206
43207
43208
43212

in my sql table, i have from_zip ans to_zip.
so i would like to see if the zip in the xls file is concurent, if so
put the lowest value in from  highest value in to. IF NOT just put
from  too to be the same value.
from_zip/to_zip
43202/43202
43206/43208
43212/43212

or
2
3
5
6
7
8
12
22

2-3
5-8
12-12
22-22

then the fun is just beginning, because i will need to see if that
range is already taken in the db, and figure out what to do with the
records that over lap.

~|
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:297490
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: is it possible to open cfml page from sql server stored procedure?

2008-01-25 Thread Alan Rother

I think to help we may need to know what your goal is. That is to say,
do you want to have SQL Server read the contents of the cfm file
itself, or perhaps the results of the CFM file? Or do you simply need
to fire off some CF process once your SQL Server process has reached a
certain point.

If the last on is the case, then you should be able to have SQL Server
fire off a VB Script the can trigger the CF code. Strangely enough, I
had to be a VBscript do just that today. I don't know offhand how to
make the SQL call the VB, but I do know it can do that.


Here is the VB code I used

URL = http://www.SomeWebsite.com;

Set WshShell = WScript.CreateObject(WScript.Shell)

Set http = CreateObject(Microsoft.XmlHttp)
http.open GET, URL, FALSE
http.send 

set WshShell = nothing
set http = nothing

HTH

=]


-- 
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;160198600;22374440;w

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

Re: is it possible to open cfml page from sql server stored procedure?

2008-01-25 Thread Terry Schmitt

You didn't specify the CF version, but for CF6+ use wget or cURL.
In the old days with CF5 (and still for me) you can actually execute the CF 
executable with the page as a parameter.

T
 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql 
 server stored procedure?
 In other words, since cf files don't have a .exe extension, is it 
 possible to open a cfml page from a sql stored procedure?
 
 note: 
 i can open sql files and run them by using commands such as the 
 following:
 
 EXEC master..xp_cmdshell 'osql -E -i 
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'
 
 best regards
 DA
 
 
  
___ 
_
 Never miss a thing.  Make Yahoo your home page. 
 http://www.yahoo.
com/r/hs 

~|
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:297494
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: is it possible to open cfml page from sql server stored procedure?

2008-01-25 Thread Russ

EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm'

 -Original Message-
 From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 4:44 PM
 To: CF-Talk
 Subject: Re: is it possible to open cfml page from sql server stored
 procedure?
 
 Yes, you can use a DTS package to run a script that makes an HTTP call.
 
 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com
 
 Discover Antartica wrote:
  Hello All
  Is there a way to execute a coldfusion file from a microsoft sql server
 stored procedure?
  In other words, since cf files don't have a .exe extension, is it
 possible to open a cfml page from a sql stored procedure?
 
  note:
  i can open sql files and run them by using commands such as the
 following:
 
  EXEC master..xp_cmdshell 'osql -E -i
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'
 
  best regards
  DA
 
 
 
 __
 __
  Never miss a thing.  Make Yahoo your home page.
  http://www.yahoo.com/r/hs
 
 
 
 

~|
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:297488
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: is it possible to open cfml page from sql server stored procedure?

2008-01-25 Thread Cutter (CFRelated)

Yes, you can use a DTS package to run a script that makes an HTTP call.

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Discover Antartica wrote:
 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql server 
 stored procedure?
 In other words, since cf files don't have a .exe extension, is it possible to 
 open a cfml page from a sql stored procedure?
 
 note: 
 i can open sql files and run them by using commands such as the following:
 
 EXEC master..xp_cmdshell 'osql -E -i 
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'
 
 best regards
 DA
 
 
   
 
 Never miss a thing.  Make Yahoo your home page. 
 http://www.yahoo.com/r/hs
 
 

~|
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:297482
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SSL Necessary? Important?

2008-01-25 Thread James Holmes

Depending on local laws, there are some things to which you simply
can't agree. For example, I can't agree that you can kill me and cook
me for dinner tonight - in most locations you are still going to be
charged with murder, no matter what agreements we had in place.

On Jan 26, 2008 5:40 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
 I agree to a point, Claude... you're right that anything can
 be overturned, but having a prior agreement is always good to have
 on your side in court.

 There would have to be gross negligence on a company's part to
 have the prior legal agreement ignored.

 I think everyone in our discussion is right, to a point.

 And, btw, I have no connection to Zillow.com.  I just happened to
 be on that site when the question about liability came up.

 I will say that if I ever do get sued because passwords and usernames
 were stolen from my company and I lost a case because someone's bank
 account was drained because it used the same password and username,
 I would absolutely start forcing my passwords on everyone.

 To this point, I've had no problem.  And we all try to balance
 user-friendliness and security.  But someone is always being bitten.
 Everyone is just playing a game of Russian Roulette and hoping we're
 not the one facing a round in the chamber.

 Rick

  -Original Message-
  From: Claude Schneegans [mailto:[EMAIL PROTECTED]
  Sent: Friday, January 25, 2008 1:36 PM
  To: CF-Talk
  Subject: Re: SSL Necessary? Important?
 
   IN NO EVENT WILL ZILLOW.COM OR ANY SUPPLIER BE LIABLE FOR
  ANY DAMAGES
 
  I'm sorry, but just from the very begining, this statement has
  absolutely no value.
  I hope you didn't pay a lawyer to write it.
 
  Nobody can state, in advance on not that he is not liable or responsible.
  ONLY a judge in court can make this decision, only based on facts.
  If you have been careless in an issue, EVEN if you warned the plaintiff that
  you are not liable, the judge can decide that you are responsible.
 
  The only utility of such notice is may be 1. to make unaware customers
  believe they can't go to court,
  2. to make them do their part about security.
 




 

~|
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:297497
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: is it possible to open cfml page from sql server stored procedure?

I tried the following:
EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm'

I got this error message:
'wget' is not recognized as an internal or external command,
operable program or batch file.


- Original Message 
From: Russ [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 3:24:50 PM
Subject: RE: is it possible to open cfml page from sql server stored procedure?

EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm'

 -Original Message-
 From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 4:44 PM
 To: CF-Talk
 Subject: Re: is it possible to open cfml page from sql server stored
 procedure?
 
 Yes, you can use a DTS package to run a script that makes an HTTP call.
 
 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com
 
 Discover Antartica wrote:
  Hello All
  Is there a way to execute a coldfusion file from a microsoft sql server
 stored procedure?
  In other words, since cf files don't have a .exe extension, is it
 possible to open a cfml page from a sql stored procedure?
 
  note:
  i can open sql files and run them by using commands such as the
 following:
 
  EXEC master..xp_cmdshell 'osql -E -i
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'
 
  best regards
  DA
 
 
 
 __
 __
  Never miss a thing.  Make Yahoo your home page.
  http://www.yahoo.com/r/hs
 
 
 
 



~|
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:297498
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SPAM: Re: is it possible to open cfml page from sql server stored procedure?

2008-01-25 Thread Andy Matthews

You can certainly run CFM pages via their http path. Our dba does that all
the time when he needs to trigger something on the CF side. 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 3:34 PM
To: CF-Talk
Subject: SPAM: Re: is it possible to open cfml page from sql server stored
procedure?

Discover Antartica wrote:
 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql server
stored procedure?
 In other words, since cf files don't have a .exe extension, is it possible
to open a cfml page from a sql stored procedure?

 note: 
 i can open sql files and run them by using commands such as the following:

 EXEC master..xp_cmdshell 'osql -E -i
\\mycomputernetworkname\Driveletter\foldername\testing.sql'

 best regards
 DA

UMMM maybe.  You could possible open the browser executable (ie.exe for
example) with the url to the CFM template is a parameter.  What good this
would do for you I can not imagine.

In other words you are not likely able to do what you are trying to do.  
CFML is not meant to be run outside of a web-server/client environment.

~|
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:297486
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

lsdateformat and dateformat clarification

2008-01-25 Thread Richard White

Hi

i need some clarification on the lsdateformat and dateformat if you can help!

i was under the impression that if i set a locale as English UK and then used 
the follwing code:

lsdateformat(07/24/1978,dd/mm/) that it would convert this date into 
24/07/1978 
but i am getting an error '07/24/1978 is an invalid date format' but if i use 
dateformat instead of lsdateformat then it converts it fine

it seems to me that lsdateformat function takes an english uk formated date 
(dd/mm/) and converts it into the mask that it is set such as mm/dd/ or 
/mm/dd

and it seems that the dateformat function takes a USA formated date 
(mm/dd/) and converts it into the mask that is set such as dd/mm/

i thought that with the lsdateformat i could pass it any formated date and it 
would format it into dd/mm/ format

is my analysis correct of what i now see this does or should it be able to take 
any formated date and convert it into dd/mm/ format

thanks very much for your help. this date conversion problem has caused me a 
headache for a couple of years now and i really need to work it out once and 
for all.

thanks

richard 

~|
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:297487
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: lite spell checker?

Yes, the 6 steps are very clean, it saves time and I appreciate it.
But I'm got an err mgs when attempted to use the checker,

Element DATA_STORAGE_1 is undefined in REQUEST.

I was wondering about that when edited the spellchecker.cfm file per
instruction, where's the {DATA_STORAGE_1} var defined? but thought maybe, some
other script addresses it...

Also, I used,
cfform ...
cfinput type=button name=speller value=Check Spell
onclick=javascript:#ajaxlink('../CFIDE/scripts/ajax/FCKeditor/editor/dialog/fck_spellerpages/spellerpages/server-scripts/spellchecker.cfm')#
/cfform
to call the spellchecker. What is supposed to be the proper way to call the
speller? Does it need a param/argument to feed it?

Thanks.

-- free is never free
ASpell is the spelling 'core', but you need the javascript/CF page, that
calls the Aspell system.

http://spellerpages.sourceforge.net/

Actually, to make things easier, this guy put out a step by step that you
could follow.

http://www.fantasy-league.com/coldfusion/fckeditor/
Where it refers to pages in the 'fck_spellerpages' directory, just change
the files that are in your spellerpages directory.

Hope this helps,

William

--
William E. Seiter

Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove

Web Developer
http://William.Seiter.com

~|
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:297484
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFHTTP.Filecontent on left side of an assignment

You're going to have to work around it.  Either by setting cfset somevar =
test.filecontent or otherwise.

On Jan 25, 2008 3:19 PM, Jim McAtee [EMAIL PROTECTED] wrote:

 Yes, it exists.  It fails using either cfhttp.filecontent or some variable
 designated through the restults attribute.


~|
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:297502
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: is it possible to open cfml page from sql server stored procedure?

I would think it should be able to.  Pydu
EXEC master..xp_cmdshell '{yourBrowserExecutable.exe} then 
{yourCFtemplatePath/yourCFtemplate.cfm}'

Have not tried it myself, but I really don't see any reason why not other than 
security. 

 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql 
 server stored procedure?
 In other words, since cf files don't have a .exe extension, is it 
 possible to open a cfml page from a sql stored procedure?
 
 note: 
 i can open sql files and run them by using commands such as the 
 following:
 
 EXEC master..xp_cmdshell 'osql -E -i 
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'
 
 best regards
 DA
 
 
  
___ 
_
 Never miss a thing.  Make Yahoo your home page. 
 http://www.yahoo.
com/r/hs 

~|
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:297485
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

is it possible to open cfml page from sql server stored procedure?

Hello All
Is there a way to execute a coldfusion file from a microsoft sql server stored 
procedure?
In other words, since cf files don't have a .exe extension, is it possible to 
open a cfml page from a sql stored procedure?

note: 
i can open sql files and run them by using commands such as the following:

EXEC master..xp_cmdshell 'osql -E -i 
\\mycomputernetworkname\Driveletter\foldername\testing.sql'

best regards
DA


  

Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs

~|
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:297474
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: quot;zip codequot; range from xls to sql

I don't understand the business logic of 
from_zip  to_zip
20106 20106
 
(same value for from and to).

But sql-wise, it would be real simple, once you 
1) finish import the excel into a db table, your table may look like this:
zipTbl
zipFrom
20106
22002


Then 
2) alter your zipTbl by adding another column/field of zipTo;
3) then just run an update statement like this
update zipTbl
set zipTo = zipFrom;

It should do it unless I misunderstood your question.

hey guys!
i need a little sql help/advice.

i have a table that has 2 columns
from_zip
to_zip


i get xls files from people in the office with massive zip entries.
like:
Zip Code
20106
22002
22401
22402
22404
22407
22408
22412

i want to go through this file and create the from/to fields...
from_zip  to_zip
20106 20106
22002 22002
22401 22402
22404 22404
22407 22408

where do i start
i can import the xls as a new table in sql server.
then i would like to great a view to do the from to by a id that i have...
not sure if i am explaining this right at all...

thanks for your help..
-m 

~|
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:297466
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: date problem

2008-01-25 Thread Richard White

Hi,

none of these suggestions are working we have the set locale setup in the 
application page, we have even tried to put it in the onrequest function
 
cfset SetLocale(English (UK))

then we are simply trying to run this following code to test it and it is not 
working:
cfset dateV = lsdateformat(07/24/1978, dd/mm/)


the error is:

07/24/1978 is an invalid date format

does anyone have any other ideas?

thanks for any help



~|
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:297483
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFHTTP.Filecontent on left side of an assignment

I confirmed the same error:

cfhttp url=http://www.web-rat.com/; result=test
cfset test.filecontent = replace(test.filecontent,'Todd
Rafferty','Goober','ALL')
cfdump var=#test#

Easy work around, but it appears to be a bug.  Unless test is no longer a
true structure anymore.

On Jan 25, 2008 2:51 PM, Jim McAtee [EMAIL PROTECTED] wrote:

  I'm getting an error in CF8 when I attempt to alter the contents of the
  filecontent key of a struct returned by CFHTTP.  This worked fine in
  CF5.
  I can easily fix it, but what's the reason for the error?  There's not
  much to go on in the debugging output.
 
  The code:
 
  cfhttp url=.com/test2.cfm result=test
  cfset test.filecontent = Replace(test.filecontent, a, b, all)
 
  The error:
 
  12:41:30.030 - java.lang.NoSuchFieldException - in D:\web\dev5\test1.cfm
  :
  line 13
 FILECONTENT
  While this statement is ok:cfset s = Replace(test.filecontent, a,
  b,
  all)
 



~|
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:297470
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

2008-01-25 Thread Will Swain

Have you tried connecting and downloading the file with an FTP client rather
than CF? 

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: 25 January 2008 18:47
To: CF-Talk
Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?

Yes, to both questions.

I'm not sure if the settings were correct, but I tried setting the scheduled
task's timeout to  seconds.

Then I tried adding cfsetting timeoutRequest= to the template, but
neither seemed to have an effect.

But also, if the problem is not with CFHTTP, why would the scheduler log so
it was?

???

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 12:44 PM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?

  No matter how I run it, I get the same error...

  - Automated Scheduled Task
  - Manual Test Run of Scheduled Task
  - Run template directly in browser

 Then your problem isn't with CFHTTP, it's with the file. Have you set 
 the TIMEOUT attribute for CFFTP? Have you also set the page timeout 
 using CFSETTING?

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized 
 instruction at our training centers in Washington DC, Atlanta, 
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

~|
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:297469
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SQL Question -- Order by a column's value?

Che Vilnonis wrote:
 I was trying to do that w/o adding another column. Can it be done? 
Yes, see Crow's, Charlie's or my post on using CASE to create an inline 
sort column with SQL.



~|
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:297467
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

Yes, I established an mapped FTP resource into Windows Explorer
and I can grab files from the remote server.

I can login to the remote server via ftp in Windows Explorer.

No problems anywhere, but with CFFTP.

I just need to get around the CFHTTP page timeout.  And there
should be a way to use the CFFTP tag without having to resort to
jumping through a lot of hoops using third-party software and
contorted methods.

Why won't the tag just work?


 -Original Message-
 From: Will Swain [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 3:11 PM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
 
 Have you tried connecting and downloading the file with an FTP client rather
 than CF?
 
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: 25 January 2008 18:47
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
 Yes, to both questions.
 
 I'm not sure if the settings were correct, but I tried setting the scheduled
 task's timeout to  seconds.
 
 Then I tried adding cfsetting timeoutRequest= to the template, but
 neither seemed to have an effect.
 
 But also, if the problem is not with CFHTTP, why would the scheduler log so
 it was?
 
 ???
 
 
  -Original Message-
  From: Dave Watts [mailto:[EMAIL PROTECTED]
  Sent: Friday, January 25, 2008 12:44 PM
  To: CF-Talk
  Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
   No matter how I run it, I get the same error...
  
   - Automated Scheduled Task
   - Manual Test Run of Scheduled Task
   - Run template directly in browser
 
  Then your problem isn't with CFHTTP, it's with the file. Have you set
  the TIMEOUT attribute for CFFTP? Have you also set the page timeout
  using CFSETTING?




~|
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:297480
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Jim McAtee

I'm getting an error in CF8 when I attempt to alter the contents of the 
filecontent key of a struct returned by CFHTTP.  This worked fine in CF5. 
I can easily fix it, but what's the reason for the error?  There's not 
much to go on in the debugging output.

The code:

cfhttp url=.com/test2.cfm result=test
cfset test.filecontent = Replace(test.filecontent, a, b, all)

The error:

12:41:30.030 - java.lang.NoSuchFieldException - in D:\web\dev5\test1.cfm : 
line 13
FILECONTENT
While this statement is ok:cfset s = Replace(test.filecontent, a, b, 
all) 


~|
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:297465
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

 I'm not sure if the settings were correct, but I tried 
 setting the scheduled task's timeout to  seconds.
 
 Then I tried adding cfsetting timeoutRequest= to the 
 template, but neither seemed to have an effect.

How many seconds does it run before failing?

 But also, if the problem is not with CFHTTP, why would the 
 scheduler log so it was?

Because the scheduler uses CFHTTP to call your page. If your page times out,
CFHTTP doesn't get a response back, and that's an error.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
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:297462
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

zip code range from xls to sql

2008-01-25 Thread morchella

hey guys!
i need a little sql help/advice.

i have a table that has 2 columns
from_zip
to_zip


i get xls files from people in the office with massive zip entries.
like:
Zip Code
20106
22002
22401
22402
22404
22407
22408
22412

i want to go through this file and create the from/to fields...
from_zip  to_zip
20106 20106
22002 22002
22401 22402
22404 22404
22407 22408

where do i start
i can import the xls as a new table in sql server.
then i would like to great a view to do the from to by a id that i have...
not sure if i am explaining this right at all...

thanks for your help..
-m

~|
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:297458
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SQL Question -- Order by a column's value?

2008-01-25 Thread Che Vilnonis

Cool. That did the trick. Thanks to all! 

-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 2:08 PM
To: CF-Talk
Subject: RE: SQL Question -- Order by a column's value?

Yes, you can do this with a CASE statement.  The syntax may depend on you
db, but on SQL Server

ORDER BY 
CASE Colleges 
WHEN 'Harvard' THEN 1
WHEN 'Princeton' THEN 2
WHEN 'Dartmouth' THEN 3
ELSE 100
END

This would put those three colleges in that order, and all others would go
after them.  To be smart you should add another ORDER BY field to sort all
of the ones that hit the default case in some way (so, sort by the CASE
statement, then by the Colleges field).

Thanks
Mark

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 1:41 PM
To: CF-Talk
Subject: OT: SQL Question -- Order by a column's value?

Suppose I have a small set of data with a column named Colleges. Is there
a way to write an ORDER BY statement to say something like...
ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

Just wondering... Che

~|
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:297463
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SQL Question -- Order by a column's value?

Sorry, add sort_order column and then do an ORDER BY sort_order and set all
the colleges in the appropriate sorting that you want it to be.

On Jan 25, 2008 1:49 PM, Todd [EMAIL PROTECTED] wrote:


 Nope, add a sort_order column and sort your colleges appropriately.


 On Jan 25, 2008 1:41 PM, Che Vilnonis [EMAIL PROTECTED] wrote:

  Suppose I have a small set of data with a column named Colleges. Is
  there
  a way to write an ORDER BY statement to say something like...
  ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges
  'Dartmouth'???
 
  Just wondering... Che


http://www.web-rat.com/


~|
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:297451
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SQL Question -- Order by a column's value?

Nope, add a sort_order column and sort your colleges appropriately.

On Jan 25, 2008 1:41 PM, Che Vilnonis [EMAIL PROTECTED] wrote:

 Suppose I have a small set of data with a column named Colleges. Is
 there
 a way to write an ORDER BY statement to say something like...
 ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

 Just wondering... Che


~|
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:297450
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SSL Necessary? Important?

2008-01-25 Thread Claude Schneegans

 IN NO EVENT WILL ZILLOW.COM OR ANY SUPPLIER BE LIABLE FOR
ANY DAMAGES

I'm sorry, but just from the very begining, this statement has 
absolutely no value.
I hope you didn't pay a lawyer to write it.

Nobody can state, in advance on not that he is not liable or responsible.
ONLY a judge in court can make this decision, only based on facts.
If you have been careless in an issue, EVEN if you warned the plaintiff that
you are not liable, the judge can decide that you are responsible.

The only utility of such notice is may be 1. to make unaware customers 
believe they can't go to court,
2. to make them do their part about security.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
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:297448
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SSL Necessary? Important?

I can assure you that I'm not your wife and there are some areas where I'm
very cut to the chase and other areas where I have learned to be more
flexible I guess. :)

On Jan 25, 2008 11:40 AM, Rick Faircloth wrote:

 You sound like my wife who's always telling me to be more civil and stop
 that my way or the highway kind of talk when I discuss issues.  It's not
 that it's my way or the highway, I just tend to cut to the chase in
 getting
 to the bottom line and not phrasing my position very diplomatically.



~|
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:297444
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

No matter how I run it, I get the same error...

- Automated Scheduled Task
- Manual Test Run of Scheduled Task
- Run template directly in browser

Is there some other way to run a template that I'm missing?

It just seems crazy to design a tag that allows one type of
functionality, but is limited in achieving that functionality
because of dependencies...

Is there an example somewhere of successful use of GetFile
using the CFFTP tag for files that take longer than a usual
browser timeout?

Rick


 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 11:24 AM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
  But how would one even use CFFTP if it always depends on
  CFHTTP for functionality?
 
 CFFTP does not depend on CFHTTP. Scheduled tasks do. If you run the page
 yourself, CFHTTP will not be used.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

~|
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:297442
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF App throwing Access access error

2008-01-25 Thread Gerald Guido

I remember this. We used to fix it by running a query with a syntax error on
the database. For some reason it will unlock the database.

On Jan 25, 2008 11:37 AM, Adkins, Randy [EMAIL PROTECTED] wrote:

 It is probably locked by the Datasource connection from CF Admin


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

 Sent: Friday, January 25, 2008 11:35 AM
 To: CF-Talk
 Subject: CF App throwing Access access error

 Everyone is logged out, and there's no lock on the access file.
 This error still persits.  Any ideas?  I've seen this a long time ago
 clear when I rebotted the machine the Access file was located on.

 Any ideas?

 Error Executing Database Query.
 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] The Microsoft Jet database engine cannot open
 the file apos;(unknown)apos;. It is already opened exclusively by
 another user, or you need permission to view its data.



 

~|
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:297438
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SSL Necessary? Important?

Here's some of the Terms for use of Zillow.com... a Real Estate listing
website.

9. LIABILITY LIMITATION; EXCLUSIVE REMEDY. IN NO EVENT WILL ZILLOW.COM OR ANY 
SUPPLIER BE LIABLE FOR
ANY DAMAGES, INCLUDING WITHOUT LIMITATION ANY INDIRECT, CONSEQUENTIAL, SPECIAL, 
INCIDENTAL, OR
PUNITIVE DAMAGES ARISING OUT OF, BASED ON, OR RESULTING FROM THESE TERMS OF USE 
OR YOUR USE OF THE
SERVICES, EVEN IF SUCH PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH 
DAMAGES. THE EXCLUSION OF
DAMAGES UNDER THIS PARAGRAPH IS INDEPENDENT OF YOUR EXCLUSIVE REMEDY AND 
SURVIVES IN THE EVENT SUCH
REMEDY FAILS OF ITS ESSENTIAL PURPOSE OR IS OTHERWISE DEEMED UNENFORCEABLE. 
THESE LIMITATIONS AND
EXCLUSIONS APPLY WITHOUT REGARD TO WHETHER THE DAMAGES ARISE FROM (A) BREACH OF 
CONTRACT, (B) BREACH
OF WARRANTY, (C) NEGLIGENCE, OR (D) ANY OTHER CAUSE OF ACTION, TO THE EXTENT 
SUCH EXCLUSION AND
LIMITATIONS ARE NOT PROHIBITED BY APPLICABLE LAW. IF YOU DO NOT AGREE WITH ANY 
PART OF THESE TERMS
OF USE, OR YOU HAVE ANY DISPUTE OR CLAIM AGAINST ZILLOW.COM OR ITS SUPPLIERS 
WITH RESPECT TO THESE
TERMS OF USE OR THE SERVICES, THEN YOUR SOLE AND EXCLUSIVE REMEDY IS TO 
DISCONTINUE USING THE
SERVICES.

Now that pretty iron-clad legally, I think, that no matter what you do,
password or other-wise, they're not going to pay for it. Quite
bottom-line, my way or the highway, especially that last clause...



 -Original Message-
 From: Todd [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 11:04 AM
 To: CF-Talk
 Subject: Re: SSL Necessary? Important?
 
 Rick,
 
 I get it.  I do.  What I'm suggesting is instead of cramming down a password
 down the throat to use clearly written english description of what a STRONG
 password would be and to use validation to determine what's a strong / weak
 passwords.  There's plenty of javascript / serverside validation methods for
 doing this, it doesn't take that long to write a custom one.  I wrote a
 custom one that I thought was pretty good until I came across a password
 issue that I had to debug and during that time, I realized that the client
 was using their email address as a password so I beefed up my validation
 even more and wrote another bullet of you can't use (first name, last name,
 email address, phone number, etc).
 
 People do the damndest things and they don't think about their own security
 sometimes, but I would still rather write the rules up and enforce those
 rules than say my way or the highway.  When I come across issues like
 that, I have a 2 simple little actions in my admin 1.) Force new password
 upon next login or 2.) Send new random strong password now and make them
 change it upon next login.
 
 I want them to be educated and use a strong password that they're going to
 remember and they're not going to write it down on a slip of paper because I
 won't let them change it otherwise.  Anyway, we'll just agree to disagree.
 It's ok.  Two very valid opinions.
 
 ~Todd
 
 On Jan 25, 2008 10:43 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
 
  I don't see anywhere in those terms that a lawyer could *without a doubt*
  use to hold Google harmless if Google's servers were hacked (their fault)
  and a client's login info stolen and used to access a bank account.
 
  I think a jury would see Google as liable for their failed security.
  But I'm no lawyer...
 
  I do however, begin to get concerned when clients want their personal data
  secured that a weak password could come back to bite them and me as
  well.
  The weak password, it would seem to me, would have to be the result of a
  user's sole choice, bypassing all guidance and cautions that I provide,
  including
  a strong password option.
 
  It is an interesting discussion.  As my clients become more widespread and
  less
  personal, the chance of lawsuits increases.
 
  Just want to protect my assets...
 
  Rick
 
 
 
 

~|
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:297439
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF App throwing Access access error

2008-01-25 Thread ColdFusion

Similar to:  select no_field from no_table thus would kill the ldb locking
file

-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 11:59 AM
To: CF-Talk
Subject: Re: CF App throwing Access access error

I remember this. We used to fix it by running a query with a syntax error on
the database. For some reason it will unlock the database.

On Jan 25, 2008 11:37 AM, Adkins, Randy [EMAIL PROTECTED] wrote:

 It is probably locked by the Datasource connection from CF Admin

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

 Sent: Friday, January 25, 2008 11:35 AM
 To: CF-Talk
 Subject: CF App throwing Access access error

 Everyone is logged out, and there's no lock on the access file.
 This error still persits.  Any ideas?  I've seen this a long time ago
 clear when I rebotted the machine the Access file was located on.

 Any ideas?

 Error Executing Database Query.
 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] The Microsoft Jet database engine cannot open
 the file apos;(unknown)apos;. It is already opened exclusively by
 another user, or you need permission to view its data.

~|
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:297440
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 App throwing Access access error

2008-01-25 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]

Thanks. I don't think that's it. It's worked for weeks and today I rebooted
the machine CF is on and still I ge the error.

It is probably locked by the Datasource connection from CF Admin



~|
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:297435
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SSL Necessary? Important?

You sound like my wife who's always telling me to be more civil and stop
that my way or the highway kind of talk when I discuss issues.  It's not
that it's my way or the highway, I just tend to cut to the chase in getting
to the bottom line and not phrasing my position very diplomatically.

Besides, I've only had half a cup of coffee this morning at this point.  :o| 
(Aaarf!)

Anyway, the problem with strong passwords is they're not easily, if at all,
memorable.  I'd rather a user have strong passwords, different ones for every
instance where they need one, and write them down (preferably not on a 
post-it-note
on the screen ;o) where they can access them, than to try to remember all the
passwords they use, which can literally be hundreds, these days.

The biggest danger is not when someone robs their home (don't put the bank 
account
passwords on paper), but hackers gaining access via email snooping, intercepting
data flow, or breaking into companies that maintain confidential data.

At least if someone breaks into my home, I know that my passwords are 
compromised.
If they just get the info from an online account, I wouldn't have a clue for 
awhile.

Rick

 -Original Message-
 From: Todd [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 11:04 AM
 To: CF-Talk
 Subject: Re: SSL Necessary? Important?
 
 Rick,
 
 I get it.  I do.  What I'm suggesting is instead of cramming down a password
 down the throat to use clearly written english description of what a STRONG
 password would be and to use validation to determine what's a strong / weak
 passwords.  There's plenty of javascript / serverside validation methods for
 doing this, it doesn't take that long to write a custom one.  I wrote a
 custom one that I thought was pretty good until I came across a password
 issue that I had to debug and during that time, I realized that the client
 was using their email address as a password so I beefed up my validation
 even more and wrote another bullet of you can't use (first name, last name,
 email address, phone number, etc).
 
 People do the damndest things and they don't think about their own security
 sometimes, but I would still rather write the rules up and enforce those
 rules than say my way or the highway.  When I come across issues like
 that, I have a 2 simple little actions in my admin 1.) Force new password
 upon next login or 2.) Send new random strong password now and make them
 change it upon next login.
 
 I want them to be educated and use a strong password that they're going to
 remember and they're not going to write it down on a slip of paper because I
 won't let them change it otherwise.  Anyway, we'll just agree to disagree.
 It's ok.  Two very valid opinions.
 
 ~Todd
 
 On Jan 25, 2008 10:43 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
 
  I don't see anywhere in those terms that a lawyer could *without a doubt*
  use to hold Google harmless if Google's servers were hacked (their fault)
  and a client's login info stolen and used to access a bank account.
 
  I think a jury would see Google as liable for their failed security.
  But I'm no lawyer...
 
  I do however, begin to get concerned when clients want their personal data
  secured that a weak password could come back to bite them and me as
  well.
  The weak password, it would seem to me, would have to be the result of a
  user's sole choice, bypassing all guidance and cautions that I provide,
  including
  a strong password option.
 
  It is an interesting discussion.  As my clients become more widespread and
  less
  personal, the chance of lawsuits increases.
 
  Just want to protect my assets...
 
  Rick
 
 
 
 

~|
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:297437
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 App throwing Access access error

2008-01-25 Thread Adkins, Randy

It is probably locked by the Datasource connection from CF Admin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Friday, January 25, 2008 11:35 AM
To: CF-Talk
Subject: CF App throwing Access access error

Everyone is logged out, and there's no lock on the access file.
This error still persits.  Any ideas?  I've seen this a long time ago
clear when I rebotted the machine the Access file was located on.

Any ideas? 

Error Executing Database Query. 
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] The Microsoft Jet database engine cannot open
the file apos;(unknown)apos;. It is already opened exclusively by
another user, or you need permission to view its data. 

~|
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:297434
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT: SSL Necessary? Important?

2008-01-25 Thread Russ

I'd like to see some proof of this.  Is this only with wildcard certs (in
which case it would only work for *.domainname.com), or it is for any kind
of cert (such that you can have www.example.com and www.example2.com) on the
same IP with no SSL problems? 

Russ



 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Thursday, January 24, 2008 7:09 PM
 To: CF-Talk
 Subject: RE: OT: SSL Necessary? Important?
 
  typically no, because virtual hosting relies on host
  headers.  The web server doesn't receive the headers until
  after the connection is established.
 
 This appears to no longer be the case with IIS 6, at least. To be honest,
 I'm not exactly sure how this works with IIS 6, but it appears that you
 can
 have multiple virtual servers sharing the same IP address for SSL/TLS.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

~|
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:297431
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SSL Necessary? Important?

Rick,

I get it.  I do.  What I'm suggesting is instead of cramming down a password
down the throat to use clearly written english description of what a STRONG
password would be and to use validation to determine what's a strong / weak
passwords.  There's plenty of javascript / serverside validation methods for
doing this, it doesn't take that long to write a custom one.  I wrote a
custom one that I thought was pretty good until I came across a password
issue that I had to debug and during that time, I realized that the client
was using their email address as a password so I beefed up my validation
even more and wrote another bullet of you can't use (first name, last name,
email address, phone number, etc).

People do the damndest things and they don't think about their own security
sometimes, but I would still rather write the rules up and enforce those
rules than say my way or the highway.  When I come across issues like
that, I have a 2 simple little actions in my admin 1.) Force new password
upon next login or 2.) Send new random strong password now and make them
change it upon next login.

I want them to be educated and use a strong password that they're going to
remember and they're not going to write it down on a slip of paper because I
won't let them change it otherwise.  Anyway, we'll just agree to disagree.
It's ok.  Two very valid opinions.

~Todd

On Jan 25, 2008 10:43 AM, Rick Faircloth [EMAIL PROTECTED] wrote:

 I don't see anywhere in those terms that a lawyer could *without a doubt*
 use to hold Google harmless if Google's servers were hacked (their fault)
 and a client's login info stolen and used to access a bank account.

 I think a jury would see Google as liable for their failed security.
 But I'm no lawyer...

 I do however, begin to get concerned when clients want their personal data
 secured that a weak password could come back to bite them and me as
 well.
 The weak password, it would seem to me, would have to be the result of a
 user's sole choice, bypassing all guidance and cautions that I provide,
 including
 a strong password option.

 It is an interesting discussion.  As my clients become more widespread and
 less
 personal, the chance of lawsuits increases.

 Just want to protect my assets...

 Rick



~|
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:297427
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

Thanks for the insight, Dave...

But how would one even use CFFTP if it always depends on
CFHTTP for functionality?

Also (to Tom, too), I tried to set the timeout in the scheduled
task to 9, but that had no effect.

It just seems that if CFFTP is always dependent upon CFHTTP, and
CFHTTP is always going to have timeout issues, that CFFTP is useless.
Aren't *all* CF pages dependent upon HTTP?

There has got to be a setting or something that will allow CFFTP
to function properly.

Rick

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 10:04 AM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
  I get about 4 MB of a 25 MB file each time then my scheduled
  task, whether I let the scheduler run it or manually trigger
  the scheduled task, or even if I run the template directly in
  the browser, I get an error from the scheduler log that says
  I had a cfhttp timeout error.
 
  Why is cfhttp involved?  Implicitly?
 
 Scheduled tasks are run using CFHTTP. I would recommend that you consider
 another way to automate this task. For example, you can automate FTP using
 the operating system scheduler and almost any FTP client.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

~|
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:297425
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

logger.xml usage in ColdFusion 7

2008-01-25 Thread Matt Sanders

I am attempting to use the logger.xml file, as documented here
(http://kb.adobe.com/selfservice/viewContent.do?externalId=94a16ba6sliceId=1)
to customize the behavior of the cflog tag. I would like to use the
various appenders made available by Log4J to output log statements to
other locations in addition to the standard log files. However, there
appears to be no documentation on how to use the logger.xml file.

So the first question I have is, does ColdFusion actually use the
logger.xml file?
Then, if so, how would one go about adding an appender to one of the
'categories' used by ColdFusion to get the log statement sent to, say
a syslog server (SyslogAppender) in addition to the normal log file?

Any advice or insight would be greatly appreciated.

Thanks,
Matt Sanders

~|
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:297423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cybersource Gateway Solution Found For ColdFusion

2008-01-25 Thread Jay Lee

Philip, 
If you are willing to share your code, please email me at [EMAIL PROTECTED]   
Thanks,
JL

 Philip,
 
 I have just been asked to interface one of our apps with Cybersource.  
 I would greatly appreciate any code that you have to share.
 
 Thanks.
 JL
 
 If anybody is interested I did find information on how to use  
 ColdFusion to access the CyberSource Credit Card Gateway.  I'll be  
 happy to send you my sample code if you need it.  Works like a charm. 


~|
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:297419
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

 I get about 4 MB of a 25 MB file each time then my scheduled 
 task, whether I let the scheduler run it or manually trigger 
 the scheduled task, or even if I run the template directly in 
 the browser, I get an error from the scheduler log that says 
 I had a cfhttp timeout error.
 
 Why is cfhttp involved?  Implicitly?

Scheduled tasks are run using CFHTTP. I would recommend that you consider
another way to automate this task. For example, you can automate FTP using
the operating system scheduler and almost any FTP client.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
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:297418
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SSL Necessary? Important?

Would you consider gmail to be pretty important if you used it daily like I
do?  Let's take a look at what Google says in their EULA:

=
6. Your passwords and account security

6.1 You agree and understand that you are responsible for maintaining the
confidentiality of passwords associated with any account you use to access
the Services.

6.2 Accordingly, you agree that you will be solely responsible to Google for
all activities that occur under your account.

6.3 If you become aware of any unauthorized use of your password or of your
account, you agree to notify Google immediately at [snipped URL].
=

I don't remember that gmail had very strict password rules.  Yet their
legalese basically negates the need since they pretty much label you
responsible for everything that happens under your account.  If my bank gets
hacked because I use my same username / password as my gmail and it was
obtained via gmail somehow, does that legalese mean Google is in the clear?

~Todd

On Jan 25, 2008 9:17 AM, Rick Faircloth [EMAIL PROTECTED] wrote:

 Well, I was just kinda giving the bottom line.  Of course, in the real
 world, a much kinder, gentler way of saying it would be appropriate.

 I can also compromise by letting you choose your password, but stipulate
 that it require one or more of certain characters, a mix of caps and lower
 case, etc.,
 or I can allow you to choose your own password without any stipulations,
 but you have to sign a waiver holding me harmless.

 I don't see that as unreasonable.  You get to decide how to handle your
 password, if you like, but you just can't blame me in the case of a poor
 choice which leads to your ruin.  I'm not going down with you...

 I think that's fair.

 I'll be most EUA's have something like that buried in their legalize.

 Thoughts?

 Rick


~|
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:297417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Why would I get a cfhttp timeout on this cfftp operation?

Rick, I made a mistake in my previous email.  I meant url?RequestTimeOut=x

Alternatively:
cfsetting requestTimeOut = *value in seconds*

On Jan 25, 2008 9:05 AM, Rick Faircloth [EMAIL PROTECTED] wrote:

 Hi, all.

 Throwing this problem out again with the code I'm running.

 I get about 4 MB of a 25 MB file each time then my scheduled task,
 whether I let the scheduler run it or manually trigger the scheduled task,
 or even if I run the template directly in the browser, I get an error
 from the scheduler log that says I had a cfhttp timeout error.

 Why is cfhttp involved?  Implicitly?
 Do I need to add a cfhttp tag around this with a long timeout or
 something?

 Anyway, here's the code. insights anyone?

 Thanks!

 Rick

 cfftp connection=12345
server=sql.x.com
username=
password=
action=Open
stoponerror=Yes

 cfftp connection=12345
passive=yes
action=GetFile
remoteFile=/Data/New_Data_Format/actives/Actives_10.zip
localFile=E:\x\Active_10.zip

 cfftp action=close connection=gamls


~|
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:297416
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Why would I get a cfhttp timeout on this cfftp operation?

Hi, all.

Throwing this problem out again with the code I'm running.

I get about 4 MB of a 25 MB file each time then my scheduled task,
whether I let the scheduler run it or manually trigger the scheduled task,
or even if I run the template directly in the browser, I get an error
from the scheduler log that says I had a cfhttp timeout error.

Why is cfhttp involved?  Implicitly?
Do I need to add a cfhttp tag around this with a long timeout or something?

Anyway, here's the code. insights anyone?

Thanks!

Rick

cfftp connection=12345
server=sql.x.com
username=
password=
action=Open
stoponerror=Yes

cfftp connection=12345   
passive=yes
action=GetFile
remoteFile=/Data/New_Data_Format/actives/Actives_10.zip
localFile=E:\x\Active_10.zip

cfftp action=close connection=gamls




~|
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:297414
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SSL Necessary? Important?

Rick, is it really not possible to compromise?  It's one thing to enforce
and shove a password down my throat... it's something else to educate the
end-user on what a strong password is.

On Jan 25, 2008 8:46 AM, Rick Faircloth [EMAIL PROTECTED] wrote:

 No problem... if you won't let me choose your password to make sure
 you and I are both protected, then you have to agree not to hold me
 accountable for any problems that occur as a result of your weak
 password.  Accept a strong password, or sign a waiver... simple.



~|
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:297413
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SSL Necessary? Important?

No problem... if you won't let me choose your password to make sure
you and I are both protected, then you have to agree not to hold me
accountable for any problems that occur as a result of your weak
password.  Accept a strong password, or sign a waiver... simple.

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 8:20 AM
 To: CF-Talk
 Subject: Re: SSL Necessary? Important?

 On 1/24/08, Rick Faircloth [EMAIL PROTECTED] wrote:
  One solution that I have used is to allow users to choose their username,
  usually just their email address, but I force a very strong password
  on them generated with CF.

 Nothing annoys me more, personally, than a web site that won't let me
 choose my own password.  Such sites are rare, thank god.

 But second on the list of annoying password things is password rules
 that don't make sense to me or seem random. One bank says your
 password cannot end in a number.  Another says you have to have two
 numbers.

 Then you get the sites that don't LET you use special characters.
 That *REALLY* annoys me.  Nothing worse than a web site that forces
 you to lower your password strength to fit their rules.

 And finally, I deal with one company that forces your password to all
 lower case.  PSNC Energy does that.  Incredibly lame.

 --
 Rick Root
 New Brian Vander Ark Album, songs in the music player and cool behind
 the scenes video at www.myspace.com/brianvanderark

~|
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:297412
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Limit on cfftp getfile file size?

 but I can't help on this one guy.

Well, now I'm just going to shut down my servers... all is lost...  ;o)

 -Original Message-
 From: Will Tomlinson [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 6:02 AM
 To: CF-Talk
 Subject: Re: Limit on cfftp getfile file size?

 Suggestions?

 I'm even open to hear what Will has to say! :o)

 Rick

 I just accidentally ran across this thread. Figured maybe you were tryin to 
 use the cftable
 tag in conjuction with cfftp. :)

 Anyway, I know it's hard to believe, but I have never used the cfftp tag 
 before. Not one time.
 I know I'm usually lots of help to you, but I can't help on this one guy.

 Will

~|
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:297410
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SPAM: Re: is it possible to open cfml page from sql server stored procedure?

Would you be able to send me the command your dba uses to open a http page 
through sql?

- Original Message 
From: Andy Matthews [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 3:04:17 PM
Subject: RE: SPAM: Re: is it possible to open cfml page from sql server stored 
procedure?

You can certainly run CFM pages via their http path. Our dba does that all
the time when he needs to trigger something on the CF side. 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 3:34 PM
To: CF-Talk
Subject: SPAM: Re: is it possible to open cfml page from sql server stored
procedure?

Discover Antartica wrote:
 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql server
stored procedure?
 In other words, since cf files don't have a .exe extension, is it possible
to open a cfml page from a sql stored procedure?

 note: 
 i can open sql files and run them by using commands such as the following:

 EXEC master..xp_cmdshell 'osql -E -i
\\mycomputernetworkname\Driveletter\foldername\testing.sql'

 best regards
 DA

UMMM maybe.  You could possible open the browser executable (ie.exe for
example) with the url to the CFM template is a parameter.  What good this
would do for you I can not imagine.

In other words you are not likely able to do what you are trying to do.  
CFML is not meant to be run outside of a web-server/client environment.

~|
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:297500
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SSL Necessary? Important?

2008-01-25 Thread James Holmes

Yes, wildcard certs work fine under Apache too.

On Jan 26, 2008 2:20 AM, Dave Watts [EMAIL PROTECTED] wrote:
  I'd like to see some proof of this.  Is this only with
  wildcard certs (in which case it would only work for
  *.domainname.com), or it is for any kind of cert (such that
  you can have www.example.com and www.example2.com) on the
  same IP with no SSL problems?

 Wildcard certs only. I neglected to mention that in my initial response, but
 added it in a followup.

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
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:297489
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: lite spell checker?

2008-01-25 Thread William Seiter

ASpell is the spelling 'core', but you need the javascript/CF page, that
calls the Aspell system.

http://spellerpages.sourceforge.net/

Actually, to make things easier, this guy put out a step by step that you
could follow.

http://www.fantasy-league.com/coldfusion/fckeditor/
Where it refers to pages in the 'fck_spellerpages' directory, just change
the files that are in your spellerpages directory.

Hope this helps,


William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer 
http://William.Seiter.com

-Original Message-
From: Don L [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 7:28 AM
To: CF-Talk
Subject: Re: lite spell checker?

William, I'm getting there... 
downloaded, installed, reading up usage instruction (I'm on Windows platform
too),
my specific use of it: run it for a CFFORM cftextarea element.
so, 
how's the run-with-aspell command?
how to call this speller, cfexecute? 
or ?
Pls give me a path it would save me time, many thanks.

Don
Once I found the right download ... 

Aspell downloaded and installed very quickly.  I was using a Microsoft
server, so it was as simple as an exe file.

http://aspell.net/man-html/Installing.html#Installing

william

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove




~|
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:297471
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: is it possible to open cfml page from sql server stored procedure?

Discover Antartica wrote:
 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql server 
 stored procedure?
 In other words, since cf files don't have a .exe extension, is it possible to 
 open a cfml page from a sql stored procedure?

 note: 
 i can open sql files and run them by using commands such as the following:

 EXEC master..xp_cmdshell 'osql -E -i 
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'

 best regards
 DA

UMMM maybe.  You could possible open the browser executable (ie.exe for 
example) with the url to the CFM template is a parameter.  What good 
this would do for you I can not imagine.

In other words you are not likely able to do what you are trying to do.  
CFML is not meant to be run outside of a web-server/client environment.

~|
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:297481
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SQL Question -- Order by a column's value?

2008-01-25 Thread Gaulin, Mark

Yes, you can do this with a CASE statement.  The syntax may depend on
you db, but on SQL Server


ORDER BY 
CASE Colleges 
WHEN 'Harvard' THEN 1
WHEN 'Princeton' THEN 2
WHEN 'Dartmouth' THEN 3
ELSE 100
END

This would put those three colleges in that order, and all others would
go after them.  To be smart you should add another ORDER BY field to
sort all of the ones that hit the default case in some way (so, sort by
the CASE statement, then by the Colleges field).

Thanks
Mark

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 1:41 PM
To: CF-Talk
Subject: OT: SQL Question -- Order by a column's value?

Suppose I have a small set of data with a column named Colleges. Is
there a way to write an ORDER BY statement to say something like...
ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges
'Dartmouth'???

Just wondering... Che




~|
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:297457
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: OT: SQL Question -- Order by a column's value?

2008-01-25 Thread Dawson, Michael

Although you can do it as Charlie demonstrated, using CASE, Dominic's
solution is probably the best.

Put the data in a table where it belongs.  Then, that same data can be
reused for other purposes.

M!ke

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 12:55 PM
To: CF-Talk
Subject: Re: OT: SQL Question -- Order by a column's value?

Do you mean put them in a predifind order based on the college, other
than alphabetical?

If so, and if you have a lookup table for your colleges, you will have
to add a numerical column called 'Ordinal' (or something else) with
which you can set their order. Then simply order by that in your SQL
statement. There is no way to do it with pure SQL alone.

Dominic


~|
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:297461
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SSL Necessary? Important?

2008-01-25 Thread Rick Root

On 1/24/08, Rick Faircloth [EMAIL PROTECTED] wrote:
 One solution that I have used is to allow users to choose their username,
 usually just their email address, but I force a very strong password
 on them generated with CF.

Nothing annoys me more, personally, than a web site that won't let me
choose my own password.  Such sites are rare, thank god.

But second on the list of annoying password things is password rules
that don't make sense to me or seem random. One bank says your
password cannot end in a number.  Another says you have to have two
numbers.

Then you get the sites that don't LET you use special characters.
That *REALLY* annoys me.  Nothing worse than a web site that forces
you to lower your password strength to fit their rules.

And finally, I deal with one company that forces your password to all
lower case.  PSNC Energy does that.  Incredibly lame.

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
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:297411
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SQL Question -- Order by a column's value?

2008-01-25 Thread Crow T. Robot

Yes, you can do this using case statements in your order by:

example:

select * from viewoffers where [EMAIL PROTECTED]

order by

case status

when 'active' then 1

when 'rejected' then 2

else 99

end



Of course, this is really a kludge.  The DB should be deisgned a little
better, but sometimes a kludge is what you need to get the job done. Not
everything can be elegant.

On Jan 25, 2008 12:41 PM, Che Vilnonis [EMAIL PROTECTED] wrote:

 Suppose I have a small set of data with a column named Colleges. Is
 there
 a way to write an ORDER BY statement to say something like...
 ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

 Just wondering... Che


 

~|
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:297459
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would I get a cfhttp timeout on this cfftp operation?

Yes, to both questions.

I'm not sure if the settings were correct, but I tried setting the
scheduled task's timeout to  seconds.

Then I tried adding cfsetting timeoutRequest= to the template,
but neither seemed to have an effect.

But also, if the problem is not with CFHTTP, why would the scheduler log
so it was?

???


 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 12:44 PM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
  No matter how I run it, I get the same error...
 
  - Automated Scheduled Task
  - Manual Test Run of Scheduled Task
  - Run template directly in browser
 
 Then your problem isn't with CFHTTP, it's with the file. Have you set the
 TIMEOUT attribute for CFFTP? Have you also set the page timeout using
 CFSETTING?
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 

~|
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:297455
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: SQL Question -- Order by a column's value?

Che Vilnonis wrote:
 Suppose I have a small set of data with a column named Colleges. Is there
 a way to write an ORDER BY statement to say something like...
 ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

 Just wondering... Che
If  I understand your question correctly, you want to order a record set 
by first 'Harvard' record(s) then 'Princeton' record(s) and finally 
'Dartmouth' record(s).  If so yes, but you do most of the work in the 
SELECT clause.  Using logic functions in the SELECT clause such as CASE 
you can create dynamically create a sortable column with the appropriate 
values such as Harvard = 1, Princeton = 2 and Dartmouth = 3.  Then you 
just ORDER BY on this dynamic column and you the the result set you desire.

HTH
Because I don't have an example at my finger tips or remember the exact 
syntax off the top of my head to cobble one together this exact second.

Ian


~|
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:297452
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SQL Question -- Order by a column's value?

2008-01-25 Thread Dominic Watson

Do you mean put them in a predifind order based on the college, other than
alphabetical?

If so, and if you have a lookup table for your colleges, you will have to
add a numerical column called 'Ordinal' (or something else) with which you
can set their order. Then simply order by that in your SQL statement. There
is no way to do it with pure SQL alone.

Dominic


On 25/01/2008, Che Vilnonis [EMAIL PROTECTED] wrote:

 Suppose I have a small set of data with a column named Colleges. Is
 there
 a way to write an ORDER BY statement to say something like...
 ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???

 Just wondering... Che


 

~|
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:297454
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SSL Necessary? Important?