Anybody tried to connect to Outlook.Applcation Object?

[JAIME HOI]

hi
i am trying to connect to outlook object using my local CF 5.0 server. I
have also installed Microsoft Outlook application. But somehow i could not
create the object. I get this error :
 Error trying to create object specified in the tag. 
COM error 0x5. Access is denied. 

   This is the code that i am using :


 
  


   
  


What could be the reason ? 

Jaime Hoi

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Studio 5.0 beta

[Andrew Scott]

That's because the status has changed from beta!!

Regards,
Andrew Scott


-Original Message-
From: Michael Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 September 2001 2:54 PM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta

I don't see anything either... I do see a post in the forums that says
"There are currently no public betas available at this time."

Different levels of access maybe?

Mike

> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, September 13, 2001 8:16 PM
> To: CF-Talk
> Subject: RE: Cold Fusion Studio 5.0 beta
> 
> 
> Hi,
> 
> I just logged in right now, and there's TONS of beta software 
> to download.
> 
> -Brent

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BETA.ALLAIRE.COM

[Andrew Scott]

Don't laugh, I have seen this sort of stuff created in Illustrator by
very good artists. I have also seen this done in Photoshop, with a bit
done in illustrator. Any tool could have been used by any good artist!!
But my guess that for ease and $'s it would have been done in a 3D
Package, Raydream Studio, Xara, 3D Max to name a few..


Regards,
Andrew Scott


-Original Message-
From: Kevin Derby [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 September 2001 8:25 AM
To: CF-Talk
Subject: Re: BETA.ALLAIRE.COM

PHOTOSHOP BE DAMNED!!

Sorry...  :)

Kevin

- Original Message -
From: "Shawn Grover" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 2:44 PM
Subject: RE: BETA.ALLAIRE.COM


