RE: Is it time for Adobe to Rebrand Cold Fusion?

2010-06-25 Thread DURETTE, STEVEN J (ATTASIAIT)
I agree not only do they need to try and get classes into the colleges, they also need to teach the capabilities to the web staff of the colleges. I took a class on web administration (required couldn't opt out even though I've been doing this a long time), and I used CF for my final project. Whe

RE: cfdot.net

2010-06-24 Thread DURETTE, STEVEN J (ATTASIAIT)
I don't know if I totally agree with that. Does the C# code follow best practices for C#? When doing a comparison between two languages you should use best practices for both languages. After all for good code we should all use best practices. I was taught that when using Java (not entirely dif

RE: Is it time for Adobe to Rebrand Cold Fusion?

2010-06-22 Thread DURETTE, STEVEN J (ATTASIAIT)
Wait... Wouldn't that be Ray 2010.1, Ray 2010.2, Ray 2010.3? :) Steve -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Tuesday, June 22, 2010 4:58 PM To: cf-talk Subject: RE: Is it time for Adobe to Rebrand Cold Fusion? [spamtrap bayes][spamtrap heur]

RE: imageRead plus imagepaste plus imageGetBlob issue

2010-06-03 Thread DURETTE, STEVEN J (ATTASIAIT)
Why don't you use a hybrid... Drop the files in a directory, then when it's that files turn, check to see if a file of the same name is in a subdirectory called watermarked (or something like that). If it is just serve up the watermarked file. If not have the process create the watermarked file

RE: CF & Domain Redirects

2010-06-03 Thread DURETTE, STEVEN J (ATTASIAIT)
(in this case www.domains.com) and have it redirect via a url to www.domain.com. I just figured there must be a simpler way than to create another "site" in IIS to do this. Che -----Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Thursday, June 03, 20

RE: CF & Domain Redirects

2010-06-03 Thread DURETTE, STEVEN J (ATTASIAIT)
As long as you own the incorrect domains.com you should be able to have IIS do a re-direct to the proper address. You can re-direct an entire url right in the interface. I've done it before but it has been a while. Steve -Original Message- From: Scott Brady [mailto:dsbr...@gmail.com]

RE: Homesite 9 project

2010-06-01 Thread DURETTE, STEVEN J (ATTASIAIT)
I'm willing to help. Just let me know what you want me to do! -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Tuesday, June 01, 2010 11:31 AM To: cf-talk Subject: Homesite 9 project I'll be updating Homesite to the latest (CF9) docs. If anyone has a

RE: How to make a select option tag selected in CF?

2010-05-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Oh and as a matter of preference (and for some code checking tools) I hate it when tags are embedded in other tags. I would re-write this as: Personal Steve -Original Message- From: Yuliang Ruan [mailto:yuliangr...@hotmail.com] Sent: Thursday, May 27, 2010 4:24 PM

RE: How to make a select option tag selected in CF?

2010-05-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Not true about selected instead of selected="selected" Selected works for HTML4, selected="selected" is for XHTML. It will depend on what is being used, but HTML4 supports selected="selected" and xhtml does not support selected. So in this case it is probably best to use selected="selected" St

RE: ColdFusion memory leaks

2010-05-21 Thread DURETTE, STEVEN J (ATTASIAIT)
umber per CF server, so on a dual-core Xeon, we used to do 15-20 connections, and the settings are per datasource, so you don't have to worry about splitting them or load-balancing them across your datasources. ---- From: "DURETTE, STEVEN J (ATTASIAIT)

RE: ColdFusion memory leaks

2010-05-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Jason, You stated that connections should be set at 5 * CPU cores, is that the cores on the CF server or the SQL server? Also... What happens if you have multiple data sources. Do you use the same settings for each data source, or do you split that 5 * CPU cores across the data sources? Steve

RE: Convert to number

2010-05-13 Thread DURETTE, STEVEN J (ATTASIAIT)
...@gmail.com] Sent: Thursday, May 13, 2010 1:38 PM To: cf-talk Subject: Re: Convert to number That won't work, you'll get "100.00", not "10.00". Try REReplace(my_number, "[^0-9.]", "", "all"). cheers, barneyb On Thu, May 13, 2010

RE: Convert to number

