Re: Searching large PDFs with Apache SOLR

[Al Musella, DPM]

I am on an older version of coldfusion - so this might not apply to you..
indexing a 50,000 page pdf would choke my  coldfusion server so I 
couldn't even attempt it.
I assume you have the date in a database before printing the pdf? 
What I would do is search the source database for the data you want 
then print out a new pdf with just that person's information

At 11:53 AM 12/6/2012, Rick Root wrote:

Hi folks,

My boss asked for my opinion on searching a large PDF document (50,000
pages) and being able to easily get to that location in the document if it
finds the matching result.  Basically, our system outputs charitable
contribution receipts in one large PDF document which we then to send out
for printing and mailing.

However, he'd like to be able to easily search these huge documents for
specific people, and easily go directly to those pages in the document.

If I were to use SOLR to index the document, could somehow open the
document and go directly to that page in the document?

Adobe doesn't do very well with doing control-F on a 50,000 page document :)

Thanks.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353402
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Searching large PDFs with Apache SOLR

[Rick Root]

Hi folks,

My boss asked for my opinion on searching a large PDF document (50,000
pages) and being able to easily get to that location in the document if it
finds the matching result.  Basically, our system outputs charitable
contribution receipts in one large PDF document which we then to send out
for printing and mailing.

However, he'd like to be able to easily search these huge documents for
specific people, and easily go directly to those pages in the document.

If I were to use SOLR to index the document, could somehow open the
document and go directly to that page in the document?

Adobe doesn't do very well with doing control-F on a 50,000 page document :)

Thanks.

Rick

-- 
*The beatings will continue until morale improves.*


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353378
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

searching between 2 date fields with where in cfquery

[Andy Mann]

i have a table that has two date fields (dateinx and dateoutx) and i need to 
find all the results for todays date that both fall between and on that date 
for a given customer: cID.

database is msSQL2005
cfserver is 7

if todays date is 12/2/2012examples of vialable entries:
 - dateinx=12/2/2012 and dateoutx = 12/5/2012
 - dateinx=11/2/2012 and dateoutx = 12/2/2012
 - dateinx=11/2/2012 and dateoutx = 12/25/2012

i am using smalldatetime in msSQL2005 and also would like to create a mask so 
that only date: 1/1/2012 would be saved. 

same for time: 1:30AM in a seperate field. msSQL is saving 
now as 1/1/2012 01:30:00AM or some such...

cfquerey at this point looks like:

SELECT *
FROM schdl
WHERE (cID = #cID#) AND 

tnx in advance
andy

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353334
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: searching between 2 date fields with where in cfquery

[Justin Scott]

 i have a table that has two date fields (dateinx and dateoutx) and i
 need to find all the results for todays date that both fall between
 and on that date for a given customer: cID.

This should be fairly simple to add to your existing query...

AND GETDATE() BETWEEN dateinx AND dateoutx

 database is msSQL2005 ... i am using smalldatetime in
 msSQL2005 and also would like to create a mask so that
 only date: 1/1/2012 would be saved.
 same for time: 1:30AM in a seperate field. msSQL is saving
 now as 1/1/2012 01:30:00AM or some such...

SQL Server has different data types for date and time which would
store these values on their own (internally I believe they're still
stored as a smalldatetime with static values for the unused portion.
 You can also look up the datepart() T-SQL function to break out a
datetime into its component parts when needed.

 WHERE (cID = #cID#) AND 

Also make sure you put a CFQUERYPARAM tag around that cID variable as
well to prevent SQL injection, among other benefits.


-Justin

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353335
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[Dominic Watson]

I unfortunately ran out of time to document things fully (moved on to
a new employer with no need for solr), but hopefully these blog posts
will point you in the direction of a solution:

http://fusion.dominicwatson.co.uk/2010/12/apache-solr-or-departing-from-confines.html
http://fusion.dominicwatson.co.uk/2010/12/apache-solr-part-ii-installing-solr.html

The basic point is that cfsearch et al don't offer the full gamut of
solr goodiness (I've heard good rumours for the next version of CF).
So, the solution is to interface with solr directly.

HTH

Dominic

On 18 July 2011 19:59, eric.da...@vmmc.org eric.da...@vmmc.org
eric.da...@vmmc.org wrote:
 It's a possibility, but I'd have to retool the app since all 4 custom fields 
 are currently in use.  It did dawn on me that I could do a query of queries 
 again the Verity results to pull out the records that are in a particular 
 directory.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346263
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

It's a possibility, but I'd have to retool the app since all 4 custom fields 
are currently in use.  It did dawn on me that I could do a query of queries 
again the Verity results to pull out the records that are in a particular 
directory. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346258
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

OK, so I've figured out the syntax or querying the key field to get a specific 
record.  The criteria looks something like this:

criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\Create_View_Delete_Calendar_Groups.doc'

*Note that every '\' has been escaped to '\\', you had to do the same with 
Verity.

Now say, I want to add additional criteria like documents that contain the word 
office, the criteria looks like this:

criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\Create_View_Delete_Calendar_Groups.doc
 AND +office'\

What I really want to do though is limit the search do docments in a specific 
folder, something like

criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\*'

I can't seem to get this to work.  I've read other posting saying wildcard 
searches need to be in lower case, and I've used lcase() around the string to 
force this, but still nothing is returned.



It's probalby a syntax issue, but I tried lots of variation with no success.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346164
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[Raymond Camden]

I don't believe (stress, believe!) that you can do fuzzy searching
against the key. Is storing a copy in one of the custom fields an
option?

On Fri, Jul 8, 2011 at 2:21 PM, eric.da...@vmmc.org
eric.da...@vmmc.org eric.da...@vmmc.org wrote:

 OK, so I've figured out the syntax or querying the key field to get a 
 specific record.  The criteria looks something like this:

 criteria='key:D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\Create_View_Delete_Calendar_Groups.doc'
-- 
===
Raymond Camden, Adobe Developer Evangelist

Email : raymondcam...@gmail.com
Blog : www.coldfusionjedi.com
Twitter: cfjedimaste

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346165
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

I'm trying to get migrate to solr, but have a question about using the record 
key in the search critera.
With Verity my code looks like this:
cfsearch name=getPreDeleteInfo 
collection=#sttCFG.strCollectionName# 
type=simple 
status=info 
language=english 
criteria= CF_KEY CONTAINS '#variables.criteria#'

The record in the collection looks like:

[Record # 1] 
AUTHOR: casjlr 
CATEGORY: smm_doclibsecure 
CATEGORYTREE: Web/ 
CONTEXT: [empty string] 
CUSTOM1: office 2003 doc test 
CUSTOM2: office 2003 doc test 
CUSTOM3: [empty string] 
CUSTOM4: Everyone_Intranet 
KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc 
RANK: 1 
RECORDSSEARCHED: 1 
SCORE: 0. 
SIZE: 76288 
SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar 
group based on the calendars that you are viewing Pick members from an Address 
Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars 
group, click Calendar Groups, and then click Create New Calendar Group.  Create 
a calendar group based on the calendars that you are viewing In Calendar, on 
the Home tab, in the Manage Calendars group, click Calendar Groups, and then 
click Save as New Calendar Group.  Add ... 
TITLE: office 2003 doc test 
TYPE: application/msword 
URL: body_emp.cfm?id=xxaction=RetrieveFileref=33fp=/Create_View_Delete_ 
Calendar_Groups.doc

An example of something that doens't work: 

cfsearch name=test collection=test_solr status=info 
criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc'

Note: ... is not the actual info (Didn't want to put my server actual path info 
in a public site)


I've tried a number of differnet combinations, but to no avail. Has anyone else 
successfully written a query like this?

Getting at the custom fields works fine.

cfsearch name=test collection=prodsite_smm_doclibsecure_solr status=info 
criteria='custom1:office 2003' brings back the expected results.

Any help is appreciated.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346080
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

I'm trying to get migrate to solr, but have a question about using the record 
key in the search critera with Verity my code looks like this:

cfsearch name=getPreDeleteInfo 
collection=#sttCFG.strCollectionName# 
type=simple 
status=info 
language=english 
criteria= CF_KEY CONTAINS '#variables.criteria#'

The record in the collection looks like:

[Record # 1] 
AUTHOR: casjlr 
CATEGORY: smm_doclibsecure 
CATEGORYTREE: Web/ 
CONTEXT: [empty string] 
CUSTOM1: office 2003 doc test 
CUSTOM2: office 2003 doc test 
CUSTOM3: [empty string] 
CUSTOM4: Everyone_Intranet 
KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc 
RANK: 1 
RECORDSSEARCHED: 1 
SCORE: 0. 
SIZE: 76288 
SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar 
group based on the calendars that you are viewing Pick members from an Address 
Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars 
group, click Calendar Groups, and then click Create New Calendar Group.  Create 
a calendar group based on the calendars that you are viewing In Calendar, on 
the Home tab, in the Manage Calendars group, click Calendar Groups, and then 
click Save as New Calendar Group.  Add ... 
TITLE: office 2003 doc test 
TYPE: application/msword 
URL: body_emp.cfm?id=xxaction=RetrieveFileref=33fp=/Create_View_Delete_ 
Calendar_Groups.doc

An example of something that doens't work:

cfsearch name=test collection=test_solr status=info 
criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc'

Note: ... is not the actual info (Didn't want to put my server actual path info 
in a public site)

I've tried a number of differnet combinations, but to no avail. Has anyone else 
successfully written a query like this?

Getting at the custom fields works fine.

cfsearch name=test collection=prodsite_smm_doclibsecure_solr status=info 
criteria='custom1:office 2003' brings back the expected results.

Any help is appreciated.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346081
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[Raymond Camden]

Just curious - why would you do a search when you know exactly what you want?

On Tue, Jul 5, 2011 at 1:19 PM, eric.da...@vmmc.org
eric.da...@vmmc.org eric.da...@vmmc.org wrote:

 I'm trying to get migrate to solr, but have a question about using the record 
 key in the search critera.
 With Verity my code looks like this:
 cfsearch name=getPreDeleteInfo
 collection=#sttCFG.strCollectionName#
 type=simple
 status=info
 language=english
 criteria= CF_KEY CONTAINS '#variables.criteria#'

 The record in the collection looks like:

 [Record # 1]

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346085
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Searching a Solr colllection

[eric.da...@vmmc.org eric.da...@vmmc.org]

I'm trying to get migrate to solr, but have a question about using the record 
key in the search critera

With Verity my code looks like this:
cfsearch name=getPreDeleteInfo 
collection=#sttCFG.strCollectionName# 
type=simple 
status=info 
language=english 
criteria= CF_KEY CONTAINS '#variables.criteria#'

The record in the collection looks like:

[Record # 1] 
AUTHOR: casjlr 
CATEGORY: smm_doclibsecure 
CATEGORYTREE: Web/ 
CONTEXT: [empty string] 
CUSTOM1: office 2003 doc test 
CUSTOM2: office 2003 doc test 
CUSTOM3: [empty string] 
CUSTOM4: Everyone_Intranet 
KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc 
RANK: 1 
RECORDSSEARCHED: 1 
SCORE: 0. 
SIZE: 76288 
SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar 
group based on the calendars that you are viewing Pick members from an Address 
Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars 
group, click Calendar Groups, and then click Create New Calendar Group.  Create 
a calendar group based on the calendars that you are viewing In Calendar, on 
the Home tab, in the Manage Calendars group, click Calendar Groups, and then 
click Save as New Calendar Group.  Add ... 
TITLE: office 2003 doc test 
TYPE: application/msword 
URL: body_emp.cfm?id=xxaction=RetrieveFileref=33fp=/Create_View_Delete_ 
Calendar_Groups.doc

An example of something that doens't work:

cfsearch name=test collection=test_solr status=info 
criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc'

Note: ... is not the actual info (Didn't want to put my server actual path info 
in a public site)

I've tried a number of differnet combinations, but to no avail. Has anyone else 
successfully written a query like this?

Getting at the custom fields works fine.

cfsearch name=test collection=prodsite_smm_doclibsecure_solr status=info 
criteria='custom1:office 2003' brings back the expected results.

In the Scheme.xml file I changed the key and URL fields to be indexed=true

 

   field name=key type=string indexed=true stored=true 
required=true /
   field name=urltype=string indexed=true stored=true 
required=true /

 
I can do a search on the URL field as long as like put the wildcard * at the 
end of the search criteria, but I still do not get any results using the key 
field.  Any ideas how now to escape colons  : in the path name? 

 cfsearch name=test =#sttCFG.strCollectionName# status=info 
criteria='url:b*=32356*'

Any help is appreciated.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346090
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

Just curious - why would you do a search when you know exactly what you want?

On Tue, Jul 5, 2011 at 1:19 PM, eric.da...@vmmc.org
eric.da...@vmmc.org eric.da...@vmmc.org wrote:
 [Record # 1]
In this case, I'm trying to get what was indexed so I can present it back to 
the user who just uploaded a file. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346091
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection

[eric.da...@vmmc.org eric.da...@vmmc.org]

I apologize for the for the multiple posting.  Because of the delay, I thought 
my posts were being accepted. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346092
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

In the Scheme.xml file I changed the key and URL fields to be indexed=true

   field name=key type=string indexed=true stored=true required=true 
/
   field name=url type=string indexed=true stored=true required=true 
/

I can now do a search on the URL field as long as like put the wildcard * at 
the end of the search criteria, but I still do not get any results using the 
key field.  Any ideas how now to escape colons : in the path name? 

cfsearch name=test =#sttCFG.strCollectionName# status=info 
criteria='url:b*=32356*'



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346093
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Solr colllection using the key value to get a specific file

[eric.da...@vmmc.org eric.da...@vmmc.org]

Another reason I need to be able to search against the key field, is that I 
allow the user to filter the search results by the directory the document is 
placed into.  The only field in the collection that contains this information 
is the key field. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346094
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Searching a Date Range

[Qing Xia]

Another approach is to use the dateDiff() SQL function.  That way, you can
determine the level of precision at which you are comparing.

For example, run the following scripts against any SQL database.  You will
see that the result is quite different.  If you only want to know two date
values are on the same day regardless of time, then using dateDiff() may be
safer.

DECLARE @dateVal_1 DATETIME
declare @dateVal_2 DATETIME
SET @dateVal_1 = '2009-12-22 00:01:01.000'
SET @dateVal_2 = '2009-12-22 23:59:59.000'

/* Using the good old greater or less than signs */
SELECT  CASE WHEN getDate()  @dateVal_1
THEN 'today is later than date value 1!'
WHEN getDate() = @dateVal_1
then 'today is the same as date value 1!'
ELSE 'today is earlier than date value 1!'
END AS date_compare_result_1,
CASE WHEN getDate()  @dateVal_2
THEN 'today is later than date value 2!'
WHEN getDate() = @dateVal_2
then 'today is the same as date value 2!'
ELSE 'today is earlier than date value 2!'
END AS date_compare_result_2

/* Using dateDiff() */
SELECT CASE WHEN dateDiff(dd,@dateVal_1,getDate())  0
THEN 'today is later than date value 1!'
WHEN dateDiff(dd,@dateVal_1,getDate()) = 0
then 'today is the same as date value 1!'
ELSE 'today is earlier than date value 1!'
END AS date_compare_result_1,
CASE WHEN dateDiff(dd,@dateVal_2,getDate())  0
THEN 'today is later than date value 2!'
WHEN dateDiff(dd,@dateVal_2,getDate()) = 0
then 'today is the same as date value 2!'
ELSE 'today is earlier than date value 2!'
END AS date_compare_result_2



On Mon, Dec 21, 2009 at 9:21 AM, Damo Drumm damien.dr...@quinn-group.comwrote:


 Thanks alot for all your help,

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329327
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Leigh]

 SET @dateVal_2 = '2009-12-22 23:59:59.000' 
 You will see that the result is quite different.  If you only
 want to know two date
 values are on the same day regardless of time, then using
 dateDiff() may be safer.

If the comparison is structured correctly, the results are the same (or 
marginally better if the database considers milliseconds).  A comparison that 
disregards time would compare against the #startDate# (at midnight) and 
#dayAFTERTheDesiredEndDate# (at midnight).  

For example, the query below would find all records dated any _time_ on 12/22. 
The same concept could be applied to any range.

WHERE  DateColumn = '2009-12-22'
ANDDateColumn   '2009-12-23' 

Also, functions may discourage optimizers from properly utilizing available 
indexes. Resulting in less efficient queries. So it is often better to avoid 
functions. Assuming the same results can (reasonably) be achieved without them. 

-Leigh


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Qing Xia]

True, if at least one side of the date comparison is a constant then it is
better to structure the comparison in such a way that functions can be
avoided.

On Tue, Dec 22, 2009 at 3:56 PM, Leigh cfsearch...@yahoo.com wrote:


  SET @dateVal_2 = '2009-12-22 23:59:59.000'
  You will see that the result is quite different.  If you only
  want to know two date
  values are on the same day regardless of time, then using
  dateDiff() may be safer.

 If the comparison is structured correctly, the results are the same (or
 marginally better if the database considers milliseconds).  A comparison
 that disregards time would compare against the #startDate# (at midnight) and
 #dayAFTERTheDesiredEndDate# (at midnight).

 For example, the query below would find all records dated any _time_ on
 12/22. The same concept could be applied to any range.

 WHERE  DateColumn = '2009-12-22'
 ANDDateColumn   '2009-12-23'

 Also, functions may discourage optimizers from properly utilizing available
 indexes. Resulting in less efficient queries. So it is often better to avoid
 functions. Assuming the same results can (reasonably) be achieved without
 them.

 -Leigh




 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329332
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Damo Drumm]

Thanks alot for all your help, 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329288
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Searching a Date Range

[Damo Drumm]

Hi im having some bother trying to get a search by date range working on a form 
in coldfusion. does anyone have any tips on setting this up?
It would be greatly appreciated 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329223
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Gerald Guido]

I just happened to have some code open...

SELECT   blah
FROM  tblCalendar
WHERE   EventDate BETWEEN#CreateODBCDate(someStartDate)#  repeat AND
#CreateODBCDate(someEndDate)#

The start and end dates can come from your form values... With CFQueryparam
of course. ;)

HTH
G!

On Thu, Dec 17, 2009 at 10:06 AM, Damo Drumm
damien.dr...@quinn-group.comwrote:


 Hi im having some bother trying to get a search by date range working on a
 form in coldfusion. does anyone have any tips on setting this up?
 It would be greatly appreciated


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329228
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Searching a Date Range

[Gerald Guido]

Opps... had some stray code in there.

SELECT   blah
FROM  tblCalendar
WHERE   EventDate BETWEEN#CreateODBCDate(someStartDate)#  AND
#CreateODBCDate(someEndDate)#

Much better.

G!



 On Thu, Dec 17, 2009 at 10:06 AM, Damo Drumm damien.dr...@quinn-group.com
  wrote:


 Hi im having some bother trying to get a search by date range working on a
 form in coldfusion. does anyone have any tips on setting this up?
 It would be greatly appreciated


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329229
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Jason Fisher]

With queryparam you don't need the createODBCDate() function:


SELECT   blah
FROM  tblCalendar
WHERE   EventDate BETWEENcfqueryparam cfsqltype=CF_SQL_DATE 
value=#form.someStartDate# /
AND cfqueryparam cfsqltype=CF_SQL_DATE value=#form.someEndDate# /

Also, note that in SQL Server, the assumption is midnight, so that the end 
date is really the day before, so you could do this before your query:

cfset endDate = dateAdd(d, 1, form.someEndDate) /

and then use that in the query:

...
AND cfqueryparam cfsqltype=CF_SQL_DATE value=#endDate# /




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Gerald Guido]

Ah... learn something new everyday. Good to know.

G!

On Thu, Dec 17, 2009 at 12:10 PM, Jason Fisher ja...@wanax.comAh... learn
something  wrote:


 With queryparam you don't need the createODBCDate() function:


 SELECT   blah
 FROM  tblCalendar
 WHERE   EventDate BETWEENcfqueryparam cfsqltype=CF_SQL_DATE
 value=#form.someStartDate# /
 AND cfqueryparam cfsqltype=CF_SQL_DATE value=#form.someEndDate# /

 Also, note that in SQL Server, the assumption is midnight, so that the end
 date is really the day before, so you could do this before your query:

 cfset endDate = dateAdd(d, 1, form.someEndDate) /

 and then use that in the query:

 ...
 AND cfqueryparam cfsqltype=CF_SQL_DATE value=#endDate# /




 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329232
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Leigh]

 Also, note that in SQL Server, the assumption is midnight,
 so that the end  date is really the day before, 
 so you could do this before your query:
 
 cfset endDate = dateAdd(d, 1, form.someEndDate) /

Yes, though the safest option is using a = and  comparison since BETWEEN is 
inclusive. 

!--- omitted cfqueryparam for brevity ---
WHERE  EventDate = #startDate#
ANDEventDate  #dayAfterTheFormEndDate# 


-Leigh


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329233
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching a Date Range

[Leigh]

 !--- omitted cfqueryparam for brevity ---
 WHERE  EventDate = #startDate#
 AND    EventDate  #dayAfterTheFormEndDate# 

Whoops, typo there. That should be EventDate =

WHERE  EventDate = #startDate#
ANDEventDate  #dayAfterTheFormEndDate# 



   

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329234
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching PDF Properties

[Raymond Camden]

cfindex most likely reads the content and md as well, but if you
want to get firm control over the indexing process, you got to the
some of the work yourself. You can always combine stuff. For example,
you can use cfindex to read in a pdf's content, and use cfpdf to
supply custom data for the index from some of the md fields.

FYI - don't forget if you want a way to read PDF text, which isn't
native in CF8, you can use my pdfutils CFC (pdfutils.riaforge.org). It
has a handy getText() function for PDF files.


On Thu, Oct 9, 2008 at 4:00 PM, Andrew Tegenkamp [EMAIL PROTECTED] wrote:
 Good point. I guess the way to go will be read the PDF metadata while I'm 
 already going through the cfindex and just store the metadata that way. I'll 
 try to post some code here if I get anything useful going.


 Have you read the docs on the CFPDF tag? It can read/set PDF metadata.



 On Thu, Oct 9, 2008 at 11:04 AM, Andrew Tegenkamp [EMAIL PROTECTED]
 com wrote:
  I am helping a .org setup a ColdFusion search and they have a lot of
 PDF content. They were hoping to be able to tag the content using PDF
 Document Properties (right click on an open PDF and go to Properties)
 to specify a Title, Author, Subject, and Keywords.
 
  Can Coldfusion and Verity search PDF keywords inputted this way? If
 so, how?
 
 
 


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Searching PDF Properties

[Andrew Tegenkamp]

I am helping a .org setup a ColdFusion search and they have a lot of PDF 
content. They were hoping to be able to tag the content using PDF Document 
Properties (right click on an open PDF and go to Properties) to specify a 
Title, Author, Subject, and Keywords. 

Can Coldfusion and Verity search PDF keywords inputted this way? If so, how?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313682
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Searching PDF Properties

[Raymond Camden]

Have you read the docs on the CFPDF tag? It can read/set PDF metadata.


On Thu, Oct 9, 2008 at 11:04 AM, Andrew Tegenkamp [EMAIL PROTECTED] wrote:
 I am helping a .org setup a ColdFusion search and they have a lot of PDF 
 content. They were hoping to be able to tag the content using PDF Document 
 Properties (right click on an open PDF and go to Properties) to specify a 
 Title, Author, Subject, and Keywords.

 Can Coldfusion and Verity search PDF keywords inputted this way? If so, how?


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313685
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching PDF Properties

[Andrew Tegenkamp]

Good point. I guess the way to go will be read the PDF metadata while I'm 
already going through the cfindex and just store the metadata that way. I'll 
try to post some code here if I get anything useful going.


 Have you read the docs on the CFPDF tag? It can read/set PDF metadata.
 
 
 
 On Thu, Oct 9, 2008 at 11:04 AM, Andrew Tegenkamp [EMAIL PROTECTED]
 com wrote:
  I am helping a .org setup a ColdFusion search and they have a lot of 
 PDF content. They were hoping to be able to tag the content using PDF 
 Document Properties (right click on an open PDF and go to Properties) 
 to specify a Title, Author, Subject, and Keywords.
 
  Can Coldfusion and Verity search PDF keywords inputted this way? If 
 so, how?
 
 
  


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313691
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Searching for keywords from an entered list...

[Les Mizzell]

I'm wanting to modify a site search (field in SQL Server database) so 
that in a single input field, a user could enter:

1. red
2. red, blue, green, brown
3. red green blue brown

 and in return, get all results that contained one/some/all of the 
entered terms.

In theory, what would be the best way to go about this?

There was a previous thread on this, but so far, I've been unable to 
find it. Anybody got the URL of the original thread?

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299894
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Searching for keywords from an entered list...

[Sonny Savage]

!--- Convert to Comma List ---
cfset search_value = red red, blue, green, brown red green blue brown
cfset search_value = reReplace(search_value, \W+, ,, all)

!--- In Your Query ---
column_name IN (cfqueryparam value=#lcv# cfsqltype=cf_sql_varchar
list=true)

On Tue, Feb 26, 2008 at 11:38 AM, Raymond Camden [EMAIL PROTECTED] wrote:

 You can treat the search as a list w/ 2 delimiters (, and  ). This
 then gives you a nice list.

 I'm not sure how you want to handle OR versus AND. If you have another
 form field Match All or Match Any then you can check that, and
 simply loop over your list and use either an AND or an OR.


 On Tue, Feb 26, 2008 at 10:34 AM, Les Mizzell [EMAIL PROTECTED]
 wrote:
  I'm wanting to modify a site search (field in SQL Server database) so
   that in a single input field, a user could enter:
 
   1. red
   2. red, blue, green, brown
   3. red green blue brown
 
    and in return, get all results that contained one/some/all of the
   entered terms.
 
   In theory, what would be the best way to go about this?
 
   There was a previous thread on this, but so far, I've been unable to
   find it. Anybody got the URL of the original thread?
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299898
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching for keywords from an entered list...

[Raymond Camden]

You can treat the search as a list w/ 2 delimiters (, and  ). This
then gives you a nice list.

I'm not sure how you want to handle OR versus AND. If you have another
form field Match All or Match Any then you can check that, and
simply loop over your list and use either an AND or an OR.


On Tue, Feb 26, 2008 at 10:34 AM, Les Mizzell [EMAIL PROTECTED] wrote:
 I'm wanting to modify a site search (field in SQL Server database) so
  that in a single input field, a user could enter:

  1. red
  2. red, blue, green, brown
  3. red green blue brown

   and in return, get all results that contained one/some/all of the
  entered terms.

  In theory, what would be the best way to go about this?

  There was a previous thread on this, but so far, I've been unable to
  find it. Anybody got the URL of the original thread?

  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299895
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Searching for keywords from an entered list...

[Richard Meredith-Hardy]

I do this in a 2 stage thing as part of an AJAX lookup
this is the CF code, #SUGGEST_LOOKUP_STR# is the input string
OUTLOOKNAME is a field in the DB made of firstName Surname, CompanyName (or
variations thereof) like in Outlook.

Result if you type in t
returns all items with any word starting in t
type in t f
returns all items which have words starting in t and f
type in tr f
returns all items which have words starting in tr and f
Etc.



CFLOOP LIST=#trim(replace(SUGGEST_LOOKUP_STR,','',all))#
DELIMITERS=  INDEX=idx
CFSET qstr =
listappend(qstr,(dbo.UDF_MAKESEARCHSTRING(OUTLOOKNAME) like
'%|#idx#%'),¬)
/CFLOOP
CFSET qstr = replace(qstr,¬, AND ,all)

CFQUERY NAME=getlist DATASOURCE=#ds1#
SELECT USERREF AS RETURNID, OUTLOOKNAME AS DIVDATA
FROM  ALLCONTACTS
WHERE 
ISCUSTOMER = 1 AND 
#preservesinglequotes(qstr)#
ORDER BY  OUTLOOKNAME
/CFQUERY
---

and the UDF in MSSQL is:

---
USE [MY_DB]
GO
/** Object:  UserDefinedFunction [dbo].[UDF_MAKESEARCHSTRING]  **/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION [dbo].[UDF_MAKESEARCHSTRING] (@mystring varchar(700))  
RETURNS varchar(700) AS  
BEGIN 
-- strip out ( and ) and , from search string
SELECT @mystring = replace(@mystring,'(','')
SELECT @mystring = replace(@mystring,')','')
SELECT @mystring = replace(@mystring,',','')

SELECT @mystring = replace(ltrim(rtrim(@mystring)),' ','|')

if len(@mystring)  1
begin
SELECT @mystring = '|' + @mystring
end

RETURN @mystring

END
---

HTH

Richard 

 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED] 
 Sent: 26 February 2008 16:34
 To: CF-Talk
 Subject: Searching for keywords from an entered list...
 
 I'm wanting to modify a site search (field in SQL Server 
 database) so that in a single input field, a user could enter:
 
 1. red
 2. red, blue, green, brown
 3. red green blue brown
 
  and in return, get all results that contained 
 one/some/all of the entered terms.
 
 In theory, what would be the best way to go about this?
 
 There was a previous thread on this, but so far, I've been 
 unable to find it. Anybody got the URL of the original thread?
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299900
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Searching for keywords from an entered list...