> I would guess, it's nothing more than an extruded B, with beveled
edges,
> then rotated in 3 dimensions.
>
> You would be able to use 3dMax, but you probably don't need to go to
those
> extremes.  Any application that can do the above features should be
able
to
> recreate the effect.  (Photoshop, Corel, etc.)
>
> Shawn Grover
>
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 1:59 PM
> To: CF-Talk
> Subject: RE: BETA.ALLAIRE.COM
>
>
> possibly or just a good artist using photoshop or illustrator it isnt
that
> intricate
> -Original Message-
> From: BT [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:17 PM
> To: CF-Talk
> Subject: BETA.ALLAIRE.COM
>
>
> Does anyone know what graphic program would be used to create the B
like
on
> beta.allaire.com? 3D studio Max?
>
>
>
>
>
> 

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BETA.ALLAIRE.COM

[Andrew Scott]

Also looks like Photoshop too!! Or Illustrator or Freehand and even
Paint Shop Pro could have been used.

Regards,
Andrew Scott



-Original Message-
From: Robert Forsyth [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 September 2001 6:11 AM
To: CF-Talk
Subject: RE: BETA.ALLAIRE.COM

Looks Like Xara3D

http://www.xara.com/products/xara3d/



-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:17 PM
To: CF-Talk
Subject: BETA.ALLAIRE.COM


Does anyone know what graphic program would be used to create the B like
on
beta.allaire.com? 3D studio Max?





~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Studio 5.0 beta

[Andrew Scott]

If you were a beta tester once before, you need to have your account
reactivated with a serial number. Send an email to [EMAIL PROTECTED] and
they ask for a serial number before they connect you back up.

I just logged in an saw the Studio/Homesite links, so they are still
there!!

Regards,
Andrew Scott


-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 September 2001 4:10 AM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta

Yes but right now when you login NO BETA SOFTWARE is listed, maybe they
removed it for the time being?


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: experience with cfm-resources

[Michael Wilson]

I never offered hosting... I just have my site hosted with
http://www.cosmotek.net/.

Mike

> -Original Message-
> It doesn't look like 961media does hosting any longer.
> Kevin

> > You also might want to look at http://www.cosmotek.net/. I have my 
> > site, http://www.961media.com, set up with them and have not had a 
> > problem thus far. 
~~
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: Cold Fusion Studio 5.0 beta

[Michael Wilson]

I don't see anything either... I do see a post in the forums that says
"There are currently no public betas available at this time."

Different levels of access maybe?

Mike

> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, September 13, 2001 8:16 PM
> To: CF-Talk
> Subject: RE: Cold Fusion Studio 5.0 beta
> 
> 
> Hi,
> 
> I just logged in right now, and there's TONS of beta software 
> to download.
> 
> -Brent
~~
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: experience with cfm-resources

[Kevin Derby]

Didn't read the post closely.  I'm a moron.

Have a great night.

Kevin

- Original Message -
From: "Kevin Derby" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 8:11 PM
Subject: Re: experience with cfm-resources


> It doesn't look like 961media does hosting any longer.
>
> Kevin
>
> - Original Message -
> From: "Michael Wilson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, September 13, 2001 7:36 PM
> Subject: RE: experience with cfm-resources
>
>
> > Hi,
> >
> > You also might want to look at http://www.cosmotek.net/. I have my site,
> > http://www.961media.com, set up with them and have not had a problem
> > thus far. In fact I have never spoken to anyone at the company; the sign
> > up is automated. They have an excellent control panel in place for
> > managing your space. I am in no way affiliated with them; I stumbled
> > across them by accident myself.
> >
> > Their basic package is:
> > $10.95 per month
> > $0 set up fee
> > 50 MB
> > 25 pop accounts
> > 4.0 GB transfer monthly
> > 2 DSN datasources included FREE
> > MS Access, MS SQL 7.0, MySQL and others
> >
> >
> > Pretty much everything you need for the basics.
> >
> > Good luck,
> >
> > Mike
> >
> > > As for cheap CFM hosting, try www.readyhosting.com - $99 usd
> > > / year
> > 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: experience with cfm-resources

[Kevin Derby]

It doesn't look like 961media does hosting any longer.

Kevin

- Original Message - 
From: "Michael Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 7:36 PM
Subject: RE: experience with cfm-resources


> Hi,
> 
> You also might want to look at http://www.cosmotek.net/. I have my site,
> http://www.961media.com, set up with them and have not had a problem
> thus far. In fact I have never spoken to anyone at the company; the sign
> up is automated. They have an excellent control panel in place for
> managing your space. I am in no way affiliated with them; I stumbled
> across them by accident myself.
> 
> Their basic package is:
> $10.95 per month
> $0 set up fee
> 50 MB
> 25 pop accounts
> 4.0 GB transfer monthly
> 2 DSN datasources included FREE
> MS Access, MS SQL 7.0, MySQL and others
> 
> 
> Pretty much everything you need for the basics.
> 
> Good luck,
> 
> Mike
> 
> > As for cheap CFM hosting, try www.readyhosting.com - $99 usd
> > / year
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Selecting All Categories that start with A..

[Bernd VanSkiver]

Try this:

WHERE Left(CategoryName, 1) = '#url.Letter#'

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
- Original Message -
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 11:37 AM
Subject: Selecting All Categories that start with A..


> Hey all,
>
> I got a database that has like 120 categories.
>
> The client wants A-Z along the top, and when A is clicked, only those
> categories that start with A will show.
>
> SO I'm trying to use SQL in the query, with a URL variable called Letter
> passed when the user clicks the letter nav bar.
>
> I am assuming that I can use a function such as Left() in SQL? Is there
> anything like that?
> How would I do something like this otherwise?
>
> -Gel
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: experience with cfm-resources

[Michael Wilson]

Hi,

You also might want to look at http://www.cosmotek.net/. I have my site,
http://www.961media.com, set up with them and have not had a problem
thus far. In fact I have never spoken to anyone at the company; the sign
up is automated. They have an excellent control panel in place for
managing your space. I am in no way affiliated with them; I stumbled
across them by accident myself.

Their basic package is:
$10.95 per month
$0 set up fee
50 MB
25 pop accounts
4.0 GB transfer monthly
2 DSN datasources included FREE
MS Access, MS SQL 7.0, MySQL and others


Pretty much everything you need for the basics.

Good luck,

Mike

> As for cheap CFM hosting, try www.readyhosting.com - $99 usd 
> / year 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT .NET: ActiveX in Disguise? FUD alert

[Jeffry Houser]

  Fear, Uncertainty, and doubt .


At 03:49 PM 09/13/2001 -0400, you wrote:
>What does FUD mean?
>
>-Original Message-
>From: Jon Hall [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, September 13, 2001 2:02 PM
>To: CF-Talk
>Subject: Re:OT .NET: ActiveX in Disguise? FUD alert
>
>
>Totally off topic, but as someone who likes .Net, I'll just say this is
>obvious. I myself have described .Net as a super COM object that comes
>with windows. If someone is critical of .Net as didn't know this
>already, they really dont have enough information to form any useful
>opinion. It would be an opinion based in ignorance. The article is FUD,
>plain and simple. The author doesn't even fully grasp the concept of
>what ActiveX is.
>
>jon
>
>Jackson Moore (CFTalk) wrote:
>
> >In case you haven't seen it, this article came out on Monday on
> > computerworld.com and in their newsletters.  For those of you
> > who are critical of .net and want some more material to back up
> > your position, here you go:
> >
> >http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
> >00.html
> >
> >Jackson Moore
> >[EMAIL PROTECTED]
> >
>
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Studio 5.0 beta

[Brent Goldman]

Hi,

I just logged in right now, and there's TONS of beta software to download.

-Brent

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 11:10 AM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta


Yes but right now when you login NO BETA SOFTWARE is listed, maybe they
removed it for the time being?

-Original Message-
From: William Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:16 PM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta


email [EMAIL PROTECTED]

or visit

http://beta.allaire.com

-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]]
Sent: 13 September 2001 16:57
To: CF-Talk
Subject: Cold Fusion Studio 5.0 beta


I've read posts on the CF Studio beta 5 before and I was wondering if this
is a public beta. If so, where can it be downloaded? Thanks for in advance
for any info.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF_BOOLSEARCH tag

[Parker, Kevin]

You could put the tag on Allaire's tag site so we can all but you might want
to check with the original author or acknowledge their work first.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 806 166




-Original Message-
From: Steven Monaghan [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 September 2001 1:20:AM
To: CF-Talk
Subject: RE: CF_BOOLSEARCH tag


Thanks for the help.

I did indeed find the tag.  I was looking for a file named
cf_boolsearch.cfm, not boolsearch.cfm.

Also, thanks for the link to the tag source.  I was modifying the source to
work with an Oracle database (which is case sensitive, unlike the Sql Server
db that was being used).

If anyone wants a copy of the modified tag, please let me know.

Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:41 AM
To: CF-Talk
Subject: Re: CF_BOOLSEARCH tag


Go to this URL:
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476C7-2830-11D4-AA
9700508B94F380&method=Full

Here you will find this tag as well as an explanation as to what it does.
- Original Message -
From: "Steven Monaghan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 9:26 AM
Subject: CF_BOOLSEARCH tag


> I am new to Cold Fusion have inherited an application written by outside
> consultants that is being brought in-house.  In the code I see a tag
> CF_BOOLSEARCH.  I have not installed any custom tags, so I don't think it
is
> one, yet I can't find any documentation/information on this tag.
>
> Can anyone help?
>
> Steve
> -
> Steven Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> [EMAIL PROTECTED]
> http://www.mscdirect.com
> -
>
>
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you are not the intended recipient, please do
not
> read, copy, use or disclose the contents of this communication to others.
> Please notify the sender that you have received this e-mail in error by
> replying to the e-mail.  Please then delete the e-mail and destroy any
>

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

Dashes in LDAP attributes

[Kevin Derby]

I read over the weekend (and now can't relocate the article) that you can't
have dashes in variable names in CF.  The article talked about having to
extract an Exchange Server LDAP query that used the "custom-attribute"
fields out to XML format, then remove/replace the dashes, then feed it back
to CF.

First off:
1.> Does this apply to CF5?
2.> If it does, what do the variable name(s) actually look like when they're
extracted (if they're even visible in that state)
3.> If they are visible, can I simply use them in their 'dash altered'
state.

Make sense?  Anyone else seen this article?

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Coldfusion & Advanced Queries and Output?

[Ianv2]

Hi Guys/Girls

I just have a quick query for you please, been trying to figure it out all 
week but having some problems so be very grateful if you could lend a hand 
please, just trying to come to grips with the concepts.

I have used this approach and it works well using the following query and 
output below on the downloads main menu (downloadssample.cfm) page.

---
---

SELECT DISTINCT
area
FROM Downloads





http://testpages/downloadsmore.cfm?area=#test.area";>#test.area#




Here you can download the latest drivers released 
for the Printers used in the I.T. section



  



http://testpages/downloadsmore.cfm?area=#test.area";>#test.area#



  
The latest software
drivers and patches currently available area available to
download from this area. 

  






---
---

When a link is selected they are taken to the downloadsmore.cfm page with the 
following query shown below and the cfoutput of the data, (not shown)




SELECT *
FROM downloads
WHERE area='#URL.area#'
ORDER BY dldate DESC




All this works great, however on the homepage of the site I wish to display 
the latest 5 records, I have a query that displays the latest five download 
titles on the homepage, this works great and is shown below.  




select dloadid, dltitle, dldate
from downloads
ORDER BY dldate DESC




However on the output for the query above how would I write it so that when I 
select a record it takes me straight to the downloadsmore.cfm page and 
displays that current record.

Any ideas on how to achieve this?


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate and StructCopy

[Tyson Vanek]

Thanks for that, Ray.  :)  Actually, I only threw that in because I run CF5,
but figured many people on the list might run CF4.  Good catch, nonetheless.

-Tyson

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:55 PM
To: CF-Talk
Subject: RE: Duplicate and StructCopy


> 19:   
> 20:listFirst(server.coldfusion.productversion)>
> 21:   
> 22:
> 23:   
> 24:   
> 25:   
> 26:   
> 27:   
> 28:   

An off topic comment on the code block above. Doing code like this,
where you have a code branch for CF5 and a code branch for <5, will
result in an error if you turn on strict attribute validation. We ran
across this in a Spectra template and had to move the CF5 code into an
include. Like so:




old code


Just something to watch out for.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BETA.ALLAIRE.COM

[Mark Adams]

Using COOL 3D this is easy.

-Mark

-- Original Message --
from: Shawn Grover <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Thu, 13 Sep 2001 15:44:06 -0600

>I would guess, it's nothing more than an extruded B, with beveled edges,
>then rotated in 3 dimensions.  
>
>You would be able to use 3dMax, but you probably don't need to go to those
>extremes.  Any application that can do the above features should be able to
>recreate the effect.  (Photoshop, Corel, etc.)
>
>Shawn Grover
>
>-Original Message-
>From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, September 13, 2001 1:59 PM
>To: CF-Talk
>Subject: RE: BETA.ALLAIRE.COM
>
>
>possibly or just a good artist using photoshop or illustrator it isnt that
>intricate 
>-Original Message-
>From: BT [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, September 13, 2001 2:17 PM
>To: CF-Talk
>Subject: BETA.ALLAIRE.COM
>
>
>Does anyone know what graphic program would be used to create the B like on
>beta.allaire.com? 3D studio Max?
>
>
>
>
>
>
~~
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: OT .NET: ActiveX in Disguise? FUD alert

[Rey Bango]

FUD = Fear, Uncertainty, Doubt

Rey...

- Original Message -
From: "Won Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 3:49 PM
Subject: RE: OT .NET: ActiveX in Disguise? FUD alert


> What does FUD mean?
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:02 PM
> To: CF-Talk
> Subject: Re:OT .NET: ActiveX in Disguise? FUD alert
>
>
> Totally off topic, but as someone who likes .Net, I'll just say this is
> obvious. I myself have described .Net as a super COM object that comes
> with windows. If someone is critical of .Net as didn't know this
> already, they really dont have enough information to form any useful
> opinion. It would be an opinion based in ignorance. The article is FUD,
> plain and simple. The author doesn't even fully grasp the concept of
> what ActiveX is.
>
> jon
>
> Jackson Moore (CFTalk) wrote:
>
> >In case you haven't seen it, this article came out on Monday on
> > computerworld.com and in their newsletters.  For those of you
> > who are critical of .net and want some more material to back up
> > your position, here you go:
> >
> >http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
> >00.html
> >
> >Jackson Moore
> >[EMAIL PROTECTED]
> >
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: BETA.ALLAIRE.COM

[Kevin Derby]

PHOTOSHOP BE DAMNED!!

Sorry...  :)

Kevin

- Original Message -
From: "Shawn Grover" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 2:44 PM
Subject: RE: BETA.ALLAIRE.COM


> I would guess, it's nothing more than an extruded B, with beveled edges,
> then rotated in 3 dimensions.
>
> You would be able to use 3dMax, but you probably don't need to go to those
> extremes.  Any application that can do the above features should be able
to
> recreate the effect.  (Photoshop, Corel, etc.)
>
> Shawn Grover
>
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 1:59 PM
> To: CF-Talk
> Subject: RE: BETA.ALLAIRE.COM
>
>
> possibly or just a good artist using photoshop or illustrator it isnt that
> intricate
> -Original Message-
> From: BT [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:17 PM
> To: CF-Talk
> Subject: BETA.ALLAIRE.COM
>
>
> Does anyone know what graphic program would be used to create the B like
on
> beta.allaire.com? 3D studio Max?
>
>
>
>
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT .NET: ActiveX in Disguise? FUD alert

[Billy Cravens]

I think you'll agree that doesn't make it right.

---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 13, 2001 3:58 PM
To: CF-Talk
Subject: RE: OT .NET: ActiveX in Disguise? FUD alert


Fear Uncertainty and Doubt.

FUB is usually false or misleading information to create those three
things in the reader about the subject.  Microsoft sowed a lot of this
about a number of products.  It looks like it is reaping time.

> -Original Message-
> From: Won Lee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:49 PM
> To: CF-Talk
> Subject: RE: OT .NET: ActiveX in Disguise? FUD alert
>
>
> What does FUD mean?
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:02 PM
> To: CF-Talk
> Subject: Re:OT .NET: ActiveX in Disguise? FUD alert
>
>
> Totally off topic, but as someone who likes .Net, I'll just say this 
> is obvious. I myself have described .Net as a super COM object that 
> comes with windows. If someone is critical of .Net as didn't know this

> already, they really dont have enough information to form any useful 
> opinion. It would be an opinion based in ignorance. The article is 
> FUD, plain and simple. The author doesn't even fully grasp the concept

> of what ActiveX is.
>
> jon
>
> Jackson Moore (CFTalk) wrote:
>
> >In case you haven't seen it, this article came out on Monday on  
> >computerworld.com and in their newsletters.  For those of you  who 
> >are critical of .net and want some more material to back up  your 
> >position, here you go:
> >
> >http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
> >00.html
> >
> >Jackson Moore
> >[EMAIL PROTECTED]
> >
>
> 

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BETA.ALLAIRE.COM

[Shawn Grover]

I would guess, it's nothing more than an extruded B, with beveled edges,
then rotated in 3 dimensions.  

You would be able to use 3dMax, but you probably don't need to go to those
extremes.  Any application that can do the above features should be able to
recreate the effect.  (Photoshop, Corel, etc.)

Shawn Grover

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:59 PM
To: CF-Talk
Subject: RE: BETA.ALLAIRE.COM


possibly or just a good artist using photoshop or illustrator it isnt that
intricate 
-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:17 PM
To: CF-Talk
Subject: BETA.ALLAIRE.COM


Does anyone know what graphic program would be used to create the B like on
beta.allaire.com? 3D studio Max?





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

[Kwang Suh]

Not possible using the CF grid.

You could extend that applet though so that it could
do this.

Or, you could write something in DHTML that does the
same thing as the grid.  This is quite an undertaking,
however.

--- "Jones, Becky" <[EMAIL PROTECTED]>
wrote:
> does anyone know if the fields in the cf grid can be
> "moved"?
> like if say i had the columns like:
> Cat   Dog Mouse
> can i put mouse before dog to look like
> Cat   Mouse   Dog
> or is this another scripting language that i would
> need to use?
> thanks so much,
> bec.
> 
> 
> *
> This e-mail, including any attachments, is intended
> for the 
> receipt and use by the intended addressee(s), and
> may contain 
> confidential and privileged information.  If you are
> not an intended 
> recipient of this e-mail, you are hereby notified
> that any unauthorized 
> use or distribution of this e-mail is strictly
> prohibited. 
> 
> 
~~
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: OT .NET: ActiveX in Disguise? FUD alert

[Ron Hornbaker]

http://www.acronymfinder.com/af-query.asp?Acronym=FUD

Hit #1 in this context: Fear, Uncertainty and Doubt. (Female Urinary
Device was a close second.)


Ron Hornbaker
President/CTO
  .  .  .  .  .  .  .  .  .  .  .  .  http://humankindsystems.com
  .  .  .  .  .  .  .  .  .  .  .  .  w e  c o d e.  w e  c a r e.


> -Original Message-
> From: Won Lee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:49 PM
> To: CF-Talk
> Subject: RE: OT .NET: ActiveX in Disguise? FUD alert
>
>
> What does FUD mean?
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:02 PM
> To: CF-Talk
> Subject: Re:OT .NET: ActiveX in Disguise? FUD alert
>
>
> Totally off topic, but as someone who likes .Net, I'll just say this is
> obvious. I myself have described .Net as a super COM object that comes
> with windows. If someone is critical of .Net as didn't know this
> already, they really dont have enough information to form any useful
> opinion. It would be an opinion based in ignorance. The article is FUD,
> plain and simple. The author doesn't even fully grasp the concept of
> what ActiveX is.
>
> jon
>
> Jackson Moore (CFTalk) wrote:
>
> >In case you haven't seen it, this article came out on Monday on
> > computerworld.com and in their newsletters.  For those of you
> > who are critical of .net and want some more material to back up
> > your position, here you go:
> >
> >http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
> >00.html
> >
> >Jackson Moore
> >[EMAIL PROTECTED]
> >
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: experience with cfm-resources

[Shawn Grover]

It took almost six months before I had any sort of notification that my
account was active at cfm-resources.  So I never bothered uploading my site
there.  On the otherhand, I've been getting lots of emails from them and
their affiliates lately (3 or 4 times a month).

As for cheap CFM hosting, try www.readyhosting.com - $99 usd / year for 500
meg of storage, with CF 4.5.2 support.  They have been good in the past,
although in the last week or so I did not get a reply to a question I posted
regarding their support for CF5.  And sometimes their server is a little
slow to respond to page requests.  Otherwise, I've had little trouble with
them. I only have one site there at the moment though, which is dynamic, but
not complex.  So don't know if this would be a fair assessment.

Shawn Grover


-Original Message-
From: cf refactoring [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 6:38 AM
To: CF-Talk
Subject: experience with cfm-resources


Has anyone had any experience with cfm-resources.com's
free or low-cost accounts? I tried to register but am
having problems and getting no email responses.

Or, can anyone recommend some cf hosting at less than
$30 a month?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer

~~
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: OT .NET: ActiveX in Disguise? FUD alert

[Jon Hall]

http://www.google.com/search?q=fud

Won Lee wrote:

>What does FUD mean?
>
>-Original Message-
>

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Updgrading to CF 5?

[Ian Lurie]

Has anyone experienced problems going from CF 5 from 4.5? We've got a server
with about 40 sites, and I'd hate to have to debug them all...

Portent Interactive
http://www.portentinteractive.com
Combining process, design, content to create great web sites since 1995
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Left Outer Join Question

[Kamie Curfman]

The LEFT JOIN didn't change anything.  Thanks for the help, though.  And
thanks to cfrefactoring.  I was hoping to not have to break it up into
individual queries, but if that's what I have to do, that's what I have to
do.  Thank you!

Kamie

Mark Stewart wrote:

> Have you tried just a LEFT JOIN?
>
> -Original Message-
> From: Kamie Curfman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:19 PM
> To: CF-Talk
> Subject: Left Outer Join Question
>
> I know this is more SQL than CF, but this list is so responsive...
>
> I'm trying to do a query that counts how many times a particular company
> showed up in the search results log table, how many times its URL was
> clicked on, etc.  So, I'm left outer joining all the log tables, on the
> chance that the company wasn't returned in any of the searches, its URL
> was never clicked on, etc.  I thought the below logic was sound, but
> instead of getting "14" for search_count, "4" for enhanced_count, "1"
> for click_through_count, and "1" for contact_me_count, I'm getting "56"
> for all.  In other words, 14*4*1*1.  Why is this happening?  Why aren't
> I getting separate counts for each?
>
> Here is the query.  Thank you so much in advance.
>
> 
>SELECT c.company, COUNT(srl.company_id) AS search_count,
> COUNT(el.company_id) AS enhanced_count, COUNT(ctl.company_id) AS
> click_through_count, COUNT(cfl.company_id) AS contact_me_count
>FROM dbo.Companies c
>   LEFT OUTER JOIN dbo.Search_Results_Log srl ON
> (c.company_id=srl.company_id)
>   LEFT OUTER JOIN dbo.Enhanced_Log el ON
> (c.company_id=el.company_id)
>   LEFT OUTER JOIN dbo.Click_Through_Log ctl ON
> (c.company_id=ctl.company_id)
>   LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON
> (c.company_id=cfl.company_id)
>WHERE c.company_id= value="#attributes.report_company#"
> cfsqltype="cf_sql_integer">
>GROUP BY company
>  
>
> Kamie
>
> --
> Kamie B. Curfman
> Matrix Group International, Inc.
> 801 N. Fairfax Street, Suite 205
> Alexandria, VA 22314
> Phone: (703) 838-9777 x3014
> Fax: (703) 838-9799
> [EMAIL PROTECTED]
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT .NET: ActiveX in Disguise? FUD alert

[Tony Schreiber]

Fear, Uncertainty and Doubt. Usually a Microsoft tactic...

> What does FUD mean?
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:02 PM
> To: CF-Talk
> Subject: Re:OT .NET: ActiveX in Disguise? FUD alert
>
>
> Totally off topic, but as someone who likes .Net, I'll just say this is
> obvious. I myself have described .Net as a super COM object that comes
> with windows. If someone is critical of .Net as didn't know this
> already, they really dont have enough information to form any useful
> opinion. It would be an opinion based in ignorance. The article is FUD,
> plain and simple. The author doesn't even fully grasp the concept of
> what ActiveX is.
>
> jon
>
> Jackson Moore (CFTalk) wrote:
>
> >In case you haven't seen it, this article came out on Monday on
> > computerworld.com and in their newsletters.  For those of you
> > who are critical of .net and want some more material to back up
> > your position, here you go:
> >
> >http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
> >00.html
> >
> >Jackson Moore
> >[EMAIL PROTECTED]
> >
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT .NET: ActiveX in Disguise? FUD alert

[Russel Madere]

Fear Uncertainty and Doubt.

FUB is usually false or misleading information to create those three things
in the reader about the subject.  Microsoft sowed a lot of this about a
number of products.  It looks like it is reaping time.

> -Original Message-
> From: Won Lee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:49 PM
> To: CF-Talk
> Subject: RE: OT .NET: ActiveX in Disguise? FUD alert
>
>
> What does FUD mean?
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 2:02 PM
> To: CF-Talk
> Subject: Re:OT .NET: ActiveX in Disguise? FUD alert
>
>
> Totally off topic, but as someone who likes .Net, I'll just say this is
> obvious. I myself have described .Net as a super COM object that comes
> with windows. If someone is critical of .Net as didn't know this
> already, they really dont have enough information to form any useful
> opinion. It would be an opinion based in ignorance. The article is FUD,
> plain and simple. The author doesn't even fully grasp the concept of
> what ActiveX is.
>
> jon
>
> Jackson Moore (CFTalk) wrote:
>
> >In case you haven't seen it, this article came out on Monday on
> > computerworld.com and in their newsletters.  For those of you
> > who are critical of .net and want some more material to back up
> > your position, here you go:
> >
> >http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
> >00.html
> >
> >Jackson Moore
> >[EMAIL PROTECTED]
> >
>
> 
~~
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

Required with meran (odbc) on oracle8i/solaris/cf4.5

[saro]

I encountered problem with merant drivers (odbc) for
oracle 8i on solaris.scenario is as follows

I have development,test,backup databases before moving
to my production.
Once my development freezes and i start moving tables
to test(before that i shall move test db to backup db)
I use Select * from ALL_TABLES where table_name='table
i indent to move to test db'
>if record exists then i execute "drop table ,create
table queries"
>If record doesn't exists then use "create table
queries"

The Problem i encounter is when i query the ALL_TABLES
for table name i am getting record count as 0(but in
real table exists)
So my create table queries fail.

I encounter this not often but 1 outof 10.
 
Saro


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Capitalize first characters

[thanh . nguyen]

Thanks all.

I got it.

:)

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 11:21 AM
To: CF-Talk
Subject: RE: Capitalize first characters




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:21 PM
To: CF-Talk
Subject: Capitalize first characters


Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?  
 
Thanks



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BETA.ALLAIRE.COM

[Robert Forsyth]

Looks Like Xara3D

http://www.xara.com/products/xara3d/



-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:17 PM
To: CF-Talk
Subject: BETA.ALLAIRE.COM


Does anyone know what graphic program would be used to create the B like on
beta.allaire.com? 3D studio Max?




~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

The Pledge of Allegiance by Red Skelton

[James Lathem]

Hi gang,

I know some of you don’t know me but I found something and wanted to share
with you.

First, I remember from a long time ago hearing Red Skelton tell a story
about learning “The Pledge Of Allegiance” and remember it was very touching
to hear him tell the story. Recently (a couple of years ago) just after his
death Kim Peterson ( http://www.kimmer.net  ) played
it on the air. I visited his site last night and he had it posted. If you
haven’t heard Mr. Skelton tell the story it is well worth your time to visit
the site and listen. Here is a hyperlink for those getting their email in an
html format.

The Pledge of Allegiance by Red Skelton


You should be able to download the mp3 file from the site above or you may
contact me and I will put it in a zip file and put it out somewhere for you
to download it.


Your friend,
Your fellow CF’er,
Your fellow American,
James



Regards,
James Lathem
Web Developer and
Certified Allaire ColdFusion Developer 

McRae Communications 
Office: 770.460.7277 Ext. 227
Fax: 770.460.0963

We judge ourselves by
what we feel capable of doing...

While others judge us by
what we have already done.
Unknown


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: BETA.ALLAIRE.COM

[Kelly Matthews]

possibly or just a good artist using photoshop or illustrator it isnt that
intricate 
-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:17 PM
To: CF-Talk
Subject: BETA.ALLAIRE.COM


Does anyone know what graphic program would be used to create the B like on
beta.allaire.com? 3D studio Max?




~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Capitalize first characters

[Joshua Miller]

I believe there's a UDF on www.cflib.org that does just that.

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[EMAIL PROTECTED]

-Original Message-
From: Baskin, Dave [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:12 PM
To: CF-Talk
Subject: RE: Capitalize first characters


There's an example in an article that discusses User Defined Functions that
does just what you want. You can find the article at
http://www.sys-con.com/coldfusion/articleprint.cfm?id=270. HTH.

d



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:21 AM
To: CF-Talk
Subject: Capitalize first characters


Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?

Thanks



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: REGEX to strip special characters

[Joshua Miller]

Help and humor ... thanks Raymond. As you proabably understand ... by
special I meant punctuation that normally wreaks havoc on data that is
supposed to be either numeric or text without !@#$%^&*()_+=-,.<>/?'";:`~

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[EMAIL PROTECTED]

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:18 PM
To: CF-Talk
Subject: RE: REGEX to strip special characters


What do you mean by special? I think R is special, but that's just me.
;)

Here are some regex char classes that might meet what you need:

Character Class Matches
alpha
 Matches any letter. Same as [A-Za-z].

upper
 Matches any uppercase letter. Same as [A-Z].

lower
 Matches any lowercase letter. Same as [a-z].

digit
 Matches any digit. Same as [0-9].

alnum
 Matches any alphanumeric character. Same as [A-Za-z0-9].

xdigit
 Matches any hexadecimal digit. Same as [0-9A-Fa-f].

space
 Matches a tab, new line, vertical tab, form feed, carriage return, or
space.

print
 Matches any printable character.

punct
 Matches any punctuation character, that is, one of ! ' # S % & ` ( ) *
+ , - . / : ; < = > ? @ [ / ] ^ _ { | } ~

graph
 Matches any of the characters defined as a printable character except
those defined as part of the space character class.

cntrl
 Matches any character not part of the character classes [:upper:],
[:lower:], [:alpha:], [:digit:], [:punct:], [:graph:], [:print:], or
[:xdigit:].


===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -Original Message-
> From: Joshua Miller [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 1:32 PM
> To: CF-Talk
> Subject: REGEX to strip special characters
>
>
> Anyone know of a REGEX to strip special characters from a string?
>

~~
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: OT .NET: ActiveX in Disguise? FUD alert

[Won Lee]

What does FUD mean?

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:02 PM
To: CF-Talk
Subject: Re:OT .NET: ActiveX in Disguise? FUD alert


Totally off topic, but as someone who likes .Net, I'll just say this is
obvious. I myself have described .Net as a super COM object that comes
with windows. If someone is critical of .Net as didn't know this
already, they really dont have enough information to form any useful
opinion. It would be an opinion based in ignorance. The article is FUD,
plain and simple. The author doesn't even fully grasp the concept of
what ActiveX is.

jon

Jackson Moore (CFTalk) wrote:

>In case you haven't seen it, this article came out on Monday on
> computerworld.com and in their newsletters.  For those of you
> who are critical of .net and want some more material to back up
> your position, here you go:
>
>http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
>00.html
>
>Jackson Moore
>[EMAIL PROTECTED]
>

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Capitalize first characters

[Don Vawter]

You can easily do this using a style tag:

 .cap{
  text-transform : capitalize;
 }


and then use blah blah


Don Vawter
www.cyberroomies.com
[EMAIL PROTECTED]

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 11:20 AM
Subject: Capitalize first characters


> Hi all, I'm just starting to learn coldfusion and I'm looking for a
function
> or a way to capitalize the first character of words in a string.  Can this
> be done?  Can someone help me with this?
>
> Thanks
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Cold Fusion Studio 5.0 beta

[tom muck]

You have to email the beta address, ask to be on the beta, and give your
serial number from ColdFusion studio 4.5.   You may also be too late, as it
was announced here months ago.

tom

"Kelly Matthews" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Yes but right now when you login NO BETA SOFTWARE is listed, maybe they
> removed it for the time being?


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Studio 5.0 beta

[Garza, Jeff]

I just logged in and the software was there.  I think that they have
different levels of participation.  If you participated in the CF5 Server or
JRun betas I don't think you automatically qualified for the Studio Betas.
You'll need to send a message to [EMAIL PROTECTED] and let them know your
userID so they can add you to the list.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 13, 2001 11:10 AM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta


Yes but right now when you login NO BETA SOFTWARE is listed, maybe they
removed it for the time being?

-Original Message-
From: William Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:16 PM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta


email [EMAIL PROTECTED]

or visit

http://beta.allaire.com

-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]]
Sent: 13 September 2001 16:57
To: CF-Talk
Subject: Cold Fusion Studio 5.0 beta


I've read posts on the CF Studio beta 5 before and I was wondering if this
is a public beta. If so, where can it be downloaded? Thanks for in advance
for any info.




~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: REGEX to strip special characters

[Dick Applebaum]

try

   x=ReReplaceNoCase(x, "[^a-z0-9]", "", "All">

hth

dick

At 1:32 PM -0400 9/13/01, Joshua Miller wrote:
>Anyone know of a REGEX to strip special characters from a string?
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

FW: CF-Linux FAQ

[Jesse Noller]

Jesse Noller
Macromedia Server Development
[EMAIL PROTECTED]

"Yes, I was in Finckle's room. It's quite pleasant if you're Hannibal
Lector."
-Ace Venture, Pet detective



-Original Message-
From: Jesse Noller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:35 PM
To: CF-Linux
Subject: CF-Linux FAQ


Hey all-


I'm once again asking for your help, I'm compiling a list of common
questions that face cf-linux users. Please forward me those questions you
feel should be in an easy to find FAQ, and I'll include them. 

Heh, and if you have the answers, send those to me too!


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Left Outer Join Question

[Mark Stewart]

Have you tried just a LEFT JOIN?

-Original Message-
From: Kamie Curfman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:19 PM
To: CF-Talk
Subject: Left Outer Join Question


I know this is more SQL than CF, but this list is so responsive...

I'm trying to do a query that counts how many times a particular company
showed up in the search results log table, how many times its URL was
clicked on, etc.  So, I'm left outer joining all the log tables, on the
chance that the company wasn't returned in any of the searches, its URL
was never clicked on, etc.  I thought the below logic was sound, but
instead of getting "14" for search_count, "4" for enhanced_count, "1"
for click_through_count, and "1" for contact_me_count, I'm getting "56"
for all.  In other words, 14*4*1*1.  Why is this happening?  Why aren't
I getting separate counts for each?

Here is the query.  Thank you so much in advance.


   SELECT c.company, COUNT(srl.company_id) AS search_count,
COUNT(el.company_id) AS enhanced_count, COUNT(ctl.company_id) AS
click_through_count, COUNT(cfl.company_id) AS contact_me_count
   FROM dbo.Companies c
  LEFT OUTER JOIN dbo.Search_Results_Log srl ON
(c.company_id=srl.company_id)
  LEFT OUTER JOIN dbo.Enhanced_Log el ON
(c.company_id=el.company_id)
  LEFT OUTER JOIN dbo.Click_Through_Log ctl ON
(c.company_id=ctl.company_id)
  LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON
(c.company_id=cfl.company_id)
   WHERE c.company_id=
   GROUP BY company
 

Kamie

--
Kamie B. Curfman
Matrix Group International, Inc.
801 N. Fairfax Street, Suite 205
Alexandria, VA 22314
Phone: (703) 838-9777 x3014
Fax: (703) 838-9799
[EMAIL PROTECTED]


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Code Snippet RE: Selecting All Categories that start with A..

[Angel Stewart]

*another embarressed look*

I..figured it out. Left worked fine..I just thought that might be quicker
than Like A%..

But..I had a ; somewhere in the SQL that was preventing it from reading any
further, hence throwing an error.
*shakes head*
Darn...

But thanks guys..oh and if anyone wants to know, here is the code I wrote.
This will give you letters from A to Z along the top that would display the
appropriate categories.

This is very simple code, however I thought it might just help someone.

-Gel




SELECT DISTINCT .Classification
FROM 
Where Left(.Classification,1) = '#Letter#';





SELECT DISTINCT .Classification
FROM x;








Show Category List





  Enter the keywords you wish to search for here.
You may search for Names (First Name,Last Name), Company Names, Zip
Codes,
Categories,Address Or State.


Keywords:

  
  


  



[ A]
[ B]
[ C]
[ D]
[ E]
[ F]
[ G]
[ H]
[ I]
[ J]
[ K]
[ L]
[ M ]
[ N]
[ O]
[ P]
[ Q]
[ R]
[ S]
[ T]
[ U]
[ V]
[ W]
[ X]
[ Y]
[ Z]
[ ALL]



http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Left Outer Join Question

[cf refactoring]

Kamie,

You'll need four separate queries for this.

When you JOIN(c.company_id=srl.company_id) and SELECT 
Count(srl.company_id), you get a count of all the srl
matches with a certain company id.

When you JOIN(c.company_id=srl.company_id) AND JOIN
(c.company_id=el.company_id), you get all the srl
matches, and then FOR EACH OF THOSE MATCHES, you also
get all el matches with the company id. Hence there's
a multiplier effect.

--- Kamie Curfman <[EMAIL PROTECTED]> wrote:
> I know this is more SQL than CF, but this list is so
> responsive...
> 
> I'm trying to do a query that counts how many times
> a particular company
> showed up in the search results log table, how many
> times its URL was
> clicked on, etc.  So, I'm left outer joining all the
> log tables, on the
> chance that the company wasn't returned in any of
> the searches, its URL
> was never clicked on, etc.  I thought the below
> logic was sound, but
> instead of getting "14" for search_count, "4" for
> enhanced_count, "1"
> for click_through_count, and "1" for
> contact_me_count, I'm getting "56"
> for all.  In other words, 14*4*1*1.  Why is this
> happening?  Why aren't
> I getting separate counts for each?
> 
> Here is the query.  Thank you so much in advance.
> 
>  name="get_company">
>SELECT c.company, COUNT(srl.company_id) AS
> search_count,
> COUNT(el.company_id) AS enhanced_count,
> COUNT(ctl.company_id) AS
> click_through_count, COUNT(cfl.company_id) AS
> contact_me_count
>FROM dbo.Companies c
>   LEFT OUTER JOIN dbo.Search_Results_Log srl ON
> (c.company_id=srl.company_id)
>   LEFT OUTER JOIN dbo.Enhanced_Log el ON
> (c.company_id=el.company_id)
>   LEFT OUTER JOIN dbo.Click_Through_Log ctl ON
> (c.company_id=ctl.company_id)
>   LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON
> (c.company_id=cfl.company_id)
>WHERE c.company_id= value="#attributes.report_company#"
> cfsqltype="cf_sql_integer">
>GROUP BY company
>  
> 
> Kamie
> 
> --
> Kamie B. Curfman
> Matrix Group International, Inc.
> 801 N. Fairfax Street, Suite 205
> Alexandria, VA 22314
> Phone: (703) 838-9777 x3014
> Fax: (703) 838-9799
> [EMAIL PROTECTED]
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Selecting All Categories that start with A..

[Paul Sizemore]

Kickin' a new flavor in your ear -
Anyone know the best way (Offhand, I vote the DISTINCT).


SELECT
FROM YourTable
Where lastname MATCHES '#url.letter#*'


Paul Sizemore

Finish Line
3308 N Mitthoeffer Rd
Indianapolis, IN 46235
W: 317-899-1022 ext 3516

-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:49 PM
To: CF-Talk
Subject: Re: Selecting All Categories that start with A..


  SELECT
DISTINCT Left(FieldName,1) as Ltr
  FROM YourTable


> I am assuming that I can use a function such as Left() in SQL? Is there
> anything like that?
> How would I do something like this otherwise?
>
> -Gel
>

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

grids

[Jones, Becky]

does anyone know if the fields in the cf grid can be "moved"?
like if say i had the columns like:
Cat Dog Mouse
can i put mouse before dog to look like
Cat Mouse   Dog
or is this another scripting language that i would need to use?
thanks so much,
bec.


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited. 

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFOBJECT ERROR

[Mark Stewart]

I ran into this same error today. The problem with my situation was that
I made a typo for the class="" attribute. I haven't worked with 
outlook
through com before so I don't know what class is correct, but I would
double check to make sure you've specified the correct class.

Mark

-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 3:07 AM
To: CF-Talk
Subject: CFOBJECT ERROR


hi 
I am using CFOBJECT to connect to OUTLOOK.APPLICATION. And i
encountered
this error below :

Error trying to create object specified in the tag. 
COM error 0x800401F3. Invalid class string 
 Anybody knows what could be the problem ?? i am running Windows2000



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Cold Fusion Studio 5.0 beta

[Jeffry Houser]

   beta.allaire.com
   You may have to ask for an account / permission but I think it is open 
to anyone who has a registered version of a previous version of CF 
Studio.  Bring on the Macromedia lawyers.

At 11:56 AM 09/13/2001 -0400, you wrote:
>I've read posts on the CF Studio beta 5 before and I was wondering if this
>is a public beta. If so, where can it be downloaded? Thanks for in advance
>for any info.
>
>
~~
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: Capitalize first characters

[Ronald-Thomas]

Check here... they have some nifty functions that should help you get
started

http://www.cflib.org/library.cfm?ID=1

ronald-thomas
w: wildminds.net
c: 512.426.4233

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:21 PM
To: CF-Talk
Subject: Capitalize first characters

Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?

Thanks


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

BETA.ALLAIRE.COM

[BT]

Does anyone know what graphic program would be used to create the B like on
beta.allaire.com? 3D studio Max?



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Capitalize first characters

[Alex Santantonio]

#UCase(Left(word, 1))##Right(word, Len(word) - 1)# - this will capitalize
the first letter and leave the rest the same.  Add an LCase() around the
second CF Variable to lower case those letters.

Alex Santantonio
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED] 
www.doceus.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:21 PM
To: CF-Talk
Subject: Capitalize first characters

Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this? 

Thanks


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Capitalize first characters

[Adkins, Randy]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:21 PM
To: CF-Talk
Subject: Capitalize first characters


Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?  
 
Thanks


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: E-Commerce...?

[Newsome, Scott]

Ian,

Have you looked at what Market Matrix has to offer. 

 

> Scott Newsome, Senior System Analyst
> Chiron Corporation - Seattle
> 206.505.6931
> 


-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 9:29 AM
To: CF-Talk
Subject: E-Commerce...?


I know this has been asked before, but here goes: Anyone out there know a
good e-commerce product, preferably easily customized, that can handle a
fairly large store (500-1000 products)?

Thanks,

Ian

Portent Interactive
http://www.portentinteractive.com
Combining process, design, content to create great web sites since 1995

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ATSwebnet

[stas]

Robert got in touch with me, and everything seems to be working fine.

I was simply trying to get a hold of him as I didn't get a reply to my
inquiry, and I could not find the phone number on ATSWEBNET's site.

Thanks.

- Original Message -
From: "Gary P. McNeel, Jr." <[EMAIL PROTECTED]>


I concur. I have five sites running at ATSWEBNET, two heavily dependant on
SQL Server with no problems except periodic spots (and they are sometimes
SWBell burps).

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> I am always available via Email and have had no reports of
> problems on your
> server.  Also no one has reported any problems connecting the SQL
> database.
> I am connected now and everyday as well.  Also the site I have
> recorded for
> you is up and has not been down other then the registry problem, but only
> affected 1 function not the whole server.


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Left Outer Join Question

[Kamie Curfman]

I know this is more SQL than CF, but this list is so responsive...

I'm trying to do a query that counts how many times a particular company
showed up in the search results log table, how many times its URL was
clicked on, etc.  So, I'm left outer joining all the log tables, on the
chance that the company wasn't returned in any of the searches, its URL
was never clicked on, etc.  I thought the below logic was sound, but
instead of getting "14" for search_count, "4" for enhanced_count, "1"
for click_through_count, and "1" for contact_me_count, I'm getting "56"
for all.  In other words, 14*4*1*1.  Why is this happening?  Why aren't
I getting separate counts for each?

Here is the query.  Thank you so much in advance.


   SELECT c.company, COUNT(srl.company_id) AS search_count,
COUNT(el.company_id) AS enhanced_count, COUNT(ctl.company_id) AS
click_through_count, COUNT(cfl.company_id) AS contact_me_count
   FROM dbo.Companies c
  LEFT OUTER JOIN dbo.Search_Results_Log srl ON
(c.company_id=srl.company_id)
  LEFT OUTER JOIN dbo.Enhanced_Log el ON
(c.company_id=el.company_id)
  LEFT OUTER JOIN dbo.Click_Through_Log ctl ON
(c.company_id=ctl.company_id)
  LEFT OUTER JOIN dbo.Contact_Form_Log cfl ON
(c.company_id=cfl.company_id)
   WHERE c.company_id=
   GROUP BY company
 

Kamie

--
Kamie B. Curfman
Matrix Group International, Inc.
801 N. Fairfax Street, Suite 205
Alexandria, VA 22314
Phone: (703) 838-9777 x3014
Fax: (703) 838-9799
[EMAIL PROTECTED]

~~
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: REGEX to strip special characters

[Raymond Camden]

What do you mean by special? I think R is special, but that's just me.
;)

Here are some regex char classes that might meet what you need:

Character Class Matches 
alpha
 Matches any letter. Same as [A-Za-z].
 
upper
 Matches any uppercase letter. Same as [A-Z].
 
lower
 Matches any lowercase letter. Same as [a-z].
 
digit
 Matches any digit. Same as [0-9].
 
alnum
 Matches any alphanumeric character. Same as [A-Za-z0-9].
 
xdigit
 Matches any hexadecimal digit. Same as [0-9A-Fa-f].
 
space
 Matches a tab, new line, vertical tab, form feed, carriage return, or
space.
 
print
 Matches any printable character.
 
punct
 Matches any punctuation character, that is, one of ! ' # S % & ` ( ) *
+ , - . / : ; < = > ? @ [ / ] ^ _ { | } ~
 
graph
 Matches any of the characters defined as a printable character except
those defined as part of the space character class.
 
cntrl
 Matches any character not part of the character classes [:upper:],
[:lower:], [:alpha:], [:digit:], [:punct:], [:graph:], [:print:], or
[:xdigit:].
 

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, September 13, 2001 1:32 PM
> To: CF-Talk
> Subject: REGEX to strip special characters
> 
> 
> Anyone know of a REGEX to strip special characters from a string?
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Capitalize first characters

[Baskin, Dave]

There's an example in an article that discusses User Defined Functions that
does just what you want. You can find the article at
http://www.sys-con.com/coldfusion/articleprint.cfm?id=270. HTH.

d

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:21 AM
To: CF-Talk
Subject: Capitalize first characters


Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?  
 
Thanks


~~
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: Capitalize first characters

[Kelly Matthews]

there are custom tags on allaire's website that can do this go check out the
developers section.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:21 PM
To: CF-Talk
Subject: Capitalize first characters


Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?  
 
Thanks


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Studio 5.0 beta

[Kelly Matthews]

Yes but right now when you login NO BETA SOFTWARE is listed, maybe they
removed it for the time being?

-Original Message-
From: William Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:16 PM
To: CF-Talk
Subject: RE: Cold Fusion Studio 5.0 beta


email [EMAIL PROTECTED]

or visit

http://beta.allaire.com

-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]]
Sent: 13 September 2001 16:57
To: CF-Talk
Subject: Cold Fusion Studio 5.0 beta


