(ot) Need Oracle Service_Name but have SID

2012-02-17 Thread Steven Durette
Hi all, I have a bit of a dilema, I need to connect to an oracle database, but I can't use a TNSNames file. However when I asked for the connection info they gave me a tnsnames.ora file and told me to figure it out from there. In the tnsnames file is a SID. However the software I am trying to

(ot) ColdFusion Builder serial number not being accepted.

2012-02-04 Thread Steven Durette
Hi all, Sorry for the OT but I don't know who to contact. I have a student edition of ColdFusion Builder 2 and it was installed on my laptop, but that laptop died. Now when I try to install on my replacement laptop, it tells me the serial number is invalid when I try to install CF Builder 2.

New computer set up

2012-02-04 Thread Steven Durette
Thanks for the idea, but I am a student and this is a freeriatools.adobe.com installation (yes I am still a full time student). So no online account. I still have the original email from adobe that I installed it with before. I have the feeling it is one of those things that you have to remove

New computer set up

2012-01-17 Thread Steven Durette
Hi all, Just wondering what all of the guru's here install when they get a new laptop. Its a windows based machine, but will probably be dual booting a form of Linux before the end of the week. Steve ~| Order the Adobe

Re: Problem with pound signs

2011-06-27 Thread Steven Durette
I tried it out. It works sort-of. It only lists the first time the single pound sign happened. While this identifies the file you have to rescan just to find the next error. Someone else mentioned that manually fixing would be boring and tedious. I agree with that but when one programmer

Re: Problem with pound signs

2011-06-27 Thread Steven Durette
Yeah but for us that involved getting another group involved and lots of programmer down-time. Sent from my iPhone On Jun 27, 2011, at 1:45 PM, Dave Watts dwa...@figleaf.com wrote: Someone else mentioned that manually fixing would be boring and tedious. I agree with that but when one

RE: Problem with pound signs

2011-06-24 Thread Steven Durette
All these responses are really helping! Ok so here is what I'm going to do so far... I have a CF Application that can search through the code base and find stuff inside of tags or between opening and closing tags, but I have to tell it what tag and give it regex to do the search. I'm breaking

Problem with pound signs

2011-06-23 Thread Steven Durette
Hi all, I've been given some code to fix that others have tried but had little luck. I believe I've found the major culprit, but I want to use regex to find it but I'm a little stumped. The errors are usually one of two things, either single pound signs in between cfoutputs (ie: font tag

Re: scoping

2011-05-19 Thread Steven Durette
You keep saying variables in the local scope. You may want to say the current page because there is a local scope. In functions if you cfset var myvar = something / it is in the local scope and you don't attach a scope to it. I believe in CF 9 they actually added the local scope for this

Re: Coldfusion 9 SQL Server 2008 XML bulkload

2011-05-03 Thread Steven Durette
First SQL has to be running under an account that has access to that directory. Then it is easiest if you make a share, then you reference it as \\sernername\sharename\filename Steve Sent from my iPhone On May 3, 2011, at 12:48 AM, Kam Heydari heyda...@yahoo.com wrote: Hi, Anyone know

Re: Problem Using QueryNew

2011-04-23 Thread Steven Durette
Varchar(max) was added to mssql 2005 2000 has a limit of Varchar(8060) Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Wordpress.com equivalent

2011-03-25 Thread Steven Durette
Hi all, I was wondering if we have an equivalent to wordpress.com? I'm not talking about codebases like blogcfc or mango blog. I mean an actual site where people can sign up for a free or premium account and just start blogging. Steve Sent from my iPhone

RE: Wordpress.com equivalent

2011-03-25 Thread Steven Durette
I was looking at it more from the point of WordPress was php's *flagship* (for lack of a better word) site and code base that made it really popular (or so I'm told). I was wondering if we have anyone out there working on it or something else like it to make ColdFusion/Railo more popular to the

Re: The vagaries of QueryNew

