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: HappyT
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.user
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
ROTECTED]]
> 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
---
>
>
> 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]
&g
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 li
>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
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
>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 Ho
9 matches
Mail list logo