(ot) Apply my own CSS in Firefox on a particular web site?

2009-05-26 Thread Jim McAtee
In CSS design articles, it seems to me that I've read of users being able to apply their own CSS to web pages, often in the context of the visually impaired modifying things like font size and color. The discussion usually centers around how to avoid keeping those custom style sheets from

How is this done without evaluate()?

2009-03-19 Thread Jim McAtee
I read that in CF8 evaluate() should no longer be necessary. If so, how would you cleanly rewrite the code below without it? I have a table populated with form field corresponding with records in a table, each idendified by record id. Say I have the record ids in a list. cfset

Re: How is this done without evaluate()?

2009-03-19 Thread Jim McAtee
I must have been thinking about setVariable(). Why Should not be used if not necessary? What would be an example where it's necessary? - Original Message - From: Claude Schneegans schneeg...@internetique.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, March 19, 2009 3:29

Can I do this in a single SQL query?

2009-02-24 Thread Jim McAtee
I have an old table of comments made to a web site in which no user registration was required, but commenters were required to enter an email address. The system had little verification and users could enter bogus addresses, but most people did enter their real email address. The new system

Re: Can I do this in a single SQL query?

2009-02-24 Thread Jim McAtee
- Original Message - From: Matt Williams mgw...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, February 24, 2009 7:47 PM Subject: Re: Can I do this in a single SQL query? UPDATE comments SET userID = ( SELECT userID FROM users WHERE users.email = comments.email )

Best practice - registration activation by email

2009-02-19 Thread Jim McAtee
Just wondering how others are dealing with public member signups that require an email activation? What I'm doing on a new site that I recently set up is sending out the activation as soon as someone registers. If a user tries to login with an account still in the unactivated state, they're

(ot) Setting IIS 6 Content-Type HTTP header

2009-02-10 Thread Jim McAtee
Does anyone know how to redifine the Content-Type HTTP header that is sent by IIS 6? Right now, its: Content-Type: text/htm; charset=UTF-8 We wanted to change the charset to iso-8859-1. In the IIS MMC I can add a custom HTTP header, but defining a Content-Type header there adds another to

Re: (ot) Setting IIS 6 Content-Type HTTP header

2009-02-10 Thread Jim McAtee
Maybe more on topic than off... Is the Content-Type header actually being set by CF? I see that when I request a simple html file from IIS I get a Content-Type of just text/html. If CF is setting this, where can it be configured? - Original Message - From: Jim McAtee jmca

Re: (ot) Setting IIS 6 Content-Type HTTP header

2009-02-10 Thread Jim McAtee
- Original Message - From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, February 10, 2009 5:43 PM Subject: Re: (ot) Setting IIS 6 Content-Type HTTP header Does anyone know how to redifine the Content-Type HTTP header that is sent by IIS 6?

Re: (ot) Setting IIS 6 Content-Type HTTP header

2009-02-10 Thread Jim McAtee
- Original Message - From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, February 10, 2009 5:41 PM Subject: Re: (ot) Setting IIS 6 Content-Type HTTP header Maybe more on topic than off... Is the Content-Type header actually being set by CF? I

Re: Need ISAPI rewrite help...

2009-02-07 Thread Jim McAtee
- Original Message - From: Will Tomlinson w...@wtomlinson.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 07, 2009 10:21 AM Subject: Need ISAPI rewrite help... I'm attempting my first SES URL rewriting with the IIS ISAPI filter, and having a few problems. I

Execute a CF scheduled task

2009-01-30 Thread Jim McAtee
In CF8 is there any way to execute a scheduled task from another CF template? I have a complex database maintenance task that is run every couple of hours, but I'd also like to fire it off from an adminstrator type of application as certain changes are made to the data. Short of duplicating

Re: SQL query sorting problem

2009-01-26 Thread Jim McAtee
WHEN state = 'CA' THEN 2 WHEN state = 'FL' THEN 3 END AS stateSortOrder FROM cities ORDER BY stateSortOrder mike Jim McAtee wrote: DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal

SQL query sorting problem

2009-01-25 Thread Jim McAtee
DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal abbreviations and are in a certain order. For example: 1. NY 2. CA 3. FL I would like the records of the report sorted by the original state order, then

Recognizing spyders

