RE: How to access files on an ftp url that doesn't allow direct ftp access?

2008-09-04 Thread Rick Faircloth
I'm in!  Thanks, Justin!
I even managed to get in with FileZilla.

I can't believe those guys were telling me a direct FTP connection
wasn't possible.  (It's not the first time I've gotten wrong info
from them, however)

Tomorrow's gonna' be a brighter day now!  :o)

Thanks, again!

Rick

> -Original Message-
> From: Justin D. Scott [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 9:49 PM
> To: CF-Talk
> Subject: RE: How to access files on an ftp url that doesn't allow direct ftp 
> access?
> 
> > What I have to do is click on a link in my email,
> > which takes to to an web page that uses an ftp url
> > (ftp://datalink.interealty.com/)
> 
> MLXchange certainly allow direct access to their FTP server.  I wrote a
> routine that downloads IDX feeds daily and it's fully automated.  I can't
> send you the full code (you know, the whole copyright and work for hire
> stuff) since it's owned by the client, but here are the pertinent parts (not
> optimized since this is just a small chunk of a vast empire of code; watch
> for line breaks)...
> 
> 
> // Set our variables.
> variables.ftp_server = "datalink.interealty.com";
> variables.ftp_username = "anonymous";
> variables.ftp_password = "[EMAIL PROTECTED]";
> variables.ftp_folder = "/DataLinkOutput/yourPathHere/";
> 
> 
> 
>  username="#variables.ftp_username#" password="#variables.ftp_password#"
> stoponerror="yes">
>  directory="#variables.ftp_folder#" stoponerror="yes">
> 
> 
> 
> At this point you'll have a remoteFiles query which you can loop through to
> either download the individual files with CFFTP, or, in our case, generate
> an FTP script and pass it to a command-line FTP utility to handle the actual
> file transfers (I found that to be more stable over time with the larger
> files).
> 
> Once downloaded, unzip, import and enjoy.  For anyone else interested in the
> trials and tribulations of the MLS system we are talking about, I wrote a
> short novel about it in my blog.
> 
> 
> --
> Justin Scott, http://www.tlson.com/
> 
> 
> 

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

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


Re: Javascript in CFC

2008-09-04 Thread Brad Wood
- Original Message - 
From: "Andy Matthews" <[EMAIL PROTECTED]>


> That's irrelevant.
>
> The ColdFusion code would completely process before ANY JavaScript code
> would even make it to the browser.


Andy, I don't think you understand how cflocation works. Even though it is a 
CF tag, the relocation does NOT happen on the server side.  If you make a 
test file and place the following code in it:


alert('test');

http://www.yahoo.com";>

 and then hit that page, your browser will make two requests.  The first 
request for your test page will come back looking much like this HTTP 
response:

=
HTTP/1.1 302 Moved Temporarily
Date: Fri, 05 Sep 2008 03:04:33 GMT
Server: Apache/2.2.4 (Win32) JRun/4.0
location: http://www.yahoo.com
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Type: text/html; charset=UTF-8
Content-Length: 6551


alert('test');

=

Notice that the output of your page (the JavaScript) DOES get passed out to 
the browser.  However, your browser (Internet Explorer at least) will ignore 
the body of the response and send out a second request for 
http://www.yahoo.com.

So whether or not the code is in a CFC or not, the browser is who actually 
does the redirect.  Of course, if one wants the JavaScript to execute BEFORE 
the redirect, you want to send back a 200 response like so:


alert('test');
document.location.href = 'http://www.yahoo.com';


~Brad


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

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


Re: Ben Nadel's POI..

2008-09-04 Thread C S
>I don't think it's a case issue. I tried it with mixed, all lower and
>all upper and continue to get the same response.

Do any of these apply?
http://www.bennadel.com/blog/80-ColdFusion-SQL-Error-Table-Is-Not-Indexable-By-Name.htm
 

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

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


RE: How to access files on an ftp url that doesn't allow direct ftp access?

2008-09-04 Thread Rick Faircloth
Thanks for the info, Justin!

I'll work on that and try to make it work.
Hopefully this will work...I hate to think that I might
have to download the data manually every day!

Rick

> -Original Message-
> From: Justin D. Scott [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 9:49 PM
> To: CF-Talk
> Subject: RE: How to access files on an ftp url that doesn't allow direct ftp 
> access?
> 
> > What I have to do is click on a link in my email,
> > which takes to to an web page that uses an ftp url
> > (ftp://datalink.interealty.com/)
> 
> MLXchange certainly allow direct access to their FTP server.  I wrote a
> routine that downloads IDX feeds daily and it's fully automated.  I can't
> send you the full code (you know, the whole copyright and work for hire
> stuff) since it's owned by the client, but here are the pertinent parts (not
> optimized since this is just a small chunk of a vast empire of code; watch
> for line breaks)...
> 
> 
> // Set our variables.
> variables.ftp_server = "datalink.interealty.com";
> variables.ftp_username = "anonymous";
> variables.ftp_password = "[EMAIL PROTECTED]";
> variables.ftp_folder = "/DataLinkOutput/yourPathHere/";
> 
> 
> 
>  username="#variables.ftp_username#" password="#variables.ftp_password#"
> stoponerror="yes">
>  directory="#variables.ftp_folder#" stoponerror="yes">
> 
> 
> 
> At this point you'll have a remoteFiles query which you can loop through to
> either download the individual files with CFFTP, or, in our case, generate
> an FTP script and pass it to a command-line FTP utility to handle the actual
> file transfers (I found that to be more stable over time with the larger
> files).
> 
> Once downloaded, unzip, import and enjoy.  For anyone else interested in the
> trials and tribulations of the MLS system we are talking about, I wrote a
> short novel about it in my blog.
> 
> 
> --
> Justin Scott, http://www.tlson.com/
> 
> 
> 

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

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


Re: CF8 ajax component skin

2008-09-04 Thread Cutter (CFRelated)
Checkout the Learning Center of the Ext website (extjs.com). In the LC's 
Community Extensions section you can find some other skins (make sure 
you get the ones for Ext 1.x, which are on the bottom half of the page I 
think).

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

henry ho wrote:
> Other than the default, aero & vista, are there anymore skins for CF ajax 
> components?
> 
> The aero & vista skins are ugly with CFLAYOUT tabs. 
> 
> 

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

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


RE: How to access files on an ftp url that doesn't allow direct ftp access?

2008-09-04 Thread Justin D. Scott
> What I have to do is click on a link in my email,
> which takes to to an web page that uses an ftp url 
> (ftp://datalink.interealty.com/)

MLXchange certainly allow direct access to their FTP server.  I wrote a
routine that downloads IDX feeds daily and it's fully automated.  I can't
send you the full code (you know, the whole copyright and work for hire
stuff) since it's owned by the client, but here are the pertinent parts (not
optimized since this is just a small chunk of a vast empire of code; watch
for line breaks)...


// Set our variables.
variables.ftp_server = "datalink.interealty.com";
variables.ftp_username = "anonymous";
variables.ftp_password = "[EMAIL PROTECTED]";
variables.ftp_folder = "/DataLinkOutput/yourPathHere/";








At this point you'll have a remoteFiles query which you can loop through to
either download the individual files with CFFTP, or, in our case, generate
an FTP script and pass it to a command-line FTP utility to handle the actual
file transfers (I found that to be more stable over time with the larger
files).

Once downloaded, unzip, import and enjoy.  For anyone else interested in the
trials and tribulations of the MLS system we are talking about, I wrote a
short novel about it in my blog.


--
Justin Scott, http://www.tlson.com/


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

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


How to access files on an ftp url that doesn't allow direct ftp access?

2008-09-04 Thread Rick Faircloth
I know that's a strange question, but it seems appropriate.

I've got a data vendor that doesn't provide direct access
to their FTP site that I can access using a traditional FTP program.
I've tried and can't get in.

What I have to do is click on a link in my email, which takes to
to an web page that uses an ftp url (ftp://datalink.interealty.com/)

I can open the site in Windows Explorer and drag-n-drop the files into
a folder or I can open the url in Firefox and use the download dialog to
get the files, which works much better that Explorer.

I've requested that the vendor allow me direct FTP access to my folder,
but they say they can't because the URL changes every day with the downloads.

That doesn't make sense to me, because the URL in the email and the URL that
shows up in the browser is always the same.  The names of the files change,
because the name includes a timestamp as part of the name.  They're still
saying they can't (probably more that they won't) set up FTP access.  Maybe
there're something I'm not understanding.

Anyway...

I tried using cfhttp to get the html off that page and try to get access to
the files that way, but all I get is a "Connection Failed" message.

Does this make sense to anyone?  Is there any way to get the links to the files
that are part of the code in the HTML page displayed in the browser when I visit
the FTP URL?

Rick


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

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


CF8 ajax component skin

2008-09-04 Thread henry ho
Other than the default, aero & vista, are there anymore skins for CF ajax 
components?

The aero & vista skins are ugly with CFLAYOUT tabs. 

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

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


Re: Odd null pointer error

2008-09-04 Thread Bryan Stevenson
Well..no takers eh ;-)

Just FYIthis appears to have been a result of a known MySQl JDBC
driver bug.  The workaround is to uncheck "maintain connection" for the
datasource and add the number zero in the "validation query" box.

So far so good

Cheers
-  


Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.


On Thu, 2008-09-04 at 08:45 -0700, Bryan Stevenson wrote:
> Hey All,
> 
> Wowlong time no post ;-)
> 
> So we just moved a bunch of client sites to a VPS (HostMySite) and all
> has gone well.
> 
> One of the sites we moved has a small web app for building content for
> an HTML e-bulletin that gets mailed out once a week.  It went out fine
> last week (after moving from shared hosting to the VPS) as it always
> does, but not yesterday.
> 
> It's running CF 8 on Windows and uses MySQL for the DB.  The DB did not
> move from where it was when the site was hosted on a shared
> server.just the code moved to the VPS.
> 
> The code is stable and HAS NOT changed since before the move to the VPS.
> 
> THE ERROR IS:
> 
> -intermittent (can refresh and erroring page and see no errors and vica
> versa)
> 
> -not happening in the same place (various files at various times)
> 
> -even references queries with NO VARIABLESjust hardcoded values in
> cfqueryparam
> 
> -always references a query
> 
> THE ERROR MESSAGE IS:
> The system has attempted to use an undefined value, which usually
> indicates a programming error, either in your code or some system code. 
> 
> Null Pointers are another name for undefined values. 
> 
> 
> So like I said.code is fine.doubled checked it all.  A page will
> run fine many times and then won't.  No other sites on the VPS are
> experiencing this problem (none use MySQL).
> 
> WHAT I'VE DONE:
> -cycled CF services - no love
> -restarted virtual server - no love
> -had tech restart MySQL service - no love
> 
> I'm at a loss on this oneany ideas welcome ;-)
> 
> Given that everything has been restarted and this thing is
> intermittentI have to think it's NOT the code as the error eludes
> to, but rather something on the VPS or an issue with the data source or
> the DB itself.
> 
> TIA
> 
> Cheers
> -  
> 
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>  
> Notice:
> This message, including any attachments, is confidential and may contain
> information that is privileged or exempt from disclosure. It is intended
> only for the person to whom it is addressed unless expressly authorized
> otherwise by the sender. If you are not an authorized recipient, please
> notify the sender immediately and permanently destroy all copies of this
> message and attachments.
> 
> 
> 
> 
> 

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

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


