Recent content by cl8855

Have a page that exports to excel using cfcontent tags: <cfcontent type="application/vnd.ms-excel"> or <cfcontent type="application/ms-excel"> Once users upgraded to excel 2003, just returns a blank worksheet instead of data? Anyone else run into this? I tried changing to use <cfheader...

Excellent. I had figured out the specification of each field, but of course I wanted to save as much typing/code as possible. But for the 2nd table update, that works perfectly. I had tried similar things to add the other fields, but after the from statement, not in the middle of the select.

OK how about I make this harder then. First part works well. 2nd part is I have audit tables that track all changes, but they have 3 additional fields that original table doesn't (last_update, updated_by, action_type). How do I do an insert into/select from and also add those three extra...

It seems to be working, but do I have to list the fields in the order they are in the database? I had one in a separate order and it seemed to put the data in the wrong columns. I had thought it would use the field names from the select to insert since they are the same. Oh well looks good...

thanks, I will give that a test run

There has to be an easy way to do this. How can I copy a full entry in a table to a new entry just changing one field (which happens to be part of the primary key) for example: servers_table has app_name, server_name, ip_address, firewall fields (plus more) I want to insert a copy of...

Hmm I don't think that works, I thought Union needed same data types on the columns. What is the "foo" stuff you are adding? Trying to get the columns to match in the union?

OK, cool I think that will work. How about I make it harder then! I want to get a.* as long as a.col1 > 1, but no matter whether (a.alertid = or <> m.alertid, m.msgid = or <> c.msgId) Of course if the others are correct then I want to get c.*

Alerts Table: alertId, col1, col2, col3 Msgs Table: alertId, MsgId Comments Table: Msgid, col1, col2, col3, col4 Is there a way to build just one query that grabs all columns/records from the alerts table for "col1 > 1", AND all columns from the comments table for that record's corresponding...

xWasted: That is not what appears to happen, because the text is formatted as per test.css, while "unique" tags from the print.css also work. Vrag: Unfortunately it is only for internal use (not online). Luckily we have a standardized IE6 browser so I don't have to worry about multiple. Supra...

If I use print and screen stylesheets as shown here: <link rel="STYLESHEET" type="text/css" media="screen" href="test.css"> <link rel="stylesheet" type="text/css" media="print" href="print.css"> Then shouldn't I be able to have the same tag in each stylesheet, for example p.bold, where each...

OK I got the answer. Turns out there is a function in coldfusion - URLEncodedFormat() which does exactly what I need, basically escapes any chars in the text automatically. thanks

Here's the issue. I have a web page storing fields into a database. Someone puts in something like server_name is "server%abc" as a field. I have several functions they can do on that field (like update) that passes them to "update_page.cfm?#server_name#" Now when the #server_name# variable...

Is there any way to get the current time (including milliseconds) in cold fusion? Doesn't look like it in the date/time functions, but someone must be doing this. thanks

We are talking about HKLM entries. If I log on to the citrix server as an admin and look at the registry the entries are there, but not all users &quot;see&quot; them. As for having the .ini file in a /winnt location, that is not possible as it is an application based function where it must be...