Re: SOT. Formatting Excel
You can always output directly to Excel using a template.. though I'm biased :) -- Ryan Emerle Query2Excel - Write Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_query2excel Excel2Query - Read Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_excel2query ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam DECREASES performance?
I've had problems due to the general way in which CF handles preparing the statement. If I recall correctly (it's been a while) I had a table with 15 million rows where the primary key was a varchar(36). Because CF uses a generic type of nvarchar(4000) (i believe), the server would choke as it performed the conversion. By changing it to a simple statement, queries decreased from 2 minutes to milliseconds. -- Ryan Emerle Query2Excel - Write Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_query2excel Excel2Query - Read Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_excel2query ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Two questions
I would recommend REReplace instead, so that you can replace both left and right angle brackets in one shot since you're dealing with a large file. REReplace(string,(|),,ALL) If you're worried about the speed, you can always drop down to straight Java: http://www.google.com/search?hl=enq=coldfusion+java+bufferedreader -- Ryan Emerle Query2Excel - Write Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_query2excel Excel2Query - Read Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_excel2query -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 20, 2006 6:59 PM To: CF-Talk Subject: RE: Two questions 1) if I want to do a replace where the character to be replaced is a forward or backward angle bracket or then I assume that this will not work: cfset name = replace(#string1#, ,, ALL) How do I escape the bracket character to make it work? 2) this is from the CFFILE doc for action=read: It is not intended for use with large files, such as logs, because this can bring down the server. Will a 500K text file bring down the server? TNX for any thoughts. Rick Colman ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FW: Certification
On average, I'd say the certification only indicates that you are good at studying for exams. It doesn't provide any meaningful metrics to other developers. That being said, however, they do complement otherwise talented developers' resumes. If you are looking to get certified, I would recommend _learning_ the material and only supplement with books and software. There's really no point in getting certified if you can't get past the developers who will undoubtedly have a part in interviewing you. -- Ryan Emerle Query2Excel - Write Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_query2excel Excel2Query - Read Excel files from ColdFusion http://www.emerle.net/programming/display.cfm/t/cfx_excel2query ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Component Footprint
Is it possible to ascertain the memory usage of a component, or anything for that matter by, let say, getting the JVM stack usage before and after a call? Anyone done so succesfully? Is there a better approach with a bit more control/accuracy? This is just a matter of curiousity more than anything. Though it would be helpful in performance tuning to some degree. -- Ryan Emerle ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211926 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Coveo Enterprise Search
Anyone had any experience integrating with Coveo (http://www.coveo.com/)? Any other enterprise-class engines? I'm working on a project that requires an enterprise-class search solution at a budget price (relative to the enterprise search market) -- Verity bundled with CF is too limited and the full version is too expensive. We're looking at a dozen or so options and Coveo is remarkably powerful for the money. It seems to have a great API as well -- I just haven't seen anyone talking about it in a CF environment. Thanks! -- Ryan Emerle ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205061 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Odd CF/network problem
Have you checked that Jumbo Frames are disabled for the NIC? This can cause problems when an intermediate switch can handle the larger frames, though you won't see a problem on an xover connection. HTH -Ryan On Tue, 21 Dec 2004 15:24:18 -0500, Matthew Fusfield [EMAIL PROTECTED] wrote: I've just run into a rather strange network issue with CFMX and am hoping someone here might have an idea. We are preparing to deploy an application on two web/CF servers and a separate MS SQL box. Each machine has two NICs. Until now, on the two CF servers, we've used one NIC to connect out to the network and the second NIC was connected via crossover cable to the other web server. (there is a decent amount of web services and other traffic between the two to warrant this) This has worked well, until today when we installed a pretty basic network switch, replacing the crossover cable, to allow the database server to connect to this private network. Both CF servers can see and use the SQL box, and can ping each other. However, when I try to send HTTP traffic from web server 1 to web server 2, I get the HTTP headers and nothing else - it simply times out. Even stranger is that this only seems to apply to ColdFusion pages - if I request a static html file from one server, it transfers just fine. I replaced the switch with the crossover cable, and everything started working again. I tried restarting services, reinstalling connectors, etc, etc to no avail. Anyone run into anything like this before? Thanks, Matt ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model
I had a similar problem with height not working when specified at 100%. Turned out being the dtd definition. If you specify a dtd, without the height attribute, it won't work. Try simply excluding the dtd definition in your doctype def: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN Not: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; HTH -Ryan On Thu, 16 Dec 2004 00:26:33 -0500, S. Isaac Dealey [EMAIL PROTECTED] wrote: so after all this time, there's still no standard that allows an adequate means of specifying something as simple as height 100% ... because according to the w3c, 100% of the height of an airplane discludes its canopy and landing gear and 100% of its length discludes its propeller and tail-fins... Before you say it -- yes, I've assigned margin: 0; padding: 0; height: 100% on both the html and the body elements in the style sheet... And in this code there is no way to make the content of the 3rd table row display without specifying a height for the row -- there is also no way to tell the browser that the row should be 100% of the _remaining_ height of the table after accounting for the space taken by the other 3 rows (above and below). So my choices are 80% (so the bottom of the table may or may not match the bottom of the window) or a fixed height (so the bottom of the table definately doesn't match the bottom of the dinwo most of the time). Any attempt to set the height of the 3rd row to 100% results in the table exceeding the height of the browser window. And why use tables at all you ask? Because there's no way to specify the iframes float left and right and fill 100% of the width of the window without one of them being shoved down underneath the other if the browser window is shrunk horizontally. Oh well... frameset it is I guess... Doesn't make me any happier with the box model. div style=height:100%; padding-bottom: 100px; table border=1 cellpadding=0 cellspacing=3 style=width:100%; height:100%; tr style=height:40px;td id=doc_title colspan=2 style=height:40px;onTap Framework/td/tr tr style=height:20px;td id=doc_ladder colspan=2 style=height:20px;Home/td/tr tr td colspan=2 style=height:80%; div style=height:100%; table border=0 cellpadding=0 cellspacing=0 style=height:100%; width: 100%; tr td style=padding: 2px; iframe name=nav_frame_menu frameborder=1 height=100% width=250/iframe /td td style=padding: 2px; width:100%; iframe name=nav_frame_content frameborder=1 height=100% width=100%/iframe /td /tr /table /div /td /tr tr style=height:60px;td colspan=2 valign=top style=height:60px; form name=paypal_donation_form action=https://www.paypal.com/cgi-bin/webscr; method=post style=margin: 0px; input type=hidden name=cmd value=_xclick / input type=hidden name=business value=[EMAIL PROTECTED] / input type=hidden name=item_name value=onTap Framework / input type=hidden name=item_number value=ontapframework / input type=hidden name=no_note value=1 / input type=hidden name=currency_code value=USD / input type=hidden name=tax value=0 / input name=submit type=image border=0 style=border:0px; background-color:transparent; float: left; alt=Make a donation. src=http://mx/otp/test/_components/docs/_images/donations.gif; / /form A target=_blank href=http://affiliates.macromedia.com/b.asp?id=2549p=go/dr_home_af f1 img align=right border=0 style=float: right; src=http://affiliates.macromedia.com/showb.asp?id=2549img=mx2004_4 68x60_b.gif //a /td/tr /table/div s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net
Re: SOT: Garbage Data Detection/Prevention
The only thing i would suggest is that you don't alienate your users by implmenting some flawed garbage detection scheme. There will be some users whose name really is Sadf Dsij (even if it's not an international site). If you do anything, i would run your algorithm in the background and simply flag the accounts for human review if they seem off. One method would be to run a spelling-type check and based on the number of possible errors, you can flag the entry. The last thing you want to do is piss of your users so that you have less work to do :) -R On Wed, 1 Dec 2004 13:39:24 -, Gavin Brook [EMAIL PROTECTED] wrote: Hi All, I've got a CF/SQL Server 2k application that serves several hundred users and is designed to store large amounts of data. I have built in many checks and restrictions into the application to prevent incorrect data being inserted. But there is a proportion of users who are circumventing these restrictions by entering garbage data. For instance, where a name is required, they would enter jdsl. There is only so far I can go to do checks as data is input, so I need to concentrate on user education by finding the culprits. There is full auditing of the data and to this end, I was wondering if anyone had any thoughts on ways to find garbage data, or other steps I could take to prevent it. Most of the data in the system is fine, so I was thinking maybe somehow comparing data with other examples of correct info to root out the garbage. I'm just not sure how! Any thoughts or suggestions would be greatly appreciated. Thanks, Gavin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Best Practice: Import Delimited List to Database
cfx_text2query and cfx_excel2query are two good _free_ tags for data import :) http://www.emerle.net/programming/ On Tue, 30 Nov 2004 13:12:57 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. -- Aaron Rouse http://www.happyhacker.com/ On Tue, 30 Nov 2004 14:08:46 -0500, Michael Dinowitz ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185737 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scripting.FileSystemObject
I can't imagine that it has any level of reasonable efficiency since COM is not native to Java. You may want to reconsider writing java native or CFML versions of those COM calls. Is there any specific reason for using the FSO anyway? -Ryan On Wed, 24 Nov 2004 13:39:07 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: How efficient is the Scripting.FileSystemObject COM call in CFMX? We are seeing huge amounts of memory consumption when running some templates using this - especially when in a custom tag. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verisign Payflow Pro
No, the CFX tag will not know what to do with it. Your best bet is to just keep the password from being immediately visible in the code if you can help it. Any way you look at it, it will be decrypted before it is sent over to verisign (though it is sent via SSL). I'm sure you can get creative with encryption so that you decrypt it as you pass it to the tag.. I have a CFC version of the PFPro tag that might give you a bit more flexibility in this area, though I personally wouldn't trust a stranger's CC gateway code :) I'd be more than happy to post it if anyone is interested though. On Wed, 24 Nov 2004 01:23:24 -0500, Ryan Mannion [EMAIL PROTECTED] wrote: Has anyone ever configured the verisign payflow pro system? The main thing I read in the manual is the importance of encrypting the password. My question is, if I use encrypt(password) when sending the password how will the cfx tag decrypt this? Or should I store the passwords encrypted in a database, then decrypt them on the way out of the DB? I'm not sure how one is supposed to accomplish this. Any suggestions would be appreciated. Here is the code to run. Thanks Ryan CFX_PAYFLOWPRO QUERY = RESULT HOSTADDRESS= test-payflow.verisign.com HOSTPORT = 443 TIMEOUT= 30 PROXYADDRESS = PROXYPORT = PROXYLOGON = PROXYPASSWORD = TRXTYPE= S TENDER = C PARTNER= VeriSign USER = YourTestAccountName PWD= YourAccountPassword ACCT = 5105105105105100 EXPDATE= 1209 AMT= 27.33 COMMENT1 = This is a comment - note that it is automatically escaped COMMENT2 = Embedded = and work when escaped CERTPATH= C:\CFusionMX\certs ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Verisign Payflow Pro
Nah, it's really rather easy, just follow the install instructions. Just make sure that you provide all of the default information such as hostname, port, proxy_username, proxy_password, etc. It's weird, but the proxy information needs to be specified whether you are using it or not. HTH -Ryan On Wed, 24 Nov 2004 12:27:22 -0500, Ryan Mannion [EMAIL PROTECTED] wrote: Thanks for the info, have you had any experience installing the verisign sdk or the CFX tag? If so can you provide any tips, or caveats I may have when doing it? Thanks agian. Ryan ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185336 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Queries in CFC, cfoutput has issues
Yeah, ran into that myself. As far as i could tell, it seems to be a limitation of the cfouptut and cfloop tags. It looks like MACR needs to update those tags for the new syntax made available by MX. Until then, i guess we'll have to settle on copying it to the variable scope. On Wed, 24 Nov 2004 13:20:40 -0400, Robert Everland III [EMAIL PROTECTED] wrote: I have a CFC that I have put all of my stored procedures into. I then input the CFC into the application scope for use throughout my application. The issue I have is that I can reference the query in a cfdump like this cfdump var=#application.queries.testquery()# and it will dump the query. I can do isquery(application.queries.testquery()) and it returns yes, but when I do cfoutput query=application.queries.testquery() or cfoutput query=#application.queries.testquery()# it throws an error. I can set the method to a local variable and then I'm able to reference the query, but it would be nice to use the method without having to move it to a local variable. Has anyone ran into this issue? Bob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Queries in CFC, cfoutput has issues
Well, now that i think about it, you would want to copy it to the variable scope anyway. Otherwise, each iteration of the loop you'd be executing the query again by calling the function every time. that is: cfloop query=application.queries.getQuery() cfoutput#application.querys.getQuery().name#/cfouput /cfloop If that worked, it would exec the function getQuery() in application.queries and iterate over the rows. Then each iteration we re-call the function to get the same query and we'd only return the name field for the first row. You need to copy the _results_ of the query to a variable so you can iterate over it. In other words, you can't iterate over a function call :) On Wed, 24 Nov 2004 13:30:02 -0500, Ryan Emerle [EMAIL PROTECTED] wrote: Yeah, ran into that myself. As far as i could tell, it seems to be a limitation of the cfouptut and cfloop tags. It looks like MACR needs to update those tags for the new syntax made available by MX. Until then, i guess we'll have to settle on copying it to the variable scope. On Wed, 24 Nov 2004 13:20:40 -0400, Robert Everland III [EMAIL PROTECTED] wrote: I have a CFC that I have put all of my stored procedures into. I then input the CFC into the application scope for use throughout my application. The issue I have is that I can reference the query in a cfdump like this cfdump var=#application.queries.testquery()# and it will dump the query. I can do isquery(application.queries.testquery()) and it returns yes, but when I do cfoutput query=application.queries.testquery() or cfoutput query=#application.queries.testquery()# it throws an error. I can set the method to a local variable and then I'm able to reference the query, but it would be nice to use the method without having to move it to a local variable. Has anyone ran into this issue? Bob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Queries in CFC, cfoutput has issues
in some cases, you'll need to use something to specify the scope: cfloop query=query1 cfloop query=query2 cfoutput#query1.name# != #query2.name#br/cfoutput /cfloop /cfloop Now try that with the unstored results of a function call. On Wed, 24 Nov 2004 14:10:13 -0400, Robert Everland III [EMAIL PROTECTED] wrote: If you were looping over the query you wouldn't need to refer to the function. Also if you did myquery().name, you would only be getting the first record every time, you would just refer to name. I think it's just a limitation in ColdFusion, looks like a lot of people are having this issue. We're very close to being able to do object oriented with CFC, but there still needs to be some work so that we can do the same thing as .NET . Bob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185355 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File Upload question
contat crystaltech.. sounds like someone changes the permissions on the windows temp directory which CF uses to temporarily store uploaded files. On Fri, 19 Nov 2004 08:49:02 -0600, Clint Tredway [EMAIL PROTECTED] wrote: I am working on a site that is hosted at www.crystaltech.com and all of a sudden my file uploads start breaking. Thier supports says I need to change the temp directory where the file uploads happen... how the heck do I do that? Here is the error: Error Occurred While Processing Request Security: The requested template has been denied access to C:\WINDOWS\TEMP\neotmp55062.tmp. The following is the internal exception message: access denied (java.io.FilePermission C:\WINDOWS\TEMP\neotmp55062.tmp read) mind you, this went from working to breaking in one day with no code changes. thoughts? -- www.fishermenstudios.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184862 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File Upload question
/contat/contact/ /changes/changed/ Looks like i need a spell checker. On Fri, 19 Nov 2004 10:02:14 -0500, Ryan Emerle [EMAIL PROTECTED] wrote: contat crystaltech.. sounds like someone changes the permissions on the windows temp directory which CF uses to temporarily store uploaded files. On Fri, 19 Nov 2004 08:49:02 -0600, Clint Tredway [EMAIL PROTECTED] wrote: I am working on a site that is hosted at www.crystaltech.com and all of a sudden my file uploads start breaking. Thier supports says I need to change the temp directory where the file uploads happen... how the heck do I do that? Here is the error: Error Occurred While Processing Request Security: The requested template has been denied access to C:\WINDOWS\TEMP\neotmp55062.tmp. The following is the internal exception message: access denied (java.io.FilePermission C:\WINDOWS\TEMP\neotmp55062.tmp read) mind you, this went from working to breaking in one day with no code changes. thoughts? -- www.fishermenstudios.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184864 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Outsourcing
Has anyone had any success outsourcing large projects, or portions of large projects, overseas or to temporary/freelance employees? Any pros/cons to either? Any resources you can offer to someone exploring his options? Basically, we're looking to supplement our current resources while the company grows. Unfortunately our timeline does not allow much flexibility to train new full/part time employees. Any help would be appreciated. Personal experiences would be extremely helpful. Thanks! -- Ryan Emerle ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: JVM 1.5.0 - Anyone using it?
I haven't had any problems yet using 1.5 except, as Dave mentioned, Axis is borked so web services don't work. So, as of right now, it's obviously not worth upgrading. I look forward to official support for 1.5, but it doesn't seem that drastic of a change to warrant any rush. -Ryan On Tue, 16 Nov 2004 08:45:03 +0100, Micha Schopman [EMAIL PROTECTED] wrote: How is your impression of the stability? :) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184455 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
JVM 1.5.0 - Anyone using it?
Hey, Has anyone upgraded to 1.5 jvm? It's supposedly has improved out-of-box performance. I'm assuming anyone who has upgraded hasn't done so on a production box. Any noticeable benefits in your dev environments? I just dropped it on a dev box here, and it seems pretty smooth. I haven't done any benchmarks as i don't intend on using it in production, but some things seem a bit more responsive. Any Comments? -- Ryan Emerle ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMail Problem
Yeah, that most definitely sounds like a relaying issue. Have your client add your server address(es) to their relay-allow list(s). Most (though it should be all) mail servers will not allow a foreign IP to send email to domains that the server does not host. -Ryan On Thu, 28 Oct 2004 11:20:49 -0400, Mark Leder [EMAIL PROTECTED] wrote: Hi all, I have a couple of clients who manage their own mail servers. I host their websites. In a simple contact form using CFMail, the message being sent to the client works fine. But as best practice, I always generate a confirmation email back to the sender, so they can have a record of what they asked (as well as a feel good that the mail was sent). Problem is, CFMail can't send the confirmation back to the end user's TO: address. I always get the message in the mail log of: Invalid Addresses; nested exception is: javax.mail.SendFailedException: 550 [EMAIL PROTECTED]: Recipient address rejected: No such domain at this location ([EMAIL PROTECTED]) In the DNS at the website, I have an MX record pointing to their mail server, as well as an A record pointing to their mail server's IP. I have a feeling that it's a relay setting or something else at the client's mail server. Here's the code I use on many sites, I'm only having problems with the second CFMail call when used where the client hosts the mail on their servers: !--- Mail which goes to the website owner --- !--- This works fine and the client receives the message --- cfmail to=#VARIABLES.sendmailtoowner# from=#REQUEST.contact# username=#REQUEST.contact# password=#REQUEST.smtpPWD# subject=#VARIABLES.sendmailownersubject# bcc=#REQUEST.bccMail# server=#REQUEST.mailserver# #VARIABLES.SiteOwnerMessage# cfmailparam name=Reply-To value=#VARIABLES.sendmailtoowner# cfmailparam name=Message-ID value=#CreateUUID()[EMAIL PROTECTED] /cfmail !--- Mail which goes to the user who filled out the newContact --- !--- this is the part that craps out; in this case, [EMAIL PROTECTED] --- cfmail to=#newContact.emailaddress# from=#REQUEST.contact# username=#REQUEST.contact# password=#REQUEST.smtpPWD# subject=#VARIABLES.sendmailendusersubject# bcc=#REQUEST.bccMail# server=#REQUEST.mailserver# #VARIABLES.EndUserMessage# cfmailparam name=Reply-To value=#VARIABLES.sendmailtoowner# cfmailparam name=Message-ID value=#CreateUUID()[EMAIL PROTECTED] /cfmail Here's what the failed message looks like in the mail log: server: [EMAIL PROTECTED]:[EMAIL PROTECTED]:25 from: [EMAIL PROTECTED] to: [EMAIL PROTECTED] bcc: replyto: [EMAIL PROTECTED] subject: Contact Form Submittal Acknowledgement from SingerWallcoverings.com type: text/plain; charset=UTF-8 X-Mailer: ColdFusion MX Application Server Message-ID: [EMAIL PROTECTED] body: body: Thank you for visiting Singer Wallcoverings on the web. body: For your reference, since you provided inquiry comments, they are listed here: body: body: body: body: Comments: Hi, body: Running a logic check. body: Please reply to let me know you received this. body: --- body: We will follow up shortly regarding your e-mail message. body: In the meantime, if you have another question or need further information, body: please contact us: body: body: Singer Wallcoverings body: body: Phone: (513) 398-1611 body: E-mail: [EMAIL PROTECTED] body: Web: http://www.SingerWallcoverings.com body: ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182852 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: .csv import for CFHTTP but not CFFILE?
Check out: http://www.emerle.net/programming/display.cfm/t/cfx_text2query (it's free) CFX_Text2Query works better than other methods because it can handle empty fields and fields with line breaks.. One alternative, using CFHTTP, requires the file to be web-accessible, and cannot handle empty fields OR line breaks. This often results in the Incorrect number of columns in row. error and a lot of headaches. On Wed, 29 Sep 2004 18:56:47 -0400, Anders Green [EMAIL PROTECTED] wrote: Interesting. Seems that CFHTTP can turn a .csv file into a query easily. But CFFILE can't. So I can pull the file from another server and handle it easily, but not when it's on my own machine? Weird. Ok, I guess I could copy the file to the web root, CFHTTP it from myself, then delete it, but that seems a little roundabout. Or, read it in, parse it, etcetera. Certainly doable, but not as oh-look-its-done-already easy. I have to do that anyway for a different file that's certainly NOT csv, and once would be just fine. :) Anyone want to jump in here? Cheers! Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED] | |Home: 919.303.0218| |Off Road Rally Racing Team: http://linaracing.com/ | +===+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: bardcode and signature extraction from tiff files
Well, you could do it with java.. http://www.tasman.co.uk/bars/readme.html Looks like they want around $3,500 for it though :) If the signature and barcode are always in the same relative area, you could get away with writing your own with little effort.. -Ryan On Thu, 16 Sep 2004 15:45:00 -0400, Andrew Tyrone [EMAIL PROTECTED] wrote: Hi everyone, I've got a job to quote and am looking for some software that can accomplish extraction of a specified section of a tiff image (which is converted from a fax) as well as read a barcode from a specific section of said image. Basically the signature needs to be extracted and saved to a separate image file.Also, there will be a barcode that they have generated that needs to be read and then the appropriate matching row in the databases needs to be updated so the bill can be marked received. Anyone ever do anything like this?Any information will be appreciated. Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Question about processing a CSV file.
I have done a lot of work with file imports, you can check out cfx_text2query: http://www.emerle.net/programming/display.cfm/t/cfx_text2query Though, your CSV seems simple enough to parse as a list, without anything fancy.. unless that file is huge.. -R On Mon, 13 Sep 2004 22:36:19 +0100, Ciliotta, Mario [EMAIL PROTECTED] wrote: Hi, I was wondering if anyone could help me out as I am stuck on this part.I have a csv file that I would like to read and then issue an update query based on the contents. Basically I would like to read the file and then loop over the file and issue and update query for each line (maybe I could convert it to stored procedure later). The file looks like this: 5388120,12345678IL 5388150,FDX123FD45 5388165,RT6789 5388198,12345HY890 5388204,123SEDFRT 5388205,1ASEFFBH6 5388209,12890HFS23 5388212,124300HGFS 5388231,123567UHJK 5388235,12WWE4DD45 5388281,1234RFGT76 5388284,313SFFS67 5388361,23DS45 5388366,4422442242 5388372,42242FDFSF 5388403,FDXUPSDELD 5388409,1234567890 5388414,ASWDERF455 5388415,123EDCVBH6 5388417,12WSED56YH 5388424,12WSC56HBN 5388428,123WSE456H 5388510,313DADDADA 5388511,HFH678947S 5388597,3131ADADAD 5388654,ADA5DFA5RD 5388655,AD4242DDAA 5388661,1331XSSA4D And what I want to do is loop over it and issue an update: PUSEDOCODE: CFLOOP over the file update table set track_nbr = '2345678il' where header_id = 5388120 /cfloop What is the best way to do this.I can process the file but I am lost as to what to do. This is what I have so far: cfset RecordDelimiter = Chr(10) Chr(13) / cfset ColumnDelimiter = chr(34) chr(44) chr(34) / cffile action = "" file = G:\inetpub\wwwroot\mario\fedex_input.csv variable = Variables.SourceFile cfloop index=index list=#Variables.SourceFile# delimiters=#RecordDelimiter# cfloop index=recordIndex list=#index# delimiters=#ColumnDelimiter# cfoutput#RecordIndex#br /cfloop hr /cfloop Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx and CAPTCHA
I have posted the tag i created on my site.You can grab a copy from here: http://www.emerle.net/programming/display.cfm/t/cfx_captcha Included is an example file which shows how you can use session variables. Basically, the example file will act as an image.You simply add an IMG tag pointing to that file: img src=""> And it will serve up the generated image with CFCONTENT right after it sets the session variable.All you have to do is check the posted value against the session value.Of course, you will have to watch out for session timeouts.. :) It's not fool-proof, but it gets the job done.. :) -Ryan - Original Message - From: Whittingham, P [EMAIL PROTECTED] Date: Wed, 16 Jun 2004 15:54:39 -0400 Subject: cfmx and CAPTCHA To: CF-Talk [EMAIL PROTECTED] Hi All, How would one provide a cfmx-only solution (no .Net) for a 'CAPTCHA' solution. Any ideas would be appreciated. http://www.devx.com/dotnet/Article/21308 TIA, Patrick Whittingham United Space Alliance _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Checking an IP Address
You'll probably be looking at a range either way..If you use net masks, then it would be the starting IP to the ending IP of the subnet. I recommend storing the IP ranges as decimals for the most efficient lookups.Check out this UDF for converting to/from decimal: http://www.cflib.org/udf.cfm?ID=946 Wouldn't hurt to do some reading on subnetting as well.. HTH -Ryan _ From: Troy Montour [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 10:25 AM To: CF-Talk Subject: Checking an IP Address Hello everyone. Writing a CF message board and want to add a feature to be able to ban a person by IP adress. I have it working for the exact match. but was thinking this person could have dynamic ip address's so I want to give the admin the choice of banning the block. I was thinking away I could do this is to have them type something like this 222.222.000.000 so the zero's could be anything. anyone have something like this? or would a range be a better UI? (222.222.343.12 to 222.222.343.15) Thanks in advance for any direction or help. Troy Montour _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Excel2Query without COM (announcement)
Hello Everyone, Since many people have gotten use out of my custom tag CSV2Query, i figured i would post this announcement that i have written a Java-based CFX tag for bringing Excel worksheets into ColdFusion without the use of COM.It's 100% java-based and free :) You can grab a copy from here: http://www.emerle.net/programming/excel2query.cfm http://www.emerle.net/programming/excel2query.cfm Or from the MM Exchange. -Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayFlowPro Install Problem
We have it running on CFMX 6.1 without a problem.Here are the settings that worked: JVM Class Path: x:\CFX_Tags\Verisign.jar CFX Definition (Java): Tag Name: cfx_PayFlowPro Class: CFXPayFlowPro HTH -Ryan _ From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 12:09 PM To: CF-Talk Subject: RE: PayFlowPro Install Problem correct -Original Message- From: Daniel O'Keefe [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 11:35 AM To: CF-Talk Subject: RE: PayFlowPro Install Problem It does not work with 6.1? The CFX tag works with 5.0, right? Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of Queries issue with 6.1
I've had this lovely issue come up before.Gotta love the fact that the columns are typed, but you have no control over it (AFAIK).What i had to do was insert a dummy row at the top of the query with the problematic field set as a string.This causes the column typing algorithm to set the column as varchar. Here's a code example cfset queryAddRow(myQuery,1) cfset querySetCell(myQuery,problem_column,dummy_text) HTH -Ryan -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:29 AM To: CF-Talk Subject: Query of Queries issue with 6.1 Afternoon I've just updated a customer site to 6.1 from 5.0 and am getting a very strange error with a QoQ, Basically, I'm creating a query object from a string that's being posted to this page, no problems here, I have a nice query object that works fine, mostly. But when I try to do comparisons with this query and another I'm getting 'Unsupported type comparison.' I've narrowed it down to one field, namely 'pin' this field is 90% of the time always integers, but can contain characters as well. I therefore have to do the comparisons with quotes eg pin = '#pin#', not pin = #pin# This is the issue, CFMX seems to be assigning a datatype of int or numeric when I'm creating the query with QueryNew(pin,other,fields), even though it won't let you specifiy what a column is. Then pin = '#pin#' throws the unsupported datatype error (using cfqueryparam produces the same results btw) Of course if I remove the quotes it works until a pin which contains letters arrives. Damned if I do, damned if I don't and very unhappy either way. Has anoyone seen this or got a work around? Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Problem with Langauges (??)
Here's some info on using Verity with international languagues: http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/indexSearch2.htm Don't know if that helps or not, but perhaps it will guide you in the right direction? HTH -Ryan -Original Message- From: Stavros Tekes [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 2:34 AM To: CF-Talk Subject: CF Problem with Langauges (??) Hi all! Lately I have changed my Cold Fusion host to one abroad (outside Greece). Eversince I am trying to make Greek appear propertly on my pages. Although I have managed to make most pages appear ok in Greek, I still haven't managed to do the same with pages that use the CFSearch tag. Although my host has installed the European/Asian Language Pack, replaced their cfxneo.dll (under c:\cfusionMX\lib\) with the double byted cfxneo from the MM website and restarted all their Cold Fusion services, I still can't retrieve search results in Greek properly. I hardcoded the search term (which is in Greek) on cfsearch tag in order to be sure that the encoding does not get lost after the FORM posting takes place but still nothing was retrieved. The same web page on my server here, runs great (I used the same verity collection, by replacing the files that verity created for my collection on the host computer with the ones it created on my server, just to be sure that it is not a cfindex fault). The cfm page that uses CFSEARCH also uses these encoding lines at its top cfprocessingdirective pageencoding=iso-8859-7 cfcontent type=text/html; charset=iso-8859-7 (iso-8859-7 is for Greek encoding) The Greek characters are all represented by question marks (?? ?? ??? ... etc) which I believe means that character information has been lost. I also noticed that when I changed cfcontent to cfcontent type=text/html; charset=utf-8 Greek again didn't come out right, but instead of question marks, different characters were returned (Ie ?aneanaoYo oui ni?i ... etc). That seemed more promising. I realise that both cftags should be pointing at the same encoding values, cause one determines the output encoding while the other sets the encoding of the data which forms the page content. Furthermore we changed their default Java Encoding to Greek as well, but that still didn;t do any good. (all of the above were tested by using null as a search string since Greek words returned no results on my host) After everything I have tried I can't come to the conclusion whether it is a verity problem or not. The only problems I get are on the pages that use the Cfsearch tag and only on my host. Everything works great on my computer. I run out of ideas! Don;t know what to try next, so if anyone can help, will be a life saviour to me! Thanks in advance, Stavros ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
We have developed a suite of tags for working with an Apache Lucene index ( http://www.lucene.com).Our suite is far more robust than that offered by the DRK.For instance, we maintain an index of 100,000+ articles and it takes no more than a fraction of a second to search. We are also able to index any number of custom fields, which has proven to be very valuable.We are waiting for authorization from Apache to use the name Lucene in our documentation.Once recieved, this suite will be offered for free. It's really amazing how well this search engine works.It is far more flexible than Verity. For the time being, i would suggest getting a hold of Lindex from the DRK. -Ryan -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 2:54 AM To: CF-Talk Subject: RE: Alternatives to Verity Just so's you know: this Lindex (I posted about it a little while ago).The CFDJ article was working off the fact that it was shipped with the DevNet Resource Kit 3. Note that you don't NEED the DRK to use it (the product itself is open-source) but the DRK does have some nice tools and docs about it. Jim Davis -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 1:57 AM To: CF-Talk Subject: RE: Alternatives to Verity Eric, There have been a few articles in recent CFDJ's that discuss a JAVA alternative to VERITY.I don't recall the name of the program or the CFDJ issues off hand, but if you don't find the information on the CFDJ site (www.sys-con.com http://www.sys-con.com/ ) contact me off list and I'll try to dig up the information for you. Thank you, Jason Egan CFDynamics.com -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Sunday, October 12, 2003 1:16 PM To: CF-Talk Subject: Alternatives to Verity WE have been having terrible times with our Verity collections corrupting, being unable to update etc at our host and am looking for alternatives. It simply queries a database and a lot of fields, some quite lengthy...so not sure a simply SQL query is an option, but are there other solutions everyone is using for higher end and more robust searches of your sites? Thanks for any pointers in advance! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Mainly i will cite that it is open source which allows for nearly limitless flexibility.Indexing and searching can be crafted to your application.Outside of that, check out the lucene website (posted earlier) for a breakdown of what Lucene can do. I have found the following to be true of lucene and not necessarily with Verity: * Free/open source * Limitless indexed entities * Cross-platform compatibility * Full control over searching and indexing * Index portablility (can create an index anywhere and use it anywhere - web,cdrom,locally,etc) Verity is very flexible, i just happen to happen to enjoy the level of control and portability of Lucene over it.Use whatever works for you and your applications, though..I prefer to have an engine that works with my application, rather than an application that works with my search engine. I do urge anyone interested to draw their own conclusions based on their experiences :) HTH -Ryan -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 9:28 AM To: CF-Talk Subject: Re: Alternatives to Verity Ryan Emerle wrote: re: lucene It's really amazing how well this search engine works.It is far more flexible than Verity. What exactly is more flexible than Verity?I'm an old Verity hack from way back -- and I'm interested in Lucene but can't really see what it does that's so special. -- geoff bowers Daemonite -- http://blog.daemon.com.au/ Fullasagoog -- http://www.fullasagoog.com/ FarCry -- http://farcry.daemon.com.au/ ArsAura -- http://daemon.typepad.com/arsaura _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Alternatives to Verity
Not in my experience.The version we are using does not natively support anything other than plain text, but it is easy enough to build analyzers for PDF, Word, etc.. The only other thing i can think of is that version 1.2 final does not support range queries fully.So, for instance, you cannot perform a query between date ranges.Version 1.3 has this functionality, though it is only a release canidate right now. Im sure there are other downsides, but i haven't found any i couldn't work around with a few lines of code.Remember, it is more of an API than it is a product. -Ryan -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 10:39 AM To: CF-Talk Subject: RE: Alternatives to Verity Have you found there to be any downsides to it? Ade -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: 13 October 2003 14:41 To: CF-Talk Subject: RE: Alternatives to Verity Mainly i will cite that it is open source which allows for nearly limitless flexibility.Indexing and searching can be crafted to your application. Outside of that, check out the lucene website (posted earlier) for a breakdown of what Lucene can do. I have found the following to be true of lucene and not necessarily with Verity: * Free/open source * Limitless indexed entities * Cross-platform compatibility * Full control over searching and indexing * Index portablility (can create an index anywhere and use it anywhere - web,cdrom,locally,etc) Verity is very flexible, i just happen to happen to enjoy the level of control and portability of Lucene over it.Use whatever works for you and your applications, though..I prefer to have an engine that works with my application, rather than an application that works with my search engine. I do urge anyone interested to draw their own conclusions based on their experiences :) HTH -Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL regex select
You can do it (in MSSQL) but it won't be RegEx per se. You can have the wildcard
rules in the db, and do something like this:
SELECT *
FROM Email_Rules
WHERE ('[EMAIL PROTECTED]' LIKE Rule_To_Check)
In this case, Rule_To_Check would be a field that contains entries like:
Rule_To_Check
-
[EMAIL PROTECTED]
[EMAIL PROTECTED]
But, you are limited to the wildcard characters that LIKE requires:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_la-lz_115x.asp?frame=true
I also don't know how fast this would be.. Though it does work; just tested it.
HTH
-Ryan
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 10:11 AM
To: CF-Talk
Subject: Re: SQL regex select
Yes, that's what I'm trying to do. This has to do with an idea for email processing
via iMS/FusionMail where certain records are required for different users or entire
domains. For example, I may want to have a template called for every mail going to
coolfusion.com. In my table I would have a rule labeled as [EMAIL PROTECTED] and then
any email to that domain would use that rule.
Thanks,
Howie
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:38 AM
Subject: Re: SQL regex select
Howie Hamlin wrote:
I have an application where I want to select rows from a table where
the rows match according to a simple regex. For example, say I have
the word tiger - I would want to select rows with values like:
t*
*
?
tiger
t??er
So let me get this straight. You have the string in your application,
and you have regex patterns stored in the database, and now you want
to know which patterns match the supplied string?
BTW, SQL:1999 doesn't do normal regex matchng, so you need to specify
which dialect your RDBMS uses (and * is not a valid regex pattern).
Jochem
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138322
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion MX 6.1, now 2.5 times faster.
http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
RE: Can anyone explain why this code is behaving like it is?
You are adding the string CFOUTPUT#Evaluate(Form.S4x6 * 3.95)#/CFOUTPUT as the value. Which will be something like: CFOUTPUT11.85/CFOUTPUT You probably just cant seen the CFOUTPUT tags in the browser because they are seen as tags. Change the code to this: CFSET Temp = QueryAddRow(Session.Cart) CFSET Temp = QuerySetCell(Session.Cart,PhotoFileName,Form.PhotoFileName) CFSET Temp = QuerySetCell(Session.Cart, Quantity,Form.S4x6) CFSET Temp = QuerySetCell(Session.Cart, Size, 4 x 6) CFSET Temp = QuerySetCell(Session.Cart, Amount,Evaluate(Form.S4x6 * 3.95)) And, i'd recommend reading up on your CF syntax. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM To: CF-Talk Subject: Can anyone explain why this code is behaving like it is? This stuff is driving me crazy! All day spent to get almost nowhere... Anyway...(deep breath)... Excerpts from the code: The formfield: SELECT Name=S4x6 Class=TextInput01 Option Value=0 Selected0/Option Option Value=11/Option Option Value=22/Option Option Value=33/Option Option Value=44/Option Option Value=55/Option Option Value=66/Option Option Value=77/Option Option Value=88/Option Option Value=99/Option Option Value=1010/Option /SELECT Sent to another page for processing: CFLOCK Scope=Session Type=Exclusive TimeOut=5 CFSET Session.Total = 0 CFIF Form.S4x6 is not 0 CFSET Temp = QueryAddRow(Session.Cart) CFSET Temp = QuerySetCell(Session.Cart, PhotoFileName, CFOUTPUT#Form.PhotoFileName#/CFOUTPUT) CFSET Temp = QuerySetCell(Session.Cart, Quantity, CFOUTPUT#Form.S4x6#/CFOUTPUT) CFSET Temp = QuerySetCell(Session.Cart, Size, 4 x 6) CFSET Temp = QuerySetCell(Session.Cart, Amount, CFOUTPUT#Evaluate(Form.S4x6 * 3.95)#/CFOUTPUT) CFOUTPUT#DollarFormat(Session.Cart.Amount)#/CFOUTPUTbr ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137591 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Perl
%children is an associative array (hash/struct) dereferenced using the syntax
$children{key}.
%line is also an associative array.
$children{key}'s value is an array.
In CF, %children is a struct that contains arrays for the value at each key.
That is,
cfset children[my_key]=ArrayNew(1)
cfset arrayAppend(children[my_key],my_value)
HTH
Ryan
-Original Message-
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 11:46 PM
To: CF-Talk
Subject: OT: Perl
Ok, sort of off topic, but I'm trying to convert a perl program to CF. I'm
stuck on a line and have no idea what it's equivalent is in CF. The line is:
push @{ $children{$line{p1}}}, shortname($line{node});
I assume $children is an array, and $line is a single line of an input file.
What exactly does the $children{$line{p1}} mean? How are they indexing an
array based on a string? Any ideas?
Cedric
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
RE: OT: Perl
%children is an associative array (hash/struct) dereferenced using the syntax
$children{key}.
%line is also an associative array.
$children{key}'s value is an array.
In CF, %children is a struct that contains arrays for the value at each key.
That is,
cfset children[my_key]=ArrayNew(1)
cfset arrayAppend(children[my_key],my_value)
HTH
Ryan
-Original Message-
From: Cedric Villat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 11:46 PM
To: CF-Talk
Subject: OT: Perl
Ok, sort of off topic, but I'm trying to convert a perl program to CF. I'm
stuck on a line and have no idea what it's equivalent is in CF. The line is:
push @{ $children{$line{p1}}}, shortname($line{node});
I assume $children is an array, and $line is a single line of an input file.
What exactly does the $children{$line{p1}} mean? How are they indexing an
array based on a string? Any ideas?
Cedric
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
RE: Free Zip-latitude/longitude db
Here is another zip code DB in text format. http://www.emerle.net/zipcode/ -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:13 AM To: CF-Talk Subject: Free Zip-latitude/longitude db Does anyone know where I can find a free zip code - latitude longitude DB? Don't need anything fancy, just zip code, longitude, latitude. Using for a basic store look-up function. Andy ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: get the current line number?
While i don't know what the best way might be, this seems to work (when called from a custom tag context) The custom tag, say currentLine.cfm would contain this: cfparam name=attributes.r_line type=variableName cftry cfoutput#undef#/cfoutput cfcatch cfset currentLine=#cfcatch.tagContext[2].line# /cfcatch /cftry cfset caller.#attributes.r_line#=currentLine It would be called like this: cf_currentLine r_line=currentLineNumber Where currentLineNumber is the line number where cf_currentLine was called from. So, you could do: cf_currentLine r_line=currentLineNumber cfoutputStarting Loop at #currentLineNumber#br/cfoutput cfloop.. ... /cfloop cf_currentLine r_line=currentLineNumber cfoutputEnding Loop at #currentLineNumber#br/cfoutput HTH -Ryan -Original Message- From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:55 PM To: CF-Talk Subject: get the current line number? Hello, Is there a way to get the current line number in Cold Fusion? Basically, I'm writing a small tag in CF to log certain events, and I'd like to be able to tell what line number (from the original cfm file) certain pieces of code were executed on. Thanks! Ryan Hagan ph: 540-731-3588 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Reg Expression
Best to learn how to do it. :)
http://www.google.com/search?q=%2Bcoldfusion+%22regular+expressions%22
-Original Message-
From: Gary Hotko [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 12:59 PM
To: CF-Talk
Subject: Reg Expression
I got the isAlphabet function from cflib.org I was wondering how
could I modify it to allow (1) Parenthisis; (2) Semicolon; (3) Commas;
(4) New lines... (For Textareas); (5) excelamation point, Question Mark,
Dash/Hyphen [-], Ampresand [], quotation marks; (6) Dollar Sign. The
regular expression that it is currently using is:
reFindNoCase([^a-z\.[:space:]],str)
cfscript
/**
* This UDF confirms whether a string contains only letters.
*
* @param str String to check. (Required)
* @return Returns a boolean.
* @author Takaki Saito ([EMAIL PROTECTED])
* @version 1, June 21, 2002
*/
function IsAlphabet(str) {
return not reFindNoCase([^a-z\.[:space:]],str);
}
/cfscript
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
RE: (OT) Office 2000 install
Or, better yet, go into the group policy editor and double-check the settings: Start-Run-gpedit.msc Then check out: Computer Configuration-Administrative Templates-Windows Components-Windows Installer There are a bunch of settings there that could affect the Office 2k install. -Ryan -Original Message- From: Trent Shepherd [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 5:47 AM To: CF-Talk Subject: RE: (OT) Office 2000 install Hi Michael Try this Check your settings here: Go to Start/Run/Regedit and navigate to this key: [HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer] Create a new DWORD value, or modify the existing value, called DisableMSI and set it according to (0 = default, 1 = admin only, 2 = disabled). Exit your registry, you may need to restart or log out of Windows for the change to take effect. -- trent Trent Shepherd SeaSpray technology design cell: 0412 245 212 phone:+61 2 4285 8793 email: [EMAIL PROTECTED] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, 29 August 2003 1:23 PM To: CF-Talk Subject: (OT) Office 2000 install I'd like to use Access 2k and every time I try to install office 2000, I get a message box saying The system administrator has set policies to prevent this instillation. I'm the system admin, I run the box, what's stopping me from doing an install here? The box was destroyed a while back and had a new version of windows laid ontop of the old version to work with the new hardware, which may be the problem somewhere. Any office or windows gurus with a clue? Thanks Michael Dinowitz Finding technical solutions to the problems you didn't know you had yet ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Forcing a List to a Specific Length
Why not use an array instead?
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 6:36 PM
To: CF-Talk
Subject: Re: Forcing a List to a Specific Length
At 18:06 25/08/2003 -0400, you wrote:
So, say only 3 results are returned - but I need to list to ALWAYS have 10
positions:
myLIST = result1|result2|result3|||
How about:
cfif ListLen(myLIST) LT 10
cfset myLIST = #myLIST##RepeatString('| ', 10-ListLen(myLIST))#
/cfif
You could loop and ListAppend, but lists are just strings, may as well just
throw the extra elements in. I think you need spaces in empty elements,
i.e. ListLen(a,b,c,,,) is just 3, but ListLen(a,b,c, , , ) is 6 as
you'd want and expect.
Gyrus
[EMAIL PROTECTED]
play: http://norlonto.net/
work: http://tengai.co.uk/
PGP key available
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do...
This is precisely why we created our own search engine. We can actually index arbitrary field names (removing the need for anything like CUSTOM1/2) and have them returned with the search results. We have a very powerful suite of tags based on an opensource project that replaces verity and extends the searching abilities of CF 10-fold (with about 3 times the speed). This suite of tags will be publicly released relatively soon, free of charge. It should prove to be an extremely potent, FREE, replacement for Verity. Example, We have an index of 75,000 articles. Most searches take about 200ms at most, AND we dont need to parse out the additional information (such as articleIDs, headlines, release dates, etc) as they have their respective fields in the search result recordset. Sorry for the ~OT, but i felt it was relevant. -Ryan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 11:19 AM To: CF-Talk Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do... Then, within your display code, you could parse the key - in the above case, using the colon as a separator - to find both the table and the primary key within the table. Alternatively, you could store information in the CUSTOM1 and CUSTOM2 fields - that might be a little easier, but wouldn't allow you to index more than one table within the same collection if you're using surrogate keys generated by identity columns or the like. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Can CF Detect a Win32 Service?
There are CFX tags that will allow interaction and listing of services and their states (CFX_Service is one). Or, you can CFEXECUTE net start to get a list of started services (then net start service_name or net stop service_name) Depends on what you are trying to do.. -Original Message- From: David Adams [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 3:01 PM To: CF-Talk Subject: Can CF Detect a Win32 Service? Is it possible to build a service control interface with CF? I need to detect the status of a service. Hope someone can comment. Dave Adams ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: problems running a Java CFX tag
Set the class path _to_ the jar file.. (or append it to the list) -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 8:33 AM To: CF-Talk Subject: problems running a Java CFX tag I'm trying to get a Java CFX tag (cfx_xmlTools from http://xml.fusebox.org/) running on my CF5 server, and I've no idea what's going wrong. I've never dealt with CFX's before. I think I've got all the settings right in the Administrator, and the tag seems to be registered OK. But I get this error when I try to use it in a CFM page: unknown exception condition TagCFX::execute The error occurred while processing an element with a general identifier of (CFX_XMLTOOLS), occupying document position (7:1) to (7:66). I can't find any mention of this error on the web. Any ideas? One thing bugging me is that cfx_xmlTools is a .jar file, not a .class file. Does this make any difference? I've assumed that you just set the Class Path as normal in the Admin (W:\CFusion\Java\classes for me), and install the .jar file in there. Gyrus [EMAIL PROTECTED] play: http://norlonto.net/ work: http://tengai.co.uk/ PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: using Randomize(GetTickCount())
yup, you need to shrink the number used in the Randomize function to less than the size of an integer. Try taking the Right() of getTickCount() or dividing/subracting it by a large number to reduce its size. I recommend just using the Right() function or by simply subtracting a larger number so your seed has more variation. -R -Original Message- From: Mike Mertsock [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 10:00 PM To: CF-Talk Subject: using Randomize(GetTickCount()) Hi folks, We suddenly encountered an interesting problem with using GetTickCount() to initialize random number generation. We have this line of code at the top of many files that endeavour to use random numbers: cfset Randomize(GetTickCount()) GetTickCount() returns a different number every millisecond so this ensures that random number generation is seeded differently on each request. However, this piece of code suddenly started throwing errors yesterday (August 7). This is the error message: Could not convert the value 1.060393676825E12 to an integer because it cannot fit inside an integer. Here's the first few lines of the stack trace: coldfusion.runtime.Cast$OutOfBoundsException: Could not convert the value 1.060393676825E12 to an integer because it cannot fit inside an integer. at coldfusion.runtime.Cast._int(Cast.java:307) at coldfusion.runtime.Cast._int(Cast.java:327) at cftick2ecfm77102974.runPage(E:\(path removed)\tick.cfm:1) --- So GetTickCount() suddenly decided to return some very large integers. Has anyone else had this problem? This only started yesterday, August 7, and is only happening on the servers this network. They are all Win2000 servers running CFMX on IIS 5. My home computer, WinXP/CFMX/IIS 6, is not throwing such an error right now - GetTickCount() is returning a smaller magnitude negative number. As a workaround, we changed Randomize(GetTickCount()) to Randomize(Second(Now())). That works fine. But I thought Randomize(GetTickCount()) was the best practice. Did the type of numbers GetTickCount() returns change with CFMX, perhaps as a side effect of the CFMX core now using Java date/time data? Trying to get some sympathy and perhaps some ideas as to why the code would suddenly begin to consistently throw these errors after working fine with CFMX for nearly three months. Mike Mertsock Alfred University Web Team Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Querying a Text File vs An MS Access Table
Here's a CFX tag that imports any type of delimited files and converts them to a CF query. It's mighty fast.. http://www.insapi.com/products/development_tools.cfm#cfx_textimport Perhaps it is something that would be useful? -Ryan -Original Message- From: B G [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: CF-Talk Subject: Querying a Text File vs An MS Access Table I am building an application where users can upload a comma delimited text file to a unique user directory then retrieve the data from it for later use. The structure of the file will be pre-defined and the users must follow that format. Field names are included in the first row. I had intentionally decided not to import that data from the text file into a table because of the file size. Reading the contents of a file with CFFILE puts the entire contents into a variable which takes up memory. 100 users all working with 10 meg files at the same time could cause a problem. But I am finding that no host will offer to support a text ODBC connection. I even had one tell me it couldn't be done. Also, a few have stated that querying a text file is too flaky to be considered reliable. Has anyone had any experience similar to this? Am I worrying about using too much RAM unnecessarily? Perhaps a more efficient way to get the contents of the text file other than CFFILE? Thanks! BG _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hiding Javascript Source
Erm.. i just did a view source and copied the JS src URL to the browser and the JS was displayed. After i hit refresh on that page, though, it said Trying to steal my javascript source? Is that UUID supposed to expire after one request? -Ryan -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 7:32 AM To: CF-Talk Subject: RE: Hiding Javascript Source See what you guys think... any comments appreciated. http://www.becomenew.com/jsGuard/ -Brad -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 3:26 AM To: CF-Talk Subject: RE: Hiding Javascript Source Yes, Brad, I'd like to see your hiding technique please. Of course, we know it's just reversable obfuscation or making it a _little_ more work to find. Also, have you seen this: http://www.jimworld.com/tools/javascript-encrypt/ It obfuscates the JavaScript code, but the trick to decrypting the whole lot is the document.write at the end of the code that is generated. If you can document.write it, you can also output it so you can copy it. Fun fun fun. - Peter -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: 30 July 2003 06:36 To: CF-Talk Subject: Re: Hiding Javascript Source If it's on my computer, I can get at it. - Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:04 PM Subject: SOT: Hiding Javascript Source I think I've found a way to hide Javascript source. Has anyone done this yet? I'll post an example if anyone is interested. -Brad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL help
..and(datepart(m,work_day) =#m#)
-Ryan
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 3:10 PM
To: CF-Talk
Subject: SQL help
Hi all
We are finally tring to upgrate from Access to SQL 2000.
I am working on making the necessary changes to the queries.
One I am having a problem with is were the WHERE statement is:
WHERE (proj_name = '#Qgetinfo.proj_name# ') and(datepart('M',work_day) =#m#)
m=number for the month: m=5.
work_day is the field in the db table.
this works fine with Access(data type date/time), but with SQL I get the
error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 1 specified
for datepart
when the data type is smalldatetime and if I change it to timestamp, no
error but no records are returned either.
This is used to create a report based on the project selected and the month.
THanks
Rodney
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Deleting an entire folder
I just wrote a tag real quick that will do it. It's CF_DELTREE. I haven't _tested_ it per se, but it should work: http://www.emerle.net/programming/index.cfm Full source in included.. FYI. -Ryan -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 3:21 PM To: CF-Talk Subject: Deleting an entire folder I need to have CF delete an entire folder and all files and folders in the Structure on the web server. How would I do this, I tried with cfdirectory and it would not let me. Matthew ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No input
If nothing is checked, then the form field will not be defined. You can check whether or not it is defined with: cfif not isDefined(form.formfieldname) !--- Reirect back to selection page --- /cfif Or you can use javascript on that page.. -Ryan -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 3:38 PM To: CF-Talk Subject: No input I have a page where a user use checkboxes to select a book they want in a shopping cart using sessions. Everything is OK, but when a user clicks submit without selecting any book I get a The specified form field cannot be found. error. How can I check for input? If a user does not select a book via a checkbox I would prefer it stays on that book selection page until they check off something. Any help appreciated. Thx. Robert O. HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ActiveEdit 3.0 Table Problem...
We have had a similar problem with CFDEV's lack of response. It's a pity because we've gone with another WYSIWYG editor. But, to answer your question, do you have the source for AE? If so, you can probably track down the problem and fix it in the source. Otherwise, can you just filter out the BR's on submit? I've used AE 3.0 and there are quite a few issues that i had to resolve with work-arounds and bug fixes. This is another reason why we moved to an alternative editor. HTH -R -Original Message- From: Andrew Golden [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:15 AM To: CF-Talk Subject: ActiveEdit 3.0 Table Problem... I know this is slightly vaguely OT but I have not gotten a response form anyone at cfdev other then to say that my complaint about lack of replys to support request e-mails was forwarded to the support department and need to get this long standing problem resolved... Has anyone using ActiveEdit had a problem with the tag inserting BR tags after every /td or /tr tag is creates? Every page I add a table to does this and the spaces get padded onto the page before the start of the containing table, resulting in all of the content being pushed off the screen to the very bottom. Obviously not a good thing when a page looks blank and you have to scroll down for a screen and a half to find content. There were several posts on their support forums asking about the same thing but the only replies were people stating they figured it out (without sharing what they changed) or others asking the same question...anyone, anyone know the answer? Andrew Looking for a place at the table Golden ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is Flash really THAT good?
I feel that flash is a good TOOL to extend the functionality or design of an application. When used as a tool, flash is very powerful and has it's place. It is when it is abused that it becomes combersome. I equate it to using a hammer to drive screws; when you use the right tool, you'll get the desired results. -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 11:59 AM To: CF-Talk Subject: RE: Is Flash really THAT good? I've always equated Flash movies with special effects in movies. The best special effects in movies are the ones you don't even know are there. Sometimes I'm on a site and I realize wow how'd they do that ... and then a right click on a certain area of the screen reveals its a Flash movie. Thats where I think Flash is best used. Something else that I wanted to mention... if you load a JPG in your browser, would you consider it to be a website? Probably not. If you load a quicktime movie in your browser, is that a web site? I would say no. Same is true for a Java applet. By the same logic, I think that when a flash movie is loaded into a web browser and its the only thing on the page, its really not a web site but instead a Flash movie running in your browser. When I hear that someone is doing a website in Flash, that never sits well with me. If you are building an application that doesn't use HTML, doesn't reload, can't be indexed by Google, doesn't even need to run in a web browser in the first place, is it really a web site or is it something else? If we were to all use Flash to build our internet applications, there would be no practical use for the web browser in the first place and suddenly the web is a propritary place. So the question I pose is this: If someone were to ask you to build them a website and your final product is a URL to a web page that runs a full page Flash movie, did you build them what they asked for? Did you build a website? Thoughts? -Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Right, so make sure that the chars entered are part of the list of acceptable chars? They don't all need to be there, just can't have chars that aren't supposed to be there.. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:21 PM To: CF-Talk Subject: RE: Time Format Question Cause the field does not need to have all those characters. Trying to rule out someone putting in something that is not part of the proper Time Mask paramters [EMAIL PROTECTED] 04/04/03 02:15PM Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time Format Question
Oh good lord: REFindNoCase([^tmhs: ],string) -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 3:01 PM To: CF-Talk Subject: RE: Time Format Question Not trying to strip out the character, I just need to know if the TIME MASK that a user enters into a text box, is a valid time mask. HH MM SS = VALID HH MM BB = INVALID HH:MM = VALID BB:M:YTS = INVALID [EMAIL PROTECTED] 04/04/03 02:49PM REreplace(string, [^tTmMhHsH: ], , all) that'll strip out the extra chars --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:28 AM To: CF-Talk Subject: RE: Time Format Question Right, so make sure that the chars entered are part of the list of acceptable chars? They don't all need to be there, just can't have chars that aren't supposed to be there.. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:21 PM To: CF-Talk Subject: RE: Time Format Question Cause the field does not need to have all those characters. Trying to rule out someone putting in something that is not part of the proper Time Mask paramters [EMAIL PROTECTED] 04/04/03 02:15PM Why don't you just check to make sure the mask contains only the chars: h,H,m,M,s,S,t,T,: (or whatever the time chars are). -R -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 2:03 PM To: CF-Talk Subject: Time Format Question ok I have a field which allows a user to enter a time format MASK to be used when displaying time on a website. Example: user enters: H:MM:SS TT This is a proepr formatting mask for TIMEFORMAT. However if a user enters: NOTIMEFORMAT or something stupid and off the wall, the timeformat function should blow up. I entered: MONKEY as a mask and the TIMEFORMAT function output: #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y I also tried to use IsDate in conjunction with CREATEDATE so I could have a valid date but an invalid time and it returns as a true statement that it is a DATE. There is not IStime function.. anyone have an idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery UPDATE
I would check the FORM.Password field and see what it's value is. If you have more than one password field on your form, the form variable will be a list containing the values of all the fields.. HTH -R -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 12:17 PM To: CF-Talk Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery UPDATE
Eh.. if you are talking about character masking, you can use input type=password .. . Otherwise, i don't understand the question :) -R -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 1:13 PM To: CF-Talk Subject: Re: cfquery UPDATE I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value= size=33 class=inputfield I then select the username I want to edit and click on the submit button which takes me to my edit template. Here I'm inserting the fields of the user into input tags for editing. What I would like to do is have the password field return also and not display the password from the database but be able to edit the field and return * when typing rather that the characters. Am I making sense? On Thu, 3 Apr 2003 10:06:45 -0800, Bryan Stevenson wrote: Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba ---
RE: Dynamically Getting Current Directory (Is There A Better Way To Code This?)
expandPath('.')?
-R
-Original Message-
From: Mike Alberts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 4:57 PM
To: CF-Talk
Subject: Dynamically Getting Current Directory (Is There A Better Way To
Code This?)
Hello all,
ColdFusion 5.
I have this code in my index.cfm files in directories throughout my sites
that sets the value of a variable to the name of the directory that the file
is in (just the name with no slashes and backslashes, etc)
cfset Request.ThisDirectory =
ListLast(Replace(GetDirectoryFromPath(GetCurrentTemplatePath()),/,\,all),'\')
This code works fine and lets me use it on both Windows and Linux boxes
without changing it. But my question is, is there a better way to do it
(that works on both platforms)?
Case and special characters are not an issue as I always name my directories
all lower case and no special characters.
Thanks for any input.
Mike
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamically Getting Current Directory (Is There A Better Way To Code This?)
yeah. how bout i read your message first. nevermind.
-Original Message-
From: Ryan Emerle
Sent: Tuesday, March 25, 2003 5:00 PM
To: CF-Talk
Subject: RE: Dynamically Getting Current Directory (Is There A Better
Way To Code This?)
expandPath('.')?
-R
-Original Message-
From: Mike Alberts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 4:57 PM
To: CF-Talk
Subject: Dynamically Getting Current Directory (Is There A Better Way To
Code This?)
Hello all,
ColdFusion 5.
I have this code in my index.cfm files in directories throughout my sites
that sets the value of a variable to the name of the directory that the file
is in (just the name with no slashes and backslashes, etc)
cfset Request.ThisDirectory =
ListLast(Replace(GetDirectoryFromPath(GetCurrentTemplatePath()),/,\,all),'\')
This code works fine and lets me use it on both Windows and Linux boxes
without changing it. But my question is, is there a better way to do it
(that works on both platforms)?
Case and special characters are not an issue as I always name my directories
all lower case and no special characters.
Thanks for any input.
Mike
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC Performance Best Practice
Your best bet is to separate CFCs into their logical parts. This will aid in usuability and readablity. Performance differences would be negligable(sp?). Remember that CFCs are components and most developers will see them as that. So instead of having one big CFC for ecommerce app, you would have a component for each component of the ecommerce application (customers,orders,cart,etc..). My $0.02 -- Ryan Emerle -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 10:25 AM To: CF-Talk Subject: CFC Performance Best Practice The question I have, is there any performance advantages and/or disadvantages to one large CFC file versus several smaller ones? I'm writing an application using a CFC for all my administration database tasks. Currently I have everything in one CFC file. The tasks could probably be logically broken up into three or four smaller CFC files by function type. My question is there any performance reason to do this? The single large file will probably top out at about 20K, does this add to the overhead of any template calling on the CFC? -- Ian Skinner Web Programmer BloodSource Sacramento, CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Retrieving CFMX code from a db
If the file is written to the filesystem when a change occurs, then CFMX _should_ recompile it upon execution. That shouldn't be a problem. The question is _why_ would you want to make your code so inaccessible and inefficient. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:16 PM To: CF-Talk Subject: RE: Retrieving CFMX code from a db You can't parse CF code in a variable, it has to exist as a file on the server. That being said, I've heard of various people creating a ramdisk on their server, pulling the CF code from the database, writting it to the ramdisk, and then CFINCLUDEing it into their app. However, that was before CFMX and it's precompilation cycle, so that won't work anymore (unless you like waiting for the java compiler to spin up every request). You could probably write your cf code, compile it, and the write the .class file to the database and extract that and write it to the CF cfclasses directory after computing the appropriate filename and including it that way, although that'd be a messy proposition. Bottom line, I think you're out of luck, at least with CF. I know you can embed SSI commands in your CF code and the web server (if it supports it) will process them in the returned content. You might be able to leverage that to some degree, depending on what you're doing, but no dynamic CF. barneyb -Original Message- From: Michael J. Sammut [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 5:01 PM To: CF-Talk Subject: Retrieving CFMX code from a db Hello all, I am in a quandry. I am currently storing all my data in a SQL database using XML for each record. Once the data goes in I am coverting it to be XML safe (i.e., span class=thistest/span is saved as lte;span class=quot;thisquot;gte;testlte;/spangte;). This leads me to my question. I would like to be able to save CF code to the database and upon retrieval parse the code. So I have two issues that I am running into issues with: 1. I am attempting to unformat the info saved in the XML format and convert it back to readable code. 2. Parse the cold fusion code from the db to the screen. Any thoughts on a good way to go about this? Regards, Michael J. Sammut ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFX_Tags and Multiple Servers
In CFMX you could make a webserivce wrapper for the CFX tag, but other than that, im pretty sure you would need a copy of the CFX on the other server. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:52 AM To: CF-Talk Subject: CFX_Tags and Multiple Servers Hi All, Is a CFX Custom Tag installed on a web server able to be called and run from websites located on a remote server, if so how would it be done? Thanks, Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RegEx Help! (more detail)
Don't think a single regEx will do it for ya. You could use the following code though
(mind the wrapping):
!--- While we still have the string to remove in our text ---
cfloop
condition=#REFindNoCase('a[^]+href=\javascript:popUpJargonDefinition\([0-9]+\)\',text)#
!--- Remove an occurance ---
cfset
text=REReplaceNoCase(text,(.*)a[^]+href=javascript:popUpJargonDefinition\([0-9]+\)([^]+)/a(.*),\1\2\3)
/cfloop
HTH
-Ryan
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 10:33 AM
To: CF-Talk
Subject: RE: RegEx Help! (more detail)
As I wrote in my previous mail, this will not work if you have more than
one link in the text. Adding ALL when using a regexp that matches
start and end (^...$) is pointless, as you can have only one occurrence.
Also, this will replace the entire text by just the label between the
anchor tag. The remark about the parens is correct, but I already
corrected that.
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: donderdag 20 maart 2003 16:02
To: CF-Talk
Subject: RE: RegEx Help! (more detail)
cf_homerDoh!/cf_homer
I think I see the problem -- the parens. We must escape the set that's
actually in the text!
CFSET bodyText = REReplaceNoCase (publishGetArticleOnContentId.body1,
'^.*A class=jargon
href=javascript:popUpJargonDefinition\([0-9]*\)([^]*)/a.*$',\1,
'all')
I also added 'all' to the rereplacenocase() so that it will strip all
instances of this, rather than just the first one. Try that. I think it
will work better.
-- Ben Doom
Programmer General Lackey
Moonbow Software, Inc
: -Original Message-
: From: Oliver Cookson [mailto:[EMAIL PROTECTED]
: Sent: Thursday, March 20, 2003 4:43 AM
: To: CF-Talk
: Subject: RE: RegEx Help! (more detail)
:
:
: Hi Jochem,
:
:
:
: Thanks for the reply (and the others who replied too!).
:
:
:
: Ok let me explain myself a little better. I am outputting a page of
: text
:
: and if the user chooses to turn off the jargon links i want to
: strip
:
: all links that look like this out:
:
:
:
: A class=jargon
: href=javascript:popUpJargonDefinition(2)article/A
:
:
:
: You say that would be easy?
:
:
:
: Well i want to keep the text inbetween the A/A tags (in this
:
: case article) and the argument i am passing to the JS function
: could
:
: be ANY number (from 1 to 2000? As this is the ID of the jargon.)
:
:
:
: I need to replace ALL occurences of this text within the large
: string.
:
:
:
: I tried this RegEx below but it didn't work? (sorry for the
: text-wrap)
:
:
:
: CFSET bodyText = REReplaceNoCase
:
: (publishGetArticleOnContentId.body1,'^.*A class=jargon
:
: href=javascript:popUpJargonDefinition([0-9]*)([^]*)/a.*$',\1)
:
:
:
: Thanks in advance and any help would be appreciated. :)
:
:
:
: Oliver
:
:
:
:
:
: : -Original Message-
:
: : From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
:
: : Sent: Friday, March 14, 2003 6:23 AM
:
: : To: CF-Talk
:
: : Subject: Re: SOT: RegEx Help!
:
: : Do you mean this string is part of a larger text? Use:
:
: : cfset text = REReplaceNoCase(text,'^.*A class=jargon
:
: :
: href=javascript:popUpJargonDefinition([0-9]*)(.*)/a.*$',\1)
:
: : else:
:
: : cfset text = REReplaceNoCase(text,'A class=jargon
:
: : href=javascript:popUpJargonDefinition([0-9]*)(.*)/a',\1)
:
: :
:
: : Jochem
:
:
:
:
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFX_Tags and Multiple Servers
Here's some info on CFMX webservices.. Haven't read it but it seems pretty useful: http://hotwired.lycos.com/webmonkey/02/34/index3a_page7.html?tw=programming -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 11:39 AM To: CF-Talk Subject: RE: CFX_Tags and Multiple Servers Interesting concept for the webservice - I'm pretty new to webservices - any tutorials, reading on how start with something like this? Thanks, Mark -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 11:15 AM To: CF-Talk Subject: RE: CFX_Tags and Multiple Servers In CFMX you could make a webserivce wrapper for the CFX tag, but other than that, im pretty sure you would need a copy of the CFX on the other server. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:52 AM To: CF-Talk Subject: CFX_Tags and Multiple Servers Hi All, Is a CFX Custom Tag installed on a web server able to be called and run from websites located on a remote server, if so how would it be done? Thanks, Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting XP Login Name?
You can access the SERVER's registry.. not a clients. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 9:09 AM To: CF-Talk Subject: RE: Getting XP Login Name? yes, it is possible, using cfregistry -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 13:53 To: CF-Talk Subject: RE: Getting XP Login Name? How would you access a user's registry??? Is that even possible? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:34 AM To: CF-Talk Subject: RE: Getting XP Login Name? I woudl assume that if you can get to the registry you can get that info... -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 13:22 To: CF-Talk Subject: Getting XP Login Name? I have not played with CF for a couple and years, and now am getting back into it. Can someone tell me if it is possible to retrieve the XP login name on the puter that is accessing my app? Thanks! Tim Claremont Applications Specialist Independent Living For Seniors 585.922.2882 [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. Thank you! ViaHealth ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Documentation examples
I have developed some tags that will enumerate custom tags on the system (giving you the paths to all of the tags) and an attribute parser that may be of some use. At very least, the custom tag enumeration could be used to develop your own CFC-like self-documentation. The Custom Tag Enumeration Suite can be found here: http://www.emerle.net/programming/index.cfm Hope it helps someone :) -- Ryan Emerle -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:13 AM To: CF-Talk Subject: RE: Documentation examples There is a version of JavaDoc for UDFs call UDFDoc. There is even a tool to generate docs from it. This can be downloaded from cflib.org. Has anybody done anything similar for regular CF templates? Obviously nothing can inspect what's going on in the template like you can with a function, but a way to format the CFML comment at the top of the page so it can be parsed and displayed would be helpful. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stripping from variable
Well, if it is duplicated each time, wouldn't you just need to get the len() of the field and divide by two? So you would have something like this left(file,len(file)/2) HTH -Ryan -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 8:59 AM To: CF-Talk Subject: Stripping from variable Hi, I have a variable called file which is being passed to my template via JS. The output always gets duplicated. file = test2test2 -OR- file = cubacuba How can I ouput just one occurrence? Is there some sort of match function? file = cuba --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Realtime Filesystem Search
Anyone know of any tools to search a collection of files on the filesystem in realtime (i.e. w/o indexing). Need a tool comparable to 'grep' for unix that will allow me to search file contents with regEx and the like. Anyone have any suggestions? -- Ryan Emerle ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Realtime Filesystem Search
Ehm.. i should add that i need to perform the search from ColdFusion (5.0 or MX).. -Original Message- From: Ryan Emerle Sent: Friday, March 14, 2003 8:53 AM To: CF-Talk Subject: Realtime Filesystem Search Anyone know of any tools to search a collection of files on the filesystem in realtime (i.e. w/o indexing). Need a tool comparable to 'grep' for unix that will allow me to search file contents with regEx and the like. Anyone have any suggestions? -- Ryan Emerle ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: did mail get sent??!
/var/log/mail.log usually contains sendmail logs. -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 9:20 AM To: CF-Talk Subject: did mail get sent??! Hi On a solaris 6 box, with cf 5, using sendmail. I have a loop thats emails about 500 people How would I get proof that those 500 emails were actually sent? Is there a log file I could search through? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: force a download - .txt file
You could serve the file up with CFCONTENT and use a Content-disposition header to mark the content as an attachment (giving you the Save As box). This would require the file to be called via a cfm file though, instead of a straight link to the text file. Perhaps there is a better way.. HTH -R -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 4:52 PM To: CF-Talk Subject: force a download - .txt file Hi everyone. I am trying to force a save as box in IE when a user clicks on a link that creates a .txt file. What keeps happening is that the browser will open the .txt file and display it - when what I really want is for the user to be prompted with a save as box. Has anyone figured out a way to do this? Thanks very much. Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Linkpoint
Did you read the manual? :) -- Ryan Emerle Data Systems Developer Interactive Network Systems, Inc. -Original Message- From: Matthew Fusfield Sent: Friday, March 07, 2003 9:30 AM To: CF-Talk Subject: Linkpoint Anyone here using Linkpoint/basic HTML with a CF-based ecommerce system? We are trying to post payment data to them via cfhttp but we keep getting an error back from their web server. Their tech support claims that it is because we don't have a live website yet. I have a feeling it has something to do with their website checking the referer, but I've tried to send what they are expecting with cfhttpparam but it still doesn't seem to work. Thanks, Matt Matthew I. Fusfield Manager of Data Systems Development InterActive Network Systems, Inc. http://www.ins-business.com/es http://www.ins-business.com/es (856) 401-9000 Ext: 1015 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFILE and carriage returns
You could: cfset crlf=#chr(13)##chr(10)# Then insert #crlf# wherever you need the carriage return/linefeed. Or, you can just set the variable with the crlf in it: cfset output=Workshop Registration Information startDate: #var# endDate: #var2# .. Lastly, you could use CFSAVECONTENT.. HTH -Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 12:01 PM To: CF-Talk Subject: CFFILE and carriage returns I am trying to write files using CFFILE and I would like to have carriage returns in the file to make it look something like below: Workshop Registration Information startDate: blah endDate: blah workshopID: blah title: blah ... Right now, I am creating a variable called orderInfo and writing that to the file. The problem is that my file ends up with everything on one long line and looks something like below: Workshop Registration Information startDate: blah endDate: blah workshopID: blah title: blah ... Anyone know how to solve this? Any suggestions would be really appreciated. --Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOCATION IE 6
We have found this to be a problem with IE6 (specifically wininet.dll packaged with SP1) and Keep-Alive handling. Temporarily, you can disable Keep-Alives on the server. MS is aware of the problem and there is a MS KB article related to it. My collegues and i discovered this this morning and have not fully tested it. It seems to have resolved most, if not all, of our header-display/browser-hanging problems. Here is the MS KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;811383 My collegue, Matthew Fusfield, will be posting additional information. -- Ryan Emerle -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 8:43 AM To: CF-Talk Subject: Re: CFLOCATION IE 6 Thanks you all for the suggestions. Some good work arounds and other paths to follow ... Matt On 2/11/2003 4:38 PM, Jochem van Dieten [EMAIL PROTECTED] wrote: Matt Kornguth wrote: Positive it is just IE 6. I test on multiple versions of IE (mostly 5.5) without ever seeing the headers. Verify that the response from the server is correct and then maybe try a microsoft.* newsgroup? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOCATION IE 6
Yeah, we tried that and it didn't seem to work. Also, this is occuring in a very large project with more that 170 templates that have cflocations in them. Not to mention we don't want to create more problems down the road because of a bug in IE now. We honestly did try every possible combination of header-based redirects without success. JS and META refreshes were not an option either.. Thanks -Ryan -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 1:21 PM To: CF-Talk Subject: Re: CFLOCATION IE 6 oi Ryan!! don't know if this will help or if even pertains to the question as I only have the last few responses to go by... and I don't feel like searching the archives... so if is a repost of information... oh well. we use this to fix our cflocation ie6 problem... cfheader name=location value=page_goes_here cfheader statuscode=302 statustext=Moved temporarily cfabort Critz Thursday, February 13, 2003, 11:56:44 AM, you wrote: RE We have found this to be a problem with IE6 (specifically wininet.dll packaged with SP1) and Keep-Alive handling. RE Temporarily, you can disable Keep-Alives on the server. MS is aware of the problem and there is a MS KB article related to it. RE My collegues and i discovered this this morning and have not fully tested it. It seems to RE have resolved most, if not all, of our header-display/browser-hanging problems. RE Here is the MS KB article: RE http://support.microsoft.com/default.aspx?scid=kb;en-us;811383 RE My collegue, Matthew Fusfield, will be posting additional information. RE -- RE Ryan Emerle RE -Original Message- RE From: Matt Kornguth [mailto:[EMAIL PROTECTED]] RE Sent: Wednesday, February 12, 2003 8:43 AM RE To: CF-Talk RE Subject: Re: CFLOCATION IE 6 RE Thanks you all for the suggestions. Some good work arounds and other paths to follow ... RE Matt RE On 2/11/2003 4:38 PM, Jochem van Dieten [EMAIL PROTECTED] wrote: Matt Kornguth wrote: Positive it is just IE 6. I test on multiple versions of IE (mostly 5.5) without ever seeing the headers. Verify that the response from the server is correct and then maybe try a microsoft.* newsgroup? Jochem RE ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfoutput + cfloop: bug or
Did you try this? cfloop query=query1 cfoutput#query1.whatever#/cfoutput cfloop query=query2 cfoutput#query2.whatever# #query1.whatever#/cfoutput /cfloop /cfloop I have found when you try to mix queries like that, CF has a bit of a problem, especially if query1 and query2 share fieldnames (even if you 'scope' the queries). A work around would be something like this: cfloop query=query1 !--- Query1 'scope' --- cfoutput#query1.whatever#/cfoutput !--- Save in Variable scope --- cfset q1whatever=query1.whatever cfloop query=query2 cfoutput#query2.whatever# #q1whatever#/cfoutput /cfloop /cfloop I've had to do perform similar workarounds in the past for these goofy situations. I am also of the school that says output and loop iteration should be separate, i rarely use cfouput to iterate through loops. HTH -- Ryan Emerle -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 9:26 AM To: CF-Talk Subject: cfoutput + cfloop: bug or Hello! I have two queries - the output of the first one is handled by a cfoutput tag, the second one is handled by a cfloop (nested construction): cfoutput query=query1 bla bla #query1.name#: cfloop query=query2 #query2.surname# (event: #query1.eventtitle#)br /cfloop /cfoutput Now I have the result that query1.eventtitle always returns the first row of query1, it's not looping as desired. my workaround: cfoutput query=query1 bla bla #query1.name#: cfset a_str_title = query1.eventtitle cfloop query=query2 #query2.surname# (event: #a_str_title#)br /cfloop /cfoutput This works as expected. We are on CF 5 (MX in the future time) Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Size of string in Bytes
Supposing there is no goofiness (ie non-ASCII), the length in bytes is the length of the string in characters.. (a character is a byte). len(string) = # of bytes. -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:05 PM To: CF-Talk Subject: Size of string in Bytes Anyone know of an easy way to get the size of a string in bytes? TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UDF always returning YES no NO when I call it in a cfoutput
You can use:
return ;
At the end of the UDF. Though it is best if you just return the result of the UDF as
that is usually the way it is done :)
HTH
-Ryan
-Original Message-
From: Huynh Weiming [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 5:06 PM
To: CF-Talk
Subject: UDF always returning YES no NO when I call it in a cfoutput
Is there a way to get rid of the YES no NO from a UDF
I have a UDF
function someFunction(param)
{
}
when I call someFuntion like this:
cfoutput
#someFunction(param)#
/cfoutput
the output is as follow:
someFunction result
and the word YES or NO following the result
thanks.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: Regular Expression
Im not sure how this relates to regular expressions.. but you could use this script
nonetheless:
cfscript
function asciiConv(letter) {
return ###asc(letter)#;
}
/cfscript
HTH
-Ryan
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 9:27 AM
To: CF-Talk
Subject: SOT: Regular Expression
Are there any resources / tutorials / tools / Cftags / UDF / CFC's /
functions that would allow a plain-text string to be converted to ASCII HTML
code? (ie, A = #65; and so on)
Thanks, Mark
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replacing characters in a string
Yet another way.. With regular expressions:
cfset maskDigits=8
cfset masked=REReplace(CCnum,^[0-9]{#maskDigits#},repeatString(*,maskDigits))
-Ryan
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 7:56 AM
To: CF-Talk
Subject: Replacing characters in a string
This should be a simple enough one...
I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?
TIA
Ryan
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Replacing characters in a string
Sorry.. MIDDLE eight.. Now it gets ugly with regEx..
cfset
masked=REReplace(ccnum,([0-9]{4})[0-9]+([0-9]{4}),\1#repeatString('*',8)#\2)
-Ryan
-Original Message-
From: Ryan Emerle
Sent: Tuesday, January 07, 2003 10:47 AM
To: CF-Talk
Subject: RE: Replacing characters in a string
Yet another way.. With regular expressions:
cfset maskDigits=8
cfset masked=REReplace(CCnum,^[0-9]{#maskDigits#},repeatString(*,maskDigits))
-Ryan
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 7:56 AM
To: CF-Talk
Subject: Replacing characters in a string
This should be a simple enough one...
I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?
TIA
Ryan
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: looping through a list using cfscript
Here ya go..
cfscript
myList=item1,item2,item3;
for(i=1;i lte listLen(myList);i=i+1) {
listItem=listGetAt(myList,i);
/* Loop Contents */
}
/cfscript
HTH
-Ryan
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 11:03 AM
To: CF-Talk
Subject: looping through a list using cfscript
I need to loop through a comma delimited list (the output of a multiple select box)
using cfscript, yet list isn't a loop type in cfscript. Is there any workaround?
Thanks
Pete
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Evaluate
This should work: #Request.thisQuery[Name]# -Ryan -Original Message- From: Mike Alberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 3:51 PM To: CF-Talk Subject: Using Evaluate Hello All, I've read many of you discouraging the use of the 'Evaluate' function, for performance reasons. So I ask ... Say I have code like this (within a cfoutput): #Evaluate(Request.ThisQuery .Name)#, where Request.ThisQuery is the name of a query that I set and .Name refers to a column in the table that I am querying. Obviously this returns the value of the column for that particular record. 1. Is there another way to code this to not use Evaluate? 2. If there ISN'T another way, would I be better off from a performance standpoint to run the Evaluate function once and set a variable with the value that it returns and just call that variable, instead of using Evaluate multiple times in the page (hope that made sense)? Thanks for any help, Mike Alberts ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Evaluate
yah.. misunderstood. -Ryan -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 4:40 PM To: CF-Talk Subject: RE: Using Evaluate No - remember (unless I read him wrong), he said Request.thisQuery was the _name_ of the query, ie, request.thisQuery = GetUsers, and what he really wants is GetUsers.Name. (Did I read you right Mike?) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 3:34 PM To: CF-Talk Subject: RE: Using Evaluate This should work: #Request.thisQuery[Name]# -Ryan -Original Message- From: Mike Alberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 3:51 PM To: CF-Talk Subject: Using Evaluate Hello All, I've read many of you discouraging the use of the 'Evaluate' function, for performance reasons. So I ask ... Say I have code like this (within a cfoutput): #Evaluate(Request.ThisQuery .Name)#, where Request.ThisQuery is the name of a query that I set and .Name refers to a column in the table that I am querying. Obviously this returns the value of the column for that particular record. 1. Is there another way to code this to not use Evaluate? 2. If there ISN'T another way, would I be better off from a performance standpoint to run the Evaluate function once and set a variable with the value that it returns and just call that variable, instead of using Evaluate multiple times in the page (hope that made sense)? Thanks for any help, Mike Alberts ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QUERY IN performance hit
Well, by using a list like that, you are kind of defeating the indexing mechanism of the SQL server. You could try to simplify the list by grouping it in large sequential chunks and using the BETWEEN operator. You also want to make sure that TicketID is indexed (if not the primary key). HTH -- Ryan Emerle -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 9:35 PM To: CF-Talk Subject: QUERY IN performance hit I'm doing a query like this: cfquery name=updateTicket datasource=#request.dsn# username=#request.dbuser# password=#request.dbpass# UPDATE Tickets SET folder = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#getEscalationInfo.eFolder#, dateUpdated = cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#CreateODBCDateTime(Now())# WHERE ticketID IN (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#tickList# list=Yes) /cfquery The tickList can contain 20-30,000+ items, and performing this query takes forever. What can I do to improve this a bit more? Perhaps doing multiple updates within the cfquery or doing ticketID = #List[1]# OR ticketIS = #List[2]# etc? Any ideas? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: CFX_SNMP, usefulness in the CF community
Hi, I've written a CFX tag that creates a simple and easy interface with SNMP-enabled entities. I am curious of the community's need for such a tag. The tag does the following: * Provides a simple interface to the somewhat complex world of SNMP * Probes multiple SNMP OIDs in a single datagram connection * Returns an easy-to-use query data structure with the results The tag currently performs GETs and WALKs through the SNMP OID tree. Below is an example: CFX_SNMP OID=1.3.6.1.2.1.25.4.2.1.2,1.3.6.1.2.1.25.5.1.1.2,1.3.6.1.2.1.25.5.1.1.1 host=#host# Community=#communityString# r_qResults=procInfo That call will actually return all NT processIDs, process memory usage, CPU time and process names in one QUERY (procInfo). Once you have the data available in CF, you have unprecedented control over the data in backend structures. I am trying to gauge the utility of such a tag as to determine whether i should bother to continue with development and QA. Let me know your feelings either here or privately. Thanks! -- Ryan Emerle, BSCS [EMAIL PROTECTED] Lead Systems Developer Interactive Network Systems, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: file storage in the database
First and foremost, any feedback at all is much appreciated. Well, I know I phrased my question inappropriately. What I really want to know is: If anyone has ever attempted to store files in the database (files such as .pdf, any image files, word documents, text files, cad drawings, you name it files.) If anyone has successfully done so. If anyone made attempts and was either not successfull, or could not satisfied with that implementation. If they were not successful, if it was due to any limitations of the db driver or limitations with coldfusion. I did fully understand your query, and was simply being concise. For the long answer: I have stored files in a DB, and the only issues i have seen are in ColdFusion's string handling. That is, attempts to dump files into a variable have lead to some corruption of the data. Dumping the file contents directly in/out of the DB have been successful. I have not used this in a multi-user environment due to the harsh performance issues (about 3x slower than the filesystem). So, i have not accounted for all possible file content combinations and their interaction with a DB server (or its drivers). This is also a widely unsupported means of managing files. So, it might occur that after your have stuffed 3000 files into the DB that one mission-critical file isn't going to work and attempts to find support will result in a lot of i told ya so responses. So, in general, i've seen it work, but the performance sucks. If performance/scalability isn't your concern, and you don't need guaranteed file integrity (unless you implement something programmatically), then go for it. I personally would seek alternate means of dealing with the security problem, rather than using an ill-suited tool and counting on not having more than X simultaneous users. HTH -Ryan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: file storage in the database
We have a client/server software package that stores all the files in the db that we are currenly rewriting in ColdFusion, but someone on the team has the idea that CF does not support file storage in the db. I think they were specifically referring to the storage of images, but we will need to store any type of file including but not limited to PDF. If it is not supported by coldfusion, then we will just store the files out to disk. I'd have to imagine that the file system would be more efficient at storing files then a DB. I generally like to make a clear distinction between files and data. Store data about the files in the DB (including location on the disk) and store the actual files on disk. I don't know of any benchmarks, but i personally like to make that distinction. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Updating a graph on the fly?
I'm looking for the best direction to look for the solution to this problem What kind of graph will be used to represent this data? (i.e. bar, pie, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Acitve edit
I hope I have made myself clearer. I guess what I am trying to ask is whether the pages that are creatdd in active edit are run through the CFML parser or straight through the web server to the browser The image chooser is a series of CFML files. They can be manipulated to do whatever you desire (as long as you've bought the activedit source). I don't really understand what you are trying to do, but that should get you started. On a standard install, the directory with the cfml files is webroot/activedit/inc/ the image-manipulation files are image.cfm, right.cfm, and left.cfm. HTH ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular Expression
I'm trying to come up with a regular expression that will help me turn this: [Object] ID=2031 URL=http://www.cnn.com/ OtherSrvLev=0w33a Category=31 Into: http://www.cnn.com/ You could easily do it with two statements. I don't think CF allows for retrieving matches to regular expressions like perl. Assuming the text above in in a variable called text, I would just do: cfset text=REReplace(text,^.*URL=,) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Changing the name of a file...
Is there a way to force it back to setup.exe? Should be able to just link to ./index.cfm/setup.exe?QueryItem1=1QueryItem2=2..., treating the page with cfcontent as a directory. I just did this the other day.. If you are calling it from a form, i believe you can just CFLOCATION to the url. cfif isDefined(form.submit) cflocation url=./index.cfm/setup.exe /cfif -Ryan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: regexp for swear filter
I want to be able to do this with a single regexp, rather than list looping
over the text and replacing the index of the current loop iteration with
its
repeatstring('*', len(index)) counterpart - which is slow if I have to do
this for many text blocks on the same page..
[...]
would the following work (bearing in mind I'm not great at regexps)?
rereplacenocase(thistext, #list#, #rereplace(list, '[^\|]', '*',
'ALL')#, ALL)
You may be able to use REFind to get the Pos and Len of the substring
matched by the regexp. I don't think it'd be a one-liner, maybe two
or three, but you wouldn't need a loop.
I haven't tried to do this, but i would imagine that would be a good place
to start.
-Ryan
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Thoughts
Well the manager wants them to make all the pages static. To have them hard coded. The manager says that because the info is only updated once in a blue moon they don't need the extra calls to the db. Well the developer called me to find out where they could find info on why this would be a bad idea. It depends on the situation, but in reality if a few extra calls to the db server are causing a problem, then perhaps it's best to upgrade the db server instead of trying to band-aid the problem. If that's not a viable option, some caching may cut down the number of db requests. -Ryan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Locking session scope on existence checks
Do ya need to lock the session scope if you're just checking if a session var exists? Im well versed in why/how to lock for read and write, so no explanations will be needed in that area :) -Ryan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio: Can Regular expression replace form.* ?
Should be able to just use a regular replace.. select the block what you want to replace and: replace # with #Trim( and replace # with )# In the selection (the '' being a literal double quote) -Ryan -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 12:35 PM To: CF-Talk Subject: CF Studio: Can Regular expression replace form.* ? I need a way to do a replace on text that has a known prefix but an unknown ending and an unknown length. An example of this would be to wrap functions around existing form input value. I need wrap all my input values with trim() Each variable has a attribute form. Input values: input type=text name=FirstName value=#Form.FirstName# input type=text name=LastName value=#Form.LastName# input type=text name=Address value=#Form.Address# I need it to look like: input type=text name=FirstName value=#Trim(Form.FirstName)# input type=text name=LastName value=#Trim(Form.LastName)# input type=text name=Address value=#Trim(Form.Address#) Anyone know if this is possible? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array i think
YOu could just leave them in a list and do some list operations on them in a loop: cfset count=1 cfloop list=#my_list# index=item cfoutputThe #listGetAt(colors,count)# #item# /cfoutput cfset count=count+1 /cfloop Or you can use structs but the key of the struct (in this case the animal name) will be all upper case on cfoutput. cfset my_list=structNew() cfscript my_list[dogs]=Brown; my_list[cats]=Black; ... /cfscript Then you can output them like: cfloop collection=#my_list# item=animal cfoutput The #animal# #my_list[animal]# /cfoutput /cfloop Or you can use an array.. but i've found arrays to be harder (more overhead) to work with when you are talking about relations. IF you do choose do an array, you might find a 2D array easier. That is: cfset myArray=ArrayNew(2) cfset myArray[arrayLen(myArray) + 1][1]=Dogs cfset myArray[arrayLen(myArray)][2]=Brown cfset myArray[arrayLen(myArray) + 1][1]=Cats cfset myArray[arrayLen(myArray)][2]=Black cfoutputThe #myArray[1][2]# #myArray[1][1]#/cfoutput == The Brown Dogs -Ryan -Original Message- From: David Misha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 5:43 PM To: CF-Talk Subject: Array i think I have: cfset my_list = Dogs,Cats,Mouse,Elephant cfset colors = Brown,Black,Grey,Pink I want to get: The Brown Dog the Black Cat The Grey Mouse The Pink Elephant ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 adding extra quote marks to cfquery
I had the same problem, but outside of UDFs.. I was testing dynamic SQL statements, and ran into a situation where the var i created would have single quotes around the appropriate items, but when the SQL server got it, it had double single quotes. If i removed the original single quotes (hoping for at least on pair of single quotes) all quotes were removed. The same thing happend if i tried to use double quotes, when the SQL server got it, it had double double quotes and the SQL server threw an error. I'm using CF5, i dont know whether this is an issue with CF4.5 or not. I played with it for about an hour and found some other way around my particular problem. I'd still like to know if this is a legitimate issue, and if there is some kind of workaround. If anyone knows... -Ryan -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 6:22 AM To: CF-Talk Subject: CF5 adding extra quote marks to cfquery I'm playing with some UDF's, and have this section of code -- cfoutput where:br #MakeWhereClause(CreateRecordID( qQuery))# /cfoutput cfquery name=qDoesit datasource=#request.dbname# select * from actuals where #MakeWhereClause(CreateRecordID( qQuery))# /cfquery -- This produces: -- where: dateid='04-Jan-01' and gcljobno=200140206 and taskid='GCL001' and starttime='09:00' and resourceid='tchiverton' -- Then the error: -- ODBC Error Code = S1000 (General error) [Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended SQL = select * from actuals where dateid=''04-Jan-01'' and gcljobno=200140206 and taskid=''GCL001'' and starttime=''09:00'' and resourceid=''tchiverton'' -- So although my MakeWhere UDF is returning a correctly escaped SQL string, when it goes inside the cfquery, and does the same bit of code, CF seems to be adding extra quote marks. Is this known behaviour ? Any way to run it off ? Other pleas for help appreciated ? :-) Regards, Thomas Chiverton Intranet Architect 01565 757 909 Another fine development by Boring Sigs Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