Re: Verity - Error in search engine library

2008-09-04 Thread Tamara Loose
> I hava a couple of collections on a CF8-machine. Since a couple of 
> months I regularly get the message "Error opening a workspace.: com.
> verity.organize.WorkSpaceOpenException: All available workers are 
> allocated to open workspaces. Increase ODK Sync Threads to allow more 
> active workspaces. [K2IdxErr_TooManyOpenWorkSpaces]". Most of the time 
> an optimize collection does the trick and everything is back to 
> normal; sometimes only a CF Search Service restart helps.
> I have tried to fiddle with the Verity-setting (although nog really 
> fool-proof) of the ODK Sync Threads but kept getting this error. I 
> don't have a clue what's creating this...Anyone had this before? Cant 
> find anything on this errormessage.
> 
> thanks!
> Bart 

Did you come across a solution for this one. Our Collections are doing this now 
too.

Error opening a workspace: com.verity.organize.WorkSpaceOpenException: All 
available workers are allocated to open workspaces. Increase ODK Sync Threads 
to allow more active workspaces. [K2IdxErr_TooManyOpenWorkSpaces]. (-5017)  

Thanks, Tammy 


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

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


Re: Javascript in CFC

2008-09-04 Thread chn g
I use document.location.href in javascript instead of cflocation.