I've read posts on the CF Studio beta 5 before and I was wondering if this
is a public beta. If so, where can it be downloaded? Thanks for in advance
for any info.



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:OT .NET: ActiveX in Disguise? FUD alert

[Jon Hall]

Totally off topic, but as someone who likes .Net, I'll just say this is 
obvious. I myself have described .Net as a super COM object that comes 
with windows. If someone is critical of .Net as didn't know this 
already, they really dont have enough information to form any useful 
opinion. It would be an opinion based in ignorance. The article is FUD, 
plain and simple. The author doesn't even fully grasp the concept of 
what ActiveX is.

jon

Jackson Moore (CFTalk) wrote:

>In case you haven't seen it, this article came out on Monday on
> computerworld.com and in their newsletters.  For those of you
> who are critical of .net and want some more material to back up
> your position, here you go:
>
>http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
>00.html
>
>Jackson Moore
>[EMAIL PROTECTED]
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Selecting All Categories that start with A..

[Craig Fisher]

Angel:

As I remember there is a left().

But you don't need it.

The SQl below should do you fine (replace the stuff in []'s with
the appropriate info):

Select [FIELDS]
FROM [TABLE]
WHERE [CategoryName] LIKE '#URL.Letter#%'

I'd also suggest a clustered index on the [CategoryName] field.