[Dennis Powers]

 a site search (field in SQL Server database)

Are you using Verity to index the database, the Free-text search feature in
SQL to index a collection or just a standard SQL query?

In one of our file archives we use SQL's search. We created a collection of
all the fields (description, author, name...etc) in the SQL server. Then on
the website we parse the input from the search field stripping non-search
terms, punctuation and Noise words and create a simple search string from
it. So if someone entered  Red,blue.green silver we would parse it and get
three search strings of:

SQLSearchString1 = red AND blue AND green AND silver

SQLSearchString2 = red NEAR blue AND green AND silver

SQLSearchString3 = red OR blue OR green OR silver

Then we perform three union queries weighting the Rank field for each query
by importance  and then sort the union by rank to obtain relevance.  Each
subsequent Query excludes the results found in the previous so we do not
wind up with duplicate records.



SELECT (KEY_TBL.RANK * 1000) AS RANK, ID, relevant_columns
FROM filesdata AS FilesTable INNER JOIN
 CONTAINSTABLE(filesdata, *, '#SQLSearchString1#*' ) 
AS KEY_TBL ON FilesTable.ID = KEY_TBL.[KEY]

UNION 

SELECT (KEY_TBL.RANK * 100) AS RANK, ID, relevant_columns
FROM filesdata AS FilesTable INNER JOIN
 CONTAINSTABLE(filesdata, FileKeywords, '#SQLSearchString2#' ) 
 AS KEY_TBL ON FilesTable.ID = KEY_TBL.[KEY]
WHERE ID NOT IN((SELECT ID
 FROM filesdata AS FilesTable INNER JOIN
 CONTAINSTABLE(filesdata, *, '#SQLSearchString1#*' ) 
 AS KEY_TBL ON FilesTable.ID = KEY_TBL.[KEY]))  
UNION