2010-05-13 Thread DURETTE, STEVEN J (ATTASIAIT)
Robert, You shouldn't have to strip it in a perfect world, but the comma makes it a string not a number according to ColdFusion. Try this instead: $#numberFormat(val(my_number), "__.00")# Might not work, I didn't test it. Steve -Original Message- From: Robert Harrison [mailto:ro

RE: What is the version of Java SDK CF should use?

2010-05-13 Thread DURETTE, STEVEN J (ATTASIAIT)
Ok, I'm not starting a war or anything here... I agree with Dave as to the fact that it doesn't happen in most cases. But I believe it should. If you code something that uses underlying code/structure/etc made by someone else and that code/structure/etc gets updated due to security issues/etc, t

RE: Which code reuse method?

2010-05-13 Thread DURETTE, STEVEN J (ATTASIAIT)
I think components still make the most reusable choice for things like this. I throw all my utility type functions into one cfc and call the correct function according to what is required, even if no input is required it still has the desired affect of doing xyz. These don't change often so I nor

RE: Which code reuse method?

2010-05-13 Thread DURETTE, STEVEN J (ATTASIAIT)
Shannon, In some ways you are right, but for code reuse I still believe the custom tag is the way to go. Say you put the code in /webroot/myIncludes/myReusableCode.cfm. Someone working in /webroot/Application1/SubApp1/report would have to use either or if the /webroot is mapped correctly. Usi

RE: SQLServer2005 and European dates

2010-05-12 Thread DURETTE, STEVEN J (ATTASIAIT)
Mike, I sent out another email with a link to an article about changing the database collation. Steve -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Wednesday, May 12, 2010 10:10 AM To: cf-talk Subject: Re: SQLServer2005 and European dates Thank you Steve, bu

RE: SQLServer2005 and European dates

2010-05-12 Thread DURETTE, STEVEN J (ATTASIAIT)
On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > Mike, > > SQL Server doesn't actually save the date in either format. It saves it > as seconds (milliseconds maybe) from a certain date (I believe > 1/1/1900). > >

RE: SQLServer2005 and European dates

2010-05-12 Thread DURETTE, STEVEN J (ATTASIAIT)
ebworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > Mike, > > SQL Server doesn't actually save the date in either format. It saves it >

RE: SQLServer2005 and European dates

2010-05-12 Thread DURETTE, STEVEN J (ATTASIAIT)
00.000 Steve -Original Message----- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Wednesday, May 12, 2010 9:35 AM To: cf-talk Subject: RE: SQLServer2005 and European dates Mike, SQL Server doesn't actually save the date in either format. It saves it as seconds (milliseconds maybe) from

RE: SQLServer2005 and European dates

2010-05-12 Thread DURETTE, STEVEN J (ATTASIAIT)
Mike, SQL Server doesn't actually save the date in either format. It saves it as seconds (milliseconds maybe) from a certain date (I believe 1/1/1900). The way it is displaying is based on the collation setting of the Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates back li

RE: Which code reuse method?

2010-05-11 Thread DURETTE, STEVEN J (ATTASIAIT)
If your custom tag doesn't surround anything, make sure you add this line: That way if you have programmers that self close tags (), it won't run twice. Steve -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Tuesday, May 11, 2010 12:32 PM To: cf-talk Subject: Re:

RE: Search for any that is referencing any UNC path.

2010-05-07 Thread DURETTE, STEVEN J (ATTASIAIT)
If you have a newer Windows OS (Vista, Win 7, Win 2008), then you can use powershell. I know in some environments you can't install software (even if it's free) because of company policies. I did a search and the following, based off of combining a lot of different articles, will create a file w

RE: Anyone done this before???

2010-05-07 Thread DURETTE, STEVEN J (ATTASIAIT)
Nope. What I would do is convert the report to a webpage and pull the data from the db. -Original Message- From: Stephen Hoskins [mailto:shosk...@andonia.com] Sent: Friday, May 07, 2010 12:17 PM To: cf-talk Subject: Anyone done this before??? I have a pretty complex MS Access report th

RE: DateAdd value different on different servers

2010-04-22 Thread DURETTE, STEVEN J (ATTASIAIT)
bject: Re: DateAdd value different on different servers Steve, On Thu, Apr 22, 2010 at 8:47 AM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > I believe it is doing this because even though you are adding a specific > amount of seconds the system automatically knows

