- see footer for list info -<
The user could put in the title = "green fingers" and I would like to
return more results than just text where the title is like '%green
fingers%'. Though the ISBN could be done with a straight query yes
you're right.
I tried making a seperate collection for each searchable index but this
is obviously a massive waste of space.
Was using FTI on SQL till I realised that the host server wouldnt allow
it :/
Duncan Cumming wrote:
- see footer for list info -<
are you sure Verity is the best means of doing this? If you're using ISBN, that's a unique identifier isn't it? This would probably be a good candidate for a normal SQL query. Verity is ideal for searching large blocks of text, rather than trying to filter it to individual columns.
Select *
from Books
Where Publisher like '%green%' AND ISBN='123456787' AND category=4
etc
Unless you wanted to create seperate collections for Publisher, Author, Title,
etc. Search those as appropriate, and possibly combine with an SQL query at
the end to narrow it down further.
Duncan Cumming
New Media Developer
Customer Relations Management / Education
Fife Council
700 4105 / 01592 414105
[EMAIL PROTECTED] 06/10/2005 13:23 >>>
- see footer for list info -<
Complete noob to verity and having to implement today eek.
Is there a way to search on individual columns of data in the
collection? Rather than all of them.
i.e. I have an advanced search that is something like
ISBN="798493734379" category="4" publisher="green" title="blue"
author="man". The search should look for 'green' only in the publisher
column/index of my collection.
Thanks,
dom
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
**********************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and should not be disclosed to any other party.
If you have received this email in error please notify your system manager and the sender of this message.
This email message has been swept for the presence of computer viruses but no
guarantee is given that this e-mail message and any attachments are free from
viruses.
Fife Council
Tel: +44 (0) 1592 414141
**********************************************************************
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
