RE: Get everything between in a CSV file.
Theres a custom tag that might be of use to you, CFX_CSVToQuery takes a CSV file and converts it into a query object for you.. It handles commas in HTH -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 22:40 To: CF-Talk Subject: Get everything between in a CSV file. Can someone help me out here. I have a cvs file being uploaded and am having trouble with one of the fields. It a field that *can* contain comments and therefore have a comma in it. I'm dumping it into the database and everything is hunky dorie until a comma is put in the comment field. I notice the csv file puts this field like this This is a comment, and another comment,and another... I would like to find all commas between the two and temporarily change the commas to something else so it doesn't think its another field... Using the ListChangeDelims function doesn't get it because it changes those commas in the comment also. Thanks, - Tracy -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Verity Collection ERROR
Brian Simpson wrote: I have several Verity Collections on one CF server. All are working fine execpt one. When ever I try and do anything (Repair, Optimize, Purge or Delete) with this collection I get the following error: I have started and stopped the server several time and still get this error. When I try and Index the colection, I get this: There was an error indexing this collection. Please verify that path D:\WebSite\htdocs\CA is correct. Does anyone know how to fix this? Delete it by hand and recreate. You should be able to delete the directory created at the point where you set the collection up. Next, go into the registry and delete all references to that collection. It is somewhere below HKLM\Software\Allaire\ColdFusion\CurrentVersion\ You should be able to recreate the collection now. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Javascript people out there? I need help with select bo xes...
You'll need to recreate the menu items a la TwoSelectsRelated.
-Original Message-
From: Yager, Brian T Contractor/NCCIM
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 4:48 PM
To: CF-Talk
Subject: RE: Any Javascript people out there? I need help with select
bo
xes...
I tried that and got this error...
selectCtrl.options[i] has no properties.
Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
-Original Message-
From: Brian Rosenstock [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 3:48 PM
To: CF-Talk
Subject: RE: Any Javascript people out there? I need help with select
bo
xes...
I think you'd need to do:
selectCtrl.options[i].value = i+1;
selectCtrl.options[i].text = i+1;
instead of just:
selectCtrl.options[i] = i+1;
Brian Rosenstock
-Original Message-
From: Yager, Brian T Contractor/NCCIM
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 4:39 PM
To: CF-Talk
Subject: OT: Any Javascript people out there? I need help with select
bo
xes...
sorry about the OT post..I need help with a select box. I am making
2
select
boxes (Month and Day). when the user changes the month, I want the
javascript
to delete what is in the day select box and fill it with the number o
f
days
in
that month. I have the deleting part working. It just won't add. I
'm
not
sure
what I need to do. Here is my code(Please ignore that I HAVE to use
ASP for
this)..
select name=month size=1
onChange=changeMonth(this.form,this.form.day,this.form.month.optio
ns[
this.f
orm.
month.selectedIndex].value);
option value=1 SELECTEDJanuary/option
option value=2February/option
option value=3March/option
option value=4April/option
option value=5May/option
option value=6June/option
option value=7July/option
option value=8August/option
option value=9September/option
option value=10October/option
option value=11November/option
option value=12December/option
/select/td
tdDay:/tdtdselect name=day size=1
%for i = 1 to 31%
option value=%=i%%=i%/option
%next%/select/td
script language=JavaScript1.2
function changeMonth(theform,selectCtrl,iValue) {
var oNewOption;
iSelection = iValue;
iOptLen=selectCtrl.length + 1;
for (i=0;i=iOptLen;i=i+1) {
selectCtrl.options[0] = null;
}
if (iSelection == 1 || iSelection == 3 || iSelection =5 ||iSelection=
7 || iSelection == 8 || iSelection == 10 || iSelection
== 12) {
for (i=0;i=30;i=i+1) {
selectCtrl.options[i] = i+1;
}
}
if (iSelection == 2) {
for (i=0;i=27;i=i+1) {
selectCtrl.options[i] = i+1;
}
}
if (iSelection == 4 || iSelection == 6 || iSelection =9 ||iSelection=
11) {
for (i=0;i=29;i=i+1) {
selectCtrl.options[i] = i+1;
}
}
}
/script
Someone please drop me a line and tell me what I am doing wrong. I
am
absolutely clueless
Thanks,
Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
_
_
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20
GB
MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Solution: Divide record output cleanly when printing?
To anyone who is interested, the solution was actually quite
straightforward. There are apparently two attributes in CSS called
pageBreakBefore and pageBreakAfter. To print exactly 5 records per page, I
inserted this code in the head of the doc within style tags.
div.page { page-break-before: always }
and this code after the end of my record display but before the close of the
output tag.
cfif get_missionary.CurrentRow MOD 5 IS 0/divdiv class=page/cfif
Works like a dream and is very cool!
~Val
Does anyone have any tricks that will not split up the results of a
record output when printing, but will instead be smart
and know that
if the entire record won't fit on one page, to begin it on
the next one?
In my particular situation, each record is fully contained
(formatted)
in its own table. As well, if it helps, I am exporting the
html to a
pdf via the custom tag html2pdf3.
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Javascript: Date Parsing
day like, day name? or day like the day number in a date? The Javascript Date() object does not have a day name property, howev er you can get the day number and date number today=new Date(some date); //this syntax isn't correct but you get the picture indexedDay=today.getDay() //will set indexed day to a zero base d number starting from sunday indexedDate=today.getDate() //will give you what day of the month it is as an int does that answer your ? Ray Bujarski [EMAIL PROTECTED] on 02/21/2002 04:15:33 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: OT Javascript: Date Parsing Does anyone know how to parse the day out of a given date in javascript . I want to do the equivalent of datepart(d, thisDate). form name=sessionWatch cflock scope=SESSION timeout=3 type=READONLY cfoutputinput type=hidden name=seshTimeOut value=#session.timeout#/cfoutput /cflock /form var ses=new Date(); var yrJS = ses.getYear(, document.sessionWatch.seshTimeOu t.value); var monJS = ses.getMonth(m, document.sessionWatch.seshTimeOut value); var dJS = ses.getDay(d, document.sessionWatch.seshTimeOut.v alue); var hJS = ses.getHour(h, document.sessionWatch.seshTimeOut. value); var nJS = ses.getMinutes(n, document.sessionWatch.seshTimeOut value); var sJS = ses.getSeconds(s, document.sessionWatch.seshTimeOut value); __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get everything between in a CSV file.
text,text,dumb,text Change , to ~. Change the independent commas, then change ~ back to ,. -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:40 PM To: CF-Talk Subject: Get everything between in a CSV file. Can someone help me out here. I have a cvs file being uploaded and am having trouble with one of the fields. It a field that *can* contain comments and therefore have a comma in it. I'm dumping it into the database and everything is hunky dorie until a comma is put in the comment field. I notice the csv file puts this field like this This is a comment, and another comment,and another... I would like to find all commas between the two and temporarily change the commas to something else so it doesn't think its another field... __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server does not want to restart
Hi! I'm having the following problem: from time to time the ColdFusion server stops and refuses to start. It has to be manually restarted or something even tweaked a little (pids files need to be removed). In the application.log appear records like the ones below. And also the application.log file get's a lot of this records and grows very quickly. Warning,2051,02/22/02,22:09:38,,In a CF_TagName construct custom tag file '/var/www/virtual/html/_admin/app_locals.cfm' will occlude custom tag file '/var/www/virtual/html/expomart/newyork/app_locals.cfm'. Warning,2051,02/22/02,22:09:38,,In a CF_TagName construct custom tag file '/var/www/virtual/html/_admin/contact/add_ff/act_process.cfm' will occlude custom tag file '/var/www/virtual/html/expomart/newyork/registration/act_process.cfm'. Warning,2051,02/22/02,22:09:38,,In a CF_TagName construct custom tag file '/var/www/virtual/html/_admin/contact/add_ff/act_verify.cfm' will occlude custom tag file '/var/www/virtual/html/expomart/newyork/registration/act_verify.cfm'. TIA, Mack. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX API with Java
I've a problem using the response and query interface in the Coldfusion Java CFX Reference. When I try to return ASCII character codes between 128 and 255 from the CFX to Coldfusion I'm not receiveing the correct ASCII character. This problem occures only when I use the response.addQuery() method and the Query interface. e.g.: resQuery2.setData(1, 1, \305 \306 \330 \345 \346 \370 - \155); (\305 Oct = ASCII value 197, Latin capital A, ring) If i use the response.setVariable() method, this is not a problem. e.g.: response.setVariable(MyVar, \305 \306 \330 \345 \346 \370 - \155); Does anyone know how I can solve this problem or where to get more information about the ColdFusion Java CFX reference? Thanx, tomas __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
List of Cities
I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP
I have been building an on-line community that is driven by emails. I use CFPOP to check an email account and using the FROM I check the database to see if they are a member. My problem is that the FROM does not always contain an email address Just friendly name. Anyone know of another solution or a work around? Rick Eidson http://www.blueear.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP
The from does contain an email address.. However if a friendly name is included the email address is surrounded by angles and as such the browser will process them out... If you view the source of the page then you will see the email addres... Or alternitavely use HTMLEditFormat() around the from address.. HTH -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 14:51 To: CF-Talk Subject: CFPOP I have been building an on-line community that is driven by emails. I use CFPOP to check an email account and using the FROM I check the database to see if they are a member. My problem is that the FROM does not always contain an email address Just friendly name. Anyone know of another solution or a work around? Rick Eidson http://www.blueear.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPOP
Just make sure email addresses are verified before you stuff 'em in the database. You can't verify they are real email addresses but you can check the format to ascertain that they appear to be real email addresses. Outside of that, there isn't much else you can do to prevent user errors. -Original Message- From: Rick Eidson [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:51 AM To: CF-Talk Subject: CFPOP I have been building an on-line community that is driven by emails. I use CFPOP to check an email account and using the FROM I check the database to see if they are a member. My problem is that the FROM does not always contain an email address Just friendly name. Anyone know of another solution or a work around? Rick Eidson http://www.blueear.com __ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPOP
I would check for the existance of a reply-to header. If that header exists it should be the real email address of the sender. If it does not exist then fall back to using the from header. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Rick Eidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 9:50 AM Subject: CFPOP I have been building an on-line community that is driven by emails. I use CFPOP to check an email account and using the FROM I check the database to see if they are a member. My problem is that the FROM does not always contain an email address Just friendly name. Anyone know of another solution or a work around? Rick Eidson http://www.blueear.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get everything between in a CSV file.
Thanks. I'll check it out. I got it working last night. Its ugly, but it works. Quoting Mike Townend [EMAIL PROTECTED]: Theres a custom tag that might be of use to you, CFX_CSVToQuery takes a CSV file and converts it into a query object for you.. It handles comma s in HTH -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 22:40 To: CF-Talk Subject: Get everything between in a CSV file. Can someone help me out here. I have a cvs file being uploaded and am having trouble with one of the fields. It a field that *can* contain comments and therefore have a comma in it. I'm dumping it into the database and everything is hunky dorie until a comma is put in the comment field. I notice the csv file puts this field like this This is a comment, and another comment,and another... I would like to find all commas between the two and temporarily change the commas to something else so it doesn't think its another field... Using the ListChangeDelims function doesn't get it because it changes those commas in the comment also. Thanks, - Tracy --- - -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
GET Size
what is the max length of a GET request? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT Javascript associative arrays
anyone know how to loop through and dump values from an associative array? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT Javascript associative arrays
Use for/in:
for(foo in ob) {
alert(foo + + ob[foo]);
}
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 11:01 AM
To: CF-Talk
Subject: OT Javascript associative arrays
anyone know how to loop through and dump values from an
associative array?
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Web based editor
Massimo, I *love* your editor -- and everything else on your site. Robert Robert Crooks _ Technical Lead Educational Services Macromedia, Inc http://www.macromedia.com/training/ -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 1:34 PM To: CF-Talk Subject: Re: Web based editor Tyler Clendenin [EMAIL PROTECTED] wrote in message i really like activedit from http://www.cfdev.com/ Yes, it's excellent, soEditor is also worth checking: http://www.siteobjects.com/pages/index.cfm Personally I just assembled a custom tag, you can see a demo here: http://www.massimocorner.com/beta/xhtmleditor.htm And grab it from: http://www.massimocorner.com/beta/cf.htm The reason why I did something on my own is that I was looking for a veyr limited set of functionalities and I wanted XHTML compatibility. Massimo Foti [EMAIL PROTECTED] http://www.massimocorner.com Dreamweaver, Ultradev and Fireworks goodies http://www.projectseven.com/viewer/snippets.htm Snippets Panel __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: GET Size
2K. Sam - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 10:56 AM Subject: GET Size what is the max length of a GET request? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Use of Style Sheets
Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you search on in bold in the description of the linked website. Or does anyone know of a better way to do this? Thanks, Steve __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Use of Style Sheets
sure, that's the exact kind of thing css is good for. just include the style sheet and when you cfoutput your results throw a style tag in the output cfouput p class=heading#title#/p span class=description#description/span /cfoutput is that what you mean? Burcham, Steve [EMAIL PROTECTED] on 02/22/2002 11:19:51 A M Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Use of Style Sheets Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you se arch on in bold in the description of the linked website. Or does anyone know of a better way to do this? Thanks, Steve __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Use of Style Sheets
Check out cf_highlight at CFDev.com. It's a free tag. http://www.cfdev.com/products/productdetail.cfm?id=1018 Greg Alton CFDev - Original Message - From: Burcham, Steve [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 12:19 PM Subject: Use of Style Sheets Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you search on in bold in the description of the linked website. Or does anyone know of a better way to do this? Thanks, Steve __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: GET Size
The HTTP protocol does not place any limit on URL length. Any limitations are imposed by either the server or the client. jon - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 10:56 AM Subject: GET Size what is the max length of a GET request? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Simple Message Board 2.0 Beta
will be available soon! I just wanted to get a feel for any additional features anyone might have been waiting for before I release this version. New features and enhancements include: 1) Multi-language support with on-the-fly switching 2) User Albums for images or other files with auto resizing, thumbnailing and file/user/site quotas 3) Ignore user function (doesn't display posts from people on your ignore list) 4) Archive thread function - stores a flat file version of a single thread but still uses current dynamic header/footer/stylesheet 5) CSS Stylesheets! 6) Who's Online (Maybe) 7) Thread Self-Destruct - Deletes after expiration date/time (maybe) I'm sure I'm forgetting something. I promise to get a site up when I release the beta. Any other feature requests? (not too complicated I hope) ;) Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RegEx rookie question
Is there a way to check for a character in a specific position in a string? For example, say I want to make sure that the 10th character in a string is an X. This would be a match: 123456789X12345 Would I have to use a pattern like ?X or is there something more elegant? Using something like the above would be cumbersome for matching the 125th character, for example. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx rookie question
how about
/^[a-z0-9]{n}X/i
where n is the index of the character and X is the character?
Howie Hamlin [EMAIL PROTECTED] on 02/22/2002 11:50:58 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: RegEx rookie question
Is there a way to check for a character in a specific position in a str
ing?
For example, say I want to make sure that the 10th
character in a string is an X.
This would be a match: 123456789X12345
Would I have to use a pattern like ?X
or is there something more elegant? Using something like the above wou
ld
be cumbersome for matching the 125th character, for
example.
Thanks,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668
x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RegEx rookie question
something like:
[0-9]\{125\}X
you could also have:
[0-9]\{m,n\}X
Where {m,n} indicates that the preceeding element must match at least m
times and may match as many as n times.
___
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 12:51 PM
To: CF-Talk
Subject: RegEx rookie question
Is there a way to check for a character in a specific position in a
string? For example, say I want to make sure that the 10th
character in a string is an X.
This would be a match: 123456789X12345
Would I have to use a pattern like ?X
or is there something more elegant? Using something like the above
would be cumbersome for matching the 125th character, for
example.
Thanks,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RegEx rookie question
How about:
mid(string,10,1) eq 'X'
- Matt Small
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 1:01 PM
To: CF-Talk
Subject: Re: RegEx rookie question
how about
/^[a-z0-9]{n}X/i
where n is the index of the character and X is the character?
Howie Hamlin [EMAIL PROTECTED] on 02/22/2002 11:50:58 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: RegEx rookie question
Is there a way to check for a character in a specific position in a str
ing?
For example, say I want to make sure that the 10th
character in a string is an X.
This would be a match: 123456789X12345
Would I have to use a pattern like ?X
or is there something more elegant? Using something like the above wou
ld
be cumbersome for matching the 125th character, for
example.
Thanks,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668
x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RegEx rookie question
Thanks, I appreciate it.
Regards,
Howie
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 1:00 PM
Subject: Re: RegEx rookie question
how about
/^[a-z0-9]{n}X/i
where n is the index of the character and X is the character?
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Simple Message Board 2.0 Beta
Where is the site?? I cannot find the site to get to your stuff anymore. www.simplemessageboard.com doesn't respond. Lee | -Original Message- | From: Tony Schreiber [mailto:[EMAIL PROTECTED]] | Sent: Friday, February 22, 2002 9:50 AM | To: CF-Talk | Subject: Simple Message Board 2.0 Beta | | | will be available soon! I just wanted to get a feel for any | additional features anyone might have been waiting for before | I release this version. New features and enhancements include: | | 1) Multi-language support with on-the-fly switching | 2) User Albums for images or other files with auto resizing, | thumbnailing and file/user/site quotas | 3) Ignore user function (doesn't display posts from people on | your ignore | list) | 4) Archive thread function - stores a flat file version of a | single thread but still uses current dynamic header/footer/stylesheet | 5) CSS Stylesheets! | 6) Who's Online (Maybe) | 7) Thread Self-Destruct - Deletes after expiration date/time (maybe) | | I'm sure I'm forgetting something. I promise to get a site up | when I release the beta. | | Any other feature requests? (not too complicated I hope) ;) | | | Tony Schreiber, Senior Partner Man and | Machine, Limited | mailto:[EMAIL PROTECTED] | http://www.technocraft.com | http://www.simplemessageboard.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Use of Style Sheets
Thanks for your help Greg. That worked great. -Original Message- From: Greg Alton [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:38 AM To: CF-Talk Subject: Re: Use of Style Sheets Check out cf_highlight at CFDev.com. It's a free tag. http://www.cfdev.com/products/productdetail.cfm?id=1018 Greg Alton CFDev - Original Message - From: Burcham, Steve [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 12:19 PM Subject: Use of Style Sheets Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you search on in bold in the description of the linked website. Or does anyone know of a better way to do this? Thanks, Steve __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Use of Style Sheets
yep here you go: cfset Results = Sun Cobalt Qube 3 software architecture is designed to provide an enhanced developer platform. Our Sun Cobalt Qube 3 appliance software architecture enables third-party developers to customize, modularize, and implement services in record time. cfset Search = Sun cfset NewResults = REReplaceNoCase(#Results#, (#Search#), FONT COLOR=##ffB\1/B/FONT, ALL) cfoutput #NewResults# /cfoutput -Original Message- From: Burcham, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:20 PM To: CF-Talk Subject: Use of Style Sheets Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you search on in bold in the description of the linked website. Or does anyone know of a better way to do this? Thanks, Steve __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: List of Cities
I'd love to take a look at those UDFs. Do they work with any lat/long values? I'm asking because I have a DB with US zips and Canadian postal codes all with lat/long values (to about 5 decimals I think). The distance calculation that I found is a pig to put it midly, so hopefully the UDFs can help me out ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tom Nunamaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 11:08 AM Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Use of Style Sheets
Other people have sent in ideas, heres another one: Highlight UDF: http://www.cflib.org/udf.cfm?ID=133 === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Burcham, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:20 PM To: CF-Talk Subject: Use of Style Sheets Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you search on in bold in the description of the linked website. Or does anyone know of a better way to do this? Thanks, Steve __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity choking?
Hi, What's the upper limit for Verity in CF 5.0? Reason I'm asking is, we've got a library with about 1000 documents in it. When we go to index it, CF sucks up all of our CPU overhead. After about 15-20 minutes it drops back down, but that's an awfully long time. Has anyone else encountered this? Should I just not worry about it? Thanks, Ian Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Image Proportions
Help... My pictures are autoresized to 560 wide but have an unlimited height. I am initially displaying these images in a table with a height restriction of 200, I also need to limit the width to 300 to fit within my table without loosing proportion. Is there a simple routine to lock a table/cell size and keep my proportion and 560 resize width or only limit the height if it is over 200 and the width only if it is over 300? It is probably a very easy routine, but I am not aware of it! It currently reads... td VALIGN=bottom width=300 HEIGHT=200 align=center colspan=1 nowrap cfif CheckImage.recordcount gt 1 and #caption_2# is not A href=../../graphics/#BrkrNmbr#/#int(ListingNmb)#-2.jpg img src=../../graphics/#BrkrNmbr#/#int(ListingNmb)#-2.jpg height=200 align=center/a p align=centerfont size=2#Caption_2#/pBR cfelseif CheckImage.recordcount gt 1 A href=../../graphics/#BrkrNmbr#/#int(ListingNmb)#-2.jpgimg src=../../graphics/#BrkrNmbr#/#int(ListingNmb)#-2.jpg height=200 align=center/a p align=centerfont size=2Photo 1/pBR /cfif /td Best Regards, Eric Wesch www.MarineSource.com [EMAIL PROTECTED] (904) 292-1269 fax:(904) 260-5277 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Documentation
I've been tasked with creating a documentation model for our applications. I'm curious if anyone has some examples of what they are doing they may be willing to share off list, or if anyone uses an industry standard they could direct me to. I'm speaking in a scope of not just code documentation, but hard application documentation. Thanks, Trey Rouse Internet Project Coordinator Web Services - Rice University __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Documentation
I like fusedoc for code documentation. For actual specs, I prefer the IEEE standard. I can't remember the number , I'm afraid, but it's very thorough... -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:24 AM To: CF-Talk Subject: Documentation I've been tasked with creating a documentation model for our applications. I'm curious if anyone has some examples of what they are doing they may b e willing to share off list, or if anyone uses an industry standard they co uld direct me to. I'm speaking in a scope of not just code documentation, but hard applicat ion documentation. Thanks, Trey Rouse Internet Project Coordinator Web Services - Rice University __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Simple Message Board 2.0 Beta
The site is still down, that's why I said I promise to have one up when I release the beta... Where is the site?? I cannot find the site to get to your stuff anymore. www.simplemessageboard.com doesn't respond. Lee | -Original Message- | From: Tony Schreiber [mailto:[EMAIL PROTECTED]] | Sent: Friday, February 22, 2002 9:50 AM | To: CF-Talk | Subject: Simple Message Board 2.0 Beta | | | will be available soon! I just wanted to get a feel for any | additional features anyone might have been waiting for before | I release this version. New features and enhancements include: | | 1) Multi-language support with on-the-fly switching | 2) User Albums for images or other files with auto resizing, | thumbnailing and file/user/site quotas | 3) Ignore user function (doesn't display posts from people on | your ignore | list) | 4) Archive thread function - stores a flat file version of a | single thread but still uses current dynamic header/footer/stylesheet | 5) CSS Stylesheets! | 6) Who's Online (Maybe) | 7) Thread Self-Destruct - Deletes after expiration date/time (maybe) | | I'm sure I'm forgetting something. I promise to get a site up | when I release the beta. | | Any other feature requests? (not too complicated I hope) ;) | | | Tony Schreiber, Senior Partner Man and | Machine, Limited | mailto:[EMAIL PROTECTED] | http://www.technocraft.com | http://www.simplemessageboard.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Documentation
Write good comments and if necessary have a small README file with the app. Documentation is always out of sync with the current code and IMO never read anyway. On Fri, 22 Feb 2002, Ian Lurie wrote: I like fusedoc for code documentation. For actual specs, I prefer the IEEE standard. I can't remember the number , I'm afraid, but it's very thorough... -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:24 AM To: CF-Talk Subject: Documentation I've been tasked with creating a documentation model for our applications . I'm curious if anyone has some examples of what they are doing they may b e willing to share off list, or if anyone uses an industry standard they co uld direct me to. I'm speaking in a scope of not just code documentation, but hard applicat ion documentation. Thanks, Trey Rouse Internet Project Coordinator Web Services - Rice University __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Simple Message Board 2.0 Beta
Ah.. Got it. Am really wanting to implement it on a site for testing, and wasn't able to find it. Thanks! Lee | -Original Message- | From: Tony Schreiber [mailto:[EMAIL PROTECTED]] | Sent: Friday, February 22, 2002 11:49 AM | To: CF-Talk | Subject: RE: OT: Simple Message Board 2.0 Beta | | | The site is still down, that's why I said I promise to have | one up when I release the beta... | | Where is the site?? I cannot find the site to get to your stuff | anymore. www.simplemessageboard.com doesn't respond. | | Lee | | | | -Original Message- | | From: Tony Schreiber [mailto:[EMAIL PROTECTED]] | | Sent: Friday, February 22, 2002 9:50 AM | | To: CF-Talk | | Subject: Simple Message Board 2.0 Beta | | | | | | will be available soon! I just wanted to get a feel for any | | additional features anyone might have been waiting for before I | | release this version. New features and enhancements include: | | | | 1) Multi-language support with on-the-fly switching | | 2) User Albums for images or other files with auto resizing, | | thumbnailing and file/user/site quotas | | 3) Ignore user function (doesn't display posts from | people on your | | ignore | | list) | | 4) Archive thread function - stores a flat file version | of a single | | thread but still uses current dynamic header/footer/stylesheet | | 5) CSS Stylesheets! | | 6) Who's Online (Maybe) | | 7) Thread Self-Destruct - Deletes after expiration | date/time (maybe) | | | | I'm sure I'm forgetting something. I promise to get a | site up when I | | release the beta. | | | | Any other feature requests? (not too complicated I hope) ;) | | | | | | Tony Schreiber, Senior Partner Man and | | Machine, Limited | | mailto:[EMAIL PROTECTED] | | http://www.technocraft.com | | | http://www.simplemessageboard.com | | __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
correct delimiter?
Is Chr(13) the right end of line delimiter for a tab delimited file? I have to grab info from a text file but cant remember if char(13) is correct. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP...
I want to know if you can specify a specific IP address for your request to come from provided you have multiple IP addresses on a server. It seems we have some people who get different origin ips that their app is running on. Thanks, Neil __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Documentation
We have to have up to date documentation on our web projects. They actually can not go into production until those docs are made. With that said, things sure do manage to slip through the cracks. The master documentation though is a good piece for the project managers to see and look over, that way they know things have been documented because they are not going to spend the time to read through all of the code. The documentation will include not only the CF, but any SQL related information such as DTS or SP information. After coming into projects behind developers many times in the past, I personally like being able to read through a master document on the project/site as well as see comments in the code. We also do use a standard methodology here on the intranet applications, but things can still be confusing to figure out if you have no comments or docs. Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Fri, 22 Feb 2002, Alex wrote: Write good comments and if necessary have a small README file with the app. Documentation is always out of sync with the current code and IMO never read anyway. On Fri, 22 Feb 2002, Ian Lurie wrote: I like fusedoc for code documentation. For actual specs, I prefer the IEEE standard. I can't remember the numb er , I'm afraid, but it's very thorough... -Original Message- From: Trey Rouse [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 11:24 AM To: CF-Talk Subject: Documentation I've been tasked with creating a documentation model for our applicatio ns . I'm curious if anyone has some examples of what they are doing they may b e willing to share off list, or if anyone uses an industry standard they co uld direct me to. I'm speaking in a scope of not just code documentation, but hard applic at ion documentation. Thanks, Trey Rouse Internet Project Coordinator Web Services - Rice University __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: correct delimiter?
Heya Phil! Chr(13) is a Line Feed and Chr(10) is a Carrige Return. I would guess it would depend on what was entered to take them to the next line in the file. Do a check for both to make sure. Just a suggestion! Paul Giesenhagen - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 2:17 PM Subject: correct delimiter? Is Chr(13) the right end of line delimiter for a tab delimited file? I have to grab info from a text file but cant remember if char(13) is correct. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: correct delimiter?
Chr(13) is a carriage return and Chr(10) is a line feed...a line of text should end in chr(13)+chr(10). Regards, Howie - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:23 PM Subject: Re: correct delimiter? Heya Phil! Chr(13) is a Line Feed and Chr(10) is a Carrige Return. I would guess it would depend on what was entered to take them to the next line in the file. Do a check for both to make sure. Just a suggestion! Paul Giesenhagen - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 2:17 PM Subject: correct delimiter? Is Chr(13) the right end of line delimiter for a tab delimited file? I have to grab info from a text file but cant remember if char(13) is correct. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
Jim Does that also work for zip codes across state lines? For instance, chicago is not far from Indiana. Would the zip codes still be numerically and physically close or does the state matter at all? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:47 PM To: CF-Talk Subject: RE: List of Cities Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
I'll get them at toshop.com later today for you Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:25 PM To: CF-Talk Subject: Re: List of Cities I'd love to take a look at those UDFs. Do they work with any lat/long values? I'm asking because I have a DB with US zips and Canadian postal codes all with lat/long values (to about 5 decimals I think). The distance calculation that I found is a pig to put it midly, so hopefully the UDFs can help me out ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tom Nunamaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 11:08 AM Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2 miles). TIA, Duane __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
RE: correct delimiter?
put them together and use them both as the delimiter like this: cfset crlf = chr(13)chr(10) cfloop delimiter=#crlf#... When you specify muliptle characters as the delimiter CF will use EITHER ONE as the delimiter. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:18 PM To: CF-Talk Subject: correct delimiter? Is Chr(13) the right end of line delimiter for a tab delimited file? I have to grab info from a text file but cant remember if char(13) is correct. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: correct delimiter?
Actually, i would say instead: Chr(13) is a carriage return and Chr(10) is a line feed...a line of text should end in chr(13)+chr(10) on a Windows platform. Jerry Johnson [EMAIL PROTECTED] 02/22/02 03:27PM Chr(13) is a carriage return and Chr(10) is a line feed...a line of text should end in chr(13)+chr(10). Regards, Howie - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:23 PM Subject: Re: correct delimiter? Heya Phil! Chr(13) is a Line Feed and Chr(10) is a Carrige Return. I would guess it would depend on what was entered to take them to the next line in the file. Do a check for both to make sure. Just a suggestion! Paul Giesenhagen - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 2:17 PM Subject: correct delimiter? Is Chr(13) the right end of line delimiter for a tab delimited file? I have to grab info from a text file but cant remember if char(13) is correct. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: correct delimiter?
True, but crlf is more of a standard. Most (if not all) internet protcols dictate crlf pairs. Howie - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:52 PM Subject: Re: correct delimiter? Actually, i would say instead: Chr(13) is a carriage return and Chr(10) is a line feed...a line of text should end in chr(13)+chr(10) on a Windows platform. Jerry Johnson __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
After some further research, Tom, I think you are correct. It does not seem to matter for north-south states. Zipcodes start in the north-westand seem to zigzag across the country ending up in Washington State. So three possibilities: 1) Instate should be fine. 2) for out of state comparisons... use a larger range, like maybe 2000? 3) north-south comparisons can be done using zip code range and east west can be done using longitudinal range. These should both run faster since there is no math calculations involved. I think that made sense. What do you think? - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:32 PM To: CF-Talk Subject: RE: List of Cities Jim Does that also work for zip codes across state lines? For instance, chicago is not far from Indiana. Would the zip codes still be numerically and physically close or does the state matter at all? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:47 PM To: CF-Talk Subject: RE: List of Cities Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting challenge. I will be working on an application that will help a company increase efficiency in shipping goods around the company. The company has its own fleet of shipping vehicles but occasional will use independents for small loads. What I need to figure out is if independent x from zip code z1 is driving to zip code z2 what cities/towns does the route pass through or close to (within 2
RE: correct delimiter?
Thanks and Hi Paul! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:27 PM To: CF-Talk Subject: Re: correct delimiter? Chr(13) is a carriage return and Chr(10) is a line feed...a line of text should end in chr(13)+chr(10). Regards, Howie - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:23 PM Subject: Re: correct delimiter? Heya Phil! Chr(13) is a Line Feed and Chr(10) is a Carrige Return. I would guess it would depend on what was entered to take them to the next line in the file. Do a check for both to make sure. Just a suggestion! Paul Giesenhagen - Original Message - From: Phillip Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 2:17 PM Subject: correct delimiter? Is Chr(13) the right end of line delimiter for a tab delimited file? I have to grab info from a text file but cant remember if char(13) is correct. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
Jim I find it hard to use the zipcode numbers as a filter due to the lack of information on how they are derived. How do I know what the correct amount is for your second possibility? Is it 2000? 1500? 2500? How do I know for sure? You don't. The only way you do know is by calculating the distances. How do I know instate is fine? You said is should be...but do you know for a fact or is that speculation? You said they should run faster since there is no math calculations involved. That's misleading since we are both using SQL between statements to create a recordset. I fail to see how I know the distance between two zipcodes with your method. Don't you have to calculate that the same way I dowith lat/longs? My method only does that calculation for a small number of wasted computations but I guarantee my results are within the correct distance desired. The method I'm using is VERY fast. The only distance calculations you do are within the rectangle of results you get by filtering out the vast majority of data. You're basically throwing out the corners of the box to make a circle if that makes sense. For instance, if I do a query looking for something within 120 NM of 0N 0W, I do this: SELECT * FROM mydata WHERE lat BETWEEN -2 AND 2 AND lon BETWEEN -2 AND 2 The farthest distance I could possibly have (assuming the rectangle is nearly a perfect square) would be 2^(1/2) = 1.4142 * 120 or 169.7 NM All other data would have been filtered out at this point...which is about 98.6% of the planet. You're going to have to do the distance calculations on this dataset and end up throwing out a maximum of about 29% of these remaining records. NOTE: As your go father North, the square is more rectangular and you're excess records will slowly increase, but not dramatically. Perhaps I'm still missing something about just using zipcode numbers as my initial filter. If I want to search within 50 miles, what zipcode amount do I vary my target from? +/- 50? What's the key? Do you have a working example? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:03 PM To: CF-Talk Subject: RE: List of Cities After some further research, Tom, I think you are correct. It does not seem to matter for north-south states. Zipcodes start in the north-westand seem to zigzag across the country ending up in Washington State. So three possibilities: 1) Instate should be fine. 2) for out of state comparisons... use a larger range, like maybe 2000? 3) north-south comparisons can be done using zip code range and east west can be done using longitudinal range. These should both run faster since there is no math calculations involved. I think that made sense. What do you think? - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:32 PM To: CF-Talk Subject: RE: List of Cities Jim Does that also work for zip codes across state lines? For instance, chicago is not far from Indiana. Would the zip codes still be numerically and physically close or does the state matter at all? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:47 PM To: CF-Talk Subject: RE: List of Cities Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120
RE: List of Cities
Tom, Someone asked if there was a faster way, so I bounced that idea out there. Your methods are correct, and I did not dispute them. I was merely bringing out another option to explore. Obviously the lack of overhead gain does not make this solution worthwhile. Have a good weekend. - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:38 PM To: CF-Talk Subject: RE: List of Cities Jim I find it hard to use the zipcode numbers as a filter due to the lack of information on how they are derived. How do I know what the correct amount is for your second possibility? Is it 2000? 1500? 2500? How do I know for sure? You don't. The only way you do know is by calculating the distances. How do I know instate is fine? You said is should be...but do you know for a fact or is that speculation? You said they should run faster since there is no math calculations involved. That's misleading since we are both using SQL between statements to create a recordset. I fail to see how I know the distance between two zipcodes with your method. Don't you have to calculate that the same way I dowith lat/longs? My method only does that calculation for a small number of wasted computations but I guarantee my results are within the correct distance desired. The method I'm using is VERY fast. The only distance calculations you do are within the rectangle of results you get by filtering out the vast majority of data. You're basically throwing out the corners of the box to make a circle if that makes sense. For instance, if I do a query looking for something within 120 NM of 0N 0W, I do this: SELECT * FROM mydata WHERE lat BETWEEN -2 AND 2 AND lon BETWEEN -2 AND 2 The farthest distance I could possibly have (assuming the rectangle is nearly a perfect square) would be 2^(1/2) = 1.4142 * 120 or 169.7 NM All other data would have been filtered out at this point...which is about 98.6% of the planet. You're going to have to do the distance calculations on this dataset and end up throwing out a maximum of about 29% of these remaining records. NOTE: As your go father North, the square is more rectangular and you're excess records will slowly increase, but not dramatically. Perhaps I'm still missing something about just using zipcode numbers as my initial filter. If I want to search within 50 miles, what zipcode amount do I vary my target from? +/- 50? What's the key? Do you have a working example? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:03 PM To: CF-Talk Subject: RE: List of Cities After some further research, Tom, I think you are correct. It does not seem to matter for north-south states. Zipcodes start in the north-westand seem to zigzag across the country ending up in Washington State. So three possibilities: 1) Instate should be fine. 2) for out of state comparisons... use a larger range, like maybe 2000? 3) north-south comparisons can be done using zip code range and east west can be done using longitudinal range. These should both run faster since there is no math calculations involved. I think that made sense. What do you think? - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:32 PM To: CF-Talk Subject: RE: List of Cities Jim Does that also work for zip codes across state lines? For instance, chicago is not far from Indiana. Would the zip codes still be numerically and physically close or does the state matter at all? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:47 PM To: CF-Talk Subject: RE: List of Cities Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at
LatLongDist UDF online
For those who were looking for the UDF to do distance between two lat/lons, here's my version: http://toshop.com/udf/latlondist.cfm Rob Brooks-Bilson wrote a UDF at cflib.org that does basically the same thing but I use a different calculation that's subject to little rounding error for short distances, has more options for the result units and has more precise conversion factors. Rob's UDF also requires DegToRad UDF which mine does not require since I've done the conversion within the latlondist UDF. Rob's version is here: http://www.cflib.org/udf.cfm?ID=73 Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
I have a stored proc I wrote for SQLServer that returns the number of cities within a defined radius of a zip code based on lat/lon. If anyone wants that they are welcome to it. Its at www.cfexperts.com/downloads/locater.zip Duane -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:03 PM To: CF-Talk Subject: RE: List of Cities After some further research, Tom, I think you are correct. It does not seem to matter for north-south states. Zipcodes start in the north-westand seem to zigzag across the country ending up in Washington State. So three possibilities: 1) Instate should be fine. 2) for out of state comparisons... use a larger range, like maybe 2000? 3) north-south comparisons can be done using zip code range and east west can be done using longitudinal range. These should both run faster since there is no math calculations involved. I think that made sense. What do you think? - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:32 PM To: CF-Talk Subject: RE: List of Cities Jim Does that also work for zip codes across state lines? For instance, chicago is not far from Indiana. Would the zip codes still be numerically and physically close or does the state matter at all? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:47 PM To: CF-Talk Subject: RE: List of Cities Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE: List of Cities The US Census agency has a free listing of lat/lon for zip codes at http://ftp.census.gov/geo/www/gazetteer/places.html I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? If anyone needs the UDF's sooner, I can dig them out of the code I'm using at www.morervs.com. Look at http://www.morervs.com/fb3/index.cfm?fuseaction=search.home and try the distance search. I think that's the kind of thing you're after. I haven't seen how others do this but my solution was based on the fact that one degree of latitude is always equal to 60 nautical miles. You take the distance for the radius of the search and convert it to nautical miles. Then add that many degrees in a box around the starting point. If my search was 138 statute miles (about 120 Nautical miles), the 120 nautical miles is 2 degrees of arc at the earth's surface (Assuming the earth is a perfect sphere). Do an SQL query to filter out the vast majority of records that fall outside of the box surrounding your origin... Something like Select * From myzipcodedata Where lat between (targetlat-dist/(60*1.15)) and (targetlat+dist/(60*1.15)) AND lon between (targetlon-dist/(60*1.15)) and (targetlon+dist/(60*1.15)) This leaves you with a rectangle that's CLOSE to a radius search. All that's left to do is to loop through these records and actually calculate the distance and throw out the ones that exceed your search distance. One degree of longitude is only equal to 60 NM at the equator. The farther North you go, the smaller the distance gets until you get to the poles where it's zero. Your initial box to filter records out is actually somewhat larger than your search distance but it will never be smaller than your search distance. If someone has a better way, I'd love to see it but this method works fairly quickly. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:29 PM To: CF-Talk Subject: RE: List of Cities Hi, There are zipcode lists with LAT and LONG coordinates for each zipcode. http://www.zipinfo.com/products/products.htm You can calculate your route's slope, distance and direction using the codes, and then look up intersection paths in the DB. Hope that helps. I've done this before, and it is actually pretty exciting when it starts working ;) - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 9:57 AM To: CF-Talk Subject: List of Cities I am faced with a rather interesting
RE: List of Cities
Hi Jim I'm the one who asked for other ways. It is an interesting idea but I'm not sure how you would use it since I doubt if USPS has standard distances between zip codes. If they did, it would be great, but I'm pretty sure they base zip codes on population density. If I get over this cold I will have a good weekend! :) Thanks Tom -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:51 PM To: CF-Talk Subject: RE: List of Cities Tom, Someone asked if there was a faster way, so I bounced that idea out there. Your methods are correct, and I did not dispute them. I was merely bringing out another option to explore. Obviously the lack of overhead gain does not make this solution worthwhile. Have a good weekend. - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:38 PM To: CF-Talk Subject: RE: List of Cities Jim I find it hard to use the zipcode numbers as a filter due to the lack of information on how they are derived. How do I know what the correct amount is for your second possibility? Is it 2000? 1500? 2500? How do I know for sure? You don't. The only way you do know is by calculating the distances. How do I know instate is fine? You said is should be...but do you know for a fact or is that speculation? You said they should run faster since there is no math calculations involved. That's misleading since we are both using SQL between statements to create a recordset. I fail to see how I know the distance between two zipcodes with your method. Don't you have to calculate that the same way I dowith lat/longs? My method only does that calculation for a small number of wasted computations but I guarantee my results are within the correct distance desired. The method I'm using is VERY fast. The only distance calculations you do are within the rectangle of results you get by filtering out the vast majority of data. You're basically throwing out the corners of the box to make a circle if that makes sense. For instance, if I do a query looking for something within 120 NM of 0N 0W, I do this: SELECT * FROM mydata WHERE lat BETWEEN -2 AND 2 AND lon BETWEEN -2 AND 2 The farthest distance I could possibly have (assuming the rectangle is nearly a perfect square) would be 2^(1/2) = 1.4142 * 120 or 169.7 NM All other data would have been filtered out at this point...which is about 98.6% of the planet. You're going to have to do the distance calculations on this dataset and end up throwing out a maximum of about 29% of these remaining records. NOTE: As your go father North, the square is more rectangular and you're excess records will slowly increase, but not dramatically. Perhaps I'm still missing something about just using zipcode numbers as my initial filter. If I want to search within 50 miles, what zipcode amount do I vary my target from? +/- 50? What's the key? Do you have a working example? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:03 PM To: CF-Talk Subject: RE: List of Cities After some further research, Tom, I think you are correct. It does not seem to matter for north-south states. Zipcodes start in the north-westand seem to zigzag across the country ending up in Washington State. So three possibilities: 1) Instate should be fine. 2) for out of state comparisons... use a larger range, like maybe 2000? 3) north-south comparisons can be done using zip code range and east west can be done using longitudinal range. These should both run faster since there is no math calculations involved. I think that made sense. What do you think? - j -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:32 PM To: CF-Talk Subject: RE: List of Cities Jim Does that also work for zip codes across state lines? For instance, chicago is not far from Indiana. Would the zip codes still be numerically and physically close or does the state matter at all? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:47 PM To: CF-Talk Subject: RE: List of Cities Because zipcodes that are numerically close are physically close, you can speed up query time by limiting zip searches to within a +- 500 - 1000 range of the originating zip code. EG. if you are in zip code 5, a distance search between 45000 an 55000 should suffice. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:08 PM To: CF-Talk Subject: RE:
Ecommerce??
I'm putting together a bid for my client on a site which incorporates Ecommerce. Does anyone know of an FB3 Ecommerce solution? It doesn't need to be full of gadgets, just the basic framework will do. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Joining Tables from Different Datasources... Possible?
How would I do a join of tables from two different datasources? Thanks, __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Joining Tables from Different Datasources... Possible?
If the two tables are on a SQL Server you could reference the full name in your query. SELECT T1.a, T2.b FROM database.username.tablename T1 INNER JOIN database2.username2.tablename ON If this is not the case, you will need to use CF 5. At 05:05 PM 2/22/2002 -0500, you wrote: How would I do a join of tables from two different datasources? Thanks, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Newbie Question
Hi Guys - I just purchased a Cobalt RAQ from Sun, and installed cold fusion version 5 on the server. I have a couple of Access Databases that I want to use as my ODBC data sources. I know there is an odbc driver available for NT Boxes, but what about my Cobalt RAQ XTR running Linux??? Thanks for your support, Jeffrey Cohen ImageWorks, LLC __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ecommerce??
FB3??? Jeffrey George Larkin wrote: I'm putting together a bid for my client on a site which incorporates Ecommerce. Does anyone know of an FB3 Ecommerce solution? It doesn't need to be full of gadgets, just the basic framework will do. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? One word - Neo. :) (In other words, I'm _very_ busy, as is Rob right now.) We just published a set of UDFs and will be getting more up soon. Remember, we check the code for best practices as well as proper categorization. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ecommerce??
Fusebox 3.0 Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jeffrey Cohen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:26 PM To: CF-Talk Subject: Re: Ecommerce?? FB3??? Jeffrey George Larkin wrote: I'm putting together a bid for my client on a site which incorporates Ecommerce. Does anyone know of an FB3 Ecommerce solution? It doesn't need to be full of gadgets, just the basic framework will do. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ecommerce??
Yeah, Fusebox 3 is now offically has a TLA :) jon - Original Message - From: Jeffrey Cohen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 5:25 PM Subject: Re: Ecommerce?? FB3??? Jeffrey George Larkin wrote: I'm putting together a bid for my client on a site which incorporates Ecommerce. Does anyone know of an FB3 Ecommerce solution? It doesn't need to be full of gadgets, just the basic framework will do. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Ecommerce??
FuseBox 3 It's the brand new version of FuseBox (a CF coding methodology). OT: I've found the usability and wonderful simplicity of Cold Fusion to be somewhat compromised in this latest version of FuseBox, but its wide-spread acceptance helps offset some of that since I can treat someone elses code like my own if they also use it. From: Jeffrey Cohen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Ecommerce?? Date: Fri, 22 Feb 2002 17:25:50 -0500 FB3??? Jeffrey George Larkin wrote: I'm putting together a bid for my client on a site which incorporates Ecommerce. Does anyone know of an FB3 Ecommerce solution? It doesn't need to be full of gadgets, just the basic framework will do. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Cities
Thanks Raymond for the update. Glad to know things are still moving along! Tom -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 4:29 PM To: CF-Talk Subject: RE: List of Cities I wrote a bunch of UDF's for latlon calculations and posted them at cflib.org about two weeks ago. I see they are still sitting in the submission queue. Why does it take two weeks to get to it guys? One word - Neo. :) (In other words, I'm _very_ busy, as is Rob right now.) We just published a set of UDFs and will be getting more up soon. Remember, we check the code for best practices as well as proper categorization. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ecommerce??
Actually yes I do! We are in the final stages of converting NetReady to FB3. NetReady is a feature-rich e-commerce engine and might be overkill for what you need, but you can't go wrong for the price and it blows away everything else out there! Check it out... http://aloha-webdesign.com/ (click on the NetReady links near the center of the page) Email me off-list for more info. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: George Larkin [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:00 PM To: CF-Talk Subject: Ecommerce?? I'm putting together a bid for my client on a site which incorporates Ecommerce. Does anyone know of an FB3 Ecommerce solution? It doesn't need to be full of gadgets, just the basic framework will do. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_excel
Has anyone had experience with the doing this within this custum tag? (attached) I downloaded this great custom tag and it does what I need it to do. I'm just trying to figure out how I can control the numeric/dollar format on some, not all of the fields that are passed to be exported to an excel spreadsheet. I've tried adding some conditional logic that would detect if a string _x was passed within the headertitle, but couldn't get it to work. Any other advice would be great! Thank you in advance. D- __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Joining Tables from Different Datasources... Possible?
If this is not the case, you will need to use CF 5. I am indeed running CF5. I'm assuming you're referring to using query of queries: I know how to run a query of one query, but I don't know how to run a query that uses the results of two queries. How is this done? Thanks, Jamie On Fri, 22 Feb 2002 17:09:08 -0500, in cf-talk you wrote: If the two tables are on a SQL Server you could reference the full name in your query. SELECT T1.a, T2.b FROM database.username.tablename T1 INNER JOIN database2.username2.tablename ON If this is not the case, you will need to use CF 5. At 05:05 PM 2/22/2002 -0500, you wrote: How would I do a join of tables from two different datasources? Thanks, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF_excel
You can't attach files to the list... :( Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 4:52 PM Subject: CF_excel Has anyone had experience with the doing this within this custum tag? (attached) I downloaded this great custom tag and it does what I need it to do. I'm just trying to figure out how I can control the numeric/dollar format on some, not all of the fields that are passed to be exported to an excel spreadsheet. I've tried adding some conditional logic that would detect if a string _x was passed within the headertitle, but couldn't get it to work. Any other advice would be great! Thank you in advance. D- __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS-Access: nulls in numerics?
I believe I am getting 'syntax error in SQL statement' type of error messages because some of the rows in a numeric column in an Access database have zero and others are blank, leading me to believe they are NULL. Is there a way to test for a null value in a numeric field? Thanks In Advance, Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS-Access: nulls in numerics?
Post your code. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 3:53 PM To: CF-Talk Subject: MS-Access: nulls in numerics? I believe I am getting 'syntax error in SQL statement' type of error messages because some of the rows in a numeric column in an Access database have zero and others are blank, leading me to believe they are NULL. Is there a way to test for a null value in a numeric field? Thanks In Advance, Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS-Access: nulls in numerics?
how about: WHERE (field = '') OR (field IS NULL) Jamie On Fri, 22 Feb 2002 16:53:27 -0600, in cf-talk you wrote: I believe I am getting 'syntax error in SQL statement' type of error messages because some of the rows in a numeric column in an Access database have zero and others are blank, leading me to believe they are NULL. Is there a way to test for a null value in a numeric field? Thanks In Advance, Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Client Variable Storage on Mutilple Sites
This may be a dumb question, but oh well. I'm setting up a data source[s] to store client variables in cold fusion administrator. We have 3 test sites and a production site running from off a SQL server with each site having it's own database. The question is: Do I need to need to create four different databases to store the client variables for each of these four sites or can I have one server act as a central repository without any possible problems of funky data. Any help greatly appreciated, Doug __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client Variable Storage on Mutilple Sites
I would. If you have to move a site for some reason, you can take it's client vars with it that way. - Original Message - From: Teel, C. Doug [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:24 PM Subject: Client Variable Storage on Mutilple Sites This may be a dumb question, but oh well. I'm setting up a data source[s] to store client variables in cold fusion administrator. We have 3 test sites and a production site running from off a SQL server with each site having it's own database. The question is: Do I need to need to create four different databases to store the client variables for each of these four sites or can I have one server act as a central repository without any possible problems of funky data. Any help greatly appreciated, Doug __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client Variable Storage on Mutilple Sites
On 2/22/02, Teel, C. Doug penned: The question is: Do I need to need to create four different databases to store the client variables for each of these four sites or can I have one server act as a central repository without any possible problems of funky data. The latter. That's why client variables work in clustered environments. If they were in separate databases there would be no advantage over using session variables, other than they don't need to be locked and will stay intact during a server reboot or ColdFusion restart. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Newbie Question
At 05:24 PM 2/22/02 -0500, you wrote: Hi Guys - I just purchased a Cobalt RAQ from Sun, and installed cold fusion version 5 on the server. I have a couple of Access Databases that I want to use as my ODBC data sources. I know there is an odbc driver available for NT Boxes, but what about my Cobalt RAQ XTR running Linux??? Are you trying to connect to access files on the cobalt box itself or are the database files on another server? Do you know if Access is available for SUSE (that's the variety of linux in there)? It's possible that the ODBC drivers don't require that Access be installed on the database machine, but I doubt it. If you are connecting to another machine, the drivers should work, theoretically. The drivers install with CF, and are not part of the MS operating systems. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Newbie Question
Well, I'd LIKE to run them on the same machine, but I guess that's not go nna be possible from what people are teeling me here, so I guess I'm gonna ha ve to learn MySQL (Oh Joy! Another learning curve cuz I have nothing but time...!) Which is why I bought the RAQ in the first place...Cuz it was Plug and Play! Oh well... Thanks... Of course, The RAQ does come with PHP and Postgress for free, so maybe if I have to learn something... Jeffrey Jennifer Larkin wrote: At 05:24 PM 2/22/02 -0500, you wrote: Hi Guys - I just purchased a Cobalt RAQ from Sun, and installed cold fusion version 5 on the server. I have a couple of Access Databases that I wa nt to use as my ODBC data sources. I know there is an odbc driver availab le for NT Boxes, but what about my Cobalt RAQ XTR running Linux??? Are you trying to connect to access files on the cobalt box itself or a re the database files on another server? Do you know if Access is availabl e for SUSE (that's the variety of linux in there)? It's possible that the ODBC drivers don't require that Access be installed on the database machine, but I doubt it. If you are connecting to another machine, the drivers should work, theoretically. The drivers install with CF, and ar e not part of the MS operating systems. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Newbie Question
Well nuthin wrong with learning a new thing. Plus you can offer clients a cheaper solution and get more business. Doug Brown - Original Message - From: Jeffrey Cohen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 7:37 PM Subject: Re: Newbie Question Well, I'd LIKE to run them on the same machine, but I guess that's not go nna be possible from what people are teeling me here, so I guess I'm gonna ha ve to learn MySQL (Oh Joy! Another learning curve cuz I have nothing but time...!) Which is why I bought the RAQ in the first place...Cuz it was Plug and Play! Oh well... Thanks... Of course, The RAQ does come with PHP and Postgress for free, so maybe if I have to learn something... Jeffrey Jennifer Larkin wrote: At 05:24 PM 2/22/02 -0500, you wrote: Hi Guys - I just purchased a Cobalt RAQ from Sun, and installed cold fusion version 5 on the server. I have a couple of Access Databases that I wa nt to use as my ODBC data sources. I know there is an odbc driver availab le for NT Boxes, but what about my Cobalt RAQ XTR running Linux??? Are you trying to connect to access files on the cobalt box itself or a re the database files on another server? Do you know if Access is availabl e for SUSE (that's the variety of linux in there)? It's possible that the ODBC drivers don't require that Access be installed on the database machine, but I doubt it. If you are connecting to another machine, the drivers should work, theoretically. The drivers install with CF, and ar e not part of the MS operating systems. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Listing from another boxes' directory
Im attempting to scour the log files of our two production servers from our dev box tragically, my efforts in mapping the shared directories hasnt helped cfdirectory get the goods. Is there a means, method, hack or other possibility to reading a locally networked computers shared directories from a separate box? Any one have a scheme to pull this one off? ronald-thomas w: wildminds.net http://wildminds.net/ c: 512.426.4233 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Listing from another boxes' directory
[insert sarcastic remark about searching the archives here] Easy fix. You need to change the user that the CF service runs as to one that has access to network resources. The default user does not. Im attempting to scour the log files of our two production servers fro m our dev box tragically, my efforts in mapping the shared directories hasn t helped cfdirectory get the goods. Is there a means, method, hack or ot her possibility to reading a locally networked computers shared directorie s from a separate box? Any one have a scheme to pull this one off? ronald-thomas w: wildminds.net http://wildminds.net/ c: 512.426.4233 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
