RE: What the heck

2011-08-22 Thread DURETTE, STEVEN J (ATTASIAIT)
It should be cfif isDefined(session.userid) isdefined requires what you are looking for to be in quotes unless the variable name you are looking for is stored in session.userid. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Monday, August

(ot) MS SSIS (BIDS) 2008 options

2011-08-19 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, Sorry for the OT, but my Google foo has failed me! When trying to save a SSIS package to a server one of the options is Protection Level and it defaults to Encrypt data with User Key. The policy in our shop is to use Rely on server storage and roles for access control. It is a major

RE: excel sheets poiutility.cfc

2011-08-17 Thread DURETTE, STEVEN J (ATTASIAIT)
I don't know about poiutility.cfc, but cfhssf on riaforge can be used to do everything in memory. No files saved at all. I helped out with it a couple of years ago and that was one of the things I had to do for my own use. I actually may have made a more updated version that checks your

RE: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Shouldn't that be cfset col1 = '#query1.col1# The ' has to be outside of the # signs. -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Wednesday, August 17, 2011 11:26 AM To: cf-talk Subject: Re: coldfusion spreadsheet leading zeroes issue I tried using

RE: quick excel question

2011-08-11 Thread DURETTE, STEVEN J (ATTASIAIT)
Using the POI is awesome. It can do so much more than the cf9 spreadsheet option. You just have to get used to it. There is a cf poi cfc on riaforge. I helped with some of the extra features! To use even more features you can also upgrade the poi that cf uses. Steve -Original

RE: Stupid Question

2011-06-30 Thread DURETTE, STEVEN J (ATTASIAIT)
Why avoid isDefined()? -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Thursday, June 30, 2011 2:12 PM To: cf-talk Subject: RE: Stupid Question Actually without getting into a flame war with Dave and others, it should be better to use cfif

RE: Stupid Question

2011-06-30 Thread DURETTE, STEVEN J (ATTASIAIT)
But if you include the scope in the call then you would be fine right? I SCOPE EVERYTHING!!! -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Thursday, June 30, 2011 2:18 PM To: cf-talk Subject: Re: Stupid Question and the reason being that IsDefined() will

RE: Problem with pound signs

2011-06-24 Thread DURETTE, STEVEN J (ATTASIAIT)
Dohh. Didn't think of that... -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, June 24, 2011 12:23 PM To: cf-talk Subject: Re: Problem with pound signs Here is a crazy idea - wouldn't what you are looking for be a runtime error? If so - can't you use

RE: application.cfm

2011-06-23 Thread DURETTE, STEVEN J (ATTASIAIT)
I believe you are correct that the answer is no and that process seems perfectly logical and correct. Here is how I see the process running... By the way this is not actual knowledge of the process, but how I've always assumed that the process occurred. 1) Request is received by web server

RE: application.cfm

2011-06-22 Thread DURETTE, STEVEN J (ATTASIAIT)
This is because you are actually saving a pdf file as a .cfm. Maybe you should save it under a different extension, then have a page that serves it up using cfcontent. -Original Message- From: =?ISO-8859-1?Q?Claude_Schn=E9egans

RE: Timing out a webpage

2011-06-22 Thread DURETTE, STEVEN J (ATTASIAIT)
You may want to use multiple ways to do it... If you just use javascript then your timeout would be bypassed by just turning off javascript in the browser. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, June 22, 2011 3:02 PM To: cf-talk

RE: dbvarname mssql cf8?

2011-06-21 Thread DURETTE, STEVEN J (ATTASIAIT)
Do all JDBC drivers ignore @dbvarname? If not (and if CF actually passes it) then maybe you can get the MS (or another company's) JDBC drivers and use them instead. Steve -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: Tuesday, June 21, 2011 11:53 AM To:

RE: SOT - adding password forgot function to Mura CMS

2011-05-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Current security practices believe this is a bad idea. If you could do that then as the person running the site you would be able to get access to all of your users passwords. The password reset feature is safer. The user pick the password and the system hashes it, that is all that is saved and

RE: (ot) Shameful

2011-05-26 Thread DURETTE, STEVEN J (ATTASIAIT)
Double tap to the chest and one to the head ensures a bullet-proof vest doesn't come back to haunt you. :P (That's my video game experience talking!) -Original Message- From: Mark Drew [mailto:mark.d...@gmail.com] Sent: Thursday, May 26, 2011 12:52 PM To: cf-talk Subject: Re: (ot)