2011-03-23 Thread Steven Durette
First, let me say that anything that can be done in the database should be. But, if you must do it this way, why don't you have the db return the extra columns as nulls then set the cell values. That way you don't have the extra query object being built. Steve Sent from my iPhone On Mar

Re: customtag not being found

2011-03-13 Thread Steven Durette
You say that you added the mapping, but did you also tell CF that this was a custom tag directory? They are two different things. Steve Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now!

ColdFusion 9 install problem

2011-03-07 Thread Steven Durette
Hi all, I've tried googling this and haven't had any luck. Here is the history. I had cf9 multiserver installed on my test laptop. Then I needed to upgrade from vista 64 to win7 64. So I uninstalled CF and jrun (along with a bunch of other stuff) and did the upgrade. Now when I try to install

Re: ColdFusion 9 install problem

2011-03-07 Thread Steven Durette
Nevermind. I just missed one of the registry entries. Sent from my iPhone On Mar 7, 2011, at 11:08 AM, Steven Durette st...@durette.org wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe

Re: CFImage at 300dpi

2011-02-06 Thread Steven Durette
Has anyone heard anything? Is he ok? Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Coldfusion Code Review Tool

2011-01-11 Thread Steven Durette
I believe codecop is still available on riaforge.org. Sent from my iPhone On Jan 11, 2011, at 5:48 AM, dev losh devl...@gmail.com wrote: Can anyone recommend any good tool that can be used for Coldfusion Code Reviews? I tried Sonar but could'nt find coldfusion plugin for the same.

Re: Bug in CFAdmin?

2010-12-23 Thread Steven Durette
I had an error like this once. I copy and pasted the date to another program (I don't remember which it was a long time ago) and it showed me I had a high character that displayed as a blank. I wiped out the field and re-entered the date. The problem went away. Steve Sent from my iPhone

Re: Bug in CFAdmin?

2010-12-23 Thread Steven Durette
tasks page. I'm not sure where this date comes from or why and it's certainly not based on user input either. Regards, Stefan On 23 Dec 2010, at 14:09, Steven Durette wrote: I had an error like this once. I copy and pasted the date to another program (I don't remember which

Re: CFMail problem since upgrading to CF9

2010-12-10 Thread Steven Durette
Smtp error 421 is the service is not available and the connection will be closed It is from the smtp server not ColdFusion, so you issue is the smtp server. Steve Sent from my iPhone On Dec 10, 2010, at 12:04 PM, Rick Root rick.r...@gmail.com wrote: We've been having significantly more

Re: CFMail problem since upgrading to CF9

2010-12-10 Thread Steven Durette
Actually the CF error is correct. CF tried to connect to the smtp server and all it got back was error 421. So connection couldn't be made. Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now!

Re: custom error message - sometimes cf ignores me and displays the standard error message

2010-12-07 Thread Steven Durette
Nick, Request and validation errors can only use cferror to redirect to HTML files that can include cferror references. Any other cell in those pages will cause your error page to generate an error. Steve Sent from my iPhone On Dec 7, 2010, at 11:24 AM, nick way n...@southeastpublishing.com

Re: custom error message - sometimes cf ignores me and displays the standard error message

2010-12-07 Thread Steven Durette
That should read any other cfml. Sent from my iPhone On Dec 7, 2010, at 11:38 AM, Steven Durette st...@durette.org wrote: Nick, Request and validation errors can only use cferror to redirect to HTML files that can include cferror references. Any other cell in those pages will cause

Re: custom error message - sometimes cf ignores me and displays the standard error message

2010-12-07 Thread Steven Durette
Correct. If you use request or exception error types they cannot use any other cfml. You can see the cferror specs at http://www.cfquickdocs.com/cf8/#cferror Sorry no cfmail with request and validation. Steve ~| Order the

Re: custom error message - sometimes cf ignores me and displays the standard error message

2010-12-07 Thread Steven Durette
Nick, What you have been using for years is exception error reporting. You have just added request and validation to the mix and they have different rules. Nothing has changed, you are just expanding your horizons! :) Steve Sent from my iPhone

Re: CF9/Win7 64 bit issues

2010-12-07 Thread Steven Durette
Not when one of the major fixes is to make it install better with a webserver. Sent from my iPhone On Dec 7, 2010, at 8:54 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I guess that makes sense -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk]

