RE: cfif help???
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???
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???
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.
RE: CFIF Help
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
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
Re: cfif help
You can try something like this: ... or, a more verbose way, but it can end up being much longer if you add possibilities: ... Francois Levesque http://blog.critical-web.com/ On Mon, Jul 13, 2009 at 9:57 AM, Steven Sprouse wrote: > > 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:324460 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 help
>You can try something like this: > > > ... > > >or, a more verbose way, but it can end up being much longer if you add >possibilities: > > > ... > > >Francois Levesque >http://blog.critical-web.com/ > > > > >> So what if I already have a field in my database called "SchoolTypeID"? >> Where do I reference that? I already pulled that field out in my query of >> that database. ~| 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:324461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfif help
Juste replace type by schoolTypeID > > ... > > >or, a more verbose way, but it can end up being much longer if you add >possibilities: > > > ... > Francois Levesque http://blog.critical-web.com/ On Mon, Jul 13, 2009 at 10:10 AM, Steven Sprouse wrote: > > >You can try something like this: > > > > > > ... > > > > > >or, a more verbose way, but it can end up being much longer if you add > >possibilities: > > > > > > ... > > > > > >Francois Levesque > >http://blog.critical-web.com/ > > > > > > > > > >> So what if I already have a field in my database called "SchoolTypeID"? > Where do I reference that? I already pulled that field out in my query of > that database. > > ~| 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:324462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfif help
>Juste replace type by schoolTypeID > >Francois Levesque >http://blog.critical-web.com/ > > > > >>Got it. Thanks so much for your help! ~| 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:324464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
