RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-18 Thread Charlie Arehart
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas MohammedSent: Wednesday, October 18, 2006 5:14 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature Thanks Charlie... I think I have the necessary

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-18 Thread Douglas Knudsen
medSent: Monday, October 16, 2006 3:20 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature Hi Charlie/Teddy, Thanks for the replies. I was in a meeting and just got chance to go thru your mail. you could store it i

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-18 Thread Ajas Mohammed
ot; does indeed limit how many cached query results (cachedwithin and cachedafter) you can have at one time (across the entire server).   /charlie http://www.carehart.org/blog/   From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Ajas MohammedSen

RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-17 Thread Charlie Arehart
cached query results (cachedwithin and cachedafter) you can have at one time (across the entire server).   /charlie http://www.carehart.org/blog/   From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Ajas MohammedSent: Monday, October 16, 2006 10:17

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Ajas Mohammed
Monday, October 16, 2006 11:13 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature Ajas, I think you confused people with the subject saying "please disregard previous email".   As for your challenge,

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Teddy Payne
eral issues of query caching.   /charlie http://www.carehart.org/blog/   From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Charlie ArehartSent: Monday, October 16, 2006 11:13 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching &am

RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Charlie Arehart
MTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature Ajas, I think you confused people with the subject saying "please disregard previous email".   As for your challenge, your challenge isn't with caching but

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Douglas Knudsen
cahced queries are identified by1) name2) username3) password4) DSN5) SQLIf any of these 3 change in any way, it is a different query and will get executed and cached seperately. http://livedocs.macromedia.com/coldfusion/7/htmldocs/0316.htmDKOn 10/16/06, Ajas Mohammed <[EMAIL PROTECTED] > wrote

RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread axunderwood
if you paste the query in here we may be able to help...there are a few things that will cause a query NOT to be cached -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ajas MohammedSent: Monday, October 16, 2006 10:37 AMTo: discussion@acfug.o

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Ajas Mohammed
Here is the query...         SELECT reg.Reg_ID, elig.Eligibility_No, note.Note_No, reas.Reason_No, reg.Reg_Name, reg.State,reg.MaxDuration,  reg.Concurrent_Policies,  reg.Link, elig.Eligibility_Text, re

RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Charlie Arehart
: Monday, October 16, 2006 10:17 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature Good Morning everyone, Just wondering if anyone has any ideas/suggestions for the 2 que

Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Ajas Mohammed
No, I do not have in any of my queries. For question no. 2, I have heard of verity but I am not sure what it does and if thats what is needed for performing search (like google).Thanks. On 10/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: For number 1: do you have a in your query - f

RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread axunderwood
For number 1: do you have a in your query - from what I understand, this doesn't work with cached queries... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ajas MohammedSent: Monday, October 16, 2006 10:17 AMTo: discussion@acfug.orgSubject:

[ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching & 2.Implementing search Feature

2006-10-16 Thread Ajas Mohammed
Good Morning everyone, Just wondering if anyone has any ideas/suggestions for the 2 questions I had asked??? I didnt see any reply which makes me think if it is very simple or if its difficult / time consuming. Thanks,Ajas.On 10/13/06, Ajas Mohammed <[EMA