SELECT (KEY_TBL.RANK) AS RANK, ID, relevant_columns 
FROM filesdata AS FilesTable INNER JOIN
CONTAINSTABLE(filesdata, *, '#SQLSearchString3#' ) 
AS KEY_TBL ON FilesTable.ID = KEY_TBL.[KEY]
WHERE ID NOT IN( (SELECT ID 
  FROM filesdata AS FilesTable INNER JOIN
  CONTAINSTABLE(filesdata, *, '# SQLSearchString1#*' ) 
  AS KEY_TBL ON FilesTable.ID = KEY_TBL.[KEY]))
   AND ID NOT IN((SELECT ID 
  FROM filesdata AS FilesTable INNER JOIN
  CONTAINSTABLE(filesdata, FileKeywords, '#
SQLSearchString2#' ) 
  AS KEY_TBL ON FilesTable.ID = KEY_TBL.[KEY]))
ORDER BY 1 DESC


We get very good results on our data-set this way and it is faster and less
CPU intensive than Verity in our application because it puts the processing
into the separate SQL server instead of on the CF box running verity.






Best Regards,

Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT  06716
Tel: (203)879-2844
http://www.uxbinternet.com/
http://www.uxb.net/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299912
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching for keywords from an entered list...

[Les Mizzell]

 !--- Convert to Comma List ---
 cfset search_value = red red, blue, green, brown red green blue brown
 cfset search_value = reReplace(search_value, \W+, ,, all)
 
 !--- In Your Query ---
 column_name IN (cfqueryparam value=#lcv# cfsqltype=cf_sql_varchar
 list=true)


This should work - until I looked at the database (which I didn't set 
up) and see a bunch of ntext fields in there, which column_name IN 
won't work with.

Ok, let me puzzle this a bit...

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299913
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Mutli-Word search and searching each word

[Jeremy Keith]

I think this should work...

cfquery name=search datasource=search 
Select 
CompanyTypes.CompanyTypeID, 
CompanyTypes.CompanyTypeName, 
CompanyTypes.CompanyTypeDesc, 
CompanyTypes.CompanyTypeImage, 
Companies.CompanyID, 
Companies.CompanyName, 
Companies.ManagerName, 
Companies.SalesManagerName, 
Companies.CompanyCity, 
Companies.CompanyAdd, 
Companies.CompanyDesc, 
Companies.CompanyRank, 
Companies.CompanyTypeID, 
Products.ProductID, 
Products.ProductName, 
Products.ProductDesc, 
Products.ProductImage, 
Products.ProductTypeID, 
Companies_Products.Companies_ProductsID, 
Companies_Products.CompanyID, 
Companies_Products.ProductID 
From 
CompanyTypes, Companies, Products, Companies_Products 
Where 
( 
CompanyTypes.CompanyTypeID = Companies.CompanyTypeID And 
Companies_Products.CompanyID = Companies.CompanyID  And   
Companies_Products.ProductID = Products.ProductID 
) 
AND 
(  
cfset listpos = 1
cfloop index=URL.SEARCH list=#FORM.SEARCHFORM# delimiters=
(Products.ProductName LIKE '%#URL.SEARCH#%'  OR 
Companies.CompanyName LIKE '%#URL.SEARCH#%' )
cfif listpos neq listlen(FORM.SEARCHFORM,  )   
OR   
/cfif   
cfset listpos = listpos +1
/cfloop 
) 


ORDER BY 
Companies.CompanyTypeID, Companies.CompanyRank ASC, 
Companies.CompanyName ASC, Companies.CompanyID, Products.ProductID; 
/cfquery



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Mutli-Word search and searching each word

[Ali]

I need to make a search function for my site. I wonder if it is
 possible to search for multi-word combinations which it searches each
 word
 individually and the words get sepereated by the user by SPACE  . I
 wrote something using cfloop but it doesn't work. Please tell me
 what's
 wrong with my code. If you know a better way to make a search function
 that users can actually write several words in the search field and
 the
 search function searches for each word and ignores the space in
 between.
Thanks
Benign

This is my code:

cfquery name=search datasource=search
Select
CompanyTypes.CompanyTypeID,
CompanyTypes.CompanyTypeName,
CompanyTypes.CompanyTypeDesc,
CompanyTypes.CompanyTypeImage,
Companies.CompanyID,
Companies.CompanyName,
Companies.ManagerName,
Companies.SalesManagerName,
Companies.CompanyCity,
Companies.CompanyAdd,
Companies.CompanyDesc,
Companies.CompanyRank,
Companies.CompanyTypeID,
Products.ProductID,
Products.ProductName,
Products.ProductDesc,
Products.ProductImage,
Products.ProductTypeID,
Companies_Products.Companies_ProductsID,
Companies_Products.CompanyID,
Companies_Products.ProductID
From
CompanyTypes,
Companies,
Products,
Companies_Products
Where (
CompanyTypes.CompanyTypeID = Companies.CompanyTypeID
AndCompanies_Products.CompanyID = Companies.CompanyID
AndCompanies_Products.ProductID = Products.ProductID
)

AND
(  cfloop index=URL.SEARCH list=FORM.SEARCHFORM delimiters= 
  Products.ProductName LIKE '%#URL.SEARCH#%'
OR
Companies.CompanyName LIKE '%#URL.SEARCH#%'

  /cfloop 
)
ORDER BY Companies.CompanyTypeID, Companies.CompanyRank ASC,
 Companies.CompanyName ASC, Companies.CompanyID, Products.ProductID;
/cfquery

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297923
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Mutli-Word search and searching each word

[William Seiter]

cfloop index=URL.SEARCH list=FORM.SEARCHFORM delimiters= 
  Products.ProductName LIKE '%#URL.SEARCH#%'
OR
Companies.CompanyName LIKE '%#URL.SEARCH#%'

  /cfloop

Lets say that the there are 2 words in the search technologies and safety.

This loop would produce: 
  Products.ProductName LIKE '%technologies%'
OR
Companies.CompanyName LIKE '%technologies%'
  Products.ProductName LIKE '%safety%'
OR
Companies.CompanyName LIKE '%safety%'


Notice between the two groups there is a missing 'OR'.

William
-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297931
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Mutli-Word search and searching each word

[Gerald Guido]

Your list is missing #'s

list=FORM.SEARCHFORM

Should be

list=#FORM.SEARCHFORM#



The following will fix the OR issue.  Notice the 1=0 at the end which will
return zero results.


cfloop index=URL.SEARCH list=#FORM.SEARCHFORM# delimiters= 
 Products.ProductName LIKE '%#URL.SEARCH#%'
OR
Companies.CompanyName LIKE '%#URL.SEARCH#%'
OR
 /cfloop
1=0

---

This will return:

Products.ProductName LIKE '%technologies%'
OR
   Companies.CompanyName LIKE '%technologies%'
OR
   Products.ProductName LIKE '%safety%'
OR
  Companies.CompanyName LIKE '%safety%'
OR
  1=0





On Feb 1, 2008 10:15 AM, Ali [EMAIL PROTECTED] wrote:

 I need to make a search function for my site. I wonder if it is
  possible to search for multi-word combinations which it searches each
  word
  individually and the words get sepereated by the user by SPACE  . I
  wrote something using cfloop but it doesn't work. Please tell me
  what's
  wrong with my code. If you know a better way to make a search function
  that users can actually write several words in the search field and
  the
  search function searches for each word and ignores the space in
  between.
 Thanks
 Benign

 This is my code:

 cfquery name=search datasource=search
 Select
CompanyTypes.CompanyTypeID,
CompanyTypes.CompanyTypeName,
CompanyTypes.CompanyTypeDesc,
CompanyTypes.CompanyTypeImage,
Companies.CompanyID,
Companies.CompanyName,
Companies.ManagerName,
Companies.SalesManagerName,
Companies.CompanyCity,
Companies.CompanyAdd,
Companies.CompanyDesc,
Companies.CompanyRank,
Companies.CompanyTypeID,
Products.ProductID,
Products.ProductName,
Products.ProductDesc,
Products.ProductImage,
Products.ProductTypeID,
Companies_Products.Companies_ProductsID,
Companies_Products.CompanyID,
Companies_Products.ProductID
 From
CompanyTypes,
Companies,
Products,
Companies_Products
 Where (
CompanyTypes.CompanyTypeID = Companies.CompanyTypeID
AndCompanies_Products.CompanyID = Companies.CompanyID
AndCompanies_Products.ProductID = Products.ProductID
 )

 AND
 (  cfloop index=URL.SEARCH list=FORM.SEARCHFORM delimiters= 
  Products.ProductName LIKE '%#URL.SEARCH#%'
 OR
 Companies.CompanyName LIKE '%#URL.SEARCH#%'

  /cfloop
 )
 ORDER BY Companies.CompanyTypeID, Companies.CompanyRank ASC,
  Companies.CompanyName ASC, Companies.CompanyID, Products.ProductID;
 /cfquery

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297934
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Mutli-Word search and searching each word

[Ali]

On Feb 1, 2008 9:57 PM, Gerald Guido [EMAIL PROTECTED] wrote:

 Your list is missing #'s

 list=FORM.SEARCHFORM

 Should be

 list=#FORM.SEARCHFORM#



 The following will fix the OR issue.  Notice the 1=0 at the end which
 will
 return zero results.


 cfloop index=URL.SEARCH list=#FORM.SEARCHFORM# delimiters= 
  Products.ProductName LIKE '%#URL.SEARCH#%'
 OR
 Companies.CompanyName LIKE '%#URL.SEARCH#%'
 OR
  /cfloop
 1=0

 ---

 This will return:

Products.ProductName LIKE '%technologies%'
 OR
   Companies.CompanyName LIKE '%technologies%'
 OR
   Products.ProductName LIKE '%safety%'
 OR
  Companies.CompanyName LIKE '%safety%'
 OR
  1=0


 I did as you said: But it didn't work! I copied the edited code below. I
 put ## around  list=#FORM.SEARCHFORM# and I put the 1=0 to stop the
 missing OR from happening. It stills returns nothing even when I type one
 word!!! Please help me.

Thanks
Benign


 cfparam name=FORM.SEARCHFORM type=any default=
  cfparam name=url.search default= type=any
 cfquery name=search datasource=search
 Select
 CompanyTypes.CompanyTypeID,
 CompanyTypes.CompanyTypeName,
 CompanyTypes.CompanyTypeDesc,
 CompanyTypes.CompanyTypeImage,
 Companies.CompanyID,
 Companies.CompanyName,
 Companies.ManagerName,
 Companies.SalesManagerName,
 Companies.CompanyCity,
 Companies.CompanyAdd,
 Companies.CompanyDesc,
 Companies.CompanyRank,
 Companies.CompanyTypeID,
 Products.ProductID,
 Products.ProductName,
 Products.ProductDesc,
 Products.ProductImage,
 Products.ProductTypeID,
 Companies_Products.Companies_ProductsID,
 Companies_Products.CompanyID,
 Companies_Products.ProductID
 From
 CompanyTypes,
 Companies,
 Products,
 Companies_Products
 Where (
 CompanyTypes.CompanyTypeID = Companies.CompanyTypeID
 AndCompanies_Products.CompanyID = Companies.CompanyID
 AndCompanies_Products.ProductID = Products.ProductID
 )
 AND
 ( cfloop index=URL.SEARCH list=#FORM.SEARCHFORM# delimiters= 
 Products.ProductName LIKE '%#URL.SEARCH#%'
 OR
 Companies.CompanyName LIKE '%#URL.SEARCH#%'

   /cfloop

   1=0
 )
 ORDER BY Companies.CompanyTypeID, Companies.CompanyRank ASC,
 Companies.CompanyName ASC, Companies.CompanyID, Products.ProductID;
 /cfquery



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297945
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Mutli-Word search and searching each word

[Jeremy Keith]

On Feb 1, 2008 9:57 PM, Gerald Guido [EMAIL PROTECTED] wrote:

Thanks
Benign


I usually set a var before my loop for a counter

then in the loop around the OR I do a CFIF to check that counter against the 
listlen

cfset listpos = 1
cfloop list=#mylist# index=searchme
(field LIKE '%#searchme#%')
cfif listpos neq listlen(deptlist)
OR
/cfif
cfset listpos = listpos +1
/cfloop


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297965
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Mutli-Word search and searching each word

[Ali]

On Feb 2, 2008 12:35 AM, Jeremy Keith [EMAIL PROTECTED] wrote:

 On Feb 1, 2008 9:57 PM, Gerald Guido [EMAIL PROTECTED] wrote:
 
 Thanks
 Benign


 I usually set a var before my loop for a counter

 then in the loop around the OR I do a CFIF to check that counter against
 the listlen

 cfset listpos = 1
 cfloop list=#mylist# index=searchme
(field LIKE '%#searchme#%')
cfif listpos neq listlen(deptlist)
OR
/cfif
cfset listpos = listpos +1
 /cfloop




I'm sorry I did't get the whole code login. Can you please give me a clue
where I should put it Can you please tell me more about it. I know it is
too much but I really apprecite it if you put some of it around my origial
code which has may ORs ad these really got me confused!
Thanks
Benign


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297967
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: SQL Full-Text Searching

[Dustin M. Snell]

CF8 and MS SQL 2000

 

I would like to implement Google-esque searching on our Intranet against our
database. 

 

To do this I enabled Full-Text on the table I want to search (customers) and
use a query like this:

SELECT * FROM Customer where CONTAINS (*, '  search  ')

 

This works somewhat but one problem I am having is that:

 

John Doe will not locate a record where firstname=John and lastname=Doe.  It
does find [EMAIL PROTECTED] however.  Both behaviors I find odd. Does
anyone know either how to correct the inability to find that record or a
better way of doing this all together?

 

BTW, we will be upgrading to MS SQL 2008 in a few months, maybe that has
some built in capability that will make this easy?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295186
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SQL Full-Text Searching

[Gaulin, Mark]

I think it indexes individual columns only, and treats them as separate
fields... It does not combine column1 with column2, so firstname=john,
lastname=doe will not match john doe, but [EMAIL PROTECTED] will
match.  Apparently (with SQL 2000 anyway) you cannot index computed
columns (first name + last name) so you may be stuck unless you create a
real column with both fields combined (or a row in a different table
where all of the fields are combined).

I have read that SQL 2008 will have a different interface to full text
searching (at least, for defining full text indexes) but I don't know if
the capabilities will be different.  

Thanks
Mark

-Original Message-
From: Dustin M. Snell [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 20, 2007 10:10 AM
To: CF-Talk
Subject: OT: SQL Full-Text Searching

CF8 and MS SQL 2000

 

I would like to implement Google-esque searching on our Intranet against
our database. 

 

To do this I enabled Full-Text on the table I want to search (customers)
and use a query like this:

SELECT * FROM Customer where CONTAINS (*, '  search  ')

 

This works somewhat but one problem I am having is that:

 

John Doe will not locate a record where firstname=John and lastname=Doe.
It does find [EMAIL PROTECTED] however.  Both behaviors I find odd.
Does anyone know either how to correct the inability to find that record
or a better way of doing this all together?

 

BTW, we will be upgrading to MS SQL 2008 in a few months, maybe that has
some built in capability that will make this easy?





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295193
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

verity and full-text searching

[Toby King]

I there

I have setup a collection of documents in verity.  When I perform a search I am 
successful in getting a document returned.  I do know what is written in each 
document.  The problem I'm facing is that I only ever get results reurned from 
the one document not from several documents which contain similar words etc.

Just wondering if anyone might know if there is anything I might have forgotten.

Also I am wanting to include a full-text search of the website - can I also 
include this somehow and if so wondering if anyone has any pointers.  Data in 
the website is coming from a MySQL database.

Thanks in advance.



P.S. website is as follows:

www.yorkfamlaw.com.au



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294266
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

searching within (cf)Eclipse

[AJ Mercer]

Does any one know if it is possible to search within search results with
Eclipse?

or know how I can achieve this?

I want to find 'update mytable'
but the mytable could be on the next line


~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching within (cf)Eclipse

[Tom Chiverton]

On Friday 29 Jun 2007, AJ Mercer wrote:
 I want to find 'update mytable'
 but the mytable could be on the next line

Eclipse allows regular expressions in the search term.

-- 
Tom Chiverton
Helping to evangelistically pursue corporate information
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282538
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching within (cf)Eclipse

[Doug Bezona]

To search within a result set, simply select the results in the search pane,
then do CTRL-H again, enter the new criteria and in the scope section,
choose selected resources

On 6/29/07, AJ Mercer [EMAIL PROTECTED] wrote:

 Does any one know if it is possible to search within search results with
 Eclipse?

 or know how I can achieve this?

 I want to find 'update mytable'
 but the mytable could be on the next line


 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: searching within (cf)Eclipse

[Eric Roberts]

I don't have eclipse to look at it while I am responding(getting ready to
shut down so I can head to work), but I didn't see a way to search either
all open docs or the current project...is there a way to do that?

Eric

-Original Message-
From: Doug Bezona [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 29, 2007 6:52 AM
To: CF-Talk
Subject: Re: searching within (cf)Eclipse

To search within a result set, simply select the results in the search pane,
then do CTRL-H again, enter the new criteria and in the scope section,
choose selected resources

On 6/29/07, AJ Mercer [EMAIL PROTECTED] wrote:

 Does any one know if it is possible to search within search results with
 Eclipse?

 or know how I can achieve this?

 I want to find 'update mytable'
 but the mytable could be on the next line


 



~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282542
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching within (cf)Eclipse

[AJ Mercer]

nice one - thanks Doug

On 6/29/07, Doug Bezona [EMAIL PROTECTED] wrote:

 To search within a result set, simply select the results in the search
 pane,
 then do CTRL-H again, enter the new criteria and in the scope section,
 choose selected resources

 On 6/29/07, AJ Mercer [EMAIL PROTECTED] wrote:
 
  Does any one know if it is possible to search within search results with
  Eclipse?
 
  or know how I can achieve this?
 
  I want to find 'update mytable'
  but the mytable could be on the next line
 
 
 

 

~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282544
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching within (cf)Eclipse

[Doug Bezona]

For searching within a project, click on the project in the file list
(navigator), CTRL-H, and choose selected resources.

Basically, whatever you have selected in the file list is what is searched
when you choose selected resources. It's pretty handy, since you can
choose specific subdirectories, specific files, a combination of them, etc.

As for open documents, there is no way to do that. This bug report explains
why:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=92178

Unfortunate, but there you have it.

On 6/29/07, Eric Roberts [EMAIL PROTECTED] wrote:

 I don't have eclipse to look at it while I am responding(getting ready to
 shut down so I can head to work), but I didn't see a way to search either
 all open docs or the current project...is there a way to do that?

 Eric

 -Original Message-
 From: Doug Bezona [mailto:[EMAIL PROTECTED]
 Sent: Friday, June 29, 2007 6:52 AM
 To: CF-Talk
 Subject: Re: searching within (cf)Eclipse

 To search within a result set, simply select the results in the search
 pane,
 then do CTRL-H again, enter the new criteria and in the scope section,
 choose selected resources

 On 6/29/07, AJ Mercer [EMAIL PROTECTED] wrote:
 
  Does any one know if it is possible to search within search results with
  Eclipse?
 
  or know how I can achieve this?
 
  I want to find 'update mytable'
  but the mytable could be on the next line
 
 
 



 

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282548
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Searching for improperly nested tags (tags inside of tags).

[DURETTE, STEVEN J (ATTASIAIT)]

Hi all,
 
Got what I hope will be a quick one for you...
 
I have a code review tool that finds common CF programming problems, but
if it hits an improperly nested tag the tool tanks and reports no
problems even if there are multiple.
 
Normally this isn't a problem because the programmers in our shop know
not to do it, but recently we have had to have some contractors come in,
and occasionally I need to make changes to their code and I've found it
happening.
 
I'm looking to see if any one has some code/regex/etc to find this
problem.  I would most likely then run that code first, make the
contractors fix it, and then run the code review tool.
 
When I say improperly nested I mean like this:
input name=test value=cfoutput#VariableValue#/cfoutput /
 
our policy is to use
cfoutputinput name=test value=#VariableValue# /
 
Thanks,
Steve
 


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280977
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Searching for improperly nested tags (tags inside of tags).

[Andy Matthews]

Simplest way to search for things like that might be to search for  in
your string. 

-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 13, 2007 8:05 AM
To: CF-Talk
Subject: Searching for improperly nested tags (tags inside of tags).

Hi all,
 
Got what I hope will be a quick one for you...
 
I have a code review tool that finds common CF programming problems, but if
it hits an improperly nested tag the tool tanks and reports no problems even
if there are multiple.
 
Normally this isn't a problem because the programmers in our shop know not
to do it, but recently we have had to have some contractors come in, and
occasionally I need to make changes to their code and I've found it
happening.
 
I'm looking to see if any one has some code/regex/etc to find this problem.
I would most likely then run that code first, make the contractors fix it,
and then run the code review tool.
 
When I say improperly nested I mean like this:
input name=test value=cfoutput#VariableValue#/cfoutput /
 
our policy is to use
cfoutputinput name=test value=#VariableValue# /
 
Thanks,
Steve
 




~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280979
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Searching for improperly nested tags (tags inside of tags).

[DURETTE, STEVEN J (ATTASIAIT)]

That would work for thing inside of strings, but one of the other things
I get is:

input type=checkbox value=YES cfif databasevaluechecked/cfif

Our policy uses:
cfif databasevalue
input type=checkbox value=YES checked=true /
cfelse
input type=checkbox value=YES /
/cfif 

It is more readable (in my opinion).

Thanks for the idea though, that might be a starting point!

Steve

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280992
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Searching for improperly nested tags (tags inside of tags).

[Andy Matthews]

That one could be found by searching for  

The thing is that you're probably going to have to do this in stages. You're 
going to have to first identify all unique issues that need to be located. Once 
you've got that list, then the search won't be hard at all.

-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 13, 2007 9:21 AM
To: CF-Talk
Subject: RE: Searching for improperly nested tags (tags inside of tags).

That would work for thing inside of strings, but one of the other things I get 
is:

input type=checkbox value=YES cfif databasevaluechecked/cfif

Our policy uses:
cfif databasevalue
input type=checkbox value=YES checked=true / cfelse
input type=checkbox value=YES /
/cfif 

It is more readable (in my opinion).

Thanks for the idea though, that might be a starting point!

Steve



~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280997
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Searching for improperly nested tags (tags inside of tags).

[Claude Schneegans]

 It is more readable (in my opinion).

May be, but it is less writable ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281022
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Searching for improperly nested tags (tags inside of tags).

[DURETTE, STEVEN J (ATTASIAIT)]

Ok, I found the way to test for it.  Using REGEX...  [^]{1,}[Cc][Ff]

At the moment I really don't care about writeable.  :P

cf_Good_Natured_Response
I once had a co-worker that wrote code that had 5 cfifs inside of one
input tag.  That was in one single (run-on) line of code!  Very hard for
the follow up (meant that guy doesn't work here anymore) programmer to
go through the code to fix errors.  As for that long line of code with 5
cfifs when converted it was one cfif!  

In my case it's a preference that makes it easier to pick up code from
someone else in the group and see the logic.  Plus like I said, my code
review tool blows up when tags are nested within tags (it wont review
anything from the closing of the inner tag until the next tag gets
opened).  Thankfully to tool can check for the regex above.  After the
contractors fix those embedded tags, I can re-run the tool and pick up
any other errors that might be there!
/cf_Good_Natured_Response

Steve

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Need help searching for files in a directory

[Bob Imperial]

Thanks again for the help on this Gert! I've setup my output but I ran into
something I'm not sure of the syntax on how to fix this. When passing the
search criteria via my form variable, it only returns exact matches in
case..here's what I have setup:

cfdirectory action=LIST directory=D:\wwwsites\mysite\#ThisDir#\
name=qryResult 
filter=#ThisFilter# recurse=Yes
cfquery name=getFile dbtype=query
Select * from qryResult Where name Like '%#form.findThis#%'
/cfquery

I've tried to use ListFindNoCase but it doesn't seem to work, or at least
not in the ways I've tried. Is there a way to handle what I'm after with it
or is there some other approach I should be taking? Thanks again for all the
help!

Bob

-Original Message-
From: Gert Franz [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 09, 2007 4:45 AM
To: CF-Talk
Subject: Re: Need help searching for files in a directory

Well since you qould try to use verity and verity does not index mp3 files
for their content, I assume you are just looking for a filename.

So what you can do is (assuming you have cfmx7):

cfdirectory action=LIST directory=D:\multimedia name=qryResult 
filter=*.mp3 recurse=Yes
cfquery name=getFile dbtype=query
Select * from qryResult Where name Like '%Alanis%'
/cfquery
cfdump var=#getFile#

Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/



Bob Imperial schrieb:
 I'm trying to figure out how to go about searching through a directory 
 of
 mp3 files I have in a shared hosting environment so no verity. The 
 search criteria would be passed via a form variable, so, I'm wondering 
 if it's possible to use cfdirectory list and maybe dump the results 
 into an array, then do loop through the array using listfindnocase on 
 it to find the specific file?? Any help or direction would be greatly 
 appreciated, I've goggled it to death only to run into the verity 
 avenue, which I can do locally, but alas, not in my shared hosting
scenario.
  
 Thanks!! Bob


 



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269432
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need help searching for files in a directory

[Matt Quackenbush]

QofQ is case sensitive.  So if you search for name LIKE '%Alanis%', it is
NOT the same as searching for '%alanis%', or '%aLaNiS%'.  The force it to be
case-INsensitive, use a couple of functions:

SELECT * FROM qryResult WHERE lower(name) LIKE '%#lCase(form.findThis)#%'


Hope that helps.


On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote:

 Thanks again for the help on this Gert! I've setup my output but I ran
 into
 something I'm not sure of the syntax on how to fix this. When passing the
 search criteria via my form variable, it only returns exact matches in
 case..here's what I have setup:

 cfdirectory action=LIST directory=D:\wwwsites\mysite\#ThisDir#\
 name=qryResult
 filter=#ThisFilter# recurse=Yes
 cfquery name=getFile dbtype=query
 Select * from qryResult Where name Like '%#form.findThis#%'
 /cfquery



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269441
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Need help searching for files in a directory

[Bob Imperial]

Thanks Matt...this covers the two possibilities of upper and lower case ..
Select * from qryResult Where lower(name) Like '%#form.findThis#%' OR
upper(name) Like '%#form.findThis#%'

I guess maybe I should address the other possibilities by eliminating the
uploading of mixed case names on the front end via javascript ;-)

Thanks again!! Bob 

-Original Message-
From: Matt Quackenbush [mailto:[EMAIL PROTECTED] 
Sent: Saturday, February 10, 2007 10:28 PM
To: CF-Talk
Subject: Re: Need help searching for files in a directory

QofQ is case sensitive.  So if you search for name LIKE '%Alanis%', it is
NOT the same as searching for '%alanis%', or '%aLaNiS%'.  The force it to be
case-INsensitive, use a couple of functions:

SELECT * FROM qryResult WHERE lower(name) LIKE '%#lCase(form.findThis)#%'


Hope that helps.


On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote:

 Thanks again for the help on this Gert! I've setup my output but I ran 
 into something I'm not sure of the syntax on how to fix this. When 
 passing the search criteria via my form variable, it only returns 
 exact matches in case..here's what I have setup:

 cfdirectory action=LIST directory=D:\wwwsites\mysite\#ThisDir#\
 name=qryResult
 filter=#ThisFilter# recurse=Yes
 cfquery name=getFile dbtype=query
 Select * from qryResult Where name Like '%#form.findThis#%'
 /cfquery





~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269443
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need help searching for files in a directory

[Matt Quackenbush]

No need for that.  If you look at my example, you'll see that I used lCase()
ColdFusion function to make sure that the form value was in lower case as
well.  So it covers it all.


On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote:

 Thanks Matt...this covers the two possibilities of upper and lower case ..
 Select * from qryResult Where lower(name) Like '%#form.findThis#%' OR
 upper(name) Like '%#form.findThis#%'

 I guess maybe I should address the other possibilities by eliminating the
 uploading of mixed case names on the front end via javascript ;-)

 Thanks again!! Bob



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269444
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Need help searching for files in a directory

[Bob Imperial]

Ahhh so am I understanding this correctly, it converts it to lower case
before it actually sends the request to the db?

-Original Message-
From: Matt Quackenbush [mailto:[EMAIL PROTECTED] 
Sent: Sunday, February 11, 2007 12:49 AM
To: CF-Talk
Subject: Re: Need help searching for files in a directory

No need for that.  If you look at my example, you'll see that I used lCase()
ColdFusion function to make sure that the form value was in lower case as
well.  So it covers it all.


On 2/10/07, Bob Imperial [EMAIL PROTECTED] wrote:

 Thanks Matt...this covers the two possibilities of upper and lower case ..
 Select * from qryResult Where lower(name) Like '%#form.findThis#%' OR
 upper(name) Like '%#form.findThis#%'

 I guess maybe I should address the other possibilities by eliminating 
 the uploading of mixed case names on the front end via javascript ;-)

 Thanks again!! Bob





~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269445
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Need help searching for files in a directory

[Matt Quackenbush]

Well, it's not actually sending to a database in this particular query; it's
querying a previous query.  But yes, the CF function will process before
making the query request, thereby converting the form var to lower case.
Then by using the SQL lower() function on the column that you're querying,
it also will be in lower case.


On 2/11/07, Bob Imperial [EMAIL PROTECTED] wrote:

 Ahhh so am I understanding this correctly, it converts it to lower
 case
 before it actually sends the request to the db?



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269451
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Need help searching for files in a directory

[Bob Imperial]

I'm trying to figure out how to go about searching through a directory of
mp3 files I have in a shared hosting environment so no verity. The search
criteria would be passed via a form variable, so, I'm wondering if it's
possible to use cfdirectory list and maybe dump the results into an array,
then do loop through the array using listfindnocase on it to find the
specific file?? Any help or direction would be greatly appreciated, I've
goggled it to death only to run into the verity avenue, which I can do
locally, but alas, not in my shared hosting scenario.
 
Thanks!! Bob


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269278
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need help searching for files in a directory

[Robertson-Ravo, Neil (RX)]

What are your search criteria? Filename, ID3?



This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions. 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Bob Imperial
To: CF-Talk
Sent: Fri Feb 09 08:58:00 2007
Subject: Need help searching for files in a directory

I'm trying to figure out how to go about searching through a directory of
mp3 files I have in a shared hosting environment so no verity. The search
criteria would be passed via a form variable, so, I'm wondering if it's
possible to use cfdirectory list and maybe dump the results into an array,
then do loop through the array using listfindnocase on it to find the
specific file?? Any help or direction would be greatly appreciated, I've
goggled it to death only to run into the verity avenue, which I can do
locally, but alas, not in my shared hosting scenario.
 
Thanks!! Bob




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269279
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need help searching for files in a directory

[Gert Franz]

Well since you qould try to use verity and verity does not index mp3 
files for their content, I assume you are just looking for a filename.

So what you can do is (assuming you have cfmx7):

cfdirectory action=LIST directory=D:\multimedia name=qryResult 
filter=*.mp3 recurse=Yes
cfquery name=getFile dbtype=query
Select * from qryResult Where name Like '%Alanis%'
/cfquery
cfdump var=#getFile#

Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/



Bob Imperial schrieb:
 I'm trying to figure out how to go about searching through a directory of
 mp3 files I have in a shared hosting environment so no verity. The search
 criteria would be passed via a form variable, so, I'm wondering if it's
 possible to use cfdirectory list and maybe dump the results into an array,
 then do loop through the array using listfindnocase on it to find the
 specific file?? Any help or direction would be greatly appreciated, I've
 goggled it to death only to run into the verity avenue, which I can do
 locally, but alas, not in my shared hosting scenario.
  
 Thanks!! Bob


 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269281
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Need help searching for files in a directory

[Bob Imperial]

Will be filename...or something like it. 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Friday, February 09, 2007 4:16 AM
To: CF-Talk
Subject: Re: Need help searching for files in a directory

What are your search criteria? Filename, ID3?



This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions. 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Bob Imperial
To: CF-Talk
Sent: Fri Feb 09 08:58:00 2007
Subject: Need help searching for files in a directory

I'm trying to figure out how to go about searching through a directory of
mp3 files I have in a shared hosting environment so no verity. The search
criteria would be passed via a form variable, so, I'm wondering if it's
possible to use cfdirectory list and maybe dump the results into an array,
then do loop through the array using listfindnocase on it to find the
specific file?? Any help or direction would be greatly appreciated, I've
goggled it to death only to run into the verity avenue, which I can do
locally, but alas, not in my shared hosting scenario.
 
Thanks!! Bob






~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269287
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Need help searching for files in a directory

[Bob Imperial]

Thanks Gert!! I knew it would be something relatively simple, but at 4AM
things just don't always fall into place ;-) Now that I've had some sleep,
it's off to come up with more things to ponder.

Bob 

-Original Message-
From: Gert Franz [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 09, 2007 4:45 AM
To: CF-Talk
Subject: Re: Need help searching for files in a directory

Well since you qould try to use verity and verity does not index mp3 files
for their content, I assume you are just looking for a filename.

So what you can do is (assuming you have cfmx7):

cfdirectory action=LIST directory=D:\multimedia name=qryResult 
filter=*.mp3 recurse=Yes
cfquery name=getFile dbtype=query
Select * from qryResult Where name Like '%Alanis%'
/cfquery
cfdump var=#getFile#

Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/



Bob Imperial schrieb:
 I'm trying to figure out how to go about searching through a directory 
 of
 mp3 files I have in a shared hosting environment so no verity. The 
 search criteria would be passed via a form variable, so, I'm wondering 
 if it's possible to use cfdirectory list and maybe dump the results 
 into an array, then do loop through the array using listfindnocase on 
 it to find the specific file?? Any help or direction would be greatly 
 appreciated, I've goggled it to death only to run into the verity 
 avenue, which I can do locally, but alas, not in my shared hosting
scenario.
  
 Thanks!! Bob


 



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269288
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

searching xml

[Phill B]

I have this XML
root
  colors
color
  cname24K/cname
  typeflek/type
  value0xfbe680/value
  price0/price
  cid1/cid  
/color
color
  cnameBlack Mist/cname
  typeflek/type
  value0x22/value
  price0cid  
/color
  /colors
/root

I need to query the cname for the value Black Mist. Then I need to
get the index of its parent color. How the heck do I go about this?
I found that I can search for the cname value using this
XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
how do I get the parent position so that I can display all the nodes
in color ?

-- 
Phil

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching xml

[Phill B]

Never mind. I figured it out.

On 1/5/07, Phill B [EMAIL PROTECTED] wrote:
 I have this XML
 root
   colors
 color
   cname24K/cname
   typeflek/type
   value0xfbe680/value
   price0/price
   cid1/cid
 /color
 color
   cnameBlack Mist/cname
   typeflek/type
   value0x22/value
   price0cid
 /color
   /colors
 /root

 I need to query the cname for the value Black Mist. Then I need to
 get the index of its parent color. How the heck do I go about this?
 I found that I can search for the cname value using this
 XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
 how do I get the parent position so that I can display all the nodes
 in color ?

 --
 Phil



-- 
Phil

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265807
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: searching xml

[Dawson, Michael]

There should be a parent method to return that object.

Check this site: http://www.w3schools.com/xpath/xpath_syntax.asp 

-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 05, 2007 9:38 AM
To: CF-Talk
Subject: searching xml

I have this XML
root
  colors
color
  cname24K/cname
  typeflek/type
  value0xfbe680/value
  price0/price
  cid1/cid  
/color
color
  cnameBlack Mist/cname
  typeflek/type
  value0x22/value
  price0cid  
/color
  /colors
/root

I need to query the cname for the value Black Mist. Then I need to
get the index of its parent color. How the heck do I go about this?
I found that I can search for the cname value using this
XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now how
do I get the parent position so that I can display all the nodes in
color ?

--
Phil

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265809
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching xml

[Teddy Payne]

cfxml variable=myXML
root
 colors
   color
 cname24K/cname
 typeflek/type
 value0xfbe680/value
 price0/price
 cid1/cid
   /color
   color
 cnameBlack Mist/cname
 typeflek/type
 value0x22/value
 price0/price
 cid1/cid
   /color
 /colors
/root
/cfxml

!--- Search String ---
cfset sSearch = Black Mist

!--- Location of the color found  ---
cfset indexLocation = 0

!--- Root ---
cfset nRoot = myXML.XMLRoot

!--- Colors Root ---
cfset nColors = nRoot.XMLChildren[1]

cfloop from=1 to=#ArrayLen(nColors.XMLChildren)# index=i

!--- Color node currently looping through ---
cfset nColor = nColors.XMlChildren[i]

cfset nCname = nColor[cname]

cfif Trim(nCname.xmlText) eq sSearch
cfset indexLocation = i
/cfif

/cfloop

cfoutput#indexLocation#/cfoutput


On 1/5/07, Phill B [EMAIL PROTECTED] wrote:

 I have this XML
 root
 colors
color
  cname24K/cname
  typeflek/type
  value0xfbe680/value
  price0/price
  cid1/cid
/color
color
  cnameBlack Mist/cname
  typeflek/type
  value0x22/value
  price0cid
/color
 /colors
 /root

 I need to query the cname for the value Black Mist. Then I need to
 get the index of its parent color. How the heck do I go about this?
 I found that I can search for the cname value using this
 XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
 how do I get the parent position so that I can display all the nodes
 in color ?

 --
 Phil

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265810
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching xml

[Massimo Foti]

 I need to query the cname for the value Black Mist. Then I need to
 get the index of its parent color. How the heck do I go about this?
 I found that I can search for the cname value using this
 XMLSearch(colorXML, /root/colors/color/cname[. ='Black Mist']) Now
 how do I get the parent position so that I can display all the nodes
 in color ?

//color[cname[. ='Black Mist']]

  
Massimo Foti, web-programmer for hire
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com
  


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265869
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

verity problem with phrase searching

[Mark Trade]

Hi All

I'm doing a phrase search with verity with following phrase (j2ee struts)

I am using MX7 and type simple

This should just return results containing the phrase but it returns results 
with j2ee OR struts

Can any one help? According to the documentation this should work.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264106
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: verity problem with phrase searching

[daniel schmid]

Hi Mark

I just had the same problem... You have to read the spec on livedocs to 
understand what  verity all does ;)

I solved the problem with the AND operator:

1) clean the verity searchcrtieria with the exzellent verityclean udf from 
cflib.org
cfset var cleanSearchstring = _verityclean(trim(lcase(arguments.criteria)))/

2) than replace any empty space with the AND operator 
cfset  cleanSearchstring = replace(cleanSearchstring,  ,  and ,all)/

If you using english language pack - what you probably do - that works 
excellent... but not when you use the german language pack. Thee AND operator 
doesn't work as exspected with the german language pack (!?!?)...nobody knows 
why, I guess, it is a bug in the language pack.

Daniel
danielschmid.name

 Hi All
 
 I'm doing a phrase search with verity with following phrase (j2ee 
 struts)
 
 I am using MX7 and type simple
 
 This should just return results containing the phrase but it returns 
 results with j2ee OR struts
 
 Can any one help? According to the documentation this should work.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264115
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching for information encrypted in the db