Re: Schedule task more frequent than 1 inute

2010-12-06 Thread Steven Durette
This sounds like you need a directory watcher gateway. I know it is available with CF8 Enterprise but I don't know about other versions. Sent from my iPhone ~| Order the Adobe Coldfusion Anthology now!

Re: CF9/Win7 64 bit issues

2010-12-06 Thread Steven Durette
Really? I thought if you got the latest download from Adobe that it was v9.0.1 Sent from my iPhone On Dec 6, 2010, at 6:33 PM, Russ Michaels r...@michaels.me.uk wrote: Which may confuse people seeing as you have to install cf9 first then cf9.0.1, so you cannot install CF to IIS during the

ColdFusion Mailing list

2008-04-09 Thread Steven Durette
All, I am in search of a prebuilt mailing list application. Here are the requirements. * Announce only type of emails (only one or two people can send to the list). * 400 or fewer recepients (probably less than 200). * Has to be ColdFusion (I can't install software because it's a hosted site).

Re: ColdFusion 7.0 Tags and Functions Poster

2007-02-22 Thread Steven Durette
I think he's talking about the big blue and white one from Adobe, not the TeraTech version. I don't know where to get one, I got mine at CFUnited 06. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 2:04 PM To: CF-Talk

OT: Breeze Presentation problem

2006-06-19 Thread Steven Durette
Hi all, I'm trying to view a saved breeze presentation (http://adobe.breezecentral.com/p15449246 Setting up Coldfusion, Apache, mySql on Linux). The presentation seems to work, but I've found a couple of problems. First, the sound is out of sync with what is displayed on the screen. This

Where does everyone blog?

2006-06-17 Thread Steven Durette
I know this comes up in the list every once in a while, but the search isn't giving me really great results. What I want to know is where everone blogs at. Do most of you blog on your own site, or use a centralized site to blog. I'm thinking of starting up a blog and I want to know where

Homesite and Dreamweaver tag defs for 7.0.1

2005-10-06 Thread Steven Durette
Hi All, Does anyone know if or when updaters with the new tag information will be available for the updates in 7.0.1 that we can add to Dreamweaver MX 2004 and Homesite 5.5+ ? Thanks, Steve Durette ~| Discover CFTicket - The

Re: Passing List into Stored Proc

2004-01-27 Thread Steven Durette
Hello John, Tuesday, January 27, 2004, 6:55:52 AM, you wrote: Jm DELETE Jm FROM DBO.a Jm WHERE DBO.a.FOLDERNAME IN ('jim','ben','tom') Jm AND DBO.a.CUSTOMERID = 1 John, Are you making sure that the @folderlist items are separated by commas and each item is surrounded by ' ? Steve

JRun with ColdFusion

2004-01-24 Thread Steven Durette
Hi all, I have a question about the JRun that is installed with ColdFusion Enterprise (second install option). Do I have to install Macromedia's JRun updaters or are they already added in? Would future patches show up in the ColdFusion Support or JRun support? (I mean, I didn't purchase JRun,

Re:CFMX61 on JRun4, JVM (multiple sort of related questions)

2004-01-20 Thread Steven Durette
Opps, I forgot to add: Win2K Server IIS 5 CFMX 6.1 Enterprise (currently at CFMX Enterprise) The JVM we have to go to is Sun 1.4.2_01 Nothing else running on the box. Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: SQL formatting question

2004-01-06 Thread Steven Durette
Eric, Tuesday, January 6, 2004, 7:03:36 PM, you wrote: EC I have a table with column of phone numbers. The phone EC numbers have been entered in a number of different formats some EC containing . or - or /. Some with area codes with (). What I want EC to do is get them all the same. Now I can

Re[2]: Two Selects

