RE: Handling invalid recipient in mailing list

[Dave Long]

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




 Run you CFMAIL..

  Mark email bad in database 



-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:



http://www.northgoods.com/global.css"; type="text/css" />





#Form.Message#



If you would like to be removed fromour mailing list,
please click here:
http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#";
title="UNSUBSCRIBE">UNSUBSCRIBE
You will receive one last
message from us to confirm your removal from our
list. 












~|
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

RE: Handling invalid recipient in mailing list

[Dave Long]

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




 Run you CFMAIL..

  Mark email bad in database 



-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:



http://www.northgoods.com/global.css"; type="text/css" />





#Form.Message#



If you would like to be removed fromour mailing list,
please click here:
http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#";
title="UNSUBSCRIBE">UNSUBSCRIBE
You will receive one last
message from us to confirm your removal from our
list. 








~|
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

Handling invalid recipient in mailing list

[Dave Long]

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:



http://www.northgoods.com/global.css"; type="text/css" />





#Form.Message#



If you would like to be removed fromour mailing list,
please click here:
http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#";
title="UNSUBSCRIBE">UNSUBSCRIBE
You will receive one last
message from us to confirm your removal from our
list.





~|
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: cfmail causing problems for our server

[Dave Long]

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

 Original message From: Dave Long
 Date:12/10/2014  12:23 PM  (GMT-06:00)
To: cf-talk  Subject:
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:359796
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

[Dave Long]

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: setting up team games

[Dave Long]

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?






  


function render(arr) {
for(var i=1; i<=arrayLen(arr); i++) {
for(var x=1; x<=arrayLen(arr[i]); x++) {
writeOutput(arr[i][x] & " ");
}
}
}




#render(data)#












#render(data)#







~|
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

[Dave Long]

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

RE: Creating maps with CF

[Dave Long]

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

RE: Creating maps with CF

[Dave Long]

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
-

// = 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></li><li
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));
}
  }

-


On Dec 3, 2013, at 9:58 AM, Dave Long  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

Creating maps with CF

[Dave Long]

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

CF/Railo development environment

[Dave Long]

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

[Dave Long]

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  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

RE: Curmudgeon painted in a corner

[Dave Long]

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  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

Curmudgeon painted in a corner

[Dave Long]

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: Need help finding new CF Hosting

[Dave Long]

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" 
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: Need help finding new CF Hosting

[Dave Long]

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  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

Need help finding new CF Hosting

[Dave Long]

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: Way OT: Funny video

[Dave Long]

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  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?

[Dave Long]

Thanks, Aaron.

I handled that with a conditional:


