Re: CFFTP and Windows Firewall
Chandan, Thanks for the reply. Yes, this is happening after applying hotfix2, although I have another server that I have not applied the patch to that I can reproduce the issue on as well. That being said, I'm not convinced this is a CF problem, because I get pretty much the same result trying to FTP the file using the Windows command line FTP client, and also using Internet Explorer to try to fetch the file. However, I don't believe those clients use passive mode so maybe that's the problem there. I suppose it's possible CF is not using passive mode when I tell it to? Is there anyway to trace what's going on in the CFFTP (to see the raw commands it's sending)? My server config is: Windows 2003 SP 2 IIS 6.0 CF 8 hotfix 2 I tried changing the JRE to 1.6.0 update 3 but that didn't help. I also updated the apache commons net library in CF to 1.4.1 but that didn't help either. Hi Sean, If I may ask, did this started only after applying hotfix2 or was it with 8.0 too? What is your server configuration? Any other info for reproducing this would be very much appreciated. In case, I can be reached at [EMAIL PROTECTED] FYI, hotfix 2 contains fix for a bug in ftp of similar nature. There is a possibility that the hotfix jar you have is either bad or not being picked! Thanks, Chandan ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFFTP and Windows Firewall
I'm having an issue using cfftp to download large files ( 50MB) in CF8, with the latest hotfix applied. Basically the download almost completes (all but the final bytes of the file are there) and then the thread just hangs: java.lang.Object.wait(Object.java:???)[Native Method] - waiting on 0x3de71c (a [I) java.lang.Object.wait(Object.java:485) org.apache.commons.net.telnet.TelnetInputStream.read(TelnetInputStream.java:339) org.apache.commons.net.telnet.TelnetInputStream.read(TelnetInputStream.java:466) Eventually the cfftp timeout passes and an error is thrown. I have tried active and passive modes. If I disable Windows Firewall on the CF server, the transfer completes every time. So something must be going on there. Does anyone know what rules I would have to add to Windows Firewall to get CFFTP to reliably work with the firewall enabled? I have tried adding jrun.exe, java.exe. Port 21 is open, but I know that FTP uses more than that for transfers. TIA ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
onError() Mystery Errors
I am using onError() in Application.cfc to catch application errors and send me an email with a dump of the arguments.exception variable. I have been getting a number of emails from this where the rootcause.message and rootcause.details are blank, there is no meaningful error diagnostic information in the exception structure. For these errors the rootcause.type is always java.lang.IllegalStateException. The email also includes the URL and the form and URL variables that were passed in. If I try to reproduce this request it doesn't throw an error; it seems to be some kind of intermittent issue. This is on a site that is currently getting about 100,000 page requests a day and I have recieved probably 100 of these mystery errors today. Any ideas about what this java.lang.IllegalStateException usually indicates? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Writing Files without CFFILE
Hey all, I have a CF script that is used to generate about 14,000 static HTML files from dynamic content (don't ask). I am looping over a query using cfsavecontent to save the HTML code for each page and then writing to a file with CFFILE. As this process runs, I sit here and watch the CF process gobble up RAM. When it hits about page 12,000 my RAM is completely spent and the server crashes (hangs). So. I'm thinking CFFILE simply isn't the right tool for this job. Does anyone out there have a suggestion for an alternate way of writing the files. I'm thinking maybe using the underlying Java in CFMX or something. Thanks in advance people. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Writing Files without CFFILE
On Mar 9, 2004, at 11:50 AM, Adam Reynolds wrote: Your issue is the number of chunks you are trying to do it in. Try doing it in 2 parts. I thought about doing that, but it seems inherently non-scalable. Like, if I break it into two parts, what happens when the database returns 24,000 records instead of 14,000. I know I could do it in 5,000 record chunks I guess, but I thought there might be something obvious that was more elegant. cffile is probably ok but your cfsavecontent may be what is causing you issues as it may not be clearing down the content. You are still creating 14000 pages inside memory space even though you are not displaying them. Have you considered that cfsavecontent may not be the right thing here? That's a good thought. I guess I could try passing the whole HTML string directly into cffile in the output attribute, but that's gonna be hard to read. Is there a way to clear the variable after each iteration of the loop that would release the RAM? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Writing Files without CFFILE
On Mar 9, 2004, at 12:26 PM, Craig Dudley wrote:
Are you using the same variable name for the cfsavecontent?
Yes. On each iteration the savecontent overwrites the previous content
var.
That being said, I believe I solved the problem. I should have
mentioned I wasn't calling CFFILE directly in the loop, rather I had a
method in a CFC called writeStaticFile that accepted two params -
fileID and content. Once I pulled this logic out of the CFC and
directly into the code all is well. I can run the whole batch without
any perceptible increase in RAM usage.
Now, why passing it into the CFC would... is question for another day.
Here's the method, if anyone cares to comment.
cffunction name=writeStaticPage access=public returntype=boolean
output=false
cfargument name=content required=yes type=string/
cfargument name=fileName required=yes type=string/
cffile action=""
file=#expandpath('../static/'arguments.fileName)#
nameconflict=overwrite addnewline=no charset=utf-8
output=#arguments.content#/
cfreturn true/
/cffunction
-Original Message-----
From: Sean Daniels [mailto:[EMAIL PROTECTED]
Sent: 09 March 2004 17:18
To: CF-Talk
Subject: Re: Writing Files without CFFILE
On Mar 9, 2004, at 11:50 AM, Adam Reynolds wrote:
Your issue is the number of chunks you are trying to do it in.
Try
doing it
in 2 parts.
I thought about doing that, but it seems inherently
non-scalable. Like,
if I break it into two parts, what happens when the database
returns
24,000 records instead of 14,000. I know I could do it in 5,000
record
chunks I guess, but I thought there might be something obvious
that was
more elegant.
cffile is probably ok but your cfsavecontent may be what is
causing
you
issues as it may not be clearing down the content. You are
still
creating
14000 pages inside memory space even though you are not
displaying
them.
Have you considered that cfsavecontent may not be the right
thing
here?
That's a good thought. I guess I could try passing the whole
HTML
string directly into cffile in the output attribute, but that's
gonna
be hard to read. Is there a way to clear the variable after
each
iteration of the loop that would release the RAM?
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Writing Files without CFFILE
On Mar 9, 2004, at 12:38 PM, Craig Dudley wrote: I can only assume you were getting 14000 instances of the cfc object, not sure why. You could try creating one instance and storing it in say, the Application scope, and use that, might help. But since it's working now anyway, might be a waste of time. I definitely was only instantiating the object once, prior to the looping. I was calling the method however, using this syntax: cfset obj.writeStaticFile(param1,param2)/ Not sure if that would be the problem. I a testing right now using: cfset temp = obj.writeStaticFile(param1,param2)/ And that seems to be gobbling as much RAM as before. In any event, as you said, it's working great when I bypass the CFC so no sense beating it to death. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with charset (I think)
I have a system built where a client can upload his product database in CSV format from Excel to update his MySQL database. Unfortunately, some of the columns in the source spreadsheet have text copied in from M$ Word or some other processor and frequently contains characters that are misinterpreted somewhere along the line (before being inserted into the database). These characters are frequently curly quotes, hyphens, etc in the original document and end up being these bizarre looking glyphs when I dump the cffile read. This same problem has plagued me in the past with clients pasting from Word directly into my CMS as well. There must be a way to clean up all this stuff or translate it into usable characters? I have ben researching this problem on the list and web and it seems like the character set might be the culprit, but I have yet to find a solution that works. Has anyone out there dealt with this problem? I am using MX 6.1 default install, so CF's character set as far as I can tell is UTF-8. Thanks in advance. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help with charset (I think)
On Jan 22, 2004, at 8:16 AM, Massimo Foti wrote: You may try the following: http://www.cflib.org/udf.cfm?ID=319 http://www.cflib.org/udf.cfm?ID=725 Thanks Massimo. I actually have a UDF I have written that does pretty much the same thing. In fact, it is a copyof Demoronize with some extra characters added. I was sort of hoping someone could point me to a solution that actually takes care of the issue without having to do some elaborate replace() on a bunch of predefined characters. Inevitably, some new one sneaks in. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Random Could not connect to JRun Server error
On Jan 22, 2004, at 10:04 AM, Darron J. Schall wrote: Just to follow-up on this issue: We've believe we've narrowed down our instability problems to using the following custom tag: cfx_PaymentNet http://www.circa3k.com/CustomTag.cfm?ID=43 This tag is old (3-4 years?), and never caused issues with CF5, or CFMX.. but it doesn't seem to play nice CFMX 6.1. As soon as a job runs that calls the tag a decent amount of times (it needs to be called once per order), the Could not connect error appears up usually 3-4 days after the last time the server was rebooted. Then, once the error occurs, CF doesn't want to stop as a service, so we reboot the box, and the cycle continues. Does anyone know of an updated version? I couldn't find anything on the VeriSign site. I recently switched from using the cfx_PaymentNet tag to using the java custom tag cfx_payflowpro. I downloaded right from Verisign, and it seems to work great with CFMX 6.1. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: problem with file uploads on a MAC
On Monday, October 20, 2003, at 11:23AM, Michael Hodgdon wrote: I was hoping I could get some help on the list. Sort of at a loss for this one. I am aware there are know issues with the MAC and IE doing for uploads. I have two upload boxes on a page. The first is required and the second is optional. If a user selects both upload options, my code runs through fine. However, because of the temp file issue with MACS, if the user does not select a file for the second option, code errors out because it tries an upload. Has anybody had this issue before? Do you know a way around it? I always do this for each file being uploaded: cfset uploadFailed = false/ cftry cffile... cfcatch cfset uploadFailed = true/ /cfcatch /cftry Basically, instead of erroring out it will set an uploadFailed boolean, which I then can use to programmatically deal with scenarios. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Session Variable Size
Does anyone know how to figure out how much RAM a given memory variable takes? I am trying to figure out how much RAM will be used by session variables, if I am storing some rather large query result sets in session scope. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Add C++ CFX in 6.1
Just did an install of 6.1. I am trying to add a CFX tag in admin and getting this response: You must configure your application server to enable native CFX support. For instructions, see Configuring ColdFusion MX in the Installing and Using ColdFusion MX book for your application server. I can't find out anything about this in the Livedocs I've looked at. Any clues? This is a Standard Edition - standalone server (IIS) on Windows 2000. ~| 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: PDF Question
On Tuesday, August 5, 2003, at 03:43 PM, Mark Stewart wrote: If there is another product other than ActivePDF, I would be open to that. Thanks in advance for any help. I've got no experience with ActivePDF but I would highly recommend checking out Big FaceLess Report Generator: http://big.faceless.org/products/report/examples.jsp The documentation is fantastic. In an afternoon you can be doing dynamic PDF generation with only your imagination as the limit. ~| 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
Clean Install of 6.1 Problem
Trying to install on a clean, fresh install Win2K Server system (with SP4 and a bunch of other security patches), using the downloaded installer. The product seems to install fine, but every single page request, including those to the config wizard and CFAdmin result in a pop up alert on the server: jrun.exe - Unable to Locate DLL The dynamic link library MSVCP60.DLL could not be found in the specified path (continues with a bunch of path information) The only potential odd thing about this installation is I installed MDAC 2.8 just prior. I know this just came out yesterday. Any thoughts? ~| 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: CFMX 6.1 upgrade - 'smooth as butter'
On Tuesday, August 5, 2003, at 11:59 PM, Stacy Young wrote: Hah, weird. I hit that exact same snag. All good now. I have the same problem. Is it safe to assume the built in wrap() function behaves the same as the UDF from CFLib? Stace -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 10:12 PM To: CF-Talk Subject: Re: CFMX 6.1 upgrade - 'smooth as butter' I did an install on a server using an old MX app, it had an error blow up on the very first page. As it turned out this was from the early days and I had included the strlib from cflib.org and wrap() is now a built in function of CFML (this is documented), so it was no surprise. I commented out the function and everything worked great! Excellent job for the team! So then I uninstalled, removed all references to cfmx from the server and am going to give the jrun/cfmx combo a shot :) Wish me luck! - Calvin - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 9:31 PM Subject: CFMX 6.1 upgrade - 'smooth as butter' Nice. That is the expected behavior! :) m, butter. WIN2K -- IIS -- SQL Server Smooth upgrade. Nice speed gain! Thanks MM Dave ~| 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
FACS Cache Database
Anyone out there worked with FACS or the Cache database it is built on? In particular, wondering if MX can connect via ODBC or some other drivers. ~| 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
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 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: Struct Sort
On Wednesday, January 29, 2003, at 03:13 PM, Brad Roberts wrote: I've got a structure that holds several questions: temp = structNew(); temp.A = a quesiton; temp.B = another question; temp.C = yet another question; ... and so on I'm outputing the questions like so: cfloop collection=#temp# item=q #temp[q]#: input type=checkbox name=#q# value=1 /br / /cfloop For some reason, the questions won't stay in order on the production server. They do fine on my dev machine. I've tried structSort(), but can't get it to work... Any suggestions? cfset keyList = listsort(structkeyList(temp),text)/ cfloop list=#keyList# index=q #temp[q]#: input type=checkbox name=#q# value=1 /br / /cfloop I'm guessing you are running MX in production, but not in dev. The ordering of structs changed from 5.0 to MX. There seems to be no rhyme or reason to the output order in MX. Fun. ~| 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
QofQ Joins
Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. Thanks, - Sean ~~ Sean Daniels Director of Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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
Call to the regex ninja clan
Sending this on behalf of a colleague. I unfortunately do not belong to the regex ninja clan either. Begin forwarded message: I have some text being sent back from a flash rich text editor. It works great but flash autogenerates some nasty html that could potentially really screw things up... So.. here is the challenge, I need to remove all the following tags: font/font | p/p | textformat/textformat ..and they may have additional attributes. Thanks in advance any who can solve this brain tickler, Brian ~| 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.
Re: Strange Mac Browser Behaviour
On Tuesday, November 26, 2002, at 04:06 PM, Joshua Miller wrote: http://demo.digitalhealthdepartment.com/webadmin/The page in question Just try any user/pass - it bombs no matter what - doesn't even act like it attempts to find the page. Get rid of the enctype=multipart/form-data attribute of your form. That may solve your issue. There is a known Mac IE bug in handling form posts of that variety. ~| 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
TUCOWS / OpenSRS
If anyone out there has had success interfacing with the OpenSRS domain name reseller system, and has any tips or code samples they can provide, I would be much obliged. 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 Get the mailserver that powers this list at http://www.coolfusion.com
Server Scope / UDFs
Is there a way to force CFMX to load some vars into server scope when the service is started? Also, has anyone had any negative reaction to loading a CFC into server scope? I basically have a library of UDFs I want globally available that I thought I would throw into a CFC and load into server scope. This way the UDF's would be available to all code, including typically blackboxed code like other CFCs and Custom tags, etc. Lastly, if someone has figured out a way to load UDFs in such a way that they behave like native functions, I would love to hear about it. (ie, globally available on the MX box without having to scope them). I would prefer to do #formatphone()# rather than #server.udfs.formatphone()#. Thanks, Sean ~| 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
Re: Server Scope / UDFs
On Tuesday, November 19, 2002, at 11:51 AM, Raymond Camden wrote: No. Unless you have all your code under an Application.cfm that does it. FYI, 'events' like this has been on the enhancement list for sometime. :) Thanks for the responses Sean Ray. I hope the events thing happens someday. As easy as it would be to add cfif not isdefined(server.udfs) to every application.cfm on the server it would be far cooler to not have to. :) Well, it is not recommends for CF5 because you would need to lock every use of it. However in MX you wouldn't need to worry about it. Yeah, this is MX, so not as much of an issue. On Tuesday, November 19, 2002, at 01:58 PM, Sean A Corfield wrote: Note that you cannot output HTML from methods of CFCs that are stored in shared scopes (but, hey, you wouldn't be outputting HTML from CFCs anyway, would you?). Absolutely not! :) Nope, you need to scope them. Sure, you could create a 'local' alias via Application.cfm (cfset formatphone = server.udfs.formatphone/) but that won't be available inside custom tags for example. Right. I was more looking for a hack ala putting custom tags into the cf-root\wwwroot\WEB-INF\cftags directory so they be called like native tags. Oh well. Only a little additional typing. ~| 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.
Access Datasources Failing on MX Re-install
So I did an uninstall of CFMX on my dev box - removing everything I could think of; directories, mappings, registry keys of previous versions, etc. After performing what I thought would be a clean install, I found when adding back my Access data sources, which were functioning fine before the uninstall, that somehow CF already knew the path to each datasource, but worse, all of them fail to verify with the following message: Connection verification failed for data source: (dsn name) []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. These are standard Access dbs with no extra security on them. Anyone seen this before? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: Access Datasources Failing on MX Re-install: SOLVED
On Thursday, October 10, 2002, at 07:46 PM, Tilbrook, Peter wrote: Using ODBC Data Sources in ColdFusion MX ColdFusion MX uses JDBC, not ODBC. Want to use your ODBC data sources with CFMX? You can. Here's what you need to do: Thanks for the suggestion, although I did try that as well and those failed too. Anyway, I did find a solution. I re-installed the latest MDAC (2.7), rebooted and everything worked again. Go figure. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
Payflow in MX?
Since our upgrade to MX, the CFX_Cybercash tag has been flaky at best so we're making the move away from Cybercash to Payflow. Can anyone out there confirm for me that the CFX_PaymentNet tag functions correctly in MX? I believe Verisign offers an XML gateway too, but I really want the minimum amount of coding to get the migration done. Heh, who doesn't? Thanks, - Sean ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: Non-Windows CFMX interfacing emulated MS-Access db. was: SOT How to set up win XP network to be recognized by OS X
On Thursday, October 3, 2002, at 07:17 AM, Dick Applebaum wrote: It is possible to interface ColdFusion MX (CFMX) running on OS X 10.2.1 (Jaguar) to a MS-Access database running under VirtualPC emulated WinXP on the same machine. Dick, thanks for posting this update. Someday when I have some free time I'm definitely going to play with this. All of your work on behalf of the Mac CF developers out there are greatly appreciated! Running MX developer on my G4 tower rocks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
Re: SOT How to set up win XP network to be recognized by OS X
On Tuesday, October 1, 2002, at 08:32 AM, Dick Applebaum wrote: The first step to do this is to get the Host Mac and winXP machines thinking they are on the same network I was trying to do this with winNT under Jaguar. Dick, Can you ping the XP VM from the Mac Network Utility? What happens when you Apple-K and put smb://[xp-ipaddress]? ANything? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: SOT How to set up win XP network to be recognized by OS X
On Tuesday, October 1, 2002, at 04:09 PM, Dick Applebaum wrote: I would like to get it working on Jaguar, but I can revert to 10.1 on one of my machines, if needed. I would guess it's not a Jaguar issue. My situation is a bit different - both my Mac and VM are in a private network and use a router as the internet gateway - so I don't have ISP issues. Each machine and VM has a static IP in the 192.168.0. range. Could you take the Mac offline and try that? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
Re: SOT How to set up win NT network to be recognized by OS X
On Thursday, September 26, 2002, at 09:38 PM, Dick Applebaum wrote: The tcip is installed. I get an error on startup saying that a service wasn't started -- event shows the adapter that uses TCP/IP didn't have a valid device -- I guess I have some digging to do -- Thanks to you and Sean, I am at least digging in the right sandbox(es). Dick, Not sure what version of VPC you are running. I am running 5.0.4. You need to make sure the WinNT Virtual machine Settings (Select your VM in the VM List and then press Apple-T) has networking enabled, and I believe you will need to be using the Virtual Switch option. This gives the virtual machine a unique IP address as opposed to sharing your Mac IP. Then you should be able to reboot the NT VM, do the ipconfig thing and get the valid IP address. Again, I can't replicate your exact situation, so I'm mainly hypothesizing. I hope your running a beefier TiBook than the one I have! __ 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 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: Cfx_linkAPI
On Friday, September 27, 2002, at 04:03 PM, Eric Hoffman wrote: Just inherited a project with this, and of course, the other developers had, ummm, zero documentation. We have not used before...and cannot find on DevEx. Can someone point me to where I can get info on this bad boy? I have the PDF documentation, let me know if you'd like me to email it to you off list. I've used it in a few projects and it's not too tricky, but the PDF is pretty weak. __ 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: SOT How to set up win NT network to be recognized by OS X
On Thursday, September 26, 2002, at 04:02 PM, Dick Applebaum wrote: This is SOT, but it is related to CF. I want to be able to manipulate MS-Access databases from CFMX (Linux) running on Mac OS X. I have been told that the way to do this is run MS-Access on a win box on a LAN, and then have my CFMX programs read the MS-Access db over the network -- OpenLink says they have a connector that can potentially be used to interface CFMX and MS-Access over a LAN. OK, Mac OS X Jaguar has built-in capability to connect to win networks, so that part should be easy. (AFAIK, Jaguar includes the popular networking protocols including, NFS, SMB, and whatever the acronyms are) I don't know where to begin on the winNT side -- How do I define a network so that I can recognize it from a Mac OS X box? Anybody got any ideas or can point me to a reference? Dick, If the WinNT box and your Mac are in the same subnet, you should be able to simply go to the directory on the Windows machine you want to share, right click, choose sharing, and create a share name for that directory. Then, from the OS X Finder hit apple-K and put smb://192.168.0.1 (or whatever the IP of the Windows machine is), hit OK, authenticate using a valid user account with access to the share on the Windows box, and bingo, you should see a select box of shares available on the PC. Select the one you just created and it should mount in the finder. Just make sure when you set up the share on the PC you allow access with the account you're going to authenticate with from the Mac. By the way, I do this daily with a Windows 2000 box, but have never done it with Windows NT and Jag. I would recommend Win2K if possible though. __ 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: Multiple Sites in IIS
On Wednesday, September 25, 2002, at 03:14 PM, Shahzad.Butt wrote: Does anyone has faced the problem of having multiple websites in IIS (using CFMX). Whats happening with us is that Page is not being refreshed neither is it looking for new files if we add new file in website. Pls reply with any issues or problems using multiple sites. See this knowledgebase article for info on configuring CFMX on Multi-homed IIS machines: http://www.macromedia.com/v1/Handlers/index.cfm?ID=23390Method=Full __ 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
Cybercash on CFMX
Anyone out there run into problems using the cfx_cybercash tag on CFMX? I am able to use the tag to run charges just fine - however, when I try to run a refund the query output from the tag contains one record with all empty strings. Help? __ 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: SOT Dynamic DNS
On Tuesday, September 24, 2002, at 05:50 PM, Dick Applebaum wrote: Anyone had any experiences with this, good or bad? Dick, I tried DynDNS a long time ago and found the service to not be really reliable. Their name servers went down a lot. That may have changed. Instead I use No-IP (no-ip.com) and their service has been rock solid plus they offer a ton of additional features. You can select a subdomain of one of their many domains, or you can park a domain with them as well; I believe it's $14.95 per year. One of the things I like most about them is the wildcard feature that allows you to have *.yourdomain.com point to the dynamic address. So you can set up multiple name based virtual web servers on a single box with a single, dynamic IP address! It rocks. site1.yourdomain.com site2.yourdomain.com site3.yourdomain.com site4.yourdomain.com They have a beta client for OS X which I haven't tried yet (it's on my list), but the Windows client works like a champ. HTH __ 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 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
Multiple Apps on localhost:8500
I've always developed code by editing files directly on my development server and using the development server to test before deployment. I'm going to begin editing and testing code locally using the built in web server in MX, so that the development machine can become more of a staging machine, but I wonder how you all handle the fact that the standalone server can only host one app at a time? I often switch between projects throughout the day and it seems like moving files in and out of the wwwroot folder depending on what project I'm working on is a kludgey solution. How do you all overcome this situation? I would like to avoid using sub-directories because of absolute paths and such. Thanks. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Auto Submit Select Boxes
On Friday, September 20, 2002, at 08:25 AM, Rick Faircloth wrote: What's the piece of code that makes a Select box submit on selection without using a button? select name=name onChange=submit() __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: export list of datasources
On Friday, September 20, 2002, at 12:42 PM, Fitch, Tyler wrote: I'm running Enterprise edition, and in MX I find 'Archives and Deployments' under the server settings options of the cf administrator. I think it should be there for Pro if you're using that. I see it on a CFMX for J2EE install as well. No dice. I suppose it's just an Enterprise thing. That makes sense. __ 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 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: Installed CFMX - all cfm templates return http 500 error
On Thursday, September 19, 2002, at 11:00 AM, Dave Wilson wrote: Does this mean that CFMX Pro doesnt support multiple virtual sites on the server? I've checked the MIME mapping and it is present in the other virtual sites. I have read in a few places that in order to support multi-homed servers (virtual sites), you must manually edit the CFusionMX\runtime\servers\default\SERVER-INF\jrun.xml file. Find: attribute name=cacheRealPathtrue/attribute Change to: attribute name=cacheRealPathfalse/attribute __ 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: export list of datasources
On Thursday, September 19, 2002, at 06:56 PM, Fitch, Tyler wrote: If you're using CF5+ - make an archive from the cfadmin - it'll grab all your datasources and cfx tags etc... I've been looking for this functionality in MX; how exactly to you do this? __ 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
CFMX Structure Sorting
OK, so I've read the livedocs explaining the changes to the way structures behave in MX, but I'm not finding it to be the case... here's what the docs say: ColdFusion MX returns struct keys in the order that you create them. ColdFusion 5 returns struct keys in alphabetical order. If you need sorted struct values or keys, use the StructSort() and StructKeySort() functions. I have the following code to create a structure for navigation: cfscript opts = structnew(); opts[0]=structnew(); opts[0][fa]=foo; opts[0][lab]=Option A; opts[0][dsc]=My Description.; opts[1]=structnew(); opts[1][fa]=foo; opts[1][lab]=Editor; opts[1][dsc]=Add, edit, and delete.; opts[2]=structnew(); opts[2][fa]=enewsmailings.main; opts[2][lab]=Creator; opts[2][dsc]=Tools for creating things.; /cfscript __ 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 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: CFMX Structure Sorting
On Wednesday, September 18, 2002, at 03:31 PM, Sean Daniels wrote: OK, so I've read the livedocs explaining the changes to the way structures behave in MX, but I'm not finding it to be the case... here's what the docs say: ColdFusion MX returns struct keys in the order that you create them. ColdFusion5 returns struct keys in alphabetical order. If you need sorted struct values or keys, use the StructSort() and StructKeySort() functions. I have the following code to create a structure for navigation: cfscript opts = structnew(); opts[0]=structnew(); opts[0][fa]=foo; opts[0][lab]=Option A; opts[0][dsc]=My Description.; opts[1]=structnew(); opts[1][fa]=foo; opts[1][lab]=Editor; opts[1][dsc]=Add, edit, and delete.; opts[2]=structnew(); opts[2][fa]=enewsmailings.main; opts[2][lab]=Creator; opts[2][dsc]=Tools for creating things.; /cfscript The list hacked my message apart. Here's the rest: When I loop over this top level struct, I would expect my results to come out the order they were created, but instead they are seemingly sorted alphabetically by the dsc key: cfloop collection=#opts# item=ii b#opts[ii]['lab']#/b/abr /#opts[ii]['dsc']#br /br / /cfloop __ 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: CFMX Structure Sorting
On Wednesday, September 18, 2002, at 05:18 PM, Raymond Camden wrote: If you look at the values for lab, you will see opts[0][lab] = Option A: opts[1][lab] = Editor opts[2][lab] = Creator You looped over Opts, so it returns 0,1,2, which would be Option A,Editor,Creator which probably made you think it was going text/desc. However, you were looping over OPTs, where the keys are 0,1, and 2. Well my last post got truncated as well. What you didn't see was the result was not what you (and I expected). The outcome was actually: Editor Add, edit, and delete. Option A My Description. Creator Tools for creating things. ANy thoughts? I would like to force the output in order of creation, or worse case in order by the top level key (which is the same obviously). I also tried this StructKeySort() function the livedocs reference and no such function seems to exist. Is this a typo in the livedocs? __ 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 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: Maintain Database Connection
On Tuesday, September 17, 2002, at 12:07 PM, Greg Luce wrote: Can someone clear this up for me. I maintain a site on a shared server and it uses access :-(. Seems every time I need to alter the mdb file it's locked on the server. I've asked the hosting company to uncheck Maintain Database Connection for the datasource and they came up with some BS answer that it keeps multiple connections being made. Isn't it just for efficiency so CF doesn't have to connect every time a call is made? Through the host's user interface you can restart the webserver, but not CF. I've tried putting up a bogus page with an invalid SQL query. Isn't that supposed to release it? That used to work, I believe prior to CF 5. For CF 5 servers I use the following: cfset rc=cfusion_disable_dbconnections(yourdsn,1) and then re-enable with: cfset rc=cfusion_disable_dbconnections(yourdsn,0) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: MP3 Jukebox Ideas?
On Tuesday, September 17, 2002, at 04:11 PM, Greg Luce wrote: Anyone have any experience building/using an MP3 database? I thought I'd ask before wasting too much time on it. I have 23,000 songs I'm putting in a db. Right now I have a Web-based CF app to search the collection, and I'd like to be able to build playlists from it. Eventually I'd like to build a stand-alone app using VB.net once I get it all sorted out. Here's the DB schema I have right now: You might find Ben Forta's latest book of interest. The first case study is a flash/CFMX based MP3 jukebox. I'm pretty sure it's open source too...? http://www.forta.com/books/0321125150 __ 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
JRunScripts Virtual Directory
What is the purpose of the JRunScripts virtual directory? Do I really need to create it for every site I add in IIS? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMX Upgrade
I am trying to upgrade my CF 5 box to CFMX. I got most of the way through the installation and had to bail to free up some disk space on my system partition. Now having done so, I rerun the CFMX installer and no longer have the option of upgrading CF 5 - I can only install in stand alone mode. Any suggestions? I don't want stand alone mode obviously. __ 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: CFMX Upgrade
On Monday, September 9, 2002, at 12:05 PM, Stacy Young wrote: Are you using IIS? You can always run it in standalone then run the IIS connector utility afterwards. (or for apache for that matter) Yeah, I could do that but I want the upgrade so I don't have to reconfigure all my datasources, and myriad of other settings. Although at this point I probably could have done that faster. I hate it when that happens. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFMX Upgrade
On Monday, September 9, 2002, at 12:11 PM, Sean Daniels wrote: Yeah, I could do that but I want the upgrade so I don't have to reconfigure all my datasources, and myriad of other settings. Although at this point I probably could have done that faster. In case anyone else has this issue, I found a solution. There is a key in CF5 registry called CFMX_Upgraded. I deleted this key and got the option to upgrade again when I ran the installer. I also learned that I could have imported all the settings when installing in stand alone mode. Did not know that. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMX - Slow, why?
I have just finished upgrading my dev box to CFMX. After going through a number of issues (search engine friendly URLs, problems with the installer), I finally have working sites again - but the debug execution times are simply unacceptable. I have 20 apps on this box where every page execution was routinely 50 - 500 ms under 4.5 and 5.0. Under MX, just about every page takes upwards of 2,000 - 20,000(!) ms. I should note this is only the first load of a given page - subsequent loads are normal. Is there some really obvious thing I'm overlooking? Has anyone else had this experience? This is a Win2K box with 256MB RAM and a 650mhz processor. Again, under CF 5.0 everything ran like clockwork. And, does anyone know of a program to allow CFMX licenses to be downgraded to CF 5.0? I need UDF and such, but this MX stuff is turning out to be a headache, especially this first time page loads deal. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFMX - Slow, why?
On Monday, September 9, 2002, at 04:58 PM, Phoeun Pha wrote: Big deal. I can't tell the difference between 1 MS and 10,000 MS. The delay is there in the beginning because the code has to be compiled first. It's a annoying :) I'm sorry, but the difference between the page instantly coming up (500ms) and waiting for 10 - 20 SECONDS for a page to come up is absolutely *HUGE*. I certainly notice, and believe me, my clients will too. Even if it is just the first page load, inevitably, my client will be the one to get that first load one of these days. And I'll get a phone call. __ 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: Connecting CF5 to MS SQL
DATASOURCE TYPE = ODBC DRIVER TYPE = Microsoft SQL Server Driver DATASOURCE NAME = mydatabase DESCRIPTION = SERVER = First, you'll need to put the server IP address or server name in the SERVER = value. Also, make sure you specify the username/password for access to the database. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ 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
PayFlow
I've seen reference to a CFX_PFPRO tag but can't find out how to go about getting it? Is it something you buy from Verisign when you sign up for Payflow? Thanks, - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Linkpoint API
On 5/6/02 2:23 PM Joseph DeVore wrote: They would be using the CFX tag. I've used it for three different clients at this point. The way they have the CF tag set up isn't exactly the way I would do it, but it works fine and service wise I've not had any issues. Seems pretty fast to authorize as well. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ 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
Browser Detection
What are people doing for browser detection these days? I am using a custom tag called browsercheck which is pretty old and I'm just curious if people have a slicker way. I have checked out the browser detection UDFs at cfdev but they don't do everything I'm looking for. I'm mainly looking to determine if the browser is reasonably CSS compliant. I'm thinking about writing a UDF isCss() that would return true for IE 4 and up and Netscape 6 and up and false for others (well, I would be more inclusive than that but you get the idea). Just don't want to reinvent the wheel if someone already has something to that effect. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ 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: OT: SQL function i know it exists
On 3/21/02 11:55 AM Tyler Clendenin wrote: say i have a table of users. and i want to select their gender, but the gender is stored as numbers 1 and 2 but i want to output them as M or F SELECT FunctionIDontKnow(Gender, 1, 'M', 2, 'F') AS GenderAbbr FROM Users In SQL 7 at least: SELECT genderabbr = case when (gender = 1) then 'M' else 'F' end From users - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFSCRIPT Preservesinglequotes()
I have written a seemingly simple UDF for cleaning up data before an insert
or update statement (it trims the string, inserts null when necessary, wraps
string in single quotes if it's a char field):
cfscript
function checknull(ii,isint) {
if (isint) {
return iif(len(trim(ii)),de(trim(ii)),de(null)); }
else {
return
iif(len(trim(ii)),de(chr(39)trim(ii)chr(39)),de(null)); }
}
/cfscript
Basically, my insert statement looks like:
Insert into tablename (intfield,charfield)
Values (#checknull(intfield,1)#,#checknull(charfield,0)#)
It works great except for when the charfield contains apostrophes. It
escapes them all and the result is that twice as many apostrophes get
inserted. I know that somewhere in here I should probably be using
preservesinglequotes() but everywhere I attempt to use it in the UDF I get a
JIT compilation error. I also get a JIT if I put the preservesinglequotes
function in the calling template
[preservesinglequotes(checknull(charfield,0))]
Any suggestions? Please? Unfortunately I used this function all through an
app before finding the bug, so I would be psyched to make repairs to the
function itself not all the code that uses it.
- Sean
~~
Sean Daniels
Director, Engineering
Marketplace Technologies, Inc
(T): 207.363.7374
(C): 207.332.6340
(F): 240.269.6319
~~
http://www.dealforce.com
http://www.mergernetwork.com
__
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: GoldMine
On 12/29/01 4:30 PM Mark A. Kruger - CFG wrote: yes it's possible. You can use DBase drivers (not good) or you can upgra de goldmine to SQL and do it that way. If you can figure out Goldmines rath er difficult Primary key schema you can make it happen. There are a lot of folks doing it with various 3rd party aps and you can find ideas on how t o proceed on the goldmine forums. Beautiful, that's what I wanted to hear. Thanks. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
GoldMine
Anyone out there have any experience using CF to interact with a GoldMine database? I am wondering if it's possible. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Frame within a frame error
On Wednesday, November 14, 2001, at 07:49 PM, Clark, Aimee wrote: Hello. I'm new to this listserv, but I have a problem in which I hope someone can help me with. I have a frame page that I have created in which the top part of the page contains an alphabet link so that when you click on the individual letters it takes you down below to the list of names to the letter that you click on. The problem is that at the top there is a drop down box in which you can choose to sort the list by last name, or first name, etc. When I choose to sort differently the page opens at the top but within the same frame page that was orginally there. Hence I have a frame within a frame thing going on. Anyone ever seen that or know how to fix it? I sounds like the drop down box is a form field that uses some javascript or something to auto submit. Whatever the case, check that the target attribute of the form is pointing to the correct frame name. ~~ 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: Masked Query Strings in URL [Solution]
On 11/9/01 3:05 AM Michiel Boland wrote: What OS version is he using? There are definite problems if you try this on WINNT SP6 without the appropriate hotfix. He's using Win2k SP2. However, I found that he's also applied a new tool M$ has out for IIS called URLScan. It's default configuration denies these fusebox style requests. It's pretty easy (one switch in the .ini file) to switch the filter off that prevents this, the trick is convincing this guy that it's going to be OK. FYI, the filter that denies these requests is AllowDotsInPath=0. - Sean ~~ 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
Nested Loops (query)
OK, I feel like I've done this before, but maybe not. Can anyone explain to me how to do this and get my desired result. cfloop query=querya cfloop query=queryb #querya.val#: #queryb.val# /cfloop /cfloop What I want is, if querya had 2 rows and queryb had 3 rows, to get 6 rows of output like this: querya.row1: queryb.row1 querya.row1: queryb.row2 querya.row1: queryb.row3 querya.row2: queryb.row1 querya.row2: queryb.row2 querya.row2: queryb.row3 Instead I get: querya.row1: queryb.row1 querya.row1: queryb.row2 querya.row1: queryb.row3 querya.row1: queryb.row1 querya.row1: queryb.row2 querya.row1: queryb.row3 Thanks in advance. - Sean ~~ 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: Message Board
On 8/29/01 12:12 PM John Paitel wrote: Anyone know of a good, open source message board written in CF? I've found a few packages, but they are all encoded. I'd rather find an open source one that I can implement and also learn from. I recently downloaded Simple Message Board (www.simplemessageboard.com) and it's really really nice. I've tinkered around in the code too and it's very cleanly written so it would be good to learn from. - Sean ~~ 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: structure in request scope
On 5/10/01 1:59 AM Mark Ireland wrote: Could someone tell me how to load a structure into the request scope in the application.cfm once only when a user first visits a page. That is, check that the structure is there and dont rerun the query code if it is unless a change has been made to the database. It sounds like you want to put the structure into a persistent scope, which request is not. Use the application scope instead if it is global to all users. If not, client or session scope. cfif isdefined(application.strFoo) cflock type=exclusive scope=application name=strLock cfset application.strFoo = structnew() !--- etc --- /cflock /cfif - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and custom style sheets
On 5/10/01 1:27 PM Scott Weikert wrote: LINK REL=StyleSheet TYPE=text/css HREF=style.cfm I've had some hassles trying to link the page like this... it doesn't seem to properly execute the CF code within. Anyone out there tried to do this same thing, and succeeded? Input would be most welcome. Two suggestions: 1. Make a new style sheet for each option, and use: cfoutput LINK REL=Style Sheet TYPE=text/css HREF=#attributes.stylesheet#.cfm /cfoutput Name you style sheets stylegreen.css, styleblue.css, etc. OR 2. Add a mapping in IIS if you can to have CF parse .css files. I've never done this, but conceivably it could work... If you have that much control of your environment. Obviously option two would be preferable so you don't have to maintain multiple style sheets. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: using WDDX for next 'n' style browsing
On 5/8/01 6:52 AM Kola Oyedeji wrote: I am passing a query object which consists of 1000 records in a hidden form field between pages as a WDDX packet, are there any reasons why this is a bad idea, such as limits to the amount of data which can be held in a form field or passed in a form? I did a similar thing but rather than pass the WDDX pack in a form field I wrote it to a local file using CFFILE. Each search (query) was givan a search_id that I used to name the local file. I pass the search_id in the hidden field, then on the next page I read it in, deserialized, and output. It was way faster than rerunning the query, and although caching the query would be faster, it was not possible because the query itself was generated dynamically (based on an advanced search form), so with many concurrent users it would have used up the max 100 cached queries on my server, which I wanted to reserve for other more consistent queries. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Re: GRRRR Claris Works 5.0 DB
On 5/8/01 9:47 AM Eric Dawson wrote: G Claris Works 5.0 DB I have a Claris Works 5DB, and need to convert to anything useful in the W2K/Office 2000 World. ideas? Does Claris have any kind of export? Like, preferably export comma delim values, then you can import into Access quite easily. That's just raw table data, of course. You won't get any interface elements that may have been developed in Claris. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to Force https vs http
On 5/3/01 9:56 AM Chris Montgomery wrote: Quick questionis it possible to have a URL redirect to a secure URL? For example, someone enters http://www.xxxblahxxx.com/secure/securepage.cfm instead of https://www.xxxblahxxx.com/secure/securepage.cfm. How do you force a redirect to the secure URL? Is that a server function, or can it be done programmatically? Programmatically, using IIS this should work: cfif cgi.https is off cflocation url=https://#cgi.server_name##cgi.path_info#; cfabort /cfif I don't know if the cgi.https variable is there for other servers, which is why I specified IIS. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ldb files w/a twist
On 5/3/01 12:53 PM Mark Smeets wrote: So, here is my question and basically it's a problem. Now when you open any Access file you get that little annoying ldb file with it, it closes no problem if you're working with Access directly however what if the Access file is on a server and you don't have access to it directly? What if I need to replace that database with a new one (and that stupid ldb file won't go away)? Any ideas would greatly help. I have the same situation, here's what I do. Put a file on the remote server called killdb.cfm the contents of which are: cfquery datasource=#yourdatasourcename# name=blah select * from any_table_that_does_not_exist /cfquery Run that script and of course you will get an error, but you also get rid of the DB connection, and the LDB file! - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sending mail with coldfusion
On 4/25/01 5:11 PM William J Wheatley wrote: has anyone come up with an alternative to sending mail then using CFMAIL? Because i swear even trying to send 1 CFMAIL to a hundred people does not cut it..its a major issue. Check out Howie's POST SE server with accompanying custom tag. It rocks. http://www.coolfusion.com - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 server not recognized by CF 4.5
On 4/23/01 1:52 PM David Baskin wrote: I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bank of America and e-stores and CFHTTP
On 4/19/01 12:42 PM Christopher Olive, CIO wrote: 3) they suggested that i have to be coming *from* a secure URL as well. i'm working on trying that possibility next. I would give that a shot. I've always had problems with form fields disappearing when posting to an HTTPS from an HTTP. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom Mail Header?
On 4/17/01 6:06 PM WebMaster wrote: Is there a way to add your own custom mail header with CFMail (like the "X-Mailer" line)? I've seen programs that let you do this and I think it would be very useful if I could tack a variable into the header of the message. For example: X-Variable: 3243423 cfmail to="#to#" from="#from#" subject="#subject#" cfmailparam name="X-Variable" value="3243423" Hello. /cfmail Note, the cfmailparam tag was introduced in version 4.5. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOLUTION: OT - Sniffing Email
On 4/12/01 10:43 AM Erika L Walker wrote: Brian, What is it that you can't seem to get? I haven't had the time yet to implement this solution since I've posted it (another priority project got in the way), so I haven't started testing it, but I may have some moments this morning to spend on it... I don't know if Brian is having the same problem I am having, but I get both versions of the email in a plain text only email. So I get: MIME-BOUNDARY Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit blah MIME-BOUNDARY Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit html body marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" bgcolor="white" blah /body /html I did notice in the headers of the email that the Content-type header appears twice. Look: Content-type: text/plain Date: Thu, 12 Apr 2001 11:20:13 -0400 From: "From" [EMAIL PROTECTED] Subject: This is my subject Content-type: multipart/alternative;boundary="MIME-BOUNDARY" X-Mailer: ContestClicker Mailer, MIME-Version: 1.0 To: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] Message-ID: DMZ6iyPoHZgzDgtZKpj1dd3@dmz6 X-OriginalArrivalTime: 12 Apr 2001 15:26:34.0687 (UTC) FILETIME=[F55A84F0:01C0C364] X-RCPT-TO: [EMAIL PROTECTED] X-UIDL: 2140 Status: U Is there something we need to do to rid oursleves of that first content type header? - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOLUTION: OT - Sniffing Email
On 4/12/01 9:53 AM Brian Peddle wrote: Im attempting to post this for the 4th time. I tried to apply the solution below and spent a couple hours on it but I can't seem to get it: Code I am using is below. It has been cut down a bit to make it straight forward. I can sent the code as an attachment if needed as it seems as though proper carriage returns count. Any help on this would be greatly appreciated Brian, I found that using the cfmailparam tag to push the extra headers (rather than appending them to the subject as was suggested) worked. Instead of: !--- Send the messages --- CFMAIL To="#emailaddr#" From='"#Form.FromAlias#" #form.from#' Server="206.57.37.74" Subject="#mySubject# Content-type: #contenttype# #myHeaders#"#myPlainMsgTop##myPlainText# #myHTMLMsgTop##myHTMLText# /cfmail I used: cfmail to="#emailaddr#" from="#Form.FromAlias#" #form.from#" subject="#subject#" cfmailparam name="Content-type" value="#contenttype#" #myPlainMsgTop##myPlainText# #myHTMLMsgTop##myHTMLText# /cfmail I believe that the cfmailparam tag isn't supported below CFAS 4.5 though. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Linkpoint Custom Tag
Anyone out there used Linkpoint and their $95 custom tag for processing CC transactions? I've only used Cybercash in the past, but am looking for alternatives. The client's existing merchant banker recommended LinkPoint for integration with CF sites. Thanks, - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disabling Save Username Password in IE 5
On 4/3/01 8:01 PM CF wrote: It's under Tools Internet Options Content AutoComplete You can do this on each workstation, or you can programmatically prevent autocomplete on any field with the attribute "autocomplete" and the value "off". For example: input type="password" name="pass" autocomplete="off" This way you can do it on a form by form basis in your code rather than going to each workstation. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio: Export RDS Settings?
Anyone know how to export RDS settings from one machine and import to another, both running Studio 4.5.2? I assumed this would be in the registry, but I can't find it. I have about 20 RDS and FTP servers mapped on my old machine I want to add to my new. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 2000 (enterprise manager)
On 3/16/01 11:03 AM Jay Patton wrote: I just upgraded to windows 2000 pro on my development machine, i was originally running win98 and had sql 7.0 Enterprise manager running on that. however after my upgrade to 2k i couldn't connect to my sql servers with that same software any longer. last night i downloaded the evaluation version of sql 2000 and with that i connected to the servers fine however now whenever i go to open the database folder to view my db the enterprise manager quits responding and i have to kill the program. has this happened to anyone else? or does anyone have any ideas why this might be happening? I haven't tried the SQL 2000 enterprise manager yet, but I use SQL 7 Enterprise Manager all the time on my Windows 2000 pro machine. You might just try reinstalling those. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Application.cfm, Session Management, and a lot less hair!
On 2/16/01 9:58 AM Ken McInnes wrote: Okay this problem has me completely baffled. We have an administration module for a client with a login page that sets some session permissions. Subsequent pages then look for the appropriate permission using CFApplication. Everything works fine on our end but when we implemented on the client site they cannot get into the administration module...very secure but useless! ;-) I have supplied the error they are getting and the CFApplication tag. The only way I have been able to replicate the error is by disabling the browser's ability to accept cookies on our internal network. This then causes Cold Fusion to throw the error. I have tried it on a number of different machines that we test on and the Cold Fusion application worked on all of them. However, when I try the application on some machines external to our network they almost always fail but some do allow access to the administrator module. They have been set to accept cookies so that doesn't seem to be the problem. Does this client have cookies disabled? If so, have them turn them on or start rewriting your code so that all links pass the #urltoken# variable. The session management in CF requires either cookies or the #urltoken#. Good luck. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cookie and tracking
Does anyone have suggestion on a method to drop a cookie on the
homepage of a site and then track that cookie to figure who is a
new user vs. returning user.
!-- home page code --
cfif isdefined("cookie.firstvisit")
!-- user has been here before --
cfelse
!-- user is visiting for the first time, or has cookies disabled --
cfcookie name="firstvisit" value="#now()#"
/cfif
- Sean
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Driving Me Nuts
Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly." Any ideas? This is driving me crazy. Running Access 2000. Install the latest MDAC on the remote server. I have gotten that error when I deploy an access 2000 db to a server that has CF 4.0 on it because the MDAC's are old and don't support Access 2000. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: RE: Allaire on a Mac?
Does someone still use Mac's? grin Would if I could. See http://www.apple.com/powerbook/ for a darn good reason. A fiercly powerful notebook, not to mention the widescreen display, less than 1 inch thick, pure titanium shell, and it looks really really cool? Not to mention $2500. Please macromedia/allaire, give me Mac Studio! (I know, I ain't holding my breath). - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT - Browsers version by percentage
Sorry for the real OT, but can somebody shed a light on this... the other day there was a thread talking about excluding some users that might have an old browser which might not support JavaScript and all that... I was wondering, by looking at your logs, can somebody tell the list what is the breakdown of users you have seem using different browsers versions... percentages will be fine... Here is a report from one of my sites. This is only for this month. * Visitors detected = 99.8% The numbers are based on the percentage of detectable visitors. 18 were not detectable due to automated robots, outdated browsers, or other visitor software limitations. Browser Breakdown Percent Total 0 1,268 2,536 Microsoft Internet Explorer 5.0 27% 2536 xx Microsoft Internet Explorer 5.5 22% 2040 x Microsoft Internet Explorer 5.0112% xx Microsoft Internet Explorer 5.0 (AOL) 11% 1092 x Microsoft Internet Explorer 4.01 6% 611 Netscape Navigator 4.7 4% 431 xx Netscape Navigator 4.73 1% 155 xx Netscape Navigator 4.75 1% 153 xx Microsoft Internet Explorer 4.01 (AOL) 1% 149 xx Netscape Navigator 4.5 1% 139 xx Netscape Navigator 4.72 1% 112 xx Netscape Navigator 4.08 1% 106 xx Netscape Navigator 4.61 1% 106 xx Netscape Navigator 4.74 1%66 x Netscape Navigator 4.51 1%63 x Netscape Navigator 61%56 x Netscape Navigator 4.04 1%43 x Netscape Navigator 4.06 1%34 x Netscape Navigator 4.05 1%22 x Netscape Navigator 4.6 1%22 x Microsoft Internet Explorer 4.0 1%16 x Microsoft Internet Explorer 4.5 (Macintosh) 1%15 x Netscape Navigator 4.07 1%12 x Microsoft Internet Explorer 3.0 1% 9 x Netscape Navigator 4.0 1% 9 x Netscape Navigator 3.01 1% 9 x Netscape Navigator 3.0 1% 7 x Netscape Navigator 4.71 1% 7 x Microsoft Internet Explorer 2.0 1% 6 x Microsoft Internet Explorer 3.0 (AOL) 1% 6 x Netscape Navigator 4.03 1% 5 x Internet Ninja 5.0 1% 5 x MSN Explorer1% 4 x Microsoft Internet Explorer 5.0 beta 1 1% 2 x Microsoft Internet Explorer 3.011% 2 x Netscape Navigator 4.02 1% 2 x Netscape Navigator 4.01 1% 2 x Netscape Navigator 3.04 1% 2 x Netscape Navigator Gold 3.011% 2 x Mozilla Seamonkey 1% 2 x Opera (unknown version) 1% 1 x Netscape Navigator Gold 3.041% 1 x Netscape Navigator Gold 3.0 1% 1 x Opera 3.62 1% 1 x Offline Explorer (unknown version) 1% 1 x - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Why doe my cfscript if statement fail?
if (Check_NT.RecordCount gt 0 is "TRUE") I don't know if this is the problem, but I would definitely not write that condition that way. I would use either: 1. if (check_NT.recordcount gt 0) or 2. if (check_NT.recordcount) Both will achieve the result I assume you are looking for. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Application.cfm Problem
Put your output in a different file in the same driectory as application.cfm and run that file. I may be wrong, but I don't think application.cfm can have any html output in it. Only cf code. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Invalid Token in IsDefined
You misspelled "elseif" on line 3. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFerror and its
The problem is that when a validation error occurs, the error page appears fine, but the CF inside the error template is not executed... it shown as if it was a regular html page with all the cf showing. can someone tell me why this is happening and how i can correct the problem?? It is not possible to get CF to parse CF code in the cferror page. As an alternative, I suggest looking into cftry, cfcatch. This is a much more sophisticated method of error-handling that does allow for CF processing to take place. Good luck. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What Does OT Stand For?
Off topic. Like this thread! :) - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access question
If a field in access has never had anything in it at all does it appear as NULL or as "". It appears as null. So would you check it with CFIF FieldName IS "" or would you use CFIF FieldName IS NULL Well, ColdFusion does not support the word "NULL", so you would use the cfif FieldName is "". Or, many people prefer: cfif not len(trim(fieldname)) The latter is boolean and therefore evaluates slightly faster. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: return every Friday for a year
Hope this is a quick and easy one... what would be the simplest way to
return the dates for every Friday in a given year? (or any other
particular
day of the week)
This probably ain't the most elegant or optimized approach, but it works :)
cfset startdate=now()
cfoutput
cfloop from="0" to="365" index="ii"
!--- dayofweek returns a number, 1=Sunday, 2=Monday, etc ---
cfif dayofweek(dateadd("d",ii,startdate)) is 6
#dateadd("d",ii,startdate)#br
/cfif
/cfloop
/cfoutput
- Sean
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTTPS setup
We do have other sites on the same IP, but none of them use SSL. That shouldn't matter, should it? The default site if you go in by IP is a different site, but that's only for port 80, so I guess its irrelevant. Is it possible for you to try making the SSL site the one with no host header requirement? If so, I would be interested to know if that solved it. I think that when you make the request https://www.whatever.com to your site, since the host header gets ignored for https, your server looks for the file on the default site. Follow? I'm kind of speculating here I guess... - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stripping CRs and LFs
What is the best way to strip CRs and LFs from a string? cfset crlf = chr(13)chr(10) cfset stripped = replacelist(myString,crlf,"") Should do the trick. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Contract
I haven't seen any sites like that, and there's probably good reason. A contract is a legal document, and laws vary per locality. Your best bet is to consult with a lawyer and have them to put together a "template" that you can use. cf_myopinion Contracts usefulness are limited. Breach of contract suits are often more expensive than what you would get if you win. Requiring a contract sets a tone of mistrust. Plus the legal fees of hiring someone to set up the template for you. I say this with some experience, although not in the CF consulting field. Before I was a CF guy, I was in a band with a major label recording contract. Guess what? Major label hoses band, label wants out, band wants $$ contractually obligated (no small amount) for breaking contract, label says "too bad suckers", band can't do anything because the cost of fighting big biz in court is greater than that to be gained. Oh well. We settle for about half. Anyway, lesson learned. I prefer to stay away from contracts. Thanks for letting me get that off of my chest. :) /cf_myopinion - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Contract
Yes .. and also, without that contract with the label, I'm pretty sure you wouldn't have gotten that 1/2 that you did. ;) Of course. I guess I should have qualified my opinion (and that's all it was of course) by stating that the size of the engagement obviously should come into play when deciding whether or not to have a document. I guess I prefer the small, friendly kind where a verbal agreement is enough. In the end, it's up to the consultant to determine their own comfort level working with or without the contract. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple Servers - Cluster Cats
Does anyone have any experience setting up Cluster Cats or any other solid backup/failover server system? ClusterCats is a software based web server load balancing service. It will do you absolutely no good if your DB server dumps it's motherboard again. For true fault tolerance you would need at least two web servers load balanced with ClusterCats (or any other software or hardware based load balancer) AND at least two DB servers running in a Active/Passive or Active/Active cluster configuration. The latter is very tricky and expensive to achieve, unfortunately. By the way, I have very little experience in actually doing this, only researching it for my own servers. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTTPS setup
The key's all set up properly, but it just finds nothing if you browse to it... we've set the SSL port to be 443 in IIS, so it should know it exists. We've also set the IP and headers with that port. We're definitely using the URL the key was registered for. Any ideas? You aren't sharing the IP address amongst sites are you? SSL doesn't support host headers, so each site needs it's own IP address. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Studio 4.52
OK, so I really want to update to 4.5.2, particularly for the "remembering that your in an RDS session". However, I have customized the crap out 4.5.1 and I am scared off by these mails that say the 4.5.2 installer kills your snippet and hotkey settings. Is there any way to back these up? Or have they fixed this prob in the newest installer? - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