>Andy Matthews wrote:
>> That's irrelevant.
>> 
>> The ColdFusion code would completely process before ANY javascript code
>> would even make it to the browser.
>
>Actually, you can have output go to the browser before the CF code 
>completes by using CFFLUSH.  This would negate CFLOCATION though, so the 
>original poster probably removed that in favor of another method of 
>redirection (such as having it all in JavaScript with a CFABORT to stop 
>further processing after the error was detected).  In any case, they 
>didn't say how it was solved, but what matters is that whatever they did 
>worked for them .
>
>
>-- 
>Justin Scott, http://www.tlson.com/ 

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

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


Re: Javascript in CFC

2008-09-04 Thread Aaron Rouse
I have some CFCs I use to build needed javascript/html that is outputted
onto pages at the time they are loaded.

On Thu, Sep 4, 2008 at 1:29 PM, Andy Matthews <[EMAIL PROTECTED]>wrote:

> That's irrelevant.
>
> The ColdFusion code would completely process before ANY javascript code
> would even make it to the browser.
>
> -Original Message-
> From: Justin Scott [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 1:24 PM
> To: CF-Talk
> Subject: Re: Javascript in CFC
>
> > This works?  Am I missing something?  How is the browser seeing
> javascript
> code in a cfc?
>
> The CFCOMPONENT and CFFUNCTION tags both support an "output" attribute that
> can be set to yes to allow their output to be injected into the content
> stream back to the user.
>
>
> --
> -Justin Scott, http://www.tlson.com/
>
>
>
>
> 

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

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


Re: Javascript in CFC

2008-09-04 Thread Justin Scott
Andy Matthews wrote:
> That's irrelevant.
> 
> The ColdFusion code would completely process before ANY javascript code
> would even make it to the browser.

Actually, you can have output go to the browser before the CF code 
completes by using CFFLUSH.  This would negate CFLOCATION though, so the 
original poster probably removed that in favor of another method of 
redirection (such as having it all in JavaScript with a CFABORT to stop 
further processing after the error was detected).  In any case, they 
didn't say how it was solved, but what matters is that whatever they did 
worked for them .


-- 
Justin Scott, http://www.tlson.com/


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

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


RE: Javascript in CFC

2008-09-04 Thread Andy Matthews
That's irrelevant.

The ColdFusion code would completely process before ANY javascript code
would even make it to the browser.

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 04, 2008 1:24 PM
To: CF-Talk
Subject: Re: Javascript in CFC

> This works?  Am I missing something?  How is the browser seeing javascript
code in a cfc?

The CFCOMPONENT and CFFUNCTION tags both support an "output" attribute that
can be set to yes to allow their output to be injected into the content
stream back to the user.


--
-Justin Scott, http://www.tlson.com/




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

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


Re: Javascript in CFC

2008-09-04 Thread Justin Scott
> This works?  Am I missing something?  How is the browser seeing javascript 
> code in a cfc?

The CFCOMPONENT and CFFUNCTION tags both support an "output" attribute 
that can be set to yes to allow their output to be injected into the 
content stream back to the user.


-- 
-Justin Scott, http://www.tlson.com/


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

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


RE: Javascript in CFC

2008-09-04 Thread Milburn, Steve
This works?  Am I missing something?  How is the browser seeing javascript code 
in a cfc?


From: chn g [EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 2:14 PM
To: CF-Talk
Subject: Re: Javascript in CFC

Thank you, its working now.

>alert() is lower case.  If that doesn't work try this:
>
>
>
>
>The cflocation is sending back a status code of 301 to your browser.  In
>fact, I don't even know if ColdFusion sends back any content created in
>the reponse body or not.
>
>~Brad
>
>What's wrong with the following code?



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

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


Re: Javascript in CFC

2008-09-04 Thread chn g
Thank you, its working now. 

>alert() is lower case.  If that doesn't work try this:
>
> 
>
>
>The cflocation is sending back a status code of 301 to your browser.  In
>fact, I don't even know if ColdFusion sends back any content created in
>the reponse body or not.
>
>~Brad
> 
>What's wrong with the following code? 

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

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


Re: Javascript in CFC

2008-09-04 Thread Justin Scott
> The cflocation is sending back a status code of 301 to your browser.

You mean it sets 302 as a temporary redirect, not permanent as a 301 
would be.

 > In fact, I don't even know if ColdFusion sends back any content
 > created in the reponse body or not.

It doesn't when you use CFLOCATION.  It's essentially the equivalent of 
setting a 302 status code, a Location header, then using CFCONTENT with 
the reset="yes" attribute.


--
Justin Scott, http://www.tlson.com/



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

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


RE: Javascript in CFC

2008-09-04 Thread Andy Matthews
CF runs on the server, before the Javascrtipt would even have a chance to
hit the browser. 

-Original Message-
From: chn g [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 04, 2008 1:05 PM
To: CF-Talk
Subject: Javascript in CFC

What's wrong with the following code?


  ...

   
   Alert("Error");
   
   http://#CGI.SERVER_NAME#/testfile.html";>


It's not showing up alert box, directly displaying the html file. 

Thanks
Chn 



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

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


RE: Javascript in CFC

2008-09-04 Thread brad
alert() is lower case.  If that doesn't work try this:

 


The cflocation is sending back a status code of 301 to your browser.  In
fact, I don't even know if ColdFusion sends back any content created in
the reponse body or not.

~Brad
 
  Original Message 
Subject: Javascript in CFC
From: chn g <[EMAIL PROTECTED]>
Date: Thu, September 04, 2008 1:04 pm
To: CF-Talk 

What's wrong with the following code?



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

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


Re: Javascript in CFC

2008-09-04 Thread Justin Scott
>
>Alert("Error");
>  
>http://#CGI.SERVER_NAME#/testfile.html";>

First thing is that CFLOCATION sets a 302 header which tells the browser 
to redirect, and none of the "output" is sent to the browser.

If you want to show an error and redirect, you'll need to do it all in 
JavaScript (also, alert should be all lower-case)...

alert("Error");
document.location.href = '/testfile.html';


--
Justin Scott, http://www.tlson.com/



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

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


Javascript in CFC

2008-09-04 Thread chn g
What's wrong with the following code?


  ...

   
   Alert("Error");
   
   http://#CGI.SERVER_NAME#/testfile.html";>


It's not showing up alert box, directly displaying the html file. 

Thanks
Chn 

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

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


Re: Ben Nadel's POI..

2008-09-04 Thread jonese
I don't think it's a case issue. I tried it with mixed, all lower and
all upper and continue to get the same response.

I've also confirmed that spelling is the same in my columnList
variable as is in the actually query results.

jonese
http://www.jonese.us
http://twitter.com/jonese



On Thu, Sep 4, 2008 at 1:22 PM,  <[EMAIL PROTECTED]> wrote:
> This is just a guess, but it looks like it maybe a case sensitivity
> thing.  The error says your table "is not indexable by journalName".
> Among the list of columns, it has "JOURNALNAME" as a column.  A ucase()
> may be in order.
>
> ~Brad
>
>   Original Message 
> Subject: Ben Nadel's POI..
> From: jonese <[EMAIL PROTECTED]>
> Date: Thu, September 04, 2008 11:54 am
> To: CF-Talk 
>
> Anyone come across this error?
>
> [Table (rows 777 columns JOURNALISSN, JOURNALNAME, JOURNALISSUE,
> JOURNALISOABBREV, JOURNALPUBDATE, JOUNRNALPUBLICATIONTYPE, PUBMEDID,
> ARTICLETITLE, ARTICLEABSTRACT, TOTALAUTHORS, AUTHORPOSITION,
> AUTHORTITLE, AUTHORABREVNAME, AUTHORFORENAME, AUTHORFIRSTNAME,
> AUTHORMIDDLENAME, AUTHORLASTNAME, AUTHORSUFFIX, SUBMISSIONKEY):
> [JOURNALISSN: [EMAIL PROTECTED] [JOURNALNAME:
> [EMAIL PROTECTED] ] is not indexable by journalName
>
>
>
> 

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

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


Re: Create Dynamic XML File for Flash File

2008-09-04 Thread Ian Skinner
David Moore wrote:
> How would I go about creating a dynamic file on the fly from a CF Query
>   

Exactly like you would create dynamic HTML.  ColdFusion does not care 
what text it creates and will do what ever you direct it to.  You can do 
it all manually or use the built in XML functionality.  Be careful of 
whitespace, XML often cares more about this then HTML would.

...

  
#theQuery.aColumn
#theQuery.bColumn
 


There are much more sophisticated ways to do this, but at the most basic 
XML generation is no different then any other output.



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

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


RE: Ben Nadel's POI..

2008-09-04 Thread brad
This is just a guess, but it looks like it maybe a case sensitivity
thing.  The error says your table "is not indexable by journalName". 
Among the list of columns, it has "JOURNALNAME" as a column.  A ucase()
may be in order.

~Brad
 
  Original Message 
Subject: Ben Nadel's POI..
From: jonese <[EMAIL PROTECTED]>
Date: Thu, September 04, 2008 11:54 am
To: CF-Talk 

Anyone come across this error?

[Table (rows 777 columns JOURNALISSN, JOURNALNAME, JOURNALISSUE,
JOURNALISOABBREV, JOURNALPUBDATE, JOUNRNALPUBLICATIONTYPE, PUBMEDID,
ARTICLETITLE, ARTICLEABSTRACT, TOTALAUTHORS, AUTHORPOSITION,
AUTHORTITLE, AUTHORABREVNAME, AUTHORFORENAME, AUTHORFIRSTNAME,
AUTHORMIDDLENAME, AUTHORLASTNAME, AUTHORSUFFIX, SUBMISSIONKEY):
[JOURNALISSN: [EMAIL PROTECTED] [JOURNALNAME:
[EMAIL PROTECTED] ] is not indexable by journalName



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

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


Ben Nadel's POI..

2008-09-04 Thread jonese
Anyone come across this error?

[Table (rows 777 columns JOURNALISSN, JOURNALNAME, JOURNALISSUE,
JOURNALISOABBREV, JOURNALPUBDATE, JOUNRNALPUBLICATIONTYPE, PUBMEDID,
ARTICLETITLE, ARTICLEABSTRACT, TOTALAUTHORS, AUTHORPOSITION,
AUTHORTITLE, AUTHORABREVNAME, AUTHORFORENAME, AUTHORFIRSTNAME,
AUTHORMIDDLENAME, AUTHORLASTNAME, AUTHORSUFFIX, SUBMISSIONKEY):
[JOURNALISSN: [EMAIL PROTECTED] [JOURNALNAME:
[EMAIL PROTECTED] [JOURNALISSUE:
[EMAIL PROTECTED] [JOURNALISOABBREV:
[EMAIL PROTECTED] [JOURNALPUBDATE:
[EMAIL PROTECTED] [JOUNRNALPUBLICATIONTYPE:
[EMAIL PROTECTED] [PUBMEDID:
[EMAIL PROTECTED] [ARTICLETITLE:
[EMAIL PROTECTED] [ARTICLEABSTRACT:
[EMAIL PROTECTED] [TOTALAUTHORS:
[EMAIL PROTECTED] [AUTHORPOSITION:
[EMAIL PROTECTED] [AUTHORTITLE:
[EMAIL PROTECTED] [AUTHORABREVNAME:
[EMAIL PROTECTED] [AUTHORFORENAME:
[EMAIL PROTECTED] [AUTHORFIRSTNAME:
[EMAIL PROTECTED] [AUTHORMIDDLENAME:
[EMAIL PROTECTED] [AUTHORLASTNAME:
[EMAIL PROTECTED] [AUTHORSUFFIX:
[EMAIL PROTECTED] [SUBMISSIONKEY:
[EMAIL PROTECTED] ] is not indexable by journalName

The error occurred in
C:\working\kol.nucleusclient.com\www\com\nucleusclient\utility\POIUtility.cfc:
line 1714
Called from 
C:\working\kol.nucleusclient.com\www\com\nucleusclient\utility\POIUtility.cfc:
line 1405
Called from 
C:\working\kol.nucleusclient.com\www\pubmedReportBuilder\includes\makeExcel.cfm:
line 65
Called from 
C:\working\kol.nucleusclient.com\www\pubmedReportBuilder\includes\pubmedThread.cfm:
line 97
Called from C:\working\kol.nucleusclient.com\www\pubmedReportBuilder\index.cfm:
line 34

1712 :  LOCAL.CellValue = ARGUMENTS.Query[
1713 :  LOCAL.Columns[ 
LOCAL.ColumnIndex ]
1714 :  ][ LOCAL.RowIndex ];
1715 :  
1716 :  // Check to see how we want to set the 
value. Meaning, what

Got any idea what i'm doing wrong? I moved from querying a Table to
querying a view in SQL. I changed up my columnList and ColumnNames as
well. Afaik everything else stayed the same...

thoughts?

jonese
http://www.jonese.us
http://twitter.com/jonese

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

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


RE: CF8 Dedicated server recommendations

2008-09-04 Thread Rick Faircloth
Those are some really good recommendation, Charlie!  ;o)

Rick

> -Original Message-
> From: charles arehart [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 11:59 AM
> To: CF-Talk
> Subject: Re: CF8 Dedicated server recommendations
> 
> > I'm looking for a fairly low-end CF 8 dedicated server setup. I've
> > been running with a VPS for a while and I'm starting to outgrow it.
> > CF8, MS-SQL, prolly don't need more than 40 GB disk, 2 GB RAM. If
> > anyone has any suggestions I'd appreciate it!
> >
> > -- Jake
> 
> 



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

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


Re: CF8 Dedicated server recommendations

2008-09-04 Thread charles arehart
Jake, I can't tell if you're saying you're aware of lists of many CF hosts and 
want a specific recommendation for your needs, but if you'd be open to having a 
list of several popular CF hosts, I can point you to one:

http://www.cf411.com/#cfhost

This is the "ColdFusion Hosting Alternatives" category in my recently announced 
CF411.com site, which has several hundred resources and tools of interest to 
CFers, in over 100 categories. Hope it (or the other categories) helps you and 
all who read this.  

I created it primarily for just this kind of common request that's asked on 
lists like this. Check it out, and please spread the word. It's only helpful 
when people learn of it. :-)

/charlie

PS I have to admit I don't read or contribute to cf-talk regularly. It's just 
way too much volume to keep up, but I know it's great stuff. I was alerted to 
this discussion via a google alert search for references to CF8 (that I'd set 
up quite a while ago), so I thought I'd drop in an offer this. Sadly, I won't 
see ongoing discussion in this or other threads, but I hoped that the info may 
be worth sharing regardless of that. Just trying to help. 

 I'm looking for a fairly low-end CF 8 dedicated server setup. I've 
> been running with a VPS for a while and I'm starting to outgrow it. 
> CF8, MS-SQL, prolly don't need more than 40 GB disk, 2 GB RAM. If 
> anyone has any suggestions I'd appreciate it!
> 
> -- Jake 


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

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


Re: CF8 Dedicated server recommendations

2008-09-04 Thread charles arehart
> I'm looking for a fairly low-end CF 8 dedicated server setup. I've 
> been running with a VPS for a while and I'm starting to outgrow it. 
> CF8, MS-SQL, prolly don't need more than 40 GB disk, 2 GB RAM. If 
> anyone has any suggestions I'd appreciate it!
> 
> -- Jake 


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

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


Odd null pointer error

2008-09-04 Thread Bryan Stevenson
Hey All,

Wowlong time no post ;-)

So we just moved a bunch of client sites to a VPS (HostMySite) and all
has gone well.

One of the sites we moved has a small web app for building content for
an HTML e-bulletin that gets mailed out once a week.  It went out fine
last week (after moving from shared hosting to the VPS) as it always
does, but not yesterday.

It's running CF 8 on Windows and uses MySQL for the DB.  The DB did not
move from where it was when the site was hosted on a shared
server.just the code moved to the VPS.

The code is stable and HAS NOT changed since before the move to the VPS.

THE ERROR IS:

-intermittent (can refresh and erroring page and see no errors and vica
versa)

-not happening in the same place (various files at various times)

-even references queries with NO VARIABLESjust hardcoded values in
cfqueryparam

-always references a query

THE ERROR MESSAGE IS:
The system has attempted to use an undefined value, which usually
indicates a programming error, either in your code or some system code. 

Null Pointers are another name for undefined values. 


So like I said.code is fine.doubled checked it all.  A page will
run fine many times and then won't.  No other sites on the VPS are
experiencing this problem (none use MySQL).

WHAT I'VE DONE:
-cycled CF services - no love
-restarted virtual server - no love
-had tech restart MySQL service - no love

I'm at a loss on this oneany ideas welcome ;-)

Given that everything has been restarted and this thing is
intermittentI have to think it's NOT the code as the error eludes
to, but rather something on the VPS or an issue with the data source or
the DB itself.

TIA

Cheers
-  


Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.




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

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


Create Dynamic XML File for Flash File

2008-09-04 Thread David Moore
How would I go about creating a dynamic file on the fly from a CF Query for a 
Flash document that uses ActiveScipt and an XML File for navigation. 

I have the Flash file, but I need to create the XML file on the fly each time, 
because I will need to tell the Flash file what the Active page is from the 
URL.PageID to make the link color different, like with CSS. I hope this makes 
since...

Any suggestions...

~David Moore 

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

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


Re: CFCOMPILE

2008-09-04 Thread Jochem van Dieten
Robert Harrison wrote:
> I'm trying to use CFCOMPILE to deploy an application. The documentation is a
> bit sketchy, so I have some questions:
> 
>   1. Do the source files have to be .cfml or can they be .cfm?

Both.


>   2. When you compile can you recurse directories?

It does so automatically.


>   3. I tried a test using:
> 
>   C:\CFusionMX7\bin\cfcompile -deploy
> C:\Inetpub\wwwroot\source C:\Inetpub\wwwroot\compiled

You are missing the webroot argument. Look inside the batchfile for details.

Jochem



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

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


Re: ses and application.cfc

2008-09-04 Thread Raymond Camden
Don't use it as a UDF. You can just use the logic of the UDF in the
onRequestStart code. Or keep it as a UDF, and call the UDF from
onRequestStart.

Don't look at it as just a cut and paste solution. You need to
understand _what_ the code is doing here. If so, it will make more
sense how you can use it in Application.cfc.

On Thu, Sep 4, 2008 at 9:06 AM, Chad Gray <[EMAIL PROTECTED]> wrote:
> If I put that code in onRequestStart I get this error.  I think it is because 
> I am creating a function inside of a function.
>
>
> Unable to complete CFML to Java translation.
> Error information unsupported statement: class 
> coldfusion.compiler.ASTfunctionDefinition
>
>
>
>
>
>> -Original Message-
>> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, September 04, 2008 10:00 AM
>> To: CF-Talk
>> Subject: Re: ses and application.cfc
>>
>> On Thursday 04 Sep 2008, Chad Gray wrote:
>> > How should I use this script when using Application.cfc?
>>
>> onRequestStart()
>>
>> --
>> Tom Chiverton
>>
>> 
>>
>> This email is sent for and on behalf of Halliwells LLP.
>>
>> Halliwells LLP is a limited liability partnership registered in England
>> and Wales under registered number OC307980 whose registered office address
>> is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
>> 3EB.  A list of members is available for inspection at the registered
>> office. Any reference to a partner in relation to Halliwells LLP means a
>> member of Halliwells LLP.  Regulated by The Solicitors Regulation
>> Authority.
>>
>> CONFIDENTIALITY
>>
>> This email is intended only for the use of the addressee named above and
>> may be confidential or legally privileged.  If you are not the addressee
>> you must not read it and must not use any information contained in nor
>> copy it nor inform any person other than Halliwells LLP or the addressee
>> of its existence or contents.  If you have received this email in error
>> please delete it and notify Halliwells LLP IT Department on 0870 365 2500.
>>
>> For more information about Halliwells LLP visit www.halliwells.com.
>>
>>
>
> 

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

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


Re: CFMAIL process works on one server but not another.

2008-09-04 Thread Mark Gordon
>Sounds like a relay issue at site b's mail server
>
>Mark Gordon wrote:
>>

Actually, I think the error message does use the word relay.  The site is 
physically hosted on a server, but the domain name and email address are hosted 
with Network solutions.  I use A Records to point the domain name to the server.



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

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


Re: CFMAIL process works on one server but not another.

2008-09-04 Thread Scott Stewart
Sounds like a relay issue at site b's mail server

Mark Gordon wrote:
> I have code that sends a confirmation email to someone.  I use CFMail.  I 
> have the same code running on two separate sites (A and B).  Problem is that 
> I don't have direct access to the Coldfusion server on site A (the one where 
> it works, cfserver version 6).  
>
> I read somewhere that the "from" field is not required.  I auto-populate the 
> "from" field with different email addresses, depending upon what the person 
> is registering for.  On Site A, where this works, any email address will work 
> (i.e. [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]), and when they 
> get the email, it says it's from that email address. 
>
> On Site B, the newer site, where I DO have access to the CF Server (version 
> 8), it has a problem.  I've set up the mail server and verified the 
> connection (mail.siteb.net).  The problem I have is that on Site B, if the 
> "from" email address is not a "@mail.siteb.net" email address I throws an 
> error.  
>
> Any help appreciated.  Is this a setting somewhere in CF Server that I'm not 
> checking?
>
>
> 

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

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


Re: CFMAIL process works on one server but not another.

2008-09-04 Thread Justin Scott
> On Site B, the newer site, where I DO have access to the CF Server (version 
> 8), it has a problem.  I've set up the mail server and verified the 
> connection (mail.siteb.net).  The problem I have is that on Site B, if the 
> "from" email address is not a "@mail.siteb.net" email address I throws an 
> error.  

I would check in the mail log to see what error the SMTP server is 
giving you and work from there.  It's likely a configuration problem on 
the SMTP server where it's not allowing the IP of your web server to 
relay out to/from non-local addresses.


-Justin Scott, http://www.tlson.com/



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

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


Re: TDD vs. Big Ball of Mud (was Re: fusebox vs model glue)

2008-09-04 Thread Brian Kotek
I don't know anyone who thinks that TDD is the be-all-end-all of software
development. The reality is that it does offer some very tangible benefits:

   - Everyone writes some kind of test. It might be a scribble pad that you
   run to make sure something works. It might be that you write code and then
   run the application and try to confirm that the code does what it should.
   Unit testing simply formalizes this and makes it a process that can be
   easily documented and repeated.
   - Writing a test first does help you determine the design of the code
   you're going to write. If you're writing a new block of code or a new
   method, writing the test helps you look at it from an API perspective: What
   do I have to pass in? What do I expect to get back? What can go wrong?
   - In a dynamic language like ColdFusion, unit tests pretty quickly become
   essential. Since we have no compiler, we can't catch any errors until
   runtime. And since values can be nearly any type, without tests that enforce
   input and output requirements it is extremely easy to write code that seems
   to work fine on the surface, or at least doesn't throw an error when you run
   it. It might be much later that something goes wrong. Tests help reduce the
   likelihood of this.
   - When a bug is found, if you add it to the test you make it far more
   unlikely that that bug can reappear.
   - Perhaps most importantly, creating and maintaining a suite of unit
   tests makes ongoing development much, much easier. If you make a change, it
   is incredibly useful to be able to run all of your tests and be fairly
   confident that you didn't break something else. Of course this isn't a
   guarantee, but it is vastly more reassuring than having no tests at all.

Now, should TDD give one complete confidence? Of course not. But it offers a
lot of benefits anyway, and it offers far more confidence than not having
any tests. It is for these reasons (which I would call very pragmatic
reasons) that I would recommend that everyone follow TDD.


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

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


CFMAIL process works on one server but not another.

2008-09-04 Thread Mark Gordon
I have code that sends a confirmation email to someone.  I use CFMail.  I have 
the same code running on two separate sites (A and B).  Problem is that I don't 
have direct access to the Coldfusion server on site A (the one where it works, 
cfserver version 6).  

I read somewhere that the "from" field is not required.  I auto-populate the 
"from" field with different email addresses, depending upon what the person is 
registering for.  On Site A, where this works, any email address will work 
(i.e. [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]), and when they 
get the email, it says it's from that email address. 

On Site B, the newer site, where I DO have access to the CF Server (version 8), 
it has a problem.  I've set up the mail server and verified the connection 
(mail.siteb.net).  The problem I have is that on Site B, if the "from" email 
address is not a "@mail.siteb.net" email address I throws an error.  

Any help appreciated.  Is this a setting somewhere in CF Server that I'm not 
checking?


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

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


RE: datasource funkyness

2008-09-04 Thread Dave Watts
> This was a weird one.  I setup a MS SQL database and forgot 
> to fill in "database" under the CF admin.
> 
> I submitted it and it said it was "OK".
> 
> I thought, OK my database is hooked up, but in my code I kept 
> getting these strange errors basically saying the table you 
> are trying to query is not a valid object.  I beat my head 
> agains the wall thinking it was my code, and eventually look 
> back in CF Admin at the database and discovered my mistake.
> 
> So once I filled in the "database" field in the CF admin it 
> all started working.
> 
> Why would CF Admin report back that the database connection 
> verified if the database itself could not be connected too?  
> Sound like a bug.

This is the expected behavior. CF isn't connecting to a database, it's
connecting to a database server. If you don't specify a database, you'll use
whatever the default database is for that user - probably "master".

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;203748912;27390454;j

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


Re: datasource funkyness

2008-09-04 Thread Brad Wood
You can create a ColdFusion data source that doesn't default to any 
particular database.  If you do, all your queries need to reference the 
database for all objects:

select *
from database_name.table_name

I know if works that way for MSSQL, so I assume it is the same for MySQL

~Brad

- Original Message - 
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, September 04, 2008 9:31 AM
Subject: datasource funkyness


> This was a weird one.  I setup a MS SQL database and forgot to fill in 
> "database" under the 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;203748912;27390454;j

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


datasource funkyness

2008-09-04 Thread Chad Gray
This was a weird one.  I setup a MS SQL database and forgot to fill in 
"database" under the CF admin.

I submitted it and it said it was "OK".

I thought, OK my database is hooked up, but in my code I kept getting these 
strange errors basically saying the table you are trying to query is not a 
valid object.  I beat my head agains the wall thinking it was my code, and 
eventually look back in CF Admin at the database and discovered my mistake.

So once I filled in the "database" field in the CF admin it all started working.

Why would CF Admin report back that the database connection verified if the 
database itself could not be connected too?  Sound like a bug.


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

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


RE: ses and application.cfc

2008-09-04 Thread Adrian Lynch
Oh and if that doesn't work, put it in a file and include it instead.

Adrian

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 04 September 2008 15:15
To: CF-Talk
Subject: RE: ses and application.cfc


Try onRequest instead.

Adrian

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: 04 September 2008 15:06
To: CF-Talk
Subject: RE: ses and application.cfc


If I put that code in onRequestStart I get this error.  I think it is
because I am creating a function inside of a function.


Unable to complete CFML to Java translation.
Error information unsupported statement: class
coldfusion.compiler.ASTfunctionDefinition





> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 10:00 AM
> To: CF-Talk
> Subject: Re: ses and application.cfc
>
> On Thursday 04 Sep 2008, Chad Gray wrote:
> > How should I use this script when using Application.cfc?
>
> onRequestStart()
>
> --
> Tom Chiverton

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

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


Re: CFCOMPILE

2008-09-04 Thread Adam Haskell
Open up the cfcompile.bat there is some good info in there. If you use the
-deploy that will allow for sourceless deployment. Are you running this from
command line? My guess is that there is an rror and you ar enot seeing it on
the command line, you'll most likely need to open up the .bat file and edit
CFUSION_HOME, J2EEJAR and WEBINF.

Adam



On Thu, Sep 4, 2008 at 9:44 AM, Robert Harrison
<[EMAIL PROTECTED]>wrote:

> I'm trying to use CFCOMPILE to deploy an application. The documentation is
> a
> bit sketchy, so I have some questions:
>
>1. Do the source files have to be .cfml or can they be .cfm?
>
>2. When you compile can you recurse directories?
>
>3. I tried a test using:
>
>C:\CFusionMX7\bin\cfcompile -deploy
> C:\Inetpub\wwwroot\source C:\Inetpub\wwwroot\compiled
>
>It opened a window and ran, but there are not files in
> C:\Inetpub\wwwroot\compiled.
>
> Any ideas?
>
> Thanks
>
>
>
>
> Robert B. Harrison
> Director of Interactive services
> Austin & Williams
> 125 Kennedy Drive, Suite 100 Hauppauge NY 11788
> T : 631.231.6600 Ext. 119
> F : 631.434.7022
> www.austin-williams.com
>
> Great advertising can't be either/or... It must be &.
>
>
>
> 

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

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


RE: ses and application.cfc

2008-09-04 Thread Adrian Lynch
Try onRequest instead.

Adrian

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: 04 September 2008 15:06
To: CF-Talk
Subject: RE: ses and application.cfc


If I put that code in onRequestStart I get this error.  I think it is
because I am creating a function inside of a function.


Unable to complete CFML to Java translation.
Error information unsupported statement: class
coldfusion.compiler.ASTfunctionDefinition





> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 10:00 AM
> To: CF-Talk
> Subject: Re: ses and application.cfc
>
> On Thursday 04 Sep 2008, Chad Gray wrote:
> > How should I use this script when using Application.cfc?
>
> onRequestStart()
>
> --
> Tom Chiverton


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

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


RE: ses and application.cfc

2008-09-04 Thread Chad Gray
If I put that code in onRequestStart I get this error.  I think it is because I 
am creating a function inside of a function.


Unable to complete CFML to Java translation.  
Error information unsupported statement: class 
coldfusion.compiler.ASTfunctionDefinition  





> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2008 10:00 AM
> To: CF-Talk
> Subject: Re: ses and application.cfc
> 
> On Thursday 04 Sep 2008, Chad Gray wrote:
> > How should I use this script when using Application.cfc?
> 
> onRequestStart()
> 
> --
> Tom Chiverton
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> 3EB.  A list of members is available for inspection at the registered
> office. Any reference to a partner in relation to Halliwells LLP means a
> member of Halliwells LLP.  Regulated by The Solicitors Regulation
> Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged.  If you are not the addressee
> you must not read it and must not use any information contained in nor
> copy it nor inform any person other than Halliwells LLP or the addressee
> of its existence or contents.  If you have received this email in error
> please delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.com.
> 
> 

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

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


Re: ses and application.cfc

2008-09-04 Thread Tom Chiverton
On Thursday 04 Sep 2008, Chad Gray wrote:
> How should I use this script when using Application.cfc?

onRequestStart()

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

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

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


ses and application.cfc

2008-09-04 Thread Chad Gray
I found this script on Ray Camden's blog for doing SES but it wont work if 
placed in Application.cfc.

How should I use this script when using Application.cfc?

I really don't want to put it on the top of each page.  I would prefer to use 
it in the Application.cfc file.



function parseSES() {
   var pathInfo = reReplaceNoCase(trim(cgi.path_info), '.+\.cfm/? *', '');
   var i = 1;
   var lastKey = "";
   var value = "";
   
   if(not len(pathInfo)) return;

   for(i=1; i lte listLen(pathInfo, "/"); i=i+1) {
  value = listGetAt(pathInfo, i, "/");
  if(i mod 2 is 0) url[lastKey] = value; 
  else lastKey = value;
   }
   //did we end with a "dangler?"
   if((i-1) mod 2 is 1) url[lastKey] = ""; 
   return;
   
}




#parseSES()#
 


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

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


CFCOMPILE

2008-09-04 Thread Robert Harrison
I'm trying to use CFCOMPILE to deploy an application. The documentation is a
bit sketchy, so I have some questions:

1. Do the source files have to be .cfml or can they be .cfm?

2. When you compile can you recurse directories?

3. I tried a test using:

C:\CFusionMX7\bin\cfcompile -deploy
C:\Inetpub\wwwroot\source C:\Inetpub\wwwroot\compiled
   
It opened a window and ran, but there are not files in
C:\Inetpub\wwwroot\compiled.

Any ideas?

Thanks




Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be &.



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

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