how do I use setlocale for an international application in order to display Japanese YEN
To summarize my problem, I want to use LSCurrencyFormat to format a number for Japanese yen. I am working on an international application where the OS is English version of Windows Server 2008 and an Japanese version of CF8 server. Before I make a mess on the server, I tested a different scenario on a laptop with English Windows Vista and English CF8. I added the Microsoft language pack. In the control panel, I changed the current format to Japan, current location to Japan, and system locale to Japan. After rebooting my laptop, there were a slew of problems. I could not use the application because setlocale threw errors about wrong locale, etc... What tidbits of information do I need to get the setlocale working. Is this something OS specific or ColdFusion specific. I don't know where or why this problem is occuring! I didn't want to make any changes on the server until I heard from a few of you with experience in this matter. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Glassfish Apache
On Wednesday 24 Jun 2009, Dirk Johnson wrote: Thanks, Tom. Do you have a link to the Railo info or is it pretty easy to find on their documentation site? Sean's write up is fairly good if not : http://corfield.org/blog/index.cfm/do/blog.entry/entry/Railo_for_Dummies_Part_IV_Appendix -- Helping to challengingly lead cross-platform strategic technologies as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: how do I use setlocale for an international application in order to display Japanese YEN
mike pop wrote: In the control panel, I changed the current format to Japan, current location to Japan, and system locale to Japan. After rebooting my laptop, there were a slew of problems. I could not use the application because setlocale threw errors about wrong locale, etc... change it back. setLocale() shouldn't be throwing errors because you changed the server OS locale. try describing the exact problem again. something OS specific or ColdFusion specific. I don't know where or why this problem is occuring! describing the problem in detail w/examples, etc. might be a good start. I didn't want to make any changes on the server until I heard from a few of you with experience in this matter. don't make any changes on the server. change your code. btw you don't really need to use a localized cf8 for this sort of thing. cf8 running on top of an en_US locale server will support every locale java does. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323924 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 MS SQL Server Query Problems
I'm with Mike on this one. The query is fine, as you know from running it on the DB server itself. CF does nothing more than pass through the query to the JDBC driver, but that query will present no difficulties. The only thing left that I can think of is that the datasource in CFAdmin isn't pointing to the right server and/or DB or something. Or maybe the user profile in the datasource config has no rights to see records in that table ... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Switched from CF to Java - need tool recommendations
All, I'm coming from a Dreamweaver and Enterprise Manager tool set and we've recently moved to Java and MySQL. I would appreciate some tool recommendations, especially for MySQL. Is there a tool out there that's similiar to Enterprise Manager? Thanks D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open source ColdFusion again
Just to chime in here in regards to the 'slow'/'bloatedness' of CF8's AJAX stuff... a) Don't forget that JS is still very hard for a lot of people. The built in Ajax-based UI tags are simple as heck to use. For a lot of people these tools are the _only_ way they are going to do even remotely Ajax-y. b) Don't forget that Ajax support in CF isn't just about UI. Native JSON support, returnFormat, are killer improvements. I bring this up because a lot of people will just poopoo CF8 Ajax in general without making the distinction. On Tue, Jun 23, 2009 at 11:04 AM, Don Ldo...@yahoo.com wrote: I don't understand what the question here is. As Barney suggests, openBD with GPL covers copyleft, Railo with LGPL covers bundling. There's no need or benefit to a full permissive BSD/MIT licensed engine. Don, if you want CFML-based AJAX functionality, and your engine of choice doesn't currently support it, then help them to develop it! (Or just learn jQuery and stop worrying about the rest.) Peter, thank you for your valuable thought. I seem to see a clearer picture, and will need to bug people like you onto this path... Don ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Switched from CF to Java - need tool recommendations
Hi D, Eclipse with Quantum DB could be an option for you. Good luck, speeves On Thu, Jun 25, 2009 at 8:10 AM, coldfusion.develo...@att.net wrote: t ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFDocument, finding y position?
Thanks Mike. I had googled CF8 and cfdocument...didn't think to google iText. -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Wednesday, June 24, 2009 9:43 PM To: cf-talk Subject: Re: CFDocument, finding y position? No, you can't do that using CF 8. I'm pretty sure the mid-line pagebreak issue has been discussed before if you search the archives of this list and the Adobe forums. Remember that cfdocument is a feature powered by an old version of iText, which is an active open-source project that has its own mailing list. -Mike Chabot On Wed, Jun 24, 2009 at 5:59 PM, Billy Coxbi...@oldworldspices.com wrote: I am using cfdocument to output a report that is primarily used as a print product. There are certain things like subtitles or a comment box that I might like to bump to the next page if it is going to be at the very bottom of a page. The question then... can cfdocument tell me the relative position on a printed page of whatever I am outputting? I am also getting that notorious issue where cfdocument pagebreaks and chops a line of text in half. I'm on CF8.01 so I don't think it's an issue with having out of date software. Billy Cox Old World Spices bi...@oldworldspices.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open source ColdFusion again
I'll agree with Ray on this. I have an advantage of being a JavaScripter long before I came into CF (and that was some time ago), but I know a lot of CF developers who never cultivated that skill set. The CF 8 Ajax components are an excellent entry point for those without the knowledge, as well as an terrific tool for rapid application prototyping for those who do have the knowledge, or for small applications looking for a little kick. When 'slow'/'bloatedness' become a barrier, then it's time to either learn the underlying technology to get beyond it, or to hire someone to do it for you. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Support for TAR files
Is there any library of functions to support mgmt of TAR files from a CF application? I have a TAR file on my server that needs to have files added to it as part of a web transaction, then gziped.(which there are methods for). I use the ZIP methods for the Windows zip files. Sam ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfxImage (gafware) IE8 JPEG colour rendering problem.
In reply to my own post. I'm afraid that it appears that there's no quick fix from the IE end of things. The IE blog team have confirmed that it is a problem with IE8 misinterpreting a particular type of JPEG formatting. But they haven't said if they are going to fix it or even if they consider it a proper bug. So the only way to keep your clients happy is to revise your image handling code, then re-generate/convert all the images you already have. As most of my sites are running on CF6.1 or 7 my solution was to switch to using imageCFC [http://imagecfc.riaforge.org/]. And in one case for a much older application that still runs on CF5 I moved to using Jukka Manna's cfx_image instead (It's on Adobe exchange). For the batch conversion I used Multiple Image Resizer .NET as it seemed to deliver decent cross conversions and was reasonably fast. I had one client with over 78,000 images (around 3Gb) and all created with cfxImage. It took about 6 hours... A lot of that time was waiting for windows to move the files around to a temp area first. I did it via the command line as it's really rather hard to work with that many files in windows explorer ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Glassfish Apache
Thanks again, it was helpful. A quick follow up question - my manager and I have a difference of opinion on how the whole cf8, glassfish, apache thing has to work. I think that once you deploy cf8 to glassfish you mod_rewrite/mod_proxy in apache with different virtual hosts and document roots and you should be able to serve multiple domains with requests like myweb.com and yourweb.com from document roots of san/websites/myweb and san/websites/yourweb. He believes that cf and glassfish need to be altered so that the cf app can be root along with serving myweb.com as root. Any thoughts that could help me clarify this once and for all? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion 7 or 8 and DB2 v9
Is anyone using ColdFusion 7 or 8 with IBM DB2 v9 for z/OS? I know that neither combination is supported. Thanks! George ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 7 or 8 and DB2 v9
I am not, but if there are JDBC drivers for v9, you should be able to set those up as 'other' datasource types. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 6/25/2009 10:04 AM, Earl, George wrote: Is anyone using ColdFusion 7 or 8 with IBM DB2 v9 for z/OS? I know that neither combination is supported. Thanks! George ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FedEx Rates
I am having a hard time finding example code for FedEx rate web service. They have example code on their web site for everything but CF. I checked RIAForge and could not find a project. Anyone have example code? I am reading through the docs and I cant even find the URL to hit the web service. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: autosuggest - other than cf8 solution
http://www.lalabird.com/?fa=JSMX.downloads scroll down the page to you see JSMXsuggest Example I really like JSMX very easy to use Andrew. I tried it. IE7 did not returned suggested data, Firefox 3.011 did not generate error, the error console says, results undefined with the JSMXsuggest.js. additional info: a) the two js files are correctly placed and referenced; b) the cfc file was changed to reflect my test case with one cffunction of type remote, a normal query instead of QoQ, and is located in the same directory as the caller cfm file and I also placed it as the root level just in case...; c) i left the JSMXsuggest.js intact since I'm using the same name for the cfc file that is, var URL = 'JSMXsuggest.cfc?method='; remains the same d) i tested the query by itself, ok e) i even use static ds f) for the returned data at the function, I've alternatively tried both of the following cfoutput[#result#]/cfoutput XOR cfwddx action=cfml2js input=#listToArray(result,'%')# toplevelvariable=r I'm puzzled, looks like I didn't do c) right. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Switched from CF to Java - need tool recommendations
I'm coming from a Dreamweaver and Enterprise Manager tool set and we've recently moved to Java and MySQL. I would appreciate some tool recommendations, especially for MySQL. Is there a tool out there that's similiar to Enterprise Manager? Thanks D Eclipse is very popular and a new version just came out: http://www.eclipse.org/downloads/ For MySQL I have been using Toad in Windows: http://www.toadsoft.com/toadmysql/Overview.htm Pau ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: autosuggest - other than cf8 solution
http://www.lalabird.com/?fa=JSMX.downloads scroll down the page to you see JSMXsuggest Example I really like JSMX very easy to use Andrew. the cfc has been tested, working and returns expected data, http://127.0.0.1:8600/test/JSMXsuggest.cfc?method=getProjectsvalue=g returns expected data the caller has execution problem: on autosuggest it erred Parser error: the returned value could not be evaluated (both IE7 and FF3.010) are they been hacked on this machine? thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 7 or 8 and DB2 v9
Cutter said: I am not, but if there are JDBC drivers for v9, you should be able to set those up as 'other' datasource types. Right. I'm not particularly concerned about connectivity. Our issue is one of official support from Adobe. I have to build a case that we will be fine if we have to match up CF7 or CF8 with DB2 v9. Thanks for your response. George ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: autosuggest - other than cf8 solution
Sounds like maybe your JSON is not valid. You can check it at http://www.jsonlint.com. If it checks out as valid, then start to look elsewhere. -- Josh -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Thursday, June 25, 2009 10:29 AM To: cf-talk Subject: Re: autosuggest - other than cf8 solution http://www.lalabird.com/?fa=JSMX.downloads scroll down the page to you see JSMXsuggest Example I really like JSMX very easy to use Andrew. the cfc has been tested, working and returns expected data, http://127.0.0.1:8600/test/JSMXsuggest.cfc?method=getProjectsvalue=g returns expected data the caller has execution problem: on autosuggest it erred Parser error: the returned value could not be evaluated (both IE7 and FF3.010) are they been hacked on this machine? thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) php commenting
Not CF related, but does anyone know what this is. When editing a php file in Dreamweaver, when you click on the comments button, you also get a choice that results in this: ?php /*??php */? I can't find that documented anywhere and I guess I am just curious. It does result in an error on my server so I've learned to ignore it, but I am still wondering why it is there and what the heck it is. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) php commenting
This is a cf mailing list not a php mailing list. :P Anyway, to answer your question that's used for commenting out blocks of php. Which could include html Ie; if you wanted to comment out the whole php block... ?php echo alkemadesigns.com; // php block ? p a href=http://www.alkemadesigns.com;Alkema Designs/a!-- html block -- /p You could select the whole php block then select the ?php /*??php */? comment box in Dreamweaver and it would comment out the whole block including ?php /*??php echo test; ??php */? -Original Message- From: Randi Knutson [mailto:rknut...@otan.us] Sent: Thursday, June 25, 2009 2:19 PM To: cf-talk Subject: (ot) php commenting Not CF related, but does anyone know what this is. When editing a php file in Dreamweaver, when you click on the comments button, you also get a choice that results in this: ?php /*??php */? I can't find that documented anywhere and I guess I am just curious. It does result in an error on my server so I've learned to ignore it, but I am still wondering why it is there and what the heck it is. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) php commenting
Woops.. I mean.. ?php echo alkemadesigns.com; // php block ? p a href=http://www.alkemadesigns.com;Alkema Designs/a!-- html block -- /p Could be commented out like... ?php /*? ?php echo alkemadesigns.com; // php block ? p a href=http://www.alkemadesigns.com;Alkema Designs/a!-- html block -- /p ?php */? heh, I sent email to early. -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 25, 2009 2:31 PM To: 'cf-talk@houseoffusion.com' Subject: RE: (ot) php commenting This is a cf mailing list not a php mailing list. :P Anyway, to answer your question that's used for commenting out blocks of php. Which could include html Ie; if you wanted to comment out the whole php block... ?php echo alkemadesigns.com; // php block ? p a href=http://www.alkemadesigns.com;Alkema Designs/a!-- html block -- /p You could select the whole php block then select the ?php /*??php */? comment box in Dreamweaver and it would comment out the whole block including ?php /*??php echo test; ??php */? -Original Message- From: Randi Knutson [mailto:rknut...@otan.us] Sent: Thursday, June 25, 2009 2:19 PM To: cf-talk Subject: (ot) php commenting Not CF related, but does anyone know what this is. When editing a php file in Dreamweaver, when you click on the comments button, you also get a choice that results in this: ?php /*??php */? I can't find that documented anywhere and I guess I am just curious. It does result in an error on my server so I've learned to ignore it, but I am still wondering why it is there and what the heck it is. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: CF based Message Queue - Thread safe stored procedure
Hi all, I have an issue with a stored proc that hopefully someone can help with... A little background... I built a CF based message queue system. It is pretty simple; I have a table of 'messages' in the database. I can fire up as many infinite threads as I want and they process those messages. My initial problem was that the same messages were being executed multiple times when I ran multiple threads at once. A simply CFLOCK solved that. The problem now, is that I need to allow the message queue threads to run from multiple servers at once. So now I'm back to messages getting executed multiple times when threads are running from different servers. I moved all of the SQL from the CFLOCK into a stored proc thinking that I could easily wrap the SQL in a transaction (SQL Transaction, not CF). I'm having quite a bit more trouble than I expected. I'm running into deadlocks. The whole flow of the Stored Procedure needs to be something like this... 1) Grab the next message record where the status is 'pending' 2) Update that record's status to 'running' 3) Return the record While that is running, no other process should be able to access the record that is being processed but It'd be nice if it didn't cause immediate deadlocks but waited (or even moved to the next record if possible) This is the procedure after my latest attempts. Ive actually changed the approach and updated the record first THEn grabbed it to return hoping that would help. It still the same issue. Deadlocks Not sure how this is going to come through in an email but here it is. -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[getNextMesssageQueueRecord]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[getNextMesssageQueueRecord] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE getNextMesssageQueueRecord AS SET TRANSACTION ISOLATION LEVEL READ COMMITTED BEGIN SET NOCOUNT ON; begin transaction declare @uuid nvarchar(32) set @uuid = lower(replace(newID(), '-','')) update queue.messages set messagestatus='running' , dateStarted = getDate() , messageUUID = @uuid where messageStatus='pending' and messageID in ( select top 1 messageID from queue.messages with(updlock) where messageStatus = 'pending' order by messageID ) commit transaction select messageID, messageStatus, messageXML from queue.messages where messageUUID = @uuid END Go - Any ideas to resolve this would be greatly appreciated. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PHP to CF pseudo code...
Anyone know where/how to get some PHP code translated into CF pseudo code or something a CF programmer would understand? Is there such a beast? I can post the example... its about 50 lines of code. ~Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PHP to CF pseudo code...
Hey Che, You're not going to find any sort of php to cf tool if that's what your looking for. I'm afraid if there was such a tool that it would highly inaccurate because there are so many different variations when working with both languages. There are some php to cf guides out their. http://sweatte.wordpress.com/syntax/ I found this page helpful sometimes, it has multiple languages but sometimes it's hard because sometimes there aren't direct language translations. Paul Alkema AlkemaDesigns.com -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 25, 2009 3:59 PM To: cf-talk Subject: PHP to CF pseudo code... Anyone know where/how to get some PHP code translated into CF pseudo code or something a CF programmer would understand? Is there such a beast? I can post the example... its about 50 lines of code. ~Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PHP to CF pseudo code...
Oh, I know there is no tool. But the code is pretty simple and I thought I might find a rough translation... Anyone want to to take a shot? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 25, 2009 4:18 PM To: cf-talk Subject: RE: PHP to CF pseudo code... Hey Che, You're not going to find any sort of php to cf tool if that's what your looking for. I'm afraid if there was such a tool that it would highly inaccurate because there are so many different variations when working with both languages. There are some php to cf guides out their. http://sweatte.wordpress.com/syntax/ I found this page helpful sometimes, it has multiple languages but sometimes it's hard because sometimes there aren't direct language translations. Paul Alkema AlkemaDesigns.com -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 25, 2009 3:59 PM To: cf-talk Subject: PHP to CF pseudo code... Anyone know where/how to get some PHP code translated into CF pseudo code or something a CF programmer would understand? Is there such a beast? I can post the example... its about 50 lines of code. ~Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PHP to CF pseudo code...
Sure. Highlight about 8 out of every 10 lines of the code with your mouse, then hit the delete key. From what's left, change the random, cryptic-looking function names to something more semantically valuable. That should be about right. Enjoy. On Thu, Jun 25, 2009 at 2:22 PM, Che Vilnonis ch...@asitv.com wrote: Oh, I know there is no tool. But the code is pretty simple and I thought I might find a rough translation... Anyone want to to take a shot? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 25, 2009 4:18 PM To: cf-talk Subject: RE: PHP to CF pseudo code... Hey Che, You're not going to find any sort of php to cf tool if that's what your looking for. I'm afraid if there was such a tool that it would highly inaccurate because there are so many different variations when working with both languages. There are some php to cf guides out their. http://sweatte.wordpress.com/syntax/ I found this page helpful sometimes, it has multiple languages but sometimes it's hard because sometimes there aren't direct language translations. Paul Alkema AlkemaDesigns.com -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 25, 2009 3:59 PM To: cf-talk Subject: PHP to CF pseudo code... Anyone know where/how to get some PHP code translated into CF pseudo code or something a CF programmer would understand? Is there such a beast? I can post the example... its about 50 lines of code. ~Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: autosuggest - other than cf8 solution
This made me to think of examing a bunch of the returned data sets, and there we go, some row has some single quotes. Resolved. Thank you very much. And it could also mean why it didn't work for me with Peter's option with clear instruction but the two js files are too big. Sounds like maybe your JSON is not valid. You can check it at http://www.jsonlint.com. If it checks out as valid, then start to look elsewhere. -- Josh http://www.lalabird.com/?fa=JSMX.downloads scroll down the page to you see JSMXsuggest Example I really like JSMX very easy to use Andrew. the cfc has been tested, working and returns expected data, http://127.0.0.1:8600/test/JSMXsuggest.cfc?method=getProjectsvalue=g returns expected data the caller has execution problem: on autosuggest it erred Parser error: the returned value could not be evaluated (both IE7 and FF3.010) are they been hacked on this machine? thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PHP to CF pseudo code...
You could always share and see if someone feels like translating it for you. :) -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 25, 2009 4:22 PM To: cf-talk Subject: RE: PHP to CF pseudo code... Oh, I know there is no tool. But the code is pretty simple and I thought I might find a rough translation... Anyone want to to take a shot? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 25, 2009 4:18 PM To: cf-talk Subject: RE: PHP to CF pseudo code... Hey Che, You're not going to find any sort of php to cf tool if that's what your looking for. I'm afraid if there was such a tool that it would highly inaccurate because there are so many different variations when working with both languages. There are some php to cf guides out their. http://sweatte.wordpress.com/syntax/ I found this page helpful sometimes, it has multiple languages but sometimes it's hard because sometimes there aren't direct language translations. Paul Alkema AlkemaDesigns.com -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 25, 2009 3:59 PM To: cf-talk Subject: PHP to CF pseudo code... Anyone know where/how to get some PHP code translated into CF pseudo code or something a CF programmer would understand? Is there such a beast? I can post the example... its about 50 lines of code. ~Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PHP to CF pseudo code...
Ha ha spot on! -- Josh -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: Thursday, June 25, 2009 1:26 PM To: cf-talk Subject: Re: PHP to CF pseudo code... Sure. Highlight about 8 out of every 10 lines of the code with your mouse, then hit the delete key. From what's left, change the random, cryptic-looking function names to something more semantically valuable. That should be about right. Enjoy. On Thu, Jun 25, 2009 at 2:22 PM, Che Vilnonis ch...@asitv.com wrote: Oh, I know there is no tool. But the code is pretty simple and I thought I might find a rough translation... Anyone want to to take a shot? -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 25, 2009 4:18 PM To: cf-talk Subject: RE: PHP to CF pseudo code... Hey Che, You're not going to find any sort of php to cf tool if that's what your looking for. I'm afraid if there was such a tool that it would highly inaccurate because there are so many different variations when working with both languages. There are some php to cf guides out their. http://sweatte.wordpress.com/syntax/ I found this page helpful sometimes, it has multiple languages but sometimes it's hard because sometimes there aren't direct language translations. Paul Alkema AlkemaDesigns.com -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 25, 2009 3:59 PM To: cf-talk Subject: PHP to CF pseudo code... Anyone know where/how to get some PHP code translated into CF pseudo code or something a CF programmer would understand? Is there such a beast? I can post the example... its about 50 lines of code. ~Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PHP to CF pseudo code...
Sharing has commenced. These functions are used for writing values to a flat
file from the jQuery Star Rating Widget.
//
// Functions
//
function in_range($val, $from=0, $to=100) {
return min($to, max($from, (int)$val));
}
function get_dbfile() {
return preg_replace('#\.php$#', '.dat', __FILE__);
}
function get_votes() {
$dbfile = get_dbfile();
return is_file($dbfile) ? unserialize(file_get_contents($dbfile)) :
array('votes' = 0, 'sum' = 0, 'avg' = 0);
}
function save_vote($vote) {
$db = get_votes();
$db['votes']++;
$db['sum'] += $vote;
$db['avg'] = sprintf('%01.2f', $db['sum'] / $db['votes']);
file_put_contents(get_dbfile(), serialize($db));
return $db;
}
-Original Message-
From: Paul Alkema [mailto:paulalkemadesi...@gmail.com]
Sent: Thursday, June 25, 2009 4:37 PM
To: cf-talk
Subject: RE: PHP to CF pseudo code...
You could always share and see if someone feels like translating it for you.
:)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open source ColdFusion again
I heard you, Ray, if anyone can afford cf8 for his/her work like distributing his/here ware or is lucky enough to have a fat gig with the gov or something like that, by all means, they don't have to go the open source cfml engine and ajax route and then have to pull their hair out at some point to dive into the on-and-off js world like me. To be honest, I truly like cf8's ajax tags and functions, and I would say tags like the famed cfajaxproxy is awesome but in the mean time, don't mean to be rude, some of them is indeed bloated and you've offered rationale for that. Imho, Adobe Coldfusion8 has its market and so would the other guys too. Best to everyone. Just to chime in here in regards to the 'slow'/'bloatedness' of CF8's AJAX stuff... a) Don't forget that JS is still very hard for a lot of people. The built in Ajax-based UI tags are simple as heck to use. For a lot of people these tools are the _only_ way they are going to do even remotely Ajax-y. b) Don't forget that Ajax support in CF isn't just about UI. Native JSON support, returnFormat, are killer improvements. I bring this up because a lot of people will just poopoo CF8 Ajax in general without making the distinction. On Tue, Jun 23, 2009 at 11:04 AM, D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PHP to CF pseudo code...
Not sure it's how I'd write a rating widget, but here's a fairly direct
translation.
(Untested, so may contain stupid bugs.)
cffunction name=in_range returntype=Numeric output=false
cfargument name=Val type=Numeric /
cfargument name=From type=Numeric default=0 /
cfargument name=To type=Numeric default=100 /
cfreturn min( Arguments.To , max( Arguments.From , Arguments.Val ) ) /
/cffunction
cffunction name=get_dbfile returntype=string output=false
!--- I *think* __FILE__ from original is a global constant... not
really sure? I've plonked it into Application ---
cfreturn rereplace( Application.File , '\.php$' , '.dat' ) /
/cffunction
cffunction name=get_votes returntype=Struct output=false
cfset var dbfile = get_dbfile() /
cfif FileExists(dbfile)
cfreturn deserializeJson( FileRead(dbfile) )/
cfelse
cfreturn { votes : 0 , sum : 0 , avg : 0 } /
/cfif
/cffunction
cffunction name=save_vote returntype=Struct output=false
cfargument name=Vote type=Numeric /
cfscript
var db = get_votes() ;
db.votes++ ;
db.sum += Arguments.Vote ;
db.avg = round( 100 * db.sum / db.votes ) / 100 ;
FileWrite( get_dbfile() , serializeJson( db ) ) ;
/cfscript
cfreturn db /
/cffunction
That needs CF8 or Railo 3.
If you've got Railo, you can do serialize/deserialize without using JSON, and
also use the terniary if operator (as the PHP version does).
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323955
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: CF based Message Queue - Thread safe stored procedure
On Thu, Jun 25, 2009 at 9:52 PM, Will Tomlinsonwrote: The whole flow of the Stored Procedure needs to be something like this... 1) Grab the next message record where the status is 'pending' 2) Update that record's status to 'running' 3) Return the record While that is running, no other process should be able to access the record that is being processed but It'd be nice if it didn't cause immediate deadlocks but waited In CF / SQL you don't need stored procedures for that, just the SQL FOR UPDATE to locjk a row until transaction commit: !-- Get candidate rows -- cfquery name=q1 SELECT PK FROM queue WHERE running = FALSE /cfquery cfloop query=q1 cftransaction !-- Try to lock -- cfquery name=q2 SELECT * FROM queue WHERE PK = #q1.PK# AND running = FALSE FOR UPDATE /cfquery cfif q2.recordcount !-- Lock success -- cfset result = q2 / !-- Update row -- cfquery name=q3 UPDATE queue SET running = TRUE WHERE PK = #q1.PK# /cfquery /cfif /cftransaction /cfloop This is all assuming your database understands and implements the SQL standard. If it doesn't you may have to translate some of these queries to something else, like using with (updlock) and snapshot isolation, before it works. (or even moved to the next record if possible) In order to do that you need to make q2 stop waiting for the lock. There is no way to do so in straight SQL, but several databases offer a NOWAIT keyword to affect that. Alternatively you can set a query timeout on q2 on the CF side. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CSS editor for eclipse galileo?
Hi everyone, does anyone have any recommendations for a CSS editor for eclipse galileo? I used to use aptana, but it just does WAAAY more than i need it to, and it seems to get in the way of CFEclipse at times (for example, when I have aptana cfeclipse installed i can no longer drag drop text). I'm okay with firing up an external editor if there's a good free one available. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS editor for eclipse galileo?
Web Tools Project? Mark On Fri, Jun 26, 2009 at 9:05 AM, Jake Pilgrim jpilg...@snapfitness.comwrote: Hi everyone, does anyone have any recommendations for a CSS editor for eclipse galileo? I used to use aptana, but it just does WAAAY more than i need it to, and it seems to get in the way of CFEclipse at times (for example, when I have aptana cfeclipse installed i can no longer drag drop text). I'm okay with firing up an external editor if there's a good free one available. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS editor for eclipse galileo?
I recently installed the Amateras plug-in on the recommendation of someone on the list. (Jim?) It's doing a great job with CSS, JS, and JSP editing. I think it handles XML, too, but I don't do XML, so I'm not sure about that. I tried Aptana, too, but it was wy to pushy. I don't even know that Amateras is there, except for the functions it provides. Highly recommended. Rick On Thu, Jun 25, 2009 at 7:34 PM, Mark Mandel mark.man...@gmail.com wrote: Web Tools Project? Mark On Fri, Jun 26, 2009 at 9:05 AM, Jake Pilgrim jpilg...@snapfitness.com wrote: Hi everyone, does anyone have any recommendations for a CSS editor for eclipse galileo? I used to use aptana, but it just does WAAAY more than i need it to, and it seems to get in the way of CFEclipse at times (for example, when I have aptana cfeclipse installed i can no longer drag drop text). I'm okay with firing up an external editor if there's a good free one available. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: CF based Message Queue - Thread safe stored procedure
Been having issues posting to the list, hopefully this one makes it through... (thanks for posting the question for me Will). I'll forgive the fact that you owe me a car. That is actually something I tried in the stored procedure already but it looks like my problem may actually be somewhere else all together. The queue process goes like this... 1) Grab the next message with status of pending 2) update the message status to running 3) Execute that Message 4) Log the message to a message Queue log table 5) Delete the message I was testing this with the full message queue process and should have put something together that was much smaller and just a test of the locking issue. I was queuing up about 500 messages and firing off about 5 threads to process them. When I was done, I would end up with anywhere from 450 to 475 records in the log table and 60 to 70 messages still in the queue with a status of running. What I didn't check was to see if those 500 messages actually executed... which they are; all 500 every time! So apparently now that I'm locking the records, the process that logs them , then deletes is having trouble reading/deleting them. I'm going to try and change the logic around a bit and see what I can come up with. I started out simple with this then I made it way more complicated (in my head) than it needed to be. Thanks very much for putting me back on track Jochem. I'll keep you posted on the results. Oh. By the way, I did move the sql back into CF and this is what is working. cftransaction cfquery datasource=#variables.dsn# name=local.getNextQueueItem Select top 1 m.messageID , m.messageStatus , m.messageXML fromqueue.messages m with(XLOCK, SERIALIZABLE) where m.messageStatus = 'pending' and m.dateStarted is null FOR UPDATE /cfquery cfif local.getNextQueueItem.recordcount cfquery datasource=#variables.dsn# name=local.updateMessageStatus update queue.messages set queue.messages.messageStatus = 'running' where queue.messages.messageID = cfqueryparam cfsqltype=cf_sql_integer value=#local.getNextQueueItem.messageID# / /cfquery /cfif /cftransaction .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Thursday, June 25, 2009 6:09 PM To: cf-talk Subject: Re: SOT: CF based Message Queue - Thread safe stored procedure On Thu, Jun 25, 2009 at 9:52 PM, Will Tomlinsonwrote: The whole flow of the Stored Procedure needs to be something like this... 1) Grab the next message record where the status is 'pending' 2) Update that record's status to 'running' 3) Return the record While that is running, no other process should be able to access the record that is being processed but It'd be nice if it didn't cause immediate deadlocks but waited In CF / SQL you don't need stored procedures for that, just the SQL FOR UPDATE to locjk a row until transaction commit: !-- Get candidate rows -- cfquery name=q1 SELECT PK FROM queue WHERE running = FALSE /cfquery cfloop query=q1 cftransaction !-- Try to lock -- cfquery name=q2 SELECT * FROM queue WHERE PK = #q1.PK# AND running = FALSE FOR UPDATE /cfquery cfif q2.recordcount !-- Lock success -- cfset result = q2 / !-- Update row -- cfquery name=q3 UPDATE queue SET running = TRUE WHERE PK = #q1.PK# /cfquery /cfif /cftransaction /cfloop This is all assuming your database understands and implements the SQL standard. If it doesn't you may have to translate some of these queries to something else, like using with (updlock) and snapshot isolation, before it works. (or even moved to the next record if possible) In order to do that you need to make q2 stop waiting for the lock. There is no way to do so in straight SQL, but several databases offer a NOWAIT keyword to affect that. Alternatively you can set a query timeout on q2 on the CF side. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Switched from CF to Java - need tool recommendations
not sure how these compare to Enterprise Manager (i do not do much MS SQL), but in MySQL world these are probably the most popular managers: MySQL GUI Tools from MySQL/Sun: http://dev.mysql.com/downloads/gui-tools/5.0.html SQLyog from WebYog: http://www.webyog.com/en/sqlyog_feature_list.php Navicat: http://www.navicat.com/ Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 25/06/2009 20:10, coldfusion.develo...@att.net wrote: All, I'm coming from a Dreamweaver and Enterprise Manager tool set and we've recently moved to Java and MySQL. I would appreciate some tool recommendations, especially for MySQL. Is there a tool out there that's similiar to Enterprise Manager? Thanks D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help with a SQL View?
I'm having a little trouble setting up a SQL Server VIEW to cut down on the amount of work CFQuery has to do. I need to pull in a number of tables for a newsletter system nl_master (master table containing newsletter title and such) nl_hed (a list of headers connected by the newsletter id nl_id nl_sto (all stories that go in the newsletter So, the view below is working fine. Everything is returned as it should - the one record from the master table, the related header, and all the stories: SELECT dbo.nl_master.nl_id, dbo.nl_master.nl_title, dbo.nl_heds.nl_hed, dbo.nl_sto.sto_title, dbo.nl_sto.sto_body, FROM dbo.nl_master INNER JOIN dbo.nl_sto ON dbo.nl_sto.nl_id = dbo.nl_master.nl_id INNER JOIN dbo.nl_heds ON dbo.nl_heds.nl_hed = dbo.nl_master.nl_hed Now, my problem is, there's also: nl_links (a table listing any number of links for each newsletter) nl_auth (a table listing any number of related authors ...) ... and a few more. Problem is, the second I try to add even ONE of them, the view goes nutz and I'll get the three stories returned 16 times or gawd knows what. Looking at the links table, I've tried inner and outer joins and I keep having the same problem. So adding: INNER JOIN dbo.nl_links ON dbo.nl_links.nl_nlid = dbo.nl_master.nl_id ... or ... LEFT JOIN dbo.nl_links ON dbo.nl_links.nl_nlid = dbo.nl_master.nl_id is doing the same thing. My code structure on the page is sorta: cfoutput #newsletter.nl_title# cfloop query=newsletter #newsletter.sto_title#br #newsletter.sto_body# /cfloop !--- If I add the link cells to the query with any type of join - then I add this too: --- cfloop query=newsletter #newsletter.myLNKS#br /cfloop /cfoutput I can just use a couple of additional queries for each related table, but that doesn't seem to efficient to me. No sure what I've got wrong...suggestions? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open source ColdFusion again
And how many hours of hair pulling are you putting in to figuring out the AJAX/JS stuff that's already done in CF 8? Are you able to charge for those hours? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/6/26 Don L do...@yahoo.com: I heard you, Ray, if anyone can afford cf8 for his/her work like distributing his/here ware or is lucky enough to have a fat gig with the gov or something like that, by all means, they don't have to go the open source cfml engine and ajax route and then have to pull their hair out at some point to dive into the on-and-off js world like me. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323963 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 + MySql 5 + Thai language + Macs (Paul Hastings to the resque?)
Thanks for your help Paul! A change to the css stylesheets to include 'Lucida Grande' in the fonts list seems to have solved the issue. On a side-note, I have found out that there IS actually a Microsoft Sans Serif font and it does include Thai glyphs... I am not shure where this font comes from, probably from MS Office... And I think it only gets installed when you select include support for east-asian languages (+thai) in the regional language options in control panel... Once again, thanks a lot. PS: after 9 years in Laos I think I am ready for a bit of real world now... it's scary, though... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 25/06/2009 10:01, Paul Hastings wrote: Azadi Saryev wrote: MS Sans Serif seems to display Thai text in the pages just fine on my Win XP... Well, actually the font specified in the site's stylesheet is Microsoft Sans Serif... I am not sure such font even exists - maybe my browser just substitutes its default unicode font for it? yes, there's *no* thai glyphs in that font though TIS-620 or windows-874 codepages might get something substituted. the early days of localization here were fractured in the extreme, still seeing the repercussions. The other 2 fonts specified in the stylesheet are FreesiaUPC and IrisUPC. More googling on these has led me to believe that they are NOT unicode fonts (http://www.ascenderfonts.com/font/freesiaupc.aspx and actually they are (true type unicode fonts), at least the ones we have installed are (i think they came from ms??). if you have the fonts installed on your w/s, pop open the character map utility turn on the advanced view. http://www.ascenderfonts.com/font/irisupc-bold.aspx), and are NOT generally-available fonts on a Mac OS10.4+. Am I correct? no they're not. what comes w/OSX thai is mainly codepage-based fonts (which i find funny in the extreme considering how much juice apple has spent on the ICU project). the PSL family of fonts are unicode based (i think): http://www.fontpsl.com/ in any case they seem to be the ones most of the design weenies i know use. they're not free though. I have also found references to these Thai Mac fonts: Ayuthaya, Krungthep, Sathu, Silom, Thonburi and Lucida Grande - which seem to come pre-installed on Mac OS10.2+, but I am not 100% sure these are unicode - do you know? Lucida Grande is (similar to Lucida sans unicode on windows), i think the others aren't (kind of old if i recall correctly). The designers do not seem to know unicode from a hole in the ground. yup, truer word were never spoken ;-) The client is all up-to-date Macs with 10.2+ as far as I know. can't you just ask them what fonts they have? Do you think I will be better off re-configuring the app to use a Thai codepage (tis-620 ?) instead of utf-8? is that a standard for Thai you already know what i'd say to that idea. in any case, even though TIS-620 is a standard you will find more windows-874 (which as per ms world domination plan is a superset of TIS-620). and you'd still be stuck w/the OSX windows codepage differences anyway in the end. websites? i would rather keep it all unicode/utf-8, because knowing this client they will probably want to have a site in multiple languages sometime soon... well you could roll out an instance per code page which i think adam ben would appreciate for the extra cf licenses you'd sell ;-) My Lao is pretty bad as well, at least on the speaking/reading side :) well there's always google's translation tools for a good laugh. Too late to learn it now - moving to Hong Kong in a month. Time to learn Chinese, I guess... i'd take laos over HK any day. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
