Re: [ACFUG Discuss] C# question clarified

2010-02-10 Thread Teddy R. Payne 
Charlie,
Confirmed on email reception.


Teddy

RE: [ACFUG Discuss] C# question clarified

2010-02-10 Thread Charlie Arehart 
Kristine, I think I may have a solution for you, but I doubt it's a CF
problem.

First, you're saying this is just being passed into a query, by which I
assume you mean a CFQUERY. But you said in your original note that it throws
a "noise word" error. Is that in reference to SQL Server's full text
searching? I had asked in my first reply if you were referring to this, or
perhaps Verity, or Solr, etc. It helps to know these things in helping solve
a problem.

Assuming that it's SQL Server's full text search, I've seen some indications
that the issue is that it regards the # as punctuation, which it ignores.
That generally would be no problem, as it's good for search engines to find
words regardless of how punctuation us used (both due to how the searched
text may have it, and how one may think to write a search query). 

But in your example you're left only with the letter C, and apparently it
considers that a "noise word" (too frequent to index). Looking into it a
little for you, I find there are various solutions.

On the surface, some assert that you could remove that c from the "noise
word" file, since you DO want to find results searching just for that value.
There seem even to be variations of SQL that may work differently (the LIKE
keyword vs the FREETEXT function), as well as a matter of whether you're
searching with US English or "Neutral" language.  But for this specific
term, c#, it turns out there may be a solution in a specific update to SQL
Server to recognize it, though it seems it may depend on whether you are
searching c# or C#. 

Perhaps one of the ideas above will be a good solution for you. Here are a
few places that discuss it more:

http://stackoverflow.com/questions/1042/why-doesnt-sql-full-text-indexing-re
turn-results-for-words-containing 
http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-
language-features/  (Search for c# on the page to find the relevant
discussion)
http://www.eggheadcafe.com/software/aspnet/29440435/c-in-freetext.aspx

I'll add that I found these by googling:

sql server text "c#" "noise word"

I just suggest that because you may have reasonably doubted if searching
google for any specific failing phrase would have found much (since it seems
a generic sql search problem), but because that specific phrase (c#) is not
only a common one where this problem would occur, but more specifically
since it turns out there's specific changes in SQL Server to help with
searching this very term, it proved fruitful that I tried. :-)

Let us know if any of those solve it for you.

/charlie

PS I hope this note will come through as I send it today, Wed at 2:05pm ET).
:-)

> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of techsupport
> Sent: Tuesday, February 09, 2010 8:25 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] C# question clarified
> 
> I'm the original poster. I didn't get the first, but appreciate any
> help so thanks for resending it.  I'm still confounded by it but I'm
> afraid I'll have to create a new way to write the search. That would be
> bad.  yes, the keyword of C# is being passed as a variable into the
> query.
> 
> I remember years ago being very frustrated years ago why my search was
> bombing when i passed variables into the query until I learned about
> the very clever "preservesinglequotes" command.  I guess I'm hoping
> there's something similar that'll work for this. No??
> 
> 




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

RE: [ACFUG Discuss] cffile and delete issues

2010-02-10 Thread Charlie Arehart 
Great to hear. I only pressed because it helps to confirm the value of
applying hotfixes, and also specifically may help someone else facing the
situation you described. :-) Thanks for the update.

/charlie


> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Troy Jones
> Sent: Wednesday, February 10, 2010 1:15 PM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] cffile and delete issues
> 
> Yes, it was indeed the problem. The CHF did not have the needed fix in
> it. Problem solved :)
> 
> 
> ___
> 
> 
> Troy Jones  |  Director of Technical Services  |  Dynapp Inc  |  1-800-
> 830-5192  ext. 603  |  dynapp.com  |  facebook.com/dynapp
> 
> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie
> Arehart
> Sent: Wednesday, February 10, 2010 11:00 AM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] cffile and delete issues
> 
> Troy, did you get to double-check the hotfixes to make sure this wasn't
> the
> solution? Just curious.
> 
> /charlie 




-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

RE: [ACFUG Discuss] cffile and delete issues

2010-02-10 Thread Troy Jones 
Yes, it was indeed the problem. The CHF did not have the needed fix in it. 
Problem solved :)


___

Troy Jones  |  Director of Technical Services  |  Dynapp Inc  |  
1-800-830-5192  ext. 603  |  dynapp.com  |  facebook.com/dynapp

-Original Message-
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie Arehart
Sent: Wednesday, February 10, 2010 11:00 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] cffile and delete issues

Troy, did you get to double-check the hotfixes to make sure this wasn't the
solution? Just curious.

/charlie


> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie
> Arehart
> Sent: Tuesday, February 02, 2010 8:35 AM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] cffile and delete issues
> 
> Mike mentions issues with CFIMAGE and processing the generated files,
> and
> that's covered by this hotfix:
> 
> http://kb2.adobe.com/cps/403/kb403411.html
> 
> Do you think that's the one you meant, Mike? While it doesn't mention
> deleting specifically, nor that message Troy offered, it's worth his
> double-checking.
> 
> And note that while it used to be a part of cumulative hotfix (CHF) 3
> for
> 8.01 (http://kb2.adobe.com/cps/511/cpsid_51180.html), it was removed
> from
> that 2 weeks after the CHF release, so yes, you do have to apply it
> manually.
> 
> So Troy, when you say you've installed "the hotfixes", do you mean this
> one?
> And not just the CHF? Might be a solution for you.
> 
> /charlie
> 
> 
> > -Original Message-
> > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mike
> Staver
> > Sent: Monday, February 01, 2010 5:55 PM
> > To: discussion@acfug.org
> > Subject: Re: [ACFUG Discuss] cffile and delete issues
> >
> > Yes, I have seen this a bunch.  What fixed it for me was a specific
> hot
> > fix (sorry, I don't remember the exact one right now). I had to apply
> > the
> > fix and restart all CF services.  These machines I had problems with
> > were
> > on windows, and some were 64 bit and some were not.  I also did some
> > stuff
> > in code to try and fix it before I applied the hotfixes.  Not sure if
> > it
> > helps or not, but for example, let's say you wanted to upload an
> image
> > and
> > resize it, etc:
> >
> >  >
> destination="#request.images#/customers/#session.customersId#/#form.str
> > TmpStorage#"
> > filefield="form.upload_file" nameconflict="overwrite">
> >
> > 
> >  >
> "#request.images#/customers/#session.customersId#/#form.strTmpStorage#"
> > >
> >
> > 
> > 
> > 
> >
> > 
> >  source="#request.image_file#">
> > 
> >  > destination="#request.images#/customers/#session.customersId#/thu
> > mb-#form.strTmpStorage#"
> > overwrite="true">
> > 
> >
> > Notice the last line there - the part where I set the mainImage
> > variable
> > to nothing.  I have no idea if this helps or not, but between that
> and
> > the
> > hotfix, my image uploading seems to work fine.
> >
> > > Has anyone else had issues deleting files in CF8 even after
> > installing the
> > > hotfixes?
> > >
> > > We have an instance of CF8 64-bit with hotfixes. We are using some
> > > upload/resize code that we've used successfully on other servers
> with
> > no
> > > issues. However, we can't seem to delete uploaded files with no
> real
> > > discernible pattern or rhyme or reason. Only the error "ColdFusion
> > could
> > > not delete the file  for an unknown reason". We've
> > worked
> > > around it for now but are left with what will potentially be a
> large
> > issue
> > > for this client and others in that they upload large amounts of
> files
> > > daily.
> > >
> > > Does anyone have an answer for this?
> > >
> > > [cid:image001.jpg@01CAA351.346122A0]
> > >
> >
> ___
> > 
> > >
> > > Troy Jones  |  Director of Technical Services  |  Dynapp Inc  |
> > > 1-800-830-5192  ext. 603  |  dynapp.com  |
> > > facebook.com/dynapp
> > >
> > >
> > >
> > >
> > > -
> > >
> > > To unsubscribe from this list, manage your profile @
> > >
> > > http://www.acfug.org?fa=login.edituserform
> > >
> > >
> > >
> > > For more info, see http://www.acfug.org/mailinglists
> > >
> > > Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> > >
> > > List hosted by http://www.fusionlink.com
> > >
> > > -
> > >
> > >
> > >
> >
> >
> >
> > -
> > To unsubscribe from this list, manage your profile @
> > http://www.acfug.org?fa=login.edituserform
> >
> > For more info, see http://www.acfug.org/mailinglists
> > Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> > List hosted by http://www.f

RE: [ACFUG Discuss] cffile and delete issues

2010-02-10 Thread Charlie Arehart 
Troy, did you get to double-check the hotfixes to make sure this wasn't the
solution? Just curious.

/charlie


> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie
> Arehart
> Sent: Tuesday, February 02, 2010 8:35 AM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] cffile and delete issues
> 
> Mike mentions issues with CFIMAGE and processing the generated files,
> and
> that's covered by this hotfix:
> 
> http://kb2.adobe.com/cps/403/kb403411.html
> 
> Do you think that's the one you meant, Mike? While it doesn't mention
> deleting specifically, nor that message Troy offered, it's worth his
> double-checking.
> 
> And note that while it used to be a part of cumulative hotfix (CHF) 3
> for
> 8.01 (http://kb2.adobe.com/cps/511/cpsid_51180.html), it was removed
> from
> that 2 weeks after the CHF release, so yes, you do have to apply it
> manually.
> 
> So Troy, when you say you've installed "the hotfixes", do you mean this
> one?
> And not just the CHF? Might be a solution for you.
> 
> /charlie
> 
> 
> > -Original Message-
> > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mike
> Staver
> > Sent: Monday, February 01, 2010 5:55 PM
> > To: discussion@acfug.org
> > Subject: Re: [ACFUG Discuss] cffile and delete issues
> >
> > Yes, I have seen this a bunch.  What fixed it for me was a specific
> hot
> > fix (sorry, I don't remember the exact one right now). I had to apply
> > the
> > fix and restart all CF services.  These machines I had problems with
> > were
> > on windows, and some were 64 bit and some were not.  I also did some
> > stuff
> > in code to try and fix it before I applied the hotfixes.  Not sure if
> > it
> > helps or not, but for example, let's say you wanted to upload an
> image
> > and
> > resize it, etc:
> >
> >  >
> destination="#request.images#/customers/#session.customersId#/#form.str
> > TmpStorage#"
> > filefield="form.upload_file" nameconflict="overwrite">
> >
> > 
> >  >
> "#request.images#/customers/#session.customersId#/#form.strTmpStorage#"
> > >
> >
> > 
> > 
> > 
> >
> > 
> >  source="#request.image_file#">
> > 
> >  > destination="#request.images#/customers/#session.customersId#/thu
> > mb-#form.strTmpStorage#"
> > overwrite="true">
> > 
> >
> > Notice the last line there - the part where I set the mainImage
> > variable
> > to nothing.  I have no idea if this helps or not, but between that
> and
> > the
> > hotfix, my image uploading seems to work fine.
> >
> > > Has anyone else had issues deleting files in CF8 even after
> > installing the
> > > hotfixes?
> > >
> > > We have an instance of CF8 64-bit with hotfixes. We are using some
> > > upload/resize code that we've used successfully on other servers
> with
> > no
> > > issues. However, we can't seem to delete uploaded files with no
> real
> > > discernible pattern or rhyme or reason. Only the error "ColdFusion
> > could
> > > not delete the file  for an unknown reason". We've
> > worked
> > > around it for now but are left with what will potentially be a
> large
> > issue
> > > for this client and others in that they upload large amounts of
> files
> > > daily.
> > >
> > > Does anyone have an answer for this?
> > >
> > > [cid:image001.jpg@01CAA351.346122A0]
> > >
> >
> ___
> > 
> > >
> > > Troy Jones  |  Director of Technical Services  |  Dynapp Inc  |
> > > 1-800-830-5192  ext. 603  |  dynapp.com  |
> > > facebook.com/dynapp
> > >
> > >
> > >
> > >
> > > -
> > >
> > > To unsubscribe from this list, manage your profile @
> > >
> > > http://www.acfug.org?fa=login.edituserform
> > >
> > >
> > >
> > > For more info, see http://www.acfug.org/mailinglists
> > >
> > > Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> > >
> > > List hosted by http://www.fusionlink.com
> > >
> > > -
> > >
> > >
> > >
> >
> >
> >
> > -
> > To unsubscribe from this list, manage your profile @
> > http://www.acfug.org?fa=login.edituserform
> >
> > For more info, see http://www.acfug.org/mailinglists
> > Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> > List hosted by http://www.fusionlink.com
> > -
> >
> >
> 
> 
> 
> 
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
> 
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
> 
>

RE: [ACFUG Discuss] cfdocument error

2010-02-10 Thread Charlie Arehart 
Was this helpful, Jeff? I realize it may not be, but since it's both a new
(since 8) and under-discussed feature, I want to make sure it's not the
solution for you.

 

/charlie

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Charlie Arehart
Sent: Saturday, February 06, 2010 12:29 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] cfdocument error

 

Jeff, one other thing: if you're on CF8 or above, use the new localurl
attribute (of CFDOCUMENT) which was introduced in CF8. 

Under the covers, if there are images (or other file references) in the
CFDOCUMENT, CF will generate an HTTP request for them by default. Using this
attribute, you're telling CF it doesn't need to do that and can find the
files locally.  

Those internal http requests could also be a part of what's hurting you.
You can view them being requested from CF in your web server logs (and then
confirm that they're no longer being requested that way with the attribute
enabled).  Hope that helps.

 

/charlie

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard
Sent: Friday, February 05, 2010 12:00 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] cfdocument error

 

Charile-

 

I got pulled in 3 different directions and away from this issue.  Looking
more at the code again the other day, I think the cfsavecontent tag may
resolve the problem but I haven't had a chance to test it yet.  The
pdf/flashpaper that is being created is fairly large with lots of big images
of receipts.  I think there are 11 images that are full page images for
expense report reasons.

 

They had me just zip up the images and send them because it was in immediate
need for an expense report audit.

 

I'll update once I get a chance to test.

 

Jeff

 


- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform 

For more info, see http://www.acfug.org/mailinglists 
Archive @ http://www.mail-archive.com/discussion%40acfug.org/ 
List hosted by FusionLink   
- 




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-