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. select * from #i# #j#

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: Format explicitly: Reg

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 c

Re: lite spell checker?

2008-01-25 Thread Don L
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.

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 soft

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 tak

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

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

2008-01-25 Thread Rick Faircloth
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 ot

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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 w

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://

Re: CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Todd
You're going to have to work around it. Either by setting 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.

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

2008-01-25 Thread Discover Antartica
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 Sent: Friday, January 25, 2008 3:04:17 PM Subject: RE: SPAM: Re: is it possible to open cfml page from sql server stored proce

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

2008-01-25 Thread Discover Antartica
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 a

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

2008-01-25 Thread Discover Antartica
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 Sent: Friday, Jan

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

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 tha

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 window

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

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 recommenda

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)

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

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

2008-01-25 Thread Dave Watts
> 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? An

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 op

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

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

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 '

Re: lite spell checker?

2008-01-25 Thread Don L
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 def

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, yo

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

2008-01-25 Thread Don L
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

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

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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 wha

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

2008-01-25 Thread Discover Antartica
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 f

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

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 pa

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

2008-01-25 Thread Ian Skinner
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

Re: "zip code" range from xls to sql

2008-01-25 Thread Don L
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 zi

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 then we are simply trying to run this following code to test it and it is not working: the error is: 07/24/1978 is an invalid date format

Re: CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Todd
I confirmed the same error: http://www.web-rat.com/"; result="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 co

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

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

2008-01-25 Thread Ian Skinner
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 m

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

2008-01-25 Thread Rick Faircloth
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 th

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" Sent: Friday, January 25, 2008 1:04 PM Subject: Re: CFHTTP.Filecontent on left side of an assignment

RE: "zip code" range from xls to sql

2008-01-25 Thread Russ
It's not very clear what you are trying to achieve. The first 2 zip codes in your fields are repeating, and then the next three are not. If you give a better example of what the data should look like from your sample xls file, then it will be easier for people to help you. Russ > -Origin

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: The error: 12:41:30.030

Re: CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Todd
Confirm that it exists? 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

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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

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

2008-01-25 Thread Dave Watts
> I'm not sure if the settings were correct, but I tried > setting the scheduled task's timeout to "" seconds. > > Then I tried adding 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 w

"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_zi

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 p

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 d

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, Jan

RE: SSL Necessary? Important?

2008-01-25 Thread Dave Watts
> 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 ... > > Now that pretty iron-clad legally, I think, that no matter > what you do, passwo

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

2008-01-25 Thread Ian Skinner
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 flex

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 sometime

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

2008-01-25 Thread Ian Skinner
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 cor

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, C

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

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

2008-01-25 Thread Rick Faircloth
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 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?

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

2008-01-25 Thread Todd
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 P

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 s

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

2008-01-25 Thread Todd
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

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

2008-01-25 Thread Che Vilnonis
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 ~

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 cou

Re: SSL Necessary? Important?

2008-01-25 Thread Todd
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

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

2008-01-25 Thread Dave Watts
> 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 usi

RE: SSL Necessary? Important?

2008-01-25 Thread Dave Watts
> 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 instructio

Re: SSL Necessary? Important?

2008-01-25 Thread Todd
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 "

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.

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

2008-01-25 Thread Rick Faircloth
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

RE: OT: SSL Necessary? Important?

2008-01-25 Thread Dave Watts
> 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 negl

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

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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

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 run

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

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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." B

re: CF App throwing Access access error

2008-01-25 Thread Mark Kruger
If you are sure that no one has the file open (like through a mapped drive etc) then I would run the repair utility on the file. Mark A. Kruger - CFG www.cfwebtools.com www.coldfusionmuse.com www.necfug.com From: [EMAIL PROTECTED] Sent: Friday, January

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 acces

Re: ODBC Error CFQuery

2008-01-25 Thread netrista khatam
> ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS > A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS > IS A SIMPLE LOGIN APPLICATION. > > > Error Executing Database Query. [Macromedia][SequeLink JDBC > Driver][ODBC Socket][Microsoft][ODBC Microsoft A

CF App throwing Access access error

2008-01-25 Thread coldfusion . developer
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][Mic

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- > Fr

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

2008-01-25 Thread Dave Watts
> 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 ca

Re: lite spell checker?

2008-01-25 Thread Don L
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 fo

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

2008-01-25 Thread Todd
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

Re: SSL Necessary? Important?

2008-01-25 Thread Todd
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 validatio

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

2008-01-25 Thread Rick Faircloth
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 a

RE: lite spell checker?

2008-01-25 Thread Will Swain
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 -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: 25 January 2008 15:30 To: CF-Talk Sub

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=94a16ba6&sliceId=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

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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 la

Re: lite spell checker?

2008-01-25 Thread Don L
But Will, my IE7 is configured to load page per visit, so, cache is supposed to be gone for the {BasicEdited} in this case. But it really won't be an option for me in this case because as mentioned it excludes other javascripts for the same CFFORM element. Don >>> Outcome, FCKeditor still u

Re: lite spell checker?

2008-01-25 Thread Don L
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 m

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

Re: Setting a value for CFTEXTAREA (richtext) via Javascript

2008-01-25 Thread Ryan Chesney
Use the ColdFusion.RichText.setValue method (created in cfrichtexteditor.js): ColdFusion.RichText.setValue(_1,_2) Where parameter _1 is the FCKEditor instance id and parameter _2 is the new value. The FCKEditor instance id is dynamic so use the DOM to obtain the id from the generated textarea

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

2008-01-25 Thread Dave Watts
> 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 i

Re: SSL Necessary? Important?

2008-01-25 Thread Todd
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

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

2008-01-25 Thread Todd
Rick, I made a mistake in my previous email. I meant url?RequestTimeOut=x Alternatively: 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

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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,

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

2008-01-25 Thread Rick Faircloth
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 schedule

Re: SSL Necessary? Important?

2008-01-25 Thread Todd
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 choos

RE: SSL Necessary? Important?

2008-01-25 Thread Rick Faircloth
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- > F

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 m

  1   2   >