Re: CFMAIL wrongly moved to Undelivr folder
Joy Anderson wrote: Jochem van Dieten wrote: CF is delivering the email message to the SMTP server and the SMTP server waits a long time before confirming the receipt. So after a while CF stops waiting for the receipt and decides the message is undeliverable, and some time later the SMTP server confirms the receipt. Look into the logfiles of the SMTP server for any clues and check how fast it processes email. Check whether you have any dependencies on antivirus software or DNS (for blacklists). Is there any setting in CF to tell it how long to wait for the receipt from the SMTP server? I don't know. But I would be focussing on making the SMTP server faster instead of making CF slower. Jochem ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Report Problems
I am creating a report with report builder. I have a report header. This report is 3 pages long. After I get the content for the first page, I add a page break. 2 problems. Once the detail band is longer than a page, the report header is forced to page 1 by itself, like a page break magically appears after the report header. Also, At a certain point I am given an error: Report design not valid : 1. The detail section, the page and column headers and footers and the margins do not fit the page height. How do I create a report that is 3 pages long, with specifically placed page breaks, and a report header. The detail band should start immediately after the report header(no page break after report header). TIA, -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Site masking from GoDaddy.com
The site is inside a frame if that helps...it's called URL framing Eric -Original Message- From: Dave Hatz [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 7:26 PM To: CF-Talk Subject: Site masking from GoDaddy.com I am not even sure site masking is the correct term, but let me see if I can explain what is happening. I have a client with a URL like this http://www.mywebsite.com/clientname but he doesn't like that name, so he goes out to GoDaddy.com and gets a new site, http://www.clientswebsite.com/ which points to http://www.mywebsite.com. We are using CF7.02 for this site. We set some session variables on the home page and the client navigates through the site. All works fine if he hits our site 1st, but if he hits the site using the masked named, the session variables are getting dropped and the site is fubar. Hopefully I have explained the problem well enough. Can someone clue me in on what is happening when the site is coming from GoDaddy's domain name? Thanks, Dave Hatz ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: running jrockit with CFusionMX7 to find memory leak
On Tuesday 07 Aug 2007, [EMAIL PROTECTED] wrote: I have been having a terrible time trying to get jrockit running with coldfusion. I have coldfusion MX 7 running and installed jrockit Can you stick your app on CF8 in the dev. environment and use the built in stuff to try and locate it by watching the graphs as you do one thing at a time ? You're not doing lots of cffile action=upload are you ? There was a leak in that... -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: coldfusion 8 and memory
On 8/8/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 07 Aug 2007, [EMAIL PROTECTED] wrote: what the heck works in native 64bit systems yet, :looks around his 64-bit machine :sees ColdFusion, Eclipse, KDE, FireFox w/Flash and Java Umm, everything ? -- Tom Chiverton I'm sure everything is working but not in what I should have stated, native 64bit mode. In two years, it will be time to upgrade my system again and maybe it would be worth checking out a 64bit system then. For me, FinalScratch is not supported on a 64bit system at this time. FS has the worst sound drivers as it is, I'm not going to push it ;-) ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Content Placeholders
in the i18n world, java MessageFormat's are often used for dynamic content like this. it's flexible, quick as an added bonus handles locale formatting where needed. Where would I find something like that? Mark ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Content Placeholders
Mark Leder wrote: Where would I find something like that? it's already in cfmx (core java anyway). see those links for examples. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cfdocument named anchors and image scaling
This is CF 7 with all updates on IIS 6. Has anyone got named anchors to work in PDFs generated by cfdocument? If so, any tips on how? If not, any other ways of including links to other portions of the document? Also, anyone got any ideas why my images would display at 100% when the document is viewed at 113%? I.e. If I view the PDF at 100% the images are scaled down and look ropey but if I view the PDF at 113% they are as per the originals and nice and sharp. Cheers Gareth ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMAIL wrongly moved to Undelivr folder
I agree it would be nice to make the SMTP server faster, but some things are out of my control. I checked the documentation -http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1710.htm - and found it mentions Connection Timeout (seconds) - Enter the number of seconds that ColdFusion MX should wait for a response from the mail server before timing out. However, I cannot find that setting in CF Administrator's Mail settings. The docs do not say it's an enterprise only setting. I can see in the Settings Summary that the Mail Connection Timneout is 60 seconds. Where can I change that? I also checked the CFMAIL tag parameters and found there is one called timeout which does the same thing, overriding the Administrator setting. Unless someone can tell me where to change this setting in CFADMIN, I'll insert this timeout setting in my CFMAIL tags. Joy ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: coldfusion 8 and memory
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: I'm sure everything is working but not in what I should have stated, native 64bit mode. In two years, it will be time to upgrade my system again and maybe it would be worth checking out a 64bit system then. I must admit - it was more hassle getting it all working than it is probably worth it. This goes double now I'm getting an Ubuntu laptop at home, which means a new kernel and all major utilities every 6 months anyway. Might as well go 32-bit till Adobe sort themselves out. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285673 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 named anchors and image scaling
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: If I view the PDF at 100% the images are scaled down and look ropey but if I view the PDF at 113% they are as per the originals and nice and sharp. Umm, yes ? Maybe the native image resolution matches your display resolution only at 113% zoom of the document. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285674 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMAIL wrongly moved to Undelivr folder
I found a file named neo-mail.xml in the \lib folder of cfroot. It contains the mail connection timeout value (default is 60.0). - var name=timeout number60.0/number /var I changed this to 120.0 and restarted CF. The Settings Summary in CFAdmin now shows the Mail Connection Timeout to be 120. I think this might just be what I was looking for. Joy ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX 7 / Vista
Randy, This is what finally got my install of CFMX 7 and Vista to work together. http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1c atid=3threadid=1257380highlight_key=ykeyword1=vista -Aaron Wolfe -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 4:56 PM To: CF-Talk Subject: CFMX 7 / Vista Has anyone able to get the CFMX 7 installer to work on Vista? I did a Google and found a few sites that talk about it but some are talking about different items that helped them. Just wondering if anyone has solid set of install instructions or steps since I know it is CF not completing the services setup and ISAPI mappings for one. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cfdocument named anchors and image scaling
Umm, cool. Not sure I understand you exactly but you must be right as the optimum zoom seems to differ across machines. Thanks :) Tom Chiverton wrote: Umm, yes ? Maybe the native image resolution matches your display resolution only at 113% zoom of the document. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion 8 CachedWithin Issue
I am getting very strange behaviors while using CachedWithin on CF8. All the sudden, something that has been working without fail for months in CF7 is giving odd errors. On CF8 I will get intermittent errors that say corrupt table null. If I remove the cachedwithin attribute the query runs fine. For example, I can pass in the state argument of AL and it works fine, but when I pass in CO it blows up. Any thoughts? cfquery name=qGetStates datasource=#Variables.Settings.DSN# cachedwithin=#CreateTimeSpan(0,12,0,0)# SELECT State,StateName,Country,TimeZone,BorderingStates FROMdbo.States WHERE 0=0 cfif len(trim(Arguments.State)) AND State = '#trim(Arguments.State)#' /cfif cfif len(trim(Arguments.TimeZone)) AND TimeZone = '#trim(Arguments.TimeZone)#' /cfif cfif len(trim(Arguments.ExcludeCountries)) AND Country NOT IN ('#trim(Arguments.ExcludeCountries)#') /cfif ORDER BY #trim(Arguments.OrderBy)# /cfquery ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: CF 8 SW Maintenance Plan
Just a quick survey..has anyone with an Adobe SW Maintenance Plan received an upgrade coupon/code or key for CF 8? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Quick Question about upgrading to CF 8
I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I have no problem just upgrading 8 over 7, thinking that it will just update all relevant parts, but I just wanted to see what the consensus was, or if there's actually a somewhat official position... Any ideas? ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 CachedWithin Issue
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: the sudden, something that has been working without fail for months in CF7 is giving odd errors. On CF8 I will get intermittent errors that say corrupt table null. If I remove the cachedwithin attribute the query runs fine. For example, I can pass in the state argument of AL and it works fine, but when I pass in CO it blows up. Any thoughts? You mean it always blows up with 'CO', or only sometimes ? Oh, and cfqueryparam everything ! -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick Question about upgrading to CF 8
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I believe by default CF8 installs into a different directory, and imports all your CF7 settings. Or you can make a CAR of your CF7 settings, uninstall CF7 and install CF8 fresh. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX 7 / Vista
That's timely and great information... thanks. I just bought a Vista machine and have been updating it. So, two related questions: 1. Does CF8 install cleanly on Vista or will these same instructions work for CF8? 2. Also, Vista does not support SQL Server2000 so I had to upgrade to 2005 (big pain). Does anyone have any experience connecting SQL Server2005 DBs to CF on Vista? That's where I was expecting issues... 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 . ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF 8 SW Maintenance Plan
We received ours on Monday. My father's school corporation received theirs a few days earlier. M!ke -Original Message- From: Howell, Craig H Civ WRALC/ITMS [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:35 AM To: CF-Talk Subject: SOT: CF 8 SW Maintenance Plan Just a quick survey..has anyone with an Adobe SW Maintenance Plan received an upgrade coupon/code or key for CF 8? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX 7 / Vista
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: I just bought a Vista machine and have been updating it. So, two related questions: There's the obvious question of 'why' that we'll save for another time. 1. Does CF8 install cleanly on Vista or will these same instructions work for CF8? No, CF8 is supported on Vista. 2. Also, Vista does not support SQL Server2000 so I had to upgrade to 2005 (big pain). Dunno, check MS's support matrix. Even if not, just stick it in a VMWare. Does anyone have any experience connecting SQL Server2005 DBs to CF on Vista? That's where I was expecting issues... It's all JDBC. Or ODBC. It'll be fine. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX 7 / Vista
Officially CF7 isn't supported on Vista (CF7 arrived nearly two years before Vista) and initially CF8 support was flaky (but so was Vista) - but now works a treat. Consider upgrading. CF7 is now old and superceded tech as far as ColdFusion goes. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285686 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX 7 / Vista
2. Also, Vista does not support SQL Server2000 so I had to upgrade to 2005 (big pain). There is always SQL Server 2005 Express if you get desperate. Vista and CF8 support both (expect a few patches for SQL Server however - sigh!). ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 8 amp; CachedWithin Issue
Well it would blow up on various states. All the time on CF8. But this has never happened on 7. I restarted the CF service and it seems to be ok now. But that is beside the point really, I am more concerned on what might have caused this issue since it is a very simple query that just pulls state data. In CF7 you could not use cachedwithin and cfqueryparam together, thus.no cfqueryparam - I am doing some checks for injection before the data is passed to the query. With 8 will be adding the cfqueryparam in b/c they can be used together. On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: the sudden, something that has been working without fail for months in CF7 is giving odd errors. On CF8 I will get intermittent errors that say corrupt table null. If I remove the cachedwithin attribute the query runs fine. For example, I can pass in the state argument of AL and it works fine, but when I pass in CO it blows up. Any thoughts? You mean it always blows up with 'CO', or only sometimes ? Oh, and cfqueryparam everything ! -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Eclipse/CFEclispe
So as advised by many on this list I'm going to try CFEclipse, but I found the whole thing a bit confusing. It looks like there are two steps. First install an Eclipse IDE / SDK, then install CFEclipse as a plug-in. I thinks that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ After that I install the CFEclipse plug-in. Is this correct? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion 8 CachedWithin Issue
Have you managed to get the SQL statement that runs when it falls over? What does it look like? Adrian -Original Message- From: Jason Fill Sent: 08 August 2007 15:26 To: CF-Talk Subject: ColdFusion 8 CachedWithin Issue I am getting very strange behaviors while using CachedWithin on CF8. All the sudden, something that has been working without fail for months in CF7 is giving odd errors. On CF8 I will get intermittent errors that say corrupt table null. If I remove the cachedwithin attribute the query runs fine. For example, I can pass in the state argument of AL and it works fine, but when I pass in CO it blows up. Any thoughts? cfquery name=qGetStates datasource=#Variables.Settings.DSN# cachedwithin=#CreateTimeSpan(0,12,0,0)# SELECT State,StateName,Country,TimeZone,BorderingStates FROMdbo.States WHERE 0=0 cfif len(trim(Arguments.State)) AND State = '#trim(Arguments.State)#' /cfif cfif len(trim(Arguments.TimeZone)) AND TimeZone = '#trim(Arguments.TimeZone)#' /cfif cfif len(trim(Arguments.ExcludeCountries)) AND Country NOT IN ('#trim(Arguments.ExcludeCountries)#') /cfif ORDER BY #trim(Arguments.OrderBy)# /cfquery ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 8 SW Maintenance Plan
We bought licenses for 7 a few months ago with subscription. We just got our 8 licenses a few days ago, last week maybe? -Original Message- From: Howell, Craig H Civ WRALC/ITMS [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:35 AM To: CF-Talk Subject: SOT: CF 8 SW Maintenance Plan Just a quick survey..has anyone with an Adobe SW Maintenance Plan received an upgrade coupon/code or key for CF 8? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Eclipse/CFEclispe
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303/ It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion 8 cfgrid and formatting
Sorry for the late reply. Yes, the mask attribute applies only if format is flash. If you want to format the data in an html grid, you will have to write your query accordingly so that it returns the date in the required format. This was specifically for the date. However we can take this up as an enhancement. I shall file it for you. Thanks for the inputs. If you have any doubts feel free to ask Regards, Bhakti Adobe ColdFusion team -Original Message- From: Dan Vega [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 11:25 PM To: CF-Talk Subject: ColdFusion 8 cfgrid and formatting I am having a hard time finding an answer to this riddle so maybe someone here can help. I have a grid with columns show below. The livedocs say the mask attribute for cfgridcolumn is only used in when the format is flash. If this is correct then how do i format data in html? This would not just be dates but really any data, does anyone know how to format data? cfform cfgrid name=ClientsGrid format=html striperows=true autowidth=true pagesize=30 bgcolor=black textcolor=white bind=cfc:clients.getClients ({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}) cfgridcolumn name=studentlast header=Last Name cfgridcolumn name=studentfirst header=First Name cfgridcolumn name=studentemail header=Email Address cfgridcolumn name=advisor header=Advisor cfgridcolumn name=entrydate header=Entry Date mask=[MM/DD/] cfgridcolumn name=monthly header=Monthly cfgridcolumn name=billto header=Bill To cfgridcolumn name=anniversary header=Anniversary /cfgrid /cfform -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 8 cfgrid and formatting
Thanks for the reply Bhakti! Dan On 8/8/07, Bhakti Pingale [EMAIL PROTECTED] wrote: Sorry for the late reply. Yes, the mask attribute applies only if format is flash. If you want to format the data in an html grid, you will have to write your query accordingly so that it returns the date in the required format. This was specifically for the date. However we can take this up as an enhancement. I shall file it for you. Thanks for the inputs. If you have any doubts feel free to ask Regards, Bhakti Adobe ColdFusion team -Original Message- From: Dan Vega [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 11:25 PM To: CF-Talk Subject: ColdFusion 8 cfgrid and formatting I am having a hard time finding an answer to this riddle so maybe someone here can help. I have a grid with columns show below. The livedocs say the mask attribute for cfgridcolumn is only used in when the format is flash. If this is correct then how do i format data in html? This would not just be dates but really any data, does anyone know how to format data? cfform cfgrid name=ClientsGrid format=html striperows=true autowidth=true pagesize=30 bgcolor=black textcolor=white bind=cfc:clients.getClients ({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}) cfgridcolumn name=studentlast header=Last Name cfgridcolumn name=studentfirst header=First Name cfgridcolumn name=studentemail header=Email Address cfgridcolumn name=advisor header=Advisor cfgridcolumn name=entrydate header=Entry Date mask=[MM/DD/] cfgridcolumn name=monthly header=Monthly cfgridcolumn name=billto header=Bill To cfgridcolumn name=anniversary header=Anniversary /cfgrid /cfform -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse/CFEclispe
Thank You. I'll give it a try... downloading now! I'm figuring since I have a new kick-butt machine and I still have my old machine and environment, I'm going bleeding edge on the new one. IIS7, CF8, SQL Server 2005, CFECLISPE, etc. Why not for once be on the lead? Normally I wouldn't try that so boldly but my development platform is still intact on the old machine and production won't be in jeopardy. Keep your fingers crossed. So far I've gotten through the glitches as they've shown themselves. 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 . ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse/CFEclispe
It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303/ It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse/CFEclispe
Yeah, that's a good question. I have the WTP build, but I don't really see any other features, such as CSS, when I'm editing .css files or even styles within an HTML page. M!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 9:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse/CFEclispe
Look at Aptana. Best CSS and JS plugin around far as I am concerned. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303 / It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse/CFEclispe
I tried aptana, but then I lost the ability to autocomplete CF tags... it was like I had to choose one or the other. CSS or CF.. I could not get autocomplete to work for each language at the same time. Is there anyway for me to upgrade my eclipse so I get this WTP all in one package features??? Or do I have to re-install and loose all my custom keys and plugins? -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:44 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe Look at Aptana. Best CSS and JS plugin around far as I am concerned. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303 / It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse/CFEclispe
You can also look at Aptana, I use that plugin and it has a lot of nice features. http://www.aptana.org On 8/8/07, Dawson, Michael [EMAIL PROTECTED] wrote: Yeah, that's a good question. I have the WTP build, but I don't really see any other features, such as CSS, when I'm editing .css files or even styles within an HTML page. M!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 9:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse/CFEclispe
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: Is there anyway for me to upgrade my eclipse so I get this WTP all in one package features??? Or do I have to reÂinstall and loose all my custom keys and plugins? Just add the WTP URL to your plugin finder. If you have Eclipse 3.3, it should be findable already. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse/CFEclispe
Well i only use aptana when I am editing .css, .js, .html. When I am editing cfm or cfc I use CFEclipse of course! Dan On 8/8/07, Chad Gray [EMAIL PROTECTED] wrote: I tried aptana, but then I lost the ability to autocomplete CF tags... it was like I had to choose one or the other. CSS or CF.. I could not get autocomplete to work for each language at the same time. Is there anyway for me to upgrade my eclipse so I get this WTP all in one package features??? Or do I have to re-install and loose all my custom keys and plugins? -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:44 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe Look at Aptana. Best CSS and JS plugin around far as I am concerned. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303 / It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help with CFNavigate
I am going to try it here since no one from the Adobe support forum knew... Now maybe I am doing it wrong but with CFNavigate, it has the parameter for a container to refresh. What if I want the whole page to refresh with the form fields passed into it? Based on the CFML Reference Guide (pg 127) all I have to do is... If you omit this argument, the link is treated as a normal URL and the entire page is refreshed. So here's the basic thing I am trying to do... use CFLAYOUTAREA which has a form in it and I have a link which should pass the form variables from myform to the test_submit.cfm page. Here's the basic code I am using: a href=javascript:ColdFusion.navigate('test_submit.cfm',,'','','post','myform');Submit it/a If I leave the container field out of it... (no quotes), I get: Syntax Error. If I enter a '' (no space), I get: Error replacing HTML, element not found. If I enter a ' ' (with a space), I get the same error as above: Error replacing HTML, element not found. Am I using it wrong? is there a _root or something I need to put in the container field for it to work? Thanks, Andy ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 SW Maintenance Plan
Here at Duke, we got our CF8 subscription licenses last week. Rick ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One form with two submit buttons in lt;cflayoutareagt;
So i did a test when I changed your cfform to post to test2.cfm, and dumped the form scope there, and I saw the same - it doesn't recognize the second button. I mean the button works, but the value is the same. Yeah, experienced the same problem too. I used a CFDUMP var=#form# and couldn't get the 2nd submit form field to show up. I am thinking it would need to be a button and use the Coldfusion.navigation tag to make it work. I posted another problem regarding that. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DW8 download?
Anyone have a link to the Dreamweaver 8 downloads? I need to get that version. We have our own key for it just need to re-install. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How would I go by doing this?
Here's a situation: Basically there is a form (CFFORM) which there are various fields. One of the field would be a basic CFINPUT text field where an image ID can be entered. The user will be able to click on a button to preview available images (CFWINDOW). Whatever image they select in the Window (via radio button or drop down), it will populate the main form with the value. I can't figure out how to pass a variable from the Window back to the parent form. To use some of the UI features, the Window will need to have a CFFORM also. I tried binding but it would only work if it is in the same form (or section). Most commands support FORMNAME.FORMFIELD naming to apply a function but is there a WINDOW.FORMNAME.FORMFIELD naming scheme? I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for pointers but I can't seem to find out what to use. It seem pretty straight forward so I figure I must be missing something obvious... please help. Thanks, Andy ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
any idea how to
Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any idea how to
Date format? Left, mid, right? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:05 PM To: CF-Talk Subject: any idea how to Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any idea how to
LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: any idea how to
crude, but it works consistently: cfset year = Left(20060523,4) cfset month = Mid(20060523,5,2) cfset day = Right(20060523,2) cfoutput#CreateDate(year,month,day)#/cfoutput On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
There is probably a trick i don't know, but something like... dTemp=createODBCDate(mid(date,3,2)right(date,2)left(date,4)) sDate=dateFormat(dTemp,m/d/) On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: any idea how to
Using SQL CONVERT(VARCHAR,CONVERT(DATETIME,'20060523'),101) Using CF Mid('20060523',5,2) '/' Right('20060523',2) '/' Left('20060523',4) -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 11:10 AM To: CF-Talk Subject: RE: any idea how to Date format? Left, mid, right? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:05 PM To: CF-Talk Subject: any idea how to Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
Scott Stewart wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas createDate(left('20060523'),mid('20060523',5,2),right('20060523')) is how I have done this in the past, you will probably want to use a variable here and there. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How would I go by doing this?
The only way I know of doing what you've indicated below is to use a JavaScript. You can reference the parent or opener window by using the opener keyword: opener.document.parentForm.pf1.value = document.childForm.cf1.value; A good example of how to do this from a JavaScript can be seen here: http://www.rgagnon.com/jsdetails/js-0066.html -- Original message -- From: Andy Chen [EMAIL PROTECTED] Here's a situation: Basically there is a form (CFFORM) which there are various fields. One of the field would be a basic CFINPUT text field where an image ID can be entered. The user will be able to click on a button to preview available images (CFWINDOW). Whatever image they select in the Window (via radio button or drop down), it will populate the main form with the value. I can't figure out how to pass a variable from the Window back to the parent form. To use some of the UI features, the Window will need to have a CFFORM also. I tried binding but it would only work if it is in the same form (or section). Most commands support FORMNAME.FORMFIELD naming to apply a function but is there a WINDOW.FORMNAME.FORMFIELD naming scheme? I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for pointers but I can't seem to find out what to use. It seem pretty straight forward so I figure I must be missing something obvious... please help. Thanks, Andy ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How would I go by doing this?
Thanks you for the Javascript. That will work with a whole new Window - childWindow=open(file,window,'resizable=no,width=200,height=400') and not with the CFWindow tag. Using the script with CFWindow, I will get a Javascript (Object expected) error (tried it with parent and opener). I think it has to be controlled through AJAX. I tried the ColdFusion.getElementValue but it has to be within the same form (since it doesn't have a container parameter). Any other ideas? The only way I know of doing what you've indicated below is to use a JavaScript. You can reference the parent or opener window by using the opener keyword: opener.document.parentForm.pf1.value = document.childForm.cf1.value; A good example of how to do this from a JavaScript can be seen here: http://www.rgagnon.com/jsdetails/js-0066.html -- Original message -- From: Andy Chen [EMAIL PROTECTED] Here's a situation: Basically there is a form (CFFORM) which there are various fields. One of the field would be a basic CFINPUT text field where an image ID can be entered. The user will be able to click on a button to preview available images (CFWINDOW). Whatever image they select in the Window (via radio button or drop down), it will populate the main form with the value. I can't figure out how to pass a variable from the Window back to the parent form. To use some of the UI features, the Window will need to have a CFFORM also. I tried binding but it would only work if it is in the same form (or section). Most commands support FORMNAME.FORMFIELD naming to apply a function but is there a WINDOW.FORMNAME.FORMFIELD naming scheme? I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for pointers but I can't seem to find out what to use. It seem pretty straight forward so I figure I must be missing something obvious... please help. Thanks, Andy ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How would I go by doing this?
If you are using cfwindow than the window is on the same page. You should be able to use JS to control the value on the original form. Like: document.formName.name.value; Check out this demo I did: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm I think the concept is kind of the same. Click the new company link and a cfwindow opens. After the new company is inserted there is a close button that uses JS to update the company picklist on the original form. It then closes the window. I hope this helps. The only way I know of doing what you've indicated below is to use a JavaScript. You can reference the parent or opener window by using the opener keyword: opener.document.parentForm.pf1.value = document.childForm.cf1.value; A good example of how to do this from a JavaScript can be seen here: http://www.rgagnon.com/jsdetails/js-0066.html -- Original message -- From: Andy Chen [EMAIL PROTECTED] Here's a situation: Basically there is a form (CFFORM) which there are various fields. One of the field would be a basic CFINPUT text field where an image ID can be entered. The user will be able to click on a button to preview available images (CFWINDOW). Whatever image they select in the Window (via radio button or drop down), it will populate the main form with the value. I can't figure out how to pass a variable from the Window back to the parent form. To use some of the UI features, the Window will need to have a CFFORM also. I tried binding but it would only work if it is in the same form (or section). Most commands support FORMNAME.FORMFIELD naming to apply a function but is there a WINDOW.FORMNAME.FORMFIELD naming scheme? I tried looking at the CF 8 Developer Guide and CF 8 CFML Refence guide for pointers but I can't seem to find out what to use. It seem pretty straight forward so I figure I must be missing something obvious... please help. Thanks, Andy ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: any idea how to
Alan, This worked... Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:11 PM To: CF-Talk Subject: Re: any idea how to LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: any idea how to
Coolio.. Make sure I got the MID function right, I tossed it together real quick and it might be 5, not 4. =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Alan, This worked... Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:11 PM To: CF-Talk Subject: Re: any idea how to LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks http://www.linkedin.com/in/sstwebworks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server problem getting records within date range
Hello all... I could use a little help here. I am trying to get the latest transaction date from all users within a specified date range. But the query below is giving me records from the date range for this year and last year. What the heck am I doing wrong? SELECT dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, max(dbo.tblUserTransactionLog.Processed) FROM dbo.tblSubscribers, dbo.tblUserTransactionLog WHERE (dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, HAVING (CONVERT(varchar, MAX(dbo.tblUserTransactionLog.Processed),101) = '08/01/2007') AND (CONVERT(varchar, MAX(dbo.tblUserTransactionLog.Processed),101) = '08/07/2007') Thanks, CWB ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Data source 'source_name' verification failed.????
I have a ColdFusion page that is accessing two different ColdFusion data sources from the same page. I have many queries that are using the first source and they all work. I have TWO queries that access the second source and one of them works and the other doesn't. They are using the same data source definition and point to the same ORACLE schema. The second one errors off giving the error: 'Data source 'source_name' verification failed.' I have removed the actual source name for security purposes. Has anyone ever seen this? Can you suggest a way to debug or isolate? Any help would be appreciated. I am at the end of my ideas. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How would I go by doing this?
Steve, that is it. Similar to what I want to do but something is weird. I still get the Javascript: Object Expected error. This means I did something stupid like typed something wrong however I don't see it, and I simplified it a lot already. This test is just to copy what is typed in the Window onto the main form. (form_test1.cfm) cfif isDefined(form.submit) cfdump var=#form# /cfif !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleInput Test/title /head body cfajaximport tags=cfform,cfwindow cfform name=mainform action=form_test1.cfm cfinput name=test1 size=10 type=text cfinput type=submit name=submit value=submit /cfform cfwindow name=win1 source=form_test1_win.cfm initshow=true / /body /html (form_test1_win.cfm) script function updateit() { document.mainform.test1.value = document.winform.wintxt.value; } /script cfform name=winform TYPE SOMETHING: cfinput type=text name=wintxt size=10 onkeyup=javascript: updateit(); /cfform If you are using cfwindow than the window is on the same page. You should be able to use JS to control the value on the original form. Like: document.formName.name.value; Check out this demo I did: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm I think the concept is kind of the same. Click the new company link and a cfwindow opens. After the new company is inserted there is a close button that uses JS to update the company picklist on the original form. It then closes the window. I hope this helps. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data source 'source_name' verification failed.????
Try catch the query that is throwing the error Dump the cfcatch return you'll have additional information in there like oracle error code. cftry cfquery / cfcatch type=any cfdump var=#cfcatch# /cfcatch /cftry Something like that should work. -Original Message- From: Charles Love [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:43 PM To: CF-Talk Subject: Data source 'source_name' verification failed. I have a ColdFusion page that is accessing two different ColdFusion data sources from the same page. I have many queries that are using the first source and they all work. I have TWO queries that access the second source and one of them works and the other doesn't. They are using the same data source definition and point to the same ORACLE schema. The second one errors off giving the error: 'Data source 'source_name' verification failed.' I have removed the actual source name for security purposes. Has anyone ever seen this? Can you suggest a way to debug or isolate? Any help would be appreciated. I am at the end of my ideas. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
About the GotCFM.com Site List
Hi Everyone, Of late, I've been seeing a number of questions as to why specific sites are not on the GotCFM list. The easy answer is that they haven't been submitted. I review and approve sites fairly quickly so its not a delay from that perspective. With that said, if you see a CF site that is not part of the list, please feel free to submit it. The form is on the homepage of GotCFM.com and its as easy as it gets. You don't need to be the site owner to submit it so please take the initiative and send the site over for review. I also get emails asking me to submit sites for people. Like everyone else, I'm fairly busy with work so I really don't have time to do that. In the time it takes someone to email me about a new site, they could've submitted it themselves. This is a resource for the CF community so a little effort on everyone's part will definitely help make the site more effective. Thanks, Rey... ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How would I go by doing this?
Andy, Move the JS to the form_test1.cfm page. It works when you do that. Here it is: http://demo.thinksys.com/cf8/cfwindow/form_test1.cfm Are you using Firebug? As Ray Camden has told me many times, use Firebug. It is really great for this stuff. You would see that the actual error was updateit() is not defined. But just move the JS to form_test1.cfm and you should be good. -Steve Steve, that is it. Similar to what I want to do but something is weird. I still get the Javascript: Object Expected error. This means I did something stupid like typed something wrong however I don't see it, and I simplified it a lot already. This test is just to copy what is typed in the Window onto the main form. (form_test1.cfm) cfif isDefined(form.submit) cfdump var=#form# /cfif !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleInput Test/title /head body cfajaximport tags=cfform,cfwindow cfform name=mainform action=form_test1.cfm cfinput name=test1 size=10 type=text cfinput type=submit name=submit value=submit /cfform cfwindow name=win1 source=form_test1_win.cfm initshow=true / /body /html (form_test1_win.cfm) script function updateit() { document.mainform.test1.value = document.winform.wintxt.value; } /script cfform name=winform TYPE SOMETHING: cfinput type=text name=wintxt size=10 onkeyup=javascript: updateit(); /cfform If you are using cfwindow than the window is on the same page. You should be able to use JS to control the value on the original form. Like: document.formName.name.value; Check out this demo I did: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm I think the concept is kind of the same. Click the new company link and a cfwindow opens. After the new company is inserted there is a close button that uses JS to update the company picklist on the original form. It then closes the window. I hope this helps. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question about upgrading to CF 8
LHWH Interactive wrote: I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Install CF 8 next to it so you can use them both. Or install a CF 8 EAR in a CF 7 instance and run CF 8 on top of CF 7. Jochem ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server problem getting records within date range
Use the WHERE not HAVING clause. Try something like SELECT ... FROM ... WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID ANDdbo.tblUserTransactionLog.Processed = convert(datetime, '08/01/2007', 101) AND dbo.tblUserTransactionLog.Processed = convert(datetime, '08/07/2007', 101) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How would I go by doing this?
Steve, You are da man! Never head of Firebug but I will give it a shot. I am pretty much developing for IE so I never thought about installing Firefox. Thanks, Andy Andy, Move the JS to the form_test1.cfm page. It works when you do that. Here it is: http://demo.thinksys.com/cf8/cfwindow/form_test1.cfm Are you using Firebug? As Ray Camden has told me many times, use Firebug. It is really great for this stuff. You would see that the actual error was updateit() is not defined. But just move the JS to form_test1.cfm and you should be good. -Steve Steve, that is it. Similar to what I want to do but something is weird. I still get the Javascript: Object Expected error. This means I did something stupid like typed something wrong however I don't see it, and I simplified it a lot already. This test is just to copy what is typed in the Window onto the main form. (form_test1.cfm) cfif isDefined(form.submit) cfdump var=#form# /cfif !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleInput Test/title /head body cfajaximport tags=cfform,cfwindow cfform name=mainform action=form_test1.cfm cfinput name=test1 size=10 type=text cfinput type=submit name=submit value=submit /cfform cfwindow name=win1 source=form_test1_win.cfm initshow=true / /body /html (form_test1_win.cfm) script function updateit() { document.mainform.test1.value = document.winform.wintxt.value; } /script cfform name=winform TYPE SOMETHING: cfinput type=text name=wintxt size=10 onkeyup=javascript: updateit(); /cfform If you are using cfwindow than the window is on the same page. You should be able to use JS to control the value on the original form. Like: document.formName.name.value; Check out this demo I did: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm I think the concept is kind of the same. Click the new company link and a cfwindow opens. After the new company is inserted there is a close button that uses JS to update the company picklist on the original form. It then closes the window. I hope this helps. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Lynda.com released the first official CF8. Thank you Lynda!
Hi: Just wanted to inform you about something. I was searching for a good CF8 video tutorial and found out Lynda.com released an essential traning. It seems it covers many basic subjects. I hope they release the intermediate and advanced DVDs soon. Thank you LYNDA.COM :) i hope you folks find it interesting too. Thanks Benign ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfquery: quotes vs queryparam
Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery vs cfquery select * from table where name=cfqueryparam cfsqltype=cf_sql_varchar maxlength=255 value=#form.lastname#/ /cfquery Seems anything I throw at the quoted query gets escaped correctly... ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery: quotes vs queryparam
Rick Schmitty wrote: Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery Depends on the database and the configuration. Seems anything I throw at the quoted query gets escaped correctly... Have you played with characters your database considers escape characters? Do you know which characters that are? Do you know which characters that will be for every database your application will ever run on? Have you played with characters CF does not consider escape characters because CF evaluates their Unicode version, but your database considers escape characters because your database considers their ASCII version? Do you know which characters that are? Do you know which characters that will be for every database your application will ever run on? Do you expect a hacker to know more about these issues then you do? Do you like to take chances? Jochem ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285731 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Commonspot
Anyone have commonspot here htat upgraded to CF8and still have authoring capability?If so, could you shout back even offlist...quick problem I am seeing and want to make sure its just me. LOL Eric J. Hoffman Managing Partner 1940 Greeley Street South Suite 102 StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4101 mob: 651.245.2717 Adobe Solutions Partner Microsoft Certified Partner This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server problem getting records within date range
Hello Janet - thanks for the reply. I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. Thanks, CWB Use the WHERE not HAVING clause. Try something like SELECT ... FROM ... WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID ANDdbo.tblUserTransactionLog.Processed = convert(datetime, '08/01/2007', 101) AND dbo.tblUserTransactionLog.Processed = convert(datetime, '08/07/2007', 101) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery: quotes vs queryparam
Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone Or, if you really wanna get tricky and someone has debugging turned on, or you can guess field / table names: Lets say you have a fName and lName column outputting a list, and I can figure that out Now I replace form.lastname with this: test'; SELECT credit_card_num as fName, expireDate as lName FROM creditCards; Now instead of seeing a firstname / lastname directory, I see a list of all your credit cards in the database =) ALWAYS use cfqueryparam, or clean the crap out of any incoming variables to ensure they are not being exploited. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Rick Schmitty [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:57 PM To: CF-Talk Subject: cfquery: quotes vs queryparam Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery vs cfquery select * from table where name=cfqueryparam cfsqltype=cf_sql_varchar maxlength=255 value=#form.lastname#/ /cfquery Seems anything I throw at the quoted query gets escaped correctly... ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Setting session param in onRequestStart
Hey all, Had an interesting conundrum today. I wanted to param a session variable in Application.cfc, so naturally I placed the cfparam name=session.myvar default=false in onSessionStart. I quickly realized that this does not catch people whose sessions are already in progress. Since we pretty much have sessions running on our production server 24/7, there is never a time when I could post the updated Application.cfc and not get a bunch of myvar not defined in session errors. Solutions would be to a) restart the server or otherwise end all sessions (not viable), b) use structKeyExists(session,mvar) anywhere the variable is used, or c) place the cfparam name=session.myvar in onRequestStart. I chose c) as it is the most DRY (Don't Repeat Yourself) to implement, but I'm wondering if it is bad practice to param a session variable in onRequestStart, or if other folks have been in a similar situation and done anything differently. -- Josh ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285735 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 Commonspot (solved)
RTFM. Hmm. Sorry about the list pollution. On 8/8/07 2:14 PM, Eric Hoffan [EMAIL PROTECTED] wrote: Anyone have commonspot here htat upgraded to CF8and still have authoring capability?If so, could you shout back even offlist...quick problem I am seeing and want to make sure its just me. LOL Eric J. Hoffman Managing Partner 1940 Greeley Street South Suite 102 StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4101 mob: 651.245.2717 Adobe Solutions Partner Microsoft Certified Partner This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error when using Java class in Cold Fusion
Hello Every one I am getting the following error in my Coldfusion code . The error is as follow === Class coldfusion.runtime.java.JavaProxy can not access a member of class Search1 with modifiers My cold fusion code is as follow === cfobject type = Java action = Create class = Search1 name = searchObj / cfset ret = searchObj.search() and its giving error for cfset ret = searchObj.search() line ... Can anyone tell me what is the reason I have a Java class named Search1 and there is a public method in it with the following declaration ... public int search() throws Exception { .. .. .. .. } Thankyou ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery: quotes vs queryparam
Have you played with characters your database considers escape characters? Do you know which characters that are? Do you know which characters that will be for every database your application will ever run on? Have you played with characters CF does not consider escape characters because CF evaluates their Unicode version, but your database considers escape characters because your database considers their ASCII version? Do you know which characters that are? Do you know which characters that will be for every database your application will ever run on? Do you expect a hacker to know more about these issues then you do? Do you like to take chances? I'm sensing a theme Jochemperhaps you think the poster should use cfqueryparam?? ;-) LOL Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery: quotes vs queryparam
Pete Freitag had an amazing session at CFUinted about things like this. It's amazing what can be done using the query string. -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:17 PM To: CF-Talk Subject: RE: cfquery: quotes vs queryparam Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone Or, if you really wanna get tricky and someone has debugging turned on, or you can guess field / table names: Lets say you have a fName and lName column outputting a list, and I can figure that out Now I replace form.lastname with this: test'; SELECT credit_card_num as fName, expireDate as lName FROM creditCards; Now instead of seeing a firstname / lastname directory, I see a list of all your credit cards in the database =) ALWAYS use cfqueryparam, or clean the crap out of any incoming variables to ensure they are not being exploited. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Rick Schmitty [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:57 PM To: CF-Talk Subject: cfquery: quotes vs queryparam Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery vs cfquery select * from table where name=cfqueryparam cfsqltype=cf_sql_varchar maxlength=255 value=#form.lastname#/ /cfquery Seems anything I throw at the quoted query gets escaped correctly... ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error when using Java class in Cold Fusion
CF won't create the actual java object until you call it, so the lack of an error on the cfobject line may not mean that part went 100% right. Things to check: * The class itself needs to be declared as public (so, public class ) * Your class needs to have a public no-argument constructor (or no constructors at all, which would also be fine). If the Search1 class does have a constructor that requires arguments then call it using CF's trick with the object init(...) method. * I don't see any package name there, so that must mean that the Search1 class doesn't have a package line at the top of it. This is definitely a good idea to include but I don't think that is source of the problem. Hope that helps. Mark -Original Message- From: Tripura Kondabala [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 4:17 PM To: CF-Talk Subject: Error when using Java class in Cold Fusion Hello Every one I am getting the following error in my Coldfusion code . The error is as follow === Class coldfusion.runtime.java.JavaProxy can not access a member of class Search1 with modifiers My cold fusion code is as follow === cfobject type = Java action = Create class = Search1 name = searchObj / cfset ret = searchObj.search() and its giving error for cfset ret = searchObj.search() line ... Can anyone tell me what is the reason I have a Java class named Search1 and there is a public method in it with the following declaration ... public int search() throws Exception { ... ... ... ... } Thankyou ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server problem getting records within date range
I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. No, if I'm understanding correctly its not required here. The WHERE clause restricts the results to the given time frame and the aggregate + the GROUP BY gives you the max (per user) Janet ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery: quotes vs queryparam
Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone ColdFusion would escape that single quote, rendering this attempt pretty much useless and data'z would still be there. I'm not suggesting that you shouldn't use CFQUERYPARAM wherever possible, but it's not so simple to inject with a quoted string as it may seem at first glance (it can certainly be done). Now, if this were ASP.Net... -Justin Scott ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery: quotes vs queryparam
I'm not seeing how your example would do anything other than find zero records... Start with: cfqueryselect from table where lastname = '#form.lastname#'/cfquery Use your example: Form.lastname = test'; DROP TABLE table; So you get (with quote-doubling) select from table where lastname = ' test''; DROP TABLE table; ' And you will return all records with a last name of test'; DROP TABLE table; . If what you describe were true then you could never search for the name O'Connor. My take-away is that all ## expanded variables in a query should be quoted, even values that are supposed to always be numbers. Sure, cfqueryparam is safe and good and all of that, but it isn't like cfquery without it is necessarily an open door (if you're consistent). Mark -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 3:17 PM To: CF-Talk Subject: RE: cfquery: quotes vs queryparam Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone Or, if you really wanna get tricky and someone has debugging turned on, or you can guess field / table names: Lets say you have a fName and lName column outputting a list, and I can figure that out Now I replace form.lastname with this: test'; SELECT credit_card_num as fName, expireDate as lName FROM creditCards; Now instead of seeing a firstname / lastname directory, I see a list of all your credit cards in the database =) ALWAYS use cfqueryparam, or clean the crap out of any incoming variables to ensure they are not being exploited. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Rick Schmitty [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:57 PM To: CF-Talk Subject: cfquery: quotes vs queryparam Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery vs cfquery select * from table where name=cfqueryparam cfsqltype=cf_sql_varchar maxlength=255 value=#form.lastname#/ /cfquery Seems anything I throw at the quoted query gets escaped correctly... ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery: quotes vs queryparam
Well thats the thing, I know I should use cfqueryparam but the quoted string wont let commands through I made a test table and tried to hack it (with something that wouldnt delete but would prove sql injection) http://localhost/test.cfm?name=rick%20or%201=1 etc, but query 2 will just return an empty set with any injection attack I tried (using CF7 and MSSQL) Query 3 is obviously the wide open one cfparam name=url.name default=/ cfquery name=test1 datasource=pubs select * from dropme /cfquery cfdump var=#test1#/ cfquery name=test2 datasource=pubs select * from dropme where Lname='#url.name#' /cfquery cfdump var=#test2#/ cfquery name=test3 datasource=pubs select * from dropme where Lname=#url.name# /cfquery cfdump var=#test3#/ I guess at the end of the day I'd use queryparam on everything, but I'd still like to see a quoted string break with injection On 8/8/07, Peterson, Chris [EMAIL PROTECTED] wrote: Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone Or, if you really wanna get tricky and someone has debugging turned on, or you can guess field / table names: Lets say you have a fName and lName column outputting a list, and I can figure that out Now I replace form.lastname with this: test'; SELECT credit_card_num as fName, expireDate as lName FROM creditCards; Now instead of seeing a firstname / lastname directory, I see a list of all your credit cards in the database =) ALWAYS use cfqueryparam, or clean the crap out of any incoming variables to ensure they are not being exploited. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Rick Schmitty [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:57 PM To: CF-Talk Subject: cfquery: quotes vs queryparam Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery vs cfquery select * from table where name=cfqueryparam cfsqltype=cf_sql_varchar maxlength=255 value=#form.lastname#/ /cfquery Seems anything I throw at the quoted query gets escaped correctly... ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
action pages
I think this is mostly because I'm not thinking clearly today. I have a form where the fields are generated by a query a loop. I want the results of the form emailed to someone but I'm having a little trouble how to get the list into the email form. Katie ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: action pages
i think you're looking for FORM.fieldnames ? On 8/8/07, Katie Miller [EMAIL PROTECTED] wrote: I think this is mostly because I'm not thinking clearly today. I have a form where the fields are generated by a query a loop. I want the results of the form emailed to someone but I'm having a little trouble how to get the list into the email form. Katie ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery: quotes vs queryparam
OKlet's all agree to disagree about added security from CFQUERYPARAM (even though it does add security...na na na boo boo) ;-) Just remember it also: -allows for additional maxlength validation (beyond your form inputs) -uses BIND vars with DBs that support them to speed up queries -adds additional data type checking (beyond your form validation) -can insert a NULL in 1 line of code instead of: cfif NOT len(trim(MyVar)) NULL, cfelse #MyVar# /cfif So is that about enough said folks...not just for security...can we put this one to bedjust use the dang tag and it's all good ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Data source 'source_name' verification failed.????
Thanks, Loathe...That did it!! I got all the info I needed to solve the problem. Turns out I had different data sources within the same cftransaction and that is a CF error. I was catching the error but only showing the message. The cfcatch.Detail shows the REAL reason for the error Thanks again... Good save ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery: quotes vs queryparam
http://localhost/test.cfm?name=rick%20or%201=1 Was this an invitation to demonstrate techniques? If so, localhost ain't going to work for anybody else. If not, never mind. But I too would like to know more details about how this actually happens. I trust that I should use cfqueryparam... and do. But I think it valuable to know the specifics and not just blindly follow. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery: quotes vs queryparam
but it isn't like cfquery without it is necessarily an open door (if you're consistent). Mark Well not that open, unless somebody has opened the door with preserveSingleQuotes() for some reason. But one would hope that this was done with a clear purpose and understanding of the risks and appropriate action was taken to mitigate them. But this also does not say that cfquery ... is a closed, secure door either. It may take more effort to fool it, but I trust the experts when they say it can be fooled and that the consistent use of cfqueryparam... makes it more secure. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: action pages
Something like this should work: cfmail...type=html... cfloop collection=#form# item=field #field#: #form.[field]#br / /cfloop /cfmail Koen ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Develop an ecommerce site in CFMX 7 using Paypal
Hi All, This is my first ecommerce application using Paypal in CFMX7. I am using Ben Forta's CFWACK book as my reference. I have downloaded the PayflowPro SDK by creating a test account in PayPal. But I couldnot download the .jar file. Could anybody please help me with the steps to be followed in developing a ecommerce application in CFMX 7. Thanks -kpltpj ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery: quotes vs queryparam
.just use the dang tag and it's all good ;-) Cheers I do, but that doesn't mean I don't want to know more how SQL injection actually works and how cfqueryparam... is mitigating this risk. Just to make myself a more knowledge person. No it has nothing to do with that site that fired me in a most horrible manner in 2000 and I'm 80% sure has not improved their security in the past 7 years or so. I'm just curious, really I am. All jokes aside, I am actually interested in the knowledge. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server problem getting records within date range
Yes, that looks correct. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server problem getting records within date range
Hello again Janet, thank you for your help on this. It suare has had me stumped. So, like this? SELECT dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, max(dbo.tblUserTransactionLog.Processed) AS LastTransaction FROM dbo.tblSubscribers, dbo.tblUserTransactionLog WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND (dbo.tblUserTransactionLog.Processed = CONVERT(datetime, '08/01/2007', 101)) AND (dbo.tblUserTransactionLog.Processed = CONVERT(datetime, '08/07/2007', 101)) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username Thanks, CWB I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. No, if I'm understanding correctly its not required here. The WHERE clause restricts the results to the given time frame and the aggregate + the GROUP BY gives you the max (per user) Janet ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery: quotes vs queryparam
I hear you, but cfqueryparm was historically not all good... It disables query caching via cachedwithin. This was always a frustrating limitation and my understanding is that is has been fixed in CF8 but I haven't played with cf8 yet to know for sure. Query parameter binding also has down-sides... It makes debugging via SQL query profiling much harder (can't see the actual query parameters in an easy-to-read way); I don't recall if the query as seen in a CF-generated error message looks different too. I wish CF could allow the use of the cfqueryparam tag without all of the other side-effects (using binding, disabling caching) so that we really could say *always* use it... To be honest, the only reason I even got into this conversation is because someone was posting incorrect information about security, and people have a way of picking up on sensational information, even when (especially when!) it is wrong. Mark -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 4:13 PM To: CF-Talk Subject: RE: cfquery: quotes vs queryparam OKlet's all agree to disagree about added security from CFQUERYPARAM (even though it does add security...na na na boo boo) ;-) Just remember it also: -allows for additional maxlength validation (beyond your form inputs) -uses BIND vars with DBs that support them to speed up queries -adds additional data type checking (beyond your form validation) -can insert a NULL in 1 line of code instead of: cfif NOT len(trim(MyVar)) NULL, cfelse #MyVar# /cfif So is that about enough said folks...not just for security...can we put this one to bedjust use the dang tag and it's all good ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery: quotes vs queryparam
Oh no, I agree (the null is my fav of cfqueryparam). This was just a case of inheriting a large pile of code w/o cfqueryparams and the guy used '#quotedvars#' for his strings (and IDs for the matter) and me wanting to feel better about not trying to convert it all over... :) On 8/8/07, Bryan Stevenson [EMAIL PROTECTED] wrote: OKlet's all agree to disagree about added security from CFQUERYPARAM (even though it does add security...na na na boo boo) ;-) Just remember it also: -allows for additional maxlength validation (beyond your form inputs) -uses BIND vars with DBs that support them to speed up queries -adds additional data type checking (beyond your form validation) -can insert a NULL in 1 line of code instead of: cfif NOT len(trim(MyVar)) NULL, cfelse #MyVar# /cfif So is that about enough said folks...not just for security...can we put this one to bedjust use the dang tag and it's all good ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Develop an ecommerce site in CFMX 7 using Paypal
The PayPal SDK can be daunting to work with. I would recommend contacting Jared Rypka-Hauer about his PayPalMX components. You can get more info here including Jared's email: http://www.web-relevant.com/blogs/cfobjective/index.cfm?mode=entryentry=83AEB42F-BDB9-5320-E0207DD531806BA8 Rey... Prema Sekar wrote: Hi All, This is my first ecommerce application using Paypal in CFMX7. I am using Ben Forta's CFWACK book as my reference. I have downloaded the PayflowPro SDK by creating a test account in PayPal. But I couldnot download the .jar file. Could anybody please help me with the steps to be followed in developing a ecommerce application in CFMX 7. Thanks -kpltpj ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery: quotes vs queryparam
Gaulin, Mark wrote: I hear you, but cfqueryparm was historically not all good... It disables query caching via cachedwithin. This was always a frustrating limitation and my understanding is that is has been fixed in CF8 but I haven't played with cf8 yet to know for sure. It is. I wish CF could allow the use of the cfqueryparam tag without all of the other side-effects (using binding, disabling caching) so that we really could say *always* use it... Caching is fixed. What functionality is left if binding is removed? Jochem ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick Question about upgrading to CF 8
It's always better to do a clean install...but CF 8 will also import setting from CF7 (and I believe 6). Eric -Original Message- From: LHWH Interactive [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:37 AM To: CF-Talk Subject: Quick Question about upgrading to CF 8 I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I have no problem just upgrading 8 over 7, thinking that it will just update all relevant parts, but I just wanted to see what the consensus was, or if there's actually a somewhat official position... Any ideas? ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery: quotes vs queryparam
I wish CF could allow the use of the cfqueryparam tag without all of the other side-effects (using binding, disabling caching) so that we really could say *always* use it... Binding is not a side-effect, it is exactly what CFQUERYPARAM does. CFQUERYPARAM creates bound parameters. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse/CFEclispe
Welcome to the dark side Robert :-D hehehe Pretty soon I will be running that with Windows Server 2008 Beta...they just shipped that out with the Microsoft Action pack Quarterly update. I love SQL Server 2005...very nice interface. It took a lil bit to get used to...first time I used it it was sprung on us at a client...we were expecting 2k. You can also just get the Eclipse SDK and then get CFEclipse and whatever other plugins you want. There are also several different packaged distros that you can download. One of them allows you to configure what packages you want on their website and then you download the whole shebang. Eric -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 9:31 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe Thank You. I'll give it a try... downloading now! I'm figuring since I have a new kick-butt machine and I still have my old machine and environment, I'm going bleeding edge on the new one. IIS7, CF8, SQL Server 2005, CFECLISPE, etc. Why not for once be on the lead? Normally I wouldn't try that so boldly but my development platform is still intact on the old machine and production won't be in jeopardy. Keep your fingers crossed. So far I've gotten through the glitches as they've shown themselves. 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 . ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery: quotes vs queryparam
Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone ColdFusion would escape that single quote, rendering this attempt pretty much useless and data'z would still be there. I'm not suggesting that you shouldn't use CFQUERYPARAM wherever possible, but it's not so simple to inject with a quoted string as it may seem at first glance (it can certainly be done). Now, if this were ASP.Net... While you're absolutely correct about this specific example not working, you should read Jochem's most recent post very carefully. It is very difficult to guarantee that there is no character sequence that will break out of your single-quoted string, and there are people much smarter than me whose job (or hobby) it is to find these sequences and use them. I can spend my time worrying about that, or I can use CFQUERYPARAM. It's an easy choice, and it conforms to the security dictum deny, then allow - rather than identifying every potentially dangerous sequence, I can just use CFQUERYPARAM to prevent any possible SQL injection. CFQUERYPARAM tells the database that input values are not executable code. It denies the possibility of execution for any value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4