Re: Sean Corfield, it's time to approve my post

[Tom Forbes]

It's a cost/benefit ratio thing. CF is expensive, the past owners 
have not been customer/user friendly and it has a lousy editor (DW).

If PHP existed back when CF 2 or 3 existed, there would be no 
discussion, CF would not currently exist.

My 2 cents.



At 06:57 PM 11/30/2006, you wrote:
>"I will say that for a few years now I've been suspicious of the
>actual revenue numbers generated by ColdFusion, how that revenue
>breaks down between maintenance versus new licenses for new versions,
>new customer growth trend, and how that trend's growth pattern
>compares to the overall growth patterns of other platforms.  Saying
>that overall revenue has grown can indicate any number of things; the
>devil's in the details."
>
>In Adam's defense, I think many of us have had the same suspicion. The
>number of shared hosting providers offering ColdFusion support has
>hardly increased. At least by my observation. In addition, it is not
>everyday (or week for that matter) that I come across a website that
>is using ColdFusion. However, I couldn't count how many times I come
>across PHP websites. There is a subtle increase in the number of open
>source projects for ColdFusion, but most of them are by the same
>people who have been contributing to the community for years (Camden,
>Helms, Woodward, Farrell, etc.). ASP.NET and PHP are being taught on
>community and university campuses in increasing numbers. At my
>community college, they just dropped the ColdFusion class in favor of
>ASP.NET.
>
>I have no idea what the future holds for ColdFusion, but the fact that
>these discussion keep coming up reveals that Adam is not the only one
>from within the community who has a sneaking suspicion that ColdFusion
>is not doing as well as we would like. Not to say that it is doing
>bad, but that it is not competing with alternatives such as Ruby, PHP
>and ASP.NET (all of which are free by the way).
>
>-Aaron
>
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262340
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Dreamweaver is a total big dog!!

[Tom Forbes]

Adobe and Macromedia are famous for applications that have huge overheads too.

Bring Back JJ Allaire! Java goes, Delphi stays. The last good version 
of CF was 5.0

Now the package is too expensive, runs anywhere from slow to crawl, 
has problems and is slowly loosing ground to PhP, IMHO.

Everyone wanted to buy it, put there own little touches on it and 
then re-sell it. It is now to the point that note pad is the preferred editor.




At 06:31 AM 11/19/2006, you wrote:
> > Install the 8.02 update, turn off cloaking and design notes.
>
>I would suggest to turn off site synchronization and site cache as well. It
>can be done on a site by site level.
>
>
> > It isn't too bad after that!
>
>In my opinion, if you only use Code View and never take advantage of the
>visual tools DW isn't better than HS+. But it's pretty much a matter of
>tastes.
>
>
>Massimo Foti, web-programmer for hire
>Tools for ColdFusion and Dreamweaver developers:
>http://www.massimocorner.com
>
>
>
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261049
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Dreamweaver is a total dog!!

[Tom Forbes]

My findings as well. I have a 3.6GHz and 1 Gb of RAM. I went back to 
HS after about a week. Too much overhead.



At 01:42 AM 11/19/2006, you wrote:
>What are the specs of the machine on which you are running it?
>
>On 11/19/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> > 
> >
> > I just installed DW for the first time, and what a piece of 
> crappola!! I have never seen nothing lag like this thing does. My 
> site has about 245 files and I cannot believe it cannot handle it. 
> Sometimes I think they put too much into these visual design tools. 
> I suppose I will go back to HS+ and be happy once again. I read all 
> the articles on how to improve DW speed, but IMO you should not 
> have to disable features in order to get something to work the way 
> it should. Arg!!!
> > 
> >
> >
> > Doug B.
> >
> >
>
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261043
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: HomeSite+ Binary Files?

[Tom Forbes]

OK - I know what you are doing - you have to click the "ADD" button in the 
FILE EXTENSION MANAGER, then add your *.exe or whatever you want.

I tried it in 5.5 and Plus - works OK for me,

Tom


At 07:11 PM 12/18/2004, you wrote:
>Thanks Tom.  I'm running HomeSite+ v5.2.  HomeSite already skips over EXE
>files, but that extension isn't listed anywhere in the Extension Manager.
>In the extension manager I can mark files "Editable", "Image", and "In
>Filter".  Is anything in the list that is not marked "Editable" considered
>binary?
>
>I would have thought that if you selected *.* as the filter and HomeSite
>didn't recognize the file extension it might assume it was binary.
>
>
>- Original Message -
>From: "Tom Forbes" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Saturday, December 18, 2004 4:21 PM
>Subject: Re: HomeSite+ Binary Files?
>
>
> > Hi Jim -
> >
> > In HomeSite goto OPTIONS, SETTINGS, FILE SETTINGS, EXTENSION MANAGER -
> >
> > I tested it with a " *.exe " and it worked OK.
> >
> > HTH,
> >
> > Tom
> >
> >
> >
> > At 04:06 PM 12/18/2004, you wrote:
> >>Where are binary file extensions defined for HomeSite+'s Extended Find?
> >>I'd like to do a server-wide search and the extended find is looking
> >>through binary files with extensions that are probably undefined
> >>anywhere
> >>in HomeSite.
>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188169
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: HomeSite+ Binary Files?

[Tom Forbes]

Hi Jim -

In HomeSite goto OPTIONS, SETTINGS, FILE SETTINGS, EXTENSION MANAGER -

I tested it with a " *.exe " and it worked OK.

HTH,

Tom



At 04:06 PM 12/18/2004, you wrote:
>Where are binary file extensions defined for HomeSite+'s Extended Find?
>I'd like to do a server-wide search and the extended find is looking
>through binary files with extensions that are probably undefined anywhere
>in HomeSite.
>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188167
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What's A Good Forum Program

[Tom Forbes]

Oh Man, thanks a million - this looks good Massimo.

Tom

At 08:37 AM 12/16/2004, you wrote:
> > I would like your opinions and advice. I want to begin a forum, that is
> > written if CF that will run on CF 5.0 (NO MX). I have only seen the
>Fusebox
> > version, and it is a little pricey.
>
>I don't have personal opinions, but you could check a few apps:
>
>http://www.adersoftware.com/index.cfm?page=cfbb
>http://sourceforge.net/projects/smb/
>http://sourceforge.net/projects/fbopenforums/
>http://www.cfmbb.org/index.cfm
>http://www.stickshiftsolutions.com/
>
>There are more...
>
>
>Massimo Foti
>DW tools: http://www.massimocorner.com
>CF tools:  http://www.olimpo.ch/tmt/
>

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187933
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: What's A Good Forum Program

[Tom Forbes]

That looks real nice Ray, but I have to stay with CF 5.0

Thanks,

Tom


At 09:25 AM 12/16/2004, you wrote:
>That's Galleon. You can see it in action at 
>www.camdenfamily.com/morpheus/forums
>
>
>On Thu, 16 Dec 2004 10:53:04 -0500, Ben Rogers <[EMAIL PROTECTED]> wrote:
> > If you're subscribed to DevNet, the one in the latest DRK seems pretty 
> good.
> >
> > Ben Rogers
> > http://www.c4.net
> > v.508.240.0051
> > f.508.240.0057
> >
> > > -Original Message-
> > > From: Tom Forbes [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, December 16, 2004 12:36 PM
> > > To: CF-Talk
> > > Subject: What's A Good Forum Program
> > >
> > > I would like your opinions and advice. I want to begin a forum, that is
> > > written if CF that will run on CF 5.0 (NO MX). I have only seen the
> > > Fusebox
> > > version, and it is a little pricey.
> > >
> > > I see lots of PHP packages that look great, but having trouble finding a
> > > CF
> > > version.
> > >
> > > Thanks!
> > >
> > > Tom
> > >
> > >
> > >
> >
> >
>
>

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187931
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

What's A Good Forum Program

[Tom Forbes]

I would like your opinions and advice. I want to begin a forum, that is 
written if CF that will run on CF 5.0 (NO MX). I have only seen the Fusebox 
version, and it is a little pricey.

I see lots of PHP packages that look great, but having trouble finding a CF 
version.

Thanks!

Tom 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187885
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Recommend a threaded forum application

[Tom Forbes]

Hi Jim,

Perhaps one of the applications listed here will take care of your needs:
http://www.cfcustomtags.com/subcategories.cfm?parentid=159  or 
http://www.cfcode.com/index.cfm/fuse/forumdetails.htm

Thanks for all your help in the past,

Tom

At 07:00 PM 4/17/04, you wrote:
>I know a variation of this question gets asked every couple of months or
>so.  Is there a good CF based forum application available?  Must be
>threaded, with the option to view threads either via a threaded view or
>flat view.  From what I've seen in the past (haven't looked in about a
>year) the choices in CF based forums are pretty slim.  And those that I've
>looked at aren't particularly full featured in comparison to some of the
>php boards.
>
>Must support CF5 and would prefer ODBC support for MySQL, but Access via
>ODBC is probably sufficient for this application.  Good use of CSS for
>customization of the look is a must.
>
>If you don't have a good CF forum to recommend, then a recommendation for
>a PHP based application would be the second choice.  I've worked with
>phpbb and like it, but have crossed it off the list due to it's lack of
>support (and no plans) for threaded discussions.  And I don't have the
>time to incorporate the fairly involved mods to phpbb to add threading.
>
>Thanks.
>
>--
>[Todays Threads] 
>[This Message] 
>[Subscription] 
>[Fast 
>Unsubscribe] [User Settings]
>
>--
>
>1520f2f.jpg
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CF Classified Ads Program

[Tom Forbes]

Excuse me, does anyone know of a CF classifieds Ad program I can purchase? 
I currently use a UNIX based one that is about 8 years old, and I would 
like to switch to CF. I have not had any luck locating one, but I figure 
there must be one out there.

Thanks CF'ers!

