RE: Displaying yes/no field dynamically in checkboxes?

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.

RE: date range search

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

RE: date range search

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

RE: How to Allow a "Doesn't Matter" Variable in a Search?

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

RE: Newbie problem: Search on Yes/No Column

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

RE: CF-Talk-list V1 #330

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

RE: Oracle Error 936 missing expression?? Query problem?

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

RE: session variable storage

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

RE: layered security

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

RE: SQL Question (Access)

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

RE: Javascirpt problem on CF

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

RE: 2 CFINSERT on ome page?

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

RE: sql learning

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