CFTOKEN CFID cookies with long gibberish prefix... CF11?

2015-04-06 Thread Gaulin, Mark
Hi We have one CF web server running CF11 and noticed that the CFTOKEN and CFID cookies on that server have a long (51 char) string of random looking characters before the actual CFID or CFOTKEN numeric value. Ex: CFTOKEN = Z3epk1hxi861r0je68dw9xjrpf2oqa1vm0ygobljizhhw2d5gjh-22151980 Within

RE: Avoiding a boat load of queries inserting multiple records - Better Way?

2014-10-10 Thread Gaulin, Mark
My experience with MS SQL Server is that you have to do multiple inserts using a series of UNION statements... Insert into tablename(field1, field2, field3, field4 ...) select value1, value2, value3, value4 ... union all select value1, value2, value3, value4 ... union all select value1,

CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark
Hi Folks Our single CF11 test server just highlighted a freaky difference between CF10 and CF11 that has us all puzzled. (We are running CF11 with the latest service pack.) It appears that the CF mappings defined in CFIDE (such as /cfc - root dir for all of our CFC's) are not defined inside

RE: CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark
that you created a mapping in the ColdFusion admin? Also, can you maybe share some of your Application.cfc code for us to get a better idea as to what you are trying to accomplish? On Wed, Oct 8, 2014 at 1:58 PM, Gaulin, Mark mark.gau...@ihs.com wrote: Hi Folks Our single CF11 test server just

RE: CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark
? On Wed, Oct 8, 2014 at 1:58 PM, Gaulin, Mark mark.gau...@ihs.com wrote: It appears that the CF mappings defined in CFIDE (such as /cfc - root dir for all of our CFC's) are not defined inside the block of code at the top of Application.cfc I would also test this with a global mapping

RE: CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark
(); } public void function onRequestStart() { application.applicationManager.onRequestStart(); } /cfscript /cfcomponent On Wed, Oct 8, 2014 at 2:39 PM, Gaulin, Mark mark.gau...@ihs.com wrote: Hi Dean Yes, we defined mappings in the CF Admin

RE: JNDI threads BLOCKED - server falling over

2010-11-09 Thread Gaulin, Mark
Hi Those threads are not your problem... They represent server threads that are waiting for someone to open a socket to them. (JNDI is built into java; CF might be using it but either way it isn't directly hurting anything.) If your dead/hung servers are using lots of cpu then look for threads

RE: Vexed over CFID

2010-07-27 Thread Gaulin, Mark
You need to make sure that you setdomaincookies=true on your cfapplication tag. This will assign cfid cftoken cookies that will be used by any site with a host name that ends with .abc.com. If you don't do domain cookies then cfid cftoken are unique for each host name. It is possible that your

RE: Deleting Verity Collections

2010-07-06 Thread Gaulin, Mark
Could be a file open for read issue... On Windows I'd recommend restarting the verify service; I don't know what the equivalent operation is for your environment. -Original Message- From: Robert Nurse [mailto:rnu...@gmail.com] Sent: Tuesday, July 06, 2010 11:36 AM To: cf-talk Subject:

Anybody exporting charts from FusionCharts?

2010-06-10 Thread Gaulin, Mark
Hi We use FusionCharts for nice client-side charting (using Flash), but we also need to generate static images on the server-side. Unfortunately they don't support CF, and their example (in jsp) is really hard to follow. (It uses their ExportBean, but we don't have documentation for it, and the

RE: Homesite 9 project

2010-06-01 Thread Gaulin, Mark
Is the homesite docs format the same as CF Studio (html files in these folders: Help\htmldocs, Extensions\Docs\CFMLTags, and Extensions\Docs\CFMLFunctions)? I have an automated process to convert the official help web site to files in this format, but I haven't done it for CF9 yet (since I use

RE: ReCaptcha service changes!

2010-03-26 Thread Gaulin, Mark
Restart ColdFusion... Java caches host-to-IP address stuff for a long time. Thanks Mark -Original Message- From: Jeff Gladnick [mailto:jeff.gladn...@gmail.com] Sent: Friday, March 26, 2010 12:36 PM To: cf-talk Subject: ReCaptcha service changes! We're using cfReCaptcha and got

RE: Why i fear ColdFusion is on its last legs - Move to CF-Community??

2010-01-22 Thread Gaulin, Mark
Please, can this thread end, or at least move to CF-Community or something? Thanks Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

RE: Caching issue

2009-07-21 Thread Gaulin, Mark
Are you using session scope for anything (like the current customer)? If so, do you have a load balancer that may have lost its sticky IP setting? (It could be that you are bouncing around your web site cluster and getting different session state on each one.) Thanks Mark

RE: HTMLEditFormat() on Password Fields

2009-06-26 Thread Gaulin, Mark
Hi Use htmlEditFormat()... The encodings ( - amp;, for example) don't affect the actual value in the edit box... It only changes the HTML used to get that value into the edit box (safely). Try it for yourself to see... (and if I'm wrong, well damn, let me know and I will have just learned

RE: HTMLEditFormat() on Password Fields

2009-06-26 Thread Gaulin, Mark
for the most part. -Original Message- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: Friday, June 26, 2009 12:37 PM To: cf-talk Subject: RE: HTMLEditFormat() on Password Fields Hi Use htmlEditFormat()... The encodings ( - amp;, for example) don't affect the actual value in the edit

RE: Secure CFIDE Virtual Directory

2009-05-26 Thread Gaulin, Mark
FYI, you can move/copy the js files out of cfide and configure CF to reference them from the new location. See http://kb2.adobe.com/cps/000/3e56e2e5.html, and probably other docs too. To answer your original question, I lock down the IP addresses that can access /cfide to prevent anyone from

RE: phone formating string and removing hidden characters

2009-05-20 Thread Gaulin, Mark
- From: Gaulin, Mark [mailto:mgau...@globalspec.com] Sent: 2009-05-19 13:53 To: cf-talk Subject: RE: phone formating string and removing hidden characters That screenshot looks like a newline character (or is it a linefeed?) as shown by an editor that was expecting a more Windows-ly

RE: phone formating string and removing hidden characters

2009-05-19 Thread Gaulin, Mark
That screenshot looks like a newline character (or is it a linefeed?) as shown by an editor that was expecting a more Windows-ly standard line ending. Other editors (like EditPad) would probably show each phone number on its own line. Anyway, you can use cf's asc() method to find the actual

RE: ColdFusion 8.0.1 Performance Affected by IIS7 Application Pool

2009-03-19 Thread Gaulin, Mark
We had a weird CF-stability problem on one IIS7 server and it turned out to be related to the IIS app pool... We deleted and recreated the default pool and the problem cleared up. This didn't make us feel all that good, but at least the problem went away. Be sure to check the Event Viewer to

RE: 64 bit imagecr3

2009-03-02 Thread Gaulin, Mark
We're using the service version of imagecr3, but not on 64 bit windows (to work better with Windows Server 2008). It works as expected. Does the Local account have access to the image folder? -Original Message- From: Rick Root [mailto:rick.r...@webworksllc.com] Sent: Monday, March 02,

RE: cffunction in Component file

2009-03-02 Thread Gaulin, Mark
Another approach that I sometimes use is to declare an explicit argument to the function call inputArgs of type struct, and then replace all references to FORM in the function to arguments.inputArgs. This allows the main page can the function with as myCfc.myFunction(inputArgs = form) and it

RE: cfinclude template issues

2009-02-19 Thread Gaulin, Mark
Hi Scott After your /cfquery, add this to see exactly what the query is returning: cfdump var=#GetPageContent# cfabort The first line will dump the query (or any variable, which is very handy), and cfabort will end the page (before the error hits). If the dump doesn't show a column called

RE: (ot) More SQL Profiler questions

2009-02-12 Thread Gaulin, Mark
...and now you know why I don't like cfqueryparam... As far as I can tell there is no way for you to translate that 162 into the actual sql that it corresponds to since the id 162 is specific to the database connection. (You can look around at prepared statements by querying syscacheobjects, but

RE: OT: More SQL Profiler questions

2009-02-12 Thread Gaulin, Mark
Hi Rick That's a good trick with MaxPooledStatements... Say, what was the deal with going back to using the regular SQL Server JDBC and my queries are flying? Thanks Mark -Original Message- From: Rick Root [mailto:rick.r...@webworksllc.com] Sent: Thursday, February 12, 2009

RE: (ot) More SQL Profiler questions

2009-02-12 Thread Gaulin, Mark
without any Questionmarks... Even if you use CFQUERYPARAM. Gert -Ursprüngliche Nachricht- Von: Gaulin, Mark [mailto:mgau...@globalspec.com] Gesendet: Donnerstag, 12. Februar 2009 15:26 An: cf-talk Betreff: RE: (ot) More SQL Profiler questions ...and now you know why I don't like

RE: Arrays

2009-02-08 Thread Gaulin, Mark
Your point about being able to use QoQ is a good one. It turns out that a query is actually implemented as a struct of arrays (where the struct key is the name of the column), and the most annoying thing about that is having to index the arrays by current row all of the time, vs a true array

RE: JVM Tuning and Garbage Collection

2009-02-06 Thread Gaulin, Mark
Hi Very interesting discussion about JVM tuning. I can't help much with that, but I do have a suggestion for investigating your database. If you have SQL Server you can run the SQL profiler to watch for slow queries; I've used this to isolate the queries that were actually slow (lots of

RE: JVM Tuning and Garbage Collection (Using SQL Profiler)

2009-02-06 Thread Gaulin, Mark
Hi I've seen a similar regular burp in SQL server performance every fifteen minutes or so on our servers too. I thought it might be related to maintaining the transaction log but I was never able to prove it. I have some notes on using SQL Profiler that I wrote for an internal information

RE: Calling functions with cfoutput

2009-01-15 Thread Gaulin, Mark
I just have to comment... Saying that using a function to output isn't really the done thing in CF is ridiculous... The CF language has many features and, used appropriately, they can all be used for just about anything in a safe, consistent, and understandable way. Good designs do not have to be

RE: IIS Application Pools and ColdFusion

2008-12-02 Thread Gaulin, Mark
Another easy thing to try: Drop and recreate your app pool. It sounds stupid but we had one server where one app pool wasn't stable but all of the other servers we had (running the same app) were fine. Recreating the app pool resolved the issue. BTW, you should be seeing failures in your Event

RE: IIS Application Pools and ColdFusion

2008-12-01 Thread Gaulin, Mark
I don't know about MS 2003 too much, but in 2008 the app pools have two related Rapid-fail protection settings that we had to tweak: the maximum failures and failure interval. It appears that app pools can be set up to shut themselves down when IIS sees too many errors within a given amount of

Try/catch rethrow in cfscript?

2008-11-21 Thread Gaulin, Mark
Hi Is there any way to rethrow an exception within a cfscript try/catch block? (In case you are wondering, you cannot use cfrethrow in a cffunction-defined UDF to get around the problem... cfrethrow must be directly nested inside a cfcatch block.) - Ok, I found a work-around

RE: client variables log database is huge

2008-11-20 Thread Gaulin, Mark
It sounds like you are referring to the transaction log portion of a database, and you can definitely expect the transaction log for Client variables database to grow very quickly because they are updated on every hit. Database transaction logs need to be checkpointed or cleared on backup or

RE: custom tags slow?

2008-11-12 Thread Gaulin, Mark
Hi CF does have a bit more work to do when you use open/close custom tags for exactly the reason you suspect. (It has to buffer the content between the tags, but it was going to buffer it anyway, just in a different place.) There are also some limitations (like not being able to use cfflush

RE: inserting a structure...within a structure...within a structure

2008-11-11 Thread Gaulin, Mark
IMHO... Tip #1 (drop the unneeded #'s) is good. Tip #2 (drop the query name within the loop) is very, very bad. Why? Because from reading the code it isn't clear where those unscoped values are coming from. You might as well tell people not to explicitly reference the url, form, attributes,

RE: Imagecr3 vs cf8 cfimage

2008-10-17 Thread Gaulin, Mark
For what it's worth, I've been sing imagecr3 for years but recently could not get the tag to work at all on CF8 on Windows Server 2008 (32bit) (but the tag does work with CF8 on other Windows Oses... go figure). We had to switch to cfimage to get things working again and anecdotally found that

CF8 setdomaincookies not working right? [Second try]

2008-10-03 Thread Gaulin, Mark
Anybody got a minute or two to run the test below on CF8? I'm about to contact Adobe about this and it would sure be nice to know that others were seeing it too. Thanks Mark -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 4:20

CF8 setdomaincookies not working right?

2008-10-02 Thread Gaulin, Mark
Hi Folks We are testing CF8 and discovered that the cfapplication option setdomaincookies doesn't appear to work with host names like www.xyz.com, but does work with www.extra.xyz.com. For www.xyz.com, it sends back headers like this: Set-Cookie: CFID=8500;expires=Sat, 25-Sep-2038 19:52:17

RE: ColdFusion Consultant as a Java Consultant?

2008-09-25 Thread Gaulin, Mark
If you don't program in java a lot then I don't see how you could successfully call yourself a java consultant. The two languages and environments are nothing alike when things start to get interesting, and is someone needs a consultant then things are probably already interesting. Thanks

RE: CFC Objects (Best Practice)?

2008-09-24 Thread Gaulin, Mark
Where to store the object would depend on the nature of the object... Does it have internal state (variables) that are specific to a given user (so, maybe use session, but definitely not application), or is the object sharable by every user (so, application might work). I tend not to cache lite

RE: list and ListContainsNoCase

2008-08-06 Thread Gaulin, Mark
Yeah, but isn't it great how the ListFind definition says ...list element in which a specified value occurs, so what the heck is occurs supposed to mean?? Occurs sounds a lot like has an occurrence, which would mean list element contains! I'm only complaining because I read the ListFind

Easy way to dump contents of a CFC?

2008-07-22 Thread Gaulin, Mark
Hi cfdump with a cfc shows the methods of the cfc. Is there an easy way to see the values stored in CFC? Does it work recursively, so if a cfc member points to another cfc instance, then that cfc is dumped in the same way? We're on cfmx 6 and also 7. Thanks Mark

RE: cfquery and cfstoredproc

2008-07-22 Thread Gaulin, Mark
As you have heard, cfquery is vulnerable to sql injection attacks, so you have to do something. You will hear that cfqueryparam is the best practice for protecting against sql injection attacks, and there is certainly truth to that. However, there are also costs associated with cfqueryparam.

RE: cfquery and cfstoredproc

2008-07-22 Thread Gaulin, Mark
Hi Brad Thanks for the links, those are interesting articles. The problem with MS SQL Profiler and cfqueryparam is that the sql that arrives at the sql server replaces the literal sql with something like sp_exec 72 (I forget the actual sp name) followed by the parameters (which are easily

(ot) Decent Eclipse plugin for SQL editing?

2008-06-25 Thread Gaulin, Mark
Hi I'm looking for an Eclipse plugin (for 3.2) that will do syntax highlighting and such for SQL (T-SQL specifically, but I don't care about that), specifically for *.sql files. I tried SQL Explorer but it does a pretty lame job of syntax highlighting while editing existing sql files... it

RE: CF running a Java Process- Making sure that it completes

2008-06-11 Thread Gaulin, Mark
Just a random suggestion, but make sure that your readWMS class isn't smart enough to know that it already ran... Maybe it sets static variables or something like that that would prevent it from running twice. I suppose you could test that by making a simple stand-alone java app that creates and

RE: CSV Generation MEMORY SUCK

2008-06-02 Thread Gaulin, Mark
We had a similar issue with an internal application and we made good improvements using the standard java classes PrintStream, FileOutputStream, and BufferedOutputStream to handle the writing to your file. Something like this (shown in java, so you'd have to wrap it properly with cfscript):

RE: Coldfusion's execution time relative to C++

2008-05-22 Thread Gaulin, Mark
This assumption is definitely wrong... The java code that CF creates (and compiles) is very different than the same logic written by hand in java code. Take a look at the .java files that are created by CF and you'll see what I mean. (I don't recall how to enable the saving of those files, but it

RE: MSSQL Query help - Finding an exact word in a field

2008-05-21 Thread Gaulin, Mark
Are there a fixed set of delimiters in use in your title field? If so then you could look for: (Title = 'CAP' OR Title like 'CAP %' OR Title like '% CAP %' OR Title like '% CAP') -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent:

RE: **UPDATE** JRn 600MB+ shortly after boot up

2008-05-19 Thread Gaulin, Mark
If you are using Task Manager to judge sizes then be sure to notice the difference between Mem Usage and VM Size... Mem Usage is the amount of physical ram currently in use by a process, but VM Size is, well, different. If you have less physical ram on a machine then you may see less Mem Usage

RE: **UPDATE** JRn 600MB+ shortly after boot up

2008-05-16 Thread Gaulin, Mark
I haven't been reading this thread closely, but is there a specific reason that you think that the JVM shouldn't be that big? For instance, I have set jvm.config to start jrun with a good chunk of memory right at start up (using -Xms). Perhaps your's is set that way too? Have you looked at how

RE: URLs being appended to query string

2008-04-22 Thread Gaulin, Mark
This is probably an attempt to generate link spam. It sucks, but other than taking measures to reduce the error notifications there may not be much you can actually do about it. Thanks Mark -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, April

RE: args arg collections

2008-04-21 Thread Gaulin, Mark
collections Yes, I could *always* use the names, but I'm trying to run the function with unnamed arguments. Additionally, I explicitly want to pass arguments from one to the next. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 5:06 PM To: CF-Talk

RE: args arg collections

2008-04-18 Thread Gaulin, Mark
Try this (below) and you'll see why... The arguments collection is key value and testMe assigns a key of 1 to the first argument, which doesn't match any of the arguments to testMe2. cffunction name=testMe2 output=1 cfargument name=one type=string cfdump var=#arguments# /cffunction

RE: CF8: Class not found: coldfusion.sql.QueryTable

2008-03-31 Thread Gaulin, Mark
I just tried compiling both ways and my classes compile to the exact same bytecode no matter which version of the cfusion jar I compile with, so that's not it. Thanks for the idea though. Thanks Mark -Original Message- From: C S [mailto:[EMAIL PROTECTED] Sent: Friday, March

RE: CF8: Class not found: coldfusion.sql.QueryTable - RESOLVED (sort of)

2008-03-31 Thread Gaulin, Mark
reloading, but something must have changed with CF8's classpath that makes cfusion.jar not available to servlets. Thanks Mark -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 3:49 PM To: CF-Talk Subject: CF8: Class not found

CF8: Class not found: coldfusion.sql.QueryTable

2008-03-28 Thread Gaulin, Mark
Hi I use java code to create a Query to be returned to a CF page, but with CF8 my java code throws this error: java.lang.NoClassDefFoundError: coldfusion/sql/QueryTable I can create this class with CreateObject(Java, coldfusion.sql.QueryTable) from a CF page, but my java code (running in

RE: Any accumulated bug reports for cold fusion 8?

2008-03-15 Thread Gaulin, Mark
? From: Will Swain [mailto:[EMAIL PROTECTED] Sent: Sat 3/15/2008 7:47 AM To: CF-Talk Subject: RE: Any accumulated bug reports for cold fusion 8? They all match, FYI. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 14 March 2008 21:26

RE: Any accumulated bug reports for cold fusion 8?

2008-03-14 Thread Gaulin, Mark
For those of us without CF8 handy, and you saying that this is accurate: cfset x = 10 cfset y = 20 cfif x eq 10 this will NOT match? cfif x eq 10 this will match? cfif y eq 20 this will match? cfif y eq 20 this will NOT match? cfif 10 eq 10 how about this? Thanks

RE: What are the Necessary Code Changes for Migrating from 6.1 to 8?

2008-03-12 Thread Gaulin, Mark
From: s. isaac dealey [mailto:[EMAIL PROTECTED] Uhuh... and in order for this statement to make sense, you would have to claim that you have never, ever made a decision, documented it, and then discovered *later* that it had an impact you hadn't expected. Shocking! No, I'm not claiming to

RE: What are the Necessary Code Changes for Migrating from 6.1 to 8?

2008-03-11 Thread Gaulin, Mark
Sounds to me like there's an expectation that the folks doing the beta for new versions will be more superhuman than everyone else. But the folks running the beta are not the ones responsible for discovering what the vendor changed! If you think we're all mad at the beta testers for not

RE: What are the Necessary Code Changes for Migrating from 6.1 to 8?

2008-03-10 Thread Gaulin, Mark
The issue is not that there might be problems running the new version, but that the vendor has not properly documented the changes between versions. I don't think they should be required to maintain a version x to version x + 2 set of issues, but a comprehensive list of compatibility-related

RE: Find/Replace for Eclipse

2008-03-05 Thread Gaulin, Mark
That is excellent news! -Original Message- From: Matthew Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2008 3:34 PM To: CF-Talk Subject: Re: Find/Replace for Eclipse That's sweet. Thanks. I just grabbed the 3.4M5 build from the eclipse site. Unzipped the folder, and

No 64-bit on Windows for CF8?

2008-02-15 Thread Gaulin, Mark
Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I am not seeing support for 64-bit CF (on 64 bit java) on Windows. I see from random a blog posts over the years that 64-bit support was hoped for in CF8

RE: No 64-bit on Windows for CF8?

2008-02-15 Thread Gaulin, Mark
for an announcement in the very near future. --- Ben -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 1:32 PM To: CF-Talk Subject: No 64-bit on Windows for CF8? Hi Based on the CF8 feature list here http://www.adobe.com/products/coldfusion/features/ I

RE: Java-Coldfusion conversion

2008-02-08 Thread Gaulin, Mark
Hi You may be having issues because the main method appears to be a static method, and I seem to recall that there is an issue with calling those directly from CF when you don't have an instance of the class handy. I suggest you create a java class of your own that does the calls you want, but

RE: JavaCC/ANTLR grammar for ColdFusion?

2008-02-03 Thread Gaulin, Mark
is a real pain, as it is one strnge language syntactically. Mark On Feb 2, 2008 7:39 AM, Gaulin, Mark [EMAIL PROTECTED] wrote: Hi Has anybody done any work on pulling together a grammar for ColdFusion, something that might be a good start for a compiler-compiler like JavaCC or ANTLR

RE: cf5 and single quote

2008-02-01 Thread Gaulin, Mark
CF has been doing proper single-quote replacement all the way back to the early days (at least CF3, probably all the way back to the original), so that is not the issue. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, February 01, 2008 1:55 PM To: CF-Talk

JavaCC/ANTLR grammar for ColdFusion?

2008-02-01 Thread Gaulin, Mark
Hi Has anybody done any work on pulling together a grammar for ColdFusion, something that might be a good start for a compiler-compiler like JavaCC or ANTLR? (If you've used these tools before, would you recommend one over the other?) I'd like to try some static analysis on CF code and having a

RE: Duplicates in Arrays or Lists

2008-01-30 Thread Gaulin, Mark
Put the values in a Struct; in one pass you can create a second array/list that avoids any values that are already in the Struct. Mark -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 11:16 AM To: CF-Talk Subject: Duplicates in

RE: SQL Question -- Order by a column's value?

2008-01-25 Thread Gaulin, Mark
Yes, you can do this with a CASE statement. The syntax may depend on you db, but on SQL Server ORDER BY CASE Colleges WHEN 'Harvard' THEN 1 WHEN 'Princeton' THEN 2 WHEN 'Dartmouth' THEN 3 ELSE 100 END This would

RE: The _ character in variable names

2008-01-24 Thread Gaulin, Mark
it isn't variable names that you need to worry about in this special case, just form (or url?) field names. That, I think, is an important difference. (And yes, it totally sucks to find out that you just spent a day tracking down this issue. Been there.) Thanks Mark -Original

RE: syntax issue between Access and MS SQL

2008-01-23 Thread Gaulin, Mark
Apparently you can't use ORDER BY on the first SELECT, so I presume that the second ORDER BY will be applied to the combined rows. Thanks Mark -Original Message- From: Ben Conner [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 9:04 AM To: CF-Talk Subject: syntax issue

RE: Strange Characters Appearing in Browser

2008-01-22 Thread Gaulin, Mark
You should look at the HTTP headers that come back when you request the static vs dynamic version of the page... I bet you will see something like this in the CF version: Content-Type: text/html; charset=UTF-8 This line asserts the character set of your content, and that can make all of the

RE: Strange Characters Appearing in Browser

2008-01-22 Thread Gaulin, Mark
LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 22, 2008 11:15 AM To: CF-Talk Subject: RE: Strange Characters

RE: Strange Characters Appearing in Browser

2008-01-22 Thread Gaulin, Mark
Obviously the real fix is up to the CMS people, but if you can't change the CMS's behavior, maybe you can tweak the data... Perhaps just replacing the 0xC5 with nbsp; via SQL or in CF? Lame, but what else can you do. Thanks Mark -Original Message- From: Steve LaBadie

RE: designing db tables for calendar events

2008-01-17 Thread Gaulin, Mark
For what it's worth, the MS SQL Server model for scheduled tasks is well documented in the SQL DMO help. Do a search for SQLDMOFreq_Daily and you'll be smack in the middle of the data model they use. Their model has no problem with first Tuesday of each month, etc, and it may give you ideas. It

RE: cfqueryparam, cached execution plans, and changing table structure

2008-01-17 Thread Gaulin, Mark
Does your query do select * ... or select fieldname, ...? We always avoid select * ... and that avoids lots of potential issues with caching in CF or in the SQL server (and I think it makes for easier-to-maintain code, even though it is more verbose). Thanks Mark -Original

RE: DB Design question

2008-01-11 Thread Gaulin, Mark
Hi It looks like you have to decide between two approaches: the one-table-per-list-type method requires a lot of tables but it gives you explicit foreign key relationships and straight-forward querying; the one-table-with-a-type-identifier method requires that you define some sort of type field

RE: Spell Checker

2008-01-10 Thread Gaulin, Mark
Any spell check is going to have to server-side component... You won't find a pure one written in JS. There may be some open spell check service out there but I didn't find one when I looked a couple of years ago. I ended up using aspell with a java wrapper (which I could easily call from CF).

RE: Odd custom tag issue

2008-01-04 Thread Gaulin, Mark
Yup, CF caches the location of custom tags. -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, January 04, 2008 11:27 AM To: CF-Talk Subject: Re: Odd custom tag issue Alright then, that one falls squarely under the heading of questions you should wait 5 more

RE: dealing with timezones

2007-12-20 Thread Gaulin, Mark
Dealing with time zones was a major PITA a recent project I did. Eventually I decided to store all dates in UTC and format them as needed for the current user. This made it much easier to deal with those dreaded daylight savings time shifts, when local time jumps around and offsets just don't cut

RE: SQL Full-Text Searching

2007-12-20 Thread 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 +

RE: What is happening to my request variables?

2007-12-17 Thread Gaulin, Mark
I haven't use an Application.cfc yet, but why would you need to explicitly create the request variable (request = structnew())... That scope is always present, right? Thanks Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 4:08

RE: 500 null due to large amounts of records returned

2007-12-14 Thread Gaulin, Mark
Hi As you suspect, calling cfquery causes ALL records returned by the query to be read into memory, so this is very likely the problem. Do you intend to show the client (browser) the million records? If not then you shouldn't need to query them on your page. (If yes, the wow, that'll be some

RE: Cfoutput query backwards

2007-11-15 Thread Gaulin, Mark
The query indexing syntax comes in handy... It lets you treat the query as a big array. So, you can use cfloop with an index (numeric values from #queryName.recordCount# down to 1, so step -1) and get your column values out by doing queryName[index].value (or is it queryName.value[index]?) Thanks

RE: Site Admin Wierdness

2007-11-13 Thread Gaulin, Mark
Are you talking about the ColdFusion site admin? I'm not recalling a rich text editor, so I'm wondering if there is some other authoring admin tool in play here. (Is /cfide in the url?) A random idea that might have no relevance whatsoever: check your browser cookies... Do you have a login-type

RE: cfdocument/cfsavecontent killing server memory

2007-11-13 Thread Gaulin, Mark
Sounds like normal virtual memory usage... The JVM had to grow to the bigger size and waited until it was sure it didn't need the memory again to give it back to the OS (because taking memory from the OS and giving it are expensive operations). BTW, I'm assuming you are looking at the amount of

RE: URLEncodedFormat question

2007-10-26 Thread Gaulin, Mark
If I understand your question then you could use cfsavecontent to grab the table being generated and store it in a string, which you could then put into a form field or encode as an url param or whatever. Thanks Mark -Original Message- From: john mcdonald [mailto:[EMAIL

RE: Lock question

2007-10-25 Thread Gaulin, Mark
Yeah, that sounds right. A refinement would be to only lock if the application data was not defined (so, test for it and return if it is defined) and, within the lock, to retest for it being defined (just as you have now). The test within the lock is to avoid a race condition where many clients

RE: CFMX 7 - Jrun 100%

2007-10-24 Thread Gaulin, Mark
If you have access to the web server (remote desktop is great) then you get an extremely useful thread dump of the jrun server process using the steps described below... They talk about CF 6 but it applies to CF7 too. SUMMARY: Try to get a stack trace (technote 18339 -

RE: Setting a variable that contains quotes and apostrophes.

2007-10-23 Thread Gaulin, Mark
That works because you switched string delimiters in your variables... The first one uses single quotes around the whole string and has internal double quotes; and second has the opposite. To combine them just remember that you can include the string delimiter in the string itself just double

RE: Am I going mad

2007-10-17 Thread Gaulin, Mark
It is possible that doing a QoQ will tweak the data types assigned to each column. QoQ was pretty flakey that way, and its behavior has changed a bit with each major version. Thanks Mark -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October

RE: CF Coding Standards / validation / CFML pasring

2007-10-11 Thread Gaulin, Mark
Coding Standards Gaulin, Mark wrote: What I would find more interesting is something approaching a coding style validator for important things, like varing local variables in functions and always scoping variables properly (to the degree that I would want), checking for cfparam tags for url, form

RE: CF Coding Standards / validation

2007-10-10 Thread Gaulin, Mark
sidetracked by other OSS commitments. I should return to it at some point, and finish it off. Mark On 10/10/07, Gaulin, Mark [EMAIL PROTECTED] wrote: Actually, all this talk about cf code formatting styles is making me wish there was a way to reformat code in cfeclipse (to my liking), but I'd always

RE: CF Coding Standards / validation

2007-10-10 Thread Gaulin, Mark
commitments. I should return to it at some point, and finish it off. Mark On 10/10/07, Gaulin, Mark [EMAIL PROTECTED] wrote: Actually, all this talk about cf code formatting styles is making me wish there was a way to reformat code in cfeclipse (to my liking), but I'd always be wary about

RE: CF Coding Standards / validation

2007-10-10 Thread Gaulin, Mark
What you say is true (only a programmer can know how a variable is used), but a warning generated if a variable is not explicitly scoped would help find the little oversights that can be a real pain to track down. I am of the opinion that all warnings in a program (java, for example) should be

RE: CF Coding Standards / validation

2007-10-10 Thread Gaulin, Mark
Hi This is an interesting tool. It does seem to flag problems that are inside strings, so it could definitely benefit from a 'real' cfml parser. (But since it is written in CF, I wouldn't expect it to be perfect; my perl-based cfml parser was pretty lame too, but still quite useful for what it

RE: CF Coding Standards

2007-10-09 Thread Gaulin, Mark
Actually, all this talk about cf code formatting styles is making me wish there was a way to reformat code in cfeclipse (to my liking), but I'd always be wary about the formatter changing something important (and subtle) in the html. Still, it might make an interesting addition to cfeclipse.

  1   2   3   4   >