RE: upload destination
I'm pretty sure you can't use network pathing in cffile. Sure you can, as long as the ColdFusion Application service is running as a user with rights to access the network share you want to use it shouldn't be a problem. -Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to parse a text file...
I need to get rid of the column headers in the first line, and then get rid of any linefeeds after the last piece of data. This seemed fairly straightforward when I started... and it should still be fairly straightforward: cfset data = listRest(data, chr(10)) / cfset data = trim(data) / -Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion DSN Security
Bobby is right. The userid and password in the code will override the DSN. Just put in a dummy user name and password.in the DSN if you must have one. The DSN won't verify but so what? Without sandboxing, this can actually be worse than having the DSN available to anyone on the server (not saying this is true in all cases, but a possibility). Now not only can anyone else on the server still access your data, they would have access to your credentials. If the host hasn't enabled sandboxing, chances are anyone on the server can use CFDIRECTORY and CFFILE to just crawl through the server and make copies of everyone's code which would now include your database username and password, so the DSN security is really the least of your concerns in this situation. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trying to use cfexecute to run batch file...
However, I can't get any results except a timeout when I use
cfexecute to run the batch file.
cfexecute name=e:\adobe_site\getfiles.bat
timeout=60
Based on the file sized that you're likely dealing with, the timeout is too
low. I run my CDEXECUTE with a timeout of 10800 for IDX downloads...
cfsetting requesttimeout=10800 /
cfexecute name=#expandPath('.\FTPBatch.cmd')# timeout=10800 /
FTPBatch.cmd is in the same folder as the calling script and has all of the
commands needed to get to the proper folder and run the ftp command line:
@echo off
e:
cd \inetpub\wwwroot\mls\imports
ftp -n -s:..\FTPScript.txt
FTPScript.txt is also in the same folder as the calling script and has the
actual FTP commands to execute (connect, user, pass, get, etc.). In my case
the imports folder is directly below the folder where all the scripts and
such are located.
--
Justin Scott, http://www.tlson.com/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312118
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to access files on an ftp url that doesn't allow direct ftp access?
What I have to do is click on a link in my email, which takes to to an web page that uses an ftp url (ftp://datalink.interealty.com/) MLXchange certainly allow direct access to their FTP server. I wrote a routine that downloads IDX feeds daily and it's fully automated. I can't send you the full code (you know, the whole copyright and work for hire stuff) since it's owned by the client, but here are the pertinent parts (not optimized since this is just a small chunk of a vast empire of code; watch for line breaks)... cfscript // Set our variables. variables.ftp_server = datalink.interealty.com; variables.ftp_username = anonymous; variables.ftp_password = [EMAIL PROTECTED]; variables.ftp_folder = /DataLinkOutput/yourPathHere/; /cfscript !--- Get a file list from the server. --- cfftp action=open connection=datalink server=#variables.ftp_server# username=#variables.ftp_username# password=#variables.ftp_password# stoponerror=yes cfftp action=listdir connection=datalink name=remoteFiles directory=#variables.ftp_folder# stoponerror=yes cfftp action=close connection=datalink At this point you'll have a remoteFiles query which you can loop through to either download the individual files with CFFTP, or, in our case, generate an FTP script and pass it to a command-line FTP utility to handle the actual file transfers (I found that to be more stable over time with the larger files). Once downloaded, unzip, import and enjoy. For anyone else interested in the trials and tribulations of the MLS system we are talking about, I wrote a short novel about it in my blog. -- Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Script on one site
Any ideas? Probably a SQL injection attack. See the previous discussion on this topic: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:57241 -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I unzip a password-protected zip file with cfzip?
I have the password and can unzip a file manually, but is there a way to use the password with cfzip action=unzip ? Hi Rick, I haven't actually used the new CFZIP tag yet, but I don't see anything in the documentation that indicates support for password protection in saving or opening ZIP files. We are using the CFX_Zip tag from EmTek Systems (http://www.emteksys.com/products/cfxzip/). We've been using that for a couple of years without any problems for password protected real estate data feeds. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard characters in filepath?
The files would follow this format: II20080830_033219_ACR.log If you're downloading via FTP then you can get a list of the remote files, then loop through the resulting query object to look for the files you want. From the filenames it looks like you're downloading images from MLXchange. I'm in the midst of updating all our MLS code here as well so I can feel your pain. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Pre-filling FileField Values
How would the one folder method be more risky than the one file method? If they're still clicking and selecting then it isn't more risk per se, but creates issues in usability for the user. If they're not careful they could theoretically upload their entire My Documents folder without realizing it when they intended to send one file. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL injection attack on House of Fusion
Filtering means allow unless it matches. A security measure should be deny unless it matches. I believe that depends on the proportion of wanted vs. unwanted items. On a firewall, this is the best approach because there are far more ports that you don't want to have available than there are that you do want available, so a deny everything and allow these few approach is workable. Trying to apply the same logic to URLs isn't workable in my opinion. With dynamic web applications there are a virtually unlimited number of good URLs that are possible, and only a handful that are undesirable. This is especially true if you pass session tokens through the URL for session management. I can think of a few ways to implement a security system to allow only approved URLs, but none of them are any more effective than using secure coding methods to begin with. If you have a novel approach I'd be interested in learning about it. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF_ImageCRTag
Does anyone use a tag by that name? If you do, could you please send it to me? I lost mine and need it back... CFX_ImageCR is published by Efflare (www.efflare.com) if that's what you're looking for. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfimage - upgrading to from older server
my webhost have too restart the cfapplication in order to unlock the files. I've found that some of these file in use situations can be averted by renaming the file just before deleting it. Set a variable with a UUID, rename the file, then delete. I've not run into this problem on CF8 and CFIMAGE, but it's worked for me in the past when files would get locked up. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion8 silent installation
The admin API was introduced in CF7. Previous, unsupported functionality using ServiceFactory may well have changed between versions, but that's just another example of why you'd want to use the admin API instead of unsupported functionality. Ah, that is probably what was in use then. I didn't write the original code, just had to update everything when it broke so I wasn't sure. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP! SQL Injection Attack!
Anyway, whatever solves the Michael's problem I feel sure is going to be a combination of things, not just the one. Actually, with this particular SQL injection attack it's really easy to stop. We created a SQL filter that is called from application.cfm. It loops through the URL structure and checks to see if any URL variables contain both a semi-colon and any SQL keyword. If a match is found, it just cfaborts the request and sends us an e-mail with the details. We periodically review those messages and have not found a single false-positive yet after deployment to every site we manage. Granted, it will not stop SQL injection through form posts, but I don't recall ever seeing a SQL injection attack through a form post (yet). At the least it can put an immediate stop to the current flood and give you time to implement other protective measures such as cfqueryparam, etc. We have CF5 and CFMX versions if anyone wants a copy. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HELP! SQL Injection Attack!
Now this is real bad for shared hosting customers. Cause even if we protect our sites, that SQL simply queries all tables in the SQL server. So, if you found your data compromise, the leak may have been caused by other sites that are using the same SQL machine, duh! On SQL Server the sysobjects and syscolumns tables are per-database, so any script that queries those will only see the tables and such for the database it's running inside of. This particular attack will stay within the database being queried and not go outside, so if your site is hit with this attack it's a sure sign that there is a problem in your code somewhere that let it in. Given that, I have seen SQL injection attacks that will go try to query the 'master' database on SQL Server, look at the sysdatabases table, and then go crawl through every database it can get access to (and if it can get to master, it's a good bet it can get to everything else). Those are the really nasty ones. If the hosting company is at all competent, they will have a unique username and password for each client database (or each client shared among your databases) which can't access other client databases. Not only does it help contain SQL injection attacks, it keeps other hosting clients out of your databases (and you out of theirs). -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any legal issue saving some CC info?
I was wondering if there are any legal issues saving the last 4 digits and expiry dates of a CC as part of a transaction? Should they be encrypted? See the PCI-DSS (Payment Card Industry Data Security Standards). There are a lot of contractual regulations that have to be met if you're processing credit card transactions. https://www.pcisecuritystandards.org/ https://www.pcisecuritystandards.org/security_standards/pci_dss.shtml http://en.wikipedia.org/wiki/PCI_DSS -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfeclipse and ftp
I've always just used WebDrive to map my FTP servers to a local drive. Second you on Webdrive, I still use HomeSite+ on Windows and found WebDrive gave me better FTP control and performance over the FTP/RDS shell extension. Eliminated that nasty ftp timeout and it zero-bytes the file and locks up issue too. -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Site needs a new home...
I am looking for a new home for one of my web sites, ZonkBoard.com. We have not done much with it over the last couple of years due to time constraints, but it has potential. It's all ColdFusion and MSSQL-based, and pretty low maintenance. If anyone is interested in taking over this web site and doing something with it, please contact me off-list. Thanks! -Justin Scott ~| 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:289808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF 7 upgrade BAD!
This is just s quick note to look for some possibilities... Have you checked the performance counters to see if pages are getting queued up? -Justin Scott | GravityFree Senior Programmer / Product Engineer 1960 Stickney Point Road, Second Floor Sarasota | FL | 34231 | 800.207.4431 941.927.7674 | f 941.923.5429 www.GravityFree.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF 7 upgrade BAD!
Performance counters? I haven't heard that term in relation to CF before...can you elaborate? Load the performance monitor in Windows, then add counters. There should be a ColdFusion entry in the selector list, then you can add the individual counters (avg page time, avg db time, queued pages, etc). Very handy for monitoring specific aspects of the CF service. -Justin Scott | GravityFree Senior Programmer / Product Engineer 1960 Stickney Point Road, Second Floor Sarasota | FL | 34231 | 800.207.4431 941.927.7674 | f 941.923.5429 www.GravityFree.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235349 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: maintaining state in multipage form
It sounds like a session variable containing an array of checkboxes and their selected values might be in order. Assuming the user has cookies enabled (or if you pass the session tokens on the URLs) this should be fairly simple to implement. -Justin -Original Message- From: Christophe Maso [mailto:[EMAIL PROTECTED] Sent: Sunday, March 12, 2006 6:52 PM To: CF-Talk Subject: maintaining state in multipage form I've taken over a web application where at one point, the user has a long list of items to choose from to be compared to one another. Each product has a checkbox next to it, and after checking off those products the user wants to see, the user submits the form and views a comparison table. This would be simple if the form were all on one page, but it's not. Since there can be potentially be a lot to choose from, the form is codes to display only 30 or so items at a time. There's hyperlink navigation at the bottom of the page to go to next/previous page, or to go to page x, in order to see other items. Clicking on any of these links executes a new request and the previous page's checkboxes lose their state. So right now the user can only compare items if they happen to be listed on the same page in the same group of 30. I need the user to be able to check boxes on any page and jump around to other pages of the form, checking or unchecking as they want, and have the form maintain it's overall state for when they finally submit. Any leads on where I can get some tips on how to do this? Thanks, Christophe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235162 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can moving from cf server 5 to mx7 cause an app to stop working?
Has anyone else experienced this issue and what do you recommend as a solution. Does it pay to persue finding a host running cf server 5 and does anyone know of one? Personally, I would try to track down the issue and update the code if you can run on a newer version of CF. If anyone has a need for a specific version of CF, the company I work for offers hosting on CF 5, 6, and 7 with MSSQL Server 2000. We also have solid e-mail service with very, very good spam/virus filtering. -Justin Scott | GravityFree Senior Programmer / Product Engineer 1960 Stickney Point Road, Second Floor Sarasota | FL | 34231 | 800.207.4431 941.927.7674 | f 941.923.5429 www.GravityFree.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: socket connections from CF to SMTP
Was wanting to confirm the existance of an email address Check out EmailVerifier from ActivSoftware. It will do everything you want and more. http://www.activsoftware.com/email/verify/ -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: socket connections from CF to SMTP
...there is a DNS record called an MBX record but it's seldom used these days - something left over from the dark ages of DNS I believe it was actually MB, defined in RFC 1035 as an experimental type. There were also MD, MF, MG and MR (some obsolete, some experimental) which performed various e-mail related functions. I have not seen any of them in actual production use in my eight years of Internetting (is that even a word?). As an aside, I have run DtDNS.com (a DNS hosting service) for the last seven years, so I keep hard copies of the DNS RFC's handy for reference. what about sending a message to the address and then checking the undelivered folder for any bounces? The ColdFusion undeliverable folder should only have messages that were either the result of your e-mail spooler being unavailable, or your spooler out-right rejecting the message (invalid user on a local domain, for instance). If your spooler is configured properly to accept mail for relay from ColdFusion, any bounce generated would go to the FROM address in your CFMAIL tag (or the optional FAILTO attribute on CFMX). You could check that mailbox with POP and parse out the results. I use the Java extension from ActivSoftware myself, which is much easier. (I posted a link earlier). -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: detecting delivered email addresses...
I was wondering if there was a way to detect the email delivery status of an email programmatically? Once an e-mail has been sent, there is no way to track its delivery like you can with a package sent via FedEx. You can, however, test to see if the mail servers configured for a domain will accept delivery for an address at the initial SMTP level. ActivSoftware has a Java extension for ColdFusion that will take an e-mail address and return whether it is valid or not by checking to see if the domain exists, if it has MX records, if there are mail servers responding on the MX records, and whether those mail servers will accept the address up to the RCPT TO command via SMTP. http://www.activsoftware.com/email/verify/ I have this implemented on my sign-up forms as an initial verification that the address is somewhat valid. I also periodically run e-mail newsletter lists through it to weed out bad addresses before sending. Of course, if a mail server has a catchall box, or if it's a backup SMTP relay for the domain that will accept all mail, then it will return a false positive, but it does a decent job of weeding out most of the addresses that are not good. Essentially what we want to do is to make sure that an email account exists or guarantee fast delivery. Unfortunately with e-mail there is no guarantee for anything, as many mail servers don't play by all the rules. -Justin Scott, GravityFree Senior Developer / Product Engineer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231625 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Log analyzer software.
I'd like some recommendations on web log analyzer software. I'm a little late on the discussion, so apologies if someone has already mentioned this. I personally prefer SmarterStats. It has a clean interface, scales well, and supports auto-login from client site admin consoles and such. It's easy to create sites, and then let the user see whatever reports they want. It will even remove the log files after a specified period of time to keep your drive from filling up. All around a great product with a great price tag compared to some of the others out there. http://www.smarterstats.com/ -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query finding data IN
Where table.sites HAS session.variable I know has isn't the right term, but this is the english of it. I believe with SQL Server that you can use a comma-delimited field as the target of an IN function as below. It's been a while since I've used code like this, so I could be remembering wrong. WHERE #session.variable# IN (table.column) -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query finding data IN
Just to be certain, I ran some tests and confirmed that my remembrance was indeed incorrect. I was probably getting the direct use of a column mixed up with using a sub-query to pull values. I've been programming with abstract interfaces that shelter me from having to write my own queries too long and it's making my SQL knife dull. -Justin Scott -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 10:20 PM To: CF-Talk Subject: Re: Query finding data IN The IN operator is used the other way around, but won't help in this scenario...if the possible values really are 1-9, then you could use charindex...otherwise you might look at using patindex. On 2/6/06, Justin D. Scott [EMAIL PROTECTED] wrote: Where table.sites HAS session.variable I know has isn't the right term, but this is the english of it. I believe with SQL Server that you can use a comma-delimited field as the target of an IN function as below. It's been a while since I've used code like this, so I could be remembering wrong. WHERE #session.variable# IN (table.column) -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: avoiding direct SQL command injection
When using numeric values as queryparams an error is thrown, (eg where fld_id=cfqueryparam cfsqltype=cf_sql_bigint value=#url.v# when v=abc) This is easy to get around by wrapping the url variable in a val() function. That will guarantee that whole number will be passed in. -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: install problem
I had a similar issue a week or so ago with the installer opening, and then vanishing. Resetting the DEP setting corrected the issue for me, so I wouldn't discount it so lightly. -Justin -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 8:57 AM To: CF-Talk Subject: Re: install problem That won't resolve every issue with the installer exiting. As Neil said, sometimes the only way to get it to work is to do a silent install. Andy On 25/01/06, Jim Wright [EMAIL PROTECTED] wrote: From Macr...err...Adobe site http://www.macromedia.com/support/coldfusion/releasenotes/mx/m x61_known_problems.html#installationandconfiguration (It's down on the page, so I'll paste the section here) 60086 On Windows 2003 systems with Service Pack 1 (SP1), the installer immediately exits in the preparing to install dialog before extracting files. This worked previously on Windows 2003 without SP1. A feature of Windows 2003 Service Pack 1 is Data Execution Prevention. This security feature blocks the InstallAnywhere self-extractor for CF 6.1 and all JRun4 Updaters. (CF 7.0 is not affected). To fix this problem, do the following: 1. Click Start, right click My Computer, and select Properties. 2. On the Advanced tab, click the [Settings] button under the Performance section. 3. Select the Data Execution Prevention Tab in the Performance Options dialog. 4. Select the radio button for Turn on DEP ... except those I select: 5. Select Add and select the Coldfusion or JRun installer. (the entry shows up as InstallAnywhere Self-Extractor in the dialog) 6. Select Apply on the performance options and OK on the System Properties page 7. Now run the installer Here is Microsoft's description of this feature: http://msdn.microsoft.com/library/default.asp?url=/library/en- us/memory/base/data_execution_prevention.as On 1/25/06, Jennifer Gavin-Wear [EMAIL PROTECTED] wrote: Coldfusion mx6.1 install on win 2003 standard. I see the installation wiz kick off and then it just disappears, can't see any processes left running. Ideas anyone? Thanks, Jenny ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230427 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: storing query results while paging through
Assuming your query pulls all of the results and you use the startrow and maxrows attributes when outputting, you could just use the cachedwithin attribute of cfquery itself to store the results in memory without all the fuss of session variables. This will also have the benefit of using the same cache if multiple sessions search for the same thing while it's in the cache. -Justin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 10:34 AM To: CF-Talk Subject: storing query results while paging through All, I don't use session variables at all, but this might a good time to use them. I have a search page that takes in a search term, runs a query and then displays the results. The user is allowed to click into a result and then page through the search resultset while in a result (via Previous/Next controls). Since I don't store the query results anywhere, I basically run that query every single time that the user presses Previous or Next (just so that I can find out where the user is while s/he is paging through and what the previous and next results are.) For an intensive search (which this is turning out to be), this means every time that the user does anything with the resultset, I am running a 4 or 5 second operation. Highly inefficient, I suspect. How do I cache the query results? Is a session variable the best option? I guess cookies would not be bad, but they are limited in the amount they can hold. How do people tackle this problem anyway? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: storing query results while paging through
The cache is based on the query name, as well as the actual query going to the SQL server. If the search string is different, then the query would be different, so it would get cached independently of the others. Note that if you are using cfqueryparam in the query, it cannot be cached with cachedwithin. -Justin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 12:13 PM To: CF-Talk Subject: Re: storing query results while paging through Justin, Suppose the query is named 'getResults' and I have enabled the cachedwithin attribute. Say user1 comes along and searches for 'Portugal'. The query 'getResults' is cached. Then user2 comes along and searches for 'Spain'. This happens while user1 is paging through the resultset for 'Portugal'. Then user3 comes along (while the sessions for user1 and user2 are still on) and searches for 'Argentina'. What happens to the cache for 'getResults' while all this is happening? How does CFMX 7 (which I am on) handle all these interactions for cached queries? Thanks, George On 1/23/06, Justin D. Scott [EMAIL PROTECTED] wrote: Assuming your query pulls all of the results and you use the startrow and maxrows attributes when outputting, you could just use the cachedwithin attribute of cfquery itself to store the results in memory without all the fuss of session variables. This will also have the benefit of using the same cache if multiple sessions search for the same thing while it's in the cache. -Justin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 10:34 AM To: CF-Talk Subject: storing query results while paging through All, I don't use session variables at all, but this might a good time to use them. I have a search page that takes in a search term, runs a query and then displays the results. The user is allowed to click into a result and then page through the search resultset while in a result (via Previous/Next controls). Since I don't store the query results anywhere, I basically run that query every single time that the user presses Previous or Next (just so that I can find out where the user is while s/he is paging through and what the previous and next results are.) For an intensive search (which this is turning out to be), this means every time that the user does anything with the resultset, I am running a 4 or 5 second operation. Highly inefficient, I suspect. How do I cache the query results? Is a session variable the best option? I guess cookies would not be bad, but they are limited in the amount they can hold. How do people tackle this problem anyway? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Print to a printer
I have a perl script that prints directly to a printer when a user submits a form. Is there a way that ColdFusion can do this through Java? Has anyone done this before. The printer will be attached to my network locally. We ran into this a couple of months ago with an intranet application that needed to print nightly reports, as well as reports on demand for a local office. We ended up installing Batch and Print Pro on the server, which has a directory monitor feature. Using CFMX 7 and the PDF generation tools, we generated PDF files and saved them to the directory the Batch and Print Pro was configured to monitor. It would then pick up the file and print it to the default printer on the server. Works like a charm! http://www.traction-software.co.uk/batchprint/ -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230092 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
IIS Authentication
I'm wondering if there is a way in ColdFusion 4.5 (or CFMX7) to determine if the user has been authenticated by IIS or not, and if so, what the username is that they are logged in with? -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IIS Authentication
cgi.Auth_User will be populated with the username I had seen that listed in the debugging output, but it was always blank. Turns out there was an error in our IIS setup that was causing the authentication to not work properly. I also see now that if it's authenticating against a domain, it also includes the domain in the variable as well. Thanks for the info! -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230134 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up MS SMTP server for CF
Anyone have any good links for setting up (securely) the MS SMTP server for sending CFMail. I'm setting up a dedicated CFMX server and need to set this up so I can route CFMail through it - that's all it will be used for - with everything on the same machine. This is so easy you shouldn't need a link: Open the properties for your virtual SMTP server under the IIS snap-in. Go to the Access tab. Click the Connection button. Select only the list below and enter the IP address(es) of your server(s) that you want to send mail from. Click OK. Click the Relay button. Select all except the list below and leave the list blank. Since your servers are the only ones that can even connect, this is okay. You can limit by IP here as well if you want to. Click OK. Click OK. Point your ColdFusion server at it. You're done. If you're doing an extremely high volume of e-mail, you can see better performance by writing your MSG files directly to the \inetpub\mailroot\pickup directory instead of using CFMAIL to send them to the same server via ColdFusion's queue and SMTP. That cuts out a step and gets the messages out that much faster. -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Free third party DNS hosting from godaddy
has anyone tried using the free DNS management from godaddy? One of my sites, www.dtdns.com, offers DNS hosting. It's not free, but I can do special deals for fellow CF developers. I've never used GoDaddy's DNS service (obviously) but I'll have to check it out. -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encrypt CC number and store in DB
customer ID to store and use for future Txs.they spend all the $$ on security and liability insurance why should you ;-) I have seen many instances where a site will collect all of the order information (including CC details), and then store it for manual processing later. They do not have online credit card processing, and instead review each order and then charge the card using an existing terminal at their store. Because of the low volume of orders, many times it doesn't make sense to pay monthly for online processing when they already have a physical terminal present that they can run the cards on. I don't know how well that flies with Visa/MC regulations, but this setup is more common than you might think. -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229602 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Parsing through text file
We have a file upload process here where a user needs to upload a file, the file then needs to be parsed through to get data out of it and inserted into a database. The file is 1.4mb long. I'm having issues just reading and looping through the file. Is there a better way to do something like this than to read the file then do listgetat(string, x, delimeter) ? Seems there has to be another way to do this. I use CFFILE and CFLOOP to process importing text files all the time. The last one I did was an 80MB MLS data pipe going into a database. You say you are having issues, but we will need some details on those issues before the problem can be addressed. -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229164 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Accessing Network Drives
1) Is it possible to run CFFILE Exists on that F:\ drive on Server 2? If so what would the CFFILE Exists code line look like? Use CFFILE, but don't use a drive mapping, use the UNC path to the server share directly. Depending on the permissions of the share, you may need to run the ColdFusion Application service as a user with permissions to access the share. This would look like... cfset theFile = \\server\share\file.txt cfif fileExists(theFile) /cfif -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229165 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
JAR Launcher Crash?
We're having an issue with one of our CFMX 6.1 servers where it will seemingly randomly throw up a JAR Launcher crash message through the Windows error reporting utility. This is CFMX 6.1 with the Sun JVM version 1.4.2. Any thoughts on why this would be happening or how it can be avoided? Thanks! -Justin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
No but you can help and thats the point, its pretty pathic when there are thousands of ppl on the list and there are like 3 ppl who volunteered to help. I watched in horror when the initial discussions about this were popping up a few months ago. In my experience, trying to START a project like this as a community effort will lead to disaster. Many people will have great ideas, some will commit to helping, and some of those will back out as they realize that their time is better spent doing other things. The ones that remain will generally bitch about the ones that left and commit further to finish a project anyway. Unfortunately, the next step is usually disagreement over what features to include, what framework will be used, coding standards, what will determine when the first release is finished, etc. Because of all the disagreements and ego contests, nothing gets done, and the project falls apart. If you REALLY want an open-source shopping cart in CF, someone, one person, will just need buckle down and write a feature set, decide on a framework, and CODE MOST OF IT OUT. Write the base code to a point where it's at least somewhat functional. That means it supports basic features, supports one or two common payment gateways, has basic shipping calculations, maybe e-gift cards or coupons, etc. Then, take that code and start a community project. Throw that base at the community and people will be much more likely to step in and flesh it out. The hard part will be done. Someone who uses a particular payment gateway may be fine with submitting code for that gateway and spending a day integrating it, but maybe they're not willing to spend several days or weeks chasing arguments over frameworks. If one person has the time and smarts to write a decent, flexible, scalable framework, the community will be far more likely to step up and plug stuff into it. I'm not the person to do that right now because of my work load, but that's what I believe will need to happen if this idea is ever going to see a release. Just my $0.02 on the matter. -Justin Scott ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF5 + CFMX7 Gotchas?
Anything special I should be aware of if I need to have CF5 and MX7 on the same box? -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226876 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Latest Stable JVM Version?
What is the latest version of the Sun JVM that is stable with MX6.1 and/or 7? Thanks! -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226877 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Custom Error Pages
Also remember that you can set IIS to check if file exists before passing the request off to ColdFusion so that IIS would handle 404's on cfm files as well. It would depend on your host as to how that was set. -Justin Scott -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 6:24 AM To: CF-Talk Subject: RE: Custom Error Pages Coldfusion 404 errors are not handled by IIS. This is a setting in the CFADMIN that specifies a global 404 page for missing .CFM pages. As far as he regular IIS errors, you can specify any page you like, the extension doesn't matter. -- Snake -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: 28 November 2005 01:29 To: CF-Talk Subject: Custom Error Pages In a shared hosting environment where HELMs is used, you can establish custom error templates for 404 errors and others. Now if I want to redirect 404 errors to an error page such as: /errors/404.cfm That should be fine, right? Or does it need to be an HTM page? I was informed this: I think the custom error pages work provided that you call a URL that doesn't end with .cfm. Anyone have more information about it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Custom Error Pages
That is good to know. I very rarely use charting, but if it ever breaks somewhere I'll know where to look g. -Justin Scott -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 8:14 AM To: CF-Talk Subject: RE: Custom Error Pages If this setting is enabled it breaks cfcharting. -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: 28 November 2005 12:59 To: CF-Talk Subject: RE: Custom Error Pages Also remember that you can set IIS to check if file exists before passing the request off to ColdFusion so that IIS would handle 404's on cfm files as well. It would depend on your host as to how that was set. -Justin Scott -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 6:24 AM To: CF-Talk Subject: RE: Custom Error Pages Coldfusion 404 errors are not handled by IIS. This is a setting in the CFADMIN that specifies a global 404 page for missing .CFM pages. As far as he regular IIS errors, you can specify any page you like, the extension doesn't matter. -- Snake -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: 28 November 2005 01:29 To: CF-Talk Subject: Custom Error Pages In a shared hosting environment where HELMs is used, you can establish custom error templates for 404 errors and others. Now if I want to redirect 404 errors to an error page such as: /errors/404.cfm That should be fine, right? Or does it need to be an HTM page? I was informed this: I think the custom error pages work provided that you call a URL that doesn't end with .cfm. Anyone have more information about it? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: pseudo-memory leak
Client.userId=123456 Now, the user has no way to change that... Now, lets say I store it in the cookie... If your site is running on any kind of traffic, you should probably be using session variables for this kind of thing anyway. Cfcookie name=userId value=123456 Now, the user can examine their cookies and know their userid. Worse, they can change the userid, and be logged in as a different user. Using an ID in a cookie in combination with something else, like a unique session hash cookie that changes upon login and gets checked against the database on every page load, you would be okay. Session variables are still more efficient in most cases though. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225501 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Grouping problems
Hi Will, if you add an ORDER BY to your query on the field(s) you want to group on it will usually take care of this problem. -Justin -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 12:44 PM To: CF-Talk Subject: Grouping problems I always have a hard time grouping my queries and usually resort to the group attribute in cfoutput. Once again, it's not showing me what I need. I think it'd be best to group in the SQL before I even output it but don't know exactly how to do it without making things worse. What I need to do is show the combined product options with their prices in a select, ordered the way I want. What I've currently got *works*, but it isn't ordered properly. You can see it here: http://wtomlinson.com/newcart/productdetail.cfm?PID=114 Here's my query: cfquery name=getproductoptions datasource=#VARIABLES.DSN# SELECT tblSKUS.SKUID, tblSKUS.merchSKUID, tblSKUS.SKU_prodID, tblSKUS.SKUprice,tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblSKUoptions.SKUoptionID, tblSKUoptions.SKUoptionname, tblSKUoptions.SKUoptionsort FROM tblSKUS, tblSKUoptions_rel, tblSKUoptions WHERE tblSKUS.SKU_prodID = #ARGUMENTS.PRODID# AND tblSKUS.SKUID = tblSKUoptions_rel.optionSKUID AND tblSKUoptions_rel.option_optionID = tblSKUoptions.SKUoptionID /cfquery Here's the output: cfif getproductoptions.recordcount NEQ 0 select option(s): cfselect name=optionID cfoutput query=getProductOptions group=optionSKUID option value=#SKUID#cfoutput#SKUoptionname#nbsp;/cfoutput #DollarFormat(SKUprice)#/option /cfoutput /cfselect Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224755 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Command line Printing SOLVED
If you can convert the HTML to PDF (see iText or fop) you can install acrobat reader on the server and print the pdf by running: cmd.exe start /C acrord32 /p /h FILE.pdf Apparently Adobe has changed the command line for newer releases of Reader and it no longer supports these switches. I did find a solution, though, in a shareware program called Batch Print Pro. It installs as an app, and can be run as a service. It manages print queues and supports both command line printing and directory monitoring. We set it up as a service that monitors a folder on the server, then we just drop PDF files in that folder and they get sent off to the default printer. Then it moves them to a different folder so we can track which ones get printed properly. Great price too! -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224613 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sending Faxes through Cold Fusion
Thanks Ali, I should have adjusted the subject line as we were discussing printing from the command line, not faxing (I hijacked a thread). -Justin -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Thursday, November 17, 2005 4:45 PM To: CF-Talk Subject: Re: Sending Faxes through Cold Fusion Where i work, we have a faxserver. To send faxes, we create either RTF or PDF attachments and then do CFFILE write, to the faxserver. Basically we write to the faxservers control file. It takes certain parameters, such as the Destination Fax Number, and Attachment. The attachment is the RTF or PDF we generate. The faxserver should come with instructions on what its control file requires. HTH Ali If you can convert the HTML to PDF (see iText or fop) you can install acrobat reader on the server and print the pdf by running: cmd.exe start /C acrord32 /p /h FILE.pdf We're running CFMX 7, so wrapping our HTML reports with CFDOCUMENT might make this a viable solution assuming we can get it to format everything correctly. Thanks! -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Multiple sites in IIS - Modifying DNS
CNAME records should only be used when aliasing a host that is not within the same zone, otherwise, use A records. -Justin Scott -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 1:39 PM To: CF-Talk Subject: RE: Multiple sites in IIS - Modifying DNS Dave, The CNAME record is used less than the A record because it causes more traffic - more lookups. You can have multiple A records for the same IP. Personally, I think it's easier to manage just A records. -Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 12:19 PM To: CF-Talk Subject: RE: Multiple sites in IIS - Modifying DNS I've created an additional site in IIS 6 on my development server with a unique Host Header. So there are currently two sites on that server. Now I've got my brilliant Network admin trying to that second site to the DNS. Thus far, he has failed miserably :-). He created a new primary forward lookup zone. On the new primary zone, he created a host A record corresponding to the Host Header name, but only the dns server itself is able to resolve it, and in that case, not to the second site, but rather the development home page itself. The bottom line is that he blames me, and I blame him, and we're about to take it outside, in which case, we'll be looking for a new network admin (LOL). We would greatly appreciate any ideas on how to resolve this DNS issue. Thanks! There's no need to create a new zone. Zones typically correspond to domains or subdomains. Assuming that both sites on your server use the same IP address, your network administrator only needs to create a CNAME record pointing the new host name to the old one. If the sites use different IP addresses, you need to create a new A record pointing the new host name to the appropriate IP address. In any case, your network administrator needs to learn how DNS works, since it's integral to so many things on a network. Unless you're changing DNS entries yourself, there's nothing he can really blame you for, except that you're making him do his job. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Multiple sites in IIS - Modifying DNS
CNAME records should only be used when aliasing a host that is not within the same zone, otherwise, use A records. I'm not a DNS expert, but my understanding is that this is simply incorrect. There's nothing wrong with using CNAME records to alias hosts within a zone. You CAN alias records within the same zone, but it's generally not a good idea because of the extra DNS lookups required to resolve them. Just because you can do a think, does not mean you should. -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Multiple sites in IIS - Modifying DNS
I don't agree with this because CNAME records pointed to A records make it easier to change IP addresses for said A records. One scenario would be 10 A records For people manually managing zone files, I suppose this could make life easier. I run my own DNS hosting service that uses variables for IP addresses and generates the zones, so it isn't an issue for me personally. My reasoning is based on minimizing the number of lookups that need to be done. As a rule I try to avoid them within the same zone for that reason. It's really not a big enough issue to argue about, so to each their own :). -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224676 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sending Faxes through Cold Fusion
Does it have to be a fax? What about sending the data to a locally installed printer? I'd love to know if there is a simple way to do that. I'm in a situation where I need to run several reports (generated in HTML) and they need to be printed on whatever the default printer is on the server (Windows 2003). I've done a lot of searching, and I've seen the redirect to lpt1 in a batch file posts and well, that won't work for sending html files. Essentially I need a service that can run on the server that I can feed a list of URLs to and have it render them, and then send them on over to the default printer. Anyone have ideas? -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sending Faxes through Cold Fusion
I wrote a small app in Visual Basic a few years ago that did exactly that. I might still have that kicking around somewhere. If you still have a copy of that and wouldn't mind sending one over, my fellow coders and I would be very appreciative. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224488 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sending Faxes through Cold Fusion
If you can convert the HTML to PDF (see iText or fop) you can install acrobat reader on the server and print the pdf by running: cmd.exe start /C acrord32 /p /h FILE.pdf We're running CFMX 7, so wrapping our HTML reports with CFDOCUMENT might make this a viable solution assuming we can get it to format everything correctly. Thanks! -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sending Faxes through Cold Fusion
Google HTMLDOC. If I remember correctly it's free and does everything you are looking for. Thanks Terry, the only thing I could find with that was a utility to convert pages to PDF, but I didn't see anything about it sending them to the printer. My ideal solution would be a tool that would simply take a URL to fetch, render, and print to the default printer with no user interaction on the server. I've been trying to write a utility in .NET to do this, but my C# skills are not to that level just yet and I'm running out of scheduled time. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfinclude problem
/ is (and has always been) a built-in CF mapping (defined in the CF Admin) that goes to the root of the site. ColdFusion has no concept of your site like IIS does. If my root folder is c:\http\mysite and I try to include /folder/file.cfm ColdFusion wouldn't know where to begin looking. Any include like this has to be defined in the administrator as a mapping, otherwise, use relative paths from the file you're including from. -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223952 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfinclude problem
Or it could be so long since I've tried to do this (include a non-relative path) that it could have changed the way it handles includes since 4.0. -Justin Scott -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Friday, November 11, 2005 11:07 AM To: CF-Talk Subject: RE: cfinclude problem / is (and has always been) a built-in CF mapping (defined in the CF Admin) that goes to the root of the site. ColdFusion has no concept of your site like IIS does. If my root folder is c:\http\mysite and I try to include /folder/file.cfm ColdFusion wouldn't know where to begin looking. Any include like this has to be defined in the administrator as a mapping, otherwise, use relative paths from the file you're including from. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223955 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Sending Faxes through Cold Fusion
I'll second the fax by e-mail method... Works like a charm! -Justin -Original Message- From: John C. Bland II [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 9:38 PM To: CF-Talk Subject: Re: Sending Faxes through Cold Fusion If you grab an fax service where you can fax by sending an email you just create an email and send it to the fax #'s email addy. eFax I know does this. On 11/9/05, Stephen Cassady [EMAIL PROTECTED] wrote: Hey all - I have a situation where I need to replace a current application (a web system that runs .exe for each requested page!) with CF. Everything is good except for one item: I need the ability to send a fax from CF. Does anybody have some suggestions or links that would assist in sending a fax from CF? Thank you for your time in advance - Stephen Cassady ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SPAM : 8.1] Re: Rumors from Max..
I think that likely has more to do with the database drivers than CF itself. If a site is getting so much traffic that its access DB is causing problems, it may be time to move up to MSDE or SQL Server. -Justin -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 12:13 PM To: CF-Talk Subject: RE: [SPAM : 8.1] Re: Rumors from Max.. Our CF5 server needs restarting much less often than the CFMX servers. Whenever a site using an Access databases gets a lot of traffic and overloads the database with too many connections, CFMX just falls over. CF5 doesn't. Russ -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:58 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Yes, perhaps he lives in a parallel dimension where everything is opposite our reality. CF5... stable... that was a joke right? -Adam On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Convert Address to Latitude/Longitude
I don't know about street addresses, but there are many commercial zip code databases that have lan/lot data included that could be joined against in queries. -Justin -Original Message- From: Troy Montour [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 4:20 PM To: CF-Talk Subject: Convert Address to Latitude/Longitude Hello everyone, I'm trying to get a project finished by monday and the last piece I need to do is convert address's or Zip codes to Lat/Long and having no luck finding code for this. does anyone know of any cold fusion code out there that will look at address's in a DB and then figure out the Lat/Long is for it? second if it can't use the address for some reason use the zip code to find Lat/Long? I had one awhile a go in VB but its not working and would rather have it in Cold fusion. So it can run it daily when the data is downloaded. Thank You Troy Montour ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Finding top ranked articles
Why does it matter if someone already viewed the article? I actually think that tracking page views and having time limits on counters is a good approach if you have the time. I run a link database that tracks clicks on the links. If someone clicks the same link more than once within six hours, it only counts once. In my situation links are marked as popular of they are within the top 5% by clicks, so this helps prevent people from clicking, hitting back, and clicking again multiple times to inflate their rankings. Clicks are tracked by IP, but I don't worry much about proxy servers for this purpose. Here's the code if the original poster can use it. Watch for line wrapping. -Justin !--- Delete any clicks more than six hours old. --- cfquery name=clickdelete datasource=#request.dsn# DELETE FROM click WHERE cliDateStamp = DATEADD(hh, -6, getdate()) /cfquery !--- Check to see if they've hit this link in the last six hours. --- cfquery name=clickcheck datasource=#request.dsn# SELECT cliID FROM click WHERE linID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#links.linID# / AND cliIP = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#cgi.remote_addr# / /cfquery !--- If not found, update the count. --- cfif not clickcheck.recordcount cfquery name=updatecounters datasource=#request.dsn# UPDATE link SET linHitCountCurrent = linHitCountCurrent + 1, linHitCountTotal = linHitCountTotal + 1 WHERE linID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#links.linID# / /cfquery !--- Add this to the click table. --- cfquery name=clickinsert datasource=#request.dsn# INSERT INTO click VALUES ( cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#cgi.remote_addr# /, getdate(), cfqueryparam cfsqltype=CF_SQL_INTEGER value=#links.linID# / ) /cfquery /cfif !--- not clickcheck.recordcount --- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XOR
clause1 XOR clause2 I suppose in dating there could only be so much tolerance. I could tolerate a smoker, or blue hair, but not both because that would be too much. cfif isSmoker XOR isBlueHair Winner! /cfif Not practical really. I don't think I've ever actually seen anyone use XOR in my 6+ years of CF coding. I'm sure someone has, but nobody I've worked with. -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223112 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XOR
And here I was hoping MOD would be next on the list. I find that to be fairly useful in regular coding for all sorts of things. -Justin -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 5:32 PM To: CF-Talk Subject: Re: XOR That will be the next question. :) I've never had a need for it, but I've found imp to be useful sometimes. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, 4 November 2005 11:00 a.m. To: CF-Talk Subject: XOR ColdFusion comparison statements (CFIF, etc.) support the XOR joiner between clauses. This is used as such: clause1 XOR clause2 This says that either clause1 or clause2 has to be true for the statement to be true. If both are true or both are false, then the entire statement is false. My question is: can anyone think of a real world example where you would need a statement like this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223133 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example Each query includes a variable called columnList that you can look at. cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput -Justin ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
OR to remove the evaluate function call. cfoutput query=qry #qry[listGetAt(qry.columnlist,2)]# /cfoutout That would be great, if it worked. Query objects cannot be accessed like structures. Query columns can (qry.col[row]), but not the query itself. Throws a Complex object types cannot be converted to simple values error in CFMX7. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222947 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Have you tried using de() within your evaluate to get past the icky column names? -Justin -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:44 PM To: CF-Talk Subject: RE: Query column index number Yes, I know, and I am using that in one part of the page. Here's the rub. I am being given a spreadsheet that I have no control over. The column headers in the spreadsheet contain periods(for example, a column header might be 5.1.A.1.C), that when imported to sql server are converted to # signs, so it becomes 5#1#A#1#C. I was using something along these lines: cfloop list=qry.columnList index=column cfset colValue = #evaluate(column)# ...other stuff here... /cfloop However, CF does not like trying to evaluate columns that have # in them. I have a few other ideas, but I was hoping I could refer to the columns by an index. If I do a CFDump of the query, I get the correct values in the columns, so CF can process the table on some level. But I can't loop through the column names and evaluate them, and by the same token I cant use cfoutput query=qry#columnName#/cfoutput. Beside, I don't even know what the column names will be as they are subject to change. Thanks for your help -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 PM To: CF-Talk Subject: RE: Query column index number How can I refer to a column in my query by it's position in the query, or an index number, rather than the name of the column? For example Each query includes a variable called columnList that you can look at. cfoutput query=qry #evaluate(qry. listGetAt(qry.columnList, 2))# /cfoutput -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query column index number
Sorry, that's what I get for suggestion code without testing it. If one uses array notation, they must note complete, column and row. This works as test on 6.1. Should also work on 7, but I have not upgrade my workstation yet. All three methods output the same value from my test query. cfoutput query=test #test.factoid#br/ #test['factoid'][currentRow]#br/ #test[listGetAt(test.columnList,2)][currentRow]#br/ br/ /cfoutput Cool beans. I never tried accessing it with the row number also, so I'm glad to see that it works that way at least. -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222962 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Find no records
Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery SELECT columns FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT e.userID FROM tbl_020eventDetails e) -Justin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222977 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time Block
but that threw a nonspecified error, and the CFSET tag would only be processed if I enclosed the portion after the EQUAL sign within quotes (which obviously converted it to a string). Any ideas on how to code this part so that it works? The code looks fine as far as I can tell. Perhaps one of the fields from the DB has an invalid value such as a null or blank string or something? If you post the error here it may help uncover the issue. -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
Since CFQUERYPARAM also generally provides a performance benefit, why wouldn't you just use that? What do you see as the advantage of your data scrubbing? It depends on the project. If the variables are scrubbed from the beginning, some basic error checking can be run that would act before the query is even run. For example, if you have a product detail page that is expecting a product ID... cfset url.id = abs(val(trim(url.id))) cfif not url.id) cflocation url=/ /cfif Now you've guaranteed that there will be some value to pass to the query, and If someone tries to get tricky with a SQL injection attack, they get booted to the home page before the query is ever run. For most of my projects I use a combination of input scrubbing and SQL optimization (QUERYPARAM and SPs where needed). As with anything else, what you do depends on how the application will be used, what kind of traffic you're expecting, and how much time and money the client wants to throw at it. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
I guess I don't see the time spent to write a CFQUERYPARAM tag as a significant addition of expense. It's not, and at this point I do use them pretty much by default in addition to input scrubbing. Also, if you pass an invalid data value to a CFQUERYPARAM tag, CF will prevent the query from running. So, you could easily do the same sort of thing just using CFQUERYPARAM and an exception handler, which will provide the extra benefit of better performance. I prefer that ColdFusion not need to throw exceptions at all if I can help it. I'd rather my sites not look like myspace.com with a basic there was an error screen. If I can find the error in advance through scrubbing or validation, I'd rather handle it my own way. Just a personal preference I suppose. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222760 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
There's no reason you can't get the exact same result using exception handling as you're doing now using conditional logic. I like to think of it as pre-exception handling :) -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222763 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
You mention SP's will give greater performance. I think that may be a myth these days. Google around and you will find all sorts of debates on it. I was shocked myself after spending a good bit of day taking some queries from a CF page and dumping them into a shiny new stored proc and things didn't improve and actually seemed to slow down some. In my experience, it depends on the data you're querying against and how it is to be used. One example I had was a table with 1,000,000+ rows that had to have random data pulled out of it about once every 3 to 5 seconds, and more at peak hours. Even with the proper indexes and the entire table in memory, the one query being run from ColdFusion with one variable was eating up 75% of the processor on average, and closer to 90% during peak. Converting that one query to a SP and passing the variable to it knocked the CPU usage on the CF server down to about 5% on average. It really did help a LOT. If you're working with smaller tables that don't get a lot of traffic, you probably won't notice much of a difference, if any. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222681 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
I do agree it depends on situation and I' be curious to see how it performed in ASP or .NET or some other language as opposed to CF. Given how much more difficult is it to pass a query from those languages compared to ColdFusion, I think I would be more inclined to call a SP anyway. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
What do you mean in memory? SQL Server will hold as much of the most accessed data pages as it can in memory once it's loaded from previous queries. This table gets hit like crazy, so my guess is that the entire thing is loaded in memory after a couple of hours. And was your DB running on the same hardware as CF? The DB has to do the same work in either case (some randomization of a million rows), so the overhead of the SP/query should be completely lost in the mass of time it'd take to deal with the data. Perhaps ramdom wasn't the right word. The query isn't pulling random rows, but subsets based on a foreign key. The foreign key that is to be loaded is not predictable, and there are 10,000+ foreign keys that can be pulled at any time. The problem with having the query come directly from ColdFusion was that the query was different for each foreign key, which required the SQL server to compile a new query plan (which could be thousands of plans that would get cycled out of memory as new ones were compiled), which took far longer than using one plan (from the SP) that was cached. Using CFQUERYPARAM on that variable may have helped, but I never tested it that way. I just went directly from dynamic query to stored procedure and the CF page response time went down significantly because it no longer had to wait so long for the SQL server to process the queries. Even if I have some of the details wrong, that one change made things go a WHOLE lot smoother. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Philosophy Q: SP's or CFQUERY?
the CF page response time went down significantly because it no longer had to wait so long for the SQL server to process the queries. After re-reading this line I think it may have been confusing. What I meant was that the response time in ms went down, so the pages got a lot faster. And what about the security factor? I've always been under the assumption that if your CF only had access to run SPs you were safer from SQL injection. I would agree with that, but you can be just as safe with inline SQL if you scrub the variables properly. I've seen people scream in horror over a query like this... WHERE id = #url.id# Until I point out... cfset url.id = abs(val(trim(url.id))) As part of the scrubbing routine. Guarantees a positive integer value, and passes in 0 if it's a string. It's not the best way, but for small sites it's quick, easy, and pretty safe. CFQUERYPARAM would help also. Unfortunately some people are still using access databases, and don't have the luxury of stored procedures. I use SQL Server myself, and sp's where needed. I'm not a zealot one way or the other on what is used. Depends on the situation. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfc ?
i cant quite figure this out what would be the best way to do this There are a couple of options off the top of my head. One would be to create a checkSubscription() method that would return a boolean value depending on whether the e-mail address was subscribed. If it is, call the unsubscribe method. If not, display your error. This is probably the better choice. You can re-use the checkSubscription() method when someone tries to join the list so it will not add a duplicate, for example. The other method would be to use your existing code, but prepend a bit value to the front of your return value. Example: cfset result=0,Not found in database. cfset result=1,You have been unsubscribed. After calling the method, you can check the bit value using listFirst(unSubscriber) to determine if it was successful, and perform whatever action was needed. Then you can listRest(unSubscriber) to display/extract your error message. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222690 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time Block
If you do it the way you're doing it, you're comparing strings, not date objects. You should take the fields you get from the DB and use createDateTime() to create a CF datetime object, then compare that to now() instead of comparing strings. -Justin Scott I'm trying to implement that solution, comparing today's date with a date I have in a database (unfortunately, the DB I inherited has the date stored as individual dd, mm, yy, hh, mm, and ss fields). So I create my date with: cfset endTimeDate= '#qry.applCloseMonth#/#qry.applCloseDay#/#qry.applCloseYear# #qry.applCloseHour#:#qry.applCloseMinute#:#qry.applCloseSecond#' (again, from individual fields in the DB) and then I create thisDate: cfset thisTime='#DateFormat(Now(), 'mmm/dd/')# #Hour(Now())#:#Minute(Now())#:#Second(Now())#' and although both dates print exactly the same on the screen, the comparison between them does not trigger an earlier that or later than behavior (I'm using GTE and LTE). Any suggestions on how to make it work (considering how the date is stored in the DB)? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222693 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time Block
Hi. I trying create a function in this format: IsBlockedTime(startdayofweek,starthour, startminute, enddayofweek, endhour,endminute) This should be simple... Once you have the values, create datetime objects using createDateTime() and then use the DateDiff() function against those and now() to determine if it is in range. Return value as needed. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Client/Session Variable: When to set?
I may sound stupid: spiders bots can detect whether or not session/client variables has been set. By default, ColdFusion uses cookies to store the tokens used to track sessions, so unless you specifically put them on the URL strings (or forget to tell CFLOCATION not to include them) the search engines will never see them on the URL and it will have no affect on your rankings. The only real reason to pass the tokens around on the URL is if you MUST use session/client variables in a situation where cookies are not likely to be available for whatever reason. It's a pain in the arse, and I try to avoid it. Having said that, I don't think it matters one bit where you set them. If they're only used in the cart, set and use them in the cart. No need to use up memory for people who never go into the cart (not that it really matters for most sites). -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222540 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
When a function is called and the result outputted directly, an extra space is prepended! It looks like the space isn't being prepended to the return value, but ColdFusion is outputting whitespace from within the CFFUNCTION tag when it is called. Even more interesting, it's only outputting whitespace AFTER the last CFARGUMENT tag. So if you put a CFSILENT within the CFFUNCTION immediately after the last CFARGUMENT tag, it will suppress the whitespace. Close the CFSILENT right after the CFRETURN is called. This appears to be a viable workaround. Plug this into your previous example... cffunction name=spaceTest cfargument name=s type=stringcfsilent cfreturn -NO MORE SPACE HERE /cfsilent /cffunction Tested in CF 7. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flushing Cached Queries
Is there a way to force CF 6.1 to update a cached query programatically. There are a couple of potential options off the top of my head. If the times that the query is run are set, you could use a cachedwithin attribute to force it to expire after a certain period. If you want to force a flush, you could invoke the CF factory object and force it to flush all queries. To invoke the factory... cfset factory = CreateObject(java, coldfusion.server.ServiceFactory) You can CFDUMP the factory object to find the exact method to call, I don't remember what it is off hand. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222063 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Credit card verification
and we can't get it back up till we talk to people in Florida. Guess what's in Florida now. :) For Sarasota County, a day off. We had slight winds through the night with occasional power outages (which are now all corrected) but no damage to speak of. As a precaution, everyone pretty much announced they would be closed today, so here we are on a gorgeous, cool breezy day with nothing to do except read mailing lists g. -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222096 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: stop: SHOUTING
Just wondering if anyone knows a good way to recognise when all the characters are capitalised? Some users love putting text in CAPS and it just looks awful when it's displayed on screen. Ben's regexp should work, or you can compare... cfif str is uCase(str) is all caps /cfif -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222104 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - MSDE - EM/QA Tools
If you download the eval for SQL Server 2000 from Microsoft it includes the client tools. -Justin -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Saturday, October 22, 2005 7:49 PM To: CF-Talk Subject: OT - MSDE - EM/QA Tools I've just installed MSDE on a local dev machine, I don't have the disk with EM and QA on and was about to hunt down some alternatives on the web. Doesn anyone have any recommendations? Web based would be ok too. Thanks. Adrian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221949 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - MSDE - EM/QA Tools
Out of interest, how are people getting on with MSDE? I've more or less ignored it up until today. IIRC, GoDaddy's SQL Server offering for their hosting plans uses MSDE for those databases, and not actually SQL Server. For your own use, it depends on what you want to do with it. Keep in mind that it has some limitations, but for low-end sites it should work fine. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221957 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using try/catch all over the place a good thing?
There are cases where a try/catch block is warranted, so long as it's used properly What is the proper use and does it exclude catching errors that might be thrown by a cffile or cfquery? A proper use would be what you described, where you have a file coming in to be imported and there may be errors when trying to parse it, or an unexpected result from a web service call, or any number of other places like this. Whether you use a site-wide error template or catch the error, you probably want to let the user know about it (either there's a problem with the site, a problem with their input, or the planets aren't aligned, or whatever). As for CFFILE and CFQUERY, sure, you can catch individual errors if you like, but I wouldn't bother unless you plan on doing something specific with them. Now if you have an instance where the only thing you're using a database for is pulling banner ads, and the DB isn't available, that would be a case where you could catch the error, ignore it, and safely move on. Just make sure you have some checks in your banner display code for the existence of your variables and such before trying to display it. No sense in stopping the visitor from viewing the site just because your ads are unavailable for whatever reason. As for wrapping cftry/catch around EVERYTHING, I missed that part. That was what started the thread, or at least that's the impression I got from the original poster; that he wanted to wrap everything in one big try/catch block. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Maintaining CGI.HTTP_REFERER
I need to maintain the url of the referer if the current page is reloaded seral times. Whats the best method of acheiving this? You could toss the value into a session variable, a cookie, a database, a structure in an application variable... There are a lot of options for keeping a value around after the first request. I do this on several sites and then send the original referrer along with contact forms, signup forms, etc. to track where people are coming from. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Referral Initiative
a referral initiative to build their database for marketing. it goes like this... One thing that comes to mind is that I could find a list of e-mail addresses somewhere and spam people hoping a few will be interested and sign up. I would suggest limiting the number of submissions a single person can make within a certain time period to prevent this. Also, what is to prevent me from creating a throwaway e-mail address and referring it, then deleting the address? I get my voucher, and you get a bounce when the newsletter or whatever gets sent out. Perhaps require that they get two or three other people to sign up before giving out the voucher to discourage this if it's a concern. This almost sounds like one of those get a free iPod sites that will give you something if you can con ten of your friends into completing one of their offers except not as annoying. Personally if one of my friends used this referral form to send whatever it is to me and it got past my spam filter, I would be updating my filter rules. Whether something like this will work depends on who you're targeting it at. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221426 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using try/catch all over the place a good thing?
I'm wrapping some cftry/catchs around my cffiles and cfquerys. It works pretty sweet if I use just an empty catch. Hi Will, what is sweet about it, exactly? If your code is generating an error, it means one of several things: 1. Your code has errors. 2. Your user is giving your code input that you didn't anticipate. 3. There is an external problems, like a database being unavailable. Ignoring those errors and allowing the page to continue is probably a Bad Idea(tm) in most cases. There are cases where a try/catch block is warranted, so long as it's used properly. I would advocate a site-wide exception handler instead of just wrapping a try/catch block around everything. You can do this in the Application.cfm file with the CFERROR tag. Point it to an error handler that will display a friendly we're sorry, but there was an error display, and then e-mail all of the error information, the URL the user called, and possibly a CFDUMP of the various variable scopes to aid in correcting the problem. Your goal should be to never receive one of these error reports, and to promptly correct problems that the handler does report so that your users will have the best possible experience on your web sites. -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluation order of CF scopes
foo would also be available to custom tags and templates included using CFMODULE in the caller scope (caller.foo). Another scope not mentioned yet is request in which variables are available throughout the life of a single request as request.varname regardless if it's called from the same page, an included page, or a custom tag/module. Request variables must be scoped (like application/session) IIRC. -Justin -Original Message- From: Duncan [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 10:52 PM To: CF-Talk Subject: Re: evaluation order of CF scopes ok so these particular scopes dont get searched through if an unamed var is present. Do I also understand that if you do this: cfset foo = bar / cfoutput#foo#/cfoutput a) foo is actually sitting in the variables scope? b) and that foo is only available to - child templates included with cfinclude and - this current template Is this correct? On 10/19/05, Nathan Strutz [EMAIL PROTECTED] wrote: Charlie, You mean: cfset application.foo = bar / cfoutput#foo#/cfoutput although they'll both throw the same exception. Duncan, one of my favorite spots in the livedocs (well, it was until i memorized it all...) is this one, dealing directly with your question: http://livedocs.macromedia.com/coldfusion/7/htmldocs/0911.htm Though, I think i like the one from cfmx 6.0 better: http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFus ion_MX_Applications_with_CFML/Variables7.htm -nathan strutz http://www.dopefly.com/ On 10/18/05, Charlie Griefer [EMAIL PROTECTED] wrote: I believe those scopes need to be explicitly ...um...scoped :) e.g. cfset application.foo = bar / cfoutput#bar#/cfoutput will result in an error, since CF hunts thru the specific scopes (query, arguments, variables, cgi, url, form, client) and does not encounter 'bar' in any of them. On 10/18/05, Duncan [EMAIL PROTECTED] wrote: I was just thumbing through my CFMX7 Developer Exam StudyGuide and there is a section that lists the evaluation order of the scopes of CF. Something is bugging me though - when does application. session. server. request. get evaluated? -- Duncan I Loxton www.sixfive.co.uk http://www.sixfive.co.uk http://www.sixfive.co.uk [EMAIL PROTECTED] I can only please one person per day. Today is not looking good. Tomorrow isn't looking much better. Dilbert ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221435 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cfinclude processing
ColdFusion waits until all of the included code has run before it moves on. It sounds like your database isn't updating the tables fast enough before you run the query to re-pull that data for display (why you would need to re-query the database right after updating it is beyond me to begin with, but that's what it sounds like you're doing). -Justin Scott -Original Message- From: CHANCE, JENNIFER M. (JSC-BJ) (BAS) [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 3:34 PM To: CF-Talk Subject: Cfinclude processing Is there any way to make a page completely process a cfinclude before continuing? I have data that is sometimes updating in the cfinclude and that data is displayed. The cfinclude page runs and the database is updated, but not quick enough to display the new data on the page that is calling the cfinclude. Any suggestions? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cfinclude processing
Ah..I just went ahead and created another query in the cfinclude page to pull the data out and will just use that query to populate instead. It works and that's all that matters :) thanks! So you were pulling data out, then running an update query, and expecting that update query to change your local query object variable? If you update the database, you also have to update your query object either manually, or by running another query (as you've done here). This is normal... -Justin ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMAIL Suppress
Is it possible to suppress the content of CFMAIL? I am sending pages to end-users, and they don't need to see From:[EMAIL PROTECTED], Subject:, something that kinds of known stuff. I'm not sure I understand the question? If you don't include a from address, your mail isn't going to get very far. -Justin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: zipping and unzipping a string
in this application a couple extra MS does count. for a faster way to use a combination of a varchar data type with compression in the application level to shave off a couple more MS. Don't you think that running a compress/decompress routine on the data is going to negate those few ms you save on the database side anyway? I would think it would actually take longer, actually. Just my $0.02. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221155 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: querying for dates mssql.
I need a query that will return all records that are set to expire ( column name toexpire - which is just a date ) in the next 7 days. select * from mytable where toexpire ??? WHERE toexpire getdate() AND toexpire = DATEADD(dd, 7, getdate()) -Justin Scott ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221011 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: godaddy.com now has CFMX7 hosting!
Godaddy now has it as an add on for $1.95 to their already ridiculously low $3.95 a month All I could find on their site was a checkbox on the order form with a small pop-up window telling you what ColdFusion is. There is no mention of any kind of database access, what tags/functions are enabled/disabled, or anything else like that. I'd imagine it's crippled to the point of being useless for most of us, unfortunately. -Justin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221050 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: godaddy.com now has CFMX7 hosting!
Really? Where did you find that information Charlie? I checked their FAQ and they do have a bit more information in there. I'm surprised that the object tags is all they disabled, but they're probably sandboxing the accounts. If you have a database plan you can even create a DSN and hook up with that. Dang... I could host most of my customers there and save quite a bit. -Justin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