RE: DateAdd value different on different servers

2010-04-22 Thread DURETTE, STEVEN J (ATTASIAIT)
I believe it is doing this because even though you are adding a specific amount of seconds the system automatically knows to make adjustments based on its time zone or if it uses daylight savings time or not. So even though you say ignore that, you can't because the system doesn't ignore it. Ste

RE: DateAdd value different on different servers

2010-04-21 Thread DURETTE, STEVEN J (ATTASIAIT)
Looks like one of the servers updated to DST and the others didn't. Steve -Original Message- From: Tom McNeer [mailto:tmcn...@gmail.com] Sent: Wednesday, April 21, 2010 1:55 PM To: cf-talk Subject: DateAdd value different on different servers There's a simple answer to this one; it's

RE: SOT: external css not displaying

2010-04-07 Thread DURETTE, STEVEN J (ATTASIAIT)
I've never been able to get the "link" tag to work with cfdocument. Try this: -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Tuesday, April 06, 2010 6:20 PM To: cf-talk Subject: Re: SOT: external css not displaying No becau

RE: Flash Forms Stopped Working In ColdFusion 9

2010-04-01 Thread DURETTE, STEVEN J (ATTASIAIT)
Any chance you moved to a Win 2008 server? We had a similar problem and it turned out that after we set everything up Win2K8 re-secured a couple of directories and there were security exceptions in the log. -Original Message- From: Larry Peery [mailto:lpe...@stfm.org] Sent: Thursday, Ap

RE: occasional issue with form fields not being passed.

2010-04-01 Thread DURETTE, STEVEN J (ATTASIAIT)
Will, I've generally found that when this happens it is because the user had a bookmark to the submitted form. I generally have my forms return to the empty form if no data was submitted. Suddenly I was bombarded with log entries about the file that deals with the submission was getting an empty

RE: Does not contain dilema

2010-03-22 Thread DURETTE, STEVEN J (ATTASIAIT)
Not knowing the exact logic, I believe you need to change to this. Better yet: Steve -Original Message- From: Orlini, Robert [mailto:rorl...@hwwilson.com] Sent: Monday, March 22, 2010 11:51 AM To: cf-talk Subject: Does not contain dilema I have a form with a field call "intype"

RE: CF9 and MS SQL DSN Creation Errors

2010-03-19 Thread DURETTE, STEVEN J (ATTASIAIT)
That sounds right. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, March 19, 2010 1:40 PM To: cf-talk Subject: Re: CF9 and MS SQL DSN Creation Errors DURETTE, STEVEN J (ATTASIAIT) wrote: > MS SQL 2005 and 2008 deny ip Connections by default, you have

RE: CF9 and MS SQL DSN Creation Errors

