File name not showing up in application.log

2013-07-17 Thread Steve Moon
There are quite a few errors in my CF8 Application.log file that look like this: String index out of range: -1 The specific sequence of files included or processed is: Why is the file name blank and what's the best way to go about troubleshooting this error? This probably has to do

Empty file name in Application.log

2013-07-17 Thread Steve Moon
There are quite a few errors in my CF8 Application.log file that look like this: String index out of range: -1 The specific sequence of files included or processed is: Why is the file name blank and what's the best way to go about troubleshooting this error?

Compare Two Lists

2013-07-17 Thread i...@markleder.com i...@markleder.com
Hi all, Attempting to clean up a table with email records. In addition to the existing table of good and bad email addresses, I have a csv file with addresses that would need to be matched up to the db table, then deleted (so I just have good addresses). Email addresses are properly

Caching

2013-07-17 Thread Steve LaBadie
Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything is fine. Is there a way to prevent this from happening

Re: Caching

2013-07-17 Thread Cameron Childress
On Wed, Jul 17, 2013 at 10:08 AM, Steve LaBadie wrote: Is there an inherent problem with CF caching pages or is this strictly a browser and IIS issue. We updated our home page and are receiving complaints that our home page isn't resolving correctly. I instruct them to push F5 and everything

RE: Caching

2013-07-17 Thread Mark A Kruger
Steve, Are you using page caching? Cfcache? More info would be helpful. -Original Message- From: Steve LaBadie [mailto:slaba...@po-box.esu.edu] Sent: Wednesday, July 17, 2013 9:08 AM To: cf-talk Subject: Caching Is there an inherent problem with CF caching pages or is this strictly

RE: Compare Two Lists

2013-07-17 Thread Mark A Kruger
Mark, Perhaps I'm missing something... but it seems like you already have your list to delete. Why are you comparing again? Why not just do: DELETE FROM someDBTable WHERE emailaddress IN ('# todelete#') Using cfqueryparam of course :) Is the list too large? Sometimes the driver will only

RE: Caching

2013-07-17 Thread Steve LaBadie
Cameron, When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From:

Re: Caching

2013-07-17 Thread Cameron Childress
This actually sounds like perhaps the CSS file is being cached. Hitting F5 may be making the browsers reload all the page's included files, including the CSS file. Have you made changes to CSS/JS files lately? One strategy to avoid this is to rename your CSS file when you change it. If it's

RE: Caching

2013-07-17 Thread Mark A Kruger
Steve, I agree with Cameron sounds like a resource is not loading... css, js or image or whatever. Firebug would tell the story probably. -mark -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 9:32 AM To: cf-talk Subject: Re:

Re: Caching

2013-07-17 Thread Cameron Childress
On Wed, Jul 17, 2013 at 10:27 AM, Steve LaBadie wrote: When someone goes to the page for the first time, the page is jumbled. I believe that it is only happening within the campus network and not off campus. One other idea here since this is only happening on campus... I know many

RE: Caching

2013-07-17 Thread Steve LaBadie
Thank you both for responding. I will give it a try. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Wednesday, July 17, 2013 10:38 AM To: cf-talk Subject: Re:

RE: Caching

2013-07-17 Thread Steve LaBadie
Mark, Maximum number of cached templates 1024 Trusted cache not checked Save class fileschecked Cache web server paths checked Maximum number of cached queries100 Steve LaBadie, Web

RE: Caching

2013-07-17 Thread Russ Michaels
You can also set the caching abd ecpiry meta rags and hears on your pages to force reload. Be careful noy to completely disable browser caching tho or it Will slow down your site. Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 17 Jul 2013 15:41, Steve LaBadie

Re: Compare Two Lists

2013-07-17 Thread i...@markleder.com i...@markleder.com
Sure seems like I make things more complicated than they need to be. If the simple delete statement as you show will drop out the 4000 records without looping, then great! ~| Order the Adobe Coldfusion Anthology now!

Re: Empty file name in Application.log

2013-07-17 Thread Steve Moon
The problem has been identified: someone or something has been hitting a blank .cfm template on my site: http://www.someurl.com/..cfm There are quite a few errors in my CF8 Application.log file that look like this: String index out of range: -1 The specific sequence of files included or

Re: Regex question

2013-07-17 Thread Cameron Childress
On Wed, Jul 17, 2013 at 11:15 AM, Matthew Allen wrote: Is it possible to change the reference-link tag from a reference link tag reference-link id=1 type=reference/ to a superscript as so sup1/sup, basically getting the value of the id attribute of the reference link tag and creating a

Regex question

2013-07-17 Thread Matthew Allen
I have a body of text as below: body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link tag

RE: Compare Two Lists