2009-01-15 Thread Jim McAtee
We keep our own page view stats in a database and want to avoid counting page views by visiting spyders. What's a good method for recognizing spyders without throwing away valid visitor page views? Something using cgi.user_agent, no doubt, but how can we keep a fairly comprehensive list up to

Re: Recognizing spyders

2009-01-15 Thread Jim McAtee
- Original Message - From: Wil Genovese jugg...@visi.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, January 15, 2009 5:06 PM Subject: Re: Recognizing spyders Yes you will have to use user-agent and partial matches. Of course there are thousands of possible bots and spiders

Is there a non-aggregate Max() function in MySQL?

2008-12-13 Thread Jim McAtee
I have a table with two columns containing min and max values minprice INT maxprice INT The max price may not be present and is set to zero when that's the case, so data might look like: 1 5 5 0 3 10 8 0 6 0 I want to order by the larger of the two column values ORDER BY Max(minprice,

Date Range Without Year

2008-12-02 Thread Jim McAtee
The DBMS that I'm using is MySQL 5.0. I have a table where I want to store begin and end dates _without_ a year. For example, 'Dec 4' through 'Jun 15'. How can I best represent this in the database? I'll be doing selects of the nature SELECT * FROM mytable WHERE #today# BETWEEN begindate AND

Re: Date Range Without Year

2008-12-02 Thread Jim McAtee
instead of numbers: 0101 to 1231, and created via #dateFormat(now(), mmdd)#. cheers, barneyb On Tue, Dec 2, 2008 at 10:34 AM, Jim McAtee [EMAIL PROTECTED] wrote: The DBMS that I'm using is MySQL 5.0. I have a table where I want to store begin and end dates _without_ a year

Re: Date Range Without Year

2008-12-02 Thread Jim McAtee
between 212 and 610 cheers, barneyb On Tue, Dec 2, 2008 at 11:14 AM, Jim McAtee [EMAIL PROTECTED] wrote: That representation makes sense, but there needs to be a way to use it to construct SELECT queries using =, =, or BETWEEN. Using expressions with MySQL functions in the SELECT would

Random record identifiers in MySQL 5.0

2008-10-28 Thread Jim McAtee
What are you using for random (unique) record identifiers in MySQL? I could use UUIDs, generated either in my CF application, or in MySQL itself. But for a table that's never likely to have more than a few hundred thousand records I could also just use something like a 10 character randomly

Passing a query to a CFML tag

2008-10-07 Thread Jim McAtee
Are queries passed into CFML tags by reference or by value? From what I'm seeing, it looks like by value. cf_mytag query=#myqery# If that's the case, is it necessary then to just pass the name of the query and then use caller.attributes.query?

Re: Passing a query to a CFML tag

2008-10-07 Thread Jim McAtee
=#ATTRIBUTES.myQuery# Works nicely. Adrian Building a DB of errors at http://cferror.org/ -Original Message- From: Jim McAtee Sent: 07 October 2008 21:48 To: cf-talk Subject: Passing a query to a CFML tag Are queries passed into CFML tags by reference or by value? From what

cfqueryparam for boolean/tinyint columns

2008-09-30 Thread Jim McAtee
I have columns in MySQL database containing boolean values, using a data type of unsigned tinyint. Would the cfsqltype of cf_sql_tinyint or cf_sql_bit be best to use? If using cf_sql_bit what does cfqueryparam do in that case with values such as -1 or 3 - will it cast them to 1/0, or will it

XML-RPC with CF8?

2008-09-17 Thread Jim McAtee
I've found some web references to consuming XMP-RPC using CF8's built-in funcitonality, but no examples. I took it to mean that it may be possible to use cfinvoke to consume XML-RPC data, but I'm not really sure if I'm on the right track. cfinvoke webservice=http://xml.a.com;

Optimize Query of Query

2008-09-16 Thread Jim McAtee
I have a process that needs to do about 500 record lookups by ID. I thought I'd do a single query of the table, pulling down the needed data for every record on file (say 1000 records, just three columns) and then use QoQ instead of hitting the database so many times. Is there any way to

Re: Dealing with MySQL escape sequences

2008-05-16 Thread Jim McAtee
on your system). there appears to be no jdbc connector option to change this behaviour, so have to do in server config/start... hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jim McAtee wrote: I ran into a problem inserting records into a MySQL 5.0 database when there's

Dealing with MySQL escape sequences