HTH

Craig Fisher
Macromedia Certified Instructor
Macromedia Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
801-791-8251

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:37 AM
To: CF-Talk
Subject: Selecting All Categories that start with A..


Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Selecting All Categories that start with A..

[Mark Stewart]

If I'm understanding you correctly, you could use the following in your
where clause of your sql statement

sql server syntax:

where substring(fieldname,1,1) = 'A'

HTH,
Mark

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that start with A..


Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel

~~
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: List trimming last line of posts ?

[Mark Stewart]

I had that happen to me this morning on cf-community. The solution - I
hit the enter key at the end of my post a few times to add some space.

Mark



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 8:17 AM
To: CF-Talk
Subject: List trimming last line of posts ?


Is it me or are the last lines being choped off ? Counting down to 1...
3
2

~~
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: Selecting All Categories that start with A..

[Russel Madere]

In TSQL (The MS version of SQL) there is the command LEFT().  you could also
do:

SELECT .
WHERE FieldName LIKE 'A%' 

Russel

> -Original Message-
> From: Angel Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 11:37 AM
> To: CF-Talk
> Subject: Selecting All Categories that start with A..
>
>
> Hey all,
>
> I got a database that has like 120 categories.
>
> The client wants A-Z along the top, and when A is clicked, only those
> categories that start with A will show.
>
> SO I'm trying to use SQL in the query, with a URL variable called Letter
> passed when the user clicks the letter nav bar.
>
> I am assuming that I can use a function such as Left() in SQL? Is there
> anything like that?
> How would I do something like this otherwise?
>
> -Gel
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate and StructCopy