2010-03-19 Thread DURETTE, STEVEN J (ATTASIAIT)
MS SQL 2005 and 2008 deny ip Connections by default, you have to go into the settings (don't remember how off the top of my head) and allow tcpip connections. -Original Message- From: Christopher Stowell [mailto:christopher.stow...@yahoo.com] Sent: Friday, March 19, 2010 1:34 PM To: cf-

RE: Data Parse error

2010-03-18 Thread DURETTE, STEVEN J (ATTASIAIT)
Remove all the quotes around the cfqueryparams. ColdFusion will deal with the quotes for you when you use the cfqueryparam tag. -Original Message- From: Steven Sprouse [mailto:sspro...@ccboe.com] Sent: Thursday, March 18, 2010 10:10 AM To: cf-talk Subject: Re: Data Parse error I'm sor

RE: Phantom Scheduled Tasks

2010-03-12 Thread DURETTE, STEVEN J (ATTASIAIT)
Bryan, You don't by any chance have a cfschedule tag in any of your code? Maybe something is hitting code with a cfschedule tag to automatically recall the page in 5 minutes. That might explain why the second hit is always exactly 5 minutes after the original call no matter what the time fra

RE: Phantom Scheduled Tasks

2010-03-11 Thread DURETTE, STEVEN J (ATTASIAIT)
riginal Message----- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, March 10, 2010 3:33 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks Bryan, I normally save all of CGI/Form/URL. The main CGI ones to look at though are: Cgi.http_referer, cgi.http_us

RE: Phantom Scheduled Tasks

2010-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
Bryan, I normally save all of CGI/Form/URL. The main CGI ones to look at though are: Cgi.http_referer, cgi.http_user_agent, cgi.remote_addr, cgi.request_method, cgi.script_name If cgi.remote_addr is the ip of the server then the server made the call. User agent helps to see if it was the schedul

Data pivot problem (brain isn't working right today)

2010-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, Got a problem trying to convert a many to many relationship to a grid. There are three tables (defined below), and I need the output in a certain way (also defined below). I've done this before, but for the life of me I can't remember how. Table 1 (Target_Stratifications): Str

RE: Phantom Scheduled Tasks

2010-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
fthrow in Event2 just after it started the report. This dumped the stack trace to a file. There was nothing before the call to Event2 besides the normal Mach-II event handling stuff. Bryan -----Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, Marc

RE: Phantom Scheduled Tasks

2010-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
In event 2, put in something that saves off all the CGI/form/url variables to a file before it does any other processing. Then you can look at the file for the second run and see what kicked it off. -Original Message- From: Bryan S [mailto:bryansgroup...@gmail.com] Sent: Wednesday, Mar

RE: Make HomeSite+ Open Source? (WAS: RE: Development Apps - Does anyone use homesite still?)

2010-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I'll raise my hand for this. I probably won't be able to do it all, but if a few of us all work on it then it should get done pretty quick. Let me know what I need to do. Steve -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Wednesday, March 10, 20

RE: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread DURETTE, STEVEN J (ATTASIAIT)
Hate to say it... Fix the database. Fixing the database almost always shows a better speed increase and processing than refactoring CF code. That is if the database is a mess in the first place. I've just started reading Joe Celko's SQL for Smarties, and in the first chapter I've found stuff I'

RE: Local Server Crashes - How to back up settings

2010-03-02 Thread DURETTE, STEVEN J (ATTASIAIT)
Thanks this will help a lot I hope! -Original Message- From: Jacob [mailto:ja...@excaliburfilms.com] Sent: Tuesday, March 02, 2010 10:30 AM To: cf-talk Subject: RE: Local Server Crashes - How to back up settings What I backup.. In the ColdFusion directory: \bin\neo-*.xml (Your CF Ad

Local Server Crashes - How to back up settings

2010-03-02 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, So I still don't have ColdFusion working. I've decided to just reinstall CF, but I need to back up all of the Admin settings. How can I do that without ColdFusion running? Thanks, Steve ~| Want to reach the

RE: CF9 local dev server crashes.

2010-03-01 Thread DURETTE, STEVEN J (ATTASIAIT)
around. ~Brad Original Message Subject: RE: CF9 local dev server crashes. From: "DURETTE, STEVEN J (ATTASIAIT)" Date: Mon, March 01, 2010 3:04 pm To: cf-talk No changes to debugging at all. Even trying to hit the CFAdmin causes it to crash. -Original Message- From: b.

RE: CF9 local dev server crashes.

2010-03-01 Thread DURETTE, STEVEN J (ATTASIAIT)
anges to the debugging templates have you? What happens if you turn off request debugging? Was there a previous install of CF on your machine? ~Brad Original Message Subject: CF9 local dev server crashes. From: "DURETTE, STEVEN J (ATTASIAIT)" Date: Mon, March 01,

CF9 local dev server crashes.

2010-03-01 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, I have a problem with my cf9 server on my local dev box crashing. Even with the most simple ColdFusion page it crashes. When I say crashes, the service stops working. I ran CF9 using cfstart.bat just to see what is going on, and the results are below. This was just working fo

RE: CFID and CFToken

2010-02-24 Thread DURETTE, STEVEN J (ATTASIAIT)
As I understand it, Firefox shares cookies, etc across all instances of Firefox. IE however treats every instance as its own little world and doesn't share well with itself. Steve -Original Message- From: Chad McCue [mailto:ch...@icsciences.com] Sent: Wednesday, February 24, 2010 1:16

RE: difference between cfproperty and variables defined with This scope

2010-02-02 Thread DURETTE, STEVEN J (ATTASIAIT)
Opps. I used didn't put variables in this instance. I wanted them to only be part of the cfc. Steve -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Tuesday, February 02, 2010 1:50 PM To: cf-talk Subject: RE: difference between cfproperty and variables defined

RE: difference between cfproperty and variables defined with This scope

2010-02-02 Thread DURETTE, STEVEN J (ATTASIAIT)
According to the docs, cfproperty only sets Metadata. I just did this recently and even though I could set the initial values I had trouble changing them and using them just inside the cfc. I resorted to Notice that there is no var in there. If the variables are outside of a function, you can

RE: Link test.

2010-02-01 Thread DURETTE, STEVEN J (ATTASIAIT)
JS file downloaded for me. -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Monday, February 01, 2010 10:52 AM To: cf-talk Subject: Link test. Can a few of you out there in CF-Talk land test this link and tell me if you get the expect JavaScript file or something e

RE: CF Equivalent of JAVA code.

2010-01-29 Thread DURETTE, STEVEN J (ATTASIAIT)
At the risk of making several assumptions > > if(getmetadata(wb).name == 'XSSFWorkbook') file += "x"; > > ~Brad > > Original Message ---- > Subject: CF Equivalent of JAVA code. > From: "DURETTE, STEVEN J (ATTASIAIT)" > Date: Fri,

RE: CF Equivalent of JAVA code.

2010-01-29 Thread DURETTE, STEVEN J (ATTASIAIT)
riday, January 29, 2010 2:27 PM To: cf-talk Subject: RE: CF Equivalent of JAVA code. At the risk of making several assumptions if(getmetadata(wb).name == 'XSSFWorkbook') file += "x"; ~Brad Original Message Subject: CF Equivalent of JAVA code. From: &quo

CF Equivalent of JAVA code.

2010-01-29 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi All, I'm trying to do some work and I have some java examples. For the most part I can easily convert to CF, but I'm not sure how to convert this: If(wb instanceof XSSFWorkbook) file += "x"; I don't know how to check if wb is an instance of XSSFWorkbook. Wb could be XSSFWorkbook o

RE: CF9 cfquery not giving same insert results as CF7

2010-01-29 Thread DURETTE, STEVEN J (ATTASIAIT)
I don't know what CF9 is doing under the hood. What I do is put all the queries in stored procedures. At the beginning of the procedure I always put SET NOCOUNT ON and I always end with SET NOCOUNT OFF. If you have a procedure that is doing a lot of stuff it can reduce a lot of back and forth an

RE: CF9 cfquery not giving same insert results as CF7

2010-01-29 Thread DURETTE, STEVEN J (ATTASIAIT)
Use SCOPE_IDENTITY(). @@Identity returns the id for the last record inserted. If an another insert into that table occurs between your insert and the select @@identity (2 different people making inserts into the db for example) you will get the id for the other record that was inserted. Scope id

RE: Using POI and ColdFusion to output to browser instead of file.

2010-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
All, Nevermind, I was able to figure it out myself. Took creating a java object. Thanks though. Steve From: DURETTE, STEVEN J (ATTASIAIT) Sent: Thursday, January 28, 2010 1:34 PM To: cf-talk Subject: Using POI and ColdFusion to output to browser instead of file. Hi all

Using POI and ColdFusion to output to browser instead of file.

2010-01-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all, I'm trying to use the Apache POI to write an excel file to the browser. I can generate the excel files no problem, but what I want to do is sent the data directly to the browser without hitting the file system at all. Sort of like using cfcontent with html. I want to use cfcontent

RE: (ot) Adobe error messages

2010-01-25 Thread DURETTE, STEVEN J (ATTASIAIT)
I don't know about that... I think it would be a perfect project for Junior Engineers just starting in the group to get into. Gets them deep into the code without having them do anything too complex to begin with! Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com]

RE: (ot) Adobe error messages

2010-01-25 Thread DURETTE, STEVEN J (ATTASIAIT)
LOL! -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, January 25, 2010 2:51 PM To: cf-talk Subject: RE: (ot) Adobe error messages You only get Allaire errors because you code is really sucky. Minor code problems get you Adobe messages. Major code

RE: IIS & ColdFusion Developer, best practices for setting up multiple sites

2010-01-08 Thread DURETTE, STEVEN J (ATTASIAIT)
I believe that you also have to add www.beta.solo.com to IIS. If the site is using host headers (exclusively) and gets one that isn't defined then it throws an error. Steve -Original Message- From: Jeff F [mailto:cftalk_l...@fongemie.com] Sent: Friday, January 08, 2010 10:22 AM To: cf

RE: Server Performance

2009-12-18 Thread DURETTE, STEVEN J (ATTASIAIT)
CFMeetup just had a meeting on "Homebrewed ColdFusion Monitoring" by Wil Genovese. It was an awesome meetup and the recording can be viewed at: http://www.meetup.com/coldfusionmeetup/pages/Recordings_of_the_ColdFusio n_Meetup-2009/ Or at: http://experts.na3.acrobat.com/p34004904/ Also Wil has p

RE: array question

2009-12-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Ben, Do an arraylen on the first row. arrayLen(myVar[1]) That will return the number of columns or planes. Steve -Original Message- From: Ben Conner [mailto:b...@webworldinc.com] Sent: Thursday, December 17, 2009 11:08 AM To: cf-talk Subject: array question Hi, Haven't played muc

RE: Basic user stats via Coldfusion

2009-12-17 Thread DURETTE, STEVEN J (ATTASIAIT)
ated? Any ideas why this may be the case? Ian -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: 15 December 2009 16:54 To: cf-talk Subject: RE: Basic user stats via Coldfusion Ian, This sounds like you should be looking at the webserver logs. If yo

RE: Two Column Select Box?

2009-12-16 Thread DURETTE, STEVEN J (ATTASIAIT)
Search through the data to get the largest length for the item in the first column. Then when you are doing your loop, do Then output #Variables.myTempFirstCol#|#Variables.mySecondCol# Since the first column will now be a fixed length everything should line up. Steve -Original Message--

RE: CF MX 6.1 - zipping files

2009-12-16 Thread DURETTE, STEVEN J (ATTASIAIT)
If CF is on a Windows box and you have access to cfexecute, Windows servers come with a built in command line version of Zip. If you can get to a command prompt just type zip /? And you should get the available commands. Then cfexecute what you need to. Steve -Original Message- From:

RE: copy from table to table

2009-12-15 Thread DURETTE, STEVEN J (ATTASIAIT)
Chad, Tedious or not it is considered by many as a best practice to name your columns. Select * is the bane of my existence many times. Steve -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, December 15, 2009 11:55 AM To: cf-talk Subject: copy from table

RE: Basic user stats via Coldfusion

2009-12-15 Thread DURETTE, STEVEN J (ATTASIAIT)
Ian, This sounds like you should be looking at the webserver logs. If you are using IIS, you can have it log the Windows Login info in the IIS logs. I don't know if Apache can or not. Then you can use something like LOG Parser from Microsoft to search the log files just like you would with a d

RE: Long Running Processes in ColdFusion

2009-12-10 Thread DURETTE, STEVEN J (ATTASIAIT)
My .02... If what is happening is being done on the database backend anyway, then do the heavy lifting in the DB. That's what they are there for. You could have CF kick something off on the DB that does something like schedule a procedure to kick off in 30 seconds, then return a status code for

RE: convert this cfscript back to tag?

2009-12-10 Thread DURETTE, STEVEN J (ATTASIAIT)
I think that's right... -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Thursday, December 10, 2009 9:43 AM To: cf-talk Subject: convert this cfscript back to tag? Hi all, could someone convert this cfscript back to tag?

Strange Page missed error.

2009-11-16 Thread DURETTE, STEVEN J (ATTASIAIT)
All, I'm having some cfform weirdness. Occasionally, a user submits a cfform (flash form) and the following page miss error gets emailed to me: E:\JRun4\servers\NOTFORU2C\cfusion.ear\cfusion.war\CFIDE\scriptscfformhi story.cfm I see that the problem is a missing \ between scripts and c

RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)
Well, Time for me to climb back down into the hole and hide my head! :) -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, November 13, 2009 3:37 PM To: cf-talk Subject: Re: JPG in Database - Retrieve for web page > That gives an error that my data must be bin

RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)
You may have to do toBinary(toBase64(yourVariable)) -Original Message- From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] Sent: Friday, November 13, 2009 3:25 PM To: cf-talk Subject: Re: JPG in Database - Retrieve for web page That gives an error that my data must be binary o

RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)
toBinary() ? -Original Message- From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] Sent: Friday, November 13, 2009 3:25 PM To: cf-talk Subject: Re: JPG in Database - Retrieve for web page That gives an error that my data must be binary on the cfcontent. Any other thoughts?

RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)
I don't fully remember but I believe that you have to wrap the data in toBase64() -Original Message- From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] Sent: Friday, November 13, 2009 3:20 PM To: cf-talk Subject: Re: JPG in Database - Retrieve for web page Thanks for the head

RE: (ot) SQL Question - flattening data

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)
Actually, if MSSQL 2005+ is being used, PIVOT might come in handy here. I had a procedure that used cursors. It ran for 2 minutes. I converted it to use PIVOT instead and I get the same results in 2 seconds! Steve -Original Message- From: Dave Phelan [mailto:dphe...@lifepoint.com] Se

RE: Better manage bulk update process

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)
I'd say no. The end time is only if you want the job to run between certain hours. For example I have a job that runs every 5 minutes between 8am and 4pm. Steve -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Friday, November 13, 2009 12:58 PM To: cf-talk Subj

Session is invalid error is driving me nuts!

2009-11-04 Thread DURETTE, STEVEN J (ATTASIAIT)
All, Ok, this is a little pet peeve of mine. We have session timeout set and we tell users that they have to do something within so much time. Problem is the users ignore that. They open a page with a form, leave it open for an hour, then when they submit the form Session is invalid erro