2008-05-15 Thread Jim McAtee
I ran into a problem inserting records into a MySQL 5.0 database when there's a backslash as the final character of a string value. I never noticed this until I began working with some randomly generated character strings. INSERT INTO users ( name, email, username, salt, password

Re: Simple List Question

2008-05-15 Thread Jim McAtee
You can't treat a word as a list of letters, because there's no delimiter. Use something like: cfset s = apple cfset t = cfloop index=i from=1 to=#len(s)# cfset t = mid(s, i, 1) . /cfloop cfoutput#t#/cfoutput - Original Message - From: Che Vilnonis [EMAIL PROTECTED] To: CF-Talk

CF hash function - why uppercase?

2008-05-01 Thread Jim McAtee
CF's hash() function returns its output hex string with uppercase letters. Generally not a problem if you only apply a single hash to a string, but if you need to do multiple hashes, then the final outcome is unlikely to match that of many other applications that use lower case hexadecimal

Re: Backup / Replicate Server Config

2008-04-29 Thread Jim McAtee
GUI GUI click click methods are nearly useless for automated backup purposes. Aren't there one or more VBS scripts included with the server OS that can backup and restore the entire IIS server configuration? - Original Message - From: Carl Von Stetten [EMAIL PROTECTED] To: CF-Talk

Passwod recovery strategies

2008-04-15 Thread Jim McAtee
I'm exploring some of the ways that we can implement password recovery. Passwords are stored as hashed values in a database. Some systems I've used will immediately reset the password, some send a message that when a link is followed resets the password. Some send the new password out in

Any reason not to use this query of queries?

2008-03-26 Thread Jim McAtee
I have a directory containing dated log files that I need to parse. These have filenames like: reMMDD.log So I do a cfdirectory to pull a list of files: cfdirectory action=list directory=#mylogdir# filter=re.log name=dir But I want exclude today's log from being

Function name capitalization?

2008-02-17 Thread Jim McAtee
I see a lot of CF code being posted using the convention of starting CF function names, both built-in and user-defined, with a lower case letter. While the CF8 docs continue to use the convention of beginning function names with upper case letters. Is there any significance or practical

Anyone still using iMS-SE mail server?

2008-02-15 Thread Jim McAtee
Just curious. I did a search through my old cf-talk messages and it looks like it's been almost 3 years since iMS-SE has been mentioned on this list. And it looks like Howie Hamlin has been absent from the list for about the same amount of time. We have a version of iMS-SE installed on our

Variable expansion within custom tag body

2008-02-14 Thread Jim McAtee
Is variable expansion supposed to take place in the generated output of a CFML tag, or does it always require cfoutput tags? cf_mytag attr1=17 attr2=#variables.x# Generated output on #dateFormat(now(), mmm d, )# /cf_mytag

Re: Query Help - find unique rows in two similar tables