[Tom Chiverton]

On Friday 03 November 2006 13:17, daniel kessler wrote:
 Really?  They won't both have the same encryption for the FOO part of the
 word?  

Not if you're using any form of encryption worthy of the name.

-- 
Tom Chiverton
Helping to dramatically pursue collaborative eyeballs



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259246
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching for information encrypted in the db

[Tom Chiverton]

On Thursday 02 November 2006 17:56, daniel kessler wrote:
 process we wish to keep notes about our progress.  If it's not encrypted,
 people might not write whatever they really think for fear of someone
 looking over the db 

All you've done is move the problem to another tier.
What's the point ?

 But the real reason is cause my boss told me to 
 encrypt it.

Stupid boss :-)

 I can search on encrypted uppercase to encrypted uppercase so that it's
 case-less.  I'd have a Notes_U field in this case.

One way around it, kicking myself for not seeing that :-)
Note you won't be able to use the '%' string operator though, because
'ABFOODE' will still encrypt (very) different to 'DEFOOAB', and so a search 
for encrpyt('FOO') will fail.

-- 
Tom Chiverton
Helping to biannually coordinate one-to-one appliances



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259003
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching for information encrypted in the db

[daniel kessler]

  I can search on encrypted uppercase to encrypted uppercase so that 
 it's case-less.  I'd have a Notes_U field in this case.
 
 One way around it, kicking myself for not seeing that :-)
 Note you won't be able to use the '%' string operator though, because
 'ABFOODE' will still encrypt (very) different to 'DEFOOAB', and so a 
 search 
 for encrpyt('FOO') will fail.