[Raymond Camden]

> 19:   
> 20:listFirst(server.coldfusion.productversion)>
> 21:   
> 22:
> 23:   
> 24:   
> 25:   
> 26:   
> 27:   
> 28:   

An off topic comment on the code block above. Doing code like this,
where you have a code branch for CF5 and a code branch for <5, will
result in an error if you turn on strict attribute validation. We ran
across this in a Spectra template and had to move the CF5 code into an
include. Like so:




old code


Just something to watch out for.

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Selecting All Categories that start with A..

[Adkins, Randy]

why not use the LIKE function in SQL:

LIKE 'A*' or is it LIKE 'A%'




-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that start with A..


Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Selecting All Categories that start with A..

[Duane Boudreau]

Use the SQL LIKE Statement


SELECT x1, x2...
FROM table
WHERE   lastname LIKE '#url.letter#%'

HTH,
Duane


-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that start with A..


Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Selecting All Categories that start with A..

[Joseph Thompson]

  SELECT
DISTINCT Left(FieldName,1) as Ltr
  FROM YourTable


> I am assuming that I can use a function such as Left() in SQL? Is there
> anything like that?
> How would I do something like this otherwise?
>
> -Gel
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Test-Please Ignore!!!

[thanh . nguyen]

this is a test

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Selecting All Categories that start with A..

