Daniel or Bill,
Can I get one of you to actually see the script by connecting to my IP?
Maybe if you see just what it does and since you both understand code, you
could help better?
[EMAIL PROTECTED]
Tony Hicks
----- 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
