Iif and CF 7vs. CF 8

2007-11-06 Thread Lincoln Milner
Hello, all, I have this code snippet below which runs fine on my local workstation (Windows XP, CF 8 IIS 5.1). When I throw it up on our dev server (Windows 2k3, IIS 6, CF 7) I get an index out of bounds error on the second IIF line below. I've looked at the docs and I don't see why this code

RE: Help- send mail problem

2007-04-17 Thread Lincoln Milner
Something similar to this has happened to us a few times. What we've seen is when the Exchange server no longer accepts your CF server as a mail relay. If Exchange is set up to only allow mail from trusted relays, and your server isn't on that list, it'll refuse the email. We've had that list

RE: querying a date/time field

2007-03-07 Thread Lincoln Milner
I think comparing as an ODBC Datetime variable (using the CreateODBCDateTime() function) should work. That way you know you're comparing apples to apples. I've done that a few times when I have fits with different date formats. -Original Message- From: Orlini, Robert [mailto:[EMAIL

RE: Server help - coldfusion services stop responding

2007-02-23 Thread Lincoln Milner
When I've seen this behavior on our servers, I get on a terminal connection and run cfstat. That usually shows a large number of queued requests and a handful (10 on our systems) that are hanging. If your boxes are robust enough, you can bump up simultaneous requests and see if that clears the

RE: Validate Password

2007-02-08 Thread Lincoln Milner
We have started that per policies at our institution. We never store plain passwords, though. We store passwords and a password history as MD5 hashes, then just do a quick MD5() on what they entered and what they have in the DB. We also have all the same restrictions you've listed (3 types of

RE: Was the Sean Corfield thread deleted from the archives?

2006-12-01 Thread Lincoln Milner
It's a conspiracy! Maybe Dr. Jonas moved the thread to CF-OT... Now where's that copy of The Catcher in the Rye at? *grin* -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Friday, December 01, 2006 10:43 AM To: CF-Talk Subject: Was the Sean Corfield thread deleted

RE: Sean Corfield, it's time to approve my post

2006-11-30 Thread Lincoln Milner
I think Sean was pretty fair in his assessment. You are discounting the enormous power a user base can have on a product, or a company. You are correct in your statement that Chizen does have a primary financial responsibility to the stockholders. But how does he meet that obligation?

RE: MySQL Front

2006-09-18 Thread Lincoln Milner
Two, depending on what you need. The MySQL Administrator is good for administration (imagine that) and is free from MySQL AB. SQLYog was recently released as open-source (some advanced functionality available in a commercial version), so it is free as well. Most of my work I do in SQLYog, with

RE: Development Environment Setup

2006-08-09 Thread Lincoln Milner
We're currently switching our model. Current old way of doing it is to develop locally with Apache and CF to a MySQL or Oracle DB. Then push changes to QA for review. Developers use SVN to maintain code repositories for version/history. Once QA is passed, changes FTPed to production. No

RE: Coldfusion with Godaddy

2006-05-05 Thread Lincoln Milner
I recently switched to GoDaddy (since I wanted CF hosting on limited budget). BlogCFC doesn't run out of the box, but I was inspiried to add some code to switch the createObjects to cfinvoke calls (only added init calls to some functions). That and skip over the localization (since I couldn't

RE: invoking components in sibling folders

2006-04-26 Thread Lincoln Milner
Yes, it is possible, I do it. A few things I've noted: 1. Maybe just a typo, but make sure your root folder (components) matches your root folder in the invoke (currently component) 2. If components is in the web root, then it should work. If it isn't, then you have two options a.

RE: CFUNITED CD

2005-07-14 Thread Lincoln Milner
According to their homepage, a little under the link to Check out the latest news... Blogs and more... is the following: Items that will be posted soon: Photos Updated presentations Blogs Next year's event and more Hang tight, I'm sure Michael, et al. will hook us up soon! -Original

Sorting QofQ in ORDER BY

2005-07-13 Thread Lincoln Milner
I've got a QofQ that I want to order on a character field. Only the field contains only numbers (don't ask), and the user wants it sorted as if they were numbers (1, 2, 3, ...) not strings (1, 10, 11, 2, 3, ...). Simple enough in database (Oracle in this case) since you can just TO_NUMBER() the

RE: Sorting QofQ in ORDER BY - RESOLVED

2005-07-13 Thread Lincoln Milner
. You might need an additional query of queries to accomplish that. For more info, see http://livedocs.macromedia.com/ coldfusion/7/htmldocs/1271.htm Jon On 7/13/05, Lincoln Milner [EMAIL PROTECTED] wrote: I've got a QofQ that I want to order on a character field. Only the field contains only

RE: Huge dropdown list of names...type in name as well as selecting it???

2004-05-13 Thread Lincoln Milner
Here's what we did to help narrow down a search for a large select box.When you type in the text field, it actually eliminates selections based on pattern matching the string in the text box with the names in the select.(NOTE: This is from a colleague of mine.I modified it for my use to only match

RE: [OT] MySQL is really free?

2004-04-21 Thread Lincoln Milner
According to MySQL (because I contacted them with a similar question): Free use for those who never copy, modify or distribute. As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether

RE: Bug? Problem with Oracle Stored Procedure

2004-02-14 Thread Lincoln Milner
I by no means am an expert in Oracle/CF storedproc calls, but my guess is that Oracle is looking for some kind of input for the IN/OUT parameter, and if you don't pass something in, then it yells. Why do you have an IN/OUT parameter defined if CF is only ever looking to get something out?My

RE: Securing word docs, excel, etc in a web app

2003-08-26 Thread Lincoln Milner
Grif, What we've done for a similar system is to have the CFFILE tag write them to a directory outside the webroot. In our case, we have /local/web for the web root, and /local/web_docs for the documents to be stored. We have links for each document, and the path to those documents is stored

RE: Timeformat incorrect

2003-08-26 Thread Lincoln Milner
If you didn't set the time in the date field, i.e., if it was user entered as 12/23/2002, then no time is available and doing a timeformat results in what you've seen. SYSDATE and a couple other Oracle functions (which I can't think of) to store full timestamps in a date column, whether you

SOT: CF and Flash MX Forms

2003-06-06 Thread Lincoln Milner
I'm looking for some resources, articles, whitepapers, etc. on Flash MX Forms. Basically we're using Oracle Forms right now for our web applications, but we're considering a complete re-design of the whole app. I've heard some good things about Flash forms, but need something somewhat

RE: CF 5 Oracle Best Pactices

2003-03-24 Thread Lincoln Milner
Well, from an Oracle standpoint, 8.1.7 is the only RDBMS that is still supported by Oracle (except under their extended contracts). 9i offers some good things with administration tasks, but, if you're interested in an 8x solution, my vote would be 8.1.7. As far as native vs. OBDC, I would use

RE: Apache 2.0.44 and CFMX Server HELP!!

2003-03-12 Thread Lincoln Milner
Do you have Updater 2 installed? You need that to work with the newer versions (i.e., after 2.0.40) of Apache... -lincoln -Original Message- From: Juan Nava [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 3:11 PM To: CF-Talk Subject: Apache 2.0.44 and CFMX Server HELP!!

RE: Apache 2.0.44 and CFMX Server HELP!!

2003-03-12 Thread Lincoln Milner
it. --- Lincoln Milner [EMAIL PROTECTED] wrote: Do you have Updater 2 installed? You need that to work with the newer versions (i.e., after 2.0.40) of Apache... -lincoln -Original Message- From: Juan Nava [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 3:11 PM To: CF

Auto-populating form item

2003-03-07 Thread Lincoln Milner
Folks, We've got this data entry form that allows entry, query, record deletion, and a host of other functionality. One thing it needs to do is after the first three form items are completed (it's a subject id.t number), the fourth auto-populates with the subject initials. This should be

RE: CF and Oracle 9i...

2003-03-06 Thread Lincoln Milner
Native drivers, unless I am way off base, are the SQL*Net drivers. If you have the SQL*Net client installed on a machine, and install CF, SQL*Net is what it's looking for. ODBC is a different way of connecting to databases, but since CF provides the ability to use native drivers (drivers from

RE: CFMX Oracle native DSN issues

2003-02-12 Thread Lincoln Milner
This may be a stupid question, but does the user that is running CF has the ability to read that file? If not, it'll not work at all. For the client, if you put tnsnames.ora in a non-standard place (outside $ORACLE_HOME/network/admin), you'll need to tell the SQL*Net client where to find it.

RE: cfoutput + cfloop: bug or

2003-02-11 Thread Lincoln Milner
I wouls assume that the second query has more than one row returned, therefore it will iterate through each loop of the cfloop until it reaches the end of the query results. Then it will return to the cfquery tag, iterate to the next query1 result, then go and loop through query2 completely

RE: end.cfm?

2003-02-11 Thread Lincoln Milner
Case counts, Tony. OnRequestEnd.cfm Shame on you...*grin* -lincoln -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 3:26 PM To: CF-Talk Subject: RE: end.cfm? onrequestend.cfm ...tony Tony Weeg Senior Web Developer UnCertified Advanced

RE: end.cfm?

2003-02-11 Thread Lincoln Milner
Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 3:40 PM To: CF-Talk Subject: RE: end.cfm? Does case count for application.cfm too? Or is that just for *nix systems? -Original Message- From: Lincoln Milner [mailto:[EMAIL PROTECTED]] Sent

RE: DB Strategy

2003-02-05 Thread Lincoln Milner
I should like to put my 2ยข in here, since I've often heard the term database to be used inappropriately in conversation, even by those persons working in the field. In Oracle, you have one Oracle database, typically. Within this database, you have one or more instances that live wholly on

RE: Oracle and CF5

2003-01-28 Thread Lincoln Milner
The Administrator just verifies it can connect to the datasource. It's not until you actually try querying something that the user tries to access any schema. So, if your CF user only has (I think) CREATE SESSION privileges, it can connect to Oracle, but without permission to schema objects,

RE: OT: MM Suprises Wall Street - Can more be done?

2003-01-24 Thread Lincoln Milner
I would be cautious with the advice for developers to become multi-skilled. In a perfect world, I would be able to do a task in PHP, Perl, CF, ASP or Java, but in the real world my head would explode knowing everything there is to know about that. Plus you stretch yourself too thin if you try

RE: What does U2 actually update?

2002-12-13 Thread Lincoln Milner
Not to continue this inane thread any longer, no one is being a jerk. If you want to know what has been updated by a software patch, you read the release notes. That is a much more definitive and accurate accounting of what has been fixed than 100 users saying COM objects work, and 20 more

RE: Can't Reach the Updater 2

2002-12-13 Thread Lincoln Milner
That's U2 (not the band, the CFMX file...) -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 11:51 AM To: CF-Talk Subject: RE: Can't Reach the Updater 2 OKgot sick of the cookie bull. Here's the address of the actual download (I

RE: PostgreSQL Sloooooow!

2002-11-21 Thread Lincoln Milner
Jillian, I would say that it's trying to create a pseudo-Cartesian product. That's a fancy way of saying you didn't join your tables in your where clause. The rule of thumb when selecting from multiple tables is that you need at least n-1 table joins, where n = the number of tables you're

RE: PostgreSQL Sloooooow! - Slightly OT

2002-11-21 Thread Lincoln Milner
If you're thinking of bailing on MySQL for another product because of transactions, foreign keys, or something, have a look at MySQL's included InnoDB implementation. From what I read (haven't put it into practice yet), it creates a tablespace where you can do those things regular MySQL can't.

RE: SQL vs PL/SQL

2002-11-14 Thread Lincoln Milner
If it is SQL in ColdFusion, don't worry. An understanding of SELECT, INSERT, UPDATE, etc. will serve you well. If you have to program a complex report mining data out of Oracle and published via the PL/SQL web toolkit over the WWW, may Fate smile upon you. Your best bet is to search for

RE: webConference software

2002-11-12 Thread Lincoln Milner
Netopia has (or had) Timbuktu Pro which I was told was the Win/Mac cross-platform solution to NetMeeting. -Original Message- From: Terry [mailto:terry;epubmgmt.com] Sent: Monday, November 11, 2002 11:48 AM To: CF-Talk Subject: Re: webConference software Is there a macintosh version of

RE: [Cold Fusion Oracle]

2000-11-10 Thread Lincoln Milner
In the CF Administrator, where you can specify what type of data source you want to set, there should be a link to setting up native drivers (in the left nav. bar). You will need an Oracle client on the server hosting CF. The Administering CF manual has a good chapter on setting up all sorts of