RE: OT: Paid by a percentage of the gross?? Anyone?
Why not an option for you to choose? How about this: Keep track of the hours you spend building the site. Multiply that by some rate...suppose $30/hour for the sake of discussion. That is the your minimum fee. If the site hasn't generated $XX of profit in 6 months, you get your hourly rate fee. If it does meet or exceed the profit goal, you get a percent of gross. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 08, 2002 10:01 AM To: CF-Talk Subject: Re: OT: Paid by a percentage of the gross?? Anyone? Stock options used to be popular too. I would recommend charging an hourly rate. On Mon, 9 Sep 2002, Michael Kear wrote: > Is anyone here being paid for their development work with a percentage > of the gross from the site they're working on? > > > I have a client who's telling me with convincing assurance that his > site Is going to make a mint, and I'd be much better off taking 20% of the gross > revenue than charging a fee for service based on my hourly rate.I can > see every transaction going through the site, so I know I'll be able > to verify how much I'm owed. In fact I can probably have it pay me > direct to my account from the credit card transactions. > > > He's probably right, he's probably going to do quite well with his site .. > he has orders backing up already before the site's even started, but > all my instincts are telling me to say "no thanks I'll take my chances > with a fee for service". > > > I know it's up to me to decide which way I'll be better off, but I was > wondering if anyone else has made this sort of arrangement and how > it's worked out. > > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Large Corporations that use ColdFusion
US Air Force, Defense Intelligence Agency, US Navy, etc.. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:41 AM To: CF-Talk Subject: Re: Large Corporations that use ColdFusion national geographic's geographynetwork also uses cf. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best JAVA Book...
Try this free ebook before you buy one: http://www.mindview.net/Books/TIJ/ Tom -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 3:39 PM To: CF-Talk Subject: RE: Best JAVA Book... So far I like the books that Sun publishes. > -Original Message- > From: Ken Brocx [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 19, 2002 3:26 PM > To: CF-Talk > Subject: OT: Best JAVA Book... > > Hi, I’d like some advice on a good JAVA book. > I know CF and ASP, but JAVA is new to me. > Thanks, > Ken > > > * Ken Brocx > * SeniÅr Developer > * Dealer Trade Group > * (425) 452-3651 > * [EMAIL PROTECTED] > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Win2k Clock....
www.acronymfinder.com -Original Message- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 2:12 PM To: CF-Talk Subject: Re: Win2k Clock Wholly acronyms batman At 08:48 PM 03/10/02 +0200, you wrote: >Brook wrote: > > What is the best/correct way to set the time on a webserver? > >UTC and link it to a NTP server (usually there is some standards agency >like NIST that offers this service). Makes it a lot easier to >synchronize logfiles if necessary. If you have multiple servers, >consider running your own NTP server. > >Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT: Browser Usage
I STILL get occasional NS 2.0 Users... Tom -Original Message- From: David Groth [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 9:47 AM To: CF-Talk Subject: Re: OT: Browser Usage Granted this is an academic environment, but here are our Netscape stats for last month. Netscape Browsers Browser - Hits - % of Total Hits - Visits 1 Netscape 4.76 - 19,452 - 13.46% - 2,720 2 Netscape 4.75 - 10,471 - 7.24% - 2,469 3 Netscape 4.77 - 8,255 - 5.71% - 1,799 4 Netscape 4.7 - 12,585 - 8.70% - 1,738 5 Netscape 6.1 - 8,282 - 5.73% - 1,386 6 Netscape 4.79 - 9,397 - 6.50% - 1,358 7 Netscape 6.2 - 7,894 - 5.46% - 1,315 8 Netscape 4.5 - 6,005 - 4.15% - 1,188 9 Netscape 7.0 - 6,304 - 4.36% - 1,104 10 Netscape 4.73 - 5,284 - 3.65% - 1,032 11 Netscape 6.2.3 - 5,234 - 3.62% - 1,030 12 Netscape 5.0 - 3,600 - 2.49% - 1,028 13 Netscape 6.2.2 - 4,468 - 3.09% - 967 14 Netscape 4.78 - 4,827 - 3.34% - 759 15 Netscape 4.72 - 3,192 - 2.20% - 746 16 Netscape 6.2.1 - 2,594 - 1.79% - 578 17 Netscape 4.61 - 4,003 - 2.77% - 568 18 Netscape 4.08 - 2,482 - 1.71% - 481 19 Netscape CIRT - 4,957 - 3.43% - 418 20 Netscape 4.51 - 1,391 - 0.96% - 243 Total For Browsers Above 130,677 - 90.42% - 22,927 David Groth, Analyst/Programmer III HSC Library & Informatics Center, University of New Mexico 505.272.8406 e-mail: [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 10/09/02 05:50PM >>> Hi All, Does any one know what percentage of users use/ prefer Netscape 4.5 or 6 over IE. Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Integrating with Flash
How about putting them on a web site we can all download it instead of sending it to everyone individually? Tom At 8/3/00 09:04 AM, you wrote: >Same here, if you don't mind. > >TIA, >-Kevin > >-Original Message- >From: Norman Elton [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 03, 2000 9:00 AM >To: [EMAIL PROTECTED] >Subject: RE: Integrating with Flash > > >I'll take a copy of your files too :). Thanks! > >Norman > >On Thu, 3 Aug 2000, Reynolds, Adam wrote: > > > Could you copy me in on this. I would be very interested. > > > > > -- > > > From: Sean Renet[SMTP:[EMAIL PROTECTED]] > > > Sent: 03 August 2000 12:24 > > > To: [EMAIL PROTECTED] > > > Subject:Re: Integrating with Flash > > > > > > I have a day left of crazy left, then I will email you an fla file and >cf > > > template off list. > > > - Original Message - > > > From: "Rich Wild" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, August 03, 2000 1:53 AM > > > Subject: RE: Integrating with Flash > > > > > > > > > > Yeah - I wasn't talking semantics though, I am genuinely interested in > > > how > > > > you pull those variables out - where does the LoadVariables pull the >CF > > > > variables from? > > > > > > > > I've used URL variables before fine - but limited as I said, due to >the > > > max > > > > length of a URL string > > > > > > > > I've used textfiles also - getting CF to create a textfile with the > > > > variables written into it: > > > > > > > > eg: variables.txt > > > > ** > > > > > > > > var1 = Hello > > > > var2 = Cheese > > > > var3 = red hot poker > > > > > > > > ** > > > > > > > > And Then Flash LoadVariables from variables.txt > > > > > > > > Now I *know* that this is brutish and poor. Must be. Makes me wince >just > > > > looking at it. > > > > > > > > How specifically are you handling it? I long for a better way... > > > > > > > > -- > > > > Rich Wild > > > > Senior Web Designer > > > > > > > > --- > > > > e-mango.com ltd Tel: 01202 587 400 > > > > Lansdowne Place Fax: 01202 587 401 > > > > 17 Holdenhurst Road > > > > Bournemouth Mailto:[EMAIL PROTECTED] > > > > BH8 8EW, UK http://www.e-mango.com > > > > --- > > > > This message may contain information which is legally > > > > privileged and/or confidential. If you are not the > > > > intended recipient, you are hereby notified that any > > > > unauthorised disclosure, copying, distribution or use > > > > of this information is strictly prohibited. Such > > > > notification notwithstanding, any comments, opinions, > > > > information or conclusions expressed in this message > > > > are those of the originator, not of e-mango.com ltd, > > > > unless otherwise explicitly and independently indicated > > > > by an authorised representative of e-mango.com ltd. > > > > --- > > > > > > > > > > > > -Original Message- > > > > From: Sean Renet [mailto:[EMAIL PROTECTED]] > > > > Sent: 03 August 2000 09:44 > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: Integrating with Flash > > > > > > > > > > > > I seldom use url variables. I am sure that someone will respond with >a > > > > url/form variable dissertation. However, I generally have an action > > > page > > > in > > > > the background that does all the work and I have flash pull the > > > variables > > > > from it using flash's LoadVariables command. I suppose this is more > > > like > > > a > > > > form variable pass as the method is "post". I don't have much time to > > > get > > > > caught up in symantics, I just do what I think works the best. You > > > don't > > > > need text output per say, you can just use cfcontent. > > > > - Original Message - > > > > From: "Rich Wild" <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Thursday, August 03, 2000 1:03 AM > > > > Subject: RE: Integrating with Flash > > > > > > > > > > > > > Am I right in saying that you are limited to using URL variables >when > > > > > controlling Flash movies though? That's what I've picked up anyway > > > > > > > > > > Kind of annoying if you have a lot of text to output... > > > > > > > > > > > > > > > > > > > > -- > > > > > Rich Wild > > > > > Senior Web Designer > > > > > > > > > > --- > > > > > e-mango.com ltd Tel: 01202 587 400 > > > > > Lansdowne Place Fax: 01202 587 401 > > > > > 17 Holdenhurst Road > > > > > Bournemouth Mailto:[EMAIL PROTECTED] > > > > > BH8 8EW, UK http://www.e-mango.com > > > > > --- > > > > > This message may contain information which is legally > > > > > privileged
RE: I need a host. Intermedia testimonials
I have a Shanje account and it's marginally OK. If you have a low volume site and don't mind it being offline briefly twice per day when he re-sync's his servers, and don't mind not being able to install CFX tags and don't mind sharing a box with 13,000 domains that can give 4000-5000 ms query times with Access databases, and don't mind not having SQL server, then it's OK. (Remember I said LOW volume web sites). For development with Access, it's great. For email, it's normally OK but I've had reports of people trying to send me email that gets bounced. Overall, you get what you pay for. If you can live with these restrictions, then it makes sense. It's really great for domain parking. Tom Nunamaker [EMAIL PROTECTED] In article <[EMAIL PROTECTED]>, you say... > I was pretty amazed when i checked out what they're offering. After i > picked my chin up off my keyboard and backspaced over all the spaces it > caused i had wondered about their reliability. Has anyone used these guys? > How reliable are they? Being that all supportis via email, how good is the > response time? > > -Original Message- > From: paul smith [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 08, 2000 1:30 AM > To: [EMAIL PROTECTED] > Subject: RE: I need a host. Intermedia testimonials > > > No I don't use them. But I will in the future. > I am constantly impressed with Shiloh and the > technology he's developed to deliver reliability. > And the price is super. > > best, paul > > At 01:30 AM 8/8/00 -0400, you wrote: > >paul... do you use shanje? how are they? > > > >-Original Message- > >From: paul smith [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, August 08, 2000 12:56 AM > >To: [EMAIL PROTECTED] > >Subject: Re: I need a host. Intermedia testimonials > > > > > >Check out http://www.shanje.com/ > > > >best, paul > > > >At 09:04 PM 8/7/00 -0500, you wrote: > > >I need a host. and I gather from cftalk that Intermedia is the winner. I > am > > >interested in hearing testimonials or other alternatives. > > > > > >1 client, 10 domains and growing. > > > > > >Thanks > > >Eric Dawson > > > >--- > - > >-- > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > >To Unsubscribe visit > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Nate Weiss???
Did you try his website? http://www.nateweiss.com/cf/ Tom Nunamaker [EMAIL PROTECTED] At 8/24/00 03:42 PM, you wrote: >Does anybody know how to get in touch with the Nate. He is the one that >wrote the TwoSelectRelated and ThreeSelectsRelated tags. I have a unique >problem when using the threeselects tag that I need to solve. Has anybody >else used these tags, or rewritten them? > >TIA!! > >Bill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Resetting JRUN admin username/password?
Is there a way to disable or reset the JRUN username/password? I installed JRUN but can't seem to remember the right combination. Tom -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Scheduled Task
Nate Weiss posted information about doing this in the Allaire forums a long time ago. Here's where the thread is: http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=335617&_#Message335617 I've used InstantOn with great success for over 6 months. MUCH more reliable than CF's scheduler, plus it gives you really granualar control over how you schedule templates to be run. Tom Nunamaker At 9/1/00 10:34 PM, you wrote: >I assume there's some way to schedule a task on NT... on a Unix-type machine >I'd just add a cron job and use lynx or wget to call a URL. > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Reliable Host
I have a dedicated server with them and have two clients that still have contracts with their shared hosting. The last four of five emails I've sent to support we never answered. I ended up having to call them on the phone. Once I was speaking to someone, the problems USUALLY were resolved. One problem is their "dedicated server guy(s)" don't work at night so no one can touch my box when I'm working on it at night. That was a minor annoyance. Overall, I'd give them average marks for customer support but certainly nothing higher than average. Tom Nunamaker -Original Message- From: Dan Bies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 9:29 PM To: CF-Talk Subject: OT: Reliable Host Has anybody here had good experience with HostMySite.com? I'm looking at their Ultra Developer package and wondered what kind of up time, support and all round experience they have. Please contact me directly. Dan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does Macromedia have some current strong Flash agenda?
> Etrade has a stock quote component on their home page. People would put the quote > in, reload the whole page to get the data. They changed it to a Flash piece, only > that changed. Saved around $400 million for them in bandwidth charges. In the Macromedia seminar I attended last week, Mike Downey said Etrade saves about $4 million per year. Tom __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Statistics Tags
I suppose I could dig out my copy of DELPHI and see what functions are buried in there I could wrap into a DLL The functions tag I put in the taggallery is mostly the arc- trig functions. I needed these to do some great circle type computations...but they were already in DELPHI, so why not just include them all? :) If there's interest in it, I can possibly write something tonight. Cheers Tom Nunamaker [EMAIL PROTECTED] lsellers wrote: > > > Looking for a CFX tag or set of tags that perform > > standard statistical functions such as the binomial > > distribution, stand dev of the mean, Bayes theorem, > > etc. > > http://toshop.com/cfx_functions/cfx_functions.htm is the closest thing I > know of, cfx-wise. > > Been a few years since I've had stats. Don't recall seeing anything like > that around. If it's not that the tag gallery you might have to roll > your own. > > --min > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How not to be seen ...
Just wrap the CFOUTPUT in normal HTML comment tags Tom Todd Ashworth wrote: > > Is there a way to a variable, but not have it display on the web > page .. to only have it display if you look at the source? > > .Todd > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL 7 Functions
I would add that a common way to generate a random number between 1 and x is: mynumber = int( rand() * x ) + 1 As far as an online reference, you HAVE to bookmark this site: http://www.sqlprogrammer.com/manuals/helpsql/helpsql.html Regards Tom Nunamaker [EMAIL PROTECTED] Justin MacCarthy wrote: > > >From BOL- mathematical functions > > Using RAND > The RAND function calculates a random floating point number between 0 and 1, > and can optionally take a tinyint, int, or smallint value for the starting > point of the random number to calculate. > > This example calculates two random numbers. The first RAND() function lets > Microsoft® SQL ServerT pick the seed value, and the second RAND() function > uses the value of 3 for the starting position. > > SELECT RAND(), RAND(3) > > The RAND function is a pseudorandom number generator that operates in a > manner similar to the C run-time library rand function. If no seed is > provided, the system generates its own variable seed numbers. If you call > RAND with a seed value, you must use variable seed values to generate random > numbers. If you call RAND multiple times with the same seed value, it > returns the same generated value. This script returns the same value for the > calls to RAND because they all use the same seed value: > > SELECT RAND(159784) > SELECT RAND(159784) > SELECT RAND(159784) > A common way to generate random numbers from RAND is to include something > relatively variable as the seed value, such as adding several parts of a > GETDATE: > SELECT RAND( (DATEPART(mm, GETDATE()) * 10 ) >+ (DATEPART(ss, GETDATE()) * 1000 ) >+ DATEPART(ms, GETDATE()) ) > > When you use an algorithm based on GETDATE to generate seed values, RAND can > still generate duplicate values if the calls to RAND are made within the > interval of the smallest datepart used in the algorithm. This is especially > likely if the calls to RAND are included in a single batch. Multiple calls > to RAND in a single batch can be executed within the same millisecond, which > is the smallest increment of DATEPART. In this case, incorporate a value > based on something other than time to generate the seed values. > > See Also > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, May 23, 2000 1:20 PM > Subject: OT: SQL 7 Functions > > > > > Where do I find a list of functions for SQL 7? > > Specifically today I'm looking for equivalent to CF Randrange(): > > SELECT TOP 1000 * > > FROM users > > WHERE ID IN (randrange(1, 3)) > > But there has to be a list somewhere. I'm getting > > frustrated looking through the online help. > > > > > > > > > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Variables X and Y [SOLVED]
If you just want a plain button to click on to execute some javascript, don't forget about the Tom Nunamaker [EMAIL PROTECTED] Steve Reich wrote: > > It was the images I was using for submit buttons. > > - Original Message - > From: "Steve Reich" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, May 24, 2000 12:25 AM > Subject: Re: Variables X and Y > > > No image map but I have 3 submit buttons in various locations that are > image > > types...? > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Avoiding using the MAX function
In SQL server, you can do this: CREATE TRIGGER GetMax_ID ON mytable FOR INSERT AS SELECT mytable_ID FROM INSERTED When you run your query to do the INSERT, the trigger will fire and return the mytable_ID of the inserted record for you. Tom Robert Everland wrote: > > WHy not use a trigger? > > Robert Everland III > Web Developer > Dixon Ticonderoga > > -Original Message- > From: Olive, Christopher M Mr USACHPPM > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 24, 2000 1:08 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Avoiding using the MAX function > > yes, if you call a stored procedure to insert the record, and reference the > @@IDENTITY property after the SP call. > > Chris Olive > DOHRS Website Administrator > [EMAIL PROTECTED] > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 24, 2000 12:45 PM > To: Cf-Talk > Subject: Avoiding using the MAX function > > Hi Everyone, > > At the CFUG-orama in Washington DC last week, I think Ben Forta said that > there is a way to avoid having to use the "MAX()" SQL function to get the ID > number of the item you just inserted into a database. Can anyone tell me > how to do this? > > In other words, currently I'm doing something like this: > > > INSERT INTO tablename (x,y,z) > values ('x','y','z') > > > Then, to get the autonumber'ed ID of the item I just inserted, I'll use: > > > Select Max(ID) as the_newest_record > >From Tablename > > > Now I'll have the ID number of the newest inserted record in > #get_the_newest_record.newest_record#. > > If I understood Ben correctly, then there is a way to insert the record AND > return the ID number of that inserted record all at the same time. > > The database in question is a SQL Server database. (Although it would be > good to know how to do it with MS Access if its possible). > > Thanks, > > Eron > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cold Fusion-based email server...?
We use a Linux box on a separate machine for our intranet running RedHat 6. It's extremely fast to send/receive mail and EXTREMELY reliable. It's the only machine in my server room that can run for months without rebooting. Tom Ian Lurie wrote: > > Hi all, > > I've seen this thread before, but can't find the info - what's everyone's CF > email system of choice? > > Ian > > Portent Interactive > http://www.portentinteractive.com > Process, Design, Content > > Market Matrix > http://www.marketmatrix.com > Secure Commerce for Your Business > > Working together to create powerful, usable web solutions. > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cf_TwoSelectsRelated
You need to put the tag where Cold Fusion can see it. Either in the same directory as the calling template or the custom tag directory Tom Katie Howell wrote: > > Can anyone help me with the TwoSelectsRelated tag? I've never used one > before, and here's the error I'm getting: > > Error Diagnostic Information > Cannot find CFML template for custom tag TWOSELECTSRELATED. Cold Fusion > attempted looking in the tree of installed custom tags but did not find a > custom tag with this name. > > The error occurred while processing an element with a general identifier of > (CF_TWOSELECTSRELATED), occupying document position (12:1) to (20:19). > > Thanks in advance! > > Katie > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: I want my #$# on the first of the month.
> > > > > > > >#createodbcdate(thedate)# > > You can't just add 1 to the current month...what happens when it is > December? You do indeed need to use the DateAdd function to do something > like this. You don't NEED to use DateAdd, but it makes the code shorter. You COULD use something like this: There are always alternative ways to do things. Tom -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Best Method
Specify a maxrows attribute in your CFQUERY call and sort by date descending: SELECT FROM .. WHERE .. ORDER BY submittedDateTime DESC Tom Nunamaker Jeffrey Cohen wrote: > > Greetings... > > What is the best method for reading ONLY the last five records in a > database for display? > > I have a client that adds articles daily to a news database, and then > displays them on a news page. There are hundreds of articles, and on his > home page he just wants to display the 5 most recent. (which would be > the last five in the database, I presume) > > Suggetstions??? > > and thanks as always for your help in advance... > > Jeffrey Cohen > ImageWorks > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cheating: Time Zone rules
Eric, We have that data in a program called "Andromeda" by camp-sys. They might be willing to sell you the data. One other consideration is Europe switches daylight savings time 1 week off from the states. I don't know about other continents, but that's something you don't want to forget. Our flight schedulers for my USAF organization do everything in Universal time (ZULU) and convert it to local for the customers with the data from Camp-Sys. If you have access to the Flight Information Publications (FLIP), the IFR Supplement has time zone information in it. It's an unclassified publication. My guess is you can buy a copy of it from the National Image and Mapping Agency (NIMA). Let me know if you still need help. Tom At 6/7/00 10:10 AM, you wrote: >Is there a custom tag that converts time to different time zones around the >world. The calculations are relatively simple, but I think you have to worry >about different times that daylight savings is in effect. > >This is going to be used to calculate local times for international airline >schedules. > >Thanks >Eric > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Oracle vs SQL server
Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? I tend to say no just because everything is already working, including some stored procedures and triggers. Has anyone had to do this migration path? What are the Advantages of Oracle over SQL Server?I've read some great things about SQL server 2000 and wonder if any advantages Oracles has at the moment will be gone with SQL Server 2000 is released later this year. Any other thoughts? Thanks Tom Nunamaker, Maj, USAF USAFE AMOCC/SC Chief, Communications Branch Senior Web Developer Ramstein AB, Germany -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle vs SQL server
Why would I spend money for Sybase when I already have SQL server and could get Oracle for free?? Tom At 6/21/00 09:04 AM, you wrote: >At 01:18 PM 6/21/2000 +0200, you wrote: > >Hi everyone. > > > >We're using SQL server 7.0 and it's working great. The DoD recently > >purchases a site license > >for the entire DoD for Oracle. My question is should I move my SQL server > >DB to Oracle? > >Just to be contrary, I'd put my vote in for Sybase. Great database, >reasonably decent company to work with (especially compared to Microsoft >and Oracle), and a good price point. > >Judah > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Slightly OT: MS SQL 6.5 -> 7 upgrade
Try pricewatch.com PC Nation had a 5 user upgrade of $319 Also check ebay...you never know. Tom At 6/24/00 02:42 PM, you wrote: >Does anyone know where I can purchase MS SQL Server 7.0 upgrade? I want to >upgrade an existing 6.5 server. > >Thanks, > >Howie Hamlin >-- >inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 >www.CoolFusion.com > >Please vote for iMS in the Most Innovative category here: >*** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** > >Check out inFusion Mail Server - the world's most configurable email server > > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: return value of Identity Column
There's another way with SQL Server using a trigger: CREATE TRIGGER GetPK_MyTable ON MyTable FOR INSERT AS SELECT MyTable_ID FROM INSERTED When you do your CFQUERY and perform the SQL INSERT, SQL server will return the inserted ID via the trigger!!! Using the @@IDENTITY variable isn't guaranteed to be correct under heavy load from my understanding. Tom Nunamaker [EMAIL PROTECTED] At 6/30/00 12:41 PM, you wrote: >There are a couple of ways, some more preferred than others. > >Option 1 (Best for Beginners and Learning, can sometimes give erroneous >results) > >Perform the insert into the database. My assumption is that you are using an >Identity field, like the Autonumber field in Access or Identity in MS SQL >Server. This gives every record a UNIQUE ID. > >Now immediately run a query that gets the MAX (a SQL Aggregate Function) of >the Identity field. >You should enclose this in a simple CFTRANSACTION tag. > >So, > > >INSERT INTO table (field) >VALUES (form.values) > > > >SELECT MAX(ID) as MaxID >FROM table > > > > >#get_new_id.MaxID# > > >That will do it for the easier way and is good for learning. > >Option 2 (More inline with larger applications and advance SQL Server - uses >stored procedure. You'll need to read the docs on this one for additional >details that I will not detail here. I have seen no books with good examples >(anyone?). (This example is using MS SQL Server) > >Here is the Stored Procedure:*** > >CREATE PROC sp_insertApplicant > >@FirstName varchar(50), >@MiddleName varchar(50), >@LastName varchar(50) > >AS > >INSERT INTO tblApplicants > (FirstName, > MiddleName, > LastName) >VALUES > (@FirstName, > @MiddleName, > @LastName) > >SELECT ApplicantID = @@IDENTITY > >Here is the code in the CFM: > >returncode="Yes" debug> > > > > > type="IN" > cfsqltype=cf_sql_varchar > value="#form.FirstName#" > dbvarname=@firstname> > > type="IN" > cfsqltype=cf_sql_varchar > value="#form.MiddleName#" > dbvarname=@middlename> > > type="IN" > cfsqltype=cf_sql_varchar > value="#form.LastName#" > dbvarname=@lastname> > > > >Now you get a result set in the form of a variable called RS1. So, in this >instance we returned the new applicantID, or RS1.ApplicantID. You can use >RS1.RecordCount to see how many records were returned (one in this case) and >RS1.ColumnList for a list of Columns returned (again, one, ApplicantID). > >We can use the result, the RS1.ApplicantID, to retrieve the record we just >created. > > >SELECT * >FROM tblApplicants >WHERE ApplicantID = #RS1.ApplicantID# > > >If I missed anything or am in error, it was the Martians who made me do it. >I waive all responsibility for my actions (seems to be going around these >days). > >This is my favorite and seems pretty fast. Feel free to contact me off list. > > >Gary McNeel, Jr. >Project Manager - DAC-Net, Research & Graduate Studies >Rice University - Houston >[Lovett Hall] 713-348-6266 (Primary) >[DAC] 713-348-5184 >[M] 713-962-0885 >[H] 713-723-9240 > >"The politicians don't just want your money. They want your soul. They want >you to be worn down by taxes until you are dependent and helpless. When you >subsidize poverty and failure, you get more of both." >-James Dale Davidson > > > -Original Message- > > From: Shawn Mirza [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 30, 2000 11:59 AM > > To: [EMAIL PROTECTED] > > Subject: RE: return value of Identity Column > > > > > > I know its an @@id when looking it up in a stored proc > > > > -Original Message- > > From: Jason Zimmerman [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 30, 2000 12:35 PM > > To: Cf-Talk (E-mail) > > Subject: return value of Identity Column > > > > > > Is there a way to return the value of an Identity Column after an insert > > into a SQL db? > > > > Thanks, > > -Jason > > -- > > -- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit >
Re: return value of Identity Column
At 7/1/00 12:44 PM, you wrote: > > Using the @@IDENTITY variable isn't guaranteed to be > > correct under heavy load from my understanding. > >thats an urban myth. it scales just fine. I just read the recent discussion on the forums (http://forums1.allaire.com/DevConf/Thread.cfm?&&Message_ID=504660&_#Message504660) about this. I had the impression the @@IDENTITY function returned the last identity value used by the SQL server, regardless of user. This was wrong. It's the last identity value used by that connection. As mentioned in the thread by Paul, there are several ways to do it with SQL server. I agree the best way is using a SP. Thanks Paul! Tom -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: forums.allaire.com
I've noticed the same problem Tom lsellers wrote: > > Anyone else have trouble with the forums? The last few days it keeps > reseting the connection before it can get more than a few threads down the > list. > > --min > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: When should I use CFLOCK?
Ben, After reading the Allaire KB article on locking, I put CFLOCK's around all instances of any session or server variables. The one place that seems a bit muddy is if the read is within a CFIF statement. I put the lock around the entire CFIF but is that required? I implied that it was from the KB article but I have never seen that specifc guidance anywhere. Thanks Tom At 7/6/00 05:02 PM, you wrote: >Tom, > >I just finished a column on just this subject for the August CFDJ. But to >summarize, locks are necessary if there is EVER a chance that shared >variables are updated. SESSION variables pretty much always need locks. >APPLICATION variables need locks if they are updated, if they are only ever >set once and are never ever written to again then the truth is they do not >need a lock (but ONLY if you can be sure of that). You could use a READONLY >lock to be sure, that does not have any real overhead and you can be safer >that way. > >--- Ben > > >-Original Message- >From: Tom Dyson [mailto:[EMAIL PROTECTED]] >Sent: Thursday, July 06, 2000 8:33 AM >To: [EMAIL PROTECTED] >Subject: When should I use CFLOCK? > > >The Allaire knowledge base article on monitoring memory usage states: > >One of the most common causes [of increased memory usage] are improperly >locked access to session, application, and server variables. These variables >are stored in memory and need to be enclosed in a CFLOCK tag with the >appropriate SCOPE attribute specified (i.e. session, application, or server) >when referenced. > >while Ben Forta says: > >Caution: avoid unnecessary use of . Forcing code to single-threaded >use only can seriously impact system performance. > >We're building an application which uses session and application variables >on every page (for security and user customisation). Should we use >when we read them? Or when we write them? Or both? Does anyone have any >guidelines on usage? > >Thanks > >Tom > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cf hosting
Unlimited domains like Shanje.com At 7/10/00 10:17 PM, you wrote: >We're thinking of starting a CF Developer hosting solution - do any of you >have some ideas or suggestions on what you would like to see in a cf hosting >provider? > >Any comments are appreciated. > >Thank you, >Jason Egan >Konnections > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What are you using instead of IDENTITY?
In Joe Celko's book "SQL for smarties", he blasts IDENTITY and other Generator Functions as "a horrible, nonstandard, nonrelational proprietary extension that should be avoided whenever possible" (p 63 if you have the book) I wrote Joe about this with this reply: === >> You don't mention why or alternatives. I work with SQL server and the topic of the @@IDENTITY variables comes up over and over. Some say use it, others like yourself say avoid it. What arguments can I bring to the table against using @@IDENTITY ? << Not Standard, not portable, and has a lot of weird side effects and behaviors (scan the UseNet and other postings from people having problems with it). For fun, build a table with one column that is an IDENTITY column, then try to insert, update and delete from it. You'll find out that it is not a table because it does not behave like a table. Conceptually, it is non-relational. If I insert the sequence {a, b, c} into a table with the IDENTITY column, they get the numbering ((a,1), (b,2), (c,3)), but if I insert the sequence {c, a, b} into a table with the IDENTITY column, they get the numbering ((c,1), (a,2), (b,3)) instead. Suddenly, ordering affects the attributes of an entity, in violation of a basic relational principle that says we are using (unordered) sets. For a data modeling viewpoint, why is a number associated at ransom with an entity? What does it mean? It means that you could not think of a good way to identify one entity from another and in desperation, you faked it!! Timestamping rows at least marks an event. --CELKO-- === The question to the group is: "What are you using instead of IDENTITY?" Perhaps you are using it and disagree with Joe Celko. What are your thoughts? Tom -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Dymanic Menu
http://popup.jscentral.com/ Tom At 7/11/00 10:43 AM, you wrote: >Hi, > >I'm looking for a dynamic menu(cross browser). > >Any Links? > > >Thanks > >Christian Labrecque >Web Developper >[EMAIL PROTECTED] >Filament Communications >www.filamentinc.com > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What are you using instead of IDENTITY...Part II
Continuing the dialog with Joe Celko, here's more fuel to the fire. New questions raised by Joe's latest email: * Has anyone looked at ORM? * I personally love ERwin. What better alternative is there? * The next step is to ask Joe Celko if he ever recommends a surrogate key. Tom Nunamaker [EMAIL PROTECTED] = >> If I have a table with repeating information, suppose a city field in an employee table for example, to normalize it you would break the city into a separate table. If I used the city name as the primary key for this "city" table, then it wouldn't accomplish anything to put it in it's own table. << That is a bad example. Each city in a Personnel table (remember use a plural or collective noun for table names) is probably going to be part of a different address -- mailing address, his/her doctor's address or whatever. Try a Personnel table with columns called kid1, kid2, and kid3 for his dependents. Clearly having a Dependents table is much better design -- it beats the heck out of requiring everyone to have three kids or to kill one if they have over-breed. >> I could create an INTEGER field in this city table and reference the integer in the employee table. That would certainly take up less space overall. Are you saying it's better to NOT to do something like this? Instead, just put the repeating city name in the employee table and forget the city table? << I would use the SAN (Standard Address Number) if I were in the book trade. It is a number for all the bookstores and publishers in the US. This is because the set of addresses can be treated like an entity in that model. I am saying look at your model. If Addresses are a serious part of the business model and appear in multiple places, then I would also have a table for (zipcode, city, state) and assemble the addresses from this and the street address line. ZIP codes get changed more than people think. If the addresses are not reused much, then put them with the table to which they belong. What you save in space with a separate address code, you will lose in doing JOINs. >> I've 'faked it' using IDENTITY fields but I'm willing to use a better approach if I can. How do you handle situations like this? I see "identifier" fields in the book "Data Modeling with ERwin". I know LOTS of developers using it. << I know a lot of developers who do it, too. I bill their employers $1500 to $2000 per day to fix that kind of code. Oh, ERwin is a bad tool. It has planar graph problems, cannot show constraints, returns only one schema, etc. You might want to look at ORM modeling methods. --CELKO-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What are you using instead of IDENTITY...Part II
At 7/12/00 10:23 PM, you wrote: >Is it just me, or does Joe seem to avoid the actual questions that Tom has >asked?? Or have the questions been truncated in some way? Nothing was truncated. I just copied and pasted the email Joe Celko sent to me. To be honest, Joe had me doubting my database modeling technique. I'm still open to better ways. Perhaps ORM is better. I am just discovering it now. So far, it seems very similar to the ER diagrams I can make with ERwin. Little apparent benefits so far. I had the same feeling that Joe was being a good politician and avoiding my question. I was going to ask his thinking about surrogate keys, but I'm happy with the way I do things now (WITH surrogate keys). At the least, Joe's comments stirred up quite a good discussion. I look forward to more of the same in the future here! Tom Nunamaker [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cftransaction error ? HELP.
Whatever the primary key is in that database, you're trying to insert a duplicate. Tom At 7/14/00 05:30 PM, you wrote: >Below is an error Im getting from a transaction that I didn't write... >and the developer is long since gone...he sort of documentmented >his code...but not really. This is the result from a form input. > >Below the result...is the transaction statement. > >Below the transaction statement is a function the developer used to >increment a new record in the table nxstar_e...am I wrong ? Its used >as an includes BEFORE the transaction statement gets called and thats >where the problem exists. Hence the error message below. Would >someone like clue me into what in the hell is going on here...I think >Im outta my depth. Ive pulled this thing apart six ways from sunday >and it still doesn't work...perhaps it never worked...I dont know. > >Help > >++ >ODBC Error Code = 23000 (Integrity constraint violation) > >[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY >constraint 'PK__nxstar_e__076C2375': Attempt to insert duplicate key >in object 'nxstar_e'. > >SQL = "insert into nxstar_e ( tar_num, type, tar_status, synopsis, >description, >prod_id, symptom_code, cust_code, bus_name, address1, address2, >address3, address4, contact, phone, entered_by, entered_date, >entered_time, opened_date, opened_time, priority, assigned_to, >assigned_by, assigned_date, assigned_time ) values >( 5456, 'CASE', 'NEW', 'sdsdfsdfsdf', 'sdfsdfsdfsdfsdfsdfsdfsdf', etc...) > >Data Source = "CCare Web" > >The error occurred while processing an element with a general >identifier of (CFQUERY), occupying document position (23:1) to (23:52). >+++ > >+++ > > > > > > > > > > > >insert into nxstar_e ( >tar_num, type, >tar_status, synopsis, description, >prod_id, >symptom_code, >cust_code, bus_name, address1, >address2, address3, address4, >contact, phone, >entered_by, entered_date, entered_time, >opened_date, opened_time, >priority, >assigned_to, assigned_by, assigned_date, assigned_time >) >values >( >#llTarNum#, 'CASE', >'NEW', '#synopsis#', '#description#', > > '#prod_id_other#', > > '#prod_id#', > >'#symptom_code#', >#cust_code#, '#qCustomer.bus_name#', '#qCustomer.address1#', >'#qCustomer.address2#', '#qCustomer.address3#', '#qCustomer.address4#', >'#Contact_Name#', '#phone#', >'WEB', #lsODBCDate#, '#lsTime#', >#lsODBCDate#, '#lsTime#', >2, 'WEB', 'WEB', #lsODBCDate#, '#lsTime#' >) > > > > > > > > > >insert into nxsnotes ( >note_id, id, topic, type, >synopsis, >entered_by, entered_date, entered_time, >opened_date, opened_time, >completed, completed_by, completed_date, completed_time, >minutes_spent, billable >) >values >( >#llNextID#, #llTarNum#, 'CASE', 'CCARE', >'Time spent adding New Case', >'WEB', #lsODBCDate#, '#lsTime#', >#lsODBCDate#, '#lsTime#', >'CCARE', 'WEB', #lsODBCDate#, '#lsTime#', >1, 'N' >) > > > > > > > >select last_used >from nxsprimr >where table_name = '#lsTableName#' >and column_name = '#lsColumnName#' > > > > > > > > > > update nxsprimr > set last_used = #llNextID# > where table_name = '#lsTableName#' > and column_name = '#lsColumnName#' > > > > > > > > select max(#lsColumnName#) mymax > from #lsTableName# > > > > > > insert into nxsprimr (table_name, column_name, last_used) > values ('#lsTableName#', '#lsColumnName#', #llNextID#) > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: email server
Sendmail on RedHat Linux :) At 7/21/00 05:47 PM, you wrote: >What's the name of the email server product which integrates well with CF? >The name is on the tip of my fingers, but... I can't remember now. > >Thanks! > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: email server
I don't see why not. Sendmail is Sendmail. Just get it working on whatever *nix you like. (Is there a Windows version of Sendmail? I haven't looked) My NT Cold Fusion server is perfectly happy talking to my Linux sendmail. I tried with the base Exchange server but my Linux box is WAY faster than Exchange Tom At 7/21/00 05:12 PM, you wrote: >At 11:59 PM 7/21/00 +0200, you wrote: > >Sendmail on RedHat Linux :) > >"Only on RedHat? Is it compatible with sendmail on any other systems?" she >says having already blown her cover on the BSD topic earlier today. > > > >At 7/21/00 05:47 PM, you wrote: > > >What's the name of the email server product which integrates well with CF? > > >The name is on the tip of my fingers, but... I can't remember now. > > > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Database Design
Email me off list if you need help Tom Nunamaker [EMAIL PROTECTED] At 7/22/00 09:54 AM, you wrote: >Hi, > > >I need to build a database with Access for a classified services such this >one:http://www.4starads.com/classifieds/ >Is anybody can help with the design of the Database (Sample file or model)? > > >Thanks > >Regards, >Rémi van der Deure > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebarsts&bodysts/cf_talk or send >a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie needs a little PRO help
Don't forget to wrap the CFQUERY doing the INSERT and the CFQUERY doing the SELECT with a CFTRANSACTION tag. Tom At 7/23/00 01:48 AM, you wrote: >Or, would you lock the tables used in the set of queries that include the > > SELECT Max(ID) AS mid FROM Table_Name? > >Sorry, still thinking aloud. > >Stephen R. Cassady >Publisher, Spank! Youth Culture Online >http://www.spankmag.com >[EMAIL PROTECTED] > > > If I understand you correctly, you need the "autonumber" that was just > > created when you inserted data into your db. If this is correct, try this: > > > > > > SELECT Max(ID) AS mid FROM Table_Name > > > > > > Hope that helps... > > > > Mark > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: email server
I know I know. But for those less silly in the crowd. At 7/23/00 06:18 PM, you wrote: >I think you missed the BSD conversation in which I previously blew my >cover. I was being silly. > >At 11:38 AM 7/22/00 +0200, you wrote: > >I don't see why not. Sendmail is Sendmail. Just get it working > >on whatever *nix you like. (Is there a Windows version of Sendmail? > >I haven't looked) My NT Cold Fusion server is perfectly happy > >talking to my Linux sendmail. I tried with the base Exchange > >server but my Linux box is WAY faster than Exchange > > > >Tom > > > > > >At 7/21/00 05:12 PM, you wrote: > > >At 11:59 PM 7/21/00 +0200, you wrote: > > > >Sendmail on RedHat Linux :) > > > > > >"Only on RedHat? Is it compatible with sendmail on any other systems?" she > > >says having already blown her cover on the BSD topic earlier today. > > > > > > > > > >At 7/21/00 05:47 PM, you wrote: > > > > >What's the name of the email server product which integrates well > > with CF? > > > > >The name is on the tip of my fingers, but... I can't remember now. > > > > > > > > > > >- > > - > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > >To Unsubscribe visit > > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > >the body. > > > > > >- > - > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > >To Unsubscribe visit > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in > >the body. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Accuweather3 tag...
International eh? Can we get a copy too? At 7/25/00 06:32 PM, you wrote: >I made another one that supports internation addresses. If you want it I'll >email it to you. > >Bob > >-Original Message- >From: Adrian Cooper [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, July 25, 2000 5:59 PM >To: [EMAIL PROTECTED] >Subject: Re: Accuweather3 tag... > > > >- Original Message - >From: "Chris" <[EMAIL PROTECTED]> >Sent: Tuesday, July 25, 2000 2:59 PM > > > > Anyone else suddenly have their accuweather 3 tag create odd results > > starting this morning? > >Errr.. where can I get this tag please? > >Does it support Accuweather international forecasts as well - or does it >just >work by US zip? > >Thanks very much. > >Adrian Cooper. > > > > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Date subtraction
Why not keep using DateAdd? DateAdd('d',-14,now())and DateAdd('d',14,now()) Tom At 7/31/00 11:13 AM, you wrote: >This is a multi-part message in MIME format. > >--=_NextPart_000_1637_01BFFAE0.554B4DC0 >Content-Type: text/plain; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > >Is there a way to substract days from a date value similar to the = >dateAdd function in CF. I looked through the manual and I am not seeing = >anything. What I am trying to do is set up date values 2 weeks before = >and 2weeks after todays date. > >Thanks! > >Kevin Schmidt >Internet Services Manager >Peterson, WIlliams & Bizer >Office: 734.995.5000 >Mobile: 734.649.4843 > > >--=_NextPart_000_1637_01BFFAE0.554B4DC0 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > >Is there a way to substract days from a = date value=20 similar to the >dateAdd function in CF. I looked through the manual = and I=20 am not >seeing anything. What I am trying to do is set up date = values 2=20 >weeks before and 2weeks after todays date. > >Thanks! >Kevin Schmidt >Internet Services=20 Manager >Peterson, WIlliams & Bizer >Office: = 734.995.5000 >Mobile:=20 734.649.4843 > >--=_NextPart_000_1637_01BFFAE0.554B4DC0-- > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFCACHE in Static Pages
There was an article a few years ago in the CFDJ about a caching tag that essentially stores the cached HTML in a memory structure with controllable timeouts. You can cache parts of a page (the main content for instance and still have dynamic navigation menus for example). I still use that tag and really like it. Here's the link to the source code: http://www.sys-con.com/coldfusion/source.cfm?id=254 Tom Nunamaker -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 8:31 AM To: CF-Talk Subject: RE: CFCACHE in Static Pages Been fleshing out a similar concept myself to play around with, the only difference that I am looking at is to have the CMS in a different directory than the site root and use CFFile to physically create the different files in the root. I haven't gotten a chance to get beyond the initial theory though. Until Later! Hatton _ From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 9:17 AM To: CF-Talk Subject: CFCACHE in Static Pages Hi we're developing a CMS writing static pages from DB data. No secret. But, for improving performance, we're looking for cache solutions for that static pages. Our CMS works like: - get data from DB - with cfcontent and cffile create static pages - every time any data is change(menu or content) ALL static pages is generated Is possible cache all static pages for fast load? How to do that? -- ___ Sign-up for Ads Free at Mail.com HYPERLINK "http://promo.mail.com/adsfreejump.htm"http://promo.mail.com/adsfreejump .htm _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=i:4:148321"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm?link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2581.2460.4" Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=35" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to model "all" in a many-to-many
Hi John, I wouldn't add an "All foods" in the intersection table. You certainly could have an all food boolean in the persons table (note: table names are normally plural since they contain a set of information) You could write a stored procedure to delete all entries for a person and add an entry for each food type for that person in the intersection table. I would think that's the purist way to handle is as your counts would always be correct. If you added a food, just run that stored procedure to update anyone with "All foods" after the new food type is created. If you delete a food type, you'd of course need to delete all entries in the intersection table first, then delete the food type most likely in one transaction and/or stored procedure. That's how I'd do it. Tom -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 6:46 PM To: CF-Talk Subject: How to model "all" in a many-to-many I ran into a fascinating problem today, but I'm pretty sure it's not unique. Surely someone on here has thought about this before: Imagine you have a table of Person and a table of Food, and you have a PersonFood table that models which people like which food using two foreign keys, such as PersonID and FoodID. Simple enough Now, that's great if Sally like apples, and Billy likes apples and walnuts, and Joe likes tacos. But what should be done about BigBob, who likes *all* foods? If we just mark off BigBob as liking all the foods using the PersonFood then any time a new Food is added , BigBob will be out of date (he really does like *all* foods!). Yet if we create a special food called "All Food" and mark BigBob with that then the "count" of how many foods he likes (which is really just the count of all Foods) is equal to one instead of the actual food count, and it's still possible to mark BigBob as liking "All Food" as well as "apples" and get a food count of 2! ugh. And it's just as wrong to say "well anyone who does not have any records in the PersonFoods table means that they like all foods" because then you have no way of showing a Person who really like zero of the Foods. Ugh, again. So I'm curious, what do you much more experienced DB guys do in such a case? Solve it with a stored procedure? Use a boolean field in the Person table for "all food eaters"? Or is there an actual way to model this with a field in the PersonFood table? thanks for any hints! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to model "all" in a many-to-many
Isn't that what John was suggesting with an "all foods" flag? The problem with that is illustrated with your example however. Suppose you do have the "all foods" flag and you setup a SP to automatically add that person to the intersection table for any new food. You later discover he doesn't like those octopus thickshakes and delete that from the intersection table. Carrying the example further, you add frog legs to the food list. When the SP is run, it would reset the octopus thickshakes association with your user. One solution could be two intersection tables. One for foods the person wants and another for foods they don't want. You could have the "all foods" Boolean flag in the people table and modify the SP to add all foods except the ones listed in the " don't want" table. Only foods in the "want" table are valid. The second intersection table would only be used for people with "all foods" to specify foods they don't want. Tom Nunamaker -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 7:23 PM To: CF-Talk Subject: RE: How to model "all" in a many-to-many What about the case where I like all foods except mushrooms? Perhaps a nice approach would be to have a flag on the person's record saying "automatically assume I like newly added foods". Then when you add a food, either a stored procedure or whatever would add the relationship for all people with this flag set. If later it turned out that a person doesn't like octopus thickshakes after all then that single relationship could be deleted. -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED] Sent: Monday, 26 January 2004 1:04 p.m. To: CF-Talk Subject: RE: How to model "all" in a many-to-many Hi John, I wouldn't add an "All foods" in the intersection table. You certainly could have an all food boolean in the persons table (note: table names are normally plural since they contain a set of information) You could write a stored procedure to delete all entries for a person and add an entry for each food type for that person in the intersection table. I would think that's the purist way to handle is as your counts would always be correct. If you added a food, just run that stored procedure to update anyone with "All foods" after the new food type is created. If you delete a food type, you'd of course need to delete all entries in the intersection table first, then delete the food type most likely in one transaction and/or stored procedure. That's how I'd do it. Tom -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 6:46 PM To: CF-Talk Subject: How to model "all" in a many-to-many I ran into a fascinating problem today, but I'm pretty sure it's not unique. Surely someone on here has thought about this before: Imagine you have a table of Person and a table of Food, and you have a PersonFood table that models which people like which food using two foreign keys, such as PersonID and FoodID. Simple enough Now, that's great if Sally like apples, and Billy likes apples and walnuts, and Joe likes tacos. But what should be done about BigBob, who likes *all* foods? If we just mark off BigBob as liking all the foods using the PersonFood then any time a new Food is added , BigBob will be out of date (he really does like *all* foods!). Yet if we create a special food called "All Food" and mark BigBob with that then the "count" of how many foods he likes (which is really just the count of all Foods) is equal to one instead of the actual food count, and it's still possible to mark BigBob as liking "All Food" as well as "apples" and get a food count of 2! ugh. And it's just as wrong to say "well anyone who does not have any records in the PersonFoods table means that they like all foods" because then you have no way of showing a Person who really like zero of the Foods. Ugh, again. So I'm curious, what do you much more experienced DB guys do in such a case? Solve it with a stored procedure? Use a boolean field in the Person table for "all food eaters"? Or is there an actual way to model this with a field in the PersonFood table? thanks for any hints! _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to model "all" in a many-to-many
Joe Celko would also disagree with your idea of singular table names. Tables contain a set of data. What's in a table describing people? If you ONLY store one person, then it is a person table. If it stores more than one person, it is storing people. Typically, tables contain more than one record; hence they typically should be named as a plural Tom -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 7:32 PM To: CF-Talk Subject: RE: How to model "all" in a many-to-many There is just no way this would work correctly, if for some reason you don't trust my answer maybe should be asking the question in a DB mailing list or forum? The only CORRECT way of doing this is to store an entry for each food in the foreign table. And I'd suggest you stick non plural naming anywhere, because as soon as you start to use plural naming you will have to start thinking "now what did I use there, food or foods?" Stick to non-plural... Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ 0421 851 786 Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Monday, 26 January 2004 11:23 AM To: CF-Talk Subject: RE: How to model "all" in a many-to-many What about the case where I like all foods except mushrooms? Perhaps a nice approach would be to have a flag on the person's record saying "automatically assume I like newly added foods". Then when you add a food, either a stored procedure or whatever would add the relationship for all people with this flag set. If later it turned out that a person doesn't like octopus thickshakes after all then that single relationship could be deleted. -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED] Sent: Monday, 26 January 2004 1:04 p.m. To: CF-Talk Subject: RE: How to model "all" in a many-to-many Hi John, I wouldn't add an "All foods" in the intersection table. You certainly could have an all food boolean in the persons table (note: table names are normally plural since they contain a set of information) You could write a stored procedure to delete all entries for a person and add an entry for each food type for that person in the intersection table. I would think that's the purist way to handle is as your counts would always be correct. If you added a food, just run that stored procedure to update anyone with "All foods" after the new food type is created. If you delete a food type, you'd of course need to delete all entries in the intersection table first, then delete the food type most likely in one transaction and/or stored procedure. That's how I'd do it. Tom -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 6:46 PM To: CF-Talk Subject: How to model "all" in a many-to-many I ran into a fascinating problem today, but I'm pretty sure it's not unique. Surely someone on here has thought about this before: Imagine you have a table of Person and a table of Food, and you have a PersonFood table that models which people like which food using two foreign keys, such as PersonID and FoodID. Simple enough Now, that's great if Sally like apples, and Billy likes apples and walnuts, and Joe likes tacos. But what should be done about BigBob, who likes *all* foods? If we just mark off BigBob as liking all the foods using the PersonFood then any time a new Food is added , BigBob will be out of date (he really does like *all* foods!). Yet if we create a special food called "All Food" and mark BigBob with that then the "count" of how many foods he likes (which is really just the count of all Foods) is equal to one instead of the actual food count, and it's still possible to mark BigBob as liking "All Food" as well as "apples" and get a food count of 2! ugh. And it's just as wrong to say "well anyone who does not have any records in the PersonFoods table means that they like all foods" because then you have no way of showing a Person who really like zero of the Foods. Ugh, again. So I'm curious, what do you much more experienced DB guys do in such a case? Solve it with a stored procedure? Use a boolean field in the Person table for "all food eaters"? Or is there an actual way to model this with a field in the PersonFood table? thanks for any hints! _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pointing multiple sites to the same IP
The other downside is SSL, which can't use host headers from what I've read Tom Nunamaker -Original Message- From: Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 2:54 PM To: CF-Talk Subject: Re: Pointing multiple sites to the same IP There are some web servers (IIS, Apache, Sambar to name a few) that support "Host Headers"... in essence when the HTTP request is made, the domain name is sent by the client and the server can use it to delegate what documents directory is accessed based on that value. It's a pretty straightforward setup and there are several tutorials available on the web... go to your search engine of choice and do a search for Host Headers Setup and the name of your webserver application. You can also have mupltiple IP's point to the same machine and assign each IP a distinct domain name... I haven't had any perosnal experience with that option but I know that it's available. The one downside of host headers is that older browsers... say from Version 3.x and before of IE/NS don't support them. They don't send the domain with their GET request. The web server doesn't know what site to point to and will redirect to the default site, which always has to exist. HTH Hatton Douglas Brown wrote: > I have heard that you can point several different sites to one IP > using http headers, what exactly does the header need in order to do > this? > > > > Douglas Brown > Email: [EMAIL PROTECTED] > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pointing multiple sites to the same IP
You ought to tell Microsoft then. Read this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q187504 Tom -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:27 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Tom, This do not think this is the case. I use virutal sites with SSL and it does seem to work. -mk -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:02 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP The other downside is SSL, which can't use host headers from what I've read Tom Nunamaker -Original Message- From: Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 2:54 PM To: CF-Talk Subject: Re: Pointing multiple sites to the same IP There are some web servers (IIS, Apache, Sambar to name a few) that support "Host Headers"... in essence when the HTTP request is made, the domain name is sent by the client and the server can use it to delegate what documents directory is accessed based on that value. It's a pretty straightforward setup and there are several tutorials available on the web... go to your search engine of choice and do a search for Host Headers Setup and the name of your webserver application. You can also have mupltiple IP's point to the same machine and assign each IP a distinct domain name... I haven't had any perosnal experience with that option but I know that it's available. The one downside of host headers is that older browsers... say from Version 3.x and before of IE/NS don't support them. They don't send the domain with their GET request. The web server doesn't know what site to point to and will redirect to the default site, which always has to exist. HTH Hatton Douglas Brown wrote: > I have heard that you can point several different sites to one IP > using http headers, what exactly does the header need in order to do > this? > > > > Douglas Brown > Email: [EMAIL PROTECTED] > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS and MX and Multiple Sites with one IP
Just to speed things up, here's the important text from that link: Tom // Web servers using ColdFusion MX that use multiple host names with different document roots ("multihomed" servers) must change the cacheRealPath option of the ProxyService to false. Otherwise, if two sites have a script with the same name relative to their web roots (for example, /index.cfm), the web server might incorrectly render the scripts. This setting might cause slower performance; this is why the option is set to true by default. Edit c:/cfusionmx/runtime/servers/default/SERVER-INF/jrun.xml and change the value of the following option from true to false. true -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 4:44 PM To: CF-Talk Subject: Re: IIS and MX and Multiple Sites with one IP chad wrote: > > What the heck is going on? And Clue? Is there an INI or CONF file > for MX > that we need to configure to point to each site? http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote s_mx.html Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pointing multiple sites to the same IP
Sounds reasonable. I don't think you can virtually host multiple domains with SSL that are using multiple certificates. Tom -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 4:41 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Ok - here's a thought based on a reading of your article. I think it works for me because I have a server that has multiple sites all "virtually hosted" but only ONE of them uses SSL (I have only installed one cert). The article refers to multiple certificates and the web server being unable to determine which one to use. But that is not the case if I only have one cert - right? I think that is why my "virtual" site works. Mark -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 4:17 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Tom, ... maybe I should. Here is an example of a secure site that is "virtually" hosted. https://secure.cfwebtools.com/bgc/index.cfm check it out. -mk -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:56 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP You ought to tell Microsoft then. Read this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q187504 Tom -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:27 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP Tom, This do not think this is the case. I use virutal sites with SSL and it does seem to work. -mk -Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 3:02 PM To: CF-Talk Subject: RE: Pointing multiple sites to the same IP The other downside is SSL, which can't use host headers from what I've read Tom Nunamaker -Original Message- From: Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 2:54 PM To: CF-Talk Subject: Re: Pointing multiple sites to the same IP There are some web servers (IIS, Apache, Sambar to name a few) that support "Host Headers"... in essence when the HTTP request is made, the domain name is sent by the client and the server can use it to delegate what documents directory is accessed based on that value. It's a pretty straightforward setup and there are several tutorials available on the web... go to your search engine of choice and do a search for Host Headers Setup and the name of your webserver application. You can also have mupltiple IP's point to the same machine and assign each IP a distinct domain name... I haven't had any perosnal experience with that option but I know that it's available. The one downside of host headers is that older browsers... say from Version 3.x and before of IE/NS don't support them. They don't send the domain with their GET request. The web server doesn't know what site to point to and will redirect to the default site, which always has to exist. HTH Hatton Douglas Brown wrote: > I have heard that you can point several different sites to one IP > using http headers, what exactly does the header need in order to do > this? > > > > Douglas Brown > Email: [EMAIL PROTECTED] > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mail server
ArgoSoft has a free version you can probably use: http://www.argosoft.com/applications/mailserver/ Tom -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 9:08 PM To: CF-Talk Subject: Mail server How would I set up a mail server on my dev box to test mail functions. Is there a small footprint, pretty simple bit of software people use etc. Currently I point to our corporate mail server but would like this to run on the dev box. ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic select
Remember, the proper HTML should be: mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 3:42 PM To: CF-Talk Subject: RE: dynamic select easy, I presume that your list of all available makes is in another table. If it is not and your select is hard coded just use the cfif statement and name the query appropriately. Example below where queryname for all available makes = qMake, and query for option to be selected = qMakeUser: (off the top of my head so ) SELECTED>#qMake.Model# Tony Gruen -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 1:25 PM To: CF-Talk Subject: dynamic select I have a query that pulls options to populate a select box, now what I need to do is have a select that makes one of the values of the select box "SELECTED" if it's value is in my inventory table from a second query. IE: query of inventory returns the value of ford for the make column... I need this to happen, whats the best way to do it. Chevy Honda Ford Douglas Brown Email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic select
My mistake. That's not correct XHTML, which is what you should be coding for if you don't want to have to redo all of your HTML in the future. Here's a good reference for converting your HTML documents to XTHML: http://www.w3schools.com/xhtml/xhtml_syntax.asp Tom -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 4:39 PM To: CF-Talk Subject: RE: dynamic select > Remember, the proper HTML should be: > > display text goes here (the closing tag is required for XHTML compliance, but not otherwise) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX/WSP Test
Michael, This error pops up on your server. Tom Server Error The server encountered an internal error and was unable to complete your request.HTTP/1.1 500 Server Error Date: Mon, 01 Jul 2002 12:36:14 GMT Server: WebSite/3.1.13 Accept-ranges: bytes Connection: Close Content-type: text/html Content-length: 552 500 Server Error The server encountered an error and was unable to complete your request. Message: ISAPI DLL C:\CFusionMX\runtime\lib\wsconfig\1\jrun.isa returned error status for this request. Please contact the server administrator at [EMAIL PROTECTED] and inform them of the time the error occured, plus anything you know of that may have caused the error. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:30 AM To: CF-Talk Subject: CFMX/WSP Test If your reading this then the installation of ColdFusion MX on Website Pro 3 was a success and I have a paper to write on the experience. Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Runaway clients
IIS logs for Website Pro? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 1:25 PM To: CF-Talk Subject: RE: Runaway clients You look in your IIS logs? -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 01, 2002 2:09 PM > To: CF-Talk > Subject: Runaway clients > > > I've got CF5 on WSP and I've been seeing the registry setting > for the client vars fill up exceptionally fast. Every second > there's like 4 new items in it. I think this has to do with > some sort of system probe, but I can't hunt it down and > disable it. Any clue from anyone? > > Michael Dinowitz > Master of the House of Fusion > http://www.houseoffusion.com > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / Client Variables as cookies
I had the same problem. Am now using DB for client storage but would prefer cookie. Ideas anyone? Tom -Original Message- From: SoW [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 2:06 PM To: CF-Talk Subject: Re: CFMX / Client Variables as cookies Weird. No matter what I do, I cannot get cookie client variables to work under CFMX, even using the same templates as with CF5. Both are pointing to the same directory, using the same application.cfm how odd. - Original Message - From: "mark brinkworth" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, June 30, 2002 8:08 PM Subject: Re: CFMX / Client Variables as cookies > Your code worked fine for me both setting as Cookie in the > administrator and > in the ClientStorage attribvute in cfapplication. > > > > > >From: "SoW" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: CFMX / Client Variables as cookies > >Date: Sun, 30 Jun 2002 19:42:33 -0700 > > > >Hi folks, > > > >I cannot get client variables to save under CFMX as cookies. Is this > >a known compatibility issue? The following code works great > >(client.test is set the > >first time > >template is run) under CF5 but not CFMX. > > > > > > client.test is defined. > > > > client.test not defined. defining.. > > > > > > > >It works instantly under CFMX if I change the storage type to > >registry or db. Has ANYONE succesfully seen client vars as cookies > >working in CFMX? If so, what's the trick? > > > >Thanks > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / Client Variables as cookies
IIS (Until WSP works with CFMX) on Windows 2000 Tom -Original Message- From: SoW [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 3:39 PM To: CF-Talk Subject: Re: CFMX / Client Variables as cookies Two other people mailed me saying they're having this problem too, so that makes 4 of us.. CFMX and cookie client variables not working, anyone got any ideas? I'm running linux 6.2 BTW. - Original Message ----- From: "Tom Nunamaker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 1:19 PM Subject: RE: CFMX / Client Variables as cookies > I had the same problem. Am now using DB for client storage but would > prefer cookie. Ideas anyone? > > Tom > > -Original Message- > From: SoW [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 01, 2002 2:06 PM > To: CF-Talk > Subject: Re: CFMX / Client Variables as cookies > > > Weird. No matter what I do, I cannot get cookie client variables to > work under CFMX, even using the same templates as with CF5. Both are > pointing to the same directory, using the same application.cfm how > odd. > > - Original Message - > From: "mark brinkworth" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, June 30, 2002 8:08 PM > Subject: Re: CFMX / Client Variables as cookies > > > > Your code worked fine for me both setting as Cookie in the > > administrator > and > > in the ClientStorage attribvute in cfapplication. > > > > > > > > > > >From: "SoW" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: CF-Talk <[EMAIL PROTECTED]> > > >Subject: CFMX / Client Variables as cookies > > >Date: Sun, 30 Jun 2002 19:42:33 -0700 > > > > > >Hi folks, > > > > > >I cannot get client variables to save under CFMX as cookies. Is > > >this > > > >a known compatibility issue? The following code works great > > >(client.test is set > the > > >first time > > >template is run) under CF5 but not CFMX. > > > > > > > > > client.test is defined. > > > > > > client.test not defined. defining.. > > > > > > > > > > > >It works instantly under CFMX if I change the storage type to > > >registry or db. Has ANYONE succesfully seen client vars as cookies > > >working in CFMX? If so, what's the trick? > > > > > >Thanks > > > > > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dedicated Hosting
Hostmysite is 150GB for $50 in extra bandwidth. They don't have a pipe the size of the interstate (dual T-3's) but it's been fine in my experience. Tom -Original Message- From: SoW [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:55 PM To: CF-Talk Subject: Re: Dedicated Hosting Well I'm ready to leave Rackspace.com after being a loyal customer for four years. They're just not competitive on prices anymore. cihost.com looks like they have good hardware prices, but they're charging $50 for every 5 GB of bandwidth over 50 GB! That's totally insane! Any other suggestions? - Original Message - From: "Mike Brunt" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 10:57 AM Subject: RE: Dedicated Hosting > http://www.cihost.com are the most cost-effective we have found if > price is > critical, we are paying around $180.00 in their Texas based facility > for single CPU Pentium boxes with 384 megs of ram 20gb month transfer > (quick warning getting extra IP's is hard on the lower end deals so at > this price you usually need to work with 1 IP). They maintain the op > system and keep patches up to date we do the rest (CF-SQL etc). > Customer support is sometimes patchy but as I said this is good deal > if price-point is critical. > I said this the other day but it may be worth repeating, we have our > own in-house organization using utilities to check server up time and email/page > us if there are issues. > > As always hth. > > Kind Regards - Mike Brunt, CTO > Webapper > http://www.webapper.com > Downey CA Office > 562.243.6255 > AIM - webappermb > > "Webapper - Making the NET work" > > > -Original Message- > From: Matt Robertson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 02, 2002 10:00 AM > To: CF-Talk > Subject: RE: Dedicated Hosting > > > Cybercon. Total reliability. *Great* service. You maintain the box > and own the software licenses. A real tech person answers the phone > on the 2nd or 3rd ring no matter when you call. Prices for Win2k > boxes start under $400 monthly. I'm paying $550 for a dual-PIII, RAID > 1 box with 1gb RAM, 96 IPs and a 2nd nic so I don't get charged > bandwidth on my online backups. > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com > > > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 02, 2002 8:07 AM > To: CF-Talk > Subject: OT: Dedicated Hosting > > > We are looking for some additional Dedicated hosting and curious who > else on this list uses dedicated hosting and their experience. > Looking for some good prices (go figure). > > Thank you in advance (you can email off-list if you wish). > > Paul Giesenhagen > QuillDesign > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / CFC / FLASH Books.
At least enough different to justify a new book :) -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 7:34 AM To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. Yep :-) -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 8:29 AM To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. but 6/MX will be substantially different then? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 13:26 To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. Yep, although I may just jump to the CFMX test. The CF5 test really did not change that much from the CF4.5 one (which is why if you were certified for 4.5 you were automatically certified for CF5 as well). --- Ben -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 8:25 AM To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. Talking of books, will you still be adding the online sample test questions for the CF5 study guide to your site? Ade -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 13:18 To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. The X was a placeholder - the publishers did not know if CFMX would be CF6 or something else, and MM has strict policies dictating when that information could be shared, so many use X until they know for sure. Which works well until you try to get the listing updated. :-) --- Ben -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 11:13 PM To: CF-Talk Subject: Re: CFMX / CFC / FLASH Books. Old thread, but I just came across this at Amazon. Reality ColdFusion: Flash X Integration with CDROM Publisher: Macromedia Press by Ben Forta, Paul Mone, Randy Drisgill, Dennis Baldwin, Greg Rewis, Matt Tatam Available: August 15, 2002 http://www.amazon.com/exec/obidos/ASIN/0321125150/qid=1025838077/sr=8-1/ ref=sr_8_1/104-6101938-0002304 I think Amazon screwed up the book titles though, some of the MX books say Coldfusion X instead of MX. If someone at Macromedia reads this I'd get in touch with Amazon... This one also, which I have preordered :). http://www.amazon.com/exec/obidos/ASIN/0321127102/ref=pd_sim_books/104-6 101938-0002304 -- jon Saturday, June 29, 2002, 12:28:46 PM, you wrote: NH> I would like to see a programmers guide to the subject. Is there NH> anything available now? I know Kevin Towes is involved in a Flash NH> MX book but how technical does that get?' __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX editors...
Studio 5 with CFMX updates Tom Nunamaker -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 06, 2002 5:25 AM To: CF-Talk Subject: RE: CFMX editors... Dreamweaver MX :-) Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/ -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 06 July 2002 05:44 To: CF-Talk Subject: CFMX editors... Curious as to what everyone is using now... It might save me a bunch of time. I've been using CFStudio 4.5.2 but now that I've loaded CFMX onto the development server I was wanting to use the new charting tags etc and an editor that supported the help for the new tags... thanks, Brian __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IP-Less domains with MX
Did you restart your CF service? Tom -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 06, 2002 11:59 PM To: CF-Talk Subject: IP-Less domains with MX According to this KB (http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179&Method=Full) all you have to do when dealing with multiple domains on a box is change a single attribute from true to false. This does not seem to be working properly as you can see from www.cfcomet.com and www.nycfug.org. Both sites are trying to access the root page for www.houseoffusion.com. Not the desired effect. Anyone have a clue as to what's up? This only seems to be happening when dealing with .cfm files. .htm files are going ok (as can be seen at www.jmpublishers.com) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IP-Less domains with MX
I had that same problem but the KB article was right on. (Win2K / IIS). I'm still waiting for the WSP patch...any updates? Tom -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 12:16 AM To: CF-Talk Subject: Re: IP-Less domains with MX Many times. :) I think that the class caching is one of the things to blame. > Did you restart your CF service? > > Tom > > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 06, 2002 11:59 PM > To: CF-Talk > Subject: IP-Less domains with MX > > > According to this KB > (http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179&Method=Full) > all you have to do when dealing with multiple domains on a box is > change a single attribute from true to false. This does not seem to be > working properly as you can see from www.cfcomet.com and > www.nycfug.org. Both sites are trying to access the root page for > www.houseoffusion.com. Not the desired effect. Anyone have a clue as > to what's up? This only seems to be happening when dealing with .cfm > files. .htm files are going ok (as can be seen at > www.jmpublishers.com) > > Michael Dinowitz > Master of the House of Fusion > http://www.houseoffusion.com > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IP-Less domains with MX
Simon That's what the KB article said that Michael pointed out in his first post said. Tom -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 3:02 AM To: CF-Talk Subject: RE: IP-Less domains with MX Mike, I've seen this before. Your problem lies in the fact that the JRUN proxy is caching template compilations. There is a flag you need to throw in one of your XML config files (I believe it was JRUN.XML or something like that). Sorry I'm not more help at the moment - I'm heading off to bed right now, but feel free to shoot me an email in the morning if you still don't have it working (I spent several hours trouble shooting the server hosting cflib.org along with Ray Camden and his network admin... we were experiencing the exact same behavior). ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 00:59 To: CF-Talk Subject: IP-Less domains with MX According to this KB (http://www.macromedia.com/v1/Handlers/index.cfm?ID=23179&Method=Full) all you have to do when dealing with multiple domains on a box is change a single attribute from true to false. This does not seem to be working properly as you can see from www.cfcomet.com and www.nycfug.org. Both sites are trying to access the root page for www.houseoffusion.com. Not the desired effect. Anyone have a clue as to what's up? This only seems to be happening when dealing with .cfm files. .htm files are going ok (as can be seen at www.jmpublishers.com) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List of Countries
How about this? http://www.the-acr.com/codes/cntrycd.htm Just do a search on google. You'll find lots of them like this. Tom -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 07, 2002 9:04 PM To: CF-Talk Subject: List of Countries Anybody know where I may find a list of countries of the world with their corresponding 2 - digt telephone country codes? Thanks, Mark __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Apache on Windows NT
We're running Apache on NT with CF Enterprise with 7 million hits per year on our intranet. Works great. Tom At 09:40 PM 9/28/00, you wrote: >Does anyone have a production-level application running on Apache using CF >(and >Spectra)?I am investigating using it, but the warnings for Win32 have me >concerned. Switching to UNIX is not an option unfortunately, although I >wish we >could -- politics you know. > >TIA, >Mary > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Database of US ZIP CODES
Did you ask the US Postal Service? At 07:42 PM 3/8/01, you wrote: >All I need though is zip, and town and state, nothing else, isnt there >something cheaper? > >THanks > >Michael > >"Dylan Bromby" <[EMAIL PROTECTED]> wrote in message >news:<001a01c0a7fc$dfb126a0$6401a8c0@bromby>... > > their data is good. i've used it for years. used to be $35. > > > > -Original Message- > > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 08, 2001 10:21 AM > > To: CF-Talk > > Subject: RE: Database of US ZIP CODES > > > > > > You can get it for $150 USD at http://www.tpsnet.com/html/zipcode.html > > > > I just finished a stored procedure that does a distance calculation and > > locates all zips with in a given radius if that is what you are trying to > > accomplish. > > > > Duane > > > > > > -Original Message- > > From: Michael [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 08, 2001 1:05 PM > > To: CF-Talk > > Subject: OT: Database of US ZIP CODES > > > > > > Anyone know of where I can get this, and reasonably accurate and up to > > date... > > > > I may be asking too much , but hey cant hurt right. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Javascript Calendar
Neil I modified some code that was on Netscape's site a few years ago. Other people has also used it I'm sure, but here's my version that's been working great for quite a while: http://www.morervs.com/code/calendar/ Regards Tom Nunamaker [EMAIL PROTECTED] General Partner RVC Enterprises / Aeromir.com Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.morervs.com/ -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 3:33 PM To: CF-Talk Subject: Javascript Calendar I am looking for a calendar that will pop up upon clicking on a link and then it will circle today's date and if I click on a date it will fill in the calling pages form. I know this has to be canned somewhere. If someone knows please let me have a link. Thanks everyone, and happy new year. Neil __ 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: Clustering and CF variables.
Neil Client variables can't store complex data types like arrays and structures. However, you CAN convert these to WDDX variables and store the WDDX data as client variables. Session variables are handy to time someone out of an application. You can do this with Client variables but you have to roll your own timeout mechanism. Either refine the CFID/CFTOKEN as cookies that expire when the browser closes or set a date/time client variable and check to see if the desired amount of time since the last access has been exceeded. Tom Nunamaker [EMAIL PROTECTED] General Partner RVC Enterprises / Aeromir.com Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.morervs.com/ -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 9:11 PM To: CF-Talk Subject: Re: Clustering and CF variables. That is great but how do you know where to use each of these types. From what it sounds like why not just use client variables all the time? Thanks, Neil - Original Message - From: "Ken Wilson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 2:47 AM Subject: RE: Clustering and CF variables. > Sure, it's painless. > > The big difference is that Session Variables are stored in Ram on the server > where they are created. That's why it's so critical to lock session variable > reads/writes. That's also why you'll lose state when you end up on another > server in the cluster...servers can't share their Ram. > > Client variables can be stored in your choice of Cookie, Registry (Nooo!) or > Database. Since you're in a clustered environment the DB storage would seem > perfect for you since they'll be available to you regardless of which server > you hit. > > Ken > > > > -Original Message- > From: Neil H. [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 05, 2002 2:21 AM > To: CF-Talk > Subject: Re: Clustering and CF variables. > > > So you are saying I should change my variable from session to client. See > maybe I am just dumb but I never really understood the difference. Sure I > have seen different definitions but I never set down and thought about it. > Maybe someone has the "for dummies" version? > > Neil :) > > - Original Message - > From: "Ken Wilson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 05, 2002 2:19 AM > Subject: RE: Clustering and CF variables. > > > > Are you talking about Session Variables or Client Variables? Session > > variables are Memory resident on the server where they are created whereas > > Client Variables will be stored in the central DB that you have setup. > > > > Ken > > > > > > > > -Original Message- > > From: Neil H. [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, January 05, 2002 12:31 AM > > To: CF-Talk > > Subject: Clustering and CF variables. > > > > > > I am using session variables. I have setup a DSN and a Client Variable > > Storage to the same database on each server. The code is identical. I am > > using Microsoft NLB. It works well except that my session variables > aren't > > carrying over. Any ideas? I know its broad but there has to be something > > obvious > > > > 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: 360 Review
You can issue you random numbers on pieces of paper, like drawing from a hat. Explain that they are unique numbers that can only be used once. Each number would correspond to a number in your ID table. Just delete it as it's used. That should alleviate fears of being tracked. Tom Nunamaker -Original Message- From: Dimo Michailov [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 11:42 AM To: CF-Talk Subject: Re: 360 Review One little problem with requiring IDs for submitting the surveys will be that it will affect the responses. If the boss wants the responses to be "STRICTLY ANONYMOUS" then dealing with any kind of ID or other identifier will likely cause the people to submit skewed reviews, just because they don't know if they are really anonymous or not. My $.02 Dimo Michael Haggerty wrote: > The strategy I have used in the past is the following: > > 1) Create two tables, one which contains a user_id corresponding to each > person in your department and a second for storing survey answers > > 2) Send a link to the survey to each user containing the user_id > > 3) Delete each user_id as the user completes the survey; require the user to > have a valid id when entering the survey. > > Mike > > -Original Message- > From: Heild, Kevin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 03, 2002 5:02 PM > To: CF-Talk > Subject: 360 Review > > > The boss of our MIS dept wants everyone to grade him on a number of > questions. He wants it to be strictly anonymous, however he wants it so each > person in our dept can only vote one time. What is the best method to do > > __ 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: Parsing an Email Line By Line
Do a "find" for chr(13) I think it is. I believe that's the carriage return character. Tom Nunamaker toshop.com -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 5:59 PM To: CF-Talk Subject: Re: Parsing an Email Line By Line How can I know if the line is supposed to continue. As previously stated there *should* be an = to signify a continuation but cfmail doesn't seem to catch it. There has to be a way to parse this email line by line and determine if the line wraps?! Thanks, Neil - Original Message - From: "Andrew Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 2:50 PM Subject: RE: Parsing an Email Line By Line > When you say truncated do you mean when you see it as an email, then > there is nothing you can do about this as the email client does this. > > > -Original Message- > From: Neil H. [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 15 January 2002 5:02 AM > To: CF-Talk > Subject: Parsing an Email Line By Line > > I am attempting to parse an email line by line. I found this code from > CFVault and it seems pretty proven: > > > > #rc# > > > > > However, it appears that the output is truncated to 77 characters. This > seems very strange but maybe someone has insight about it? > > Thanks, > > Neil > > __ 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: Parsing an Email Line By Line
A lot of email programs wrap text at certain lengths. Why not read the email body into a variables. Replace all chr(10) and chr(13)'s with nothing ('') (ie...eliminate them), then split the text up the way you want to? There's a nice UDF at cflig.org for taking the left 'n' characters but not splitting words apart. Tom -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:27 PM To: CF-Talk Subject: Re: Parsing an Email Line By Line That doesn't work. As we said before the chr(13) comes in at about 77 characters so CFMAIL or the mail server or something (don't know which) is putting the chr(13) or chr(10) in the middle of the line! Thanks, Neil - Original Message - From: "Tom Nunamaker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 7:11 PM Subject: RE: Parsing an Email Line By Line > Do a "find" for chr(13) I think it is. I believe that's the carriage return > character. > > Tom Nunamaker > toshop.com > > -Original Message- > From: Neil H. [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 14, 2002 5:59 PM > To: CF-Talk > Subject: Re: Parsing an Email Line By Line > > > How can I know if the line is supposed to continue. As previously stated > there *should* be an = to signify a continuation but cfmail doesn't seem to > catch it. There has to be a way to parse this email line by line and > determine if the line wraps?! > > Thanks, > > Neil > > - Original Message - > From: "Andrew Scott" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 14, 2002 2:50 PM > Subject: RE: Parsing an Email Line By Line > > > > When you say truncated do you mean when you see it as an email, then > > there is nothing you can do about this as the email client does this. > > > > > > -Original Message- > > From: Neil H. [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 15 January 2002 5:02 AM > > To: CF-Talk > > Subject: Parsing an Email Line By Line > > > > I am attempting to parse an email line by line. I found this code from > > CFVault and it seems pretty proven: > > > > > > > > #rc# > > > > > > > > > > However, it appears that the output is truncated to 77 characters. This > > seems very strange but maybe someone has insight about it? > > > > Thanks, > > > > Neil > > > > > > __ 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: Photo Sharing
We do that with CFX_IMAGE... works great. I found it in the old Allaire Tag Gallery. If you can't find it, let me know and I'll post it here Tom Nunamaker -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:30 PM To: CF-Talk Subject: OT: Photo Sharing Hi. Looking for a quick and easyish way of getting my photos online. Does anyone know of a tag available (even to just thumbnail the photos) - or if not, what sites can you recommend? Cheers Will __ 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: Photo Sharing
CF_IMGv2 was free and works great Tom -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:43 PM To: CF-Talk Subject: RE: Photo Sharing We have two products at cfdev you might want to take a look at. 1) AutoResize - resize images (thumbnails) free uses Jukka Mannar's CFX_Image tag. 2) ActiveScan - scan images through your browser directly to your web site (could also be used in conjunction with AutoResize. $199 you can check them out here: http://www.cfdev.com/products + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 7:30 PM To: CF-Talk Subject: OT: Photo Sharing Hi. Looking for a quick and easyish way of getting my photos online. Does anyone know of a tag available (even to just thumbnail the photos) - or if not, what sites can you recommend? Cheers Will __ 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: Photo Sharing
The ZIP file I attached didn't come along for the ride. Here's the URL for this tag: http://cfdev.iamserious.com.au/ Tom Nunamaker -Original Message----- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 7:56 PM To: CF-Talk Subject: RE: Photo Sharing CF_IMGv2 was free and works great Tom -Original Message- From: Pete Freitag [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:43 PM To: CF-Talk Subject: RE: Photo Sharing We have two products at cfdev you might want to take a look at. 1) AutoResize - resize images (thumbnails) free uses Jukka Mannar's CFX_Image tag. 2) ActiveScan - scan images through your browser directly to your web site (could also be used in conjunction with AutoResize. $199 you can check them out here: http://www.cfdev.com/products + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 7:30 PM To: CF-Talk Subject: OT: Photo Sharing Hi. Looking for a quick and easyish way of getting my photos online. Does anyone know of a tag available (even to just thumbnail the photos) - or if not, what sites can you recommend? Cheers Will __ 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: Limiting an output string
left(statement_txt,255) Tom -Original Message- From: Michael Blair [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 10:53 AM To: CF-Talk Subject: Limiting an output string I have a variable called "statement_txt". It has small to large data in it. I want to only display up to 255 characters. What is the best way. __ 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: Calculating workdays
But that won't work. What about Holidays? Joe Celko's book "SQL for Smarties" has a good discussion of this question on page 74. Here's a series of INSERT INTO statements for all of the workdays in 2002 excluding US Federal Holidays. I made this list is Excel, per Joe Celko's suggestion. Tom Nunamaker INSERT INTO workdays VALUES ('2002-1-2') INSERT INTO workdays VALUES ('2002-1-3') INSERT INTO workdays VALUES ('2002-1-4') INSERT INTO workdays VALUES ('2002-1-7') INSERT INTO workdays VALUES ('2002-1-8') INSERT INTO workdays VALUES ('2002-1-9') INSERT INTO workdays VALUES ('2002-1-10') INSERT INTO workdays VALUES ('2002-1-11') INSERT INTO workdays VALUES ('2002-1-14') INSERT INTO workdays VALUES ('2002-1-15') INSERT INTO workdays VALUES ('2002-1-16') INSERT INTO workdays VALUES ('2002-1-17') INSERT INTO workdays VALUES ('2002-1-18') INSERT INTO workdays VALUES ('2002-1-22') INSERT INTO workdays VALUES ('2002-1-23') INSERT INTO workdays VALUES ('2002-1-24') INSERT INTO workdays VALUES ('2002-1-25') INSERT INTO workdays VALUES ('2002-1-28') INSERT INTO workdays VALUES ('2002-1-29') INSERT INTO workdays VALUES ('2002-1-30') INSERT INTO workdays VALUES ('2002-1-31') INSERT INTO workdays VALUES ('2002-2-1') INSERT INTO workdays VALUES ('2002-2-4') INSERT INTO workdays VALUES ('2002-2-5') INSERT INTO workdays VALUES ('2002-2-6') INSERT INTO workdays VALUES ('2002-2-7') INSERT INTO workdays VALUES ('2002-2-8') INSERT INTO workdays VALUES ('2002-2-11') INSERT INTO workdays VALUES ('2002-2-12') INSERT INTO workdays VALUES ('2002-2-13') INSERT INTO workdays VALUES ('2002-2-14') INSERT INTO workdays VALUES ('2002-2-15') INSERT INTO workdays VALUES ('2002-2-19') INSERT INTO workdays VALUES ('2002-2-20') INSERT INTO workdays VALUES ('2002-2-21') INSERT INTO workdays VALUES ('2002-2-22') INSERT INTO workdays VALUES ('2002-2-25') INSERT INTO workdays VALUES ('2002-2-26') INSERT INTO workdays VALUES ('2002-2-27') INSERT INTO workdays VALUES ('2002-2-28') INSERT INTO workdays VALUES ('2002-3-1') INSERT INTO workdays VALUES ('2002-3-4') INSERT INTO workdays VALUES ('2002-3-5') INSERT INTO workdays VALUES ('2002-3-6') INSERT INTO workdays VALUES ('2002-3-7') INSERT INTO workdays VALUES ('2002-3-8') INSERT INTO workdays VALUES ('2002-3-11') INSERT INTO workdays VALUES ('2002-3-12') INSERT INTO workdays VALUES ('2002-3-13') INSERT INTO workdays VALUES ('2002-3-14') INSERT INTO workdays VALUES ('2002-3-15') INSERT INTO workdays VALUES ('2002-3-18') INSERT INTO workdays VALUES ('2002-3-19') INSERT INTO workdays VALUES ('2002-3-20') INSERT INTO workdays VALUES ('2002-3-21') INSERT INTO workdays VALUES ('2002-3-22') INSERT INTO workdays VALUES ('2002-3-25') INSERT INTO workdays VALUES ('2002-3-26') INSERT INTO workdays VALUES ('2002-3-27') INSERT INTO workdays VALUES ('2002-3-28') INSERT INTO workdays VALUES ('2002-3-29') INSERT INTO workdays VALUES ('2002-4-1') INSERT INTO workdays VALUES ('2002-4-2') INSERT INTO workdays VALUES ('2002-4-3') INSERT INTO workdays VALUES ('2002-4-4') INSERT INTO workdays VALUES ('2002-4-5') INSERT INTO workdays VALUES ('2002-4-8') INSERT INTO workdays VALUES ('2002-4-9') INSERT INTO workdays VALUES ('2002-4-10') INSERT INTO workdays VALUES ('2002-4-11') INSERT INTO workdays VALUES ('2002-4-12') INSERT INTO workdays VALUES ('2002-4-15') INSERT INTO workdays VALUES ('2002-4-16') INSERT INTO workdays VALUES ('2002-4-17') INSERT INTO workdays VALUES ('2002-4-18') INSERT INTO workdays VALUES ('2002-4-19') INSERT INTO workdays VALUES ('2002-4-22') INSERT INTO workdays VALUES ('2002-4-23') INSERT INTO workdays VALUES ('2002-4-24') INSERT INTO workdays VALUES ('2002-4-25') INSERT INTO workdays VALUES ('2002-4-26') INSERT INTO workdays VALUES ('2002-4-29') INSERT INTO workdays VALUES ('2002-4-30') INSERT INTO workdays VALUES ('2002-5-1') INSERT INTO workdays VALUES ('2002-5-2') INSERT INTO workdays VALUES ('2002-5-3') INSERT INTO workdays VALUES ('2002-5-6') INSERT INTO workdays VALUES ('2002-5-7') INSERT INTO workdays VALUES ('2002-5-8') INSERT INTO workdays VALUES ('2002-5-9') INSERT IN
RE: Macromedia's destruction of the Allaire Site...
I already wrote MM about this too. What are they thinking -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:03 PM To: CF-Talk Subject: Macromedia's destruction of the Allaire Site... I try to go to the developer's download section and get this lovely message: Due to scheduled maintenance, certain areas of our website are unavailable at this time. These areas include Macromedia Membership, Free Trial Downloads, the Macromedia Store, the Edge newsletter, the Showcase, Events, the Macromedia Flash, Dreamweaver, and UltraDev Exchanges, the Developers Exchange and Forums. You can use NNTP newsgroups instead of Forums until our maintenance is complete. We apologize for the inconvenience and will be restoring service as soon as possible. If you've already made a download purchase, please return after 6 pm PST on Sunday 1/27/02 to download your products. Meanwhile, you can continue to browse the rest of our site. You can also read about other ways to purchase Macromedia products or contact our Customer Service Center. Return to Macromedia home page. OFFLINE FOR 2-3 DAYS? what in the world are these folks thinking? Bring the old site back please -paris __ 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: Macromedia's destruction of the Allaire Site...
Maybe they areNEO. Isn't this the future of CF? Basically taking CF template and changing them into JSP files? I've heard NEO is suppose to be pretty fast, but MM is worrying me now Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] MM, if you're listening and it's not too late, build the CF Dev Exchange with ColdFusion please. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.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: Best way to store credit cards in database?
I guess I'm a bit too paranoid to even THINK about putting credit card numbers in one of my databases. Just thinking of the potential liability is staggering. Can you imagine your clients' attorneys asking you to explain your own encryption algorithm to a judge? Or why you used a public algorithm that had known vulnerabilities (that you didn't necessarily know about). Banks and financial institutions can keep the liability headaches to themselves. You know how you make money on wall street? Controlling your risk. I like to follow the same advice when it comes to potential lawsuits. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 10:55 AM To: CF-Talk Subject: Re: Best way to store credit cards in database? Roll your own encryption. I remember awhile back some posted their algorithm for encryption in CF, and it seemed pretty solid. If you use your own encryption scheme, it would be a lot harder for a hacker to decrypt the CC number. Using a public standard (like cfencrypt) is not a very good solutiion. I almost went down the path of cryptology - its a lot of fun, but I didn't want to work in a vault the rest of my life. -Bill www.brainbox.tv - Original Message - From: "Jeff Fongemie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, January 27, 2002 10:17 AM Subject: Best way to store credit cards in database? > Sunday, January 27, 2002, 10:12:15 AM > Hello CF-Talk, > > I've got a simple site, and uses a small Access database. We will be > taking credit cards. > > Wondering what others consider a realistic practice to ensure > security to a reasonable level. What do others do? > > The site will have a SLL, but I'm thinking along the lines of > encrypting the card number. However, I know how unsecure ColdFusions > encryption is, so why bother? > > If people do somehow encrypt the card number, would you be willing > to give examples? And I guess I'll need a way to unencrypt the > numbers in an admin area. > > I've seen where a site will store half of the number, and the second > half gets sent by email to the shop owners. Then the shop owners > need to go in and match up the numbers. > > Thanks for any advice, recommendations on this. > > > Best regards, > Jeff Fongemie mailto:[EMAIL PROTECTED] > __ 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: Best way to store credit cards in database?
> -Original Message- > From: Thane Sherrington [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 28, 2002 3:03 PM > To: CF-Talk > Subject: RE: Best way to store credit cards in database? > Here's a suggestion that might help - store everything but the last four > numbers in a hashed format. The customer still has to type something in, > but it's only 4 numbers, and it makes it virtually impossible to be hacked. Why would you do that? Then you'd only have to guess one in 10,000 possibilities instead of 10E16 possibilities? Plus you would have "everything" else like the expiration date, card holder name and address...etc. Just a matter of time before they would crack the last 4 numbers. Tom Nunamaker [EMAIL PROTECTED] __ 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: scripting windows 2000 dns
Jim I downloaded the BIND 9.2.0 windows package but it didn't have any of the configuration files Tom -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 8:26 PM To: CF-Talk Subject: Re: scripting windows 2000 dns If you can use BIND for Win32, life is infinitely simpler. Just read and write text files. The server has a master configuration file, plus one file per zone. Once changes are made, use cfexecute to run a command-line program that controls the DNS server. You can reload a single zone, reload all zones, check the server's status, etc. Win32 binaries of versions 8.3.0 and 9.2.0 can be found at ftp://ftp.isc.org/isc/bind/contrib/ for anyone interested. Jim - Original Message - From: "Neil H." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 6:48 PM Subject: Re: scripting windows 2000 dns > Yeah we use the CFexecute with the DNS provider. It works beautifully > > Neil > > - Original Message - > From: "Jon Hall" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 31, 2002 3:37 PM > Subject: Re: scripting windows 2000 dns > > > > In addition to cfexecute, you could just use cfobject to interact > > with the > > DNS provider object. I can't say it would be easy though. You are > > going to > > have to rely on the docs if you don't know vbs pretty well. I know a > little, > > but that code is nasty :) > > > > The other possibility if you need to use CF, is just to figure out > > how to > > recreate the zone files in CF, write them out, create the registry > entries, > > then restart the DNS server. The zone files themselves are just > > plain text... > > > > jon > > - Original Message - > > From: "Bernd VanSkiver" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, January 31, 2002 2:35 PM > > Subject: scripting windows 2000 dns > > > > > > > I am trying to use WMI to manage DNS entries in a Windows 2000 DNS > server. > > > I have some VBS files that I can do this with from the command > > > prompt, > but > > > am not sure how to run them with ColdFusion. Here is a link to > > > the > > article > > > I am looking at for instructions on how to accomplish this task: > > > http://www.iisfaq.com/Articles/319/. Just trying to automatially > create, > > > modify, and delete dns entries with ColdFusion, if anyone knows of > > > a > > better > > > way to do this then using the VBS files I mentioned then please > > > let me > > know. > > > > > > Bernd VanSkiver > > > [EMAIL PROTECTED] > > > ColdFusion Developer __ 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: Creating Thumbnails of webpages again :-)
CFX_IMAGE already does this. Why re-invent the wheel? Tom -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 1:34 PM To: CF-Talk Subject: Creating Thumbnails of webpages again :-) microsoft have a really cool example of this for vb & c# .net http://www.gotdotnet.com/playground/services/ThumbnailGen/ThumbnailClien t.aspx there are example cpp files there, anyone interested in doing a little work to create a CFX http://blah.com/file.htm"; height="40" width="100" output="c:\temp\thumb.gif"> the example files alos have a command line tool which makes bmps of a url z __ 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: Creating Thumbnails of webpages again :-)
Wrong. Here's the code we're using in production to generate thumbnails: This creates a thumbnail 88 pixels wide. Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 1:48 PM To: CF-Talk Subject: Re: Creating Thumbnails of webpages again :-) Tom Nunamaker wrote: >CFX_IMAGE already does this. Why re-invent the wheel? > cf_image only generates images from commands and src images files i believe __ 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: Creating Thumbnails of webpages again :-)
Zac I mis-read your question...you are correct that CFX_IMAGE manipulates existing images. Why would you want a BMP of a website? Tom -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 1:48 PM To: CF-Talk Subject: Re: Creating Thumbnails of webpages again :-) Tom Nunamaker wrote: >CFX_IMAGE already does this. Why re-invent the wheel? > cf_image only generates images from commands and src images files i believe __ 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: Creating Thumbnails of webpages again :-)
It's a serious question because you said "the example files alos have a command line tool which makes bmps of a url" Tom -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 2:19 PM To: CF-Talk Subject: Re: Creating Thumbnails of webpages again :-) Tom Nunamaker wrote: >Zac > >I mis-read your question...you are correct that CFX_IMAGE manipulates >existing images. > >Why would you want a BMP of a website? > well gif or jpeg or png is more web friendly :-) is that a serious question? __ 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 __ 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
Calendar Server recommendations??
Does anyone have any good calendar server application recommendations?? Thanks Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] __ 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: Week Number = date range ?
How do you define your week? Does it always start the same day of the week or is it based on the 1st of January's day of the week (changing every year)? Tom Nunamaker Paladin Computers Macromedia Certified Advanced ColdFusion 5.0 Developer http://www.toshop.com/ [EMAIL PROTECTED] -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 6:59 PM To: CF-Talk Subject: RE: Week Number = date range ? I dont think that will work for me. I think I would need to know the date in order to use the tag, I dont have the date available. I have a week number and year, thats it. I need to determine the first day in that week and/or last day. jeff -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 4:44 PM To: CF-Talk Subject: RE: Week Number = date range ? The best way would probably be to convert the Julian date, which is just the number of the day out of 365 days, and then add 7 to it using dateadd. There's a tag for converting to and from Julian dates at this URL. http://www.zyxxy.com/cf_bit/julian/index.cfm?opt=julian&subID=4 __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 7:18 PM To: CF-Talk Subject: Week Number = date range ? Hi all, Anyone out there have some logic to figure out what date range a particular week number is? Example: Week #39 in 2001 = sep/16 - sep/22 I thought I this working, but it blew up around week 52 and 53 :( I query for aggregate stats by the week, so the query returns week number and year. Thanks, Jeff __ 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: SQL indexing
Image trying to lookup a phone number in the white pages if the entries were in the order they were entered in to the database (ie...not in alphabetical order). You would have to look through the entire phone book to find any number. That's what your database has to do if you don't use indexed fields. For small tables, that's not a problem. With 27000 or 2.7 million records, it's a HUGE problem. I had a user in my users group once with a 150 MB Access database from a military supply mainframe. He imported the data everyday and came to the group complaining that he queries were taking 5-15 MINUTES to run. We looked at his database and discovered he had only text fields with no indexes. After we explained indexes to him his query times dropped dramatically. Cheers Tom Nunamaker -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 3:04 PM To: CF-Talk Subject: RE: SQL indexing Indexing any field that is used to search with on a regular basis is always a good idea. For instance, I had a database full of users (about 27,000 of them) and the login process would take forever. Placing an index on the username and password fields increases the query execution speed by over 1000% (used to take over a minute, now around 1 second). The same principle would apply to any field where the server needs to lookup the table and return records based on the field in the where clause. If it has a pre-built index of rows where these values are, your query will run faster. Inserts of course will be a little slower as the index has to be rebuilt each time a new row is inserted. Regards Darryl -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Monday, 18 February 2002 5:26 AM To: CF-Talk Subject: OT: SQL indexing Is there any benefit to indexing a "tinyint" field that is used as a boolean (either 1 or 0)? I have four fields that work this way and I use them heavily in queries for reporting. They are used in aggregate functions (count and sum) as well as in the where clauses for various queries. I know I could play with the indexes and test the timing, but I only have a live database to work with and don't want to disrupt anything until I feel there will be some significant benefit. Also, along the same lines, I report by grouping output (in SQL - not CF's group=) using the DAY, HOUR and MONTH parts of a datetime stamp. Will indexing help when using portions of a datetime field in this way, as opposed to considering the entire field? BTW - this is using SQL Server 2000 (and I guess the same theory would apply to SQL 7). Thanks! Jeff __ 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: NOCOUNT question
This is from SQL server 2000 Books Online about NOCOUNT. In serveral SQL server programming books I have, they all recommend setting NOCOUNT ON. One book I have mentioned the SET NOCOUNT ON can cause problems with Access, so you should limit its use to SQL server. Tom Nunamaker == SET NOCOUNT Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results. Syntax SET NOCOUNT { ON | OFF } Remarks When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the count is returned. The @@ROWCOUNT function is updated even when SET NOCOUNT is ON. SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. When using the utilities provided with MicrosoftR SQL ServerT to execute queries, the results prevent "nn rows affected" from being displayed at the end Transact-SQL statements such as SELECT, INSERT, UPDATE, and DELETE. For stored procedures that contain several statements that do not return much actual data, this can provide a significant performance boost because network traffic is greatly reduced. The setting of SET NOCOUNT is set at execute or run time and not at parse time. Permissions SET NOCOUNT permissions default to all users. -Original Message- From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 10:19 AM To: CF-Talk Subject: NOCOUNT question Howdy -- I have seen some in this forum suggest implicitly via their code examples that SET NOCOUNT ON...SET NOCOUNT OFF should bracket any SQL command(s) submitted via CF to SQL Server. I realize that for "routine" operations these statements are not necessary, but I was wondering whether there are special situations where they might be helpful or even necessary. I searched the CF support forums, the SQL Server docs and Microsoft support KB, and even Google, but aside from a few comments to the effect that this approach might provide a very slight performance advantage in high-traffic environments, I really couldn't find any other reason to explain why some CF coders routinely use this approach. Enlightening comments, anyone? -- Larry Afrin Med. Univ. of S.C. [EMAIL PROTECTED] __ 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: SOT: Is the Netscape browser still a consideration?
We run an RV Classified site with about 40,000 visitors per month. The average age of Rver's is in their early 60's. Believe it or not, about 1.5% of our visitors use Netscape 3.0. We've had to code in FONT tags with the CSS classes so it didn't look horrible in NS 3.0 Tom Nunamaker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10:04 PM To: CF-Talk Subject: Re: SOT: Is the Netscape browser still a consideration? Here's my .02 cents I'm leaning towards giving more consideration to the Netscape 6.0 above but I'm not ready to declare Netscape 4.75 dead. I think there's still about 10 percent of the internet users that are using Netscape 4.75. Netscape 6.0 is coming along real nicely and I've seen some users jumping over from IE to Netscape 6.0. It would make sense if someone would overlook some of the small design differences between Netscape 4.75 and 6.0 +. However, I wouldn't go too far in ignoring some of the glaring layout differences. The clients we work with generally have no understanding why there's a browser war, why netscape 4.75 doesn't support some of the HTML tags as well as IE does and etc. It would hurt the contractors' reputation if they were to ignore 4.75 as of now. If anyone wants to work with IE 5.5 and Netscape 6.0+ exclusively then there are almost zero differences between those versions. It'll make your job much easier. I have a small site tracking system on my site and every one user in about 10 or 15 users are showing up with a 4.75 version. So I have no choice but to design sites for 3 different versions. Thus, I'd recommend you do the same thing. > For the longest time, I've coded my sites to take into account > Netscape users but with the ever-dwindling numbers of Navigator > afficianados and IE's continued growth, I've been wondering if I > should even bother worrying about > whether my sites work with Netscape. > > Since this has been one of my best resources for info and some of the > most talented and savvy people that I've met post to CF-Talk, I was > hoping that I could get some good feedback. > > So, if we consider that the apps that I'm developing will be geared > towards the Internet consumer at large and I won't have the luxury of > developing for a controlled environment like a corporate intranet, I > beg the question: > > Should I continue to worry about Netscape? If so, which version should > serve > as a baseline? > > Looking forward to your responses. > > C-ya, > > Rey... Nathaniel Horwitz mailto:[EMAIL PROTECTED] AIM: NRHorwitz Fax: 510-573-2298 Web Site: http://www.nathanielhorwitz.com " What separates winning from losing is the head. The brain sometimes doesn't believe in the power of the body" __ 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
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. 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
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. 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. > > 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 do
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. 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 (a
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
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]] Sen
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: 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. 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