Really?  They won't both have the same encryption for the FOO part of the word? 
 I'm using the same key.
Gosh, this is something else.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching for information encrypted in the db

[Tom Chiverton]

On Wednesday 01 November 2006 17:58, Daniel Kessler wrote:
 AND UPPER(meeting_name) LIKE cfqueryparam value=%#encrypt(UCase
 (Form.meeting_name),the_key)#% cfsqltype=cf_sql_varchar

Imagine encrypt(name,key) is '5HIO' if name is 'Bob', and '7HJL' if name 
is 'BOB'
You're saying:
'5HIO' LIKE '%7HJL%'

-- 
Tom Chiverton
Helping to advantageously monetize guinine content



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258815
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching for information encrypted in the db

[daniel kessler]

I'm still confused.  Are you explaining why it isn't working?
I'm am having trouble understanding where to adjust to make this work.  I 
figured since it's already encrypted in the database, I'd encrypt the form 
information, capitalize both and then search - at least that's what I tried and 
it didn't work.  How do I then get Bob to find BOB?

 On Wednesday 01 November 2006 17:58, Daniel Kessler wrote:
  AND UPPER(meeting_name) LIKE cfqueryparam value=%#encrypt(UCase
  (Form.meeting_name),the_key)#% cfsqltype=cf_sql_varchar
 
 Imagine encrypt(name,key) is '5HIO' if name is 'Bob', and '7HJL' if 
 name 
 is 'BOB'
 You're saying:
 '5HIO' LIKE '%7HJL%'
 
 -- 
 Tom Chiverton

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258844
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching for information encrypted in the db

