NPS - just think you may have performance problems with searching that size
of table in access...
Do you have access to SQL?
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2001 11:15
To: SQL
Subject: Re: Search DB
Sorry about yet another question not being Answered..
I learned Access a long time ago to build address books and have come to
rely on it so much and for the visual interface, i use it..
never used sql server.
----- Original Message -----
From: Daniel Lancelot <[EMAIL PROTECTED]>
To: SQL <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 5:14 AM
Subject: RE: Search DB
> Another point to consider is to allow search ranges (e.g between matthew
and
> John) etc.
>
> Also (And I did ask this before and got no reply) what DB are you using -
Is
> it Access or SQL server???
>
> cheers
>
> Dan
>
> -----Original Message-----
> From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 05:20
> To: SQL
> Subject: Search DB
>
>
> ok so all's well that ends well or something similar, except that it's
> not...
>
> I of course want to let users search the db.. but I want to let them
narrow
> it down only as far as they want to... so if they wall all the verses in
> Romans 8, let them have it..
>
> <cfquery name='searchbible' datasource='thebible'>
> Select
> Book, chapter, verse, textdata from #table# (kjv or AmericanStandard)
> Where
> Book='#book#' and Chapter='#chapter#' and verse='#verse#'
> </cfquery>
>
> <cfoutput>
> .....
> </cfoutput>
>
> The problem is that if I specify book, chapter, and verse, it nails it,
but
> if i don't specify any one of them, it errors out.. and i don't even know
> how to go about searching textdata for a word or phrase..
>
> Help?
>
> Tony Hicks
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
