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

[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 
working when someone visits your site.

I frequent one particular web site (a forum) that I find difficult to read 
due to the choice of skin colors, font face, sizing and line spacing.  Is 
there any way in Firefox that I can apply a style sheet to _only_ this 
particular web site? 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322802
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

How is this done without evaluate()?

[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 idlist=32,8,11,45

cfloop index=id list=#idlist#
  tr
tdinput type=text name=#id#_name 
value=#evaluate('form.#id#_name')#
...
  /tr
/cfloop 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320715
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How is this done without evaluate()?

[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 PM
Subject: Re: How is this done without evaluate()?



 I read that in CF8 evaluate() should no longer be necessary.

 This is wrong. What is true is Should not be used if not necessary
 Which by the way is your case here.
 But there are more complex issues where it can't be avoided.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320724
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Can I do this in a single SQL query?

[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 requires user registration and new comments are now tied 
directly to a user account.  What I'd like to do is link any newly 
registered users to their old comments by using the email address.  It's 
imperfect, but better than nothing.  In the comments table below old 
comments have the name and email columns populated, while new comments 
have the userid populated instead.

users

userid int
username   varchar
email  varchar
...

comments

commentid  int
userid int
name   varchar
email  varchar
commentvarchar
...

Is there a single SQL query that could set userid in the comments table 
based on linking the email address in the two tables?  I can easily do it 
by looping over the users table and querying the comments table, but 
that's potentially a lot of queries. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319779
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[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
 )


Doh... Really?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319782
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Best practice - registration activation by email

[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 shown an appropriate error 
message and given the option of having another activation email sent to 
them.

I expire the unactivated accounts after 48 hours, deleting them completely 
from the books.  This should allow someone to re-register using the same 
email address, in case their activation email was lost, overlooked, or 
caught by a spam filter.

Other approaches? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319561
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

(ot) Setting IIS 6 Content-Type HTTP header

[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 the one IIS already sends.

Can this be done throug the MMC, or is there another way it must be done? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319131
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

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

[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...@mediaodyssey.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Tuesday, February 10, 2009 1:42 PM
Subject: (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?  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 the one IIS already sends.

 Can this be done throug the MMC, or is there another way it must be 
 done?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319139
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[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?  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 the one IIS already sends.

 Can this be done throug the MMC, or is there another way it must be 
 done?

 This might help:
 http://www.w3.org/International/O-HTTP-charset#server


Thanks, but it appears to be completely wrong for IIS 6.  There is no 
HTTP Headers = File Types... that I can see. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319143
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

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

[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 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?

 CF sets the content type for documents generated by CF. Otherwise, IIS
 sets the content type.


Ok, that's the impression that I got.  Where can it be set?  I've tried:

cfprocessingdirective pageencoding=iso-8859-1

and still get the same HTTP Content-Type header, showing a charset of 
'UTF-8'. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319144
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need ISAPI rewrite help...

[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 wanted to process .html files as .cfm's. That part seems to work,


You know you don't have to use a rewrite tool to do that - you can just 
map the .html extension to CF in IIS.


 but I have another rule that converts /EID/993 to ?EID=993

 My URL var doesn't seem to be seen on the action page.

 http://staging.ac100.org/calendarDetails.html?/EID/935


Wouldn't the goal be to eliminate the ? completely from your URLs?

http://staging.ac100.org/calendarDetails.html/EID/935


 I dump the value of URL.EID, and it's 0, which I had cfparam'd.

 Here are my rewrite rules in httpd.ini. Thanks for any help someone 
 could offer.

 RewriteRule (.*)/(.*)\.html(.*) /$2.cfm [I]

 #Convert SES URLs to standard URLs before passing them to ColdFusion
 RewriteRule (.*?\.cfm)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? 
 $1(?2$2:\?)$3=$4?5$5: [N,I]
 RewriteRule (.*?\.cfc)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? 
 $1(?2$2:\?)$3=$4?5$5: [N,I]


I think you might need to use the .html extension.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319020
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Execute a CF scheduled task

[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 all the code from the scheduled task, or creating a 
server-wide CFML tag or object out of it, this is the only solution that 
comes to mind. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318697
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL query sorting problem

[Jim McAtee]

Michael,

Thanks. That worked perfectly.

Jim


- Original Message - 
From: Dawson, Michael m...@evansville.edu
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, January 26, 2009 8:07 AM
Subject: RE: SQL query sorting problem


 The proper solution would be a separate table that contains the state
 codes with their desired sort order.  That table is joined to the main
 table.  This is probably best if you have to list all 50+ states.

 If you only need to list three states, then I would use CASE as Azadi
 suggested.

 In MSSQL:

 SELECT
  state
  ,CASE
WHEN state = 'NY' THEN 1
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
 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 by city name.  I can pull the data for the report in
 single query, but can't figure out how to maintain the state order.

 Turning the state list above into a comma delimmited list (NY,CA,FL),
 my query looks something like:

 SELECT *
 FROM cities
 WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY
 state, city

 Except that I lose the original order of the state list.

 There are a number of workarounds, such as looping through the states
 and doing one query for each.  Or run the single query shown above and

 then in a similar manner loop through the states and do a QoQ for
 each.

 Is there a way to do this in a single query?






 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SQL query sorting problem

[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 by city name.  I can pull the data for the report in single query, 
but can't figure out how to maintain the state order.

Turning the state list above into a comma delimmited list (NY,CA,FL), my 
query looks something like:

SELECT *
FROM cities
WHERE state IN (cfqueryparam value=#states# list=yes)
ORDER BY state, city

Except that I lose the original order of the state list.

There are a number of workarounds, such as looping through the states and 
doing one query for each.  Or run the single query shown above and then in 
a similar manner loop through the states and do a QoQ for each.

Is there a way to do this in a single query? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318510
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Recognizing spyders

[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 date, and do we try to do exact string matches, 
partial matches, or what? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318036
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Recognizing spyders

[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 out there so you will
 have a fun time building the list and then updating it.  Since your
 doing your own, I'm guessing you have access to the HTTP log files?

No, we're logging it in real time.  We don't create a record for every 
visit, though, just a daily record per page containing a count that gets 
incremented.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318038
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[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, maxprice) DESC

But SQL's MAX() can't be used like this since it's an aggregate function. 
Is there a MySQL function that would do this? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316742
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Date Range Without Year

[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 enddate 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316118
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Date Range Without Year

[Jim McAtee]

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 be ok, if it can be done.


- Original Message - 
From: Barney Boisvert [EMAIL PROTECTED]
To: cf-talk cf-talk@houseoffusion.com
Sent: Tuesday, December 02, 2008 11:52 AM
Subject: Re: Date Range Without Year


 You could just use numbers to represent the dates.  Year runs from 101
 to 1231 (thats MDD), and easily create from a date like this:
 #month(now()) * 100 + day(now())#.  Strings would also work 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.
 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 enddate




 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316120
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Date Range Without Year

[Jim McAtee]

That won't work in cases where begindate  enddate.  This is essentially a 
seasonal newsletter signup, where the user is given a choice of the date 
to begin and end the email.  They might subscribe from Feb 12 to Jun 10, 
but they might also subscribe from Nov 10 to Apr 5.  The typical query 
would be to select all records where today falls within the subscribed 
date range.

This can be done using a MySQL conditional, but it gets a little ugly.

SELECT *
FROM newsletter
WHERE IF( begindate = enddate,
 '1202' BETWEEN begindate AND enddate,
 '1202' = begindate OR '1202' = enddate );



- Original Message - 
From: Barney Boisvert [EMAIL PROTECTED]
To: cf-talk cf-talk@houseoffusion.com
Sent: Tuesday, December 02, 2008 12:31 PM
Subject: Re: Date Range Without Year


 Select all events between February 12th and June 10th:

 select *
 from eventTable
 where dateCol 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 be ok, if it can be done.


 - Original Message -
 From: Barney Boisvert [EMAIL PROTECTED]
 To: cf-talk cf-talk@houseoffusion.com
 Sent: Tuesday, December 02, 2008 11:52 AM
 Subject: Re: Date Range Without Year


 You could just use numbers to represent the dates.  Year runs from 101
 to 1231 (thats MDD), and easily create from a date like this:
 #month(now()) * 100 + day(now())#.  Strings would also work 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.
 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 enddate 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316123
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Random record identifiers in MySQL 5.0

[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 generated number or string.  The advantage of the 
latter is that it would be a lot easier for any humans that might need to 
deal with the string.

Whatever is used, if the application generates the random identifier, then 
it needs to first do a record lookup to be sure the identifier is unique, 
contained within a transaction along with the insert query.  Is that 
avoidable by using the database to generate the identifier? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314443
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Passing a query to a CFML tag

[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?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313567
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Passing a query to a CFML tag

[Jim McAtee]

I want to modify the query within the tag.  If the query were being passed 
by reference then I would think it wouldn't be necessary to reference it 
using the CALLER scope.


- Original Message - 
From: Adrian Lynch [EMAIL PROTECTED]
To: cf-talk cf-talk@houseoffusion.com
Sent: Tuesday, October 07, 2008 3:24 PM
Subject: RE: Passing a query to a CFML tag


 Nope, it's by reference.

 I'd only set it to CALLER if you were modifying it. Do you really mean 
 that
 you want to just use the query in the tag?

 I pass it in as:

 cf_mytag query=#myQuery#

 and then use it with:

 cfdump var=#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 
 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?


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313571
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfqueryparam for boolean/tinyint columns

[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 throw an error? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313287
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

XML-RPC with CF8?

[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;
  method=getReport
  returnvariable=rpt
 cfinvokeargument name=userid value=company22
 cfinvokeargument name=password   value=abcdef
 cfinvokeargument name=args   value=17
/cfinvoke

When I try this I get the following errors:

Cannot generate stub objects for web service invocation.
Name: http://xml.y.com. WSDL: http://xml.aa.com. 
WSDLException (at /methodResponse): faultCode=INVALID_WSDL: Expected 
element '{http://schemas.xmlsoap.org/wsdl/}definitions'.: It is 
recommended that you use a web browser to retrieve and examine the 
requested WSDL document to ensure it is correct. If the requested WSDL 
document cannot be retrieved or is dynamically generated, it is likely 
that the target web service has programming errors.

So I take it that it's trying to retrieve a WSDL document and one doesn't 
exist?  Am I on the right track to using CF8's facilities for doing this? 
I can successfully make the same XML-RPC call using cfhttp. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312727
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Optimize Query of Query

[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 index or otherwise optimize the dataset that I 
retrieve to optimize the query of query lookups?  If I'm doing lookups 
using a particular column, would it help to sort the query by that column? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312635
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Dealing with MySQL escape sequences

[Jim McAtee]

Thanks.  I'll have to try it.

- Original Message - 
From: Azadi Saryev [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, May 15, 2008 8:00 PM
Subject: Re: Dealing with MySQL escape sequences


 you can run MySQL in  NO_BACKSLASH_ESCAPES mode: see chapter 5.2.6 in
 MySQL ref manual

 there's more in the Appedixes:

 This SQL mode also can be enabled automatically when the server starts
 by using the command-line option --sql-mode=NO_BACKSLASH_ESCAPESor by
 setting sql-mode=NO_BACKSLASH_ESCAPES in the server option file (for
 example, my.cnf or my.ini, depending 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 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
   )
 VALUES (
'Cindy Smith',
   '[EMAIL PROTECTED]',
   'cindysmith',
   'd}\',
   'c9a96937d248c0f192ff217a72935cdd'
   )

 The workaround is to either enapsulate the value in a cfqueryparam 
 tag
 or to escape the backslashes with \\.  But I also realize that there 
 are
 any number of places where this could crop up in existing code.  Is 
 this a
 bug in CF8's handling of these strings for MySQL?  I would have thought 
 it
 would escape them transparently.

 Is there a better workaround?



 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305486
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Dealing with MySQL escape sequences

[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
  )
VALUES (
   'Cindy Smith',
  '[EMAIL PROTECTED]',
  'cindysmith',
  'd}\',
  'c9a96937d248c0f192ff217a72935cdd'
  )

The workaround is to either enapsulate the value in a cfqueryparam tag 
or to escape the backslashes with \\.  But I also realize that there are 
any number of places where this could crop up in existing code.  Is this a 
bug in CF8's handling of these strings for MySQL?  I would have thought it 
would escape them transparently.

Is there a better workaround? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305358
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Simple List Question

[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-talk@houseoffusion.com
Sent: Thursday, May 15, 2008 2:04 PM
Subject: Simple List Question


 Probably been covered before...
 How do I take a word like, apple and loop through each letter? I'd 
 like to
 end up with a.p.p.l.e. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305366
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF hash function - why uppercase?

[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 
digits.  I just wasted more than an hour realizing this.

Trying to authenticate against a vBulletin user table, which uses a 
hashing functon of

$hash = MD5(MD5($password) + $salt))

In CF, you need to force the intermediate string to lower case (and 
optionally, do so to the finah string as well.

hashedpwd = lCase(hash(lCase(hash(form.password))  user.salt))



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304613
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Backup / Replicate Server Config

[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 cf-talk@houseoffusion.com
Sent: Tuesday, April 29, 2008 4:49 PM
Subject: Re: Backup / Replicate Server Config


 Kevin,

 WRT IIS, you can backup the IIS settings for either individual websites
 or the whole server from IIS Admin.  For the whole server, open IIS
 Admin, right-click on the Web Sites node, and select All Tasks ---
 Save Configuration to a File  You can then export current settings
 to an XML file.  You can do the same for individual web sites or even
 virtual directories.

 If you intend to use these XML files to replicate settings onto other
 servers, examine the contents and change any server-specific data as 
 needed.

 To reimport the XML file settings, right-click on the desired node and
 select New---Web Site (from file)... or Virtual Directory (from
 file...).  In the Import Configuration dialog, click on Browse...
 and select the xml file you wish to import.  Then click on Read File.
 From the list of web sites that are displayed, pick the one you wish to
 restore/create, and click OK.  If the site already exists, you will be
 prompted whether to create a new site or replace the existing site.
 Select which you want to do, then click OK.

 HTH,
 Carl



 Kevin Aebig wrote:
 Hey all,



 This is driving me nuts, but how do you backup than replicate not only
 CFMX7, but IIS6 as well? I thought given the ease of administering 
 these
 services that this would be a joke.



 Thanks for any tips,



 !k






 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304443
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Passwod recovery strategies

[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 plaintext, some requre changing that password 
immediately, some let you use the randomly generated password 
indefinitely.

Ideas, pros and cons of different approaches? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303503
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Any reason not to use this query of queries?

[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 processed.  This isn't possible 
using cfdirectory's filter, so I figured:

cfset today = dateFormat(now(), mmdd

cfquery type=dbtype name=dir
SELECT * FROM dir
WHERE name  're#today#.log'
/cfquery

Seems to work.  Should this type of QoQ, using the same query name to 
effectively delete rows, be safe in most circumstances? 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302128
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Function name capitalization?

[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 
reason for the initial lower case naming convention? 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299232
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Anyone still using iMS-SE mail server?

[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 CF8 server, using it mostly 
for mass mailings, while using CFMAIL for most one-off messages.  But 
CFMAIL continues to frustrate the  out of me.  Although the spooling 
time has been set to 15 seconds in the Administrator, messages sit for up 
to 10 minutes before being sent. 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299116
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Variable expansion within custom tag body

[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


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299049
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

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

[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 in two similar tables


 You know...  This probably won't work.  I don't have access to a
 database server right now to test this.  I'm trying to picture the
 results, but it's late and my brain is foggy.

 M!ke

 -Original Message-
 From: Dawson, Michael [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 11, 2008 8:45 PM
 To: CF-Talk
 Subject: RE: Query Help - find unique rows in two similar tables

 SELECT
 a.*
 ,b.*
 FROM
 TableA a
 FULL OUTER JOIN TableB b
 ON a.id = b.id
 WHERE
 a.id IS NULL
 OR
 b.id IS NULL

 (Untested)

 M!ke 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298771
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF Scheduling weekly or monthly

[Jim McAtee]

Yeah, that's how I've done it in the past, but I'd prefer to just use the 
CF sheduler if it's capable.


- Original Message - 
From: Dawson, Michael [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, February 11, 2008 8:00 PM
Subject: RE: CF Scheduling weekly or monthly


 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 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 execute monthly on the 15th of the month - just set
 the start date to something like Jan 15, 2008? 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298770
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF Scheduling weekly or monthly

[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 execute monthly on the 15th of the month - just set 
the start date to something like Jan 15, 2008? 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298767
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Query Help - find unique rows in two similar tables

[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 to run two queries - show the 
rows in table A that aren't present in table B, then a second query to do 
the opposite.  The primary keys in the two tables are _not_ the same, so 
rows must be deamed the same by examing a combination of three other 
columns.

I've found some examples of queries to finding duplicate rows in two 
similar tables, but not the inverse.  And most of those examples use the 
primary key. 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298764
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Admin API

[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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298621
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Admin API

[Jim McAtee]

Is there any documentation of the API anywhere?  I can't find anything in 
the CF8 livedocs.  All I could find were a couple of examples in the CF7 
docs:

http://livedocs.adobe.com/coldfusion/7/htmldocs/1734.htm



- Original Message - 
From: Brian Rinaldi [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, February 09, 2008 1:11 PM
Subject: Re: Admin API


 It exists. I use it on my Illudium Code Generator which works the same 
 on
 both 7 and 8.

 -- 
 Brian Rinaldi
 blog - http://www.remotesynthesis.com/blog
 ColdFusion Open Source List- 
 http://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 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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298631
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Access JDBC driver and Rnd() Function

[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 worked 
well in CF5, but in CF8 it appears to consistently generate the same sets 
of numbers for randcolumn.  What's really odd is that about 90+% of the 
time it will return the exact same set of numbers (and so the same sort 
order), then the remaining 10% of the time there will be a couple other 
variations.

Any ideas about what's going on and whether there's a simple workaround? 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298141
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF8 and MySQL Zero 0000-00-00 Dates

[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 weren't instructions on how it's done. 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFHTTP.Filecontent on left side of an assignment

[Jim McAtee]

Yes, it exists.  It fails using either cfhttp.filecontent or some variable 
designated through the restults attribute.


- Original Message - 
From: Todd [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 1:04 PM
Subject: Re: CFHTTP.Filecontent on left 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 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 url=.com/test2.cfm result=test
 cfset test.filecontent = Replace(test.filecontent, a, b, all)

 The error:

 12:41:30.030 - java.lang.NoSuchFieldException - in 
 D:\web\dev5\test1.cfm :
 line 13
FILECONTENT
 While this statement is ok:cfset s = Replace(test.filecontent, a, 
 b,
 all)




 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297472
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFHTTP.Filecontent on left side of an assignment

[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 url=.com/test2.cfm result=test
cfset test.filecontent = Replace(test.filecontent, a, b, all)

The error:

12:41:30.030 - java.lang.NoSuchFieldException - in D:\web\dev5\test1.cfm : 
line 13
FILECONTENT
While this statement is ok:cfset s = Replace(test.filecontent, a, b, 
all) 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297465
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: SSL Necessary? Important?

[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.  It's RapidSSL in 
one and GeoTrust in the other.  That's all you're paying extra for.  But 
RapidSSL is a division of GeoTrust and GeoTrust is now owned by Verisgn. 
The SSL certificate business is a racket.


- Original Message - 
From: Rick Root [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, January 24, 2008 10:16 AM
Subject: Re: OT: SSL Necessary? Important?


 On 1/24/08, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Thursday 24 Jan 2008, James Holmes wrote:
  A dedicated IP is probably necessary with your host, since I assume
  you're sharing an IP right now.

 You can serve multiple different SSL'ed domains from the same IP, can't 
 you ?
 Your existing hose may also have a cheaper deal too.

 typically no, because virtual hosting relies on host headers.  The
 web server doesn't receive the headers until after the connection is
 established.

 As for self-signing with OpenSSL - it's not a viable option at all
 unless you're doing it for an intranet or a site with a VERY VERY
 small base of users (like 2-3 users).. cuz then you can tell the 2-3
 users to ignore the certificate warning.  But that's STILL a security
 risk to you and those 2-3 users.

 I've found this reseller to be reliable and cheap - they've been in
 business for a long time and they're still there, and still cheap.

 http://www.spacereg.com/webcert.html

 the StarterSSL certificate is only $25/year with 96% browser
 recognition go up to the QuickSSL to get 99% recognition at
 $80/year...

 Rick


 -- 
 Rick Root
 New Brian Vander Ark Album, songs in the music player and cool behind
 the scenes video at www.myspace.com/brianvanderark

 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297334
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

OT: ISAPI_Rewrite with IIS6

[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 aren't being 
executed.  Any ideas why that may be? 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297324
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ISAPI_Rewrite with IIS6

[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 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 aren't
 being executed.  Any ideas why that may be?

 If you look at the properties of the virtual server in question, does
 the
 ISAPI filter show up in the list of loaded filters?

No, it's server-wide and inherited by all virtual servers.  It doesn't get
listed for each site.

It ended up being a permission issue.  I found something specific to IIS6
in the help that says to give the IIS_WPG user read permission on any
httpd.ini files and write permission on the folders containing them so
that error logs can be written.

Thanks. 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297387
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

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

[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 public web site, 
then add IUSR_MACHINENAME to the ACL with Deny for all permissions.

On the new server that same strategy gives fairly strange results - it 
looks like the user authenticates OK, but I get no page output.  If CF 
debugging is enabled for the IP address, I see no page output, but the CF 
debugging output is shown and lists execution times for all the CF 
templates for the page generation.

Oddly enough, I get the same behavior in IIS6 if I use IIS's integrated 
directory security instead of Windows folder ACLs. 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296637
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[Jim McAtee]

In the source, above the CF debugging output I have just some white space. 
Numerous CRLFs, but also a few tabs at the beginning of some lines.


- Original Message - 
From: Crow T. Robot [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, January 15, 2008 6:42 PM
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 McAtee [EMAIL PROTECTED] wrote:

 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 public web 
 site,
 then add IUSR_MACHINENAME to the ACL with Deny for all permissions.

 On the new server that same strategy gives fairly strange results - it
 looks like the user authenticates OK, but I get no page output.  If CF
 debugging is enabled for the IP address, I see no page output, but the 
 CF
 debugging output is shown and lists execution times for all the CF
 templates for the page generation.

 Oddly enough, I get the same behavior in IIS6 if I use IIS's integrated
 directory security instead of Windows folder ACLs.


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296641
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[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 with W2k3/IIS6?


 In the source, above the CF debugging output I have just some white 
 space.
 Numerous CRLFs, but also a few tabs at the beginning of some lines.


 - Original Message - 
 From: Crow T. Robot [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Tuesday, January 15, 2008 6:42 PM
 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 McAtee [EMAIL PROTECTED] wrote:

 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 public web
 site,
 then add IUSR_MACHINENAME to the ACL with Deny for all permissions.

 On the new server that same strategy gives fairly strange results - it
 looks like the user authenticates OK, but I get no page output.  If CF
 debugging is enabled for the IP address, I see no page output, but the
 CF
 debugging output is shown and lists execution times for all the CF
 templates for the page generation.

 Oddly enough, I get the same behavior in IIS6 if I use IIS's 
 integrated
 directory security instead of Windows folder ACLs.


 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296642
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

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

[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
 exactly the same?

It's not a matter of the values, but the column names.  Moving an 
application from a CF5 server using Microsoft ODBC drivers to a CF8 
server, I found that this 'Access with Unicode' driver behaves differently 
than the ODBC driver that had been used previously, and also differently 
from the other Access driver included with CF8.  The application expects 
to have a column named 'userid' returned in the query, but it doesn't 
exist.

I'd never run into the issue before trying to use this particular Access 
driver, so wasn't aware that doing this could cause confusion. 


~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

How should SQL handle same named columns from different tables?

[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 that the CF8 'Microsoft Access with Unicode' driver does #3, which 
I hadn't seen before in other ODBC drivers.  It returns two columns named 
'a.userid' and 'b.userid'. 


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

How to back up a CF8 installation?

[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. 


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290617
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 Pricing

[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 AM
Subject: Re: CF8 Pricing


 Besides, your Windows 2k3 license is far more expensive than the app
 server

 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288967
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 Pricing

[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
 information on Adobe's site but I cannot.

 Directly from the Adobe site:
 http://www.adobe.com/products/coldfusion/faq/#section-2

 What are the editions of ColdFusion 8, and how are they priced?

ColdFusion 8 is sold in two editions: Standard Edition at US$1,299 
 per
 two CPUs and Enterprise Edition at US$7,499 per two CPUs. ColdFusion may
 also be used for development at no cost with the free Developer Edition, 
 a
 full-featured server for development use only.

 So, multiply by 4!


That would certainly suck. 


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288830
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF5 Regex Help

[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 text and HTML follows...

I need a regex that will let me extract and remove the leading text so 
that it can be stored in a separate column. 


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288856
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Best data type for comments using MySQL?

[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, 2007 4:18 PM
Subject: Re: Best data type for comments using MySQL?


 Med text allows for up to 65,535 characters so that should be plenty.
Longtext allows for like millions.

 Fixed it!

 Thanks dude!


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288428
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF8 Debugging

[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 debugging output there's a little missing 'topdoc.gif' image, 
which is being referenced in a location within /CFIDE.  Surely CF8 doesn't 
expect you to map CFIDE as a virtual directory in the HTTP server for 
_every_ virtual web site on the machine? 


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287885
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

How to move CFIDE in CF8?

[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 Administrator bombs.  I put everything back the way it was and went 
into the Administrator and see that it CF has an unchangeable logical 
directory mapping of /CFIDE pointing at the physical location.  I'm 
guessing that's the problem.

How can I move the folder and change the mapping of /CFIDE? 


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287890
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Map .htm to ColdFusion

[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

Either the Macromedia application server(s) are unreachable or none of 
them has a mapping to process this request.



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287891
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF8 Debugging

[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' image,
 which is being referenced in a location within /CFIDE.  Surely CF8 
 doesn't
 expect you to map CFIDE as a virtual directory in the HTTP server for
 _every_ virtual web site on the machine?

 If you want it to show up, yes.
 Do you really care if a graphic is missing in the debug output though ?


No.  It's trivial.  But it seems to imply that either the developers of 
the server expected the CFIDE directory mapping to exist for all virtual 
sites or else they were oblivious to this happening.  Why go to the 
trouble of designing a nicely formatted debug output page and then have it 
punctuated by a missing graphic? 


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287894
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Map .htm to ColdFusion

[Jim McAtee]

- Original Message - 
From: Andrew Scott [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 06, 2007 3:36 AM
Subject: Re: Map .htm to ColdFusion


 Is this a standard install? Or multie server?

Standard install.

 There is new filter mappings in the web.xml 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 [EMAIL PROTECTED] wrote:

 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
 
 Either the Macromedia application server(s) are unreachable or none of
 them has a mapping to process this request.


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287895
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 Debugging

[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 exist for all virtual sites or else they were
 oblivious to this happening. Why go to the trouble of
 designing a nicely formatted debug output page and
 then have it punctuated by a missing graphic?

 Since CF, by default, has many dependencies that rely on the existence 
 of a
 /CFIDE URL, I submit that they expected you'd have that directory on a
 properly configured server. But putting that aside, where else could 
 they
 put it? It has to go somewhere - can you suggest a better location?

The graphic?  Who knows.  I'm not worried about the graphic.

What other functionality relies on the CFIDE mapping?  It it necessary for 
things like CFFORM?

When I first set up the server I had several virtual IIS sites.  Then I 
deleted those sites and programmatically created all the necessary 
production sites by a script.  I notice in the wsconfig.log file that when 
CF was installed it created both the /CFIDE and /cfdocs virtual 
directories for every web site that was on the server at the time.  So I 
guess it's expected.

Which also begs the question - is there some functionality that relies on 
the /cfdocs mapping?  I always thought that from a security standpoint it 
was undesirable to have cfdocs installed, so having the installer create 
this mapping on _every_ site seems like an odd move.

The thing about needing /CFIDE that strikes me a odd is that it contains 
the CF Administrator application, so that the Administrator becomes 
accessible from every web site on the server.  Yes, it's up to the system 
administrator to make sure the CF Administrator is properly secured, but 
this still seems rather a lax approach.  The CF Administrator isn't be 
needed on every site.



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287923
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How to move CFIDE in CF8?

[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 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 Administrator bombs.  I put everything back the way it was and went
 into the Administrator and see that it CF has an unchangeable logical
 directory mapping of /CFIDE pointing at the physical location.  I'm
 guessing that's the problem.

 How can I move the folder and change the mapping of /CFIDE?


I'm guessing now that this will require the editing of an XML 
configuration file.  Anyone know which one contains the CF mappings?  Does 
CF use the registry at all for configuration settings? 


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287924
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Can the server-wide missing template handler be overridden?

[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 
if it can't find it, the only way I can figure out how to make this work 
is by creating a CF mapping to the directory containing the cf file I want 
to execute.

Unlike CF5, you don't specify the file's path directly, so it appeared to 
me that I might be able to override the missing error handler on 
individual web sites.  On one site I tried creating a physical directory 
with the same name as the CF mapped directory, but it's not recognized.  I 
must missing something here - why not just specify the actual path to the 
file as in CF5? 


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287499
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF 7 - What JVMs are supported

[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...
 http://www.adobe.com/products/coldfusion/coldfusion7/pdfs/cfmx7_systemsupportmatrix.pdf

 On 22/08/07, Bosky, Dave [EMAIL PROTECTED] wrote:
 Which JVM's does CF7 support?


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286868
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

OT: Microsoft IIS 6 FTP

[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 _design_ virtual FTP 
directories created in IIS are not listed in directory listings, making 
them invisible to FTP clients.  Huh???

Are there workarounds to make IIS FTP usable?



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286865
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Microsoft IIS 6 FTP

[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 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.
 
 We have been consolidating our Windows FTP Servers into a single Serv-U
 system here.  Serv-U, in my experience, is far more flexible.
 
 First thing I run into is that apparently by _design_ virtual
 FTP directories created in IIS are not listed in directory 
 listings, making them invisible to FTP clients.  Huh???
 
 For a virtual folder to show up to the user in a directory listing, an
 actual folder with the same name has to exist on the server.  The
 virtual part only kicks in when they try to CD to that folder.  This
 is one of many weird quirks you will run into.  You're not in Kansas
 anymore...


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286875
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Running CF7 on 64 bit Windows

[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. Connecting to
 a 64 bit webserver is not supported.


So what would be the recommended course of action given the current server 
setup?

Reconfiguring the server by reformatting and installing 32 bit Win2k3 
Server would be a possibility, although not a terribly attractive one.

Should we run Apache server?



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284409
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Running CF7 on 64 bit Windows

[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 searches lead me to not a lot of concrete information.  The 
configuration is not fully supported by Macromedia, whatever that means. 
Are there no workarounds?  Do we have to either wait for CF8 (surely 64 
bit is fully supported in CF8, right?) or else install 32 bit Win2k3 
Server?


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284402
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Query of Query with dates

[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 RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282397
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Upgrade to CF7 now?

[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 would it be better to wait for CF8 to be released?  I don't fancy going 
through two major projects of porting to a new generation of CF server in 
the course of a year.  For those using CF8, is it proving to be a lot of 
work to go from 7 to 8, or is it relatively painless? 


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281421
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Sort array of structs on column?

[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.

Is there an easy way to do something like this?  I also thought about the 
possibility of building a new query instead of using an array, and then 
using a query of queries to do the sorting. 


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280193
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Development Machine Setup

[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 03, 2007 2:59 PM
Subject: Re: Development Machine Setup


 Thanks Neil,

 Pretty much what I thought to be honest - I'll have a play about with 
 some
 of the VM solutions available.

 As a 1 man shop I'm not entirely sure what I'm going to do with this
 bd.netlicence but hey a freebie is a freebie so I'm sure I'll come up
 with
 something.


~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279957
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Moving from CF5 on Windows to CFMX on Linux

[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 the same time may be 
too much.

We use about a dozen CFX tags, so that's one issue to deal with.

Most of our data is in MySQL.  But another issue we face is that a couple 
of legacy applications use Access via ODBC.  The databases are complex 
enough and the applications so seldom used that migrating these to MySQL 
isn't really feasible.  I'm not sure what that means should we move to 
Linux.

What other problems might we expect to encounter? 


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278999
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

MySQL on CF server

[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 the same machine?  The new server will likely be far more 
powerful than needed given our traffic level and the complexity of our web 
sites - either a single or dual dual-core Xeon, 4GB memory, 10k RPM SAS 
disks.  I suspect MySQL will run faster on this machine, even with CF and 
IIS running along side, and it eliminates the 100 Mbps network connection 
between two machines.

Any thoughts or recommendations? 


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278531
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: MySQL on CF server

[Jim McAtee]

Appreciate the recommendation, but we've always owned and maintained our 
own servers and have a partial cabinet in a pretty nice colocation 
facility.


- Original Message - 
From: Hatem Jaber [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, May 17, 2007 5:02 PM
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]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Thursday, May 17, 2007 7:00 PM
 Subject: MySQL on CF server


 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 the same machine?  The new server will likely be far more
 powerful than needed given our traffic level and the complexity of our 
 web
 sites - either a single or dual dual-core Xeon, 4GB memory, 10k RPM SAS
 disks.  I suspect MySQL will run faster on this machine, even with CF 
 and
 IIS running along side, and it eliminates the 100 Mbps network 
 connection
 between two machines.

 Any thoughts or recommendations? 


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278534
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: MySQL on CF server

[Jim McAtee]

Thanks Matt.

SMTP and POP are on a separate server, and web stats on another.  One 
issue we've always had with multiple boxes powering a web site is that 
when one server is down then the web site is down.  Say CF/IIS on one and 
MySQL on another.  Without clustering or other failover measures this (to 
my thinking) effectively doubles the probability that the site will be 
down at any given time due to a hardware failure or the need to reboot 
either one of the machines.


- Original Message - 
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, May 17, 2007 5:22 PM
Subject: Re: MySQL on CF server


 It will run, but no matter how overbuilt your server is, you'll get
 better reliability from two separate servers.

 For years I ran a setup like you are describing... big dual-processor
 behemoth with uber-SCSI drives and gobs of memory.  The theory was to
 overbuild the single box and use all that extra capacity to run
 multiple apps off the same box (in my case that was CF/IIS, mySQL and
 SmarterMail/ASSP).

 When I eventually outgrew that, I went to two behemoths and put CF/IIS
 alone to itself, moving db and mail/antispam to its own box.

 Reliability went WAY up.

 Later, I decided to go with a lower-cost approach:  A mid-grade build
 for web/CF (dual Xeon, 2gb, 1 73gb SCSI drive), and a single cheapo
 server for mySQL, another for mail, another for DNS/antispam and so
 on.  I wound up spending less for *five* 'little' servers that each
 did only one or two things ($480/month) than I did for Godzilla and
 Megalon ($850/month for both) ... and reliability went from 'pretty
 darn reliable' to 'rock solid forever and ever'.  I personally would
 never go back to doubling and tripling up like that if I could help
 it.  My server setup:

 LARRY
   primary DNS
   statistics (smarterstats)
   backup for all the other servers (synchback, mySQL via sqlYog 
 scheduled jobs)
 CURLY
   CF-generated smtp (smartermail)
   antispam gateway for human-generated mail (ASSP)
 MOE
   mySQL
 SHEMP
   CF
   IIS
 JOE
   Secondary 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 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 the same machine?  The new server will likely be far more
 powerful than needed given our traffic level and the complexity of our 
 web
 sites - either a single or dual dual-core Xeon, 4GB memory, 10k RPM SAS
 disks.  I suspect MySQL will run faster on this machine, even with CF 
 and
 IIS running along side, and it eliminates the 100 Mbps network 
 connection
 between two machines.

 Any thoughts or recommendations?




 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278537
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[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 hyphen-delimited list. The last item in the list needs to be 
 flagged if it contains OL1, OL2, etc.

 Just if it contains the OL at all, I need to flag it as an online 
 course.

 Here's what I'm using now, what's a better way to handle it?

 cfif ListLast(getSection.section, -) CONTAINS OL
 cfset isOLCourse = true
 /cfif


cfset isOLCourse = Left(ListLast(getSection.section, -), 2) is OL 


~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276494
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Query Problem

[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) unsigned,
albumid int(10) unsigned

artist
-
artistid int(10) unsigned NOT NULL auto_increment,
name varchar(255)

artisttrack
-
artistid int(10) unsigned
trackid int(10) unsigned


There can multiple artists per track (e.g. the album Back to Back by 
Duke Ellington and Johnny Hodges).  For now, forget about albums that 
might have different artist lineups per track.  I'd like a listing that 
shows _all_ of the artists on an album.  Can this be done in a single 
query, and in SQL (MySQL) only, without any manipulation by CF after the 
query?

Here's what I have, but it can return only a single artist for the album:

SELECT ar.name,
   a.albumtitle,
   a.year
FROM album a
 LEFT JOIN track t ON t.album = a.albumid
 LEFT JOIN artisttrack at ON at.trackid = t.trackid
 LEFT JOIN artist ar ON ar.artistid = at.artistid
GROUP BY a.albumid
ORDER BY a.albumtitle;











~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259244
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: I am soooo pissed

[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 networksolutions.


 Go Figure

 Doug



 - Original Message - 
 From: Andy Matthews [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Tuesday, September 05, 2006 1:38 PM
 Subject: RE: I am s pissed


 Just wait. The person bidding might default.

 !//--
 andy matthews
 web developer
 certified advanced coldfusion programmer
 ICGLink, Inc.
 [EMAIL PROTECTED]
 615.370.1530 x737
 --//-

 -Original Message-
 From: Doug Brown [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 05, 2006 2:25 PM
 To: CF-Talk
 Subject: Re: I am s pissed


 No, it was just a regular type name I suppose. gobuddy.com the auction 
 is
 now at 3,800.00


 - Original Message -
 From: Snake [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Tuesday, September 05, 2006 1:22 PM
 Subject: RE: I am s pissed


  Was it something CF related, as I have tons of CF related domains
 
  -Original Message-
  From: Doug Brown [mailto:[EMAIL PROTECTED]
  Sent: 05 September 2006 20:13
  To: CF-Talk
  Subject: OT: I am s pissed
 
  I hate all these auctions for domain names. I was after a domain that
  expired and was being auctioned at snapnames, I had a limit at what I
 would
  pay and it was 1,000.00 and the damn thing is already up to 2,600.00 
  Oh
  well, I guess the search continues for something good.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252114
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: MyODBC and blobs with text

[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 twos lets me (more or less) get the original ASCII string.  The 
problem I'm running into is that I can only retrieve strings of a maximum 
size of 18 ASCII characters (36 hex characters).  Any ideas of what's 
going on?  I looked for something within the MySQL ODBC driver setup for 
the DSN, but didn't see anything promising. 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249683
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

MySQL query help

[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 don't 
have the id in the second table, only the name.  Also, the 
contributor_sort table may not have matches for all rows in the 
contributors table. 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242292
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Using IIf() in query value

[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 simplification of the query the single quote within the first 
string is escaped, but the second one is not, causing an error.

form.name = John O'Mara
authresponse.http_response = 1|1|1|John O'Mara|approved

cfquery datasource=#dsn#
INSERT INTO cctransactions (
  name,
  response
  )
VALUES (
  '#form.name#',
  '#IIf(StructKeyExists(authresponse, http_response),
authresponse.http_response,
DE())#'
  )
/cfquery 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242161
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Only update DB if data has changed?

[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 sure you gain much in the way of database activity, since 
you'll generally have to look up the record(s) after the page is 
submitted, then do comparisons, then conditionally do your updates.  Which 
is a lot of work to save what may not be much processing.  For 30 records 
it would require 30 select queries, plus your updates, which may save you 
little over just doing 30 updates and being done with it.

One technique to avoid the lookup queries on the server is to do 
everything on the client side using javascript, comparing data when the 
form is submitted, then turning on flags (sent as hidden fields) telling 
you whether you need to update a record.  This is also a lot of work, and 
is subject to the same caveats as relying soley on client side data 
validation.  In a controlled environment such as on an intranet, though, 
it may be acceptable.


- Original Message - 
From: Andy Mcshane [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, May 26, 2006 3:25 AM
Subject: Only update DB if data has changed?


 Hi all, does anybody have any ideas how I could best implement the 
 following;

 I have a page that loads anything up to about 30 individual records at a 
 time. Each record consists of 17 fields of data. All the records are 
 displayed on the page to give the user the option of editing any 
 individual field. When the user then submits the page I need to be able 
 to work out which records have had data changed and only do database 
 updates for those specific records. Having an individual submit for each 
 record is not an option, the whole page must be submitted as one but 
 only records that have changed should be updated. Can anybody suggest a 
 method for doing this?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241549
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Server Backup Solutions

[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 
filename (incorporating the date).  I do a weekly full backup, then 
incremental daily backups.


- Original Message - 
From: Mike Klostermeyer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, May 22, 2006 1:58 PM
Subject: RE: Server Backup Solutions


 Thanks.  Now thinking about it, an ideal solution would be able to 
 manage,
 say, a weeks worth of daily backups, on a rotating basis.  Any other 
 ideas?

 Mike

 -Original Message-
 From: Adkins, Randy [mailto:[EMAIL PROTECTED]
 Sent: Monday, May 22, 2006 2:15 PM
 To: CF-Talk
 Subject: RE: Server Backup Solutions


 I use the standard NT Backup that comes with Windows.
 I made sure my drive mappings were setup and then scheduled
 Backups from that to a tape.

 Now ideally would be awesome to have the auto-tape changer
 System. I have seen it before but the project I am on, well
 Lets say we do with what we have or what we can scrounge for.




 -Original Message-
 From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
 Sent: Monday, May 22, 2006 3:07 PM
 To: CF-Talk
 Subject: OT: Server Backup Solutions

 Curious if anyone has some suggestions for server backup software.  I
 need to backup (probably to a separate drive cage) web servers and
 database servers in a Microsoft environment, and looking for any input
 or experiences.  I don't need much, but some requirements are to be able
 to put backup process on a scheduler, compression, and obviously, the
 cheaper the better.  Thanks.

 Mike







 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241172
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

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

[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 = CreateDate(Year(Now()), Month(Now()), 1)
cfset threemonths = DateAdd(m, 3, startdate)
cfset enddate = CreateDate(Year(threemonths), Month(threemonths),
DaysInMonth(threemonths))

WHERE event_date BETWEEN startdate AND enddate



- Original Message - 
From: Les Mizzell [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, May 17, 2006 10:28 PM
Subject: Re: ARGH! - Three Months in the future query problem


 Duh!

 This does it:

 WHERE event_date  #threemonths# and
   event_date = #startDATE#

 See! Getting away from the computer and thinking about things while
 walking your dogs really helps!!


 cfset startDATE = #now()#
 cfset threemonths = DateAdd(m,3,startDATE)

 cfquery name=calendar
 SELECT
 id, event_date, event_name FROM events
 WHERE month(event_date) = #month(startDATE)#
   and event_date  #threemonths#
   and year(event_date) = #year(startDATE)#
 ORDER BY event_date,event_time ASC
 /cfquery 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240877
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

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

[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 problem


 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 = CreateDate(Year(Now()), Month(Now()), 1)
 cfset threemonths = DateAdd(m, 3, startdate)
 cfset enddate = CreateDate(Year(threemonths), Month(threemonths),
DaysInMonth(threemonths))

 WHERE event_date BETWEEN startdate AND enddate



 - Original Message - 
 From: Les Mizzell [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Wednesday, May 17, 2006 10:28 PM
 Subject: Re: ARGH! - Three Months in the future query problem


 Duh!

 This does it:

 WHERE event_date  #threemonths# and
   event_date = #startDATE#

 See! Getting away from the computer and thinking about things while
 walking your dogs really helps!!


 cfset startDATE = #now()#
 cfset threemonths = DateAdd(m,3,startDATE)

 cfquery name=calendar
 SELECT
 id, event_date, event_name FROM events
 WHERE month(event_date) = #month(startDATE)#
   and event_date  #threemonths#
   and year(event_date) = #year(startDATE)#
 ORDER BY event_date,event_time ASC
 /cfquery 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240878
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How do I detect day lights savings?

[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) {
  var yr = Year(dt);
  var DSTBegin = CreateDateTime(yr, 4, 8 - DayOfWeek(CreateDate(yr, 4, 
7)), 2, 0, 0);
  var DSTEnd = CreateDateTime(yr, 10, 32 - DayOfWeek(CreateDate(yr, 10, 
31)), 2, 0, 0);
  return (dt gte DSTBegin) and (dt lt DSTEnd);
}
/cfscript


- Original Message - 
From: Tony [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, May 11, 2006 1:03 PM
Subject: Re: How do I detect day lights savings?


 :) never is so fun to say tho'

 tw

 On 5/11/06, Paul Hastings [EMAIL PROTECTED] wrote:
 Tony wrote:
  it works here in america, where the application i use it for will
  ALWAYS reside :)

 in the i18n world you just violated a big honking taboo, never say
 never. now you're screwed. probably have to make it i18n first thing
 tomorrow ;-)

  and yeah, congress... ill change it when it comes to that.

 you'll remember? lying on the fairway concussed by some errant golf 
 ball?

  so no, its not i18n friendly, but i bet you could help me get it 
  there!

 no need, the timezone CFC does most stuff folks need or have asked for.
 though lately i've started to recommend using icu4j's timezone class as
 the base for the CFC as it's olson data (and other tasty bits) get
 updated way way more frequently than core java. and in any case 
 updating
 it is kind of difficult w/cf but you could get caught w/your pants 
 down.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240290
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

CF Server RDS on Port 80

[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: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF Server RDS on Port 80

[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 just processes requests that your web server receives. Basically, if 
 a
 request ends in .cfm, etc, your web server passes it to the CF server. 
 If a
 request asks specifically for /CFIDE/Main/ide.cfm, your web server 
 passes it
 to RDS.

I see... So something like saving a file from within the HomeSite editor 
is actually sent as a form post and processed by the CF server?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238430
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Registry hosed?

[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 
using Terminal Services for administration purposes.  Expanding the 
registry size in Windows hasn't helped, but I'm not certain that it's 
actually being expanded.  The registry was at 215 MB in size with a 256MB 
limit, and we expanded it to a 512 MB limit, but the size remains at 215 
MB.

I'm unable to delete any of the CF Client keys in the registry, either 
manually, by using reg.exe from the Resource Kit, or by CF script 
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17881). 
I've tried manually deleting keys both with and without CF and IIS 
actively running, with the same results.

CF Sites are running fine, but we're seeing some other problems.  If we 
try to save a scheduled task with a name longer than six characters, it 
doesn't get saved.  We can't get in to view CF logs in CF Administrator, 
getting an error:

--
Unable to delete the registry entry in branch 
hkey_local_machine\software\allaire\coldfusion\currentversion\logging\logViewerFilters\CurrentFilter
A problem was encountered trying to access the system registry. Error 
number 1019 occurred.

--

This is the same error that the CF script throws when trying to delete the 
client variables.  Any ideas how to fix this mess, or is the registry 
completely fubar?




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237398
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Registry hosed?

[Jim McAtee]

Registry permissions in the Clients branch appear to be correct. 
Administrators and System have full permissions on the key and subkeys.


- Original Message - 
From: Dawson, Michael [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, April 10, 2006 5:22 PM
Subject: RE: 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-Talk
 Subject: Registry hosed?

 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
 using Terminal Services for administration purposes.  Expanding the
 registry size in Windows hasn't helped, but I'm not certain that it's
 actually being expanded.  The registry was at 215 MB in size with a
 256MB limit, and we expanded it to a 512 MB limit, but the size remains
 at 215 MB.

 I'm unable to delete any of the CF Client keys in the registry, either
 manually, by using reg.exe from the Resource Kit, or by CF script
 (http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17881).

 I've tried manually deleting keys both with and without CF and IIS
 actively running, with the same results.

 CF Sites are running fine, but we're seeing some other problems.  If we
 try to save a scheduled task with a name longer than six characters, it
 doesn't get saved.  We can't get in to view CF logs in CF Administrator,
 getting an error:

 --
 Unable to delete the registry entry in branch
 hkey_local_machine\software\allaire\coldfusion\currentversion\logging\lo
 gViewerFilters\CurrentFilter
 A problem was encountered trying to access the system registry. Error
 number 1019 occurred.

 --

 This is the same error that the CF script throws when trying to delete
 the client variables.  Any ideas how to fix this mess, or is the
 registry completely fubar?

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237404
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Client Variables in MySQL

[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, or are MyISAM tables sufficient?

 Yes:
 http://dev.mysql.com/doc/refman/4.1/en/internal-locking.html?ff=nopfpls


Yes, what?  A or B?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237241
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Client Variables in MySQL

[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: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Client Variables in MySQL

[Jim McAtee]

But does CF5 utilize transactions (if available) for client variable 
storage?


- Original Message - 
From: Munson, Jacob [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, April 07, 2006 4:36 PM
Subject: RE: Client Variables in MySQL


 It's been a while, but I'm 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 CF5.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237213
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

How to keep unrelated CFML tags from repeating includes?

[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 
the request scope, but that obviously requires all tags to play nicely 
together.  Is there a way to do it without the tags knowing anything about 
one another?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235383
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

SQL IN and cfqueryparam lists

[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
   value=#ValueList(anotherquery.recordid)#
   list=Yes
   null=#YesNoFormat(not Len(ValueList(anotherquery.recordid)))#)


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234742
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54