[Tom Chiverton]

On Thursday 02 November 2006 14:20, daniel kessler wrote:
 I'm still confused.  Are you explaining why it isn't working?

Yeah. I've no idea at the mo how to make it work, sorry.

 figured since it's already encrypted in the database, I'd encrypt the form
 information, capitalize both and then search - at least that's what I tried
 and it didn't work.  How do I then get Bob to find BOB?

You are upper casing the encrypted string, and compairing it to the encrypted 
upper cased form field - this isn't going to work :-)
Does your database have native encrypt/decrypt SQL functions you could use 
instead ?

-- 
Tom Chiverton
Helping to autoschediastically evolve world-class relationships



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258851
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching for information encrypted in the db

[daniel kessler]

 On Thursday 02 November 2006 14:20, daniel kessler wrote:
 You are upper casing the encrypted string, and compairing it to the 
 encrypted 
 upper cased form field - this isn't going to work :-)
 Does your database have native encrypt/decrypt SQL functions you could 
 use 
 instead ?

hmm, it's Oracle.  I suppose it probably does.  hmmm.

thank you.

daniel

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: searching for information encrypted in the db

[Alan Rother]

Ok,

I will ask the question everyone else seems to be afraid to ask


What is this data (obviously, don't tell us anything secret, just a vague
understanding like it's personal medical info or maybe the datatype...) you
are trying to search on and why is it encrypted?

Generally speaking, I only encrypt data I don't want virtually anyone
getting their hands on, like SSNs and CC numbers. These are things I would
never let anyone, including myself have a blind like search on. They are
generally only pieces of info to be used in a very specific context on a
person by person basis.


Also, how large is the databse you are searching, if the datset is small
enough you could in theory select * and decrypt the data and then Query of
Queries on the decrypted data. Don't do this if it's a large recordset, the
performance issues would be massive.

-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258860
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching for information encrypted in the db

[daniel kessler]

I will ask the question everyone else seems to be afraid to ask
What is this data (obviously, don't tell us anything secret, just a vague
understanding like it's personal medical info or maybe the datatype...) you
are trying to search on and why is it encrypted?

It's a Notes field.  We're becoming a certified school and during the process 
we wish to keep notes about our progress.  If it's not encrypted, people might 
not write whatever they really think for fear of someone looking over the db 
which has a good chance of happening during a certification process.  
But the real reason is cause my boss told me to encrypt it.

Also, how large is the databse you are searching, if the datset is small
enough you could in theory select * and decrypt the data and then Query of
Queries on the decrypted data. Don't do this if it's a large recordset, the
performance issues would be massive.

Well we'll have records as entered.  It's a set of notes about a process.  
Later there'll be more - probably under 20,000 in the end.  I'd like the 
process not to get longer as the years go on.

I was suggested another solution and I think it's okay but would like opinions. 
 It's to make an alternate Notes field and capitalize it so that I can search 
on encrypted uppercase to encrypted uppercase so that it's case-less.  I'd have 
a Notes_U field in this case.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258879
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

searching for information encrypted in the db

[Daniel Kessler]

I am entering information into a database and on my INSERT command, I  
am encrypting it using a generated key and the encrypt() function.   
Now I wish to search on the information.  I usually do an UPPER on  
both the search criteria the data in the field to assure that caps do  
not matter.  IOW,  'Meeting' will also find 'meeting'.  Now that the  
information is encrypted, I'm having trouble figuring out how to  
search for it and where to encrypt during the search

Need to adjust:
AND UPPER(meeting_name) LIKE cfqueryparam value=%#UCase 
(Form.meeting_name)#% cfsqltype=cf_sql_varchar

This finds nothing when it should find something, assuming it were  
correct:
AND UPPER(meeting_name) LIKE cfqueryparam value=%#encrypt(UCase 
(Form.meeting_name),the_key)#% cfsqltype=cf_sql_varchar

if the db data is not encrypted an neither is the query then the  
above code finds lots of entries.

thank you.

-- 

Daniel Kessler

College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
Phone: 301-405-2545
http://hhp.umd.edu




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258714
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: searching for online booking system written in CF

[desiree.renaud]

Hi, Adrian.

Thanks for responding to my query about a CF online booking solution for 
property managers.  Sorry for the delay in responding to your question.

I'm looking for the following features:

A search feature that will produce search results for users so they can find 
the property they desire.
The page returned will allow a view of the photos of the property and a short 
description.
A calendar that will show when a property is available for rent to users.
A back end web admin tool that works with a MySql db that allows the property 
manager to update available property on the site.
Some e-mail functionality that confirms the user's reservation and starts a 
process for sending a deposit by credit card.  Some kind of encryption or other 
method of keeping the card info secure will be required.

This system will not be interfacing with their in-house accounting system.  It 
will just be a way for users to make reservations for vacation rentals and the 
in-house staff will be required to keep the site updated with available 
properties as necessary.

Got any ideas?
 
Desiree Anne

Well behaved women rarely make history.
 --Laurel Thatcher Ulrich

- Original Message 
From: Adrian Lynch [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, April 17, 2006 8:19:50 AM
Subject: RE: searching for online booking system written in CF

What features are you both looking for from this system?

Adrian

-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: 17 April 2006 15:14
To: CF-Talk
Subject: Re: searching for online booking system written in CF


I am going to be in need of the same sort of thing,
As I work with not for profit and child advocacy programs I would also hope
for something open source...


On 4/15/06, Desiree Anne [EMAIL PROTECTED] wrote:

 Hi, everyone.

 I'm trying to find an out-of-the-box online
 booking/online reservations system written in CF
 designed to work with MySQL.

 Anyone know of such an animal?

 Thanks.

 Desiree



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238778
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: searching for online booking system written in CF

[desiree.renaud]

Hi, Bob.

Sorry for the delay in responding to you.

Yes, I believe I've seen your booking engine and visited your site.

How would this work with a vacation property rental company that serves many 
properties and adds and drops them at will?

My needs are a little bit different than a hotel because each property is 
different and has different photos and descriptions.

And how much work will it be for me to port the database over to MySql?  I have 
created MySql db's from scratch but have not ported any other db over to 
it...yet.  ;)
 
Desiree Anne

Well behaved women rarely make history.
 --Laurel Thatcher Ulrich

- Original Message 
From: Robert Everland III [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, April 17, 2006 8:29:00 AM
Subject: Re: searching for online booking system written in CF

I have a reservation engine I created in CF, it's written to use SQL, but 
shouldn't be too hard to port to MYSQL now that it supports Stored procedures. 
http://www.reactivevision.com




Bob Everland



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238780
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Searching through word docs.

[Brian McGarvie]

Hi All. 

I have a requirement to search for postal codes ( or matches of postal code 
strings ) in order to return a search result list from a directory of word 
documents. I need to parse the contents of each word to search for a postal 
code ( string ) match.

Was wondering if anyone had done this or looked into this at any point.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238508
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Searching through word docs.

[Will Tomlinson]

I think you could use Verity for this. 

Will

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238509
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Searching through word docs.

[Jose Diaz]

Hi Brian

Verity searches word documents and also pdfs and html files, have a look at
the cfcollection and cfindex tags.

All the best

Jose Diaz


On 4/24/06, Will Tomlinson [EMAIL PROTECTED] wrote:

 I think you could use Verity for this.

 Will

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238524
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: searching for online booking system written in CF

[Richard Dillman]

I am going to be in need of the same sort of thing,
As I work with not for profit and child advocacy programs I would also hope
for something open source...


On 4/15/06, Desiree Anne [EMAIL PROTECTED] wrote:

 Hi, everyone.

 I'm trying to find an out-of-the-box online
 booking/online reservations system written in CF
 designed to work with MySQL.

 Anyone know of such an animal?

 Thanks.

 Desiree

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237901
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: searching for online booking system written in CF

[Andy Matthews]

My company has a hosted booking solution. But I think that you're looking
for something you can run on your own server right?

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: Monday, April 17, 2006 9:14 AM
To: CF-Talk
Subject: Re: searching for online booking system written in CF


I am going to be in need of the same sort of thing,
As I work with not for profit and child advocacy programs I would also hope
for something open source...


On 4/15/06, Desiree Anne [EMAIL PROTECTED] wrote:

 Hi, everyone.

 I'm trying to find an out-of-the-box online
 booking/online reservations system written in CF
 designed to work with MySQL.

 Anyone know of such an animal?

 Thanks.

 Desiree





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237903
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: searching for online booking system written in CF

[Adrian Lynch]

What features are you both looking for from this system?

Adrian

-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: 17 April 2006 15:14
To: CF-Talk
Subject: Re: searching for online booking system written in CF


I am going to be in need of the same sort of thing,
As I work with not for profit and child advocacy programs I would also hope
for something open source...


On 4/15/06, Desiree Anne [EMAIL PROTECTED] wrote:

 Hi, everyone.

 I'm trying to find an out-of-the-box online
 booking/online reservations system written in CF
 designed to work with MySQL.

 Anyone know of such an animal?

 Thanks.

 Desiree

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237904
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: searching for online booking system written in CF

[Robert Everland III]

I have a reservation engine I created in CF, it's written to use SQL, but 
shouldn't be too hard to port to MYSQL now that it supports Stored procedures. 
http://www.reactivevision.com




Bob Everland

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237906
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: searching for online booking system written in CF

[Richard Dillman]

SQL Server 2005 is what I have here, but again im working with Not for
Profits and kids so I can't charge for this.

On 4/17/06, Robert Everland III [EMAIL PROTECTED] wrote:

 I have a reservation engine I created in CF, it's written to use SQL, but
 shouldn't be too hard to port to MYSQL now that it supports Stored
 procedures. http://www.reactivevision.com




 Bob Everland

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237915
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: searching for online booking system written in CF

[Robert Everland III]

Contact me off list, let's see if the product fits your needs, if it does maybe 
I can donate a copy and get a tax deduction form from you for doing that. Not 
sure on the specifics of it since I have never done it. 




Bob Everland

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237920
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

searching for online booking system written in CF

[Desiree Anne]

Hi, everyone.

I'm trying to find an out-of-the-box online
booking/online reservations system written in CF
designed to work with MySQL.

Anyone know of such an animal?

Thanks.

Desiree

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237841
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CFUNITED-06 interview 8: Raymond Camden - Verity Searching Secrets

[Michael Smith]

In this issue of ColdFusion conference and training news:
* Hotel 89% full
* New Sponsor
* Conference Keynotes announced
* Win a ticket to CFUNITED with our competition. Deadline 2/28/06
* CFUNITED Sneak Peek 3/1/06
* New Dynamic Schedule http://www.cfunited.com/schedule.cfm
* Interview with Raymond Camden - Verity Searching Secrets


CFUNITED is the premier ColdFusion Conference near
Washington DC 6/28-7/1/06 (Four whole days!)
Check out speakers and topics at http://www.cfunited.com/

- Michael Smith
TeraTech, Inc

Have 3 years of CF and love helping other developers?
http://www.teratech.com/index.cfm?go=About.JobDetailJobID=7

Conference and training news


* Upcoming classes
FB101 - Intro to FuseboxFeb 28 2006
MS01 - Avoiding web disasters   Mar 1 2006
FB201 - Intermediate FuseboxMar 7 2006
CF206 - ColdFusion SQL Skills   Mar 14 2006

Cost $59 - $349 see http://www.teratech.com/training/ for more
details and registration



CFUNITED NEWS!
* Confirmed - Ben Forta will be a speaker for Adobe's primary keynote 
presentation on the
conference's first day, June 28th.
Also, Microsoft and New Atlanta will be presenting their keynote on 
Thursday and Friday. See our
topics page to find out more. www.cfunited.com/topics.cfm

* Check out the CFObjective Conference 
(http://www.cfobjective.com/conference/) in Minneapolis, MN
on March 11-12. Learn about Enterprise software engineering as it 
applies to ColdFusion. The early
bird rate ends 2/26/06.

* ColdFusion Developer's Journal is proud to be a sponsor of CFUNITED.

* Hotel guest room update. Currently 89% of the rooms have been sold. 
The Bethesda
North Marriot is the host of our event, which is located right at the 
Montgomery
County Conference Center. See http://www.cfunited.com/travel.cfm for 
details.
-- Over flow information coming soon --

* Win a ticket to CFUNITED with our competition. Answer the questions 
and tell us
why should people come to CFUNITED-06 by 2/28/06 and you could win a 
free ticket to the event
http://www.cfunited.com/survey.cfm

* Come to CFUNITED Sneak Peek event on March 1st, 2006 at 7pm - 9pm at 
the Bethesda North Marriott
Hotel and Montgomery County Conference Center in the Brookside Room on 
the lower level. This is a
chance to get the inside scoop at what is happening new at this year's 
main event in June and you
also get to learn a little bit more about ColdFusion too. By the way, 
the event is FREE! (But
registration is required).
http://www.cfug-md.org/cfunited-sneak-peek.cfm

* We have a new schedule posted. Recently updated as of February 22, 2006.
   http://www.cfunited.com/schedule.cfm

* Only 4 months until CFUNITED (123 days).

* Timely bird price ends 3/31/06

* Can't afford to come for 4 days? Or can't take time off work during the
   week? Come to our Saturday only event.

* Full time students and umemployed programmers substantial discounts
available - email liz (at) teratech.com for your discount code.



**
And now our CFUNITED spotlight interview.

Michael Smith: This time we are talking with Raymond Camden about his 
CFUNITED-06 talk Verity
Searching Secrets. So why should a developer come to your session Raymond?

Raymond Camden: While it is simple enough to add a search feature to a 
web site with Verity, it
isn't easy to add a powerful, and relevant search engine. Verity gives 
you tools to not only add
search, but to help yours users really find what they are looking for.

MS: So do you have to buy Verity on top of ColdFusion?

RC: No - Verity ships with ColdFusion MX. There are certain restrictions 
to the version that ships
with ColdFusion, but if you do purchase Verity, you can use that easily 
from CF as well.

MS: Search coding sounds really complex - how many lines of code does it 
take to add a good search
to a site?

RC: One. Ok - one for the search itself, and a few more to actually 
populate the data, but the API
is -very- simple and easy to use.

MS: So what kind of extra search tools are in Verity?

RC: You have your basic search matching Find me foo with 'Camden' in 
it as well as more
particular type searches. You can search within a category. You can 
search for words close to your
initial search term. You can even get suggestions back when your search 
doesn't return any results.

MS: Wow that sounds like the options in the Google Advanced Search 
screen! When you say search
within a category what is an example of that?

RC: A typical search will search all of your content. By using 
categories, you can give you users
the ability to find better results. So if you have a review site that 
discusses movies, music, and
video games, you could let the search engine filter by just movies for 
example.

MS: Cool! Any other new Verity features that you will be covering?

RC: I'll mainly be discussing basic searching, categories, suggestions, 
and ways to integrate
Verity into your code. I'll touch a bit