Call of a soap webservice passing headers
Hello, usually I have no problem consuming webservices, but this time I don't understand what I do wrongly; before being able to call any method, I should login, passing username and password in the soap headers; and there comes the pain : I try to call it via createboject, cfinvoke or even with cfhttp like mentionned in this post (http://blog.brijeshradhika.com/2011/04/consuming-webservice-using-coldfusion.html), I can't make it work. The documentation of the webservice provides a php example (see below). Anyone of you guys being able to translate into Coldfusion code? Thanks in advance /* Create the UsernameToken class */ class UsernameToken { public $Username; public $Password; public function __construct($username, $password) { $this - Username = $username; $this - Password = $password; } } /* Initialise the SOAP client */ $client = new SoapClient('http://www.thesite.nl/api/thesite.wsdl', array( trace = 1 )); /* Send user authentication headers */ $ut = new UsernameToken('username', 'password'); $soapHeaders[] = new SoapHeader('http://schemas.xmlsoap.org/ws/2002/07/utility/', 'UsernameToken', $ut); $client - __setSoapHeaders($soapHeaders); ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Clear out webservices?
Post is rather old but i think it still works : http://www.bpurcell.org/blog/index.cfm?entry=965mode=entry Is there any way to automatically clear out the webservices listed in the CF Admin every time the instance restarts? [circle]http://www.suny.edu/ Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398Fax: 518.320.1550 Be a part of Generation SUNY: Facebookhttp://www.facebook. com/generationsuny - Twitterhttp://www.twitter.com/generationsuny - YouTubehttp://www.youtube.com/generationsuny ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Force logout a user
Hi Uday, the CFID/CFTOKEN (or JSESSIONID) should indeed do the trick : when a user logs in to your site, you update a certain field in DB with CFID/CFTOKEN, and store it into a session user structure (that you certainly already have for the userid, name or something equivalent). When the same user logs on on a different machine (or browser but that has the same effect), you update this field again (which is the same field because it's the same user). You now just have to perform a check on every request (onRequestStart method seems perfect for this) to see if field from DB matches the value defined in the user session struct. If not, onSessionEnd() etc. Uday, Can you expand on the reason for the single machine requirement? Folks here may be able to provide an alternate direction or solution if we understand your reason for this restriction. Hi Byron, Gathering some information about users machine was a thought that came in my mind while i was implementing this solution. But this was not my purpose. My aim was to have a user logged in on ONLY one machine at any given point. Thanks Regards, Uday lead coldfusion developer ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The Symbol you provided is not a function
Did you try calling it cfset LOCAL.invCheck = checkCustomerListing(... instead of cfset LOCAL.invCheck = Super.checkCustomerListing(... ? Because if your cfc extends the parent (FeedDAO thus), it don't need to call the function with 'super', it just knows the functions enclosed in the parent's body. On Sep 6, 2011, at 9:35 AM, Daniel Short wrote: The symbol I provided sure the hell is a function! :) I have a question on StackOverflow I can't seem to figure out, so I'm posting it where all the smart CFers are. Can you help? http://stackoverflow.com/q/7272498/177534 Thanks, Dan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFLOCK QUESTION
It's correct, but you don't need to make it that long : timeout=20 is too long for me, timeout=5 would be really long enough (if not too long already). Something I don't get though : why do you make your application last the same value as the session scope? Do you really need your application to be reset every 4 hours? regards I know this is a stupid question, but I still want to be sure I'm doing this right. I have a 'Portal' which is tailored to individuals. I'm using session.userid to identify individual users so I can do lookups, etc. as specified in their various profiles. I want the session variable to last around 4 hours... this I'm using: cfapplication name=vaughn_student_portal sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,4,0,0)# applicationtimeout=#CreateTimeSpan(0,4,0,0)# When the session.userid is set I'm wrapping it in CFLOCK (like below). Please confirm... I only need that lock to hold long enough to set the variable (in case multiple people are logging in at the same time) and DO NOT need it for the entire session. cflock scope=session type=exclusive timeout=20 cfset session.userid=#getprofile.student_user_id# /cflock Does this look correct? Thanks, Robert Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams. com/unplugged ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Stupid Question
Maybe a stupid question too, but why is it better to use structkeyexists() than isdefined() ? Both will check if the given variable exists right? I don't get it, is it bound to performance or so? I thought of that, but then wasn't sure how that would behave if capability_detail was a query. On Thu, Jun 30, 2011 at 12:11 PM, Andrew Scott andr...@andyscott.id.auwrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Query Problem
I would do it this way : select b.* from b where b.id not in (select a.id from a) How about: select b.* from b left outer join a on b.id = a.id where a.id is null Carl On 6/21/2011 10:37 AM, Jenny Gavin-Wear wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Homesite 5.5
Something weird I've noticed while reading these posts : I've not read about CFBuilder, did I (or maybe I'm wrong), but people are talking about Homesite, dreamweaver, eclipse and related free ides, but not about the one made by (sold by) Adobe, which is now the main contact point for what CF is about. Anyway, I've always worked with homesite and loved it, but there's a moment changes have to occur (pity because homesite was a really good product, and i still miss it) because of some strategic moves or commercial decisions. For my concern, I had to change because I changed my main os (to mac) and had to find a professional way to work on cf projects. I thus opted for CFBuilder, and yes the change was long and painful to be honest, but is now rewarded by functionalities that Homesite do not have (version 2 of CFBuilder is well worth it now). I certainly do not want to to restart what some could call the ides comparison posts like already took place before on this community site, just wanted to give my opinion. The only thing that matters according to me is : find something that best suits you and your needs, but do not be reluctant to changes if it becomes a necessary (i told it before : i still miss my homesite 5.5 ++) Stéphane Vantroyen To answer the original question, you might have HomeSite and not realize it. It was bundled with Dreamweaver, as well as the various software bundles that contain Dreamweaver. HomeSite is somewhat hidden on these CDs and it won't appear in the list of software that is on the CD, but it is there. You have to find the HomeSite folder on the CD and install it separately from everything else. HomeSite might also be found on the various trial or demo CDs Macromedia used to hand out. -Mike Chabot On Tue, May 17, 2011 at 10:20 AM, edmo...@sitecon.com edmo...@sitecon.com edmo...@sitecon.com wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
prompt for download form cfc in ajax?
Hello guys, I'm looking for a solution to following problem : I display a dialog bow with details (legal info) on a page and would like to give the user the possibility to print it out. I've tried to this in ajax via jquery, calling a cfc and letting do the following : cfheader name=Content-Disposition value=Attachment;FILENAME=#fileName# charset=utf-8 cfcontent type = application/pdf; charset=utf-8 file=#fullPath# deleteFile = yes but never get the prompt on screen; I thought I could make use of the js print() fucntion then, but this gives me the whole page when I just need the particular info displayed in a jquery opened dialog box. Any idea? Thanks in advance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: prompt for download form cfc in ajax?
Thanks, it works indeed, I would never have thought of doing it that way. Thanks again off the top of my head, you could use an IFRAME which will allow you to invoke the PRINT command via JS and only print the content you need. On Sat, Mar 26, 2011 at 10:28 PM, Stephane Vantroyen s...@emakina.comwrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Jquery ajax and CFC ioutside webroot
Hello, in your jquery ajax call, just give the full http address of your cfc, like so : $.ajax({ url: 'http://www.yoursite.com/cfc/yourCFC.cfc?yourmethodyourargumentsIfAny', type: POST, dataType:json}); Cheers Hi All - Can I use jquery ajax to call a cfc that is located outside the webroot? I tried it but I think it is trying to look for the cfc within web root. How can I get it to point to a cfc outside the webroot? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Jquery ajax and CFC ioutside webroot
Hi, I don't think I fully understand it : isn't your cfc reachable via a dns or ip? Then I don't know if it's feasible. Are you able to read it within a browser? I mean, to see it's wsdl structure? Hello, in your jquery ajax call, just give the full http address of HI, The cfc is located outside of webroot. I cant access it using full site address the structure is as follow: E --Cfc -- website ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
local dev and isapi rewrite
Hi all, I have a local dev cf9 install on macbookpro (built-in webserver), and would like to try isapi rewrite (lite, for dev) for my devs. I think I need to install apache to be able to use isapi, so I've installed xamp too, but don't know how to 'link' apache to jrun to be able to use cf via the apache webserver (instead of the built-in one). That was question 1 :-) And then, supposedly it's working, how do I install isapi to make it work with the apache webserver config? Thanks in advance, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: why is cf_builder so expensive?
My 50 cents : I've been working with CFBuilder for about 6 months now (coming from homesite++, hard to let this one go...) and I will honestly say that it is a very good product, with some lacks or some problems (from time to time), but with great functionalities as well. It helps me to work better (it always can be better than what you know), and once used to it, it becomes your friend at work (I'm a freelance and work most of the time alone). From this point of view, I'd not say that a product that costs round 200$ (was it 300?) is 'so expensive'. If you need a working tool, be prepared to pay for it. There are other company tools (from adobe, but from other companies also) that cost a lot more, and nobody complains about it. I'll also add that you will not hear from people when a product works. You _will_ hear when it doesn't work. On Tue, Jan 25, 2011 at 9:13 PM, Sean Corfield seancorfield@gmail. com wrote: On Tue, Jan 25, 2011 at 7:05 PM, Michael Firth mfsqlserver@gmail. com wrote: Based on the feedback I am getting Builder seems to be very stable contrary to a few web posts I have read. I think a lot of people tried the public beta, had problems, and never went back after the public 1.0 release. Their loss, IMO. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 'e-commerce' product catalogue
Hi, I know this question has certainly been asked many times before, but does anyone know a good free CF 'e-commerce' product catalogue? I've searched on riaforge but didn't find anything alike? Thanks, Stephan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Preventing use of remote method by other sites
Hi, I would instantiate a session variable on begin of calling page, add it to the parameters when calling the function, and then just check in the remote function if the one given via parameter matches the one from session scope. Regards, Stephan I have a method that I'm exposing remotely. We'll be using AJAX calls to insert usability stats about a new application. I'm working through the code when I realize that since it's remote access, anyone from any site could post to it and skew our results. I'm wondering what's the best way to prevent access to this URL from any other site, or code. My first thought was to compare the current URL, dev1 for example, to the URL the request was made from, or perhaps the IP address. But I'm not sure how to get that information. Anyone have ideas? andy matthews ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Move CF website to non CF host
Hi, if your site (mean the viewed pages of the site) aren't cfm pages anymore and all are html pages (or something alike), yes you sure can. But if some called pages have cfml extension, you still need CF application server to be served to the web server. Stephane Hi, newbie here so I apologize in advance. I had a website developed that used an MS SQL database and it was done with CF. I no longer require the database or MS SQL as that part (one page) of the site is no longer used. I would like to move that site to be hosted without CF (or MS SQL). Can I just post it and have the html code run correctly without CF on the new host? Sorry for the lack of details and I'm sure there are particulars that may or may not influence the answer so a maybe, absolutely not or no problem answer are all acceptable. Thanks for any input. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JSON object error
Hello, you should return it as 'plain', and not as json (it 'double jsonencode' it then) When I use http://127.0.0.1:8500/prototype/getData. cfc?method=rptDataidval=04 in URL, I get following displayed in browser- {\COLUMNS\:[\REPORT_NAME\],\DATA\:[[\AAA\],[\BBB\]]} Looks like the JSON object is properly get created. Then not sure whats wrong ~| 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:331718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion autosuggest
I don't know where it is, but you may overwrite it with e.g. style .autosuggestcontainer li {color:navy;background-color:white;} /style Does anyone know where the css that controls the autosuggest feature of an input box. I need to adjust the layout of the results returned. ~| 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:331112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF, IE6 Ext JS Oh My!
Hi, I'm not aware of such a book, but have you tried something like : function refreshActiveTab(){ try{ var mySelectedTab = cfoutput'#url.selectedTab#'/cfoutput ColdFusion.Layout.selectTab(myTabs, mySelectedTab); return; } catch(err){} } function addLoadEvent(func) { var oldonload = window.onload; if (typeof window.onload != 'function') { window.onload = func; } else { window.onload = function() { oldonload(); func(); } } } addLoadEvent(refreshActiveTab); Where refreshActiveTab should hold the needed disabletabs of yours.. I use this to do something else, but why shouldn't it work in your case...? Ok got a question for all the gurus out there. Is there a hidden book of knowledge on the subject of ColdFusion and Ext JS for version 8 of CF? One of the annoying things I am running into that I can live with but I just want to know why it happens is this. I am using cflayout in a tabbed layout. The target browser of the client is IE 6 [Can't change it, large corporate monster I'd sooner get a pardon from the president then them upgrading.]. When the page renders, the content renders first kind of in a stack down the screen way and then there is like a slight hiccup [flicker if you will] then all the tabs get rendered properly and the display is as intended. I am wondering if like in Flex there is some kind of creation complete event that fires off when all the data is done loading and then the browser is reloading everything into the tabbed interface. The reason I am asking that question is because it spawns from another thing I noticed. I was attempting to 'hide' one of the tabs depending on if a certain flag was flipped on or off. I was controlling this via inline javascript on the page. See code below: cflayout name=DataContainer type=tab style=width:100%; height:100%; cflayoutarea name=Element1 title=Element1 !--- Content Here --- cflayoutarea cflayoutarea name=Element2 title=Element2 !--- Content Here --- cflayoutarea cflayoutarea name=Element3 title=Element3 !--- Content Here --- cflayoutarea /cflayout !--- This is directly below the cflayout --- cfif SESSION.UserBucket.UserAccess NEQ 1 script function disable_tabView(m,n){ ColdFusion.Layout.disableTab(m,n); } disable_tabView('DataContainer','Comments'); /script /cfif !--- This code is abit further down the page but still after cflayout --- input type=button value=LightsOut onclick=disable_tabView('DataContainer','Comments');/ When this page loads there is a javascript error [down in the statusbar] thrown stating that there was an unhandled exception. Appon further inspection and running this in Firefox with Error Console plugin the error states: [Error: uncaught exception: ColdFusion.Layout. disableTab: Tab layout not found, id: DataContainer] which is strange because if I click the button I have on the page, guess what, the tab is disabled. This is leading me to believe that the whole flicker problem I described above is related. Maybe the flicker I see when the browser redraws the content in to the tabs on the screen is happening after my inline js fires off, in which case I am inclined to understand why my code is busted. If this is the case, then is there an event that fires off to let me know that the browser is done redrawing the content and then I can fire off the js function? This is not super important, just wanna know why this is not working. Brett ~| 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:327831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion Builder caracter encoding
Hi guys, I've always been using Homesite to create/edit my cfm pages, and got motivated to try CF Builder on SOTR session this week, in Brussels. My problem/question is : encoding ('spelling') used by Homesite (its default, I guess) is ANSI, and if I open a Homesite created file in CF Builder, it corrupts some special caracters. Example : Home site : cfset lEntitiesChars = ç,ô,â,Ã,Ã,Ã,Ã,Ã,Å,Ã,«,»,Ã,à CF Builder : cfset lEntitiesChars = �,�,�,�,�,�,�,�,�,�,�,� In Belgium, it is a problem because we do use such special caracters. I've tried to use another encoding than the default in CF Builder (UTF_8, or ISO-8859-1), but doesn't help. And if I copy/paste the line from Homesite to CF Builder, it works, but you can imagine I can't do this kind of operation on all files of my projects. Have you got a clue on how making CF Builder to better deal with this problem? I know this possibility exists in Dreamweaver (the problem is the same but there's a work around with Dreamweaver, and this option doesn't seem to exist in CF Builder). Thanks, Stephane ~| 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:327820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stop cursor typing past 500 characters
Hi, to do you can use javascript, like here : http://javascript.internet.com/forms/limit-textarea.html Regards, Stephane Hi Iâve a text box on my form, and in the database it is set to allow 500 characters to be entered, however i can write any amount of characters above 500, I do get an error sayng: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated. But the email still sends anyway, what im trying to do is get rid of the error message altogether, so is there a way I can stop the cursor from typing past 500 characters? 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:326221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
hardaware question for cf local server
Hi guys, a stupid question for some (maybe) but i'd like to know if a small pc (like MSI Wind NetTop 110-026 or ASRock NetTop ION 330, with an Intel Atom 230 processor) is enough to run windows server 2003 and Coldfusion, for local server use only. I don't know the processor and its capabilities, nor what windows server require to run correctly. 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:325606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hardaware question for cf local server
Well, I meant, i don't know what it is capable of; the processor is a Intel Atom Dual Core 330 2 Go (1,6 GHz, DDR2 800 - PC2-6400). I'd say it will suit, but wanted to be sure of it before buying it (really cheap, not the problem, but not interessant if doesn't work at all with windows server 2003 and CF) I don't know the processor and its capabilities This is too bad, because I would say that the performance will mostly depend on the speed of the processor, and the amount of RAM it has. ~| 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:325612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hardaware question for cf local server
Thanks a lot! Unfortunately, I think the Atom is probably the least-well-suited to running serverware processor there is. You may also struggle to find Server 2003 drivers for it. You might have better luck with a dirt cheap consumer desktop. I would check out dell.com/outlet, you can get super cheap desktops fully capable of running all of your serverware for development purposes ( with significantly better performance ) for netbook price range. And they come with full warrantees. There's a 2.33 Ghz Core 2 Quad w/ 8 GB of RAM for $435, a Core 2 2.8 Ghz w/ 6GB for $350, or a 2.7 Ghz AMD Athlon w/ 4GB for $300 right now, for example, all with large 7200 RPM HDs. Dell's outlet is where I've gotten most of my dev servers over the years and I've been more than happy. They also don't charge a restocking fee if you buy one and find out it can't do what you want it to. My 2 cents. They also offer coupons every other week to cut 10-25% off of the purchase price. Here's the one I used to find those prices I listed: http://www.xpbargains.com/index.php/send_deal/116189 Good luck. On Sun, Aug 23, 2009 at 10:25 AM, Stephane Vantroyen s...@emakina.comwrote: ~| 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:325620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hardaware question for cf local server
Thanks for the answer; I will follow your advise and David's and will go for another kind of config like a 'regular' desktop (Dell or alike) machine, takes more space (and a bit more $, but not that much, in their outlet section) but it'll handle it pretty well, without having to modify anything in it. Thanks again, Stephane a stupid question for some (maybe) but i'd like to know if a small pc (like MSI Wind NetTop 110-026 or ASRock NetTop ION 330, with an Intel Atom 230 processor) is enough to run windows server 2003 and Coldfusion, for local server use only. I don't know the processor and its capabilities, nor what windows server require to run correctly. I've actually run CF on some pretty minimal hardware configurations, such as Sony and oqo UMPCs, over the last few years. If you just want to demo a site, you can certainly do this with an Atom machine, but it's going to be slow. I haven't tried installing a server OS on any of these, though. Looking at the minimum hardware requirements for Windows Server 2003, I think it'll let you install it. Memory is going to be the big limiting factor here, though, as 1 GB RAM just isn't a whole lot. I would recommend against this, though. Get something just a little bit beefier, and things will run much better. 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:325623 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Help
it's not good practice in ColdFusion to do this. I don't agree with that : sometimes you have to do multiple updates, inserts or else at the same time, depending on your process and some conditions; instead of doing multiple cfquery (and thus multiple db connections), it is sometimes cool to be able to put all the statement(s) in a variable. You then can do one cfquery for the all list of statements at once (juste separate the statements with a ;, in the string variable that you create). If you encounter the problem of the quotes (number of extra single quotes in the statement generated upon your variable), just use the PreserveSingleQuotes() function; basically, your query will look like : ('mystring' is the variable that contains your statements) cfquery name=myName datasource=myDsn #PreserveSingleQuotes(mystring)# /cfquery As Dominic said, putting the entire sql statement in as a variable in ColdFusion isn't necessary. Many languages like php that sort of thing is necessary but in ColdFusion, as Dominic said, it's just redundant. However, just for future knowledge sake, the reason your receiving this error is because when you feed in a variable with single quotes, for some reason they become duplicated when you feed it in sql. I've actually never seen this before mostly because it's not good practice in ColdFusion to do this. However, Just FYI though... the below query should work. cfset sqlToRun = INSERT INTO personalevent(eventid, userid, username, eventdate) VALUES(#FORM.eventidentity#, #FORM.whois#, '#FORM.juser#', '#FORM.eventdate#') cfquery name=addpersonaleventtome dataSource=cf_WikiData #replace(sqlToRun,'',',ALL)# /cfquery Paul Alkema Basically, the cfset sqlToRun = ... / is kind of redundant and negates the benefit of the cfquery tag. Put all you SQL inside the cfquery tag. cfqueryparam is only valid within cfquery tags. Dominic CF 8.01 OS X. I have: cfset sqlToRun = INSERT INTO personalevent(eventid, userid, username, eventdate) VALUES(#FORM.eventidentity#, #FORM.whois#, '#FORM.juser#', '#FORM.eventdate#') 1, 'jason', '2009-06-27') Which runs fine in a SQL Editor, but running that in the above cfquery I get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1'', ''1'', ''jason'', ''2009-06-27'')' at line 1 There are a number of extra single quotes that I dont see why. If I try converting to crqueryparam I have something messed up because I get an error: I did: cfset sqlToRun = INSERT INTO personalevent(eventid, userid, username, eventdate) VALUES(cfqueryparam value=#FORM.eventidentity# cfsqltype=CF_SQL_INTEGER, cfqueryparam value=#FORM.whois# cfsqltype=CF_SQL_INTEGER, cfqueryparam value=#FORM.juser# cfsqltype=CF_SQL_VARCHAR, cfqueryparam value=#FORM.eventdate# cfsqltype=CF_SQL_DATE) ~| 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:324063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
I would suggest doing this way : cfquery name=myQueryyour query here/cfquery cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all') ] So you have a list in the same format as your example here below; Then you just replace the list (with [ and ]) by cfoutput#myList#/cfoutput in the script Theer are other ways of doing this I'm sure, but that's the one I would use to go faster Stéphane I am trying to use jquery code provided by one of the online samples. The code is below. As you can see the city list is hard coded. I am wondering if I can create my own searchable list from query results and replace the list below with my new list. Thanks for any suggestions. script type=text/javascript $(document).ready(function() { $(#country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(#city).autocompleteArray( [1,2,3,Brighton and Hove,Bristol, Cambridge,Canterbury,Carlisle,Chester,Chichester, Coventry,Derby,Durham,Ely,Exeter,Gloucester,Hereford, Kingston upon Hull,Lancaster,Leeds,Leicester,Lichfield, Lincoln,Liverpool,London,Manchester,Newcastle-upon-Tyne, Norwich,Nottingham,Oxford,Peterborough,Plymouth, Portsmouth, Preston,Ripon,Salford,Salisbury,Sheffield,Southampton, St Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield, Wells, Westminster,Winchester,Wolverhampton,Worcester,York], { minChars:1, delay:10, autoFill:true, matchSubset:1, matchContains:1, selectOnly:1 } ); }); /script ~| 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:322875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
Have you tried to dump the value of the list to see if it matches the format of the list in the jquery script? You also may wanna try to put the list in a script var and use it : script type=text/javascript var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput; $(document).ready(function() { $(#country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(#city).autocompleteArray(scriptList), { minChars:1, delay:10, autoFill:true, matchSubset:1, matchContains:1, selectOnly:1 } ); }); /script Thanks The list creation does exactly what I need it to but the cfoutput... does work. It's not giving an error but the autocomplete does nothing. ~| 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:322885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question on jquery..need answer pretty quickly if possible
Yes, i guess... if still not working try displaying an alert of the var in the script, to see what's wrong with it Would it look like this? cfoutput script type=text/javascript var scriptList = '#myList#'; $(document).ready(function() { $(##country).autocomplete( data/country.cfm, { minChars:2, delay:200, autoFill:false, matchSubset:false, matchContains:1, cacheLength:10, selectOnly:1 } ); $(##city).autocompleteArray( scriptList, { minChars:1, delay:10, autoFill:false, matchSubset:10, matchContains:10, selectOnly:10 } ); }); /script /cfoutput ~| 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:322888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFAjax problem - cant see why this doesn't work
Hi, you have to convert your query before returning it to the grid, with queryConvertForGrid : your cfreturn should look like : cfreturn QueryConvertForGrid(QGetCountries, page, pageSize) Regards, Stéphane Is the cfcs.utilities.utilitieslibrary mapping correct? Adrian Building a database of ColdFusion errors at http://cferror.org/ I am experimenting with the ajax parts of CF8, and I'm following the video on the Adobe site where it shows how to build a master detail application using the CF8 inbuilt ajax stuff. It has a CFGRID tag, which binds to a cfc method. There's where my problem arises i think.I have a simply utilities cfc that has some commonly used methods, one of which is getCountries() which returns a query containing country names and abbreviations. When i call the method using the tags i've always used, i get a query object which i can dump and it shows exactly what i'd expect. However when i use CFGrid, bound to the same method, I get an empty query, and therefore an empty grid. I'be checked that the method is access=remote, but what else have i missed? Here's the CFGrid tag: cfform scriptsrc=/cms/forms/scripts cfgrid name=TrialGrid format=html pagesize=15 bind=cfc:cfcs.utilities.utilitieslibrary.GetCountriesGrid( {cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection} ) bindonload=yes cfgridcolumn name=country header=Country display=yes / cfgridcolumn name=countrycode header=Country Code display=yes / cfgridcolumn name=countryid header=countryid display=no / /cfgrid /cfform and here's the method in the Utilitieslibrary cfc : cffunction name=GetCountriesGrid output=false returntype=query access=remote hint=Returns a list of countries for drop down list cfargument name=cfgridpage required=no type=string / cfargument name=cfgridpagesize required=no type=string / cfargument name=cfgridsortcolumn required=no type=string / cfargument name=cfgridsortdirection required=no type=string / cfquery name=QGetCountries datasource=thetestdsn SELECT Country, countrycode, countryid FROM Countries ORDER BY Country /cfquery cfreturn QGetCountries / /cffunction Can anyone see why calling this method using CFINVOKE returns a result and using CFGrid doesnt? -- 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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to create an .xls file from a page
Hi, another possibility is to use the POI Utility you can find on Ben Nadel's page : http://www.bennadel.com/blog/865-POIUtility-cfc-Examples-For-Reading-And-Writing-Excel-Files-In-ColdFusion.htm Greets Stéphane I wouldn't say it is the *best* way but this will maintain table layouts: http://mgt.pastebin.com/f27bd1c5a Another way to do it is what Mike Chabot suggested. Yet another way: Create a spreadsheet and fill the places where you want your data to go with CF vars #.yourQury.yourVar# and then save as XML or HTML (I forget) and use the above method to populated it and force it to the browser. HTH ~G~ On Mon, Oct 27, 2008 at 3:14 PM, Brian Yager [EMAIL PROTECTED]wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 HTML CFGRID with checkbox possible with binding?
Hi guys and gals, has anybody already had the following question (and its answer of course) : is there a solution (soft, CF, ... whatever) to convert a pdf into html content? Thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PDF into HTML?
Sorry guys I think I've posted this item first in the wrong section... So the question : has anybody already had to do the following : convert pdf docs into html content? Thanks in advance, ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
variable session is undefined
Hi guys, i think some of you already encoutered the same problem : when using j2ee session variables, I sometimes get the message variable session is undefined... what I tried to solve by checking the existence in application.cfc (on requeststart, cfif not isdefined('session')), but that doesn't work. I also tried to change the value of validity length of the session in web.xml to match with the one in CF admin, but doesn't solve the problem either... Any idea, clue? Thanks, Stephane ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: variable session is undefined
CF8, patch 8.0.1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Interesting results with setting variables - cfset vs. using a cfscript block
You should read this, quite interesting (CF8 vs CF7 etc) : http://neilmiddleton.com/2007/07/01/cf-8-and-performance-comparisons/ Regards, Stephane ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFile append with a source file?
Hi, i'm looking for a custom tag (cfx or anything else) that would allow me to use cffile action=append with a source file: the purpose here is to merge several documents (xml files) into another one without having to read them in a variable (too large amount of data for the server's RAM). Thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4