Re: cachedwithin amp; queries of same name, caching advise
Fifteen hundred records isn't very many. Query of queries is relatively slow, so I wouldn't be surprised if that approach is slower than just querying the database at runtime for each product. Generating output on the first runtime hit (with CF_ACCELERATE or CFCACHE) will generally provide the best performance if you have a lot of cache hits. CF_ACCELERATE is very memory-dependent, of course, so you'll have to be careful there. CFCACHE is very bad if you don't have many cache hits. Generating static HTML through custom application logic provides the best performance, obviously, but at the cost of not being able to use dynamic stuff at runtime. I already auto-update a cfinclude (html only) for the homepage blog entries and new products pod. I could do that for categories I guess, just have to work out the auto-updating. That's obviously the fastest, don't know why I wasn't thinking of that. I'm not sure about search though. I have search results set up to display products just as a category would, not just links, and provide a lot of search links, like tags really, to bring up various product classes. And of course what anyone searches for. Maybe best to leave to the cachedwithin tag? Thanks for the tips. ~| 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:293357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cachedwithin queries of same name, caching advise
If I have various queries using the same query name but different sql can they all be cached at the same time, or will the new one overwrite the last one because of the name? For example, search queries. I'm wondering how best to serve the category and search results. We have about 1500 products. Would it be wise to make a huge query of all the product info, stick it in the application scope, and always use a query of queries against it? Or something else? Maybe the cf-accelerator tag? mysql query cache? I am on a vps but I don't really know how to test such things, and it's a one man show :-( Thanks. ~| 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:292964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Tab Issue
Here's the breakdown if interested, btw, just realized the web developer toolbar brings it all up nicely: Scripts (8 files) http://code.fraser.id.au/CFIDE/scripts/ajax/ext/ext-core.js 76 KB http://code.fraser.id.au/CFIDE/scripts/ajax/package/cfajax.js 34 KB http://code.fraser.id.au/CFIDE/scripts/ajax/yui/yahoo-dom-event/yahoo-dom-event.js 28 KB http://code.fraser.id.au/CFIDE/scripts/ajax/messages/cfmessage.js 15 KB http://code.fraser.id.au/CFIDE/scripts/ajax/yui/animation/animation-min.js 15 KB http://code.fraser.id.au/CFIDE/scripts/ajax/ext/adapter/yui/ext-yui-adapter.js 10 KB http://code.fraser.id.au/CFIDE/scripts/ajax/ext/package/tabs/tabs.js10 KB http://code.fraser.id.au/CFIDE/scripts/ajax/package/cflayout.js 9 KB Style Sheets (1 file) 61 KB http://code.fraser.id.au/CFIDE/scripts/ajax/resources/ext/css/ext-all.css 61 KB ~| 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:287364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Tab Issue
Andrew, here's your post about Railo javascript the other day: by the looks of the generated code it is very bloated to say the least as well. And now you're having a hissy fit because someone pointed out that a simple tab example doesn't need 258kbs? Try to read what people actually post, and reply somewhat objectively and civilly. If you really must insult, always do it with style. And thats nothing compared to a extJS web application I have written. I'm sure your dick is huge too ;-) ~| 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:287395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Tab Issue
Have you weighed up all those wondrous cf includes? ***258kbs***!!! It's insane. even with extJS you need to have just as many js includes as well. No, because you've got 3 CF-specific js files included to start. Then there's even a 60kb generic css file included. Yui is bloated but if yui/ext requires massive generic includes to run anything it's a problem, though cf seems to be dumping every possible file in that might be needed. The whole cflayout looks to be avoided to me. I'm no jquery fanboy, just use anything that doesn't require a massive, ridiculous 258kbs of generic includes for a simple tab system. ~| 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:287361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Railo 2 Released
My take is that for $300 you can run unlimited virtual hosts. Seems like a pretty fair price to me. Now, am I wrong? Seems wrong because you have to pay an extra $100/web, they say. So running 5 sites means $700, etc. By default with the Professional Version a single web (webapp) can be used. With the Professional Version of Railo you buy a contingent of webs (webapps) which can be accessed. This number can be enlarged at any time. Can anyone clarify what a web/webapp is? I'm assuming a domain? How exactly is it restricted? By IP? ~| 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:287363 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 Tab Issue
I have what should be a really simple Tab example. And an absolutely insane amount of js and css added to the page for it - 9 includes! It's ridiculous and should not be used. Seriously, do your own javascript. Go get jquery (about 20kbs for the entire library) and the jquery tabs plugin and forget all that nonsense. ~| 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:287270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best way to store search terms entered on a website?
Yes, but the rows are not (duplicate). The time, the search string. Potentially the IP address. in combination, always unique. Well, I just meant a duplicate term meaning after a year you'd have some insane number of rows. Thanks. ~| 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:287118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best way to store search terms entered on a website?
Create two data tables, one for terms (have an term_ID and search_term field) and one for search date/time (have a term_ID and date/time field). I know little about db design, sorry: why would you use 2 tables rather than one with 3 columns? Sure it's helpful. I want to know how many times people search for terms as it helps me figure out what people are searching for. But your description of the task didn't have a counter. Or would just keep adding repeat entries ad infinitum which can't be good. In any case, I don't see how the lastdate used helps me to do much. The term might not be used for a year, then once last week. Doesn't help to see what has been popular this month. My top 10 might be really old searches. I could query so lastdate must be within a recent period, but no more than that. I guess that's enough if no better solution. That's basically why I was asking what people have done and considered a file for each period. Am I missing anything obvious? The userid tip might be nice but we already have a custom bookmark page where the products are determined by users saving them to that page. ~| 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:287023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: best way to store search terms entered on a website?
Actually, I wrote an article about this for CFDJ, which includes code for a cfc that reports on search terms, auto-mails a weekly (or other period) report, etc.: http://cfdj.sys-con.com/read/48234.htm I'll take a look, thanks for the tip! ~| 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:287028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: best way to store search terms entered on a website?
You seriously just keep adding row upon (duplicate) row every day for years and years? That's a hell of a lot of rows because people search a lot. I'm surprised, but I'm no expert. If no one thinks that's a bad idea... Thanks again. ~| 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:287102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
best way to store search terms entered on a website?
Any suggestions on how best to store search terms entered on a website? If the database, then see if used already and increment, or add if not, and maybe set a datelastused? But then that is 2 db hits right there and could grow quite big. Or just write them to a file and parse and reset the whole file weekly or monthly? I'm thinking the latter, but how slow is writing to a file (on Linux)? it's not a heavily trafficked site, but just wondering what people do. Thanks. ~| 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:286916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: best way to store search terms entered on a website?
I just log the term and the date. So one row per search. This then lets me do stuf like top ten search phrases. Wouldn't you need to search for the phrase first and increment a total? Otherwise you'd have naked on 90,000 rows :-) And the date only refers to the last time, so not so helpful, no? That's why I was thinking a file might be better. ?? ~| 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:286970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Query Error: Duplicate entry?
Does anyone know why I might get this sometimes? Mysql: Query Error: Duplicate entry '75A8BA37-2B3E-7F0C-15E97C353E23FA73_100' for key 1 Datasource: Native Error Code: 1062 SQL State: 23000 Executing SQL: INSERT INTO ... Normally works fine so I don't understand it and google does help much. There is already a check to see if the basket exists before adding the item, so shouldn't be a duplicate basket id. ~| 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:283368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
BD7 booleans value greater than 1 problem?
Does bluedragon 7 have any differences/problems evaluating booleans where the value is greater than 1? I get errors only sometimes in a few different places about Can't perform this operation on these data types on code like: cfif x.Credits AND y.RecordCount Can't figure out why. On Linux if that could possibly make any difference. Ideas? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why might sessions end more quickly after changing to linux/B D?
Not followed directly but are you using a load balancer? I have a secretary, is that what you mean? ;-) No, we're not balancing. And the only site using the server except for 1 tiny site that is rarely visited. By the way, what is the exact relationship between the timeouts set in the code and on the server? I assume the code overrules the server, or does the server set both the default AND maximum? ~| 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:280351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: why might sessions end more quickly after changing to linux/B D?
sorry, HoF says an error occured with the template when posting. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280352 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: why might sessions end more quickly after changing to linux/B D?
Not followed directly but are you using a load balancer? I have a secretary, is that what you mean? No, we're not balancing ;-) And the only site using the server except for 1 site that is rarely visited. By the way, what is the exact relationship between the timeouts set in the code and on the server? I assume the code overrules the server, or does the server set both the default AND maximum? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: why might sessions end more quickly after changing to linux/B D?
- The timeout value that's set on the server directly Was 20min, I upped it to 40, no change. - The timeout value that you've set in your Application.cfm (if any) It's longer. I do have a search for useragent string for spiders and crawlers and knock them down to 1 second timeouts to preserve memory, but code hasn't changed from previous server and was never an issue before. I'm going to revise that code and see if it does anything. - This could also be related to network problems. Are you on a network where IP changes often? No, and it is not only me. Some customers say suddenly their cart will be empty sometimes. Clearly they lost their session. - Are you using cookieless session tracking? (that can get tricky...) Cookies. I'm clutching at straws here, but was wondering if something to do with vps perhaps and losing the domain/cookie? (And dns propagated 2 weeks ago.) Thanks for any ideas. ~| 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:280210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why might sessions end more quickly after changing to linux/B D?
You might also increase the session timeout I will, but the session timeout is restarted with each page load, right? so I don't think that's it. This hasn't helped. I'll be the admin section, leave the page for 5 minutes, then try to load a page and I'm kicked out. What could I possibly check? apache/centos/bluedragon/vps if that might affect something. ~| 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:280147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why might sessions end more quickly after changing to linux/B D?
perhaps the server is failing and being restarted? seems fine You might also increase the session timeout I will, but the session timeout is restarted with each page load, right? so I don't think that's it. weird... ~| 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:279993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
why might sessions end more quickly after changing to linux/BD?
Just moved from shared cfmx/windows to a vps BD/linux. Code hasn't changed. Now we keep getting kicked out of sessions quickly. Sign into the app admin and get kicked out quickly whereas before it was fine for a long time. Session timeout is 20 minutes in BD but happens faster than that I think. People say their cart will come up empty suddenly too. What might it be that I could check? ~| 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:279931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Franken-Fusion?
I recently posted this about Ray Camden's projects and is related to the aim of your discussion: Personally, I think Adobe should buy all the projects from you (and a framework like Coldbox or something) as a reward for all your hard work and then support at arms length an open source community/website/system around them. Now that would be incredibly helpful for CF and proactive on their part, though completely contrary to their Enterprise-down approach. (Maybe Bluedragon would be a better fit.) They should consider the projects as valuable add-ons to their server which actually serve the customer's higher goal of acting on the internet, not just coding. In a tiny market like CF, which is going to remain tiny until a decent free server appears, they need to be more nurturing; take more of a Singapore approach. Wouldn't it be cool if, just by using CF, you got access to a killer set of apps? ~| 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:278417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: a couple windows to linux, cf to bluedragon problems
1) One is a cfsavecontent latest in an include that is not appearing now. Traced this to no CGI.path_info coming up so not inserted later. Even on somehting like http://site.com/folder/index.cfm?id=45 CGI.path_info is blank. Why would that be? On CentOS. 2) Another is my search page, which worked fine, now gives a Badly formatted template error. What is that and why? ~| 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:278004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: a couple windows to linux, cf to bluedragon problems
Dump the CGI scope and see if there is something you can use instead. Worked around it, thanks. formatted template error. What is that and why? If anyone has this come up, mine was a comment in the middle of a multi-line cfif in the search sql. Maybe bluedragon didn't like that. ~| 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:278062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
a couple windows to linux, cf to bluedragon problems
I'm moving from windows to linux and cf to bluedragon and a few issues in moving the same code: 1) One is a cfsavecontent latest in an include that is not appearing now. cfoutputcfinclude template=o_latest.cfm/cfoutput cfset z = StructInsert(extras, latest, latest) I can't remember why the StructInsert attributes have the same name but worked fine. Now nothing appears. Ideas? 2) Another is my search page, which worked fine, now gives a Badly formatted template error. What is that and why? Thanks. ~| 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:277973 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 or other easy way to change code to lowercase for linux
If you change the setting for mysql to lower_case_table_names=1 instead of the default 0, you won't have to worry about the upper case names in your code. MySQL will lowercase all of the names when it runs the query. Then you don't have to change your code. Oh, great. I had heard about that but thought it just pretended the table names themselves were lowercase, not the cfquery code. I see now it is actually the opposite and I'll have to change the database names: Note that if you plan to set the lower_case_table_names system variable to 1 on Unix, you must first convert your old database and table names to lowercase before restarting mysqld with the new variable setting. Thanks. Just have to hunt down the img/file names and such now. If anyone still has any trusty regexs for those... ~| 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:276734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
regex or other easy way to change code to lowercase for linux
Can anyone suggest a regex or another easy way to change all the cfquery table name code and other required bits (file names, etc.) to lowercase for linux/mysql? I'm using homesite. For example, I can't seem to come up with a regex for cfquery that isn't greedy but allows tags inbetween the start and finish. Searching and checking all the table names would be awful, so I just want to set everything to lowercase and go from there. Btw, if you have a WHERE table.field clause, does mysql require that table name to be case sensitive just like in the FROM clause? Thanks. ~| 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:276606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone using coral Coral Web Builder
does it have to be Coral? Or could you live with Railo too? You can use it for free in it's community version... Gert, I sent an email to you guys yesterday asking if Railo can be packaged up like Coral. Can it? (Not on CD, but installed/setup locally as an app in an easy manner like Coral says it can, not resource heavy either.) I will be looking to build a browser based solution using some AJAX, CFC's and a DB, those are the key factors for me. Exact same for me. A local app using a browser. Possible Gert? If just another cf server, then the customer would need a webserver and such as well, no? Is there anyone who has ever used Coral? Does it not support cfcs? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
why SESSION scope is not enabled error on new server?
New bd7 server, just setting up a very simple site but getting the error: The requested SESSION scope is not enabled. yet application.cfm has: cfapplication name=gordan clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimeSpan(1, 0, 0, 1)# applicationtimeout=#CreateTimeSpan(2, 0, 0, 1)# BD is set to regular sessions, not j2ee, cookie storage. Worked fine locally or on old host. Newly on linux if that makes any difference. Ideas??? ~| 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:276279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why SESSION scope is not enabled error on new server?
Capital A for Application. Windows spoils you :-) Do you mean the file itself must always be named Application.cfm? Why exactly? Slightly off-topic, am I correct that db table names must match case as well? What about field names within tables? I see some serious search replace in my near future. Thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: why SESSION scope is not enabled error on new server?
Next time I'll google first: http://www.firstserv.com/support/sharedHosting/coldfusion/coldfusionLinuxConversion.cfm Still curious why application would be capitalized; guess something internal, huh? Table names are case sensitive. -doesn't mention the field names. Do you know? I know there is also some ini setting in mysql to force lower case; I guess I still would have to change the queries to lowercase then, huh? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
=?iso-8859-1?Q?Re: how can I strip a UK =A3 sign from a u rl variable??=
then you're pre-cf7. what version of cf? this is just locally, testing it. However cf7 on the host gives the same type error after setting to setLocale(en_GB) - btw, moving to BD shortly if that makes a difference. Parameter 1, �66.16, of function LSParseCurrency is an invalid currency value in the current locale. what encoding is the page that produced the url value, the page accepting it, I have no idea, sorry, I guess the default. etc.? have you tried urlDecode on those url vars? -just did, same error. Hm.. ~| 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:274818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
=?iso-8859-1?Q?Re: how can I strip a UK =A3 sign from a u rl variable??=
using cf7, utf-8, that snippet works fine. I checked GetEncoding(URL) and it said utf-8 ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
=?iso-8859-1?Q?Re: how can I strip a UK =A3 sign from a u rl variable??=
Nothing worked so ended up regexing them and resetting them. Thanks for the help anyway. ~| 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:274826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
=?iso-8859-1?Q?Re: how can I strip a UK =A3 sign from a u rl variable??=
However cf7 on the host gives the same type error Just to clarify, I meant the same ?66 is not a number error, not a locale error. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
=?iso-8859-1?Q?Re: how can I strip a UK =A3 sign from a u rl variable??=
setLocale(en_GB); pounds=lsParseCurrency(url. currencyVar); That local it says doesn't exist and gives an error. I used setLocale(English (UK)) but I still get: Parameter 1, �6.16, of function LSParseCurrency is an invalid currency value in the current locale. Ideas? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
=?iso-8859-1?Q?how can I strip a UK =A3 sign from aurl va riable?3F?=3D?=
I'm stuck trying to strip a UK pound symbol £ from url variables. I've tried a bunch of things but just keep getting an error like ?50 cannot be converted to a number. Tried stripping the symbol itself, %A3 which shows up in the address bar after entering it (think this is server dependent?), and a question mark. Nothing works. I did get stripping %A3 from cgi.QUERY_STRING to work and I could rewrite all the variables from that but hoping for something direct and easier. Ideas? I can't do anything about the symbol being in there, coming from a dumb program elsewhere. 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:274665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: viviotech vps, non-admin linux newbie, rambling questions
Great responses guys, thanks so much. I was also thinking another 256mb would be good if running mysql off it. I never really use webmail anyway except if on holidays. If anyone has anything to add... ~| 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:273637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
any stability/performance difference with cf on linux vs. windows?
Any stability/performance difference with cf on linux vs. windows? Anything to watch out for on linux beyond case sensitivity of files and db tables? Some cfx tags can't work? I've always used windows but linux hosting is cheaper. Hostmysite is about 40% cheaper for linux; also thinking viviotech vps when feeling brave. Thanks. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
viviotech vps, non-admin linux newbie, rambling questions
Thinking about a viviotech vps but I'm not an admin and never used linux. Wondering how hard it would be and what people are using there. I've searched and read the good feedback. It's either that or shared hosting somewhere like hostmysite/ct. I know there is a managed solution but wondering if I could toy with an unmanaged one and set it up slowly myself. Would like to hear from anyone but especially people who were in the same boat. Rambling thoughts: Is a basic package with 256mb enough for Bluedragon and mysql4/5 on a not too busy niche commerce site? I thought much more memory would be needed. Is the line fast enough? Find much difference between BD and cfmx on linux? (I know the tag differences.) Are there problems monitoring BD in case it pegs the cpu? I know you can't use cfmx monitors. What do people do? (I also don't want to be tied to a computer 24hrs a day.) Big issue, small issue? What sort of monitoring does viviotech do for you themselves? Is it a full-time job for you now monitoring the site yourself and jumping in to fix things all the time? How difficult was it to set up such an environment there with a couple extra very minor domains, ftp, email and such? Mysql backup has to be done manually? Do you also have to monitor mysql somehow? Do you install phpadmin to handle mysql, or something else? I'm not really a command-line guy. Did you have to become BD/mysql/apache gurus just in order to use them for the site, or left them as-is? I'm afraid I'd do this then find I'd never tweaked some obvious setting which was causing big problems. What do you do to ensure security? What were the biggest hurdles you faced going it alone? And calling Peter J. Farrell: what happened to the promised part 2 on your blog last year about setting up your vps there? ;-) Thanks for any tips! ~| 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:273482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
tips for testing slow pages and queries?
I have a crappy old app I'd like to go thru to find any bottlenecks. Any tips/tools for testing slow pages and queries? Thanks. ~| 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:271483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cache one big query or many smaller ones
Actually only 1.5k records, not 15k. Not a big/popular site. Just setting up mysql. How do people cache queries when using cfqueryparam? ~| 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:270085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cache one big query or many smaller ones
Store the query and creation time in the Application scope? Is that a memory problem, or does it work the same as caching queries normally? I would think the latter has some automatic management while the former can lead to problems? Is the mysql cache another option? I'm just changing from an access db so I don't know what approach to take. By the way, why exactly does cfqueryparam prevent caching? The query still looks the same in the end using some custom cf check or cfqueryparam check. Why didn't MM work around whatever the problem is? ~| 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:270164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cache one big query or many smaller ones
What makes best sense in a shopping cart system with about 1500 products (and all the usual price, new, sale, photo, description, dateadded, etc, columns), to do one big query of all of them together and keep it cached and then for each category and individual pages, do a query of query against it, or just do and cache each smaller query, no big one? We're on a shared host too. ~| 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:270066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: repeated random error with request variable
What is your Session timeout (in administrator and within your cfapplication tag) set to? CreateTimeSpan(0, 1, 0, 1) I don't know in the administrator because it is a shared host. The variable locale is only used in the one instance on application pages. Anyway, doesn't seem to be that variable per se causing the error. For now I've put a cfif to check if isdefined above the query and reset the cache time to 0 if not, because refreshing always fixes it when it's down. I just can't figure out how it could go wrong to start as that querry is always called by application.cfm and is cached. How can it call it then within a couple lines of code it is no longer defined? And I even had a check for isdefined to recall it right above the line giving the error. (Hence the refresh code added now.) Could it be another site on a shared host is mucking things up in the cache??? ~| 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:247020 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
repeated random error with request variable
I keep getting an error every so often related to a request variable missing which crashes my entire website. I have on the application page an include for basic settings which are written to request scope. The query uses a request cache. If url refresh varibles are added it is refreshed. Later in the page I set a variable based on one of those request settings. Normally works fine. But every few days when I go to the site I see only an error page with the error relating to setting this variable because the request variable I'm using is not defined. So, I got sick of that, and above setting the varible I put this: cfif NOT isdefined(request.appSettings.Locale) !--- Get Settings --- cfinclude template=queries/getsettings.cfm /cfif To reget them. Well, damn it, it still happens every few days. I can't see how possible. As soon as I refresh the cache by setting request cache to 0, it reloads fine again for who knows how long. So: 1) how can this be hapenning? 2) I'm going to try setting the cach to zero just above the 2nd request but want to solve number one first. Ideas? ~| 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:246674 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: repeated random error with request variable
I didn't write this code, and I just realized I can let cfmx set this locale = setlocale() variable itself, but I think this is a refresh/cache problem and will reoccur with another request variable set in that query anyway. So, ideas why? 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/cf_lists/message.cfm/forumid:4/messageid:246703 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: how (the heck) to call functions on a jsp page?
i don't see where that code uses anything but java.util.zip. is there more to this? Two other pages, but they just call those two functions. Apparently whoever wrote it wasn't too swift in java. It appears to be working in a quick test! Thank you so much! Would have taken me forever to get all the syntax correct. Do you have a webpage with your address listed? I'd like to send a little token of appreciation. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242299 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: how (the heck) to call functions on a jsp page?
Here's the code on the jsp page.
1) it imports some stuff.
2) I need to call the functions from cf.
How exactly would I do both?
Thank you if you can help.
**
% //
Import Package
// %
%@ page import = java.sql.*, java.util.*, java.util.zip.* %
%!
public boolean verifyCheckSumAll(String MerchantId, String
OrderId, String Amount, String WorkingKey, String currencyType, String
Auth_Status, String checksum) throws Exception {
String str =
MerchantId+|+OrderId+|+Amount+|+WorkingKey+|+currencyType+|+Auth_Status;
Adler32 adl = new Adler32();
adl.update(str.getBytes());
long adler = adl.getValue();
String newChecksum = String.valueOf(adl.getValue());
if (newChecksum.equals(checksum)) return true; else return
false;
}
public String getChecksum(String MerchantId, String OrderId,
String Amount, String WorkingKey, String currencyType, String redirectURL)
throws Exception {
String str =
MerchantId+|+OrderId+|+Amount+|+WorkingKey+|+currencyType+|+redirectURL;
Adler32 adl = new Adler32();
adl.update(str.getBytes());
return String.valueOf(adl.getValue());
}
%
*
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242204
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
how (the heck) to call functions on a jsp page?
I need to either rewrite some functions into cf (see my asp conversion thread) or include a jsp file and call 2 functions in there. To the latter: 1) the jsp file has at the top %@ page import = java.sql.*, java.util.*, java.util.zip.* % followed by 2 functions. Is that a problem? Are those special classes or regular ones the shared cf7 server will have already? 2) how do I call the 2 functions in the jsp page? I know I can use a GetPageContext().include(hello.jsp?name=Bobby); style but I don't need to include url variables, I need to call the functions there. How exactly do I call them??? Or I also found this example: !--- import the custom tag library so that this template can see it --- CFIMPORT taglib = /WEB-INF/lib/random.jar prefix=myrand !--- execute a custom tag from this library --- myrand:number id=randpass range=00 - 99 algorithm=SHA1PRNG provider=SUN/ But does that mean I must make the jsp page into a jar and put in that location? And how exactly to I call the function and plunk down the returned value in my cf code? (For example, the result of the above example, I just use #randpass# afterwards?) Finally, if I get this working (with your help), will it be slow for any reason? Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241780 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
help a blind man convert asp functions to cf
I need to either rewrite some functions into cf, or include a jsp file and call
2 functions in there (see my jsp thread). To the former:
I don't know asp. I'm getting an error:
The value cannot be converted to a number
254 : op = opBitAnd( mid(op3 , i ,1), mid(op4 ,i ,1) );
Here is my translation. Can you see what I did wrong? I also tried ( mid(op3 ,
i ,1) AND mid(op4 ,i ,1) )
Thanks for any help.
/*
function andop(op1 , op2)
op3 = cbin(op1)
op4 = cbin(op2)
for i = 1 to 32
op = op(cint(mid(op3 , i ,1)) and cint(mid(op4 ,i ,1)))
next
andop = cdec(op)
end function
*/
function andop(op1 , op2)
{
op3 = cbin(op1);
op4 = cbin(op2);
op = ; ??
for (i = 1; i LTE 32; i=i+1)
{
op = opBitAnd( mid(op3 , i ,1), mid(op4 ,i ,1) );
}
return cdec(op);
}
/*
function cbin(num)
do
bin = cstr((num mod 2))bin
num = fix(num / 2)
loop while not ((num = 0) )
for i = 1 to 32 - len(bin)
bin = 0bin
next
cbin = bin
end function
*/
// function used for decimal to binary conversion
function cbin(num)
{
bin = ; ///??
do
{
bin = (num mod 2) bin;
num = fix(num/2);
}
while (num NEQ 0);
for ( i = 1; i LTE (32-len(bin)); i=i+1)
{
bin = 0 bin;
}
return bin;
}
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241787
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: how (the heck) to call functions on a jsp page?
No, should be fine, java.* classes are normal. Any idea how to call the functions? Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241789 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: how (the heck) to call functions on a jsp page?
Just stick the Java code between JSP tags. Not sure what you mean. To include it I used: GetPageContext().include(myFunctions.jsp); Later in the cfml page I call one function on that jsp page same as I would any cf function, but get an error that that function is undefined. Hence... how? Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241812 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: how (the heck) to call functions on a jsp page?
Why not just use CreateObject() to create the Java class you need, and then use it like a CFC. So how would I do all that, including the jsp page includes and calling the functions on the jsp page? I have no idea, sorry. What's a class exactly? Where's it go, how's it made, called, etc? I just want to include the jsp page's needed includes, and call the darn function on that page. Can anyone give a code sample explaining how to do that? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241840 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: help a blind man convert asp functions to cf
254 : op = opBitAnd( mid(op3 , i ,1), mid(op4 ,i ,1) ); Just take ' ' out. Well, that was redundant I see now, thanks, but doesn't change the outcome at all. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241841 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: help with paypal ipn testing - always INVALID response
I've only tested with the eliteweaver test server. I tried both code formats and both get invalid back. I haven't tried with paypal yet. I think it probably works and it's just the eliteweaver server. I'll post again if fails with paypal. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227965 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: help with paypal ipn testing - always INVALID response
Thanks, I'm aware of it and thought of it, but the code to do this IPN is only a few lines long. I think it must work and is just something silly; going to rig it up so I can try it live and see... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: help with paypal ipn testing - always INVALID response
Surely one person out there has worked on this stupid ipn system, no? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227676 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: help with paypal ipn testing - always INVALID response
Any ideas anyone? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
help with paypal ipn testing - always INVALID response
I am having trouble with the IPN response as it always comes through with the CFHTTP.FileContent = INVALID instead of VERIFIED. I am using http://www.eliteweaver.co.uk/testing/ipntest.php. I tried 2 code formats, both the same. I think str isn't sending back EXACTLY what I get, therefore rejected as different and an invalid response given. But why? Any ideas? ** cfset x = GetHttpRequestData() cfset str=cmd=_notify-validate x.content !---post back to PayPal for validation--- !--- https://www.paypal.com/cgi-bin/webscr?#str# FOR TESTING http://www.eliteweaver.co.uk/testing/ipntest.php?#str# --- !--- other format: CFSET str=cmd=_notify-validate CFLOOP INDEX=TheField list=#form.fieldnames# CFSET str = str #LCase(TheField)#=#URLEncodedFormat(Form[TheField])# /CFLOOP CFIF IsDefined(FORM.payment_date) CFSET str = str payment_date=#URLEncodedFormat(Form.payment_date)# /CFIF CFIF IsDefined(FORM.subscr_date) CFSET str = str subscr_date=#URLEncodedFormat(Form.subscr_date)# /CFIF --- cfhttp url=http://www.eliteweaver.co.uk/testing/ipntest.php?#str#; method=GET resolveurl=no ** It's saying my script never replied: HTTP Status: HTTP/1.1 200 OK IPN Received: Your script did not reply! I have cfhttp doing other things on the server, so don't see why it wouldn't work here. Anyway, how did cfhttp.fileContent get the INVALID reply??? Here's the url in the cfhttp tag after receiving the orginal post: http://www.eliteweaver.co.uk/testing/ipntest.php?cmd=_notify-validatereceiver_email=paypal%40yourdomain%2Ecomreceiver_id=S1D89I62CBYZ1business=paypal%40yourdomain%2Ecomitem_name=Item%20Nameitem_number=402quantity=1invoice=778671custom=Customoption_name1=Optionoption_selection1=Selectionoption_name2=Optionoption_selection2=Selectionpayment_status=Completedpayment_gross=24%2E99payment_fee=1%2E02mc_gross=24%2E99mc_fee=1%2E02mc_currency=USDtax=0%2E00txn_id=5QEEZUB4BI415B32Wtxn_type=web%5Facceptmemo=PayPal%20Special%20Instructions%2FNote%20Field%2Efirst_name=Thomaslast_name=Testeraddress_street=21%20Test%20Streetaddress_city=Testopiaaddress_state=Testvilleaddress_zip=123456address_country=Unitedaddress_status=confirmedaddress_owner=1payer_email=paypal%40theirdomain%2Ecompaypal_address_id=MQKQILDJSN8BCpayer_id=MFYK3Y5MEE9IVpayer_business_name=Test%20Company%20Ltd%2Epayer_status=verifiedpayment_type=instantnotify_version=1%2E6verify_sign=48sY9zJkFf2X4xTatUKP3Vtan4C43sZmg9gYeeubwrMU%2DBWY2p41rBZpsubscr_effective=10%3A06%3A49%20Dec%2019%2C%202005%20PDTperiod1=7%20dperiod2=3%20wperiod3=11%20mamount1=1%2E99amount2=6%2E49amount3=19%2E99mc_amount1=1%2E99mc_amount2=6%2E49mc_amount3=19%2E99recurring=1reattempt=1retry_at=10%3A06%3A49%20Dec%2026%2C%202005%20PDTusername=QvIIZFyapassword=iP487ItIuWqO2subscr_id=S%2DUO43TD9EYTVC5KB3Spayment_date=10%3A06%3A49%20Dec%2019%2C%202005%20PDTsubscr_date=10%3A06%3A49%20Dec%2019%2C%202005%20PDT Would the url encoding be a problem? or the length? Does the Elite form just not work, or what? I can't see anything wrong except it thinks some items are not being posted back exactly the same, but when I use the follow IPN button my debugging output seems fine apart for urlencoding. Any ideas??? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227393 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
jar launcher crashes randomly
No one has ever heard of this? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: how to post
Obviously the form should not even appear if you are not signed in and not permitted to post, but rather the sign in/register info and links. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209245 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: jar launcher crashes randomly
Hmmm. But I always eat cereal for breakfast, so that can't be it. Anyone else? :-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209261 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
how to post
I posted on the server forum, but never showed up. How to post? (Checking if this one works.) Where's the sign in? Where's the account profile? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209095 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
why can you post on this site, but no indication it fails?
This forum is badly confusing. I posted a few times, nothing ever showed up. No sign in link, nothing, so figured I must be logged in by cookie. Finally tracked down the signin under site map. Why no check before posting? No sign in/account link? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
why can you post on this site, but no indication it fails?
Weird, my other thread below showed up after I signed in. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
jar launcher crashes randomly
xp, cfmx 6.1. I get a random error popping up about jar launcher had to close on my local machine. Usually when starting the computer, or at random times, nothing to do with accessing a site even. Usually I can then access a site after a moment (restarting the service?); sometimes it says service unavailable or some such thing, and have to reboot. No other problems. Sending in the error to MS they say it is Java and Sun's problem. I recently reinstalled xp, and no change. Only thing different in my setup is I put cfdocs/cfid in f:\web. My webroot is F:\. The report for MS is: Server=watson.microsoft.com UI LCID=1033 Flags=1672016 Brand=WINDOWS TitleName=JAR Launcher DigPidRegPath=HKLM\Software\Microsoft\Windows NT\CurrentVersion\DigitalProductId ErrorText=If you were in the middle of something, the information you were working on might be lost. Stage1URL= Stage1URL=/StageOne/jrun_exe/4_0_0_63824/jvm_dll/0_0_0_0/0015755c.htm Stage2URL= Stage2URL=/dw/stagetwo.asp?szAppName=jrun.exeszAppVer=4.0.0.63824szModName=jvm.dllszModVer=0.0.0.0offset=0015755c DataFiles=C:\DOCUME~1\username\LOCALS~1\Temp\WER3ebb.dir00\jrun.exe.mdmp|C:\DOCUME~1\stylo\LOCALS~1\Temp\WER3ebb.dir00\appcompat.txt Heap=C:\DOCUME~1\username\LOCALS~1\Temp\WER3ebb.dir00\jrun.exe.hdmp ErrorSubPath=jrun.exe\4.0.0.63824\jvm.dll\0.0.0.0\0015755c DirectoryDelete=C:\DOCUME~1\username\LOCALS~1\Temp\WER3ebb.dir00 Any idea why? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209105 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: how to post
It works Yeah, see other thread. This one showed up after I signed in. Or maybe I just can't post on the other list. But there needs to be an indication of some sort if you can't post. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209106 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
How to get the full url requested in cf?
I don't want the file system path, I want the full url of the page requested, e.g., http://www.shop.com/index.cfm . (Actually I just need the first part, not even the page, as I only want to know if www was used or not.) How can I get that in a CF variable when the page is requested? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205829 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: How to get the full url requested in cf?
HTTP_HOST and SERVER_NAME both work. (On my local setup I thought they didn't because of my local url and missed them.) Thanks! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205937 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: How to get the full url requested in cf?
I don?t know why you need to know if www is there or not but if you had access to IIS, you could have http://www.shop.com point to a different place than http://shop.com all together There is a stored shop url in the code. Problem is that cookies are being lost between www.shop.com and shop.com when code refers to the shop url variable and cflocates in a few places, or a linkbase variable is set based upon it to use on menus used on various directory levels. I asked my host and they said I would need something like IISrewrite to redirect, or metatags. So I thought to rewrite the request.shopurl variable that is being set, based on their being www or not. Then the cflocate and linkbase will be in line with how people come to the site, with www or not. (Or I can simply relocate all www requests to non www. Maybe better, but wondering about links to the site and search engines.) If you have a better idea, I'm all ears. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Access type mismatch killing me - and also this website
Ok, this is killing me. Acess db query fails if w2 has a decimal place. Works if an integer. CFQUERY ... maxrows=1 SELECT#ShipZonesCAUPS.Day3# AS d3, #ShipZonesCAUPS.Standard# AS st, weight FROM ShipCanUS WHERE (Weight = #w2#) !--- round up to next highest --- /CFQUERY cfqueryparam shows a type mismatch using type float or numeric (not sure which is correct as the docs are so bad). Works with type integer. Thing is same query works fine on 2 other tables that are the same setup. All have type number columns. Any ideas? * BTW, how to edit your account here? All account links return to the same sign in page, showing you signed in. Using Firefox. Also, can the admin add some css for spacing between the lines on the list of threads? So scrunched together they're hard to read. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access type mismatch killing me - and also this website
WHERE (Weight = #w2#) To clarify further, weight in the db column has even numbers. I'm getting 0 records returned if w2 has a decimal. 35.1 SHOULD return the values corresponding to 36 (as the single row =35.1), but returns nothing for some reason. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access type mismatch killing me - and also this website
My last post clued me in. Somehow the weight column settings were changed on the one column. Who'd a thunk it? Ignore me. -Unless you can answer about the site login issue. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advice on structure and cfcs (petmarket related)
I wouldn't get too hung up on 'performance'... Sadly, I'd actually get more hung up on the coding, until I have more practice at it, but was thinking next app anyway. I was just going by the times shown in the comparison of fb3/fb4/machii/ontap floating around. And that some fb3 apps I've tried were quite slow. I figured if I could code something nice and clean somewhat along the lines of the petmarket it would be faster loading. Is that not the case? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advice on structure and cfcs (petmarket related)
Thanks for the advice. I was looking at this chart: Avg. TTFB (ms) Framework20 threads150 threads MachII139312473 OnTap293912243 Fusebox 312709423 Fusebox 411448863 Does that chart not mean that under medium load MachII is 1/4 sec slower than FB4, and, under heavy load, MachII is about 4 seconds slower than FB4 (at least on this app)? Would have been nice to compare to some inline code as a base so as to know what the framework was adding. I understand the maintainibility trade-off, just trying to get a handle on how much trade-off. I actually prefer the MachII approach to FB, though I have a general dislike of how frameworks route everything through index.cfm and have nasty urls. I imagine there are workarounds for that, though. Thanks again. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advice on structure and cfcs (petmarket related)
I'm not interested in Fusebox, and MachII is a bit much to begin with, maybe later. I am worried, however, about the speed of MachII. I thought FB3 apps ran slowly, and MachII is apparently slower, no? I do have Ray's BlogCFC and need to look at it more, but, to be honest, at first glance I find the structure of it a bit confusing, what with all the folders and ini file, though I will certainly study it, especially the cfcs and flow of it. Thanks, Ray! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: chinese translations anyone?
I really need this to get done today. Chinatown for lunch? ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
advice on structure and cfcs (petmarket related)
I'm looking how to best structure an application and build it with cfcs. I'm looking at the petmarket example right now (cfml only, not the flash front end version). What do people feel in general about the way that application is structured? In particular, I'm wondering about the detailview.cfm which is called by the product.cfc detailview function and used to output the page. Isn't that a bad thing? I would have thought you would call from a page template a cfc to return query info on a product and output that. Anything else about this application in particular I should be aware of or wary of duplicating, as maybe there is a better method or better performance to be had another way? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DHTML recursion problem
I don't know, but it's a nasty way to do it. First of all, you don't need to call every function in the onclick (lowercase, not camelCase). Just send the needed var to a function and go from there. Secondly, you should not even have cf put onclick inline; just have a class on the nec. menu items, then use js to add the onclick via a getElementsByClassName script. The images can also be background images associated with a class. See here for some ideas: http://www.kryogenix.org/code/browser/aqlists/ I understand, however, if you are stuck with a script that's not yours :-( [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMail Sanity Check - Where's the Macromedia rep
Having run mail servers and bought/used various server-level antispam products, I haven't seen anything that biases against CF Well, that's good to hear. I hope spamcop is included in that. My CF 6.1 does not place a message ID or a content-type (just checked). Your ISP is propping up CF and thats fine, but I would caution that you can't count on that. -good to know, thanks. But you see then the characteristics of cfmail DO contribute to a spam score, as missing headers - I think - are noted on many spam tests. This is exactly what I was getting at above. Why in the world does CFMX not include them then??? Maybe you've had few problems as you are fixing Macromedia's mistakes? -Or maybe there's a good explanation from MM as to why? I don't know, but that is why I say that MM needs to look at it seriously and write something up about it. It's a major concern. One less CFC article; one (and a first) cfmail and spam article. How can it be detected if CF places the header properly, and its a valid value? I mean that things like a fake but correct Outlook mailer ID are detected because there can be several checks and if they all don't match perfectly it is noted as forged, which is a death sentence. That's why I am very wary of using any spammer tricks. Finding out the real problem and MM's fixing it is better. If on the other hand you had a sender of [EMAIL PROTECTED] and the reply-to was [EMAIL PROTECTED] then yes, that would be a giant red flag. -yes, I have been doing that out of necessity. Can't tell how bad the effect is, but a few bounces. Maybe others are tossed. Others go through fine. But I need to change that. BTW, you should not use external css in an email. Odd as after a LOT of trial and error we found that an external style sheet, linked back to the original web site, was the least failure-prone option. I put my real css block at the bottom of the email within the content div I'm styling. Basing styles on body doesn't work and css can be stripped out if in the head. See this article and especially the forum responses with tips: http://alistapart.com/articles/cssemail/ After a couple of rounds, I moved forward with embedded styles. This turned out to be my first step to success. (In further support of embedded styles, it is important to note that AOL versions 6.0+ will reject any email linking to external style sheets. Yes: reject, bounce, slam the door in your virtual face.) Also worth noting on topic that css cuts down on spam flags. Nice bonus! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMail Sanity Check - Where's the Macromedia rep
How would he know? There are thousands of anti-spam solutions (millions if you count the variations in configuration) that all work differently. You think there is somebody who knows for all of them how they behave? OK, you pummelled my strawman to death, I'll give you that. But we're not talking about he and all. You have people assigned by Macromedia to look at it. And not every single host of course, but the major ones (AOL, Hotmail, Yahoo, Gmail to start), and the major spam associations used by hosts (spamcop, etc.). Not too difficult really. Then write an atricle up with best practices and the facts. It's the same sort of work Mozilla did when getting banks to support their browser. If Mozilla can do it... There was a time a LONG time ago when CF headers were an issue, but the A/S industry has progressed in sophistication well past this oversimplification. Do you know that for certain? That's the whole question. I hope it's true. Just the other day a host said on here that it probably still is a check for spam with some. I doubt anyone has any facts to back anything up. I can't tell myself as many ISPs will just toss your email with no bounce if thought to be spam, and there are many complicating issues. Macromedia has an interest in testing and finding out the state of things. The fact that no one really knows means 1) never an issue at all, and/or 2) Macromedia doesn't take it seriously. But it is incredibly difficult to get legitimate website email delivered these days, let alone email a small update list, so they should take it very seriously *if* their great product is inadvertently bumping emails over the spam check threshhold. And you have to start with the *if*. (If not clear, I'm not saying the mailer ID alone will get email tagged as spam, but wondering how and if Coldfusion email characteristics contribute.) You could eliminate that problem is short order by routing your CFMAIL through a qualified mail server. No, I do route it though my ISP and it still says X-Mailer: ColdFusion MX Application Server Also has the following: Message-ID: [EMAIL PROTECTED] cfmailparam name=Message-ID VALUE=#CreateUUID()[EMAIL PROTECTED] cfmailparam name=Content-Type VALUE=#variables.ContentValue# cfmailparam name=Mime-Version VALUE=1.0 I don't add them as those are all inserted automatically on my headers that I've checked (CFMX 6.1 thru ISP). I think it's bad practice to add anything that might be detected as a forged header such as the message ID, but I see what you mean if not added at all. cfmailparam name=Reply-To VALUE=#my.Email# -Just so you know, that is a specific mark of spam on some systems. I get some bounces for no relaying spam because of that. (I *think* because of that.) link href="" rel=stylesheet type=text/css BTW, you should not use external css in an email. Will often fail. Little trick for you: write it into the email as a block and also, before the html tags, add another set of empty style/style tags for Hotmail. Hotmail will then zap the empty block and leave the real style block in the email. Voila, css works in Hotmail! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMail Sanity Check - Where's the Macromedia rep
email servers tagging mail as spam when a ColdFusion header is detected has been happening for many years now. Where's the Macromedia rep who posts on here sometimes? Surely he knows. A recent host was on here saying he didn't think that was the case anymore. But I have no idea. Macromedia/CF needs to address this issue if they haven't already. Really, what is the point of improving cfmail if your email is unreliable simply because automatically tagged as spam? Again, has anyone tried blanking the mailer ID, or changing to a random name? This would make for a GREAT practical cf article if anyone actually knows what's what. -Or a great post by a Macromedia rep :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMail Sanity Check
I, too, briefly tried the Outlook lines and saw they were being IDed as forged. I would suggest adding a CFMAILPARAM to specify the message-id header as one possible solution. Then you would have two of them and be detected again as forged, no? Copying spammer techniques is just not the answer here. Obviously this is a very serious practical issue that needs to be addressed and evangelized by Macromedia/CF. Are they aware of it? Has anyone at Macromedia/CF actually checked if Coldfusion in the mailer ID is a current mark of spam with major hosts and spam associations? If so and it is, are they actively working with them to make sure it is NOT a check for spam? (Or are major spammers using CF, in which case, quite unfortunately, it is a good check for spam?) Does anyone know what is being done on this by Macromedia/CF? -Or is nothing being done? Mozilla had to do the same to get their browser working with major banks and such. Surely Macromedia/CF can make an effort here, otherwise all their improvements to cfmail are for not. In the meantime, does anyone actually know if a blank mailer ID, or a random name for it, helps? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Notifying Server of Client Side Events
I think Brent's rpc library is overkill these days (ns4?) but maybe you need it. Pengoworks also has an api using an iframe. For new browsers, you can also just load scripts dynamically except in Safari (annoyingly won't act on them), or use httpRequest in Moz/IE Win/Safari. Apple developer has a good recent article on the latter.
I use dynamic scripts now where a small window pops up and loads the page if no dynamic script support, but was thinking to combine methods and use httpRequest but load scripts for IE Mac and Opera. Each method has it's uses and issues. For example, with dynamic scripts, you get back js (i.e., alert('hi') will simply run), which can be handy. With httpRequest, you get data, xml, html, whatever.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Mailing to email list using CF
So doing a DNS check will not help much in verifying an account I just checked my list via dns using worldcast and about 10% failed, but many with messages about not having an IP they can reverse look-up, so useless. To send a newsletter in a slower way with CF, use an email trickler (a page that reloads and cycles through a query). Matt Robertson has posted it before here and one on easy-cfm or whatever its called. Google for coldfusion and email trickler. Kym, very helpful. Hard to know what emails are getting rejected for exactly what, or just tossed, so what do estimate the hourly threshhold is for big guys like AOL, Hotmail, etc? I have a list of 3000 subscribers and have been trickling it out at only 300/hour out of paranoia. Also, do you think the presence of a localhost IP (from 127.0.0.1 for [ISP IP] etc.) and the coldfusion name as the sending program in the header is a big spam filter problem? One thing that annoys me is I send via my local IPS account with a reply-to for our domain, and a certain percentage of hosts rejects that as no relaying. That's not relaying. Or maybe it's the localhost IP in there, not sure. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mailing to email list using CF
that they have to qualify it all over again with an opt-in.They'll be laughing all the way to the balcony, and more so as you sail off of it. I think you've misread something when replying to me. I didn't say - nor did anyone I can see - to re-qualify a list with an opt-in. Personally I'd check format once, then use it, then delete emails after 3 bounces. If a website based list, though, I'd certainly start using a double opt-in for any new emails added. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mailing to email list using CF
At send time, it's just to kick out the bad ones. I don't get it. If you check the addresses first, why check again? If an existing list, just check the format once. There is a udf on cflib.org for that. Done. Then use as normal. If an ongoing list, ALWAYS send an email to it that must be confirmed (link in it clicked) in order to be added to the list. Never just add an address. Even if correctly formatted it might be wrong. Show where you sent it so the customer can see if a spelling error: Thank you. We have sent an email to you at [EMAIL PROTECTED] Check your email. You must confirm it to be added to our list. Then you have zero bad addresses (and no real need to even check the format, though I do to point out errors first). The bad ones never arrive in their inbox and are thus never confirmed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mailing to email list using CF
I forgot to add, can't a dns check fail because rejected just like spam? Would AOL let you (and spammers) check via dns tons of AOL emails? Maybe technically unable to stop it as you disconnect as soon as connected, but maybe not. Anyone know? BTW, you could download worldcast for free and use their dns check on your list. It's a crappy little program but works. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
how to change IP cfmail uses when sending?
I'm sending email to my subscription list from my office computer using CFMX. If using cfmail, it says something like from name ([127.0.0.1]) by etc, whereas if sent by Outlook it says from [my dsl ip] by etc. Why is that? I'm thinking that the 127.0.0.1 ip won't be appreciated much by spam filters. Has anyone found that to be the case? And, if so, anyway that that can be worked around with cf? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: connect to a network db, and log on account - XP
Thank you very much, sir! I'll try that. if you want to manage servers Actually not at all (as you can tell!), I just have my little 4 computer office (through a workgroup). Just happens that I want daily to modify a program's db on another computer, converting all the prices from dollars to pounds. Long story. I assume cf can't login as Guest or whatever I am when XP starts up? Has to be a 2nd user? (If so, wouldn't all the permissions be in place already?) need to create a user on the other machine with rights to access that file The one part that I really don't understand is why I need to add the account and set permissions on the *other* computer. I would have thought that any account on my computer could access any of the available files on the network, and why not?, they were already explicitly shared. Seems redundant to have to add the account on the other computer, but maybe XP does that automatically for normal accounts and this one must be done manually? (But I don't see the names of my other computers under accounts on my computer.) But how to permit an account to access a specific file? I just know the sharing tab via properties, but that is just for network sharing. Or the account details via computer management, but nothing there about sharing a specific file. I guess just make it a regular account and it works? Thanks again. I'll try it all out. Hopefully this info will help someone later when they search ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
connect to a network db, and log on account - XP
Win XP. I can't connect to a db on my network. I get: The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. Nothing needed to open the db and I've set sharing on the folder and no one is using it. I've searched on here and one thread points to a Forta tip. Can't link to it bc of the bizarre aging way he links to them. Here it is: Having trouble getting ColdFusion to access files and directories on other servers on your network? It is likely a rights related problem. When ColdFusion is installed on NT (or Windows 2000) it is installed with standard system service access - this allows ColdFusion to access the server it is on, but not any other server. For the ColdFusion service to be able to access other servers you'll need to configure the service to log on with an actual user account. You can do this from within the Services Control Panel applet (or the Services component in Windows 2000). Sounds right, but doesn't say much. There are 3 cf services. I assume cf server is the one, not cf odbc agent, or cf odbc server? If I check properties on the cf server, the 2nd tab says Log On and I choose the This Account button, which auto-inserts a password (no idea). If I leave it at that, it never takes, just goes back to Local system account. There is an account field to fill in, but what am I supposed to fill in there? And what is the related password? I'm afraid to delete the auto-filled one there in case needed for something. Should I type Guest and delete the password? When I start up XP I don't use an account, it just starts up. So what would anyone suggest? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: connect to a network db, and log on account - XP
BTW, I just tried using the account name Guest and deleted the unknown password there. (With the unknown password still in it said it was an incorrect password.) When restarting the cf server it failed and said something bizarre like could not end the pipe, or smoked the pipe way too much. Had to reset to the Local System account button to get it to put down the pipe and start working again. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JavaScript RegEx bug in NS6?
my goal is to support users who have NN6 if at all There are only 4 people still using it, so forget it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mx error inserting date, cfqueryparameter advice
Always, for every datatype, every single time. I found a list of dtattypes for most db (the cf docs are poor!) but what about Access? I don't know what mates up with a text or memo field and such. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: form.cfid ignored. Why?
with CF5 they need to be in the URL scope before the cfapplication tag (not to be confused with application.cfm file). Thanks for confirming. Looks like I'm hosed then. The application.cfm file calls the application tag, so it will be done before the page starts. Hmmm... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: urlencode mangling accented letters
What version of CF? cf5. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: urlencode mangling accented letters
This could be related to the charset. Are you using utf-8? I'm not using a charset; it's just going right out in a cfemail. It comes in as an accent grave e, for example, and arrives as 3 or 4 chars, say a paragraph symbol and some others. This is only resulting from the urlencoding; was fine before. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: form.cfid ignored. Why?
No, just do (not tested) I don't see how that does it. The application page is called first, and it has the cfapplication tag in it, so already done by the time you start the page. But do you have control over the sending page (form)? No, coming from another site [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