2008-02-11 Thread Jim McAtee
It was pretty close. Running it in one direction, knowing that table B has extra records, works fine. - Original Message - From: Dawson, Michael [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 11, 2008 7:59 PM Subject: RE: Query Help - find unique rows

Re: CF Scheduling weekly or monthly

2008-02-11 Thread Jim McAtee
Many people run a daily task, then check the date to determine if the task should continue. M!ke -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, February 11, 2008 8:49 PM To: CF-Talk Subject: CF Scheduling weekly or monthly Would I be correct

CF Scheduling weekly or monthly

2008-02-11 Thread Jim McAtee
Would I be correct in assuming that if you wanted to schedule something to run weekly on a particular day of the week, that you'd do it by setting the starting date to be a date that falls on that weekday? If that's correct, would monthly scheduling work the same? Say you wanted something to

Query Help - find unique rows in two similar tables

2008-02-11 Thread Jim McAtee
I have two tables with identical structures. The data in the two tables is _nearly_ identical, with one table having a few additional rows. I need to find those additional rows. I want to query the two tables and find the rows in one or the other that are not present in both. It would be OK

Admin API

2008-02-09 Thread Jim McAtee
Does the Admin API exist in CF8 or has it be replaced by something else? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w

Re: Admin API

2008-02-09 Thread Jim McAtee
://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org Adobe Community Expert - http://www.adobe.com/communities/experts/members/brian_rinaldi.html On Sat, Feb 9, 2008 at 1:06 PM, Jim McAtee [EMAIL PROTECTED] wrote: Does the Admin API exist in CF8 or has it be replaced

Access JDBC driver and Rnd() Function

2008-02-04 Thread Jim McAtee
We recently moved an application the uses an Access database from CF5 to CF8. To display a set of records in random order we had been using a query like: SELECT , Rnd(id) AS randcolumn FROM ... ORDER BY randcolumn The values in randcolumn are floats in the range of 0 to 1. This

CF8 and MySQL Zero 0000-00-00 Dates

2008-01-29 Thread Jim McAtee
Is there a way of dealing with MySQL default -00-00 dates beyond going through all of our databases and changing them to NULL or a valid date? I came across an aticle suggesting that there may be a JDBC connection setting that will keep the MySQL JDBC driver from choking on them, but there

Re: CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Jim McAtee
side of an assignment Confirm that it exists? cfdump var=#test# I thought it was just cfhttp.fileContent? I see they added the results attribute in 7, but there's no additional documentation on it. On Jan 25, 2008 2:51 PM, Jim McAtee [EMAIL PROTECTED] wrote: I'm getting an error in CF8

CFHTTP.Filecontent on left side of an assignment

2008-01-25 Thread Jim McAtee
I'm getting an error in CF8 when I attempt to alter the contents of the filecontent key of a struct returned by CFHTTP. This worked fine in CF5. I can easily fix it, but what's the reason for the error? There's not much to go on in the debugging output. The code: cfhttp

Re: OT: SSL Necessary? Important?

2008-01-24 Thread Jim McAtee
Or RapidSSL for $13-15 per year. http://www.namecheap.com/learn/other-services/ssl-certificates.asp I bought a RapidSSL cert for our intranet yesterday and a QuickSSL cert for another site. Beside the domain name in the Subject, they're identical except for the entity listed as the Issuer.

OT: ISAPI_Rewrite with IIS6

2008-01-24 Thread Jim McAtee
I just moved some web sites from a W2k/IIS5/CF5 server to a W2k3/IIS6/CF8 server. On the old server we ran ISAPI_Rewrite 2.11 and I've also installed it on the new server and copied the httpd.ini file with the server-wide rewrite rules. Seems to be installed correctly in IIS6, but the rules

Re: ISAPI_Rewrite with IIS6

2008-01-24 Thread Jim McAtee
- Original Message - From: Dave Watts To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 24, 2008 5:35 PM Subject: RE: ISAPI_Rewrite with IIS6 I just moved some web sites from a W2k/IIS5/CF5 server to a W2k3/IIS6/CF8 server. On the old server we ran ISAPI_Rewrite 2.11 and

How do you lock down a web site with W2k3/IIS6?

2008-01-15 Thread Jim McAtee
I have a web site that is to be accessible only to Windows domain members. I'm moving it from a W2k/IIS5/CF5 server to a W2k3/IIS6/CF8 server in a new domain. With W2k/IIS5 this seemed relatively straightforward. Just give the root folder of the private web site the same permissions as a

Re: How do you lock down a web site with W2k3/IIS6?

2008-01-15 Thread Jim McAtee
Subject: Re: How do you lock down a web site with W2k3/IIS6? this may seem silly, but it almost sounds like there is a comment that is improperly opened/closed. this happened to us recently and nearly drove us crazy. what do you get when you look at the source? On Jan 15, 2008 7:01 PM, Jim

Re: How do you lock down a web site with W2k3/IIS6?

2008-01-15 Thread Jim McAtee
Ack... just found the problem... there was a cfabort firing in Application.cfm when run on the new server. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, January 15, 2008 7:00 PM Subject: Re: How do you lock down a web site

Re: How should SQL handle same named columns from different tables?

2007-10-25 Thread Jim McAtee
From: Kris Jones In general, it is up to the developer to alias the columns so that they can be referenced appropriately in such a scenario. I also am not a fan of the * in queries. And, I wonder, in the example you have given, why this is an issue, since the values for the columns will be

How should SQL handle same named columns from different tables?

2007-10-24 Thread Jim McAtee
SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun 1) one column named userid 2) two columns named userid 3) two columns with some type of unique name for each I find

How to back up a CF8 installation?

2007-10-08 Thread Jim McAtee
Does anyone have pointers, or maybe a link to instructions on how to back up a CF8 installation? Server settings, data sources, scheduled tasks, installed tags, etc. We're running a fairly plain vanilla CF8 Standard install on Win2k3 Server with IIS6.