2003-12-31 Thread Steven Durette
You might also want to check out a tutorial I wrote for easycfm.com It deals with homegrown multiple selects related that can be used multiple times within a form. The article can be found at http://tutorial196.easycfm.com There is also an example at

Re[5]: Two Selects

2003-12-31 Thread Steven Durette
All, I have just tested the Multi Selects Related demo for the tutorial on the following browsers: IE 6.0.2800.106.xpsp2.030422-1633 Opera 7.23 Mozilla 1.5.0.2003100716 Mozilla Firebird 0.7 Netscape 7.1 MyIE2 0.9.12 And it passed all of them with flying colors.Are there any other major browsers

Re: evaluate

2003-10-11 Thread Steven Durette
The major difference is that attributes.query is set to caller.[insert query name here] And that's how this works.The custom tag has worked for years, I just wanted to get rid of the evaluates. Thanks for the info though Steve - Original Message - From: Jim Davis To: CF-Talk Sent:

Re: evaluate

2003-10-11 Thread Steven Durette
The String of the name of the query. - Original Message - From: Jim Davis To: CF-Talk Sent: Saturday, October 11, 2003 1:38 PM Subject: RE: evaluate But is it being set to the string of the name or the query itself? That's the key. Jim Davis -Original Message- From: Steven

CFLOCK and CFFILE

2003-05-29 Thread Steven Durette
Hi all, It has been suggested to me to use CFLocks around my cffile write and cffile appends. This is to prevent file errors that we have been having lately where the append tries to start before the original write is complete. What would the syntax for this cflock be? I know that I would

RDS on CFMX

2003-02-25 Thread Steven Durette
Hi All, Does anyone here know why RDS might suddenly stop working on a CFMX server? It was working fine until a couple of days ago and then it just suddenly stopped. We are using the Enterprise edition of CFMX on a Win2K server with IIS. We are not using advanced security. Also, I have

cfmx and jre problem with cfgrid (not the standard problem).

2003-01-08 Thread Steven Durette
Hi all, I am having a problem with CFMX and CFGRID, every time a user browses to the cfgrid they have to download 1.3 They browse away and come back, they have to download again. Has anyone else had this problem and if so, how was it fixed. Also, I have been trying to find the answer on

Re: MX Server installs and Microsoft Security Toolkits

2002-12-05 Thread Steven Durette
There's plenty of documentation out there on all these topics, also. Unfortunately, it's not all in one place, really; CF information is provided by Macromedia, IIS information by Microsoft, general web application security information by others, and so on. Fig Leaf Software offers a one-day

Re: Code Summary: Recursive File Delete

2002-12-03 Thread Steven Durette
Just a quick note. I do just this sort of thing to deal with temporary files. It is scheduled to run every two hours. One problem that we came across is if the file is being used. We ended up adding a cftry..cfcatch setup to ensure that if one file was being used, the cf page would continue

cfscript equivalent for cfloop?

2002-11-21 Thread Steven Durette
Is there an equivalent of to be used with cfscript? I have code similar to this: lt;cfloop query=#34;myQuery#34;gt; lt;cfif myQuery.myColName IS 1gt; lt;cfset myVar = 1gt; lt;/cfifgt; lt;/cfloopgt; This loop is surrounded on both sides by cfscript blocks and I would like to

Cfloop equivalent in cfscript?

2002-11-21 Thread Steven Durette
Didn't see this hit the list, so I thought that I would try again. Is there an equivalent of to be used with cfscript? I have code similar to this: cfloop query=myQuery cfif myQuery.myColName IS 1 cfset myVar = 1 /cfif /cfloop This loop is surrounded on both sides by

Re: CFFILE WRITE TO EXCEL SHEET

