Re: Creating a .cfm file on the fly
On Wed, Mar 12, 2008 at 7:26 PM, Casey Dougall [EMAIL PROTECTED] wrote: Denny, I can see where you are headed there. The only issue I have with that, if the end user wants to change the name of the file after it's been put into play, or delete the file all together, you would end up with a bunch of dead links. In this type of scenario, I'd end up rewriting the page content with a 301 redirect to the new page or a message stating that that page does not exist. Yes, 301s and 404s sound like a nice touch. You can also do amazing things with URL re-writing. People just eat that stuff up, too. Great way to get around that I want the URL to say X problem. Sure you can say. Whatever floats your boat, pretty much.. ColdCourse sounds good, if you can't use the webserver's. Something like that (human readable URLs) might make it easy to add one of those were you looking for /this/ type of related search deals, too. You also have some issues with re-writing all of the pages when someone wants to change the location of the banner or another template type modification, I guess you could have a script go through and re-write all pages... Most likely if I were to go that route I would still consider writing the page as .cfm just in case. That generation time is a small price to pay, if you can swing the non-dynamic-ness of it. On a heavily trafficed site, it would probably be worth it to have quite a bit of the content be static (even if it's getting overwritten quite often). That's such an edge case tho, really. I feel a little funny letting the user edit stuff that eventually turns into a CF page. I went so far as to create a meta-language for one CMS, just to avoid direct .cfm generation. Probably silly, in retrospect, but it was not too terrible of an idea, and I learned a lot from the experience. One reason I'm digging on the DHTML type stuff, is the ease of keeping content separate from the styles and eye candy/layout. The url hardly changes, besides anchors, like #somethingToBookmark, which is nice. Eh. Sorta wandering now, so, um, I guess that's it. :-) -Denny -- The oldest and strongest emotion of mankind is fear. --- H.P. Lovecraft ~| 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:301146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating a .cfm file on the fly
On Wed, Mar 12, 2008 at 7:27 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks, Denny... I read recently that dashes - in filenames were more search engine friendly than underscores. If I were to want to disallow underscores and allow dashes, how would the regex change? You can just replace the _ with the -, in that expression. It's a good learner expression, actually: Those | pipes mean that the stuff 'tween them is optional. The ^ at the front is special, means exclusion or something, I think. :] The set is everything between the [ and ] -- A-Z == All upper case apha letters. a-z is all lower, although usually you can do A-z, I think, to get both. 0-9 == all digits between 0 and 9. If you want to add an asterisk, the general idea would be: [^a-z|A-Z|0-9|_|*]. And an asterix and a 'sclamation? : [^a-z|A-Z|0-9|_|*|!]. Generally you need to escape certain chars, like the * or the bang, but within sets [things] are different. There are various flavors of regex engines, and not all the same stuff works the same across the board, but they can be really useful-- this is one of my favorites, because you're automatically disallowing anything you didn't specifically add 'tween those |s. Not especially CF related, I know. And maybe not exactly accurate-- but regular expressions are just so darn cool. Figured I'd give giving a little detail a shot. As far as preference with the search engines? I seriously doubt that much of that goes on-- you gotta think, the more stuff they index, the better it is for them, right? At least for dashes or underscores, it would seem silly, but I don't have any hard data. Seems like a lot of stuff goes by link weight (number of other links that link to it, or something) more than the actual href. Eh. Search ranking has only been important to me once, so... not the most versed in that particular dark art :] -Denny -- I must not fear. Fear is the mind-killer. Fear is the little-death that brings total obliteration. I will face my fear. I will permit it to pass over me and through me. And when it has gone past I will turn the inner eye to see its path. Where the fear has gone there will be nothing. Only I will remain. --- Frank Herbert, Dune - Bene Gesserit Litany Against Fear ~| 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:301147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Adobe plan the future of ColdFusion (along that line)
Right on.. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 7:03 PM To: CF-Talk Subject: Re: Help Adobe plan the future of ColdFusion (along that line) Sure, but not Java. Flex does this really well and fits better with CF as an adobe product: http://www.adobe.com/devnet/coldfusion/articles/multifile_upload.html On Thu, Mar 13, 2008 at 7:42 AM, Azadi Saryev [EMAIL PROTECTED] wrote: yes +1 to better file upload. start with built-in tag-based multiple file upload. a nice built-in java applet for selecting multiple files or whole folders to upload will be nice, too... especially one that can be called with a tag and an upload progress bar -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301148 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 Adobe plan the future of ColdFusion (along that line)
Don, I was responding to your suggestion and I got carried away and wrote about 5 paragraphs So instead of cluttering up the list I put it in a blog post: http://www.coldfusionmuse.com/index.cfm/2008/3/13/cf8.catch.22 As a practical note specifically for you, I would mention that you are free to use FCK editor without the Adobe implementation - and it is just as easy. You can download the latest and greatest from the web. There is even a custom component (and a custom tag think) you can use. You can strip it down to the bones as needed. We use it all the time for many applications on CF 6 through CF 8. Also I was interested in your off the cuff comment regarding scary script kiddie attacks (or kitties if you like). If I hear you correctly you mean that you want to make sure the editor doesn't make it too easy to attempt attacks. Keep in mind that there is no protection (none, zero, zilch, nada, bupkis) provided by any client side code against attack. Validating user input is always always always (did I mention always) a server side task - and therefore it has little to do with which editor you use. Client side code and validation is about convenience and the user experience - but user submitted data must be religiously vetted on the server regardless of what you are doing on the client. Of course CF provides some global server side protection for XSS but not for things like HTML or SQL injection. No client side code can protect against such attacks because, once that HTML buffer leaves your server and is sent to the browser it is out of your control. Oh! Thanks for letting me stand in for Ben. I'm also open to speaking for Ray when he's in the john - or Dave Watts when he's busy on the phone with Bill Gates (ha). Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 6:48 PM To: CF-Talk Subject: Re: Help Adobe plan the future of ColdFusion (along that line) Hey Mark, I'm just tossing an idea around, absolutely no pressure on Adobe. But I do hope Adobe would come up with fix/patch for theirI FckEditor integration very quickly, my beta users like its WYSIWG feature but are getting mad with me for its slow rendering and some times it fails (cf8 standard)... some of the alternative solutions was either only able to work in a very simple environment or scary, script kittie attack... I understand this is a first-cut but Data Capture is a critical element for any business application... Hope you would agree. I don't like to bug Ben all the time... ~| 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:301150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Google Maps, CF and Ajax
Hehe... My late night PBS viewing is catching up with me. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 4:09 AM To: CF-Talk Subject: RE: Google Maps, CF and Ajax I so hope everyone knows that's in reference to Red Dwarf! :O. http://en.wikipedia.org/wiki/Red_Dwarf_characters#Ace_Rimmer :OD -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: 12 March 2008 22:25 To: CF-Talk Subject: RE: Google Maps, CF and Ajax Steve, I'm probably too long in the tooth to succumb to such familiarity. But maybe this once Thanks Cutter Gee that felt kind of good. Will you call me Ace Rimmer? :) -Mark ~| 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:301151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Google Maps, CF and Ajax
I so hope everyone knows that's in reference to Red Dwarf! :O. http://en.wikipedia.org/wiki/Red_Dwarf_characters#Ace_Rimmer :OD -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: 12 March 2008 22:25 To: CF-Talk Subject: RE: Google Maps, CF and Ajax Steve, I'm probably too long in the tooth to succumb to such familiarity. But maybe this once Thanks Cutter Gee that felt kind of good. Will you call me Ace Rimmer? :) -Mark ~| 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:301149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: file upload/virus scan
On Thursday 13 Mar 2008, Mark Fuqua wrote: 1. If all I allow for uploads is pdf and jpg, is that still neccessary? Yes. These formats could cause buffer overflows of vulnerable implementations, for instance. You might want to check your virus scanner picks these up. 2. My site is on a vps so it would be all self serve...what can I use and how do I get it to scan the uploaded file? cfexecute your favourite scanner. -- Tom Chiverton Helping to proactively syndicate guinine initiatives on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Set cfwindow to stay at the place of the link!
Hi: I have a catalog and at the end of each product description I have 3 thumbnails of the product and I want to use cfwindow to let the users click and see the larger image. It works fine but the only problem I have is how I can set the cfwindow to open at the place over the thumbnail. Now when I click on the link to see the larg image cfwindow opens it at the top of the page while I need it to stay down the page where the thumbnails are. I know I can set X and Y for cfwindow but there is a huge variation in the content of each product description so the X and Y properties for each product thumbnails are very different from other products. I wonder if there is a way to keep cfwindow window over the link when I click on link. Please help me Thanks Ali ~| 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:301153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best way to order appearance of database content...
Rick, Say, I've got two agents in the db. First has display-order 10, second has display-order 20. A third agent is added who is to be displayed second, so is given the display-order number 15 in the form. When the form is submitted, the first agent retains number 10, the new second agent's number is rounded up from 15 to 20, and the agent whose number was 20 now has the number 30. That way there are always values between the agents' display-order numbers to add new agents. Make any sense? Would this be the best way to do this? Other ways? There's no reason to use number in multiples of 10. Just store their real order and do something like: cfset iNewUserOrder = 3 / !---// do this before inserting //--- cfquery update Employees set display-order = display-order + 1 where display-order = #iNewUserOrder# /cfquery Then ever user who's order was 3 or more is shifted up and then you can actually insert the new user at position 3. -Dan ~| 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:301154 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_SQL_TIMESTAMP
This problem only started occuring with DW CS3, btw. I do not use DW. So I am not sure how or even if it would affect the parsing of dates. As I understand it, CF parses the cfqueryparam value into a date object before the sql is sent to your database. Since most CF date functions use U.S. date formatting rules, an ambiguous value like 12/04/2008 would be converted to December 12th, 2008 cfset yourDate = 12/04/2008 cfquery name=insertRecord datasource=#dsn# INSERT INTO SomeTable (SomeColumn) VALUES ( cfqueryparam value=#yourDate# cfsqltype=cf_sql_timestamp ) /cfquery As you can see from the debug output, CF translates the value using mm/dd/ format before it is ever sent to the database. Query Parameter Value(s) - Parameter #1(cf_sql_timestamp) = 2008-12-04 00:00:00.0 As mentioned - you could pre-parse the values into the correct date, or - use a less ambiguous format, or - if CF is running under a locale that uses dd/mm/ format, you could wrap the value in one of the LS date functions, so it is parsed correctly. ~| 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:301155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best way to order appearance of database content...
On 3/12/08, Rick Faircloth [EMAIL PROTECTED] wrote: Anyway.I want to be able to determine the appearance order of Real Estate agents on a page, other than by last name, etc. I want a user to be able to specify the appearance, say, by number. I could have an display-order column and use a number. Hi Rick, I'm just thinking from the agents point of view. Wouldn't it be better for them if it was a random order? Then maybe a teared display, if they would like to be placed higher on the page. Package 1 gets you on the bottom third, Package 2, middle section, Package 3 Top section of page... No one wants to be on the bottom, so putting a random sort order in place was always the key here. That's my belief anyhow. ~| 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:301156 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_SQL_TIMESTAMP
Hi CS, I do use LSformat. The problem is the cf_sql_timestamp totally ignores it, same with cf_sql_date. How could I preparse the values, please? I'm not 100% sure what you mean by this. Jenny -Original Message- From: C S [mailto:[EMAIL PROTECTED] Sent: 13 March 2008 12:32 To: CF-Talk Subject: Re: CF_SQL_TIMESTAMP This problem only started occuring with DW CS3, btw. I do not use DW. So I am not sure how or even if it would affect the parsing of dates. As I understand it, CF parses the cfqueryparam value into a date object before the sql is sent to your database. Since most CF date functions use U.S. date formatting rules, an ambiguous value like 12/04/2008 would be converted to December 12th, 2008 cfset yourDate = 12/04/2008 cfquery name=insertRecord datasource=#dsn# INSERT INTO SomeTable (SomeColumn) VALUES ( cfqueryparam value=#yourDate# cfsqltype=cf_sql_timestamp ) /cfquery As you can see from the debug output, CF translates the value using mm/dd/ format before it is ever sent to the database. Query Parameter Value(s) - Parameter #1(cf_sql_timestamp) = 2008-12-04 00:00:00.0 As mentioned - you could pre-parse the values into the correct date, or - use a less ambiguous format, or - if CF is running under a locale that uses dd/mm/ format, you could wrap the value in one of the LS date functions, so it is parsed correctly. ~| 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:301157 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_SQL_TIMESTAMP
Hi Jenny, I think the correct function to be using here is LSParseDateTime. That will return a valid date object. What happens when you do this? cfset yourDate = 12/04/2008 cfqueryparam value=#LSParseDateTime(yourDate)# cfsqltype=cf_sql_timestamp ~| 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:301158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Adobe plan the future of ColdFusion (along that line)
On 3/12/08, Azadi Saryev [EMAIL PROTECTED] wrote: file upload. a nice built-in java applet for selecting multiple files or dear god NO! No java applet! Ack. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Creating a .cfm file on the fly
Thanks for the explanation, Denny! Rick -Original Message- From: denstar [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 4:04 AM To: CF-Talk Subject: Re: Creating a .cfm file on the fly On Wed, Mar 12, 2008 at 7:27 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks, Denny... I read recently that dashes - in filenames were more search engine friendly than underscores. If I were to want to disallow underscores and allow dashes, how would the regex change? You can just replace the _ with the -, in that expression. It's a good learner expression, actually: Those | pipes mean that the stuff 'tween them is optional. The ^ at the front is special, means exclusion or something, I think. :] The set is everything between the [ and ] -- A-Z == All upper case apha letters. a-z is all lower, although usually you can do A-z, I think, to get both. 0-9 == all digits between 0 and 9. If you want to add an asterisk, the general idea would be: [^a-z|A-Z|0-9|_|*]. And an asterix and a 'sclamation? : [^a-z|A-Z|0-9|_|*|!]. Generally you need to escape certain chars, like the * or the bang, but within sets [things] are different. There are various flavors of regex engines, and not all the same stuff works the same across the board, but they can be really useful-- this is one of my favorites, because you're automatically disallowing anything you didn't specifically add 'tween those |s. Not especially CF related, I know. And maybe not exactly accurate-- but regular expressions are just so darn cool. Figured I'd give giving a little detail a shot. ~| 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:301160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best way to order appearance of database content...
Thanks for those options, Sonny Dan... Casey... yes, the random option is definitely possible. The site I'm currently rebuilding for an agency uses that approach. However, another agency prefers to order by seniority, so I have to be prepared to deliver that option, too. Thanks for the input! Rick -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 7:28 AM To: CF-Talk Subject: RE: Best way to order appearance of database content... Rick, Say, I've got two agents in the db. First has display-order 10, second has display-order 20. A third agent is added who is to be displayed second, so is given the display-order number 15 in the form. When the form is submitted, the first agent retains number 10, the new second agent's number is rounded up from 15 to 20, and the agent whose number was 20 now has the number 30. That way there are always values between the agents' display-order numbers to add new agents. Make any sense? Would this be the best way to do this? Other ways? There's no reason to use number in multiples of 10. Just store their real order and do something like: cfset iNewUserOrder = 3 / !---// do this before inserting //--- cfquery update Employees set display-order = display-order + 1 where display-order = #iNewUserOrder# /cfquery Then ever user who's order was 3 or more is shifted up and then you can actually insert the new user at position 3. -Dan ~| 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:301161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Join one concatenated field to four fields
Sonny Savage wrote: Ouch... doing conversions in the where clause is gonna' kill your performance. Yeah, the good thing is that this only has to run once. This was not a web application requirement. It is a one time only, public data request that we get $50 for but costs us a couple hundred dollars in man hours to create. So down and dirty, but quick is the key concept. ~| 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:301162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CSS help
Okay, I'm working on a pretty simple navigation element for this web site: http://www.bvafans.com/forums.cfm I'm using ulli/ul for the navigation, and set the li to display inline and set specific widths on the li elements. Looks great in IE. Not so much in firefox. Firefox doesn't seem to like the widths on the lis at all, and seems to be ignoring the margin or padding on the ul element as well (the first link is indented, like a normal ul would be. Help! Sandy, I need you! -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
Would this be the best way to do this? Other ways? In my CMS, there are several items the user can choose the order he wants, ie. paragraphs in a page. In order to do so, he has a list of all of them and he can move them up or down (Javascript). On submit, a list of items is created in order chosen by the user, in a hidden field. In the table, each item has a column seq for a sequence number. In the update template, I simply update all sequence numbers in a loop, ie: CFSET seq = 1 CFLOOP INDEX=paraId LIST=#listPara# CFQUERY DATASOURCE=#application.applicationName# UPDATE paragraphs SET seq = #seq# WHERE paraId = #paraId# /CFQUERY CFSET seq = seq+1 /CFLOOP Then use the seq column to sort by your queries. It may be a little more overhead on the database, but for items in small numbers (say less than 1000), it is marginal. And it is much simpler to handle than leaving holes between numbers and eventually renumber items any way when there are no more holes left. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSS help
This'll no doubt help http://www.google.co.uk/search?hl=ensa=Xoi=spellresnum=0ct=resultcd=1q =taming+listsspell=1 Adrian -Original Message- From: Rick Root Sent: 13 March 2008 13:38 To: CF-Talk Subject: CSS help Okay, I'm working on a pretty simple navigation element for this web site: http://www.bvafans.com/forums.cfm I'm using ulli/ul for the navigation, and set the li to display inline and set specific widths on the li elements. Looks great in IE. Not so much in firefox. Firefox doesn't seem to like the widths on the lis at all, and seems to be ignoring the margin or padding on the ul element as well (the first link is indented, like a normal ul would be. Help! Sandy, I need you! -- Rick Root ~| 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:301165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS help
Yeah, IE and FF treat styles of the list elements completely different. You might look at zero-ing your element margins (in all browsers) prior to writing any CSS, to gain a somewhat consistent look and feel. Google Eric Meyers on this topic... Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Rick Root wrote: Okay, I'm working on a pretty simple navigation element for this web site: http://www.bvafans.com/forums.cfm I'm using ulli/ul for the navigation, and set the li to display inline and set specific widths on the li elements. Looks great in IE. Not so much in firefox. Firefox doesn't seem to like the widths on the lis at all, and seems to be ignoring the margin or padding on the ul element as well (the first link is indented, like a normal ul would be. Help! Sandy, I need you! ~| 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:301166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Google Maps, CF and Ajax
Steve, Both of these tags actually do not use the version 2 ajax loader of google maps... They aer both version 1 inline markers... Do you, or anyone else, have any other ideas? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 3:23 PM To: CF-Talk Subject: RE: Google Maps, CF and Ajax Cool... I didn't think to look there. Thanks Steve. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 2:41 PM To: CF-Talk Subject: Re: Google Maps, CF and Ajax Yeah, RIAForge.org has two custom tags for interacting with Google Maps v2. You want to cache marker locations, so you don't hit the geocoder over and over for the same location info. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Mark Kruger wrote: Mashup gurus, I'm looking for some simple examples of using google maps version 2 with CF and Ajax Anyone? Also - any tips you have on performance when using a lot of markers. Thanks! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS help
On 3/13/08, Adrian Lynch [EMAIL PROTECTED] wrote: This'll no doubt help http://www.google.co.uk/search?hl=ensa=Xoi=spellresnum=0ct=resultcd=1q =taming+listsspell=1 That's an interesting page but doesn't seem to address my issue of setting width's on inline list elements. I also found this interesting web site: http://css.maxdesign.com.au/listamatic/ (which includes some Eric Myers stuff) but NONE of the horizontal examples include widths on inline elements. So I've given up on that. =) I've gone with simple padding of the list elements, so they aren't all the same size but it looks pretty nice. One thing I noticed with firefox is that it renders whitespace inside ul elements that appears betwen list elements. That's pretty lame. So I had to make sure I removed all the whitespace ullifoo/lilifoo2/li/ul Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best way to order appearance of database content...
I'm guessing the Javascript automatically assigns new values to the hidden field for seq for each paragraph upon reordering? I've thought about a JS solution, especially with jQuery, but I'm finding myself bringing in so many JS solutions, that keeping up with them is getting to be a chore. I guess this one would be important enough to use, especially since it seems to be the most intuitive for the user interface. That aspect alone could save me many support calls... Thanks, Claude! Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 9:44 AM To: CF-Talk Subject: Re: Best way to order appearance of database content... Would this be the best way to do this? Other ways? In my CMS, there are several items the user can choose the order he wants, ie. paragraphs in a page. In order to do so, he has a list of all of them and he can move them up or down (Javascript). On submit, a list of items is created in order chosen by the user, in a hidden field. In the table, each item has a column seq for a sequence number. In the update template, I simply update all sequence numbers in a loop, ie: CFSET seq = 1 CFLOOP INDEX=paraId LIST=#listPara# CFQUERY DATASOURCE=#application.applicationName# UPDATE paragraphs SET seq = #seq# WHERE paraId = #paraId# /CFQUERY CFSET seq = seq+1 /CFLOOP Then use the seq column to sort by your queries. It may be a little more overhead on the database, but for items in small numbers (say less than 1000), it is marginal. And it is much simpler to handle than leaving holes between numbers and eventually renumber items any way when there are no more holes left. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Creating a .cfm file on the fly
True and Google announced about six months ago that underscore will be treated like spaces, just like dashed are. http://www.seroundtable.com/archives/014260.html -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 6:27 PM To: CF-Talk Subject: RE: Creating a .cfm file on the fly Thanks, Denny... I read recently that dashes - in filenames were more search engine friendly than underscores. If I were to want to disallow underscores and allow dashes, how would the regex change? And, any thoughts on the dashes vs underscore issue? Thanks, Rick -Original Message- From: denstar [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 9:01 PM To: CF-Talk Subject: Re: Creating a .cfm file on the fly Here's a function that uses a regex to say, only good chars through, sorta: cffunction name=safeString access=public hint=strips unsafe chars returntype=string output=false cfargument name=stringToClean required=true type=string cfreturn rereplacenocase(stringToClean,'[^a-z|A-Z|0-9|_]','','all') /cffunction Basically, the allowed ones are the ones there-- A-Z (upper or lower case), 0-9, and underscores. Any others get stripped out. HIH, Denny -PS I use this in my existing CMS type of deal-- I'd recommend using more of a CMS approach (not writing .CFM files, and instead modeling what you want), or even better, if you like to generate stuff: pipe it all out to HTML files-- super performant-er! =] On Wed, Mar 12, 2008 at 6:35 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Casey... Do the replace's that you use below take care of *all* unwanted filename characters? I'm thinking about implementing a page-creation tool, also, and didn't think about the problems that could be created with bad filenames a user might create. Bruce... I tinkered with page creation, too, and used a template for the basis of a new page, then used cffile action = append... to add the HTML to the template. I also updated a menu.cfm file using append to add the new page name to the menu and cfincluded the menu.cfm in the new page. So basically, I just used cffile to copy the existing template to the requested filename, then used cffile append to the HTML and also used cffile append to update any cfincluded files, like the menu.cfm I mentioned. I'm also planning to use the CF8 FCKEditor (modified to be able to add photos, etc.) to allow the user to create the main content for the page. Pretty straightforward. Rick -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 8:16 PM To: CF-Talk Subject: Re: Creating a .cfm file on the fly On 3/12/08, Bruce Sorge [EMAIL PROTECTED] wrote: I have a client who wants me to make a change to a form he has. Currently he has a page that creates a new project that uses a WYSIWYG editor and put everything into a database table. What he wants instead is for the user to add a page name field in addition to the fields he already has, and when the user submits the form, he wants a .cfm page created with the value from the page name field being the file name. Of course I need to put the site's header and footer on there as well. So is there a way that I can create a template, and then when the form is submitted, using CFFILE or something like that to take that template and make a new page with it? Does this even make sense? Thanks, Bruce Yeah, I do something like this, you may know some regex that could eliminate half of this junk at the beginning. cfset FixedPageName =replace(FORM.PageName, ,-,all) cfset FixedPageName =replace(FixedPageName,:,,all) cfset FixedPageName =replace(FixedPageName,?,,all) cfset FixedPageName =replace(FixedPageName,$,S,all) cfset FixedPageName =replace(FixedPageName,,-and-,all) cfset FixedPageName =replace(FixedPageName,',,all) cfset FixedPageName =replace(FixedPageName,.,,all) cfset FixedPageName = LCase(FixedPageName) cfset FORM.FixedPageName=replace(FixedPageName,#FixedPageName#,#FixedPageName#. cfm,all) CFPARAM name=SavePath default=#ExpandPath(../../Folder)# CFSET sFileOutput = CFFILE Action=Write File=#SavePath#\#FORM.FixedPageName# Output=#sFileOutput# ~| 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:301170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe:
Coldfusion JSONp
Does anyone know anything about JSONp? I'm trying to call a CFC directly with
returnFormat set to JSON. I can get the result in the browser when I call the
URL directly, but nothing happens in my jQuery code. It appears that the
problem is that CF is outputting plain JSON and not JSONp.
I've got an AIR app I'm working on, one in which I'll be needing to
make a few calls from the user's desktop to our login server. I found
on the jQuery site where it says that cross domain calls work fine if
you return JSON data using the JSONP format. The demo works just fine,
but when I try to replicate it using my code, I get no data, or an
error. Can anyone tell me what I'm missing? Here's the two samples,
the one copied straight from the docs, the other copied and pasted
from my code:
$.getJSON(http://api.flickr.com/services/feeds/photos_public.gne?
tags=cattagmode=anyformat=jsonjsoncallback=?,
function(data){
alert(data);
$.each(data.items, function(i,item){
$(img/).attr(src,
item.media.m).appendTo(#content);
if ( i == 3 ) return false;
}
);
});
$.getJSON(http://www.commadelimited.com/uploads/bullhorn/bullhorn.cfc?
method=retriveDatajsoncallback=?,
function(data){
alert(1);
}
);
I've crossposted to the jQuery list as well...there are already a few replies
over there:
http://groups.google.com/group/jquery-en/browse_thread/thread/21a68cea4bb11e84/0d44e36723274ad1#0d44e36723274ad1
andy matthews
~|
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:301171
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion JSONp
What happens when you use $.ajax()?
$.ajax({
url: http://www.commadelimited.com/uploads/bullhorn/bullhorn.cfc
?method=retriveDatajsoncallback=?
, datatype: json
, method: get
, success: function() { /* do some stuff */ }
, error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(errorThrown); }
)
(or something similar)
Neil
On Thu, Mar 13, 2008 at 3:44 PM, Andy Matthews [EMAIL PROTECTED]
wrote:
Does anyone know anything about JSONp? I'm trying to call a CFC directly
with returnFormat set to JSON. I can get the result in the browser when I
call the URL directly, but nothing happens in my jQuery code. It appears
that the problem is that CF is outputting plain JSON and not JSONp.
I've got an AIR app I'm working on, one in which I'll be needing to
make a few calls from the user's desktop to our login server. I found
on the jQuery site where it says that cross domain calls work fine if
you return JSON data using the JSONP format. The demo works just fine,
but when I try to replicate it using my code, I get no data, or an
error. Can anyone tell me what I'm missing? Here's the two samples,
the one copied straight from the docs, the other copied and pasted
from my code:
$.getJSON(http://api.flickr.com/services/feeds/photos_public.gne?
tags=cattagmode=anyformat=jsonjsoncallback=?,
function(data){
alert(data);
$.each(data.items, function(i,item){
$(img/).attr(src, item.media.m
).appendTo(#content);
if ( i == 3 ) return false;
}
);
});
$.getJSON(http://www.commadelimited.com/uploads/bullhorn/bullhorn.cfc?
method=retriveDatajsoncallback=?,
function(data){
alert(1);
}
);
I've crossposted to the jQuery list as well...there are already a few
replies over there:
http://groups.google.com/group/jquery-en/browse_thread/thread/21a68cea4bb11e84/0d44e36723274ad1#0d44e36723274ad1
andy matthews
~|
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:301172
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Creating a .cfm file on the fly
Thanks for the clarification, Jacob. Rick -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 10:36 AM To: CF-Talk Subject: RE: Creating a .cfm file on the fly True and Google announced about six months ago that underscore will be treated like spaces, just like dashed are. http://www.seroundtable.com/archives/014260.html -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 6:27 PM To: CF-Talk Subject: RE: Creating a .cfm file on the fly Thanks, Denny... I read recently that dashes - in filenames were more search engine friendly than underscores. If I were to want to disallow underscores and allow dashes, how would the regex change? And, any thoughts on the dashes vs underscore issue? Thanks, Rick -Original Message- From: denstar [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 9:01 PM To: CF-Talk Subject: Re: Creating a .cfm file on the fly Here's a function that uses a regex to say, only good chars through, sorta: cffunction name=safeString access=public hint=strips unsafe chars returntype=string output=false cfargument name=stringToClean required=true type=string cfreturn rereplacenocase(stringToClean,'[^a-z|A-Z|0-9|_]','','all') /cffunction Basically, the allowed ones are the ones there-- A-Z (upper or lower case), 0-9, and underscores. Any others get stripped out. HIH, Denny -PS I use this in my existing CMS type of deal-- I'd recommend using more of a CMS approach (not writing .CFM files, and instead modeling what you want), or even better, if you like to generate stuff: pipe it all out to HTML files-- super performant-er! =] On Wed, Mar 12, 2008 at 6:35 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Casey... Do the replace's that you use below take care of *all* unwanted filename characters? I'm thinking about implementing a page-creation tool, also, and didn't think about the problems that could be created with bad filenames a user might create. Bruce... I tinkered with page creation, too, and used a template for the basis of a new page, then used cffile action = append... to add the HTML to the template. I also updated a menu.cfm file using append to add the new page name to the menu and cfincluded the menu.cfm in the new page. So basically, I just used cffile to copy the existing template to the requested filename, then used cffile append to the HTML and also used cffile append to update any cfincluded files, like the menu.cfm I mentioned. I'm also planning to use the CF8 FCKEditor (modified to be able to add photos, etc.) to allow the user to create the main content for the page. Pretty straightforward. Rick -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 8:16 PM To: CF-Talk Subject: Re: Creating a .cfm file on the fly On 3/12/08, Bruce Sorge [EMAIL PROTECTED] wrote: I have a client who wants me to make a change to a form he has. Currently he has a page that creates a new project that uses a WYSIWYG editor and put everything into a database table. What he wants instead is for the user to add a page name field in addition to the fields he already has, and when the user submits the form, he wants a .cfm page created with the value from the page name field being the file name. Of course I need to put the site's header and footer on there as well. So is there a way that I can create a template, and then when the form is submitted, using CFFILE or something like that to take that template and make a new page with it? Does this even make sense? Thanks, Bruce Yeah, I do something like this, you may know some regex that could eliminate half of this junk at the beginning. cfset FixedPageName =replace(FORM.PageName, ,-,all) cfset FixedPageName =replace(FixedPageName,:,,all) cfset FixedPageName =replace(FixedPageName,?,,all) cfset FixedPageName =replace(FixedPageName,$,S,all) cfset FixedPageName =replace(FixedPageName,,-and-,all) cfset FixedPageName =replace(FixedPageName,',,all) cfset FixedPageName =replace(FixedPageName,.,,all) cfset FixedPageName = LCase(FixedPageName) cfset FORM.FixedPageName=replace(FixedPageName,#FixedPageName#,#FixedPageName#. cfm,all) CFPARAM name=SavePath default=#ExpandPath(../../Folder)# CFSET sFileOutput = CFFILE Action=Write File=#SavePath#\#FORM.FixedPageName# Output=#sFileOutput# ~| Adobe® ColdFusion® 8
Re: Creating a .cfm file on the fly
If you are on CF8 or BD7 you could keep the same code base, mostly. Just change the links to the filename and then use onMissingTemplate in Application.cfc. Adam Haskell On Wed, Mar 12, 2008 at 8:13 PM, Bruce Sorge [EMAIL PROTECTED] wrote: Denny, Thanks for the info. The client is currently using a CMS and the pages are being called by page_detail.cfm?ID=X. They want to do away with this and use an actual file instead. So I will be taking the name of the file, and insert it into the DB in a new field instead of the pages HTML. Bruce denstar wrote: -PS I use this in my existing CMS type of deal-- I'd recommend using more of a CMS approach (not writing .CFM files, and instead modeling what you want), or even better, if you like to generate stuff: pipe it all out to HTML files-- super performant-er! = ~| 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:301174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SPAM: Re: Coldfusion JSONp
Well the problem is that it's going to have to be a cross domain request.
The client will be an AIR app runnning on my machine, and at that point
any request, to any domain, would be cross domain.
So I don't think it's the getJSON method that's at fault...it appears to be
that CF doesn't understand JSONp which is what the getJSON call is expecting
to see.
-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2008 10:02 AM
To: CF-Talk
Subject: SPAM: Re: Coldfusion JSONp
What happens when you use $.ajax()?
$.ajax({
url: http://www.commadelimited.com/uploads/bullhorn/bullhorn.cfc
?method=retriveDatajsoncallback=?
, datatype: json
, method: get
, success: function() { /* do some stuff */ }
, error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(errorThrown); }
)
(or something similar)
Neil
On Thu, Mar 13, 2008 at 3:44 PM, Andy Matthews [EMAIL PROTECTED]
wrote:
Does anyone know anything about JSONp? I'm trying to call a CFC
directly with returnFormat set to JSON. I can get the result in the
browser when I call the URL directly, but nothing happens in my jQuery
code. It appears that the problem is that CF is outputting plain JSON and
not JSONp.
I've got an AIR app I'm working on, one in which I'll be needing to
make a few calls from the user's desktop to our login server. I found
on the jQuery site where it says that cross domain calls work fine if
you return JSON data using the JSONP format. The demo works just fine,
but when I try to replicate it using my code, I get no data, or an
error. Can anyone tell me what I'm missing? Here's the two samples,
the one copied straight from the docs, the other copied and pasted
from my code:
$.getJSON(http://api.flickr.com/services/feeds/photos_public.gne?
tags=cattagmode=anyformat=jsonjsoncallback=?,
function(data){
alert(data);
$.each(data.items, function(i,item){
$(img/).attr(src, item.media.m
).appendTo(#content);
if ( i == 3 ) return false;
}
);
});
$.getJSON(http://www.commadelimited.com/uploads/bullhorn/bullhorn.cfc?
method=retriveDatajsoncallback=?,
function(data){
alert(1);
}
);
I've crossposted to the jQuery list as well...there are already a few
replies over there:
http://groups.google.com/group/jquery-en/browse_thread/thread/21a68cea
4bb11e84/0d44e36723274ad1#0d44e36723274ad1
andy matthews
~|
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:301175
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
export to Excel
I need to export query results and graph objects to excel. the spreadsheet is no big deal, however, I've never created a graph from coldFusion to Excel. I would like to know what all of you advise. Also what is the best custom tag (if any) for this? Thanks KES ~| 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:301176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best way to order appearance of database content...
I'm guessing the Javascript automatically assigns new values
to the hidden field for seq for each paragraph upon reordering?
Not exactly.
I use a table to display elements, each one in its own row TR element.
I use some move up and move down function to switch two TR element in a
table.
The row has icons like up and down arrows. For example:
TR ID=#paraId#
TD onclick=move(this, -1)IMG SRC=up.gif WIDTH=16 HEIGHT=13
BORDER=0 ALT=Move up/TD
TD onclick=move(this, 1)IMG SRC=down.gif WIDTH=16 HEIGHT=13
BORDER=0 ALT=Move down/TD
TD(description of the element)/TD
/TR
The the onClick function will find the TR parent element, the one
before, or after and switch the two rows in the table.
Then only on submit, the function setSeq is called.
What it does, is get the table containing the elements, find all TRs in
the order the use has chosen,
each TR has an id which is actually the id of the paragraph. From these,
the function set the valu of the listPara hidden field.
Pretty simple:
function setSeq()
{
var tb = document.getElementById(tablePara);
if (tb)
{
var tr = tb.rows;
var nbTr = tr.length;
var val = tr[0].id;
for (var i = 1; inbTr ; i++) val += , + tr[i].id
document.formul.listPara.value = val;
}
}
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301177
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Experienced ColdFusion Developer Needed - ALLEN, TX
By the way, no agencies please. Only developers looking for a home with a fantastic company need respond. The company for which I work is currently seeking an experienced CF developer. We need someone with good experience, who's intelligent, can figure out complex problems and write smart and efficient code to deal with them. We need someone who can be creative and can work well in a small team without a big corporate structure. We've got to have someone full-time and on-site. I'll tell you that this is the best place I've ever worked. The company is small and the environment relaxed, (I wear jeans and a t-shirt just about every day and sometimes shorts in the summer). There are no politics to worry about and we move fairly rapidly. When we have something that needs to be done, we just sit down and do it. We're in the process of upgrading to CF8 right now and we're also in the middle of a move up to MySQL 5. The company has been more profitable than the previous year for each year it has been in business. We fit in a nice little niche where our customers seek us out as often as we go looking for them. The pay is competitive and the benefits are nice. I really love working here. The job description is pasted below; take a minute to send me a resume and let's talk about how you might fit in here! About the position: Latitude Technologies is seeking a candidate to develop, maintain and enhance Cold-Fusion-based Internet applications. The position offers a high degree of autonomy and flexibility, a wide range of tasks, and requires no travel. The opportunity is full time with benefits including medical and dental coverage and a 401K plan. About the candidate: Candidates must have a strong programming background in Cold Fusion and related Internet development technologies. Knowledge of MySQL is preferred. A background in the energy industry is a plus. The candidate should have an interest in learning and mastering new Internet tools and techniques as our customer's requirements evolve. About the company: Allen, Texas-based Latitude Technologies, Inc. is a growing, 10-year-old technology services company that provides Internet-based applications to the dynamic and evolving energy industry. Our customers range from Fortune 100 companies to small independent energy providers. Our success stems from our emphasis on providing our customers with timely, reliable results. More details about our services can be found at www.LatitudeTech.net . Thanks, Ken Ferguson ~| 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:301178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best way to order appearance of database content...
That sounds like the type of solution I'm looking for.
I've found some drag-n-drop re-order js, but I think the
arrow version of reordering would be more user friendly.
Thanks for the explanation.
Rick
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2008 11:29 AM
To: CF-Talk
Subject: Re: Best way to order appearance of database content...
I'm guessing the Javascript automatically assigns new values
to the hidden field for seq for each paragraph upon reordering?
Not exactly.
I use a table to display elements, each one in its own row TR element.
I use some move up and move down function to switch two TR element in a
table.
The row has icons like up and down arrows. For example:
TR ID=#paraId#
TD onclick=move(this, -1)IMG SRC=up.gif WIDTH=16 HEIGHT=13
BORDER=0 ALT=Move up/TD
TD onclick=move(this, 1)IMG SRC=down.gif WIDTH=16 HEIGHT=13
BORDER=0 ALT=Move down/TD
TD(description of the element)/TD
/TR
The the onClick function will find the TR parent element, the one
before, or after and switch the two rows in the table.
Then only on submit, the function setSeq is called.
What it does, is get the table containing the elements, find all TRs in
the order the use has chosen,
each TR has an id which is actually the id of the paragraph. From these,
the function set the valu of the listPara hidden field.
Pretty simple:
function setSeq()
{
var tb = document.getElementById(tablePara);
if (tb)
{
var tr = tb.rows;
var nbTr = tr.length;
var val = tr[0].id;
for (var i = 1; inbTr ; i++) val += , + tr[i].id
document.formul.listPara.value = val;
}
}
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301179
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Experienced ColdFusion Developer Needed - ALLEN, TX
Really sorry all, I was attempting to post back to CF-JOBS to add the line at the top to my post there, but I accidentally sent it to the CF-TALK address instead. - Original Message From: Kenneth Ferguson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 13, 2008 10:29:35 AM Subject: Experienced ColdFusion Developer Needed - ALLEN, TX By the way, no agencies please. Only developers looking for a home with a fantastic company need respond. The company for which I work is currently seeking an experienced CF developer. We need someone with good experience, who's intelligent, can figure out complex problems and write smart and efficient code to deal with them. We need someone who can be creative and can work well in a small team without a big corporate structure. We've got to have someone full-time and on-site. I'll tell you that this is the best place I've ever worked. The company is small and the environment relaxed, (I wear jeans and a t-shirt just about every day and sometimes shorts in the summer). There are no politics to worry about and we move fairly rapidly. When we have something that needs to be done, we just sit down and do it. We're in the process of upgrading to CF8 right now and we're also in the middle of a move up to MySQL 5. The company has been more profitable than the previous year for each year it has been in business. We fit in a nice little niche where our customers seek us out as often as we go looking for them. The pay is competitive and the benefits are nice. I really love working here. The job description is pasted below; take a minute to send me a resume and let's talk about how you might fit in here! About the position: Latitude Technologies is seeking a candidate to develop, maintain and enhance Cold-Fusion-based Internet applications. The position offers a high degree of autonomy and flexibility, a wide range of tasks, and requires no travel. The opportunity is full time with benefits including medical and dental coverage and a 401K plan. About the candidate: Candidates must have a strong programming background in Cold Fusion and related Internet development technologies. Knowledge of MySQL is preferred. A background in the energy industry is a plus. The candidate should have an interest in learning and mastering new Internet tools and techniques as our customer's requirements evolve. About the company: Allen, Texas-based Latitude Technologies, Inc. is a growing, 10-year-old technology services company that provides Internet-based applications to the dynamic and evolving energy industry. Our customers range from Fortune 100 companies to small independent energy providers. Our success stems from our emphasis on providing our customers with timely, reliable results. More details about our services can be found at www.LatitudeTech.net . Thanks, Ken Ferguson ~| 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:301180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
Using arrows to swap items certainly works (I've used that technique myself), but it becomes a pain for the user when they want to move an item (an agent, in this case) several slots up or down. I did a blog post on how to use jQuery to reorder a list using drag-and-drop: http://www.swartzfager.org/blog/index.cfm/2007/11/11/UI-Tool--Rearranging-Items-in-a-List-jQuerystyle the example page has a download link where you can download the code. -- Brian Swartzfager http://www.swartzfager.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFDOCUMENT and table cells with background colors and borders
Hi, I am generating a table with borders (it is a report). I am then using the same content that I display to the screen within my cfdocument tag. Some of the cells (like the column header row) have background colors. I also have a 3px border on the left and right side of the whole table. The problem I'm having is that the background color bleeds through the border 1 pixel. It does it on the right border and the bottom border, but the top and left borders look just fine. I cannot figure out why this happens as the table displayed within the browser looks perfect. Please help! 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:301182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinput=datefield display problems in IE7
I was getting the same thing, so I played around a little bit with wrapping the cfinput in another div, and this seems to work in IE7 and FF2: div style=clear:both;position:relative;z-index:3;cfinput type../div div style=clear:both;position:relative;z-index:2;cfinput type../div div style=clear:both;position:relative;z-index:1;cfinput type../div I have a form with auto-generated datefields that are vertically aligned on top of one another. In IE7, the div holding the javascript generated calendar gets displayed underneath the form field items directly below it. Does anyone have any ideas about how to fix this? I am currently using a javascript function to throw the calendar out to the side of the fields, but I would prefer the default functionality. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Best way to order appearance of database content...
Thanks, Brian. I'll check it out. Rick -Original Message- From: Brian Swartzfager [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 1:26 PM To: CF-Talk Subject: Re: Best way to order appearance of database content... Using arrows to swap items certainly works (I've used that technique myself), but it becomes a pain for the user when they want to move an item (an agent, in this case) several slots up or down. I did a blog post on how to use jQuery to reorder a list using drag-and-drop: http://www.swartzfager.org/blog/index.cfm/2007/11/11/UI-Tool--Rearranging-Items-in-a-List- jQuerystyle the example page has a download link where you can download the code. -- Brian Swartzfager http://www.swartzfager.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Advanced CF Certified Developer directory
Hi Where is the official list of certified developers theses days? All I can find ATM is dead or hanging links. ta ~| 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:301185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best way to order appearance of database content...
but it becomes a pain for the user when they want to move an item (an agent, in this case) several slots up or down. Exact. I favored the arrow method because pages have only a few paragraphs in average. For my menu editor however I use the drag'n drop method. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT and table cells with background colors and borders
Dave Phillips wrote: The problem I'm having is that the background color bleeds through the border 1 pixel. That is a cfdocument bug: http://adobe.com/go/wish/ Jochem ~| 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:301187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Website Statistics Recommendations
All: Can anyone recommend a website statistics (log analyzer or otherwise) package that can work with dynamic content and URLs? That is, it should be able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, ideally, even allow you to assign titles to each of the pages. Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Website Statistics Recommendations
We use urchin (which you might not be able to get anymore), but Google analytics should give you most of what you need. Plus it's FREE. Russ -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 12:51 PM To: CF-Talk Subject: Website Statistics Recommendations All: Can anyone recommend a website statistics (log analyzer or otherwise) package that can work with dynamic content and URLs? That is, it should be able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, ideally, even allow you to assign titles to each of the pages. Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT and table cells with background colors and borders
It was happening in MX 7 too, so I'm surprised if it's a bug it hasn't been fixed. Does anyone have any ideas for a work-around/hack to deal with it? Thanks! Dave Dave Phillips wrote: The problem I'm having is that the background color bleeds through the border 1 pixel. That is a cfdocument bug: http://adobe.com/go/wish/ Jochem ~| 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:301190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Website Statistics Recommendations
On Thu, Mar 13, 2008 at 12:50 PM, Mosh Teitelbaum [EMAIL PROTECTED] wrote: All: Can anyone recommend a website statistics (log analyzer or otherwise) package that can work with dynamic content and URLs? That is, it should be able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, ideally, even allow you to assign titles to each of the pages. omniture.com Not free but well worth the price, if you need super detailed stats... I think it can go for around 0.17 cents every 1000 page views or something. ~| 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:301191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Website Statistics Recommendations
SmarterStats by SmarterTools -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 12:51 PM To: CF-Talk Subject: Website Statistics Recommendations All: Can anyone recommend a website statistics (log analyzer or otherwise) package that can work with dynamic content and URLs? That is, it should be able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, ideally, even allow you to assign titles to each of the pages. Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT and table cells with background colors and borders
I have submitted a bug request. I'm going to post a separate thread for a workaround. It was happening in MX 7 too, so I'm surprised if it's a bug it hasn't been fixed. Does anyone have any ideas for a work-around/hack to deal with it? Thanks! Dave Dave Phillips wrote: The problem I'm having is that the background color bleeds through the border 1 pixel. That is a cfdocument bug: http://adobe.com/go/wish/ Jochem ~| 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:301193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDOCUMENT bug - workaround challenge!
Hi all,
I have discovered what appears to be a bug with CFDOCUMENT and am now looking
for some sort of workaround/hack/fix for it. I'm working on one right now, but
thought I'd share my test code with the community in case someone who is a
better coder than I can come up with a solution faster! :) (and there are
plenty of you out there I'm sure!)
See the code below: The result is that the background color of the column
header row and total rows bleed through the right border 1 pixel and the bottom
row bleeds through the bottom border 1 pixel as well.
cfparam name=url.toPDF default=false
!--- note: adding /testbug.pdf to the url below causes windows to display
that as the filename
when opening the PDF instead of testbug.cfm ---
a href=testbug.cfm/testbug.pdf?toPDF=trueExport to PDF/abr
cfsavecontent variable=sContent
table width=100% cellspacing=0 cellpadding=0
tr
td style=background-color: #c0c0c0; border-left: 3px
solid black; border-top: 3px solid black; font-weight: bold;COL Header 1/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 3px solid black; font-weight: bold;COL Header 2/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 3px solid black; font-weight: bold;COL Header 3/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 3px solid black; font-weight: bold;COL Header 4/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 3px solid black; border-right: 3px solid black;
font-weight: bold;COL Header 5/td
/tr
cfloop from=1 to=5 index=rownum
tr
td style=border-left: 3px solid black; border-top:
1px solid black;Data Row cfoutput#rownum#/cfoutput/td
td style=border-left: 1px solid black; border-top:
1px solid black;Data Row cfoutput#rownum#/cfoutput/td
td style=border-left: 1px solid black; border-top:
1px solid black;Data Row cfoutput#rownum#/cfoutput/td
td style=border-left: 1px solid black; border-top:
1px solid black;Data Row cfoutput#rownum#/cfoutput/td
td style=border-left: 1px solid black; border-top:
1px solid black; border-right: 3px solid black;Data Row
cfoutput#rownum#/cfoutput/td
/tr
/cfloop
tr
td style=background-color: #c0c0c0; border-left: 3px
solid black; border-top: 2px solid black; border-bottom: 3px solid
black;Total Row/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 2px solid black; border-bottom: 3px solid
black;Total Row/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 2px solid black; border-bottom: 3px solid
black;Total Row/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 2px solid black; border-bottom: 3px solid
black;Total Row/td
td style=background-color: #c0c0c0; border-left: 1px
solid black; border-top: 2px solid black; border-right: 3px solid black;
border-bottom: 3px solid black;Total Row/td
/tr
/table
/cfsavecontent
cfif url.toPDF
cfdocument format=PDF
filename=#expandPath('testbug.pdf')#
overwrite=true
orientation=landscape
scale=100
pagewidth=10.5
pageheight=8
margintop=.25
marginbottom=.25
marginleft=.25
marginright=.25
cfoutput#sContent#/cfoutput
/cfdocument
cfheader name=Content-Disposition
value=attachment='#expandPath('testbug.pdf')#'
cfcontent file=#expandPath('testbug.pdf')# type=application/pdf
reset=yes
cfelse
cfoutput#sContent#/cfoutput
/cfif
~|
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:301194
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Emergency cfcfform isssue
We have a live site that uses cfform and the js is not being generated AT ALL. Any Idea on how to get it to work. pls no lectures on cf form. The site was done in 2.5 days. We just need it work work. Many thanx G -- I am always doing that which I can not do, in order that I may learn how to do it. - Pablo Picasso ~| 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:301195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Emergency cfcfform isssue
Gerald Guido wrote: We have a live site that uses cfform and the js is not being generated AT ALL. Any Idea on how to get it to work. pls no lectures on cf form. The site was done in 2.5 days. We just need it work work. Many thanx G CFIDE properly mapped and available? ~| 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:301196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Emergency cfcfform isssue
Never mind... major freak out 9 hours sleep in 3 days... On Thu, Mar 13, 2008 at 1:46 PM, Gerald Guido [EMAIL PROTECTED] wrote: We have a live site that uses cfform and the js is not being generated AT ALL. Any Idea on how to get it to work. pls no lectures on cf form. The site was done in 2.5 days. We just need it work work. Many thanx G -- I am always doing that which I can not do, in order that I may learn how to do it. - Pablo Picasso -- I am always doing that which I can not do, in order that I may learn how to do it. - Pablo Picasso ~| 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:301197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
File download not working
I'm trying to enable a user to download a user information file. The file is generated on a different server and is supposed to be offered up to the user to save. I had it working before, but now it's not. I have looked all over the web and have seen and tried various adaptations to the code I started with, but none of them seem to be working. All I get is the message ...cannot download DownloadUserInfo.cfm...site is either unavailable or cannot be found I know that the file is there and functioning and that the cfm is being reached and is being processed. It fails when I try to add the content. Code below: cfset myFile = #fromdir# txtfiles.aes cfheader name=Content-Disposition value=attachment:filename=txtfiles.aes cfheader name=Content-Description value=User Info File cfcontent type=application/aes file=#myFile# I've tried various adaptations including using cflocation to no avail. The path points to d:\synchdata\davetest\qatest\txtfiles.aes which is correct. TIA David Phelan Senior CF Developer LifePoint Informatics (Formerly Labtest.com) (201) 447-9991 Ext. 318 [EMAIL PROTECTED] ~| 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:301198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Emergency cfcfform isssue
CFIDE properly mapped and available? that was it... I was looking at page that didn't have any generated JS so I assumed it was some feakish Murphy's law thing... lack of sleep, huge amount of pressure The site is of *Major importance* to the company. A sub dropped the ball and we had to generate a survey with ~ 400 questions. over a thousand cfinputs (radio, checkbox) 2 guys 2.5 days. All database manipulation was done with 5 lines of code using SQL.cfc. No really... we wrote 2 small update querys cuz to make sure a variable stuck in the DB. Yeah. Do that with some other language. CF Rules. On Thu, Mar 13, 2008 at 1:48 PM, Ian Skinner [EMAIL PROTECTED] wrote: Gerald Guido wrote: We have a live site that uses cfform and the js is not being generated AT ALL. Any Idea on how to get it to work. pls no lectures on cf form. The site was done in 2.5 days. We just need it work work. Many thanx G CFIDE properly mapped and available? ~| 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:301199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Emergency cfcfform isssue
Gerald Guido wrote: CFIDE properly mapped and available? that was it... I was looking at page that didn't have any generated JS so I assumed it was some feakish Murphy's law thing... Yup... CFIDE isn't just for JavaScript anymore. It also has the SWF's and such logic necessary for the Flash stuff. ~| 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:301200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: CFEclipse and excluding directories from a project
Hey All, I'm trying to add a remote folder (easy enough), but I only want the files in it's root and specific child folders. For example: Remote Dir: My App My Dir contains: file 1 file 2 file 3 dir 1 dir 2 dir 3 I want a folder in Eclipse called My App that contains all 3 files and only dir 1. Any thoughts? and to be clear I'd really rather not create a local folder called My App and then add each remote/linked file individually and then just the remote/linked folder I want. That would take forever (way more files and folders than my example). TIA Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: CFEclipse and excluding directories from a project
Use working sets, that's exactly what they're for. And better yet, you can overlay multiple working sets on a single project (or group of projects). Incredibly handy for larger projects/groups of projects. I don't know if that'll work with remote dir things, as I'm not familiar with those at all? That a CFEclipse thing? cheers, barneyb On Thu, Mar 13, 2008 at 11:30 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I'm trying to add a remote folder (easy enough), but I only want the files in it's root and specific child folders. For example: Remote Dir: My App My Dir contains: file 1 file 2 file 3 dir 1 dir 2 dir 3 I want a folder in Eclipse called My App that contains all 3 files and only dir 1. Any thoughts? and to be clear I'd really rather not create a local folder called My App and then add each remote/linked file individually and then just the remote/linked folder I want. That would take forever (way more files and folders than my example). TIA Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Website Statistics Recommendations
Urchin was bought by someone and I don't remember who... Google analytics is pretty cool...and as you state...free :-D Eric /*-Original Message- /*From: Russ [mailto:[EMAIL PROTECTED] /*Sent: Thursday, March 13, 2008 11:54 AM /*To: CF-Talk /*Subject: RE: Website Statistics Recommendations /* /*We use urchin (which you might not be able to get anymore), but Google /*analytics should give you most of what you need. Plus it's FREE. /* /*Russ /* /* -Original Message- /* From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] /* Sent: Thursday, March 13, 2008 12:51 PM /* To: CF-Talk /* Subject: Website Statistics Recommendations /* /* All: /* /* /* /* Can anyone recommend a website statistics (log analyzer or otherwise) /* package that can work with dynamic content and URLs? That is, it should /* be /* able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, /* ideally, even allow you to assign titles to each of the pages. /* /* /* /* Thanks. /* /* /* /* -- /* /* Mosh Teitelbaum /* /* evoch, LLC /* /* Tel: (301) 942-5378 /* /* Fax: (301) 933-3651 /* /* Email: [EMAIL PROTECTED] /* /* WWW: http://www.evoch.com/ /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: CFEclipse and excluding directories from a project
On Thu, 2008-03-13 at 11:41 -0700, Barney Boisvert wrote: Use working sets, that's exactly what they're for. And better yet, you can overlay multiple working sets on a single project (or group of projects). Incredibly handy for larger projects/groups of projects. Do you have some quick and dirty steps to using them? ;-) I don't know if that'll work with remote dir things, as I'm not familiar with those at all? That a CFEclipse thing? By remote dir I simply meant adding a linked directory to a project (right click new folder click advanced button browse to remote folder click finish). I want to be able to add a remote directory, exclude some of it's child directories. Cheers cheers, barneyb - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating a .cfm file on the fly
Check out Peter Bell's CFTemplate at http://cftemplate.riaforge.org/ I use this to do exactly what you are talking about. It will take you an hour to come up to speed on what he is doing, but it works really nicely for creating cfm templates on the fly. Jeff I have a client who wants me to make a change to a form he has. Currently he has a page that creates a new project that uses a WYSIWYG editor and put everything into a database table. What he wants instead is for the user to add a page name field in addition to the fields he already has, and when the user submits the form, he wants a .cfm page created with the value from the page name field being the file name. Of course I need to put the site's header and footer on there as well. So is there a way that I can create a template, and then when the form is submitted, using CFFILE or something like that to take that template and make a new page with it? Does this even make sense? Thanks, Bruce ~| 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:301205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Website Statistics Recommendations
On Thu, Mar 13, 2008 at 11:55 AM, Eric Roberts [EMAIL PROTECTED] wrote: Urchin was bought by someone and I don't remember who... Google analytics is pretty cool...and as you state...free :-D i'm pretty sure Urchin was bought by (and is now) Google Analytics :) -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| 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:301206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Website Statistics Recommendations
Urchin was bought by Google... and is no longer available for purchase AFAIK. Google analytics will only analyze pages on which you put their js. It will not analyze images/etc. There are some free log analyzers if that's what you need to do. Russ -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 2:56 PM To: CF-Talk Subject: RE: Website Statistics Recommendations Urchin was bought by someone and I don't remember who... Google analytics is pretty cool...and as you state...free :-D Eric /*-Original Message- /*From: Russ [mailto:[EMAIL PROTECTED] /*Sent: Thursday, March 13, 2008 11:54 AM /*To: CF-Talk /*Subject: RE: Website Statistics Recommendations /* /*We use urchin (which you might not be able to get anymore), but Google /*analytics should give you most of what you need. Plus it's FREE. /* /*Russ /* /* -Original Message- /* From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] /* Sent: Thursday, March 13, 2008 12:51 PM /* To: CF-Talk /* Subject: Website Statistics Recommendations /* /* All: /* /* /* /* Can anyone recommend a website statistics (log analyzer or otherwise) /* package that can work with dynamic content and URLs? That is, it should /* be /* able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, /* ideally, even allow you to assign titles to each of the pages. /* /* /* /* Thanks. /* /* /* /* -- /* /* Mosh Teitelbaum /* /* evoch, LLC /* /* Tel: (301) 942-5378 /* /* Fax: (301) 933-3651 /* /* Email: [EMAIL PROTECTED] /* /* WWW: http://www.evoch.com/ /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Website Statistics Recommendations
Thanks for the recommendations everyone. I'll check them out. -- Mosh Teitelbaum evoch, LLC WWW: http://www.evoch.com/ -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Can anyone recommend a website statistics (log analyzer or otherwise) package that can work with dynamic content and URLs? That is, it should be able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, ideally, even allow you to assign titles to each of the pages. ~| 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:301208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: CFEclipse and excluding directories from a project
On Thu, Mar 13, 2008 at 12:01 PM, Bryan Stevenson [EMAIL PROTECTED] wrote: On Thu, 2008-03-13 at 11:41 -0700, Barney Boisvert wrote: Use working sets, that's exactly what they're for. And better yet, you can overlay multiple working sets on a single project (or group of projects). Incredibly handy for larger projects/groups of projects. Do you have some quick and dirty steps to using them? ;-) Once you have your remote folder mapped, click the down arrow in the toolbar for the view and hit 'select working set'. Hit 'new' to name and select the included items on the new working set. You can either check the top-level stuff and uncheck children, or leave the top-level unchecked and just check the children you care about. You then use the same down arrow menu to switch between working sets (or no working site - all projects). cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:301209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Website Statistics Recommendations
Urchin can be downloaded as a three month trial now. It is in beta testing according to Google, and will be available for 2995 when it is released. I like the SmarterStats. Rob On Thu, Mar 13, 2008 at 3:05 PM, Russ [EMAIL PROTECTED] wrote: Urchin was bought by Google... and is no longer available for purchase AFAIK. Google analytics will only analyze pages on which you put their js. It will not analyze images/etc. There are some free log analyzers if that's what you need to do. Russ -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 2:56 PM To: CF-Talk Subject: RE: Website Statistics Recommendations Urchin was bought by someone and I don't remember who... Google analytics is pretty cool...and as you state...free :-D Eric /*-Original Message- /*From: Russ [mailto:[EMAIL PROTECTED] /*Sent: Thursday, March 13, 2008 11:54 AM /*To: CF-Talk /*Subject: RE: Website Statistics Recommendations /* /*We use urchin (which you might not be able to get anymore), but Google /*analytics should give you most of what you need. Plus it's FREE. /* /*Russ /* /* -Original Message- /* From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] /* Sent: Thursday, March 13, 2008 12:51 PM /* To: CF-Talk /* Subject: Website Statistics Recommendations /* /* All: /* /* /* /* Can anyone recommend a website statistics (log analyzer or otherwise) /* package that can work with dynamic content and URLs? That is, it should /* be /* able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, /* ideally, even allow you to assign titles to each of the pages. /* /* /* /* Thanks. /* /* /* /* -- /* /* Mosh Teitelbaum /* /* evoch, LLC /* /* Tel: (301) 942-5378 /* /* Fax: (301) 933-3651 /* /* Email: [EMAIL PROTECTED] /* /* WWW: http://www.evoch.com/ /* /* /* /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File download not working
Dave wrote: ...cannot download DownloadUserInfo.cfm...site is either unavailable or cannot be found cfset myFile = #fromdir# txtfiles.aes cfheader name=Content-Disposition value=attachment:filename=txtfiles.aes cfheader name=Content-Description value=User Info File cfcontent type=application/aes file=#myFile# Why do you need the Content-Description? It is not a header from RFC 2616. Your Content-Disposition has a colon instead of a semi-colon. I would add some error checking as well: cfset myFile = fromdir txtfiles.aes cfif FileExists(myFile) cfheader name=Content-Disposition value=attachment; filename=txtfiles.aes / cfcontent type=application/aes file=#myFile# / cfelse cfthrow message=File #myFile# not found / /cfif If that doesn't work use a packetsniffer to see what really gets send to the browser. Jochem ~| 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:301211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: CFEclipse and excluding directories from a project
Thanks Barney That sounds doable except for the fact you have to add all the crap you don't want in the first place ;-) Sure makes for a hellish first refresh until you can exclude things. *sigh* Oh well...too bad we can pick a remote folderuncheck the child stuff we don't want and add it as we want it first and not adjust it after the fact. Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Thu, 2008-03-13 at 12:10 -0700, Barney Boisvert wrote: On Thu, Mar 13, 2008 at 12:01 PM, Bryan Stevenson [EMAIL PROTECTED] wrote: On Thu, 2008-03-13 at 11:41 -0700, Barney Boisvert wrote: Use working sets, that's exactly what they're for. And better yet, you can overlay multiple working sets on a single project (or group of projects). Incredibly handy for larger projects/groups of projects. Do you have some quick and dirty steps to using them? ;-) Once you have your remote folder mapped, click the down arrow in the toolbar for the view and hit 'select working set'. Hit 'new' to name and select the included items on the new working set. You can either check the top-level stuff and uncheck children, or leave the top-level unchecked and just check the children you care about. You then use the same down arrow menu to switch between working sets (or no working site - all projects). cheers, barneyb ~| 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:301212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Website Statistics Recommendations
I use mint and really like it, plus it has a plugin interface, so you can write your own plugin (PHP) or download any of the third-party plugins. You can get it at haveamint.com -Brian All: Can anyone recommend a website statistics (log analyzer or otherwise) package that can work with dynamic content and URLs? That is, it should be able to differentiate between page.cfm?id=123 and page.cfm?id=456 and, ideally, even allow you to assign titles to each of the pages. Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
inSERTurl variables into database using coldfusion
Hi guys . I have 2 forms . The first form sending email which provide the link
to second form
pa
href=http://omnilearn.com/sunriseportal/external/addressemail/form.cfm?name=test;Address
Form Submission/a/p. When the usr click on the link the second form show
up. after the complete the form they click the submit button and insert
supposed to occur . So in my insert I ma trying to insert url variable that i
passed with the link but the url value does not get inserted
cfparam name=form.address1 default=
cfparam name=form.address2 default=
cfparam name=form.city default=
cfparam name=form.state default=
cfparam name=form.zip default=
cfparam name=form.hidName default=
cfif isDefined(form.btnsubmit) and isDefined(url.name)
cfset name=#url.name#
cftry
cfquery name=qryInsert datasource=cfelsunrise dbtype=ODBC
insert into address values ('#name#','#form.address1#', '#form.address2#',
'#form.city#', '#form.state#', '#form.zip#')
/cfquery
cfcatch type=database
p Apologies, an error has occurred. Please try again later./p
/cfcatch
/cftry
cflocation url=thankyou.cfm addtoken=no
/cfif
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titleAddress Form/title
/head
body
fieldset style=width:40%; margin:400px; background-color:#99FF00
legendAddress Form/legend
div align=center
form action=form.cfm method=post name=formTest
label for=address1bPlease enter Address1:/b/label
input type=text name=address1 /br /
label for=address2bPlease enter your Address2:/b/label
input type=text name=address2 /br /
label for=citybPlease enter your City:/b/label
input type=text name=city /br /
label for=statebPlease enter your state:/b/label
input type=text name=state /br /
label for=zipbPlease enter your Zip Code:/b/label
input type=text name=zip /br /
input type=submit name=btnsubmit value=Submit /
/form
/div
/fieldset
/body
/html
~|
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:301214
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: inSERTurl variables into database using coldfusion
URL (get) variables are accessed via the URL scope. URL.foo As opposed to form [post] variables, which are accessed via the FORM scope. FORM.foo ~| 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:301215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: File download not working
I'd seen the content-description in a few examples figured I'd give it a try. I've also see the attachment formatted with colon and semi-colon as well as simply attachment=filename. I started with a semi-colon and no content-description with the same end. It is working under firefox, just not IE7. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 3:43 PM To: CF-Talk Subject: Re: File download not working Dave wrote: ...cannot download DownloadUserInfo.cfm...site is either unavailable or cannot be found cfset myFile = #fromdir# txtfiles.aes cfheader name=Content-Disposition value=attachment:filename=txtfiles.aes cfheader name=Content-Description value=User Info File cfcontent type=application/aes file=#myFile# Why do you need the Content-Description? It is not a header from RFC 2616. Your Content-Disposition has a colon instead of a semi-colon. I would add some error checking as well: cfset myFile = fromdir txtfiles.aes cfif FileExists(myFile) cfheader name=Content-Disposition value=attachment; filename=txtfiles.aes / cfcontent type=application/aes file=#myFile# / cfelse cfthrow message=File #myFile# not found / /cfif If that doesn't work use a packetsniffer to see what really gets send to the browser. Jochem ~| 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:301216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: inSERTurl variables into database using coldfusion
URL (get) variables are accessed via the URL scope. URL.foo As opposed to form [post] variables, which are accessed via the FORM scope. FORM.foo Ok. But how can i get it fix so it will pass the url by clicking on the link ~| 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:301217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: inSERTurl variables into database using coldfusion
If you mean by clicking on the submit button, then the variable will have to be in a hidden field as as FORM variable, OR in the form action=url?name=xxx as a URL variable. -Original Message- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 5:04 PM To: CF-Talk Subject: Re: inSERTurl variables into database using coldfusion URL (get) variables are accessed via the URL scope. URL.foo As opposed to form [post] variables, which are accessed via the FORM scope. FORM.foo Ok. But how can i get it fix so it will pass the url by clicking on the link ~| 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:301218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Hostmysite down?
All my sites seem to be down and so does their website and phone support. Anyone know what's going on? Russ ~| 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:301219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hostmysite down?
All my sites seem to be down and so does their website and phone support. Anyone know what's going on? Russ One of our Datacenters (DC2) is experiencing an outage, and has been for the last 10 minutes or so. The phones are jammed (and in some cases going to BUSY, depending on the line you call) from the traffic. Unfortunately I don't have a cause or ETA as of yet, but I'll post it here ASAP. Jamie Price Account Executive HostMySite.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hostmysite down?
Thanks Jaimie, we came back up a little while ago. Any idea of what the problem was? Russ -Original Message- From: Jamie Price [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 6:48 PM To: CF-Talk Subject: Re: Hostmysite down? All my sites seem to be down and so does their website and phone support. Anyone know what's going on? Russ One of our Datacenters (DC2) is experiencing an outage, and has been for the last 10 minutes or so. The phones are jammed (and in some cases going to BUSY, depending on the line you call) from the traffic. Unfortunately I don't have a cause or ETA as of yet, but I'll post it here ASAP. Jamie Price Account Executive HostMySite.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hostmysite down?
The problem has been diagnosed and for the most part resolved. The main core switch there had a corruption in it's configuration and rebooted, but due to the corruption issue we could not automatically fail over to the hot spare. This was remedied by manually failing over. The total downtime measured for 28 minutes or so, and tonight we will be doing emergency maintainence to resolve the confug issue that prevented the automatic failover. If your site or server(s) were affected by the outage please contact [EMAIL PROTECTED] and a credit of 5% of your monthly fees. Please accept our deepest apologies for the inconvenience, and know that we are working hard to prevent this type of outage from occuring in the future. ~| 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:301222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File download not working
Did you recently turn off caching in IE, or do you prevent caching in the page higher up (with no-cache headers etc)? On Fri, Mar 14, 2008 at 6:01 AM, Dave [EMAIL PROTECTED] wrote: I'd seen the content-description in a few examples figured I'd give it a try. I've also see the attachment formatted with colon and semi-colon as well as simply attachment=filename. I started with a semi-colon and no content-description with the same end. It is working under firefox, just not IE7. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmail to hotmail
Hi all, any emails I send to a hotmail account through cfmail just seem to disappear into cyber-heaven. They're not going to a spam folder and my logs say that the email was sent successfull but in the hotmail inbox they are not. Anyone experience this? Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT - 404 error for files that exist...
This is sorta off-topic, but the folks here are smarter than some of the other lists - heh. It *is* a Coldfusion site, so it's not completely off-topic. For this month, a particular site has generated an amazingly large number of HTTP 404 Document Not Found errors. 10,621 this month to date, to be exact. Looking at the individual errors in the log files, almost every single file shown as generating the 404 *DOES EXIST*. You can browse right to them. Most of the 404s are image files - that *do* exist. I can browse right to them. Most of the 404 images are being called by a handful of specific referrer pages. I can go to those specific pages, they load fine, no errors, no missing files, no nothing. It's all there just like it was last month, the month before, and six months before that. Nothing has recently changed on the site. I'm totally stumped. Any ideas as to what the heck might be going on here? ~| 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:301225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail to hotmail
Add yahoo to the mysterious dissappearing trick too. Incidentally, gmail and pop3 accounts having no problems and I can CC another address :O Dominic On 13/03/2008, Dominic Watson [EMAIL PROTECTED] wrote: Hi all, any emails I send to a hotmail account through cfmail just seem to disappear into cyber-heaven. They're not going to a spam folder and my logs say that the email was sent successfull but in the hotmail inbox they are not. Anyone experience this? Dominic -- Blog it up: http://fusion.dominicwatson.co.uk -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail to hotmail
Make sure you have a ptr record setup for your webserver so that on dns checks yahoo and msn know your webserver is allowed to send mail from your domain. This site can assist in getting spf txt records setup for ya http://www.openspf.org/ On Thu, Mar 13, 2008 at 7:51 PM, Dominic Watson [EMAIL PROTECTED] wrote: Add yahoo to the mysterious dissappearing trick too. Incidentally, gmail and pop3 accounts having no problems and I can CC another address :O Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLDAP finds cn but can't find password or certain attributes
FIXED It required userPrincipalName (retrieved from the first CFLDAP query using the cn as the username) for the username on the second query. Wow - what a nightmare. But my app works and the client is happy, so all's well that ends well. Thank you all very very much - I wouldn't have made it thru without your support. David Or use the userPrincipalName of [EMAIL PROTECTED] I would suggest that each of you create an object dumper page that outputs all of the Active Directory variables for users. Then, compare the following attributes: cn distinguishedName name sAMAccountName userPrincipalName In our directory, we ensure that all of these values are consistent. In other words, for my user: cn = md40 distinguishedName = CN=md40,OU= name = md40 sAMAccountName = md40 userPrincipalName = [EMAIL PROTECTED] This consistency is very helpful, but may not be possible in your installation. I spend several days manually renaming accounts so that they matched our current style of usernames. It was time well spent. m!ke attributes OK, I got it to work. It was the user name. It is wierd. My login account is nstein, but cn is Nick Stein, so I have to use the latter in my CFLDAP. Here is the code that works: cfldap action=QUERY name=GetUserInfo attributes=givenName,sn,cn,name,dn start=DC=codagenomics,DC=net scope=subtree filter=((objectClass=user)(objectCategory=Person)(cn=Nick Stein)) server=192.168.xxx.xxx username=Nick Stein password=Wolfst93 cfdump expand=yes var=#GetUserInfo# / and it dumps 1 record. If I remove the (cn=Nick Stein), it dumps all the records for the user category. this thread... http://forum.java.sun.com/thread.jspa?messageID=4227692 mentioned the fact that a 525 error is user not found. That got me on the trail of checking the cn value, which I assumed (and we all know what that does) it was the same as my login ID. Nick Stein ~| 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:301228 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Handling multiple selection
Hi there I am developing a form for an organisation for their HR section to report on superannuation contributions etc. HR want to be able to select 1 or more staff members to report on at any one time. I have a list/menu in the form where a user can select 1 or more names to report on. After a user fills in the form I pass them to a confirmation screen to allow them to either proceed or return to the form to make amendments. If a user selects only one prson everything works fine when displaying the names. If 2 or more people are selected the names are not displayed. From the selection form I am passing over multiple empids in the format, 3173B704-19-02-08,E6A2E4D1-05-02-08 (just shown are 2 empids. Now in the confirmation screen I have a query SELECT * FROM tbl_employees WHERE empid = '#form.empid#' How do I handle this - I am guessing I will have to do an unstring or something Thanks in advance. ~| 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:301229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Handling multiple selection
WHERE empid IN (cfqueryparam list=yes value=#form.empid# cfsqltype=cf_sql_varchar) hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Toby King wrote: Hi there I am developing a form for an organisation for their HR section to report on superannuation contributions etc. HR want to be able to select 1 or more staff members to report on at any one time. I have a list/menu in the form where a user can select 1 or more names to report on. After a user fills in the form I pass them to a confirmation screen to allow them to either proceed or return to the form to make amendments. If a user selects only one prson everything works fine when displaying the names. If 2 or more people are selected the names are not displayed. From the selection form I am passing over multiple empids in the format, 3173B704-19-02-08,E6A2E4D1-05-02-08 (just shown are 2 empids. Now in the confirmation screen I have a query SELECT * FROM tbl_employees WHERE empid = '#form.empid#' How do I handle this - I am guessing I will have to do an unstring or something Thanks in advance. ~| 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:301230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling multiple selection
Hi Azadi That works but if a user selects 2 employees, it is only handling the first id. Thanks On Fri, Mar 14, 2008 at 4:19 PM, Azadi Saryev [EMAIL PROTECTED] wrote: WHERE empid IN (cfqueryparam list=yes value=#form.empid# cfsqltype=cf_sql_varchar) hth Azadi Saryev Sabai-dee.com http://sabai-dee.com/ http://www.sabai-dee.com/ Toby King wrote: Hi there I am developing a form for an organisation for their HR section to report on superannuation contributions etc. HR want to be able to select 1 or more staff members to report on at any one time. I have a list/menu in the form where a user can select 1 or more names to report on. After a user fills in the form I pass them to a confirmation screen to allow them to either proceed or return to the form to make amendments. If a user selects only one prson everything works fine when displaying the names. If 2 or more people are selected the names are not displayed. From the selection form I am passing over multiple empids in the format, 3173B704-19-02-08,E6A2E4D1-05-02-08 (just shown are 2 empids. Now in the confirmation screen I have a query SELECT * FROM tbl_employees WHERE empid = '#form.empid#' How do I handle this - I am guessing I will have to do an unstring or something Thanks in advance. ~| 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:301231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Handling multiple selection
what do you mean by 'handling'? are you referring to the form's action page? multi-select list passes a coma-delimited list of selected items' values to the action page. you may have to adjust your action page code to loop over this list and perform necessary actions... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Peter Tanswell wrote: Hi Azadi That works but if a user selects 2 employees, it is only handling the first id. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion Remote Developer
LOL! Brilliant! : -Original Message- : From: Steve Brownlee : : Does your family own the town you live in?? : : -Original Message- : From: Brian Thornton : : -_-_-_-_-_-_-_-_-_-_-_- : Brian Thornton : 871 Thornton Parkway, Suite #176 : Thornton, CO 80229 : cell: 702-787-7913 : fax: 303-457-4879 : -_-_-_-_-_-_-_-_-_-_-_-_-_-_ ~| 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-Jobs-Talk/message.cfm/messageid:3688 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Cold Fusion Remote Developer
Heh heh. well, if Brian is a son or grandson of the then-Mayor of CO, Dan Thornton, when the original community was developed in the 50's, then MAYBE! On Thu, Mar 13, 2008 at 11:51 AM, Erika L. Walker [EMAIL PROTECTED] wrote: LOL! Brilliant! : -Original Message- : From: Steve Brownlee : : Does your family own the town you live in?? : : -Original Message- : From: Brian Thornton : : -_-_-_-_-_-_-_-_-_-_-_- : Brian Thornton : 871 Thornton Parkway, Suite #176 : Thornton, CO 80229 : cell: 702-787-7913 : fax: 303-457-4879 : -_-_-_-_-_-_-_-_-_-_-_-_-_-_ ~| 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-Jobs-Talk/message.cfm/messageid:3689 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
COLDFUSION DEVELOPER CONTRACT - CHICAGO
Looking for a ColdFusion Developer to work a 3-7 day project in downtown Chicago. Our client needs someone to come in and clean up and upgrade there DIMIS (Data Integration Management Information System). This system was created in MySQL and the main programming language is ColdFusion. Candidate must have excellent written and verbal communication skills, along with strong leadership skills. The candidate must be solutions oriented, enjoy working with new technology, be a self-motivated learner, and pay meticulous attention to detail. Responsibilities: ⢠Data Pulls from MySQL and SQL Server 2000 Databases ⢠Maintaining DIMIS systems ⢠Making changes and adaptations to the System ⢠Data Mining and cleansing MySQL Experience is a must. Please respond back with a MS Word copy of your resume if you are interested to [EMAIL PROTECTED] The client will interview on 3/14 and start Monday, 3/17. ~| 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-Jobs-Talk/message.cfm/messageid:3690 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
