Message from swap_18 Most recent post: 10/27/2007 2 authors and 2 replies. I am using ColdFusion 8 to develop forms. I need to check if user has entered a value of type "text". If not then a message has to Cfoutput. I am using the following code: <CFIF not isdefined("form.question")> <CFOUTPUT> Enter question </CFOUTPUT> </CFIF> The problem is even f nothing is entered in the Question Field, the message Enter question isn't being displayed. Its as is the <CFIF not isdefined("form.question")> isn't at all being recognised. I also tried <CFIF not isdefined("form.question_now")> Please help. read more about
Message from dave.frank Most recent post: 10/27/2007 2 authors and 4 replies. I am interested to learn about database development for use with ColdFusion dynamic development. Before I make any significant financial investments I'm wondering if [u]MS SQL Server 2005[/u] [b]Express Edition[/b] is a reasonable place to start learning about db development. The Adobe Cold Fusion 8 SYSTEMS SUPPORT MATRI X indicates compatibility with: Microsoft SQL Server 7.0, 2000, 2005 - Does this compatibility include the FREE [u]MS SQL Server 2005[/u] [b]Express Edition[/b] ? Does it bother Microsoft that folks may want to use their db solutions with a competitor's dynamic-development solutions? In other words, are the compatible db products fully functional with CF? read more about MS SQL Server 2005 - Express Edition?
Message from zac1234 Most recent post: 10/27/2007 2 authors and 2 replies. hello everyone, could do with some quick help please as i'm at a a crucail part of my site. i'm using CFMX7 and i'm trying to create a new datasource but when it comes to the bit where you browse to the DB file it says: "unable to authenticate on rds using current security information" what does this mean and what can I do to sort it? thanks zac read more about RDS error when adding new datasource
Message from Nordiam Most recent post: 10/26/2007 3 authors and 6 replies. I'd love to know if it is possible for a Cold Fusion developer to speak with Adobe tech support for free, I remember Sarge at a conference saying this was possible? I'm no stranger to configuring JRun, but I'm totally lost. After completely uninstalling CF7, I tried installing CF8 (single instance) to run through IIS 7 on Vista Ultimate. At the end of the install, it fails to configure the web connectors, stating that the port (51020) may be blocked by firewall, etc. I can get to the actual JRun web service in a browser (and .CFM files work), but I could not get the connector working. In jrun.xml, I have tried setting deactivated to false in jrun.xml for JRunProxyService, and changing the ports for the proxy (and also the JRun Naming Service, and the JRun Web Server)... numerous times... all to no avail. I have verified through port scans that all the above ports are open and listening (many port changes and ColdFusion service restarts). I have even tried specifying the starting port and number of ports from the command line, as in -DWSConfig.PortScanStartPort=startport -DWSConfig.PortScanCount=portrange, etc. No matter what I do, the web server configuration tool tells me that it, "Couldn't connect to any JRun/Cold Fusion servers on host localhost"... but I can connect through the JRun web server port. I have tried all this by uninstalling and reinstalling CF8 without firewall or anti-virus software as well. I decided th read more about Cold Fusion 8 Install/Config Problems
Message from Naim.Beg Most recent post: 10/26/2007 3 authors and 6 replies. When I try using the browse feature, for instance under Packaging & Deployment, in Cold Fusion Archives, when I hit the Browse Server button I am getting a "Server Error, IO error on server communication" error window. How can I resolve this??? Windows 2003 IIS 6.0 JRun 4.0 Updater 7 Cold Fusion8 jdk1.6.0_02 read more about Browse feature in ColdFusion Admin not working.
Message from Detlef Most recent post: 10/26/2007 3 authors and 3 replies. Hi, I am new to this forum, I saw Ben Forta these days explaining, that it is possible to make executables (.exe) from CMFL files using Cold Fusion. Is that true? How can I find a tutorial for this? didnt fint it in the help files! Please help! Greetings from Germany Detlef read more about Create an .exe with Cold Fusion
Message from melvebak Most recent post: 10/26/2007 2 authors and 2 replies. Is there any issue with Uninstalling Cold Fusion MX with Cold Fusion 8 also on server? We've both install at the same time and'd like to remove Cold Fusion MX now that Cold Fusion 8 is running successfully. Are there any issues with shared files that we could mess everything up by unistalling Cold Fusion MX now? read more about Uninstalling Cold Fusion MX with Cold Fusion 8 also onserver
Message from PHall Most recent post: 10/26/2007 2 authors and 2 replies. If I have Windows 2003 Server with service pack 1, and I want to install CF8 Standard, do I have to add the R2 package to the Windows Server 2003? read more about R2 required for CF8 Standard?
Message from dgiet Most recent post: 10/26/2007 2 authors and 3 replies. Hi all, I'd like to download french language for Verity / Cold Fusion MX 6.1. The only link I have found ask me MX 7 serial number and, of course, don't allow me with my 6.1 serial number. Thanks for your help. read more about French Verity package for MX 6.1
Message from mega_L Most recent post: 10/26/2007 5 authors and 15 replies. I'm calling an existing function called PLayout() from 2 different locations. PLayout function and the calling functions are all at the same page. From the 1st location, on top of the page, I'm passing PID: <CFSET PLayout(UserID,PID)> From the 2nd Location, at the bottom of the page, I'm passing DocID : <CFSET PLayout(UserID,DocID)> This is the existing Function: <CFFUNCTION name="PLayout" output="No"> <CFARGUMENT name="UserID" required="Yes"> <CFARGUMENT name="PID" required="Yes"> <CFARGUMENT name="DocID" required="No"> <<<<< I added this and required set to NO otherwise I got error saying DocID isn't passed. <CFQUERY datasource="#application.maindsn#" name="doInsert"> DECLARE @xxxxxxxxxxx int; SET @xxxxxxxxxxx = (SELECT SetVal FROM SysSet WHERE SetName = 'Layout' AND PID = <CFIF IsDefined ("DocID")> #DocID# <CFELSE> #PID# </CFIF>); DELETE FROM J_Plans_Layouts WHERE PlanID = #UserID#; INSERT INTO J_P_L(UserID, PID, LayoutID) VALUES(#UserID#,<CFIF IsDefined ("DocID")> #DocID# <CFELSE> #PID# </CFIF>, @xxxxxxxxxxx); </CFQUERY> </CFFUNCTION>[/ read more about How to pass diff. Values to the same function
Message from Adomacro Most recent post: 10/25/2007 4 authors and 8 replies. [Macromedia][Sybase JDBC Driver][Sybase]Implicit conversion from datatype 'VARCHAR' to 'SMALLINT' isn't allowed. Use the CONVERT function to run this query. read more about How to fix this?
Message from Libby H Most recent post: 10/25/2007 3 authors and 5 replies. I am at my wits end trying to fix what I think is a client variable problem. I am currently running CFMX 6.1 + updaters on a Windows 2003 R2 SP1standard edition server with IIS 6.0. Since implementing with this server (01/2007), we have installed all the necessary Windows patches for security every month. I have installed hot fixes for client variables (TN 19590) and a few others for COM and CFFORMS issues. I have experienced ColdFusion 'hanging'; not allowing anyone into the application. I shut down the ColdFusion MX Application service, the ColdFusion MX ADBC agent, and try to shut the ColdFusion MX ODBC server, but it remains in a 'stopping' state, with a reboot the only cure. While trying to troubleshoot the problem, I have come across the following error: 10/16 15:12:24 error Operation failed on the data source named "Treasury". Cold Fusion.runtime.ClientScopeDBException: Operation failed on the data source named "Treasury". at Cold Fusion.runtime.JDBCHelper.Store(PersistenceFactory.JAVA:261) at Cold Fusion.runtime.ClientScopeServiceImpl.PersistClientVariables(ClientScopeServ iceImpl.JAVA:282) at Cold Fusion.runtime.ClientScopeServiceImpl.PersistClientVariablesForRequest(Clien tScopeServiceImpl.JAVA:264) at Cold Fusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilt er.JAVA:32) at Cold Fusion.filter.BrowserFilter.invoke(BrowserFilter.JAVA:35) at Cold Fusion.filter.GlobalsFilter.invoke(Glo read more about Client Variable Purge
Message from PeytonT Most recent post: 10/25/2007 3 authors and 4 replies. Hello. I'm just about to return to ColdFusion programming after 5 years in academia. Back when I stopped ColdFusion progamming, we were at version 5, and now I see we're up to version 8. Anyway, I have just persuaded an old FoxPro client of mine to let me enhance his website using ColdFusion. The site was written by another programmer using ASP (3.0, not .NET)while I was away from programming.The enhancement I make will have its own url since it'll serve a different group of users, but the catch is that it must run on the same server, at the same time, as the ASP site. Will that be a problem? I assume the answer is 'Of course not! No problem at all!' Right? (except, I suppose, that the ColdFusion site will be ignorant of variables set and objects created by the ASP site and vice versa - is that right? In any case it would be no problem). Apologies for my ignorance. I was once a crackerjack ColdFusion programmer, but just as with FoxPro, I was only good at writing applications. I never did know much about or much enjoy the wider system which the application belonged to! Oh, and before I forget: Obviously ColdFusion runs in Windows 2003 Server, right? And obviously it'll run in the next version of that OS, which my client plans to upgrate to, right? Thanks for your help, Peyton Todd peytontodd@xxxxxxxxxxx read more about Cold Fusion - ASP Compatiility?
Message from alecken Most recent post: 10/25/2007 5 authors and 6 replies. In my .CFM file I have a few CFFUNCTION Within my CFFUNCTION I have a big chunk of <CFSCRIPT></CFSCRIPT> Within <CFSCRIPT >I have codes written in block of if else if statements this way: <CFFUNCTION name="Bla"> <CFSCRIPT> .... .... if (listFind("3,5,6",getFormsForPlan.FormID) AND len(trim(A_New[53]))) { ..... ..... ..... structFormText[numKey][1]["formText"] = " [B]CHOOSE THE PERCENTAGE OF.....[/B]"; structFormText[numKey][1]["XPosition"] = "73"; structFormText[numKey][2]["XPosition"] = "73"; ..... ..... ..... } other similar block of codes from here down </CFSCRIPT> <CFFUNCTION> If I want to comment out ONE whole block of code, Starting from if.... { and end in } what should I use? // on every line OR /* */ ? Since I'm commenting out a block of code I'd assume using /* */ is better and more logical than putting // on each line but when I use /* */, a few lines didn't turn grey especially the text: [B]CHOOSE THE PERCENTAGE OF.....[/B]"; but others turn grey Please help! read more about What to use for comment
Message from ironyx Most recent post: 10/25/2007 2 authors and 6 replies. I am trying to set up RDS for Reporting in CFMX 7 in a Weblogic 8.1 Server on Windows. I found the context root and added (and took away just in case) I have tried a variety of ip, paths for host name. I have tried with SSL and that says no. I have tried port 80, 443, 8500. I have also tried a variety of ports I have configured for ColdFusion If I try the host with HHTP: I get ... a 403 Forbidden error. When I try with HTTPS, I get "A connection to the RDS Server couldn't be established... " , when I click the SSL it says it cannot use it. Any ideas? I am getiing so frustrated. Thanks so much, as always! Va. read more about Setting up RDS for reporting in CFMX 7
Message from Volantorman Most recent post: 10/25/2007 6 authors and 11 replies. When I change the webpage filename from filename.html to filename.CFM the webpage loses its format/styling. WTF! Anyone have a solution or know why this is happening? :confused; read more about HTML to CFML
Message from 3Dgregory Most recent post: 10/25/2007 2 authors and 2 replies. I am about to buy a server to place Cold Fusion MX 7.0. I thought that an HP tower might be a good server to start with. I do not know a lot yet about Cold Fusion and its use on a server, so do you think that an HP tower'd be a good purchase. The type of server that was suggested was a ProLiant 350 G5 Windows Server, but they did not know about Cold Fusion. read more about New server
Message from susanring Most recent post: 10/25/2007 2 authors and 2 replies. how does it work? what will I use it for ? can u provide me code examples? thanks read more about what is a CFTOKEN?
Message from Naim.Beg Most recent post: 10/24/2007 2 authors and 3 replies. Is there an advantage of using an EAR deployment versus a WAR deployment of CFMX8 on JRun4? (I know the EAR is recommended) On our current servers (Windows 2003, IIS 6 JRun4) we deployed CFMX7 as a WAR. (We are using JRun clustering for Cold Fusion if that makes any difference). We'll be migrating our ColdFusion apps to CFMX8 in which we'll be getting new servers (again Windows 2003 IIS6). I plan to install JRun4, then updater 6 or 7 because we'll be using multiple JRun instances for other services. Are there advantages in using the EAR over the WAR deployment? If not, I'd prefer to continue to use the WAR deployment because it's a configuration that we are used to working with... read more about Choosing a EAR or WAR deployment
Message from shashtri Most recent post: 10/24/2007 3 authors and 4 replies. I need to convert decimal numbers to time. For example: 8.5 to 8:30 and anything parts there of . :disgust; Thanks for your help read more about convert decimal numbers to time
Message from sanman Most recent post: 10/24/2007 3 authors and 7 replies. I am using ColdFusion 7 and Microsoft SQL 2005 database. I insert items into the database with default newid() so it creates a new uniqueidentifier automatically. When I query and output the uniqueidentifier column I get "ByteArray objects cannot be converted to strings". The same thing used to work fine on ColdFusion 5. read more about can not CFOUTPUT uniqueidentifiers
Message from Triton_Ops Most recent post: 10/24/2007 2 authors and 3 replies. Hey all, I'm currently using some of the flash form features of CF7 to build a new website for the company I work for. I have run into one issue thus far I'm wondering if anyone can help with and I also have a question about another feature. The issue I'm having is using the <img> tag in a <CFFORMITEM> container who's type has been set to html. The image won't display. All the other supported html tags (<a>, [B], <br>, etc.) work fine. The documentation states the <img> tag is supported however. Is there something I am doing wrong? An example of the tag as I am using it'd be: <img src="images/myimagegif" alt="" /> which is the xhtml format. However I have also tried using the old html format <img src="images/myimage.gif" alt=""> and it still doesn't display the image. Any ideas? Also I have a question regarding the usage of the Tab Navigator CFFORMGROUP type. Is it possible for me to place links within the content of one tab that link to another tab? An example'd be 2 tabs labled A and B. A link on tab A says "click me" and upon clicking the link you are taken to tab B. Is such a thing possible and if so how'd I go about coding this? Any help is much appreciated. Thanks in advance! -Shannon read more about CF7 - Questions Regarding Flash Forms
Message from blah411 Most recent post: 10/24/2007 2 authors and 3 replies. I have a real estate site with which has the ability to search all MLS listings through Cold Fusion, however I have a problem because the MLS people are making it so I have to iframe the Cold Fusion page from my main site. This is causing me a major headache because they use cookies to track the queries and since it is iframe'd IE6 and IE7 consider them third party cookies and block them (I have attempted to get them to implement P3P headers with no luck.). I have been doing research on this issue and came across session variables, is this a solution or am I chasing my tail? Can someone help me out with this, I can do basic html and ColdFusion but this seems to be beyond my skill level. For those of you interested, here is my error: Attribute validation error for tag cfoutput. The value of the attribute query, which is currently QParams, is invalid. The error occurred in E:\Inetpub\wwwroot\SarahMacy\cgi-bin\GetPageTb.cfm: line 44 42 : </TR> 43 : <TR> 44 : <TD><CFOUTPUT query="QParams"><span class="style1"><font face="Arial, Helvetica, sans-serif"> 45 : <CFIF QParams.RecordCount gt 0> 46 : <CFIF Stories isn't 'Any'> read more about Session instead of cookies?
Message from rezun8 Most recent post: 10/24/2007 4 authors and 4 replies. Im just now starting to learn ColdFusion so excuse me if this is stupid. I have a site built in PHP, currently we need to convert parts to ColdFusion for a few reasons. is it possible to do a CFINCLUDE into a ColdFusion page and have it call a file.php? 'd I use a CFINCLUDE or a phpinclude to do this?? Thanks for any insight Regards Russ read more about ColdFusion and php includes
Message from cgibbs-cra Most recent post: 10/24/2007 3 authors and 4 replies. I'm about to upgrade my dev system and I was wondering if now'd be a good time to move to Vista 64. Of course, that decision entirely depends on being able to run a CF8 dev instance on the new computer. I was looking around the web and see that CFMX could run on Windows 2003 64 with a bit of work. The question is: Is there a way to run CF8 on Vista 64? Even if it's unsupported, I'd like to know if it's possible. TIA read more about Possible to run CF8 on Vista 64?
Message from Moozzie Most recent post: 10/24/2007 4 authors and 6 replies. Hi The title is the question: What to use: <CFFUNCTION name="WelcomeMsg" returntype="string"> <CFARGUMENT name="name" type="string" required="yes"> <CFRETURN 'Hi '& name> </CFFUNCTION> Or <CFSCRIPT> function WelcomeMsg(name){ return 'Hi '& name; } </CFSCRIPT> Are both of the function correct? Of am I not allowed to use the second function (may-b it is an old style and ColdFusion is trying to drop it or something, Does someone knows?) read more about Use or dont use CFSCRIPT by creation functions
Message from PHRED-SE Most recent post: 10/24/2007 2 authors and 3 replies. I am reinstalling an upgrade copy of CFMX on a replacement server. I have installed this version on several different Windows 2000 servers over the past few years. This is the first time I have installed in on Windows 2003 Std Ed. I have selected IIS and am now on the directory setup page. The "Install CFMX files to" selection is set to c:\CFusionMX, which is correct. The problem comes with the "Install Web Files to" selection. It is pointing to just a plain backslash, "\". No disk drive and no directory. I'd expect it to be pointing at c:\Inetpub, since it knows I want to use IIS. When I click the Change button, I get the following error msg: "Error 1314. The specified path \ is unavailable". I will buy that, but I can not do anything about that because it crashes when I try to do something about it. To top it off, it then takes me out of the installation procedure with no way back. You've to go back to the start of the installation and reenter the serial numbers, etc. Like I said, I have installed ColdFusion (3.1 to MX) probably a dozen times on W2K servers over the past 6 or 7 years and never had a problem like this before. I'd greatly appreciate any suggestions, if anyone has one, because i'd dead in the water at this point. Thanks in advance for your hep. :-}}} Len P.S. I tried it 4 times and got the same result each time.... Does this meet the definiton of insanity yet??? read more about MX Installation error
Message from nightwolf666 Most recent post: 10/24/2007 4 authors and 4 replies. This is my RSS Page which is causing trouble, I did find anything wrong in it but still it is working in IE, Mozilla, it doesn't work sometimes in opera but doesn't load the body contents like it subscribes to the feeds in buld in feed menu but when I click the link, nothing comes up in the space provided below in the opera feed menus, can anyone have idea what's wrong with it.. <CFSETTING enablecfoutputonly="yes"> <CFQUERY datasource="#dsn#" name="qGetDown"> SELECT * FROM downloads ORDER BY downloadid </CFQUERY> <CFSAVECONTENT variable="theXML"> <CFOUTPUT> <?xml version="1.0" encoding="iso-8859-1"?> <rss Version="2.0"> <channel> <downloadid>Download ID</downloadid> <title>Download Title</title> <urllocation>website URL</urllocation> <descr>description</descr> <dateadded>Posted On</dateadded> <source_by>Source</source_by> <dcomments>Comments</dcomments> <counts>Counts</counts> <cat>Categories</cat> <visits>Visits</visits> </CFOUTPUT> <CFLOOP from="1" to="#qGetDown.recordcount#" index="ctr"> <CFSCRIPT> downl read more about Rss Problem
Message from mega_L Most recent post: 10/24/2007 4 authors and 6 replies. I got an error saying: The argument STLOCANDATTAHMENTIDS passed to function CheckExistance() isn't of type structure. Have I done something wrong? Please help! Here is what I did: <CFFUNCTION Name="CheckExistance"> <CFARGUMENT name="stLocAndAttahmentIDs" required="true" type="structure"> <CFQUERY name="IsRecordFound" datasource="#application.maindsn#"> Select * from j_plans_attachmentlocations_attachments Where PlanID=#PlanID# and LocID=#stLocAndAttahmentIDs["LocationID"]# and attachID=#stLocAndAttahmentIDs ["AttachmentID"]# </CFQUERY> <CFRETURN #IsRecordFound.Recordcount#> </CFFUNCTION> <CFSET LocationName="Term Form (PDF)"> <CFSET stLocAndAttahmentIDs=InsertPlanAttLocationAttachment(LocationName)> <CFSET RecordExist=CheckExistance(stLocAndAttahmentIDs)> <CFIF RecordExist EQ 0> <CFQUERY name="AssociatingPlanAttachmentLocAndAttachment" datasource="#dsn#"> INSERT INTO j_p_attlocs_atts (PlanID, LocationID, AttachmentID, AttachmentStatusID) VALUES (#PlanID#, #stLocAndAttahmentIDs["LocationID"]#, #stLocAndAttahmentIDs["AttachmentID"]#, 3) </CFQUERY> </CFIF> read more about Structure question, please help.
Message from game_on Most recent post: 10/23/2007 2 authors and 2 replies. Hi. When CFPRESENTATION is used and set to output to a directory it craetes a file like this: This, on it's own works great. But, if it's put inside a table or another div it stops working. Any idea why? Matt read more about CFPRESENTATION inside a table
Message from man jackals Most recent post: 10/23/2007 2 authors and 2 replies. Why cache all the rows of a search when u can cache the Id's only and get 100% better performance (money back guarantee). 4 instance if u r search results give 1000 records, typical pagination system will cache the 1000 rows * the number of fields. now that bogs the server down. why not cache the Ids of the 1000 rows which will incrementally display the pages. Now just wonna share this with anyone interested and have a version of php. I got this pagination from Javier Julio (easycfm) and improved it. Just email me @xxxxxxxxxxx mjahkoh@xxxxxxxxxxx with the title Cold Fusion Pagination Mjahkoh read more about 'Super' Pagination
Message from mletson Most recent post: 10/23/2007 3 authors and 4 replies. Hello, I am implimenting a simple login script as such: <CFIF isLogin.recordCount EQ 1> <CFLOGINUSER name = "#form.username#" password= "#form.password#" roles = "#isLogin.role#"> <script language="JAVAscript">location.href="index.cfm";</script> </CFIF> After a sucessfull login, I then check for the user role which I have verified to be "admin" using the following script: <CFIF isUserInRole("admin") EQ true> Admin <CFELSE> Not Admin </CFIF> The problem is that the above function never returns "admin". I have verified many times that the CFLOGINUSER Roles attribute is set to "admin". Am I missing something? As always, Thanks read more about CFLOGIN Probem
Message from jkzfixme Most recent post: 10/23/2007 2 authors and 2 replies. I tried the fix that worked w/ ubuntu 7.04 even though it was a different error. This however didn't change anything , I am still not able to install . Any input'd be greatly appreciated. ~$ cat Cold Fusion-8-lin.bin | sed "s/export LD_ASSUME_KERNEL/#xport LD_ASSUME_KERNEL/" > /tmp/Cold Fusion.bin ~$ sudo sh /tmp/Cold Fusion.bin Launching installer... exec: 2481: /tmp/install.dir.8037/Linux/resource/jre/bin/JAVA: not found I am running JAVA version "1.6.0_03" JAVA(TM) SE Runtime Environment (build 1.6.0_03-b05) JAVA HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode) 2.6.22-14-server #1 SMP Sun Oct 14 22:09:15 GMT 2007 x 86_64 GNU/Linux read more about Cold Fusion 8 install on ubuntu gutsy 7.10
Message from Hydrowizard Most recent post: 10/23/2007 2 authors and 2 replies. I am trying to implement my first udf http://www.cflib.org/udf.cfm?id=585&enable=1 which list the keywords received in a cgi.http_referer but I don´t understand it properly. I have the udf on one page saved as a .CFM which is included on the Application.CFM (please see UDF code below) My script which I put on the same page is here: <CFSET greferer= cgi.http_referer> <CFOUTPUT> Keywords from #referer# = #GetGoogleKeywords(greferer)#<br> </CFOUTPUT> How do I implement this rigth? Thank you UDF: <CFSCRIPT>/* ** Pass it a http_referer value and this fuction will parse out the keywords used to find it if referred from Google. * * @xxxxxxxxxxx referer The referer string to check. (Required) * @xxxxxxxxxxx Returns a string. * @xxxxxxxxxxx Matthew Fusfield (matt@fus.net) * @xxxxxxxxxxx 1, June 28, 2002 */ function getGoogleKeywords(referer) { var Keywords=''; var StartPos=0; var EndString=''; if (referer contains 'google.com') { StartPos=ReFindNoCase('q=.',referer); if (StartPos GT 0) { EndString=mid(referer,StartPos+2,Len(referer)); Keywords=ReReplaceNoCase(EndString,'&.*','','ALL'); Keywords=URLDecode(Keywords); } return Keywords; } else { return ''; } }</CFSCRIPT> read more about UDF
Message from silviasalsa Most recent post: 10/23/2007 4 authors and 4 replies. what are CF Application Variables? SessionVariables? ServerVariables? clientVariables? any otherVariables? what are locking and how is it significant to these variables? what do you lock and what reasons to lock and how many locks? common locks? how are all these relevant when a CF program crashes? I ask because I am a beginner and the seniors were talking about these issuse but wasn't defined and clear to me. Thanks read more about what are CF Application Variables?
Message from quiero mas Most recent post: 10/23/2007 3 authors and 3 replies. I know access isnt the best but... Can someone tell me the process I have some very small thumbnails I want to display randomly - this side of things is going fine. But Im not sure how to store the gifs in access so that they display when pulled from the db. any advice'd be most appreciated read more about images Cold Fusion access
Message from mega_L Most recent post: 10/22/2007 4 authors and 6 replies. I have a function and returning a structure: <CFSET stLoc_and_AttIDs=StructNew(1)> <CFSET stLoc_and_AttIDs["LocID"]="#getLocID.LocationID#"> <CFSET stLoc_and_AttIDs["AttID"]="#getLocID.AttachmentID#"> I call this function like this: <CFSET LocAndAttIDs= MyFunction(LocName)> I'm having difficulty in refering to the values of this structure in my insert statement: I'm doing it this way and got error, I'm sure I did not do it right, please help. Insert Into MyTable (Column1, Column2, Column3, .....) VALUES (#LocAndAttIDs.stLoc_and_AttIDs["LocID"]="#, #LocAndAttIDs.stLoc_and_AttIDs["AttID"], 23) read more about How to use the structure on my insert statement.
Message from Adomacro Most recent post: 10/22/2007 3 authors and 6 replies. I got a field in table to capute current date and time...i am using SQL Server. field name datatype length enter_datetime datetime 8 What is the best way to get current date and time and insert to table?. Is this way?. <CFSET curtime = '#dateformat(now(),'mm/dd/yyyy')# #timeformat(now(),'hh:mm:ss')#'> This way looks like time isn't entered correctly. or any other better way?. read more about What is the best way to captue current date and time?
Message from mega_L Most recent post: 10/22/2007 3 authors and 4 replies. I thought when a variable is needed, ColdFusion developer can just set it on the fly, <CFSET var MyVar="assign a value here"> I'm writing a simple UDFs, and didn't declare a variable. The error I got was Variable is undefined. Should I declared the variable when it is used within a function? <CFFUNCTION name="InUser"> <CFARGUMENT name="EmpID" required="true" type="numeric"> <CFARGUMENT name="DeptArray" required="true" type="array"> <CFSET NewUserID = 0> ----????????? If Omitted this, I got error saying NewUserID is Undefined. . . . <CFSET NewUserID = GetNewUser(UserName)> . . Then I use the value of NewUserID for something else down here. . . </CFFUNCTION>