[C. Hatton Humphrey]

In your query use:

WHERE Name Like 'A%'

The percent sign is the wildcard in SQL.

C. Hatton Humphrey 

> -Original Message-
> From: Angel Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 12:37 PM
> To: CF-Talk
> Subject: Selecting All Categories that start with A..
> 
> 
> Hey all,
> 
> I got a database that has like 120 categories.
> 
> The client wants A-Z along the top, and when A is clicked, only those
> categories that start with A will show.
> 
> SO I'm trying to use SQL in the query, with a URL variable called Letter
> passed when the user clicks the letter nav bar.
> 
> I am assuming that I can use a function such as Left() in SQL? Is there
> anything like that?
> How would I do something like this otherwise?
> 
> -Gel
> 
~~
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: Selecting All Categories that start with A..

[Christopher Olive]

try, in your WHERE clause,

WHERE
categoryname LIKE 'A%'

christopher olive, cio
cresco technologies, inc
http://www.crescotech.com


-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that start with A..


Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Selecting All Categories that start with A..

[Koo Pai Lao]

What is the architecture of the DB like?  are those categories individual 
tables?  or rows with IDs?






>From: "Angel Stewart" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Selecting All Categories that start with A..
>Date: Thu, 13 Sep 2001 11:37:15 -0500
>
>Hey all,
>
>I got a database that has like 120 categories.
>
>The client wants A-Z along the top, and when A is clicked, only those
>categories that start with A will show.
>
>SO I'm trying to use SQL in the query, with a URL variable called Letter
>passed when the user clicks the letter nav bar.
>
>I am assuming that I can use a function such as Left() in SQL? Is there
>anything like that?
>How would I do something like this otherwise?
>
>-Gel
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

REGEX to strip special characters

[Joshua Miller]

Anyone know of a REGEX to strip special characters from a string?

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Capitalize first characters

[thanh . nguyen]

Hi all, I'm just starting to learn coldfusion and I'm looking for a function
or a way to capitalize the first character of words in a string.  Can this
be done?  Can someone help me with this?  
 
Thanks

~~
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: Cold Fusion Studio 5.0 beta

[William Swain]

email [EMAIL PROTECTED]

or visit

http://beta.allaire.com

-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]]
Sent: 13 September 2001 16:57
To: CF-Talk
Subject: Cold Fusion Studio 5.0 beta


I've read posts on the CF Studio beta 5 before and I was wondering if this
is a public beta. If so, where can it be downloaded? Thanks for in advance
for any info.


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Recall: Delete Duplicate items in list

[van Wyk, Carlo]

van Wyk, Carlo would like to recall the message, "Delete Duplicate items in
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: E-Commerce...? Duane Boudreau FIRED by client

[Tyson Vanek]

No doubt.  People whine about someone posting a JRun-related question to
this list but will let this childish slamming go on here instead?

Geesh.