2013-07-17 Thread Mark A Kruger
Not exactly It should look like this mark DELETE FROM someDBTable WHERE emailaddress IN (cfqueryparam cfsqltype=CF_SQL_CHAR value=#todelete# list=yes/) I left off the syntax for expediency :) Be sure this is what you want to do! -Original Message- From:

Tag replacement

2013-07-17 Thread a.matthew14
Hello all, I have a body of text as below:  body body body bodybodybody bodybody body body reference-link id=1 type=reference/ body body body reference-link id=2 type=reference/body body body bodybody body body body body Is it possible to change the reference-link tag from a reference link

RE: Tag replacement

2013-07-17 Thread Mark A Kruger
Here's one way to do this using adaptive tags. http://www.coldfusionmuse.com/index.cfm/2006/5/10/adaptive.tags Note.. I whipped this up and it may need debugging. First create a sub folder - call it whatever... let's say /adtags Next create a cfm file within the folder called reference.cfm

RE: Tag replacement

2013-07-17 Thread a.matthew14
Thanks Mark, will give it a go. Matt.  Original message From: Mark A Kruger mkru...@cfwebtools.com Date: 17/07/2013 17:37 (GMT+00:00) To: cf-talk cf-talk@houseoffusion.com Subject: RE: Tag replacement Here's one way to do this using adaptive tags.

Re: Tag replacement

2013-07-17 Thread Dean Lawrence
You could also simply use a regular expression to do the replace. cfset *testString* = 'reference-link id=2 type=reference/' / cfset *newstring* = *rereplace*(*testString*,'reference-link id=(\w) type=reference/',sup\1/sup) / The newstring variable would now be sup2/sup Dean On Wed, Jul 17,

Re: Tag replacement

2013-07-17 Thread Dean Lawrence
Your message is a reply to anothers post and is more than 100 lines of text. If possible, please trim your posts when replying. Thank you. This is just a friendly reminder and your message has not been blocked or altered in any way.

RE: Caching

2013-07-17 Thread Steve LaBadie
Russ, I had added META HTTP-EQUIV=Pragma CONTENT=no-cache before posting this thread with no luck. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edu -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, July 17,

Re: Caching

2013-07-17 Thread Russ Michaels
that by itself may not work, you need to add content expiry headers as well. If you google the topic you will find several code examples. On Wed, Jul 17, 2013 at 6:15 PM, Steve LaBadie slaba...@po-box.esu.eduwrote: Russ, I had added META HTTP-EQUIV=Pragma CONTENT=no-cache before posting

Re: Compare Two Lists

2013-07-17 Thread i...@markleder.com i...@markleder.com
FWIW: I have 4000 records to delete, with CF 9, throws an error: [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. I can break up the routines

Re: Compare Two Lists

2013-07-17 Thread Cameron Childress
Depending on where this CSV file is coming from, I'd just not use cfqueryparam. The only real reason to use it in a case like this is to make sure nobody's SQL injecting you. If this is an automated process and you think maybe one day you might not be able to trust the inputs form the CVS file,

Re: Compare Two Lists

2013-07-17 Thread Jeff Garza
What database platform are you on? I'd import those email addresses in the CSV to a temporary table and then just use a sub-select in the where clause. Let the database do the work... DELETE FROM someTable WHERE emailaddress in (SELECT email from tempImportTable) Also, if you are on SQL

Slow running request

2013-07-17 Thread Richard Steele
We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time

Re: Slow running request

2013-07-17 Thread Cameron Childress
On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele r...@photoeye.com wrote: We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db

Re: Slow running request

2013-07-17 Thread Russ Michaels
if you perform a stack trace on the slow requests while they are running this will tell you what it is doing at the time. On Wed, Jul 17, 2013 at 8:18 PM, Cameron Childress camer...@gmail.comwrote: On Wed, Jul 17, 2013 at 3:11 PM, Richard Steele r...@photoeye.com wrote: We occasionally

RE: Compare Two Lists

2013-07-17 Thread Mark A Kruger
If you do it this way you need listQualify() cfset toDelete = listqualify(toDelete,)/ Then you will need to preservesinglequotes in the query as in... WHERE emailAddress IN (#preservesinglequotes(todelete)#) That's one of the reasons that I USE cfqueryparam - to keep me from having to

RE: Slow running request

2013-07-17 Thread Mark A Kruger
Richard, You've only scratched the surface of what could be happening (ha). GC or other JVM related stuff could be happening... networking is also a good starting vector - assuming you are right about the SQL and I/O. For example, switches and NICs set to auto negotiate can sometimes exhibit

Re: Compare Two Lists

2013-07-17 Thread Cameron Childress
On Wed, Jul 17, 2013 at 5:09 PM, Mark A Kruger wrote: That's one of the reasons that I USE cfqueryparam - to keep me from having to write list code :) Agreed. It's rare that I recommend against cfqueryparam, but in this case I think it might be easier. -Cameron