RE: Which Is Faster, multiple CFQuery or Multiple Query of a Quer y?

[Bryan Love]

bingo

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis



-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 8:12 AM
To: CF-Talk
Subject: Re: Which Is Faster, multiple CFQuery or Multiple Query of a
Query?


In many situations though simpy GROUP'ing the data with CFOUTPUT would
eliminate the need for any other queries at all... (just a thought)

> Agree Keen, the first query is local then the query of that query does not
> need to exercise the database again.



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Is there a SQL guru in the house?

[Lee Fuller]

Please respond off list - [EMAIL PROTECTED]

In need of a SQL guru to answer some vbscript/ADO/SQL questions (for pay
of course).  Thought this would be a good place to look.

TTAIA

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Turning a query recordset into a comma-delimited string/file

[Scott Weikert]

Sweet! Did the trick. I was considering converting my process (which was
similar, but not as well done) to CFSCRIPT, but wanted to find something
better... and this was it. Many thanks Jim :)

- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 10:26 AM
Subject: RE: Turning a query recordset into a comma-delimited string/file


> http://www.cflib.org/udf.cfm?ID=404


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: light editor (was: oh, man)

[Mark A. Kruger - CFG]

Yes but... is there really that much money in basement sites? I think one of
the reasons why so many of them ARE in Perl and PHP is that they are done on
a shoestring budget.  I want CF to move in the other direction - then I can
afford to hire someone to do all my basement sites for me (ha).

-mk

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 9:55 AM
To: CF-Talk
Subject: Re: light editor (was: oh, man)


OK, so let's take a look at this from another direction.  You're a Cold
Fusion developer with a "day job" that shells out the grand for CF Pro (plus
the web server and OS), and the $300+ for CF development studio.  Yet, you
want to build a functional, database driven site for your brother's business
(or to show off your dog, or whatever) and you want to host it on an old
computer you have set up as a server that's connected to your cable
modem/DSL line.  So, would you rather (a) pirate said software from your
employer (not a good thing); (b) use another cheaper/free technology like
PERL or PHP; (c) have an inexpensive but still very functional and familiar
coding tool and a free/cheap way of serving up CF pages from the server you
have hooked up to your cable modem (or that your web host didn't have to pay
one red cent for, so they said "sure, we'll install CF Express")?

Hmm, let me see.  I pick "C".  I just turned down a job offer because I
didn't want to stop developing in CF (offer was from a JSP/Websphere
shop)...

Not everyone who NEEDS these tools at home is an "amateur".

Pete

- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 10:39 AM
Subject: RE: light editor (was: oh, man)


> Why is it that talk of taking CF to the current market of FrontPage
> users makes me cringe?
>
> That's exactly what we DON'T need - is trying to take ColdFusion DOWN to
> a more basic level for home users. I can picture a lot of time and
> effort that would be better focused on the advancement of CF being
> wasted on trying to compete with FrontPage.
>
> I like the fact that Macromedia makes professional tools for
> professional developers. Their products are always strong and robust - I
> think fighting battles on both fronts would only serve to impede the
> progress of Macromedia and in turn ColdFusion.
>
> As long as HomeSite+ doesn't go away I'll have no complaints - but it's
> this constant push to be on everyone's desktop that makes products too
> limited for professional developers. I have used Dreamweaver since 1.0
> and I love it for what it is, but making DW the front end for a CF
> version of FrontPage makes my blood boil.
>
> Microsoft can have the home user - Macromedia should stick with the
> professional route.
>
> This is like saying they should re-develop Freehand to compete with MS
> Paint.
>
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
>
>
> -Original Message-
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 9:32 AM
> To: CF-Talk
> Subject: Re: light editor (was: oh, man)
>
>
> Yes, but at what cost?  FP2002 upgrade is $80 (full is $140), while
> Dreamweaver upgrade is $140 (full is $265)...surely the new
> DreamweaverMX will cost even more than Dreamweaver 4...
>
> I'm not saying that FP2002 is better (certainly it is NOT).  However,
> Macromedia needs to create tools for the home/small business market that
> can directly compete, price-wise, with FP (which allows users to create
> data-driven sites).  Personally, I think making CFExpress as ubiquitous
> with ISP's as Front Page Extensions are, and having a tool that can help
> home users/small businesses build data driven sites with a $75 software
> package combined with CFExpress and a simple datasource (Access, FoxPro,
> etc.) would be regarded very favorably in the marketplace, especially if
> MM really promoted CFExpress to ISP's and also offered a Linux version
> (since most "cheap" web hosting seems to be Linux-based).
>
> I think the old Costnerism "If you build it, they will come"
> applies...and many of those users that grow to know and love CFExpress
> will eventually "graduate" to fully-blown tools like CF and DW Studio.
>
> Just my 2 cents
>
> Pete
>
> - Original Message -
> From: "Trusz, Andrew" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 09, 2002 9:01 AM
> Subject: RE: light editor (was: oh, man)
>
>
> 
> > As an additional benefit, DWMX will continue to be a nice
> > out-of-the-box solution for less ambitious sites.  You can build your
> > own interactive
> site
> > almost as easily as a static site with DWMX. It will remain
> technologically
> > superior to FP and will likely hold its own, if the company survives.
> >
> 
>
>
>

___

Re: light editor (was: oh, man)

[Douglas Brown]

Well I will pick (d) which was not on the list. If my brother had
a business, and needed a dynamic content site, I would design it
for him in CF and tell him to get the thing hosted for 19.95 a
month. Why on earth would I want to host a business site on a
dsl/cable line?




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 9:40 AM
Subject: RE: light editor (was: oh, man)


> Yes but... is there really that much money in basement sites? I
think one of
> the reasons why so many of them ARE in Perl and PHP is that they
are done on
> a shoestring budget.  I want CF to move in the other direction -
then I can
> afford to hire someone to do all my basement sites for me (ha).
>
> -mk
>
> -Original Message-
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 9:55 AM
> To: CF-Talk
> Subject: Re: light editor (was: oh, man)
>
>
> OK, so let's take a look at this from another direction.  You're
a Cold
> Fusion developer with a "day job" that shells out the grand for
CF Pro (plus
> the web server and OS), and the $300+ for CF development studio.
Yet, you
> want to build a functional, database driven site for your
brother's business
> (or to show off your dog, or whatever) and you want to host it
on an old
> computer you have set up as a server that's connected to your
cable
> modem/DSL line.  So, would you rather (a) pirate said software
from your
> employer (not a good thing); (b) use another cheaper/free
technology like
> PERL or PHP; (c) have an inexpensive but still very functional
and familiar
> coding tool and a free/cheap way of serving up CF pages from the
server you
> have hooked up to your cable modem (or that your web host didn't
have to pay
> one red cent for, so they said "sure, we'll install CF
Express")?
>
> Hmm, let me see.  I pick "C".  I just turned down a job offer
because I
> didn't want to stop developing in CF (offer was from a
JSP/Websphere
> shop)...
>
> Not everyone who NEEDS these tools at home is an "amateur".
>
> Pete
>
> - Original Message -
> From: "Joshua Miller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 09, 2002 10:39 AM
> Subject: RE: light editor (was: oh, man)
>
>
> > Why is it that talk of taking CF to the current market of
FrontPage
> > users makes me cringe?
> >
> > That's exactly what we DON'T need - is trying to take
ColdFusion DOWN to
> > a more basic level for home users. I can picture a lot of time
and
> > effort that would be better focused on the advancement of CF
being
> > wasted on trying to compete with FrontPage.
> >
> > I like the fact that Macromedia makes professional tools for
> > professional developers. Their products are always strong and
robust - I
> > think fighting battles on both fronts would only serve to
impede the
> > progress of Macromedia and in turn ColdFusion.
> >
> > As long as HomeSite+ doesn't go away I'll have no complaints -
but it's
> > this constant push to be on everyone's desktop that makes
products too
> > limited for professional developers. I have used Dreamweaver
since 1.0
> > and I love it for what it is, but making DW the front end for
a CF
> > version of FrontPage makes my blood boil.
> >
> > Microsoft can have the home user - Macromedia should stick
with the
> > professional route.
> >
> > This is like saying they should re-develop Freehand to compete
with MS
> > Paint.
> >
> > Joshua Miller
> > Web Development :: Programming
> > Eagle Web Development LLC
> > www.eaglewd.com
> > [EMAIL PROTECTED]
> > (304) 622-5676 (Clarksburg Office)
> > (304) 456-4942 (Home Office)
> >
> >
> > -Original Message-
> > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 9:32 AM
> > To: CF-Talk
> > Subject: Re: light editor (was: oh, man)
> >
> >
> > Yes, but at what cost?  FP2002 upgrade is $80 (full is $140),
while
> > Dreamweaver upgrade is $140 (full is $265)...surely the new
> > DreamweaverMX will cost even more than Dreamweaver 4...
> >
> > I'm not saying that FP2002 is better (certainly it is NOT).
However,
> > Macromedia needs to create tools for the home/small business
market that
> > can directly compete, price-wise, with FP (which allows users
to create
> > data-driven sites).  Personally, I think making CFExpress as
ubiquitous
> > with ISP's as Front Page Extensions are, and having a tool
that can help
> > home users/small businesses build data driven sites with a $75
software
> > package combined with CFExpress and a simple datasource
(Access, FoxPro,
> > etc.) would be regarded very favorably in the marketplace,
especially if
> > MM really promoted CFExpress to ISP's and also offered a Linux
version
> > (since most "cheap" web hosting seems to be Linux-based).
> >
> > I think the old Costnerism "If you build it, they will come"
> > applies...and many of those users that grow to know and love

RE: light editor (was: oh, man)

[Joshua Miller]

Personally I'd choose B. I don't care if I can build small piddly sites
in CF - actually that's the best way to learn other technologies is to
do the sites for friends/family using Open Source solutions.

If I were you, I'd go the JSP route. Apache, Tomcat and Cocoon are free,
easy to use and perfect for exactly what you're talking about. 

How exactly would MM make money to further develop CF and CF Express if
it's free? I'd rather the resources go into making DWMX a better tool
from a coder standpoint and making the next version of CF Server even
more feature rich.

That's just my opinion though - and you are entitled to yours.

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 09, 2002 12:41 PM
To: CF-Talk
Subject: RE: light editor (was: oh, man)


Yes but... is there really that much money in basement sites? I think
one of the reasons why so many of them ARE in Perl and PHP is that they
are done on a shoestring budget.  I want CF to move in the other
direction - then I can afford to hire someone to do all my basement
sites for me (ha).

-mk

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 9:55 AM
To: CF-Talk
Subject: Re: light editor (was: oh, man)


OK, so let's take a look at this from another direction.  You're a Cold
Fusion developer with a "day job" that shells out the grand for CF Pro
(plus the web server and OS), and the $300+ for CF development studio.
Yet, you want to build a functional, database driven site for your
brother's business (or to show off your dog, or whatever) and you want
to host it on an old computer you have set up as a server that's
connected to your cable modem/DSL line.  So, would you rather (a) pirate
said software from your employer (not a good thing); (b) use another
cheaper/free technology like PERL or PHP; (c) have an inexpensive but
still very functional and familiar coding tool and a free/cheap way of
serving up CF pages from the server you have hooked up to your cable
modem (or that your web host didn't have to pay one red cent for, so
they said "sure, we'll install CF Express")?

Hmm, let me see.  I pick "C".  I just turned down a job offer because I
didn't want to stop developing in CF (offer was from a JSP/Websphere
shop)...

Not everyone who NEEDS these tools at home is an "amateur".

Pete

- Original Message -
From: "Joshua Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 10:39 AM
Subject: RE: light editor (was: oh, man)


> Why is it that talk of taking CF to the current market of FrontPage 
> users makes me cringe?
>
> That's exactly what we DON'T need - is trying to take ColdFusion DOWN 
> to a more basic level for home users. I can picture a lot of time and 
> effort that would be better focused on the advancement of CF being 
> wasted on trying to compete with FrontPage.
>
> I like the fact that Macromedia makes professional tools for 
> professional developers. Their products are always strong and robust -

> I think fighting battles on both fronts would only serve to impede the

> progress of Macromedia and in turn ColdFusion.
>
> As long as HomeSite+ doesn't go away I'll have no complaints - but 
> it's this constant push to be on everyone's desktop that makes 
> products too limited for professional developers. I have used 
> Dreamweaver since 1.0 and I love it for what it is, but making DW the 
> front end for a CF version of FrontPage makes my blood boil.
>
> Microsoft can have the home user - Macromedia should stick with the 
> professional route.
>
> This is like saying they should re-develop Freehand to compete with MS

> Paint.
>
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
>
>
> -Original Message-
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 9:32 AM
> To: CF-Talk
> Subject: Re: light editor (was: oh, man)
>
>
> Yes, but at what cost?  FP2002 upgrade is $80 (full is $140), while 
> Dreamweaver upgrade is $140 (full is $265)...surely the new 
> DreamweaverMX will cost even more than Dreamweaver 4...
>
> I'm not saying that FP2002 is better (certainly it is NOT).  However, 
> Macromedia needs to create tools for the home/small business market 
> that can directly compete, price-wise, with FP (which allows users to 
> create data-driven sites).  Personally, I think making CFExpress as 
> ubiquitous with ISP's as Front Page Extensions are, and having a tool 
> that can help home users/small businesses build data driven sites with

> a $75 software package combined with CFExpress and a simple datasource

> (Access, FoxPro,
> etc.) would be regar

RE: light editor (was: oh, man)

[CWatt]

I agree, pay the $19.95 a month.  One thing to keep in mind is, what will
the phone/cable company do.  If you read you contract, you are not suppose
to host any servers of any kind on that line.  In Kansas City, the cable
carrier has shut off inbound http requests to it's subscribers (an easy
thing to do at there router!!!).  I would not be surprised to others
following suit!

Christian

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 09, 2002 12:47 PM
To: CF-Talk
Subject: Re: light editor (was: oh, man)


Well I will pick (d) which was not on the list. If my brother had a
business, and needed a dynamic content site, I would design it for him in CF
and tell him to get the thing hosted for 19.95 a month. Why on earth would I
want to host a business site on a dsl/cable line?




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 9:40 AM
Subject: RE: light editor (was: oh, man)


> Yes but... is there really that much money in basement sites? I
think one of
> the reasons why so many of them ARE in Perl and PHP is that they
are done on
> a shoestring budget.  I want CF to move in the other direction -
then I can
> afford to hire someone to do all my basement sites for me (ha).
>
> -mk
>
> -Original Message-
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 9:55 AM
> To: CF-Talk
> Subject: Re: light editor (was: oh, man)
>
>
> OK, so let's take a look at this from another direction.  You're
a Cold
> Fusion developer with a "day job" that shells out the grand for
CF Pro (plus
> the web server and OS), and the $300+ for CF development studio.
Yet, you
> want to build a functional, database driven site for your
brother's business
> (or to show off your dog, or whatever) and you want to host it
on an old
> computer you have set up as a server that's connected to your
cable
> modem/DSL line.  So, would you rather (a) pirate said software
from your
> employer (not a good thing); (b) use another cheaper/free
technology like
> PERL or PHP; (c) have an inexpensive but still very functional
and familiar
> coding tool and a free/cheap way of serving up CF pages from the
server you
> have hooked up to your cable modem (or that your web host didn't
have to pay
> one red cent for, so they said "sure, we'll install CF
Express")?
>
> Hmm, let me see.  I pick "C".  I just turned down a job offer
because I
> didn't want to stop developing in CF (offer was from a
JSP/Websphere
> shop)...
>
> Not everyone who NEEDS these tools at home is an "amateur".
>
> Pete
>
> - Original Message -
> From: "Joshua Miller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 09, 2002 10:39 AM
> Subject: RE: light editor (was: oh, man)
>
>
> > Why is it that talk of taking CF to the current market of
FrontPage
> > users makes me cringe?
> >
> > That's exactly what we DON'T need - is trying to take
ColdFusion DOWN to
> > a more basic level for home users. I can picture a lot of time
and
> > effort that would be better focused on the advancement of CF
being
> > wasted on trying to compete with FrontPage.
> >
> > I like the fact that Macromedia makes professional tools for 
> > professional developers. Their products are always strong and
robust - I
> > think fighting battles on both fronts would only serve to
impede the
> > progress of Macromedia and in turn ColdFusion.
> >
> > As long as HomeSite+ doesn't go away I'll have no complaints -
but it's
> > this constant push to be on everyone's desktop that makes
products too
> > limited for professional developers. I have used Dreamweaver
since 1.0
> > and I love it for what it is, but making DW the front end for
a CF
> > version of FrontPage makes my blood boil.
> >
> > Microsoft can have the home user - Macromedia should stick
with the
> > professional route.
> >
> > This is like saying they should re-develop Freehand to compete
with MS
> > Paint.
> >
> > Joshua Miller
> > Web Development :: Programming
> > Eagle Web Development LLC
> > www.eaglewd.com
> > [EMAIL PROTECTED]
> > (304) 622-5676 (Clarksburg Office)
> > (304) 456-4942 (Home Office)
> >
> >
> > -Original Message-
> > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 9:32 AM
> > To: CF-Talk
> > Subject: Re: light editor (was: oh, man)
> >
> >
> > Yes, but at what cost?  FP2002 upgrade is $80 (full is $140),
while
> > Dreamweaver upgrade is $140 (full is $265)...surely the new 
> > DreamweaverMX will cost even more than Dreamweaver 4...
> >
> > I'm not saying that FP2002 is better (certainly it is NOT).
However,
> > Macromedia needs to create tools for the home/small business
market that
> > can directly compete, price-wise, with FP (which allows users
to create
> > data-driven sites).  Personally, I think making CFExpress as
ubiquitous
> > with ISP's a

RE: light editor (was: oh, man)

[Joshua Miller]

LOL! Yeah, well put! CF is a professional development tool - if you want
to do free sites and you can't justify paying for CF then CF clearly
isn't the answer. PHP and JSP are excellent technologies and can be done
for little to no money. I leave ASP out because I hate it, but it may be
a good alternative as well.

I just setup Apache / Tomcat / Cocoon on my personal server (Being
served off a DirecWAY satellite in about 30 mins - as soon as the guy's
done installing it.) and I think it's a fabulous alternative to CF for
free/cheap development.

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 09, 2002 1:47 PM
To: CF-Talk
Subject: Re: light editor (was: oh, man)


Well I will pick (d) which was not on the list. If my brother had a
business, and needed a dynamic content site, I would design it for him
in CF and tell him to get the thing hosted for 19.95 a month. Why on
earth would I want to host a business site on a dsl/cable line?




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 9:40 AM
Subject: RE: light editor (was: oh, man)


> Yes but... is there really that much money in basement sites? I
think one of
> the reasons why so many of them ARE in Perl and PHP is that they
are done on
> a shoestring budget.  I want CF to move in the other direction -
then I can
> afford to hire someone to do all my basement sites for me (ha).
>
> -mk
>
> -Original Message-
> From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 9:55 AM
> To: CF-Talk
> Subject: Re: light editor (was: oh, man)
>
>
> OK, so let's take a look at this from another direction.  You're
a Cold
> Fusion developer with a "day job" that shells out the grand for
CF Pro (plus
> the web server and OS), and the $300+ for CF development studio.
Yet, you
> want to build a functional, database driven site for your
brother's business
> (or to show off your dog, or whatever) and you want to host it
on an old
> computer you have set up as a server that's connected to your
cable
> modem/DSL line.  So, would you rather (a) pirate said software
from your
> employer (not a good thing); (b) use another cheaper/free
technology like
> PERL or PHP; (c) have an inexpensive but still very functional
and familiar
> coding tool and a free/cheap way of serving up CF pages from the
server you
> have hooked up to your cable modem (or that your web host didn't
have to pay
> one red cent for, so they said "sure, we'll install CF
Express")?
>
> Hmm, let me see.  I pick "C".  I just turned down a job offer
because I
> didn't want to stop developing in CF (offer was from a
JSP/Websphere
> shop)...
>
> Not everyone who NEEDS these tools at home is an "amateur".
>
> Pete
>
> - Original Message -
> From: "Joshua Miller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 09, 2002 10:39 AM
> Subject: RE: light editor (was: oh, man)
>
>
> > Why is it that talk of taking CF to the current market of
FrontPage
> > users makes me cringe?
> >
> > That's exactly what we DON'T need - is trying to take
ColdFusion DOWN to
> > a more basic level for home users. I can picture a lot of time
and
> > effort that would be better focused on the advancement of CF
being
> > wasted on trying to compete with FrontPage.
> >
> > I like the fact that Macromedia makes professional tools for 
> > professional developers. Their products are always strong and
robust - I
> > think fighting battles on both fronts would only serve to
impede the
> > progress of Macromedia and in turn ColdFusion.
> >
> > As long as HomeSite+ doesn't go away I'll have no complaints -
but it's
> > this constant push to be on everyone's desktop that makes
products too
> > limited for professional developers. I have used Dreamweaver
since 1.0
> > and I love it for what it is, but making DW the front end for
a CF
> > version of FrontPage makes my blood boil.
> >
> > Microsoft can have the home user - Macromedia should stick
with the
> > professional route.
> >
> > This is like saying they should re-develop Freehand to compete
with MS
> > Paint.
> >
> > Joshua Miller
> > Web Development :: Programming
> > Eagle Web Development LLC
> > www.eaglewd.com
> > [EMAIL PROTECTED]
> > (304) 622-5676 (Clarksburg Office)
> > (304) 456-4942 (Home Office)
> >
> >
> > -Original Message-
> > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 9:32 AM
> > To: CF-Talk
> > Subject: Re: light editor (was: oh, man)
> >
> >
> > Yes, but at what cost?  FP2002 upgrade is $80 (full is $140),
while
> > Dreamweaver upgrade is $140 (full is $265)...surely the new 
> > DreamweaverMX will cost even more than Dreamwea

RE: Fw: Oh man, no more HomeSite/CFStudio, for real :-(

[Costas Piliotis]

What I actually meant was that it shows the files within the directory tree
on the left panel.  That is a bit awkward when you have a tree that's really
deep.  The way cf studio did it was more efficient.  You had your tree at
the top and the file list at the bottom.  That difference I can tell I'm
going to hate...

-Original Message-
From: Vernon Viehe [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 08, 2002 9:08 PM
To: CF-Talk
Subject: RE: Fw: Oh man, no more HomeSite/CFStudio, for real :-(


The file window (and databases)? Those are located in panels (which can be
on the left or right). Files are in the Files panel, databases are in the
Applications panel.

I thought he meant those buttons just to the left of the window, where the
line number, auto-complete, etc are in CF Studio.

-Vern 

-Original Message-
From: Matthew Walker
To: CF-Talk
Sent: 5/8/2002 9:04 PM
Subject: RE: Fw: Oh man, no more HomeSite/CFStudio, for real :-(

He meant the tree on the left.

> > Can you use the old file browser from studio?  The one in DWMX takes
up 
too 
much room. 

> Well, the one in Studio used IE. There really isn't one in DWMX, you
preview a temp file in your own external browsers. This is probably one of
the areas it will take some effort for CFers to get used to, and we can hope
for improvment in this area in future revs.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: light editor (was: oh, man)

[Pete Ruckelshaus]

I'm going to crawl back into my hole now.

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

Insert statement using '#session.arrBasketLit[Request.idx][3]#',

[Dave Clay]

When using the Request.idx session variable, and the variable has an apostrophe in a 
string, it  creates the following error.

  Error Diagnostic Information
  ODBC Error Code = 37000 (Syntax error or access violation) 


  [Microsoft][ODBC SQL Server Driver][SQL Server]Line 21: Incorrect syntax near 
'l'. 



  The error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (75:1) to (75:65).
 

Anyone know how to work around this?  You help would be appreciated.

Dave Clay
Trusjoist.com

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

OT:SQL Question

[Paul Giesenhagen]

I have two tables I am trying to join, one is a header and one is the links
under that header.

header table:
id, header

links table
id, headerid, link, link_title

I am writing a join query to pull up all the headers and the links that go
with a particular header, but I if there are no links associated with the
header, it won't display anything.  I want it to show the headers with 0
links or with 100 links associated.


Query is:


select h.id, h.header,  l.link, l.link_title
from headers h, links l
where f.sub_object = l.headerid
and f.sub_object = h.id
group by h.header, f.state, f.sort, l.link, l.link_title, h.id


Any help would be appreciated.

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder

__
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

Fw: CF Studio 5.0 Favorites Folder.

[David Brown]

I have 2 servers both running CF 5.0 pro.  I have favorites setup for both servers to 
different folders using RDS.  The favorites work fine one server and only get me to 
the drive letter on the other server.

Any idea why it would work on one, but not 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

RE: light editor (was: oh, man)

[Joshua Miller]

Hehehe ... Not a bad idea - I see where you're coming from, personally I
think all software should be free if it's not being used for profit.
Then we wouldn't have to worry about the free sites and community sites.

As a side note, we do FULL CF hosting for $16.95 a month - not too
fancy, but it'll get you full tag support and Access or mySQL database.

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 09, 2002 2:00 PM
To: CF-Talk
Subject: Re: light editor (was: oh, man)


I'm going to crawl back into my hole now.

Pete

__
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: SQL Question

[Van Vliet, Scott]

With SQL Server, you would do a LEFT JOIN:


select h.id, h.header,  l.link, l.link_title
from headers h LEFT JOIN links l ON f.sub_object = l.headerid
where f.sub_object = h.id
group by h.header, f.state, f.sort, l.link, l.link_title, h.id


Which DB are you using?

--
Scott Van Vliet
Sempra Energy
555 W. 5th St., 21st Floor
Los Angeles, CA 90013
Tel > 213.244.5205
Email > [EMAIL PROTECTED]




> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 11:04 AM
> To: CF-Talk
> Subject: OT:SQL Question
> 
> 
> I have two tables I am trying to join, one is a header and 
> one is the links
> under that header.
> 
> header table:
> id, header
> 
> links table
> id, headerid, link, link_title
> 
> I am writing a join query to pull up all the headers and the 
> links that go
> with a particular header, but I if there are no links 
> associated with the
> header, it won't display anything.  I want it to show the 
> headers with 0
> links or with 100 links associated.
> 
> 
> Query is:
> 
> 
> select h.id, h.header,  l.link, l.link_title
> from headers h, links l
> where f.sub_object = l.headerid
> and f.sub_object = h.id
> group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> 
> 
> Any help would be appreciated.
> 
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
> 
> 
__
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: taxes... shipping or billing address?

[Alex]

shipping

On Thu, 9 May 2002, chad wrote:

> When applying state taxes to an order do you apply the taxes according to 
> the shipping address or billing address?
> 
> I would think it would be billing...
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Turning a query recordset into a comma-delimited string/file

[Brook Davies]

How well would the CSVFormat function work on a 20,. result recordset 
with, say 10 fields?

Any ideas? I have been using the Query2Excel Custom tag and it is way to 
slow for this size of operation. I hope this is better!

Brook

At 10:52 AM 09/05/02 -0600, you wrote:
>Sweet! Did the trick. I was considering converting my process (which was
>similar, but not as well done) to CFSCRIPT, but wanted to find something
>better... and this was it. Many thanks Jim :)
>
>- Original Message -
>From: "Jim Curran" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, May 09, 2002 10:26 AM
>Subject: RE: Turning a query recordset into a comma-delimited string/file
>
>
> > http://www.cflib.org/udf.cfm?ID=404
>
>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Question

[Cantrell, Adam]

SELECT h.id, h.header,  l.link, l.link_title
FROM headers h, links l
WHERE h.id *= l.headerid

//notice the star on the left side of the = in the condition


Adam.


> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:04 PM
> To: CF-Talk
> Subject: OT:SQL Question
> 
> 
> I have two tables I am trying to join, one is a header and 
> one is the links
> under that header.
> 
> header table:
> id, header
> 
> links table
> id, headerid, link, link_title
> 
> I am writing a join query to pull up all the headers and the 
> links that go
> with a particular header, but I if there are no links 
> associated with the
> header, it won't display anything.  I want it to show the 
> headers with 0
> links or with 100 links associated.
> 
> 
> Query is:
> 
> 
> select h.id, h.header,  l.link, l.link_title
> from headers h, links l
> where f.sub_object = l.headerid
> and f.sub_object = h.id
> group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> 
> 
> Any help would be appreciated.
> 
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
> 
> 
__
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

udf help

[Deanna Schneider]

Hi Folks,
I'm trying to modify Raymond Camden's highlight udf to allow for multiple
terms, and I'm not having a lot of luck. But, I've never written a udf,
so

Here's where I'm at so far, basically, my thinking is that I have to loop
over the regular expression for each term passed in, yes? But, it's not
working - doesn't throw an error, but doesn't highlight anything either.
(Yes, I realize that only the Not matchase part would loop right now...one
piece at a time.)

function highLight(str,word) {
 var front = "";
 var i = 0;
 var back = "";
 var matchCase = false;
 if(ArrayLen(arguments) GTE 3) front = arguments[3];
 if(ArrayLen(arguments) GTE 4) back = arguments[4];
 if(ArrayLen(arguments) GTE 5) matchCase = arguments[5];
 if(NOT matchCase)
 for(i=1; i lt listlen(word, " "); i = i + 1)
 return REReplaceNoCase(str,"#listgetat(word,i)#","#front#\1#back#","ALL");


 else return REReplace(str,"(#word#)","#front#\1#back#","ALL");

}


Deanna Schneider
Interactive Media Developer
[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: SQL Question

[Paul Giesenhagen]

Let me paste a more detailed query, I am now realizing that I needed to put
more online...

I am testing on MS SQL Server, but want it to be generic enough to work with
Oracle and others if possible.



select h.id, h.header, f.state, f.sort, l.link, l.link_title
from headers h, fusion f, link l
f.sub_object = l.headerid
where f.owner = '#prefs.indexid#'
and f.sub_object = h.id
group by h.header, f.state, f.sort, l.link, l.link_title, h.id


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

WYSIWYG-cross browser

[Ray Bujarski]

Does anyone know of a good cross browser wysiwyg editor?  Do they even 
exist?  Unfortunately, I work with a shop that is dominated by netscape.

Ray Bujarski
858-845-7669
858-636-9900 pgr
[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: Insert statement using '#session.arrBasketLit[Request.idx][3]#',

[Jim Gurfein]

I had a similar problem recently and fixed it by setting a new variable... eg:


It seemed to escape the single quote... good luck

At 11:59 AM 5/9/02 -0600, you wrote:
>When using the Request.idx session variable, and the variable has an 
>apostrophe in a string, it  creates the following error.
>
>   Error Diagnostic Information
>   ODBC Error Code = 37000 (Syntax error or access violation)
>
>
>   [Microsoft][ODBC SQL Server Driver][SQL Server]Line 21: Incorrect 
> syntax near 'l'.
>
>
>
>   The error occurred while processing an element with a general 
> identifier of (CFQUERY), occupying document position (75:1) to (75:65).
>
>
>Anyone know how to work around this?  You help would be appreciated.
>
>Dave Clay
>Trusjoist.com
>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: WYSIWYG-cross browser

[Drew Harris]

Are you looking for one that will work as part of a web application?
Does it also need to be cross platform?
-Drew Harris

On 5/9/02 1:19 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:

> Does anyone know of a good cross browser wysiwyg editor?  Do they even
> exist?  Unfortunately, I work with a shop that is dominated by netscape.
> 
> Ray Bujarski
> 858-845-7669
> 858-636-9900 pgr
> [EMAIL PROTECTED]
> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: WYSIWYG-cross browser

[Reuben Poon]

Try Ektron's eWebEditPro.  It's the best editor out there that I've found.  

Reuben Poon


-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 11:20 AM
To: CF-Talk
Subject: WYSIWYG-cross browser
Importance: Low


Does anyone know of a good cross browser wysiwyg editor?  Do they even 
exist?  Unfortunately, I work with a shop that is dominated by netscape.

Ray Bujarski
858-845-7669
858-636-9900 pgr
[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: WYSIWYG-cross browser

[Ray Bujarski]

Yes, it will need to work with in Netscape and IE/Windows and UNIX.


At 01:26 PM 5/9/2002 -0500, you wrote:
>Are you looking for one that will work as part of a web application?
>Does it also need to be cross platform?
>-Drew Harris
>
>On 5/9/02 1:19 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:
>
> > Does anyone know of a good cross browser wysiwyg editor?  Do they even
> > exist?  Unfortunately, I work with a shop that is dominated by netscape.
> >
> > Ray Bujarski
> > 858-845-7669
> > 858-636-9900 pgr
> > [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: SQL Question

[Paul Giesenhagen]

Adam,

Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?)

Thanks that is working beautifully!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder



> SELECT h.id, h.header,  l.link, l.link_title
> FROM headers h, links l
> WHERE h.id *= l.headerid
> 
> //notice the star on the left side of the = in the condition
> 
> 
> Adam.
> 
> 
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:04 PM
> > To: CF-Talk
> > Subject: OT:SQL Question
> > 
> > 
> > I have two tables I am trying to join, one is a header and 
> > one is the links
> > under that header.
> > 
> > header table:
> > id, header
> > 
> > links table
> > id, headerid, link, link_title
> > 
> > I am writing a join query to pull up all the headers and the 
> > links that go
> > with a particular header, but I if there are no links 
> > associated with the
> > header, it won't display anything.  I want it to show the 
> > headers with 0
> > links or with 100 links associated.
> > 
> > 
> > Query is:
> > 
> > 
> > select h.id, h.header,  l.link, l.link_title
> > from headers h, links l
> > where f.sub_object = l.headerid
> > and f.sub_object = h.id
> > group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> > 
> > 
> > Any help would be appreciated.
> > 
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> > 
> > 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Turning a query recordset into a comma-delimited string/file

[Scott Weikert]

Well these are rough estimates, and your server performance may vary - but
in my testing, a recordset with about 20 fields, and just under 3000
records, the file that ran this through CSVFormat (among some other
functions beforehand, which take up part of the total) ran around 35
seconds.

But the server I'm running this on (our dev server) isn't the
hardest-hitting box out there, either. Your mileage may vary.

- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 12:25 PM
Subject: Re: Turning a query recordset into a comma-delimited string/file


> How well would the CSVFormat function work on a 20,. result recordset
> with, say 10 fields?
>
> Any ideas? I have been using the Query2Excel Custom tag and it is way to
> slow for this size of operation. I hope this is better!


__
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[2]: DWMX Install w/o RDS?

[Debbie Dickerson]

Dreamweaver is actually not really related to why you see the change from it being 
called "Allaire FTP & RDS" to "Macromedia FTP & RDS". That change was made in CF 
Studio 5 (which was released post-merger). If you had upgraded to Studio 5 at some 
point, you would have seen that same change without Dreamweaver ever being installed 
onto the machine.

Deb

- Original Message -
From: "Critz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 12:31 PM
Subject: Re[2]: DWMX Install w/o RDS?


> oi Scott!!
>
> ah. mine were already labeled as macro
>
> disregard previous message
>
>
> --
> Critz
> Certified Adv. ColdFusion Developer
>
> Crit[s2k] - 
> 
> Thursday, May 9, 2002, 12:22:24 PM, you wrote:
>
> >> i never lost my rds settings.
>
> VVS> But did it switch to Macromedia FTP & RDS, or did it stay as Allaire
FTP &
> VVS> RDS?  On the beta machine that I installed it on, it wipped by
Allaire
> VVS> version and replaced it with the Macromedia version (which is not
working
> VVS> for me), however it did keep the settings, suhc as the RDS and FTP
sites I
> VVS> had configured.
>
> VVS> Thanks!
>
> VVS> --
> VVS> Scott Van Vliet
> VVS> Sempra Energy
> VVS> 555 W. 5th St., 21st Floor
> VVS> Los Angeles, CA 90013
> Tel >> 213.244.5205
> Email >> [EMAIL PROTECTED]
>
>
> VVS>
> 
__
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: SQL Question

[Cantrell, Adam]

I can say that it's ANSI 92 compliant and that it works on SQL
server/Access. It's just a short way of saying:

SELECT h.id, h.header,  l.link, l.link_title
FROM headers h LEFT OUTER JOIN links l
ON h.id = l.headerid

To me, the other way is more simple to digest, but this might be a better
approach if you're looking for portability.

Adam.


> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: SQL Question
> 
> 
> Adam,
> 
> Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?)
> 
> Thanks that is working beautifully!
> 
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
> 
> 
> 
> > SELECT h.id, h.header,  l.link, l.link_title
> > FROM headers h, links l
> > WHERE h.id *= l.headerid
> > 
> > //notice the star on the left side of the = in the condition
> > 
> > 
> > Adam.
> > 
> > 
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:04 PM
> > > To: CF-Talk
> > > Subject: OT:SQL Question
> > > 
> > > 
> > > I have two tables I am trying to join, one is a header and 
> > > one is the links
> > > under that header.
> > > 
> > > header table:
> > > id, header
> > > 
> > > links table
> > > id, headerid, link, link_title
> > > 
> > > I am writing a join query to pull up all the headers and the 
> > > links that go
> > > with a particular header, but I if there are no links 
> > > associated with the
> > > header, it won't display anything.  I want it to show the 
> > > headers with 0
> > > links or with 100 links associated.
> > > 
> > > 
> > > Query is:
> > > 
> > > 
> > > select h.id, h.header,  l.link, l.link_title
> > > from headers h, links l
> > > where f.sub_object = l.headerid
> > > and f.sub_object = h.id
> > > group by h.header, f.state, f.sort, l.link, 
> l.link_title, h.id
> > > 
> > > 
> > > Any help would be appreciated.
> > > 
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > > 
> > > 
> > 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: WYSIWYG-cross browser

[Drew Harris]

Boy, that's a biggie.
I've used ActiveEdit by cfdev
However I know it does not work on the mac
So I would presume it will not work on Unix.
You could always roll your own using a Flash front end and a CF backend...

-Drew

On 5/9/02 1:28 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:

> Yes, it will need to work with in Netscape and IE/Windows and UNIX.
> 
> 
> At 01:26 PM 5/9/2002 -0500, you wrote:
>> Are you looking for one that will work as part of a web application?
>> Does it also need to be cross platform?
>> -Drew Harris
>> 
>> On 5/9/02 1:19 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:
>> 
>>> Does anyone know of a good cross browser wysiwyg editor?  Do they even
>>> exist?  Unfortunately, I work with a shop that is dominated by netscape.
>>> 
>>> Ray Bujarski
>>> 858-845-7669
>>> 858-636-9900 pgr
>>> [EMAIL PROTECTED]
>>> 
>>> 
>> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: WYSIWYG-cross browser

[Ray Bujarski]

I figured as much when I did a look up on wysiwyg editors.  Everything 
seemed to only be tailored to IE.

At 01:54 PM 5/9/2002 -0500, you wrote:
>Boy, that's a biggie.
>I've used ActiveEdit by cfdev
>However I know it does not work on the mac
>So I would presume it will not work on Unix.
>You could always roll your own using a Flash front end and a CF backend...
>
>-Drew
>
>On 5/9/02 1:28 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:
>
> > Yes, it will need to work with in Netscape and IE/Windows and UNIX.
> >
> >
> > At 01:26 PM 5/9/2002 -0500, you wrote:
> >> Are you looking for one that will work as part of a web application?
> >> Does it also need to be cross platform?
> >> -Drew Harris
> >>
> >> On 5/9/02 1:19 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:
> >>
> >>> Does anyone know of a good cross browser wysiwyg editor?  Do they even
> >>> exist?  Unfortunately, I work with a shop that is dominated by netscape.
> >>>
> >>> Ray Bujarski
> >>> 858-845-7669
> >>> 858-636-9900 pgr
> >>> [EMAIL PROTECTED]
> >>>
> >>>
> >>
> >
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

sign up for FlashCoders?

[mynews]

Anyone know the URL to sign up for Brendan Hall's FlashCoders 
listserv?

BJ

___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Question

[Dina Hess]

paul,

it's my understanding that the *= syntax is legacy syntax; i
believe you'll want ansi syntax to effect compatibility with a
most dbms's:

SELECT h.id, h.header,  l.link, l.link_title
FROM headers h LEFT JOIN links l ON h.id = l.headerid

~ dina



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 1:35 PM
Subject: Re: SQL Question


> Adam,
>
> Is the *= universal syntax (MS SQL, Access, Oracle, MySQL
ect..?)
>
> Thanks that is working beautifully!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
> > SELECT h.id, h.header,  l.link, l.link_title
> > FROM headers h, links l
> > WHERE h.id *= l.headerid
> >
> > //notice the star on the left side of the = in the condition
> >
> >
> > Adam.
> >
> >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:04 PM
> > > To: CF-Talk
> > > Subject: OT:SQL Question
> > >
> > >
> > > I have two tables I am trying to join, one is a header and
> > > one is the links
> > > under that header.
> > >
> > > header table:
> > > id, header
> > >
> > > links table
> > > id, headerid, link, link_title
> > >
> > > I am writing a join query to pull up all the headers and
the
> > > links that go
> > > with a particular header, but I if there are no links
> > > associated with the
> > > header, it won't display anything.  I want it to show the
> > > headers with 0
> > > links or with 100 links associated.
> > >
> > >
> > > Query is:
> > >
> > > 
> > > select h.id, h.header,  l.link, l.link_title
> > > from headers h, links l
> > > where f.sub_object = l.headerid
> > > and f.sub_object = h.id
> > > group by h.header, f.state, f.sort, l.link,
l.link_title, h.id
> > > 
> > >
> > > Any help would be appreciated.
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> >
>

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: sign up for FlashCoders?

[Cantrell, Adam]

http://chattyfig.figleaf.com

signed up today :)

Adam.



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 2:04 PM
> To: CF-Talk
> Subject: sign up for FlashCoders?
> 
> 
> Anyone know the URL to sign up for Brendan Hall's FlashCoders 
> listserv?
> 
> BJ
> 
> ___
> Sent by ePrompter, the premier email notification software.
> Free download at http://www.ePrompter.com.
> 
> 
__
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: SQL Question

[Rob Baxter]

The older Transact SQL syntax (*=) is pretty widely supported, but as Adam
suggested for portability (and IMO readability) it is better to use the ANSI
SQL syntax (LEFT OUTER JOIN).

In addition, both Microsoft and Sybase reccommend using ANSI style joins.

http://www.microsoft.com/sql/using/tips/development/July23.asp





-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:35 PM
To: CF-Talk
Subject: Re: SQL Question


Adam,

Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?)

Thanks that is working beautifully!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder



> SELECT h.id, h.header,  l.link, l.link_title
> FROM headers h, links l
> WHERE h.id *= l.headerid
>
> //notice the star on the left side of the = in the condition
>
>
> Adam.
>
>
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:04 PM
> > To: CF-Talk
> > Subject: OT:SQL Question
> >
> >
> > I have two tables I am trying to join, one is a header and
> > one is the links
> > under that header.
> >
> > header table:
> > id, header
> >
> > links table
> > id, headerid, link, link_title
> >
> > I am writing a join query to pull up all the headers and the
> > links that go
> > with a particular header, but I if there are no links
> > associated with the
> > header, it won't display anything.  I want it to show the
> > headers with 0
> > links or with 100 links associated.
> >
> >
> > Query is:
> >
> > 
> > select h.id, h.header,  l.link, l.link_title
> > from headers h, links l
> > where f.sub_object = l.headerid
> > and f.sub_object = h.id
> > group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> > 
> >
> > Any help would be appreciated.
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
>

__
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: sign up for FlashCoders?

[mynews]

Great Thanks!

= = = Original message = = =

http://chattyfig.figleaf.com

signed up today :)

Adam.



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 2:04 PM
> To: CF-Talk
> Subject: sign up for FlashCoders?
> 
> 
> Anyone know the URL to sign up for Brendan Hall's FlashCoders 

> listserv?
> 
> BJ
> 
> ___
> Sent by ePrompter, the premier email notification software.
> Free download at http://www.ePrompter.com.
> 
> 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Question

[Paul Giesenhagen]

That being the case, what about this query?


select h.id, h.header, f.state, f.sort, l.link, l.link_title
from headers h, fusion f, link l
f.sub_object = l.headerid
where f.owner = '#prefs.indexid#'
and f.sub_object = h.id
group by h.header, f.state, f.sort, l.link, l.link_title, h.id


There are more then two tables involved here..  You can't outer join on
joined tables...




> The older Transact SQL syntax (*=) is pretty widely supported, but as Adam
> suggested for portability (and IMO readability) it is better to use the
ANSI
> SQL syntax (LEFT OUTER JOIN).
>
> In addition, both Microsoft and Sybase reccommend using ANSI style joins.
>
> http://www.microsoft.com/sql/using/tips/development/July23.asp
>
>
> 
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 2:35 PM
> To: CF-Talk
> Subject: Re: SQL Question
>
>
> Adam,
>
> Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?)
>
> Thanks that is working beautifully!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
> > SELECT h.id, h.header,  l.link, l.link_title
> > FROM headers h, links l
> > WHERE h.id *= l.headerid
> >
> > //notice the star on the left side of the = in the condition
> >
> >
> > Adam.
> >
> >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:04 PM
> > > To: CF-Talk
> > > Subject: OT:SQL Question
> > >
> > >
> > > I have two tables I am trying to join, one is a header and
> > > one is the links
> > > under that header.
> > >
> > > header table:
> > > id, header
> > >
> > > links table
> > > id, headerid, link, link_title
> > >
> > > I am writing a join query to pull up all the headers and the
> > > links that go
> > > with a particular header, but I if there are no links
> > > associated with the
> > > header, it won't display anything.  I want it to show the
> > > headers with 0
> > > links or with 100 links associated.
> > >
> > >
> > > Query is:
> > >
> > > 
> > > select h.id, h.header,  l.link, l.link_title
> > > from headers h, links l
> > > where f.sub_object = l.headerid
> > > and f.sub_object = h.id
> > > group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> > > 
> > >
> > > Any help would be appreciated.
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> >
>
> 
__
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

Excel

[Thane Sherrington]

I don't have the option to use CFObject to work with Excel (it's not on the 
server) so I'm trying to use CFContent.  This works for basic stuff, but 
I'm wondering if I can a)create charts through it, or b)add to a precreated 
workbook so that I can set up the charts to pull data from the cells I fill 
in with CFContent.

Any help would be greatly appreciated.  (I've a customer who's wedded to 
radar charts so I'm trying to get one that works.)


T

__
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

cfsavecontent

[David Schmidt]

Does using cfsavecontent cause excess overhead / memory usage on the server
during a page request?  I suspect that it would set thisTag.generatedContent
to null, which is fine for after the end tag is encounted.  But the question
really is "Does the start tag cause a new variable to be created, containing
the contents of the wrapped code as it processes? Or is it simply copied to
the memory space after the content is completely generated?".  Does anyone
have inside knowledge on this one?


Thanks,

Dave Schmidt



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

[Eric Dawson]

you can create an excel spreadsheet that uses a "web query" to get data for 
charts etc. simpler than even cfcontent if it does the trick for ya. I can 
do a sample file so you can see it work - need a little time. hr or two.

I think web query is pretty good for picky up small amounts of data.

HTH
Eric


From: Thane Sherrington <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Excel
Date: Thu, 09 May 2002 16:17:08 -0300

I don't have the option to use CFObject to work with Excel (it's not on the
server) so I'm trying to use CFContent.  This works for basic stuff, but
I'm wondering if I can a)create charts through it, or b)add to a precreated
workbook so that I can set up the charts to pull data from the cells I fill
in with CFContent.

Any help would be greatly appreciated.  (I've a customer who's wedded to
radar charts so I'm trying to get one that works.)


T


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Excel

[Thane Sherrington]

At 02:20 PM 09/05/02 -0500, Eric Dawson wrote:
>you can create an excel spreadsheet that uses a "web query" to get data for
>charts etc. simpler than even cfcontent if it does the trick for ya. I can
>do a sample file so you can see it work - need a little time. hr or two.

That would be excellent.  I never thought of using a web query.

T

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Excel

[Douglas Brown]

http://www.cfcomet.com/cfcomet/Excel/index.cfm?ArticleID=87AB3CF6-
22AC-49C3-AB33B25C754DF301








Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Thane Sherrington" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 12:17 PM
Subject: Excel


> I don't have the option to use CFObject to work with Excel (it's
not on the
> server) so I'm trying to use CFContent.  This works for basic
stuff, but
> I'm wondering if I can a)create charts through it, or b)add to a
precreated
> workbook so that I can set up the charts to pull data from the
cells I fill
> in with CFContent.
>
> Any help would be greatly appreciated.  (I've a customer who's
wedded to
> radar charts so I'm trying to get one that works.)
>
>
> T
>
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Excel

[Thane Sherrington]

At 12:31 PM 09/05/02 -0700, Douglas Brown wrote:
>http://www.cfcomet.com/cfcomet/Excel/index.cfm?ArticleID=87AB3CF6-
>22AC-49C3-AB33B25C754DF301

I have this working (and working beautifully on my development machine) but 
when I moved it to my hosted space, it fails, I think because Excel isn't 
installed on the hosting company's server.  (I wept bitter tears when I 
realized this - but it was my own fault for not testing a simple page 
before putting in the work.)

(If there's a way to do this without Excel installed on the server, I'd 
love to hear about it.)

T

__
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: SQL Question

[Cantrell, Adam]

Is fusion your cross-reference table between headers and link?

Adam.



> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 2:15 PM
> To: CF-Talk
> Subject: Re: SQL Question
> 
> 
> That being the case, what about this query?
> 
> 
> select h.id, h.header, f.state, f.sort, l.link, l.link_title
> from headers h, fusion f, link l
> f.sub_object = l.headerid
> where f.owner = '#prefs.indexid#'
> and f.sub_object = h.id
> group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> 
> 
> There are more then two tables involved here..  You can't 
> outer join on
> joined tables...
> 
> 
> 
> 
> > The older Transact SQL syntax (*=) is pretty widely 
> supported, but as Adam
> > suggested for portability (and IMO readability) it is 
> better to use the
> ANSI
> > SQL syntax (LEFT OUTER JOIN).
> >
> > In addition, both Microsoft and Sybase reccommend using 
> ANSI style joins.
> >
> > http://www.microsoft.com/sql/using/tips/development/July23.asp
> >
> >
> > 
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 2:35 PM
> > To: CF-Talk
> > Subject: Re: SQL Question
> >
> >
> > Adam,
> >
> > Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?)
> >
> > Thanks that is working beautifully!
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> > > SELECT h.id, h.header,  l.link, l.link_title
> > > FROM headers h, links l
> > > WHERE h.id *= l.headerid
> > >
> > > //notice the star on the left side of the = in the condition
> > >
> > >
> > > Adam.
> > >
> > >
> > > > -Original Message-
> > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 1:04 PM
> > > > To: CF-Talk
> > > > Subject: OT:SQL Question
> > > >
> > > >
> > > > I have two tables I am trying to join, one is a header and
> > > > one is the links
> > > > under that header.
> > > >
> > > > header table:
> > > > id, header
> > > >
> > > > links table
> > > > id, headerid, link, link_title
> > > >
> > > > I am writing a join query to pull up all the headers and the
> > > > links that go
> > > > with a particular header, but I if there are no links
> > > > associated with the
> > > > header, it won't display anything.  I want it to show the
> > > > headers with 0
> > > > links or with 100 links associated.
> > > >
> > > >
> > > > Query is:
> > > >
> > > > 
> > > > select h.id, h.header,  l.link, l.link_title
> > > > from headers h, links l
> > > > where f.sub_object = l.headerid
> > > > and f.sub_object = h.id
> > > > group by h.header, f.state, f.sort, l.link, 
> l.link_title, h.id
> > > > 
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > Paul Giesenhagen
> > > > QuillDesign
> > > > http://www.quilldesign.com
> > > > SiteDirector Commerce Builder
> > > >
> > > >
> > >
> >
> > 
> 
__
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: Excel

[Thane Sherrington]

At 02:20 PM 09/05/02 -0500, Eric Dawson wrote:
>you can create an excel spreadsheet that uses a "web query" to get data for
>charts etc. simpler than even cfcontent if it does the trick for ya. I can
>do a sample file so you can see it work - need a little time. hr or two.

I think this will really work!  I've just created a web query (amazing what 
one can do when one puts one's mind to it) and it's pulling in 
data.  You're a godsend!

Thanks,

T

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Question

[Dina Hess]

paul,

try this:

 
   select h.id, h.header, f.state, f.sort, l.link,
l.link_title
from headers h left join fusion f on h.id=f.sub_object
left join link l on f.sub_object = l.headerid
where f.owner = '#prefs.indexid#'
group by h.header, f.state, f.sort, l.link, l.link_title,
h.id
 

~ dina



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 2:15 PM
Subject: Re: SQL Question


> That being the case, what about this query?
>
> 
> select h.id, h.header, f.state, f.sort, l.link,
l.link_title
> from headers h, fusion f, link l
> f.sub_object = l.headerid
> where f.owner = '#prefs.indexid#'
> and f.sub_object = h.id
> group by h.header, f.state, f.sort, l.link,
l.link_title, h.id
> 
>
> There are more then two tables involved here..  You can't outer
join on
> joined tables...
>
>
>
>
> > The older Transact SQL syntax (*=) is pretty widely
supported, but as Adam
> > suggested for portability (and IMO readability) it is better
to use the
> ANSI
> > SQL syntax (LEFT OUTER JOIN).
> >
> > In addition, both Microsoft and Sybase reccommend using ANSI
style joins.
> >
> >
http://www.microsoft.com/sql/using/tips/development/July23.asp
> >
> >
> > 
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 2:35 PM
> > To: CF-Talk
> > Subject: Re: SQL Question
> >
> >
> > Adam,
> >
> > Is the *= universal syntax (MS SQL, Access, Oracle, MySQL
ect..?)
> >
> > Thanks that is working beautifully!
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> > > SELECT h.id, h.header,  l.link, l.link_title
> > > FROM headers h, links l
> > > WHERE h.id *= l.headerid
> > >
> > > //notice the star on the left side of the = in the
condition
> > >
> > >
> > > Adam.
> > >
> > >
> > > > -Original Message-
> > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 1:04 PM
> > > > To: CF-Talk
> > > > Subject: OT:SQL Question
> > > >
> > > >
> > > > I have two tables I am trying to join, one is a header
and
> > > > one is the links
> > > > under that header.
> > > >
> > > > header table:
> > > > id, header
> > > >
> > > > links table
> > > > id, headerid, link, link_title
> > > >
> > > > I am writing a join query to pull up all the headers and
the
> > > > links that go
> > > > with a particular header, but I if there are no links
> > > > associated with the
> > > > header, it won't display anything.  I want it to show the
> > > > headers with 0
> > > > links or with 100 links associated.
> > > >
> > > >
> > > > Query is:
> > > >
> > > > 
> > > > select h.id, h.header,  l.link, l.link_title
> > > > from headers h, links l
> > > > where f.sub_object = l.headerid
> > > > and f.sub_object = h.id
> > > > group by h.header, f.state, f.sort, l.link,
l.link_title, h.id
> > > > 
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > Paul Giesenhagen
> > > > QuillDesign
> > > > http://www.quilldesign.com
> > > > SiteDirector Commerce Builder
> > > >
> > > >
> > >
> >
> >
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Inserting and pulling CLOBS...

[Yager, Brian T Contractor/NCCIM]

Has anyone worked with CLOBS before?  I am having a devil of a time inserting
into them if the data is over 4000 characters long.  Plus, When I pull them, I
can't get the whole thing.  Does anyone have any suggestions?

I am getting this error when inserting...

"[Microsoft][ODBC driver for Oracle][Oracle]ORA-01704: string literal too long "

Thanks,

Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Question

[Ben Johnson]

Are you talking about doing something like:


select h.id, h.header, f.state, f.sort, l.link, l.link_title
from headers h
left join fusion f
on f.sub_object = l.headerid
left join link l
on f.linkID = l.linkID


You can join to an already joined table.  Just think of it as Table1 JOIN
Table2 is a whole new table.  Then the next join joins to that new table.

Or maybe I'm just missing something.  


Ben Johnson
Hostworks, Inc.


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

Re: SQL Question

[Paul Giesenhagen]

Yes,

fusion is:

id, owner, sub_object, type, sort, state

This is the whole menu system So

OWNER 1 can have SUB_objects 2,3,4,6,10 ect..

So each HEADER id will be a sub_object of the #prefs.indexid# value

I then look into the links table to grab all links associated with the
headerid value that relates to the id value in the header table and the
sub_object value in the fusion table.

Make sense?

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder



> Is fusion your cross-reference table between headers and link?
>
> Adam.
>
>
>
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 2:15 PM
> > To: CF-Talk
> > Subject: Re: SQL Question
> >
> >
> > That being the case, what about this query?
> >
> > 
> > select h.id, h.header, f.state, f.sort, l.link, l.link_title
> > from headers h, fusion f, link l
> > f.sub_object = l.headerid
> > where f.owner = '#prefs.indexid#'
> > and f.sub_object = h.id
> > group by h.header, f.state, f.sort, l.link, l.link_title, h.id
> > 
> >
> > There are more then two tables involved here..  You can't
> > outer join on
> > joined tables...
> >
> >
> >
> >
> > > The older Transact SQL syntax (*=) is pretty widely
> > supported, but as Adam
> > > suggested for portability (and IMO readability) it is
> > better to use the
> > ANSI
> > > SQL syntax (LEFT OUTER JOIN).
> > >
> > > In addition, both Microsoft and Sybase reccommend using
> > ANSI style joins.
> > >
> > > http://www.microsoft.com/sql/using/tips/development/July23.asp
> > >
> > >
> > > 
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 2:35 PM
> > > To: CF-Talk
> > > Subject: Re: SQL Question
> > >
> > >
> > > Adam,
> > >
> > > Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?)
> > >
> > > Thanks that is working beautifully!
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > >
> > > > SELECT h.id, h.header,  l.link, l.link_title
> > > > FROM headers h, links l
> > > > WHERE h.id *= l.headerid
> > > >
> > > > //notice the star on the left side of the = in the condition
> > > >
> > > >
> > > > Adam.
> > > >
> > > >
> > > > > -Original Message-
> > > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 1:04 PM
> > > > > To: CF-Talk
> > > > > Subject: OT:SQL Question
> > > > >
> > > > >
> > > > > I have two tables I am trying to join, one is a header and
> > > > > one is the links
> > > > > under that header.
> > > > >
> > > > > header table:
> > > > > id, header
> > > > >
> > > > > links table
> > > > > id, headerid, link, link_title
> > > > >
> > > > > I am writing a join query to pull up all the headers and the
> > > > > links that go
> > > > > with a particular header, but I if there are no links
> > > > > associated with the
> > > > > header, it won't display anything.  I want it to show the
> > > > > headers with 0
> > > > > links or with 100 links associated.
> > > > >
> > > > >
> > > > > Query is:
> > > > >
> > > > > 
> > > > > select h.id, h.header,  l.link, l.link_title
> > > > > from headers h, links l
> > > > > where f.sub_object = l.headerid
> > > > > and f.sub_object = h.id
> > > > > group by h.header, f.state, f.sort, l.link,
> > l.link_title, h.id
> > > > > 
> > > > >
> > > > > Any help would be appreciated.
> > > > >
> > > > > Paul Giesenhagen
> > > > > QuillDesign
> > > > > http://www.quilldesign.com
> > > > > SiteDirector Commerce Builder
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Question

[Paul Giesenhagen]

Bingo !!!  I truely appreciate the help.

I am back in the status of rookie.  We have changed our method of database
design and thus getting into all kinds of joins  so I guess it is off to
the books to do some basics!

Thanks again!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder




> paul,
>
> try this:
>
>  
>select h.id, h.header, f.state, f.sort, l.link,
> l.link_title
> from headers h left join fusion f on h.id=f.sub_object
> left join link l on f.sub_object = l.headerid
> where f.owner = '#prefs.indexid#'
> group by h.header, f.state, f.sort, l.link, l.link_title,
> h.id
>  
>
> ~ dina
>
>
>
> - Original Message -
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 09, 2002 2:15 PM
> Subject: Re: SQL Question
>
>
> > That being the case, what about this query?
> >
> > 
> > select h.id, h.header, f.state, f.sort, l.link,
> l.link_title
> > from headers h, fusion f, link l
> > f.sub_object = l.headerid
> > where f.owner = '#prefs.indexid#'
> > and f.sub_object = h.id
> > group by h.header, f.state, f.sort, l.link,
> l.link_title, h.id
> > 
> >
> > There are more then two tables involved here..  You can't outer
> join on
> > joined tables...
> >
> >
> >
> >
> > > The older Transact SQL syntax (*=) is pretty widely
> supported, but as Adam
> > > suggested for portability (and IMO readability) it is better
> to use the
> > ANSI
> > > SQL syntax (LEFT OUTER JOIN).
> > >
> > > In addition, both Microsoft and Sybase reccommend using ANSI
> style joins.
> > >
> > >
> http://www.microsoft.com/sql/using/tips/development/July23.asp
> > >
> > >
> > > 
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 2:35 PM
> > > To: CF-Talk
> > > Subject: Re: SQL Question
> > >
> > >
> > > Adam,
> > >
> > > Is the *= universal syntax (MS SQL, Access, Oracle, MySQL
> ect..?)
> > >
> > > Thanks that is working beautifully!
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > >
> > > > SELECT h.id, h.header,  l.link, l.link_title
> > > > FROM headers h, links l
> > > > WHERE h.id *= l.headerid
> > > >
> > > > //notice the star on the left side of the = in the
> condition
> > > >
> > > >
> > > > Adam.
> > > >
> > > >
> > > > > -Original Message-
> > > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 1:04 PM
> > > > > To: CF-Talk
> > > > > Subject: OT:SQL Question
> > > > >
> > > > >
> > > > > I have two tables I am trying to join, one is a header
> and
> > > > > one is the links
> > > > > under that header.
> > > > >
> > > > > header table:
> > > > > id, header
> > > > >
> > > > > links table
> > > > > id, headerid, link, link_title
> > > > >
> > > > > I am writing a join query to pull up all the headers and
> the
> > > > > links that go
> > > > > with a particular header, but I if there are no links
> > > > > associated with the
> > > > > header, it won't display anything.  I want it to show the
> > > > > headers with 0
> > > > > links or with 100 links associated.
> > > > >
> > > > >
> > > > > Query is:
> > > > >
> > > > > 
> > > > > select h.id, h.header,  l.link, l.link_title
> > > > > from headers h, links l
> > > > > where f.sub_object = l.headerid
> > > > > and f.sub_object = h.id
> > > > > group by h.header, f.state, f.sort, l.link,
> l.link_title, h.id
> > > > > 
> > > > >
> > > > > Any help would be appreciated.
> > > > >
> > > > > Paul Giesenhagen
> > > > > QuillDesign
> > > > > http://www.quilldesign.com
> > > > > SiteDirector Commerce Builder
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFENCODE Decoder

[Van Vliet, Scott]

One of my developers deleted a file w/o backing it up. *_*
Do any of you out there have one of those handy litte tools to decode a
CFENDODE.exe'ed file?  You can email me of list if you want to remain
anonymous :)
 
Thanks!

--
Scott Van Vliet
Sempra Energy
555 W. 5th St., 21st Floor
Los Angeles, CA 90013
Tel > 213.244.5205
Email > [EMAIL PROTECTED]  



 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Question

[Dina Hess]

glad that helped, paul. here's a link you may want to check out.
it's a good sql tutorial:

http://www.devguru.com/features/tutorials/AdvancedSQL/advancedSQL
html

good luck,

~ dina


- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 2:45 PM
Subject: Re: SQL Question


> Bingo !!!  I truely appreciate the help.
>
> I am back in the status of rookie.  We have changed our method
of database
> design and thus getting into all kinds of joins  so I guess
it is off to
> the books to do some basics!
>
> Thanks again!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
>
> > paul,
> >
> > try this:
> >
> >  
> >select h.id, h.header, f.state, f.sort, l.link,
> > l.link_title
> > from headers h left join fusion f on
h.id=f.sub_object
> > left join link l on f.sub_object = l.headerid
> > where f.owner = '#prefs.indexid#'
> > group by h.header, f.state, f.sort, l.link,
l.link_title,
> > h.id
> >  
> >
> > ~ dina
> >
> >
> >
> > - Original Message -
> > From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, May 09, 2002 2:15 PM
> > Subject: Re: SQL Question
> >
> >
> > > That being the case, what about this query?
> > >
> > > 
> > > select h.id, h.header, f.state, f.sort, l.link,
> > l.link_title
> > > from headers h, fusion f, link l
> > > f.sub_object = l.headerid
> > > where f.owner = '#prefs.indexid#'
> > > and f.sub_object = h.id
> > > group by h.header, f.state, f.sort, l.link,
> > l.link_title, h.id
> > > 
> > >
> > > There are more then two tables involved here..  You can't
outer
> > join on
> > > joined tables...
> > >
> > >
> > >
> > >
> > > > The older Transact SQL syntax (*=) is pretty widely
> > supported, but as Adam
> > > > suggested for portability (and IMO readability) it is
better
> > to use the
> > > ANSI
> > > > SQL syntax (LEFT OUTER JOIN).
> > > >
> > > > In addition, both Microsoft and Sybase reccommend using
ANSI
> > style joins.
> > > >
> > > >
> >
http://www.microsoft.com/sql/using/tips/development/July23.asp
> > > >
> > > >
> > > > 
> > > >
> > > >
> > > > -Original Message-
> > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 2:35 PM
> > > > To: CF-Talk
> > > > Subject: Re: SQL Question
> > > >
> > > >
> > > > Adam,
> > > >
> > > > Is the *= universal syntax (MS SQL, Access, Oracle, MySQL
> > ect..?)
> > > >
> > > > Thanks that is working beautifully!
> > > >
> > > > Paul Giesenhagen
> > > > QuillDesign
> > > > http://www.quilldesign.com
> > > > SiteDirector Commerce Builder
> > > >
> > > >
> > > >
> > > > > SELECT h.id, h.header,  l.link, l.link_title
> > > > > FROM headers h, links l
> > > > > WHERE h.id *= l.headerid
> > > > >
> > > > > //notice the star on the left side of the = in the
> > condition
> > > > >
> > > > >
> > > > > Adam.
> > > > >
> > > > >
> > > > > > -Original Message-
> > > > > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Thursday, May 09, 2002 1:04 PM
> > > > > > To: CF-Talk
> > > > > > Subject: OT:SQL Question
> > > > > >
> > > > > >
> > > > > > I have two tables I am trying to join, one is a
header
> > and
> > > > > > one is the links
> > > > > > under that header.
> > > > > >
> > > > > > header table:
> > > > > > id, header
> > > > > >
> > > > > > links table
> > > > > > id, headerid, link, link_title
> > > > > >
> > > > > > I am writing a join query to pull up all the headers
and
> > the
> > > > > > links that go
> > > > > > with a particular header, but I if there are no links
> > > > > > associated with the
> > > > > > header, it won't display anything.  I want it to show
the
> > > > > > headers with 0
> > > > > > links or with 100 links associated.
> > > > > >
> > > > > >
> > > > > > Query is:
> > > > > >
> > > > > > 
> > > > > > select h.id, h.header,  l.link, l.link_title
> > > > > > from headers h, links l
> > > > > > where f.sub_object = l.headerid
> > > > > > and f.sub_object = h.id
> > > > > > group by h.header, f.state, f.sort, l.link,
> > l.link_title, h.id
> > > > > > 
> > > > > >
> > > > > > Any help would be appreciated.
> > > > > >
> > > > > > Paul Giesenhagen
> > > > > > QuillDesign
> > > > > > http://www.quilldesign.com
> > > > > > SiteDirector Commerce Builder
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: WYSIWYG-cross browser

[Costas Piliotis]

There's been a few threads on this before.  Check the cf-talk archives.  I
think there's an applet that'll work in Nutscrape, Opera, and IE as long as
they have jvm installed...

-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 09, 2002 11:59 AM
To: CF-Talk
Subject: Re: WYSIWYG-cross browser


I figured as much when I did a look up on wysiwyg editors.  Everything 
seemed to only be tailored to IE.

At 01:54 PM 5/9/2002 -0500, you wrote:
>Boy, that's a biggie.
>I've used ActiveEdit by cfdev
>However I know it does not work on the mac
>So I would presume it will not work on Unix.
>You could always roll your own using a Flash front end and a CF 
>backend...
>
>-Drew
>
>On 5/9/02 1:28 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:
>
> > Yes, it will need to work with in Netscape and IE/Windows and UNIX.
> >
> >
> > At 01:26 PM 5/9/2002 -0500, you wrote:
> >> Are you looking for one that will work as part of a web 
> >> application? Does it also need to be cross platform? -Drew Harris
> >>
> >> On 5/9/02 1:19 PM, "Ray Bujarski" <[EMAIL PROTECTED]> wrote:
> >>
> >>> Does anyone know of a good cross browser wysiwyg editor?  Do they 
> >>> even exist?  Unfortunately, I work with a shop that is dominated 
> >>> by netscape.
> >>>
> >>> Ray Bujarski
> >>> 858-845-7669
> >>> 858-636-9900 pgr
> >>> [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

Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Hi,

 Can any one tell me what is the mistake in 



#ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#




I am getting the following error:

An error occurred while evaluating the expression: 
"#ListLen(FORM.FIELDNAMES)#"


 Any help on this is appreciated.

thanks,
Sudheer Chakka. 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Problem with comparenocase vs "is" in CFIF

[Margaret Fisk]

Hi everyone,

I'm experiencing a strange error that I can't figure out and was hoping for
some help. I've included the "problem" code below.

Here is what I'm doing:
I have a form that includes a report table. Each of the headers is a submit
button with the name sort_order and the value of the text that displays
(taken from the columnlist variable below). I also pass the previous
sort_order button in a hidden field called sort_order_hidden so if the user
choses the next 10 records, they will still be sorted by the selected value.

I started with using "is" to compare the list value for the display names
with the button value (which is the display name). However, on one of my
pages, only when passing the sort order through the hidden field (the
CFELSEIF), it does not find any matching value when running the statement
 (I displayed the results and the value
is there, but it is not considered a match. I changed to the code to  and now it matches the first value
(or when I remove the CFBREAK, the last value) in the loop even if for
example, the list item is Company Name and the Form.sort_order_hidden is
Phone.

As you can tell, I'm stumped and would appreciate any advice, assistance
etc.

Thanks in advance,
Margaret

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Reuben Poon]

If the page was called directly and not from a form submission you could get
that error because no FORM fields are defined.

Reuben Poon



-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:16 PM
To: CF-Talk
Subject: Form.FIELDNAME - error
Importance: Low


Hi,

 Can any one tell me what is the mistake in



#ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#




I am getting the following error:

An error occurred while evaluating the expression:
"#ListLen(FORM.FIELDNAMES)#"


 Any help on this is appreciated.

thanks,
Sudheer Chakka.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Jeff Brown]

make sure you're in a ...

v/r,
Jeff

-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:16 PM
To: CF-Talk
Subject: Form.FIELDNAME - error


Hi,

 Can any one tell me what is the mistake in 



#ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#




I am getting the following error:

An error occurred while evaluating the expression: 
"#ListLen(FORM.FIELDNAMES)#"


 Any help on this is appreciated.

thanks,
Sudheer Chakka. 


__
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

Execution Time

[Van Vliet, Scott]

Is there a way (perhaps in OnEndRequest.cfm) to obtain template execution
times which are show when "Show Detailed Processing Time Breakdown" is
turned on, as variables for use in a template?

Thanks!

--
Scott Van Vliet
Sempra Energy
555 W. 5th St., 21st Floor
Los Angeles, CA 90013
Tel > 213.244.5205
Email > [EMAIL PROTECTED]

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

RE: Form.FIELDNAME - error!!!!

[Jeff Brown]

i take that back, that shouldn't matter.

-Original Message-
From: Jeff Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:27 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


make sure you're in a ...

v/r,
Jeff

-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:16 PM
To: CF-Talk
Subject: Form.FIELDNAME - error


Hi,

 Can any one tell me what is the mistake in 



#ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#




I am getting the following error:

An error occurred while evaluating the expression: 
"#ListLen(FORM.FIELDNAMES)#"


 Any help on this is appreciated.

thanks,
Sudheer Chakka. 



__
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: Form.FIELDNAME - error!!!!

[Timothy Heald]

Not sure if this is an error or just a bad practice, but you don't need the
# signs in your variable declaration (cfset)



works just fine.  Also you don't need to generate that var at all you can
just do a list loop like this:


#formField# = #evaluate(formField)#


Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:16 PM
> To: CF-Talk
> Subject: Form.FIELDNAME - error
>
>
> Hi,
>
>  Can any one tell me what is the mistake in
>
>   
>   
>   #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> 
>   
>
>
> I am getting the following error:
>
> An error occurred while evaluating the expression:
> "#ListLen(FORM.FIELDNAMES)#"
>
>
>  Any help on this is appreciated.
>
> thanks,
> Sudheer Chakka.
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Getting data from excel97

[William H. Bowen]

My turn to post off-topic! Sorry!

I have an excel file that is provided to me on a semi-regular basis. It
contains names of files, their owners and version numbers.
I import the data into a table in MSSQLServer 7 using DTS, no problem
there...BUT

and there is always a but...

There is a column full of numbers in the excell file that doesn't copy
completely in to the table _unless_ I go through the column manually and
place an apostrophe in front of every number.

Oh...and non importing issue seems to happen randomly, sometimes one row,
sometimes 50.

My questions then, are these:
1. Is there a way that I can append the apostrophe to each row in that
particular column in the excel file before/during import?
2. Is there something I can do to avoid this problem altogether and import
the data properly the first time? (i.e., am I missing something?)

I think that should cover it for now.

TIA

will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

[EMAIL PROTECTED]
http://www.esca.com/


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Hi Reuben,
  
   I am submitting using "Post" method. I am using FuseBox3. Will that make
a difference??

Thanks, 
Sudheer Chakka
   
-Original Message-
From: Reuben Poon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:24 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


If the page was called directly and not from a form submission you could get
that error because no FORM fields are defined.

Reuben Poon



-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:16 PM
To: CF-Talk
Subject: Form.FIELDNAME - error
Importance: Low


Hi,

 Can any one tell me what is the mistake in



#ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#




I am getting the following error:

An error occurred while evaluating the expression:
"#ListLen(FORM.FIELDNAMES)#"


 Any help on this is appreciated.

thanks,
Sudheer Chakka.



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Getting data from excel97

[Reuben Poon]

Will,

I've had lots of problems with Excel and exporting its data.  Take a look at
the first row (or first few rows) of data in the Excel file.  If it's a
blank value or a string, then Excel will convert the entire column to that
datatype.  Sometimes you need to put data in the first few rows to get Excel
to not do this.

Not sure if this made sense or not.  Send me an email if you're still having
problems.

Reuben Poon
[ [EMAIL PROTECTED] ]



-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:31 PM
To: CF-Talk
Subject: OT: Getting data from excel97
Importance: Low


My turn to post off-topic! Sorry!

I have an excel file that is provided to me on a semi-regular basis. It
contains names of files, their owners and version numbers.
I import the data into a table in MSSQLServer 7 using DTS, no problem
there...BUT

and there is always a but...

There is a column full of numbers in the excell file that doesn't copy
completely in to the table _unless_ I go through the column manually and
place an apostrophe in front of every number.

Oh...and non importing issue seems to happen randomly, sometimes one row,
sometimes 50.

My questions then, are these:
1. Is there a way that I can append the apostrophe to each row in that
particular column in the excel file before/during import?
2. Is there something I can do to avoid this problem altogether and import
the data properly the first time? (i.e., am I missing something?)

I think that should cover it for now.

TIA

will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

[EMAIL PROTECTED]
http://www.esca.com/



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

RE: Problem with comparenocase vs "is" in CFIF

[Matt Robertson]

Maybe you left the "not" off of your "is" comparison?  Looks like it.

"NOT CompareNoCase" is equivalent to "is" or "eq"
"CompareNoCase" is equivalent to "is not" or "neq"

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


 
 
__
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: Form.FIELDNAME - error!!!!

[Paul Giesenhagen]

Tim,

I wouldn't call that bad practice, It should actually be called good
practice (at least in my book).  You are setting a variable and the ##
around the variable show that it is a variable, makes for easier reading.
Now, ## on the set side would be considered bad practice.

my .02

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder


> Not sure if this is an error or just a bad practice, but you don't need
the
> # signs in your variable declaration (cfset)
>
> 
>
> works just fine.  Also you don't need to generate that var at all you can
> just do a list loop like this:
>
> 
> #formField# = #evaluate(formField)#
> 
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
> > -Original Message-
> > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 4:16 PM
> > To: CF-Talk
> > Subject: Form.FIELDNAME - error
> >
> >
> > Hi,
> >
> >  Can any one tell me what is the mistake in
> >
> > 
> > 
> > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > 
> > 
> >
> >
> > I am getting the following error:
> >
> > An error occurred while evaluating the expression:
> > "#ListLen(FORM.FIELDNAMES)#"
> >
> >
> >  Any help on this is appreciated.
> >
> > thanks,
> > Sudheer Chakka.
> >
> >
> 
__
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: Form.FIELDNAME - error!!!!

[Timothy Heald]

I made a mistake and forgot the scope.  Also you should probably have
something to break it up so you can read it, like this:


#formField# = #evaluate('form' &formField)# 


Also someone mentioned that the cfoutput wouldn't matter, well the loop does
need to be contained inside of an output for the server to process that
section of the template and write the variables.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Timothy Heald [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:28 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> Not sure if this is an error or just a bad practice, but you
> don't need the
> # signs in your variable declaration (cfset)
>
> 
>
> works just fine.  Also you don't need to generate that var at all you can
> just do a list loop like this:
>
> 
>   #formField# = #evaluate(formField)#
> 
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
> > -Original Message-
> > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 4:16 PM
> > To: CF-Talk
> > Subject: Form.FIELDNAME - error
> >
> >
> > Hi,
> >
> >  Can any one tell me what is the mistake in
> >
> > 
> > 
> > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > 
> > 
> >
> >
> > I am getting the following error:
> >
> > An error occurred while evaluating the expression:
> > "#ListLen(FORM.FIELDNAMES)#"
> >
> >
> >  Any help on this is appreciated.
> >
> > thanks,
> > Sudheer Chakka.
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Problem with comparenocase vs "is" in CFIF

[Margaret Fisk]

Thanks for all the help I know I would have gotten, but I figured it out.

Human error of course :-)
In my columnlist, I am doing a comma delimited list but to make it more
readable, I have a space in front of the values. In my default, I didn't
include the space. It only affected this page because the other pages have
the first value as the default sort.

Sorry,
Margaret

-Original Message-
From: Margaret Fisk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:19 PM
To: CF-Talk
Subject: RE: Problem with comparenocase vs "is" in CFIF 


Hi everyone,

I'm experiencing a strange error that I can't figure out and was hoping for
some help. I've included the "problem" code below.

Here is what I'm doing:
I have a form that includes a report table. Each of the headers is a submit
button with the name sort_order and the value of the text that displays
(taken from the columnlist variable below). I also pass the previous
sort_order button in a hidden field called sort_order_hidden so if the user
choses the next 10 records, they will still be sorted by the selected value.

I started with using "is" to compare the list value for the display names
with the button value (which is the display name). However, on one of my
pages, only when passing the sort order through the hidden field (the
CFELSEIF), it does not find any matching value when running the statement
 (I displayed the results and the value
is there, but it is not considered a match. I changed to the code to  and now it matches the first value
(or when I remove the CFBREAK, the last value) in the loop even if for
example, the list item is Company Name and the Form.sort_order_hidden is
Phone.

As you can tell, I'm stumped and would appreciate any advice, assistance
etc.

Thanks in advance,
Margaret


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Reuben Poon]

Sudheer,

No, that should not make a difference.

Do you have debugging turned on?  Look at at the FORM variables in the
debugging info.  Make sure that AT LEAST ONE form variable is passed and it
is listed in the fieldnames variable.

Reuben Poon


-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:28 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error
Importance: Low


Hi Reuben,

   I am submitting using "Post" method. I am using FuseBox3. Will that make
a difference??

Thanks,
Sudheer Chakka

-Original Message-
From: Reuben Poon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:24 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


If the page was called directly and not from a form submission you could get
that error because no FORM fields are defined.

Reuben Poon



-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:16 PM
To: CF-Talk
Subject: Form.FIELDNAME - error
Importance: Low


Hi,

 Can any one tell me what is the mistake in



#ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#




I am getting the following error:

An error occurred while evaluating the expression:
"#ListLen(FORM.FIELDNAMES)#"


 Any help on this is appreciated.

thanks,
Sudheer Chakka.




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Hi Tim,
   I checked with that code also. It is giving the same error.

An error occurred while evaluating the expression: 
"#form.fieldnames#"
Error near line 3, column 17.

Thanks a lot guys for all ur time.
Sudheer Chakka.


-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:28 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


Not sure if this is an error or just a bad practice, but you don't need the
# signs in your variable declaration (cfset)



works just fine.  Also you don't need to generate that var at all you can
just do a list loop like this:


#formField# = #evaluate(formField)#


Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:16 PM
> To: CF-Talk
> Subject: Form.FIELDNAME - error
>
>
> Hi,
>
>  Can any one tell me what is the mistake in
>
>   
>   
>   #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> 
>   
>
>
> I am getting the following error:
>
> An error occurred while evaluating the expression:
> "#ListLen(FORM.FIELDNAMES)#"
>
>
>  Any help on this is appreciated.
>
> thanks,
> Sudheer Chakka.
>
> 

__
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: Form.FIELDNAME - error!!!!

[Timothy Heald]

As long as you submit the form to that page you are good.  if you try and
run the template directly then you will run into problems.  Using FB 3 will
not cause a problem like this, but it would be best practices to use
attributes scoped variables for this, not form.  The Fb 3 core files will
set all url and form variables into the attributes scope.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:28 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> Hi Reuben,
>
>I am submitting using "Post" method. I am using FuseBox3. Will
> that make
> a difference??
>
> Thanks,
> Sudheer Chakka
>
> -Original Message-
> From: Reuben Poon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 3:24 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> If the page was called directly and not from a form submission
> you could get
> that error because no FORM fields are defined.
>
> Reuben Poon
>
>
>
> -Original Message-
> From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:16 PM
> To: CF-Talk
> Subject: Form.FIELDNAME - error
> Importance: Low
>
>
> Hi,
>
>  Can any one tell me what is the mistake in
>
>   
>   
>   #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> 
>   
>
>
> I am getting the following error:
>
> An error occurred while evaluating the expression:
> "#ListLen(FORM.FIELDNAMES)#"
>
>
>  Any help on this is appreciated.
>
> thanks,
> Sudheer Chakka.
>
>
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Reuben Poon]

I think that the # on the right side of the set operand is redundant.



or



There is only one thing for *another_var* to be: a variable.  If you wanted
my_var to hold the string "another_var" you should quote the right hand
side:



So my .02 is that pounds just clutter up your statement.

Reuben Poon


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:35 PM
To: CF-Talk
Subject: Re: Form.FIELDNAME - error
Importance: Low


Tim,

I wouldn't call that bad practice, It should actually be called good
practice (at least in my book).  You are setting a variable and the ##
around the variable show that it is a variable, makes for easier reading.
Now, ## on the set side would be considered bad practice.

my .02

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder


> Not sure if this is an error or just a bad practice, but you don't need
the
> # signs in your variable declaration (cfset)
>
> 
>
> works just fine.  Also you don't need to generate that var at all you can
> just do a list loop like this:
>
> 
> #formField# = #evaluate(formField)#
> 
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
> > -Original Message-
> > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 4:16 PM
> > To: CF-Talk
> > Subject: Form.FIELDNAME - error
> >
> >
> > Hi,
> >
> >  Can any one tell me what is the mistake in
> >
> > 
> > 
> > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > 
> > 
> >
> >
> > I am getting the following error:
> >
> > An error occurred while evaluating the expression:
> > "#ListLen(FORM.FIELDNAMES)#"
> >
> >
> >  Any help on this is appreciated.
> >
> > thanks,
> > Sudheer Chakka.
> >
> >
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Data From The Mainframe & Line Ending Codes

[Gerry Pauline]

CF-Pros:

I'm trying to deal with a file generated on our mainframe with CFFILE.
I'm using CFFILE to read the contents into a variable and then parse out
the contents; CFFILE seems to be working fine.

The code is pretty standard:



The problem occurs when I try to parse out the records. I'm using the
following code, which is also pretty standard:



#row# 



A record looks like this:

01;003307198;LORE,IRENE SUSAN 
;A;6;2907;2907;;;[EMAIL PROTECTED]   
;  ; 
;A;;3601245 ;MANAGEMENT;

This is only one record, and most likely will wrap around on your screen
(the record length is 216 characters).

It seems I don't have the correct codes to indicate the end of the
records. I've tried "chr(10)" and "chr(13)" separately, and in unison,
as in the above example. 

Does anyone out there in CFExpertLand know what the correct line ending
code would be ?

Thank you.

-Gerry

Gerard T. Pauline
Mgr, Internet/DB Applications
Computer Systems, DoIT
Pace University
__
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: Form.FIELDNAME - error!!!!

[Paul Giesenhagen]

I understand your point, but it is like saying periods clutter up pages in a
book.

If you have:


That tells me that there is a variable being set and it is a string



Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?

To each his own, but it makes more sense to me to see those pounds on the
right hand side ..  Plus reading a book with periods is easier too :)

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder




> I think that the # on the right side of the set operand is redundant.
>
> 
>
> or
>
> 
>
> There is only one thing for *another_var* to be: a variable.  If you
wanted
> my_var to hold the string "another_var" you should quote the right hand
> side:
>
> 
>
> So my .02 is that pounds just clutter up your statement.
>
> Reuben Poon
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> Tim,
>
> I wouldn't call that bad practice, It should actually be called good
> practice (at least in my book).  You are setting a variable and the ##
> around the variable show that it is a variable, makes for easier reading.
> Now, ## on the set side would be considered bad practice.
>
> my .02
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
> > Not sure if this is an error or just a bad practice, but you don't need
> the
> > # signs in your variable declaration (cfset)
> >
> > 
> >
> > works just fine.  Also you don't need to generate that var at all you
can
> > just do a list loop like this:
> >
> > 
> > #formField# = #evaluate(formField)#
> > 
> >
> > Tim Heald
> > ACP/CCFD :)
> > Application Development
> > www.schoollink.net
> >
> > > -Original Message-
> > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 4:16 PM
> > > To: CF-Talk
> > > Subject: Form.FIELDNAME - error
> > >
> > >
> > > Hi,
> > >
> > >  Can any one tell me what is the mistake in
> > >
> > > 
> > > 
> > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > 
> > > 
> > >
> > >
> > > I am getting the following error:
> > >
> > > An error occurred while evaluating the expression:
> > > "#ListLen(FORM.FIELDNAMES)#"
> > >
> > >
> > >  Any help on this is appreciated.
> > >
> > > thanks,
> > > Sudheer Chakka.
> > >
> > >
> >
>
> 
__
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

OT: Using JS to intercept/prevent window close via the X button?

[Shawn Grover]

We have a situation where the user might hit the X button on a window to
close it.  We need to prompt the user to save or abort the changes they've
made, and if save is selected but the data is not valid, cancel the close.
I suspect this is not quite possible, but have seen some things that
indicate it might be.  I also think we might need to sacrifice some of this
functionality (i.e. if data is not valid, warn the user, but still close the
page...)

The following block of code DOES allow us to prevent closing the window, but
we are stuck with the MS implementation (developing for IE 5.5+) which shows
OK/Cancel buttons, and some extra text in the prompt.  This breaks the look
and feel of our app (we have our own confirmation windows we pop up).  Also,
it triggers the event if the page is only being reloaded.


MyFunction()



function MyFunction() {
event.returnvalue = "Are you sure?";
}



So, I'm looking for suggestions on how to go about this.  I'm sure someone
has handled this before.  Is there some way to do this with hidden frames?
Windows?  Is it possible to only do this when a window is in fact being
closed, not reloaded?  I think signed scripts might be required, but want to
avoid this if possible.

(if it helps any, our app has a main page, which opens up sub windows, some
modal, as required.  These sub windows might open another sub window.  But
it is typically the first sub window that we need this functionality on.
Point being, they might close a window, but not be leaving our application.)

TIA.

Shawn Grover

__
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: Getting data from excel97

[William H. Bowen]

Well, that makes sense... the first row of the column is text (used for the
column name) that may be what is happening.

Can I make references to the default names of the excel columns when
importing? (sheet1A,sheet1B,sheet1C,etc.)

will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

[EMAIL PROTECTED]
http://www.esca.com/

- Original Message -
From: "Reuben Poon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 1:34 PM
Subject: RE: Getting data from excel97


> Will,
>
> I've had lots of problems with Excel and exporting its data.  Take a look
at
> the first row (or first few rows) of data in the Excel file.  If it's a
> blank value or a string, then Excel will convert the entire column to that
> datatype.  Sometimes you need to put data in the first few rows to get
Excel
> to not do this.
>
> Not sure if this made sense or not.  Send me an email if you're still
having
> problems.
>
> Reuben Poon
> [ [EMAIL PROTECTED] ]
>
>
>
> -Original Message-
> From: William H. Bowen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:31 PM
> To: CF-Talk
> Subject: OT: Getting data from excel97
> Importance: Low
>
>
> My turn to post off-topic! Sorry!
>
> I have an excel file that is provided to me on a semi-regular basis. It
> contains names of files, their owners and version numbers.
> I import the data into a table in MSSQLServer 7 using DTS, no problem
> there...BUT
>
> and there is always a but...
>
> There is a column full of numbers in the excell file that doesn't copy
> completely in to the table _unless_ I go through the column manually and
> place an apostrophe in front of every number.
>
> Oh...and non importing issue seems to happen randomly, sometimes one row,
> sometimes 50.
>
> My questions then, are these:
> 1. Is there a way that I can append the apostrophe to each row in that
> particular column in the excel file before/during import?
> 2. Is there something I can do to avoid this problem altogether and import
> the data properly the first time? (i.e., am I missing something?)
>
> I think that should cover it for now.
>
> TIA
>
> will
> 
>
> William H. Bowen
> Webmaster
> ALSTOM's Energy Management and Markets Business
>
> [EMAIL PROTECTED]
> http://www.esca.com/
>
>
>
> 
__
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: Form.FIELDNAME - error!!!!

[Reuben Poon]

I'd like to continue this but I am relatively new to this forum.

Are these types of debates encouraged/discouraged?  Should they be taken
offline?

Reuben Poon



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:54 PM
To: CF-Talk
Subject: Re: Form.FIELDNAME - error
Importance: Low


I understand your point, but it is like saying periods clutter up pages in a
book.

If you have:


That tells me that there is a variable being set and it is a string



Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?

To each his own, but it makes more sense to me to see those pounds on the
right hand side ..  Plus reading a book with periods is easier too :)

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder




> I think that the # on the right side of the set operand is redundant.
>
> 
>
> or
>
> 
>
> There is only one thing for *another_var* to be: a variable.  If you
wanted
> my_var to hold the string "another_var" you should quote the right hand
> side:
>
> 
>
> So my .02 is that pounds just clutter up your statement.
>
> Reuben Poon
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> Tim,
>
> I wouldn't call that bad practice, It should actually be called good
> practice (at least in my book).  You are setting a variable and the ##
> around the variable show that it is a variable, makes for easier reading.
> Now, ## on the set side would be considered bad practice.
>
> my .02
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
> > Not sure if this is an error or just a bad practice, but you don't need
> the
> > # signs in your variable declaration (cfset)
> >
> > 
> >
> > works just fine.  Also you don't need to generate that var at all you
can
> > just do a list loop like this:
> >
> > 
> > #formField# = #evaluate(formField)#
> > 
> >
> > Tim Heald
> > ACP/CCFD :)
> > Application Development
> > www.schoollink.net
> >
> > > -Original Message-
> > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 4:16 PM
> > > To: CF-Talk
> > > Subject: Form.FIELDNAME - error
> > >
> > >
> > > Hi,
> > >
> > >  Can any one tell me what is the mistake in
> > >
> > > 
> > > 
> > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > 
> > > 
> > >
> > >
> > > I am getting the following error:
> > >
> > > An error occurred while evaluating the expression:
> > > "#ListLen(FORM.FIELDNAMES)#"
> > >
> > >
> > >  Any help on this is appreciated.
> > >
> > > thanks,
> > > Sudheer Chakka.
> > >
> > >
> >
>
>

__
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: Data From The Mainframe & Line Ending Codes

[Ben Johnson]

> It seems I don't have the correct codes to indicate the end of the
> records. I've tried "chr(10)" and "chr(13)" separately, and in unison,
> as in the above example.
>
> Does anyone out there in CFExpertLand know what the correct line ending
> code would be ?


You may want to use a hex editor to determine the ASCII value of the line
character.  Also, another option would to be to loop through all the
characters and do a ASC(Mid(string, position, 1)) to find unusual
characters.  Or if you can find the length of the first row, simply find the
ASC of the character right after the end.


Ben Johnson
Hostworks, Inc.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Form.FIELDNAME - error!!!!

[Douglas Brown]

Nope all discussion is encouraged!!! Unless it gets ugly




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Reuben Poon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 2:10 PM
Subject: RE: Form.FIELDNAME - error


> I'd like to continue this but I am relatively new to this forum.
>
> Are these types of debates encouraged/discouraged?  Should they
be taken
> offline?
>
> Reuben Poon
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:54 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> I understand your point, but it is like saying periods clutter
up pages in a
> book.
>
> If you have:
>
> 
> That tells me that there is a variable being set and it is a
string
>
> 
>
> Am I setting my variable to the two words seperated by a period,
> query.column? or to a variable query.column?
>
> To each his own, but it makes more sense to me to see those
pounds on the
> right hand side ..  Plus reading a book with periods is easier
too :)
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
>
> > I think that the # on the right side of the set operand is
redundant.
> >
> > 
> >
> > or
> >
> > 
> >
> > There is only one thing for *another_var* to be: a variable.
If you
> wanted
> > my_var to hold the string "another_var" you should quote the
right hand
> > side:
> >
> > 
> >
> > So my .02 is that pounds just clutter up your statement.
> >
> > Reuben Poon
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:35 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > Tim,
> >
> > I wouldn't call that bad practice, It should actually be
called good
> > practice (at least in my book).  You are setting a variable
and the ##
> > around the variable show that it is a variable, makes for
easier reading.
> > Now, ## on the set side would be considered bad practice.
> >
> > my .02
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> > > Not sure if this is an error or just a bad practice, but you
don't need
> > the
> > > # signs in your variable declaration (cfset)
> > >
> > > 
> > >
> > > works just fine.  Also you don't need to generate that var
at all you
> can
> > > just do a list loop like this:
> > >
> > > 
> > > #formField# = #evaluate(formField)#
> > > 
> > >
> > > Tim Heald
> > > ACP/CCFD :)
> > > Application Development
> > > www.schoollink.net
> > >
> > > > -Original Message-
> > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > To: CF-Talk
> > > > Subject: Form.FIELDNAME - error
> > > >
> > > >
> > > > Hi,
> > > >
> > > >  Can any one tell me what is the mistake in
> > > >
> > > > 
> > > > 
> > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > 
> > > > 
> > > >
> > > >
> > > > I am getting the following error:
> > > >
> > > > An error occurred while evaluating the expression:
> > > > "#ListLen(FORM.FIELDNAMES)#"
> > > >
> > > >
> > > >  Any help on this is appreciated.
> > > >
> > > > thanks,
> > > > Sudheer Chakka.
> > > >
> > > >
> > >
> >
> >
>
>

__
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: Form.FIELDNAME - error!!!!

[Timothy Heald]

I think as long as it has something to do with CF and you don't let your
emotions carry you away, that debate is acceptable, but I haven't seen any
cf-talk rules or a faq or anything.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Reuben Poon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:10 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> I'd like to continue this but I am relatively new to this forum.
>
> Are these types of debates encouraged/discouraged?  Should they be taken
> offline?
>
> Reuben Poon
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:54 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> I understand your point, but it is like saying periods clutter up
> pages in a
> book.
>
> If you have:
>
> 
> That tells me that there is a variable being set and it is a string
>
> 
>
> Am I setting my variable to the two words seperated by a period,
> query.column? or to a variable query.column?
>
> To each his own, but it makes more sense to me to see those pounds on the
> right hand side ..  Plus reading a book with periods is easier too :)
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
>
> > I think that the # on the right side of the set operand is redundant.
> >
> > 
> >
> > or
> >
> > 
> >
> > There is only one thing for *another_var* to be: a variable.  If you
> wanted
> > my_var to hold the string "another_var" you should quote the right hand
> > side:
> >
> > 
> >
> > So my .02 is that pounds just clutter up your statement.
> >
> > Reuben Poon
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:35 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > Tim,
> >
> > I wouldn't call that bad practice, It should actually be called good
> > practice (at least in my book).  You are setting a variable and the ##
> > around the variable show that it is a variable, makes for
> easier reading.
> > Now, ## on the set side would be considered bad practice.
> >
> > my .02
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> > > Not sure if this is an error or just a bad practice, but you
> don't need
> > the
> > > # signs in your variable declaration (cfset)
> > >
> > > 
> > >
> > > works just fine.  Also you don't need to generate that var at all you
> can
> > > just do a list loop like this:
> > >
> > > 
> > > #formField# = #evaluate(formField)#
> > > 
> > >
> > > Tim Heald
> > > ACP/CCFD :)
> > > Application Development
> > > www.schoollink.net
> > >
> > > > -Original Message-
> > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > To: CF-Talk
> > > > Subject: Form.FIELDNAME - error
> > > >
> > > >
> > > > Hi,
> > > >
> > > >  Can any one tell me what is the mistake in
> > > >
> > > > 
> > > > 
> > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > 
> > > > 
> > > >
> > > >
> > > > I am getting the following error:
> > > >
> > > > An error occurred while evaluating the expression:
> > > > "#ListLen(FORM.FIELDNAMES)#"
> > > >
> > > >
> > > >  Any help on this is appreciated.
> > > >
> > > > thanks,
> > > > Sudheer Chakka.
> > > >
> > > >
> > >
> >
> >
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Kevin Schmidt]

Extra pound signs are a pet peeve of mine as well.  You don't need them.
If you ask me, adding pound signs is like adding an additional period,
not taking one away.

Kevin


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 09, 2002 3:54 PM
To: CF-Talk
Subject: Re: Form.FIELDNAME - error

I understand your point, but it is like saying periods clutter up pages
in a
book.

If you have:


That tells me that there is a variable being set and it is a string



Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?

To each his own, but it makes more sense to me to see those pounds on
the
right hand side ..  Plus reading a book with periods is easier too :)

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder




> I think that the # on the right side of the set operand is redundant.
>
> 
>
> or
>
> 
>
> There is only one thing for *another_var* to be: a variable.  If you
wanted
> my_var to hold the string "another_var" you should quote the right
hand
> side:
>
> 
>
> So my .02 is that pounds just clutter up your statement.
>
> Reuben Poon
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> Tim,
>
> I wouldn't call that bad practice, It should actually be called good
> practice (at least in my book).  You are setting a variable and the ##
> around the variable show that it is a variable, makes for easier
reading.
> Now, ## on the set side would be considered bad practice.
>
> my .02
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
> > Not sure if this is an error or just a bad practice, but you don't
need
> the
> > # signs in your variable declaration (cfset)
> >
> > 
> >
> > works just fine.  Also you don't need to generate that var at all
you
can
> > just do a list loop like this:
> >
> > 
> > #formField# = #evaluate(formField)#
> > 
> >
> > Tim Heald
> > ACP/CCFD :)
> > Application Development
> > www.schoollink.net
> >
> > > -Original Message-
> > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 4:16 PM
> > > To: CF-Talk
> > > Subject: Form.FIELDNAME - error
> > >
> > >
> > > Hi,
> > >
> > >  Can any one tell me what is the mistake in
> > >
> > > 
> > > 
> > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > 
> > > 
> > >
> > >
> > > I am getting the following error:
> > >
> > > An error occurred while evaluating the expression:
> > > "#ListLen(FORM.FIELDNAMES)#"
> > >
> > >
> > >  Any help on this is appreciated.
> > >
> > > thanks,
> > > Sudheer Chakka.
> > >
> > >
> >
>
> 

__
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: Form.FIELDNAME - error!!!!

[Paul Giesenhagen]

:) they are common ... they get discouraged when the go on and on ...but
usually this group is very informative and you can learn alot by the
debates!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder



> I'd like to continue this but I am relatively new to this forum.
>
> Are these types of debates encouraged/discouraged?  Should they be taken
> offline?
>
> Reuben Poon
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:54 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> I understand your point, but it is like saying periods clutter up pages in
a
> book.
>
> If you have:
>
> 
> That tells me that there is a variable being set and it is a string
>
> 
>
> Am I setting my variable to the two words seperated by a period,
> query.column? or to a variable query.column?
>
> To each his own, but it makes more sense to me to see those pounds on the
> right hand side ..  Plus reading a book with periods is easier too :)
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
>
> > I think that the # on the right side of the set operand is redundant.
> >
> > 
> >
> > or
> >
> > 
> >
> > There is only one thing for *another_var* to be: a variable.  If you
> wanted
> > my_var to hold the string "another_var" you should quote the right hand
> > side:
> >
> > 
> >
> > So my .02 is that pounds just clutter up your statement.
> >
> > Reuben Poon
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:35 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > Tim,
> >
> > I wouldn't call that bad practice, It should actually be called good
> > practice (at least in my book).  You are setting a variable and the ##
> > around the variable show that it is a variable, makes for easier
reading.
> > Now, ## on the set side would be considered bad practice.
> >
> > my .02
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> > > Not sure if this is an error or just a bad practice, but you don't
need
> > the
> > > # signs in your variable declaration (cfset)
> > >
> > > 
> > >
> > > works just fine.  Also you don't need to generate that var at all you
> can
> > > just do a list loop like this:
> > >
> > > 
> > > #formField# = #evaluate(formField)#
> > > 
> > >
> > > Tim Heald
> > > ACP/CCFD :)
> > > Application Development
> > > www.schoollink.net
> > >
> > > > -Original Message-
> > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > To: CF-Talk
> > > > Subject: Form.FIELDNAME - error
> > > >
> > > >
> > > > Hi,
> > > >
> > > >  Can any one tell me what is the mistake in
> > > >
> > > > 
> > > > 
> > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > 
> > > > 
> > > >
> > > >
> > > > I am getting the following error:
> > > >
> > > > An error occurred while evaluating the expression:
> > > > "#ListLen(FORM.FIELDNAMES)#"
> > > >
> > > >
> > > >  Any help on this is appreciated.
> > > >
> > > > thanks,
> > > > Sudheer Chakka.
> > > >
> > > >
> > >
> >
> >
>
> 
__
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: Form.FIELDNAME - error!!!!

[Kevin Miller]

Regardless of what everyone thinks, it's slower to include the pounds because CF then 
has to enumerate the variable's value rather than just referring to the variable 
itself.

Kevin

>>> [EMAIL PROTECTED] 05/09/02 01:53PM >>>
I understand your point, but it is like saying periods clutter up pages in a
book.

If you have:


That tells me that there is a variable being set and it is a string



Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?

To each his own, but it makes more sense to me to see those pounds on the
right hand side ..  Plus reading a book with periods is easier too :)

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com 
SiteDirector Commerce Builder




> I think that the # on the right side of the set operand is redundant.
>
> 
>
> or
>
> 
>
> There is only one thing for *another_var* to be: a variable.  If you
wanted
> my_var to hold the string "another_var" you should quote the right hand
> side:
>
> 
>
> So my .02 is that pounds just clutter up your statement.
>
> Reuben Poon
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, May 09, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> Tim,
>
> I wouldn't call that bad practice, It should actually be called good
> practice (at least in my book).  You are setting a variable and the ##
> around the variable show that it is a variable, makes for easier reading.
> Now, ## on the set side would be considered bad practice.
>
> my .02
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com 
> SiteDirector Commerce Builder
>
>
> > Not sure if this is an error or just a bad practice, but you don't need
> the
> > # signs in your variable declaration (cfset)
> >
> > 
> >
> > works just fine.  Also you don't need to generate that var at all you
can
> > just do a list loop like this:
> >
> > 
> > #formField# = #evaluate(formField)#
> > 
> >
> > Tim Heald
> > ACP/CCFD :)
> > Application Development
> > www.schoollink.net 
> >
> > > -Original Message-
> > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] 
> > > Sent: Thursday, May 09, 2002 4:16 PM
> > > To: CF-Talk
> > > Subject: Form.FIELDNAME - error
> > >
> > >
> > > Hi,
> > >
> > >  Can any one tell me what is the mistake in
> > >
> > > 
> > > 
> > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > 
> > > 
> > >
> > >
> > > I am getting the following error:
> > >
> > > An error occurred while evaluating the expression:
> > > "#ListLen(FORM.FIELDNAMES)#"
> > >
> > >
> > >  Any help on this is appreciated.
> > >
> > > thanks,
> > > Sudheer Chakka.
> > >
> > >
> >
>
> 

__
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: Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Hi,

   That didn't solve my problem. It is not even recognising the
Form.FieldNames 


#formField# = #evaluate('form' &formField)# 


it is giving error in the first line of the above code.

Any more suggestions.

Thanks,
Sudheer Chakka.

-Original Message-
From: Reuben Poon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:44 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


I think that the # on the right side of the set operand is redundant.



or



There is only one thing for *another_var* to be: a variable.  If you wanted
my_var to hold the string "another_var" you should quote the right hand
side:



So my .02 is that pounds just clutter up your statement.

Reuben Poon


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:35 PM
To: CF-Talk
Subject: Re: Form.FIELDNAME - error
Importance: Low


Tim,

I wouldn't call that bad practice, It should actually be called good
practice (at least in my book).  You are setting a variable and the ##
around the variable show that it is a variable, makes for easier reading.
Now, ## on the set side would be considered bad practice.

my .02

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder


> Not sure if this is an error or just a bad practice, but you don't need
the
> # signs in your variable declaration (cfset)
>
> 
>
> works just fine.  Also you don't need to generate that var at all you can
> just do a list loop like this:
>
> 
> #formField# = #evaluate(formField)#
> 
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
> > -Original Message-
> > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 4:16 PM
> > To: CF-Talk
> > Subject: Form.FIELDNAME - error
> >
> >
> > Hi,
> >
> >  Can any one tell me what is the mistake in
> >
> > 
> > 
> > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > 
> > 
> >
> >
> > I am getting the following error:
> >
> > An error occurred while evaluating the expression:
> > "#ListLen(FORM.FIELDNAMES)#"
> >
> >
> >  Any help on this is appreciated.
> >
> > thanks,
> > Sudheer Chakka.
> >
> >
>


__
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: Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Well Guys,
  
   I am Sorry!! It is weird that i closed all my opened IE Browser windows
and reopened, it 
   
   worked. the same code worked !!! 
  
   Tim your code is working !! - thanks.

   Guys, Thanks for all of ur patience.

Special Thanks to Tim, Reuben , Paul  and everyone who participated in this
discussion.

Sudheer Chakka.
  



-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:15 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


I think as long as it has something to do with CF and you don't let your
emotions carry you away, that debate is acceptable, but I haven't seen any
cf-talk rules or a faq or anything.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Reuben Poon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:10 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> I'd like to continue this but I am relatively new to this forum.
>
> Are these types of debates encouraged/discouraged?  Should they be taken
> offline?
>
> Reuben Poon
>
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:54 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> I understand your point, but it is like saying periods clutter up
> pages in a
> book.
>
> If you have:
>
> 
> That tells me that there is a variable being set and it is a string
>
> 
>
> Am I setting my variable to the two words seperated by a period,
> query.column? or to a variable query.column?
>
> To each his own, but it makes more sense to me to see those pounds on the
> right hand side ..  Plus reading a book with periods is easier too :)
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
>
> > I think that the # on the right side of the set operand is redundant.
> >
> > 
> >
> > or
> >
> > 
> >
> > There is only one thing for *another_var* to be: a variable.  If you
> wanted
> > my_var to hold the string "another_var" you should quote the right hand
> > side:
> >
> > 
> >
> > So my .02 is that pounds just clutter up your statement.
> >
> > Reuben Poon
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:35 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > Tim,
> >
> > I wouldn't call that bad practice, It should actually be called good
> > practice (at least in my book).  You are setting a variable and the ##
> > around the variable show that it is a variable, makes for
> easier reading.
> > Now, ## on the set side would be considered bad practice.
> >
> > my .02
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> > > Not sure if this is an error or just a bad practice, but you
> don't need
> > the
> > > # signs in your variable declaration (cfset)
> > >
> > > 
> > >
> > > works just fine.  Also you don't need to generate that var at all you
> can
> > > just do a list loop like this:
> > >
> > > 
> > > #formField# = #evaluate(formField)#
> > > 
> > >
> > > Tim Heald
> > > ACP/CCFD :)
> > > Application Development
> > > www.schoollink.net
> > >
> > > > -Original Message-
> > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > To: CF-Talk
> > > > Subject: Form.FIELDNAME - error
> > > >
> > > >
> > > > Hi,
> > > >
> > > >  Can any one tell me what is the mistake in
> > > >
> > > > 
> > > > 
> > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > 
> > > > 
> > > >
> > > >
> > > > I am getting the following error:
> > > >
> > > > An error occurred while evaluating the expression:
> > > > "#ListLen(FORM.FIELDNAMES)#"
> > > >
> > > >
> > > >  Any help on this is appreciated.
> > > >
> > > > thanks,
> > > > Sudheer Chakka.
> > > >
> > > >
> > >
> >
> >
>
> 

__
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: udf help

[Rob Baxter]

Deanna,

I've made a few alterations to the highlight UDF which should work. It
basically uses recursion to call itself on each word of a comma delimitted
list (you should probably change this to make the delimiter an optional
parameter, I was just lazy). I've done a few basic tests and it seems to
work, but no garauntees.

One thing you need to watch out for when highlighting multiple keywords is
that if you have any keyword which is a substring of another keyword, you
may not get the correct results. There are workarouds for this, but it's
probably a pretty unlikely occurance depending on what you are using the
highlight function for. If it becomes a problem, I can tell you how I've
dealt with it in the past.

Here's the modified UDF

function highLight(str, wordList) {

var front = "";
var back = "";
var matchCase = false;

//check for empty word list, this is the base condition for the recursion
if(ListLen(wordList) Lt 1)
return str;
else
word = ListFirst(wordList);

if(ArrayLen(arguments) GTE 3) front = arguments[3];
if(ArrayLen(arguments) GTE 4) back = arguments[4];
if(ArrayLen(arguments) GTE 5) matchCase = arguments[5];


if(Not matchCase)
CurTxt = REReplaceNoCase(str,"(#word#)","#front#\1#back#","ALL");
else
CurTxt = REReplace(str,"(#word#)","#front#\1#back#","ALL");

return Highlight(CurTxt, ListRest(wordList), front, back, matchCase);

}

Let me know if it works for you


on a more personal note; I don't know if you remember me but I used to work
for UWEX in Wisplan. Say hi to Eric and Greg for me if they're still kicking
around there.



-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:18 PM
To: CF-Talk
Subject: udf help


Hi Folks,
I'm trying to modify Raymond Camden's highlight udf to allow for multiple
terms, and I'm not having a lot of luck. But, I've never written a udf,
so

Here's where I'm at so far, basically, my thinking is that I have to loop
over the regular expression for each term passed in, yes? But, it's not
working - doesn't throw an error, but doesn't highlight anything either.
(Yes, I realize that only the Not matchase part would loop right now...one
piece at a time.)

function highLight(str,word) {
 var front = "";
 var i = 0;
 var back = "";
 var matchCase = false;
 if(ArrayLen(arguments) GTE 3) front = arguments[3];
 if(ArrayLen(arguments) GTE 4) back = arguments[4];
 if(ArrayLen(arguments) GTE 5) matchCase = arguments[5];
 if(NOT matchCase)
 for(i=1; i lt listlen(word, " "); i = i + 1)
 return REReplaceNoCase(str,"#listgetat(word,i)#","#front#\1#back#","ALL");


 else return REReplace(str,"(#word#)","#front#\1#back#","ALL");

}


Deanna Schneider
Interactive Media Developer
[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: Form.FIELDNAME - error!!!!

[Timothy Heald]

Have we found out what the source of the original error is yet?  I love a
good debate, but I would really like to help out the person who started this
thread as well.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:20 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
>
>
> :) they are common ... they get discouraged when the go on and on ...but
> usually this group is very informative and you can learn alot by the
> debates!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
> > I'd like to continue this but I am relatively new to this forum.
> >
> > Are these types of debates encouraged/discouraged?  Should they be taken
> > offline?
> >
> > Reuben Poon
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:54 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > I understand your point, but it is like saying periods clutter
> up pages in
> a
> > book.
> >
> > If you have:
> >
> > 
> > That tells me that there is a variable being set and it is a string
> >
> > 
> >
> > Am I setting my variable to the two words seperated by a period,
> > query.column? or to a variable query.column?
> >
> > To each his own, but it makes more sense to me to see those
> pounds on the
> > right hand side ..  Plus reading a book with periods is easier too :)
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> >
> > > I think that the # on the right side of the set operand is redundant.
> > >
> > > 
> > >
> > > or
> > >
> > > 
> > >
> > > There is only one thing for *another_var* to be: a variable.  If you
> > wanted
> > > my_var to hold the string "another_var" you should quote the
> right hand
> > > side:
> > >
> > > 
> > >
> > > So my .02 is that pounds just clutter up your statement.
> > >
> > > Reuben Poon
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:35 PM
> > > To: CF-Talk
> > > Subject: Re: Form.FIELDNAME - error
> > > Importance: Low
> > >
> > >
> > > Tim,
> > >
> > > I wouldn't call that bad practice, It should actually be called good
> > > practice (at least in my book).  You are setting a variable and the ##
> > > around the variable show that it is a variable, makes for easier
> reading.
> > > Now, ## on the set side would be considered bad practice.
> > >
> > > my .02
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > > > Not sure if this is an error or just a bad practice, but you don't
> need
> > > the
> > > > # signs in your variable declaration (cfset)
> > > >
> > > > 
> > > >
> > > > works just fine.  Also you don't need to generate that var
> at all you
> > can
> > > > just do a list loop like this:
> > > >
> > > > 
> > > > #formField# = #evaluate(formField)#
> > > > 
> > > >
> > > > Tim Heald
> > > > ACP/CCFD :)
> > > > Application Development
> > > > www.schoollink.net
> > > >
> > > > > -Original Message-
> > > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > > To: CF-Talk
> > > > > Subject: Form.FIELDNAME - error
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >  Can any one tell me what is the mistake in
> > > > >
> > > > >  INDEX="i">
> > > > > 
> > > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > I am getting the following error:
> > > > >
> > > > > An error occurred while evaluating the expression:
> > > > > "#ListLen(FORM.FIELDNAMES)#"
> > > > >
> > > > >
> > > > >  Any help on this is appreciated.
> > > > >
> > > > > thanks,
> > > > > Sudheer Chakka.
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
> 
__
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: WYSIWYG-cross browser

[Drew Harris]

Has anyone ever used this?
http://flashkit.com/movies/Utilities/Realtime-Mike_Dog-3935/index.shtml
-Drew Harris

__
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: CFENCODE Decoder

[W Luke]

Still need it?

Will
- Original Message -
From: "Van Vliet, Scott" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Thursday, May 09, 2002 8:51 PM
Subject: CFENCODE Decoder


> One of my developers deleted a file w/o backing it up. *_*
> Do any of you out there have one of those handy litte tools to decode a
> CFENDODE.exe'ed file?  You can email me of list if you want to remain
> anonymous :)
>
> Thanks!
>
> --
> Scott Van Vliet
> Sempra Energy
> 555 W. 5th St., 21st Floor
> Los Angeles, CA 90013
> Tel > 213.244.5205
> Email > [EMAIL PROTECTED] 
>
>
>
>
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Hi Tim,

   I appreciate u r concern and U will be happy to know that i could solve
the problem by 

   closing all the opened IE browser windows and opened it and the same code
is working.

 thanks for u r offer to help.

Sudheer Chakka.

-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:25 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


Have we found out what the source of the original error is yet?  I love a
good debate, but I would really like to help out the person who started this
thread as well.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:20 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
>
>
> :) they are common ... they get discouraged when the go on and on ...but
> usually this group is very informative and you can learn alot by the
> debates!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
> > I'd like to continue this but I am relatively new to this forum.
> >
> > Are these types of debates encouraged/discouraged?  Should they be taken
> > offline?
> >
> > Reuben Poon
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:54 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > I understand your point, but it is like saying periods clutter
> up pages in
> a
> > book.
> >
> > If you have:
> >
> > 
> > That tells me that there is a variable being set and it is a string
> >
> > 
> >
> > Am I setting my variable to the two words seperated by a period,
> > query.column? or to a variable query.column?
> >
> > To each his own, but it makes more sense to me to see those
> pounds on the
> > right hand side ..  Plus reading a book with periods is easier too :)
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> >
> > > I think that the # on the right side of the set operand is redundant.
> > >
> > > 
> > >
> > > or
> > >
> > > 
> > >
> > > There is only one thing for *another_var* to be: a variable.  If you
> > wanted
> > > my_var to hold the string "another_var" you should quote the
> right hand
> > > side:
> > >
> > > 
> > >
> > > So my .02 is that pounds just clutter up your statement.
> > >
> > > Reuben Poon
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:35 PM
> > > To: CF-Talk
> > > Subject: Re: Form.FIELDNAME - error
> > > Importance: Low
> > >
> > >
> > > Tim,
> > >
> > > I wouldn't call that bad practice, It should actually be called good
> > > practice (at least in my book).  You are setting a variable and the ##
> > > around the variable show that it is a variable, makes for easier
> reading.
> > > Now, ## on the set side would be considered bad practice.
> > >
> > > my .02
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > > > Not sure if this is an error or just a bad practice, but you don't
> need
> > > the
> > > > # signs in your variable declaration (cfset)
> > > >
> > > > 
> > > >
> > > > works just fine.  Also you don't need to generate that var
> at all you
> > can
> > > > just do a list loop like this:
> > > >
> > > > 
> > > > #formField# = #evaluate(formField)#
> > > > 
> > > >
> > > > Tim Heald
> > > > ACP/CCFD :)
> > > > Application Development
> > > > www.schoollink.net
> > > >
> > > > > -Original Message-
> > > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > > To: CF-Talk
> > > > > Subject: Form.FIELDNAME - error
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >  Can any one tell me what is the mistake in
> > > > >
> > > > >  INDEX="i">
> > > > > 
> > > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > I am getting the following error:
> > > > >
> > > > > An error occurred while evaluating the expression:
> > > > > "#ListLen(FORM.FIELDNAMES)#"
> > > > >
> > > > >
> > > > >  Any help on this is appreciated.
> > > > >
> > > > > thanks,
> > > > > Sudheer Chakka.
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
> 

__
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: CFENCODE Decoder

[Van Vliet, Scott]

Got it :) Thanks for the help!

--
Scott Van Vliet
Sempra Energy
555 W. 5th St., 21st Floor
Los Angeles, CA 90013
Tel > 213.244.5205
Email > [EMAIL PROTECTED]





> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:59 PM
> To: CF-Talk
> Subject: Re: CFENCODE Decoder
> 
> 
> Still need it?
> 
> Will
> - Original Message -
> From: "Van Vliet, Scott" <[EMAIL PROTECTED]>
> Newsgroups: cf-talk
> Sent: Thursday, May 09, 2002 8:51 PM
> Subject: CFENCODE Decoder
> 
> 
> > One of my developers deleted a file w/o backing it up. *_*
> > Do any of you out there have one of those handy litte tools 
> to decode a
> > CFENDODE.exe'ed file?  You can email me of list if you want 
> to remain
> > anonymous :)
> >
> > Thanks!
> >
> > --
> > Scott Van Vliet
> > Sempra Energy
> > 555 W. 5th St., 21st Floor
> > Los Angeles, CA 90013
> > Tel > 213.244.5205
> > Email > [EMAIL PROTECTED] 
> >
> >
> >
> >
> >
> > 
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form.FIELDNAME - error!!!!

[Timothy Heald]

The cache monster strikes again :)

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:18 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> Well Guys,
>
>I am Sorry!! It is weird that i closed all my opened IE Browser windows
> and reopened, it
>
>worked. the same code worked !!!
>
>Tim your code is working !! - thanks.
>
>Guys, Thanks for all of ur patience.
>
> Special Thanks to Tim, Reuben , Paul  and everyone who
> participated in this
> discussion.
>
> Sudheer Chakka.
>
>
>
>
> -Original Message-
> From: Timothy Heald [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:15 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> I think as long as it has something to do with CF and you don't let your
> emotions carry you away, that debate is acceptable, but I haven't seen any
> cf-talk rules or a faq or anything.
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
> > -Original Message-
> > From: Reuben Poon [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 5:10 PM
> > To: CF-Talk
> > Subject: RE: Form.FIELDNAME - error
> >
> >
> > I'd like to continue this but I am relatively new to this forum.
> >
> > Are these types of debates encouraged/discouraged?  Should they be taken
> > offline?
> >
> > Reuben Poon
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:54 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > I understand your point, but it is like saying periods clutter up
> > pages in a
> > book.
> >
> > If you have:
> >
> > 
> > That tells me that there is a variable being set and it is a string
> >
> > 
> >
> > Am I setting my variable to the two words seperated by a period,
> > query.column? or to a variable query.column?
> >
> > To each his own, but it makes more sense to me to see those
> pounds on the
> > right hand side ..  Plus reading a book with periods is easier too :)
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> >
> > > I think that the # on the right side of the set operand is redundant.
> > >
> > > 
> > >
> > > or
> > >
> > > 
> > >
> > > There is only one thing for *another_var* to be: a variable.  If you
> > wanted
> > > my_var to hold the string "another_var" you should quote the
> right hand
> > > side:
> > >
> > > 
> > >
> > > So my .02 is that pounds just clutter up your statement.
> > >
> > > Reuben Poon
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:35 PM
> > > To: CF-Talk
> > > Subject: Re: Form.FIELDNAME - error
> > > Importance: Low
> > >
> > >
> > > Tim,
> > >
> > > I wouldn't call that bad practice, It should actually be called good
> > > practice (at least in my book).  You are setting a variable and the ##
> > > around the variable show that it is a variable, makes for
> > easier reading.
> > > Now, ## on the set side would be considered bad practice.
> > >
> > > my .02
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > > > Not sure if this is an error or just a bad practice, but you
> > don't need
> > > the
> > > > # signs in your variable declaration (cfset)
> > > >
> > > > 
> > > >
> > > > works just fine.  Also you don't need to generate that var
> at all you
> > can
> > > > just do a list loop like this:
> > > >
> > > > 
> > > > #formField# = #evaluate(formField)#
> > > > 
> > > >
> > > > Tim Heald
> > > > ACP/CCFD :)
> > > > Application Development
> > > > www.schoollink.net
> > > >
> > > > > -Original Message-
> > > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > > To: CF-Talk
> > > > > Subject: Form.FIELDNAME - error
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >  Can any one tell me what is the mistake in
> > > > >
> > > > >  INDEX="i">
> > > > > 
> > > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > I am getting the following error:
> > > > >
> > > > > An error occurred while evaluating the expression:
> > > > > "#ListLen(FORM.FIELDNAMES)#"
> > > > >
> > > > >
> > > > >  Any help on this is appreciated.
> > > > >
> > > > > thanks,
> > > > > Sudheer Chakka.
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.hou

RE: Form.FIELDNAME - error!!!!

[Chakka, Sudheer]

Hi Tim,

U know that is cache, bacuse I tried submitting the form for another
form which is completely new for that session of IE and that form also
didn't send the form variables.

It is kinda of bug in IE... may be I will look into more the next time
if it happens!!

Thanks,
Sudheer Chakka.

 

-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:31 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


The cache monster strikes again :)

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:18 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> Well Guys,
>
>I am Sorry!! It is weird that i closed all my opened IE Browser windows
> and reopened, it
>
>worked. the same code worked !!!
>
>Tim your code is working !! - thanks.
>
>Guys, Thanks for all of ur patience.
>
> Special Thanks to Tim, Reuben , Paul  and everyone who
> participated in this
> discussion.
>
> Sudheer Chakka.
>
>
>
>
> -Original Message-
> From: Timothy Heald [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 4:15 PM
> To: CF-Talk
> Subject: RE: Form.FIELDNAME - error
>
>
> I think as long as it has something to do with CF and you don't let your
> emotions carry you away, that debate is acceptable, but I haven't seen any
> cf-talk rules or a faq or anything.
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
> > -Original Message-
> > From: Reuben Poon [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 5:10 PM
> > To: CF-Talk
> > Subject: RE: Form.FIELDNAME - error
> >
> >
> > I'd like to continue this but I am relatively new to this forum.
> >
> > Are these types of debates encouraged/discouraged?  Should they be taken
> > offline?
> >
> > Reuben Poon
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:54 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > I understand your point, but it is like saying periods clutter up
> > pages in a
> > book.
> >
> > If you have:
> >
> > 
> > That tells me that there is a variable being set and it is a string
> >
> > 
> >
> > Am I setting my variable to the two words seperated by a period,
> > query.column? or to a variable query.column?
> >
> > To each his own, but it makes more sense to me to see those
> pounds on the
> > right hand side ..  Plus reading a book with periods is easier too :)
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> >
> > > I think that the # on the right side of the set operand is redundant.
> > >
> > > 
> > >
> > > or
> > >
> > > 
> > >
> > > There is only one thing for *another_var* to be: a variable.  If you
> > wanted
> > > my_var to hold the string "another_var" you should quote the
> right hand
> > > side:
> > >
> > > 
> > >
> > > So my .02 is that pounds just clutter up your statement.
> > >
> > > Reuben Poon
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:35 PM
> > > To: CF-Talk
> > > Subject: Re: Form.FIELDNAME - error
> > > Importance: Low
> > >
> > >
> > > Tim,
> > >
> > > I wouldn't call that bad practice, It should actually be called good
> > > practice (at least in my book).  You are setting a variable and the ##
> > > around the variable show that it is a variable, makes for
> > easier reading.
> > > Now, ## on the set side would be considered bad practice.
> > >
> > > my .02
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > > > Not sure if this is an error or just a bad practice, but you
> > don't need
> > > the
> > > > # signs in your variable declaration (cfset)
> > > >
> > > > 
> > > >
> > > > works just fine.  Also you don't need to generate that var
> at all you
> > can
> > > > just do a list loop like this:
> > > >
> > > > 
> > > > #formField# = #evaluate(formField)#
> > > > 
> > > >
> > > > Tim Heald
> > > > ACP/CCFD :)
> > > > Application Development
> > > > www.schoollink.net
> > > >
> > > > > -Original Message-
> > > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > > To: CF-Talk
> > > > > Subject: Form.FIELDNAME - error
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >  Can any one tell me what is the mistake in
> > > > >
> > > > >  INDEX="i">
> > > > > 
> > > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > I am getting the following error:
> > > > >
> > > > > An error occurred while evaluating the expression:
> > > > > "#ListLen(FORM.FIELDNAMES)#"
> > > > >
> > > > >
> > > > >

RE: Form.FIELDNAME - error!!!!

[Craig Thomas]

>>


Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?
<<

The first.  If you wanted to set myVar to a variable query.column, don't use
quotes.  (Either way, the period should be a _ or some such.)


SO,


myVar = the string "query_column"


sets the variable variables.myVar to some other variable, namely,
query_column if it exists and throws an error if it doesn't.

-Craig Thomas


__
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: Form.FIELDNAME - error!!!!

[Matthew Walker]

I vote for Reuben on this. I disagree with your argument. While you want
periods in a book. You. Don't. Want. Too. Many. Of. Them. People new to CF
often over use pound signs. So we are encouraged to learn when they're not
needed and then not use them. Thus Reuben's and my preference for not using
them when not needed. That doesn't mean it's the only right way, but it
certainly is one of them.

I don't understand your example: 
It's obvious that you're setting your variable to the two words separated by
a period.

I also write things like  and I think this is
easier to read (for me anyway) than .

Matt

- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 8:53 AM
Subject: Re: Form.FIELDNAME - error


> I understand your point, but it is like saying periods clutter up pages in
a
> book.
>
> If you have:
>
> 
> That tells me that there is a variable being set and it is a string
>
> 
>
> Am I setting my variable to the two words seperated by a period,
> query.column? or to a variable query.column?
>
> To each his own, but it makes more sense to me to see those pounds on the
> right hand side ..  Plus reading a book with periods is easier too :)
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
>
> > I think that the # on the right side of the set operand is redundant.
> >
> > 
> >
> > or
> >
> > 
> >
> > There is only one thing for *another_var* to be: a variable.  If you
> wanted
> > my_var to hold the string "another_var" you should quote the right hand
> > side:
> >
> > 
> >
> > So my .02 is that pounds just clutter up your statement.
> >
> > Reuben Poon
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:35 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > Tim,
> >
> > I wouldn't call that bad practice, It should actually be called good
> > practice (at least in my book).  You are setting a variable and the ##
> > around the variable show that it is a variable, makes for easier
reading.
> > Now, ## on the set side would be considered bad practice.
> >
> > my .02
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> > > Not sure if this is an error or just a bad practice, but you don't
need
> > the
> > > # signs in your variable declaration (cfset)
> > >
> > > 
> > >
> > > works just fine.  Also you don't need to generate that var at all you
> can
> > > just do a list loop like this:
> > >
> > > 
> > > #formField# = #evaluate(formField)#
> > > 
> > >
> > > Tim Heald
> > > ACP/CCFD :)
> > > Application Development
> > > www.schoollink.net
> > >
> > > > -Original Message-
> > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > To: CF-Talk
> > > > Subject: Form.FIELDNAME - error
> > > >
> > > >
> > > > Hi,
> > > >
> > > >  Can any one tell me what is the mistake in
> > > >
> > > > 
> > > > 
> > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > 
> > > > 
> > > >
> > > >
> > > > I am getting the following error:
> > > >
> > > > An error occurred while evaluating the expression:
> > > > "#ListLen(FORM.FIELDNAMES)#"
> > > >
> > > >
> > > >  Any help on this is appreciated.
> > > >
> > > > thanks,
> > > > Sudheer Chakka.
> > > >
> > > >
> > >
> >
> >
> 
__
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

cflocation showing headers

[Jon Hall]

Ok, I'm seeing this problem now. After a cflocation, cf5 is outputting the
http headers to the screen.
I've seen other people mention it in the past, but can't recall what the fix
was.

jon

__
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

Pound sign debate (from Form.FIELDNAME - error!!!!)

[Reuben Poon]

Well, I don't think it is quite like leaving out a period.  A period is a
required function to denote the closing of a sentence.

Pound signs are only required when a variable explicitly needs to be
evaluated.  The rest of the time they are optional.

And your example:



is flawed because if the value of query.column holds a numeric value, it
will be converted to a string.  The way the statement is structured, someone
reading that line would read that the intention of the statement is to
assign a STRING to the variable my_var.  If the variable query.column holds
a numeric value then this statement is misleading and incorrect.  Because
Cold Fusion is untyped, this USUALLY does not pose problems but it could
potentially cause problems.

And as for your other example:



This statement puts the STRING "query.column" into the variable my_var.  You
are not getting the value of the query.column variable.


Reuben Poon



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:54 PM
To: CF-Talk
Subject: Re: Form.FIELDNAME - error
Importance: Low


I understand your point, but it is like saying periods clutter up pages in a
book.

If you have:


That tells me that there is a variable being set and it is a string



Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?

To each his own, but it makes more sense to me to see those pounds on the
right hand side ..  Plus reading a book with periods is easier too :)

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector Commerce Builder




> I think that the # on the right side of the set operand is redundant.
>
> 
>
> or
>
> 
>
> There is only one thing for *another_var* to be: a variable.  If you
wanted
> my_var to hold the string "another_var" you should quote the right hand
> side:
>
> 
>
> So my .02 is that pounds just clutter up your statement.
>
> Reuben Poon
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
> Importance: Low
>
>
> Tim,
>
> I wouldn't call that bad practice, It should actually be called good
> practice (at least in my book).  You are setting a variable and the ##
> around the variable show that it is a variable, makes for easier reading.
> Now, ## on the set side would be considered bad practice.
>
> my .02
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
> > Not sure if this is an error or just a bad practice, but you don't need
> the
> > # signs in your variable declaration (cfset)
> >
> > 
> >
> > works just fine.  Also you don't need to generate that var at all you
can
> > just do a list loop like this:
> >
> > 
> > #formField# = #evaluate(formField)#
> > 
> >
> > Tim Heald
> > ACP/CCFD :)
> > Application Development
> > www.schoollink.net
> >
> > > -Original Message-
> > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 4:16 PM
> > > To: CF-Talk
> > > Subject: Form.FIELDNAME - error
> > >
> > >
> > > Hi,
> > >
> > >  Can any one tell me what is the mistake in
> > >
> > > 
> > > 
> > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > 
> > > 
> > >
> > >
> > > I am getting the following error:
> > >
> > > An error occurred while evaluating the expression:
> > > "#ListLen(FORM.FIELDNAMES)#"
> > >
> > >
> > >  Any help on this is appreciated.
> > >
> > > thanks,
> > > Sudheer Chakka.
> > >
> > >
> >
>
>

__
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: Form.FIELDNAME - error!!!!

[Reuben Poon]

Sudheer,

For future reference.  The caching problem created an error probably because
the FORM variables were not defined.

Reuben


-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:25 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error
Importance: Low


Hi Tim,

   I appreciate u r concern and U will be happy to know that i could solve
the problem by

   closing all the opened IE browser windows and opened it and the same code
is working.

 thanks for u r offer to help.

Sudheer Chakka.

-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 4:25 PM
To: CF-Talk
Subject: RE: Form.FIELDNAME - error


Have we found out what the source of the original error is yet?  I love a
good debate, but I would really like to help out the person who started this
thread as well.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:20 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
>
>
> :) they are common ... they get discouraged when the go on and on ...but
> usually this group is very informative and you can learn alot by the
> debates!
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector Commerce Builder
>
>
>
> > I'd like to continue this but I am relatively new to this forum.
> >
> > Are these types of debates encouraged/discouraged?  Should they be taken
> > offline?
> >
> > Reuben Poon
> >
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 09, 2002 1:54 PM
> > To: CF-Talk
> > Subject: Re: Form.FIELDNAME - error
> > Importance: Low
> >
> >
> > I understand your point, but it is like saying periods clutter
> up pages in
> a
> > book.
> >
> > If you have:
> >
> > 
> > That tells me that there is a variable being set and it is a string
> >
> > 
> >
> > Am I setting my variable to the two words seperated by a period,
> > query.column? or to a variable query.column?
> >
> > To each his own, but it makes more sense to me to see those
> pounds on the
> > right hand side ..  Plus reading a book with periods is easier too :)
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> >
> > > I think that the # on the right side of the set operand is redundant.
> > >
> > > 
> > >
> > > or
> > >
> > > 
> > >
> > > There is only one thing for *another_var* to be: a variable.  If you
> > wanted
> > > my_var to hold the string "another_var" you should quote the
> right hand
> > > side:
> > >
> > > 
> > >
> > > So my .02 is that pounds just clutter up your statement.
> > >
> > > Reuben Poon
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:35 PM
> > > To: CF-Talk
> > > Subject: Re: Form.FIELDNAME - error
> > > Importance: Low
> > >
> > >
> > > Tim,
> > >
> > > I wouldn't call that bad practice, It should actually be called good
> > > practice (at least in my book).  You are setting a variable and the ##
> > > around the variable show that it is a variable, makes for easier
> reading.
> > > Now, ## on the set side would be considered bad practice.
> > >
> > > my .02
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > > > Not sure if this is an error or just a bad practice, but you don't
> need
> > > the
> > > > # signs in your variable declaration (cfset)
> > > >
> > > > 
> > > >
> > > > works just fine.  Also you don't need to generate that var
> at all you
> > can
> > > > just do a list loop like this:
> > > >
> > > > 
> > > > #formField# = #evaluate(formField)#
> > > > 
> > > >
> > > > Tim Heald
> > > > ACP/CCFD :)
> > > > Application Development
> > > > www.schoollink.net
> > > >
> > > > > -Original Message-
> > > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > > To: CF-Talk
> > > > > Subject: Form.FIELDNAME - error
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >  Can any one tell me what is the mistake in
> > > > >
> > > > >  INDEX="i">
> > > > > 
> > > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > I am getting the following error:
> > > > >
> > > > > An error occurred while evaluating the expression:
> > > > > "#ListLen(FORM.FIELDNAMES)#"
> > > > >
> > > > >
> > > > >  Any help on this is appreciated.
> > > > >
> > > > > thanks,
> > > > > Sudheer Chakka.
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> >
>


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co

pound signs and strings (WAS: Form.FIELDNAME - error!!!!)

[Gyrus]

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]

If you have:


That tells me that there is a variable being set and it is a string



Am I setting my variable to the two words seperated by a period,
query.column? or to a variable query.column?
---

I missed the start of this thread, but this seems like a small but
important tangent to get straight...

Doesn't the second CFSET set the variable to the string "query.column"?
I imagine the real debate is between:



and



If we're pitching in, I usually prefer the second if your only using
that variable. Studio colour coding means it's easy to see you're
referring to a variable... If you're concatenating, though I find it
easier to use



rather than



Again, colour coding makes the first one easier to scan.

Signing out on the "CF nit-picking" debate :-)

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
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: Getting data from excel97

[Reuben Poon]

You should be able to change a setting to make the first row denote the
column names.

For the references to the default names, I am not sure about that (or
exactlly what you're trying to do).

Reuben Poon


-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:05 PM
To: CF-Talk
Subject: Re: Getting data from excel97
Importance: Low


Well, that makes sense... the first row of the column is text (used for the
column name) that may be what is happening.

Can I make references to the default names of the excel columns when
importing? (sheet1A,sheet1B,sheet1C,etc.)

will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

[EMAIL PROTECTED]
http://www.esca.com/

- Original Message -
From: "Reuben Poon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 1:34 PM
Subject: RE: Getting data from excel97


> Will,
>
> I've had lots of problems with Excel and exporting its data.  Take a look
at
> the first row (or first few rows) of data in the Excel file.  If it's a
> blank value or a string, then Excel will convert the entire column to that
> datatype.  Sometimes you need to put data in the first few rows to get
Excel
> to not do this.
>
> Not sure if this made sense or not.  Send me an email if you're still
having
> problems.
>
> Reuben Poon
> [ [EMAIL PROTECTED] ]
>
>
>
> -Original Message-
> From: William H. Bowen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 1:31 PM
> To: CF-Talk
> Subject: OT: Getting data from excel97
> Importance: Low
>
>
> My turn to post off-topic! Sorry!
>
> I have an excel file that is provided to me on a semi-regular basis. It
> contains names of files, their owners and version numbers.
> I import the data into a table in MSSQLServer 7 using DTS, no problem
> there...BUT
>
> and there is always a but...
>
> There is a column full of numbers in the excell file that doesn't copy
> completely in to the table _unless_ I go through the column manually and
> place an apostrophe in front of every number.
>
> Oh...and non importing issue seems to happen randomly, sometimes one row,
> sometimes 50.
>
> My questions then, are these:
> 1. Is there a way that I can append the apostrophe to each row in that
> particular column in the excel file before/during import?
> 2. Is there something I can do to avoid this problem altogether and import
> the data properly the first time? (i.e., am I missing something?)
>
> I think that should cover it for now.
>
> TIA
>
> will
> 
>
> William H. Bowen
> Webmaster
> ALSTOM's Energy Management and Markets Business
>
> [EMAIL PROTECTED]
> http://www.esca.com/
>
>
>
>

__
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: Form.FIELDNAME - error!!!!

[Timothy Heald]

I agree.  Plus why type the extra characters.  I know on the Fb list every
so often someone will voice the wish that instead of  you could
just use   I think that would be great :)

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 09, 2002 5:03 PM
> To: CF-Talk
> Subject: Re: Form.FIELDNAME - error
>
>
> I vote for Reuben on this. I disagree with your argument. While you want
> periods in a book. You. Don't. Want. Too. Many. Of. Them. People new to CF
> often over use pound signs. So we are encouraged to learn when they're not
> needed and then not use them. Thus Reuben's and my preference for
> not using
> them when not needed. That doesn't mean it's the only right way, but it
> certainly is one of them.
>
> I don't understand your example: 
> It's obvious that you're setting your variable to the two words
> separated by
> a period.
>
> I also write things like  and I think this is
> easier to read (for me anyway) than .
>
> Matt
>
> - Original Message -
> From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 10, 2002 8:53 AM
> Subject: Re: Form.FIELDNAME - error
>
>
> > I understand your point, but it is like saying periods clutter
> up pages in
> a
> > book.
> >
> > If you have:
> >
> > 
> > That tells me that there is a variable being set and it is a string
> >
> > 
> >
> > Am I setting my variable to the two words seperated by a period,
> > query.column? or to a variable query.column?
> >
> > To each his own, but it makes more sense to me to see those
> pounds on the
> > right hand side ..  Plus reading a book with periods is easier too :)
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector Commerce Builder
> >
> >
> >
> >
> > > I think that the # on the right side of the set operand is redundant.
> > >
> > > 
> > >
> > > or
> > >
> > > 
> > >
> > > There is only one thing for *another_var* to be: a variable.  If you
> > wanted
> > > my_var to hold the string "another_var" you should quote the
> right hand
> > > side:
> > >
> > > 
> > >
> > > So my .02 is that pounds just clutter up your statement.
> > >
> > > Reuben Poon
> > >
> > >
> > > -Original Message-
> > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 09, 2002 1:35 PM
> > > To: CF-Talk
> > > Subject: Re: Form.FIELDNAME - error
> > > Importance: Low
> > >
> > >
> > > Tim,
> > >
> > > I wouldn't call that bad practice, It should actually be called good
> > > practice (at least in my book).  You are setting a variable and the ##
> > > around the variable show that it is a variable, makes for easier
> reading.
> > > Now, ## on the set side would be considered bad practice.
> > >
> > > my .02
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > > http://www.quilldesign.com
> > > SiteDirector Commerce Builder
> > >
> > >
> > > > Not sure if this is an error or just a bad practice, but you don't
> need
> > > the
> > > > # signs in your variable declaration (cfset)
> > > >
> > > > 
> > > >
> > > > works just fine.  Also you don't need to generate that var
> at all you
> > can
> > > > just do a list loop like this:
> > > >
> > > > 
> > > > #formField# = #evaluate(formField)#
> > > > 
> > > >
> > > > Tim Heald
> > > > ACP/CCFD :)
> > > > Application Development
> > > > www.schoollink.net
> > > >
> > > > > -Original Message-
> > > > > From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 09, 2002 4:16 PM
> > > > > To: CF-Talk
> > > > > Subject: Form.FIELDNAME - error
> > > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > >  Can any one tell me what is the mistake in
> > > > >
> > > > >  INDEX="i">
> > > > > 
> > > > > #ListGetAt(Form.FIELDNAMES, i)# = #Evaluate(var)#
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > I am getting the following error:
> > > > >
> > > > > An error occurred while evaluating the expression:
> > > > > "#ListLen(FORM.FIELDNAMES)#"
> > > > >
> > > > >
> > > > >  Any help on this is appreciated.
> > > > >
> > > > > thanks,
> > > > > Sudheer Chakka.
> > > > >
> > > > >
> > > >
> > >
> > >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists