date:20051030

AFternoon,

OK, here's what is working:
1. All form fields are from drop-down lists
2. cfif statements to account for the fact
that you can decide *not* to choose anything
   (xox is the default value)

Is there a better way to refine this?


SELECT
   Shows.Title,
   Credits.PlayerID,
   Players.FName,
   Players.LName,
   Shows.Network,
   Credits.ShowID,
   Shows.Genre
FROM
   Shows
   INNER JOIN Credits ON (Shows.ShowID = Credits.ShowID)
   INNER JOIN Players ON (Credits.PlayerID = Players.PlayerID)
WHERE
   Credits.CreditType like '%#form.credittype#%'

   cfif IsDefined(form.network) AND #form.network# NEQ xox
AND  Shows.Network ='#form.network#'
   /cfif

   cfif IsDefined(form.category) AND #form.category# NEQ xox
 AND Shows.Category = '#form.category#'
   /cfif

   cfif IsDefined(form.genre) AND #form.genre# NEQ xox
 AND Shows.genre like '%#form.genre#%'
   /cfif

  Order by LName



-- 
---
Les Mizzell

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222643
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: SHOUTING

2005-10-30 Thread Webmaster at FastTrack On Line

Maybe the Lcase function?

Jenny

- Original Message - 
From: Saturday (Stuart Kidd) [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, October 24, 2005 6:02 PM
Subject: stop: SHOUTING

 Hi guys,

 Just wondering if anyone knows a good way to recognise when all the
 characters are capitalised?  Some users love putting text in CAPS and
 it just looks awful when it's displayed on screen.

 Any help I'd be grateful.

 Thanks,

 Saturday

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222644
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: OT - Complex SQL

2005-10-30 Thread Dina Hess

Jillian,
 If you're using DB2 UDB, you can use the date() function to pass in your
date:
 where table_1.expiry_date = date('2005-12-31') ...
 Dina

 On 10/28/05, Dawson, Michael [EMAIL PROTECTED] wrote:

 Along these lines, you might want to look into DB2's data dictionary.
 On our AS400, you can find the data dictionary in the qsys2 libraries.
 Look for a table named syscolumns. That table will give you the
 details on any column in the database.

 I created a simple DB2 datadictionary view a few years ago and it comes
 in quite handy.

 M!ke

 -Original Message-
 From: Jillian Koskie [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 28, 2005 5:41 PM
 To: CF-Talk
 Subject: RE: OT - Complex SQL

 You're so right... Anybody happen to now offhand (I'm off to search
 after I send this message) what the date format is for DB2?

 I'm just running this at the command line, so no need for any CF
 stuffs... But unfortuantely also can't take advantage of CF stuffs.

 -Original Message-
 From: Dawson, Michael [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 28, 2005 4:16 PM
 To: CF-Talk
 Subject: RE: OT - Complex SQL

 You need single quotes around each of your values in the IN clause.

 snip
 AND table_1.table_id IN ('value1','value2','value3') /snip

 The date formats may be wrong, too. Check the actual data in the
 database and/or use createODBCDateTime() and definitely use
 CFQUERYPARAM. It will make your job a bit eaiser.

 Either way, I would remove the dates from your WHERE claus, fix the IN
 clause, then run the query. See if you get any results with very
 limited filtering, first.

 Then, go from there and add more filtering as needed.

 M!ke

 -Original Message-
 From: Jillian Koskie [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 28, 2005 5:12 PM
 To: CF-Talk
 Subject: OT - Complex SQL

 Okay, I think it's because it is Friday at 4... can somebody help me
 out?

 SELECT table_1.expiry_date,
 table_3.expiry_date
 FROM table_3
 JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
 JOIN table_1 ON table_1.table1_key = table_2.table1_key
 WHERE table_1.expiry_date = 'Dec 31, 2005'
 AND table_3.expiry_date = 'Dec 31, 2005'
 AND table_1.table_id IN ('value1,value2,value3')

 This isn't returning results, and it should... where is my syntax
 incorrect?

 --
 Jillian





 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222645
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: Big Honking Queries Make Me Want To Scream

2005-10-30 Thread Joseph Flanigan

One technique to use for complex joins is to build the joins in 
views. (I rarely use a join in a cfquery)  By  using views, the 
execution plan for the join is stored with the view and does not have 
to calculated with the dynamic SQL in a cfquery. By using views for 
joins, it allows focusing on the results of the joins before adding 
other conditions.

For example:

CREATE VIEW dbo.vShowDetail
AS
SELECT P.FNname, P.LName, C.CreditType, S.Title, S.Network, 
S.[Desc], SM.SubjectType, S.Logline
FROM dbo.tCredits C INNER JOIN
   dbo.tPlayers P ON C.PlayerID = P.PlayerID INNER JOIN
   dbo.tShows S ON C.ShowID = S.ShowID INNER JOIN
   dbo.tSubjectMatter SM ON S.ShowID = SM.ShowID
ORDER BY P.LName

  Then  the cfquery is simpler

SELECT TOP 100 PERCENT FNname, LName, CreditType, Title, Network, Logline
FROM dbo.vShowDetail
WHERE (Network = 'A') AND (Title = 'B') AND (CreditType = 'C')


At 05:27 PM 10/28/2005, you wrote:
Try the ColdFusion MX Bible it has some very good chapters SQL

  Is there a damned good book/tutorial somewhere on writing these things?
 
 Using Complex SQL Statements in Coldfusion for Idiots ??
 
 --
 ---
 Les Mizzell



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222646
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

cfcdev list status

2005-10-30 Thread Raymond Camden

(Forgive the OT msg)

I am aware of the bombing that has been going on the CFCDev list. I
am not sure iwhy/i it is happening though. It looks like the email
addresses that are no longer valid are having their failure notices
showing up on list. That should not happen, of course. I am manually
cleaning these people out when I can. I am going to open a ticket with
MailEnable since it also appears we may have hit the max number of
people for a mailing list, and obviously I want the list to grow.

However - I need to be away for most of today. So unfortunately I
can't do anything else right now. I deeply apologize for any trouble
this causes (boy do I love being an admin of a service ;) and I hope
to have things cleared away tonight.
--
===
Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com)

Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : ray.camdenfamily.com
Yahoo IM : cfjedimaster

My ally is the Force, and a powerful ally it is. - Yoda

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222647
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: Problem in a Simple webservice: 1D array works 2D fails

2005-10-30 Thread John C. Bland II

You may want to look at using custom types.

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?href=1549.htm

I was working on something similar and in research it seemed as if custom
types would fix it for me. That portion of the app hasn't been created yet
so I can't say yay or nay.

On 10/28/05, Will Tomlinson [EMAIL PROTECTED] wrote:

 Thanks to everyone else for suggesting other data structures that work. I
 did some testing and there is no problem with Structs of Structs and
 other
 combinations, but the designer wants as simple and portable a solution as
 possible, so it's back to see what I can do to make the 2D Array work.

 I don't know how it can get any simpler than a struct of structs.

 Will

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222648
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

Philosophy Q: SP's or CFQUERY?

2005-10-30 Thread Pete Ruckelshaus

I'm going back and tweaking a web app that I'm building and have
learned a few stored procedure tricks (my SP skills were pretty basic
before I started to play around).  As a result, I'm replacing a number
of CF queries (using cfqueryparam) with SQL Server stored procedures. 
Now, these are pretty much limited to the customer-facing (non-admin)
pages, though I'm using SP's in the admin where I already have them
written to return the rest sets that I need.

Realizing that SP's will give greater performance, the question is
this: Is it OK to write your most frequently run queries as SP's and
leave the rest of the site as straight SQL queries?  Or should I just
make the entire site SP's?

What I've been doing during development is writing straight SQL until
I get what I need, then I rewrite as a SP.  I've replaced a dozen or
so queries that are all on the customer-facing end of things, but
there are well over 100 queries still written as SQL on the admin
side, and it would take a bit of effort to convert (or merge into
existing SP's) those queries.

Pete

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222649
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 would I send an XML file to another server/application?

2005-10-30 Thread Ian Sheridan

Wow, thank you guys so much. I was not sure about the cfhttp thing.  
Much Much appreciated!

- Ian

On 10/27/05, Anthony Prato [EMAIL PROTECTED] wrote:
 I had a client who could not figure out how to send and xml post like
 Andy's example. On my recieving page I put this code to allow them to
 post as a named form field or an xml post.

 cftry
 cfset RequestXML = FORM.xmlbody
 cfcatch
 cfset RequestXML = GetHTTPRequestData().content
 /cfcatch
 /cftry

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222650
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: WAY OT: Configuring FCKEditor

2005-10-30 Thread Webmaster at FastTrack On Line

Hi Jay,

I'm having a real headache with this fck config, do you have any install 
notes I could take a look at please?  I've got it all working but the 
graphics upload :-S

Thanks, Jenny

- Original Message - 
From: Jay Greer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, October 28, 2005 6:39 PM
Subject: Re: WAY OT: Configuring FCKEditor


 (for versiion 2.1.1)

 /FCKEditor/editor/filemanager/browser/default/connectors/cfm/config.cfm

 Lines 9  11

 Good Luck!

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222651
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: cfcdev list status

2005-10-30 Thread Raymond Camden

Just an FYI, I'm running a queue cleaner and it is still in progress.
I've disabled the list for now. There are still messages in the
outgoing queue, so more will come out,  but it should be over soon.
Sorry for the trouble folks. I was going to open a ticket with
MailEnable, but they don't have a free support option - lovely.

On 10/29/05, Raymond Camden [EMAIL PROTECTED] wrote:
 (Forgive the OT msg)

 I am aware of the bombing that has been going on the CFCDev list. I
 am not sure iwhy/i it is happening though. It looks like the email
 addresses that are no longer valid are having their failure notices
 showing up on list. That should not happen, of course. I am manually
 cleaning these people out when I can. I am going to open a ticket with
 MailEnable since it also appears we may have hit the max number of
 people for a mailing list, and obviously I want the list to grow.

 However - I need to be away for most of today. So unfortunately I
 can't do anything else right now. I deeply apologize for any trouble
 this causes (boy do I love being an admin of a service ;) and I hope
 to have things cleared away tonight.
 --
 ===
 Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com)

 Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

 Email: [EMAIL PROTECTED]
 Blog : ray.camdenfamily.com
 Yahoo IM : cfjedimaster

 My ally is the Force, and a powerful ally it is. - Yoda



--
===
Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com)

Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : ray.camdenfamily.com
Yahoo IM : cfjedimaster

My ally is the Force, and a powerful ally it is. - Yoda

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222652
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

Others have already answered, but another idea is to just write your
own cfdump. It wouldn't be too hard. :) Another idea - write a custom
tag that calls cfdump and all your tag does is a regex on the result
of cfdump - ie - a wrapper. Just some random ideas.:)

On 10/28/05, Ryan Guill [EMAIL PROTECTED] wrote:
hey ray, somewhat on and off topic,

do you know if it is possible to modify the cfdump structure?
particularly the stylesheet. I had a developer ping me the other day
about the cfdump stylesheet color specifications did not use pound
signs, something like color: 336633;

He said it was using a browser that wasn't liking it or something. As
far as I can tell there is no way, thats an innerds of cf thing, but
just wondered if you knew if it was possible.

On 10/28/05, Raymond Camden [EMAIL PROTECTED] wrote:
Something else to consider. My starfish project handles debugging
info, stuff like the time it took to do X. It does NOT handle erorrs.

However...

It IS possible to modify error behaviour. I've written to blog entries on
this.

This entry:
http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modifications

Tells you how ot make stack traces collapse in Firefox, like they do in IE.

This entry:
http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-Templates-in-CFMX-701
Will make it so if you use a struct key that doesn't exist, the error
will tell you which keys _do_ exist in the struct, which is VERY
helpful. Ie, instead of, you can't do foo.goo, you get, you can't do
foo.goo, but moo and zoo are valid keys.

This is ALL something you do NOT want to do on a production server,
but it may be of use to you.

On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
Some good points Jim,...thanks...good points to ponder for sure..

Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222653
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: debugging complaint

2005-10-30 Thread Snake

 actually cfdump is just a regular custom tag, altho it is encrypted.
But you could effectively replace it.

Russ

On 10/28/05, Ryan Guill [EMAIL PROTECTED] wrote:
 hey ray, somewhat on and off topic,

 do you know if it is possible to modify the cfdump structure?
 particularly the stylesheet.  I had a developer ping me the other day 
 about the cfdump stylesheet color specifications did not use pound 
 signs, something like color: 336633;

 He said it was using a browser that wasn't liking it or something.  As 
 far as I can tell there is no way, thats an innerds of cf thing, but 
 just wondered if you knew if it was possible.

 On 10/28/05, Raymond Camden [EMAIL PROTECTED] wrote:
  Something else to consider. My starfish project handles debugging 
  info, stuff like the time it took to do X. It does NOT handle erorrs.
 
  However...
 
  It IS possible to modify error behaviour. I've written to blog entries
on this.
 
  This entry:
  http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modi
  fications
 
  Tells you how ot make stack traces collapse in Firefox, like they do in
IE.
 
  This entry: 
  http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-
  Templates-in-CFMX-701 Will make it so if you use a struct key that 
  doesn't exist, the error will tell you which keys _do_ exist in the 
  struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, 
  you get, you can't do foo.goo, but moo and zoo are valid keys.
 
  This is ALL something you do NOT want to do on a production server, 
  but it may be of use to you.
 
 
  On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
   Some good points Jim,...thanks...good points to ponder for sure..
  
   Bryan Stevenson B.Comm.
   VP  Director of E-Commerce Development Electric Edge Systems 
   Group Inc.
   phone: 250.480.0642
   fax: 250.480.1264
   cell: 250.920.8830
   e-mail: [EMAIL PROTECTED]
   web: www.electricedgesystems.com
  
  
 
 

 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222654
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: Unusual Image Rotation Request

 adding arbitrary rotation angles would be pretty trvial
to your choice of image manipulators, as long as you can get the
source.

I wouldn't say so: rotation by an angle being a multiple of 90º is 
pretty trivial, because the transformation can be reduced to some 
symetry. All pixels are preserved, and no new pixel has to be created.
Any angle rotation is quite a different and more complex algorithm, this 
is why most tools provide only 90º rotations.

 -- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222655
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

OT: CSS editor for Eclipse

2005-10-30 Thread Phill B

Is there a good CSS editor for Eclipse? I downloaded one and all it
seemed to do was set Eclipse to be the default editor of css files.

--
Phil

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222656
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: SHOUTING

2005-10-30 Thread Bobby Hartsfield

 Maybe the Lcase function?

I dont believe thats what the lcase function does ;)

Just compare the strings uppercase form to its original form...
Eg: find(ucase(str), str) 

It will return 1 if the string is all uppercase, 0 if it is not...

Of course... one lowercase letter in the middle of 1 uppercase letters
is not all uppercase though :)

You could easily write a looping function to count the number of uppercase
characters and compare that with the over all length of the string. Then you
could base your decision to allow/disallow the string on the percentage of
upper case characters vs lower case
 
Steps:
Loop over the string while #refind([A-Z], str, start)#. Each time #start#
will be the results of the refind()and a counter would be incremented by 1
(the counter will hold the number of uppercase characters in the end)

I've gotta run or I'd test out some actual code for you here. I'll be glad
to do I later if you want something like this but have trouble writing it.

Cheers

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Webmaster at FastTrack On Line
[mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 30, 2005 1:12 AM
To: CF-Talk
Subject: Re: SHOUTING

Maybe the Lcase function?

Jenny

- Original Message - 
From: Saturday (Stuart Kidd) [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, October 24, 2005 6:02 PM
Subject: stop: SHOUTING


 Hi guys,

 Just wondering if anyone knows a good way to recognise when all the
 characters are capitalised?  Some users love putting text in CAPS and
 it just looks awful when it's displayed on screen.

 Any help I'd be grateful.

 Thanks,

 Saturday


 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222657
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: Unusual Image Rotation Request

I'm not saying build your own pixel rewriter.  I'm saying that most
tools only expose multiples of 90 because that's good enough 99.999%
of the time.  Pretty much any tool is going to be build on top of a
graphics library of some sort, and I've yet to see such a library that
doesn't support arbitrary rotation angles.  So it'd just be a matter
of making the CFC or CF/CFX tag leverage that capability.

For example, Alagad Image Component uses the Java 2D libraries, which
certainly support arbitrary rotation, though I don't know if AIC
exposes it.  If it's not there, adding it would be trivial.  I suspect
that many (most?) other tools work in similar fashion.

cheers,
barneyb

On 10/30/05, Claude Schneegans [EMAIL PROTECTED] wrote:
  adding arbitrary rotation angles would be pretty trvial
 to your choice of image manipulators, as long as you can get the
 source.

 I wouldn't say so: rotation by an angle being a multiple of 90º is
 pretty trivial, because the transformation can be reduced to some
 symetry. All pixels are preserved, and no new pixel has to be created.
 Any angle rotation is quite a different and more complex algorithm, this
 is why most tools provide only 90º rotations.



--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222658
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: OT: CSS editor for Eclipse

check csseditor.sourceforge.net

I haven't used it in a while (prefering the one included in
MyEclipse), but it used to, and it worked well enough.

cheers,
barneyb

On 10/30/05, Phill B [EMAIL PROTECTED] wrote:
 Is there a good CSS editor for Eclipse? I downloaded one and all it
 seemed to do was set Eclipse to be the default editor of css files.

 --
 Phil

--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222659
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: Philosophy Q: SP's or CFQUERY?

I'd use them only where there is a proven necessity.  I.e. where the
performance gains (demonstrated by load testing) are worth the
trouble, or the security concerns are such that there's no other way.

SPs move your business logic out of your application and into the
database, which isn't necessarily a bad thing, but it does split the
code, which can make maintenance harder.  Careful design can mitigate
most of that concern, of course, but it's still added complexity that
shouldn't be brought on yourself for no good reason.

Single queries, in particular, ought never to be converted to SPs
unless it's a security concern, if you ask me.  The performance isn't
going to be any greater, since you still have to pass the recordset
back to CF and let it create a CF query object.

cheers,
barneyb

On 10/29/05, Pete Ruckelshaus [EMAIL PROTECTED] wrote:
 I'm going back and tweaking a web app that I'm building and have
 learned a few stored procedure tricks (my SP skills were pretty basic
 before I started to play around).  As a result, I'm replacing a number
 of CF queries (using cfqueryparam) with SQL Server stored procedures.
 Now, these are pretty much limited to the customer-facing (non-admin)
 pages, though I'm using SP's in the admin where I already have them
 written to return the rest sets that I need.

 Realizing that SP's will give greater performance, the question is
 this: Is it OK to write your most frequently run queries as SP's and
 leave the rest of the site as straight SQL queries?  Or should I just
 make the entire site SP's?

 What I've been doing during development is writing straight SQL until
 I get what I need, then I rewrite as a SP.  I've replaced a dozen or
 so queries that are all on the customer-facing end of things, but
 there are well over 100 queries still written as SQL on the admin
 side, and it would take a bit of effort to convert (or merge into
 existing SP's) those queries.

 Pete

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222660
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: WAY OT: Configuring FCKEditor

2005-10-30 Thread Jay Greer

Hi Jenny:

Sorry for the delayed reply.
Yeah, I was having a devil of a time, too.

This entry on Brian Rinaldi's Blog got me started.
http://tinyurl.com/cw7m8
After that it was trial  error ( error  error...).

Best of Luck!!!

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222661
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

CFC - best practice - locks and so on

2005-10-30 Thread Michel Deloux

Hi all

I'm looking for comments about cfc instantiation and the best
practices for cflock.

Please look this code used in my application.

When user enters in application i call a cfc.

In application.cfm:
---BEGIN application.cfm---
cfif not isDefined('session.Instantiated')
cfset session.ComponentVar =
createObject(component,components.app).init()
cfset session.qryAllProducts = session.ComponentVar.getAllProducts()  
several cfset with session variables related to all SELECT queries in cfc
/cfif
-END application.cfm--

In app.cfc:
---BEGIN app.cfc---
cfcomponent output=false
cfset init()
cffunction name=init access=public
cfreturn this
/cffunction
cffunction name=getAllProducts output=false access=public
hint=Get all products returntype=query
arguments list
cfquery name=qryAllProducts datasource=#application.DSN#
SELECT

FROM
Products
/cfquery
!--- query is loaded to session scope ---
cfset session.qryAllProducts = qryAllProducts 
cfreturn session.qryAllProducts
/cffunction
several CRUD operations
/cfcomponent
END app.cfc-

- This(using cfc in session scope) is a best practice?
- Need cflock? Where?
- It's possible to optimize this application? How?

Any help will be very appreciated.

Cheers

MD

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222662
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: SHOUTING

2005-10-30 Thread Bobby Hartsfield

Here ya go...

cfscript
function ucasecount(str)
{
ucount = 0;
ufinder = refind([A-Z], str);

while (ufinder neq 0)
{
ucount = ucount + 1;
ufinder = refind([A-Z], str, ufinder+1);
}
return ucount;
}
/cfscript

cfset strng = AbCdEfGhI

cfoutput#ucasecount(strng)#/cfoutput


The function returns a single numeric value. It's the number of uppercase
characters found in the string. (In the example string... 5). You could
easily add more to it such as getting the actual percent of uppercase
characters that the number represents but the easiest way would be to just
see if it's more than half the characters and do what you need to do.

Example:
cfset tooMnayUC = len(trim(strng)) lt (ucasecount(strng)*2)

The string is #len(strng)# characters long. Out of those #len(strng)#
characters, #ucasecount(strng)# characters are uppercase.brbr
Are there too many uppercase characters? b#tooMnayUC#/b


 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 30, 2005 11:38 AM
To: CF-Talk
Subject: RE: SHOUTING

 Maybe the Lcase function?

I dont believe thats what the lcase function does ;)

Just compare the strings uppercase form to its original form...
Eg: find(ucase(str), str) 

It will return 1 if the string is all uppercase, 0 if it is not...

Of course... one lowercase letter in the middle of 1 uppercase letters
is not all uppercase though :)

You could easily write a looping function to count the number of uppercase
characters and compare that with the over all length of the string. Then you
could base your decision to allow/disallow the string on the percentage of
upper case characters vs lower case
 
Steps:
Loop over the string while #refind([A-Z], str, start)#. Each time #start#
will be the results of the refind()and a counter would be incremented by 1
(the counter will hold the number of uppercase characters in the end)

I've gotta run or I'd test out some actual code for you here. I'll be glad
to do I later if you want something like this but have trouble writing it.

Cheers

...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Webmaster at FastTrack On Line
[mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 30, 2005 1:12 AM
To: CF-Talk
Subject: Re: SHOUTING

Maybe the Lcase function?

Jenny

- Original Message - 
From: Saturday (Stuart Kidd) [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, October 24, 2005 6:02 PM
Subject: stop: SHOUTING


 Hi guys,

 Just wondering if anyone knows a good way to recognise when all the
 characters are capitalised?  Some users love putting text in CAPS and
 it just looks awful when it's displayed on screen.

 Any help I'd be grateful.

 Thanks,

 Saturday


 





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222663
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: SHOUTING

2005-10-30 Thread Bobby Hartsfield

This one returns the percentage of the string that is uppercase. The string
explains my enthusiasm. ;)

cfscript
function ucasePercentage(str)
{
ucount = 0;
ufinder = refind([A-Z], str);

while (ufinder neq 0)
{
ucount = ucount + 1;
ufinder = refind([A-Z], str, ufinder+1);
}
return round((ucount / len(str)) * 100);
}
/cfscript

cfset strng = I Think I Am Having Way Too Much Fun With This Little
Script. It's Probably Because I've Been Forced To Write Nothing But .NET
Code For The Past Two Months. I Think My Project Manager Hates Me! LOL!

cfoutput
#ucasePercentage(strng)#% of this string is made up of uppercase characters.
/cfoutput


So now you can come up with what percentage of the string you want to allow
as uppercase and just check to see if #ucasePercentage(string)# is less than
that number. I don't know what kind of posts your users are making but be
aware that something like 'LOL' is 100% uppercase and probably legit. You
may also consider only checking for the uppercase percentage once the string
is longer than a specific number.


..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 30, 2005 12:40 PM
To: CF-Talk
Subject: RE: SHOUTING

Here ya go...

cfscript
function ucasecount(str)
{
ucount = 0;
ufinder = refind([A-Z], str);

while (ufinder neq 0)
{
ucount = ucount + 1;
ufinder = refind([A-Z], str, ufinder+1);
}
return ucount;
}
/cfscript

cfset strng = AbCdEfGhI

cfoutput#ucasecount(strng)#/cfoutput


The function returns a single numeric value. It's the number of uppercase
characters found in the string. (In the example string... 5). You could
easily add more to it such as getting the actual percent of uppercase
characters that the number represents but the easiest way would be to just
see if it's more than half the characters and do what you need to do.

Example:
cfset tooMnayUC = len(trim(strng)) lt (ucasecount(strng)*2)

The string is #len(strng)# characters long. Out of those #len(strng)#
characters, #ucasecount(strng)# characters are uppercase.brbr
Are there too many uppercase characters? b#tooMnayUC#/b


 
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.6/151 - Release Date: 10/28/2005
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222664
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: SHOUTING

2005-10-30 Thread Jim Davis

Nifty.

As further suggestions:

You might save metrics on this but not do anything at all at first.  That
way you could later go through and examine the messages occurring at certain
percentages and determine a good cut-off point.

You might also just find that your problem focuses on a very small number of
distinct people - smack them in line and you don't have to do anything.  ;^)
You might then just keep an eye on the statistics and warn people as needed.

You might also take the decision out of your hands by just warning people on
post.  Look at the message before it's submitted and present a warning
(Your message is 95% capital letters.  If you're shouting, please don't
shout.)

You can use the metrics collected (a simple log of messages which got the
warning would do) to check on how people are doing (are they honoring the
warning or not?)

For example sometimes we do shout.  Something like I've tried SCSI, IDE and
SATA and NOTHING WORKS!  Please HELP ME! might be forgiven.  ;^)  Letting
people know you're watching something can often curtail the behavior even if
you've no actual recourse for punishing the behavior.

Jim Davis




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222665
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: OT: CSS editor for Eclipse

2005-10-30 Thread Phill B

I cant seem to get it to do anything for me except open a CSS file. Am
I missing some thing or maybe some thing I need to configure? I'm
still new to Eclipse so who know what I may be doing wrong.

On 10/30/05, Barney Boisvert [EMAIL PROTECTED] wrote:
 check csseditor.sourceforge.net

 I haven't used it in a while (prefering the one included in
 MyEclipse), but it used to, and it worked well enough.

 cheers,
 barneyb

 On 10/30/05, Phill B [EMAIL PROTECTED] wrote:
  Is there a good CSS editor for Eclipse? I downloaded one and all it
  seemed to do was set Eclipse to be the default editor of css files.
 
  --
  Phil

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222666
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

New contest open

2005-10-30 Thread Raymond Camden

(If folks mind messages like this, just please let me know.)

For those who do not follow my blog, I recently wrapped up a
ColdFusion coding contest for beginners. Today I have announced a new
contest for intermediate-level developers. Details may be found here;

http://ray.camdenfamily.com/index.cfm/2005/10/30/Intermediate-ColdFusion-Contest

The prize for this contest is a fully licensed copy of CFMX Standard,
a 1.3k value. The contest will be open over the next two weeks. Good
luck.

--
===
Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com)

Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : ray.camdenfamily.com
Yahoo IM : cfjedimaster

My ally is the Force, and a powerful ally it is. - Yoda

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222667
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: Philosophy Q: SP's or CFQUERY?

2005-10-30 Thread Dawson, Michael

I went through the route of inline SQL, then to SPs, and now I'm back to
inline SQL.  (When I say inline, I mean anything other than SPs.)

We use many related DBs on our SQL Server.  Many queries require joins
across DBs.  SPs caused us all kinds of problems when we moved DBs from
one server to another.  I decided it was best to just leave the SQL
statements in the application server and not try to create SPs.

The real plan is to put most, if not all, SQL statements within CFCs
thereby creating some sort of encapsulation.  SPs are great in the fact
that you can return multiple recordsets at once.  I miss that feature,
but not enough to use them again.

If you desire using SPs, then I would say you are doing it the right way
of creating your SQL statements then converting them to SPs once you
have them tied down.

M!ke 

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: Saturday, October 29, 2005 12:16 PM
To: CF-Talk
Subject: Philosophy Q: SP's or CFQUERY?

I'm going back and tweaking a web app that I'm building and have learned
a few stored procedure tricks (my SP skills were pretty basic before I
started to play around).  As a result, I'm replacing a number of CF
queries (using cfqueryparam) with SQL Server stored procedures. 
Now, these are pretty much limited to the customer-facing (non-admin)
pages, though I'm using SP's in the admin where I already have them
written to return the rest sets that I need.

Realizing that SP's will give greater performance, the question is
this: Is it OK to write your most frequently run queries as SP's and
leave the rest of the site as straight SQL queries?  Or should I just
make the entire site SP's?