Re: CF8 Pricing

2007-09-20 Thread Jim McAtee
Windows Server 2003 Enterprise supports 8 CPUs and 64 GB of RAM and is available for about $3400. Four x CF8 Standard would be at least $4800. - Original Message - From: Cutter (CFRelated) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 20, 2007 7:21

Re: CF8 Pricing

2007-09-19 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, September 19, 2007 11:10 AM Subject: RE: CF8 Pricing Can anyone on the list tell exactly what the purchase price of CF8 would be for 8 CPU's. I am trying to find the

CF5 Regex Help

2007-09-19 Thread Jim McAtee
I need to run this on our CF5 server: I have some large text fields containing HTML, most of which have some variation of the following HTML snippet at the beginning: biSome text/i/b More text and HTML follows... ibSome more text/i/b More text and HTML follows... ibYet some more text/b/i More

Re: Best data type for comments using MySQL?

2007-09-13 Thread Jim McAtee
Why not just use VARCHAR()? They can be up to 65,535 characters in length in MySQL 5.0.3 and later. http://dev.mysql.com/doc/refman/5.0/en/string-types.html - Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 13,

CF8 Debugging

2007-09-06 Thread Jim McAtee
Two questions: - Is there any way to enable Robust Exception Information _only_ for debugging IP addresses? It's a lot of useful information to have in the event of an error that isn't shown elsewhere in the debugging output, but it's too much information for outside visitors. - In the

How to move CFIDE in CF8?

2007-09-06 Thread Jim McAtee
When I installed CF8, it placed the CFIDE folder under the source directory of the default web site and created a virtual directory in IIS pointing at the folder. That's not a good location for our use, so I'd like to move it. I tried, and changed the IIS virtual directory, but the CF

Map .htm to ColdFusion

2007-09-06 Thread Jim McAtee
When I try to map the extension .htm to ColdFusion under IIS6, I get the error shown below when requesting a .htm file. I'm pretty sure that with CF5 and IIS5 all that was necessary was this IIS extension mapping. What else is needed with CF8? Server Error

Re: CF8 Debugging

