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: 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
Re: High CPU usage on HouseOfFusion.Com
Same here. And I agree the fan noise is really annoying :) - Original Message - From: Jim Rising [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, June 21, 2007 5:54 PM Subject: High CPU usage on HouseOfFusion.Com not sure if anyone else has noticed this, but on XP Pro IE6 and FF 2.0.0.4, when i go to the houseoffusion.com website, my CPU usage spikes and pins at about 60% utilization. i've had 4 other people using the same platform confirm this, though 2 others on Mac did not have the same effect. (go figure) i'm thinking it must be javascript or flash related. either way... there's something funky going on, and i can't stand to have my fan whirring on my laptop while i'm hanging out here. :) Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL sum question
I have a db table that stores basic historical page view data. Each day a task runs and inserts the date, a record of the pages viewed and a count of how many times each was viewed. It's easy to select the most viewed pages for a given date using: select pname,pagehit from tbl_log_page_count where CONVERT(char(8), logdate, 112) = #DateFormat(DateAdd('d',-1,now()),'mmdd')# order by pagehit desc What I'd like to be able to do is aggregate the data for a given date range so if my table had (date,hits,page) : 15-5-2007 | 2 | /index.cfm 15-5-2007 | 4 | /about-us.cfm 15-5-2007 | 3 | /not-about-us.cfm 14-5-2007 | 1 | /index.cfm 14-5-2007 | 6 | /about-us.cfm 14-5-2007 | 2 | /not-about-us.cfm I would like to be able to get this for the shown date range: 3 | /index.cfm 10 | /about-us.cfm 5 | not-about-us.cfm I can achieve what I want by creating a new query, looping over the distinct pagenames and summing all found hit counts in the time period but it's slow and seems messy. The date range bit isn't a problem but I can't figure out if it's possible to sum the pagehit column for each occurence of a page name. The closest I've got is below but this only sums the hitcount where the page name and hitcount match (i.e. if I have the same number of page views for a given page on multiple dates): select pname,sum(pagehit) as pagehit where dates between x and y group by pname, pagehit order by pagehit desc, pname Not sure if it's even possible to achieve what I want with a single query. Any ideas? Thanks Gareth ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278575 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 sum question
I really should have been able to figure that out. Hopefully I'll remember next time :) Many thanks Jochem. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, May 18, 2007 12:36 PM Subject: Re: SQL sum question Gareth Hughes wrote: select pname,sum(pagehit) as pagehit where dates between x and y group by pname, pagehit order by pagehit desc, pname select pname,sum(pagehit) as pageHitCumul where dates between x and y group by pname order by sum(pagehit) desc, pname Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client-side validation or Server-side Validation?
Then you have a caching issue. Anything inside noscript/noscript only displays with JS off. Enable JS, close your browser, reopen and try the page again. - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, April 17, 2007 8:48 PM Subject: RE: Client-side validation or Server-side Validation? Well to test my code I created a .cfm page and put this code in a table... td id=snownoscriptcfoutputflakes/cfoutput/noscript/td With JS disabled or with the noscript tags removed, flakes was shown on the screen. When I enabled JS and left the noscript tag in, flakes again was shown on the screen. Rick -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 17, 2007 2:53 PM To: CF-Talk Subject: RE: Client-side validation or Server-side Validation? What's the method to this madness? Do I set up some checking to see if JS is turned on and then execute certain code accordingly? Do I put alternate code (CF code that displays error messages) inside noscript tags to only run it if JS is disabled? There may be some confusion here. When thinking about this, it is very important to keep in mind that CF runs on the server and JS runs on the client AND NEVER THE TWO SHALL MIX! This can get muddled in one's mind when thinking about dynamic JS code generation and|or AJAX. But even here, the CF code runs on the server ONLY and the JS code runs on the client ONLY. So the short answer to your last question is NO. Putting CF code inside noscript tags would never work. The server has no idea if JS is enables and the client would have no idea what to do with the CF code. For me the highest level of looking at this is first build your application with NO JS. Just use old fashioned server/client request/response patterns to handle the validation. This is the fall back code for when JS is disabled. A user fills out the form, it is submitted to the server, the server does the validations, if problems our found they are displayed to the user and the user is allowed to fix them and resubmit the form. Then JS enhances can be added. These can short circuit the server/clent request/response cycle. Either validates the data in the client or makes AJAX request to the server for more complex validations with hidden requests. Then either report the errors and allow correction or allow the form to be submitted to the server where the validations are repeated. Yes repeated because your server can NOT rely on the user validations happened. What I am suggesting is that it's not a big stretch to create a framework/library/system that uses one set of rules to run both the server side validation and be used to create the JS code that will run the client side validation. Just make sure that the application works correctly without this code, then if it is disabled it just falls back to the client server round trips. The cfinput/cffrom functionality in CF exactly this already, but if one wants something more universal then one will need to expand on this foundation. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Client-side validation or Server-side Validation?
Not sure this will help/be of interest but this is what I do. On my page I set a bunch of eror messages like: cfset errorMsgs.userName = Sorry, the user name you have chosen is already in use cfset errorMsgs.firstName = Please enter a first name I use jQuery validation plugin with a hack called 'remote' which allows me to do ajax validation on fields it will benefit (checking user names are unique for example). So my JS looks something like: var validator = $('##myForm').validate({ event: 'blur', focusInvalid: false, rules: { userName: {required: true, remote: '/com/users.cfc?method=remotevalidationfield=username'}, firstName: {required: true} messages: { userName: #errormsg.userName #, firstName: #errormsg.firstName# } }); This takes care of client side validation if the user has JS enabled and gives the benefit of ajax validation on certain fields. The form is self-referencing (i.e. it posts to itself). Above all the HTML goodness I detect if the form has been submitted and, if it has, pass the form structure to 'addUserValidation' function in the user.cfc. This validates each form field, passing certain fields (such as userName) back to the 'remoteValidation' function to avoid doubling up code. The function creates a list of any fields that fail validation which is passed back to the form page which, in turn, loops through the list and presents the appropriate error messages (the same ones used for the JS) to the user. If the fields all validate, the form struct is passed to another function which performs all the logic (and then basically redirects the user to a success page). And that takes care of server-side validation. If the user has JS they get the benefit of real-time validation prior to submitting the form. If they don't have JS the form submits normally. JS or not the form goes through the server-side validation. So far this is working well for me. However there is one major, major flaw. The only way I could get the ajax to work was to make it syncronous which freezes the browser until a response is received. Under the circumstances (a dedicated CMS app on a dedicated server on an internal network) I'm happy for my client to take that risk :). Otherwise the ajax stuff would be out of the window until I figure out a way to do it asyncronously. Cheers! Gareth ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Printing a page without the standard header and footer
You could use CSS to hide the header and footer when printing (not 100% this syntax is correct): @media print{ .header{display:none;} ..footer{display:none;} } Or, something I've done is use custom comment tags above and below the required content. The print page then cfhttp's the original (referer), strips out everthing between the tags and inserts 'print appropriate' headers and footers. - Original Message - From: Curt Schryver [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 30, 2007 2:34 PM Subject: Printing a page without the standard header and footer I realize that I can remove and modify what is printed in the header and footer of a page within my browser, but what I'd rather figure out is if there's a way to launch a special page (a packing list) that I can print that will exclude these items. Thanks. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274197 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 (VMWare ESX Server Vs Physical Hardware)?
Yup, used it twice - once to convert a remote machine and once to convert the local machine. The remote machine failed but I suspect that was because of the old/strange raid storage it uses which I've heard can cause problems. The instance that did work is perfect. - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 26, 2007 5:59 PM Subject: Re: CF (VMWare ESX Server Vs Physical Hardware)? Other than those items (which are really all configuration issues) there's really nothing different. Your VM will be seen as a real PC in every way that matters. I've been using VMWare since it's inception (Desktop) and currently have deployed apps on VMWare Player (for laptop-based demos on the go), VMWare Server (staging and internal apps), and ESX2.0 (for a client) so I'm all for this I'm curious though, since we're on the subject, if anyone has tried the VMWare Converter http://www.vmware.com/products/converter/ to convert a physical machine into a virtual one. Anyone? I'd love to hear about it. Parallels has a similar tool, btw, for their Mac Desktop users that's on my agenda as soon as the new MacBook comes in... -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cflocation url=#CGI.SCRIPT_NAME#
cgi.script_name is the 'current' page so cflocation url=#CGI.SCRIPT_NAME# would send them to the page they are already on (basically refresh the page). Perhaps the page checks if they are logged in and does something if they are or, if they're not, logs them in and then 'refreshes' the page. - Original Message - From: Pete [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 21, 2007 8:13 AM Subject: cflocation url=#CGI.SCRIPT_NAME# Hi there I have a login page for an application and I am trying to find out what page a person goes to once they have successfully logged in. There is a line in the code: cflocation url=#CGI.SCRIPT_NAME# But I cant see anywhere in the code what page the user should go to. Does anyone have any ideas where I could look - how does #CGI.SCRIPT_NAME# work so as to send a user to a particular page. Thanks in advance. P ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx help
listFirst(/level-1/2nd-level/index.cfm,/) maybe? - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, March 20, 2007 9:03 PM Subject: RegEx help I'm really not very good at this, so I'm grateful for any help. I've been using one of those regex editors, but I just can't seem to get my head around the way it's used (regEx buddy). What I want to do is take a URL string, such as /level-1/2nd-level/index.cfm and just keep the string which is between the first set of / (level-1 no quotes). How would this be written? Thanks, Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273198 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 Login Faliure
I'll second that. IPSec can be complicated when you first set it up but is very flexible. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 14, 2007 4:23 PM Subject: Re: SQL Login Faliure Robert Rawlins - Think Blue wrote: Is there a method for closing the server so it only receives connections through the local server, It's only 2 or 3 of my CF apps that use it. Set an IPSec policy. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
As an FYI, 1.4.2_11 does not support the US DST changes as they apply to Canada. 1.4.2_13 does. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
Well, it was late when the last reply on this subject came through so I slept on it. And guess what? This morning all zones are reporting the correct time (on _11 _13). I would say this is a bug in the JVM. It was correctly identifying a zone was in new US DST but didn't factor it into the offset until 24hrs later. At least the problem appears to be resolved. Thanks to all who replied. Phew. :) - Original Message - From: Gareth Hughes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 12:35 AM Subject: Re: Timezone.cfc and US DST changes 'timezone hell'. Oh boy :) Thanks for the reply Paul, I'm reading the blog post now... - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 12:19 AM Subject: Re: Timezone.cfc and US DST changes Gareth Hughes wrote: because of the change in US DST when using the castFromServer method. The welcome to timezone hell: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can I use CLIENT variable storage with MySQL 5?
Not sure it will help but this the SQL to create the tables for MS SQL. Note the table names are CDATA and CGLOBAL (not cFdata and cFglobal): CREATE TABLE [dbo].[CDATA] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [app] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] CREATE TABLE [dbo].[CGLOBAL] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [lvisit] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] - Original Message - From: Jonathan Block [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 1:24 AM Subject: Can I use CLIENT variable storage with MySQL 5? I'm trying very hard to figure out how to get MySql 5 to work with CF client variable storage. I need that... its a requirement. Has anybody done it before? The CF administrator does not have it built in, and when I try to manually create CFDATA and CFGLOBAL, my front end app errors out with a 500 database error. Thank you, Jon ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
but the CFC is still broken as there is still an issue w/ dateConvert(). did the new one i sent work better? Sorry Paul, I didn't receive a new one from you. I tested using the older version I had and the latest version from your site. Both produced the same results. From what I understood of your blog post the issue with dateConvert() is that you can be x hours out during a DST switch over period. Using UTC or epoch as oppose to server time would resolve this. The thing I can't get my head around (and what made me think this was a JVM issue) is the fact that on Sunday: getRawOffset was reported correctly, -5 inDST was reported correctly, yes getDST was reported correctly, +1 getTZOffset was NOT reported correctly, -5 But today, offset is reported correctly as -4. Looking at the code, it doesn't look like dateConvert() factors in the above methods. This stuff is confsing :) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
is this your real email? yes. no, my blog talks about all cf datetime's being server datetimes which maybe not what you intended as far as tz goes. Ah, that makes sense... the dateConvert issue is that it doesn't take DST into account when converting. but now I'm confused again :) So how come castFromServer returns the correct itme (including DST)? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Timezone.cfc and US DST changes
Running 7.02 and 1.4.2_11 JVM and using Paul Hastings' timezone.cfc to calculate various times around the globe. It looks like I'm getting errors because of the change in US DST when using the castFromServer method. The time on the server is correct. If my understanding is correct I thought castFromServer generated the correct time factoring in DST. Can someone confirm/deny that the cast from server time is incorrect for EST (for example) on the timezone.cfc test page? http://www.sustainablegis.com/projects/tz/testTZCFC.cfm Am I supposed to manually factor in the DST difference (or is this something else)? Thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Thanks Kris I appreciate the confirmation. As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
Thanks Paul, I found that same page earlier but 1.4.2_11 is the latest officially recognised JVM by Adobe and although Sun say _13 is required they (sun and adobe) both say _11 supports the US DST changes: http://java.sun.com/developer/technicalArticles/Intl/USDST_Faq.html#jdkversion http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470 Having said that, according to my tests it looks as though _11 is returning the wrong info so I'll upgrade the JVM and see if it makes a difference. - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 11, 2007 8:36 PM Subject: RE: Timezone.cfc and US DST changes As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. Hate to burst your bubble but according to the Sun website, your JVM is too old... http://java.sun.com/developer/technicalArticles/Intl/USDST/ They state the version that has the correct timezone calcs is 1.4.2_13 Before you go any further, I'd update to the right version of the JVM and re-test. Paul ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
it's the same on _13 - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, March 11, 2007 8:36 PM Subject: RE: Timezone.cfc and US DST changes As an update it looks like the http://www.sustainablegis.com server is not patched with a recent enough JVM as it reports EST as NOT being in DST. My server, using the 1.4.2_11 reports that it is (which is correct). However, my server still reports the incorrect castfromserver time so I'm beginning to think this might be an issue with the cfc. Hate to burst your bubble but according to the Sun website, your JVM is too old... http://java.sun.com/developer/technicalArticles/Intl/USDST/ They state the version that has the correct timezone calcs is 1.4.2_13 Before you go any further, I'd update to the right version of the JVM and re-test. Paul ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Timezone.cfc and US DST changes
Yes :( To clarify, if you use _11 then EST is reported as being in DST. If you use _13 then EST is not reported as being in DST. This is as expected according to the alerts from Sun. The problem is, whether you use EST (_11) or America/New_York (_13), the returned time offset (and hence the time) calculated by the cfc (which, I believe, is calculated by the jvm) is incorrect. In other words, the cfc recognises the fact that the time zone is in DST but does not appear to factor it into the returned time. All other time zones in DST, other than those affected by the US changes, are reported correctly. it's the same on _13 That seems to be a problem then Have you read: http://java.sun.com/developer/technicalArticles/Intl/alert.html and http://java.sun.com/developer/technicalArticles/Intl/alertFurtherInfo.html Paul ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Timezone.cfc and US DST changes
'timezone hell'. Oh boy :) Thanks for the reply Paul, I'm reading the blog post now... - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, March 12, 2007 12:19 AM Subject: Re: Timezone.cfc and US DST changes Gareth Hughes wrote: because of the change in US DST when using the castFromServer method. The welcome to timezone hell: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entryentry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduled Task Times not saving
Are you sure the task times are completely blank? I've seen this where for some reason lots of space was put in before the actual time. If you put your cursor in the time field and do select all copy, do you get anything when you paste the result into notepad (or similar). - Original Message - From: Dana Kowalski [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 07, 2007 3:58 PM Subject: Scheduled Task Times not saving Suddenly yesterday after four months all my scheduled tasks have gone bonkers and are running up to 8 times a day at random times with no logical interval. All of the tasks were set up as recurring tasks running daily at x:xx. When I go into each task now the time for daily at is blanked out. If I enter a new time it saves fine but I go back in and its blank again. any ideas? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271892 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 DSN, text data type, CLOB is required?
You don't have to enable clob to use text or ntext data types but if you don't then CF will crop any input to those fields that exceeds a certain length. I can't remember what the length is that CF crops at but I have experienced this. Not sure about blob. - Original Message - From: Jacob Munson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 07, 2007 10:57 PM Subject: SQL Server DSN, text data type, CLOB is required? A co-worker of mine just told me that in order to use the text data type in SQL Server, you have to enable CLOB and BLOB in the data source in CFAdmin. Is this true? I need to use the text data type because my users potentially could enter a large amount of text ( 8000 chars). -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
7.02 no such classpath error
I'm running CF 7,0,2,142559 (Java 1.4.2_11) standard edition. I've noticed that I'm getting: no such classpath element: C:\CFusionMX7\runtime/../../classes in c:\CFusionMX7\runtime\logs\coldfusion-err.log. I've manually edited the jvm.config to remove the {application.home}/../../classes entry but everytime I edit the Java and JVM settings page in CFAdmin and restart I get the error again and the entry is reentered in the jvm.config. In my JVM Arguments in CF Admin I have: -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib Is this correct? Could someone have a look at their settings (on a 7.02 box that isn't throwing this error) and tell me what their settings are? I thought this was fixed in 7.02? Am I still supposed to install a patch or something? Thanks ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 7.02 no such classpath error
Blimey. I'll remember that, thanks Andy. Annoying that Adobe would specifically claim this bug is fixed when it isn't though. - Original Message - From: Andy Allan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, March 02, 2007 3:13 PM Subject: Re: 7.02 no such classpath error NEVER edit your Java/JVM page in the ColdFusion Administrator. It corrupts the jvm.config file and it also hides various JVM arguments, which because they aren't directly visible to you can cause CF not to restart. ALWAYS edit manually. Andy On 02/03/07, Gareth Hughes [EMAIL PROTECTED] wrote: I'm running CF 7,0,2,142559 (Java 1.4.2_11) standard edition. I've noticed that I'm getting: no such classpath element: C:\CFusionMX7\runtime/../../classes in c:\CFusionMX7\runtime\logs\coldfusion-err.log. I've manually edited the jvm.config to remove the {application.home}/../../classes entry but everytime I edit the Java and JVM settings page in CFAdmin and restart I get the error again and the entry is reentered in the jvm.config. In my JVM Arguments in CF Admin I have: -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib Is this correct? Could someone have a look at their settings (on a 7.02 box that isn't throwing this error) and tell me what their settings are? I thought this was fixed in 7.02? Am I still supposed to install a patch or something? Thanks ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Ugly Verity
Does anyone else on the list use the Verity Unicode pack? I'm using it and the indexing performance is appallingly bad, perhaps 50 times (or more) slower than indexing an Englishx collection. If given a multiple row query to index it will consume way too much memory and eventually timeout. Indexing a 1000 row query would take hours. It's causing all sorts of problems (obviously) to the extent where I'm faced with writing hideous work-arounds to prevent it from killing the server. I can't find anything on the web about this so I wonder, could I be doing something wrong? Is anyone else using the Unicode pack? Can you confirm / deny the performance difference? Thanks Gareth ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ugly Verity
Yup, just text, but the query has extra columns added prior to indexing which is one of the reasons why SQL Full Text wouldn't work. I've already got the Lucence CFCs but switching would be a major PIA. I guess that's why I'm asking if anyone else is using the Unicode Pack - if it did what it was supposed to do it would serve my purposes perfectly but, at the moment, it seems like it's very, very badly integrated with the Verity engine. - Original Message - From: Russ [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 01, 2007 8:12 PM Subject: RE: Ugly Verity What kind of data are you indexing? Is it just text? You might want to look into SQL Server Full Text Search or Lucene. It's fairly easy to write some wrapper CFC's around lucene's java classes, and you can achieve much better performance, I believe, then Full Text Search or Verity. Russ -Original Message- From: Gareth Hughes [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 2:28 PM To: CF-Talk Subject: Ugly Verity Does anyone else on the list use the Verity Unicode pack? I'm using it and the indexing performance is appallingly bad, perhaps 50 times (or more) slower than indexing an Englishx collection. If given a multiple row query to index it will consume way too much memory and eventually timeout. Indexing a 1000 row query would take hours. It's causing all sorts of problems (obviously) to the extent where I'm faced with writing hideous work-arounds to prevent it from killing the server. I can't find anything on the web about this so I wonder, could I be doing something wrong? Is anyone else using the Unicode pack? Can you confirm / deny the performance difference? Thanks Gareth ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP
You could try installing a later JVM. I posted instructions a while ago: http://www.houseoffusion.com:80/groups/CF-Talk/message.cfm/messageid:269082 - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 21, 2007 3:53 PM Subject: HELP One of our clients had the idea to clean up their web server and now the CF service wont start. I found this error in this log file: C:\CFusionMX\runtime\logs\default-err.log Error: no `server' JVM at `C:\Program Files\Java\j2sdk1.4.2_09\jre\bin\server\jvm.dll'. Error: no `server' JVM at `C:\Program Files\Java\j2sdk1.4.2_09\jre\bin\server\jvm.dll'. Any tips on getting CF to run again? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JVM / JRE update
I need to update a customers windows 2003 server to 1.4.2_11 JVM (currently 1.4.2_05 / CF 7.01). I have noticed the server has the v5 JRE installed separately in C:\Program Files\Java\jre1.5.0_06. Assuming that I install only the development tools and NOT the public JRE does anyone know of any reason why this could cause problems for whatever might be using the v5 JRE? I'm thinking along the lines of the install adjusting system variables for example. My guess it is should be fine but I'd appreciate other's opinions before I go ahead. Thanks Gareth ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JVM / JRE update
Cool. Thanks all. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 07, 2007 2:29 PM Subject: RE: JVM / JRE update I need to update a customers windows 2003 server to 1.4.2_11 JVM (currently 1.4.2_05 / CF 7.01). I have noticed the server has the v5 JRE installed separately in C:\Program Files\Java\jre1.5.0_06. Assuming that I install only the development tools and NOT the public JRE does anyone know of any reason why this could cause problems for whatever might be using the v5 JRE? I'm thinking along the lines of the install adjusting system variables for example. My guess it is should be fine but I'd appreciate other's opinions before I go ahead. It'll be fine. The JVMs won't affect each other. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JVM / JRE update
JRE v5 is not supported and AFAIK there are issues with some CF functionality when it's used. Assuming you're running windows, below are the instructions I wrote for a client to upgrade to 1.4.2_11. No guarantees they'll work for you though :( 1) Stop all ColdFusion Services (if ColdFusion MX 7 Application Server fails to stop, kill the jrun.exe process in task manager) and the World Wide Web Publishing Service (IIS) 2) Run j2sdk-1_4_2_11-windows-i586-p.exe. Choose to install 'Development Tools' only and change the install path to C:\CFusionMX7\runtime\j2sdk1.4.2_11\ 3) When install completes, do not restart server, open C:\CFusionMX7\runtime\bin\jvm.config in notepad (or similar). Comment (#) the line that says java.home=C:/CFusionMX7/runtime/jre and add a new line below that says java.home=C:/CFusionMX7/runtime/j2sdk1.4.2_11/jre. It should look like: #java.home=C:/CFusionMX7/runtime/jre java.home=C:/CFusionMX7/runtime/j2sdk1.4.2_11/jre 4) Now restart the server 5) Once restarted, browse to http://x.x.x.x/cfide/administrator (where x.x.x.x is the server ip) and login to the CF Admin. Choose 'Settings Summary' from the left menu to confirm that the Java Version is 1.4.2_11 Hope it helps Gareth - Original Message - From: sam komo [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, February 07, 2007 10:29 PM Subject: Re: JVM / JRE update Hi All, Our production server CF7.02 server setting for Java JVM says 1.4.2_05 even though I installed the JRE v5. Will this Handle the Daylight savings time issue?. Also, I installed the 1.4.2_11 on my test server, changed the CF to point to the new version but my CF froze. Luckly I backed up my the xml file. How can I safely upgrade my test servers? Thanks Sam ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: website thumbnail
cfx_url2bmp from efflare creates an uncompressed bmp which can then be converted to a thumbnail: http://efflare.com/download/ - Original Message - From: Richard Cooper [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 15, 2006 1:48 PM Subject: website thumbnail Is there any way of dynamically making thumbshots of websites using MX 7? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Get DNS servers programatically
Or nslookup on windows: cfexecute name=nslookup.exe timeout=5 arguments=-q=ns houseoffusion.com variable=dnsinfo / cfdump var=#dnsinfo# - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 19, 2006 7:51 PM Subject: Re: Get DNS servers programatically lists wrote: Hello, I'm looking for a way to obtain the DNS servers of a domain without having to do a whois and parsing the whois information. I have been able to get the IPs of www.domain.com but can't get ns1.hostingprovider.com and ns2.hostingprovider.com from domain.com if those are the NS records... Anybody have any insight? Thanks, -Blaine ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Select distinct on multiple columns
I'm turning my brain to mush with a SQL conundrum and wonder if anyone can offer some help. I keep a record of what people searched for, the date/time they searched for it and the page they were on when they searched. My table consists of three columns 'search_criteria', 'search_datetime' and 'search_page'. What I can't figure out is how to produce reports using distinct values such as 'the 10 most recent searches' where I get ten unique results even if there are duplicates in the most recent db entries. For example let's say the most recent 10 entries includes the search phrase 'foo' 3 times - if I selected TOP 10 I'd actually only have 8 unique results. I've tried using DISTINCT in various ways but, because I need the 'search_datetime' and 'search_page' columns in the select list, the 'foo' entries are all considered unique. So, I'm wondering if it's possible to get unique values for my search phrases but include the other column data? I'm stuck. Any ideas? Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Select distinct on multiple columns
That's so simple compared to the things I'd been trying! It works perfectly and as Brad suggested I can easily get counts as well which is a major bonus. Many thanks Jim. Mike, I tried your suggestion but it didn't seem to produce the desired result. I'll tinker with it though to see what I can learn. Teddy, I'm not too familiar with views so my attempt produced incorrect results. As above though, I'll play with it to see what I can learn. Thanks for the help, its most appreciated. - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 18, 2006 4:05 PM Subject: Re: Select distinct on multiple columns Maybe something like... SELECT TOP 10 search_criteria, search_page, max(search_datetime) AS latestdate FROM tblSearches GROUP BY search_criteria, search_page ORDER BY latestdate DESC ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduler Problem
Are you running it from a browser on your local machine or the server? You need to try it on the server if possible. - Original Message - From: George Owns [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, October 06, 2006 7:51 AM Subject: RE: Scheduler Problem If I run the template from the browser it works properly (using the servers domain name) Adkins, Randy [EMAIL PROTECTED] schrieb: Sounds like a DNS issue not a CF Scheduler issue. What happens if you run the template manually using your browser? Can you use the Domain Name to access any other templates in the root folder? - Was ist Glück? Schlafen Fische überhaupt? Die Antworten gibt's auf Yahoo! Clever. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduler Problem
Then it is a DNS issue. You need to either: A) make the CF server use an internal DNS server which has the records for your domain using the internal IP address or B) Assuming this is a windows CF server, go to C:\WINDOWS\system32\drivers\etc\ where you will find a file called 'hosts' (no extension). Open 'hosts' in notepad and add the line: 192.168.1.2test.server.com Save the file, restart CF and your task should work. - Original Message - From: George Owns [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, October 06, 2006 8:25 AM Subject: Re: Scheduler Problem I've tried to run it from the server, but it doesn't work. It throws an error: Windows can not find serverDomain ... Gareth Hughes [EMAIL PROTECTED] schrieb: Are you running it from a browser on your local machine or the server? You need to try it on the server if possible. - Was ist Glück? Schlafen Fische überhaupt? Die Antworten gibt's auf Yahoo! Clever. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduler Problem
Sounds like the server (or at least CF) is unaware of the DNS. Either point the CF server to an internal DNS server that uses the local IP info or put the info in the hosts file on the CF server. Then restart CF. - Original Message - From: George Owns [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 05, 2006 10:04 AM Subject: Scheduler Problem Hi, I'm working on a internal CF7 development server here. My problem is: Let's say i've got a template called 'template.cfm' in the main root. If I want to schedule a task by using the url of the server like: http://test.server.com/template.cfm Coldfusion throws an error if I want to run this scheduled task. But: If I use the internal IP of the server like: 192.168.1.2/template.cfm for the scheduled task and then run it, it works. Does anybody has an explanation for that? Btw: Sorry for my bad english, I'm german. Don't hate me :-) - Yahoo! Messenger - kostenlos* mit Familie und Freunden von PC zu PC telefonieren. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: verity spider
Ah, I see. My preference is to index the DB which avoids getting header/footer/menu text in the index and run a seperate index for files such as PDF etc. Anyway, do you have any other collections and do they work? If not, I'd set up a test collection to check the error is with your collection only. For example, this should return an empty query: cfcollection action=create collection=testx path=C:\CFusionMX7\verity\collections cfsearch name=testxResult collection=testx criteria=a cfdump var=#testxResult#cfabort If this does produce an empty query is it possible to then populate the testx collection with the spider? - Original Message - From: George Lu [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 04, 2006 11:46 PM Subject: Re: verity spider Thank you Gareth. I prefer to use vspider since cfindex will index all docs linked or not linked. I want user to be able just search and see everything just http linked or generated html page NOT the source code. On 04/10/06, Gareth Hughes [EMAIL PROTECTED] wrote: From the verity people: --- Error -1705 = Node is offline. You get this error when the K2 server and collection is not online. --- If the collection has been successsfully created and registered you might try restarting Verity to see if that clears the error. Have you tried using cfindex instead of verity spider? Try using cfcollection (as you have below) to create a new, empty collection then use cfindex to build the collection. I'd suggest trying it on a small test directory rather than your entire intranet in the first instance: cfindex collection=snippets action=update type=path key=c:\inetpub\wwwroot\cfdocs\snippets urlpath=http://localhost/cfdocs/snippets recurse=no extensions=.* - Original Message - From: George Lu [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 04, 2006 6:53 AM Subject: verity spider Currently I'm using K2 server to index and search our intranet. Indexing and searching is very slow and it is not working with dynamic content such as ..cfm. I've found very limited documentation using Google. Anyway, I've managed to create and index a collection using vspider. e.g. Vspider -collection e:\CFusionMX7\verity\collections\test -start http://localhost/test/ -style e:\CFusionMX7\verity\Data\stylesets\ColdFusionVspider And then I've tried to use CF administrator to register the collection. It fails. I've created a file contains: cfflush cfcollection action=create collection=test path=e:\CFusionMX7\verity\collections language=English CATEGORIES=no cfflush It has successfully registered the collection 'test' in the CF administrator. However, when I search the collection I've got this error: There was a problem executing the CFSearch tag with the following collections. Collection (status code): test (-1705) The error occurred in E:\webroot\IntraDev\Functions\Search\SearchAction.cfm: line 34 32 : collection=test MAXROWS=300 33 : type=internet 34 : criteria=#searchstring# Can anyone please help? Thanks, George ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: verity spider
From the verity people: --- Error -1705 = Node is offline. You get this error when the K2 server and collection is not online. --- If the collection has been successsfully created and registered you might try restarting Verity to see if that clears the error. Have you tried using cfindex instead of verity spider? Try using cfcollection (as you have below) to create a new, empty collection then use cfindex to build the collection. I'd suggest trying it on a small test directory rather than your entire intranet in the first instance: cfindex collection=snippets action=update type=path key=c:\inetpub\wwwroot\cfdocs\snippets urlpath=http://localhost/cfdocs/snippets recurse=no extensions=.* - Original Message - From: George Lu [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 04, 2006 6:53 AM Subject: verity spider Currently I'm using K2 server to index and search our intranet. Indexing and searching is very slow and it is not working with dynamic content such as ..cfm. I've found very limited documentation using Google. Anyway, I've managed to create and index a collection using vspider. e.g. Vspider -collection e:\CFusionMX7\verity\collections\test -start http://localhost/test/ -style e:\CFusionMX7\verity\Data\stylesets\ColdFusionVspider And then I've tried to use CF administrator to register the collection. It fails. I've created a file contains: cfflush cfcollection action=create collection=test path=e:\CFusionMX7\verity\collections language=English CATEGORIES=no cfflush It has successfully registered the collection 'test' in the CF administrator. However, when I search the collection I've got this error: There was a problem executing the CFSearch tag with the following collections. Collection (status code): test (-1705) The error occurred in E:\webroot\IntraDev\Functions\Search\SearchAction.cfm: line 34 32 : collection=test MAXROWS=300 33 : type=internet 34 : criteria=#searchstring# Can anyone please help? Thanks, George ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Rather big log
Thanks Nick / Tom So the bug prevents the log rotation but I can fix that manually. Cool. But I don't think the same bug explains why I'm getting errors trying to use the registry for client storage. I switched storage to cookies and the errors have stopped - is that considered acceptable practice or would I be better off setting up a DB? Thanks for the quick replies. Gareth - Original Message - From: Nick Tong - TalkWebSolutions.co.uk [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 26, 2006 11:54 AM Subject: Re: Rather big log Hi Gareth, Check out this post http://www.succor.co.uk/index.cfm/2006/5/2/Massive-CFJrun-log-files and read the comments. It's a bug with jrun. On 26/09/06, Gareth Hughes [EMAIL PROTECTED] wrote: Ooooh dear. I just checked in C:\CFusionMX7\runtime\logs\ and... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Rather big log
Ooooh dear. I just checked in C:\CFusionMX7\runtime\logs\ and the coldfusion-out.log is a whopping 500MB. It is packed to the rafters with nearly 2 million lines like these: 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\urltoken: Windows error number 2 occurred.The handle is invalid. 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\lastvisit: Windows error number 2 occurred.The handle is invalid. 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\timecreated: Windows error number 2 occurred.The handle is invalid. 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\hitcount: Windows error number 2 occurred.The handle is invalid. 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\cftoken: Windows error number 2 occurred.The handle is invalid. 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\cfid: Windows error number 2 occurred.The handle is invalid. The box uses the default registry setting for client variables and CF runs under the local system account. Anyone have any ideas what might be causing this? Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Rather big log
Great info Adam, serioulsy appreciated. Thanks for the other replies too. This is a valuable lesson learned for me :) Thanks again. - Original Message - From: Adam Churvis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 26, 2006 2:31 PM Subject: Re: Rather big log Take a look at your registry at HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients\, but be prepared to wait a while as it draws the tree, because you're probably packed to the rafters with client variable keys. Check this out: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_17881 If you get an error running the Purge link, you'll need to set the maximum allowable size of your Registry higher to accommodate its own internal logging system's need to record each change to the Registry. Don't set your Registry size too high or you might cause a problem, and make sure to set it back down once you're done. Though it may not prompt you to restart after changing sizes, I've been advised that it's a good idea anyway. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Gareth Hughes To: CF-Talk Sent: Tuesday, September 26, 2006 7:32 AM Subject: Re: Rather big log Thanks Nick / Tom So the bug prevents the log rotation but I can fix that manually. Cool. But I don't think the same bug explains why I'm getting errors trying to use the registry for client storage. I switched storage to cookies and the errors have stopped - is that considered acceptable practice or would I be better off setting up a DB? Thanks for the quick replies. Gareth - Original Message - From: Nick Tong - TalkWebSolutions.co.uk [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 26, 2006 11:54 AM Subject: Re: Rather big log Hi Gareth, Check out this post http://www.succor.co.uk/index.cfm/2006/5/2/Massive-CFJrun-log-files and read the comments. It's a bug with jrun. On 26/09/06, Gareth Hughes [EMAIL PROTECTED] wrote: Ooooh dear. I just checked in C:\CFusionMX7\runtime\logs\ and... ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PDFBox
Anyone using PDFBox to extract PDF content on CF 7 (standard)? I'm doing it on CF 6 but does anyone know of any issues with using it on 7? If anyone knows alternative solutions for extracting pdf text on 7 that would be great too :) Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDFBox
Cool, thanks for the info Paul. I'll give it a try then. And no James, unfortunately not using Oracle. Thanks for the heads up though. Cheers - Original Message - From: Paul Hastings [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 13, 2006 10:32 AM Subject: Re: PDFBox Gareth Hughes wrote: Anyone using PDFBox to extract PDF content on CF 7 (standard)? I'm doing it on CF 6 but does anyone know of any issues with using it on 7? beside it not doing arabic/farsi unicode text it works ok under cf7 from our limited testing in july. note that hebrew appears to work ok, so it's not an RTL thing. i suppose the adobe XPAAJ lib might also work for this (though i've never tried it). ben's published a few articles/tags on using this library. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FckEditor / JS
You'll need to pull this apart to get it to work for you but below is the JS I use to check an FCK instance isn't empty. So, you should be able to update your div with secondFrame.body.innerHTML. firstFrame = document.getElementById(FCKeditor1___Frame).contentWindow.document; secondFrame = firstFrame.getElementById(eEditorArea).contentWindow.document; if ((secondFrame.body.innerHTML==null) || (secondFrame.body.innerHTML=='')) { alert(Stupid user alert); } - Original Message - From: Bobby Hartsfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 3:48 PM Subject: OT: FckEditor / JS What I have is a textarea. As you type in the text area, a div tag is updated with the textarea's content creating a 'live preview'. I need to change that textarea to the FCKEditor but keep the live preview. The problem is that I don't have the same control over the onchcnage and onkeyup attributes of the hidden field that the FCKEditor creates as I do the normal textarea. I tried using setAttribute('onchange'), 'myfunction()') on the hidden field but no such luck. Can anyone offer any help here? ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/437 - Release Date: 9/4/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FckEditor / JS
Huh, that's a bit neater than the method I'm using :) I see what you mean now but not sure how you'd do it. Maybe a key event listener on document.window that polls the FCK instance and updates the div? No idea if that's actually possible though, sorry. - Original Message - From: Bobby Hartsfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 4:23 PM Subject: RE: FckEditor / JS Hi Gareth. The problem is actually triggering a function when the content of the editor changes not actually reading the content. As for just reading the content, I figured that would be stored in the hidden text field that FCK creates. If I'm wrong about that, then I'm pretty sure this will get the content at anytime: FCKeditorAPI.__Instances['instanceNameHere'].GetHTML(); ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Gareth Hughes [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 11:18 AM To: CF-Talk Subject: Re: FckEditor / JS You'll need to pull this apart to get it to work for you but below is the JS I use to check an FCK instance isn't empty. So, you should be able to update your div with secondFrame.body.innerHTML. firstFrame = document.getElementById(FCKeditor1___Frame).contentWindow.document; secondFrame = firstFrame.getElementById(eEditorArea).contentWindow.document; if ((secondFrame.body.innerHTML==null) || (secondFrame.body.innerHTML=='')) { alert(Stupid user alert); } - Original Message - From: Bobby Hartsfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 3:48 PM Subject: OT: FckEditor / JS What I have is a textarea. As you type in the text area, a div tag is updated with the textarea's content creating a 'live preview'. I need to change that textarea to the FCKEditor but keep the live preview. The problem is that I don't have the same control over the onchcnage and onkeyup attributes of the hidden field that the FCKEditor creates as I do the normal textarea. I tried using setAttribute('onchange'), 'myfunction()') on the hidden field but no such luck. Can anyone offer any help here? .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/437 - Release Date: 9/4/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
valuelist and variable column name
I'm struggling to get ValueList to work on a column name which is a variable: cfset varColumnName = actualColumnName cfdump var=myQuery[varColumnName][1] !--- this line works --- cfset myList = valueList(myQuery[varColumnName]) !--- this line doesn't work --- I thought the square bracket notation should work here but apparently not. Does anyone know the best way to do this? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: valuelist and variable column name
Not sure what you're suggesting here, you've only got one square bracket. But I've tried as many combinations as I can think of with wrapping the brackets around the column name, the query and column name, with dot, without dot etc and I can't make it work. Evaluate? - Original Message - From: srinivas ganta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, August 28, 2006 12:59 PM Subject: Re: valuelist and variable column name Hi Hughes Try this cfset myList = valueList(myQuery.varColumnName]) Srinivas On 8/28/06, Gareth Hughes [EMAIL PROTECTED] wrote: I'm struggling to get ValueList to work on a column name which is a variable: cfset varColumnName = actualColumnName cfdump var=myQuery[varColumnName][1] !--- this line works --- cfset myList = valueList(myQuery[varColumnName]) !--- this line doesn't work --- I thought the square bracket notation should work here but apparently not. Does anyone know the best way to do this? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valuelist and variable column name
Ah, thanks Mike, I'll work around it. Srinivas, evaluate doesn't work either but thanks anyway. - Original Message - From: Dawson, Michael [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, August 28, 2006 1:18 PM Subject: RE: valuelist and variable column name I think this is one of those instances where it just won't work. I ran across this issue a year or so back. I'm pretty sure it was with the valueList() function. M!ke -Original Message- From: Gareth Hughes [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 7:13 AM To: CF-Talk Subject: Re: valuelist and variable column name Not sure what you're suggesting here, you've only got one square bracket. But I've tried as many combinations as I can think of with wrapping the brackets around the column name, the query and column name, with dot, without dot etc and I can't make it work. Evaluate? - Original Message - From: srinivas ganta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, August 28, 2006 12:59 PM Subject: Re: valuelist and variable column name Hi Hughes Try this cfset myList = valueList(myQuery.varColumnName]) Srinivas On 8/28/06, Gareth Hughes [EMAIL PROTECTED] wrote: I'm struggling to get ValueList to work on a column name which is a variable: cfset varColumnName = actualColumnName cfdump var=myQuery[varColumnName][1] !--- this line works --- cfset myList = valueList(myQuery[varColumnName]) !--- this line doesn't work --- I thought the square bracket notation should work here but apparently not. Does anyone know the best way to do this? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valuelist and variable column name
Nice. Thanks James. - Original Message - From: James Holmes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, August 28, 2006 1:39 PM Subject: Re: valuelist and variable column name Why use evaluate() as a fudge for valueList() when you can just use arrayToList()? cfset myList = arrayToList(myQuery[varColumnName]) On 8/28/06, Gareth Hughes [EMAIL PROTECTED] wrote: Not sure what you're suggesting here, you've only got one square bracket. But I've tried as many combinations as I can think of with wrapping the brackets around the column name, the query and column name, with dot, without dot etc and I can't make it work. Evaluate? - Original Message - From: srinivas ganta [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, August 28, 2006 12:59 PM Subject: Re: valuelist and variable column name Hi Hughes Try this cfset myList = valueList(myQuery.varColumnName]) Srinivas On 8/28/06, Gareth Hughes [EMAIL PROTECTED] wrote: I'm struggling to get ValueList to work on a column name which is a variable: cfset varColumnName = actualColumnName cfdump var=myQuery[varColumnName][1] !--- this line works --- cfset myList = valueList(myQuery[varColumnName]) !--- this line doesn't work --- I thought the square bracket notation should work here but apparently not. Does anyone know the best way to do this? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Clearing out cfclasses folder
I have an aging windows 2000 server (CF 6.1) where disk space is at a premium. The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder is taking up a lot of space (40,000 files) and I'm sure many of the files are from pages and sites that no longer exist. Can anyone tell me if it would be ok to clear out the cfclasses folder and just let it refill as needed. Does anyone know of any problems (other than the initial performance hit) with doing this? Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing out cfclasses folder
Thanks for the answers all. I've taken the easy option of deleting everything and leaving 'Save Class Files' turned on. I'll monitor the number of files over the next week or so and may turn it off if the number of files grows huge again. Never occured to me their would performance issues with lots of files. Thanks for the tip. Gareth - Original Message - From: Andy Allan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, August 16, 2006 3:58 PM Subject: Re: Clearing out cfclasses folder If you've got that many files, then 1) Untick Save Class Files from the CFAdmin 2) Delete the files. Wen you've got as many files as that, it's actually faster for CF to compile the file every time than for it to go trawl through 40,000 files on disk to find the right one. Andy On 16/08/06, Gareth Hughes [EMAIL PROTECTED] wrote: I have an aging windows 2000 server (CF 6.1) where disk space is at a premium. The C:\CFusionMX\wwwroot\WEB-INF\cfclasses folder is taking up a lot of space (40,000 files) and I'm sure many of the files are from pages and sites that no longer exist. Can anyone tell me if it would be ok to clear out the cfclasses folder and just let it refill as needed. Does anyone know of any problems (other than the initial performance hit) with doing this? Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Some questions on CF7 Verity language packs
Hi All I've tried looking through the docs and Google results surrounding this topic but I'm left a little confused. Any info appreciated. What purpose do the Verity language packs serve exactly? Are they required just so Verity can read documents in the specified language or are they used so Verity can interpret the content and therefore offer spelling suggestions etc? On a similar note are they required to enable Verity just to output the title / summary content in the specific language? Does a collection have to be specified as being in a particular language? For example, If I wanted to search some Russian documents and return the search results in Russian do I have to have a dedicated Russian language collection? Likewise, can I have a single collection that uses multiple languages with each language in a different category? For example say I had example.com (English) and example.com/jp (Japanese) could I have a collection that returns results in the /jp section for both Japanese and English pages using the same collection? What happens if I index non-English content in an English collection (or vice versa)? Is the content ignored by Verity or does it return nonsense results? What about if I have the Unicode language pack installed, does that change things? If I have multiple language collections on one server would I need to install anything other than the Unicode pack (to search and return Japanese docs for example) or do I need the individual packs in addition to the Unicode pack? Sorry, lots of questions! Any clues would be appreciated though, I'm writing a proposal where having a better understanding of this would really help me out. Thanks Gareth ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246771 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OOP, why me?
I thought this thread had gone quiet until I realised the whole list was quiet and being blocked by SpamCop... Mike and Isaac, sincere thanks for the detailed responses. Mike, I've been a CSS convert for a number of years and that analogy was the first thing I've heard that really does help me understand the potential benefits of using an OOP approach. I admit I need to read the thread again to get my head around OOP, MVC, Framework details but at least now I'm clearer about what I need to start understanding :o Even taking into account Claudes comments about the difficulties Frameworks can introduce (and I can relate to a framework based app being difficult to maintain if you're not familiar with the framework), I'm now thinking that at least understanding, even if not regularly using, OOP would be beneficial. To clarify, if the advantages are as great as those introduced by using CSS layouts then, even though I can't get my head around what they are just yet, I can see there would be real benefits to using a structured (MVC, OOP) approach. As Mike mentioned, the slight off-topicness of the thread is a good thing. At the very least it helped me realise I know less than I thought :) So, thanks to all those who chipped in and debated the pros and cons. Isaac, your explanations and examples have really helped - I'm pleased Rick said his head was spinning and prompted the extra explanation :) Mike, is the bean/DAO approach you use an established framework (i.e. a methodology used by other people) or is it more of a working method you devised yourself because it made sense/was easy(ish) to understand? Jacob, as someone else who's on the fence, has this thread helped your decision making? As an aside, I was looking at Raymond Camden's blog earlier and read this which includes a lot of the good, bad and ugly points in two paragraphs: .It was the first time I did form validation in Model-Glue. To be honest, it felt a bit akward. I had a form view in one file, form validation in a controller, data validation in a bean, and the use of a Data Access Object (DAO) to save the data. It was more than a little bit difficult to grok the process with all these balls in the air. Now that I'm done with it though, it makes more sense. I also like how my form is a lot slimmer. It's basically just the text. I know this is a reoccuring theme in my posts, but the seperation of all the pieces simply gives me the warm fuzzies. If for some reason I decide I hate Model-Glue, I would be able to re-use almost every line of code most likely. That's a Good Thing(tm). ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OOP, why me?
Cool, thanks for that Bob. Gareth, The bean DAO method is used in some of Ray Camden's free application. The one I know of for sure is Lighthouse. This helped me understand some OOP stuff that I hadn't quite grasped before. http://ray. camdenfamily.com Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54