Oh just in case anyone is interested - here is a link to the development
site:
http://202.157.179.158/csandbdirectory
Cheers
-Original Message-
From: Pete [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 January 2007 1:03 PM
To: CF-Talk
Subject: Advanced Search
Hi all
I'm trying to finish
From: Pete [mailto:[EMAIL PROTECTED]
cfquery name=qGetAdvertisers datasource=#request.db_dsn#
username=#request.db_login# password=#request.db_pwd# select *
from tbl_advertisers a, tbl_procedures p, tbl_advertiserprocs ap,
tbl_advertiserstates r, tbl_states s where a.advertiserid =
i assume if they select all states then you don't want
AND s.stateid=#form.stateid#
in the query. so that should be surrounded by a conditional.
On 1/18/07, Pete [EMAIL PROTECTED] wrote:
Oh just in case anyone is interested - here is a link to the development
site:
In other words...and yes by all means cfqueryparam
cfif form.states neq 0 !---assuming the value is 0 in your option for
all states---
where s.stateID = CFQUERYPARAM cfsqltype=cf_sql_integer
value=#form.stateID#
/cfif
Doug B.
- Original Message -
From: Pete [EMAIL PROTECTED]
To:
My question is this - how to I retain the values that
were entered in the search form - so that a user can check
that the records returned are correct according to the search
criteria entered.
The easiest way to do this is to use CFFORM for your form, and set the
PRESERVEDATA
a person can continue to retain the
values which were selected.
Thanks in advance
Pete
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, 13 November 2006 2:22 AM
To: CF-Talk
Subject: RE: Advanced Search
My question is this - how to I retain the values
I looked at the CFForm examples and did some reading on
cfform and preserve data. It appears to work for some fields
such as cfinput, cfslider, cftextinput; but it does not
appear to assist in retaining values selected in a drop
down display.
No, it does allow you to preserve those
: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 11:55 AM
To: CF-Talk
Subject: RE: advanced search
Thanks guys for helping me with this.I looked more in
Verity.Verity only looks at static pages.Since my page is
generated dynamically by the database at runtime, this option
Welcome to the wonderful world of Verity
Remember that each time you add something to the db you should also
add it to the verity colleciton, it is also an idea to have another
(CF) machineperforming the updates to verity to keep it going nice
and fast.
--
Mark Drew
mailto:[EMAIL PROTECTED]
On Wednesday 16 Jun 2004 23:07 pm, Ray Champagne wrote:
What's CFQUERYPARAM?
It turns your query into a statement - which in theory excutes faster, as well
as protecting against SQL injection.
The CF docs are fairly good, ya know.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel:
On Thu, 17 Jun 2004 13:34:38 +0100, Thomas Chiverton wrote:
On Wednesday 16 Jun 2004 23:07 pm, Ray Champagne wrote:
What's CFQUERYPARAM?
It turns your query into a statement - which in theory excutes faster, as well
as protecting against SQL injection.
The CF docs are fairly good, ya
On Thursday 17 Jun 2004 13:57 pm, Philip Arnold wrote:
Erm, you obviously missed the 2nd line of his reply
:looks
After all the random white space ? Yeah...
J/K of course.
:P
I didn't think acronyms had slashes in...
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
Thanks guys for helping me with this.I looked more in Verity.Verity
only looks at static pages.Since my page is generated dynamically by
the database at runtime, this option will not work.I'm still kinda new
to CF and so didn't know about CFQUERYPARAM...but I do now :-)
I am using Microsoft SQL
three can be combined into one index to create
a powerful search capability. That's how we handle search functionality on all our
projects.
:) n.
-Original Message-
From: Frank Dewey [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 6:20 PM
To: CF-Talk
Subject: RE: advanced search
On Thu, 17 Jun 2004 11:19:46 -0500, Frank Dewey wrote:
Thanks guys for helping me with this.I looked more in Verity.Verity
only looks at static pages.
You're clearly not reading the Verity documentation properly
Look at the QUERY attribute of CFINDEX
[Todays Threads]
[This Message]
Nando,
Thanx for that
Frank
From: Nando [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 12:03 PM
To: CF-Talk
Subject: RE: advanced search
Frank,
IF creating the index for dynamic pages is all that's holding you up,
look a little
deeper
Thanks guys for helping me with this.I looked more in
Verity.Verity only looks at static pages.Since my page is
generated dynamically by the database at runtime, this option
will not work.I'm still kinda new to CF and so didn't know
about CFQUERYPARAM...but I do now :-)
You can index
On Wed, 16 Jun 2004 15:59:23 -0500, Frank Dewey wrote:
I'm looking into searching a website for a particular string or
occurence of a string.I would like for this to be an advanced search
(what I am looking for is something more complex than a simple LIKE).
Verity?
In the database -
What's CFQUERYPARAM?
J/K of course.
At 06:06 PM 6/16/2004, you wrote:
On Wed, 16 Jun 2004 15:59:23 -0500, Frank Dewey wrote:
I'm looking into searching a website for a particular string or
occurence of a string.I would like for this to be an advanced search
(what I am looking for is
What kind of database are you using?If you are using Oracle, you might
look into CONTEXT indexes.I'm not sure offhand if they'll do what you want
them to, but they are useful for indexing long text fields.
Other than that your only choice is to use multiple comparisons.
SELECT *
FROM
Look into text indexing in SQL Server, Oracle text in
Oracle, and ?(I've forgotten)? in mysql. LIKE
'%#form.words#%' queries are best avoided, for speed
and feature reasons. In general, text indexing allows
ranked searches, stemming, thesauri, and other nice
featuers.
--- Frank Dewey [EMAIL
besides crystal reports?
-Original Message-
From: Samuel Neff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 2:23 PM
To: CF-Talk
Subject: Advanced search examples, field based searches
I'm looking for examples of search interfaces for end users that provide
fully query type
: Advanced search examples, field based searches
besides crystal reports?
-Original Message-
From: Samuel Neff [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 2:23 PM
To: CF-Talk
Subject: Advanced search examples, field based searches
I'm looking for examples of search
Sam, sounds like I may have some tools that fit the bill.Question though, you mentioned about non-technical end user, well, if so,
IMHO, they are less likely to know AND/OR/NOT operators and let alone RELATIONS etc., on the other hands, there might be a group of savvy users who know about them,
into your database to see if it offers and sort of amplifier support. I belive Oracle does, as well as phonetic engines.
-adam
-Original Message-
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 07:30 PM
To: 'CF-Talk'
Subject: Re: Advanced search
25 matches
Mail list logo