RE: scoping

2011-05-19 Thread DURETTE, STEVEN J (ATTASIAIT)
Always scope your variables! We used to have a cf programmer around here that used to put the variable level in the application scope. Then he occasionally put it in session scope, occasionally in request scope, sometimes in the variables scope, and even sometimes he would pull a query with

RE: (ot) Shameful

2011-05-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Please take this offline or to another more appropriate list. -Original Message- From: Irvin Gomez [mailto:ir...@pixel69.com] Sent: Tuesday, May 17, 2011 3:33 PM To: cf-talk Subject: Re: (ot) Shameful Really? You come in here with the intention to insult and raise ire and act like you

RE: Odd issue with DB pausing

2011-05-16 Thread DURETTE, STEVEN J (ATTASIAIT)
Do you have any indexes on this table. Improper indexes can really hamper the database while doing inserts. Steve -Original Message- From: Scott Weikert [mailto:li...@alphageek.cc] Sent: Monday, May 16, 2011 12:27 PM To: cf-talk Subject: Re: Odd issue with DB pausing Ok just

SSL Cert problem.

2011-05-05 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi Everyone, I'm trying to connect with SSL, and I have imported the CER into the java keystore, but when I try to do the connection I get the following error: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization. The server name is [REDACTED],

RE: MS XML Parse

2011-05-03 Thread DURETTE, STEVEN J (ATTASIAIT)
Are you sure that someone didn't screw up the XML in the file? -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Tuesday, May 03, 2011 12:15 PM To: cf-talk Subject: MS XML Parse Hello all. I am trying to parse thru an XML feed using the method that I always

RE: Output the value of dymanic session vars

2011-03-25 Thread DURETTE, STEVEN J (ATTASIAIT)
Try #session.institutionRegister[HUMANRESEARCH_SB_MODULE moduleID _GROUP groups.GroupID]# Steve -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Friday, March 25, 2011 10:21 AM To: cf-talk Subject: Output the value of dymanic session vars I dynamically

RE: Output the value of dymanic session vars

