Re: Full screen?
Well what's weirder ( sillier ) is that entire operating systems don't. And by entire operating systems I mean Mac OS X. There's no fullscreen support for any of the browsers. On most Windows browsers the user can actually activate fullscreen mode independent of the web site they're on manually. On Wed, Jun 17, 2009 at 9:24 PM, Don L wrote: > > >It's part of the Flash Player. You can toggle between fullscreen and > >embedded with a simple Actionscript call. > > > > >On Wed, Jun 17, 2009 at 8:54 PM, D > > > >> > > Thanks for the info but I'll have to stay away from Flash. Weird though > why web standard does not support such a useful feature? > > ~| 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:323623 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Full screen?
>It's part of the Flash Player. You can toggle between fullscreen and >embedded with a simple Actionscript call. > > >On Wed, Jun 17, 2009 at 8:54 PM, D > >> Thanks for the info but I'll have to stay away from Flash. Weird though why web standard does not support such a useful feature? ~| 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:323622 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Full screen?
It's part of the Flash Player. You can toggle between fullscreen and embedded with a simple Actionscript call. On Wed, Jun 17, 2009 at 8:54 PM, Don L wrote: > > Hulu movie has a full screen option, I'm wondering if we could also easily > implement that for a cf web app? Has anyone done something like that? > > Thanks. > > 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:323621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Full screen?
Hulu movie has a full screen option, I'm wondering if we could also easily implement that for a cf web app? Has anyone done something like that? Thanks. 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:323620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and jQuery
Just to give you another way of looking at it. JSON is just a string format, much like WDDX is (although a lot less verbose). Without parsing, it's still just a string. The manual way of converting JSON to a JS data struct is by calling eval() on it - like so: var data = eval(myJSONString); And you are good to go. Mark On Thu, Jun 18, 2009 at 9:16 AM, Josh Nathanson wrote: > > It looks like you're getting a string back and it never becomes a > javascript > object. > > If you put dataType:'json' in your ajax params, I believe it will > automatically eval the response for you, which turns the json string > response into a javascript object. You should see this in Firebug as a > clickable green link; when you click it, it should show you the property > values. If it is not clickable, then you have a string rather than an > object. > > This is independent of passing returnformat=json to your cfc. That creates > a json string which gets passed back to the client. However you must do > something in javascript to turn the string into an object; either eval'ing > it manually, or use dataType: 'json' which will do it for you. > > -- Josh > > > > -Original Message- > From: James White [mailto:jwhite1...@gmail.com] > Sent: Wednesday, June 17, 2009 3:51 PM > To: cf-talk > Subject: Re: CFC and jQuery > > > >1) Add dataType:'json' as an attribute of your ajax call, or use $.getJSON > >2) use Firebug / console.log to examine the response, make sure DATA is a > >valid property of the response JSON > > > >-- Josh > > > > > > > >I am trying to call a query from a CFC using jQuery with the following > code: > > > >$(document).ready( > > function () { > > $.ajax({ > > type: "GET", > > url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json > >&queryformat=column", > > data: datastring, > > success: > > function(response) { > > var resp = jQuery.trim(response); > > alert(resp); > > } > > }); > > > >}); > > > >When I look at the data inside an alert it looks exactly like it should. > >However, when I try to get to the values inside of it (e.g. resp.DATA) it > is > >always undefined. Do I need to perform an extra step? I appreciate any > >advice I can get on this. > > > >Thanks, > > > >JW > > Josh, > > 1. I already am getting the results back in JSON format using the > returnformat=json parameter. I tried $.getJSON without much success (If > you > know of a good CFC example using $.getJSON, I'd be happy to review it). I > cannot even get results back using it, where as with the $.ajax I get > results, I just can't seem to do much with them but print the whole json > object(i.e. document.write) to a page or display the results in an alert > box. > > 2. I am Firebug and I did verify that DATA is a valid parameter. > Basically > I am returning a db table and putting in JSON format. The code I have > returns the following: > > > {"ROWCOUNT":20,"COLUMNS":["SAVEDVALUE"],"DATA":{"SAVEDVALUE":["blah,blah,bla > h"]}} > > But when I try and access for instance resp.ROWCOUNT, it's undefined. So > basically, I want to know how I can actually get to the values I can only > seem to read. > > Thanks, > > James > > > > > > > > > > > ~| 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:323619 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC and jQuery
It looks like you're getting a string back and it never becomes a javascript object. If you put dataType:'json' in your ajax params, I believe it will automatically eval the response for you, which turns the json string response into a javascript object. You should see this in Firebug as a clickable green link; when you click it, it should show you the property values. If it is not clickable, then you have a string rather than an object. This is independent of passing returnformat=json to your cfc. That creates a json string which gets passed back to the client. However you must do something in javascript to turn the string into an object; either eval'ing it manually, or use dataType: 'json' which will do it for you. -- Josh -Original Message- From: James White [mailto:jwhite1...@gmail.com] Sent: Wednesday, June 17, 2009 3:51 PM To: cf-talk Subject: Re: CFC and jQuery >1) Add dataType:'json' as an attribute of your ajax call, or use $.getJSON >2) use Firebug / console.log to examine the response, make sure DATA is a >valid property of the response JSON > >-- Josh > > > >I am trying to call a query from a CFC using jQuery with the following code: > >$(document).ready( > function () { > $.ajax({ > type: "GET", > url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json >&queryformat=column", > data: datastring, > success: > function(response) { > var resp = jQuery.trim(response); > alert(resp); > } > }); > >}); > >When I look at the data inside an alert it looks exactly like it should. >However, when I try to get to the values inside of it (e.g. resp.DATA) it is >always undefined. Do I need to perform an extra step? I appreciate any >advice I can get on this. > >Thanks, > >JW Josh, 1. I already am getting the results back in JSON format using the returnformat=json parameter. I tried $.getJSON without much success (If you know of a good CFC example using $.getJSON, I'd be happy to review it). I cannot even get results back using it, where as with the $.ajax I get results, I just can't seem to do much with them but print the whole json object(i.e. document.write) to a page or display the results in an alert box. 2. I am Firebug and I did verify that DATA is a valid parameter. Basically I am returning a db table and putting in JSON format. The code I have returns the following: {"ROWCOUNT":20,"COLUMNS":["SAVEDVALUE"],"DATA":{"SAVEDVALUE":["blah,blah,bla h"]}} But when I try and access for instance resp.ROWCOUNT, it's undefined. So basically, I want to know how I can actually get to the values I can only seem to read. Thanks, James ~| 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:323618 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and jQuery
>1) Add dataType:'json' as an attribute of your ajax call, or use $.getJSON >2) use Firebug / console.log to examine the response, make sure DATA is a >valid property of the response JSON > >-- Josh > > > >I am trying to call a query from a CFC using jQuery with the following code: > >$(document).ready( > function () { > $.ajax({ > type: "GET", > url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json >&queryformat=column", > data: datastring, > success: > function(response) { > var resp = jQuery.trim(response); > alert(resp); > } > }); > >}); > >When I look at the data inside an alert it looks exactly like it should. >However, when I try to get to the values inside of it (e.g. resp.DATA) it is >always undefined. Do I need to perform an extra step? I appreciate any >advice I can get on this. > >Thanks, > >JW Josh, 1. I already am getting the results back in JSON format using the returnformat=json parameter. I tried $.getJSON without much success (If you know of a good CFC example using $.getJSON, I'd be happy to review it). I cannot even get results back using it, where as with the $.ajax I get results, I just can't seem to do much with them but print the whole json object(i.e. document.write) to a page or display the results in an alert box. 2. I am Firebug and I did verify that DATA is a valid parameter. Basically I am returning a db table and putting in JSON format. The code I have returns the following: {"ROWCOUNT":20,"COLUMNS":["SAVEDVALUE"],"DATA":{"SAVEDVALUE":["blah,blah,blah"]}} But when I try and access for instance resp.ROWCOUNT, it's undefined. So basically, I want to know how I can actually get to the values I can only seem to read. Thanks, James ~| 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:323617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and jQuery
>depends on what you have in cfc as well, are you seeing the response in >firebug? > >shouldn't this: > var resp = jQuery.trim(response); > >be this: > var resp = $.trim(response); > >are you on adobe or railo? >railo this wont work yet: >&queryformat=column > > >where you getting datastring from? > > >> I am trying to call a query from a CFC using jQuery with the following >> code: >> >> $(document).ready( > >> function () { >> $.ajax({ >> type: "GET", >> url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json Dave, To answer your questions: 1. I thought jQuery.trim(response) = $.trim(response). If not, pls let me know. 2. I am using adobe/CF8 with cfeclipse. The data is returning from the CFC just fine. if use either document.write or an alert the text displays in JSON format as expected. However, if I try and call something inside of the code it comes back undefined. 3. datastring is a variable that hold the parameters that are sent back to CFC in this case the datasource and the id values (which is why I did not add them to the example code :-)). Thanks, JW ~| 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:323616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ubuntu - how WinXP compatible?
Peter Boughton wrote: > Another thought on the VM front - rather than running Windows in a Ubuntu VM, > maybe start with running Ubuntu in a Windows VM - so you've got everything > else familiar, and you can play with Ubuntu more leisurely. > > Of course, that also makes it easier to ignore/forget, since you're less > immersed, but after a while you should hopefully be comfortable enough to > switch more fully. Why not just get another computer to run it on? That way, you keep everything just as is and have another machine with Ubuntu that you can hammer on. A used one or one of the cheap systems would probably be fine. I don't know the minimum configuration for that system. Good luck, Roger -- Visit http://www.misshunt.com/ for fun and creative items including the famous Clean/Dirty dishwasher magnet, now available in velcro. ~| 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:323615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxCFC Access Denied
Wow, I'm not sure where to start. I guess I'll start by saying the whole "cf.mapping.to.ajax" string is NOT what you should actually be typing into your code unless you have an "ajax" folder in a "to" folder in a "mapping" folder in a "cf" folder in your webroot. (not likely) When the AjaxCFC documentation said that, they intended for you to replace the text "cf.mapping.to.ajax" with the actual honest-go-goodness path on your specific server. The path to a CFC is simply a period delimited list of directories starting in your web root, a mapping, or a custom tag path. If the ajax.cfc file is in the same directory as the CFC's that are extending it, then you don't need the dot delimited path. If the ajax.cfc file is anywhere else, you need to create the period delimited path to the file based on WHERE IT IS ON YOUR SERVER. From your posts, I'm not sure where you have the ajax.cfc file, but if it was off the web root in a folder called geeILikeIceCream then you would do this in your webservice: As far as your permission denied error, I don't think that has anything to do with your cfm files, what your objects do, the flow of your application, or the weather outside. Like I said in my initial reply, you need to do two things: 1) Confirm the windows user your ColdFusion service is running as 2) Grant Read rights for that user to the web-inf directory that was referenced by the error message. Until you do that, it is mostly a waste of time to talk about how the app works. If you are saying that some of your ajax calls work, but others produce that permission error, then I don't know what to tell you without knowing more information. If you can't create an instance of your component and call a method with cfinvoke (which is what AjaxCFC does) without getting that permissions denied on component.cfc then you definitely need to fix permissions. I have a suspicion that there are some other errors at play, but we will need more info than knowing that your server "barked" at you to help. Have you looked into AjaxCFC's logging feature to catch what errors are happening on the server side. Also, use Fiddler or FireBug to get the actual HTTP request of your Ajax calls and run them by themselves in a new browser window. If a bunch of Javasciprt is output it is probably working, otherwise you should see the error. Good Look. ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres Date: Wed, June 17, 2009 4:15 pm To: cf-talk OK, something weird is happing here. I did not reply to your question earlier because things seemed to start working. I made some changes to some of my logic in one my CFC and CFC file, and now that page is giving me the same error again. To answer your questions: Are you using shared hosting? Yes A VPS? No Do you have access to the CF administrator web interface? Yes Are you still getting your "Access deniedâ¦â? Yes Do you have a folder called "components" in your web root? Yes ~| 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:323614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfencode.solaris not working on our CF8-Solaris server
Dave Watts wrote: > > Can you just do the encoding on another server (or your workstation) > and copy the files to the Solaris server? I know that's a pretty lame > workaround, but I think it should work fine. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ Yup, once I worked out the LDAP problem and could think about this issue again, that workaround occurred to us as well. It was fairly easy. Encrypted the desired file on a handy windows server and just FTP it to the external Unix server and it was good to go. 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:323613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange CFLdap Active Directory issue
Dave Watts wrote: > Are other members of the proper group able to access the content? That > is, is it a user problem or a group problem? > > Can you monitor the LDAP traffic and see what's going on? > http://justgeeks.blogspot.com/2009/05/using-wireshark-to-sniff-active.html > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ It was a developer problem. Once we started systematically cataloging the users that could not access the applications, we noticed that they where all part of a specific node of our Active Directory. Once we identified this and started seeing why members of this node where excluded -- I noticed that the 'start' parameter of the LDAP tag was set to start at a node that would exclude the group of interest. I fixed the start parameter to start much higher in our LDAP tree and all was well. Thanks for the suggestions folks. Ian ~| 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:323612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
Another thought on the VM front - rather than running Windows in a Ubuntu VM, maybe start with running Ubuntu in a Windows VM - so you've got everything else familiar, and you can play with Ubuntu more leisurely. Of course, that also makes it easier to ignore/forget, since you're less immersed, but after a while you should hopefully be comfortable enough to switch more fully. ~| 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:323611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC and jQuery
1) Add dataType:'json' as an attribute of your ajax call, or use $.getJSON 2) use Firebug / console.log to examine the response, make sure DATA is a valid property of the response JSON -- Josh -Original Message- From: James White [mailto:jwhite1...@gmail.com] Sent: Wednesday, June 17, 2009 1:41 PM To: cf-talk Subject: CFC and jQuery I am trying to call a query from a CFC using jQuery with the following code: $(document).ready( function () { $.ajax({ type: "GET", url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json &queryformat=column", data: datastring, success: function(response) { var resp = jQuery.trim(response); alert(resp); } }); }); When I look at the data inside an alert it looks exactly like it should. However, when I try to get to the values inside of it (e.g. resp.DATA) it is always undefined. Do I need to perform an extra step? I appreciate any advice I can get on this. Thanks, JW ~| 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:323610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and jQuery
depends on what you have in cfc as well, are you seeing the response in firebug? shouldn't this: var resp = jQuery.trim(response); be this: var resp = $.trim(response); are you on adobe or railo? railo this wont work yet: &queryformat=column where you getting datastring from? > I am trying to call a query from a CFC using jQuery with the following > code: > > $(document).ready( > function () { > $.ajax({ > type: "GET", > url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json > &queryformat=column", > data: datastring, > success: > function(response) { > var resp = jQuery.trim(response); > alert(resp); > } > }); > > }); > > When I look at the data inside an alert it looks exactly like it > should. However, when I try to get to the values inside of it (e.g. > resp.DATA) it is always undefined. Do I need to perform an extra step? > I appreciate any advice I can get on this. > > Thanks, > > JW ~| 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:323609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
OK, something weird is happing here. I did not reply to your question earlier because things seemed to start working. I made some changes to some of my logic in one my CFC and CFC file, and now that page is giving me the same error again. To answer your questions: Are you using shared hosting? Yes A VPS? No Do you have access to the CF administrator web interface? Yes Are you still getting your "Access deniedâ¦â? Yes Do you have a folder called "components" in your web root? Yes Here is the summary of the scenario: There is a page called â/admin/permmanage/list.cfmâ that list users. Some code from this page: â¦.more codeâ¦. This page is creating the CFC object and grabs the component to return the result that fills the page. You select one or many users, and after you click âManage Permissionsâ it take you to a page called â/admin/permmanage/ManagePerm.cfmâ Some code from this page: function setPerm(val,pos) { // send data to CF var sUserID=getCookie('userIDs'); if (val == '') val='0'; DWRUtil.useLoadingMessage(); DWREngine._execute('/components/permissions.cfc', null, 'setPermUser', sUserID, pos, val, results); } // call back function function results (r) { var loadingMessage = 'Permission updated!'; $('divMessage').innerHTML = loadingMessage; } â¦.some html code here class="odd"> Select selected>None selected>View selected>Full #variables.qryPerm.ItemName# #variables.qryPerm.Position# #variables.qryPerm.Description# #variables.qryPerm.pagename# I know is a mess displaying code this way, thatâs why I didnât want to put code here yet. Anyway, as I was saying once that you select the user it will take to the page âManagePerm.cfmâ. On this page you will see all the permissions available. Each row has a drop-down with the values âselect, none, view, and fullâ On the onChange event of the drop-down and event is fired, âsetPermâ. This function makes an ajax call, that will send the value, the id, and the position of the permission to be updated on the server. There is when I get that error. Like I said, earlier this morning I modified the CFC and move the ajax.cfc to the root and it started working. The authors of AjaxCFC say the following about extending the ajax.cfc: Extending ajax.cfc To create ajax listeners you will need to extend ajax.cfc. For example: If you decide to store ajax.cfc in a different folder than your components, you will need to extend it with a mapping: Note also that your methods do not need to have remote access, making them more secure. Yesterday I moved Ajax.cfc to the âcomponentsâ folder and still was working on my machine. Then I pushed the changes to production and I had that error. Today I decided to move the Ajax.cfc back to the root, and I tried to put something similar as the documentation for my components extends="cf.mapping.to.ajax", but it started barking at me for that. I tried to research online this extends="cf.mapping.to.ajax" deal, and I couldnât get any thing. In conclusion: I believe is nothing wrong with my CFCs, their functions are returning their data back. Only when I make an ajax call is when I get the message. Now this is more weird, I have another page, (by the way my index.cfm page displays some tabs, and when you click one of the tabs, it access another page, but everything is just there) another tab (page) that creates three levels, like parent, child, and grandchild, it is making ajax calls, and it is working in some portion right. I have several actions that happen here, actions such us âcreate a new parentâ, âremoveâ a parent or child, âattachâ a link or file, and âcreateâ a child or grandchild. Well, only the âcreate a new parentâ, âremoveâ, and âcreateâ a child or grandchild are working. These all are making an ajax call. The others are not working for some reason. I am still taking the bugs from the production version. I know there is a lot, but this is what is happening. David ~| 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:323608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC and jQuery
I am trying to call a query from a CFC using jQuery with the following code: $(document).ready( function () { $.ajax({ type: "GET", url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json &queryformat=column", data: datastring, success: function(response) { var resp = jQuery.trim(response); alert(resp); } }); }); When I look at the data inside an alert it looks exactly like it should. However, when I try to get to the values inside of it (e.g. resp.DATA) it is always undefined. Do I need to perform an extra step? I appreciate any advice I can get on this. Thanks, JW ~| 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:323607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Rewriting
This is what I'm gonna do: 1. Create Virtual Directories in IIS: (ie /public/about will be /about) 2. Incoming links such as http://www.mydomain.com/public/about will be redirected to http://www.mydomain.com/about as such with IIRF RedirectRule ^/public/about /about [R=301] Am I missing anything that anyone can see? Eventually Google should start pointing to the virtual directories and I won't lose anything now or then. -- Ryan LeTulle On Wed, Jun 17, 2009 at 2:48 PM, Dave Watts wrote: > > > Unfortunately, everything is not in that folder. I toyed with Virtual > > Directories earlier. I am thinking of creating multiple virtual > directories > > like: > > /about , /about/staff ... , /visitors , /visitors/attractions > Does > > this make sense to you? > > Sure, assuming that these folders are parallel to the "pages" folder. > > > The client just doesn't want the "pages" folder to ever show in the path. > > Was told by "SEO experts" this is bad for Google and looks ugly. Maybe > it > > is bad but the pages they are referencing are their highest ranking pages > in > > Google so go figure. > > Well, I wouldn't want "/pages" in the path either, since it doesn't > add any meaningful value. Here's how I like my URLs: > > http://www.w3.org/Provider/Style/URI > > That said, if their current pages rank highly with "/pages" in the > URL, they will be throwing that away (at least temporarily) if they > discard those URLs in favor of, well, anything else. > > And as far as SEO goes, it doesn't make any difference. But nowadays, > anybody can claim to be an "SEO expert"; it doesn't count for much. > Here's a decent SEO presentation by my coworker, Steve Drucker (who > isn't an "SEO expert", but doesn't claim to be - and who has as good > or better a working knowledge of SEO as many of these so-called > "experts"): > > http://figleaf.mmalliance.acrobat.com/seo/ > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more inf > > ~| 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:323606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange CFLdap Active Directory issue
First, make sure nested groups are not the issue. AD's "memberOf" attribute returns only the first level of group membership. Ensure that the user is directly assigned to the correct group, not in a group within the correct group. Are these accounts created with the same process and/or user administrator? Look for differences there, as well. Make sure everyone creates user accounts, and assigns group membership, using the same process that is known to work. Thanks, Mike -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Wednesday, June 17, 2009 1:33 PM To: cf-talk Subject: Strange CFLdap Active Directory issue We have a intermittent strange issue using cfldap to access user's active directory records. We use this on web resources secured with Windows Integrated Security in IIS. The ColdFusion code then uses the cgi.auth_user value to read the users ldap record and parses out the groups of which the user is a member. This information is then used to authorize certain users to access certain sections of our intranet site. This all works as expected with the majority of the users. The trouble is that for four users, they are denied access to content, even though everything we can look at says they are members of the proper group. Can anybody provide suggestions on what places we should investigate this issue? What could be different about these users that prevent them from accessing resources when their neighbors and co-works can. Even in a couple of cases, a separate, new active directory account for the same user can access the content while what seems to be an identical account can not. TIA Ian ~| 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:323605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL Rewriting
> Unfortunately, everything is not in that folder. I toyed with Virtual > Directories earlier. I am thinking of creating multiple virtual directories > like: > /about , /about/staff ... , /visitors , /visitors/attractions Does > this make sense to you? Sure, assuming that these folders are parallel to the "pages" folder. > The client just doesn't want the "pages" folder to ever show in the path. > Was told by "SEO experts" this is bad for Google and looks ugly. Maybe it > is bad but the pages they are referencing are their highest ranking pages in > Google so go figure. Well, I wouldn't want "/pages" in the path either, since it doesn't add any meaningful value. Here's how I like my URLs: http://www.w3.org/Provider/Style/URI That said, if their current pages rank highly with "/pages" in the URL, they will be throwing that away (at least temporarily) if they discard those URLs in favor of, well, anything else. And as far as SEO goes, it doesn't make any difference. But nowadays, anybody can claim to be an "SEO expert"; it doesn't count for much. Here's a decent SEO presentation by my coworker, Steve Drucker (who isn't an "SEO expert", but doesn't claim to be - and who has as good or better a working knowledge of SEO as many of these so-called "experts"): http://figleaf.mmalliance.acrobat.com/seo/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inf ~| 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:323604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Completely agree with Brad. Also wouldn't hurt to ensure that the arguments parameters aren't sticky, by referencing the scope of 'language' and 'placeholder' as appropriate. SELECT content FROM translations WHERE lang = AND placeholder = SELECT content FROM translations WHERE lang = 'EN' AND placeholder = ", arguments[varName])> From: b...@bradwood.com Sent: Wednesday, June 17, 2009 3:38 PM To: "cf-talk" Subject: RE: Application Scope Problem Do you think this could have anything to do with the fact that this function is being stored in the application scope? === Yes, it has everything to do with that. You need to var EVERY variable used in that function. Otherwise it is shared by everyone calling your code at the exact same time getTranslation and varName need to be varred like so at the top of the function. ~Brad ~| 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:323603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL Rewriting
Thanks Dave. Unfortunately, everything is not in that folder. I toyed with Virtual Directories earlier. I am thinking of creating multiple virtual directories like: /about , /about/staff ... , /visitors , /visitors/attractions Does this make sense to you? The client just doesn't want the "pages" folder to ever show in the path. Was told by "SEO experts" this is bad for Google and looks ugly. Maybe it is bad but the pages they are referencing are their highest ranking pages in Google so go figure. -- Ryan LeTulle On Wed, Jun 17, 2009 at 2:32 PM, Dave Watts wrote: > > > I saw the topic of url rewriting come up here recently which peeked my > > interest so here I go with my first newb issue: > > Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is > > behaving nicely. > > > > I have a site with all pages physically located inside a subfolder (ie > > /pages) directly off the root. > > > > I was asked to remove the "pages" folder from the location that shows in > the > > web browser (ie change http://www.mydomain.com/pages/events/ to > > http://www.mydomain.com/events). > > > > I just want to hide the "pages" folder from view. > > > > Is this possible? > > If all your pages are in fact in that one folder, you can just > configure IIS to use that as the root folder. If you then want to > serve other files, like images, from a parallel folder, just create a > virtual directory pointing to that folder. There's no need to do URL > rewriting for this. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| 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:323602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Do you think this could have anything to do with the fact that this function is being stored in the application scope? === Yes, it has everything to do with that. You need to var EVERY variable used in that function. Otherwise it is shared by everyone calling your code at the exact same time getTranslation and varName need to be varred like so at the top of the function. ~Brad ~| 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:323601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Rewriting
> I saw the topic of url rewriting come up here recently which peeked my > interest so here I go with my first newb issue: > Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is > behaving nicely. > > I have a site with all pages physically located inside a subfolder (ie > /pages) directly off the root. > > I was asked to remove the "pages" folder from the location that shows in the > web browser (ie change http://www.mydomain.com/pages/events/ to > http://www.mydomain.com/events). > > I just want to hide the "pages" folder from view. > > Is this possible? If all your pages are in fact in that one folder, you can just configure IIS to use that as the root folder. If you then want to serve other files, like images, from a parallel folder, just create a virtual directory pointing to that folder. There's no need to do URL rewriting for this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:323600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange CFLdap Active Directory issue
> This all works as expected with the majority of the users. The trouble > is that for four users, they are denied access to content, even though > everything we can look at says they are members of the proper group. > > Can anybody provide suggestions on what places we should investigate > this issue? What could be different about these users that prevent them > from accessing resources when their neighbors and co-works can. Even in > a couple of cases, a separate, new active directory account for the same > user can access the content while what seems to be an identical account > can not. Are other members of the proper group able to access the content? That is, is it a user problem or a group problem? Can you monitor the LDAP traffic and see what's going on? http://justgeeks.blogspot.com/2009/05/using-wireshark-to-sniff-active.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informati ~| 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:323599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application Scope Problem
Hey guys, The company I work for has a ColdFusion function that's being stored in the application scope. This function is used to pull translated text which changes based off of the users current country that they selected. An issue we've been having however is that on occasions we will run into instances where the translator function will output the wrong string. For instance I've seen instances where pages got all messed up because we had some alt text that was being translated using this component and instead it outputted whole paragraphs from some other random location on the site. This only occurs maybe, once a month. Usually someone will call my department and complain because text is inaccurate, I ask them to reload the page and it goes away. Do you think this could have anything to do with the fact that this function is being stored in the application scope? Code Example SELECT * FROM translations WHERE lang = AND placeholder = SELECT * FROM translations WHERE lang = 'EN' AND placeholder = ", arguments[varName])> #application.translator.lookup(placeholder="testtext.69EE0E03",language=requ est.current_lang)# ~| 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:323598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfencode.solaris not working on our CF8-Solaris server
> Has anybody out there successfully used the cfencode utility on a > Solaris server? > > I've never had trouble using this utility on windows servers when > desired, but today I needed to run it on the solarirs server and it is > throwing all types of errors I don't know what to do about. > > /cfencode.solaris > /export/home/devuser/resources/cfm/prodavail/prodavail_other.cfm /v "2" > > ld.so.1: cfencode.solaris: fatal: libporting.so: open failed: No such > file or directory > Killed Can you just do the encoding on another server (or your workstation) and copy the files to the Solaris server? I know that's a pretty lame workaround, but I think it should work fine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:323597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: multiple session instances
right i see, thanks do you know of any supported ways of gathering all the active sessions. i know some have suggested to copy the session into the application scope onsessionstart and remove it onsessionend, however this has caused us problems in the past and doesnt always get deleted. thanks >I don't have an answer for your question, but since the >coldfusion.runtime.SessionTracker class is an undocumented and >unsupported "feature" of ColdFusion your only luck might be if an Adobe >programmer steps in and offers some insight to the inner working of CF. > >Let us know what you find. > >~Brad > >hi > >i have been using the following code to analyse sessions: > >var oSession = createObject("java","coldfusion.runtime.SessionTracker"); >var mySessions= oSession.getSessionCollection(arguments.appName); > >i have noticed that sometimes a session has multiple instances. for >example if i log in to our application (which creates a ), then dump out >the mySessions variable from above it sometimes has several structure >elements: > >appname_encryptedCode1 >appname_encryptedCode2 >etc... > >... and all instances have the same contents. > >they also do not get cleared when i use the structclear(session) >function... i am using j2ee session variables > >this only happens sometimes and i cannot replicate it purposely > >does anyone have any ideas? ~| 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:323596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
could it be that you only have href="test.cfm" as when they receive the email it would not know how to interpret that. you would need the full server path as well right? > I have a program that emails a user a link to verify their email. > > So I thought I would take their email and use encrypt to mask it. > Then decrypt it to verify the email against the database. > > So I wrote this and put it in the email so they could click on it: > > > > I am getting some errors where some users the URL variable "ID" (the > second variable in the hyperlink) is not defined. Like they clicked > on the link in the email and part of the URL variables were chopped > off. > > Anyone recommend a better way of making the URL so I can validate the > users email address? > > I thought URLEncodedFormat would fix any strange characters that would > not pass in a URL variable. > > Maybe it is their email program chopping off the URL variables? > ~| 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:323595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
chad, we do almost exactly the same thing and it works fine, not sure why yours would not. this is how we do it: https://#cgi.HTTP_HOST#/Folder/test.cfm?email=#encryptedEmail#";> and then in the email we have: Click Here to Validate we have never had any problems with this > I have a program that emails a user a link to verify their email. > > So I thought I would take their email and use encrypt to mask it. > Then decrypt it to verify the email against the database. > > So I wrote this and put it in the email so they could click on it: > > > > I am getting some errors where some users the URL variable "ID" (the > second variable in the hyperlink) is not defined. Like they clicked > on the link in the email and part of the URL variables were chopped > off. > > Anyone recommend a better way of making the URL so I can validate the > users email address? > > I thought URLEncodedFormat would fix any strange characters that would > not pass in a URL variable. > > Maybe it is their email program chopping off the URL variables? > ~| 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:323594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multiple session instances
I don't have an answer for your question, but since the coldfusion.runtime.SessionTracker class is an undocumented and unsupported "feature" of ColdFusion your only luck might be if an Adobe programmer steps in and offers some insight to the inner working of CF. Let us know what you find. ~Brad Original Message Subject: multiple session instances From: Richard White Date: Wed, June 17, 2009 1:02 pm To: cf-talk hi i have been using the following code to analyse sessions: var oSession = createObject("java","coldfusion.runtime.SessionTracker"); var mySessions= oSession.getSessionCollection(arguments.appName); i have noticed that sometimes a session has multiple instances. for example if i log in to our application (which creates a ), then dump out the mySessions variable from above it sometimes has several structure elements: appname_encryptedCode1 appname_encryptedCode2 etc... ... and all instances have the same contents. they also do not get cleared when i use the structclear(session) function... i am using j2ee session variables this only happens sometimes and i cannot replicate it purposely does anyone have any ideas? ~| 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:323593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Strange CFLdap Active Directory issue
We have a intermittent strange issue using cfldap to access user's active directory records. We use this on web resources secured with Windows Integrated Security in IIS. The ColdFusion code then uses the cgi.auth_user value to read the users ldap record and parses out the groups of which the user is a member. This information is then used to authorize certain users to access certain sections of our intranet site. This all works as expected with the majority of the users. The trouble is that for four users, they are denied access to content, even though everything we can look at says they are members of the proper group. Can anybody provide suggestions on what places we should investigate this issue? What could be different about these users that prevent them from accessing resources when their neighbors and co-works can. Even in a couple of cases, a separate, new active directory account for the same user can access the content while what seems to be an identical account can not. TIA Ian ~| 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:323592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ubuntu - how WinXP compatible?
Mike, As you assumed moving to another OS is not a trivial matter. I would take Peter's and Bryan's advice and take the VM approach to get your "set up" where you want it. Though they offer the lowest barrior to entry, I found live CD's to be a bit sluggish for my tastes.You can get a lot of preconfigured VM's on the internets. I would take a look at the offerings at the offerings at VMware's Virtual Appliance Marketplace http://www.vmware.com/appliances/ There are all sorts of tasty nuggets over there. You can also get a lot of preconfiged images for VirtualBox. The great thing about VM's is that you can make a copy of the VM (or take a snap shot) when you get it where you want it. Then you can experiment all you like while getting your "set up" down pat and if you hose your box you can roll back to your back up image (experience talking here ;o) ). That sure beats a total reinstall. Have fun. G! On Wed, Jun 17, 2009 at 12:27 PM, Mike Kear wrote: > > @Shannon Peevey: yes i know its off topic but i didnt want to waste > time joining a windows or a ubuntu list hoping to get a rational > objective response. And nearly all the people here have the same > kinds of issues as i do - the OS isnt the be-all and end-all its only > a side-issue on the main game which is web development. > > @Peter Boughton : thanksmy issue really was that i have a big > investment in terms of time and money and existing code in my > WindowsXP systems - i was hoping to be able to phase over from > Windows, but reading into your comments, I doubt that's going to be > the way it will happen. By the looks of it, I'm going to have to bite > the bullet and go all the way over to Ubuntu in one go, or else stay > with WindowsXP.For example i run a radio show and a radio station > library from Windows, using some windows apps, and i dont want them > down at all. So it looks like i'm going to have to think carefully > before moving to another O/S. > > Thanks for your help. > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > On Wed, Jun 17, 2009 at 10:59 PM, Shannon Peevey > wrote: > > > > Hi Mike, > > > > This is off-topic for this mailing list. You can contact me off-list if > you > > like. I have run both, plus have some insight into the multimedia > packages > > on GNU/Linux. > > > > thanks, > > speeves > > > > On Wed, Jun 17, 2009 at 7:22 AM, Mike Kear > wrote: > > > >> > >> I'm rebuilding a system and thought i might have a look at Ubuntu > >> instead of just reloading WinXPPro again .. > >> > >> I see in the Ubuntu site lots of talk about open source versions of > >> Office apps, browsers etc but no mention of compatibility (or > >> otherwise) with Windows apps.are all those other apps at all > >> compatible or do you need to find Linux/Ubuntu versions of everything? > >> > >> I can see that there are office, browser, media player equivalents > >> etc but the kinds of apps i'm thinking about are sound apps (i run > >> and edit radio shows from this machine), IDE things like Photoshop, > >> Dreamweaver, Fireworks, Flash, Audition and all those other little > >> apps that just seem to accumulate here and there. > >> > >> Generally speaking, do you have to locate equivalent Linux/Ubuntu > >> apps or do the existing WInXPPro versions generally work under > >> Ubuntu? > >> > >> -- > >> Cheers > >> Mike Kear > >> Windsor, NSW, Australia > >> Adobe Certified Advanced ColdFusion Developer > >> AFP Webworks > >> http://afpwebworks.com > >> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > >> > >> > > > > > > ~| 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:323591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading Excel Files with Coldfusion
Chad, have you looked into JExcelAPI (http://jexcelapi.sourceforge.net/), it is fantastic at reading and writing Excel documents. in fact we moved to JExcelAPI because we had so many problems with reading and writing data in Excel. sandra was right that it is due to how excel saves the data in the background. you have encountered one problem with how the data is stored but there is also many more problems that arise due to this issue. we have found JExcelAPI very easy to use, supports all our Excel activities and has good documentation >How would you go about doing it if you don't have column names to test >if would be a date value. > >The dates are counted from Excel's internally stored date of 1/1/1900. > >I did it using the following information. Note I used Ben Nadel's >POIUtility.cfc instead of using the POI libraries directly from="1" to="#local.excelsheet.maxcolumncount#" index="column"> > Replace(local.excelsheet.columnnames[column]," ","","ALL")> > > > dateAdd('d',evaluate('column#column#'),local.earlydate)> > > dateformat(local.date,"mm/dd/")> > > evaluate('column#column#')> > > > >I am currently using the code below to read in an uploaded excel file. > >CreateObject("java","org.apache.poi.hssf.usermodel.HSSFWorkbook").Init( > >CreateObject("java","java.io.FileInputStream").Init( > > CreateObject("java","java.io.File").Init( > >"#trim(SrcDirectory.SrcF_Directory)#\#UploadedFilename#" >) > ) >) /> > > >Everything works good except that it is reading date values (7/7/1996) >as a numeric values and outputting some weird long number. How can I get >it to produce 7/71996 in the output instead of a numeric value. ~| 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:323590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
multiple session instances
hi i have been using the following code to analyse sessions: var oSession = createObject("java","coldfusion.runtime.SessionTracker"); var mySessions= oSession.getSessionCollection(arguments.appName); i have noticed that sometimes a session has multiple instances. for example if i log in to our application (which creates a ), then dump out the mySessions variable from above it sometimes has several structure elements: appname_encryptedCode1 appname_encryptedCode2 etc... ... and all instances have the same contents. they also do not get cleared when i use the structclear(session) function... i am using j2ee session variables this only happens sometimes and i cannot replicate it purposely does anyone have any ideas? 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:323589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
Hey Mike, Ubuntu can do it all, but it may take some time to find the replacements. Without getting into all the detailsconsider these options: 1) dual boot Windows and Ubuntuthis is how I started my Linux adventure 2) Try the live CDcan test things out without effecting your system 3) Virtualization.using VirtualBox (now owned by Sun) for your Windows needs I made the switch over a year ago and can't say enough good things. There are issues as there are in Windows, but solving them is easier and the community is WAY more helpful. Office replacements (Open Office) and e-mail replacements (Thunderbird replaces Outlook Express and Evolution is a full-blown Outlook replacement) work very well. I've only seen one issue with an Open Office doc displaying oddly in MS Word, but tracking changes across Open Office and MS Word users has worked well. Ubuntu is also setup to behave like Windows in many wayslike all your usual shortcut keys work (CTRL+C for copy and so on). Anywaysthere's some options...hope it works out for you Cheers - Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| 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:323588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another excel file reading question
> I'm using the following code to read an excel file. But it only runs > once and I have to restart coldfusion before it will be successful again, > ... > rs.close(); I do not use dynamic odbc excel connections much. But one thing that jumps out at me is you are closing the resultset, but not the connection object. Always close both, and use error handling to make sure the objects are properly closed in the event of an error. But you might also consider using a fixed datasource instead. IIRC, you can read excel files dynamically using a single MS Access or Excel/odbc datasource. ~| 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:323587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ajaxCFC Access Denied
In order to be invoked, your CFC's need to be in the same directory of the calling page, or in a folder specified in ColdFusion Administrator as a mapping, the web root, or a custom tag path. (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=buildingComponents_27.html "Specifying the CFC location") For instance, if you created a mapping in the Admin called /hereBeDragons and it pointed to c:\someDirectory and in someDirectory you had a file called Elliot.cfc then you could create an instance of that CFC anywhere in your app as petesDragon = createObject("component","hereBeDragons.Elliot") You're skipping aroud a lot, so it's hard to help you. Are you using shared hosting? A VPS? Do you have access to the CF administrator web interface? Are you still getting your "Access denied(java.io.filepermission C:\coldfusion8\wwwroot\web-inf\cftags\componet.cfc read)" error?? Did you copy that error message exactly, because the actual file name is "component.cfc"? The code you posted earlier looked like so: createObject("component", "components.site_user") Do you have a folder called "components" in your web root, or a folder called "components" in one of your custom tag paths, or a ColdFusion mapping called "components"? That will be a good start. Take things one step at a time and tell us what errors you are getting. If all of this code worked on your development environment, chances are you just are missing some mapping on your production server. ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres Date: Wed, June 17, 2009 9:51 am To: cf-talk I had created some new CFCs for this enhancement. Do you know if this new CFCs need to be some how register in order to work on the server? By the way this is not my production server. It is host by hostmysite. Thanks, David >What Charlie pointed out was simply a syntax issue separate from what >appears to be a permissions problem. > >Your error seems to be that ColdFusion does not have read access to the >web-inf directory. What user is ColdFusion running under? If CF starts >with Windows as a service, a user can be specified for that service. >The default with windows is "System". If this is your production >server, I would recommend creating a special user for CF to run as which >is NOT an administrator for security's sake. That user will need access >to the web-inf directory among other things. BTW: component.cfc is the >base object that all components inherit from. > >Here is a knowledge base article on the subject: >http://kb2.adobe.com/cps/172/tn_17279.html > >~Brad > >Thank you for replying, > >I made the change: > > >Still the same error. > >David ~| 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:323586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URL Rewriting
I saw the topic of url rewriting come up here recently which peeked my interest so here I go with my first newb issue: Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is behaving nicely. I have a site with all pages physically located inside a subfolder (ie /pages) directly off the root. I was asked to remove the "pages" folder from the location that shows in the web browser (ie change http://www.mydomain.com/pages/events/ to http://www.mydomain.com/events). I just want to hide the "pages" folder from view. Is this possible? -- Ryan LeTulle ~| 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:323585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfencode.solaris not working on our CF8-Solaris server
Has anybody out there successfully used the cfencode utility on a Solaris server? I've never had trouble using this utility on windows servers when desired, but today I needed to run it on the solarirs server and it is throwing all types of errors I don't know what to do about. /cfencode.solaris /export/home/devuser/resources/cfm/prodavail/prodavail_other.cfm /v "2" ld.so.1: cfencode.solaris: fatal: libporting.so: open failed: No such file or directory Killed ~| 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:323584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Deploying to a server farm
We do it pretty similar to you. We are using ColdBox, so we just hit the fwreinit URL with our reinit password to pick up the changes. Of course, if are a lot of changes, we schedule a release in off-hours and lock down the site to provide a maintenance window. But for small hot fixes, we just reinit the framework and our users don't lose their sessions or anything. We usually set up DNS so we can hit out web servers individually as www1.example.com, www2.example.com, www2.example.com for web1, web2 and web3 respectively. In bouts of severe laziness we've been known to create a utility page somewhere that cfhttp's to each reset URL at the click of a button and reinits all the servers at once. On the topic, if I ever need to bounce the actual CF service on a windows box, I use a batch file and the SysInternals psservice utility: psservice \\web3 restart "ColdFusion 8 Application Server" pause ~Brad Original Message Subject: Deploying to a server farm From: Donnie Carvajal Date: Wed, June 17, 2009 10:51 am To: cf-talk My applications are hosted on multiple servers and I am storing several DAO components in the Application scope. Basically, whenever a change is made to any component that is stored in the Application scope and we deploy to the server farm, I have to restart the application on each server (basically run a web page for a URL specific to each server). What is the common practice out there for updating an application on a server farm and restarting the application to refresh the application scope components? ~| 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:323583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
@Shannon Peevey: yes i know its off topic but i didnt want to waste time joining a windows or a ubuntu list hoping to get a rational objective response. And nearly all the people here have the same kinds of issues as i do - the OS isnt the be-all and end-all its only a side-issue on the main game which is web development. @Peter Boughton : thanksmy issue really was that i have a big investment in terms of time and money and existing code in my WindowsXP systems - i was hoping to be able to phase over from Windows, but reading into your comments, I doubt that's going to be the way it will happen. By the looks of it, I'm going to have to bite the bullet and go all the way over to Ubuntu in one go, or else stay with WindowsXP.For example i run a radio show and a radio station library from Windows, using some windows apps, and i dont want them down at all. So it looks like i'm going to have to think carefully before moving to another O/S. Thanks for your help. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jun 17, 2009 at 10:59 PM, Shannon Peevey wrote: > > Hi Mike, > > This is off-topic for this mailing list. You can contact me off-list if you > like. I have run both, plus have some insight into the multimedia packages > on GNU/Linux. > > thanks, > speeves > > On Wed, Jun 17, 2009 at 7:22 AM, Mike Kear wrote: > >> >> I'm rebuilding a system and thought i might have a look at Ubuntu >> instead of just reloading WinXPPro again .. >> >> I see in the Ubuntu site lots of talk about open source versions of >> Office apps, browsers etc but no mention of compatibility (or >> otherwise) with Windows apps. are all those other apps at all >> compatible or do you need to find Linux/Ubuntu versions of everything? >> >> I can see that there are office, browser, media player equivalents >> etc but the kinds of apps i'm thinking about are sound apps (i run >> and edit radio shows from this machine), IDE things like Photoshop, >> Dreamweaver, Fireworks, Flash, Audition and all those other little >> apps that just seem to accumulate here and there. >> >> Generally speaking, do you have to locate equivalent Linux/Ubuntu >> apps or do the existing WInXPPro versions generally work under >> Ubuntu? >> >> -- >> Cheers >> Mike Kear >> Windsor, NSW, Australia >> Adobe Certified Advanced ColdFusion Developer >> AFP Webworks >> http://afpwebworks.com >> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month >> >> > > ~| 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:323582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deploying to a server farm
We used a shared SAN, so all instances of Coldfusion were looking at the same code, and then had shell scripts that would ssh into the boxes and restart the appropriate Coldfusion instances. I have also seen instances in which code is mirrored on each box, using rsync, or shell scripts to push the code out to the boxes. The push scripts would contain the restart commands, so that the server would be restarted once the new code was in place. speeves On Wed, Jun 17, 2009 at 10:51 AM, Donnie Carvajal < donnie.carva...@transformyx.com> wrote: > > My applications are hosted on multiple servers and I am storing several DAO > components in the Application scope. Basically, whenever a change is made > to any component that is stored in the Application scope and we deploy to > the server farm, I have to restart the application on each server (basically > run a web page for a URL specific to each server). > > What is the common practice out there for updating an application on a > server farm and restarting the application to refresh the application scope > components? > > ~| 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:323581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Deploying to a server farm
My applications are hosted on multiple servers and I am storing several DAO components in the Application scope. Basically, whenever a change is made to any component that is stored in the Application scope and we deploy to the server farm, I have to restart the application on each server (basically run a web page for a URL specific to each server). What is the common practice out there for updating an application on a server farm and restarting the application to refresh the application scope components? ~| 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:323580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Redirect in Application.cfc Pseudo Contructor Area: Bad Form?
This is great advice. Thank you, gentlemen. Mike -Original Message- From: Cutter (CFRelated) [mailto:cold.fus...@cutterscrossing.com] Sent: Wednesday, June 17, 2009 10:20 AM To: cf-talk Subject: Re: Redirect in Application.cfc Pseudo Contructor Area: Bad Form? Being that the https is required on every request, having this at the top of your constructor makes sense, to prevent processing of the other functions should the request be unsecure. I would put the check and redirect in a custom function, and call the function in the beginning of your constructor. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer ~| 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:323579 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Redirect in Application.cfc Pseudo Contructor Area: Bad Form?
Being that the https is required on every request, having this at the top of your constructor makes sense, to prevent processing of the other functions should the request be unsecure. I would put the check and redirect in a custom function, and call the function in the beginning of your constructor. 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/17/2009 10:02 AM, Dawson, Michael wrote: > One of the first things I want to do, on each request, is to ensure that > each request/response is secured. Therefore, if cgi.https is "off", I > will redirect the browser to the secured location. > > My plan was to put this code in the pseudo-constructor area (not in any > particular function body): > > > > > > > > > url="https://#cgi.server_name##cgi.path_info##queryString#"; > addtoken="no" statuscode="301"> > > > The code works fine, but I'm wondering if it is the wrong place to put > this code. Would it be more-semantic if it were located in the > onRequestStart function? > > On this particular site, every page will need to be secured. > > Michael Dawson > Manager of Web Applications > Office of Technology Services > University of Evansville > > Each time you send an email message with a background pattern > or loud background color, an endangered tree dies. > Please help us save a tree. Just say "NO" to email backgrounds. > > > > ~| 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:323578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Redirect in Application.cfc Pseudo Contructor Area: Bad Form?
Yes, on one of my shopping apps, I put the following right in my onRequestStart method: https://"; & cgi.server_name & cgi.path_info /> That just lets the CGI handle all the pathing etc. ~| 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:323577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Redirect in Application.cfc Pseudo Contructor Area: Bad Form?
One of the first things I want to do, on each request, is to ensure that each request/response is secured. Therefore, if cgi.https is "off", I will redirect the browser to the secured location. My plan was to put this code in the pseudo-constructor area (not in any particular function body): https://#cgi.server_name##cgi.path_info##queryString#"; addtoken="no" statuscode="301"> The code works fine, but I'm wondering if it is the wrong place to put this code. Would it be more-semantic if it were located in the onRequestStart function? On this particular site, every page will need to be secured. Michael Dawson Manager of Web Applications Office of Technology Services University of Evansville Each time you send an email message with a background pattern or loud background color, an endangered tree dies. Please help us save a tree. Just say "NO" to email backgrounds. ~| 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:323576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
I had created some new CFCs for this enhancement. Do you know if this new CFCs need to be some how register in order to work on the server? By the way this is not my production server. It is host by hostmysite. Thanks, David >What Charlie pointed out was simply a syntax issue separate from what >appears to be a permissions problem. > >Your error seems to be that ColdFusion does not have read access to the >web-inf directory. What user is ColdFusion running under? If CF starts >with Windows as a service, a user can be specified for that service. >The default with windows is "System". If this is your production >server, I would recommend creating a special user for CF to run as which >is NOT an administrator for security's sake. That user will need access >to the web-inf directory among other things. BTW: component.cfc is the >base object that all components inherit from. > >Here is a knowledge base article on the subject: >http://kb2.adobe.com/cps/172/tn_17279.html > >~Brad > >Thank you for replying, > >I made the change: > > >Still the same error. > >David ~| 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:323575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Another excel file reading question
I'm using the following code to read an excel file. But it only runs once and I have to restart coldfusion before it will be successful again, its clock word. the error message indicates system resource exceeded. Anyone figured this out? var c = ""; var stmnt = ""; var rs = ""; var sql = "Select * from [#sheetName#$]"; var myQuery = ""; arguments.filename = expandPath(arguments.filename); if(len(trim(arguments.filename)) and fileExists(arguments.filename)){ CreateObject("java","java.lang.Class").forName("sun.jdbc.odbc.JdbcOdbcDriver"); c = CreateObject("java","java.sql.DriverManager").getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" & arguments.filename ); stmnt = c.createStatement(); rs = stmnt.executeQuery(sql); myQuery = CreateObject('java','coldfusion.sql.QueryTable').init(rs); rs.close(); } return myQuery; ~| 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:323574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading Excel Files with Coldfusion
How would you go about doing it if you don't have column names to test if would be a date value. -Original Message- From: Sandra Clark [mailto:slli...@shayna.com] Sent: Wednesday, June 17, 2009 9:15 AM To: cf-talk Subject: RE: Reading Excel Files with Coldfusion The dates are counted from Excel's internally stored date of 1/1/1900. I did it using the following information. Note I used Ben Nadel's POIUtility.cfc instead of using the POI libraries directly -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: Wednesday, June 17, 2009 8:51 AM To: cf-talk Subject: Reading Excel Files with Coldfusion I am currently using the code below to read in an uploaded excel file. CreateObject("java","java.io.FileInputStream").Init( CreateObject("java","java.io.File").Init( "#trim(SrcDirectory.SrcF_Directory)#\#UploadedFilename#" ) ) ) /> Everything works good except that it is reading date values (7/7/1996) as a numeric values and outputting some weird long number. How can I get it to produce 7/71996 in the output instead of a numeric value. ~| 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:323573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Reading Excel Files with Coldfusion
The dates are counted from Excel's internally stored date of 1/1/1900. I did it using the following information. Note I used Ben Nadel's POIUtility.cfc instead of using the POI libraries directly -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: Wednesday, June 17, 2009 8:51 AM To: cf-talk Subject: Reading Excel Files with Coldfusion I am currently using the code below to read in an uploaded excel file. CreateObject("java","java.io.FileInputStream").Init( CreateObject("java","java.io.File").Init( "#trim(SrcDirectory.SrcF_Directory)#\#UploadedFilename#" ) ) ) /> Everything works good except that it is reading date values (7/7/1996) as a numeric values and outputting some weird long number. How can I get it to produce 7/71996 in the output instead of a numeric value. ~| 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:323572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
Hi Mike, This is off-topic for this mailing list. You can contact me off-list if you like. I have run both, plus have some insight into the multimedia packages on GNU/Linux. thanks, speeves On Wed, Jun 17, 2009 at 7:22 AM, Mike Kear wrote: > > I'm rebuilding a system and thought i might have a look at Ubuntu > instead of just reloading WinXPPro again .. > > I see in the Ubuntu site lots of talk about open source versions of > Office apps, browsers etc but no mention of compatibility (or > otherwise) with Windows apps.are all those other apps at all > compatible or do you need to find Linux/Ubuntu versions of everything? > > I can see that there are office, browser, media player equivalents > etc but the kinds of apps i'm thinking about are sound apps (i run > and edit radio shows from this machine), IDE things like Photoshop, > Dreamweaver, Fireworks, Flash, Audition and all those other little > apps that just seem to accumulate here and there. > > Generally speaking, do you have to locate equivalent Linux/Ubuntu > apps or do the existing WInXPPro versions generally work under > Ubuntu? > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > ~| 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:323571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reading Excel Files with Coldfusion
I am currently using the code below to read in an uploaded excel file. CreateObject("java","java.io.FileInputStream").Init( CreateObject("java","java.io.File").Init( "#trim(SrcDirectory.SrcF_Directory)#\#UploadedFilename#" ) ) ) /> Everything works good except that it is reading date values (7/7/1996) as a numeric values and outputting some weird long number. How can I get it to produce 7/71996 in the output instead of a numeric value. ~| 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:323570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
>Generally speaking, do you have to locate equivalent Linux/Ubuntu >apps or do the existing WInXPPro versions generally work under >Ubuntu? You cannot run Windows binaries (.exe) on a non-Windows system (which includes Linux, MacOS, Solaris, etc) You can get emulators (e.g. WINE) that allow you to *emulate* a Windows system, although with a limited (but growing) amount of applications that work. A better choice these days is a virtual machine (e.g VirtualBox, VMWare, etc) that allows you to run actual Windows on virtual hardware - this is likely to cope with most things, (although I'm not sure how they cope with demanding things like games). Of course, there will be Linux applications for most of what you want - whether you prefer, so it's worth giving them a try before immediately running an emulator/vm, in case you decide you prefer them. However, if you're serious about this I think your best first step might be to look for some 'introduction to Linux' guides that explains the fundamental differences, and that will allow you to better evaluate it, without necessarily having your head stuck in 'Windows mode'. ~| 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:323569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Ubuntu - how WinXP compatible?
I'm rebuilding a system and thought i might have a look at Ubuntu instead of just reloading WinXPPro again .. I see in the Ubuntu site lots of talk about open source versions of Office apps, browsers etc but no mention of compatibility (or otherwise) with Windows apps.are all those other apps at all compatible or do you need to find Linux/Ubuntu versions of everything? I can see that there are office, browser, media player equivalents etc but the kinds of apps i'm thinking about are sound apps (i run and edit radio shows from this machine), IDE things like Photoshop, Dreamweaver, Fireworks, Flash, Audition and all those other little apps that just seem to accumulate here and there. Generally speaking, do you have to locate equivalent Linux/Ubuntu apps or do the existing WInXPPro versions generally work under Ubuntu? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:323568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4