What I've been doing during development is writing straight SQL until I
get what I need, then I rewrite as a SP.  I've replaced a dozen or so
queries that are all on the customer-facing end of things, but there are
well over 100 queries still written as SQL on the admin side, and it
would take a bit of effort to convert (or merge into existing SP's)
those queries.

Pete

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222668
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

How to recognize robots

Has any one a trick to detect and identify robots and search engine 
visiting CF pages?

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222669
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: MySQL DSN

2005-10-30 Thread jt

Can you post any errors you get from CF/MySQL -- also any errors in the CF
logs?

---
Josh Trefethen
Exciteworks, Inc
http://exciteworks.com
Expert Reseller Hosting


On 10/28/05, Snake [EMAIL PROTECTED] wrote:

 MySQL 4.1.13

 I dunno what the grant statement was as I use HELM or MySQL Administrator
 to
 create the databases.
 But I have the same MySQL 4.1.13 on another server which works fine with
 CFMX7.

 Russ

 -Original Message-
 From: Damien McKenna [mailto:[EMAIL PROTECTED]
 Sent: 28 October 2005 16:14
 To: CF-Talk
 Subject: RE: MySQL DSN

  -Original Message-
  From: Snake [mailto:[EMAIL PROTECTED]
 
  Create a MySQL DSN, put the username password into the DSN and it
  works fine. Pass the username/password in the code and it doesn't
  work.

 Which version of MySQL? What was the GRANT statement used to give
 permissions to the user?

 --
 Damien McKenna - Web Developer - [EMAIL PROTECTED] The
 Limu
 Company - http://www.thelimucompany.com/ - 407-804-1014 #include 
 stdjoke.h



 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222670
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: How to recognize robots

2005-10-30 Thread Michael Dinowitz

The good ones identify themselves. The bad ones can be tracked by logging every 
page request while setting a cfid/cftoken. If a series of page requests from 
the same agent/ip is showing a different cfid/cftoken per request, then either 
its a user that does not support cookies (even session ones) or its a bot. 
There are other ways as well including hidden pages that real people would 
never visit and the like, but the one above is the method I use and it works 
rather well. 

Has any one a trick to detect and identify robots and search engine 
visiting CF pages?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222671
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: How to recognize robots

 The good ones identify themselves.

Ok, and how do they do that?

If a series of page requests from the same agent/ip is showing a 
different cfid/cftoken per request, then either its a user that does not 
support cookies (even session ones) or its a bot.

Well, actually not really easy to implement ;-/

The reason I ask, is that I just implemented some statistics facility on 
some of my customers sites. This will count all hits, including those 
from robots, so I'd like to be able to discriminates visitors hits from 
others.

Thanks.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222672
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 to recognize robots

2005-10-30 Thread Brian Peddle

There are user agent lists out there

http://www.psychedelix.com/agents1.html  for example.

You could run a report later and go against a table of useragents

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 30, 2005 5:15 PM
To: CF-Talk
Subject: Re: How to recognize robots

 The good ones identify themselves.

Ok, and how do they do that?

If a series of page requests from the same agent/ip is showing a 
different cfid/cftoken per request, then either its a user that does not 
support cookies (even session ones) or its a bot.

Well, actually not really easy to implement ;-/

The reason I ask, is that I just implemented some statistics facility on 
some of my customers sites. This will count all hits, including those 
from robots, so I'd like to be able to discriminates visitors hits from 
others.

Thanks.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222673
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: Philosophy Q: SP's or CFQUERY?

2005-10-30 Thread Brian Peddle

You mention SP's will give greater performance.  I think that may be a myth
these days.  Google around and you will find all sorts of debates on it.  I
was shocked myself after spending a good bit of day taking some queries from
a CF page and dumping them into a shiny new stored proc and things didn't
improve and actually seemed to slow down some.

Here is one link http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx
but there are many.



-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: Saturday, October 29, 2005 1:16 PM
To: CF-Talk
Subject: Philosophy Q: SP's or CFQUERY?

I'm going back and tweaking a web app that I'm building and have
learned a few stored procedure tricks (my SP skills were pretty basic
before I started to play around).  As a result, I'm replacing a number
of CF queries (using cfqueryparam) with SQL Server stored procedures. 
Now, these are pretty much limited to the customer-facing (non-admin)
pages, though I'm using SP's in the admin where I already have them
written to return the rest sets that I need.

Realizing that SP's will give greater performance, the question is
this: Is it OK to write your most frequently run queries as SP's and
leave the rest of the site as straight SQL queries?  Or should I just
make the entire site SP's?

What I've been doing during development is writing straight SQL until
I get what I need, then I rewrite as a SP.  I've replaced a dozen or
so queries that are all on the customer-facing end of things, but
there are well over 100 queries still written as SQL on the admin
side, and it would take a bit of effort to convert (or merge into
existing SP's) those queries.

Pete



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222674
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: How to recognize robots

2005-10-30 Thread Matthew Walker

 The reason I ask, is that I just implemented some statistics facility 
 on some of my customers sites. This will count all hits, including
those
 from robots, so I'd like to be able to discriminates visitors hits
from
 others.

One way is to use an image in your page that is actually a cfm file. Use
the cfm file to track stats (pass in query string info to specify what
page you're looking at). You can use JS to load the image, which will
block bots but also drop the fraction of users with JS disabled. 

Not sure what happens if you embed the image directly. Presumably Google
will get counted due to its image search functionality. But perhaps
others won't??

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222675
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: Philosophy Q: SP's or CFQUERY?

2005-10-30 Thread Michael Dinowitz

Two simple rules I use are:
1. Is the query results going to be cached by CF (a list of all the mailing 
lists on a site)? If so, use standard.
2. Is the query results based on a large group of data with many people viewing 
the data (a day's messages for example) Is so, use SP.
Other than that, it all depends on the data, the DB, the available RAM on the 
SQL server and if I really need to have a SP for the data or not. I hate to say 
it's a case by case basis, but it is. 

There are also a few books you can read that deal with the subject really well:
SQL Tuning (O'Reilly)
http://www.amazon.com/exec/obidos/ASIN/0596005733/houseoffusion

SQL Performance Tuning (Addison-Wesley)
http://www.amazon.com/exec/obidos/ASIN/0201791692/houseoffusion
  
SQL Server Query Performance Tuning Distilled (Apress)
http://www.amazon.com/exec/obidos/ASIN/1590594215 /houseoffusion

Microsoft SQL Server 2000 Performance Tuning Technical Reference (Microsoft)
http://www.amazon.com/exec/obidos/ASIN/0735612706 /houseoffusion 

I've always been a fan of the O'Reilly books but the APress ones are looking 
better and better. Of course, Microsoft wrote SQL 2k, so their book might be 
worth looking at. :)


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222676
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 to recognize robots

 One way is to use an image in your page that is actually a cfm file.

Hmmm, this will also be blocked by some email readers, including my own, 
and I have some pages sent by email (News letter).

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222677
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 to recognize robots

2005-10-30 Thread Michael Dinowitz

The good ones identify themselves.

Ok, and how do they do that?
The HTTP_User_Agent. Google and Yahoo will show up with their name in the 
agent. Others will as well. On the other hand, when you see something that 
looks like IE but doesn't act like a human would, then it's time to think it 
may be a bot.

If a series of page requests from the same agent/ip is showing a 
different cfid/cftoken per request, then either its a user that does not 
support cookies (even session ones) or its a bot.

Well, actually not really easy to implement ;-/
Are you running CF 7 enterprise or pro? If the former, I've got some code for 
you for logging that will deal with it nicely. If the latter, I still have some 
code for you but it's not as 'clean and tight'.

The reason I ask, is that I just implemented some statistics facility on 
some of my customers sites. This will count all hits, including those 
from robots, so I'd like to be able to discriminates visitors hits from 
others.
I've been meaning to write an interface to my logs to allow people to download 
a list of bot agents/ips. Now that the hardware for HoF is moved over I can try 
to get onto that. (yeh, right). :)

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222678
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 to recognize robots

 The HTTP_User_Agent.

Yeah, I should have gessed! ;-)
I think, I'll just add the user agent in my stats and work something 
around it.

Are you running CF 7 enterprise or pro?

This particular site is still under CF 5

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222679
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: Philosophy Q: SP's or CFQUERY?

The performance benefits that SPs bring are based around their ability
to act on a query result without having to send the resultset back
across the network to CF.   I.e. if I have to do two queries and the
second depends on the results of the first, an SP will most likely be
more performant, because it only requires two network trips, rather
than four, and one CF recordset creation, rather than two.  This
effect obviously increases with the more complex the interactions are,
especially if the first recordset would have been large, and isn't
needed except for use in the second query.

If you just have a simple query, there's not really anything that an
SP can do to speed it up that isn't going to happen anyway.  And then
there's the overhead of calling the SP itself, which doesn't exist in
a simple query.

cheers,
barneyb

On 10/30/05, Brian Peddle [EMAIL PROTECTED] wrote:
 You mention SP's will give greater performance.  I think that may be a myth
 these days.  Google around and you will find all sorts of debates on it.  I
 was shocked myself after spending a good bit of day taking some queries from
 a CF page and dumping them into a shiny new stored proc and things didn't
 improve and actually seemed to slow down some.

 Here is one link http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx
 but there are many.




--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222680
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: Philosophy Q: SP's or CFQUERY?

 You mention SP's will give greater performance.  I
 think that may be a myth these days.  Google around
 and you will find all sorts of debates on it.  I was
 shocked myself after spending a good bit of day
 taking some queries from a CF page and dumping them
 into a shiny new stored proc and things didn't
 improve and actually seemed to slow down some.

In my experience, it depends on the data you're querying against and how it
is to be used.  One example I had was a table with 1,000,000+ rows that had
to have random data pulled out of it about once every 3 to 5 seconds, and
more at peak hours.  Even with the proper indexes and the entire table in
memory, the one query being run from ColdFusion with one variable was eating
up 75% of the processor on average, and closer to 90% during peak.

Converting that one query to a SP and passing the variable to it knocked the
CPU usage on the CF server down to about 5% on average.  It really did help
a LOT.  If you're working with smaller tables that don't get a lot of
traffic, you probably won't notice much of a difference, if any.


-Justin Scott


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222681
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: Philosophy Q: SP's or CFQUERY?

2005-10-30 Thread Brian Peddle

I do agree it depends on situation and I' be curious to see how it performed
in ASP or .NET or some other language as opposed to CF.  

-Original Message-
From: Justin D. Scott [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 30, 2005 6:48 PM
To: CF-Talk
Subject: RE: Philosophy Q: SP's or CFQUERY?

 You mention SP's will give greater performance.  I
 think that may be a myth these days.  Google around
 and you will find all sorts of debates on it.  I was
 shocked myself after spending a good bit of day
 taking some queries from a CF page and dumping them
 into a shiny new stored proc and things didn't
 improve and actually seemed to slow down some.

In my experience, it depends on the data you're querying against and how it
is to be used.  One example I had was a table with 1,000,000+ rows that had
to have random data pulled out of it about once every 3 to 5 seconds, and
more at peak hours.  Even with the proper indexes and the entire table in
memory, the one query being run from ColdFusion with one variable was eating
up 75% of the processor on average, and closer to 90% during peak.

Converting that one query to a SP and passing the variable to it knocked the
CPU usage on the CF server down to about 5% on average.  It really did help
a LOT.  If you're working with smaller tables that don't get a lot of
traffic, you probably won't notice much of a difference, if any.

-Justin Scott

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222682
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: Philosophy Q: SP's or CFQUERY?

 I do agree it depends on situation and I' be curious
 to see how it performed in ASP or .NET or some other
 language as opposed to CF.  

Given how much more difficult is it to pass a query from those languages
compared to ColdFusion, I think I would be more inclined to call a SP
anyway.


-Justin Scott


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222683
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: Philosophy Q: SP's or CFQUERY?

What do you mean in memory?  And was your DB running on the same
hardware as CF?  The DB has to do the same work in either case (some
randomization of a million rows), so the overhead of the SP/query
should be completely lost in the mass of time it'd take to deal with
the data.

cheers,
barneyb

On 10/30/05, Justin D. Scott [EMAIL PROTECTED] wrote:
  You mention SP's will give greater performance.  I
  think that may be a myth these days.  Google around
  and you will find all sorts of debates on it.  I was
  shocked myself after spending a good bit of day
  taking some queries from a CF page and dumping them
  into a shiny new stored proc and things didn't
  improve and actually seemed to slow down some.

 In my experience, it depends on the data you're querying against and how it
 is to be used.  One example I had was a table with 1,000,000+ rows that had
 to have random data pulled out of it about once every 3 to 5 seconds, and
 more at peak hours.  Even with the proper indexes and the entire table in
 memory, the one query being run from ColdFusion with one variable was eating
 up 75% of the processor on average, and closer to 90% during peak.

 Converting that one query to a SP and passing the variable to it knocked the
 CPU usage on the CF server down to about 5% on average.  It really did help
 a LOT.  If you're working with smaller tables that don't get a lot of
 traffic, you probably won't notice much of a difference, if any.


 -Justin Scott

--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222684
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: Philosophy Q: SP's or CFQUERY?

 What do you mean in memory?

SQL Server will hold as much of the most accessed data pages as it can in
memory once it's loaded from previous queries.  This table gets hit like
crazy, so my guess is that the entire thing is loaded in memory after a
couple of hours.

 And was your DB running on the same hardware as CF?
 The DB has to do the same work in either case (some
 randomization of a million rows), so the overhead
 of the SP/query should be completely lost in the
 mass of time it'd take to deal with the data.

Perhaps ramdom wasn't the right word.  The query isn't pulling random
rows, but subsets based on a foreign key.  The foreign key that is to be
loaded is not predictable, and there are 10,000+ foreign keys that can be
pulled at any time.

The problem with having the query come directly from ColdFusion was that the
query was different for each foreign key, which required the SQL server to
compile a new query plan (which could be thousands of plans that would get
cycled out of memory as new ones were compiled), which took far longer than
using one plan (from the SP) that was cached.

Using CFQUERYPARAM on that variable may have helped, but I never tested it
that way.  I just went directly from dynamic query to stored procedure and
the CF page response time went down significantly because it no longer had
to wait so long for the SQL server to process the queries.

Even if I have some of the details wrong, that one change made things go a
WHOLE lot smoother.


-Justin Scott


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222685
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: Philosophy Q: SP's or CFQUERY?

2005-10-30 Thread Greg Luce

And what about the security factor? I've always been under the assumption
that if your CF only had access to run SPs you were safer from SQL
injection. I'd like to hear Neil Robertson-Ravo chime in on this come 8:00
am London time.
 I didn't know there were so many proponents for inline SQL. I've just
always figured MSSQL was better able to run some pre-compiled execution plan
in the case of an SP, over ad-hoc SQL queries. Neil? Dave Watts?
 Greg
 On 10/30/05, Justin D. Scott [EMAIL PROTECTED] wrote:

  What do you mean in memory?

 SQL Server will hold as much of the most accessed data pages as it can in
 memory once it's loaded from previous queries. This table gets hit like
 crazy, so my guess is that the entire thing is loaded in memory after a
 couple of hours.

  And was your DB running on the same hardware as CF?
  The DB has to do the same work in either case (some
  randomization of a million rows), so the overhead
  of the SP/query should be completely lost in the
  mass of time it'd take to deal with the data.

 Perhaps ramdom wasn't the right word. The query isn't pulling random
 rows, but subsets based on a foreign key. The foreign key that is to be
 loaded is not predictable, and there are 10,000+ foreign keys that can be
 pulled at any time.

 The problem with having the query come directly from ColdFusion was that
 the
 query was different for each foreign key, which required the SQL server to
 compile a new query plan (which could be thousands of plans that would get
 cycled out of memory as new ones were compiled), which took far longer
 than
 using one plan (from the SP) that was cached.

 Using CFQUERYPARAM on that variable may have helped, but I never tested it
 that way. I just went directly from dynamic query to stored procedure and
 the CF page response time went down significantly because it no longer had
 to wait so long for the SQL server to process the queries.

 Even if I have some of the details wrong, that one change made things go a
 WHOLE lot smoother.


 -Justin Scott


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222686
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

cfc ?

2005-10-30 Thread dave

i cant quite figure this out

what would be the best way to do this

If i have a mailing list and the user wants to unsubscribe, I take the the 
email from the unsubscribe form and invoke the cfc. I can get it to unsubscribe 
fine but I want to add some code to check too be sure the email is in the db 
first and if not return an error if it is run the unsubscribe query.

the main problem I am getting is the error message back, not quite sure how to 
display it

on unsubscribe page i create the cfc object if the form was submitted
!--- if the unsubscribe form was submitted ---
cfif StructKeyExists(form, unsubscribe)
!--- invoke subscribe cfc ---
cfset unSubscriber = 
createObject(component,rrcfc.subscribe).unSubscriber(tbl_email=#form.email#)
/cfif

in the cfc

!---updates unsubscribe form submission to db ---
cffunction name=unSubscriber access=public returntype=string 
hint=checks email address to see if its in database output=true
!--- define arguments ---
cfargument name=tbl_email type=string required=yes

!--- check database for email address ---
cfquery name=dupEmail datasource=#request.datasource# 
username=#request.username# password=#request.password#
SELECT tbl_email
FROM jtbl_mailingList
WHERE tbl_email = cfqueryparam value=#tbl_email# 
cfsqltype=cf_sql_varchar
/cfquery

!--- Check to see if the email is in the database if not send a not found 
message back, if found change to unsubscribe ---
cfif dupEmail.recordcount EQ 0
cfset result = That email address was not found in our mailing list
cfreturn result
cfelse

!--- update to unsubscribed now ---
cfquery datasource=#request.datasource# username=#request.username# 
password=#request.password#
UPDATE jtbl_mailingList
SETtbl_subscribe = cfqueryparam value=no 
cfsqltype=cf_sql_varchar,
tbl_unsubscribeDate = cfqueryparam 
value=#DateFormat(Now(), 'ddd, dd mmm ')# cfsqltype=cf_sql_date,

WHEREtbl_email = cfqueryparam 
value=#trim(HTMLEditFormat(tbl_email))# cfsqltype=cf_sql_varchar
/cfquery

cfset result = You have been unsubscribed.
cfreturn result
/cfif
/cffunction
/cfcomponent

should i make it 2 different methods?
and how do i call the result? 

tia

~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time. 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222687
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: Philosophy Q: SP's or CFQUERY?

  the CF page response time went down significantly
  because it no longer had to wait so long for the
  SQL server to process the queries.

After re-reading this line I think it may have been confusing.  What I meant
was that the response time in ms went down, so the pages got a lot faster.

 And what about the security factor? I've always been
 under the assumption that if your CF only had access
 to run SPs you were safer from SQL injection.

I would agree with that, but you can be just as safe with inline SQL if you
scrub the variables properly.  I've seen people scream in horror over a
query like this...

WHERE id = #url.id#

Until I point out...

cfset url.id = abs(val(trim(url.id)))

As part of the scrubbing routine.  Guarantees a positive integer value,
and passes in 0 if it's a string.  It's not the best way, but for small
sites it's quick, easy, and pretty safe.  CFQUERYPARAM would help also.
Unfortunately some people are still using access databases, and don't have
the luxury of stored procedures.  I use SQL Server myself, and sp's where
needed.  I'm not a zealot one way or the other on what is used.  Depends on
the situation.


-Justin Scott


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222688
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: CFC - best practice - locks and so on

2005-10-30 Thread James Holmes

Instantiating the object into the session scope is fine. However,
manipulating the session scope from inside the CFC as per:

!--- query is loaded to session scope ---
cfset session.qryAllProducts = qryAllProducts
cfreturn session.qryAllProducts

is not recommended. This breaks the encapsulation rules usually
associated with CFCs.

Consider doing this instead: Create a method that queries the DB and
saves the query in a property in the VARIABLES scope. Then have the
getter method return the VARIABLES scoped query. This has the
benefit of keeping the query data in the component instead of having
to save it separately in the session scope and makes the thing behave
like an object with its own properties.

It's when the object has these properties that locking can become more
important. One technique that works well for instantiated objects is
to use a named lock where a UUID forms the name. Create the UUID as
part of the init() method and use it for every lock in the component:

cfset VARIABLES.MyLockName = createUUID()
.
cflock name=#VARIABLES.MyLockName # .

This means that every instance of the component gets a unique lock
name, improving performance over full scope locks or a single shared
name.

On 10/31/05, Michel Deloux [EMAIL PROTECTED] wrote:
 Hi all

 I'm looking for comments about cfc instantiation and the best
 practices for cflock.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222689
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: cfc ?

 i cant quite figure this out
 what would be the best way to do this

There are a couple of options off the top of my head.

One would be to create a checkSubscription() method that would return a
boolean value depending on whether the e-mail address was subscribed.  If it
is, call the unsubscribe method.  If not, display your error.  This is
probably the better choice.  You can re-use the checkSubscription() method
when someone tries to join the list so it will not add a duplicate, for
example.

The other method would be to use your existing code, but prepend a bit value
to the front of your return value.  Example:

cfset result=0,Not found in database.
cfset result=1,You have been unsubscribed.

After calling the method, you can check the bit value using
listFirst(unSubscriber) to determine if it was successful, and perform
whatever action was needed.  Then you can listRest(unSubscriber) to
display/extract your error message.


-Justin Scott


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222690
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: Time Block

2005-10-30 Thread Roberto Perez

At 05:17 PM 10/28/2005, Bobby Hartsfield wrote:

Even easier, once you have the dates just check to see if now() is

A) GTE EndDateTime OR LTE StartDateTime
B) GTE StartDateTime AND LTE EndDateTime

A being true means grant access
B being true means deny access


Hey,

I'm trying to implement that solution, comparing today's date with a date I 
have in a database (unfortunately, the DB I inherited has the date stored 
as individual dd, mm, yy, hh, mm, and ss fields). So I create my date with:

cfset endTimeDate= 
'#qry.applCloseMonth#/#qry.applCloseDay#/#qry.applCloseYear# 
#qry.applCloseHour#:#qry.applCloseMinute#:#qry.applCloseSecond#'
(again, from individual fields in the DB)

and then I create thisDate:

cfset thisTime='#DateFormat(Now(), 'mmm/dd/')# 
#Hour(Now())#:#Minute(Now())#:#Second(Now())#'

and although both dates print exactly the same on the screen, the 
comparison between them does not trigger an earlier that or later than 
behavior (I'm using GTE and LTE). Any suggestions on how to make it work 
(considering how the date is stored in the DB)?

Thanks in advance,

Roberto Perez
[EMAIL PROTECTED]


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222691
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 to recognize robots

I have a page I've been using on a site just to annoy harvester bots. 
This page is listed in my robots file as a do not crawl page, which 
the harvester bots love to visit!

The page contains a javascript version of wpoison written by D.K.Merriman.

To a bot, the page in question looks like a guest book with thousands of 
entires. It also generates random links that actually link back to the 
same page, so once a harvester bot hits the page, it will sit there for 
ever slurping up bogus email addresses. At the top of the same page, 
I've included the below that emails me and then I can go see where the 
little bastard came from:

cfmail
   to=[EMAIL PROTECTED]
   from=Some Spammer
   subject=HARVESTER ALERT 

address = #cgi.remote_addr#br
host = #cgi.remote_host#br
referer = #cgi.http_referer#br
agent = #cgi.http_user_agent#br
page = #cgi.script_name#

/cfmail


Damn good fun!

-- 
---
Les Mizzell

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222692
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: Time Block

If you do it the way you're doing it, you're comparing strings, not date
objects.  You should take the fields you get from the DB and use
createDateTime() to create a CF datetime object, then compare that to now()
instead of comparing strings.


-Justin Scott



 I'm trying to implement that solution, comparing today's date 
 with a date I 
 have in a database (unfortunately, the DB I inherited has the 
 date stored 
 as individual dd, mm, yy, hh, mm, and ss fields). So I create 
 my date with:
 
 cfset endTimeDate= 
 '#qry.applCloseMonth#/#qry.applCloseDay#/#qry.applCloseYear# 
 #qry.applCloseHour#:#qry.applCloseMinute#:#qry.applCloseSecond#'
 (again, from individual fields in the DB)
 
 and then I create thisDate:
 
 cfset thisTime='#DateFormat(Now(), 'mmm/dd/')# 
 #Hour(Now())#:#Minute(Now())#:#Second(Now())#'
 
 and although both dates print exactly the same on the screen, the 
 comparison between them does not trigger an earlier that or 
 later than 
 behavior (I'm using GTE and LTE). Any suggestions on how to 
 make it work 
 (considering how the date is stored in the DB)?
 
 Thanks in advance,
 
 Roberto Perez
 [EMAIL PROTECTED]


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222693
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 to recognize robots

 I have a page I've been using on a site just to annoy harvester bots.

I think you're having a weird idea of what the robots are doing.
I certainly do not want to annoy Google's bot or others ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222694
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: How to recognize robots

2005-10-30 Thread Alan Rother

I think his point was that good bots such as google will obey his do not
crawl command.
 He is trying to annoy the scumbags who crawl websites to steal email
address so they can spam people, these jerks ignore the robots file and love
to follow do not follow links.
 I for one applaud his efforts and would be very interested in seeing the
code if you don't mind Les

 On 10/30/05, Claude Schneegans [EMAIL PROTECTED] wrote:

 I have a page I've been using on a site just to annoy harvester bots.

 I think you're having a weird idea of what the robots are doing.
 I certainly do not want to annoy Google's bot or others ;-)

 --
 ___
 REUSE CODE! Use custom tags;
 See http://www.contentbox.com/claude/customtags/tagstore.cfm
 (Please send any spam to this address: [EMAIL PROTECTED])
 Thanks.


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222695
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 to recognize robots

 I think you're having a weird idea of what the robots are doing.
 I certainly do not want to annoy Google's bot or others ;-)

No, the page I wrote about is specifically EXCLUDED from the googlebot 
or any other friendly bot. The only bots that ever actually hit it are 
spam harvestors.

-- 
---
Les Mizzell

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222696
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: How to recognize robots