2011-03-25 Thread DURETTE, STEVEN J (ATTASIAIT)
Ugh EVALUATE. Why can't that just die? :P -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Friday, March 25, 2011 10:34 AM To: cf-talk Subject: Re: Output the value of dymanic session vars Try using cfset

ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi All, I have a short turn around on this so hopefully someone can help. I have searched the Adobe website, but I didn't find the appropriate documents. As I understand it if you purchase ColdFusion Enterprise edition, you get to use it on 2 machines (Production, Development/Hot Spare),

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I swear that I saw somewhere (I thought on this list but couldn't find it) that the licensing for CF9 was a change for what I had said before about the dev/hot spare, and it didn't have the ip restrictions. I thought that Adam had put both of the items out on this list, but I was looking for the

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I found the EULA for ColdFusion. Here are the appropriate sections: 3.1.3 If Licensee purchases one or more Production Software licenses, then Adobe also grants Licensee the right to install and use the Software as Development Software for internal development, testing and staging. 3.2

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
/index.cfm/2010/10/7/Buy-ColdFusion-9-Get-Free-Copi es-Of-ColdFusion-Builder Thanks, Steve -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, March 10, 2011 9:57 AM To: cf-talk Subject: Re: ColdFusion License and Builder On 3/10/2011 6:47 AM, DURETTE, STEVEN J

RE: ColdFusion License and Builder

2011-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
Eric, You are correct on that. I posted the relevant parts of the EULA in a previous email. Steve -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Thursday, March 10, 2011 12:39 PM To: cf-talk Subject: RE: ColdFusion License and Builder I also

RE: I think I'm confused...

2011-02-24 Thread DURETTE, STEVEN J (ATTASIAIT)
When I'm working on my local development I just add local. So: 127.0.0.1 local.www.durette.org That way I keep the url close to the original for code purposes, but I can get to the real site just by not putting in local. Steve -Original Message- From: Eric Cobb

RE: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-18 Thread DURETTE, STEVEN J (ATTASIAIT)
Probably a stupid question, but if the data was used across applications wouldn't it make sense to push it into the server scope? That would allow you to have one copy of the needed items, but still let you keep the applications separate. I know that a lot of the time having a different

RE: Invalid Precision Value from SQL Server CF9

2011-02-18 Thread DURETTE, STEVEN J (ATTASIAIT)
No it doesn't. Here is an example on SQL 2005: declare @test table ( testVal bit ) insert into @test (testval) values (0); insert into @test (testval) values ('Yes'); -- Results in error Conversion failed when converting the varchar value 'Yes' to data type bit. insert into @test

RE: SELECT - Option selected

2011-02-17 Thread DURETTE, STEVEN J (ATTASIAIT)
I read that you got this fixed, but for future reference I remember reading somewhere (I think on cf-talk) that the option value=/option Needs to have a space between the to make it work properly. Steve -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent:

RE: decimals and variables

2011-02-10 Thread DURETTE, STEVEN J (ATTASIAIT)
You need to do this: cfset tax = subtot * (tx / 100) / This actually converts the tx to a decimal. Also you don't need the #s in the cfset. :) Steve -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Thursday, February 10, 2011 9:14 AM To: cf-talk Subject:

RE: Form Validation Issue using cfinput AND jquery

2011-02-01 Thread DURETTE, STEVEN J (ATTASIAIT)
Is your JQuery validation returning false? Here is how I see it (I'm assuming here so don't shoot me)... CFValidation = false JQuery = true One result is true so it processes. CFValidation = true JQuery = false Same One result is true so it processes. CFValidation = false JQuery = false Both

RE: Insert without checking existance

2011-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
If you are just doing an insert, why don't you do it like this Insert into table(keyword) Select @keyword -- Variable containing the keyword Where not exists(select keyword from table where keyword=@keyword); Keeps it all in one block/transaction. -Original Message- From: Michael

RE: Insert without checking existance

2011-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
So just out of curiosity, is this on a SQL 2008 box? If so then you can use merge and give different options for insert or update (even delete if you want) Steve ~| Order the Adobe Coldfusion Anthology now!

RE: Subtracting two dates

2011-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Depends... If you are looking at less than 31 days difference then you can do it in the db. (only tried this in SQL Server). Select cprAdultExp, getDate() as [now], day(getDate() - cprAdultExp) - 1 as dayDiff From table You can get days, hours, minutes, seconds from this. Day is the only one

RE: Coldfusion Hosting

2011-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
That's funny, http://hostingatoz.com/ returns FORBIDDEN You don't have permission to access/ on this server! Steve -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Friday, January 28, 2011 2:03 PM To: cf-talk Subject: Re: Coldfusion Hosting Well, if

RE: Coldfusion Hosting

2011-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Strange it came up for me in Firefox, but my Corporate version of IE8 gets the following error: Forbidden You don't have permission to access / on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. -Original

RE: Insert without checking existance

2011-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
We have SQL2005 and SQL2008 servers. When we went to 2005 I thought This is great, with 2008 I think How did I do this before! The MERGE function is really nice. It's also nice to be able to declare a variable and set its value all in one statement. Example: 2005 (and before): declare @today

RE: why is cf_builder so expensive?

2011-01-27 Thread DURETTE, STEVEN J (ATTASIAIT)
/products/coldfusion/cfbuilder/faq/ ) only says you need to be a current student (and that you aren't allowed to use it for production purposes, which does limit its usefulness for people on this list). Scott On Wed, Jan 26, 2011 at 7:12 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: One

RE: why is cf_builder so expensive?

2011-01-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Sorry my failed attempt at humor. I just thought it was funny. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Thursday, January 27, 2011 10:41 AM To: cf-talk Subject: Re: why is cf_builder so expensive? There are multiple places on Adobe.com that use PHP.

RE: why is cf_builder so expensive?

2011-01-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Guys... This was just something funny I noticed... It happens all of the time when you have to get a project out and the only developer available doesn't know your preferred language. Maybe it was a new guy, maybe it was a designer who just used graphical tools (Dreamweaver) to do the site and

RE: why is cf_builder so expensive?

2011-01-26 Thread DURETTE, STEVEN J (ATTASIAIT)
One note on the student edition of CFBuilder, it is the only one that *requires* that you will be taking a course in ColdFusion at the college to get the free version. I applied for it a couple of times before I noticed that. Steve -Original Message- From: Dave Watts

RE: why is cf_builder so expensive?

2011-01-26 Thread DURETTE, STEVEN J (ATTASIAIT)
Please don't take my response as being anything against Dave. I was just making a statement about what I found out through trial and error. I have a lot of respect for Dave. He takes the time to help out many people here on the list. His varied experience with ColdFusion has made him one of the

RE: why is cf_builder so expensive?

2011-01-26 Thread DURETTE, STEVEN J (ATTASIAIT)
Yeah I forgot Nadel, Camden and others. I was just trying to do it quickly. -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, January 26, 2011 10:19 AM To: cf-talk Subject: Re: why is cf_builder so expensive? You forgot Nadel. Also I +1 the Watts

RE: Custom Tags, cf_location

2011-01-25 Thread DURETTE, STEVEN J (ATTASIAIT)
You know one of the things that I have always loved about this list is that anyone could ask a question no matter how NOOBISH and no one would treat them with any ill will. The people would always gently move them to the proper way of doing things and everyone would learn. I apologize that this

Need a little sql help...

2011-01-24 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, My SQL mojo seems to have left me. Here is the situation, I have 1 table. In this table there are some times two rows that should have actually been one. Here is an example to explain. Table: Name, Age, address one, address two Row 1: Steve,40,123 Anystreet,NULL Row 2:

RE: Need a little sql help...

2011-01-24 Thread DURETTE, STEVEN J (ATTASIAIT)
That was just example data... The Name is actually a distinct number letter combination. When the data is passed over to me they are supposed to pre-merge the rows into one, but they don't so I have been tasked to deal with it when the data suppliers don't. Another issue is that there are MANY

RE: Anyone know anything about this new ColdFusion conference?

2011-01-21 Thread DURETTE, STEVEN J (ATTASIAIT)
SO... All of this is interesting conversation, but the initial question was is there any more information on this new conference? I've been trying to find a list of the 2011 conferences so I can plan to attend one. I have to schedule my vacation so I can attend my first conference. The only

RE: Anyone know anything about this new ColdFusion conference?

2011-01-21 Thread DURETTE, STEVEN J (ATTASIAIT)
Subject: Re: Anyone know anything about this new ColdFusion conference? On Fri, Jan 21, 2011 at 9:34 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: The only conference I saw any detail on was cfopen in Texas and I didn't find out about that until too late. Since it hasn't happened yet

RE: Anyone know anything about this new ColdFusion conference?

2011-01-19 Thread DURETTE, STEVEN J (ATTASIAIT)
New ColdFusion conference in DC in august?!?!?! Do tell! I'm trying to plan to attend my first CF Conference this year and it's been really hard trying to find out when they are going to happen. I found out about cf open summit, but I don't think I have enough time to plan for that. Thanks,

Strange errors when running CF from command line and running Flash Forms.

2011-01-06 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, Recently I started running ColdFusion from the command line so I can see any errors/exceptions/etc live. While I was running a page that has a flash form in it, the following errors came up on the screen: 01/06 11:55:04 [jrpp-0] ERROR internal error: expected to get a state

RE: Strange errors when running CF from command line and running Flash Forms.

2011-01-06 Thread DURETTE, STEVEN J (ATTASIAIT)
Thank you. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, January 06, 2011 1:18 PM To: cf-talk Subject: Re: Strange errors when running CF from command line and running Flash Forms. The [jrpp-0] bit isn't relevant for your search, as it just designates

RE: Another 8.01 Gotcha (CFDOCUMENT)

2010-12-15 Thread DURETTE, STEVEN J (ATTASIAIT)
Brook, No, Installing the latest hot fix may not include everything. Charlie Arehart just blogged on this. Try these links: http://bit.ly/fWhBU4 and http://bit.ly/fT6yip Steve -Original Message- From: Brook Davies [mailto:br...@logiforms.com] Sent: Wednesday, December 15, 2010 3:58

RE: checking for active links/pages (OT)

2010-12-08 Thread DURETTE, STEVEN J (ATTASIAIT)
You could write something that parses out cfm files looking for the cflocation, cfinclude and a href tags and grab the filenames. Then you could filter that to be a distinct list. Then as everyone else suggested, search the logs to see if they have been hit recently. Steve -Original

RE: SQL Azure and Coldfusion 9

2010-11-30 Thread DURETTE, STEVEN J (ATTASIAIT)
So use isDefined(Variables.queryname) first. -Original Message- From: Sean Henderson [mailto:shender...@followup.net] Sent: Tuesday, November 30, 2010 4:14 PM To: cf-talk Subject: Re: SQL Azure and Coldfusion 9 This is actually incredibly easy to deal with this scenario, you just have

RE: Choosing between ColdFusion Builder and IntelliJ

2010-11-18 Thread DURETTE, STEVEN J (ATTASIAIT)
Aptana? Really? I tried adding the Aptana plugin with cfeclipse once. It slowed Eclipse down massively and in general just got in my way. Maybe I'm using it wrong though. Anyone have quick tips for using Aptana for CF development? I may try it again if I can get some value out of it. Steve

RE: cfheader/cfheader not working as expected

2010-11-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I don't remember if you posted any code, but I get by this with the following: cfset Variables.contVal = inline;filename=#Variables.myFileName# / cfheader value=#Variables.contVal# name=content-disposition cfcontent type=#Variables.myType# reset=Yes variable=#Variables.mySpreadsheetVar# Before

CF Blog software

2010-11-09 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, So I haven't blogged in about a year because of different issues with my website provider... Any how I'm looking to get my blog going again, but I don't know how I should proceed. I used to use blogcfc, but my provider restricts a bunch of tags (below). Can anyone suggest which blog

RE: CF Blog software

2010-11-09 Thread DURETTE, STEVEN J (ATTASIAIT)
Kind of wish I could, but I get my package for $119 a year, the site doesn't make any money it is just for personal use, and I can't afford much more for what I get. For that price I can host 5 domains, unlimited email addresses for each domain, I don't remember how much bandwidth or drive

RE: CF Blog software

2010-11-09 Thread DURETTE, STEVEN J (ATTASIAIT)
, you're not really alive. -- Margaret Atwood On Tue, Nov 9, 2010 at 10:08 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Kind of wish I could, but I get my package for $119 a year, the site doesn't make any money it is just for personal use, and I can't afford much more for what I

RE: CF Blog software

2010-11-09 Thread DURETTE, STEVEN J (ATTASIAIT)
, DURETTE, STEVEN J (ATTASIAIT) wrote: my provider restricts a bunch of tags (below) Most of the restrictions are reasonable for a shared host that wants to provide a modicum of security. In a properly configured Sandbox cfcontent, cflog and setProfileStrng could be enabled but the rest is just the way

RE: CF Blog software

2010-11-09 Thread DURETTE, STEVEN J (ATTASIAIT)
: DURETTE, STEVEN J (ATTASIAIT) Sent: Tuesday, November 09, 2010 4:07 PM To: cf-talk Subject: RE: CF Blog software Yes, but you are assuming commercial hosting. I host my own website (non-commercial) and the website for a club at the local community college. Neither generates money so cost

RE: I think I'm just making this way too hard...

2010-11-05 Thread DURETTE, STEVEN J (ATTASIAIT)
Remove the # signs. You are telling cf to pass dateOfTotal to the server as a variable value. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, November 05, 2010 4:21 PM To: cf-talk Subject: RE: I think I'm just making this way too hard... Well,

RE: Group BY

2010-11-03 Thread DURETTE, STEVEN J (ATTASIAIT)
Your group by has to match your select in most cases... Also, you are using reserved words in your query so that can mess stuff up. Try this instead... Select count(intMemberID) as [NewMembers], dateName(mm, [dteAdded]) + '-' + dateName(, [dteAdded]) as MTH From table Group by dateName(mm,

RE: What difference does the parenthesis make?

2010-10-18 Thread DURETTE, STEVEN J (ATTASIAIT)
That depends on the DB server. MSSQL doesn't have any problem with getting rid of the () that I know of. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Monday, October 18, 2010 3:17 PM To: cf-talk Subject: What difference does the parenthesis make? What's

RE: 32-bit / 64-bit COM object issues in ColdFusion 9

2010-10-12 Thread DURETTE, STEVEN J (ATTASIAIT)
I believe they just did do some kind of update to COM. I was just reading something that mentioned it. You may have to roll back the update to make it work the way you expect. That's a security/stability decision for Eric though. Steve -Original Message- From: Cameron Childress

RE: ListFunction Question

2010-10-08 Thread DURETTE, STEVEN J (ATTASIAIT)
Assuming that the file is delimited by chr(13): Variables.myFile is the entire file cfoutput cfloop from=1 to=#listLen(Variables.myFile, chr(13))# index=Variables.outerLoop #Variables.outerLoop#:#listLen(listGetAt(Variables.myFile, Variables.outerLoop, chr(13)), ,)#br / /cfloop

RE: ListFunction Question

2010-10-08 Thread DURETTE, STEVEN J (ATTASIAIT)
Oh wait I get it now. CF ignores things like ,, and you want to know if it has a value. Try this, cfset myArray = arrayNew(1) / cfset myArray = listToArray(Variables.myList, ,, true) / cfif len(myArray[Variables.itemToTest]) ... Code to process if this item actually exists ... /cfif

RE: CF 9.01 with JRocket JRE

2010-10-08 Thread DURETTE, STEVEN J (ATTASIAIT)
The error you gave said something about missing java.config right? Then try attrib /s java.config from C:\ It will tell you every place that file exists on the C drive (change drives as appropriate) Steve -Original Message- From: Mary Jo Sminkey [mailto:mary...@cfwebstore.com] Sent:

RE: CF 9.01 with JRocket JRE

2010-10-08 Thread DURETTE, STEVEN J (ATTASIAIT)
Opps that was missing or corrupt jvm.config so attrib /s jvm.config -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Friday, October 08, 2010 1:29 PM To: cf-talk Subject: RE: CF 9.01 with JRocket JRE The error you gave said something about missing java.config right

RE: CF9 Paused Scheduled Tasks Still Running

2010-10-05 Thread DURETTE, STEVEN J (ATTASIAIT)
I'm not totally sure, but I do notice that when I restart my CF server, there is an entry for the scheduled task in the log stating that it is paused. Could it be that that date updates every time the CF Server tries to run (on its scheduled time) but doesn't actually run it. Or maybe instead

WOT: W3C Validator install on Windows problem

2010-10-04 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, I'm trying to install the W3C Validator on a windows machine. It uses Perl to do the validations, and I have tried both ActivePerl and Strawberry Perl. I've tried installing one of the needed perl Modules (SGML:Parser:OpenSP) and I can't seem to get it to work. I installed OpenSP

RE: WOT: W3C Validator install on Windows problem

2010-10-04 Thread DURETTE, STEVEN J (ATTASIAIT)
Oh yes! The problem isn't specifically with perl, it is with installing the required Perl Module SGML:Parser:OpenSP. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, October 04, 2010 3:23 PM To: cf-talk Subject: Re: WOT: W3C Validator install on Windows

RE: Restricting CFM file access

2010-10-01 Thread DURETTE, STEVEN J (ATTASIAIT)
Do it in code, cfif cgi.remote_addr neq 127.0.0.1cfabort/cfif Of course you may want to add a couple others then you could use listFind instead of a simple string compare. Steve -Original Message- From: Asaf Peleg [mailto:a...@locusenergy.com] Sent: Friday, October 01, 2010 2:14 PM

RE: Website validation... need suggestions

2010-09-29 Thread DURETTE, STEVEN J (ATTASIAIT)
Thanks for the info! -Original Message- From: Ketan Jetty [mailto:kje...@yahoo.com] Sent: Tuesday, September 28, 2010 3:13 PM To: cf-talk Subject: Re: Website validation... need suggestions Hi Steven, You can use JMeter (free toll) to stress test your application. Also you can use

Website validation... need suggestions

2010-09-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, I recently got tasked with doing some compatibility testing. While doing that testing I found that there were other things that were wrong with the website(s). This is a bunch of sites that are developed by multiple programmers, so I expect a little slop here and there, but I found

RE: Website validation... need suggestions

2010-09-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Russ, Thanks for the Google Links, but again this is on an intranet so I can't submit something outside the firewall. I am looking at the W3 Validator for download again along with the link checker and W3C Log checker. My main reason for asking was also more on the idea of something that

IIS 7 401.2 Error for cftree (long post with error info)

2010-09-24 Thread DURETTE, STEVEN J (ATTASIAIT)
All, I have a website that has to use NTLM authentication. A little Info first: IIS7, Windows 2008 Server, CF Version: 8,0,1,198765, Non-standard port: 81. URL looks like http://admin.mywebsite.com:81/index.cfm No issues at all accessing the CFAdmin. I have set the /CFIDE/scripts and

RE: IIS 7 401.2 Error for cftree (long post with error info)

2010-09-24 Thread DURETTE, STEVEN J (ATTASIAIT)
I have /CFIDE/Scripts and /CFIDE/classes changed to Anonymous and that cleared up the errors fiddler reported for them, but I still get the error notification and the calls to /webs/coldfusion/applets/CFTreeApplet.class and /webs/coldfusion/applets/CFTreeApplet/class.class don't make any sense.

RE: IIS 7 401.2 Error for cftree (long post with error info)

2010-09-24 Thread DURETTE, STEVEN J (ATTASIAIT)
Do you mean I have to turn on both NTLM and Anonymous for these items? For testing purposes I've also granted EVERYONE read/execute to all of these folders. I set All of CFIDE to anony and locked down Administrator and adminapi. Still no love. :( -Original Message- From: Dave Watts

RE: IIS 7 401.2 Error for cftree (long post with error info)

2010-09-24 Thread DURETTE, STEVEN J (ATTASIAIT)
Thanks Dave! That seems to have done it. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, September 24, 2010 12:38 PM To: cf-talk Subject: Re: IIS 7 401.2 Error for cftree (long post with error info) Do you mean I have to turn on both NTLM and Anonymous

RE: 3 layers of validation?

2010-09-23 Thread DURETTE, STEVEN J (ATTASIAIT)
First off, NEVER NEVER NEVER (should I say it again) assume that the data hitting the server or the database is coming from your form page. It is extremely easy for someone to do a view source and find out where the form data posts to. Then they can send all sorts of crap at the server just to

RE: 3 layers of validation?

2010-09-23 Thread DURETTE, STEVEN J (ATTASIAIT)
And then of course there is always this: http://xkcd.com/327/ I showed that comic to an intern, years ago, who didn't validate his database inputs and accidentally deleted a whole database because he put code in the wrong place.

RE: 3 layers of validation?

2010-09-23 Thread DURETTE, STEVEN J (ATTASIAIT)
To: cf-talk Subject: Re: 3 layers of validation? On Thu, Sep 23, 2010 at 9:48 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Lastly, NEVER assume that your server application (CF, PHP, ASPX) is the only thing that will hit your database. Say someone finds your database and calls

ColdFusion and Internet Explorer Compatibility testing tool

2010-09-17 Thread DURETTE, STEVEN J (ATTASIAIT)
I have to do testing for a migration project using the Internet Explorer Compatibility Testing Tool, IE8 and Windows 7. Before we get into an IE/Firefox/Chrome war, this is a corporate requirement! During testing the following issues have come up: 1) I've found that any time a

RE: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'

2010-09-08 Thread DURETTE, STEVEN J (ATTASIAIT)
With SQL Server, DEFINITELY go with left(str, 4) = 'string' It has much less processing overhead. -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, September 08, 2010 1:20 PM To: cf-talk Subject: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'

RE: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'

2010-09-08 Thread DURETTE, STEVEN J (ATTASIAIT)
and easy to find? On Wed, Sep 8, 2010 at 1:23 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: With SQL Server, DEFINITELY go with left(str, 4) = 'string' It has much less processing overhead. -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday

RE: CFParam vs. IsDefined

2010-09-01 Thread DURETTE, STEVEN J (ATTASIAIT)
Using your way ensures that any variables that you are using already exist. I was always taught that I should define my variables before I use them in code (my ancient programming college courses). So, I tend to follow your method. Also, from a security stand, you should already know what

RE: manipulating Excel files

2010-08-30 Thread DURETTE, STEVEN J (ATTASIAIT)
Yes that would be interesting to know since I also believe that POI is what ColdFusion uses for its internal tags to do manipulation. I mean if it doesn't use POI, then why are the POI jars included in CF? :) -Original Message- From: Steve Bryant [mailto:st...@bryantwebconsulting.com]

RE: Suppressing whitespace from CFCs

2010-08-05 Thread DURETTE, STEVEN J (ATTASIAIT)
cfsilentYour non-output code here!/cfsilent -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, August 05, 2010 10:14 AM To: cf-talk Subject: Suppressing whitespace from CFCs I've moved output function into CFC's; thus I'm using output=true.

RE: Suppressing whitespace from CFCs

2010-08-05 Thread DURETTE, STEVEN J (ATTASIAIT)
Robert, I just tested it out (CF9) and cfsilent worked fine in a cffunction in a cfc with output=true. Maybe something in your code between the cf silents is breaking the tag matching. Or maybe your cfsilents are in bad positions. I know that this bit me before (not my code, but took me a while

RE: SQL Server Data Archival - my solution

2010-07-30 Thread DURETTE, STEVEN J (ATTASIAIT)
Pete, This is awesome! I'm going to consider using it for certain tables that we have problems with. I might suggest that you add in the user name and/or ip that made the change. That can help if you need to find out who made specific changes! Thanks, Steve -Original Message- From:

RE: CF8 on 2008 R2 and batch files

2010-07-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Sorry to say, I write and use custom tags all the time. Plus, you don't want to break any current functionality so you kinda need to make the tags work, unless you have the power, time, money, etc to make them re-write all the code that uses the custom tags. Steve -Original Message-

(ot) changing the default for loading actionscript files in cfeclipse/eclipse

2010-07-19 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, Sorry for the off topic, but when I'm working on a project in CFEclipse that has actionscript files, if I double click on the file it starts up Flash to open the file. I don't want that, I want the .as file to open in CFEclipse. I know I can right click the file and choose Open With

RE: (ot) changing the default for loading actionscript files in cfeclipse/eclipse

2010-07-19 Thread DURETTE, STEVEN J (ATTASIAIT)
Ok... But why should I have to do that? The default OS Application for .cfm files is Dreamweaver, but when I open CFE and double click a .cfm file it opens in CFE. Besides, in some companies, changing defaults like that are locked down. Thanks for the idea though, I might do that as a last

RE: (ot) changing the default for loading actionscript files in cfeclipse/eclipse

2010-07-19 Thread DURETTE, STEVEN J (ATTASIAIT)
File Associations :den -- In the beginning the Universe was created. This has made a lot of people very angry and has been widely regarded as a bad move. Douglas Adams On Mon, Jul 19, 2010 at 10:45 AM, Won Lee wrote: On Mon, Jul 19, 2010 at 12:42 PM, DURETTE, STEVEN J (ATTASIAIT) wrote: Ok

CFGrid and actionscript

2010-07-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, I have a small dilemma and would like some suggestions. I have an app that has been working for a long time. It is a Flash Form using a cfgrid. ActionScript and Flash Remoting is used to deal with updating and saving changes, etc. If there is only a row or two in the grid

RE: Best conference?

2010-07-14 Thread DURETTE, STEVEN J (ATTASIAIT)
So... Did anyone else get the email stating that this year would be the LAST CFUnited conference? Steve ~| Order the Adobe Coldfusion Anthology now!

RE: struct lookup vs. query of queries

2010-07-14 Thread DURETTE, STEVEN J (ATTASIAIT)
Correct me if I'm wrong (please) but isn't a query already a Struct of Arrays? I mean the following is totally valid: Table user_list (user_fname, user_lname) {shown in comma delimited format} Cameron, Childress Michael, Dinowitz Steve, Durette cfquery name=myUserList (blah blah) Select

RE: cfqueryparam question (null attribute)

2010-07-06 Thread DURETTE, STEVEN J (ATTASIAIT)
Why not define form.myDate in the first place. cfparam name=form.myDate default= / Then... cfqueryparam value=#form.myDate# null=#not len(trim(form.myDate))# / Steve -Original Message- From: Matthew Lowrey [mailto:rid...@gmail.com] Sent: Tuesday, July 06, 2010 11:57 AM To: cf-talk

  1   2   3   >