RE: Form Insanity

2009-11-04 Thread DURETTE, STEVEN J (ATTASIAIT)
Quick and dirty fix... In the processing page, add this to the top: Steve -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Wednesday, November 04, 2009 1:16 PM To: cf-talk Subject: RE: Form Insanity With radio buttons, checkboxes, and multiple select d

RE: Clear Fields In Firefox

2009-11-04 Thread DURETTE, STEVEN J (ATTASIAIT)
One reason could be Corporate policy. I know one company for sure that will not be named that has a policy that states that user id and password fields will be blank. Even though they lock down the browser not to auto populate, some people could still get past it. Then for some reason, the powe

RE: CFForms don't display... Help!

2009-11-02 Thread DURETTE, STEVEN J (ATTASIAIT)
I found the problem. Permissions. Permissions. Permissions! -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Monday, November 02, 2009 11:03 AM To: cf-talk Subject: CFForms don't display... Help! All, We moved from a CF7 server to a CF8 server this weekend. No

CFForms don't display... Help!

2009-11-02 Thread DURETTE, STEVEN J (ATTASIAIT)
All, We moved from a CF7 server to a CF8 server this weekend. Now the flash forms will not display. When I hit the pages I get an error: object expected Line: (what ever line for that page) When I choose to debug I get this:

