Re: Why does htmlCodeFormat change font

2001-12-22 Thread Douglas Brown
That worked great. Thanks a bunch Doug - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 21, 2001 11:42 PM Subject: Re: Why does htmlCodeFormat change font Either use HTMLCodeFormat and CSS to set a style for pre tags:

Altering the name of a table

2001-12-22 Thread Brad Wood
Can I use the alter table SQL statement to change the name of a table? ~Brad [EMAIL PROTECTED] (573) 474-2453 Box 9383 [Personal Web Site] [Business Web Site] www.bradwood.com www.midamericapc.com

Re: Altering the name of a table

2001-12-22 Thread Nick de Voil
Brad Can I use the alter table SQL statement to change the name of a table? No, but you can do CREATE TABLE b AS SELECT * FROM a (in some DBMS) DROP TABLE a which has the same effect. Nick __ Get Your Own Dedicated Windows

RecordCount EQ 0 Problem

2001-12-22 Thread Richard L Smith
Hello, I am using the following code to display a message based on the RecordCount variable's value. Everything works ok as long as the query returns some records. However when it is zero no message displays, nothing. I am getting no errors so i don't think it's syntax related? Any Ideas?

Re: RecordCount EQ 0 Problem

2001-12-22 Thread Jochem van Dieten
Richard L Smith wrote: Hello, I am using the following code to display a message based on the RecordCount variable's value. Everything works ok as long as the query returns some records. However when it is zero no message displays, nothing. I am getting no errors so i don't think it's

RE: Password Protecting an Access ODBC connection

2001-12-22 Thread Michiel Boland
Also, I didn't say don't store cc's. I said if you have to store them at I would at least encrypt them. Especially when it's easy. The coldfusion built-in encryption functions are trivial to break, once you know the key. Since the key must be stored on the server, there is 100% probability

Active Edit???

2001-12-22 Thread Douglas Brown
I had heard there was once a free version of activeEdit. If so, does anyone know where I could find this free encrypted version at? Doug __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB

Re: SQL Question

2001-12-22 Thread Gonzo Rock
You are SOOO Right... It did NOT put it in my example... BUT... It is in my table design. (I hate when I screw up in email like that! It really complicates this process.) My delima is given a TravH_ID, create a list of all the OP Records related to the related set of TravD records via the

Formatting HTML to be Handled by Excel's Web Query

2001-12-22 Thread Dave Babbitt
Hi Guys! Playing around with Excel's Web Query, I've discovered that when you format a cell as a date and save it as a web page, Excel encloses that cell in table data tags and adds a number to the tag's attributes like so: !-- This is my Clock In field -- td class=xl34

Re: SQL Question

2001-12-22 Thread Dina Hess
Gonzo, Sounds like you might need something like this: SELECT op_id, released FROM op WHERE op_id IN (SELECT op_id FROM travd WHERE travh_id = 1) Dina - Original Message - From: Gonzo Rock To: CF-Talk Sent: Saturday, December 22, 2001 3:04 PM Subject: Re: SQL

Re: Active Edit???

2001-12-22 Thread Dina Hess
Looks like it's been re-named to eWebEditPro. Here's a link: http://www.ektron.com/wysiwyg-html-editor.cfm. Don't know if it's free though. You may also want to check out ezEdit at: http://www.siteobjects.com/index.cfm?fuseaction=showezedit - Original Message - From: Douglas Brown

Dynamic Site Map

2001-12-22 Thread Darien C. Small
Hi, Of all of my lists, this is one of the three where someone always has an answer, so thanks in advance. I need either or both of these: A. A method to have a site map that is dynamically created and that can act as a link to each of the pages in the site map. Ideally, a user clicks a file

Re: Active Edit???

2001-12-22 Thread Howie Hamlin
Actually, ActivEdit is here: http://www.cfdev.com/activedit/ I don't think there's a free version, though. Howie - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 22, 2001 5:16 PM Subject: Re: Active Edit??? Looks like it's

Stored procedures for queries

2001-12-22 Thread Stephen Hait
I've been wondering about using stored procedures in templates instead of embedding queries. Is there a good reason for this if the queries are only select statements? Stephen __ Why Share? Dedicated Win 2000 Server · PIII

Re: Stored procedures for queries

2001-12-22 Thread Jon Hall
If you are concerned about performance, converting cfquery's to stored procedures is the best way to optimize an application. Even for selects. jon Stephen Hait wrote: I've been wondering about using stored procedures in templates instead of embedding queries. Is there a good reason for

Re: Stored procedures for queries

2001-12-22 Thread Stephen Hait
Jon, thanks for your response. Stephen If you are concerned about performance, converting cfquery's to stored procedures is the best way to optimize an application. Even for selects. jon Stephen Hait wrote: I've been wondering about using stored procedures in templates instead of

Re: CF-Talk-list V1 #33

2001-12-22 Thread [EMAIL PROTECTED]
From: mtroy [EMAIL PROTECTED] Subject: REMOVE, Unsubscribe Date: Mon, 3 Dec 2001 23:16:32 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_000D_01C17C50.915FFF20 X-Priority: 3 X-MSMail-Priority: Normal X-Unsent: 1 X-MimeOLE: Produced By Microsoft

Re: CF-Talk-list V1 #31

2001-12-22 Thread [EMAIL PROTECTED]
From: mtroy [EMAIL PROTECTED] Subject: REMOVE, Unsubscribe Date: Mon, 3 Dec 2001 23:16:32 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_000D_01C17C50.915FFF20 X-Priority: 3 X-MSMail-Priority: Normal X-Unsent: 1 X-MimeOLE: Produced By Microsoft

Re: CF-Talk-list V1 #32

2001-12-22 Thread [EMAIL PROTECTED]
From: mtroy [EMAIL PROTECTED] Subject: REMOVE, Unsubscribe Date: Mon, 3 Dec 2001 23:16:32 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_000D_01C17C50.915FFF20 X-Priority: 3 X-MSMail-Priority: Normal X-Unsent: 1 X-MimeOLE: Produced By Microsoft

What datasources does CF5 need?

2001-12-22 Thread Jim McAtee
I've got a CF5/Win2k server on which I did a clean install of CF5, without documentation. I've also got a development server, a CF5/NT4 machine where I've gone from CF4-CF4.5-CF5. On the latter, I elected to install the CF5 documentation. On the clean install machine I only have one cf