2002-10-31 Thread Steven Durette
Jamie, If this is to be text, make sure that the field has a ' in front of the field. That's how excel deals with numbers that need to be text. Steve Durette - Original Message - From: JAIME HOI [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 2:54 AM

Dreamweaver Keyboard mapping (cf studio user forced to convert!)

2002-10-31 Thread Steven Durette
Can any one tell me if there is a way to get the ctrl-m functionality from Studio to work in Dreamweaver. Many times I have to work through other peoples cfcode and the ability to jump to the end tag for the current tag is extremely helpful. Thanks Steve Durette

Re: Screwy Excel Query Result

2002-10-28 Thread Steven Durette
Ian, I have seen this behavior before. It seems that sometimes when you use excel even if you declare a field text and you then enter a number into it excel will convert it to a number instead! Before I get flamed stating that this doesn't happen, it has happened to me. The easiest way to fix

Re: HTML to PDF

2002-03-27 Thread Steven Durette
How about the HTML2PDF3 tag in the devexchange? It uses htmldoc to create the pdf files. HtmlDoc was recently made opensource and therefor free. A compiled version of HtmlDoc is included in the tag download. Steve - Original Message - From: Michael Vinson [EMAIL PROTECTED] To: CF-Talk

Re: Calculations in Query?

2002-02-17 Thread Steven Durette
Ann, This might not have worked if you have any zeros in the D_Goal column. This would work for SQL Server, and should work for Access, but I'm not sure. SELECT D_ID, D_Name, (CASE D_Goal WHERE 0 THEN 0 ELSE D_Loss/D_Goal*100) as MyValue FROM diet Steve - Original Message -

CFStoredProc vs CFQUERY

2002-01-21 Thread Steven Durette
I was just wondering if any one knew the difference between the following: CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO dbVarName = @param2 CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE = BAR dbVarName

CFStoredProc vs CFQUERY

2002-01-21 Thread Steven Durette
I was just wondering if any one knew the difference between the following: CFSTOREDPROC PROCEDURE=usp_myproc DATASOURCE=mydatasource CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_DATE VARIABLE = FOO dbVarName = @param2 CFPROCPARAM TYPE=IN CFSQLTYPE = CF_SQL_INTERGER VARIABLE = BAR dbVarName

CFAPPLICATION question.

2002-01-21 Thread Steven Durette
Can answer this for me? Will users in a sub-application keep the outer application from timing out? Here is an example: I have a CF application that user log into an then have the option to log into a sub application. The sub application is actually in a subdirectory off of the main

Re: CFAPPLICATION question.

2002-01-21 Thread Steven Durette
an application scope altogether (becaus e there is no cfappplication running). At least that is how I understand it. Someone else could perhaps shed a bit more light. mark -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 5:43 PM To: CF

Re: CFStoredProc vs CFQUERY

2002-01-21 Thread Steven Durette
, you can have multiple recordsets returned, and have access to the Stored Procedures return value. You can't do that with CFQuery. Shawn Grover -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 6:15 PM To: CF-Talk Subject: CFStoredProc

Re: PRINTING-SOME WORDS DROP

2001-11-03 Thread Steven Durette
I had somewhat the same problem with a few sites that I had. The resolution (which might not work for you.) was to change the color of the font. The variables were color coded for emphasis on the displayed page and the printers that the user had was seeing the light color I used as white. I

Re: Newbie Syntax Help

2001-09-09 Thread Steven Durette
(prevents errors) and the change to the CFQUERY means that it doesn't have to evaluate 3 CFIFs. If for some strange reason you can't do this, then to correct your original code, change CFIF request = to CFIF request IS Steven Durette MGR. - Engineering Construction System Support Database

Re: cfquery Question

2001-09-08 Thread Steven Durette
What your looking for is: CFQUERY Name=myTables Datasource=yourDataSource SELECT * FROM sysobjects WHERE xtype = 'U' /CFQUERY Type U is user tables and S is system tables. There are others, but I'm not sure what they are. Steven Durette MGR. - Engineering Construction System Support Database

Re: DateAdd Strangeness? (Or is it me?) --it's you!!

2001-07-28 Thread Steven Durette
Don't forget, some fiscal years start and end in February. Therefore, fiscal 1Q 2001 would be Feb-Apr. - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 2:46 PM Subject: RE: DateAdd Strangeness? (Or is it me?) --it's you!!