Message from v_roma Most recent post: 10/27/2007 4 authors and 4 replies. Hi, Is it possible to check where a visitor is coming from and only allow that visitor to view a page if coming from a specific domain? This domain'd be outside my website. Also, I'm using ColdFusion 5. Thanks much! read more about Check for referrers
Message from gr8white Most recent post: 10/26/2007 2 authors and 2 replies. Is there a way to protect an Excel workbook created using CFCONTENT so the user can not unprotect it? I can protect the workbook using XML - but the user can just remove the protection. APparently you can not add password protection using XML (if you protect a workbook with a password Excel does not let you save as XML). I'm guessing this is not possible but I told my manager I'd try to find out. Thanks, Ken read more about Protect Excel file?
Message from kruse Most recent post: 10/26/2007 3 authors and 3 replies. I have a flash grid that shows some data. When a line is clicked (onchange="listingGridChanged()") the following actionscript is executed. <CFFORMITEM type="script"> public function listingGridChanged():Void { actionMessage.text = foodList.selectedItem.Id; } </CFFORMITEM> But instead of showing the id found I will execute an CFC that retrieves data from that id. Is this possible? read more about Can an Action script execute an cfc?
Message from chazman113 Most recent post: 10/26/2007 5 authors and 5 replies. I'm working with the new cf8 CFLAYOUT tag to create a tab-based system. I also use <CFINPUT type="datefield" to get the nice ajax date selector. My problem is whenever I click on the date image it'll open up the mini calendar and my tabs (that contain the cfinput) will dissapear in IE6! I have tried applying the "IE7" compliance fix from sourceforge but still the same problem. Any suggessions as to how to fix this? read more about IE6 CFLAYOUT tabs and datefield bug
Message from TNMellowMan Most recent post: 10/26/2007 3 authors and 5 replies. I have a problem with my server getting a JRun error and stopping Cold Fusion entirely if a linked database becomes unavailable. My database will still be available and as long as nothing in the application hits the linked database, my system is fine. After several hits to the linked database, the Cold Fusion server dies and never logs any error. All of the queries are in cftry/CFCATCH blocks. I am assuming that the database connection is timing out because of the linked database being unavailable. Is there any other way to catch these errors so I can error out without dropping the whole system? Web Server: ColdFusion MX 6.1 updater 2 with database update patches Windows Server 2003 IIS 6.0 Database Server: Oracle 9.4.0.4 Windows Server 2003 Thanks read more about Database Link down crashing server
Message from Photoshare Most recent post: 10/26/2007 4 authors and 4 replies. I am trying to find software that'd allow visitors to upload a photograph(s) to see how they'd look in selected greeting cards or frames. I have the greeting cards scanned and saved in .PNG format with a transparency window for showing the photograph but I need to find a tool that'd allow the image to be resized or cropped by the visitor - to best fit the opening in the frame or card. Any thoughts on where I should look or start? Thanks in advance. Ron read more about Manual Photo Cropping / Resizing within Page
Message from Jatrix Most recent post: 10/26/2007 2 authors and 3 replies. Can CF8 be run on a virtual machine? if so, what'd the requirements be? read more about CF 8 On a virtual machine
Message from drybagel Most recent post: 10/26/2007 2 authors and 3 replies. I am creating a Web Service in Cold Fusion MX 7 and I am looking for help on its design. The problem is, one of the cffunction's called "calculateQuote" requires over 30 <cfargument...> statements to get all of the necessary input. To make matters worse, 10 of these arguments describe insurance policies as part of the quote and each policy can occur from 1 to many times. I am envisioning a <cffunction...> statement that is enormous. As an alternative, is it reasonable to have 1 <cfargument...> statement that contains an xml document that has all of the input?'d this be a strange thing to do or is it a "normal" way to write web services that require a lot of input data? Here is what I'd assume the CFFUNCTION'd look like... <CFFUNCTION access="remote" name="calculateQuote" output="false" returntype="???"> <CFARGUMENT name="xmlQuoteInput" type="???" required="true"> ... <CFSET strucValidate = XmlValidate(ARGUMENTS.xmlQuoteInput,myXSDFile)> <!--- Validate the XML ---> <CFSET varXMLQuoteInput = XmlParse(ARGUMENTS.xmlQuoteInput)> ... and so on </CFFUNCTION> Thank you! read more about Creating Web Service - Repeating data structure
Message from Kac1e Most recent post: 10/26/2007 2 authors and 4 replies. I have a session variable in my application, and sometimes it just mysteriously can not be found or it is 'undefined' right now it is undefined when using it in a query for a report. But on my bosses computer it is working. So right now he can view the data, but I get an undefined error. I lock it when I make it, and I used to have it locked everywhere I used it, but I changed it to lock only when I make it. I really do not understand locks, some say you need them every time, some say you do not. I also do not know if that has anything to do with why the session variable. The variable stays alive throughout all the pages...but once I get to the last page it dies...and only sometimes, like this has not happened to me since I took all the locks off. Keep in mind it is working fine for my boss right now...any suggestions? read more about session variably mysteriously dropped
Message from larksys Most recent post: 10/26/2007 4 authors and 8 replies. I can not be the only one on earth with this error/problem. I have 2 pieces of code that are essentially the same. One works and one produces the error "error invoking cfc....:internal server error". read more about error invoking cfc: internal server error
Message from YogeshM Most recent post: 10/25/2007 2 authors and 9 replies. Hi, I'm currently using POI to generate Microsoft Excel documents from ColdFusion I believe it's a great tool because it gave me the possibility to export the data on different worksheets, etc. Before using POI, I was just using only ColdFusion (see PART 1 in attached code). The advantage was that I could display all 3 tables in 1 page and control their display using plain html. The disadvantage was that, when the request was to display each product details on 1 separate worksheet, I was stuck! And this is where using POI becomes interesting! However, I have noticed that you can only export 1 query to the POI, and my question is: Is there a way to pass more than 1 query to the POI, so that it displays in the same way as it'd using ColdFusion (3 different blocks or tables)? This is because, even though I have to separate each product on a separate worksheet, I still need to have the same display i.e. 1 table for the Overall, then a blank column (separator), 1 table for the "Entries", then a blank column as separator again, and then 1 table for the "Exits". (Forget about the names Overall, Entries and Exits, this is just an example. I only need to display 3 sections of data on the same sheet). Now, since I do not know if this is possible or not, I have tried to work around the problem differently. What I have done is to create 1 query (see PART 2 in attached code). Now, here I have got a big problem, especia read more about Need some help with POI pls...
Message from Tinaja Most recent post: 10/25/2007 2 authors and 3 replies. I am trying to use the following code to bind to a JAVAscript function and it's not working. I finally had to use jQuery to bind the event handler, but I would like to see the ColdFusion generated stuff work. Am I missing something here? This jquery code is the workaround: $('.match').change(function(){ updateSA(this); }) <CFINPUT name="bMatch_#getSA.seminarattendee_id#" class="match" type="checkbox" checked="#getSA.bMatched#" bind="JAVAscript:updateSA(this)"> The JAVAscript looks like this: updateSA = function(ele) { var o = {}; var p = new reconcile(); var id = ele.id.split("_")[1]; var midEle = $('#ministryID_' + id)[0]; var mcidEle = $('#ministryContactID_' + id)[0]; o.mid = midEle.options[midEle.selectedIndex].value; o.mcid = mcidEle.options[mcidEle.selectedIndex].value; o.bMatch = 0; o.id = id; if (ele.checked){o.bMatch = 1} p.setAsyncMode(); p.setCallbackHandler(ajaxResponse); p.updateSA(o); } ajaxResponse = function(r) { console.log(r); } read more about Binding to a JAVAscript function isn't working
Message from tslow Most recent post: 10/25/2007 5 authors and 8 replies. I cannot get <CFFLUSH> to work on a CF8 server. I am doing a simple cfoutput, running a CFX sleep tag, and then outputing more text with a cfoutput. On my CF6.1 server (which is identical besides the version of CF), this works correctly. On the CF8 server, nothing is displayed until the whole page finishes. Both servers are running on Windows 2003 IIS 6. I'm returning a large chunk of text in both cfoutputs, so it's not the browser complaining that there is not enough text. Thanks, Tim read more about CF8 CFFLUSH not working
Message from susanring Most recent post: 10/25/2007 2 authors and 2 replies. There are three folders. fbx_settings.CFM dsp_recommendation.CFM Mainsubmenu.CFM how do they work together? There are three folders. These are under the one of the main folders/menu menu2 So it Is LLS /menu2/recognition And then the 3 files fbx_settings.CFM dsp_recommendation.CFM Mainsubmenu.CFM I understand that dsp is a fuse but what does this code do ? It has a loop ? <CFLOOP from="1" to="#arraylen(request.menu.main)#" index="x"> <CFSET link = "#self#?fuseaction=#request.menu.main[x][2]#&do=view&menu=#attributes.menu#"> <CFIF CompareNocase(x,attributes.menu)> <CFSET imgSubMenugege = "gegemenu3.gif"> <CFELSE> <CFSET imgSubMenugege = "gegemenu.gif"> </CFIF> <a href="#variables.link#" <CFIF ListContainsNoCase(attributes.fuseaction, "#request.menu.main[x][3]#")>class="thislinksthemainmenu"</cfif# request.menu.main[x][1]#</a> | </CFLOOP> Then it has a fbx_settings <CFSET XFA in the fbx_settings? Also, what does this CFSCRIPT do in Mainsubmenu.cfm? <CFSCRIPT> request.menu.Main2 = arraynew(2); a = 1; request.menu.Main2[a][1] = "bandera"; request.menu.Main2[a][2] = "#XFA.refbandera#"; request.men read more about There are three folders. fbx_settings.cfmdsp_recommendation.CFM Mainsubmenu.CFM how do they worktogether?
Message from UpstateWeb Most recent post: 10/25/2007 3 authors and 3 replies. I am using ColdFusion 6.1 on Windows: ESPN sent me 4 URL's for sports score content that I can use for an affiliate website. The problem is, I can not figure out how to use it. I do not think it is a true RSS feed. Can someone tell me how to best use this information: http://proxy.espn.go.com/profile/affiliate/scores?sport=mlb&width=125 Thanks in advance for your help, David G. Moore, Jr. UpstateWeb LLC read more about Specific RSS Feed from ESPN
Message from mactech999 Most recent post: 10/25/2007 2 authors and 2 replies. I have a login page that was created with Cold Fusion. This page links to an ASPX page what I would like to happen is when the client logs in the userID is carried over to the Asp.net page. the variable in CFML is a Session Variable. any ideas?? read more about Transfering a CFML session variable to an ASP.Net Page
Message from TheScarecrow Most recent post: 10/25/2007 2 authors and 8 replies. Ok I have a DIV that on rollover of an object it changes position to the mouse pointer. However, I also want it to replace the content of the DIV tag with Cold Fusion code. Something like this: <CFOUTPUT><img src="../#staffmember.imageName[3]#" align="middle"><span class="style1"> #staffmember.wName[3]# </span> </CFOUTPUT> Does anyone know how to do this? Thanks. (current link code): <a onmouseover="ShowContent('magnify'); return true;" onmouseout="HideContent('magnify'); return true;" href="JAVA script:ShowContent('magnify')"> IMAGE </a> read more about CSS & Cold Fusion, replacing DIV content
Message from WolfShade Most recent post: 10/24/2007 4 authors and 28 replies. Hello, all. In the past, I always used HASH to encrypt the password for users; all I needed to do was to check the HASHed value from login and compare to what is in the db - simple. Now I have a client that'd like to add a password retrieval system to the site. I'm having difficulties with the values never being the same. Originally I tried encrypting with BLOWFISH, but that did not work for decrypt. Here is the code I have, so far: APPLICATION.CFM: <CFSET request.cryptAlgorithm = "DESEDE"> <CFSET request.cryptEncoding = "HEX"> <CFSET request.cryptKey = GenerateSecretKey(request.cryptAlgorithm)> <CFSET request.cryptPhrase = "Eightcha"> LOGINACTION.CFM <CFSET session.user.password = URLEncodedFormat(Encrypt("#trim(form.password)#", request.cryptKey, request.cryptAlgorithm)) /> <CFSET session.user.SQLpassword = trim(replace(session.user.password,"'","''","all")) /> <CFQUERY name="checkLogin" dbtype="odbc" datasource="#request.data_source#"> EXEC check_login @xxxxxxxxxxx='#trim(session.user.username)#', @xxxxxxxxxxx='#trim(session.user.SQLpassword)#' </CFQUERY> <CFDUMP var="#checkLogin#"><CFABORT> I'm dumping the results of the query and aborting to view the values; the password is always changing. How can I keep the value always the same? Thanks, ^_^ read more about Encrypt / Decrypt help
Message from akkraus Most recent post: 10/24/2007 3 authors and 3 replies. I am using the anchor tag to navigate from one page to another. I am passing parameters to the page via the anchor tag as well. Ie <A HREF="test.cfm?Param1=Yes&Param2=No">Edit</A> Is there any way to do this without showing the parameters in the path displayed in the browser? read more about Hide parameters passed in path
Message from ogre11 Most recent post: 10/24/2007 3 authors and 4 replies. Is it possible to use regex variables with rereplace? For instance if I wanted to put brackets around the area code in a phone number, I'd like to do the below code, but it doesnt work, just sees the variable as a string rereplace(someNumber, "([\d]{3,3})", "($1)") read more about regex variables in rereplace
Message from cepsJane Most recent post: 10/24/2007 2 authors and 6 replies. Hi there, I am trying to use CFDOCUMENT to generate Avery labels for a abel printer. Basically I query the db and write the data to the pdf. The CFDOCUMENT tag I am using is: <CFDOCUMENT format="pdf" unit="in" margintop="0.05" marginbottom="0" marginleft="0" marginright="0" pagetype="custom" pagewidth="2.5" pageheight="2" fontembed="yes" orientation="portrait" scale="100"> My problem is the name and the mailing address are displayed from the middle of the label and the address line get saperated into two lines even though these are still a lot of spaces left on the first line of address. I have specified the marginleft="0" and marginright="0" but they didn't work. Any ideas? Thanks a lot. read more about use CFDOCUMENT to create avery labels
Message from susanring Most recent post: 10/24/2007 2 authors and 2 replies. i found it in a dsp_name.CFM what is findNOcase ? client.Roles? what does this code do ? <CFPARAM default="0" name="CreatedShowAll">? what is findNOcase ? <CFIF FindNoCase("Target Regional", client.Roles) OR FindNoCase("Target Manager", client.Roles)> <CFPARAM default="0" name="CreatedShowAll"> <CFELSE> <CFPARAM default="1" name="CreatedShowAll"> </CFIF> read more about what is dsp_name.cfm: findNOcase , client.Roles,[code][/code]?
Message from stephenmbell Most recent post: 10/24/2007 3 authors and 3 replies. I have done some research on the CFSETTING tag, specifically, the showdebugoutput attribute, and for some reason, I cannot get it to work. I am having an issue with part of my site, where, in development, a particular action page works fine, but in production, the same action page, given the same input parameters doesn't execute successfully. In production, I am in a shared hosting environment. Is there a way to turn on debug output if I set a url.debugoutput = true?? thanks in advance. sb read more about Displaying Debug Output?!?
Message from Gimmejazz56 Most recent post: 10/24/2007 2 authors and 3 replies. Hello, I'm trying to suppress the <CFHTTPPARAM type="header" name="Request-number" value="1"> <CFHTTPPARAM type="header" name="Document-type" value="Request"> <CFHTTPPARAM type="header" name="Merchant-id" value="1111111"> <CFHTTPPARAM type="header" name="Trace-number" value="#ATTRIBUTES.OrderID#"> <CFHTTPPARAM type="header" name="Accept" value="application/xml"> <CFHTTPPARAM type="header" name="Content-Type" value="application/OU812" > </CFHTTP> <CFDUMP var="#CFHTTP.FileContent#"> Response: <?xml version="1.0" encoding="UTF-8"?> <Response> <QuickResp> <ProcStatus>05</ProcStatus> <StatusMsg>OU812,TEXT/XML; CHARSET=UTF-8 isn't supported</StatusMsg> </QuickResp> </Response> read more about CFHTTP header trouble
Message from cfchick12 Most recent post: 10/24/2007 5 authors and 6 replies. Hi, I need help with accessing some rows from Sql Server database(a select statement) when I am inserting rows into DB2 database within the cftransaction. I get the following error. "Message : Data source MANAGEMENT verification failed. Detail: The root cause was that: JAVA.sql.SQLException: Datasource names for all the database tags within CFTRANSACTION must be the same." I realised I can not perform this. Eventhough I didn't like the idea, I put this in a request variable in application.cfm. Then I try to do a QofQ using the Request variable, I still get the same message. I can not perform this after the commit, it has to be within that transaction. Right now my solution is putting it in application.CFM and looping the query to get my result. Is there a better solution for this? Thanks all for your time. read more about CFTRANSACTION with Multiple Datasource /Query
Message from barrys2552 Most recent post: 10/24/2007 3 authors and 3 replies. In general how do I get better and more information in the logs when a Cold Fusion/jrun process hangs. Currently we are running Cold Fusion MX7 7.0.2,142559 and JRUN4 build 106363. The process is a JAVA process thats spawned off from Cold Fusion, and it hangs never returning any informatin in the logs. read more about ColdFusion MX7 troubleshooting
Message from jasonpresley Most recent post: 10/24/2007 2 authors and 2 replies. I am developing and application that I am planning on "leasing" out to busnesses but to keep my source code safe I'll only allow the application to be run under a hosting account that I control so that the source isn't subject to being stolen. Other then CFENCRYPT (which can be decrypted) is there a way for me to distribute my application to companies that want to outright purchase it and allow them to install it on a different server yet protecting the source code? Can I compile it into .jar files and us it that way? And if so how do I do that? Thanks, read more about Protecting Source Code
Message from obouillaud Most recent post: 10/24/2007 6 authors and 19 replies. Hi Here is my problem : as soon as I create a cfc, it takes a lot of time (on a computer time scale). Here is a simple test : On my server it takes between 170 and 200 ms for each loop of hundred CFC generations. That is around 16ms for each CFC... where is the error ??? As soon as I need inheritance or imbricated cfc's for example to display a small list of 5 products on a page, it takes 150-400 ms to generate !!! Do you've the same behavior ? <CFLOOP from="1" to="10" index="j"> <CFSET start = GetTickCount()> <CFLOOP from="1" to="100" index="i"> <CFSET "product_#j#_#i#" = CreateObject("component","composants.produits.test")> </CFLOOP> <CFSET looptime = GetTickCount() - start> <CFOUTPUT> #j# : #looptime# ms<br /> </CFOUTPUT> </CFLOOP> ------------------------------------------------------ and my test.CFC file : <CFCOMPONENT> </CFCOMPONENT> read more about CFC generation is slow
Message from cffan3 Most recent post: 10/24/2007 3 authors and 5 replies. Hi all, I have a major problem connecting to a webservice provided by SABRE (the travel agency people). If you try to consume : http://cert.webservices.sabre.com/wsdl/sabreXML1.0.00/tpf/OTA_AirPriceLLS1.1.1RQ .wsdl You get this exception in CF: Couldn't generate stub objects for web service invocation. Name: https://cert.webservices.sabre.com/cert. WSDL: https://cert.webservices.sabre.com/cert. WSDLException (at /soap-env:Envelope): faultCode=INVALID_WSDL: Expected element '{http://schemas.xmlsoap.org/wsdl/}definitions'.: It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can not be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. I can browse the WSDL just fine (try it yourself). Obviously having the WSDL modified is out of the question, as billion-dollar company like SABRE are not exactly going to listen to this puny ColdFusion developer :-D The question is: Is Cold Fusion compatible with all webservices? Or is the one described above somehow only work with certain platforms? Cheers! read more about Is Cold Fusion NOT compatible with some webservices?
Message from GiambattistaScivoletto Most recent post: 10/24/2007 2 authors and 2 replies. Hi, I'm building a simple Cold Fusion-ajax forum. It works quite fine but I have a problem. Since when someone click on a link of a post I do something like this: <a href="void(NULL)" onclick="ajax_open_post_in_a_div_on_the_same_page"> Using this solution the link of the post will never be set as "visited". So, I'd like to find an alternate solution to set VISITED or READ posts already read. Actually I tried to use cookies: I set a coookie in which I insert all post visited's IDs. But I have the limitation of 4 kb. Other options are: 1) To create a database table in which I put all post read from each user. 2) To create a txt file for each user in which put all post read. Are there smarter solutions for you? Or less stupid ... :-) ... ? I'm not a great programmer, unfortunely ... read more about Cold Fusion Ajax Forum
Message from Lumpia Most recent post: 10/23/2007 3 authors and 4 replies. Developers, I realize that iText has been widely discussed here and Cold Fusion MX 8 now includes the <CFPDF> tag to merge and alter pdfs, but my company still uses CFMX 7 and PDFLib and am hoping for some assistance in altering pdflib code to work with Cold Fusion. Below is the example pdf merge file provided by PDFLib. It is written in JAVA, much like the iText example was, and then coded for Cold Fusion by PaulH http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=7&t hreadid=1114635. Thanks in advance for any and all help. Code: /* $Id: starter_pdfmerge.JAVA,v 1.8 2007/08/30 18:30:50 katja Exp $ * PDF merge starter: * Merge pages from multiple PDF documents * * Interactive elements (e.g. bookmarks) will be dropped. * * Required software: PDFlib+PDI/PPS 7 * Required data: PDF documents */ package com.pdflib.cookbook.pdflib.pdf_import; import com.pdflib.pdflib; import com.pdflib.PDFlibException; public class starter_pdfmerge { public static void main (String argv[]) { /* This is where the data files are. Adjust as necessary. */ String searchpath = "../input"; String outfile = "starter_pdfmerge.pdf"; String title = "Starter PDF Merge"; pdflib p = null; String pdffiles[] = { "PDFlib-real-world.pdf", "PDFlib-datasheet.pdf", "TET-datasheet.pdf", "PLOP-datasheet.pdf", "pCO read more about PDFLib Cold Fusion example
Message from eleeana Most recent post: 10/23/2007 2 authors and 4 replies. Whenever I attempt to parse any google rss or atom feeds the xmlparse function says that they are invalid XML. Has anyone ever run into this before? I am able to parse any other feed that I have tried, Google seems to be the only issue. I am using CF7. <CFHTTP url="http://news.google.com/?output=rss" method="get"> <CFSET myXMLDoc = xmlParse(cfhttp.filecontent)> read more about xmlparse() and google rss/atom feeds
Message from apocalipsis19 Most recent post: 10/23/2007 2 authors and 4 replies. At work, I was required to create a report. We don't have the ColFusion report tool so when we are creating reports we use the <CFDOCUMENT> tags. I'll explain now what my structure was about. I was required to break down the students in a school by grade then within each grade (1,2,3,etc), break them down by race (white, hispanic, black, asin, pacific islander etc) then within each race break them down by curriculum code (special ed, regular ed, etc etc). So I created my structure and guys you should've seen my smile when I dumped my structure and saw that beautiful structure in blue and black font on my browser.......then my smile was even wider (ear to ear) when I ran my query against the school data and I got the correct results. My smile disappear when I wanted to display that "crosstab" in my cfdocument. It looks and sounds like if I needed to create a business object from scratch but I really thought there was a way for me to manipulate the rows and columns of an html table dynamically according to the data that they were receiving form my structure. After 7 days of my time a two projects backed up for the company my boss asked to stop and after analyzing from top to the bottom the case we both concluded that it was a nightmare to do unless we had a reporting tool. I can not stop thinking aobut this problem even though it was 3 weeks ago. I even dream about the freaking sutuation. I want to get it done! I know I am bei read more about Cold Fusion Structure and a HTML Table
Message from larksys Most recent post: 10/22/2007 3 authors and 8 replies. I'm a little frustrated with CF8 and the new Spry functions. I'm trying to convert my old autosuggests to the CFINPUT and binding with a function in a cfc. I'm trying to follow the examples