Tom
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Does CF Studio 4.52 get along with XP Pro or XP Home?

[Tom Forbes]

Thanks to all of you that gave me the OK to upgrade to XP with CF 4.52. 
But... If I am just making web sites with cf, would you recommend XP Pro or 
XP Home?

My income depends on my productivity, and when I have to re-learn a piece 
of software, that reduces my productivity. In addition, I have long ago 
decided I want nothing that Dream Weaver has to offer. I don't do Flash 
stuff, and frankly, I don't have a high opinion of MM's techsupport.

In addition, their prices are high, and the software is not reliable or 
there would be about 50% fewer posts on this board.

I'm not looking for an onslaught of opposing views here, I just like to 
stick to software that I know well through years of use. If I could get a 
new computer with Win98SE loaded, I would not hesitate!

Again, thank you very much for your help!

Tom


At 01:48 PM 11/10/03 -0500, you wrote:
>How come you don't want to upgrade?
>
>
>Adam Wayne Lehman
>Web Systems Developer
>Johns Hopkins Bloomberg School of Public Health
>Distance Education Division
>
>
>-Original Message-
>From: Tom Forbes [mailto:[EMAIL PROTECTED]
>Sent: Monday, November 10, 2003 1:28 PM
>To: CF-Talk
>Subject: Does CF Studio 4.52 get along with XP Pro or XP Home?
>
>
>Dear CF'ers
>
>I have been running CF Studio 4.52 for several years on a Win 98 SE
>machine, using the "Personal Web Server." I only develop sites, I do not
>host.
>
>I now need to replace my computer and my question is what problems
>should I
>expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want
>to
>change from CF Studio 4.52 to a newer upgrade.
>
>Thank You Very Much!
>
>Tom
>
>   _
>
>
>--
>[
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Does CF Studio 4.52 get along with XP Pro or XP Home?

[Tom Forbes]

Dear CF'ers

I have been running CF Studio 4.52 for several years on a Win 98 SE 
machine, using the "Personal Web Server." I only develop sites, I do not host.

I now need to replace my computer and my question is what problems should I 
expect with using CF Studio 4.52 with XP Pro or XP Home? I DO NOT want to 
change from CF Studio 4.52 to a newer upgrade.

Thank You Very Much!

Tom


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Image upload en masse

[Tom Forbes]

Fantastic Solution!

Tom




At 11:27 PM 9/1/03 -0500, you wrote:
>have him use the browser to ftp.  Instead of using http in the front, he
>puts ftp in the front.
>
>(ie: ftp://yourftpsite
>
>he'll need to pass username and password to the site but after he does, all
>he has to do is drag and drop.
>
>for example:
>
>ftp://username:[EMAIL PROTECTED]
>
>ie:
>ftp://myusername:[EMAIL PROTECTED]
>
>simple... ??
>
>Try it... do a drag and drop and you'll see how easy it is.
>
>-pat-
>
>
>
>-Original Message-
>From: Parker, Kevin [mailto:[EMAIL PROTECTED]
>Sent: Monday, September 01, 2003 11:13 PM
>To: CF-Talk
>Subject: RE: Image upload en masse
>
>
>That's the obvious and certainly best solution but we're not sure if FTP
>clients are going to be available from Internet Cafe's in India or if the
>cafe will allow them to be loaded. As the web is always accessible from
>cafes then a web based app seemed like a sure thing but I'm open to advice
>and suggestions.
>
>
>**
>Kevin Parker
>Web Services Manager
>WorkCover Corporation
>
>e: [EMAIL PROTECTED]
>w: www.workcover.com
>
>p:+ 61 8 8233 2548
>f: +61 8 8233 2282
>m: 0418 806 166
>**
>
>
>-Original Message-
>From: B.H. Forbes [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, 2 September 2003 1:36 PM
>To: CF-Talk
>Subject: RE: Image upload en masse
>
>
>have him use ftp
>
>or is that too simple??
>
>
>
>-Original Message-
>From: Parker, Kevin [mailto:[EMAIL PROTECTED]
>Sent: Monday, September 01, 2003 10:53 PM
>To: CF-Talk
>Subject: Image upload en masse
>
>
>Have a friend who's touring India for about 2 months later this year and is
>taking his digi camera. Periodically he'll get them dumped to a CD (if he
>can find a place in India to do that) but as a precaution (in case he loses
>the camera and the CDs) he wants to dump them on the web. He figures he'll
>have about 80 images at a time.
>
>Picking them one at a time (such as in a CF form) is pretty intensive and
>he's looking for a way to grab them en masse and upload them. Given that
>he'll probably be doing this from Internet Cafe's he probably needs to do
>this via some web app because its unlikely the cafes will have an FTP client
>loaded or allow one to be loaded.
>
>Any suggested approaches please.
>
>
>**
>Kevin Parker
>Web Services Manager
>WorkCover Corporation
>
>e: [EMAIL PROTECTED]
>w: www.workcover.com
>
>p:+ 61 8 8233 2548
>f: +61 8 8233 2282
>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.
>
>
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com

Can You Suggest a GOOD Forum?

[Tom Forbes]

Dear CF'ers,

I need to acquire a CF forum and customize it by the end of June. Can 
anyone with experience working with one please suggest one that will:

Work with CF4.52, Open Source, Not Beta - but time proven, Windows, Under 
500.00.

I would Love to find one that has had the "polish" applied by having gone 
through several versions. As you all know, not all applications that work 
properly have a good feature set, look aesthetically pleasing and are 
bullet-proof.

Thanks to all for your comments and suggestions!

Tom

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

Hi Jim,

Thanks, That did it! BUT, it works great locally with CF Studio, but when I 
upload it the list does not change order. It stays with the first random 
order it generated. It's not a cached query. I reload and reload, but no 
change in the order. Granted, it is a random order, but it stays the same.

Any ideas here?? Sorry to be a pain.

Tom


At 04:46 PM 4/3/03 -0700, you wrote:
>Tom,
>
>In Access, something like the following works for us, where 'PrimaryKey' is a
>unique key in the table:
>
>SELECT *
>FROM CompanyTbl
>WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'
>ORDER BY ClassOfService, rnd(PrimaryKey)
>
>If you're not seeing the expected number of records, I'd examint the WHERE
>clause, as the sort order should have no effect on this.
>
>Jim
>
>- Original Message -
>From: "Tom Forbes" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, April 03, 2003 4:11 PM
>Subject: RE: How can I "ORDER BY RANDOM" ?
>
>
> > This method does return a random order, but there should be 7 records
> > returned, and there is a random number returned!
> >
> > Tom
> >
> >
> >
> > At 10:48 AM 4/4/03 +1200, you wrote:
> > >You'd have to write
> > >  SELECT CompanyTbl.*
> > >   FROM CompanyTbl
> > >   WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 
> 'Yes'
> > >   ORDER BY CompanyTbl.ClassOfService, rnd()
> > >
> > >Some dbms's will happily generate the same random number for each row. I
> > >know this works in SQL Server:
> > > SELECT*
> > > FROM  myTable
> > > ORDER BY  NEWID()
> > >
> > >
> > >
> > > > -Original Message-
> > > > From: Tom Forbes [mailto:[EMAIL PROTECTED]
> > > > Sent: Friday, 4 April 2003 10:45 a.m.
> > > > To: CF-Talk
> > > > Subject: RE: How can I "ORDER BY RANDOM" ?
> > > >
> > > > Hi Russ,
> > > >
> > > > I did that, but I get an error stating that there is no column in 
> the db
> > > > named SortOrder. Here is the modified query:
> > > >
> > > >  > > > DBTYPE="ODBC">
> > > >
> > > >  SELECT CompanyTbl.*, Rnd() as SortOrder
> > > >
> > > >  FROM CompanyTbl
> > > >
> > > >  WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic 
> = 'Yes'
> > > >
> > > >  ORDER BY CompanyTbl.ClassOfService, SortOrder
> > > >
> > > > 
> > > >
> > > > Thanks,
> > > >
> > > > Tom
> > > >
> > > > At 04:10 PM 4/3/03 -0600, you wrote:
> > > > >If your database has a random number generator function, you can try:
> > > > >
> > > > >SELECT tblCompany.*, Random() as SortOrder FROM tblCompany ORDER by
> > > > >SortOrder
> > > > >
> > > > >HTH--haven't tried it myself.
> > > > >
> > > > >Russ
> > > > >
> > > > > > -Original Message-
> > > > > > From: Tom Forbes [mailto:[EMAIL PROTECTED]
> > > > > > Sent: Thursday, April 03, 2003 4:06 PM
> > > > > > To: CF-Talk
> > > > > > Subject: How can I "ORDER BY RANDOM" ?
> > > > > >
> > > > > >
> > > > > > Dear CF'ers:
> > > > > >
> > > > > > I have searched my CF books for a clue, but am unable to find
> > > > > > an example of
> > > > > > what I am trying to do.
> > > > > >
> > > > > > I need to modify the below query so that my results are still
> > > > > > ordered by
> > > > > > "ClassOfService" (a number between 1 and 4) - BUT, the
> > > > > > "CompanyName" needs
> > > > > > to be displayed in a RANDOM ORDER each time the query is run,
> > > > > > rather than
> > > > > > its current alphabetical order. This will give all companies that
> > > > > > participate an even advantage of being selected rather than
> > > > > > those that
> > > > > > begin with the first letters of the alphabet.
&g

Re: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

I use Access 97




At 04:19 PM 4/3/03 -0700, you wrote:
>Ahh, I see.  You want the rows to be randomized.
>
>What DB are you using?
>
>- Original Message -----
>From: Tom Forbes <[EMAIL PROTECTED]>
>Date: Thursday, April 3, 2003 4:05 pm
>Subject: Re: How can I "ORDER BY RANDOM" ?
>
> > Thanks, I tried this, and it DOES return a list in a random order
> > every
> > time, BUT ... the record set is 7, and the query returns random
> > numbers of
> > results, from 1 to 7! I have the following line that I modified to
> > include
> > your code - could my GROUP parameter causing problems??
> >
> > Tom
> >
> >  > GROUP="ClassOfService"
> > startrow="#row#" maxrows="1">
> >
> >
> > At 03:32 PM 4/3/03 -0700, you wrote:
> > >Leave your query the same.
> > >
> > >Do something like:
> > >
> > >
> > >
> > > > maxrows="1">>  {do processing here}
> > >
> > >
> > >- Original Message -
> > >From: Tom Forbes <[EMAIL PROTECTED]>
> > >Date: Thursday, April 3, 2003 3:30 pm
> > >Subject: Re: How can I "ORDER BY RANDOM" ?
> > >
> > > > I know, I stated in my question that I wanted to MODIFY the
> > > > EXISTING query.
> > > >
> > > >
> > > > At 02:26 PM 4/3/03 -0800, you wrote:
> > > > >OK...but you should still remove that field from the ORDER BY
> > > > clause :-)
> > > > >Granted it may not always return records in a random order, but
> > > > there is no
> > > > >point in ordering by the CompanyName if you're after random
> > results.> > >
> > > > >Bryan Stevenson B.Comm.
> > > > >VP & Director of E-Commerce Development
> > > > >Electric Edge Systems Group Inc.
> > > > >t. 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 Forbes" <[EMAIL PROTECTED]>
> > > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > >Sent: Thursday, April 03, 2003 2:16 PM
> > > > >Subject: Re: How can I "ORDER BY RANDOM" ?
> > > > >
> > > > >
> > > > > > Bryan,
> > > > > >
> > > > > > I need to display the company names in a random order EACH
> > > > TIME the query
> > > > > > is run.
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Tom
> > > > > >
> > > > > >
> > > > > > At 02:12 PM 4/3/03 -0800, you wrote:
> > > > > > >Remove the CompanyName field from the ORDER BY clause.  Then
> > > > the results
> > > > > > >will be ordered by ClassOfService onlyunless I'm missing
> > > > your point
> > > > >;-)
> > > > > > >
> > > > > > >Bryan Stevenson B.Comm.
> > > > > > >VP & Director of E-Commerce Development
> > > > > > >Electric Edge Systems Group Inc.
> > > > > > >t. 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 Forbes" <[EMAIL PROTECTED]>
> > > > > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > > > >Sent: Thursday, April 03, 2003 2:05 P

RE: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

Hi Benjamin,

Thanks for the good sql resource. I looked at the 7 articles, the ones that 
pertain to Access are dead links. I have Access DB.

But, this site will come in very handy for other queries. Thanks very much!

Tom



At 05:33 PM 4/3/03 -0500, you wrote:
>A quick search produced this list of articles:
>
>http://www.sqlteam.com/FilterTopics.asp?TopicID=135
>
>Benjamin S. Rogers
>http://www.c4.net/
>v.508.240.0051
>f.508.240.0057
>
>-Original Message-
>From: Tom Forbes [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 03, 2003 5:06 PM
>To: CF-Talk
>Subject: How can I "ORDER BY RANDOM" ?
>
>
>Dear CF'ers:
>
>I have searched my CF books for a clue, but am unable to find an example
>of
>what I am trying to do.
>
>I need to modify the below query so that my results are still ordered by
>
>"ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName"
>needs
>to be displayed in a RANDOM ORDER each time the query is run, rather
>than
>its current alphabetical order. This will give all companies that
>participate an even advantage of being selected rather than those that
>begin with the first letters of the alphabet.
>
>Can someone please point me in the right direction? I have studied the
>CF
>RANDOM tag but can't figure out how to apply it.
>
>DBTYPE="ODBC">
>
>  SELECT *
>
>  FROM CompanyTbl
>
>  WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic =
>'Yes'
>
>  ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
>
>
>
>Thanks very much!!
>
>Tom Forbes
>
>
>
>***
>Tom Forbes,  Forbes Consulting, Inc.
>TEL: 407-772-3427   FAX: 407-772-3428
>Visit www.medmatrix.com for Medical Equipment Web Sites!
>E-Mail Subscription at www.medmatrix.com/mail_list.htm
>***
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

This method does return a random order, but there should be 7 records 
returned, and there is a random number returned!

Tom



At 10:48 AM 4/4/03 +1200, you wrote:
>You'd have to write
>  SELECT CompanyTbl.*
>   FROM CompanyTbl
>   WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'
>   ORDER BY CompanyTbl.ClassOfService, rnd()
>
>Some dbms's will happily generate the same random number for each row. I
>know this works in SQL Server:
> SELECT*
> FROM  myTable
> ORDER BY  NEWID()
>
>
>
> > -Original Message-
> > From: Tom Forbes [mailto:[EMAIL PROTECTED]
> > Sent: Friday, 4 April 2003 10:45 a.m.
> > To: CF-Talk
> > Subject: RE: How can I "ORDER BY RANDOM" ?
> >
> > Hi Russ,
> >
> > I did that, but I get an error stating that there is no column in the db
> > named SortOrder. Here is the modified query:
> >
> >  > DBTYPE="ODBC">
> >
> >  SELECT CompanyTbl.*, Rnd() as SortOrder
> >
> >  FROM CompanyTbl
> >
> >  WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'
> >
> >  ORDER BY CompanyTbl.ClassOfService, SortOrder
> >
> > 
> >
> > Thanks,
> >
> > Tom
> >
> > At 04:10 PM 4/3/03 -0600, you wrote:
> > >If your database has a random number generator function, you can try:
> > >
> > >SELECT tblCompany.*, Random() as SortOrder FROM tblCompany ORDER by
> > >SortOrder
> > >
> > >HTH--haven't tried it myself.
> > >
> > >Russ
> > >
> > > > -Original Message-
> > > > From: Tom Forbes [mailto:[EMAIL PROTECTED]
> > > > Sent: Thursday, April 03, 2003 4:06 PM
> > > > To: CF-Talk
> > > > Subject: How can I "ORDER BY RANDOM" ?
> > > >
> > > >
> > > > Dear CF'ers:
> > > >
> > > > I have searched my CF books for a clue, but am unable to find
> > > > an example of
> > > > what I am trying to do.
> > > >
> > > > I need to modify the below query so that my results are still
> > > > ordered by
> > > > "ClassOfService" (a number between 1 and 4) - BUT, the
> > > > "CompanyName" needs
> > > > to be displayed in a RANDOM ORDER each time the query is run,
> > > > rather than
> > > > its current alphabetical order. This will give all companies that
> > > > participate an even advantage of being selected rather than
> > > > those that
> > > > begin with the first letters of the alphabet.
> > > >
> > > > Can someone please point me in the right direction? I have
> > > > studied the CF
> > > > RANDOM tag but can't figure out how to apply it.
> > > >
> > > >  > > > DBTYPE="ODBC">
> > > >
> > > >  SELECT *
> > > >
> > > >  FROM CompanyTbl
> > > >
> > > >  WHERE CompanyWantsMiniSite = 'Yes' AND
> > > > MakeMiniSitePublic = 'Yes'
> > > >
> > > >  ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
> > > >
> > > > 
> > > >
> > > > Thanks very much!!
> > > >
> > > > Tom Forbes
> > > >
> > > >
> > > >
> > > > **
> > > > *
> > > > Tom Forbes,  Forbes Consulting, Inc.
> > > > TEL: 407-772-3427   FAX: 407-772-3428
> > > > Visit www.medmatrix.com for Medical Equipment Web Sites!
> > > > E-Mail Subscription at www.medmatrix.com/mail_list.htm
> > > > **
> > > > *
> > > >
> > > >
> > >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

Thanks, I tried this, and it DOES return a list in a random order every 
time, BUT ... the record set is 7, and the query returns random numbers of 
results, from 1 to 7! I have the following line that I modified to include 
your code - could my GROUP parameter causing problems??

Tom




At 03:32 PM 4/3/03 -0700, you wrote:
>Leave your query the same.
>
>Do something like:
>
>
>
>
>  {do processing here}
>
>
>----- Original Message -
>From: Tom Forbes <[EMAIL PROTECTED]>
>Date: Thursday, April 3, 2003 3:30 pm
>Subject: Re: How can I "ORDER BY RANDOM" ?
>
> > I know, I stated in my question that I wanted to MODIFY the
> > EXISTING query.
> >
> >
> > At 02:26 PM 4/3/03 -0800, you wrote:
> > >OK...but you should still remove that field from the ORDER BY
> > clause :-)
> > >Granted it may not always return records in a random order, but
> > there is no
> > >point in ordering by the CompanyName if you're after random results.
> > >
> > >Bryan Stevenson B.Comm.
> > >VP & Director of E-Commerce Development
> > >Electric Edge Systems Group Inc.
> > >t. 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 Forbes" <[EMAIL PROTECTED]>
> > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > >Sent: Thursday, April 03, 2003 2:16 PM
> > >Subject: Re: How can I "ORDER BY RANDOM" ?
> > >
> > >
> > > > Bryan,
> > > >
> > > > I need to display the company names in a random order EACH
> > TIME the query
> > > > is run.
> > > >
> > > > Thanks,
> > > >
> > > > Tom
> > > >
> > > >
> > > > At 02:12 PM 4/3/03 -0800, you wrote:
> > > > >Remove the CompanyName field from the ORDER BY clause.  Then
> > the results
> > > > >will be ordered by ClassOfService onlyunless I'm missing
> > your point
> > >;-)
> > > > >
> > > > >Bryan Stevenson B.Comm.
> > > > >VP & Director of E-Commerce Development
> > > > >Electric Edge Systems Group Inc.
> > > > >t. 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 Forbes" <[EMAIL PROTECTED]>
> > > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > >Sent: Thursday, April 03, 2003 2:05 PM
> > > > >Subject: How can I "ORDER BY RANDOM" ?
> > > > >
> > > > >
> > > > > > Dear CF'ers:
> > > > > >
> > > > > > I have searched my CF books for a clue, but am unable to
> > find an
> > >example
> > > > >of
> > > > > > what I am trying to do.
> > > > > >
> > > > > > I need to modify the below query so that my results are
> > still ordered
> > >by
> > > > > > "ClassOfService" (a number between 1 and 4) - BUT, the
> > "CompanyName">needs
> > > > > > to be displayed in a RANDOM ORDER each time the query is
> > run, rather
> > >than
> > > > > > its current alphabetical order. This will give all
> > companies that
> > > > > > participate an even advantage of being selected rather
> > than those that
> > > > > > begin with the first letters of the alphabet.
> > > > > >
> > > > > > Can someone please point me in the right direction? I have
> > studied the
> > >CF
> > > > > > RANDOM tag but can't figure out how to apply it.
> > &g

Re: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

I have version 4.5

Tom


At 03:09 PM 4/3/03 -0700, you wrote:
>Ivan Latunov ([EMAIL PROTECTED]) wrote a great UDF for doing that with an
>array, called ArrayShuffle (http://www.cflib.org/udf.cfm?ID=292).  You
>write the companys into an array, and then it shuffles them.  (I did a
>similar thing here
>(http://hscwebdev.unm.edu/webdev/staff/groth/hogwash_form.cfm) to
>juggle 25 table cells.
>
>David Groth, Analyst/Programmer III
>HSC Library & Informatics Center, University of New Mexico
>505.272.8406  e-mail: [EMAIL PROTECTED]
>
> >>> [EMAIL PROTECTED] 04/03/03 03:05PM >>>
>Dear CF'ers:
>
>I have searched my CF books for a clue, but am unable to find an
>example of
>what I am trying to do.
>
>I need to modify the below query so that my results are still ordered
>by
>"ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName"
>needs
>to be displayed in a RANDOM ORDER each time the query is run, rather
>than
>its current alphabetical order. This will give all companies that
>participate an even advantage of being selected rather than those that
>
>begin with the first letters of the alphabet.
>
>Can someone please point me in the right direction? I have studied the
>CF
>RANDOM tag but can't figure out how to apply it.
>
>DBTYPE="ODBC">
>
>  SELECT *
>
>  FROM CompanyTbl
>
>      WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic =
>'Yes'
>
>  ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
>
>
>
>Thanks very much!!
>
>Tom Forbes
>
>
>
>***
>Tom Forbes,  Forbes Consulting, Inc.
>TEL: 407-772-3427   FAX: 407-772-3428
>Visit www.medmatrix.com for Medical Equipment Web Sites!
>E-Mail Subscription at www.medmatrix.com/mail_list.htm
>***
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

Hi Russ,

I did that, but I get an error stating that there is no column in the db 
named SortOrder. Here is the modified query:



 SELECT CompanyTbl.*, Rnd() as SortOrder

 FROM CompanyTbl

 WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'

 ORDER BY CompanyTbl.ClassOfService, SortOrder



Thanks,

Tom

At 04:10 PM 4/3/03 -0600, you wrote:
>If your database has a random number generator function, you can try:
>
>SELECT tblCompany.*, Random() as SortOrder FROM tblCompany ORDER by
>SortOrder
>
>HTH--haven't tried it myself.
>
>Russ
>
> > -Original Message-
> > From: Tom Forbes [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 03, 2003 4:06 PM
> > To: CF-Talk
> > Subject: How can I "ORDER BY RANDOM" ?
> >
> >
> > Dear CF'ers:
> >
> > I have searched my CF books for a clue, but am unable to find
> > an example of
> > what I am trying to do.
> >
> > I need to modify the below query so that my results are still
> > ordered by
> > "ClassOfService" (a number between 1 and 4) - BUT, the
> > "CompanyName" needs
> > to be displayed in a RANDOM ORDER each time the query is run,
> > rather than
> > its current alphabetical order. This will give all companies that
> > participate an even advantage of being selected rather than
> > those that
> > begin with the first letters of the alphabet.
> >
> > Can someone please point me in the right direction? I have
> > studied the CF
> > RANDOM tag but can't figure out how to apply it.
> >
> >  > DBTYPE="ODBC">
> >
> >  SELECT *
> >
> >  FROM CompanyTbl
> >
> >  WHERE CompanyWantsMiniSite = 'Yes' AND
> > MakeMiniSitePublic = 'Yes'
> >
> >  ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
> >
> > 
> >
> > Thanks very much!!
> >
> > Tom Forbes
> >
> >
> >
> > **
> > *
> > Tom Forbes,  Forbes Consulting, Inc.
> > TEL: 407-772-3427   FAX: 407-772-3428
> > Visit www.medmatrix.com for Medical Equipment Web Sites!
> > E-Mail Subscription at www.medmatrix.com/mail_list.htm
> > **
> > *
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

I know, I stated in my question that I wanted to MODIFY the EXISTING query.


At 02:26 PM 4/3/03 -0800, you wrote:
>OK...but you should still remove that field from the ORDER BY clause :-)
>Granted it may not always return records in a random order, but there is no
>point in ordering by the CompanyName if you're after random results.
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 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 Forbes" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, April 03, 2003 2:16 PM
>Subject: Re: How can I "ORDER BY RANDOM" ?
>
>
> > Bryan,
> >
> > I need to display the company names in a random order EACH TIME the query
> > is run.
> >
> > Thanks,
> >
> > Tom
> >
> >
> > At 02:12 PM 4/3/03 -0800, you wrote:
> > >Remove the CompanyName field from the ORDER BY clause.  Then the results
> > >will be ordered by ClassOfService onlyunless I'm missing your point
>;-)
> > >
> > >Bryan Stevenson B.Comm.
> > >VP & Director of E-Commerce Development
> > >Electric Edge Systems Group Inc.
> > >t. 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 Forbes" <[EMAIL PROTECTED]>
> > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > >Sent: Thursday, April 03, 2003 2:05 PM
> > >Subject: How can I "ORDER BY RANDOM" ?
> > >
> > >
> > > > Dear CF'ers:
> > > >
> > > > I have searched my CF books for a clue, but am unable to find an
>example
> > >of
> > > > what I am trying to do.
> > > >
> > > > I need to modify the below query so that my results are still ordered
>by
> > > > "ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName"
>needs
> > > > to be displayed in a RANDOM ORDER each time the query is run, rather
>than
> > > > its current alphabetical order. This will give all companies that
> > > > participate an even advantage of being selected rather than those that
> > > > begin with the first letters of the alphabet.
> > > >
> > > > Can someone please point me in the right direction? I have studied the
>CF
> > > > RANDOM tag but can't figure out how to apply it.
> > > >
> > > >  > > > DBTYPE="ODBC">
> > > >
> > > >  SELECT *
> > > >
> > > >  FROM CompanyTbl
> > > >
> > > >  WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic =
>'Yes'
> > > >
> > > >  ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
> > > >
> > > > 
> > > >
> > > > Thanks very much!!
> > > >
> > > > Tom Forbes
> > > >
> > > >
> > > >
> > > >
>***
> > > > Tom Forbes,  Forbes Consulting, Inc.
> > > > TEL: 407-772-3427   FAX: 407-772-3428
> > > > Visit www.medmatrix.com for Medical Equipment Web Sites!
> > > > E-Mail Subscription at www.medmatrix.com/mail_list.htm
> > > >
>***
> > > >
> > > >
> > >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How can I "ORDER BY RANDOM" ?

[Tom Forbes]

Bryan,

I need to display the company names in a random order EACH TIME the query 
is run.

Thanks,

Tom


At 02:12 PM 4/3/03 -0800, you wrote:
>Remove the CompanyName field from the ORDER BY clause.  Then the results
>will be ordered by ClassOfService onlyunless I'm missing your point ;-)
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 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 Forbes" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, April 03, 2003 2:05 PM
>Subject: How can I "ORDER BY RANDOM" ?
>
>
> > Dear CF'ers:
> >
> > I have searched my CF books for a clue, but am unable to find an example
>of
> > what I am trying to do.
> >
> > I need to modify the below query so that my results are still ordered by
> > "ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName" needs
> > to be displayed in a RANDOM ORDER each time the query is run, rather than
> > its current alphabetical order. This will give all companies that
> > participate an even advantage of being selected rather than those that
> > begin with the first letters of the alphabet.
> >
> > Can someone please point me in the right direction? I have studied the CF
> > RANDOM tag but can't figure out how to apply it.
> >
> >  > DBTYPE="ODBC">
> >
> >  SELECT *
> >
> >  FROM CompanyTbl
> >
> >  WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'
> >
> >  ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName
> >
> > 
> >
> > Thanks very much!!
> >
> > Tom Forbes
> >
> >
> >
> > ***
> > Tom Forbes,  Forbes Consulting, Inc.
> > TEL: 407-772-3427   FAX: 407-772-3428
> > Visit www.medmatrix.com for Medical Equipment Web Sites!
> > E-Mail Subscription at www.medmatrix.com/mail_list.htm
> > ***
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

How can I "ORDER BY RANDOM" ?

[Tom Forbes]

Dear CF'ers:

I have searched my CF books for a clue, but am unable to find an example of 
what I am trying to do.

I need to modify the below query so that my results are still ordered by 
"ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName" needs 
to be displayed in a RANDOM ORDER each time the query is run, rather than 
its current alphabetical order. This will give all companies that 
participate an even advantage of being selected rather than those that 
begin with the first letters of the alphabet.

Can someone please point me in the right direction? I have studied the CF 
RANDOM tag but can't figure out how to apply it.



 SELECT *

 FROM CompanyTbl

 WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes'

 ORDER BY CompanyTbl.ClassOfService, CompanyTbl.CompanyName



Thanks very much!!

Tom Forbes



***********
Tom Forbes,  Forbes Consulting, Inc.
TEL: 407-772-3427   FAX: 407-772-3428
Visit www.medmatrix.com for Medical Equipment Web Sites!
E-Mail Subscription at www.medmatrix.com/mail_list.htm
***

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFOUTPUT group by & recordcount HELP

[Tom Forbes]

Dear Dina Hess,

Thank you very much for taking the time this morning to help me with this 
Query/RecordCount problem. There is NO WAY I would have come to this 
solution on my own. I have since read up on column aliases, aggregate 
functions and loops so that I can understand how this works. I have tested 
it on my db, and it runs great - no tweaking!

You made it possible for me to get the problem solved, and I learned a lot 
in the process.

Thanks again for your excellent help, and have a very happy Holiday.

Tom




At 09:20 AM 12/10/02, you wrote:
>Recordcount isn't what you're after since it returns the total number of 
>rows in the query recordset.
>
>Instead you can get the number of records returned for each distinct 
>category by requerying (or in CF5+ do a query of the original 
>query)...something like this:
>
>
>   Select d.DomainCategoryID as catid,
>   count(d.DomainCategoryID) as num_cat_recs
>   FROM DomainCategoryTbl c, DomainNamesTbl d
>   WHERE c.DomainCategoryID=d.DomainCategoryID
>   Group By d.DomainCategoryID
>
>
>Then you could output it like this:
>
>
>
>Category: #DomainCategory# -
>
>
>
>
> 
> #num_cat_recs#
> 
>
>
>
>#DomainName#
>
>
>
>   - Original Message -
>   From: Tom Forbes
>   To: CF-Talk
>   Sent: Monday, December 09, 2002 9:28 PM
>   Subject: CFOUTPUT group by & recordcount HELP
>
>
>   I have checked my books and the CF achieve, but need a little help in the
>   right direction, please.
>
>   I have a db table that contains, among other things, Domain Names and 
> about
>   20 Different Domain Name Categories. I want to Output the results of this
>   db table by GROUPING the Domain Name Categories (I got that to work) and
>   next to the Category I would like to use the RecordCount parameter of the
>   Query to indicate how many Domain Names in each category. The problem with
>   the code below is that the RecordCount parameter returns the TOTAL number
>   of categories, not the Total Number of Categories for each particular
>   Domain Name.
>
>   I would greatly appreciate any help. Thanks!
>
>   I have:
>
>   
>SELECT *
>FROM DomainCategoryTbl,DomainNamesTbl
>   WHERE DomainCategoryTbl.DomainCategoryID=DomainNamesTbl.DomainCategoryID
>   ORDER By DomainCategory, DomainName
>   
>
>   and for the output I have:
>
>   
>
>   Category: #DomainCategory# - #GroupDomainCategories.RecordCount#
>
>   
>   #DomainName#
>   
>
>   
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
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

CFOUTPUT group by & recordcount HELP

[Tom Forbes]

I have checked my books and the CF achieve, but need a little help in the 
right direction, please.

I have a db table that contains, among other things, Domain Names and about 
20 Different Domain Name Categories. I want to Output the results of this 
db table by GROUPING the Domain Name Categories (I got that to work) and 
next to the Category I would like to use the RecordCount parameter of the 
Query to indicate how many Domain Names in each category. The problem with 
the code below is that the RecordCount parameter returns the TOTAL number 
of categories, not the Total Number of Categories for each particular 
Domain Name.

I would greatly appreciate any help. Thanks!

I have:


 SELECT *
 FROM DomainCategoryTbl,DomainNamesTbl
WHERE DomainCategoryTbl.DomainCategoryID=DomainNamesTbl.DomainCategoryID
ORDER By DomainCategory, DomainName


and for the output I have:



Category: #DomainCategory# - #GroupDomainCategories.RecordCount#


#DomainName#




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: test

[Tom Forbes]

Test # 3




At 02:59 AM 8/30/02, you wrote:
>replying :)
>
>-Original Message-
>From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
>Sent: Friday, August 30, 2002 2:59 AM
>To: CF-Talk
>Subject: Re: test
>
>
>Anyone who is on right now and wants to reply to this test post, please do
>so. Please DO NOT post to this thread past 5am. Thank you.
>
>
> > test 2
> >
> > Michael Dinowitz
> > Master of the House of Fusion
> > http://www.houseoffusion.com
> > - Original Message -
> > From: "Michael Dinowitz" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, August 30, 2002 2:27 AM
> > Subject: test
> >
> >
> > > test - please do not respond.
> > >
> > > Michael Dinowitz
> > > Master of the House of Fusion
> > > http://www.houseoffusion.com
> > >
> > >
> >
>
>
~|
Archives/subscription: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: Very disturbing rumors from macromedia that threaten cold fusion

[Tom Forbes]

It seems to be a rather HOT TOPIC - why don't I see any evidence of this 
discussion on the cf-community side??

Can Michael Dinowitz explain this phenomena before he takes the matter and
 
simply converts it into additional entropy?


Tom









At 10:43 PM 1/30/02, you wrote:
>This thread and those related to it have gone on wy to long. I'm
>banning the topic(s) for the next 2 days so we can get back to the
>technical side of ColdFusion.
>
> > Hi all,
> >
> > I apolgize if this has been posted already but a friend sent me this
>link.
> >
> >  MicroMedia
> > Big rumors abound in Macromedia land... word is the company is in dire
> > straights and that discussions between Macromedia and Microsoft are in
>the
> > works. Acquisition? Possibly... probably just Flash, DreamWeaver, and
> > UltraDev -- and in the meanwhile, kill off MS ASP competitor (not
>really)
> > ColdFusion. Who knows about FreeHand, Director, and the Java stuff...
> > Layoffs imminent.
> > When: 1/30/2002
> > Company: Macromedia
> > Severity: 90
> > Points: 189
> > 232 comments in the Happy Fun Slander Corner!
> >
> > url: http://www.fuckedcompany.com/
> >
> > Excuse the language :)
> >
> > It's funny to see whoever wrote this thinks that CF isn't a direct
> > competitor to ASP. Here's the link to the rest of the discussion.
> >
> > http://forum.fuckedcompany.com/phpcomments/index.php?newsid=82133&pag=
>1&par
> > entid=0&crapfilter=1
> >
> > 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
> >
>
__
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: Macromedia.com

[Tom Forbes]

This is not a one year old rumor. It was posted today at 
http://finance.yahoo.com/mp#macr and quite a few shares were BOUGHT in 
speculation of the MS involvement.

Tom



At 05:12 PM 1/30/02, you wrote:
>Tom, take a look at Matt Brown's previous response to this (below).
>
>Christine
>-Original Message-
>From: Matt Brown [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, January 30, 2002 11:30 AM
>To: CF-Talk
>Subject: Re: Macromedia.com
>
>
>
> >Doubt its true, if you look at the comments on fuckedcompany on the story
> >some of them refer to a rumour in a yahoo newsgroup. Probably someone
>trying
> >to influence share prices
>
>First. Great that you posted here. When you hear things like that you
>deserve to get some answer from MM. Thank you.
>
>This is an old rumor. A month old at least. I heard it before we announced
>our earnings when our stock spiked pretty well. I think that this
>hypothesis, that it was an attempt at manipulation, is correct.
>
>Macromedia, like all web based companies and software companies is facing
>challenges in this market. On the other hand, we have had our layoffs
>already. We have superior products in the pipeline. The overall economy is
>looking quite a bit better. I personally, after 6 years at MM, feel that we
>are more focused and more productive and more excited than we ever have
>been. I am working on projects that are going to make you all very happy
>over time and I think that is the future of MM, not as a subsidiary of MS.
>
>Macromedia is very well positioned for the time being. While I have no
>insight into the sales figures or the business. I am very confident that CF
>is doing well and that it will continue to do so for some time.
>_
>
>Matt Brown   Community
>Manager
>Macromedia  (650) 481-4525   [EMAIL PROTECTED]
>
>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT (was: Macromedia.com)

[Tom Forbes]

You're Right! After 56 posts regarding this topic in the last 3 days, let's
 
just move it to a different board so fewer people are exposed to it. That 
should help - but first

11:10AM Macromedia layoff/takeover rumors (MACR) 17.80 -0.20: Website 
f@#!ckedcompany.com, known best for its accurate layoff rumors, reports 
today that layoffs are imminent at MACR, but also notes unsubstantiated 
rumors that the company is in discussions with Microsoft (MSFT), hinting at
 
a sale of all or part of the company.

What Could This Mean???





At 04:45 PM 1/30/02, you wrote:
> > > Is CF Dead, no, but it is dying.
> >
> > Please explain this statement
>
>Or, better yet, don't. The cf-talk list isn't an appropriate forum for this
>discussion. It's for technical issues. The cf-community list is for this
>kind of thing - that's why we have separate lists. I think there's enough
>legitimate traffic on cf-talk without burdening it with this stuff.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
__
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: Macromedia.com

[Tom Forbes]

Mr. Stevenson,

Your comments, in my opinion, do a fairly inadequate job of sweeping the 
past, current and future concerns voiced by this forum, under the carpet.

Your lifetime experience regarding these very issues indicates you are 
quite naive to the course of the future of MM and CF. When the CF 
principals sold the small stock holders of their company down the river, 
thus creating the huge down gap in price and even huger monetary losses, it
 
should have been evident to you that you and other CF'ers were going to 
begin to whistle a new tune, the MM Company tune.

Is CF Dead, no, but it is dying. No problem for you though Bryan, As you so
 
just stated "If CF dies we all know how to develop web applications and can
 
apply that knowledge to a new language." What a great solution!

In my opinion, your title should be "VP & Director of E-Commerce 
Development and Solutions" - you could be the VP of one and the Director of
 
the other.

Good Luck

Tom

t 03:36 PM 1/30/02, you wrote:
>Can we stop all the fearmongering etc.!
>
>If CF dies we all know how to develop web applications and can apply that
 
>knowledge to a new
>langauge..get over it!
>
>CF ain't gonna dieMM is doing fine...againget over it!
>
>If I were MM and heard this much bitching I'd wonder why I was supporting
 
>those bitching...stop
>bitching!
>
>If you like CF and want it to continue to flourish as it has...make 
>constructive comments to the
>list and to MM that will help build a better productdon't post crap 
>and bitch and moan about
>every litttle hiccupthis is life and in life sh^t happens...deal with
 it!
>
>Lets see some positive comments coming out...try not to scare off new 
>CFers with stupid useless
>drivel.
>
>Try using CF to build the next killer app and glorify MM and CF until 
>nobody has any choice but to
>use CF because it can do wonderful thingshmm what a concept ;-)
>
>My 2 cents and I'm stickin to it.
>
>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
>
>- Original Message -
>From: "Billy Cravens" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, January 30, 2002 9:40 AM
>Subject: Re: Macromedia.com
>
>
> > Undoubtedly it will change.  Will it go away?  As long as it's 
> profitable, I
> > doubt it.  However, I continually ask myself, if [insert technology
 here]
> > disappeared tomorrow, could I feed my family?  I may like one language
 or
> > technology more than others, but I'll be damned if I'll bet my (and
 others
> > that depend on me) well-being on some company's (who's goal is profit,
 not
> > my well-being) product.
> >
> >
> > - Original Message -
> > From: "Cantrell, Adam" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, January 30, 2002 10:15 AM
> > Subject: RE: Macromedia.com
> >
> >
> > > Even if the rumor is true or not, we can't kid ourselves into thinking
> > > ColdFusion will be around for much longer in it's current state. It's
> > > governed by a company that's core product is a plugin to display
 moving
> > > vector graphics. Granted, they have other products, I personally use
> > > fireworks as an alternative to photoshop. That's all great, but we
 can't
> > > expect them to churn out and maintain a solid, server-side scripting
> > engine,
> > > capable of competing with it's FREE alternatives - for much longer.
 It's
> > > simply out of their scope.
> > >
> > > At first, I want to say "release it to the public, and charge for
 studio
> > > licenses", but then I look at the linux operating system, and that
 blows
> > > that whole idea out of the water (not trying to offend any hardcore
 linux
> > > advocates out there). There has to be some viable solution to preserve
> > this
> > > tool without worrying about its parent's control over its existence.
 
> I can
> > > live with having to develop in PHP, ASP.NET, or even the dreaded
 "J2EE"
> > (VM
> > > - blech), but I just don't want to. Cold Fusion makes it easy for me
 to
> > hack
> > > something together in a day and please the boss or whoever it is I'm
> > > developing for, which is great - "work smarter not harder" right? It's
> > solid
> > > (if you know all the little gotchas), and it's clean. There's just
 that
> > one
> > > big, dark cloud hovering above us all that quietly chants "I may not
 be
> > here
> > > for you in a year, I may suddenly abandon you, your work will mean 
> nothing
> > > then, you will have wasted 4 years living with me, I am the ghost of
> > > Macromedia Future".
> > >
> > > Am I just crazy, or is anyone else in the same boat as I?
> > >
> > > Adam.
> > >
> > > ps. I'm not trying to sound like one of those "the end is near"
> > > fearmongerers, I just want to see if I'm the only one that feels this
 
> way.
> > >
> > >
> > >
>

Re: IP Address Blocking

[Tom Forbes]

Ooooh, I wasn't thinking -

Thanks!



At 05:55 PM 12/20/01, you wrote:
>
>You are not allowed to view this page!
>
>
>
>HTH,
>
>Howie
>
>----- Original Message -
>From: "Tom Forbes" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, December 20, 2001 5:49 PM
>Subject: IP Address Blocking
>
>
> > I am unable to learn through any of my CF books if it is possible to
 block
> > a specific IP address from viewing a .cfm page.
> >
> > Has anyone out there either done this before, or could possibly point me
 in
> > the right direction?
> >
> > Happy Holidays!
> >
> > Tom
> > 
>
 ***
*
> > Tom Forbes,  Forbes Web Consulting, Inc.
> > TEL: 407-772-3427   FAX: 407-772-3428
> > Visit www.medmatrix.com for New and Used Medical Equipment!
> > We build and host Medical Equipment company Web sites too!
> > 
>
 ***
*
> >
>
__
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

IP Address Blocking

[Tom Forbes]

I am unable to learn through any of my CF books if it is possible to block 
a specific IP address from viewing a .cfm page.

Has anyone out there either done this before, or could possibly point me in 
the right direction?

Happy Holidays!

Tom

Tom Forbes,  Forbes Web Consulting, Inc.
TEL: 407-772-3427   FAX: 407-772-3428
Visit www.medmatrix.com for New and Used Medical Equipment!
We build and host Medical Equipment company Web sites too!

__
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: Mailing List Server/Bulk Mailer

[Tom Forbes]

You may want to take a look at http://www.mailermailer.com/ a try. Opt 
in/out, double opt in/out, lots of features, web based and priced according 
to the volume of mail per month.

You can upload current database e-mail lists in either comma or tab 
delimited format. No contracts to sign. They give you the code to paste 
into your page.

So far it has worked well for me. You can use it for free for an unlimited 
amount of time providing your list does not exceed 200.

Tom




At 12:03 AM 9/13/01, you wrote:
>Hey guys,
>
>What do you use for your bulk emailers or mailing list servers? We have a
>newsletter system here but we obviously don't want to use CFMAIL to send
>potentially thousands of HTML emails out at once.
>
>MOre specifically what about opt-in/opt-out, archives, etc, and integration
>with CF/databases.. Jmail?
>
>
>
>---
>Regards,
>
>Darryl Lyons
>Senior Systems Developer
>Fuzion: http://www.fuzion.com.au
>
>Email : [EMAIL PROTECTED]
>Phone : (07) 3620 1000
>Fax   : (07) 3620 1001
>Technical Support : 1300 888 480
>
>'merging business + technology'
>
~~
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

The To: line in CF MAIL - are spaces problems?

[Tom Forbes]

Dear CF'ers,

We are having an intermittent problem with the spool - it seems to "Freeze" 
about twice a day, with varying numbers of messages in que. The fix is to 
cycle the CF Server. We have CF4.51 SP2, Win2K - shared environment.

Will an unnecessary "space" in the To: line cause this. Some addresses are 
"[EMAIL PROTECTED],[EMAIL PROTECTED]" while others are separated with a 
space such as: "[EMAIL PROTECTED], [EMAIL PROTECTED]"

Thanks,

Tom

********
Tom Forbes,  Forbes Web Consulting, Inc.
TEL: 407-772-3427   FAX: 407-772-3428
Visit www.medmatrix.com for New and Used Medical Equipment!
We build and host Medical Equipment company Web sites too!

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

Mailing List Manager

[Tom Forbes]

I need to move to an opt in / opt out mailing list to accommodate about 
5,000 addresses. Can someone recommend a good Mailing List Manager that is 
CF based?

Thank you,

Tom Forbes

**
Shop MedSearch - Over 500 Web sites under one roof!
http://www.medsearch.medmatrix.com
TEL: 407-772-3427   FAX: 407-772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
**


~~
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: Throttling CFMAIL

[Tom Forbes]

FALSE ALARM - I found it - Thanks!

Tom


At 03:36 PM 8/30/01, you wrote:
>Found it - google returned the dev forum link.
>
>http://devex.allaire.com/developer/gallery/info.cfm?ID=05D90D06-6C6B-11D5-83
>F100508B94F85A
>
>Tony
>
>-Original Message-
>From: Cameron Childress [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 30, 2001 11:30 AM
>To: CF-Talk
>Subject: RE: Throttling CFMAIL
>
>
> > Also, if you don't have CF_ResendUndeliverableMail3 running on
> > your server, you should.
>
>What an awesome tag!  :)
>
>-Cameron
>
>
>Cameron Childress
>elliptIQ Inc.
>p.770.460.1035.232
>f.770.460.0963
>--
>http://www.neighborware.com
>America's Leading Community Network Software
>
~~
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: Throttling CFMAIL

[Tom Forbes]

The link below doesn't work for me, and a search of 
CF_ResendUndeliverableMail3 in the Developer Gallery turns up nothing.

Is this a joke? The tag sounds too good to be true. Any ideas?

Tom



At 03:36 PM 8/30/01, you wrote:
>Found it - google returned the dev forum link.
>
>http://devex.allaire.com/developer/gallery/info.cfm?ID=05D90D06-6C6B-11D5-83
>F100508B94F85A
>
>Tony
>
>-Original Message-
>From: Cameron Childress [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 30, 2001 11:30 AM
>To: CF-Talk
>Subject: RE: Throttling CFMAIL
>
>
> > Also, if you don't have CF_ResendUndeliverableMail3 running on
> > your server, you should.
>
>What an awesome tag!  :)
>
>-Cameron
>
>
>Cameron Childress
>elliptIQ Inc.
>p.770.460.1035.232
>f.770.460.0963
>--
>http://www.neighborware.com
>America's Leading Community Network Software
>
~~
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: How to Auto-Send email Every 10 Min?

[Tom Forbes]

Thanks Everyone - I can get it now!

Have a good evening and thank you for your help,

Tom


At 06:38 PM 8/25/01, you wrote:
>Good Evening,
>I suspect my ISP is loosing mail, the mail server stops and I have to call
>and tell them to cycle the CF Server - then all is well, but most of the
>time I loose what was in the spool.
>
>I would like to use  to auto send myself an e-mail every 10 min or
>so. Doing this, I could tell if the server was down by not receiving the
>message. I can not use the CF SCHEDULE TAG. How could I do this in a simple
>fashion??
>
>Thank You - I would appreciate any help.
>
>Tom
>
>
>
~~
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

How to Auto-Send email Every 10 Min?

[Tom Forbes]

Good Evening,
I suspect my ISP is loosing mail, the mail server stops and I have to call 
and tell them to cycle the CF Server - then all is well, but most of the 
time I loose what was in the spool.

I would like to use  to auto send myself an e-mail every 10 min or 
so. Doing this, I could tell if the server was down by not receiving the 
message. I can not use the CF SCHEDULE TAG. How could I do this in a simple 
fashion??

Thank You - I would appreciate any help.

Tom


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

Exploding "Main Frame"

[Tom Forbes]

Dear CF'ers,

I created a frames based directory, 
http://medsearch.medmatrix.com/explore/category2website.htm that has a 
problem with the "main" or "bottom right" window. Some sites are very 
unruly and are not confined within the "MAIN" window - they break out and 
take up the entire screen. Very Rude!

I have searched my Javascript Goodies book, as well as the 
www.javascripts.com site. I believe there must be a way to constrain these 
wild pages, but for the life of me I can not figure it out.

Anyone have a similar problem at one time that they would not mind sharing 
the solution to??

Thank You Very Much,

Tom Forbes

*
MedMatrix New & Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
*


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

How do I list query results in a random order fashion??

[Tom Forbes]

Dear Cf'ers:

I have the below query that gets companies alphabetically (stupid, eh?) - 
the problem is, the companies don't like it because, being ordered by 
company name, it gives preference to those that begin with the first 
letters of the alphabet. Can anyone think of a way to order this list in a 
random fashion each time it is envoked??

Thank you all for your consideration.

Tom




 SELECT DISTINCT
JoinTbl.CategoryID, JoinTbl.CompanyID, CategoryTbl.CategoryName, 
CategoryTbl.CategoryID, CompanyTbl.CompanyID, CompanyTbl.CompanyName, 
CompanyTbl.WebAddress

FROM CategoryTbl, JoinTbl, CompanyTbl

WHERE
JoinTbl.CategoryID = CategoryTbl.CategoryID AND
JoinTbl.CompanyID = CompanyTbl.CompanyID AND
JoinTbl.CategoryID = #CategoryID# AND CompanyTbl.WebAddress IS NOT NULL

ORDER BY CompanyTbl.CompanyName



*
MedMatrix New & Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
*


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

How do I increment counter field by clicking on link?

[Tom Forbes]

Help Please -

I have a database table with company information, and a field called "Visits" -

The below link appears in the left hand frame panel. When clicked, the 
visitor sees the company's web site in the right hand frame (bottomright).

http://#WebAddress#"; TARGET="bottomright">#CompanyName#

I want to increment the "Visits" field by one count every time the link is 
clicked. I have tried many approaches, but am unable to resolve this - can 
someone please help me??

Thanks very much!

Tom






***
MedMatrix Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
***


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

Re: Dynamic Table Height

[Tom Forbes]

Guy,

Create a 2 cell table consisting of a right and left cell. Assign one cell 
the dynamic contents, and the other the static contents. Set VALIGN = TOP. 
As the dynamic cell grows in height, the adjacent static cell will also 
grow in height. As the dynamic cell shrinks in height it will stop 
shrinking once it equals the minimum static cell height. This is because 
the two cells are in the same "ROW" - - - - Hope this helps.

Example:



 Static Cell
 Dynamic Cell



Regards,

Tom Forbes




At 09:23 AM 6/1/01, you wrote:
>Hmmm...
>
>Situation: Two tables beside each other. One contains
>dynamic content, the other is static.
>Goal: To have both tables the same height at all times
>regardless of how much content is in the dynamic table.
>However, the dynamic table should also never be shorter
>than the static table.
>Resources: A novice understanding of JavaScript, info
>brought in via  from an Access DB
>My Priority on this: Pretty low, but it would be really
>cool to be able to do.
>
>Yours In Conservation,
>
>Guy J. McDowell
>Webmaster
>Ontario Federation of Anglers & Hunters
>(705) 748-6324 ext. 262
>www.OFAH.org
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


***
MedMatrix Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
***


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

RE: Hyphen Use in CF 4.52

[Tom Forbes]

Thanks Steve! I learned from experimenting that database names and 
datasource names MAY contain a hyphen, regardless of CF version. CF version 
2 allowed a hyphen in the query name, but beginning with version 3, hyphens 
are not allowed - just underscores.

Thanks,

Tom Forbes



At 01:00 PM 3/22/01, you wrote:
>I can't remember back that far to know whether the variable naming rules
>were more lax then but as far as CF4.52 is concerned, variable names must
>contain only letters, numbers and underscores, and must start with a letter.
>This translates to meaning that your query names should follow the same
>convention as the query name forms part of the variable name when you use it
>to prefix the column name. The datasource name is fine as that isn't
>constrained by CF but the operating system upon which CF is installed. I
>haven't experimented with a range of different characters but I know that
>spaces work.
>
>Steve
>
>-Original Message-
>From: Tom Forbes [mailto:[EMAIL PROTECTED]]
>Sent: 22 March 2001 13:37
>To: CF-Talk
>Subject: Hyphen Use in CF 4.52
>
>
>
>I wrote an application in CF 2.0 several years ago. My provider just moved
>it to CF 4.52 and I get DataSource errors.
>
>My question: is it OK to use a hyphen in either/both the datasource name
>and/or the query name, or is this now illegal?
>
>Thanks very much,
>
>Tom
>
>***
>MedMatrix Used Medical Equipment Web Portal
>http://www.medmatrix.com
>V:(407) 772-3427   F:(407) 772-3428
>Tom Forbes,  Forbes Web Consulting, Inc.
>178 S. Monterey Isle Blvd., Longwood, FL - 32779
>***
>
~~
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

Hyphen Use in CF 4.52

[Tom Forbes]

I wrote an application in CF 2.0 several years ago. My provider just moved
it to CF 4.52 and I get DataSource errors.

My question: is it OK to use a hyphen in either/both the datasource name
and/or the query name, or is this now illegal?

Thanks very much,

Tom

***
MedMatrix Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
***


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

Hyphen Use in CF 4.52

[Tom Forbes]

I wrote an application in CF 2.0 several years ago. My provider just moved 
it to CF 4.52 and I get DataSource errors.

My question: is it OK to use a hyphen in either/both the datasource name 
and/or the query name, or is this now illegal?

Thanks very much,

Tom

***
MedMatrix Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
***


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

Re: dupes

[Tom Forbes]

It's a temporary problem, soon to be fixed. I get them too.

Tom

At 07:55 PM 2/8/01, you wrote:
>Why does this list constantly have duplicates posted to its
>members? Any thoughts?
>
>Regards,
>Stephen
>
>
>
~~
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

Re: OT: Mailing List Server Explosion?

[Tom Forbes]

It happened to me too, but to a lesser degree.

Tom


At 08:59 AM 2/8/01, you wrote:
>Did anyone else just get a huge amount of repeats last night, or do I need
>to talk to my network admin about our mail server recreating 24 e-mails
>about 100 times... I walked in this morning and had 233 e-mails from this
>list... and no dupes from anything else.
>
>Hatton Humphrey
>
>
>
~~
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

RE: You know what would be really cool?

[Tom Forbes]

CF'ers --

I've paid for entertainment that isn't this good.

It would be different if the problem was not chronic and acute (IMHO)

Tom

At 07:03 PM 7/12/00, you wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
> > > > 1) Using IIS
> > > > 2) .. therefore, using NT
> > > This can be found out through other means though - they're
> > > actually running IIS4... therefore NT4
> >
> > Not necessarily NT4 just because of IIS4 though.  That runs
> > on 98 too  (yes
> > its PWS but still reports IIS4).
>
>If Allaire is running their webservers on a 98 box, I think I'll wet
>myself laughing...  It wouldn't particularlly SURPRISE me, given what
>I've seen, but it would be dang funny!  
>
>Regards,
>Zac Bedell
>
>-BEGIN PGP SIGNATURE-
>Version: PGPfreeware 6.5.3 for non-commercial use 
>Comment: Please use PGP!!!
>
>iQA/AwUBOWz5NwraVoMWBwRBEQK1bQCfZ7AgKWgp6SZkM8nS0pF41PRd0vQAn3eo
>DA20LgjRGGLIqeKsWvbi3ddR
>=omua
>-END PGP SIGNATURE-
>--
>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: Is there anything that ASP can do and CF cannot?

[Tom Forbes]

Bill -

Thanks for saying something regarding that last post from Jim - I too don't 
like to see the term ASP used, this is a CF board - lets keep it that way! 
My hat's off to Bill, but I am in agreement with Jim.

Happy Mothers Day.

Tom

At 10:58 PM 5/5/00, you wrote:
>Please don't use the foul language on this list.  While I am sure that many
>would agree with your use of it, we are all adults and we can find many,
>many other words in the English dictionary to use instead.  Thanks for not
>using them in the future.
>
>Bill
>
> > -Original Message-
> > From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 05, 2000 10:32 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Is there anything that ASP can do and CF cannot?
> >
> >
> > I wouldn't be so quick to dismiss the differences between "a coding point
> > of view" and "functionality".  At this stage of the process they're really
> > one and the same.  Functionality that can't be achieved though convenient
> > means is just about useless for all but the most diehard coders.  With the
> > current state of the two environment, ASP'S user defined functions rival
> > CF's simplicity in database connectivity in usefulness for anything but
> > the most trivial applications.  The nice thing about CF is that it seems
> > to be moving quickly toward those areas most sought after by it's user
> > while Microsoft continues, as always, to say "fuck you" to it's
> > developers.
> >
> > Jim
> >
> >
> > -Original Message-
> > From: Leong Yew <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> > Date: Friday, May 05, 2000 6:52 PM
> > Subject: RE: Is there anything that ASP can do and CF cannot?
> >
> >
> > >User defined functions. If only ColdFusion could have what VBScript and
> > >Javascript have. That's actually from a coding point of view rather than
> > >functionality.
> > >
> > >-Original Message-
> > >From: aslam bajaria [mailto:[EMAIL PROTECTED]]
> > >Sent: Saturday, May 06, 2000 1:32 AM
> > >To: [EMAIL PROTECTED]
> > >Subject: Is there anything that ASP can do and CF cannot?
> > >
> > >
> > >I was just wondering if there is something that cannot
> > >be done in CF and can be done in ASP? Has anyone
> > >encountered such an instance.
> > >
> > >My understanding is that Active Server Pages (ASP) are
> > >theoretically equivalent to Cold Fusion Pages but
> > >using Microsoft proprietary programming.  My guess is
> > >that we can do the same thing with Cold Fusion what we
> > >can do in ASP.It wouldn't surprise me if Microsoft has
> > >placed barriers to using other environments with its
> > >products such as MS SQL Server.
> > >
> > >Appreciate.
> > >A.B.
> >
> > --
> > 
> > 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.

Thomas J. Forbes
Forbes Web Consulting, Inc.

TEL: 407-772-3427
FAX: 407-772-3428

http://www.medmatrix.com
Medical Equipment Web Portal




--
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: ABI Hosting has great support

[Tom Forbes]

Speaking of their excellent company, I had a REAL CLOSE-UP look at the 
"New" auction package that they are trying to sell. If any of you have any 
doubts about their products or support other than their flagship "Shopping 
Cart" treat yourself to a free download of the "New Auction !! IMHO 
Have a bag handy.

Tom


At 01:05 AM 4/17/00, you wrote:
>ABI Hosting is an excellent company, I have had great results working with
>them and their customer service is second to none, quite frankly they are
>unusually professional and at the same time very reasonably priced for a
>hosting company. I intend to keep working with them for Cold Fusion
>hosting. Able Commerce on the other hand has been a different experience as
>can be gauged by the threads thus far. Someone suggested getting open
>source templates from them, will find out tomorrow if that's doable without
>forking out another $1500 which my client will not go for. Satire aside,
>hopefully we can keep this forum open to discuss the CF problem affecting
>us rather than those that interest just a few.
>
>At 12:52 AM 4/17/2000 -0400, you wrote:
>
> >All I know is ABI did my client right. I have no complaints.
> >
> >Skip
> >- 
> -
> >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: banner ad weighting....

[Tom Forbes]

Good idea ... sort of like a look-up table.

Tom


At 03:40 PM 4/13/00, you wrote:
>There may be a much simpler way:
>
>For each ad, just have 1 field that specifies what % that ad should have.
>Whenever you add / edit an ad (maybe use a trigger), have it then fill in
>(or update)  2 more fields, call it N1 and N2, with the numbers from 0 to
>100 which represent that fraction they should get.. for example:
>
>
>Ad titlePercent N1 N2
>Ad1 20  0   20
>Ad2 50  20  70
>ad3 30  70  100
>
>Now just generate a random number , R, from 0 to 100.
>Look for the ad where  R is between N1 and N2
>   I did something like that, and the ads come out remarkably close to the
>predicted frequency!
>
>Al Musella
>World Wide Websites
>
>--
>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.

Tom Forbes
Forbes Consulting
407-772-3427

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

Classified Ads Application

[Tom Forbes]

Dear CF'ers

Can anyone our there recommend an industrial strength classified ad
application, preferable written in CF?

The FusionFX one is in long term beta - I'll pass - I bought the V1
package, it never worked right, and here we are a year later, no progress
on B2 or interest in completting it for that matter.

I appreciate anything you folks may be able to recommend to me.

Tom


Thomas J. Forbes
Forbes Consulting

TEL: 407-772-3427
FAX: 407-772-3428

http://www.medmatrix.com
MedMatrix Medical Equipment Portal




--
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: HELP: banner ad weighting factors....

[Tom Forbes]

Mark  -

How about an array or look-up table. I did this successfully with a Monte 
Carlo simulation I wrote to address queing theory. Was that a dry project. 
A weighted randomly generated number would designate the probability of an 
event. Your columns can be probibility (30% = .3) and so on.

Tom


At 10:03 PM 4/12/00, you wrote:


>Hello All,
>
>I plan to offer banner ads on our Fusioneers.com web site ASAP.  I don't 
>want to use any of the canned scripts from the developer's exchange for 
>various reasons that I don't want to dwell on here.
>
>The way the banner displays are going to work is this
>
>All Fusioneers.com partners are entitled to a free banner ad on our 
>site.  People who pay a monthly fee will obviously be given a far greater 
>weighting factor than the freebies.
>
>So, our plan was to do something like the following:
>
>All freebie ads combined would account for 1% of the total weighting factor.
>
>We would then sell off weights in blocks of 10%, 20% and 30% of 
>impressions until the maximum of a 100% has been reached.  The unsold 
>weight blocks would display a "Your Ad Here" ad.
>
>So, in other words, when we display the ads, they will be called at 
>random, but I want the weights to affect their odds of being displayed.
>
>Hopefully this makes sense.  By the way, for the person who figures out 
>the best solution, we'll give you a 30% block of the 1st month's banner ad 
>weighting absolutely free as our way of saying thank you.
>
>---mark
>
>--
>Mark Warrick
>Phone: (714) 547-5386
>Efax.com Fax: (801) 730-7289
>Personal Email: [EMAIL PROTECTED]
>Personal URL: http://www.warrick.net
>Business Email: [EMAIL PROTECTED]
>Business URL: http://www.fusioneers.com
>ICQ: 346566
>--
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>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.

Thomas J. Forbes
Forbes Consulting

TEL: 407-772-3427
FAX: 407-772-3428

http://www.medmatrix.com
MedMatrix Medical Equipment Portal




--
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: banner ad weighting....

[Tom Forbes]

How about an array or look-up table. I did this successfully with a Monte 
Carlo simulation I wrote to address queing theory. Was that a dry project.

Tom




At 10:01 PM 4/12/00, you wrote:
>Hello All,
>
>I plan to offer banner ads on our Fusioneers.com web site ASAP.  I don't 
>want to use any of the canned scripts from the developer's exchange for 
>various reasons that I don't want to dwell on here.
>
>The way the banner displays are going to work is this
>
>All Fusioneers.com partners are entitled to a free banner ad on our 
>site.  People who pay a monthly fee will obviously be given a far greater 
>weighting factor than the freebies.
>
>So, our plan was to do something like the following:
>
>All freebie ads combined would account for 1% of the total weighting factor.
>
>We would then sell off weights in blocks of 10%, 20% and 30% of 
>impressions until the maximum of a 100% has been reached.  The unsold 
>weight blocks would display a "Your Ad Here" ad.
>
>So, in other words, when we display the ads, they will be called at 
>random, but I want the weights to affect their odds of being displayed.
>
>Hopefully this makes sense.  By the way, for the person who figures out 
>the best solution, we'll give you a 30% block of the 1st month's banner ad 
>weighting absolutely free as our way of saying thank you.
>
>---mark
>
>--
>Mark Warrick
>Phone: (714) 547-5386
>Efax.com Fax: (801) 730-7289
>Personal Email: [EMAIL PROTECTED]
>Personal URL: http://www.warrick.net
>Business Email: [EMAIL PROTECTED]
>Business URL: http://www.fusioneers.com
>ICQ: 346566
>--
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>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.

Thomas J. Forbes
Forbes Consulting

TEL: 407-772-3427
FAX: 407-772-3428

http://www.medmatrix.com
MedMatrix Medical Equipment Portal




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

Classified Ads Application

[Tom Forbes]

Dear CF'ers

Can anyone our there recommend an industrial strength classified ad 
application, preferable written in CF?

The FusionFX one is in long term beta - I'll pass - I bought the V1 
package, it never worked right, and here we are a year later, no progress 
on B2 or interest in completting it for that matter.

I appreciate anything you folks may be able to recommend to me.

Tom

Thomas J. Forbes
Forbes Consulting

TEL: 407-772-3427
FAX: 407-772-3428

http://www.medmatrix.com
MedMatrix Medical Equipment Portal




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

Rotating Banner Tag

[Tom Forbes]

Fellow CF'ers:

Could I please take advantage of the collective experience of you folks 
once again?

Given: I have a medical equipment portal that consists of .cfm and .htm 
templates - and they are spread out across 3 domains. 

Problem: I would like to discontinue a JavaScript banner rotating program 
that is in place, as it generates zero data and is mostly capable of random 
display and redirection. I know that there are several (many) CF tags that 
accomplish this, but I am unfamiliar with them.

Question: I would like to know which tag you would use, based on ease of 
installation, and ease of Admin. The tag would live on an NT server, and 
would need to be able to function on both .htm and .cfm templates across 3 
domains. It doesn't have to be free, and in fact, the "right one" will not 
be. I am familiar with the CF Tag Gallery, but it seems that, because I 
have a limited amount of CF ability, when I try to use some of the tags I 
am unable to get them to function properly because I can not set them up 
correctly. I need something that is ready to go, right out of the box so to 
speak.

What would you ladies and gentlemen recommend, and where do I go to get it?

Thank you very much for your time and consideration. Have a great week!

Tom

Thomas J. Forbes
Forbes Consulting

[EMAIL PROTECTED]

TOLL FREE: 877-772-3427
TEL: 407-772-3427
FAX: 407-772-3428

Webmaster of the MedMatrix Medical Equipment Portal






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