RE: Handling invalid recipient in mailing list
Thanks so much to all and to Mike and William, I will be putting your advice on the top of my list of things to do. The list in question has approximately 5,500 names but, by the time it is cleaned up, will probably be closer to 5,000. The idea of not disturbing subscribers unnecessarily is most attractive. Thanks again. Dave -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Thursday, April 2, 2015 7:32 PM To: cf-talk Subject: RE: Handling invalid recipient in mailing list Dave, You could have your code 'automatically' scrub the list and use a 'log' to keep track of the changes. This way you won't have to do a test run. Also, you could set up your code on a 'dummy' email server that will send the email but trap it prior to being mailed, this way you don't have to bother your recipients list. Also, you could create an email validation loop so that you can 'verify' the list without the concern for sending an email out at all (instead of doing a 'cfmail' tag, you would do the validation of the email address). I don't know how large your recipient's list is, but I would try to not bother them with testing emails. Just my 2 pence, William -- William Seiter -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Thursday, April 02, 2015 3:55 PM To: cf-talk Subject: RE: Handling invalid recipient in mailing list Thanks to all. The scheme worked perfectly. Next I will have to warn my recipients that a test is coming so I can remove invalid recipients. Unless maybe you can suggest a method to delete them as they occur. I intend to add a confirmation message requirement to our contact form, which should have been there all along, but a means of automatically cleaning the existing mailing list would help everyone... me most of all though. Thanks again for your help. Dave Long -Original Message- From: Rick [mailto:cfh...@kchost.net] Sent: Thursday, April 2, 2015 5:20 PM To: cf-talk Subject: RE: Handling invalid recipient in mailing list cftry Run you CFMAIL.. cfcatchMark email bad in database/cfcatch /cftry -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Thursday, April 02, 2015 5:12 PM To: cf-talk Subject: Handling invalid recipient in mailing list I am trying to send a mass mailing to a somewhat carelessly created list of contacts using e-mail addresses which were not verified at the time of entry. Whenever the cfloop tag comes to an erroneous recipient, it quits and throws an error. Is there anything I can do to the code to make it keep going? Here's the code: CFLOOP list=#Form.SelectedRecipients# index=Recipient CFMAIL from=#Form.Sender# to=#Recipient# subject=#Form.Subject# type=HTML htmlheadlink rel=stylesheet href=http://www.northgoods.com/global.css; type=text/css //headbody bgcolor=black table width=800 align=center TR TD align=center colspan=2 table width=800 align=center border=4 cellpadding=10 bgcolor=blacktrtd strongfont face=Arial size=+1 color=##FF6600 #Form.Message# /font/strong /td/tr/table table align=center trth colspan=2strongfont face=Arial size=-1 color=##FF6600If you would like to be removed frombrour mailing list, please click here:/font/strongbr a href=http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#; title=UNSUBSCRIBEfont face=Arial size=-1 color=whitestrongUNSUBSCRIBE/strong/font/abr font face=Arial size=-1 color=##FF6600You will receive one last message from us to confirm your removal from our list./font/strong/th/tr /TABLE/body/html /CFMAIL /CFLOOP ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Handling invalid recipient in mailing list
I am trying to send a mass mailing to a somewhat carelessly created list of contacts using e-mail addresses which were not verified at the time of entry. Whenever the cfloop tag comes to an erroneous recipient, it quits and throws an error. Is there anything I can do to the code to make it keep going? Here's the code: CFLOOP list=#Form.SelectedRecipients# index=Recipient CFMAIL from=#Form.Sender# to=#Recipient# subject=#Form.Subject# type=HTML htmlheadlink rel=stylesheet href=http://www.northgoods.com/global.css; type=text/css //headbody bgcolor=black table width=800 align=center TR TD align=center colspan=2 table width=800 align=center border=4 cellpadding=10 bgcolor=blacktrtd strongfont face=Arial size=+1 color=##FF6600 #Form.Message# /font/strong /td/tr/table table align=center trth colspan=2strongfont face=Arial size=-1 color=##FF6600If you would like to be removed frombrour mailing list, please click here:/font/strongbr a href=http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#; title=UNSUBSCRIBEfont face=Arial size=-1 color=whitestrongUNSUBSCRIBE/strong/font/abr font face=Arial size=-1 color=##FF6600You will receive one last message from us to confirm your removal from our list./font/strong/th/tr /TABLE/body/html /CFMAIL /CFLOOP ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Handling invalid recipient in mailing list
Thanks to all. The scheme worked perfectly. Next I will have to warn my recipients that a test is coming so I can remove invalid recipients. Unless maybe you can suggest a method to delete them as they occur. I intend to add a confirmation message requirement to our contact form, which should have been there all along, but a means of automatically cleaning the existing mailing list would help everyone... me most of all though. Thanks again for your help. Dave Long -Original Message- From: Rick [mailto:cfh...@kchost.net] Sent: Thursday, April 2, 2015 5:20 PM To: cf-talk Subject: RE: Handling invalid recipient in mailing list cftry Run you CFMAIL.. cfcatchMark email bad in database/cfcatch /cftry -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Thursday, April 02, 2015 5:12 PM To: cf-talk Subject: Handling invalid recipient in mailing list I am trying to send a mass mailing to a somewhat carelessly created list of contacts using e-mail addresses which were not verified at the time of entry. Whenever the cfloop tag comes to an erroneous recipient, it quits and throws an error. Is there anything I can do to the code to make it keep going? Here's the code: CFLOOP list=#Form.SelectedRecipients# index=Recipient CFMAIL from=#Form.Sender# to=#Recipient# subject=#Form.Subject# type=HTML htmlheadlink rel=stylesheet href=http://www.northgoods.com/global.css; type=text/css //headbody bgcolor=black table width=800 align=center TR TD align=center colspan=2 table width=800 align=center border=4 cellpadding=10 bgcolor=blacktrtd strongfont face=Arial size=+1 color=##FF6600 #Form.Message# /font/strong /td/tr/table table align=center trth colspan=2strongfont face=Arial size=-1 color=##FF6600If you would like to be removed frombrour mailing list, please click here:/font/strongbr a href=http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#; title=UNSUBSCRIBEfont face=Arial size=-1 color=whitestrongUNSUBSCRIBE/strong/font/abr font face=Arial size=-1 color=##FF6600You will receive one last message from us to confirm your removal from our list./font/strong/th/tr /TABLE/body/html /CFMAIL /CFLOOP ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfmail causing problems for our server
My customer's site allows interested visitors to subscribe to intermittent e-mail notifications regarding his annual event. My hosting provider tells me that use of cfmail to contact his 5,000+ mailing list is triggering blacklisting when we use it to notify subscribers of event changes and additions. He (the hosting provider) insists we use a third party e-mail service instead. Can anyone recommended such a service that can be trusted not to resell the DB? Thank you. Dave Long NorthGoods Merchant Services ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmail causing problems for our server
Thanks, everyone. I'll check them out. -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Wednesday, December 10, 2014 12:42 PM To: cf-talk Subject: RE: cfmail causing problems for our server I use and like mail chimp Rob Sent from my Verizon Wireless 4G LTE smartphone div Original message /divdivFrom: Dave Long d...@northgoods.com /divdivDate:12/10/2014 12:23 PM (GMT-06:00) /divdivTo: cf-talk cf-talk@houseoffusion.com /divdivSubject: cfmail causing problems for our server /divdiv /div My customer's site allows interested visitors to subscribe to intermittent e-mail notifications regarding his annual event. My hosting provider tells me that use of cfmail to contact his 5,000+ mailing list is triggering blacklisting when we use it to notify subscribers of event changes and additions. He (the hosting provider) insists we use a third party e-mail service instead. Can anyone recommended such a service that can be trusted not to resell the DB? Thank you. Dave Long NorthGoods Merchant Services ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: setting up team games
Cool! Now, how about brackets for a single elimination tournament beginning with the sweet sixteen? (Or has this already been posted?) Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, February 4, 2014 3:30 PM To: cf-talk Subject: RE: setting up team games I think I figured something out. I found this chunk of code on Ray's blog. http://www.raymondcamden.com/index.cfm/2009/11/17/Ask-a-Jedi-Round-robin-dis play-of-data Thank you Ray as always! And tweaked it out to model the table structure of a round robin schedule. http://en.wikipedia.org/wiki/Round-robin_tournament Now I just need to take it and convert it to a query object or something like that so I can ask it Team 1 plays who in the 4th round? !--- team names --- cfset data = [ [team1, team2, team3, team4, team5, team6, team7, team8, team9, team10] ] !--- number of rounds to play --- cfset rounds = 12 cfscript function render(arr) { for(var i=1; i=arrayLen(arr); i++) { for(var x=1; x=arrayLen(arr[i]); x++) { writeOutput(arr[i][x] ); } } } /cfscript cfoutput #render(data)# p/ /cfoutput cfloop from=1 to=#variables.rounds# index=ii cfset movingItem = data[1][1] cfset arrayDeleteAt(data[1],1) cfset arrayAppend(data[1], movingItem) cfoutput #render(data)# p/ /cfoutput /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Snippets tab is hiding
Using Macromedia Homesite+ I have no idea why but the snippets tab at the bottom of my resource window suddenly disappeared. Under View, Resource Windows all choices are grayed out. Can anyone tell me what might have happened? Dave Long NorthGoods ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Creating maps with CF
Can anyone suggest a link to a good tutorial on setting up an app to create either a Google or Bing map populated by a MySQL db using ColdFusion? (for real estate purposes) I've tried going to their sites (Google, Bing) but it seems you have to have been born knowing the terminology to find the correct instructions. Thanks, Dave Long --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating maps with CF
Well, you folks really come through every time! It's going to take a bit to go through all this but it sure gets me off the ground. Thanks so much to you all. Dave -Original Message- From: Jon Clausen [mailto:jon_clau...@silowebworks.com] Sent: Tuesday, December 3, 2013 4:49 PM To: cf-talk Subject: Re: Creating maps with CF I developed an app a few years back that made pretty extensive use of custom data mapping for points and areas. I found the cleanest way to deal with loading the data was through AJAX calls to an API, while developing your javascript libraries independently. Otherwise, you end up bringing a whole bunch of inline JS in to your views and couple them too tightly with the map API. Once you set up your API to deliver XML or JSON, you can use the standard Google Maps API methods to add the points, map boundaries, etc like so. I used a spatial database and then converted the point and geometry values to lat/lon floats. Note that the JS below uses XML, is missing some of the custom marker variables which were set earlier in the JS library. It was also written for an earlier version of the API. HTH, Jon - script type=text/javascript // = Start with an empty GLatLngBounds object = var bounds = new GLatLngBounds(); // getXML var request = GXmlHttp.create(); request.open(GET, api_xml, true); request.onreadystatechange = function() { //If we have loaded the XML if (request.readyState == 4) { //Kill our loading message and show the notes again $(#load-msg).slideUp(fast,function(){$(#load-msg).remove();$(.note). slideDown(normal);}); var xmlDoc = request.responseXML; // obtain the array of markers and loop through it var markers = xmlDoc.documentElement.getElementsByTagName(wpt); for (var i = 0; i markers.length; i++) { // obtain the attribues of each marker var actMarker = markers[i]; var lat = parseFloat(actMarker.getAttribute(lat)); var lng = parseFloat(actMarker.getAttribute(lon)); var point = new GLatLng(lat,lng); var html = GXml.value(actMarker.getElementsByTagName(desc)[0]); var label = GXml.value(actMarker.getElementsByTagName(name)[0]); var link = a class=\detail-link\ href=\+GXml.value(actMarker.getElementsByTagName(link)[0])+\View Detail/a; var append = ul class=\geo\li class=\lat\Latitude:abbr title=\+lat+\ class=\latitude\+lat+/abbr/lili class=\lon\Longitude:abbr title=\+lng+\ class=\longitude\+lng+/abbr/li/ul; html = p class=\gmap-label\+html+append+/p; label = label+link; // create the marker var marker = createMarker(point,label,html); map.addOverlay(marker); // Each time a point is found, extent the bounds of the map = bounds.extend(point); } // = determine the zoom level from the bounds = map.setZoom(map.getBoundsZoomLevel(bounds)); // = determine the centre from the bounds == var clat = (bounds.getNorthEast().lat() + bounds.getSouthWest().lat()) /2; var clng = (bounds.getNorthEast().lng() + bounds.getSouthWest().lng()) /2; map.setCenter(new GLatLng(clat,clng)); } } /script - On Dec 3, 2013, at 9:58 AM, Dave Long d...@northgoods.com wrote: Can anyone suggest a link to a good tutorial on setting up an app to create either a Google or Bing map populated by a MySQL db using ColdFusion? (for real estate purposes) I've tried going to their sites (Google, Bing) but it seems you have to have been born knowing the terminology to find the correct instructions. Thanks, Dave Long --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating maps with CF
Wow, you folks really come through every time! It's going to take a bit to go through all this but it sure gets me off the ground. Thanks so much to you all. Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF/Railo development environment
Please accept my apology for re-asking a question I know I've asked before. My XP machine died and took my archived e-mails with it to hard drive heaven (or hell as may be.) I've used Homesite+ for the last ten or twelve years but now, having been dragged kicking and whining onto Windows 8.1, I'm in desperate need of a new environment. By charging $299.00 for CF Builder, Adobe is obviously intent on eliminating hobbyists such as myself from the marketplace. I only host about 40 sites, of which less than 20 are CF, so expensive software, no matter how elaborate, is just not practical for me. Is there a less expensive alternative that would still include niceties such as tag completion, snippets, tool bars and, most importantly, RDS capability with wizards for commonly used code like record viewers, etc.? Thank you! Dave Long NorthGoods Merchant Services http://www.northgoods.com --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Curmudgeon painted in a corner
Winston Churchill: A fanatic is one who can't change his mind and won't change the subject. Get back to work please. ;-) Dave -Original Message- From: Mark Drew [mailto:mark.d...@gmail.com] Sent: Monday, March 18, 2013 8:10 AM To: cf-talk Subject: Re: Curmudgeon painted in a corner + 1 for this. There are very few things I even need my Windows VM for (at the moment, I use it for testing installers. ) . Not sure how a mac would own you, I would guess in the same way a windows machine would too? You don't need to know the terminal but it is damn awesome once you start using it a lot more. Back to the original question, I would say use Sublime Text 2 and first thing to do is install package manager. Also, here are a few videos that might help you get started with Sublime: http://www.youtube.com/watch?v=TZ-bgcJ6fQo Hope that helps! Mark Drew On 18 Mar 2013, at 13:04, Bruce Sorge sor...@gmail.com wrote: I don't understand the statement of a Mac owning me. I was a windows user since it first came out and a DOS user before then. In switched to a Mac about a year ago and I love it. I have CF10 running with apache, MySQL and php all working great. Using Adobe creative cloud for dev and I have no complaints. Once you get used to working in the terminal macs are easy to use and my machine in no way owns me. Just saying. And for the occasional instance where I HAVE to use windows, I have windows 8 running with bootcamp. No complaints and Windows 8 screams on the Mac. Having 8 gigs of RAM helps too. Bruce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Curmudgeon painted in a corner
I've been using Homesite 5 on my Compaq laptop since a year or two before Y2K was scary. Now the old hoss is reluctant to boot (takes about 30 minutes or more) so I'm kind of forced to get a new machine. Problem: new ones all come with Windows 8 so it looks like I'll be buying (unless I can find freebies) some new development tools. My server host is moving to Railo to avoid doubling my fees, so what do you folks recommend for CF development environment? Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Curmudgeon painted in a corner
Thanks everyone, I checked out Sublime Text 2 and even watched a couple sessions of the tutorials offered. I'm sold. One neat thing... They say you can install it on more than one computer with only one license. Now that's pretty civilized of them. Cameron, thanks anyway. I want to own the machine, not have the machine own me. Thanks again. Dave -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Sunday, March 17, 2013 9:30 PM To: cf-talk Subject: Re: Curmudgeon painted in a corner On Sun, Mar 17, 2013 at 6:05 PM, Dave Long d...@northgoods.com wrote: Problem: new ones all come with Windows 8 I have to say I am disappointed that no-one has yet said, with a sh*t eating grin on their face: New Macs do not come with Win 8 -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need help finding new CF Hosting
I'm trying to find a CF Hosting provider with 24/7 support and allows code such as CFILE plus access to the CF Administrator so I can add ODBC sources timely. Any suggestions? Dave Long NorthGoods Merchant Services ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need help finding new CF Hosting
Thanks to everyone for such a quick response. Now comes the hard part... Making a choice. I'm just a bit confused when Russ said ODBC datasources don't work with CF. I've been using them for more than 10 years. Thanks again. Dave -Original Message- From: Anthony Doherty [mailto:anthony...@gmail.com] Sent: Tuesday, December 18, 2012 9:58 AM To: cf-talk Subject: Re: Need help finding new CF Hosting flinthosts.co.uk are great in the UK and their support is very quick also On 18 December 2012 15:32, Dave Long d...@northgoods.com wrote: I'm trying to find a CF Hosting provider with 24/7 support and allows code such as CFILE plus access to the CF Administrator so I can add ODBC sources timely. Any suggestions? Dave Long NorthGoods Merchant Services ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need help finding new CF Hosting
You are correct in assuming I've been using CF5. If I move to a newer version will my MySQL DBs stop working? Dave -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, December 18, 2012 12:28 PM To: cf-talk Subject: Re: Need help finding new CF Hosting But that's a bridge from jdbc to odbc, not native odbc. If you simply create an odbc dsn in windows, you wont be able to use it without a bridge. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Dec 18, 2012 5:51 PM, Dave Watts dwa...@figleaf.com wrote: If your using odbc them ypu must be on coldfusion 5 or older, as cf runs on java since cf6 and java uses jdbc. CF includes a JDBC-ODBC bridge, called SequeLink, licensed from DataDirect Technologies. I believe that CF 10 still includes this, and know that CF 9 does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Way OT: Funny video
Congrats to him! He's not waiting in some welfare line. -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Friday, January 27, 2012 3:31 PM To: cf-talk Subject: Re: Way OT: Funny video On Fri, Jan 27, 2012 at 2:29 PM, Brook Davies cft...@logiforms.com wrote: Its Friday, so don't hate: If you haven't seen this, you need to. Its an oldie but a goody: http://www.youtube.com/watch?v=zV0OgsRK0Bc Good stuff. This guy lives in Atlanta and the video was filmed in my neighborhood (Little 5 Points, specifically). This thing got him hired by an agency very quickly. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How many products in a specific category?
Well, I think you've put me on the right track, so thank you very much. I'm going to read up on CFLOOP in the book. Thanks again. Dave Long NorthGoods Merchant Services http://www.northgoods.com Maybe not the most efficient way but you can loop through the GetCategories query and within each iteration of the loop get the associated product count using another query. Not tested but this should work: cfloop query=GetCategories cfquery name=GetProducts datasource=XYZ SELECT Products.ID, Products.CATEGORY FROM products WHERE Products.CATEGORY = #GetCategories.Categories.ID# /cfquery cfoutputGetCategories.CATEGORY ( #GetPorducts.RecordCount # )/cfoutput /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How many products in a specific category?
Eureka!! A few minor modifications and your code worked like a charm. Not only did the code work but I learned more about Aggregate Functions and GROUP BY, (page 174 of Mastering...) Thanks so much to Aaron, Leigh, Akos and Jacob for your assistance. Dave You should be able to just do this in one query. Syntax for the query might be dependent upon what database you are using though. But something like this general syntax should work: SELECT C.ID, C.CATEGORY, C.RANK, COUNT(P.ID) CNT FROMCATEGORIES C LEFT OUTER JOIN PRODUCTS P ON C.CATEGORY = P.CATEGORY GROUP BY C.ID, C.CATEGORY, C.RANK ORDER BY C.RANK Then you can loop over the results, display your category and rank then within the parenthesis you output the CNT for the count of products for that category. I'd personally avoid putting a query within a loop, it might be okay for this but can be a very bad habit to get into. Aaron On Wed, Dec 21, 2011 at 11:17 AM, Dave Long d...@northgoods.com wrote: Well, I think you've put me on the right track, so thank you very much. I'm going to read up on CFLOOP in the book. Thanks again. Dave Long NorthGoods Merchant Services http://www.northgoods.com Maybe not the most efficient way but you can loop through the GetCategories query and within each iteration of the loop get the associated product count using another query. Not tested but this should work: cfloop query=GetCategories cfquery name=GetProducts datasource=XYZ SELECT Products.ID, Products.CATEGORY FROM products WHERE Products.CATEGORY = #GetCategories.Categories.ID# /cfquery cfoutputGetCategories.CATEGORY ( #GetPorducts.RecordCount # )/cfoutput /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How many products in a specific category?
Thanks, Aaron. I handled that with a conditional: cfoutput query=GetCategories li type=squarea href=productitems.cfm?RecordID=#ID_Field##CATEGORY# CFIF ProductCount GT 0(#ProductCount#)/CFIF/a/libr /cfoutput See it in action at http://www.ireallywantstuff.com/categories.cfm The site is far from complete but I'm after it. Happy Holidays! Dave -Original Message- From: Aaron Rouse [mailto:aaron.ro...@gmail.com] Sent: Wednesday, December 21, 2011 3:38 PM To: cf-talk Subject: Re: How many products in a specific category? BTW, I did a left outer join in my example for if you ever have categories with zero products. Forgot to clarify that point earlier. Glad to hear you have things working out for your needs. Aaron On Wed, Dec 21, 2011 at 1:34 PM, Dave Long d...@northgoods.com wrote: Eureka!! A few minor modifications and your code worked like a charm. Not only did the code work but I learned more about Aggregate Functions and GROUP BY, (page 174 of Mastering...) Thanks so much to Aaron, Leigh, Akos and Jacob for your assistance. Dave You should be able to just do this in one query. Syntax for the query might be dependent upon what database you are using though. But something like this general syntax should work: SELECT C.ID, C.CATEGORY, C.RANK, COUNT(P.ID) CNT FROMCATEGORIES C LEFT OUTER JOIN PRODUCTS P ON C.CATEGORY = P.CATEGORY GROUP BY C.ID, C.CATEGORY, C.RANK ORDER BY C.RANK Then you can loop over the results, display your category and rank then within the parenthesis you output the CNT for the count of products for that category. I'd personally avoid putting a query within a loop, it might be okay for this but can be a very bad habit to get into. Aaron On Wed, Dec 21, 2011 at 11:17 AM, Dave Long d...@northgoods.com wrote: Well, I think you've put me on the right track, so thank you very much. I'm going to read up on CFLOOP in the book. Thanks again. Dave Long NorthGoods Merchant Services http://www.northgoods.com Maybe not the most efficient way but you can loop through the GetCategories query and within each iteration of the loop get the associated product count using another query. Not tested but this should work: cfloop query=GetCategories cfquery name=GetProducts datasource=XYZ SELECT Products.ID, Products.CATEGORY FROM products WHERE Products.CATEGORY = #GetCategories.Categories.ID# /cfquery cfoutputGetCategories.CATEGORY ( #GetPorducts.RecordCount # )/cfoutput /cfloop ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How many products in a specific category?
Sorry to bother you folks with what is likely to be a very primitive problem but I've poured over my copy of Mastering ColdFusion 5 with no success. I have a list of categories which is queried from a table called Categories. I have another table called products and it shares a common field named Category with the Categories table. In the template that displays the list of categories, I would like to include a parenthesis after the category name that displays the number of products entered in the products table with that category name. Here are the queries I'm using that aren't working. I can get the list of categories but the product count stops after one category. CFQUERY name=GetCategories dataSource=XYZ SELECT Categories.ID, Categories.CATEGORY, Categories.RANK, Categories.CATEGORY AS ID_Field FROM Categories ORDER BY Categories.RANK /CFQUERY CFQUERY name=GetProducts dataSource=XYZ SELECT Products.ID, Products.CATEGORY FROM Products WHERE Products.CATEGORY = #GetCategories.Category# /CFQUERY cfinclude template=Header.htm table align=center cellpadding=10 cellspacing=0 border=0tr td align=centerh3Browse by Category:/h3/td/tr tr ul td cfoutput query=GetCategories li a href=productitems.cfm?RecordID=#ID_Field##Category#/a (#GetProducts.RecordCount#)/li br /cfoutput /td/ul/tr br /table cfinclude template=Footer.htm I'm using MySQL 3.51 and CF5.0 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Mailing list maintenance.
I have a customer who has a modest opt-in mailing list of approx. 4,000 subscribers that have been added to a MySQL DB via a CF enabled contact form. Since the list pertains to a once-a-year event, he does not utilize the list until a month or two before the event and perhaps once or twice afterwards. As you might guess, over the year long interim, two or three hundred addresses become invalid annually. Now, please don't laugh at the ignorance of my process because I'm here to be educated. In order to prevent accumulation of bad e-mails, I open each individual failure notice, bring up the attached original message, scroll to the bottom to click the Unsubscribe link which activates a delete query for that specific e-mail address, (which also displays an acknowledgement page,) close the page, close the attachment, and finally, delete the notice. (Whew!) Repeating this action several hundred times is a real time waster. Does anyone in this illustrious group have an idea how this house cleaning could be automated with ColdFusion (or otherwise)? One really tough part of the problem is that the failure notices are not a consistent form... various servers use varied formats. BTW, if it matters, I'm using a CF5 server with MySQL 3.51 on a Linux system. Thanks for considering this problem. Dave Long NorthGoods Merchant Services http://www.northgoods.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: why is cf_builder so expensive?
I do appreciate the assistance I have received from members of this group but overpriced goods squeeze the cynicism out of my pores. It seems defenders of Adobe's pricing like to compare the cost of CFB to tools used by carpenters, plumbers and mechanics. However, that comparison is invalid because there is only a small reduction of manufacturing costs as volume of real world tool sales increases. Margin does not necessarily increase as more units are sold. This is not true of software which, once developed, has only minute costs involved as more copies are sold. Margin increases rapidly and thus the software could be priced at one half the price and sales might double with margin remaining intact, increasing at a slower rate perhaps but increasing none the less. Oh well, they were told at Harvard that greed is good! Bill Gates set the standard and they all want to be him at the expense of their customers. Why settle for being millionaires when you can soak your customers and be billionaires. Another factor in Adobe's pricing is to discourage entry as much as possible. This approach has been used by AutoDesk since the 1990s and prevents a lot of architect wannabees carpenters from designing the buildings they build. With CFNL as simple as it is, every high school senior in the country might be jumping into data driven design. Perhaps the folks at Adobe even want to kill it off, judging by the price charged for their Enterprise version. Time to learn PHP, I guess. Dave -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, January 26, 2011 3:15 PM To: cf-talk Subject: Re: why is cf_builder so expensive? It would be nice if unicorns shit rainbows too. Well, you can get unicorn meat:) http://www.thinkgeek.com/caffeine/wacky-edibles/e5a7/ I don't know. Look at where those rainbows are in the meat chart. I think I covered that in my initial statement. I always choose my words carefully. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Counting photos on a remote server
Our server use ColdFusion 5 and MySQL 3.51. My application displays photos stored on a server remote from the server on which the app is hosted. The number of photos varies from one to twenty. The image files are named using a constant ID number plus a sequential number for each file, like this: 12345_p01.jpg, 12345_p02.jpg, and so on in order to relate them to a specific record on my server. My problem is this: I want to create a slide show of these photos but if there are only two photos, not twenty, how can I end the slide show after only two have been called for? If the files were on my server, I could use a conditional FileExists but that doesn't work for a remote server. Does anybody have a suggestion? (Please keep it G rated.) Dave Long -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Counting photos on a remote server
Thanks to all for your responses. I'm going to try Mack's suggestion first and see how it integrates into my app. Our old motto: Laborare Debit (It should work!?) Dave Long NorthGoods Merchant Services http://www.northgoods.com -Original Message- From: Mack [mailto:mrsmith.w...@gmail.com] Sent: Wednesday, December 15, 2010 10:29 AM To: cf-talk Subject: Re: Counting photos on a remote server Does anybody have a suggestion? (Please keep it G rated.) You can use HEAD requests to verify that the images exists and cache the results of the tests locally, something like: cfloop condition=remoteFile exists cfhttp method=head url=remoteFile cfif (cfhttp.statusCode eq 404) // file does not exist, break the loop cfbreak cfelse // file exist, try next one remoteFile = next remoteFile /cfif /cfloop application.lastFileThatExists = remoteFile -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
using CF to eliminate old Real Estate photos
I program and host for about 15 Real Estate Agent/Brokers in our area using a server with CF5 installed.. The company that provides server management for our local Realtor's association sends a zipped file of modified photos to my server each night. The file contains new listings and updated photos for existing listings but does not address the problem of accumulating expired or sold listings. Even if I set the directory capacity to 3 GB, sooner or later the directory will fill up. Therefore, I have to come up with a scheme to remove the out-of-date photos to avoid reaching the directory's maximum allowed space. So far, I have succeeded in creating a complete list of current MLS numbers from the multiple tables this provider uses (query name: GetAll) and a complete list of files contained in the images directory (using CFDIRECTORY name = Photos.) Both of these queries produce exactly the data I expect. However, I believe the hitch in my get-along comes from the file naming convention used by the provider. They allow 12 photos per listing and name each of photo by adding a letter to the end of the MLS number, so that photos for MLS # 9 are named 9a, 9b, and so on. Well, I thought I had it figured out. I tried to create a list of unmatched files using this query: CFQUERY name=GetUnmatched dataSource=#DSN# SELECT Name FROM Photos WHERE %Name% NOT IN (cfqueryparam value=#valueList(GetAll.MLS_Number)# cfsqltype=cf_sql_integer list=true) ORDER BY Name /CFQUERY and then use a CFFILE tag to delete the records found in the unmatched list. However, I get an error when I run it. You can give it a try at http://www.newnorthrealestate.com/GetMLSnew.cfm ( It takes a while to generate the lists and you'll have to scroll way down to see the error message) Question: Can the wildcard % be used they way I have them in the GetUnmatched query? Is there a correct method for parsing the file names in the photo directory and then doing the comparison? Am I on the right track at all? Thanks for taking a look at this. Dave -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: using CF to eliminate old Real Estate photos
Thanks for the info, Rick but unfortunately, the MLS numbers currently vary between five and six digits. If that Real Estate market stays this bad, they may go to seven or eight digit numbers. However, is it possible to create a list from the query Photos and Remove a character from the right side of the field? Thanks again. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Tuesday, July 21, 2009 4:24 PM To: cf-talk Subject: RE: using CF to eliminate old Real Estate photos Without being able to test it since I use MySQL instead of SQL server, I think the problem is the use of %Name% in that manner. You might try taking your MLS number query, GetAll, and loop or output that over a second query, deleting the photo if its name isn't found. cfoutput query = GetAll cfquery name = selectMatchingImage datasource=#dsn# selectname from photos where left(name, 5) = '#GetAll.mlsNumber#' /cfquery cfif selectMatchingImage.recordCount eq 0 cffile action = delete file = #expandPath('/photos/#selectMatchingImage.name#')# /cfif /cfoutput That works with MySQL 5. You'd need an equivalent for SQL Server for the left(name, 5) if that doesn't work. This also assumes that the MLS numbers are always the first 5 digits, and not more or less. Hope this helps somehow... Rick -Original Message- From: Dave Long [mailto:d...@northgoods.com] Sent: Tuesday, July 21, 2009 4:06 PM To: cf-talk Subject: using CF to eliminate old Real Estate photos I program and host for about 15 Real Estate Agent/Brokers in our area using a server with CF5 installed.. The company that provides server management for our local Realtor's association sends a zipped file of modified photos to my server each night. The file contains new listings and updated photos for existing listings but does not address the problem of accumulating expired or sold listings. Even if I set the directory capacity to 3 GB, sooner or later the directory will fill up. Therefore, I have to come up with a scheme to remove the out-of-date photos to avoid reaching the directory's maximum allowed space. So far, I have succeeded in creating a complete list of current MLS numbers from the multiple tables this provider uses (query name: GetAll) and a complete list of files contained in the images directory (using CFDIRECTORY name = Photos.) Both of these queries produce exactly the data I expect. However, I believe the hitch in my get-along comes from the file naming convention used by the provider. They allow 12 photos per listing and name each of photo by adding a letter to the end of the MLS number, so that photos for MLS # 9 are named 9a, 9b, and so on. Well, I thought I had it figured out. I tried to create a list of unmatched files using this query: CFQUERY name=GetUnmatched dataSource=#DSN# SELECT Name FROM Photos WHERE %Name% NOT IN (cfqueryparam value=#valueList(GetAll.MLS_Number)# cfsqltype=cf_sql_integer list=true) ORDER BY Name /CFQUERY and then use a CFFILE tag to delete the records found in the unmatched list. However, I get an error when I run it. You can give it a try at http://www.newnorthrealestate.com/GetMLSnew.cfm ( It takes a while to generate the lists and you'll have to scroll way down to see the error message) Question: Can the wildcard % be used they way I have them in the GetUnmatched query? Is there a correct method for parsing the file names in the photo directory and then doing the comparison? Am I on the right track at all? Thanks for taking a look at this. Dave -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Finding values not in a list
I'm trying to create a page with two lists consisting of data from two different sources. The first list is a table of real estate property listings that have been processed and the second is a list of properties *remaining* to be processed. First, I obtained the processed listings: CFQUERY name=GetRecord dataSource=#DSN2 SELECT MLS_number FROM VPT ORDER BY MLS_number /CFQUERY Next I created a list from the first query: CFOUTPUT query=GetRecord CFSET list = #GetRecord.MLS_number# /CFOUTPUT To verify that the list was actually created, I ouptut the list to the screen with #list# Which produced this correct list of processed numbers: 87867 88623 89035 89094 89256 100336 100349 100506 100516 100519 100520 100521 100522 100708 100711 100713 100716 100719 100803 100804 100811 100815 100817 100868 101042 Then I tried to create a list of unprocessed listings from the other DB by comparing the MLS_Number to the list: CFQUERY name=GetResidential dataSource=#DSN1# SELECT MLS_Number FROM Residential WHERE List_Firm = #FirmID# AND MLS_Number NOT IN #list# ORDER BY MLS_Number /CFQUERY This produces the following error: ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '101042'. SQL = SELECT MLS_Number, List_Price FROM Residential WHERE List_Firm = 175 AND MLS_Number NOT IN 101042 ORDER BY MLS_Number First of all, I'm puzzled that it displays the last MLS number instread of th first. Secondly, I suspect I need to have the list separated by commas but it throws another syntax error if I include them in the CFSET tag. The results do not change whether I use single or double quotes or no quotes at all. So far, I am unable to find any other syntax for comparing the second query results to the list. Can anyone advise me? Dave Long -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Finding values not in a list
Well, that helped... I think. I added a comma to the CFSET that creates the list: CFOUTPUT query=GetRecord cfset list = #ViewField2#, #list# /CFOUTPUT Which displays: 87867, 88623, 89035, 89094, 89256, 100336, 100349, 100506, 100516, 100519, 100520, 100521, 100522, 100708, 100711, 100713, 100716, 100719, 100803, 100804, 100811, 100815, 100817, 100868, 101042, And here's the comparison query now: CFQUERY name=GetResidential dataSource=#DSN# SELECT MLS_Number FROM Residential WHERE List_Firm = #FirmID# AND MLS_Number NOT IN CFQUERYPARAM VALUE=(list) CFSQLTYPE=CF_SQL_INTEGER SEPARATOR=, ORDER BY MLS_Number /CFQUERY But now I get this error: Error Diagnostic Information VALUE Invalid data '(list)' for CFSQLTYPE 'CF_SQL_INTEGER'. Once again, I tried adding single and doublew quotes as well as # # to the (list) in the query but still get errors. What am I overlooking/ -Original Message- From: Barney Boisvert [mailto:bboisv...@gmail.com] Sent: Monday, April 06, 2009 1:09 PM To: cf-talk Subject: Re: Finding values not in a list IN requires parentheses to delimit the expression it is searching within: NOT IN (#listOfIds#) ... And use CFQUERYPARAM. Really. cheers, barneyb On Mon, Apr 6, 2009 at 11:02 AM, Dave Long d...@northgoods.com wrote: I'm trying to create a page with two lists consisting of data from two different sources. The first list is a table of real estate property listings that have been processed and the second is a list of properties *remaining* to be processed. First, I obtained the processed listings: CFQUERY name=GetRecord dataSource=#DSN2 SELECT MLS_number FROM VPT ORDER BY MLS_number /CFQUERY Next I created a list from the first query: CFOUTPUT query=GetRecord CFSET list = #GetRecord.MLS_number# /CFOUTPUT To verify that the list was actually created, I ouptut the list to the screen with #list# Which produced this correct list of processed numbers: 87867 88623 89035 89094 89256 100336 100349 100506 100516 100519 100520 100521 100522 100708 100711 100713 100716 100719 100803 100804 100811 100815 100817 100868 101042 Then I tried to create a list of unprocessed listings from the other DB by comparing the MLS_Number to the list: CFQUERY name=GetResidential dataSource=#DSN1# SELECT MLS_Number FROM Residential WHERE List_Firm = #FirmID# AND MLS_Number NOT IN #list# ORDER BY MLS_Number /CFQUERY This produces the following error: ODBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '101042'. SQL = SELECT MLS_Number, List_Price FROM Residential WHERE List_Firm = 175 AND MLS_Number NOT IN 101042 ORDER BY MLS_Number First of all, I'm puzzled that it displays the last MLS number instread of th first. Secondly, I suspect I need to have the list separated by commas but it throws another syntax error if I include them in the CFSET tag. The results do not change whether I use single or double quotes or no quotes at all. So far, I am unable to find any other syntax for comparing the second query results to the list. Can anyone advise me? Dave Long -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Finding values not in a list
Thanks everyone, but I must be trying to accomplish the impossible with our version 5 CF server. None of these suggestions has worked. I guess we're just going to have to write down which listings we've processed. Thanks again. -Original Message- From: Yuliang Ruan [mailto:yuliangr...@hotmail.com] Sent: Monday, April 06, 2009 2:53 PM To: cf-talk Subject: Re: Finding values not in a list Next I created a list from the first query: CFOUTPUT query=GetRecord CFSET list = #GetRecord.MLS_number# /CFOUTPUT This code does NOT produce a list. this only sets the list variable to the current record's MLS_number. the correct code to create a list of all the MLS_numbers in the current recordset would be: cfloop query=GetRecord cfset list=listappend(list,getrecord.MLS_number) /cfloop or equiv: cfset list=ValueList(GetRecord.MLS_number) Then I tried to create a list of unprocessed listings from the other DB by comparing the MLS_Number to the list: CFQUERY name=GetResidential dataSource=#DSN1# SELECT MLS_Number FROM Residential WHERE List_Firm = #FirmID# AND MLS_Number NOT IN #list# ORDER BY MLS_Number /CFQUERY CFQUERY name=GetResidential dataSource=#DSN1# SELECT MLS_Number FROM Residential WHERE List_Firm = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#FirmID# AND MLS_Number NOT IN (cfqueryparam cfsqltype=CF_SQL_CHAR value=#list#) ORDER BY MLS_Number /CFQUERY note the parens around the list. also swapped you over to cfqueryparam syntax ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Finding values not in a list
Charlie! You did it!!! Dahnke! ¡Gracias! Thank you! Thank you! Thank you!!! It's taken me all day to get this right. Thank goodness, I'm self-employed or I'd be looking for a new place to sit down to work. Dave -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Monday, April 06, 2009 1:13 PM To: cf-talk Subject: Re: Finding values not in a list On Mon, Apr 6, 2009 at 11:02 AM, Dave Long d...@northgoods.com wrote: So far, I am unable to find any other syntax for comparing the second query results to the list. Can anyone advise me? look into the valueList() function for getting a comma-delimited list of values from a query column. Your IN values need to be enclosed in parentheses: AND MLS_Number NOT IN (#valueList(GetRecord.MLS_number)#) ... and you'll also want to cfqueryparam that: AND MLS_Number NOT IN (cfqueryparam value=#valueList(GetRecord.MLS_number)# cfsqltype=cf_sql_integer list=true /) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using FileExists function in a CFIF tag
Thanks to all. I get it now... http://; is NOT the start of an absolute path but a URL and that's why it won't work. The photos occupy about 5 gigs of space and we were going to park them on a different server but, on second look, we've got gobs of space left on the same box as the Web site so we're just going to copy the pix over. That should solve the problem, I hope. Thanks again. Dave -Original Message- From: Yuliang Ruan [mailto:yuliangr...@hotmail.com] Sent: Monday, February 02, 2009 2:24 PM To: cf-talk Subject: Re: Using FileExists function in a CFIF tag filexists is for checking file existence on the local filesystem. not for checking out on the web. are you hosting the images? if you are, you should be doing something to effect of: cfset PhotoLocation = c:\www\htdocs\images\ cfset PhotoLocation = PhotoLocation ViewField20 cfif FileExists('#PhotoLocation#-2.jpeg')Yes, it's here.cfelseI couldn't find it./cfif /td/tr if you are not hosting the images, then you should be doing cftry cfhttp url=#photoLocation#-2.jpeg/cfhttp cfif cfhttp.responsecode contains 404 not found cfelse found cfcatch /cfcatch /cftry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using FileExists function in a CFIF tag
I am attempting to prevent broken pictures on a page displaying details regarding real estate listings. Agents are allowed to upload as many as 12 pictures of a particular listing but frequently post less than twelve. When that happens, a broken picture emblem appears, and we want to eliminate that. An example of the (not working) test page can be found at: http://www.vacationlandproperties.com/Residential_Listing.cfm?RecordID=89255 I have entered some extraneous code in order to determine that the correct path is being used, thusly: cfset PhotoLocation = http://mls.northernweb.net/images/Photo; cfset PhotoLocation = PhotoLocation ViewField20 table align=center cellpadding=1 cellspacing=0 border=0 trtd colspan=5 align=center#PhotoLocation#-2.jpegbr cfif FileExists('#PhotoLocation#-2.jpeg')Yes, it's here.cfelseI couldn't find it./cfif /td/tr As you can see at the test page, the path to the photo shows up correctly but the CFIF tag is unable to produce desired results. Any idea of what I am doing wrong? Is there a better way to test to see if a file exists in order to avoid broken pictures on the page? Thanks, Dave Long -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Ben Forta for president?
Great idea! Somebody send me the PDF for some counterfeit voter registration forms and we can start canvassing. Dave -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2008 9:16 PM To: cf-talk Subject: Ben Forta for president? Is this true? Ben Forta is running for President of the USA?? Bit of fun, but I'm really impressed with the video. Have a look http://www.tsgnet.com/pres.php?id=370617altf=Cfoaltl=Gpsub It's a bit of fun for Friday but i have serious tech question about this - how do they do the video clip? What technology are they using to create the video on the fly? I specially like the tattoo. Is this a flash application? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314335 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
I've heard that in Saudi Arabia, a thief has the offending member removed at the wrist. Since hackers commit their offence with their brain, wouldn't it be appropriate to behead them? Just a suggestion. :-\ Dave L. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2008 12:36 PM To: CF-Talk Subject: RE: SQL injection attack on House of Fusion even if it is from parasitic bottom-feeding bots created by despicable scum-sucking feeble-excuse-for-a-carbon-based-life-form repugnant socially-inept basement-dwelling death-penalty-deserving hacker-wannabes Come on, Ben! Don't hold back! Tell us how you *really* feel! :o) -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2008 11:51 AM To: CF-Talk Subject: RE: SQL injection attack on House of Fusion Yep, I turned e-mail notifications off too, leave it on and you can inadvertently turn blocking SQL injection attacks into a self-imposed DoS attack. Fun stuff. On the plus side, it's nice to see CF finally getting the recognition it deserves, even if it is from parasitic bottom-feeding bots created by despicable scum-sucking feeble-excuse-for-a-carbon-based-life-form repugnant socially-inept basement-dwelling death-penalty-deserving hacker-wannabes. --- Ben -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2008 11:41 AM To: CF-Talk Subject: Re: SQL injection attack on House of Fusion Which explains why House of Fusion is being so heavily hit. We're literally everywhere on Google. Fusion Authority on the other hand has all of its urls masked to .htm so the only one being attacked there is an old .cfm archive. I'm working on a webserver level fix for this which will bypass the need to block based on IPs. I just need a few moments. The attacks are hitting VERY hard. I got 4000 alert emails in the space of 5 minutes before I turned them off again. On Fri, Aug 8, 2008 at 11:27 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 08 Aug 2008, Scott Stewart wrote: I'm almost flattered that someone thought my site was important enough to attack... They didn't. The attack is probably driving itself based on a Google search ( [inurl:.cfm] ?) . -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.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:310554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Looking for Accomodations Software
I'm looking for a software package that will function with MySQL4.0 DB on a ColdFusion5.0 server. It would have to allow multiple accounts with user maintenance of pics of resorts' and/or hotel/motels' units, rates, and have some sort of calendar to show lodging availability of individual account units. Anyone seen anything like that? Dave Long -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| 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:308709 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 Studio 5
Thanks to all for the comments. All I was really missing was the CF documentation and I have that now. Thanks Mark! Our server is still at Version 5 so I have to avoid some of the nice tidbits from 7 and 8. Otherwise, I'm happy as a clam. (Anyway, I think they're happy.) Dave Long NorthGoods Merchant Services 103 E. Wisconsin Avenue Tomahawk, WI 54487-1471 (715) 453-7414 -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2008 3:03 AM To: CF-Talk Subject: RE: CF Studio 5 I bit the bullet and moved from CF Studio 5 to CFEclipse. I found the initial learning curve to get it all set up how I wanted was rather steep. With three months at it now, I won't be going back, but on balance I still think CF Studio 5 is hard to beat; really the only reason I'm using CFEclipse is because it's useful to have CF8 syntax (though it seems to fail on some 'original' tags like CFFILE). Richard -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 04 June 2008 23:17 To: CF-Talk Subject: Re: CF Studio 5 y'know, somebody's bound to say it... so i'll just throw out a suggestion that this might be a good time to check out eclipse and cfeclipse :) hey, if you try it and don't like it, you can always resume the search for CF Studio 5. Won't cost you anything in the interim. On Wed, Jun 4, 2008 at 3:02 PM, Dave Long [EMAIL PROTECTED] wrote: I've had to reformat my computer after 5years of faithful service. After re-installing Macromedia Studio MX, I realized it only has Homesite 5.0+. Does anyone know where I can download a copy of ColdFusion Studio 5.0? Of course, they are very similar but there seem to be some features that are different. Adobe has insulated itself rather well from users who don't upgrade so I'm hoping someone here knows of a safe download site. Dave Long NorthGoods Merchant Services 103 E. Wisconsin Avenue Tomahawk, WI 54487-1471 (715) 453-7414 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Studio 5
I've had to reformat my computer after 5years of faithful service. After re-installing Macromedia Studio MX, I realized it only has Homesite 5.0+. Does anyone know where I can download a copy of ColdFusion Studio 5.0? Of course, they are very similar but there seem to be some features that are different. Adobe has insulated itself rather well from users who don't upgrade so I'm hoping someone here knows of a safe download site. Dave Long NorthGoods Merchant Services 103 E. Wisconsin Avenue Tomahawk, WI 54487-1471 (715) 453-7414 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306847 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 Studio 5
Thanks Gerald, I understand about playing by the rules. It should be legal because I bought and paid for Macromedia Studio MX and it was they who upgraded HS 5 plus to CF Studio 5 in the first place. If anyone knows otherwise, please advise. As often happens when one corporation swallows another, the new owners only seem to care about the old company's end users if they buy their new stuff. I bought a lifetime subscription to MusicMatch Jukebox and after Yahoo bought them out, they shut down the server with the registration key info, so now I can't register the re-installed copy and it locks up trying to find it. My attorney is looking into the possibility of a class action suit but that's a long shot and highly unlikely to resolve the problem. I'll send you a direct message tomorrow after someone has had a chance to let us know if it is legal or not. Dave Long NorthGoods Merchant Services 103 E. Wisconsin Avenue Tomahawk, WI 54487-1471 (715) 453-7414 -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 6:41 PM To: CF-Talk Subject: Re: CF Studio 5 Troublemaker... :) Look Mark, you know as well as I that Charlie is a card carrying member of the CFeclipse Gestapo and is under direct orders from Herr Drew to recruit members by any and all means possible. I find your lack of faith disturbing. But yeah Dave, I have a copy of CFS 5.0 shareware on back up. Unless I am a violating some law or something I can make it available to you. Pls send me a personal email and I will get you a copy unless I am violating a law... then the deal is off (sorry... I gotta play by the rules). G$ -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert/retrieve image into database SQL Server 2005/CF8?
I do it using a unix cron job timed to retrieve, unzip and rename the files soon after they're refreshed on the remote server, then set a CF scheduled task to run about 15 minutes later that deletes the existing records and inserts the new ones from today. The CF task takes about 10 minutes or less to install about 6,000 records and I have found it a good idea to put a link to my real estate site in the Windows startup folder so I can actually eyeball the app first thing every day... it has rarely been known to fail for various reasons. But it works great almost all the time. I even have a separate site to boost links to my hosted brokers' sites and listings at http://www.northgoodsrealestate.com. I'm sure it could be designed better but at my skill level, this seems to work ok for my folks and includes a number of different methods for visitors to search for a listing. Dave Long -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 10:00 AM To: CF-Talk Subject: insert/retrieve image into database SQL Server 2005/CF8? Hi, I'm trying to insert an Image into MS SQL Server 2005 database using CF 8. I started to work with the SQL Server 'Image' data type but I'm not sure this data type is the best/correct choice. Somebody has probably done this before, so what data-type should/could I use in SQL Server - The choices include Image, binary, varbinary, and varbinary(max). Should I be using the new image tags or resorting to older methods to achieve the path of least resistance? Here is a sample of what I am working on, here I am just trying to read a file and place it in the database cffile action=READBINARY variable=ThisPicture file=/var/www/images/staffpics/#staffID#.jpg cfset myImage=ImageNew(ThisPicture) cfquery name=qryinsertImage datasource=#CMSDSN# Update tblStaff Set staffphoto = cfqueryparam value=#ImageGetBlob(myImage)# cfsqltype=cf_sql_blob Where StaffID = #staffID#; /cfquery !--- write out the image: check to make sure something works. --- cfimage action=WRITETOBROWSER source=#myImage#br I'm getting The source file should contain an extension, so that ColdFusion can determine the image format. Verify your inputs. The source file should contain an extension, so that ColdFusion can determine the image format. as an error. It isn't clear, at least to me, where I can be more specific about setting the image format - is this an error from SQL server? The manual says If you do not specify a source image, an unknown source image format error is generated, am I not pointing to my variable correctly? The examples in the manual show an insert statement and I am trying to do an update, is my query syntax messed up? My next question is obviously about getting the images out of the DB, so if there are any tricks to that, please feel free to elaborate. Many thanks, -Nate ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert/retrieve image into database SQL Server 2005/CF8?
Our server still uses CF5 (can't afford the money to buy or the time to wrestle with CF8) but it does the job for us most of the time. Here's the basic method: Your MySQL DB table is set up with appropriate fields and data types and in the sequence as required by the MLS with which you are working, i.e. MLSNumber (int)(ID_Field), bedrooms (vchar), baths(vchar), sq_ft (int), price (int), etc. (The one I work with has almost 70 fields in each of two separate tables, because they keep commercial listings separate from residential.) Once you have those set up, create and schedule your cron job in unix or whatever is appropriate scripting language for your server for the appropriate time when the new zip file will be available. If you can use CF8 to do the same thing, that is fetch the zip files, unzip them and rename them to overwrite the previous day's download, do it. I just am unaware of if or how that's done with any version of CF. I paid a local geek $20.00 to write it (10 lines of code) in unix for me and it works great. Next, create the file(s) needed to do the task(s) It can be done in one file but the more you ask the file to do, the more it is likely the server is going to time out the job. The CF Administrator can be set to allow longer times but that isn't always desirable. Better to schedule two or more tasks and use less run time for each. Here's a sample of a typical update.cfm: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUpdate the listings/title /head body !--- First, we delete the data from the reslist table --- cfquery name=removelist datasource=DNS dbtype=ODBC Delete From reslist /cfquery !--- Grab the data from the Residential text file --- cfhttp url=http://www.mysite.com/MLS/Residential.txt; method=GET name=reslist columns=AccessRoad,AppliancesChattels,Attic,BasementType,NumberofBathrooms, NumberofBedrooms,ComplexSubdivision,Construction,County,ElementarySchool,Ext eriorFeatures,ExteriorFinish,NumberofFireplaces,FireplaceStoveTypes,Flooring ,Foundation,Fuel,HighSchool,WaterHeater,MLSNumber,InteriorFeatures,ListingAg ent,ListingOffice,ListingOfficePhone,LotAcres,LotSqft,LotDepth,SiteInfluence ,LotWidth,Township,MiddleSchool,NumberofParkingSpaces,Garage,ZipCode,PriceCu rrent,PropertyType,Remarks,RoadFrontage,Roofing,UtilitiesServices,WaterFront age,Shoreline,Sqft1stFloor,Sqft2ndFloor,Sqft3rdFloor,SqftBsmt,SqftFinishedBs mt,SqftGarage,SqftTotal,NumberofStoves,Style,AmountofTaxes,Title,PhotoID,Uni tNumber,Sewer,Water,YearBuilt,Zoning,LakeorRiverName,StreetName,StreetNumber ,AgentName,AgentID,TaxYear,OriginalPrice,LakeChain,LakeAcres,DateEntered,Dat eListed,DaysOnMarket textqualifier= delimiter= resolveurl=false/cfhttp !--- Now insert that data into the reslist table --- cfoutput query=reslist cfquery name=insertres datasource=DNS dbtype=ODBC Insert into reslist Values ('#AccessRoad#','#AppliancesChattels#','#Attic#','#BasementType#','#Numberof Bathrooms#','#NumberofBedrooms#','#ComplexSubdivision#','#Construction#','#C ounty#','#ElementarySchool#','#ExteriorFeatures#','#ExteriorFinish#','#Numbe rofFireplaces#','#FireplaceStoveTypes#','#Flooring#','#Foundation#','#Fuel#' ,'#HighSchool#','#WaterHeater#','#MLSNumber#','#InteriorFeatures#','#Listing Agent#','#ListingOffice#','#ListingOfficePhone#','#LotAcres#','#LotSqft#','# LotDepth#','#SiteInfluence#','#LotWidth#','#Township#','#MiddleSchool#','#Nu mberofParkingSpaces#','#Garage#','#ZipCode#','#PriceCurrent#','#PropertyType #','#Remarks#','#RoadFrontage#','#Roofing#','#UtilitiesServices#','#WaterFro ntage#','#Shoreline#','#Sqft1stFloor#','#Sqft2ndFloor#','#Sqft3rdFloor#','#S qftBsmt#','#SqftFinishedBsmt#','#SqftGarage#','#SqftTotal#','#NumberofStoves #','#Style#','#AmountofTaxes#','#Title#','#PhotoID#','#UnitNumber#','#Sewer# ','#Water#','#YearBuilt#','#Zoning#','#LakeorRiverName#','#StreetName#','#St reetNumber#','#AgentName#','#AgentID#','#TaxYear#','#OriginalPrice#','#LakeC hain#','#LakeAcres#','#DateEntered#','#DateListed#','#DaysOnMarket#') /cfquery /cfoutput Mission accomplished! /body /html And that's it! Save the file and you should be able to set it up in the CF Administrator to run at least 15 minutes after your cron job. But check it because your MLS source files may not be available every day and when they aren't, your table will have NO records. Then you might have to get in touch with the folks at the MLS to nudge them into fixing their end. I'm sure it might be possible to have the update file check the file size of the source ..txt file before overwriting it but I don't know how to do it. If someone reads this that does, let me know. It sure could come in handy sometimes. Nate, I hope this is helpful. Like I said, I'm not familiar with any version of CF beyond CF5 and that's often a mystery to this old carpenter. Dave Long http://www.northgoods.com -Original Message
RE: insert/retrieve image into database SQL Server 2005/CF8?
My apologies, Nate. I didn't catch on that your main problem was with the images. Ours are stored on a separate server and referenced through the record ID. Since I don't deal with the images, only the listings, my job is much simpler. There's no reason I know of why you can't use something like ImageMagick to manage the images and rename them with the MLSnumber as part of the file name. Are you familiar with that? Dave Long -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 2:14 PM To: CF-Talk Subject: RE: insert/retrieve image into database SQL Server 2005/CF8? I didn't think so either... You are always a great resource Dave, any thoughts on my original question? 'http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:54861#29676 6' -Nate -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 1:54 PM To: CF-Talk Subject: RE: insert/retrieve image into database SQL Server 2005/CF8? I was hoping to avoid the tired old in-DB v. Out-of-DB conversation. Like the war between good and evil, that conversation is eternal. There's nothing wrong with storing images in a modern RDBMS. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Tags useful to accomplish automating MLS direct feed into MySQL DB?
Yes, thanks Adrian. I'll forward this info to our Sysadmin. Can MySQL 3.0 handle CSV files or does it only work in 4.0 or later? Dave -Original Message- From: Adrian Moreno [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 3:24 PM To: CF-Talk Subject: Re: Tags useful to accomplish automating MLS direct feed into MySQL DB? Regarding CF taking forever to read/parse large files: CF used to load the entire file into memory when trying to read it. It was still doing this as of CF 6 7, but since it was then easier to directly invoke Java, large files could be better handled using java.io.FileReader. http://coldfusion.sys-con.com/read/86121.htm A client of mine had a 70+Mb inventory CSV that I had to load into MySQL. On CF 4/4.5/5, this process took at least 40 minutes. When we upgraded to CF 6, I used the Java process and the import was down to less than 3 minutes. CF 8 has incorporated java.io.FileReader into CFLOOP: cfloop file=C:\\test.txt index=x / So now CF can read large files on the fly without the overhead from previous versions. Also, many people don't know that MySQL can import CSV files directly if you have the correct access: http://dev.mysql.com/doc/refman/5.0/en/load-data.html HTH, Adrian Hi, all. I assume some of you work on Real Estate sites where you have to deal with a direct feed of data from MLS's. The direct feed for one of my Real Estate sites currently in development will be in the form of an FTP site, from which I can download a zip file with all files, including a tab delimited data file for properties and photos whose name will include broker's MLS numbers so they can be matched to properties. I will then import the tab delimited info and property filenames into an MySQL database, and place the property photos into the appropriate local server directory. This is something I've never attempted before and I'd like to know, first, if it's possible to automate this process so I don't have to update everything manually each day. If it is possible to automate the process, what tags should I look to employ to carry this out. Not asking for any code (yet! :o), but just a bullet-point overview of the process. Then I can go and do some research on how to put it together. But I thought I'd just pick some experienced brains concerning the basic procedure. Remember, I'm still thinking, for the most part in CF 4.5 terms, and there will be a ton of tags and functionality I'm not even familiar with. such as, I've never written or used a CFC! :| Thanks for any feedback on tags and, especially tutorial or blogs on the subject. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: calendar event
You might find this link helpful: http://www.bennadel.com/blog/877-ColdFusion-Calendar-Event-Scripting-Inspire d-By-Peter-Bell-.htm It discusses the How-to of recurring events. What a group! You guys sound like you are terrified of helping a newbie, yet you pass code back and forth between each other without inhibition. I suppose you were all born knowing CF and SQL so you never needed help from anyone to understand the principles involved. Ravi, don't forget to try Google for answers, too. Dave Long -Original Message- From: Ravi Shankar [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 15, 2008 3:45 AM To: CF-Talk Subject: calendar event Hi , I would like your expert help in the same. I am working on a project in which i have to design the web-page for scheduling the meetings online with recurrence option also. The screen is the same as it comes in the outlook express when we schedule any meeting. It has the following fields Appointment Time Start time End time Duration Recurrence pattern -- Daily Weekly Monthly Yearly and the pattern changes based on the type which we choose Recurrence range start date No end date End after occurences End date. I need to come up with the table structures for this. Can you pls help me in designing the tables for this. Looking forward for your help. Thanks Ravi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Hosting
I've been using them for a while as well and, although their rates are great, their support is iffy. After several months of trying to get a cron job to run correctly on their server, I finally just gave up. No one there speaks English well enough to understand the problem. Then there are the features I would have to give up. My current provider is local and allows me access to the CF Administration pages in order for me to add ODBC datasources and schedule tasks. Hostnexus does not. It can take up to several days to get a new site's DB up and running. Also, my favorite MySQL DB manager, Navicat, does not work with their system. Instead, they insist on the rather primitive (by comparison) PHPMyAdmin. The 80 sites I host will not be transferred to them, even though it would cut my cost to less than 1/4 of what I pay now. There is still one site remaining on their server and I really should move it off of there and stop paying them. Dave Long -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Sunday, January 13, 2008 10:02 PM To: CF-Talk Subject: Re: OT: Hosting look at hostnexus.com and their cf plans - the basic one starts from 9.95/month. their tech support is superb. been with them for over 3years now. http://www.hostnexus.com/solutions/coldfusion.htm cfmx7 only (for now) hth --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Apple + Adobe = ??
Try to keep up, Tony. ;-) -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Monday, January 14, 2008 10:48 AM To: CF-Talk Subject: Re: Apple + Adobe = ?? i heard coldfusion was being discontinued from adobe's product lineup. On 1/14/08, Neil Middleton [EMAIL PROTECTED] wrote: To be honest,knowing the history of ColdFusion isn't it about time Adobe got bought? - we've been with the same owner for literally months now... Neil On Jan 14, 2008 4:06 PM, Billy Cox [EMAIL PROTECTED] wrote: How would it change our lives if Apple were to buy Adobe? Would this be a good thing for CF, or would it just be something that Apple gets along with the products it is *really* interested in? (such as Photoshop, Illustrator, Premiere, etc.) http://blogs.zdnet.com/BTL/?p=7571 http://blogs.zdnet.com/BTL/?p=7571tag=nl.e539 tag=nl.e539 Billy Cox Old World Spices [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Salutation in CF Mail list
I am trying to create a template to mail a newsletter to a list of members by looping thru the members table. The main purpose of using cfloop is to prevent each member from receiving the entire list of E-mail addresses in the header as well as make the message a little more personal. Is there anyway to have each copy display an individual greeting to each recipient? Naming the query in the CFOUTPUT tag, causes the whole list of names to display on every message but if eliminating the query name, only returns the first name on the list, no matter to whom the message is addressed. Any advice you can share will be greatly appreciated. Here is the code for the mail form: CFQUERY name=Recipients dataSource=DSN SELECT Members.Contact, Members.Email AS EmailField FROM Members WHERE Members.Email ORDER BY Members.Contact /CFQUERY CFINCLUDE template=admin_header.cfm div align=center FONT size=+2B Members Mailing Form/font/B /div !--- Entry form --- FORM action=Members_MailingAction.cfm method=post TABLE width=500 align=center border=0 cellspacing=0 cellpadding=10 TRTD valign=top align=rightBTo:/B/TD TD INPUT type=hidden name=SelectedRecipients_required value=You did not select any recipients SELECT name=SelectedRecipients size=5 multiple CFOUTPUT query=Recipients OPTION value=#EmailField##Contact#/CFOUTPUT OPTION value= /SELECT CFOUTPUT INPUT type=hidden name=Salute value=#Recipients.Contact# /CFOUTPUT /TD /TR TRTD align=rightBFrom:/B/TD TDINPUT type=text name=Sender size=40/TD /TR TRTD align=rightBSubject:/B/TD TDINPUT type=text name=Subject size=40/TD /TR TRTD colspan=2 TEXTAREA name=Message rows=20 cols=60/TEXTAREA /TD /TR TRTD colspan=2 align=centerINPUT type=submit value= Send /TD/TR /TABLE /FORM CFINCLUDE template=admin_footer.cfm -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Salutation in CF Mail list
Never mind. I made it work by adding a query on the action page inside the loop after the index was set to match up the current Recipient's E-mail address and grab the Contact name. Works fine now. Thanks anyway. Dave Long -Original Message- From: Dave Long [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 2:30 PM To: CF-Talk Subject: Salutation in CF Mail list I am trying to create a template to mail a newsletter to a list of members by looping thru the members table. The main purpose of using cfloop is to prevent each member from receiving the entire list of E-mail addresses in the header as well as make the message a little more personal. Is there anyway to have each copy display an individual greeting to each recipient? Naming the query in the CFOUTPUT tag, causes the whole list of names to display on every message but if eliminating the query name, only returns the first name on the list, no matter to whom the message is addressed. Any advice you can share will be greatly appreciated. Here is the code for the mail form: CFQUERY name=Recipients dataSource=DSN SELECT Members.Contact, Members.Email AS EmailField FROM Members WHERE Members.Email ORDER BY Members.Contact /CFQUERY CFINCLUDE template=admin_header.cfm div align=center FONT size=+2B Members Mailing Form/font/B /div !--- Entry form --- FORM action=Members_MailingAction.cfm method=post TABLE width=500 align=center border=0 cellspacing=0 cellpadding=10 TRTD valign=top align=rightBTo:/B/TD TD INPUT type=hidden name=SelectedRecipients_required value=You did not select any recipients SELECT name=SelectedRecipients size=5 multiple CFOUTPUT query=Recipients OPTION value=#EmailField##Contact#/CFOUTPUT OPTION value= /SELECT CFOUTPUT INPUT type=hidden name=Salute value=#Recipients.Contact# /CFOUTPUT /TD /TR TRTD align=rightBFrom:/B/TD TDINPUT type=text name=Sender size=40/TD /TR TRTD align=rightBSubject:/B/TD TDINPUT type=text name=Subject size=40/TD /TR TRTD colspan=2 TEXTAREA name=Message rows=20 cols=60/TEXTAREA /TD /TR TRTD colspan=2 align=centerINPUT type=submit value= Send /TD/TR /TABLE /FORM CFINCLUDE template=admin_footer.cfm -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe ColdFusion IDE survey
-Original Message- From: Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 08, 2008 10:19 AM To: CF-Talk Subject: RE: Adobe ColdFusion IDE survey (snip) I believe that some people need to realize that their personal must have feature is not necessarily even needed by other developers within this community. snip) I rather thought this was the impetus for the survey. My passion for CF Studio 5 is not likely to be shared by a great number of developers and therefore my plea is very likely to be passed over. However, if a significant number of participants note a particular feature for a specific tool, I'll bet Adobe will perk up and listen. Dave Long, O.F.P.W. (Old Fart Programmer Wannabe) http://www.northgoods.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe ColdFusion IDE survey
Well, I've lurked around here for several of months now and you're finally discussing a subject about which I have strong feelings. Homesite and CF Studio are the only tools I've ever used to develop Web apps. The Studio 5 CFML Wizards are great but should be easier to customize. The custom buttons for the tool bars are too restrictive (two characters? Come on!) but otherwise, I love it. It's particularly helpful when trying to make sense of a JavaScript with the code jammed together in a single line. (I use Extended replace to add a carriage return after the semicolon. It also works great for changing .css file and datasource names when re-using templates from other sites.) I plan to continue using Studio 5 as long as it works on my operating system even though I have Macromedia Studio MX. DreamWeaver MX came with a tutorial but what I needed was a cookbook, There's no time to drain the swamp when you're up to your sphincter in alligators!, so I never took the two or three weeks off required to learn it. Maybe someday, if I retire or go out of business. BTW, Ben, your ColdFusion MX - WACK is never more than a forearm's length away from me, and bless you for writing it, but it is also in the form of a tutorial, which makes digging out the moment's essential code a more time consuming effort than it could be. (See HTML, XHTML, CSS, Sixth Edition by Elizabeth Castro for a sample of the cookbook format to which I refer.) Sorry to be so wordy but my purpose in posting is pretty simple: Please, please, please, Adobe, don't take away the best darned tool I've ever owned for programming new CF apps! Dave Long, Owner, Janitor, Snake Oil Technician NorthGoods Merchant Services http://www.northgoods.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe ColdFusion IDE survey
Right, Claude! Where do I sign up? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, January 07, 2008 3:16 PM To: CF-Talk Subject: Re: Adobe ColdFusion IDE survey Please, please, please, Adobe, don't take away the best darned tool I've ever owned for programming new CF apps! How about starting a union? ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Studio Browse tab doesn't work
For some reason, I've never been able to develop mappings to preview .cfm pages in the Browse tab of CF Studio, probably because I don't have my server set up properly, but I was always able to preview static pages there. A few weeks ago, this feature stopped working and I have no idea what I might have done to cause this. I now receive an error message stating, This browser only supports local files. Can anyone tell me how to fix this? Dave -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| 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:287203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Studio Browse tab doesn't work
For some reason, I've never been able to develop mappings to preview .cfm pages in the Browse tab of CF Studio, probably because I don't have my server set up properly, but I was always able to preview static pages there. A few weeks ago, this feature stopped working and I have no idea what I might have done to cause this. I now receive an error message stating, This browser only supports local files. Can anyone tell me how to fix this? Dave -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| 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:287208 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 Studio Browse tab doesn't work
Thanks, Jerry. It took a lot of trial and error but I finally got it working... even the .cfm pages are displaying data. Great! Dave -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 11:47 AM To: CF-Talk Subject: Re: CF Studio Browse tab doesn't work You need to tell studio how to translate file paths into urls. You do this on the Debug - development mappings. On 8/27/07, Dave Long [EMAIL PROTECTED] wrote: For some reason, I've never been able to develop mappings to preview .cfm pages in the Browse tab of CF Studio, probably because I don't have my server set up properly, but I was always able to preview static pages there. A few weeks ago, this feature stopped working and I have no idea what I might have done to cause this. I now receive an error message stating, This browser only supports local files. Can anyone tell me how to fix this? Dave -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMyAdmin
It's not free but Navicat is a terrific MySQL tool. Check it out at http://www.navicat.com/ Dave -Original Message- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Sunday, May 13, 2007 8:00 PM To: CF-Talk Subject: Re: CFMyAdmin Anybody? I'm trying to find a tool to manage my MySQL server remotely with the same ease phpMyAdmin provides. Any push in the right direction would be great. I would install php, but I want to keep my server overhead to a minimum. Steve Good wrote: Has CFMyAdmin disappeared? The cfmyadmin.com site says there is no site configured for that domain. Has it moved or is there something else out there that is similar? Thanks! Steve ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4