2007-09-06 Thread Jim McAtee
- Original Message - From: Tom Chiverton [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 06, 2007 3:23 AM Subject: Re: CF8 Debugging On Thursday 06 Sep 2007, [EMAIL PROTECTED] wrote: ­ In the debugging output there's a little missing 'topdoc.gif'

Re: Map .htm to ColdFusion

2007-09-06 Thread Jim McAtee
that you might need to add too as well. Other than that it is an interesting question. So, I may have to edit this file by hand? What's the procedure - stop CF, edit file, restart CF? Can anyone confirm whether this is necessary to process .htm files with CF8? On 9/6/07, Jim McAtee

Re: CF8 Debugging

2007-09-06 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 06, 2007 5:03 AM Subject: RE: CF8 Debugging No. It's trivial. But it seems to imply that either the developers of the server expected the CFIDE directory mapping to

Re: How to move CFIDE in CF8?

2007-09-06 Thread Jim McAtee
- Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 06, 2007 3:01 AM Subject: How to move CFIDE in CF8? When I installed CF8, it placed the CFIDE folder under the source directory of the default web site and created

Can the server-wide missing template handler be overridden?

2007-08-30 Thread Jim McAtee
I'm moving a couple dozen web sites from a CF5 server to a new CF8 Standard server. In setting up the server-wide missing error handler, CF8 wants a relative path. Relative to -what- it doesn't say, and since it checks for the existance of the file in the CF Adminsitrator and throws an error

Re: CF 7 - What JVMs are supported

2007-08-22 Thread Jim McAtee
Is there a similar support matrix published for CF8? - Original Message - From: Andy Allan [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, August 22, 2007 1:05 PM Subject: Re: CF 7 - What JVMs are supported Officially...

OT: Microsoft IIS 6 FTP

2007-08-22 Thread Jim McAtee
I'm setting up a new Win2k3 server with CF8, moving from Win2k/CF5. I thought I'd give Microsoft's IIS FTP server a try, having used mostly FTP Serv-U in the past. All I can say is: Is this FTP server even marginally usable in the real world? First thing I run into is that apparently by

Re: Microsoft IIS 6 FTP

2007-08-22 Thread Jim McAtee
Thanks. Is there still a mailing list or user forum for Serv-U somewhere? - Original Message - From: Justin Scott [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, August 22, 2007 1:12 PM Subject: RE: Microsoft IIS 6 FTP I'm setting up a new Win2k3 server

Re: Running CF7 on 64 bit Windows

2007-07-24 Thread Jim McAtee
From: Jochem van Dieten Jim McAtee wrote: I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. You can run CF as a 32 bit application on 64 bit Windows

Running CF7 on 64 bit Windows

2007-07-23 Thread Jim McAtee
I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. I'm getting the following error trying to access the CFIDE: %1 is not a valid Win32 application. Some

Query of Query with dates

2007-06-27 Thread Jim McAtee
Using ColdFusion5. Is there a secret to working with dates in a query of a query? I keep getting zero rows from any date comparision I do in a WHERE clause. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard

Upgrade to CF7 now?

2007-06-17 Thread Jim McAtee
We're in the process of spec'ing a new web server and planning on moving from our current CF5 based web sites to CF7. This is planeed for the July/August time period, with early September targeted as a live date. Anyone have a recommendation to whether it would be wise to do this now, or

Sort array of structs on column?

2007-06-05 Thread Jim McAtee
I have a report to run where I query a number of different tables. I need to sort the output by date, which means I need to consolidate the queries and then sort the whole. I don't believe I can use a union, so I thought I'd throw it all into an array of structs, which I'd sort afterwards.

Re: Development Machine Setup

2007-06-03 Thread Jim McAtee
Why the need for VMs? Can't you just bind multiple addresses to the NIC and configure IIS and Apache to listen to whichever addresses for their respective web sites? - Original Message - From: Michael Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, June

Moving from CF5 on Windows to CFMX on Linux

2007-05-23 Thread Jim McAtee
We're going to be undertaking a long-overdue upgrade from CF5 to CFMX 7.1. At the same time we're considering moving from a Win2k server with IIS to Linux and Apache. Obviously we're dealing with two issues - moving from CF5 to CFMX 7.1 and moving to Linux, so we're wondering if doing both at

MySQL on CF server

2007-05-17 Thread Jim McAtee
We're finally going to be migrating from CF 5 to CFMX 7.1 soon and will spec a new server with Win2k3 Server Standard as the OS. The dbms, currently running on a separate Windows server, is MySQL 5.0. If we move MySQL to the new server, how well could we expect it to coexist with CF/IIS on

Re: MySQL on CF server

2007-05-17 Thread Jim McAtee
Subject: Re: MySQL on CF server Goto Fullcontrol.net and check out what they have. I have been with them for over 4 years and can't be any happier. We have never had any downtime due to their network or servers. Good luck! - Original Message - From: Jim McAtee [EMAIL PROTECTED

Re: MySQL on CF server

2007-05-17 Thread Jim McAtee
DNS human smtp/pop mail server, web mail (smartermail) If I need more capacity I'd replace one of the small boxes above with a bigger one. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On 5/17/07, Jim McAtee [EMAIL PROTECTED] wrote: We're finally going

Re: How can I check this string a different way?

2007-04-28 Thread Jim McAtee
- Original Message - From: Will Tomlinson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, April 28, 2007 2:54 PM Subject: How can I check this string a different way? I need a better way to evaluate a string here. Maybe a regex I guess? I have a

Query Problem

2006-11-05 Thread Jim McAtee
I have a database of music CDs, something like: album - albumid int(10) unsigned NOT NULL auto_increment, albumtitle varchar(255), year smallint(5) unsigned track - trackid int(10) unsigned NOT NULL auto_increment, tracktitle varchar(255), tracknumber smallint(5)

Re: I am soooo pissed

2006-09-05 Thread Jim McAtee
..com's are s 1999 - Original Message - From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 2:58 PM Subject: Re: I am s pissed You know what is weird...The site is already online!! I thought it took awhile, especially at

OT: MyODBC and blobs with text

2006-08-13 Thread Jim McAtee
I have a database (that I didn't develop) with tables that contain text stored in columns of type blob. I believe the reasoning behind this was to to be able to store various language character sets. When I query these from CF using MyODBC I see hexadecimal strings, but grouping these into

MySQL query help

2006-06-03 Thread Jim McAtee
Using MySQL 5.0.21, I have two tables: contributors - contributor_id name namesort contributor_sort - name namesort I'd like to update the namesort column in contributors by using the values in the namesort column in contributor_sort wherever name = name. I

Using IIf() in query value

2006-06-02 Thread Jim McAtee
I'm working in CF5. I thought single quotes within strings were always escaped in a cfquery. I have a query using an IIf() in the value and this doesn't appear to be the case. Does this have something to do with how I'm doing the evaluation of the second argument in the IIf() below? In this

Re: Only update DB if data has changed?

2006-05-26 Thread Jim McAtee
Do you want to do this for a reason, or are you just trying to avoid unnecessary queries? I can see this if you're stamping the records with a timestamp and/or noting the person who updated them, then you might want to avoid marking the record as updated when it actually wasn't. But I'm not

Re: Server Backup Solutions

2006-05-22 Thread Jim McAtee
Rotation of backups can easily be done with Windows scripting or batch files. I do this with my personal computers at home, backing up to an NAS on my network. I use the Windows scheduler to run the backup batch file each night. The batch file fires NTBackup, setting a destination backup

Re: ARGH! - Three Months in the future query problem

2006-05-18 Thread Jim McAtee
Depends on what you're trying to do. Do you want everything between today and the date three months from today? For instance 5/17/2005 to 8/17/2005. Or do you want everthing from the beginning of May through the end of July? The latter could be done with cfset startdate =

Re: ARGH! - Three Months in the future query problem

2006-05-18 Thread Jim McAtee
Whoops. Add just two months to get this month plus the next two. DateAdd(m, 3, startdate) - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, May 18, 2006 3:15 AM Subject: Re: ARGH! - Three Months in the future query

Re: How do I detect day lights savings?

2006-05-11 Thread Jim McAtee
This will tell you if a date/time is currently in DST, assuming it's in an area with the most common US DST rules. cfscript // // Determine if a date/time falls within Daylight Savings Time period // - 2AM on the first Sunday in April to 2AM on the last Sunday in October // function IsDST(dt)

CF Server RDS on Port 80

2006-04-21 Thread Jim McAtee
How does CF's RDS service coexist when listening on port 80 with an HTTP server listening on the same port? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238422 Archives:

Re: CF Server RDS on Port 80

2006-04-21 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, April 21, 2006 2:43 PM Subject: RE: CF Server RDS on Port 80 How does CF's RDS service coexist when listening on port 80 with an HTTP server listening on the same port? RDS

Registry hosed?

2006-04-10 Thread Jim McAtee
On our Win2k/CF5 server I mistakenly enabled client variables (although we're not using them) on a busy site. Client variable storage was still set to the default 'registry'. Apparently it ran fine for a few weeks, then we began getting registry full errors when connecting to the server

Re: Registry hosed?

2006-04-10 Thread Jim McAtee
: Registry hosed? Check the permissions. Make sure you are logging in as an administrator of the server. Then, make sure the admins have permissions to remove the key. M!ke -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, April 10, 2006 5:28 PM To: CF

Re: Client Variables in MySQL

2006-04-08 Thread Jim McAtee
- Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, April 08, 2006 2:13 AM Subject: Re: Client Variables in MySQL Jim McAtee wrote: Are there any good reasons to use InnoDB for CF client varible storage in MySQL

Client Variables in MySQL

2006-04-07 Thread Jim McAtee
Are there any good reasons to use InnoDB for CF client varible storage in MySQL, or are MyISAM tables sufficient? Running CF5. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237210 Archives:

Re: Client Variables in MySQL

2006-04-07 Thread Jim McAtee
pretty sure that innoDB gives you transactions, if you need those. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, April 07, 2006 4:23 PM Are there any good reasons to use InnoDB for CF client varible storage in MySQL, or are MyISAM tables sufficient? Running

How to keep unrelated CFML tags from repeating includes?

2006-03-14 Thread Jim McAtee
I have a site that uses a number of unrelated cfml tags. Often, these tags need to insert an external javascript file reference into the page's HTML header. What is a good technique for keeping more than one tag from inserting the same code? To date I've been setting boolean variables in

SQL IN and cfqueryparam lists

2006-03-08 Thread Jim McAtee
Is it necessary to designate list=yes for a cfsqlqueryparam value if the value is already a comma delimitted list? Or is that exactly what the attibute is to be used for? Is the following a valid use of the 'null' attribute? WHERE recordid IN (cfqueryparam cfsqltype=cf_sql_varchar

  1   2   3   4   5   6   7   8   9   10   >