#CATEGORY#
(#ProductCount#)


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  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  
> 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:
> >
> > 
> >  
> > SELECT Products.ID, Products.CATEGORY
> > FROM   products
> > WHERE  Products.CATEGORY = #GetCategories.Categories.ID#
> >   
> >
> > GetCategories.CATEGORY ( #GetPorducts.RecordCount # 
> > ) 
> >
> >
> >
> >
>
>
>
> 



~|
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

RE: How many products in a specific category?

[Dave Long]

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  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:
>
> 
>  
> SELECT Products.ID, Products.CATEGORY
> FROM   products
> WHERE  Products.CATEGORY = #GetCategories.Categories.ID#
>   
>
> GetCategories.CATEGORY ( #GetPorducts.RecordCount # 
> ) 
>
>
>
> 



~|
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?

[Dave Long]

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:


  
 SELECT Products.ID, Products.CATEGORY
 FROM   products
 WHERE  Products.CATEGORY = #GetCategories.Categories.ID#
   

 GetCategories.CATEGORY ( #GetPorducts.RecordCount #
)  



~|
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

How many products in a specific category?

[Dave Long]

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.


SELECT Categories.ID, Categories.CATEGORY, Categories.RANK,
Categories.CATEGORY AS ID_Field
FROM Categories
ORDER BY Categories.RANK



SELECT Products.ID, Products.CATEGORY
FROM Products
WHERE Products.CATEGORY = "#GetCategories.Category#"




Browse by Category:





#Category#
(#GetProducts.RecordCount#)









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.

[Dave Long]

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?

[Dave Long]

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

RE: Counting photos on a remote server

[Dave Long]

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

Counting photos on a remote server

[Dave Long]

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: using CF to eliminate old Real Estate photos

[Dave Long]

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.
> 
> 
> 
> 
> 
> selectname
> from  photos
> where left(name, 5) = '#GetAll.mlsNumber#'
> 
> 
> 
> 
> 
>  file   =
> "#expandPath('/photos/#selectMatchingImage.name#')#">
> 
> 
> 
> 
> 
> 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:
> 
> 
> SELECT Name
> FROM Photos
> WHERE %Name% NOT IN ( value="#valueList(GetAll.MLS_Number)#" cfsqltype="cf_sql_integer"
> list="true">)
> ORDER BY Name
> 
> 
> 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

using CF to eliminate old Real Estate photos

[Dave Long]

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:


SELECT Name
FROM Photos
WHERE %Name% NOT IN ()
ORDER BY Name


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: Finding values not in a list

[Dave Long]

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 
>  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 ( 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: Finding values not in a list

[Dave Long]

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:
> > 
> >
> >
> >
> >
> >
> 
> 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:
> 
> 
> 
> 
> 
> or equiv:
> 
> 
> 
> >Then I tried to create a list of unprocessed listings from 
> the other DB 
> >by comparing the  MLS_Number to the list:
> > 
> >
> >
> > SELECT MLS_Number
> >FROM Residential
> >WHERE List_Firm = #FirmID# AND MLS_Number NOT IN #list#
> >ORDER BY MLS_Number
> > 
> >
> 
> 
> SELECT MLS_Number
> FROM Residential
> WHERE List_Firm =  cfsqltype="CF_SQL_INTEGER" value="#FirmID#"> AND MLS_Number 
> NOT IN () 
> ORDER BY MLS_Number
> 
> 
> 
> 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

[Dave Long]

Well, that helped... I think.

I added a comma to the CFSET that creates the list:



#list#


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:


SELECT MLS_Number
FROM Residential
WHERE List_Firm = #FirmID#
AND MLS_Number NOT IN 
ORDER BY MLS_Number


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 
>  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:
> >
> >
> > 
> >  SELECT MLS_number
> >  FROM VPT
> >  ORDER BY MLS_number
> > 
> >
> >
> > Next I created a list from the first query:
> >
> >
> > 
> > 
> > 
> >
> >
> > 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:
> >
> >
> > 
> >  SELECT MLS_Number
> > FROM Residential
> > WHERE List_Firm = #FirmID# AND MLS_Number NOT IN #list#
> > ORDER BY MLS_Number
> >  
> >
> >
> > 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

Finding values not in a list

[Dave Long]

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:
 


 SELECT MLS_number 
 FROM VPT
 ORDER BY MLS_number


 
Next I created a list from the first query:
 





 
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:
 


 SELECT MLS_Number
FROM Residential
WHERE List_Firm = #FirmID# AND MLS_Number NOT IN #list#
ORDER BY MLS_Number
 

 
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: Using "FileExists" function in a "CFIF" tag

[Dave Long]

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:
> 
> 
> 
> Yes, it's 
> here.I couldn't find it.  
> 
> 
> if you are not hosting the images, then you should be doing
> 
> 
> 
> 
>  
> not found
> 
> found
> 
> 
>  
> 
> 

~|
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

[Dave Long]

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:

http://mls.northernweb.net/images/Photo";>


#PhotoLocation#-2.jpeg
Yes, it's here.I couldn't
find it.

 
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?

[Dave Long]

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=370617&altf=Cfo&altl=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

[Dave Long]

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

[Dave Long]

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

[Dave Long]

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

RE: CF Studio 5

[Dave Long]

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

CF Studio 5

[Dave Long]

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: Tags useful to accomplish automating MLS direct feed into MySQL DB?

[Dave Long]

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:



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: insert/retrieve image into database SQL Server 2005/CF8?

[Dave Long]

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: insert/retrieve image into database SQL Server 2005/CF8?

[Dave Long]

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:





Update the listings







Delete
>From reslist





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">
 




  

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#')
 



Mission accomplished!




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

RE: insert/retrieve image into database SQL Server 2005/CF8?

[Dave Long]

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




Update tblStaff
Set staffphoto = 
Where StaffID = #staffID#;




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: calendar event

[Dave Long]

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: Apple + Adobe = ??

[Dave Long]

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
> >  &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

RE: OT: Hosting

[Dave Long]

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: Salutation in CF Mail list

[Dave Long]

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:


SELECT Members.Contact, Members.Email AS EmailField
FROM Members
WHERE Members.Email <> ""
ORDER BY Members.Contact





 Members Mailing Form








To:





#Contact#









From:



Subject:















-- 
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

Salutation in CF Mail list

[Dave Long]

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:


SELECT Members.Contact, Members.Email AS EmailField
FROM Members
WHERE Members.Email <> ""
ORDER BY Members.Contact





 Members Mailing Form








To:





#Contact#









From:



Subject:















-- 
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: Adobe ColdFusion IDE survey

[Dave Long]

-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."
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

[Dave Long]

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

RE: Adobe ColdFusion IDE survey

[Dave Long]

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: CF Studio Browse tab doesn't work

[Dave Long]

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

CF Studio Browse tab doesn't work

[Dave Long]

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=finder&productID=1522&loc=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

CF Studio Browse tab doesn't work

[Dave Long]

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=finder&productID=1522&loc=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

RE: CFMyAdmin

[Dave Long]

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