RE: List sort problem... My brain isn't working today.

2009-10-29 Thread DURETTE, STEVEN J (ATTASIAIT)
Dave, Thanks, we can always count on you. I actually came up with another way as well. What you did inspired me. The numbers range from 6 down to 1. I made a copy of the string and replaced the 6 with A, 5 with B, etc. Then I can sort it ascending and not worry about it. After its sorted th

List sort problem... My brain isn't working today.

2009-10-29 Thread DURETTE, STEVEN J (ATTASIAIT)
All, I have a strange situation. I have to sort a list twice. First by a number, descending, then by text ascending. I know sounds strange but here is an example. Original list (example only real info stripped out): 2-CCC|2-AAA|2-DDD|5-ZZZ First it has to be sorted by the number, s

RE: SQL Join help needed

2009-10-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Daniel, Try this: SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid ,a.student_id ,a.people_id ,coalesce(b.fname, c.fname) fname ,coalesce(b.lname, c.lname) lname ,coalesce(b

RE: SQL Join help needed

2009-10-28 Thread DURETTE, STEVEN J (ATTASIAIT)
Daniel, You didn't post a link to the data. Steve -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: Wednesday, October 28, 2009 8:47 AM To: cf-talk Subject: Re: SQL Join help needed >OPPS... > >Change the on a.student_id = d.student_id to on a.passport_listing_i

RE: SQL Join help needed

2009-10-27 Thread DURETTE, STEVEN J (ATTASIAIT)
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id Steve -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Tuesday, October 27, 2009 3:11 PM To: cf-talk Subject: RE: SQL Join help needed Sorry about that... Try this

RE: SQL Join help needed

2009-10-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Sorry about that... Try this... SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid ,a.student_id ,a.people_id ,coalesce(b.fname, c.f

RE: SQL Join help needed

2009-10-27 Thread DURETTE, STEVEN J (ATTASIAIT)
If it's a version newer than oracle 8 I believe it can use either notation but the newer form is suggested. I don't remember which version they added this notation. I believe it falls under the SQL92 standards. Steve -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Se

RE: SQL Join help needed

2009-10-27 Thread DURETTE, STEVEN J (ATTASIAIT)
This code isn't using inner/outer join notation, but the old style. Is there a reason for this? I would change the code to this: SELECT a.passport_listing_id ,a.passport_registration_id ,a.email_sent_attendance ,a.s_uid

RE: Getting last inserted record from database

2009-10-27 Thread DURETTE, STEVEN J (ATTASIAIT)
Problem with that is when you are dealing with timing in less than a second that can go wrong... For example assume before you start an insert the max_id = 1. Then 2 people go to make an insert at the same time... Insert A - max_id increments to 2. Insert B - max_id increments to 3 (this inser

RE: Checking line 26 or 27

2009-10-21 Thread DURETTE, STEVEN J (ATTASIAIT)
Yes, that is why my code set invoice = "". Then set invoicenumber = line 26. Go to line 27 if invoicenumber has a length then continue on, if not set the invoice number to the value on line 27. Ok, so my code didn't work... Is something else changing invoice number? Can I see the whole loop. I

RE: Checking line 26 or 27

2009-10-21 Thread DURETTE, STEVEN J (ATTASIAIT)
Wow... I just re-read what I wrote. I sounded like a jerk didn't I. Sorry about that didn't mean it that way. -Original Message----- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Wednesday, October 21, 2009 11:15 AM To: cf-talk Subject: RE: Checking line 26 or 27 I think the logic i

RE: Checking line 26 or 27

2009-10-21 Thread DURETTE, STEVEN J (ATTASIAIT)
I think the logic is a little off. You only need either line 26 or line 27. That will set invoice number to the value in either 26 or 27 (I assumed this was in a loop). Having a bigger section of code would have helped more. Also, there is probably a cleaner way to do t

RE: Ok...I give...what's wrong with this code?

2009-10-20 Thread DURETTE, STEVEN J (ATTASIAIT)
imagesW200 is a query result. I believe you have to use imagesW200.name to reference the actual name. -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Tuesday, October 20, 2009 2:03 PM To: cf-talk Subject: Ok...I give...what's wrong with this code? I'm g

RE: display wingding character code

2009-10-16 Thread DURETTE, STEVEN J (ATTASIAIT)
#chr(252)# Don't know how it will display if the computer doesn't have the wingdings font though. Steve -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: Friday, October 16, 2009 1:47 PM To: cf-talk Subject: Re: display wingding character code is there no way

RE: cfprocparam - null setting

2009-10-15 Thread DURETTE, STEVEN J (ATTASIAIT)
ore readable than NOT len(), but the result is the same. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/15 DURETTE, STEVEN J (ATTASIAIT) : > > You can only pass in things that resolve to true/false, zero/one, > yes/no, etc. > > Using not

RE: cfprocparam - null setting

2009-10-15 Thread DURETTE, STEVEN J (ATTASIAIT)
AM To: cf-talk Subject: RE: cfprocparam - null setting Can you pass anything other than true/false to the null parameter in cfprocparam? I know you can in cfqueryparam, but I was under the impression than in cfprocparam it's strictly true/false -Original Message- From: DURETTE, STE

RE: cfprocparam - null setting

2009-10-15 Thread DURETTE, STEVEN J (ATTASIAIT)
put TRUE in the NULL and pass a null to the procedure. I do this all the time to ensure that the proper values get to my procedures. Steve -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) Sent: Thursday, October 15, 2009 8:59 AM To: cf-talk Subject: RE: cfprocparam - null setting

RE: cfprocparam - null setting

2009-10-15 Thread DURETTE, STEVEN J (ATTASIAIT)
Actually, I think you can solve this problem easily. If the only two bad options are zero and "" then try this... Of course replace Variables.myPassIn with whatever your variable is. Steve -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Thurs

<    1   2   3   >