RE:

2002-03-11 Thread kbutterly
look at the directoryexists function. that will do what you want. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 8:56 AM To: CF-Talk Subject: Re: F

RE: Update multiple rows

2002-03-11 Thread kbutterly
Paul, AFAIK, you can only update multiple rows at the same time if you are updating the rows to the same value(s). Since each of your updates are unique, then each query must be run separately. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Origin

RE:

2002-03-12 Thread kbutterly
Check out your cfif. You are testing if MyListr.name IS "." or MyList.name IS ".." and then if that is true, you are testing if MyList.name IS "", which CANNOT be true, since you know that MyListr.name IS "." or MyList.name IS ".." Your original email seems to have a typo. Do you want to see if

RE:

2002-03-12 Thread kbutterly
yes, don't use a submit button, use some kind of graphic, or a standard button. We use the following: This makes the image, which is a picture of a button with the word Back on it clickable. The javascript:history.back() is what you want to use. Kathryn Butterly Web Developer Wash

RE: Database and Query issues.......YIKES!

2002-03-12 Thread kbutterly
Have you looked at the group attribute of the cfoutput tag? That might help. Could you give us a sample of what you want your output to look like? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Jon [mailto:[EMAIL PROTEC

RE: Problem with formatting output

2002-03-15 Thread kbutterly
Just a few questions: Do you group on Job? I ask because the two letter code is different for the two instances of Whatever. Do you have a table that can be used to differentiate the direct costs from indirect costs? Is the date used in any way, or does the column number determine the date? K

Converting Word and Excel to HTML

2001-09-20 Thread kbutterly
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C141D3.50AA0870 Content-Type: text/plain; charset="iso-8859-1" Good morning, all Here is my problem. We have a number of Word

Setting up a knowledgebase

2001-09-25 Thread kbutterly
Good morning, all. I have just been assigned a project to set up a company wide knowledge base and I am soliciting ideas, references, warnings, and resources. We will be using SQL Server for the database. There will be a user portion of the site and an admin portion. >From the user portion we

Using VBScript from ColdFusion

2001-09-27 Thread kbutterly
Good morning, all. Excuse the very basic nature of this question, but how do I use VBScript with ColdFusion? All the documentation says that the

RE: Last Updated Date

2001-10-02 Thread kbutterly
Simon, If you are using Access, the system tables all start with "M". Try MSysobjects Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 8:45 AM To:

RE: Last Updated Date

2001-10-02 Thread kbutterly
Simon, I just reread your original post. Do you want the last updated date of the database, or of a table in the database? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Simon Whittaker [mailto:[EMAIL PROTECTED]] Sent:

RE: Visual Equation Building

2002-02-28 Thread kbutterly
OTTOMH, What about two select boxes, one containing a list of fields, and one containing operators. Use the onChange event to fire off some Javascript to concatenate each building block to the current equation. Then have the javascript put the updated equation to a textarea or something like t

RE: Date Function

2002-02-28 Thread kbutterly
I'm sorry, I'm not sure what you are asking. Are you asking how to get the previous day's date? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002

RE: can someone see a problem with this!!!

2002-03-05 Thread kbutterly
well the error points to the criteria field, so have you checked what #Variables.RecordID# is? put #Variables.RecordID# right before your query to check. is StoreID defined to be the datatype of #Variables.RecordID#? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMA

RE: Sorry to flood the List BUT.... ListContains NOT functioning properly!

2002-03-05 Thread kbutterly
Isn't it because "spin" IS contained in the list? in siteSpin? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 1:59 PM To: CF-Talk Subject: Sorry to f

RE: whats wrong with DateFormat()

2002-03-05 Thread kbutterly
OK, did it give you yesterday's date, 3/4/2002, when you put in DateFormat(day(now()), 'dd'), or did it give you 04? Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesd

RE: whats wrong with DateFormat()

2002-03-05 Thread kbutterly
Thanks. This is why: day(now()) returned 5, because today is the fifth of the month. DateFormat(5, 'mm/dd/yy') would return 01/04/1900, because you have asked for the fifth day, counting from 12/31/1899 (and if you want to read about why that date was/was not chosen, there's lots to read!) Dat

RE: Intranet apps

2002-03-07 Thread kbutterly
here's a few ideas: Conference room scheduler: Do you use Outlook? If so, make the conference room a person, and have people "invite" the conference room to meetings. Give an admin rights to handle the conference rooms schedule. Make the schedule visible to all. There are a few sites that h

RE: Mailing an excel file with

2002-03-07 Thread kbutterly
I don't know if this will work, but after you create the file, can you rename it so that the extension is .csv? That will cause Excel to open it, on most systems. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: bajaria a

RE: SQL Statement dumping data

2002-03-08 Thread kbutterly
if you mean delete all the data, use the Purge command. It is very fast. Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:23 AM To: CF-Talk Subject:

RE: Report Writer

2002-03-08 Thread kbutterly
It is possible, although the learning curve is a bit step, to generate Avery mailing labels in Word .doc format, which your users can then use to open and print the labels. Would that work for you? There is an article in www.irt.org about outputting CF to Word, if you are interested. I have bec