Re: Shouldn't these statements work?
Not necessarily. It should be used when you want to make sure the value AND the object type both match. On Oct 5, 2011, at 2:36 PM, Rick Faircloth r...@whitestonemedia.com wrote: I'm not entirely sure about the === operator, but it's working. My understanding from what I've read is that the === operator should be used only when comparing strings. Is that not correct? -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, October 05, 2011 1:39 PM To: cf-talk Subject: Re: Shouldn't these statements work? if ( activeLinkID === 'search_properties' currentPage === 'index.cfm' As everyone's already mentioned, this comparison operator is not an equality operator. It's an identity operator - it's used to see if two object references point to the same object. A literal string won't work here, as it's not the same object as the object to which you're comparing it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Shouldn't these statements work?
The triple === in JavaScript at least is a strict comparison. It not only
checks for truthiness, but that both sides are the same type.
Have you tried simple eq or ==
On Oct 4, 2011, at 9:17 PM, Rick Faircloth r...@whitestonemedia.com wrote:
if ( activeLinkID === 'search_properties' currentPage === 'index.cfm'
)
{ window.location = 'modules/search-properties/search-properties.cfm';
}
if ( activeLinkID === 'search_properties' currentPage === ''
)
{ window.location = '../search-properties/search-properties.cfm';
}
My first code, that still seems valid, was:
if ( activeLinkID === 'search_properties' (currentPage === 'index.cfm'
|| currentPage === '') )
{ window.location = 'modules/search-properties/search-properties.cfm'
}
else { window.location = '../search-properties/search-properties.cfm'
}
No syntax errors, but the page is not changed
to search-properties.cfm.
These lines are bypassed as if conditions are not met,
and the conditions are met.
They work if the URL ends in 'index.cfm', but not if the
URL is just the domain name.
I've tried every version of this I can think of.
Clues, anyone?
Rick
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347928
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Shouldn't these statements work?
Try logging each variable and it's type using typeOf. That'll help you move int
the right direction.
On Oct 4, 2011, at 9:35 PM, Lists li...@commadelimited.com wrote:
The triple === in JavaScript at least is a strict comparison. It not only
checks for truthiness, but that both sides are the same type.
Have you tried simple eq or ==
On Oct 4, 2011, at 9:17 PM, Rick Faircloth r...@whitestonemedia.com wrote:
if ( activeLinkID === 'search_properties' currentPage === 'index.cfm'
)
{ window.location = 'modules/search-properties/search-properties.cfm';
}
if ( activeLinkID === 'search_properties' currentPage === ''
)
{ window.location = '../search-properties/search-properties.cfm';
}
My first code, that still seems valid, was:
if ( activeLinkID === 'search_properties' (currentPage === 'index.cfm'
|| currentPage === '') )
{ window.location = 'modules/search-properties/search-properties.cfm'
}
else { window.location = '../search-properties/search-properties.cfm'
}
No syntax errors, but the page is not changed
to search-properties.cfm.
These lines are bypassed as if conditions are not met,
and the conditions are met.
They work if the URL ends in 'index.cfm', but not if the
URL is just the domain name.
I've tried every version of this I can think of.
Clues, anyone?
Rick
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347931
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Code from cfhtmlhead showing up in jQuery AJAX JSON data
Good job Steve!!
On Sep 24, 2011, at 8:18 AM, Rick Faircloth r...@whitestonemedia.com wrote:
Duh... Steve, what you and Russ have pointed out makes perfect sense.
My initial thought was to use onRequestStart, but for some reason
decided to use onApplicationStart, which wouldn't work for every page.
I guess I was thinking of just creating the variables once for
global use, rather than focusing on the fact that I needed to create
them for every page.
Thanks for the tip! (...and the code, Steve! :o)
And yes, it's CF9...
Rick
-Original Message-
From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com]
Sent: Saturday, September 24, 2011 8:41 AM
To: cf-talk
Subject: Re: Code from cfhtmlhead showing up in jQuery AJAX JSON data
You wouldn't put it in onApplicationStart, but onRequest (cf9+).
onRequest is only triggered on cfm requests, whereas a cfc would trigger
onCFCRequest. (I am assuming your Ajax requests are going to a CFC)
Set up your js vars in onApplicationStart
cfscript
application.siteDetail = {js_sitename=application.sitename,
js_website=application.website,
js_site_manager_dsn=application.site_manager_dsn,
js_client_dsn=application.client_dsn }
/cfscript
Then, in your onRequest (though some header include custom tag, included
at the page level, would be better and give greater flexibility)
cfoutputscript type=text/javascriptvar siteDetail =
#SerializeJSON(application.siteDetail)#;/script/cfoutput
Then, in your JS, access the vars from the JS obj
... // some JQuery Ajax call data object
data: $.extend(true,{},siteDetail,{someArg:1,someArg2:'myArg'})
There's probably many ways to handle all of this, but putting the output
in your onApplication or onSession methods is not the way to go.
Steve 'Cutter' Blades
Adobe Community Professional
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer
http://cutterscrossing.com
Co-Author Learning Ext JS 3.2 Packt Publishing 2010
https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-st
yle-user-interfaces/book
The best way to predict the future is to help create it
On 9/24/2011 7:31 AM, Rick Faircloth wrote:
Ok... something to talk about besides $20/hr (which may look
really good, depending on how hungry you are...)
I recently started using cfhtmlhead in onApplicationStart to put
the following CF/JS in the head of each page to translate my CF
site variables to JS:
cfset js_sitename = application.sitename/
cfset js_website= application.website /
cfset js_site_manager_dsn = application.site_manager_dsn/
cfset js_client_dsn = application.client_dsn /
cfoutput
script
var js_sitename = '#js_siteName#';
var js_website = '#js_website#';
var js_site_manager_dsn = '#js_site_manager_dsn#';
var js_client_dsn = '#js_client_dsn#';
/script
/cfoutput
However, I just coded a page to load its content via jQuery AJAX
which accesses a CFC method which uses cfSaveContent to generate
the page.s HTML and then saves that to a document, which is then loaded
via jQuery AJAX.
After cfSaveContent does its thing, I send a 'Success' message
in JSON back to the AJAX call. But this wasn't working. I've written
this routine hundreds of times, so I know nothing was wrong with the
AJAX code.
It turns out that the JS above in between the twocfoutput's was
being sent back in the JSON, which was causing the message being sent
back to the AJAX call to not just be 'Success', which would trigger
the page HTML loading.
Why would the above JS show up in the JSON data and what can I do about
it? Taking the cfhtmlhead functionality out of the application.cfc's
onApplicationStart routine and putting it manually in the head of the
document solved the problem, but I enjoyed being able to insert the
variable routine into the head of each page automatically.
Thoughts? Suggestions?
For $20 an hour? :o)
Rick
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347689
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Article on F'd Company mentions using CFML
According to stephen withington (Blue River) Apple actually uses Mura internally for content management. On Sep 8, 2011, at 4:20 PM, .jonah jonah@creori.com wrote: Pud just sold one of his companies - TinyLetter - to MailChimp: http://blog.mailchimp.com/mailchimp-acquires-tinyletter/ TinyLetter was built on the same CFML stack and as a side note to that MailChimp is OK with being a bit weird themselves: http://blog.mailchimp.com/ewww-you-use-php/ Pud's coment: http://news.ycombinator.com/item?id=2947822 Glad to see a bit of validation for CFML in the startup scene. On 9/8/11 1:29 PM, Dave Watts wrote: Passing this along as an FYI for fun. Came across this on the High Scalability blog. Talks about what the creator of F'edCompany uses for his backend (hint - uses CFML): http://highscalability.com/blog/2011/8/31/pud-is-the-anti-stack-windows-cfml-dropbox-xeround-jungledis.html The article is kind of interesting, in that it really says bad things about his technology choices, yet in the end acknowledges that they're working fine for him. His Twitter feed points out something I'd never heard before. If you go here, you'll see a CF error message: http://investor.apple.com/Application.cfc We can do better than that: http://investor.apple.com/stockquote.cfm ... and, it's running on IIS 6! Server:Microsoft-IIS/6.0 X-Powered-By:ASP.NET Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programming for an iPod - OT javascript/HTML question
So you have an example you can see online? Is it only mobile safari that breaks or does desktop safari as well? On Sep 6, 2011, at 1:25 PM, Stephens, Larry V steph...@indiana.edu wrote: I'm working on a form in CF that displays just fine on a desktop/laptop but the javascript breaks in Safari once I introduce a div. If anyone has a clue about this, please contact me off-list at steph...@indiana.edu Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: API Question
Extend it if the data in main.cfc doesn't need to be manipulated in some unique way by the API call. On Aug 1, 2011, at 10:55 AM, Eric Cobb cft...@ecartech.com wrote: I'm creating an API (if you can call it that) for one of our applications. It's nothing big or fancy, actually just 1 cfc with 1 method in it that's going to be a front-facing component for AJAX calls to hit. All it's going to do is take an ID, call our main cfc to do some processing, then return the results. My question is, is it better to have my API cfc just extend the main component, or should create the connection to the main component in the API cfc? What is the standard or preferred method for doing this? Thanks, Eric http://www.cfgears.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scoping
Local scope is only implied when using cf9 On May 18, 2011, at 11:51 AM, Eric Roberts ow...@threeravensconsulting.com wrote: We had a discussion at work as to whether or not we should scope local vars with the variables. scope since that is implied in a cfset. One camp says it is not needed because of the implicit scoping when using cfset...the other camp says it is better to tack on variables. and make it explicit for security and readability. Any thoughts? Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scoping
The variables scope isn't local. It's global to CFC or to the page. On May 18, 2011, at 8:56 PM, Eric Roberts ow...@threeravensconsulting.com wrote: So is there any real benefit in using or not using variables. For local variables? -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: Wednesday, May 18, 2011 12:40 PM To: cf-talk Subject: Re: scoping ALWAYS SCOPE! Especially if someone else might have to maintain the code someday. On Wed, May 18, 2011 at 9:51 AM, Eric Roberts ow...@threeravensconsulting.com wrote: We had a discussion at work as to whether or not we should scope local vars with the variables. scope since that is implied in a cfset. One camp says it is not needed because of the implicit scoping when using cfset...the other camp says it is better to tack on variables. and make it explicit for security and readability. Any thoughts? Er ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google Picasaweb API
I wrote a wrapper for picasa that you can use as the basis for your app. Http://Picasacfc.Riaforge.org On May 17, 2011, at 7:30 PM, Guru cfexp...@gmail.com wrote: One of my friend is a photographer and he need a shopping cart type application which he can sell his photo albums. He already uses Picasaweb desktop application for uploading his photos and don't want to interrupt that. I was thinking if anything is available out there, preferably in CF so I can modify by myself rather than writing something from the beginning. Any ref. would be appreciated. Thanks, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx Question
You could actually do this with jquery quite easily should you want to do it
client side.
$('a[href*=pdf]').click(function(){
window.open($(this).href);
})
On May 17, 2011, at 5:35 PM, Duane Boudreau du...@sandybay.com wrote:
Hi All,
First time posting in a very long time.
I'm stuck on a RegEx problem that I can't wrap my head around. I need to have
a block of html and I need to add target=_blank to any hyperlink that has a
pdf link in it. Any suggestions?
Here is the match string I tried so far but I don't think I'm even close.
a\\s[^]*href=['\\\]( (?i:)(?:jpg|gif|doc|pdf)$*)
If anyone can point me in the right direction it would be much appreciated.
TIA,
Duane
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344609
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question about API wrapper design
I've done this quite a bit. Perhaps some of my code could give you ideas? Start with http://foursquarecfc.riaforge.org then check my other projects. On Apr 15, 2011, at 5:08 PM, Jeff Gladnick jeff.gladn...@gmail.com wrote: I'm one of the developers working on a CFML wrapper for the highrise API (highrise.riaforge.org) and we're starting to plan out how we're going to organize the file structure. We have a few choices: 1) Separate file for each type of object (people, task, note, etc) 2) One big CFC file containing functions for each. Although it seems like a no brainer to go with #1, I figured it might be easier for CF developers to integrate into their projects if there was just a single file to include, rather then a big library. Advanced users could just strip out what they didn't want/need. The 2nd question is about function encapsulation. On the people object, http://developer.37signals.com/highrise/people, there seem to be 7 different variations of GET person that could all be combined into a single getPerson() function that had (at least) 7 different arguments. It seems like we could shrink the codebase a lot more this way. Any suggestions for file function organization? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Parsing .css files with CF
One thing to consider with this approach is that you lose the browser caching
benefits.
Is writing a CSS file at variable change time an option?
On Apr 14, 2011, at 11:21 AM, Rick Faircloth r...@whitestonemedia.com wrote:
So just use:
style.cfm
-
cfcontent type=text/css charset=ISO-8859-1
cfset variables.color = ##fff
cfoutput
body { color:#variables.color#; }
/cfoutput
Then in calling doc:
link rel=stylesheet href=style.cfm text=text/css /
???
Also, I got the charset=ISO-8859-1 from an example.
Is that necessary or important, and why?
-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com]
Sent: Thursday, April 14, 2011 12:05 PM
To: cf-talk
Subject: Re: Parsing .css files with CF
Nah. Just use .cfm and cfcontent to set the type of the .cfm to .css and
then you can actually call the .cfm where you'd usually call your .css file
in HTML. I promise it's easier done than said. :-)
On Thu, Apr 14, 2011 at 11:02 AM, Rick Faircloth
r...@whitestonemedia.comwrote:
So, is setting up IIS to cause CF to parse
CSS files still the best way to accomplish
using variables in CSS files?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343730
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrade Coldfusion from an upgrade?
Yea they do. On Jan 8, 2011, at 11:07 AM, Michael David presid...@planetarycorp.com wrote: Hi to all! Anyone know if licenses from MX7 upgrades qualify for CF9 upgrades? -- Cheers! Michael David ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: question for jquery experts here
Without seeing your code I'd wager that the problem is you're assigning too
many event handlers with your selector. Rather than putting a class on every
row of a table, put an I'd on the table and use this instead.
$('#myTable tr')
I'll bet that you'll get better performance.
On Dec 17, 2010, at 1:59 PM, fun and learning funandlrnn...@gmail.com wrote:
hi All -
I am using the following jquery script to hover and click on table rows:
$(.simplehighlight).click(function() {
$(this).children().addClass('clicked');
$(this).siblings().children().removeClass('clicked');
});
$(.simplehighlight).hover(function() {
$(this).children().css('backgroundColor', '#ffdc87');
}, function() {
$(this).children().css('backgroundColor', '');
});
'simplehighlight' is the class name of a tr. The script works fine in
Firefox, but the problem comes with IE8. I have around 20 to 25 columns, and
For hover, it takes some milliseconds to catch up with the cursor, and with
click, it takes around two seconds. Any suggestions on this?
I am asking this question in this forum, because lot of Coldfusion developers
use jquery. So trying my luck here too.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340125
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database query - match 1 or more zeros
Consider adding a caret to the start of the regex or you'll match multiple zeros anywhere in the cell. Would match 00 000 123000 12345670 On Dec 17, 2010, at 1:55 PM, Ian Skinner h...@ilsweb.com wrote: On 12/17/2010 11:41 AM, Michael Grant wrote: I think regex is the way to go for you. WHERE field = [0]* I think would work. Thanks, that was the seed of the idea I needed. WHERE REGEXP_LIKE(grower_id, '0+') I just changed it to 0+ because I wanted to match one or more zeros NOT zero or more zeros, which I expect would have matched ALL rows. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Builder now available, includes Flash Builder
Last night at midnight EST Adobe made available for purchase the final version of ColdFusion Builder. Priced at $299 it includes a full license of Flash Builder Standard. http://www.adobe.com/products/coldfusion/buy/ You can even upgrade to CFBuilder and Flash Builder from Flex Builder 3 for only $299. andy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help with apache web server v2.2.14
Mike. I don't think it actually matter what you put for local dev. On Mar 7, 2010, at 4:46 AM, Mike Kear afpwebwo...@gmail.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: iframe cfscript getting parent form field values
You could make this MUCH easier on yourself and just do a form POST into the iframe. Hekc, you could even use GET if you wanted to. Regardless, just target the iframe using JS then set hidden form fields to get passed in to. andy -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Saturday, February 20, 2010 10:17 PM To: cf-talk Subject: RE: iframe cfscript getting parent form field values No, if you are doing what I think you are trying to do then your best bet is Ajax. Once the server has processed the request, the client (browser) has control of the final request. If you are looking at populating things before the client receives it then you could do something like this cfoutput input value=#form.someValue# / /cfoutput However if you are looking at trying to do this once the user is doing something in the form then no, you need to think about ajax and/or process the form by sending it back to the server to process and return the entire page again. You have to remember that server and client can only talk in a certain manner, and if I am hearing you right you are needing to understand that before continuing with your development. -Original Message- From: Dan Blickensderfer [mailto:d...@blickensderfer.com] Sent: Sunday, 21 February 2010 2:04 PM To: cf-talk Subject: Re: iframe cfscript getting parent form field values Can I set the form value to a cfset variable? - Original Message - From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 20, 2010 10:01 PM Subject: RE: iframe cfscript getting parent form field values No, Cfscript is server side scripting. You need to write javascript to do this using document.all.form[0] -Original Message- From: Dan Blickensderfer [mailto:d...@blickensderfer.com] Sent: Sunday, 21 February 2010 1:40 PM To: cf-talk Subject: iframe cfscript getting parent form field values Hi everyone, I've ran into a problem and do not know if cfscript will allow this. I have a page that has an iframe and a form named eform with a half of dozen fields. I have a javascript function onblur on the last field to call another cf page (page2) through the iframe. I'm trying to get cfscript on the page2 to get the values of the eform of the parent page and set them to cf variables to query data and other logic. Will cfscript allow this and what would the proper syntax be? Thanks, Dan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: can't get encrypt to work.
I believe it's supposed to generate a new key every time. It's sort of like a UUID, unique with each iteration. If you're encrypting, with plans to decrypt later, then you'll have to store the key as well. Perhaps in a completely separate database, with no direct connection between the two? andy -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Tuesday, February 16, 2010 8:08 PM To: cf-talk Subject: Re: can't get encrypt to work. Yes, I found that via google. Maybe I'm not understanding how to use this properly. This works: cfset enc = Encrypt(test, generatesecretkey(DES), DES, hex) But this results in different values for each one: cfset key = generatesecretkey(DES) #key#br / cfset key = generatesecretkey(DES) #key#br / cfset key = generatesecretkey(DES) #key#br / cfset key = generatesecretkey(DES) #key#br / cfset key = generatesecretkey(DES) #key#br / The plan is to encrypt something and save it in the db. Then use it later and decrypt it. If the key changes everytime, won't I be unable to decrypt? On Tue, Feb 16, 2010 at 8:04 PM, Kevin Pepperman chorno...@gmail.comwrote: HOF had a similar discussion. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:52757 http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:52757 -- /Kevin Pepperman ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330810 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 Advanced Status?
In the past it's been 85% I believe. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Sunday, January 31, 2010 9:18 PM To: cf-talk Subject: CF8 Advanced Status? Does anyone know what the % score needed to get the Advanced Certified Status in CF8 is? I went searching for it (high and low!) but no dice. Hmm, maybe the Pentagon needs to hire Adobe to guard its papers. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: jQuery loaded page and cfwddx
If test.cfm has other markup then you need to rethink your use of cfwddx.
Just throw an cfoutput around everything you want to return to the calling
page. When the calling page receives the contents of test.cfm in the success
handler, then you can do something with it. In this case, I'm dumping the
entire contents of the cfm page into a div on the html page. Check it out:
TEST.cfm
cfset myVar = 10
cfoutputb#myVar# times #myVar# is #myVar * myVar#/b/cfoutput
TEST.html
-
html
head
title new document /title
script src=jquery/jquery-1.3.1.min.js
type=text/javascript/script
script type=text/javascript
!--
$(document).ready(function(){
$.get('test.cfm', function(data){
$('#myDiv').html(data);
});
});
//--
/script
/head
body
div id=myDiv/div
/body
/html
-Original Message-
From: Victor Moore [mailto:victor.mo...@gmail.com]
Sent: Sunday, January 24, 2010 5:55 PM
To: cf-talk
Subject: Re: jQuery loaded page and cfwddx
Yes, it helped crystallizing some ideas.
In my case test.cfm has a lot of other html markup and if I do an eval I get
an error.
I have tried sticking the javascript in a div and getting it after, which I
can and I can evaluate it too and dump the content to the console, but if I
try to access d i still get and undefined error.
Thanks again for your support
Victor
On Sat, Jan 23, 2010 at 8:50 PM, lists li...@commadelimited.com wrote:
Victor...
What version of CF are you using? Can you share your code? That would
be much simpler. I went ahead and threw together a quick example of
how cfwddx and an ajax call should work. Both files should be placed
in the same directory. Note that when test.html first loads, you'll
get an alert with plain text...that's the string that's actually being
returned by the cfm page. Before it can be used as JavaScript, it must
first be evaluated.
TEST.CFM
-
cfscript
myStruct = {};
myStruct['one'] = 1;
myStruct['two'] = 2;
myStruct['three'] = 3;
/cfscript
cfwddx action=cfml2js input=#myStruct# topLevelVariable=d
TEST.HTML
-
html
head
title new document /title
script src=jquery/jquery-1.3.1.min.js
type=text/javascript/script
script type=text/javascript
!--
$(document).ready(function(){
$.get('test.cfm', function(data){
alert(data);
eval(data);
console.log(d);
alert(d['two']);
});
});
//--
/script
/head
body
!--- left empty ---
/body
/html
Hope this helps you out.
-Original Message-
From: Victor Moore [mailto:victor.mo...@gmail.com]
Sent: Saturday, January 23, 2010 6:55 PM
To: cf-talk
Subject: Re: jQuery loaded page and cfwddx
Yes, it's a get.
It seems that after I restarted the browser the jQuery event click on
the button works.
But I still can't access the toplevelvariable that was setup by the
cfddx call when the page was loaded.
Thanks
Victor
On Sat, Jan 23, 2010 at 6:27 PM, lists li...@commadelimited.com wrote:
I assume you're using a get call. What happens when you console.log
the argument passed to your success callback function?
If you're not using getjson Then most likely you need to evaluate the
argument before it's ready to be used.
On Jan 23, 2010, at 2:06 PM, Victorng Moore victor.mo...@gmail.com
wrote:
Hi,
I am loading a cfm page with jQuery.
On that page I use cfwddx.. action=cfml2js...
If I try to access the top variable and it tells me that it's
undefined, bu I can clearly see it in firebug if i expend the jQuery
call that it's there.
any idea what I'm missing?
Thanks
Victor
PS BTW i have also tried to trigger a click event on a button on
the page and it's not being triggered.
I have tried using the live function too with no success
$(input:button[name='test']).live (click, function(){
alert (this.id);
});
No error but no alert...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330093
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery loaded page and cfwddx
I assume you're using a get call. What happens when you console.log
the argument passed to your success callback function?
If you're not using getjson Then most likely you need to evaluate the
argument before it's ready to be used.
On Jan 23, 2010, at 2:06 PM, Victorng Moore victor.mo...@gmail.com
wrote:
Hi,
I am loading a cfm page with jQuery.
On that page I use cfwddx.. action=cfml2js...
If I try to access the top variable and it tells me that it's
undefined, bu I can clearly see it in firebug if i expend the jQuery
call that it's there.
any idea what I'm missing?
Thanks
Victor
PS BTW i have also tried to trigger a click event on a button on the
page and it's not being triggered.
I have tried using the live function too with no success
$(input:button[name='test']).live (click, function(){
alert (this.id);
});
No error but no alert...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330076
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: jQuery loaded page and cfwddx
Victor...
What version of CF are you using? Can you share your code? That would be
much simpler. I went ahead and threw together a quick example of how cfwddx
and an ajax call should work. Both files should be placed in the same
directory. Note that when test.html first loads, you'll get an alert with
plain text...that's the string that's actually being returned by the cfm
page. Before it can be used as JavaScript, it must first be evaluated.
TEST.CFM
-
cfscript
myStruct = {};
myStruct['one'] = 1;
myStruct['two'] = 2;
myStruct['three'] = 3;
/cfscript
cfwddx action=cfml2js input=#myStruct# topLevelVariable=d
TEST.HTML
-
html
head
title new document /title
script src=jquery/jquery-1.3.1.min.js
type=text/javascript/script
script type=text/javascript
!--
$(document).ready(function(){
$.get('test.cfm', function(data){
alert(data);
eval(data);
console.log(d);
alert(d['two']);
});
});
//--
/script
/head
body
!--- left empty ---
/body
/html
Hope this helps you out.
-Original Message-
From: Victor Moore [mailto:victor.mo...@gmail.com]
Sent: Saturday, January 23, 2010 6:55 PM
To: cf-talk
Subject: Re: jQuery loaded page and cfwddx
Yes, it's a get.
It seems that after I restarted the browser the jQuery event click on the
button works.
But I still can't access the toplevelvariable that was setup by the cfddx
call when the page was loaded.
Thanks
Victor
On Sat, Jan 23, 2010 at 6:27 PM, lists li...@commadelimited.com wrote:
I assume you're using a get call. What happens when you console.log
the argument passed to your success callback function?
If you're not using getjson Then most likely you need to evaluate the
argument before it's ready to be used.
On Jan 23, 2010, at 2:06 PM, Victorng Moore victor.mo...@gmail.com
wrote:
Hi,
I am loading a cfm page with jQuery.
On that page I use cfwddx.. action=cfml2js...
If I try to access the top variable and it tells me that it's
undefined, bu I can clearly see it in firebug if i expend the jQuery
call that it's there.
any idea what I'm missing?
Thanks
Victor
PS BTW i have also tried to trigger a click event on a button on the
page and it's not being triggered.
I have tried using the live function too with no success
$(input:button[name='test']).live (click, function(){
alert (this.id);
});
No error but no alert...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330082
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HOF site down for several days?
I got a Java error this morning when I first read the thread. It's working fine now. -Original Message- From: Dave Merrill [mailto:dmerr...@usa.net] Sent: Saturday, January 09, 2010 7:17 PM To: cf-talk Subject: RE: HOF site down for several days? All three seem fine now. Odd, dns hiccup maybe. Thanks for checking Michael. Dave Merrill Web . Database . Interaction Design I haven't seen any problems with the site for the last few days. Can you hit www.fusionauthority.com or www.blogoffusion.com? They are on the same machine. Actually, I'm sending this through the list archives. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting an AJAX response to coldfusion object
Any remote call to a CFC will return WDDX (unless otherwise specified).
You could serialize the JS object into JSON, then pass it to ColdFusion as a
struct.
-Original Message-
From: Developer MediaDoc [mailto:skings...@media-doc.com]
Sent: Thursday, November 19, 2009 9:32 PM
To: cf-talk
Subject: Converting an AJAX response to coldfusion object
Hi all,
I am probably not using the correct 'language' here -- forgive me new to the
AJAX world.
I have a lovely cfgrid populated by binding it to a CFC. Everything works
great. I have some 'filters' that let the users filter the data in the grid.
Now the client has asked to have a 'download grid data to excel.'
I've done this many times in the past - just not with AJAX data. Now I am
stuck.
The data is in a javascript object, which I'd like to convert to a
coldfusion object.
I've tried statements like cfset cfData=DeserializeJSON(theData)
and I've set 'theData' via javascript like var theData=
ColdFusion.Grid.getGridObject('resource_list');
But I keep getting errors on variable theData not found.
a) if I don't specify returnFormat in my CFC, what format does cfgrid data
come back as? (JSON, WDDX?).
b) how can I convert the javascript object into a coldfusion object?
c) or should I be doing something totally different :-)
I am missing something -- help/suggestions much appreciated!
Cheers,
Matts
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328564
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex help with invalid HTML
Andy matthews, you're welcome. -Original Message- From: Mark Henderson [mailto:m...@cwc.co.nz] Sent: Monday, November 16, 2009 4:29 PM To: cf-talk Subject: RE: Regex help with invalid HTML Azadi Saryev wrote on 16 November 2009 at 17:58 you can do it with something like this: cfset line='trtd class=la href=/blah.com/atd31 622td25 623td193 645td840 642td1.9 GB' cfset cleanline = rereplace(line, 't[^]+', '|', 'all') cfoutput#listfirst(cleanline, '|')# #listlast(cleanline, '|')#/cfoutput and if you do not want any html in final result (not even a tag), then use: cfset cleanline = rereplace(line, '[^]+', '|', 'all') Thanks Azadi. That's all I needed to get the thought processes rolling in the right direction (it never occurred to me to check each entry was on a new line, so thanks also to the individual I can only refer to as list!). Here's the truncated code relevant to the question I asked that's working: cfhttp url=http://localhost/statsmerged.html; cfset sStartString = cfhttp.filecontent cfset sStartTag = FindNoCase(td class='l', sStartString) cfset sTempString = RemoveChars(sStartString,1, sStartTag-1) cfset sEndTag = FindNoCase(/table, sTempString) cfset sFinalString = RemoveChars(sTempString,sEndTag, Len(sTempString)) cfloop index=thisLine list=#sFinalString# delimiters=#chr(10)##chr(13)# cfset cleanLine = ReReplace(thisLine, '[^]+', '|', 'all') cfoutput#listFirst(cleanLine, '|')# #listLast(cleanLine, '|')#/cfoutput /cfloop ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex help with invalid HTML
testing -Original Message- From: Mark Henderson [mailto:m...@cwc.co.nz] Sent: Monday, November 16, 2009 4:29 PM To: cf-talk Subject: RE: Regex help with invalid HTML Azadi Saryev wrote on 16 November 2009 at 17:58 you can do it with something like this: cfset line='trtd class=la href=/blah.com/atd31 622td25 623td193 645td840 642td1.9 GB' cfset cleanline = rereplace(line, 't[^]+', '|', 'all') cfoutput#listfirst(cleanline, '|')# #listlast(cleanline, '|')#/cfoutput and if you do not want any html in final result (not even a tag), then use: cfset cleanline = rereplace(line, '[^]+', '|', 'all') Thanks Azadi. That's all I needed to get the thought processes rolling in the right direction (it never occurred to me to check each entry was on a new line, so thanks also to the individual I can only refer to as list!). Here's the truncated code relevant to the question I asked that's working: cfhttp url=http://localhost/statsmerged.html; cfset sStartString = cfhttp.filecontent cfset sStartTag = FindNoCase(td class='l', sStartString) cfset sTempString = RemoveChars(sStartString,1, sStartTag-1) cfset sEndTag = FindNoCase(/table, sTempString) cfset sFinalString = RemoveChars(sTempString,sEndTag, Len(sTempString)) cfloop index=thisLine list=#sFinalString# delimiters=#chr(10)##chr(13)# cfset cleanLine = ReReplace(thisLine, '[^]+', '|', 'all') cfoutput#listFirst(cleanLine, '|')# #listLast(cleanLine, '|')#/cfoutput /cfloop ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Regex help with invalid HTML
Will it always be a domain name you want to keep? And will the file size always be at the very end of the line? -Original Message- From: Mark Henderson [mailto:m...@cwc.co.nz] Sent: Sunday, November 15, 2009 8:38 PM To: cf-talk Subject: Regex help with invalid HTML Calling all regex gurus. I've spent a little time on this so now it's time to seek advice from the professionals. Here is an example of the content I'm working with: trtd class=la href=/abc.co.nz/atd52 363td73 815td5 122 265td2 166 760td471.47 MB trtd class=la href=/xyz.co.nz/atd31 622td23 443td193 645td840 642td1.8 GB trtd class=la href=/blah.com/atd31 622td25 623td193 645td840 642td1.9 GB And what I want to do is remove everything between the first td (after the closing /a) and the last td BEFORE the next tr. E.G. This trtd class=la href=/abc.co.nz/atd52 363td73 815td5 122 265td2 166 760td471.47 MB becomes trtd class=la href=/abc.co.nz/a 471.47 MB At that point I will then strip all the remaining HTML tags (which I can do) and I should be good to go. Unfortunately I have no control over this code as it is generated by a stats program, and if indeed it used the correct closing tags and validated I could probably fumble around and eventually achieve what I want, as I've done in the past. And just in case anyone out there can do all this in one hit, ultimately I want the output from above to look like this: abc.co.nz 471.47 MB xyz.co.nz 1.8 GB blah.com 1.9 GB etc. I hope that makes sense. TIA Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ISAPI Rewrite
Ah. I assumed that was just part of your example. In the ISAPI Rewrite rule I wrote for a client I did not need to escape the ? Or period when used like I wrote. andy -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Thursday, November 12, 2009 4:51 AM To: cf-talk Subject: Re: ISAPI Rewrite Why have a rule for each article when you could use the same rule for all of them? Because the ids do not correlate. but I can figure out how to get the article.php?id=10 to be found using ISAPI rewrite I think you're close - the period and question marks are special regex characters that need escaping, and the parenthesis are redundant. Try: RewriteRule /article\.php\?id=10 /index.cfm?event=IndustryNewsDetailIndustryNewsID=24 [I,O,RP,L] RewriteRule /article\.php\?id=11 /index.cfm?event=IndustryNewsDetailIndustryNewsID=25 [I,O,RP,L] Here's a really useful regex tester: http://gskinner.com/RegExr/ Dominic 2009/11/12 lists li...@commadelimited.com Why have a rule for each article when you could use the same rule for all of them? Try this out: RewriteRule (.*)/article.php?id=([0-9]+) $1/index.cfm?event=IndustryNewsDetailIndustryNewsID=$2 -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: Wednesday, November 11, 2009 9:07 PM To: cf-talk Subject: ISAPI Rewrite I am trying to use ISAPI rewrite for some 301 redirects and can't figure out the Reg Ex for it. I need [article.php?id=10] to be 301 redirected to [index.cfm?event=IndustryNewsDetailIndustryNewsID=24] and [article.php?id=11] to be 301 redirected to index.cfm?event=IndustryNewsDetailIndustryNewsID=25] but I can figure out how to get the article.php?id=10 to be found using ISAPI rewrite currently trying with no luck RewriteRule /article.php(\?)?(id=10) /index.cfm?event=IndustryNewsDetailIndustryNewsID=24 [I,O,RP,L] RewriteRule /article.php(\?)?(id=11) /index.cfm?event=IndustryNewsDetailIndustryNewsID=25 [I,O,RP,L] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CKEditor
You might have trouble finding it if you're looking for CKEditor. In CF 8 it was still called FCKEditor. -Original Message- From: Terry Troxel [mailto:te...@it-werks.com] Sent: Wednesday, November 11, 2009 5:37 AM To: cf-talk Subject: CKEditor Has anyone used this in CF8. I can't find any documentation for Integration to Coldfusion. Terry Troxel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ISAPI Rewrite
Why have a rule for each article when you could use the same rule for all of them? Try this out: RewriteRule (.*)/article.php?id=([0-9]+) $1/index.cfm?event=IndustryNewsDetailIndustryNewsID=$2 -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: Wednesday, November 11, 2009 9:07 PM To: cf-talk Subject: ISAPI Rewrite I am trying to use ISAPI rewrite for some 301 redirects and can't figure out the Reg Ex for it. I need [article.php?id=10] to be 301 redirected to [index.cfm?event=IndustryNewsDetailIndustryNewsID=24] and [article.php?id=11] to be 301 redirected to index.cfm?event=IndustryNewsDetailIndustryNewsID=25] but I can figure out how to get the article.php?id=10 to be found using ISAPI rewrite currently trying with no luck RewriteRule /article.php(\?)?(id=10) /index.cfm?event=IndustryNewsDetailIndustryNewsID=24 [I,O,RP,L] RewriteRule /article.php(\?)?(id=11) /index.cfm?event=IndustryNewsDetailIndustryNewsID=25 [I,O,RP,L] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: passing coldfusion variable to javascript
Also, if the JS file is on the same server as the processing page you could simply read in the JS file, replace the variables with their ColdFusion equivalents and go from there. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Saturday, November 07, 2009 7:52 AM To: cf-talk Subject: Re: passing coldfusion variable to javascript Well, obviously, JS is client side code and CF is server side. Normally if I wanted to let JS work with a CF variable, I'd simply output it: cfoutput script var x = #x# /script /cfoutput or cfoutput script var #toScript(x, x)# /script /cfoutput However, in your case, the JS library isn't emdedded on the page, but loaded externally. So your options then are a bit different. You could put the CF variable in a hidden form field and just read it that way. That would be OK for simple variables. Another option is to use AJAX to fetch the value. On Sat, Nov 7, 2009 at 5:28 AM, Jayel Villamin jayel.villa...@flinders.edu.au wrote: I have an external javascript file which I have attached to my page. I want to set some variables in this file to corresponding CF variables. How can I do this? I tried: - html cfoutput head script src=my_own.js/script /head /cfoutput body my web page /body /html - but the CF code (e.g. #my_variable_name#) inside the my_own.js file remains unchanged. Any ideas? Thank you ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328116 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 and coldfusion
jQuery explicitly offers compatibility mode for use alongside other frameworks. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, October 21, 2009 12:02 AM To: cf-talk Subject: Re: javascript and coldfusion H reading this chain of emails... a question raised in my mind can we use multiple frameworks on the same page... I mean can use jQuery to create a window and use ExtJS for displaying a grid Generally, yes, although some frameworks may have compatibility issues with others (Prototype comes to mind). Keep in mind that more frameworks means more JS files for your user to download, though. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Database-less queries
A super simple method would be to store the plain text as ColdFusion's JSON
format. You could change it up, add (or remove) rows, and more. Then
whenever you need to, just have CF convert it a native query object:
Peep this sample code:
cfset REQUEST.q = QueryNew('firstname, lastname, email')
cfset QueryAddRow(REQUEST.q,3)
cfset QuerySetCell(REQUEST.q, 'firstname', 'neil', 1)
cfset QuerySetCell(REQUEST.q, 'lastname', 'finn', 1)
cfset QuerySetCell(REQUEST.q, 'email', 'nf...@crowdedhouse.com', 1)
cfset QuerySetCell(REQUEST.q, 'firstname', 'thom', 2)
cfset QuerySetCell(REQUEST.q, 'lastname', 'yorke', 2)
cfset QuerySetCell(REQUEST.q, 'email', 't...@radiohead.com', 2)
cfset QuerySetCell(REQUEST.q, 'firstname', 'ben', 3)
cfset QuerySetCell(REQUEST.q, 'lastname', 'folds', 3)
cfset QuerySetCell(REQUEST.q, 'email', 'b...@benfoldsfive.com', 3)
cfset REQUEST.toJSON = SerializeJSON(REQUEST.q)
cfset REQUEST.fromJSON = DeserializeJSON(REQUEST.toJSON, false)
cfdump var=#REQUEST#
cfabort
The key is the false flag in the Deserialize. It prevents ColdFusion from
converting the incoming string into strict data types (like arrays and
structs). Remove it, or change it to true, and you'll see what I mean. So
convert your query into JSON once then save that off and format it nice and
pretty so that it's human readable, and save it as a text file or something.
andy
-Original Message-
From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com]
Sent: Saturday, October 03, 2009 7:58 PM
To: cf-talk
Subject: Database-less queries
There are times when I have a simple problem that calls for a simple
solution. I have data that is perhaps a half dozen columns and three dozen
rows; I was thinking how it would be cool to load that data somehow as a
query object in a memory-resident (most likely application scope) variable,
with the data stored as wddx in a text file that would get loaded when the
application loads. New data could be added by loading the object into a
cfgrid.
Before I venture forth on this bit of experimental (for me) coding, I was
wondering if anyone else has done this, and what were the results? This is
really more of a proof of concept, and would be used with a relatively low
traffic web site.
Thanks,
Pete
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF jQuery - How to delay ajax completion until images are processed...
Rick... Are you using the GET/POIST methods, or using the AJAX methods from within jQuery? AJAX is gonna be your best bet as it's got more options. andy -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Tuesday, September 22, 2009 10:13 PM To: cf-talk Subject: RE: CF jQuery - How to delay ajax completion until images are processed... Thanks for the tip, James... I tried to use the setting async: false in the ajax parameters, but that didn't seem to have any effect. I wish I could somehow let the image processing continue even if the close button on the success dialog is clicked. But that causes the processing to stop. It might work if I weren't re-writing the property list on the screen after adding a property, but that defeats the whole purpose of using ajax. Clients have commented about the length of time it takes for all the image processing to occur. I even tried putting the image processing part of the cfc method into a cfthread, but that didn't seem to help, either. I'll check out your link...perhaps that's the answer. Rick -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Tuesday, September 22, 2009 11:01 PM To: cf-talk Subject: Re: CF jQuery - How to delay ajax completion until images are processed... It sounds like you need a synchronous request e.g.: http://stackoverflow.com/questions/133310/how-can-i-get-jquery-to-perform-a- synchronous-rather-than-asynchronous-ajax-req Of course, if you have to wait for a response, it may be worth simply doing a normal post rather than using ajax. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/9/23 Rick Faircloth r...@whitestonemedia.com: Got a combination CF jQuery question for those of you who use both.usually, I can get a better response from folks who use CF jQuery than I can from those who use only jQuery. I've got an ajax call (not AJAX call.) that inserts property data into a database then processes from 1 to usually no more than around 10 images, creating multiple sizes, etc. The problem I'm having is that the ajax call, being asynchronous, returns back to the calling page and continues executing instructions before the images are all processed. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Displaying image from a byte array
Ray should be right. I've passed raw image byte data from flex to coldfusionjedi with no problem. If you're receiving the data in a cfc just type the argument as binary. On Sep 13, 2009, at 9:40 AM, Raymond Camden rcam...@gmail.com wrote: Is it a Java buffered image? If so you can pass it to ImageNew(). Have you tried that? On Sun, Sep 13, 2009 at 5:44 AM, Omotola Anjorin anjorin_...@totco.org wrote: Please i need display an image from a byte array. The byte array contains a fingerprint image captured from the fingerprint device. I am using the java class from coldfusion, i am having problem displaying the image from the byte array. The fingerprint device is Secugen Hamster plus should anyone have integrated it with coldfusion. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help with cgi server
yes, you'd have to take this up with your hosting company. You can look around your hosting control panel, or just email their tech-support. - Rex -- i've created a table in my db that allows the header and footer to adjust depending on the subdomain. basically the code calls: cfquery name=partner datasource=#dsn# SELECT * FROM Partners WHERE URL = '#cgi.server_name#' /cfquery it is recognizing the root domain (www.domain.com) but getting a page not found error when dealing with any of the subs. do i need my hosting company to make any adjustments to accommodate subdomains (#url#.domain.com) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Disable Image Button in IE
What happens after the page submits and you hit the browser's back button, is your image still disabled or can u click on it again? -Original Message- From: morgan l [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:04 AM To: CF-Talk Subject: Re: Disable Image Button in IE Should be as simple as an onclick=this.disabled = true : input type=image src=/images/buttons/button_save.gif onclick=this.disabled=true / Works for me in IE7 in my quick test. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: XML Help
Adrian, That worked, thank you. But, why can't I access the elements the way I had it? I have used that method many times before with no problems. Is there something wrong with the XML that was sent to us? Dave -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, December 28, 2007 6:37 AM To: CF-Talk Subject: RE: XML Help Have a look at using XMLSearch cfsavecontent variable=x?xml version=1.0 standalone=no? !DOCTYPE schema SYSTEM http://devweb0010.propay.com/PPResponse; XMLResponse XMLTrans transType02/transType invNumpp1/invNum status00/status transNum2/transNum /XMLTrans /XMLResponse/cfsavecontent cfset x = XMLParse(x) cfdump var=#x# cfset status = XMLSearch(x, /XMLResponse/XMLTrans/status) cfdump var=#status[1].XmlText# Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Dave Hatz [mailto:[EMAIL PROTECTED] Sent: 28 December 2007 14:14 To: CF-Talk Subject: XML Help I am having a hell of a time trying to figure out what I am doing wrong with the following XML: ?xml version=1.0 standalone=no? !DOCTYPE schema SYSTEM http://devweb0010.propay.com/PPResponse; XMLResponse XMLTrans transType02/transType invNumpp1/invNum status00/status transNum2/transNum /XMLTrans /XMLResponse I have the following CF code to parse the XML: cffile action=read file=d:/inetpub/wwwroot/x2.xml variable=infile cfset x2=XmlParse(infile) cfdump var=#x2# cfset x=x2.XMLResponse.XMLTrans.status.XmlText Everytime I try to access any of the elements of the XML I get : Element XMLRESPONSE.XMLTRANS.STATUS.XMLTEXT is undefined in X2 I have tried it with .XmlText and without .XmlText and get the same results. When I view the CFDUMP of the XML, it looks fine. Can someone please clue me in on what I am doing wrong here? I am running this on CF7 on a Windows 2003 box. Thanks, Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse/CFEclispe
Is Aptana compatible with Eclipse 3.3 yet? -Original Message- From: Dan Vega [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 7:52 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe You can also look at Aptana, I use that plugin and it has a lot of nice features. http://www.aptana.org On 8/8/07, Dawson, Michael [EMAIL PROTECTED] wrote: Yeah, that's a good question. I have the WTP build, but I don't really see any other features, such as CSS, when I'm editing .css files or even styles within an HTML page. M!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 9:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFEclipse not compatible w/ Eclipse 3.3
Mark, How would a case of Jack contribute? Dude, I saw your session at CFUnited and I would buy u 10 cases of Jack for all the time you have saved me with your great plug-in. I think I speak for a lot of other CF developers as well, hell of job and thank you. Cheers... Dave -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 2:32 PM To: CF-Talk Subject: Re: CFEclipse not compatible w/ Eclipse 3.3 Brian is right, I WAS running CFEclipse on Eclipse 3.3 but I have found some bugs and missing features I want to update to make sure they are working, not just on Eclipse 3.3 but on 3.2 and even 3.1. Dean Harmon did a lot of coding at CFUnited and we got a running version, now this running version runs from debug but there are some issues with actually deploying it (not just running it as a debug) which I am trying to fix before I check something in. My process for check-ins tends to be that every check in relates to a bug and most of the time I am trying to check in something that closes that bug. So stick with 3.2 and in the coming days I shall do a release that you can try out, there are other things in that release that I want to polish off and give a usable product, rather than a bleeding edge (because it takes a lot of effort to do an update site, so might as well do it for a useful version) So, we ARE on the case, and if you think about it, its rather unfair to expect a release a WEEKEND after they have released 3.3. I barely managed to download Eclipse 3.3 FINAL at the airport on the way home... and you already want a fixed, tested, and deployed version by monday (when I was doing a talk on saturday and flying home on sunday/ monday). This is a team of one. ME. Its like expecting all the CF5 applications to work the day CF 6 was released with both quality assurance and deployment on lots of platforms with different databases. I am also deploying *NEW* functionality so need to make sure that works and makes sense! So bear with me please. Or, bloody well contribute and try and fix the bugs yourselves! Mark Drew On 2 Jul 2007, at 15:46, Brian Kotek wrote: It's a bleeding edge version of the codebase but it isn't the actual development repository. What goes into bleeding edge is still what he considers to be relatively stable (enough to let others use). So think of it as Beta or Release Candidate code, but not Alpha or pre-Alpha. Don't worry, it's coming. He's having to rework a good bit of stuff since the changes in 3.3 are quite extensive under the hood. On 7/2/07, Dan G. Switzer, II [EMAIL PROTECTED] wrote: But it is not in the Source Repository I thought that this was used for bleeding edge development? Quite frankly, I wouldn't blame Mark at all for not checking in code which he thought still was buggy to public repositories. If he checks in code that he knows is buggy, he's just going to end up opening the flood gates with questions. Now, I'm sure if he got more people who were actively helping with development that policy might change. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282761 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 escape the character # in a string
That did the trickthanks for all the help guys. Dave -Original Message- From: Mik Muller [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 11:08 AM To: CF-Talk Subject: Re: How to escape the character # in a string newVar=Replace(var,chr(35), ,ALL); or newVar=Replace(var,chr(35),chr(32),ALL); At 01:46 PM 6/5/2007, you wrote: I am trying to do the following, newVar=Replace(var,#, ,ALL); but the # is throwing errors. I have tried ## and it runs, but will not replace the # in my strings. Any suggestions? Thanks, Dave Hatz ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform format=flash won't render
start with upgrading to cf 702, that will solve the active-x warning - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 24, 2006 9:12 PM Subject: cfform format=flash won't render We recently installed CF 7. I created a simple page to test Flash Forms. Here is the code, pretty much right out of Ben Forta's book: I get a page with a box around it an a tool-tip-like box saying to click to Press SPACE BAR or ENTER to activate and use this control. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get DNS servers programatically
Hello, I'm looking for a way to obtain the DNS servers of a domain without having to do a whois and parsing the whois information. I have been able to get the IPs of www.domain.com but can't get ns1.hostingprovider.com and ns2.hostingprovider.com from domain.com if those are the NS records... Anybody have any insight? Thanks, -Blaine ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recommendations for a mail server...
get iMSLite (free) http://www.coolfusion.com/Commerce/index.cfm?category=7 the relay server will allow you to get your mail off your box - Original Message - From: Russ [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 19, 2006 9:44 PM Subject: RE: Recommendations for a mail server... My scenario is that I don't provide POP accounts and am trying to using SMTP to move mail generated by CF through the mail server. I guess I'm trying to act like an open relay without actually being one... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Get DNS servers programatically
This is what worked the best... I'm just using some quick parsing code to take the DNS servers out of the string NSlookup returned... Thanks everyone! -Blaine - Original Message Follows - From: Gareth Hughes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Get DNS servers programatically Date: Thu, 19 Oct 2006 20:28:19 +0100 Or nslookup on windows: cfexecute name=nslookup.exe timeout=5 arguments=-q=ns houseoffusion.com variable=dnsinfo / cfdump var=#dnsinfo# - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 19, 2006 7:51 PM Subject: Re: Get DNS servers programatically lists wrote: Hello, I'm looking for a way to obtain the DNS servers of a domain without having to do a whois and parsing the whois information. I have been able to get the IPs of www.domain.com but can't get ns1.hostingprovider.com and ns2.hostingprovider.com from domain.com if those are the NS records... Anybody have any insight? Thanks, -Blaine ~~~ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257510 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Database of phone countrycodes?
http://www.lincmad.com/countrycodes.html - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 10, 2006 1:45 PM Subject: Database of phone countrycodes? I'm sorry if this is a duplicate post, but I posted it about 20 hours ago now and it still hasn't appeared on the list so I figured something must have gone astray somewhere along the way Does anyone know if there's a ready-made, freely downloadable database of the countries and the telephone dialing codes for them? Free would be good but could pay a moderate amount if necessary. I have an app where i need to match phone numbers to countries of residence and one of the things I need to do is check the phone number includes the correct country dialing code. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF IIS -- any way to treat .html files as .cfm?
you also need to make changes in the coldfusion xml config file to get coldfusion to actually process the html files as if they were cfml files towards the end of the file you find at C:\CFusionMX\wwwroot\WEB-INF\web.xml , I added servlet-mapping id=macromedia_mapping_14 servlet-nameCfmServlet/servlet-name url-pattern*.html/url-pattern /servlet-mapping servlet-mapping id=macromedia_mapping_15 servlet-nameCfmServlet/servlet-name url-pattern*.html/*/url-pattern /servlet-mapping - Original Message - From: Matt Williams [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, September 02, 2006 6:00 AM Subject: Re: CF IIS -- any way to treat .html files as .cfm? I'm thinking you can have .html, .htm or even .asp handled by the CF server. I could be way off, but go to IIS, WebSite, Properties, HomeDirectory, Configuration. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF IIS -- any way to treat .html files as .cfm?
http://www.talkingtree.com/blog/index.cfm/2006/2/17/CF-Custom-File-Extensions - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, September 02, 2006 8:34 AM Subject: Re: CF IIS -- any way to treat .html files as .cfm? No sure you even have to do this, will have to check. All you should need to do is add\modify IIS to throw htm files to the jrun.dll. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Declaring SQL variables
without testing: I think the into only takes the name of the (new) table If you need to change the column names you could try it like this: SELECT SiteAreaName as DeletedAreaName, Lft as DeletedLft , Rgt as DeletedRgt INTO DeletedArea FROM directoryLinks WHERE SiteAreaName = '#ARGUMENTS.SiteAreaName#' - Original Message - From: Richard Cooper [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 23, 2006 12:39 PM Subject: CF Declaring SQL variables Hi all, I've a section of query I'm trying to run, I've tried lots of different ways to write it but have had no success yet Does anyone know how this query should be written: [code] cfquery name=breadcrumb datasource=#REQUEST.theDatabase# !---SELECT the values for the Deleted level into variables--- DECLARE DeletedAreaName VARCHAR(50); DECLARE DeletedLft INTEGER; DECLARE DeletedRgt INTEGER; SELECT SiteAreaName, Lft, Rgt INTO DeletedAreaName, DeletedLft, DeletedRgt FROM directoryLinks WHERE SiteAreaName = '#ARGUMENTS.SiteAreaName#' /cfquery [/code] Thanks, Richard ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Only update DB if data has changed?
one way would be to build a string of all elements of 1 field, get the hash of this string and include that as a hidden field, then you do the same for the posted info and compare both hash strings - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, May 26, 2006 11:14 AM Subject: RE: Only update DB if data has changed? Should be easy enough and no doubt several way s to achieve thisboth in CF Code and in SQL. One way would be to load the records at page load into a structure and then on submit comparing both the pre-edited and post edited form struct to see what has changed etc... -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: 26 May 2006 10:25 To: CF-Talk Subject: Only update DB if data has changed? Hi all, does anybody have any ideas how I could best implement the following; I have a page that loads anything up to about 30 individual records at a time. Each record consists of 17 fields of data. All the records are displayed on the page to give the user the option of editing any individual field. When the user then submits the page I need to be able to work out which records have had data changed and only do database updates for those specific records. Having an individual submit for each record is not an option, the whole page must be submitted as one but only records that have changed should be updated. Can anybody suggest a method for doing this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SERVER scope in CF Enterprise
Hi, If you're running CF Enterprise with sandboxes, does the SERVER scope still apply to the entire server or dos each sandbox have its own SERVER scope? Cheers, Baz ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228116 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: determine SQL Server Version via Ent Mngr
SELECT SERVERPROPERTY('ProductVersion');
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, December 20, 2005 8:26 PM
Subject: OT: determine SQL Server Version via Ent Mngr
Can anyone point me to a way that I can determine the version of a remote
SQL Server database via Enterprise Manager?
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
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227360
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Server 2005 and CF?
I think the driver class name should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
if you drop the jar in the cf lib dir you do not need to change the
classpath
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, November 27, 2005 1:36 PM
Subject: SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the
OS). Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource
name ('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc
Driver Name: com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix,
please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver
available for comix, please check the driver setting in resources
file, error: com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant,
but none that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with
P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of
SQL Server), but had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not
2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The
settings that I've posted above are kind of an amalgam of what I was
able to glean from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The
last was due to a suggestion that Kola had made regarding placing the
jar file in the CFusion\lib directory (I copied the file over
over...wasn't sure if that would require a classpath variable, but
figured it wouldn't hurt to try). CFMX service was cycled after each
time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap
(it's 7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225326
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query caching and cfcs
that's what I figured...danke -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX, multi instance, and logs
Where oh where is the log destination set for CFMX?I have multi-instances of CFMX on a box and I can't get teh application, server, etc logs going.The original CFMX instance is working, bu the second is not.I set the destination on the second instance correctly in the CFADMIN tool D:\JRun4\servers\myserver\cfusion-ear\cfusion-war\WEB-INF\cfusion\logs but nothing is there.Which one of the zillion XML files is this setting in? --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelouon't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX, multi instance, and logs
Where oh where is the log destination set for CFMX?I have multi-instances of CFMX on a box and I can't get teh application, server, etc logs going.The original CFMX instance is working, bu the second is not.I set the destination on the second instance correctly in the CFADMIN tool D:\JRun4\servers\myserver\cfusion-ear\cfusion-war\WEB-INF\cfusion\logs but nothing is there.Which one of the zillion XML files is this setting in? --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelouon't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX Java
Okay, I am venturing into the world of Java again and am trying to figure out how to insatiate an instance of a class that is stored within a package. The .jar file in question is stored at C:\plumtree\ptedk\5.0\devkit\java\WEB- INF\lib.I have added this path to the class path in the CFMX admin and have restarted the server to load it. Within this folder are many jar files, with the one I am interested named 'edk.jar'.Inside of this jar file is a class 'AccessLevel.class' located in a folder path 'com\plumtree\remote\prc'. So, the question is how do I handle the fact that this class is within a package?I have not been able to find a path for cfimport that will locate the class file ... cfobject action="" type=java class=edk.com.plumtree.remote.prc.AccessLevel name=edkTest Any suggestions? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Java
Okay, I figured it out.Instead of putting the folder path to the jar file in the CFMX admin, I put the entire path including the edk.jar file in the CFMX admin.Then, using the following cfobject tag, I was able to create the class instance. cfobject action="" type=java class=com.plumtree.remote.prc.AccessLevel name=edkTest Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx - request timeout setting
when the requesttimeout wall is hit, the user gets a message.Can't trap this one though, sucks.Note that when this occurs, the thread tied up in this request is not freed neccessarily. -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou hi there. if you have a request timeout setting of 30 seconds, and that time threshold is hit, what if any notification does the requesting template get? anything? an error that can be caught?it seems like the page churns and churns, for 30 seconds, and then just nothing.no error, no nothing, just sits there...then eventually my server crashes...WTF? -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx - request timeout setting
You can't kill it.In CF5 and earlier you could set a threashold for the number of these 'unresponsive' threads.When this was hit, CF restarted itself.In CFMX I do not see this anymore, well, you might see it in the CFMX Standalone version, but not the J2EE version. Better to find out why you have these long requests.Is your app DB intensive?I have apps on intranets that are and have the timeout set to 180secs.Maybe you have one page running a nasty SQL that needs to be tuned up? Anyone know of similar settings for JRun -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou how does one free that thread?its killing my webserver, and its getting to be a problem. tw On Thu, 05 Aug 2004 14:13:23 +, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: when the requesttimeout wall is hit, the user gets a message.Can't trap this one though, sucks.Note that when this occurs, the thread tied up in this request is not freed neccessarily. -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou hi there. if you have a request timeout setting of 30 seconds, and that time threshold is hit, what if any notification does the requesting template get? anything? an error that can be caught?it seems like the page churns and churns, for 30 seconds, and then just nothing.no error, no nothing, just sits there...then eventually my server crashes...WTF? -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx - request timeout setting
This has been a sucky issue.If there are network issues or anything, CF can't tell when accessing the DB and has no graceful way of handling it.We use Oracle, if the TNS listner goes off line for like 5 minutes, the CF server basically chokes and dies.Maybe there is a Java approach to this by by of JDBC?I dunno. TW, maybe you can have that job chunk up the delete?Have it delete only a few rows at a time to min the impact. -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou its adv. sql server 2000 its a sql job. that aside. my bigger problem with this... how does cfmx server/how should cfmx server handle a database that just is too busy to feed back a requested recordset?should it crash the cmfx server? or not? this is the bigger problem, i think. ill fix the db.whats the problem with cfmx? tw [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: remote restart cfmx service
Running CFMX on JRun?You can use the JMC to bounce CFMX.I suppose many have the JRun Admin server off for security maybe.So, how does the JMC restart a server?Does it maybe use some sort of Java class that is exposed to CF? Also, could use ASP to exec a bat file, eh? -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Image Manipulation - server side
Qasim, me thinks the attachment got knicked by the list gods.You have it on the MM Exchange yet?Or maybe a link?I played with it for a few minutes, quite impressive! Thanks! -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: remote restart cfmx service
Tony Weeg wrote: does anyone have a quick and easy way to set something up that could kickstart a cfmx service if it were hung, etc? from? Install OpenSSH and use net stop/start from the command line (I presume this is what Dick means with VPN). Then run a SSH client rom your phone. Jochem this is uber sweet.I have an SSH client on my cell now, but my servers are behind phat firewalls and teh security guys will not let me in.too badnow maybe with blackstone eh?send an SMSbamm!!! bounce ur proc or ur server. -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: remote restart cfmx service
I guess you could run a cfexeute a bat file with NET STOP Macromedia ColdFusion Server or the relevant service under Jrun.. does that sound a bit suicidal tho? Coldfusion killing itself?? On Wed, 04 Aug 2004 22:22:33 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Tony Weeg wrote: does anyone have a quick and easy way to set something up that could kickstart a cfmx service if it were hung, etc? from? Install OpenSSH and use net stop/start from the command line (I presume this is what Dick means with VPN). Then run a SSH client from your phone. Jochem LOL!This was actually popular in CF5 if you used ODBCto connect to Access.Had it scheduled to nightly bounce CF5 process. -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Image Manipulation - server side
Qasim, Looks real cool, your server is down now though.Did you use the Java JAI for this? -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou Here is the link to an image manipulation application that I had developed. As I said earlier once I have finished a basic documentation set, I will post it on MM exchange http://kaasu.fmip.org:8500/imagemanipulation Please let me know about any comments. Qasim Rasheed [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Monitor CFMX threads
Well, I'm not getting any errors, using Pete's newer version with the try/catch block.But I get no info on each thread at all.I get the # of threads, but that's all.Any tweaks we can make to this?is this code depend on the JVM version or something? -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Best Practice - Forms
I have done it before storing the entire form contents into a session variable, but storing the record ID might be simpler.I will have to think about this one some more. Thanks for all of the feedback. -- Jeff Quoting Tangorre, Michael [EMAIL PROTECTED]: Right after your initial insert set a session variable containing the some kind of ID to the record. Before you do another insert, check to see if the session var exists and if so, use an update query instead with the ID in the var... Mike The problem I have run into in the past is that a user will submit a form, then see the results (confirmation page) and need to make a change, hit the back button, and end up creating record #2 instead of updating the original record. So, in this case, how do you make the second pass on the form actual perform an update operation instead of an insert? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Best Practice - Forms
The problem I have run into in the past is that a user will submit a form, then see the results (confirmation page) and need to make a change, hit the back button, and end up creating record #2 instead of updating the original record. So, in this case, how do you make the second pass on the form actual perform an update operation instead of an insert? Thanks -- Jeff Quoting Paul Giesenhagen [EMAIL PROTECTED]: I am not sure what you are actually asking ... Questions back at you: 1) Are you concerned with someone who inserts a form and hitting their back button only to get the form again without anything in it or an EXPIRED page? 2) Or are you asking if someone goes into a page where they are updating information, and then hits refresh?Wouldn't it just refresh the page and the data from the db? Maybe I am missing something on your original post. Paul Giesenhagen QuillDesign - Original Message - From: Jeff Chastain To: CF-Talk Sent: Wednesday, July 28, 2004 1:33 PM Subject: Best Practice - Forms I have dealt with this in a variety of different ways in the past, I am wanted to see how other people did it.I have a form.This same form is reused for creating a new record as well as updating an existing record. So, the question is how do people 'control' the back button and the case where the user submits the form, backs up, and resubmits it again?In the case of a create operation, the first time the form is displayed it would be empty, but upon reloading the form, it would contain the original data and would now be an update operation.In the case of an update operation, the first time the form is displayed, it would contain the current data, but upon reloading the form, it would contain the updated data and still be an update operation (would go to an update query instead of an insert). So, what are your best practices for handling form input and reusing a form? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: duplicate emails and CFMX
seems to be a little heard of/experienced issue though.Can't find anything of substance on Google at all. -- --- Douglas Knudsen http://www.cubicleman.com If you don't like something, change it. If you can't change it, change your attitude. Don't complain. - Maya Angelou - Have this issue from time to time also. Dave Win2k, CFMX 6.1 - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Monday, July 26, 2004 12:46 PM Subject: duplicate emails and CFMX Anyone see duplicte email issues with CFMX?Have a couple apps that send emails, CFMX is sending the same one twice.I saw this once before, resarting the JRun service nipped it, but restarting CFMX process does not.Strange. anyone? running CFMX in J2EE style on JRun. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OO Coding Relational Databases
One of the biggest issues I have getting fully into OO programming usings CFCs is my understanding of how data comes from a relational database, into an object and vice versa.Most of the CF resources I have found talk plenty about CFCs, but they completely ignore working with OO code and a database. Can somebody point me to any resources that might help fill in the gaps here? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mailing List / Archive App
Thanks Michael. ... grabbing the message before or after it is sent ... What is the difference here?It would seem like after would be much simpler.Is there a benefit otherwise? ... different mail browsers use different headers ... Is there anywhere that at least states what all of the different options that must be handled are? ... I suggest using something other than CFSCHEDULE for this ... How else would you do it?The gateway feature of Blackstone sounds nice in order to get it as close to real time as possible, but what alternativesare there now? Thanks again, -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: App Skinning via XSL?
This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I have read a couple of articles about using CFMX, XML and XSL to do this on a much smaller scale - i.e. reformat a menu.Has anybody done this on a full application level and if so, any suggestions or warnings? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: App Skinning via XSL?
Thanks Barney.This was my main concern - XSL on a little menu looked pretty easy, but for a full layout?I am just trying to find the best way to make the end product look like a completly custom app, but still have one central code base for upgrades, fixes, etc. Thanks -- Je ff Quoting Barney Boisvert [EMAIL PROTECTED]: I've used it with great success on many small content pieces, but never for an entire application.Personally, I think you'd be much better off with writing a very thing view layer for each client that calls on the central app for all it's non-presentation functionality.XSL is good for certain things, but it gets unweildy very quickly on large or complicated transformations (as reorganizing a site layout would be). My $0.02. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:33 AM To: CF-Talk Subject: OT: App Skinning via XSL? This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I have read a couple of articles about using CFMX, XML and XSL to do this on a much smaller scale - i.e. reformat a menu.Has anybody done this on a full application level and if so, any suggestions or warnings? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Yet another OT Mail Relay move question
What pending mail? Incoming or outgoing? You should be able to run the two mailservers simultaneously if you make sure to use different ports. That way you can have the postoffice server available on nonstandard ports so that people can still retrieve their old mail. - Original Message - From: Alan Rafael Bleiweiss To: CF-Talk Sent: Friday, February 06, 2004 7:11 AM Subject: Yet another OT Mail Relay move questionDoes anyone have any experience in how to move pending email to the new server?(I've got fifty virtual domains...) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking for work around for an error
I would set up an extra access database that has linked tables to the original database, use the one with the linked tables as your datasource. The other one will not be locked and you can muck with it as you wish. Performance in my experience is not impacted. - Original Message - From: Mickael To: CF-Talk Sent: Monday, January 26, 2004 3:35 PM Subject: Looking for work around for an error Hello All, I have an issue with one of my apps using Access.The database that we are using is created on a machine in our network then sent via FTP to the webserver in a Zipped file. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Need help with Batch file
I think you can issue the 'prompt' command before the mget, this enables or disables prompting for an mget download so something like username password cd Custom extracts\ ourfolder lcd \inetpub\wwwroot\project\files prompt mget p_mth_choice*.zip y quit good luck - Original Message - From: Mike Kear To: CF-Talk Sent: Thursday, January 08, 2004 8:39 AM Subject: OT: Need help with Batch file Here's one for some of you older fellas, who still remember DOS: I needsome help with a batch file for using FTP.(I can't use CFFTP, because it fails at the change to directory - the directory we want includes a space in the name and no matter how I try it won't include the space as part of the name) The commands I'm having trouble with is the get or mget.I don't know the exact file name I need to retrieve because it contains the date.The filename will always be in the form: p_mth_choice_mag_ddmmm_nn.zip where dd is the date, mmm is the month, is the year, and nn is a serial number of some sort.So I was hoping to have the ftp file use get or mget to retrieve p_mth=choice*.zip. When I do this using manual commands,get doesn't work because it doesn't support wildcards, but mget does.However mget wants a y confirmation for each file.How to I put in the batch file to answer Y? Here's the batch file I've written so far: ftp -d -s:C:\Inetpub\wwwroot\project\ftpconfig.txt ftp.comain.com.au And the ftpconfig.txt file contains the following: username password cd Custom extracts\ ourfolder lcd \inetpub\wwwroot\project\files mget p_mth_choice*.zip y quit But this fails because it hasn't got any Y response to the prompt.I know there's a way to have the batch file submit the Y to the script but I'm at a block.Can't remember how to do it, and my old DOS manuals went in the recycle bin years ago. Can anyone help? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: HTTP Response codes
cfheader statuscode=606 would probably do what you want? - Original Message - From: Howie Hamlin To: CF-Talk Sent: Monday, January 05, 2004 5:57 PM Subject: HTTP Response codes Can ColdFusion be forced to send a particular HTTP response code?For an application that I have I need to send a 606 response when an error occurs. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFFUNCTION - Any thoughts??
Bryan,
I tried this on windows and just get -1 for height and width. (CF 6.1
Ent.) Any ideas?
cffunction name=ImageSize returnType=struct access=public
cfargument name=FileLoc type=string required=Yes
cfset ImageInfo = StructNew()
cfset ImageObject =
CreateObject(java,javax.swing.ImageIcon).init(ARGUMENTS.FileLoc)
cfset ImageInfo.ImgWidth = ImageObject.getIconWidth()
cfset ImageInfo.ImgHeight = ImageObject.getIconHeight()
cfreturn ImageInfo
/cffunction
cfset x = ImageSize('clock150.jpg')
cfoutput
ImageInfo.ImgWidth #ImageInfo.ImgWidth#br
ImageInfo.ImgHeight #ImageInfo.ImgHeight#br
/cfoutput
From: Bryan Stevenson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: CFFUNCTION - Any thoughts??
Date: Fri, 28 Nov 2003 16:20:46 -0800
Hey All,
Below is a CFFUNCTION to check an image's size:
cffunction name=ImageSize returnType=struct access=public
cfargument name=FileLoc type=string required=Yes
cfset ImageInfo = StructNew()
cfset ImageObject =
CreateObject(java,javax.swing.ImageIcon).init(#ARGUMENTS.FileLoc#)
cfset ImageInfo.ImgWidth = ImageObject.getIconWidth()
cfset ImageInfo.ImgHeight = ImageObject.getIconHeight()
cfreturn ImageInfo
/cffunction
It works fine on Windows but bails on Linux RedHat 9.0 with CFMX 6.1
Enterprise installed.There error is below.It appears to be having an
issue instantiating the object abovebut I'm unsure as to whyany
thoughts??
ERROR DETAILS:
struct
Detail An exception occurred when instantiating a java object. The
cause of this exception was that: .
Message Object Instantiation Exception.
RootCause struct
Cause struct
Message [empty string]
StackTrace java.lang.NoClassDefFoundError at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:141) at
java.awt.Toolkit$2.run(Toolkit.java:748) at
java.security.AccessController.doPrivileged(Native Method) at
java.awt.Toolkit.getDefaultToolkit(Toolkit.java:739) at
javax.swing.ImageIcon.init(ImageIcon.java:81) at
javax.swing.ImageIcon.init(ImageIcon.java:107) at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39) at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27) at
java.lang.reflect.Constructor.newInstance(Constructor.java:274) at
coldfusion.runtime.java.JavaProxy.CreateObject(JavaProxy.java:128) at
coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:56) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1622) at
cfutility2ecfc1211421247$funcIMAGESIZE.runFunction(/var/www/pmcfcs/utility.c
fc:53) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:
250) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582) at
coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:327) at
coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1872) at
cfleg_photo_maint2ecfm1369148617.runPage(/var/www/html/secure/includes/leg_p
hoto_maint.cfm:62) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at
coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871) at
cfindex2ecfm1722994938.runPage(/var/www/html/secure/index.cfm:48) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28) at
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
Re: CFFUNCTION - Any thoughts??
Massimo, Would you be able to share the older version for those of us stuck on 6.0? Greg From: Massimo, Tiziana e Federica [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CFFUNCTION - Any thoughts?? Date: Mon, 1 Dec 2003 21:57:55 +0100 Did this CFC require you to install anything extra (i.e. Java SDK or JRE) on your RH9 machine? I had tried this particular CFC before, which is when I discovered I was missing the javax library altogether. Earlier version (1.2) were designed to work on top of CF 6.0 and JRE 1.3, starting from 1.6 it uses a different set of Java APIs, taking advantage of JRE 1.4 installed alongside CF 6.1. I never tested it on a Unix box, so I have no idea if it may work on your enviroiment or not... All you can do is to give it a try Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFFUNCTION - Any thoughts??
Massimo, I found the version 1.2 on your site (Wish I could read italian, looks like a great site) and it doesn't seem to work on my 6.0/linux. Works on 6.1/Windows though. Any ideas? Greg From: Massimo, Tiziana e Federica [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: CFFUNCTION - Any thoughts?? Date: Mon, 1 Dec 2003 21:57:55 +0100 Did this CFC require you to install anything extra (i.e. Java SDK or JRE) on your RH9 machine? I had tried this particular CFC before, which is when I discovered I was missing the javax library altogether. Earlier version (1.2) were designed to work on top of CF 6.0 and JRE 1.3, starting from 1.6 it uses a different set of Java APIs, taking advantage of JRE 1.4 installed alongside CF 6.1. I never tested it on a Unix box, so I have no idea if it may work on your enviroiment or not... All you can do is to give it a try Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ImageMagick/MagickTag
Has anyone used imagemagick or magicktag to write text on an image? This doesn't work. CF_MagickTag action=""> inputtype=file inputfile=/usr/var/www/html/greg/banner.gif outputType=file outputFile=/usr/var/www/html/greg/greg.gif debug=No timeout=5 CF_MagickAction action="" string=text 10,30 GREG /CF_MagickTag Nor this: CF_MagickAction action="" string=text 10,30 GREG Tried this also: cfexecute name=/usr/bin/convert arguments=/usr/var/www/html/greg/banner.gif -draw text 10,30 'GREG' /usr/var/www/html/greg/greg.gif timeout=5 /cfexecute And this: cfexecute name=/usr/bin/convert arguments=/usr/var/www/html/greg/banner.gif -draw text 10,30 GREG /usr/var/www/html/greg/greg.gif timeout=5 /cfexecute [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLogin
How about a show of hands of people using CFLogin? I've been trying to get my head around it for a few days now. I did a tutorial on EasyCFM and got MORE confused. Anyone like it? Anyone want to take a shot at explaining it? I'm still not sure what MM gave us. A container? We still have to provide tables to store the username/pw and the roles? HELP! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLogin
I guess I was expecting more from cflogin. I thought it was going to do everything for you. You'd think there would be built-in security tables if there are built in functions to validate users. From: Raymond Camden [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CFLogin Date: Tue, 25 Nov 2003 08:22:42 -0600 Just as a warning, I've seen wierd issues when I used cflogout above my cflogin block. This never had any issues in 6.0, but I noticed an oddity under 6.1 with it where (I believe) getAuthUser was NOT returning after the cflogout. I don't remember the exact details, but I solved it by moving my logout _after_ the cflogin block, and just using a cflocation to reload the current page and force the login. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLogin
Okay, this is going to sound dumb to some of you but how can you do this WITHOUT using a DB? Greg From: Raymond Camden [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CFLogin Date: Tue, 25 Nov 2003 08:56:06 -0600 There is always a fine line between doing too little and doing too much. I think cflogin hits the sweet spot myself. By NOT forcing you to use a db, it allows you to easily switch your authentication methods without having to update your entire site. Also do not forget that the security system can be tied to CFCs as well with the use of the roles attribute. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: If Image Exist...
One way is to use your webserver functionality: asiign a default image to the 404 error for that particular directory, if the webserver is asked for a noexistant image it will serve up the default image. - Original Message - From: Bailey, Neal To: CF-Talk Sent: Wednesday, November 26, 2003 12:21 AM Subject: If Image Exist... Is there a way to check if image exist in CF? I have some image names in the database that are pointing to an image that does not exist. Therefore I get the little red X in IE. I would like to instead display and alternate image. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ImageMagick
Can someone steer me in the right direction to lear to use ImageMagick? I've been using MagickTag to resize images without any trouble, but I want to do some more things with imagemagick like write text on images, and combine images. Documentation is slim that I can find. I've downloaded a 5.9Gig ImageMagick-5.5.7-11.zip but have no idea where to start installing it. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ImageMagick
Oops, meant 5.9Meg. Anyways. I'm getting some of the commands to work like -border, but can't figure out the -draw command. Anyone have an example? From: Brook Davies [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: ImageMagick Date: Fri, 21 Nov 2003 11:09:05 -0800 A 5.9Gig zip file? Damn! Thats one big ass zip file! At 10:45 AM 11/21/2003, you wrote: Can someone steer me in the right direction to lear to use ImageMagick? I've been using MagickTag to resize images without any trouble, but I want to do some more things with imagemagick like write text on images, and combine images. Documentation is slim that I can find. I've downloaded a 5.9Gig ImageMagick-5.5.7-11.zip but have no idea where to start installing it. Thanks. -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SESConverter
I've been reading about the sesConverter at Fusium.com and wondered what other's experience was using it, preferrably with fusebox. I have a FB2 site a client wants better reporting/search engine ability on. After looking into the sesConverter I didn't understand the reason/value of having the dummy filename on the url. What is this dummy file? Do you actually create a file with searchable content or is it just so the stats app will have something to display? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Eolas patent suit
On the other hand, it seems that automatically downloading images, and I guess by extension other 'rich' content is disabled by default in outlook 2003, which will be a major headeache for everyone sending out newsletters. - Original Message - From: Christian Cantrell To: CF-Talk Sent: Saturday, October 25, 2003 9:12 PM Subject: Re: Eolas patent suit On Friday, October 24, 2003, at 12:03 PM, Jeff Beer wrote: My livelihood comes from developing and delivering flash-based newsletters and promotions in e-mail.When this change goes into effect, we're either out of business or facing the loss of our primary product. You don't have anything to worry about, Jeff.Users who have enabled ActiveX controls in Outlook will not be prompted before the Flash player and other ActiveX controls are loaded.Microsoft confirmed that since Outlook is not considered a browser, the upcoming changes to Internet Explorer will not affect it. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DataDirect JDBC drivers (shipped with CFMX)..
Yes, copy the jar files to the cfmx lib directory, that's the simplest (restart CFMX in order to load the drivers) Then, when setting up your datasource, use the type 'other' and use the values you find here: JDBC URL: jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=yourDatabaseName Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver Driver Name: any name but I use SQLServerDriverJDBC - Original Message - From: Nathan Strutz To: CF-Talk Sent: Friday, October 24, 2003 8:48 PM Subject: RE: DataDirect JDBC drivers (shipped with CFMX).. Joe, Robert, anyone... I've decided to give the MS JDBC drivers a go. What's the procedure for installing them to make CF use the Microsoft drivers over the DataDirect ones? I would imagine copying the jar files to the cfmx\lib folder would be a start...? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Add or Multiply as a Variable - Question Repharased
You could maybe provide two fields in the database, one for multiply/divide (default to 1) and one for add/substract (default to 0), and just perform both operations, if the values are at default the result is unchanged - Original Message - From: Les Mizzell To: CF-Talk Sent: Thursday, October 23, 2003 6:02 AM Subject: Re: Add or Multiply as a Variable - Question Repharased Michael T. Tangorre wrote: why would you want to do this? For: #DollarFormat(ST_100.DIST_COST * ADJUST.ADJUST100)# How would I make the Arithmetic _expression_ *a variable from the database.. I know I can do this with a switch of if structure, but I'm really curious if there *is* a way to do it with just the one line of code... -- Les Mizzell - Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Assistance
Join twice on the user table and differentiate by an alias select newsID, c.firstName creatorFirstName, c.lastName creatorLastName, u.firstName updaterFirstName, u.lastName updaterLastName from tbl_news n join tbl_user c on n.creatorID = c.userID join tbl_user u on n.updaterID = u.userID - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Thursday, October 23, 2003 2:31 PM Subject: OT: SQL Assistance I have two tables: tbl_user and tbl_news In the tbl_user table I have 3 columns (among others): userId, firstName, lastName In tbl_news I have two columns (among others): creatorId, updaterId both of which relate back to the tbl_user table. In a query, how would I get the first name and last name of both the creator and updater? I can JOIN and get one, but how to you differentiate between the creator and updater names when joining? Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Grouped cfoutput
cfoutput query=yourqueryname group=phaseName br#phasename#br cfoutput - #milestoneName#br /cfoutput /cfoutput should be close enough - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Monday, October 20, 2003 3:25 PM Subject: Grouped cfoutput I have a query whose result set looks like this: phaseId | phaseName | milestoneId | milestoneName -- 1phase11 name1 1phase12 name2 1phase13 name3 2phase24 name4 2phase25 name5 2phase26 name6 3phase37 name7 3phase38 name8 3phase39 name9 I am trying to output the query so that in a table I can get the output to look like: Phase1 ---name1 ---name2 ---name3 Phase2 ---name4 ---name5 ---name6 Phase3 ---name7 ---name8 ---name9 The query I am using is as follows: SELECT P.phaseId, P.phaseName, M.milestoneId, M.nilestoneName FROM milestone M INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId) ORDER BY P.phaseName How do I setup the cfoutput tags with the query and group attributes set to obtain the output I described above.. Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multiply in Output Statement??
What most likely would also work is to wrap it in a function like #int(myrecord.myvar * 100)# or else let your database do the calculation - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 19, 2003 5:05 AM Subject: RE: Multiply in Output Statement?? I've been building some admin pages that have stuff like: cfoutput #myrecord.myvar * 100# /cfoutput This runs perfectlly locally, but once out on the server... ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137644 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Query to List
Did you check out valuelist(query.column) - Original Message - From: G-matcomkc [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:41 PM Subject: Query to List In the CF docs, I saw some code that converted a query result into a list. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: oracle datasource as OLEDB
The Microsoft ODBC driver for Oracle seems to be the best companion for CF, so you might want to try that. - Original Message - From: Sheila Handler [EMAIL PROTECTED] Is it possible to define an Oracle database with OLEDB, or do I have to use ODBC? Can anyone give me some hints about defining an Oracle datasource? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Web Server Error 500 with Oracle 9i and ColdFusion MX
Most people seem to have better luck using the jdbc thin client driver. It might already be installed on your machine, or else you can get if from the Oracle website. - Original Message - From: Eppler Thomas (XHS 98) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:43 PM Subject: Web Server Error 500 with Oracle 9i and ColdFusion MX We are currently migrating from MS SQL-Server to Oracle 9i. So now the ColdFusion Pages sometimes(!) are coming with an Web Server Error 500 (Internal Server Error). On the same machine with SQL Server this error never occurs. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
