Thanks Bryan,
You were right-on with the quotes.
John
On Tue, 09 January 2001, Bryan Batchelder wrote:
>
> throw some single quotes around the office IDs
>
> AND tblReferrals.strRefOfficeIDFK BETWEEN '#StartSort#' AND '#EndSort#'
>
> --b
>
> --------------------------------------------------------
> Bryan Batchelder Home: 727.547.1322
> Web Application Developer Work: 813.935.7100 x427
> Cell: 727.460.6665
> --------------------------------------------------------
> Company: www.connectwise.com
> Personal: pontiphex.stetsonsucks.com
> Personal Key: pontiphex.stetsonsucks.com/pgp.txt
> Work Key: pontiphex.stetsonsucks.com/bbatchelder.asc
> --------------------------------------------------------
> At the macro level, it may appear that I am doing
> nothing. But at the cellular level I am really
> quite busy.
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 09, 2001 3:55 PM
> > To: CF-Talk
> > Subject: Searching Multiple Data Ranges
> >
> >
> > Hello,
> >
> > I am looking for some assistance on searching for data ranges.
> >
> > On my search form I have the following two ranges to search on:
> >
> > <INPUT TYPE="Text" NAME="Datethen"
> > VALUE="#dateFormat(Now()-7)#"> TO <INPUT TYPE="Text"
> > NAME="Datenow" VALUE="#dateFormat(Now())#">
> > <INPUT TYPE="Text" NAME="OfficeIDA"> TO <INPUT TYPE="Text"
> > NAME="OfficeIDB">
> >
> > When I submit the form I am looking for records with a
> > specific date range and office id range.
> >
> > I reassign the OfficeID values on the action page:
> >
> > <CFSET StartSort=form.OfficeID1>
> > <CFSET EndSort=form.OfficeID2>
> >
> > and then use the following query:
> >
> > WHERE tblReferrals.dteRefDate BETWEEN #createodbcdate(form.Datethen)#
> > AND #createodbcdate(form.Datenow)# AND
> > tblReferrals.strRefOfficeIDFK BETWEEN #StartSort# AND #EndSort#
> >
> > The Date range search works but I am having difficulties with
> > the Start and End variables. When I enter values into the
> > OfficeID fields and receive an odbc error "Invalid column name".
> >
> > Any help would be greatly appreciated.
> >
> > Thanks.
> >
> > John
> >
> > Visit www.cfworkshop.com
> > Find the best deals on the web at AltaVista Shopping!
> > http://www.shopping.altavista.com
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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