Use J2EE datasource to insert Clob on MX6,7
Dear all: We are testing to use CF's J2EE Datasource to insert Clob to Oracle 9i database. I have checked CF's datasource config,and enable long text retrieval support in data source config. But return to spread an IO Execption: End of TNS data channel Environment config as follows CF version:mx6.1updater,mx7.0.2 J2EE server:Weblogic8.1u6 Oracle driver:9.2.0.8 Any suggestion will be appreciated ^^ -- View this message in context: http://www.nabble.com/Use-J2EE-datasource-to-insert-Clob--on-MX6%2C7-tp20261109p20261109.html Sent from the Cold Fusion - Technical mailing list archive at Nabble.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: detecting mobiles
On Thursday 30 Oct 2008, Dawson, Michael wrote: One solution is to check the HTTP_ACCEPT variable for text/vnd.wap.wml. I'd want to check that appears or not if it's gone through Google's 'make it look nice on a mobile' gateway. For instance. The best thing to do might be to go read alistapart for a couple of days and write your site to degrade gracefully. -- Tom Chiverton Helping to administratively e-enable high-yield enterprise granular high-end channels 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Use J2EE datasource to insert Clob on MX6,7
Dear Tom: Tks for ur reply.I will check oracle log later. I had tried to use mx8(8,0,1,195765) with oracle 9i and 10g driver ,and CF throws the same execption as follow Error casting an object of type weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed. weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection Maybe this is a weblogic's problem ? Tom Chiverton-2 wrote: On Friday 31 Oct 2008, anguss wrote: But return to spread an IO Execption: End of TNS data channel Have you checked the Oracle logs ? -- Tom Chiverton Helping to collaboratively customize advanced frictionless best-of-breed exceptional channels 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use J2EE datasource to insert Clob on MX6,7
On Friday 31 Oct 2008, anguss wrote: But return to spread an IO Execption: End of TNS data channel Have you checked the Oracle logs ? -- Tom Chiverton Helping to collaboratively customize advanced frictionless best-of-breed exceptional channels 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 Dev Environment
Hi - having been developing in CF5/CF Studio for some years, finally moving to CF8. What would you recommend for development environment for Windows? I'm particularly interested in line debug capability. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Dev Environment
CFEclipse (http://cfeclipse.org/) is really solid, but frankly I still use HomeSite+ a lot of the time. I just really like its text search across files and folders, and I really can't live without my custom keyboard-linked snippets. (CFEclipse may support keying custom snippets to keyboard shortcuts now, but it didn't used to.) HTH ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Dev Environment
CFE has had the ability to add snippets for quite some time. Regardless of what IDE you decide on, I am fairly certian that in order to use the line debugger, you will need Eclipse. On Fri, Oct 31, 2008 at 8:34 AM, Jason Fisher [EMAIL PROTECTED] wrote: CFEclipse (http://cfeclipse.org/) is really solid, but frankly I still use HomeSite+ a lot of the time. I just really like its text search across files and folders, and I really can't live without my custom keyboard-linked snippets. (CFEclipse may support keying custom snippets to keyboard shortcuts now, but it didn't used to.) HTH ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Dev Environment
Jason Fisher wrote: CFEclipse may support keying custom snippets to keyboard shortcuts now, but it didn't used to. It does. It also allows for some pretty dynamic searching. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfexchange getting tomorrow's schedule from Calendar?
I haven't built one, but it would be easy. You only need: cfexchangeconnection cfexchangecalendar cfexchangefilter in addition to things like dateAdd(), cfoutput, cfmail, etc. Mike -Original Message- From: Dan LeGate [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2008 8:16 PM To: cf-talk Subject: cfexchange getting tomorrow's schedule from Calendar? Has anyone successfully built an app/util that will grab a particular day's schedule from an Exchange Calendar? Would love to set something up where I can email myself tomorrow's schedule from my Outlook Calendar. Anyone doing anything list this? Thanks! keywords: cfexchangecalendar, cfexchangemail, cfexchangeconnection, cfexchangetask, cfexchangecontact, cfexchangefilter ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314647 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 issue - header / footer cutting off content
Hi everyone, FYI here is the answer: You have to set your page size, top and bottom margins correctly? It's part of the CFDOCUMENT tag. Cheers Matthew ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Dev Environment
I use a combo of CFEclipse, Dreamweaver, and Notepad ++. CFEclipse for CFC development. Dreamweaver for UI, notepad for quick and dirty code fixing. Been using the cs4 beta, and quite frankly the code hinting / completion aspects of Dreamweaver is way better than CFEclipse. Also the new Javascript features and related files feature of the new DW is a real time saver! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Blowin our own horn: New CF Site
We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314650 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Seriously bogs down my computer when looking at it. Your flash implies that it's a menu, but I guess it isn't. Several links don't seem to do anything. IMHO, it needs allot of work still. Robert Harrison wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Blowin our own horn: New CF Site
and one more thing.. I'm on broadband... Have you tested this for dialup speeds? I seriously worry about trying to download this via modem (Yes, they are still in use). :) Robert Harrison wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Regular Expression help
Please help, banging my head against a wall and my deadline is up... I need to search a text filed of html formatted text to see if the user enter in bad words I have it all set to go but the regexp is giving me trouble. I am looping over the list of badwords and checking the variable skills. cfif REFindnocase(([\]+#badword#+[\]),skills) The issue is that if the word kiss is a bad word I need to be able to flag it if it is wrapped by html tags i.e. brkiss the pony/br and I only want kiss not kissing. Please help with the regexp to get this done. Thank you 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Dev Environment
+1 for CFEclipse. Also DW is good. DW CS4 absolutely ROCKS at GIU dev. The Live code view is amazing. It is like View Source meets FireBug in real time. It even swaps out the CSS classes/Attributes in the HTML as you mouse over items. I was stunned when I first saw it. It also has some ColdBug style debugging. I donno if it has line debugging. You may need Eclipse for that. ~G~ On Fri, Oct 31, 2008 at 8:34 AM, Jason Fisher [EMAIL PROTECTED] wrote: CFEclipse (http://cfeclipse.org/) is really solid, but frankly I still use HomeSite+ a lot of the time. I just really like its text search across files and folders, and I really can't live without my custom keyboard-linked snippets. (CFEclipse may support keying custom snippets to keyboard shortcuts now, but it didn't used to.) HTH ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
grammar error: *We're out to knock your socks off take your breath away.*With research-driven marketing strategies. Mind-blowing creative. And rock-solid results. agency.cfm Shouldn't that be Mind-blowing creativity? A couple of comments: I had to dig in a couple of pages before I understood what austin-williams does, it's not clear from the outset. While that front splash is visually cool, it doesn't convey what the company does. A personal peeve, I hate the Times font or anything that looks like it, I'd change the font on the left side navigation. BTW: I was really expecting it to be an accordion type of navigation. overall, it looks good, but could get the message across quicker and more urgently. Robert Harrison wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression help
I think you want something like this: cfif REFindnocase(([\s\]#badword#[\s\]),skills) You may want to expand it to non-alphanumeric wrappers, though, to catch punctuation: he gave her a kiss. cfif REFindnocase(([\W]#badword#[\W]),skills) which is the same as cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),skills) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blowin our own horn: New CF Site
On a T1, waiting for it to load crashed my IE browser. Tiffany Trott Application Developer American Residential Communities Phone: 303-383-7532 Efax: 303-749-3005 E-mail: [EMAIL PROTECTED] -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 8:07 AM To: cf-talk Subject: Blowin our own horn: New CF Site We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Blowin our own horn: New CF Site
Well done. It is is a bit stutter-y though on a 1.5 year old Dell Optiplex corporate desk top. I sent to to a GUI dev buddy. On Fri, Oct 31, 2008 at 10:07 AM, Robert Harrison [EMAIL PROTECTED] wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Scott Stewart wrote: I had to dig in a couple of pages before I understood what austin-williams does, it's not clear from the outset. While that front splash is visually cool, it doesn't convey what the company does. With the limited time I was able to spend there (I exited out of frustration at the speed my computer was able to handle the page at), I thought there sold pictures. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blowin our own horn: New CF Site
Not bad. I think the nav needs some serious rethinking. Vertical text? Sideways? For the main navigation? Not a good choice IMO. From a font perspective, the choices made don't seem to jive with the logo. You're using a serif font for your primary navigation, a sans-serif font for the sub-nav (our mission, latest news, etc.) and an HTML font for your copyright fonts. The navigation feels like it should behave like an accordion, but merely acts as mouse-overs. A previous poster indicated that he couldn't find out what Austin-Williams does. That's easy enough to find using the Agency Profile button. The sub-nav offers clickable areas, but has no common indicator for that, IE the hand cursor. I might suggest changing the cursor for those items since you can click on them to perform an action. Missing image on the following page: http://www.austin-williams.com/services-strategic-overview.cfm Also, in this section, you've got navigation THREE levels deep: Primary Nav Subnav (strategic/creative) Sub-sub-nav (overview/brand...). This is a big mistake, and one that will def confuse users. Overall, I'd say that the design of the site is well done, but the layout and navigation choices were poor and not well thought through. andy -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 9:07 AM To: cf-talk Subject: Blowin our own horn: New CF Site We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Blowin our own horn: New CF Site
On a corporate workstation, shared bandwidth, loaded really pretty well for me, and like the design. The humanizing touches are clever, the dog delivering the paper for News, etc. It was a bit odd to jump out of the layout for Portfolio, but other than that I found it to be a better use of Flash than I'm used to. Love that each page really is a separate (CFM) page: means I could send a link to someone that would be directly to the content I wanted to share. Nice to not make your users have these conversations: Saw some cool stuff, go to http://blah.com, scroll the nav down, link over 3 times, click the Photos link, drill down to Subsection Beta, and now see that cool thing? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blowin our own horn: New CF Site
It's really cool and it has a nice wow factor. I like the shadow people and the way they seem to be scoping out the pics on the wall... Very innovative. On the other hand, I'm not sure what you are selling. My first thought was that it was photography or art. Even when I clicked on Our mission it's not apparent it's an ad agency (We're out to knock your socks offI thought of laundry nazis). Only when I finally clicked on profile or services did I finally figure it out. Probably most folks get it quicker than I do. I am one of those people on the web that gloss over fancy pants stuff and look for readable, useful stuff that is not marketing (not pitchy)... So your site mystifies me a little :) Finally, portfolio pages like this drive me crazy. A bunch of random icons with no discernable way of figuring out what anything is. I'm forced to hover and click. Frankly I would prefer a list of clients in text with descriptions and links. The drop downs for company and industry are nice and useful But again with the icons. What are you hiding? Am I the only one who thinks this is (in the words of Jack Sparrow) maddeningly unhelpful? On the other hand I would prefer a poke in the eye to spending more than 10 minutes with any sales person. When my insurance man calls I usually hide in the closet... So I'm probably not the best judge of your site eh? Anyway, that's my take - stunning visuals yes... Useful content not so much. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 9:07 AM To: cf-talk Subject: Blowin our own horn: New CF Site We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: detecting mobiles
Alistapart.com is nice! I never knew about it. Thanks Tom! -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 5:44 AM To: cf-talk Subject: Re: detecting mobiles On Thursday 30 Oct 2008, Dawson, Michael wrote: One solution is to check the HTTP_ACCEPT variable for text/vnd.wap.wml. I'd want to check that appears or not if it's gone through Google's 'make it look nice on a mobile' gateway. For instance. The best thing to do might be to go read alistapart for a couple of days and write your site to degrade gracefully. -- Tom Chiverton Helping to administratively e-enable high-yield enterprise granular high- end channels 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blowin our own horn: New CF Site
Well, the chicks look pretty hot, but I noticed they keep doing the same thing... Walk and point... walk and point... The girl on the right appears to be walking from one X to another X where she is supposed to stop and turn. You might want to record a couple more movements so they are not so repetitious. Actually, it loaded pretty fast on my PC. I think it looks nice, but I agree that the nav appeared to be an accordian, but I was misled. Not sure that I liked having to wait for the Login Security Failed audio when I tried to access your extranet site. I must say that it is pleasing to my eyes. It's crisp and clean and the concept of the three people walking through the gallery is slick. Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Verity problems
Do you update your indexes regularly and have you been doing so for some time? If so, this thread on the Adobe forums might be worth looking at: http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=3threadid=1279952 Julian Halliwell I have three separate indexes on my server each indexing a different table in our database. For some reason the indexes keep getting messed up on a near nightly basis. One index just refuses to work giving back an error There was a problem executing the cfSearch tag with the following collections. Collection (status code): products (-1706) another one shows 48 items in the table which is what is there but when you search it show that it searched 708 items which is the amount in another table. It does also retrieve the data that it is supposed to, but with allot of bad links as well. IS there a cache issue with verity and CF8 or any known bugs. I did not have this problem until we had more than one index. Thanks for any help you can give me. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression help
Not sure what I am doing wrong but this is not working. I have the string kissess are goodbrkissbrthe girlfriend Kiss is a badword, and this regexp is not picking it up. Please advise and thanks for your help. Matt I think you want something like this: cfif REFindnocase(([\s\]#badword#[\s\]),skills) You may want to expand it to non-alphanumeric wrappers, though, to catch punctuation: he gave her a kiss. cfif REFindnocase(([\W]#badword#[\W]),skills) which is the same as cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),skills) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression help
Hm, that should work, certainly. Did you try that 3rd option? cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),skills) That should find any use of the word 'kiss' when it's surrounded by any non-alpha characters. Sadly I don't have access to my CF environment right at the moment, so I can't test :( Not sure what I am doing wrong but this is not working. I have the string kissess are goodbrkissbrthe girlfriend Kiss is a badword, and this regexp is not picking it up. Please advise and thanks for your help. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression help
Forgot about Ryan Swanson's slick little tool. It certainly validates and picks up the middle 'kiss' in his validator, using either '\W' or '^a-zA-Z0-9_' as the filter: http://ryanswanson.com/regexp/#start ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
xml data referencing
I'm using another person's library (feedToQuery) to work with my xml document and make it into a query. I'm having trouble referencing some of the data. Most of it is done through xmlText. But this data is in the entries scheme. Here's the entry and the code that I use to work with it. I'm trying to get the category information out of the category scheme. Oh, I'd also like to know if there's a way of finding out the data in however many category entries there are. DATA: entry id tag:blogger.com,1999:blog-1550840680584738668.post-851696689458182282 /id published 2008-10-29T09:49:00.002-04:00 /published updated 2008-10-29T09:56:21.122-04:00 /updated category scheme='http://www.blogger.com/atom/ns#' term='What are you doing?'/ category scheme='http://www.blogger.com/atom/ns#' term='Health in the News'/ title type='text' Family Election Guide with Dr. Elaine Anderson /title /entry Here's the part of the code that I'm using to currently reference xml text (and put it into a created db) which isn't working to grab the data out of category scheme: if (structKeyExists(parsed[feed].XMLChildren[index], category)) querySetCell(retQuery, category, parsed[feed].XMLChildren[index].category.XMLText, rows); If there's multiple categories, I'd like it to combine them with a delimiter and put them into one db cell. thanks in advance about whatever learning I get. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Holy CPU usage Batman. I'm sitting on a fairly new Dell Optiplex at work with AMD 64X2 Dual Core 2.2 Ghz with 3 Gb of memory. With the home page running FireFox is using 50-60% of my CPUs. I just made the mistake of opening that site in IE at the same time and watched my CPU's MAX out. Do better performance in Opera either. And the flash does nothing functional. So the only Coldfusion is a basic content managment system? Do you viewers a favor and cut back on the Flash. Jason posted It was a bit odd to jump out of the layout for Portfolio I agree, at first I thought I lost the nav completly. Wil Genovese On Fri, Oct 31, 2008 at 9:52 AM, Dawson, Michael [EMAIL PROTECTED]wrote: Well, the chicks look pretty hot, but I noticed they keep doing the same thing... Walk and point... walk and point... The girl on the right appears to be walking from one X to another X where she is supposed to stop and turn. You might want to record a couple more movements so they are not so repetitious. Actually, it loaded pretty fast on my PC. I think it looks nice, but I agree that the nav appeared to be an accordian, but I was misled. Not sure that I liked having to wait for the Login Security Failed audio when I tried to access your extranet site. I must say that it is pleasing to my eyes. It's crisp and clean and the concept of the three people walking through the gallery is slick. Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Very cool Robert. I didn't have any performance problems at all on Firefox. What kind of stuff did you use CF for on this project? Steve Nelson On Fri, Oct 31, 2008 at 10:07 AM, Robert Harrison [EMAIL PROTECTED] wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blowin our own horn: New CF Site
-Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 10:07 AM To: cf-talk Subject: Blowin our own horn: New CF Site We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com It seems to load quickly for me (Comcast Cable). But... +) I had a lot of trouble with the sideways menu text. It's small (too small to support a cosmetic orientation) and heavily anti-aliased (making it fuzzy and hard to read since text antialiasing is optimized for horizontal text). The very tight kerning doesn't help. +) Like others I also tried (in vain) to click on the items in the Flash movie. That's a LOT of real-estate to consume for a non-functional element (especially one that doesn't actually explain anything). +) A lot of the interactivity is frustrating. When I click on Our Mission I get the mission... then when I move the mouse out of the way to READ Our Mission it disappears (even tho' you've also included a specific control element as well). +) You're navigation is all over the map... the main navigation palette is spacious and large (even if the text is small and cramped) while on inner pages (like the brand studies page) this is replaced with a crowded, tiny palette (with even harder to read gray-on-gray text). +) I think most importantly: after watching the Flash Intro longer than I would normally watch ANY Flash into in the wild I still don't know what the site is for. I asked my lovely bride as well and she immediately knew what it was: a site for an art gallery. Oh, and yeah: we're pricks. But you did pop your head up into our sights. ;^) Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression help
Figured out the issue, this works great. Thank you, thank you, thank you ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Blowin our own horn: New CF Site
Site runs fine for me speed, load, and %cpu-wise. ff3 I agree with most of the criticisms (except the creative, which reads fine to me), but those are NITS, the overall site rocks. Well done. A couple of tweaks will smooth out those rough edges, but I like it. On Fri, Oct 31, 2008 at 10:07 AM, Robert Harrison [EMAIL PROTECTED] wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
one thing that immediately annoyed me was my desire to click on the things that the shadow people were pointing at, and my inability to do that. :) -- Jim Rising Serial Entrepreneur Cold Fusion Developer Concentration is the key to profits. Greater profits require that you concentrate your efforts on the smallest number of activities that will produce the largest amount of revenue. -Peter Drucker On Fri, Oct 31, 2008 at 9:07 AM, Robert Harrison [EMAIL PROTECTED] wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com We've got some cool stuff in there. Enjoy! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Robert you'll be wishing you hadn't stuck your head up now g But I think it looks definitely like an advertising agency site. I was looking at you team bios page, out of sheer noseyparker-ness, and there's no way to find a particular person. For example suppose I'm a potential client and i'd been talking to you on the phone, so I thought i'd check up to see what your background is. To find Robert Harrison in the bios, i have to open all the bios at random or systematically open them one by one until i find yours.I suggest you put the name as alt text on the images so it comes up as a tooltip, or perhaps a line somewhere with the person's name and title that changes with the mouseover or make the icons relate to their job function or something. Just some way to find the person i might be looking for. After all, if i came to your office as a prospective client, I wouldnt just walk about your office at random, stopping people saying 'who are you, what's your background, what do you do here? I can see that the icon graphics you use are related to their personal interests, but to be really honest, if i'm looking for an ad agency, I'm not going to be saying to myself i want to use an agency where the account exec likes ice skating.Unless you have pretty dumbass clients.i'd want to have an account exec who knows advertising and likes the business, and with some luck has some understanding of MY business, and to hell with their personal interests. I also see that the subnav at the bottom leads to a more easy-to-follow subdivision, reducing the number of icons to a smaller group, with the names listed on the right, which is better, but it's not obvious when you arrive at the bios page, that's what that area does. I like that you figure your staff personal interests are important for clients to relate to, but if your site is intended to provide prospective clients the answer to the question should i use these guys as my ad agency? this section isnt really pulling its weight. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Sat, Nov 1, 2008 at 3:19 AM, Jim Davis [EMAIL PROTECTED] wrote: -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 10:07 AM To: cf-talk Subject: Blowin our own horn: New CF Site We've just launched our own new site. It's fully CF driven from MS SQL DB. If you want to see it, it's at: http://www.austin-williams.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blowin our own horn: New CF Site
Thanks for all the comments. You all actually gave me some backup for some of the issues I've been trying to get addressed. I think the site is cool, but I am concerned with the CPU burden from the HP flash and the fact that the flash is not clickable on the images. We are going to address both of those issues. I also don't disagree with some comments on the creative and navigational issues as well, but that's a political and an ego thing, so that goes how it goes. I'm sure you all now the 'design by committee' scenario. Please do not hesitate to let me know of any problems though. This is definitely not your standard site. It takes some risks. We will be fine-tuning over the next few weeks. Thanks All, Robert Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Redirecting
Hi All, Have a site whose DNS is not controlled by us. They (the DNS controllers), have setup a URL to redirect at the DNS level (so they tell me), www.abc.com/french to come to our site via an IP address. When we get this visitor, they need to get to our FRENCH page. Our standard default page is the english one. I've looked through the CGI scope, and there is ZERO indication in that scope that they are coming from www.abc.com/french (our HTTP referrer is empty string). Is there anyway WE can get this to work, or is it on their end at the DNS. (Its a government client, so any changes we request take ~ 1 month!). We are on CF 7.0, IIS 6.0. Many thanks, Matts ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
LDAP Query Performance question
I have a query of a SQL table that returns to me a bunch of usernames. From that, I need to query some information out of Active Directory for each user. Right now I have it looping over each row in the result from the SQL query and doing a separate LDAP query to the AD. This just doesn't seem like the best way to do things. Does anyone know if there's a syntax within LDAP querying of the AD to do something like an IN keyword where I could give the whole list of usernames I want to query and get a single result set back from one query instead of doing individual queries? There's no commonality amongst the user accounts in the AD except for the fact that their usernames are all in this external SQL table. Let me know if you have any ideas. Or maybe the single LDAP queries aren't as intensive as bad as what I'm thinking. I just know I always try to avoid multiple queries in SQL whenever possible. Here's the syntax I'm using now when querying the AD: cfldap action=QUERY name=GetEmployeeIDByUsername attributes=cn,displayName,givenName,extensionAttribute1 start=dc=domain,dc=com scope=subtree filter=((objectCategory=Person)(cn=#myQuery.username#)) server=domaincontroller.mydomain.com username=#ADUsername# password=#ADPassword# Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Redirecting
You could use something like CGI.REMOTE_ADDR or CGI.REMOTE_HOST, but these may or may not work, if you are behind a load-balancer, and they are not passing the x-remote-addr header back to you, or if the end user is coming through a proxy... On Fri, Oct 31, 2008 at 11:19 AM, Developer MediaDoc [EMAIL PROTECTED] wrote: Hi All, Have a site whose DNS is not controlled by us. They (the DNS controllers), have setup a URL to redirect at the DNS level (so they tell me), www.abc.com/french to come to our site via an IP address. When we get this visitor, they need to get to our FRENCH page. Our standard default page is the english one. I've looked through the CGI scope, and there is ZERO indication in that scope that they are coming from www.abc.com/french (our HTTP referrer is empty string). Is there anyway WE can get this to work, or is it on their end at the DNS. (Its a government client, so any changes we request take ~ 1 month!). We are on CF 7.0, IIS 6.0. Many thanks, Matts ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LDAP Query Performance question
Here is a link to information about optimizing and profiling ldap queries to AD: http://robbieallen.com/downloads/RAllen_LDAP_Searching.ppt On Fri, Oct 31, 2008 at 11:25 AM, Burns, John D [EMAIL PROTECTED] wrote: I have a query of a SQL table that returns to me a bunch of usernames. From that, I need to query some information out of Active Directory for each user. Right now I have it looping over each row in the result from the SQL query and doing a separate LDAP query to the AD. This just doesn't seem like the best way to do things. Does anyone know if there's a syntax within LDAP querying of the AD to do something like an IN keyword where I could give the whole list of usernames I want to query and get a single result set back from one query instead of doing individual queries? There's no commonality amongst the user accounts in the AD except for the fact that their usernames are all in this external SQL table. Let me know if you have any ideas. Or maybe the single LDAP queries aren't as intensive as bad as what I'm thinking. I just know I always try to avoid multiple queries in SQL whenever possible. Here's the syntax I'm using now when querying the AD: cfldap action=QUERY name=GetEmployeeIDByUsername attributes=cn,displayName,givenName,extensionAttribute1 start=dc=domain,dc=com scope=subtree filter=((objectCategory=Person)(cn=#myQuery.username#)) server=domaincontroller.mydomain.com username=#ADUsername# password=#ADPassword# Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LDAP Query Performance question
On Friday 31 Oct 2008, Burns, John D wrote: I have a query of a SQL table that returns to me a bunch of usernames. From that, I need to query some information out of Active Directory for each user. Right now I have it looping over each row in the result from Firstly, how many is a bunch, how up-to-date does the result for each need to be,and how often is the AD data updated (and how) ? It maybe you can just cache the result, or have the new data for a person pushed to you. -- Tom Chiverton Helping to efficiently incentivize visionary intuitive six-generation environments 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Redirecting
They (the DNS controllers), have setup a URL to redirect at the DNS level (so they tell me), www.abc.com/french to come to our site via an IP address. When we get this visitor, they need to get to our FRENCH page. Our standard default page is the english one. The DNS entries *CANNOT* account for anything after the slash. DNS can only determine what to do with www.abc.com and abc.com, not the /french portion. That can only be handled on the webserver for abc.com: either through server redirects or through a script in the home directory or something, that website or webserver would have to read the CGI to get the script after the host name and forward to your server if the script part is /french. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: LDAP Query Performance question
It's just a nightly task but it may have 300-400 results each time it runs. I don't think it'll bring down the house or anything it just brought up the question to see if there was a more elegant way of doing it. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 12:51 PM To: cf-talk Subject: Re: LDAP Query Performance question On Friday 31 Oct 2008, Burns, John D wrote: I have a query of a SQL table that returns to me a bunch of usernames. From that, I need to query some information out of Active Directory for each user. Right now I have it looping over each row in the result from Firstly, how many is a bunch, how up-to-date does the result for each need to be,and how often is the AD data updated (and how) ? It maybe you can just cache the result, or have the new data for a person pushed to you. -- Tom Chiverton Helping to efficiently incentivize visionary intuitive six-generation environments 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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: xml data referencing
Hi Daniel You'll need to use XMLAttributes and it will return a structure. XMLChildren[index].category.XMLAttributes On Fri, Oct 31, 2008 at 8:06 AM, daniel kessler [EMAIL PROTECTED] wrote: I'm using another person's library (feedToQuery) to work with my xml document and make it into a query. I'm having trouble referencing some of the data. Most of it is done through xmlText. But this data is in the entries scheme. Here's the entry and the code that I use to work with it. I'm trying to get the category information out of the category scheme. Oh, I'd also like to know if there's a way of finding out the data in however many category entries there are. DATA: entry id tag:blogger.com,1999:blog-1550840680584738668.post-851696689458182282 /id published 2008-10-29T09:49:00.002-04:00 /published updated 2008-10-29T09:56:21.122-04:00 /updated category scheme='http://www.blogger.com/atom/ns#' term='What are you doing?'/ category scheme='http://www.blogger.com/atom/ns#' term='Health in the News'/ title type='text' Family Election Guide with Dr. Elaine Anderson /title /entry Here's the part of the code that I'm using to currently reference xml text (and put it into a created db) which isn't working to grab the data out of category scheme: if (structKeyExists(parsed[feed].XMLChildren[index], category)) querySetCell(retQuery, category, parsed[feed].XMLChildren[index].category.XMLText, rows); If there's multiple categories, I'd like it to combine them with a delimiter and put them into one db cell. thanks in advance about whatever learning I get. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression help
I just found an issue with this regexp cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),clean_skills) this works great if it is not the first word or only word in the string. what do I need to do to update the regexp to pick up the bad word it is the first last or only word in the string also. Thank you again for all of your help. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression help
Typo: cfif REFindnocase(((^|\W)#badword#(\W|$)),clean_skills) On Fri, Oct 31, 2008 at 1:09 PM, Sonny Savage [EMAIL PROTECTED] wrote: cfif REFindnocase(((^|\W)#badword#(\W|$),clean_skills) On Fri, Oct 31, 2008 at 1:04 PM, Matthew Friedman [EMAIL PROTECTED]wrote: I just found an issue with this regexp cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),clean_skills) this works great if it is not the first word or only word in the string. what do I need to do to update the regexp to pick up the bad word it is the first last or only word in the string also. Thank you again for all of your help. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression help
Good call. Try this, seems to work in initial testing: cfif REFindnocase(((^|[^a-zA-Z0-9_])#badword#([^a-zA-Z0-9_]|$)), clean_skills) I just found an issue with this regexp cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]), clean_skills) this works great if it is not the first word or only word in the string. what do I need to do to update the regexp to pick up the bad word it is the first last or only word in the string also. Thank you again for all of your help. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression help
cfif REFindnocase(((^|\W)#badword#(\W|$),clean_skills) On Fri, Oct 31, 2008 at 1:04 PM, Matthew Friedman [EMAIL PROTECTED] wrote: I just found an issue with this regexp cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),clean_skills) this works great if it is not the first word or only word in the string. what do I need to do to update the regexp to pick up the bad word it is the first last or only word in the string also. Thank you again for all of your help. Matt ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
How well is your site designed for disabled access? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Blowin our own horn: New CF Site
grammar error: *We're out to knock your socks off take your breath away.*With research-driven marketing strategies. Mind-blowing creative. And rock-solid results. agency.cfm Shouldn't that be Mind-blowing creativity? I think that's deliberate... I believe it's fairly common in marketing circles to use creative as a multiple-noun. Similar to saying talented people. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Scott Stewart wrote: I had to dig in a couple of pages before I understood what austin-williams does, it's not clear from the outset. While that front splash is visually cool, it doesn't convey what the company does. With the limited time I was able to spend there (I exited out of frustration at the speed my computer was able to handle the page at), I thought there sold pictures. I'm gonna miss having Fios when we have to leave... Had no performance issues on a fiber connection. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
Denny, I have started to work in JasperReports, can you shoot me an email at your convenience? I have some questions about the set up for CF and JR to work together nicely. Email is first letter first name and full last name at gmail (stupid spam bots). Cheers, Mike Greider JasperReports is built right into coldfusion. You can create a jasperreport JRXML file using iReport, and use createObject to run the report, etc. I don't do it any more because report generation takes such a toll on the server, and it's just waay better to have report stuff running on a separate server, pulling from a replication database. So now I use JasperServer, and it's KICK ASS! For anyone doing a lot of reporting, I'd recommend it. Simply the best! But if you're stuck with pure CF, and need to do those common reporting things that are just impossible with reportbuilder, then createObject and jasperrepoerts might be the way to go, because you can build the reports with iReport, which is a STELLAR report-builder (cross platform y todo). HIH, :Denny -- If an injury has to be done to a man it should be so severe that his vengeance need not be feared. Niccolo Machiavelli ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Blowin our own horn: New CF Site
Kudos to you for making a non-traditional 3 column layout like we're all accustomed to. I think some folks get upset when they don't get what they are expecting. Sure... I agree that placing navigation in places that are easy to find is important. However, ad agencies tend to be artsy... and 'artsy' is anything but cookie cutter. Like others have mentioned, I think the main navigation needs some tweaks. I'm 'ok' with the orientation of the next, but not the font (or color). I personally think you've got too many colors going on (grey, light blue, dark blue, orange bullets, red bullets, yellow bullets). I think a more consistent color palette would make the site look more professional. Opinions may vary. As others have mentioned, I dig the silhouettes. Creative idea. The page took a fair amount of time to load... I actually didn't wait for the main animation to finish loading before I went clicking around. Otherwise, it works okay. Why not let the news (news.cfm) stretch to the edge of the container? The scrollbar hanging 200 px off the right seems odd to me. I'd make those elements expand the width of the black area. I also agree with the comment about the bios. Names/titles would be handy. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blowin our own horn: SITE JUST KILLED!
This is unbelievable. We have a bunch of old sites done way before I ever got here. When we changed DNS for our site and a bunch of client sites started crashing. It seems the first web developer who was here and gone before I came, used functions, images, style sheets, etc. from our old web site on client sites. He didn't move the files... he just referenced our site with http requests. I started looking and I found that a bunch of our clients sites are just spidered all throughout our old site. I have to change DNS back to the old site (which has 5Gb of crap in it). This is probably one of the stupidest things I have ever seen, short of the idiot that named our root server ourdomain.com. UNBELEIVABLE! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: SITE JUST KILLED!
I guess he was taking 'reusing code' a bit too far .You must have been affecting your client sites a lot without realising it. Tweak your own site a little and have unforseen effects elsewhere without knowing it. FUN!! Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Sat, Nov 1, 2008 at 6:22 AM, Robert Harrison [EMAIL PROTECTED] wrote: This is unbelievable. We have a bunch of old sites done way before I ever got here. When we changed DNS for our site and a bunch of client sites started crashing. It seems the first web developer who was here and gone before I came, used functions, images, style sheets, etc. from our old web site on client sites. He didn't move the files... he just referenced our site with http requests. I started looking and I found that a bunch of our clients sites are just spidered all throughout our old site. I have to change DNS back to the old site (which has 5Gb of crap in it). This is probably one of the stupidest things I have ever seen, short of the idiot that named our root server ourdomain.com. UNBELEIVABLE! Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple instances of CF_TwoSelectsRelated on the same page
Doesn't the tag just go off the form field names within the page? I would think you could use multiple instances out of the box in the same page, what type of error is it throwing? On Fri, Oct 31, 2008 at 1:48 PM, Debi Lewis [EMAIL PROTECTED] wrote: Has anyone ever tried this? I found a link online to someone who had rewritten the tag to accommodate that, but the link was dead. Any ideas? I can't seem to figure it out! Thanks, Debi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: xml data referencing
Hi Daniel
You'll need to use XMLAttributes and it will return a structure.
XMLChildren[index].category.XMLAttributes
ah that worked nicely. It gave me a struct and I referenced 'term' to get my
data.
parsed[feed].XMLChildren[index].category.XMLAttributes.term
However, if there were two 'category' items, it only gave me the last one. I
figured out how to reference them with [n], but how do I know how many of them
there are? I'm supposing that I need to loop through them to get all the
'category' entries. If I try to reference more than what's there, I receive an
error.
Here is my attempt to deal with all that, but I receive an error:
for (ll = 1; ll LTE 25; ll=ll+1){
if
(isdefined(parsed[feed].XMLChildren[index].category[ll].XMLAttributes.term))
categories = categories 'some_data|';
}
if (structKeyExists(parsed[feed].XMLChildren[index], category))
querySetCell(retQuery, category, categories, rows);
Receives error: Element CATEGORY is undefined in a Java object of type class
coldfusion.xml.XmlNodeMap referenced as
any additional help would be greatly appreciated and thanks Nick for your help
getting me this far.
daniel
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314699
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple instances of CF_TwoSelectsRelated on the same page
Has anyone ever tried this? I found a link online to someone who had rewritten the tag to accommodate that, but the link was dead. Any ideas? I can't seem to figure it out! Thanks, Debi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: LDAP Query Performance question
First, do you have SQL Server 200x? If so, create a link to Active Directory and then you can join the two datasources just as you would join two tables. If not, retrieve all your AD accounts, using a single CFLDAP query and store them in a SQL database. From there, you can join the data as needed. If you have a beefy domain controller, you should not have any problems hitting the directory hundreds, or thousands, of times. I do this on an almost-daily basis. You could build your LDAP filter to retrieve multiple accounts, however, I wouldn't have it return more than a couple dozen, at a time. Try changing your filter to be something like: ((objectCategory=Person)(|(cn=user_1)(cn=user_2)(cn=user_n))) Personally, I'd just hit the domain controllers as you are doing now and be happy in the simplicity of the solution. Mike -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 11:26 AM To: cf-talk Subject: LDAP Query Performance question I have a query of a SQL table that returns to me a bunch of usernames. From that, I need to query some information out of Active Directory for each user. Right now I have it looping over each row in the result from the SQL query and doing a separate LDAP query to the AD. This just doesn't seem like the best way to do things. Does anyone know if there's a syntax within LDAP querying of the AD to do something like an IN keyword where I could give the whole list of usernames I want to query and get a single result set back from one query instead of doing individual queries? There's no commonality amongst the user accounts in the AD except for the fact that their usernames are all in this external SQL table. Let me know if you have any ideas. Or maybe the single LDAP queries aren't as intensive as bad as what I'm thinking. I just know I always try to avoid multiple queries in SQL whenever possible. Here's the syntax I'm using now when querying the AD: cfldap action=QUERY name=GetEmployeeIDByUsername attributes=cn,displayName,givenName,extensionAttribute1 start=dc=domain,dc=com scope=subtree filter=((objectCategory=Person)(cn=#myQuery.username#)) server=domaincontroller.mydomain.com username=#ADUsername# password=#ADPassword# Thanks in advance for any help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: LDAP Query Performance question
Oh, by the way, regarding my earlier message. We have about 5,500 accounts that I update on a daily basis. Performance isn't really an issue, however, I have plans to cut this down from taking several minutes, to just a few dozen seconds. Mike -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 12:03 PM To: cf-talk Subject: RE: LDAP Query Performance question It's just a nightly task but it may have 300-400 results each time it runs. I don't think it'll bring down the house or anything it just brought up the question to see if there was a more elegant way of doing it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
I love the way you disguise the cold fusion pages by using a php extension on the links.. http://www.austin-williams.com/portfolio/popup.php?image=Allied/ad1http://www.austin-williams.com/portfolio/popup.php?image=Allied/ad1 At 10:07 AM 10/31/2008, you wrote: We've just launched our own new site. It's fully CF driven from MS SQL DB. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Keep up, Al. LOL. They had to revert to the old site, due to legacy files being used on other (client) websites. On Fri, Oct 31, 2008 at 3:48 PM, Al Musella, DPM [EMAIL PROTECTED] wrote: I love the way you disguise the cold fusion pages by using a php extension on the links.. http://www.austin-williams.com/portfolio/popup.php?image=Allied/ad1http://www.austin-williams.com/portfolio/popup.php?image=Allied/ad1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LDAP Query Performance question
LDAP is optimized for reading, so I would assume that tens of thousands of requests per second shouldn't phase it. (OpenLDAP 2.4 can handle 32,000 per second, (I can't seem to find a number for Active Directory)). speeves On Fri, Oct 31, 2008 at 2:45 PM, Dawson, Michael [EMAIL PROTECTED]wrote: Oh, by the way, regarding my earlier message. We have about 5,500 accounts that I update on a daily basis. Performance isn't really an issue, however, I have plans to cut this down from taking several minutes, to just a few dozen seconds. Mike -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 12:03 PM To: cf-talk Subject: RE: LDAP Query Performance question It's just a nightly task but it may have 300-400 results each time it runs. I don't think it'll bring down the house or anything it just brought up the question to see if there was a more elegant way of doing it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: LDAP Query Performance question
AD can handle 32,001 ;^) -Original Message- From: Shannon Peevey [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 3:06 PM To: cf-talk Subject: Re: LDAP Query Performance question LDAP is optimized for reading, so I would assume that tens of thousands of requests per second shouldn't phase it. (OpenLDAP 2.4 can handle 32,000 per second, (I can't seem to find a number for Active Directory)). speeves ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
A small thing. When you click Profiles the menu disappears. So you can no longer navigate unless you use the browser's back button. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LDAP Query Performance question
My point exactly :) On Fri, Oct 31, 2008 at 3:17 PM, Dawson, Michael [EMAIL PROTECTED]wrote: AD can handle 32,001 ;^) -Original Message- From: Shannon Peevey [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 3:06 PM To: cf-talk Subject: Re: LDAP Query Performance question LDAP is optimized for reading, so I would assume that tens of thousands of requests per second shouldn't phase it. (OpenLDAP 2.4 can handle 32,000 per second, (I can't seem to find a number for Active Directory)). speeves ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: xml data referencing
Hi Daniel,
Yes you'll need to loop through and append them to a string if you are
trying to save them to one query record. What does the entire xml file look,
I assume that previous piece of code is just one of the entries?
On Fri, Oct 31, 2008 at 12:06 PM, daniel kessler [EMAIL PROTECTED] wrote:
Hi Daniel
You'll need to use XMLAttributes and it will return a structure.
XMLChildren[index].category.XMLAttributes
ah that worked nicely. It gave me a struct and I referenced 'term' to get
my data.
parsed[feed].XMLChildren[index].category.XMLAttributes.term
However, if there were two 'category' items, it only gave me the last one.
I figured out how to reference them with [n], but how do I know how many of
them there are? I'm supposing that I need to loop through them to get all
the 'category' entries. If I try to reference more than what's there, I
receive an error.
Here is my attempt to deal with all that, but I receive an error:
for (ll = 1; ll LTE 25; ll=ll+1){
if
(isdefined(parsed[feed].XMLChildren[index].category[ll].XMLAttributes.term))
categories = categories 'some_data|';
}
if (structKeyExists(parsed[feed].XMLChildren[index], category))
querySetCell(retQuery, category, categories, rows);
Receives error: Element CATEGORY is undefined in a Java object of type
class coldfusion.xml.XmlNodeMap referenced as
any additional help would be greatly appreciated and thanks Nick for your
help getting me this far.
daniel
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFEclipse Eclipse Ganymede?
Is there an ETA on when CFEclipse will be working properly in Ganymede? I've got to upgrade to Eclipse 3.4.x, but CFEclipse (which I also need) isn't supported in Ganymede and won't install. Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse Eclipse Ganymede?
I didn't have any issues installing CFE on Ganymede. Just set up a new environment last week on my new workstation and it was as smooth as butter. Just dropped the update site URL in there and install it. On Fri, Oct 31, 2008 at 2:26 PM, Pete Ruckelshaus [EMAIL PROTECTED] wrote: Is there an ETA on when CFEclipse will be working properly in Ganymede? I've got to upgrade to Eclipse 3.4.x, but CFEclipse (which I also need) isn't supported in Ganymede and won't install. Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Blowin our own horn: New CF Site
Keep up, Al. LOL. I was gonna make another joke about his lagging behind because he spelled it Cold Fusion ... but I thought some folks might think it mean spirited? -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.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;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use J2EE datasource to insert Clob on MX6,7
Is there a reason you're not using the DataDirect Oracle drivers that came with CF? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/31 anguss [EMAIL PROTECTED]: Dear Tom: Tks for ur reply.I will check oracle log later. I had tried to use mx8(8,0,1,195765) with oracle 9i and 10g driver ,and CF throws the same execption as follow Error casting an object of type weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed. weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection Maybe this is a weblogic's problem ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
