P@tty,
Checkboxes work a bit differently. You'll need to use a simple cfif statement to set
the checked property of the different checkboxes:
Hot tub:
CHECKED">
So if the value of cabinHottub is 1/yes/true, set this form element to 'CHECKED' Use
this for each checkbox.
I think you want to use the CreateODBCDate() function to create your start and end
dates.
Then refer to those in your query *without* 's. (the CreateODBCDate() function puts
them in for you):
SELECT * FROM wwebsales
where orderdate between #startdate# and #enddate#
> -Original Messa
en 01/01/00 and
> 01/01/01"
> Data Source = "wwebsales"
> --
>
> Thanks.
>
> Robert O.
>
> >-Original Message-
> >From: Lamon, Alec [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, April 03, 2001 3:04 P
Patty -- Checkboxes might solve your problem 'cuz they only get passed as form values
if they're *checked.* Therefore, your query could simply string together only the
passed checkboxes for the Boolean case you describe below. The user says 'This
doesn't matter' by simply not checking a parti
P@tty,
Move the ORDER BY clause to the end of everything else and give it a try.
Alec
> -Original Message-
> From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 9:58 AM
> To: CF-Talk
> Subject: Re: Newbie problem: Search on Yes/No Column
>
>
> Randy (and/or a
Michael,
Could you clarify your question? 'Locking' in CF simply controls how many requests can
access a thread at a given time. It does *not* make them last longer than the timeout
value in your tag. If you wish to have variables that last longer
than a session, I would suggest using clien
Shouldn't it read:
SELECT
headline, news, blurb, date_entered, newsID, live, top
FROM news
WHERE live = 'YES' and top = 'NO'
ORDER by date_entered DESC
Alec Lamon
> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 9:19 AM
> To: CF-Talk
Steven...
Do you mean client variables? Session variables are stored in RAM...
Alec Lamon
> -Original Message-
> From: Steven Dworman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 10:46 AM
> To: CF-Talk
> Subject: session variable storage
>
>
>
> registry or database?
>
Janine,
It sounds like you won't need a second login. Since you know the teacher ID after the
first login, can't you run a dynamic query that displays only those students that
attached to a particular teacher ID?
Perhaps I'm misunderstanding your scenario
Alec
> -Original Message---
Michael,
How 'bout doing a subquery that grabs only questions with answers, then having the
main query filter questionID using the IN keyword?
Something like:
SELECT
HNTQuestion.QuestionID,
HNTQuestion.Category,
HNTQuestion.QuestionSh
Well, I see one syntactical error. The OR below should be ||
if(cnt_chk >= 14 OR cnt_chk <=12) // SHould read if(cnt_chk >= 14 ||
cnt_chk <=12)
Don't know if that solves everything...
Alec
> -Original Message-
> From: PEREZ, RICHARD RINGO (SBCSI) [mailto:[EMAIL PROTEC
try using CFQUERY instead of CFINSERT You can string many CFQUERY together into one
transaction.
> -Original Message-
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 29, 2001 12:48 PM
> To: CF-Talk
> Subject: 2 CFINSERT on ome page?
>
>
> Hello cf-talk,
>
>
A great reference book to have around after tutorials is The Practical SQL Handbook by
Bowman, Emerson and Darnovsky
> -Original Message-
> From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 29, 2001 12:30 PM
> To: CF-Talk
> Subject: sql learning
>
>
> Just wonder
13 matches
Mail list logo