-Original Message-
From: Kurt Ward [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:06 AM
To: CF-Talk
Subject: RE: E-Commerce...? Duane Boudreau FIRED by client


Take it elsewhere children.

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:35 AM
To: CF-Talk
Subject: RE: E-Commerce...? Duane Boudreau FIRED by client


I hate to break the news to you Mike Randolph but I'm still employed by my
client full time. Yes there are hard feelings but only because I am forced
to work with your product!

Duane


-Original Message-
From: Mike Randolph [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 5:06 PM
To: CF-Talk
Subject: Re: E-Commerce...? Duane Boudreau FIRED by client


Hello Everyone,

I'm done listening to Duane Boudreau chiming in... About AbleCommerce.

When Duane dropped the ball on an AbleCommerce project and was FIRED by the
client he was obviously left with some hard feelings ...The project was
quickly
done by a real CF Programmer. (being as PC as I can be)  Out techical
support
is second to NONE, we answer our phone we quickly resolve issues.  You don't
get a real company to stand behind a product for free.  We were recently
reviewed against IBM and Microsoft's commerce products and did very well.

Thanks,

Mike Randolph
CEO of AbleCommerce

Duane Boudreau wrote:

> Ian,
>
> If you plan to do any customization of the product yourself, I would
> strongly advise against ablecommerce. Unfortunately, I've had the
> displeasure of working with and customizing ACB 2.6-2.9 for the past 9
> months and here are just some of the things I've found.
>
> Its expensive (as compared to apps like CFWebStore).
>
> The code is some places is very poorly written and very poorly thought out
> (being PC as possible here). Maintainability, and ease of customization
> clearly wasn't a consideration during development.
>
> There is little to no documentation and good luck trying to secure a
> database diagram from the folks at ACB. I tried for almost a month and all
> they would give me is some marketing documents.
>
> I would never recommend ACB to anyone!
>
> JMHO,
> Duane
>
> -Original Message-
> From: Mark Campbell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 1:13 PM
> To: CF-Talk
> Subject: Re: E-Commerce...?
>
> Ian ,I would look at this company's offering.
> http://ablecommerce.com/
> Mark Campbell
> Ian Lurie wrote:
>
> > I know this has been asked before, but here goes: Anyone out there know
a
> > good e-commerce product, preferably easily customized, that can handle a
> > fairly large store (500-1000 products)?
> >
> > Thanks,
> >
> > Ian
> >
> > Portent Interactive
> > http://www.portentinteractive.com
> > Combining process, design, content to create great web sites since 1995
> >
>

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Studio 5.0 beta

[Andrew Scott]

It can be downloaded from beta.allaire.com, however you will need to
send an email to [EMAIL PROTECTED] to get a login ID to participate:-) 


Regards,
Andrew Scott


-Original Message-
From: Nate Smith [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 September 2001 1:57 AM
To: CF-Talk
Subject: Cold Fusion Studio 5.0 beta

I've read posts on the CF Studio beta 5 before and I was wondering if
this
is a public beta. If so, where can it be downloaded? Thanks for in
advance
for any info.


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: filled up a client var

[Mike Townend]

Depends on what you are doing... I recently had the same problem.. I was
saving the results of a db search to a wddx packet in a client var...
Till it got too big.

My work around was to save the search params in the client var and
requery the database to reget the same results



-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 13, 2001 16:41
To: CF-Talk
Subject: filled up a client var


Hi, I've just filled up a client variable - what now?

Though the "Long" data field in the CDATA table can handle up to 2GB,
we're getting an Oracle error (no. 1704) that the "string literal too
long" - apparently there's a 4000-character limitation.  I've exceeded
that with my 6500-character WDDX packet stored in a client variable. 

To use a longer string we need to use bind variables in Oracle - the
database guys are working on that now.

Anybody else deal with this?

thanks,
Chris Norloff


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

.NET: ActiveX in Disguise?

[CFTalk]

In case you haven't seen it, this article came out on Monday on
 computerworld.com and in their newsletters.  For those of you
 who are critical of .net and want some more material to back up
 your position, here you go:

http://www.computerworld.com/rckey11/story/0,1199,NAV63_STO63605,
00.html

Jackson Moore
[EMAIL PROTECTED]
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Selecting All Categories that start with A..

[Angel Stewart]

Hey all,

I got a database that has like 120 categories.

The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.

SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.

I am assuming that I can use a function such as Left() in SQL? Is there
anything like that?
How would I do something like this otherwise?

-Gel
~~
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: CFUPDATE vs. UPDATE

[savan . thongvanh]

uh huh  :)




Billy Cravens <[EMAIL PROTECTED]> on 09/13/2001 10:11:28 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:

Subject:  RE: CFUPDATE vs. UPDATE


I'm not sure about performance issues, but from a logic standpoint, I'd
recommend always using a full UPDATE statement.  For a straight
modification of data from a simple form, CFUPDATE seems adequate.

However, this limits what you can do:
- limited server-side validation
- limited to one table

Some disadvantages:
- forces your form to expose information about your database

I acknowledge that CF is all about saving time, and CF tags tend to
be faster (to code) than raw SQL.  However, the biggest problem I see is
that developers use them as a crutch - you find yourself trying to shape
your logic so that CFUpdate will work - which you should never do.  Your
logic drives your code, not the other way around.

---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: Koo Pai Lao [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 5:24 PM
To: CF-Talk
Subject: CFUPDATE vs. UPDATE


which is faster or why should i use one over the other?
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Recall: Delete Duplicate items in list

[van Wyk, Carlo]

van Wyk, Carlo would like to recall the message, "Delete Duplicate items in
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: VBS to CF

[Jon Hall]

I assume you mean a select query...let me know if I am wrong.

I dont do VBScript, so my example is in JScript but I the concept is the 
same.

rs=DBConnect.Execute(strSQL);
//this returns a recordset object with the results of the SQL query

while (!rs.EOF) {
println(rs.fields("IPAddress").Value);
rs.moveNext();
}
//this loops through the recordset displaying the records
rs.close();
rs = null;
//this closes the db connection, which cfquery does automatically.

The CF equivalent to this is:


SELECT IPAddress ...



#ipaddress#


ADO database updates are a little different...

jon
Janine Jakim wrote:

>I'm looking at some vbs code and want to convert it to CF. I have most of
>it, however, am not quite sure about one spot. 
>They use the line of code:
>
>Set orr=DBConnect.Execute(strSQL)
>DBConnect had been set to Creat connection to DB
>strSQL is the name of the query that they wrote.
>
>That makes sense to me. But then they set data fields and then to move to
>the next record they use 
>orr.MoveNext
>I'm wondering if there is an equivalent in CF.  I thought a loop query would
>do the trick but I'm not getting the results that I need.
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Trouble with ClusterCats

[Trey Rouse]

Yeah, the more I dug into this I realized this is how clustercats was
monitoring the load state of each machine in  the cluster... I verified that
/btauxdir/cfprobe.cfm was public viewable over http://.

I went ahead and took a look at the log files for each web server and I can
see where ever 60 seconds or so a hit is made to cfprobe.cfm with a browser
agent of Allaire+ClusterCATS+probe.  I can even see my own hits to the page
as well hitting inbetween clusterCATS polling the state.  Unfortunatly there
is no apparent error happening. =(

Anyone else have any ideas?

Trey

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 7:18 AM
To: CF-Talk
Subject: RE: Trouble with ClusterCats


I had a problem with similar symptoms; turned out that the probe process
couldn't access cfprobe.cfm.  The method ClusterCats uses to decide where to
look for cfprobe.cfm is not clear to me, and if it can't get it for any
reason it decides that the server is busy.  Look in your IIS (or whatever)
logs for requests to cfprobe.cfm and see if they are being denied for some
reason.



> -Original Message-
> From: Trey Rouse [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 7:01 PM
> To: CF-Talk
> Subject: Trouble with ClusterCats
>
>
> I'm having some troubles configuring clustering on CF5.
>
> Specificaly, the load monitor on all servers runs at less
> than 3% for 20-30
> seconds then shoots up to 100% and makes the machine in the
> cluster offline.
>
> To simplify testing this, the problem duplicates by adding
> only a single
> machine to the cluster and bringing up load monitor.
>
> Here is my process:
>
> 1. Create the Cluster
> 2. Add A SINGLE machine to the cluster
> 3. Configure a basic probe to the btauxdir\cfprobe.cfm file
> checking for
> "Hello"
> 4. Manually verify cfprobe.cfm is working
> 5. Bring up the load monitor on the single server.
>
> Within 30 seconds server load is reported at 100%.  Using OS tools and
> checking the service, there is no noticable load.
>
> I have found restarting the CF monitoring service will return state to
> normal for another 20-30 seconds before jumping up to full
> utilization.
>
> I'm using a very simple configuration, 2 identical servers
> set up on DNS
> round robin. No hardware ballancing. My goal is primarily failover
> protection for when one machine becomes unavailable.
>
> I did find the hotfix about CPU utilization.  I didn't think
> it would apply
> to this as OS CPU utilization is unaffected by this, but the results
> duplicate regardless of applying the hotfix or not.
>
> On an unrelated note, I've descovered on every install of
> every machine I've
> ever made of CF5 w/ custerCATS the reset feature under ClusterCATS
> Administrator -> Advanced -> Reset fails with an unable to
> remove Btauxdir
> error message.
>
> I've looked around and found no related issues reported in
> support forums or
> addressed in a knowledge base article (go figure) so I
> thought I would see
> if anyone has any ideas here...
>
> Trey Rouse
> [EMAIL PROTECTED]
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: VBS to CF

[Andrew Scott]

Think of the orr.Next as a counter, VB doesn't (and this is off the toip
of my head) allow Recordsets to be returned in one hit, and you need to
use the cursor to move between rows.

So in that case instead of this:
 
 Set orr=DBConnect.Execute(strSQL)

You do this:-

 Cfquery name="QueryName" datasource="">
  Sql goes here.
 /cfquery

 Then doing cfoutput query="QueryName" or using cfloop to go through the
returned records!!

Regards,
Andrew Scott


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Friday, 14 September 2001 1:25 AM
To: CF-Talk
Subject: RE: VBS to CF

> I'm looking at some vbs code and want to convert it to CF. I 
> have most of it, however, am not quite sure about one spot. 
> They use the line of code:
> 
> Set orr=DBConnect.Execute(strSQL)
> DBConnect had been set to Creat connection to DB
> strSQL is the name of the query that they wrote.
> 
> That makes sense to me. But then they set data fields and 
> then to move to the next record they use orr.MoveNext
> I'm wondering if there is an equivalent in CF. I thought a 
> loop query would do the trick but I'm not getting the results 
> that I need.

There is no direct analog to this in CF, because querying databases and
looping over recordsets is handled instead using CFQUERY and CFOUTPUT,
which
is a bit simpler than the way you'd do it with ADO in ASP. CF, unlike
VBS in
ASP, doesn't provide objects with methods (such as the Recordset object
with
its MoveNext method).

If you wanted to build something as similar in CF to your VBS/ASP code,
you
could use a loop within a CFSCRIPT block, although that wouldn't be an
exact
analog either:


SELECT field1, field2 ...




for (i = 1; i lte qFoo.RecordCount; i = i + 1) {
WriteOutput("");
WriteOutput("" & qFoo.field1[i] & "");
WriteOutput("" & qFoo.field2[i] & "");
WriteOutput("");
}



Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFUPDATE vs. UPDATE

[Won Lee]

UPDATE vs CFUPDATE

This is actually one circumstance where using cfupdate is permissble.
Oracle has a limitaition of only being able to insert/update a max of 255
chars in a text field on an insert/update command.  That means you either
have to write a stored procedure to read and insert/update 255 chars at a
time or use a cfinsert or cfupdate.

Won Lee
Allaire Certified ColdFusion Developer.

PS It's good to be back writing ColdFusion.  I've taken a bit of a hiatus
trying some other things like JSP.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 9:33 AM
To: CF-Talk
Subject: Re: CFUPDATE vs. UPDATE


sorry no numbers but I seem to find that UPDATE works a HAIR faster.
virtually the same though especially for simple queries (which seem to be
most).

just a personal preference but I try alway to use SQL.  why use  when you can use the real deal...?




"Koo Pai Lao" <[EMAIL PROTECTED]> on 09/12/2001 05:24:25 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:

Subject:  CFUPDATE vs. UPDATE


which is faster or why should i use one over the other?
~~
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: PDF/Verity CF 5?

[Stephen M Aylor]

If mem serves correctly  its Adobe's switch to unicode support in
version 4 and 5 of the Acrobat product that causes the grief for the verity
engine bundled with CF 4x.

Wonder if you opened several of the pdf's in question in the full version of
acrobat 4, and elected to Save As - version 3 of acrobat.  Acrobat 4x allows
you to elect which version you want to Save As.  Dunno know if your using
some advanced features of Acro 4 / 5 - maybe you need that.

Maybe someone on the PDFZone.com site or www.planetpdf.com has a tool for
sale that will do the conversion "en masse" back to Acrobat 3x.

You may also want to drop a note to Dylan Bromby [ dont know where he's at
now ] - he posted a note that he had it working CF4.5/Verity/Acro4x.

HTH,

Steve Aylor

- Original Message -
From: "Ian Lurie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 6:43 AM
Subject: PDF/Verity CF 5?


> Hi Everyone,
>
> We're about to launch a site that includes a searchable PDF library. It
> worked, up to yesterday. When we deleted and reindexed the PDF library,
> Verity failed to index the same PDFs it had indexed perfectly the week
> before.
>
> The only hint we've found is that the Verity engine with CF 4.5 doesn't
> support PDFs encoded using Acrobat 4 or 5.
>
> If that's true, we have to upgrade. But we've got 30 or 40 other CF sites
on
> that server.
>
> Here's the big question: Is 5 totally backwards compatible? Or am I going
to
> spend the next 3 weeks debugging sites that were previously OK?
>
> Ian
>
> Portent Interactive
> http://www.portentinteractive.com
> Combining process, design, content to create great web sites since 1995
>
~~
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: VBS to CF

[Cary Gordon]

It is not possible to fully address your question with the information 
which you provide.  That said, the number one gotcha in converting asp to 
cf is refusing to believe how simple it is.

In general, unless you are nesting result sets, you want to loop through 
the results using This result line is 
#bar#., or something like that.

At 10:35 AM 9/13/2001 -0400, you wrote:
>I'm looking at some vbs code and want to convert it to CF. I have most of
>it, however, am not quite sure about one spot.
>They use the line of code:
>
>Set orr=DBConnect.Execute(strSQL)
>DBConnect had been set to Creat connection to DB
>strSQL is the name of the query that they wrote.
>
>That makes sense to me. But then they set data fields and then to move to
>the next record they use
>orr.MoveNext
>I'm wondering if there is an equivalent in CF.  I thought a loop query would
>do the trick but I'm not getting the results that I need.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: VBS to CF

[Garza, Jeff]

Can we see some more code, specifically what they are doing with the data
fields.  The MoveNext command is the ASP way of moving through a recordset.
Something like

While Not rs.EOF 
// Show fields, manipulate values, etc...
rs.MoveNext
Wend

You should be able to do exactally the same thing with a CFOUTPUT tag
referencing your query.  Post some code.


Jeff Garza
Lead Developer/Webmaster
[EMAIL PROTECTED]

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 13, 2001 7:36 AM
To: CF-Talk
Subject: VBS to CF


I'm looking at some vbs code and want to convert it to CF. I have most of
it, however, am not quite sure about one spot. 
They use the line of code:

Set orr=DBConnect.Execute(strSQL)
DBConnect had been set to Creat connection to DB
strSQL is the name of the query that they wrote.

That makes sense to me. But then they set data fields and then to move to
the next record they use 
orr.MoveNext
I'm wondering if there is an equivalent in CF.  I thought a loop query would
do the trick but I'm not getting the results that I need.
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:OT - Software allocation of RAM

[savan . thongvanh]

NT is excepted.

Win9x is limited in the amount of RAM it can allocate, anything more than
128 is junk..

Win2k Server/Advanced Server/Datacenter can scale up to gigs and gigs of
RAM and as you said, with better garbage collection than previous versions.
I think the lowest one is 2 Gig for W2k Server.






[EMAIL PROTECTED] (Carol Bluestein) on 09/13/2001 09:13:41
AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:

Subject:  Re:OT - Software allocation of RAM


You are not alone.

I'm not an expert here and I'm sure you are going to get plenty of expert
help.
However, I will say that anything less that windows2000 (and I don't know
if
NT is excepted here) allocates only 125 of RAM ( or some such low number)
no matter how much RAM you have installed.  Win2000 handles RAM much
better and you don't keep getting the "low resources" message.

I ran into the same trouble and just kept "unnecessary" applications or
resources
closed.  Allaire has this information in its knowledgebase, I believe,
because
they are the ones that explained it.

Carol

Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:OT - Software allocation of RAM
Author: [EMAIL PROTECTED]
Date:   9/12/01 3:34 PM

General question here -

I'm going to assume windows allocates certain percentages of memory (RAM)
  to specific software programs, is there a way to change this?  The
  reason Im asking is I frequently run out of memory (RAM) and get odd
  error messages from programs saying not enough memory.  Well, I have
  recently upgraded my work PC to 1/2 GIG of RAM from 256, but still
  get these screwy messages.  I admit I do have a lot of applications
  open on my workstation but I would think I would run out of 1/2 GIG
  of RAM that easily. I am running a P3 667 w/ 500 MEG RAM.

Applications running when error messages occur:

IE 5.5, MS Access 97', windows explorer, Lotus Notes, SQL query analyzer,
  SQL Enterprise Manager, AOL instant messenger. (I would not think
  this would be enough to yield memory errors, but as soon as I shut
  one down all is well.)



Thanks,

Casey Cook
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Duplicate and StructCopy

[Tyson Vanek]

An interesting scenario that should be considered.  Given the following code
example:

01: 
02: arrTest1 = arrayNew(1);
03:
04: arrTest1[1] = "foo1";
05: arrTest1[2] = "foo2";
06: arrTest1[3] = "foo3";
07: arrTest1[4] = structNew();
08: arrTest1[4]['0001'] = "1";
09: arrTest1[4]['0002'] = "2";
10: arrTest1[4]['0003'] = "3";
11: arrTest1[4]['0004'] = "4";
12: arrTest1[4]['0005'] = "5";
13:
14: arrTest2 = arrTest1;
15:
16: arrTest2[1] = "foo1_2";
17: arrTest2[4]['0005'] = "5_2";
18: 
18:
19: 
20: 
21: 
22:
23: 
24: 
25: 
26: 
27: 
28: 
29: arrTest1[1] = #arrTest1[1]#
30: arrTest2[1] = #arrTest2[1]#
31: 
32: arrTest1[4]['0005'] = #arrTest1[4]['0005']#
33: arrTest2[4]['0005'] = #arrTest2[4]['0005']#
34: 
35: 

Although arrTest1 and arrTest2 are arrays, the variable set on line #14
creates a copy of the array but a pointer reference to the embedded
structure.  You'll see that when you output the embedded simple value from
each array, they will have been changed independantly.  However, you'll find
that the change made to the embedded structure in the second array also
changes the structure in the first array.

As a best practice, you should always run a code example like the one above
if you are uncertain if your variable set need to use the duplicate()
function.  Better safe than sorry.  :)

Hope this helps,
Tyson


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 9:37 AM
To: CF-Talk
Subject: RE: Duplicate and StructCopy


> Duplicate() is used with CFSET to copy a complex variable
> (query, array or structure).  If you don't use Duplicate()
> then the copy is not a real copy, but a pointer back to the
> original - this can cause problems with shared-scope
> variables (application, session, server).

Arrays aren't complex variables, so they are passed by value anyway. I made
the same mistake myself; I thought they were complex variables.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
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

Cold Fusion Studio 5.0 beta

[Nate Smith]

I've read posts on the CF Studio beta 5 before and I was wondering if this
is a public beta. If so, where can it be downloaded? Thanks for in advance
for any info.

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

real time processing II

[Chase, John]

Thanks to all for the input, I'm glad I asked before getting in too deep...
I think I'm going to ditch CF for 2 of the 3 "real time" projects I have on
the plate. The one that I have attempted is definitely not even near real
time, but goes something like this: I cfhttp a file every 15 minutes. When a
user first loads the page, I have init (param) values set to 0. The file
gets parsed and I compare the first set of values with the param values. I
then begin to feed the controls and the meters smoothly ramp up to the first
data set points over the next fifteen minutes. I then re-get the file, which
has been overwritten with a new set of values. These are in turn compared to
the last set and a range is then fed to the controls which then ramp to that
set over the ensuing 15 minute period. So, its kind of a smoothed
representation of what is happening with a 15 minute lag. It seems safe that
CF can accomplish this much. 
Thanks again, 

> John Chase
> Web Programmer
> National Renewable Energy Laboratory
> 1617 Cole Boulevard
> Golden, CO 80401-3393
> (303) 275-3620 
> (303) 275-3603 FAX
> 
> 
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF_BOOLSEARCH tag

[Steven Monaghan]

Thanks for the help.

I did indeed find the tag.  I was looking for a file named
cf_boolsearch.cfm, not boolsearch.cfm.

Also, thanks for the link to the tag source.  I was modifying the source to
work with an Oracle database (which is case sensitive, unlike the Sql Server
db that was being used).

If anyone wants a copy of the modified tag, please let me know.

Steve
-
Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-

-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:41 AM
To: CF-Talk
Subject: Re: CF_BOOLSEARCH tag


Go to this URL:
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3476C7-2830-11D4-AA
9700508B94F380&method=Full

Here you will find this tag as well as an explanation as to what it does.
- Original Message -
From: "Steven Monaghan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 9:26 AM
Subject: CF_BOOLSEARCH tag


> I am new to Cold Fusion have inherited an application written by outside
> consultants that is being brought in-house.  In the code I see a tag
> CF_BOOLSEARCH.  I have not installed any custom tags, so I don't think it
is
> one, yet I can't find any documentation/information on this tag.
>
> Can anyone help?
>
> Steve
> -
> Steven Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> [EMAIL PROTECTED]
> http://www.mscdirect.com
> -
>
>
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law.  If you are not the intended recipient, please do
not
> read, copy, use or disclose the contents of this communication to others.
> Please notify the sender that you have received this e-mail in error by
> replying to the e-mail.  Please then delete the e-mail and destroy any
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: VBS to CF

[Neil Clark]

isnt the Query a collection in this case?

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

filled up a client var

[Chris Norloff]

Hi, I've just filled up a client variable - what now?

Though the "Long" data field in the CDATA table can handle up to 2GB, we're getting an 
Oracle error (no. 1704) that the "string literal too long" - apparently there's a 
4000-character limitation.  I've exceeded that with my 6500-character WDDX packet 
stored in a client variable. 

To use a longer string we need to use bind variables in Oracle - the database guys are 
working on that now.

Anybody else deal with this?

thanks,
Chris Norloff

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: VBS to CF

[tom muck]

You need to execute the query first (what the VBScript execute is doing)
with:


  SELECT blah from blah


Then loop thru the query with a  or .  Check
the CF docs for details.

 There is no "movenext" in CF.  There is no concept of a pointer to a
current record.  You can look at any or all of the results at any time.

tom
www.basic-ultradev.com


"Janine Jakim" <[EMAIL PROTECTED]> wrote in message
1BEB99C913B7D411855F00B0D020F05B134006@STMS">news:1BEB99C913B7D411855F00B0D020F05B134006@STMS...
> I'm looking at some vbs code and want to convert it to CF. I have most of
> it, however, am not quite sure about one spot.
> They use the line of code:
>
> Set orr=DBConnect.Execute(strSQL)
> DBConnect had been set to Creat connection to DB
> strSQL is the name of the query that they wrote.
>
> That makes sense to me. But then they set data fields and then to move to
> the next record they use
> orr.MoveNext
> I'm wondering if there is an equivalent in CF.  I thought a loop query
would
> do the trick but I'm not getting the results that I need.
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists