cfif

[Peter Benoit]

I want to check if a date is not greater than 30 days old.

I've got the datediff working, but I want to present the table only if the
date isn't over 30 days old.  So I'm doing this: 

Which obviosly doesn't work.  What am I doing wrong?

-Peter

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

cfif

[Janine Jakim]

I am very comfortable with making generic queries and calling them in my
page.  My colleague mentioned that I should be able to do that with if
statements also.  I have an cfif statement that I use on several pages and
it'd be nice just have it in one spot
So this is the code I call into several pages- it checks to see if it is the
current quarter or if a teacher has access to a past quarter- if yes to
either they are given input boxes. If no they can view but not edit grades


 


  




#UCase(Grade)#



Is there a way to just pull this type of code in?
TIA
j
__
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

CFIF

[netman]

Good Evening,

Trying to figure out how to do a cfif on the url that is being passed.  Need
to redirect according to the url that the user has try to go to.

Just not sure about the syntax to use to compare according to the url.
Tried xyz  But did not work.  I thought it would
be similar to a url.var.

Can anyone help,

Robert

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfif contains

[Rick Sanders]

How can I do a cfif contains?

Error I am getting:

You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members.   


The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6

4 : 
5 : 
6 :


I hope someone can shed some light on this. thanks!

Rick





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338258
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CFIF question...

[Gary McNeel, Jr.]

can you use BETWEEN or maybe IN in a cfif?

ex: do something
ex: do something

Is there a better, faster way to do this?

Thanks.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFIF Statement

[Kent A. Orso]

Trying to do a CFOUTPUT Statement that returns all of the lastname records
that begin with the letter "A", and order by lastnames, but the following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent

__
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

CFIF Questions

[LH Rothman]

Hello!

I want to force folks to select a state but I'm using CFSELECT and the
required tag doesn't work with it.  Consequently I'm attempting to
modify the CFIF statement on my action page with little success.  I've
tried this:


Error!  You must select a state!



but it doesn't work.  The ultimate goal is to require folks to select at
MINIMUM a state in this search and give them an error if they select
nothing.  I know I'm making a stupid mistake and and any help would be
very appreciated!!!

Thank you,
-Laura
An Apparent Newbie!


-- My Action page in progress--


SELECT Zip, City, County, State, Business, Phone, Fax, Website, Email,
Street1, Legal, Comments
FROM Contacts
WHERE Legal LIKE '1'


 AND Business LIKE '#Business#%'


 AND City LIKE '#City#%'


 AND County LIKE '#County#%'


 AND Zip LIKE '#Zip#%'


 AND State LIKE '#State#%'

ORDER BY Business




Search Results





Found #Contacts.RecordCount# Matches







#Business#
#Street1#N/A
#City#, #State# #Zip#
PH: #Phone#N/A
FX: #Fax#N/A
Web: #Website#N/A
Email: mailto:#Email#">#Email#N/A
#Comments#











--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFCASE/CFIF

[Jake Hileman]

Is CFCASE faster then CFIF?

Also, execution time wise.. I'm hitting upwards of 500ms or so when I
usually only hit about 100-200ms.. but I'm setting about 100CFparams in this
so 500 I guess is expected.

Is 500ms slow?  This is my dev machine.. p2 300, 256mb ram, win2k, mysql
3.23.24.

thanks!

jake --more below.
422 milliseconds
  282 ms D\ADDPLAN.CFM
  93 ms D\ADDPLANCASE.CFM
  16 ms D\FOOTER.INC
  0 ms D\HEADER.INC
  31 ms STARTUP, PARSING, & SHUTDOWN



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFIF discussion

[W Luke]

Hi,

I'm 5 weeks into Cold Fusion and have a question for the Experienced Masses.

So far in my programming, I try to keep all the code in one file as much as
possible.  For example, if I have a form that is used as part of a Query,
then I'll obviously "post" that form' data to the same page, resulting in a
number of .

However, at what stage would you suggest that this isn't a good idea?  I've
been doing a small sub-project today which is about 400 lines long, and by
17:00 will be considerably bigger.  Is this a case of "whatever suits you
best?"

I'd be interested to hear everyone's opinions.

Will



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif

[Anthony Geoghegan]

Hi Peter,

Try something like this:




-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2000 14:32
To: CF-Talk
Subject: cfif


I want to check if a date is not greater than 30 days old.

I've got the datediff working, but I want to present the table only if the
date isn't over 30 days old.  So I'm doing this: 

Which obviosly doesn't work.  What am I doing wrong?

-Peter
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif

[Peter Benoit]

Well here is all the offending code








I'm not sure how I'd use your example with this.



*  -Original Message-
*  From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 11, 2000 9:40 AM
*  To: CF-Talk
*  Subject: RE: cfif
*  
*  
*  Hi Peter,
*  
*  Try something like this:
*  
*  
*  
*  
*  -Original Message-
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: 11 October 2000 14:32
*  To: CF-Talk
*  Subject: cfif
*  
*  
*  I want to check if a date is not greater than 30 days old.
*  
*  I've got the datediff working, but I want to present the 
*  table only if the
*  date isn't over 30 days old.  So I'm doing this: 
*  
*  Which obviosly doesn't work.  What am I doing wrong?
*  
*  -Peter
*  -
*  -
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  To Unsubscribe visit 
*  http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lis
ts/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif

[Anthony Geoghegan]

Hi Pete,
Like this.

Keep it simple.

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2000 15:43
To: CF-Talk
Subject: RE: cfif


Well here is all the offending code








I'm not sure how I'd use your example with this.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif

[Peter Benoit]

I don't know enough yet to keep it simple :)

thanks!

-Pete

*  -Original Message-
*  From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 11, 2000 10:54 AM
*  To: CF-Talk
*  Subject: RE: cfif
*  
*  
*  Hi Pete,
*  Like this.
*  
*  Keep it simple.
*  
*  -Original Message-
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: 11 October 2000 15:43
*  To: CF-Talk
*  Subject: RE: cfif
*  
*  
*  Well here is all the offending code
*  
*  
*  
*  
*  
*  
*  
*  
*  I'm not sure how I'd use your example with this.
*  
*  
*  -
*  -
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  To Unsubscribe visit 
*  http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lis
ts/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif

[Ryan Williams]

Pete,
What Anthony was attempting (I believe) to
show you is you can use the dateadd function and
increment the current date (i.e. Now()) by "x"
amount and compare the result in the if statement.

So, if you used today's date formatted like:
10/11/2000 13:40:00 and used the dateadd
function like Anthony suggested in his
response to you,

> 

it would return:

11/10/2000 00:00:00

and then you can execute the cfif.

Simple eh ? :-)

The CF help files that are accessible from
the studio I use all the time.  Do a search
there on "date" and view the "date and time
functions" that will come up, or just search
dateadd.  Either way, it shouldn't be hard to
find.

Cheers :-)

Ryan Williams
[EMAIL PROTECTED]
301-397-2860

P.S. "Remember, it isn't what you do correct, but
what you screw up that is important to your peers"
- Anonymous


-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 11, 2000 12:05 PM
To: CF-Talk
Subject: RE: cfif


I don't know enough yet to keep it simple :)

thanks!

-Pete

*  -Original Message-
*  From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 11, 2000 10:54 AM
*  To: CF-Talk
*  Subject: RE: cfif
*
*
*  Hi Pete,
*  Like this.
*  
*  Keep it simple.
*
*  -Original Message-
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: 11 October 2000 15:43
*  To: CF-Talk
*  Subject: RE: cfif
*
*
*  Well here is all the offending code
*
*  
*  
*  
*
*  
*
*
*  I'm not sure how I'd use your example with this.
*
*
*  -
*  -
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  To Unsubscribe visit
*  http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lis
ts/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif

[Anthony Geoghegan]

Sorry Guys,
I didn't mean keep it simple as in make it easy to follow.  I've been coding
too long I think.  I meant keep it simple as in smaller code = smarter code.
The less processing the page has to do the better.
I guess I've left those days of being a teacher long behind.
Sorry for being so cryptic Pete ;-).

Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

cfif help???

[HappyToad.com]

I am trying to set up a form that compares the form field user_id to the
database.  Here is what I have written:


Sorry User ID is Taken







I am getting an error saying:
Error Diagnostic Information
InsideText

Cannot convert user1 to boolean.

user1 is what was entered as user id on the form page.

Any ideas,
Rich


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: cfif

[Jerry Johnson]

By "pulling it in", I assume you want to use this same bit of code from a couple of 
different places (different sections of code in one cfm or different cfms.



It doesn't even need to be a .cfm file - even if it contains CFM code.



The big question is where to store the code.

If all the files that are going to use it are already stored in the same directory, 
you can just place it in amongst them.

but if you are going to include it from files in diferent directories, and especially 
different depths from the top of the tree, you need to give the storage a little more 
thought.

often the include files are included in a directory, off the main tree, called includes

so the include would then actually be



Hope this gives yo ua place to start.
Jerry Johnson

>>> [EMAIL PROTECTED] 04/26/02 11:40AM >>>
I am very comfortable with making generic queries and calling them in my
page.  My colleague mentioned that I should be able to do that with if
statements also.  I have an cfif statement that I use on several pages and
it'd be nice just have it in one spot
So this is the code I call into several pages- it checks to see if it is the
current quarter or if a teacher has access to a past quarter- if yes to
either they are given input boxes. If no they can view but not edit grades


 


  




#UCase(Grade)#



Is there a way to just pull this type of code in?
TIA
j

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

[Adrian Lynch]

cfinclude???

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2002 16:41
To: CF-Talk
Subject: cfif


I am very comfortable with making generic queries and calling them in my
page.  My colleague mentioned that I should be able to do that with if
statements also.  I have an cfif statement that I use on several pages and
it'd be nice just have it in one spot
So this is the code I call into several pages- it checks to see if it is the
current quarter or if a teacher has access to a past quarter- if yes to
either they are given input boxes. If no they can view but not edit grades


 


  




#UCase(Grade)#



Is there a way to just pull this type of code in?
TIA
j

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

[Andy Ewings]

or even better with a Custon Tag

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2002 17:03
To: CF-Talk
Subject: RE: cfif


cfinclude???

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2002 16:41
To: CF-Talk
Subject: cfif


I am very comfortable with making generic queries and calling them in my
page.  My colleague mentioned that I should be able to do that with if
statements also.  I have an cfif statement that I use on several pages and
it'd be nice just have it in one spot
So this is the code I call into several pages- it checks to see if it is the
current quarter or if a teacher has access to a past quarter- if yes to
either they are given input boxes. If no they can view but not edit grades


 


  




#UCase(Grade)#



Is there a way to just pull this type of code in?
TIA
j


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

[Douglas Brown]

this is where fusebox really comes in handy as far as code reuse
goes, you may want to look into it.




"Success is a journey, not a destination!!"



Doug Brown
- Original Message -
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 9:04 AM
Subject: RE: cfif


> or even better with a Custon Tag
>
> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
> Sent: 26 April 2002 17:03
> To: CF-Talk
> Subject: RE: cfif
>
>
> cfinclude???
>
> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: 26 April 2002 16:41
> To: CF-Talk
> Subject: cfif
>
>
> I am very comfortable with making generic queries and calling
them in my
> page.  My colleague mentioned that I should be able to do that
with if
> statements also.  I have an cfif statement that I use on several
pages and
> it'd be nice just have it in one spot
> So this is the code I call into several pages- it checks to see
if it is the
> current quarter or if a teacher has access to a past quarter- if
yes to
> either they are given input boxes. If no they can view but not
edit grades
>
>  GetSubjects.EndingDate) AND ((CLIENT.SpecialAccess EQ 0) OR
> (CLIENT.SpecialAccess EQ ""))>
>  
>
> 
> 
>
> 
>
> 
> #UCase(Grade)#
>
> 
>
> Is there a way to just pull this type of code in?
> TIA
> j
>
>
>
__

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

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

[Janine Jakim]

In Fusebox wouldn't you just use a cfinclude. (I know FB2 but haven't had
the time to look at FB3)
It does work if I use the whole cfif statement. I was hoping to only use
parts of it. (ie a cfinclude that had only



but not 


It's the code between the  and  I don't want
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 12:20 PM
To: CF-Talk
Subject: Re: cfif


this is where fusebox really comes in handy as far as code reuse
goes, you may want to look into it.




"Success is a journey, not a destination!!"



Doug Brown
- Original Message -
From: "Andy Ewings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 9:04 AM
Subject: RE: cfif


> or even better with a Custon Tag
>
> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
> Sent: 26 April 2002 17:03
> To: CF-Talk
> Subject: RE: cfif
>
>
> cfinclude???
>
> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]]
> Sent: 26 April 2002 16:41
> To: CF-Talk
> Subject: cfif
>
>
> I am very comfortable with making generic queries and calling
them in my
> page.  My colleague mentioned that I should be able to do that
with if
> statements also.  I have an cfif statement that I use on several
pages and
> it'd be nice just have it in one spot
> So this is the code I call into several pages- it checks to see
if it is the
> current quarter or if a teacher has access to a past quarter- if
yes to
> either they are given input boxes. If no they can view but not
edit grades
>
>  GetSubjects.EndingDate) AND ((CLIENT.SpecialAccess EQ 0) OR
> (CLIENT.SpecialAccess EQ ""))>
>  
>
> 
> 
>
> 
>
> 
> #UCase(Grade)#
>
> 
>
> Is there a way to just pull this type of code in?
> TIA
> j
>
>
>
__

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


__
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

cfif shorthand

[Jon Hall]

I'm working on some code that uses a shorthand (I guess...) cfif style quite
a bit. I have tried to stay away from doing this since it makes the code
harder to read, so I never really took the time to figure it out.

For instance...

Is this testing for the existence of the query or if it is greater than
zero?


This particular one has me scratching my head, it never seems to test
negative in the code, but what is it testing for?

Could someone please fill me in here...

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

CFIF Help

[Joshua Tipton]

Okay,

I have a 7 layer error code.  I want to do a query to display only the one
that is not 0.  e1-e7.  Six will be 0 and one will be occupied by a 1.  This
is how it will be displayed:  #ecode# .  What
would the code for all of th  tags would be.  Here is the query:



SELECT  RRDD, SLIC, SONum, ModNum, DateArriv, AttnTo, Creator, E1, E2,
E3, E4, E5, E6, E7
FROM exception
where rrdd ='#url.dis#' and slic = '#url.slic#'
order by datearriv



Joshua Tipton


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFIF Confusion

[Ken Monroe]

Hello!

I'm working with SQL Server 2000 and I have a query I'm confused about.
There's a field (FIELD1) that's defined as a VARCHAR.  The field contains
either "Yes" or "No".  I SELECT all records and then want to display
somthing different if FIELD1 is a "Yes" or "No".

  The following structure works:

Bunch of code


This structure does not work:

Bunch of code


I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...

???
Thx


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

CFIF Issue

[Bruce Sorge]

OK. I have the following code:



Select User_Type
From Users
Where Auth_User = '#CGI.Auth_User#'
   


   #qGetUser.User_Type#



   

SELECT bcon.AutoNumber, bcon.CERNER_Mnemonic, bcon.CERNER_Code
FROM (Sections INNER JOIN UserSection ON Sections.Section_ID = 
UserSection.Section_ID) INNER JOIN bcon ON Sections.Section_ID = 
bcon.Section_ID
WHERE (((UserSection.Auth_User)='#CGI.Auth_User#'))
AND Cerner_Mnemonic <> ''
Order By Cerner_Mnemonic
   





SELECT bcon.AutoNumber, bcon.CERNER_Mnemonic, bcon.CERNER_Code
FROM BCON
WHERE Cerner_Mnemonic <> ''
Order By Cerner_Mnemonic
   


When I run this, the outputted User Type is User (I see it on the screen 
from the  I have above). So I know that the User Type is User. 
However, the CFIF statements are not picking this up. The weird thing is 
that I have a similar application in production that uses the same 
logic, and it works fine. I am baffled!

Thanks,
Bruce

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

CFIF Insanity

[Richard Crawford]

I have a rather long script that I've been editing with HomeSite.  When 
I try to run it, I keep getting this error:

  Context validation error for tag cfif.
The end tag  requires a matching start tag.

I've gone over this code with a fine-toothed comb several times and even 
rewritten big parts of it, even introduced extra CFIF tags (along the 
lines of ) and I have not been able to get rid of this 
error.  HomeSite also has a feature which allows you to examine all tags 
and find matching close or start tags, and I found no unmatched  
tags.

I conclude that it's not REALLY a CFIF error, but something more 
insidious and subtle, the true intention of which is to piss me off. ;-)

Anyone have any ideas where else I could be looking?

-- 
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFIF Troubles!!!

[Ian Vaughan]

Iam having some trouble with cfif statements 

If I enter more than one value in the search form such as

Surname = Vaughan
Funding = budget

The results bring back all surname records where the funding = budget when it should be bringing back only the surnames that contain Vaughan

Is it something to do with my CFIF statements?


SELECT * FROM funding
WHERE 1=1


    AND UPPER(orgname) LIKE UPPER(
value="%#form.orgname#%">)


    AND UPPER(funding) LIKE UPPER(
value="%#form.funding#%">)


    AND UPPER(surname) LIKE UPPER(
value="%#form.surname#%">)


AND IsNumeric(form.commdayfrom) AND IsNumeric(form.commyearto) AND
IsNumeric(form.commmonthto) AND IsNumeric(form.commdayto)>

   
 AND IssueDate BETWEEN
    TO_DATE('#form.commyearfrom#-#form.commmonthfrom#-#form.commdayfrom#','-MM-DD')
    AND
    TO_DATE('#form.commyearto#-#form.commmonthto#-#form.commdayto#','-MM-DD')

 



--

This is the output from debugging

Queries 

funding (Records=8, Time=58ms)
SQL = 
SELECT * FROM funding
WHERE 1=1

    AND UPPER(funding) LIKE UPPER(:1)

Query Parameter Value(s) -
Parameter #1 = %Budget%
As you can see the surname field parameter does not seem to have been parsed  ???

Any ideas?

Ian


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

Re: CFIF

[KJis18]

--part1_75.ca0f6c5.2751e531_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

I know if you are using CFIF like in a CFIF statement, you can do it this 
way...


sample.cfm?action=xyz


 Send Me to This URL

 Send to other URL


Kev

--part1_75.ca0f6c5.2751e531_boundary
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

I know 
if you are using CFIF like in a CFIF statement, you can do it this way...


sample.cfm?action=xyz

<cfif action IS "xyz">
 Send Me to This URL
<cfelse>
 Send to other URL
</cfif>

Kev

--part1_75.ca0f6c5.2751e531_boundary--
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFIF

[netman]

I am aware of that function, but what I need to do is ex. the user goes to
www.xyz.com I want to be able to use CFIF to look at the www.xyz.com and
redirect to another url.  I need to do this for a few url's.  I hope this
helps explain more.

Robert

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 25, 2000 11:01 PM
Subject: Re: CFIF


>
> --part1_75.ca0f6c5.2751e531_boundary
> Content-Type: text/plain; charset="US-ASCII"
> Content-Transfer-Encoding: 7bit
>
> I know if you are using CFIF like in a CFIF statement, you can do it this
> way...
>
>
> sample.cfm?action=xyz
>
> 
>  Send Me to This URL
> 
>  Send to other URL
> 
>
> Kev
>
> --part1_75.ca0f6c5.2751e531_boundary
> Content-Type: text/html; charset="US-ASCII"
> Content-Transfer-Encoding: 7bit
>
> I know if you are using CFIF like in a CFIF statement, you can do
it this way...
> 
> 
> sample.cfm?action=xyz
> 
> <cfif action IS "xyz">
>  Send Me to This URL
> <cfelse>
>  Send to other URL
> </cfif>
> 
> Kev
>
> --part1_75.ca0f6c5.2751e531_boundary--
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFIF

[James McCullough]

If you are trying to find out where the user is coming from in order to
redirect them use cgi.http_referer like this





-Original Message-
From: netman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 7:54 PM
To: CF-Talk
Subject: CFIF


Good Evening,

Trying to figure out how to do a cfif on the url that is being passed.  Need
to redirect according to the url that the user has try to go to.

Just not sure about the syntax to use to compare according to the url.
Tried xyz  But did not work.  I thought it would
be similar to a url.var.

Can anyone help,

Robert

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFIF

[netman]

Thanks again,

But I want to know what URL the user is trying to goto, it should be
something like the URL they put in there address box in the browser.

Thanks,
Robert

- Original Message -
From: "James McCullough" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 25, 2000 10:22 PM
Subject: RE: CFIF


> If you are trying to find out where the user is coming from in order to
> redirect them use cgi.http_referer like this
>
> 
> 
> 
>
> -Original Message-
> From: netman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 25, 2000 7:54 PM
> To: CF-Talk
> Subject: CFIF
>
>
> Good Evening,
>
> Trying to figure out how to do a cfif on the url that is being passed.
Need
> to redirect according to the url that the user has try to go to.
>
> Just not sure about the syntax to use to compare according to the url.
> Tried xyz  But did not work.  I thought it would
> be similar to a url.var.
>
> Can anyone help,
>
> Robert
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFIF

[netman]

Thanks for everyone's help, but I finally figured out which variable it is.
SERVER_NAME is the one.

Thanks again,
Robert


- Original Message -
From: "James McCullough" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 25, 2000 10:22 PM
Subject: RE: CFIF


> If you are trying to find out where the user is coming from in order to
> redirect them use cgi.http_referer like this
>
> 
> 
> 
>
> -Original Message-
> From: netman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 25, 2000 7:54 PM
> To: CF-Talk
> Subject: CFIF
>
>
> Good Evening,
>
> Trying to figure out how to do a cfif on the url that is being passed.
Need
> to redirect according to the url that the user has try to go to.
>
> Just not sure about the syntax to use to compare according to the url.
> Tried xyz  But did not work.  I thought it would
> be similar to a url.var.
>
> Can anyone help,
>
> Robert
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFIF

[Rob Keniger]

on 11/26/00 3:15 PM, netman at [EMAIL PROTECTED] wrote:

> Thanks for everyone's help, but I finally figured out which variable it is.
> SERVER_NAME is the one.

I think you'll find you need to use #cgi.server_name##cgi.script_name# to
get the full path...
-- 

Rob Keniger

big bang solutions




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFIF

[James McCullough]

Oh, I see.

Try  this.



> 

-Original Message-
From: netman [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 25, 2000 8:27 PM
To: CF-Talk
Subject: Re: CFIF


Thanks again,

But I want to know what URL the user is trying to goto, it should be
something like the URL they put in there address box in the browser.

Thanks,
Robert

- Original Message -
From: "James McCullough" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 25, 2000 10:22 PM
Subject: RE: CFIF


> If you are trying to find out where the user is coming from in order to
> redirect them use cgi.http_referer like this
>
> 
> 
> 
>
> -Original Message-
> From: netman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 25, 2000 7:54 PM
> To: CF-Talk
> Subject: CFIF
>
>
> Good Evening,
>
> Trying to figure out how to do a cfif on the url that is being passed.
Need
> to redirect according to the url that the user has try to go to.
>
> Just not sure about the syntax to use to compare according to the url.
> Tried xyz  But did not work.  I thought it would
> be similar to a url.var.
>
> Can anyone help,
>
> Robert
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFIF

[Stanislav Maximov]

You do not need s there. Don't bother the engine with a useless
parsing ;)

stas@

> -Original Message-
> From: James McCullough [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 26, 2000 11:17 PM
> To: CF-Talk
> Subject: RE: CFIF
>
>
> Oh, I see.
>
> Try  this.
>
> 
> 
> > 
>
> -Original Message-
> From: netman [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 25, 2000 8:27 PM
> To: CF-Talk
> Subject: Re: CFIF
>
>
> Thanks again,
>
> But I want to know what URL the user is trying to goto, it should be
> something like the URL they put in there address box in the browser.
>
> Thanks,
> Robert
>
> - Original Message -
> From: "James McCullough" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, November 25, 2000 10:22 PM
> Subject: RE: CFIF
>
>
> > If you are trying to find out where the user is coming from in order to
> > redirect them use cgi.http_referer like this
> >
> > 
> > 
> > 
> >
> > -Original Message-----
> > From: netman [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, November 25, 2000 7:54 PM
> > To: CF-Talk
> > Subject: CFIF
> >
> >
> > Good Evening,
> >
> > Trying to figure out how to do a cfif on the url that is being passed.
> Need
> > to redirect according to the url that the user has try to go to.
> >
> > Just not sure about the syntax to use to compare according to the url.
> > Tried xyz  But did not work.  I
> thought it would
> > be similar to a url.var.
> >
> > Can anyone help,
> >
> > Robert
> >
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
> > http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official
> book at http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFIF IsDefined

[Donna French]

I want to thank you all for being patient with me. I have started
rebuilding our site in CFMX and trying to learn all aspects as I go
this time around.

Shouldn't this work I am trying to display date but if there is no
date, display a blank text field.


value="#LSDateFormat(rsClientDetails.Client_ClosedDate,'M/DD/YY')#">

TIA,
Donna
-- 

Donna French
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

cfif issues

[Phillip Perry]

Hi,

assuming all variables are correct what is wrong with this code?




#ListFiles.name#


When i click on the very first link the path looks similar to this..

testftp.cfm?directory=wwwroot

So the next page would have links that should now look similar to this..

testftp.cfm?directory=wwwroot/images

however something is failing with the IsDefined statement becauase I'm
getting this..

testftp.cfm?directory=images

Does anyone have any thoughts?

Phil




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

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

cfif help

[Steven Sprouse]

I need help figuring out how to display a link if an ID type is 1 or 2 (as 
defined in by database) but not displaying the link if the ID type is 3 or 4. I 
know this should be easy, but I keep screwing it up.

The page that I'm working from is 
http://www2.ccboe.com/schoolscenters/viewschool.cfm?id=22 (just picked an ID at 
random). For elementary and middle schools I want to display a School Supply 
link in the resources section at the bottom. For High schools and centers, I do 
not want to display that link.

Can anyone help me? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324458
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfif help

[Steven Sprouse]

I need help figuring out how to display a link if an ID type is 1 or 2 (as 
defined in by database) but not displaying the link if the ID type is 3 or 4. I 
know this should be easy, but I keep screwing it up.

The page that I'm working from is 
http://www2.ccboe.com/schoolscenters/viewschool.cfm?id=22 (just picked an ID at 
random). For elementary and middle schools I want to display a School Supply 
link in the resources section at the bottom. For High schools and centers, I do 
not want to display that link.

Can anyone help me? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324459
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfif contains

[Phillip Vector]

1. No need for # inside the cfif. :)

2. You shouldn't need to trim it if you use a contains.

3. You set CPU to a single value of AMD. Therefore, cpu.description
doesn't exist anymore.

On Sun, Oct 17, 2010 at 2:03 PM, Rick Sanders  wrote:
>
> How can I do a cfif contains?
>
> Error I am getting:
>
> You have attempted to dereference a scalar variable of type class
> java.lang.String as a structure with members.
>
>
> The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6
>
> 4 : 
> 5 : 
> 6 :     
>
>
> I hope someone can shed some light on this. thanks!
>
> Rick
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338259
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: cfif contains

[Rick Sanders]

Thanks!

I realized what I did afterwards. Just coping and pasting code isn't the
best way to do things always. I re-coded it and it works great thanks!

Rick

-Original Message-
From: Phillip Vector [mailto:vec...@mostdeadlygame.com] 
Sent: Sunday, October 17, 2010 6:06 PM
To: cf-talk
Subject: Re: cfif contains


1. No need for # inside the cfif. :)

2. You shouldn't need to trim it if you use a contains.

3. You set CPU to a single value of AMD. Therefore, cpu.description
doesn't exist anymore.

On Sun, Oct 17, 2010 at 2:03 PM, Rick Sanders  wrote:
>
> How can I do a cfif contains?
>
> Error I am getting:
>
> You have attempted to dereference a scalar variable of type class
> java.lang.String as a structure with members.
>
>
> The error occurred in E:\Websites\nscomputers\systembuilder2.cfm: line 6
>
> 4 : 
> 5 : 
> 6 :     
>
>
> I hope someone can shed some light on this. thanks!
>
> Rick
>
>
>
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338260
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Arrays and CFIF

[Chris Farrugia]

I have an array that catalogues a bunch of products and categories... for
instance, ProductIDArray[1][1] is "Case" and ProductIDArray[1][2] could be
"Mid Tower."  With that in mind, this is for a system configurator...  now,
there are checkboxes for SOftware...  if they check one, then it goes into
the productIDArray... if they check two, then ProductIDArray[21][1] becomes
Additional Software and ProductIDArray[21][2] becomes two product ID's like
131,132.  So...  all I want to do is say "If ProductIDArray[21][2] has a
value, then do the following..."

How can I do that?  The code I'm trying is:



This comes back with the following error...

Error Diagnostic Information

 The element at position 21 in dimension 1 of object "ProductIDArray" cannot
be found. The object has elements in positions 1 through 20. Please, modify
the index expression.

 The error occurred while evaluating the expression:

  len(#ProductIDArray[21][2]#) IS NOT 0

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Array and CFIF

[Chris Farrugia]

I have an array that catalogues a bunch of products and categories... for
instance, ProductIDArray[1][1] is "Case" and ProductIDArray[1][2] could be
"Mid Tower."  With that in mind, this is for a system configurator...  now,
there are checkboxes for SOftware...  if they check one, then it goes into
the productIDArray... if they check two, then ProductIDArray[21][1] becomes
Additional Software and ProductIDArray[21][2] becomes two product ID's like
131,132.  So...  all I want to do is say "If ProductIDArray[21][2] has a
value, then do the following..."

How can I do that?  The code I'm trying is:



This comes back with the following error...

Error Diagnostic Information

 The element at position 21 in dimension 1 of object "ProductIDArray" cannot
be found. The object has elements in positions 1 through 20. Please, modify
the index expression.

 The error occurred while evaluating the expression:

  len(#ProductIDArray[21][2]#) IS NOT 0

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFIF and CFELSE

[Willy Ray]

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_2C7475F2.A6C7A9E6
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

There Must be something I don't know about CFIF.  I want to check if a URL =
variable exists.  If it does, I want to add the same variable to the URL =
of the action of a CFForm, basically so I can check for it on the action =
page, and use it to re-route a cflocation. =20

Here's the problem.  I have a CFIF that, if it's true, starts a CFFORM =
with the URL variable included in the action, then it has a CFELSE that =
starts the same form, just without the URL variable.  Problem is, it =
doesn't work.  Tells me that there's an extraneous  at the bottom =
of the template.  Basically, whether or not the criterion is met, it =
doesn't start the form. =20

I musta missed something about CFIF, CFELSE, or CFFORM.  Any Ideas?  =
Here's my logic:




   
  
   =

 


Whether myvariable exists or not it doesn't print either of the cfform =
lines.

--=_2C7475F2.A6C7A9E6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML






There Must be something I don't know about CFIF.  I =
want=20
to check if a URL variable exists.  If it does, I want to add =
the same=20
variable to the URL of the action of a CFForm, basically so I can check =
for it=20
on the action page, and use it to re-route a cflocation.  
 
Here's the problem.  I have a CFIF that, if it's true, starts a =
CFFORM=20
with the URL variable included in the action, then it has a CFELSE that =
starts=20
the same form, just without the URL variable.  Problem is, it =
doesn't=20
work.  Tells me that there's an extraneous </CFFORM> at the =
bottom of=20
the template.  Basically, whether or not the criterion is met, it =
doesn't=20
start the form.  
 
I musta missed something about CFIF, CFELSE, or CFFORM.  Any=20
Ideas?  Here's my logic:
 
 
 
<cfif IsDefined ('URL.myvariable')>   <cff=
orm=20
action=3D"emp_add_action.cfm?myvariable=3Dtrue" method=3D"post"=20
enablecab=3D"Yes">  <cfelse>   &l=
t;cfform=20
action=3D"emp_add_action.cfm" method=3D"POST"=20
enablecab=3D"Yes"> </cfif>
 
 
Whether myvariable exists or not it doesn't print either of the =
cfform=20
lines.

--=_2C7475F2.A6C7A9E6--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF problems

[Deanna L. Schneider]

The error is occuring because the  tag exists outside the
 tags. In other words, you have things incorrectly nested. It
would be better do something like this:

?variable=#url.yourvariable#"
method="post">

Hope that helps.
-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF question...

[Erki Esken]

do something

Erki

- Original Message -
From: "Gary McNeel, Jr." <[EMAIL PROTECTED]>
To: "Cf-Talk" <[EMAIL PROTECTED]>
Cc: "theCrewOnly" <[EMAIL PROTECTED]>
Sent: Wednesday, July 19, 2000 7:07 PM
Subject: CFIF question...


> can you use BETWEEN or maybe IN in a cfif?
>
> ex: do something
> ex: do something
>
> Is there a better, faster way to do this?
>
> Thanks.
>
> Gary McNeel, Jr.
> Project Manager - DAC-Net, Research & Graduate Studies
> Rice University - Houston
> [Lovett Hall] 713-348-6266 (Primary)
> [DAC] 713-348-5184
> [M] 713-962-0885
> [H] 713-723-9240
>
> "Great spirits have always encountered violent opposition from
mediocre
> minds."
>-Albert Einstein
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF question...

[David Shadovitz]

Putting aside the "better, faster" part, searching the CF docs for
"operators" reveals that CF supports {IS, IS NOT, CONTAINS, DOES NOT
CONTAIN, GREATER THAN, LESS THAN, GREATER THAN OR EQUAL TO, LESS THAN OR
EQUAL TO}.  All but the two CONTAINS and its opposite have abbreviations.

For "BETWEEN" you'd need to use both GTE and LTE (for an inclusive sense
of BETWEEN).

-David

> can you use BETWEEN or maybe IN in a cfif?
> 
> ex: do something
> ex: do something
> 
> Is there a better, faster way to do this?


YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFIF and CFMAIL

[Jim Watkins]

The following will not work.  Exactly what do I need to do to change the
mail header based on a variable?  I sure would appreciate help on this :)









etc, etc,




Jim Watkins
http://www.clarkes.tec.ga.us/blairsville


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFIF statement problem

[Cfmarksport]

Hi again,

First, thank you so much to Bill & Dana for your advice.  I was able to fix 
those things you pointed out to me.  I feel good that you didn't say "your 
approach is entirely wrong." LOL

But now I'm getting a new error.  A person comes to our site at 
http://www.marksport.com/testsandbox/registerform.cfm and enters their email 
address.  I want to query the database (which is built and accessible but has 
absolutely no data in it at the moment) and send them to 
http://www.marksport.com/testsandbox/updateform.cfm if their email exists in 
the database OR http://www.marksport.com/testsandbox/shortform.cfm if it does 
not.  To that end I have this  and query (among other things)...


 


SELECT uid, email
FROM user_info_basic
WHERE email = variable.user








HELP  It goes to updateform.cfm, which, of course, cannot parse correctly 
because there is nothing in the database to parse.  I've tried different 
things before writing this email.  Can't seem to find a setup that works.

Thank you in advance for your help.

:-)
Oriole
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF Statement

[Randell B Adkins]

#LASTNAME#

>>> [EMAIL PROTECTED] 06/24/02 12:10PM >>>
Trying to do a CFOUTPUT Statement that returns all of the lastname
records
that begin with the letter "A", and order by lastnames, but the
following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent


__
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: CFIF Statement

[Tony Gruen]

Give this a try - (off the top of my head)

Tony Gruen






-Original Message-
From: Kent A. Orso [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 9:11 AM
To: CF-Talk
Subject: CFIF Statement


Trying to do a CFOUTPUT Statement that returns all of the lastname records
that begin with the letter "A", and order by lastnames, but the following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent


__
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: CFIF Statement

[Michael Dinowitz]

Your code will only show those lastnames that ARE A, not that begin with A. Try this

The Left function will take the variable and return a number of characters from it. In 
the above example, it will return the first letter. This letter can then be compared 
to A. There are other ways of doing this, but I think the above will suffice.

At 12:10 PM 6/24/02, you wrote:
>Trying to do a CFOUTPUT Statement that returns all of the lastname records
>that begin with the letter "A", and order by lastnames, but the following is
>not working, any ideas?
>
>#LASTNAME#
>
>
>Thanks in advance,
>Kent
>
>
__
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: CFIF Statement

[Adrian Lynch]

That will only output lastnames that are A, not lastnames that begin with A.

-Original Message-
From: Kent A. Orso [mailto:[EMAIL PROTECTED]]
Sent: 24 June 2002 17:11
To: CF-Talk
Subject: CFIF Statement


Trying to do a CFOUTPUT Statement that returns all of the lastname records
that begin with the letter "A", and order by lastnames, but the following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent


__
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: CFIF Statement

[Jim Vosika]

#LASTNAME#

HTH,
Jim Vosika
http://www.softwaresupermall.com


-Original Message-
From: Kent A. Orso [mailto:[EMAIL PROTECTED]] 
Sent: Monday, June 24, 2002 11:11 AM
To: CF-Talk
Subject: CFIF Statement

Trying to do a CFOUTPUT Statement that returns all of the lastname
records
that begin with the letter "A", and order by lastnames, but the
following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent


__
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: CFIF Statement

[Philip Arnold - ASP]

> Trying to do a CFOUTPUT Statement that returns all of the
> lastname records that begin with the letter "A", and order
> by lastnames, but the following is not working, any ideas?
>
> #LASTNAME#

Your CFIF says that the WHOLE LastName must be "A"

Try



Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911

www.aspmedia.co.uk
www.aspevents.net

An ISO9001 registered company.

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


__
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: CFIF Statement

[Bryan Stevenson]

That said, I'd make the database do the work and run a query that only retrieves 
lastnames that
start with A.

my 2 cents

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Kent A. Orso" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 9:10 AM
Subject: CFIF Statement


> Trying to do a CFOUTPUT Statement that returns all of the lastname records
> that begin with the letter "A", and order by lastnames, but the following is
> not working, any ideas?
>
> #LASTNAME#
>
>
> Thanks in advance,
> Kent
>
> 
__
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: CFIF Statement

[Star Interactive (John Ceci)]

Kent,

What Michael said...but just as follow-up...if you did it with your SQL
statement instead in CF you would probably see a nice performance hit too...

WHERE tablename.lastname LIKE 'A%'

HTH,
John

-Original Message-
From: Kent A. Orso [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 12:11 PM
To: CF-Talk
Subject: CFIF Statement


Trying to do a CFOUTPUT Statement that returns all of the lastname records
that begin with the letter "A", and order by lastnames, but the following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent


__
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: CFIF Statement

[Jim Vosika]

Or somehow work in Query of Querys if it is appropriate for this
task

My 2¢

Jim Vosika
http://www.softwaresupermall.com


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, June 24, 2002 11:23 AM
To: CF-Talk
Subject: Re: CFIF Statement



That said, I'd make the database do the work and run a query that only
retrieves lastnames that
start with A.

my 2 cents

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Kent A. Orso" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 9:10 AM
Subject: CFIF Statement


> Trying to do a CFOUTPUT Statement that returns all of the lastname
records
> that begin with the letter "A", and order by lastnames, but the
following is
> not working, any ideas?
>
> #LASTNAME#
>
>
> Thanks in advance,
> Kent
>
> 

__
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: CFIF Statement

[Kent A. Orso]

Thanks for the information, how would I keep the database from displaying
the remaining LASTNAME records that don't start with "A"?

This is what I have thus far,


SELECT LASTNAME, FIRSTNAME, DEPARTMENT
FROM olist
ORDER BY LASTNAME



#LASTNAME#, #FIRSTNAME#
#DEPARTMENT#




- Original Message -
From: "Randell B Adkins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 12:13 PM
Subject: Re: CFIF Statement


#LASTNAME#

>>> [EMAIL PROTECTED] 06/24/02 12:10PM >>>
Trying to do a CFOUTPUT Statement that returns all of the lastname
records
that begin with the letter "A", and order by lastnames, but the
following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent



__
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: CFIF Statement

[Randell B Adkins]

Two ways

ONE: Add the WHERE condition to the Query:

SELECT LASTNAME, FIRSTNAME, DEPARTMENT
FROM olist
WHERE LEFT(LASTNAME,1) = 'A'
ORDER BY LASTNAME


*** You can subsitute a variable for the letter if needed then display
all records.



OR

TWO:
Leave the query as it is and use a condition on the output area:


#LASTNAME#, #FIRSTNAME#
#DEPARTMENT#






>>> [EMAIL PROTECTED] 06/24/02 12:42PM >>>
Thanks for the information, how would I keep the database from
displaying
the remaining LASTNAME records that don't start with "A"?

This is what I have thus far,


SELECT LASTNAME, FIRSTNAME, DEPARTMENT
FROM olist
ORDER BY LASTNAME



#LASTNAME#, #FIRSTNAME#
#DEPARTMENT#




- Original Message -
From: "Randell B Adkins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 12:13 PM
Subject: Re: CFIF Statement


#LASTNAME#

>>> [EMAIL PROTECTED] 06/24/02 12:10PM >>>
Trying to do a CFOUTPUT Statement that returns all of the lastname
records
that begin with the letter "A", and order by lastnames, but the
following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent




__
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: CFIF Statement

[Michael Dinowitz]

 
SELECT LASTNAME, FIRSTNAME, DEPARTMENT 
FROM olist 
WHERE LASTNAME LIKE 'A%'
ORDER BY LASTNAME 

The added WHERE clause says only get the rows where the lastname starts with A.

At 12:42 PM 6/24/02, you wrote:
>Thanks for the information, how would I keep the database from displaying
>the remaining LASTNAME records that don't start with "A"?
>
>This is what I have thus far,
>
>DATASOURCE="clast"
>NAME="list"
>>
>SELECT LASTNAME, FIRSTNAME, DEPARTMENT
>FROM olist
>ORDER BY LASTNAME
>
>
>
>#LASTNAME#, #FIRSTNAME#
>#DEPARTMENT#
>
>
>
>
>- Original Message -
>From: "Randell B Adkins" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, June 24, 2002 12:13 PM
>Subject: Re: CFIF Statement
>
>
>#LASTNAME#
>
>>>> [EMAIL PROTECTED] 06/24/02 12:10PM >>>
>Trying to do a CFOUTPUT Statement that returns all of the lastname
>records
>that begin with the letter "A", and order by lastnames, but the
>following is
>not working, any ideas?
>
>#LASTNAME#
>
>
>Thanks in advance,
>Kent
>
>
>
>
__
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: CFIF Statement

[Jim Vosika]

You could use Query of Query or  simply:

#LASTNAME#

Jim Vosika
http://www.softwaresupermall.com


-Original Message-
From: Kent A. Orso [mailto:[EMAIL PROTECTED]] 
Sent: Monday, June 24, 2002 11:42 AM
To: CF-Talk
Subject: Re: CFIF Statement

Thanks for the information, how would I keep the database from
displaying
the remaining LASTNAME records that don't start with "A"?

This is what I have thus far,


SELECT LASTNAME, FIRSTNAME, DEPARTMENT
FROM olist
ORDER BY LASTNAME



#LASTNAME#, #FIRSTNAME#
#DEPARTMENT#




- Original Message -
From: "Randell B Adkins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 12:13 PM
Subject: Re: CFIF Statement


#LASTNAME#

>>> [EMAIL PROTECTED] 06/24/02 12:10PM >>>
Trying to do a CFOUTPUT Statement that returns all of the lastname
records
that begin with the letter "A", and order by lastnames, but the
following is
not working, any ideas?

#LASTNAME#


Thanks in advance,
Kent




__
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: CFIF Statement

[Philip Arnold - ASP]

> 
> #LASTNAME#, #FIRSTNAME#
> #DEPARTMENT#
> 

On top of the Query suggestions...

What you're doing here is only not displaying the surname, but quite
happily displaying the FirstName and Department, no matter what the name
is...

Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911

www.aspmedia.co.uk
www.aspevents.net

An ISO9001 registered company.

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


__
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: CFIF Questions

[Terri Stocke]

Laura,

What I do is place a blank option tag in my query-driven select field, like 
so, making sure that it is selected by default:





Then in your action page:


Error!  You must select a state!




Terri

Original Message Follows
From: LH Rothman <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF Talk <[EMAIL PROTECTED]>
Subject: CFIF Questions
Date: Thu, 24 Aug 2000 21:34:57 -0700

Hello!

I want to force folks to select a state but I'm using CFSELECT and the
required tag doesn't work with it.  Consequently I'm attempting to
modify the CFIF statement on my action page with little success.  I've
tried this:


Error!  You must select a state!



but it doesn't work.  The ultimate goal is to require folks to select at
MINIMUM a state in this search and give them an error if they select
nothing.  I know I'm making a stupid mistake and and any help would be
very appreciated!!!

Thank you,
-Laura
An Apparent Newbie!


-- My Action page in progress--


SELECT Zip, City, County, State, Business, Phone, Fax, Website, Email,
Street1, Legal, Comments
FROM Contacts
WHERE Legal LIKE '1'


  AND Business LIKE '#Business#%'


  AND City LIKE '#City#%'


  AND County LIKE '#County#%'


  AND Zip LIKE '#Zip#%'


  AND State LIKE '#State#%'

ORDER BY Business




Search Results





Found #Contacts.RecordCount# Matches







#Business#
#Street1#N/A
#City#, #State# #Zip#
PH: #Phone#N/A
FX: #Fax#N/A
Web: #Website#N/A
Email: mailto:#Email#">#Email#N/A
#Comments#











--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
the body.


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFCASE/CFIF

[Michael 'Maxx' Porter]

If you have more than 2 choices then SWITCH/CASE is faster.  The down side 
to SWTICH/CASE is CASE has to be constant it cannot be a varaiable.

At 11:24 PM 9/24/00 -0400, you wrote:
>Is CFCASE faster then CFIF?
>
>Also, execution time wise.. I'm hitting upwards of 500ms or so when I
>usually only hit about 100-200ms.. but I'm setting about 100CFparams in this
>so 500 I guess is expected.
>
>Is 500ms slow?  This is my dev machine.. p2 300, 256mb ram, win2k, mysql
>3.23.24.
>
>thanks!
>
>jake --more below.
>422 milliseconds
>   282 ms D\ADDPLAN.CFM
>   93 ms D\ADDPLANCASE.CFM
>   16 ms D\FOOTER.INC
>   0 ms D\HEADER.INC
>   31 ms STARTUP, PARSING, & SHUTDOWN
>
>
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

end
*
Every child is an artist. The problem is how to remain an artist once he
grows up. -Pablo Picasso, painter and sculptor (1881-1973)
*
Michael "Maxx" Porter
Vice President
Paradox Studios Inc.
847-869-3673
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFCASE/CFIF

[Peter Tilbrook]

Depending on how it is used CFCASE is usually faster than CFIF (or nested
CFIF's).

If CFCASE will do what you want it would be the better method.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFCASE/CFIF

[Peter Tilbrook]

If you have more than 2 choices then SWITCH/CASE is faster.

The down side to SWTICH/CASE is CASE has to be constant it cannot be a
varaiable.

>>It can indeed be a variable however you need to know what you are checking
for. If all CFCASES fail then you can use the CFDEFAULTCASE to perform
default processing or error correction.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFCASE/CFIF

[Gunawan]

- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 11:10 AM
Subject: RE: CFCASE/CFIF


> Depending on how it is used CFCASE is usually faster than CFIF (or nested
> CFIF's).
>
> If CFCASE will do what you want it would be the better method.
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFCASE/CFIF

[Jake Hileman]

Okay also.. about my MS question.

I have a form with about 25 check boxes.. so the processing of checking if
they are checked, etc.. makes my one template run at about 600-800ms.. while
every other template on the site runs at around 200ms or less.

The db time is 0-20ms.. so it's very fast.

I am doing the following:

test.cfm?action=insert
action can be, insert, update, delete.

action is a cfswitch and each switch loads up 3 include files.. about 40k in
total include text with about 2-3 quick db calls.  the 3 include files
include all the large code to check the checkboxes out, etc. and a header
and footer.

this takes upwards of 800ms... I've never written anything so far that took
over 400ms or so on this machine.

is my coding bad?  is 800ms slow?

thanks,

jake

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFCASE/CFIF

[Hayes, David]

Turn on your debugging and look at the execution times for each template.

-Original Message-
From: Jake Hileman [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 12:22 AM
To: CF-Talk
Subject: Re: CFCASE/CFIF


Okay also.. about my MS question.

I have a form with about 25 check boxes.. so the processing of checking if
they are checked, etc.. makes my one template run at about 600-800ms.. while
every other template on the site runs at around 200ms or less.

The db time is 0-20ms.. so it's very fast.

I am doing the following:

test.cfm?action=insert
action can be, insert, update, delete.

action is a cfswitch and each switch loads up 3 include files.. about 40k in
total include text with about 2-3 quick db calls.  the 3 include files
include all the large code to check the checkboxes out, etc. and a header
and footer.

this takes upwards of 800ms... I've never written anything so far that took
over 400ms or so on this machine.

is my coding bad?  is 800ms slow?

thanks,

jake


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFCASE/CFIF

[Jake Hileman]

Yes, I did that.

Should have been pasted in the previous message at the bottom.

Jake
- Original Message -
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 10:35 AM
Subject: RE: CFCASE/CFIF


> Turn on your debugging and look at the execution times for each template.
>
> -Original Message-
> From: Jake Hileman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 12:22 AM
> To: CF-Talk
> Subject: Re: CFCASE/CFIF
>
>
> Okay also.. about my MS question.
>
> I have a form with about 25 check boxes.. so the processing of checking if
> they are checked, etc.. makes my one template run at about 600-800ms..
while
> every other template on the site runs at around 200ms or less.
>
> The db time is 0-20ms.. so it's very fast.
>
> I am doing the following:
>
> test.cfm?action=insert
> action can be, insert, update, delete.
>
> action is a cfswitch and each switch loads up 3 include files.. about 40k
in
> total include text with about 2-3 quick db calls.  the 3 include files
> include all the large code to check the checkboxes out, etc. and a header
> and footer.
>
> this takes upwards of 800ms... I've never written anything so far that
took
> over 400ms or so on this machine.
>
> is my coding bad?  is 800ms slow?
>
> thanks,
>
> jake
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF discussion

[William J Wheatley]

I and many others us a methology *looks around* called fusebox
www.fusebox.org.
Its a way we write and organize code so its easier to read, to develop with
multiple users, etc. Read the site you may find it more to your liking if
you need anymore help with it, goto www.houseoffusion.com and join the
FUSEBOX talk list. And the fuseboxers (myself included) will be more the
happy to help ya.



"Please forward all Complaints to /dev/null"

Bill Wheatley
Director of Development
AEPS INC
Allaire Coldfusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645


- Original Message -
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 9:10 AM
Subject: CFIF discussion


> Hi,
>
> I'm 5 weeks into Cold Fusion and have a question for the Experienced
Masses.
>
> So far in my programming, I try to keep all the code in one file as much
as
> possible.  For example, if I have a form that is used as part of a Query,
> then I'll obviously "post" that form' data to the same page, resulting in
a
> number of .
>
> However, at what stage would you suggest that this isn't a good idea?
I've
> been doing a small sub-project today which is about 400 lines long, and by
> 17:00 will be considerably bigger.  Is this a case of "whatever suits you
> best?"
>
> I'd be interested to hear everyone's opinions.
>
> Will
>
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF discussion

[paul smith]

Run, don't walk, to www.fusebox.org for a methodology
many like that is just the opposite of what you are
trying.

best,  paul

At 02:10 PM 10/4/00 +0100, you wrote:
>Hi,
>
>I'm 5 weeks into Cold Fusion and have a question for the Experienced Masses.
>
>So far in my programming, I try to keep all the code in one file as much as
>possible.  For example, if I have a form that is used as part of a Query,
>then I'll obviously "post" that form' data to the same page, resulting in a
>number of .
>
>However, at what stage would you suggest that this isn't a good idea?  I've
>been doing a small sub-project today which is about 400 lines long, and by
>17:00 will be considerably bigger.  Is this a case of "whatever suits you
>best?"
>
>I'd be interested to hear everyone's opinions.
>
>Will
>
>
>
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFIF discussion

[Robert Everland]

Or we can just answer your question. If it's getting huge the best part is
to use a method from the fusebox methodology which is to take the code you
have between your if statements and make them other pages. So you have maybe
5 cfif and the total code is 500 lines you can break it up so instead of the
code there is a cfinclude there. Fusebox isn't the save all method of this
world, you can take a look at it, but you just wanted a simple answer and
there you go.

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 9:16 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: Re: CFIF discussion


Run, don't walk, to www.fusebox.org for a methodology
many like that is just the opposite of what you are
trying.

best,  paul

At 02:10 PM 10/4/00 +0100, you wrote:
>Hi,
>
>I'm 5 weeks into Cold Fusion and have a question for the Experienced
Masses.
>
>So far in my programming, I try to keep all the code in one file as much as
>possible.  For example, if I have a form that is used as part of a Query,
>then I'll obviously "post" that form' data to the same page, resulting in a
>number of .
>
>However, at what stage would you suggest that this isn't a good idea?  I've
>been doing a small sub-project today which is about 400 lines long, and by
>17:00 will be considerably bigger.  Is this a case of "whatever suits you
>best?"
>
>I'd be interested to hear everyone's opinions.
>
>Will
>
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF discussion

[W Luke]

I could have predicted someone suggesting that!  It's something I've read
and talked about with many in here...haven't got round to implementing it
yet though..

Will
- Original Message -
From: "paul smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 2:16 PM
Subject: Re: CFIF discussion


> Run, don't walk, to www.fusebox.org for a methodology
> many like that is just the opposite of what you are
> trying.
>
> best,  paul
>
> At 02:10 PM 10/4/00 +0100, you wrote:
> >Hi,
> >
> >I'm 5 weeks into Cold Fusion and have a question for the Experienced
Masses.
> >
> >So far in my programming, I try to keep all the code in one file as much
as
> >possible.  For example, if I have a form that is used as part of a Query,
> >then I'll obviously "post" that form' data to the same page, resulting in
a
> >number of .
> >
> >However, at what stage would you suggest that this isn't a good idea?
I've
> >been doing a small sub-project today which is about 400 lines long, and
by
> >17:00 will be considerably bigger.  Is this a case of "whatever suits you
> >best?"
> >
> >I'd be interested to hear everyone's opinions.
> >
> >Will
> >
> >
> >
>
>---
---
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
>
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFIF discussion

[Paul Johnston]

I have tried this before and have come up with two important points.

Don't use a bunch of


Do processing...

Do processing...

Do processing...

Do processing...

Do processing...


Use



Do processing...


Do processing...


Do processing...


Do processing...


Do processing...



It's much much quicker.

Also, take a look at fusebox (it uses the idea of using one page to do all
the work as it's basis) at www.fusebox.org

Paul

> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: 04 October 2000 14:11
> To: CF-Talk
> Subject: CFIF discussion
>
>
> Hi,
>
> I'm 5 weeks into Cold Fusion and have a question for the
> Experienced Masses.
>
> So far in my programming, I try to keep all the code in one file
> as much as
> possible.  For example, if I have a form that is used as part of a Query,
> then I'll obviously "post" that form' data to the same page,
> resulting in a
> number of .
>
> However, at what stage would you suggest that this isn't a good
> idea?  I've
> been doing a small sub-project today which is about 400 lines long, and by
> 17:00 will be considerably bigger.  Is this a case of "whatever suits you
> best?"
>
> I'd be interested to hear everyone's opinions.
>
> Will
>
>
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF discussion

[Billy Cravens]

I'm not going to jump on the Fusebox methodology bandwagon (though I do
use it, and it's decent, but I do not necessarily recommend it those new
to ColdFusion), but I will say that the idea behind Fusebox is a sound
one that you want to encompass.  You need to break your file up.  First
of all, it makes your code more maintainable.  Secondly, there's very
little overhead by doing so.  Additionally, multiple files is the norm
in the industry, so unless your going to be working for the same company
all your life, and they never change methodologies, you want to gear
your "education" towards what is most useful (whether it's
page1.cfm->page2.cfm->page3.cfm or
index.cfm?fuseaction=1->index.cfm?fuseaction=2, etc.).

I will caution you, and I've said it before:
Be very careful about separating language from methodology.  Whether you
keep an application the size of Amazon in one big .cfm file, traditional
linear development, FuseBox, CFObject, JoeBox, BillObjects, or whatever,
make sure you can separate that from CFML itself.  However, if you feel
very comfortable with your overall knowledge of ColdFusion, by all
means, try different methodology (just don't become a card-carrier :)

-- 
Billy Cravens
[EMAIL PROTECTED]


W Luke wrote:
> 
> Hi,
> 
> I'm 5 weeks into Cold Fusion and have a question for the Experienced Masses.
> 
> So far in my programming, I try to keep all the code in one file as much as
> possible.  For example, if I have a form that is used as part of a Query,
> then I'll obviously "post" that form' data to the same page, resulting in a
> number of .
> 
> However, at what stage would you suggest that this isn't a good idea?  I've
> been doing a small sub-project today which is about 400 lines long, and by
> 17:00 will be considerably bigger.  Is this a case of "whatever suits you
> best?"
> 
> I'd be interested to hear everyone's opinions.
> 
> Will
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFIF discussion

[W Luke]

I seeI think I have 5 Cfifs for example one page, all determining the
value of action - if the 5th value is true, then all 5 have to be tested and
rejected...ah ha.  That's messy.

Cool, thanks.

Will
- Original Message -
From: "Paul Johnston" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Wednesday, October 04, 2000 2:29 PM
Subject: RE: CFIF discussion


> I have tried this before and have come up with two important points.
>
> Don't use a bunch of
>
> 
> Do processing...
> 
> Do processing...
> 
> Do processing...
> 
> Do processing...
> 
> Do processing...
> 
>
> Use
>
> 
> 
> Do processing...
> 
> 
> Do processing...
> 
> 
> Do processing...
> 
> 
> Do processing...
> 
> 
> Do processing...
> 
> 
>
> It's much much quicker.
>
> Also, take a look at fusebox (it uses the idea of using one page to do all
> the work as it's basis) at www.fusebox.org
>
> Paul
>
> > -Original Message-
> > From: W Luke [mailto:[EMAIL PROTECTED]]
> > Sent: 04 October 2000 14:11
> > To: CF-Talk
> > Subject: CFIF discussion
> >
> >
> > Hi,
> >
> > I'm 5 weeks into Cold Fusion and have a question for the
> > Experienced Masses.
> >
> > So far in my programming, I try to keep all the code in one file
> > as much as
> > possible.  For example, if I have a form that is used as part of a
Query,
> > then I'll obviously "post" that form' data to the same page,
> > resulting in a
> > number of .
> >
> > However, at what stage would you suggest that this isn't a good
> > idea?  I've
> > been doing a small sub-project today which is about 400 lines long, and
by
> > 17:00 will be considerably bigger.  Is this a case of "whatever suits
you
> > best?"
> >
> > I'd be interested to hear everyone's opinions.
> >
> > Will
> >
> >
> >
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFIF discussion

[Warrick, Mark]

I always split up my logic into various files - queries, business logic, display 
files, etc. but in your case, I would highly recommend you consider using the CFSWITCH 
syntax.  So long as your IF statements are merely flow control statemetns, the 
CFSWITCH tag should work fine for you needs.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 04, 2000 6:11 AM
> To: CF-Talk
> Subject: CFIF discussion
> 
> 
> Hi,
> 
> I'm 5 weeks into Cold Fusion and have a question for the 
> Experienced Masses.
> 
> So far in my programming, I try to keep all the code in one file 
> as much as
> possible.  For example, if I have a form that is used as part of a Query,
> then I'll obviously "post" that form' data to the same page, 
> resulting in a
> number of .
> 
> However, at what stage would you suggest that this isn't a good 
> idea?  I've
> been doing a small sub-project today which is about 400 lines long, and by
> 17:00 will be considerably bigger.  Is this a case of "whatever suits you
> best?"
> 
> I'd be interested to hear everyone's opinions.
> 
> Will
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif help???

[Hayes, David]

I take it your user_id values are character ('user1').


Select user_id
from users
where user_id EQ '#form.user_id#'





Sorry, #form.user_id# is already in use.

create account code





etc.

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 2:08 PM
To: CF-Talk
Subject: cfif help???


I am trying to set up a form that compares the form field user_id to the
database.  Here is what I have written:


Sorry User ID is Taken







I am getting an error saying:
Error Diagnostic Information
InsideText

Cannot convert user1 to boolean.

user1 is what was entered as user id on the form page.

Any ideas,
Rich



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfif help???

[Gavin Myers]

if #user_id# equals #user_id# ?

wouldn't that always return true?

but you could try


Sorry User_ID is taken


but that will always return true... there's a bunch of ways of doign this -
here's one, i'm sure there are better ways


select count(*) as user_id_check
from database
where '#form.userid#' eq user_id



sorry that username is taken




-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 2:08 PM
To: CF-Talk
Subject: cfif help???


I am trying to set up a form that compares the form field user_id to the
database.  Here is what I have written:


Sorry User ID is Taken







I am getting an error saying:
Error Diagnostic Information
InsideText

Cannot convert user1 to boolean.

user1 is what was entered as user id on the form page.

Any ideas,
Rich



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: cfif help???

[Dave Hannum]

Try this:







- Original Message -
From: "HappyToad.com" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 3:08 PM
Subject: cfif help???


I am trying to set up a form that compares the form field user_id to the
database.  Here is what I have written:


Sorry User ID is Taken







I am getting an error saying:
Error Diagnostic Information
InsideText

Cannot convert user1 to boolean.

user1 is what was entered as user id on the form page.

Any ideas,
Rich



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFLOCK and CFIF

[Yager, Brian T Contractor/Sverdrup]

Hello list..Another, hopefully, quick question.  

Is there a problem with putting a cfif tag within a cflock?  Here is an example:

  

  

  Do insert

  
  
  

Would this cause any problems?

Thanks for the help!

Brian Yager
President - North AL Cold Fusion Users Group
http://www.nacfug.com
Sr. Systems Analyst
Sverdrup/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

Cfif cfelse question

[Ben Covington]

Hello All,

I'm trying to develop a way to differentiate between a new record or the
editing of a previous entered record using a single template.  The user
clicks on the link which passes the variable ID to the template for the
cfif new and cfelse edit - but can only get one portion of the template
to show at a time?  I've also tried cfswitch and cfcase to no avail.  

What else should I try?  Any assistance or direction will be greatly
appreciated.  

Best regards, Ben
__
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

CFSCRIPT v CFIF

[Double Down]

Does CFSCRIPT process faster than using CFIF statements? I am using both
and trying to decide if I should use one more than the other throughout
the site.
 
Thank for the info.
 
DDINC
 

~~
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: cfif shorthand

[Bryan Stevenson]

> I'm working on some code that uses a shorthand (I guess...) cfif style
quite
> a bit. I have tried to stay away from doing this since it makes the code
> harder to read, so I never really took the time to figure it out.
>
> For instance...
> 
> Is this testing for the existence of the query or if it is greater than
> zero?

for zero recordcount not existence

>
> 
> This particular one has me scratching my head, it never seems to test
> negative in the code, but what is it testing for?

testing that the date has a length (i.e. if there is a date then it will
test true and proceed...boolean test...true/false...length or not)

>
> Could someone please fill me in here...
>
> jon
> 
~~
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: cfif shorthand

[Bryan Love]

when you omit the comparison operator (EQ, NEQ, IS, GT,...) the IF statement
assumes the value is boolean.  If the value you are testing is not numeric
it will err.  If it is numeric then 0 is FALSE and anything > 0 is TRUE.  

For example:


this will display if any records were returned



this will display if the string is at least one character long



this will display if string is a numeric value GT 0

*** the above example will err if STRING cannot be converted to a number.


+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecomunication 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: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 4:40 PM
To: CF-Talk
Subject: cfif shorthand


I'm working on some code that uses a shorthand (I guess...) cfif style quite
a bit. I have tried to stay away from doing this since it makes the code
harder to read, so I never really took the time to figure it out.

For instance...

Is this testing for the existence of the query or if it is greater than
zero?


This particular one has me scratching my head, it never seems to test
negative in the code, but what is it testing for?

Could someone please fill me in here...

jon

~~
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: cfif shorthand

[Ben Forta]

 is the same as .

TRUE = yes = !0
FALSE = no = 0

So  is testing that there is not 0 records (in other
words, records were retrieved and the query is not empty).

 is testing that Len() does not return 0 (in other
words, the column is not empty).

 will never really test for existence unless you use IsDefined() or
ParameterExists().

--- Ben


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 7:40 PM
To: CF-Talk
Subject: cfif shorthand


I'm working on some code that uses a shorthand (I guess...) cfif style quite
a bit. I have tried to stay away from doing this since it makes the code
harder to read, so I never really took the time to figure it out.

For instance...

Is this testing for the existence of the query or if it is greater than
zero?


This particular one has me scratching my head, it never seems to test
negative in the code, but what is it testing for?

Could someone please fill me in here...

jon

~~
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: cfif shorthand

[Brunt, Michael]

Jon the "recordcount" is testing if the query returned any results.
"len(xx) returns the length of a string or binary object.  You will
probably encounter many more flavors of CFIF's, tags, functions etc.  In my
experience the on-line documents which hopefully were installed with
ColdFusion server are a great reference particularly the tags and functions
listings.  If you have either a local system with ColdFusion Studio and
Server installed you can go to start-programs and find a link to docs there
(if you have 4.5 or less).  Alternatively you can log into ColdFusion
Administrator and find a link to the on-line docs there.

Mike Brunt
Sempra Energy
213.244.5226

"ASCII stupid question, get a stupid ANSI !" 


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 4:40 PM
To: CF-Talk
Subject: cfif shorthand


I'm working on some code that uses a shorthand (I guess...) cfif style quite
a bit. I have tried to stay away from doing this since it makes the code
harder to read, so I never really took the time to figure it out.

For instance...

Is this testing for the existence of the query or if it is greater than
zero?


This particular one has me scratching my head, it never seems to test
negative in the code, but what is it testing for?

Could someone please fill me in here...

jon

~~
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: cfif shorthand

[Brunt, Michael]

And of course, get a hold of one of the great books that abound on CF, I cut
all my teeth on Ben Forta's and can recommend any bearing his name without
reservation. As another quick recommend (slightly O this T) one of the most
understated titles of any book I bought is another Ben Forta gem "Teach
yourself SQL in 10 Minutes".  A very slim volume in size but not content I
always carry it with me.

Mike Brunt
Sempra Energy
213.244.5226

"ASCII stupid question, get a stupid ANSI !" 


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 4:40 PM
To: CF-Talk
Subject: cfif shorthand


I'm working on some code that uses a shorthand (I guess...) cfif style quite
a bit. I have tried to stay away from doing this since it makes the code
harder to read, so I never really took the time to figure it out.

For instance...

Is this testing for the existence of the query or if it is greater than
zero?


This particular one has me scratching my head, it never seems to test
negative in the code, but what is it testing for?

Could someone please fill me in here...

jon

~~
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: CFIF Help

[Joshua Tipton]

Why any I reciving this error?  Thanks for the code Rich it set me in a new
direction which I think is better than the one I was going in.



















#FinalAnswer#

Error Diagnostic Information

An error occurred while evaluating the expression:


 FinalAnswer = ListGetAt(eList, ListPosition, ",")



Error near line 71, column 7.



Parameter 2 of function ListGetAt which is now "0" must be a positive
integer


> -Original Message-
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 1:15 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CFIF Help
>
>
> Not sure you gave enough information for a right answer, but you could
> create two lists to determine which field contains the 1. It's quick and
> dirty and there's probably a better way, but maybe this will get
> you looking
> at it a little differently
>
> 
> 
> 
> 
> 
> 
> 
>
> 
> 
> 
> 
>
> #FinalAnswer#
>
> HTH,
> Steve
>
> "Joshua Tipton" <[EMAIL PROTECTED]> wrote in message
> news:<002201c0d762$a513f7d0$[EMAIL PROTECTED]>...
> > Okay,
> >
> > I have a 7 layer error code.  I want to do a query to display
> only the one
> > that is not 0.  e1-e7.  Six will be 0 and one will be occupied by a 1.
> This
> > is how it will be displayed:   align="center">#ecode# .  What
> > would the code for all of th  tags would be.  Here is the query:
> >
> >
> >  >  datasource="0424_SQL_TSG_DISPOS"
> >  dbtype="ODBC"
> >  username=""
> >  password="">
> > SELECT  RRDD, SLIC, SONum, ModNum, DateArriv, AttnTo,
> Creator, E1, E2,
> > E3, E4, E5, E6, E7
> > FROM exception
> > where rrdd ='#url.dis#' and slic = '#url.slic#'
> > order by datearriv
> > 
> >
> >
> > Joshua Tipton
> >
> >
> >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFIF Help

[David Shadovitz]

ListPosition is 0 because ListFind looks for a matching *element*, not a 
matching *string*.  Use ListContains if you want your search for "1" to return 
the index of the 1st element which contains a "1".
-David

On Monday, May 07, 2001 10:52 PM, Joshua Tipton [SMTP:[EMAIL PROTECTED]] wrote:
> Why any I reciving this error?  Thanks for the code Rich it set me in a new
> direction which I think is better than the one I was going in.
>
>
>
>
>
> 
> 
> 
> 
> 
> 
> 
> 
>
> 
> 
> 
> 
> 
> #FinalAnswer#
>
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
>
>
>  FinalAnswer = ListGetAt(eList, ListPosition, ",")
>
>
>
> Error near line 71, column 7.
> 
> 
>
> Parameter 2 of function ListGetAt which is now "0" must be a positive
> integer
>
>
> > -Original Message-
> > From: Steve Reich [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 08, 2001 1:15 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: CFIF Help
> >
> >
> > Not sure you gave enough information for a right answer, but you could
> > create two lists to determine which field contains the 1. It's quick and
> > dirty and there's probably a better way, but maybe this will get
> > you looking
> > at it a little differently
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> > 
> > 
> >
> > #FinalAnswer#
> >
> > HTH,
> > Steve
> >
> > "Joshua Tipton" <[EMAIL PROTECTED]> wrote in message
> > news:<002201c0d762$a513f7d0$[EMAIL PROTECTED]>...
> > > Okay,
> > >
> > > I have a 7 layer error code.  I want to do a query to display
> > only the one
> > > that is not 0.  e1-e7.  Six will be 0 and one will be occupied by a 1.
> > This
> > > is how it will be displayed:   > align="center">#ecode# .  What
> > > would the code for all of th  tags would be.  Here is the query:
> > >
> > >
> > >> >  datasource="0424_SQL_TSG_DISPOS"
> > >  dbtype="ODBC"
> > >  username=""
> > >  password="">
> > > SELECT  RRDD, SLIC, SONum, ModNum, DateArriv, AttnTo,
> > Creator, E1, E2,
> > > E3, E4, E5, E6, E7
> > > FROM exception
> > > where rrdd ='#url.dis#' and slic = '#url.slic#'
> > > order by datearriv
> > > 
> > >
> > >
> > > Joshua Tipton

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Curious about CFIF

[Tony Hicks]

When you have a CFIF with a CFELSE or CFELSE IF... does cold fusion only
read the code inside the matching condition?

For instance


Name = Bob

Name = Joe


If the name is 'bob' does CF pay any attention to the content to be
processed if the name is joe? and if the name is joe, does it pay any
attention to "bob's content" since it comes first...?

Curious,
Tony Hicks
- Original Message -
From: Bryan LaPlante <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 3:12 AM
Subject: Re: Logon Attempts


> To resolve the problem put this code into login.cfm
> 
> 
> 
> 
> 
>
> You can use cfinclude or call the login.cfm as a custom tag, either way
the
> client scope will persist to the next page load where you can check it for
> the appropriate action.
>
> - Original Message -
> From: "Jerry Staple" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, May 29, 2001 2:35 AM
> Subject: Logon Attempts
>
>
> > Could anyone inform tell me what would be the best way to implement a
> > logon page where the user gets 3 attempts to logon,after the 3 attempts
> > the user is directed elsewhere.I have tried setting a variable on the
> > application page then adding +1 when it goes to the Logon_Action.cfm but
> > to no avail.
> >
> > Help
> >
> >
> > Regards
> > Jerry Staple
> > Web Applications Developer
> > Biznet Solutions
> > 133 - 137 Lisburn Road
> > Belfast
> > BT9 7AG
> > www.biznet-solutions.com
> > Tel: +44 (0)28 90205652
> > Fax: +44 (0)28 9022 3223
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFIF Confusion

[Tangorre, Mike]

I would use type 'bit' for the field instead of varchar. Where 1 is yes and
0 is no, then in your if
check if it is EQ 1 or EQ 0.

Mike



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 10:07 AM
To: CF-Talk
Subject: CFIF Confusion


Hello!

I'm working with SQL Server 2000 and I have a query I'm confused about.
There's a field (FIELD1) that's defined as a VARCHAR.  The field contains
either "Yes" or "No".  I SELECT all records and then want to display
somthing different if FIELD1 is a "Yes" or "No".

  The following structure works:

Bunch of code


This structure does not work:

Bunch of code


I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...

???
Thx
~~
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: CFIF Confusion

[C. Hatton Humphrey]

When in doubt, use Trim() and UCase() functions to make sure, so instead of



try



See if that helps.

Hatton Humphrey

> -Original Message-
> From: Ken Monroe [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 30, 2001 10:07 AM
> To: CF-Talk
> Subject: CFIF Confusion
> 
> 
> Hello!
> 
> I'm working with SQL Server 2000 and I have a query I'm confused about.
> There's a field (FIELD1) that's defined as a VARCHAR.  The field contains
> either "Yes" or "No".  I SELECT all records and then want to display
> somthing different if FIELD1 is a "Yes" or "No".
> 
>   The following structure works:
> 
> Bunch of code
> 
> 
> This structure does not work:
> 
> Bunch of code
> 
> 
> I've also notice that in SQL, if I do a:
> SELECT *
> FROM TableName
> WHERE (FIELD1 LIKE 'yes')
> it works, but
> SELECT *
> FROM TableName
> WHERE (Field1 IS 'yes')
> does not work...
> 
> ???
> Thx
> 
> 
>
~~
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: CFIF Confusion

[Bill Killillay]

If you can change the data type of the Field1 you would be better to make it
a bit field and then use 1 for yes and 0 for no, then your CF logic and your
SQL will probably make more sense.  Right now your trying to do String
Comparisons when what you really want to be doing by what you have put down
below is Boolean comparisons.  Hope that makes sense, please let me know if
you need me to explain more.

-Bill Killillay

-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 10:07 AM
To: CF-Talk
Subject: CFIF Confusion


Hello!

I'm working with SQL Server 2000 and I have a query I'm confused about.
There's a field (FIELD1) that's defined as a VARCHAR.  The field contains
either "Yes" or "No".  I SELECT all records and then want to display
somthing different if FIELD1 is a "Yes" or "No".

  The following structure works:

Bunch of code


This structure does not work:

Bunch of code


I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...

???
Thx
~~
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: CFIF Confusion

[Stephen Hait]

You could check the value of the variable to see if it's really 'Yes' 
or not:

FIELD1='#FIELD1#'


Note single quotes surrounding variable output. Check to see if 
there might be trailing spaces - this might be the problem.

HTH, Stephen


> Hello!
> 
> I'm working with SQL Server 2000 and I have a query I'm confused
> about. There's a field (FIELD1) that's defined as a VARCHAR.  The
> field contains either "Yes" or "No".  I SELECT all records and then
> want to display somthing different if FIELD1 is a "Yes" or "No".
> 
>   The following structure works:
> 
> Bunch of code
> 
> 
> This structure does not work:
> 
> Bunch of code
> 
> 
> I've also notice that in SQL, if I do a:
> SELECT *
> FROM TableName
> WHERE (FIELD1 LIKE 'yes')
> it works, but
> SELECT *
> FROM TableName
> WHERE (Field1 IS 'yes')
> does not work...
> 
> ???
> Thx
> 
> 
>
~~
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: CFIF Confusion

[G]

> 
> I've also notice that in SQL, if I do a:
> SELECT *
> FROM TableName
> WHERE (FIELD1 LIKE 'yes')
> it works, but
> SELECT *
> FROM TableName
> WHERE (Field1 IS 'yes')
> does not work...
> 
> ???
> Thx

Thats because the correct syntax for SQL would be:

WHERE Field1 = 'yes'

"IS" would be the equality check for Cold Fusion.

Brian


~~
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: CFIF Confusion

[Mark Warrick]

I'm not certain why the SQL statements you noted below would work the way
they do, but it's possible that the fields are padded with extra spaces
around the "yes" which is causing a problem.

Converting the field type from varchar to integer will solve the problem.

---mark

=
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=


-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 7:07 AM
To: CF-Talk
Subject: CFIF Confusion


Hello!

I'm working with SQL Server 2000 and I have a query I'm confused about.
There's a field (FIELD1) that's defined as a VARCHAR.  The field contains
either "Yes" or "No".  I SELECT all records and then want to display
somthing different if FIELD1 is a "Yes" or "No".

  The following structure works:

Bunch of code


This structure does not work:

Bunch of code


I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...

???
Thx
~~
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: CFIF Confusion

[Kwang Suh]

That's because IS is not a valid SQL keyword...


I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...



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