DateDiff bug?

2005-08-17 Thread Lofback, Chris
I've been looking at how the DateDiff calculations work in CFMX 6.1 and found an odd issue. It appears that DateDiff thinks that 1942 only has 8759 hours and that 1945 has 8761 hours when both should have 8760. This code shows the discrepancy: CFLOOP FROM=1940 TO=1950 INDEX=y CFSET a

RE: DateDiff bug?

2005-08-17 Thread Lofback, Chris
back off in the fall). That's just a WAG, but I'd imagine it's something along those lines, rather than a bug. cheers, barneyb On 8/17/05, Lofback, Chris wrote: I've been looking at how the DateDiff calculations work in CFMX 6.1 and found an odd issue. It appears that DateDiff

RE: DateDiff bug?

2005-08-17 Thread Lofback, Chris
. Googled '1942 leap hour' and it was the first result: http://www.thesunchronicle.com/articles/2005/08/07/opinion/opi nion5.txt cheers, barneyb On 8/17/05, Lofback, Chris wrote: I thought it could've been something like that too. I tried Googling it a few different ways but couldn't find

Delete CFMAGIC cookie?

2004-11-15 Thread Lofback, Chris
All-- Is there anyway to force a client browser to delete a CFMAGIC domain-level cookie? We have users who have domain cookies that are getting each other's sessions and need to remove the cookie. Thanks, Chris ~| Special

RE: Delete CFMAGIC cookie?

2004-11-15 Thread Lofback, Chris
We tried that and it didn't work. Here's the background: We were using SETDOMAINCOOKIES in CFAPPLICATION. The CFMAGIC cookie is a domian cookie with no exdate and it appears to be overriding our other host cookies that we want to expire when the browser is closed. CF is bumping all the cookies

Users getting other user's CFIDs and CFTOKENs

2004-11-15 Thread Lofback, Chris
We have discovered that some of our users--not all--are somehow getting another user's CFID/CFTOKEN. Our setup: CF5/Win2K/IIS5, two apps, each in a 2-server cluster, each in the same domain: ie, app1.domain.com and app2.domain.com, storing client variables in a database. We were using

RE: Verify an email address from a query

2004-09-29 Thread Lofback, Chris
AFAIK, an IP address is a valid host in an email address.This RE does not handle that. I also thought that the mailbox name could only contain alphanumerics, hyphens or underscores.But after reading this post and Googling the topic I've found someone who claims that the following are all valid:

Hal Helms Java For CF Developers class?

2004-08-26 Thread Lofback, Chris
Is there anyone on the list that has attended any of Hal Helms' training classes?I am interested in his Java For CF Developers but would like feedback from anyone who has taken it or any of his other classes. Also, the only contact info on his web site is an email address and so far I am unable

RE: Automated Scripts?

2004-08-23 Thread Lofback, Chris
Use the Scheduler in the CF Admin.Write a CF template to handle the logic and schedule it to run each morning. Chris -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 12:39 PM To: CF-Talk Subject: Automated Scripts? I'm trying to figure

RE: Double Negative way of making decisions? Good?

2004-08-19 Thread Lofback, Chris
IIRC, there was a time (thru CF5, I believe) where the use of Compare() was said to be faster because it was a numeric function rather than a string comparison (like IS or EQ).So this was an optimization method.I found it difficult to read too so I stuck with IS and suffered the few millisecond

RE: Double Negative way of making decisions? Good?

2004-08-19 Thread Lofback, Chris
But it is treated as boolean.0 is false and anything else is true, including -1 and 3.I use this principle all the time like this: CFIF qryFoo.RecordCount --Output records here-- CFELSE No records found! /CFIF Chris -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL

RE: 3 gmail invites

2004-08-19 Thread Lofback, Chris
Yes please! Thanks, Chris -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 1:33 PM To: CF-Talk Subject: OT: 3 gmail invites After a long drought I have 3 gmail invites available.Anyone want one? -- --Matt Robertson-- MSB Designs, Inc.

RE: JavaScript Question.

2004-08-16 Thread Lofback, Chris
Well, the original code would fail against a value between 0 and 0.01 (like 0.001) so I'd modify it like this: var reg = /([^0-9\.])/g; var str = $0.01; var myValue = parseFloat(str.replace(reg,)) alert(myValue0.01); Also, keep in mind that this will not catch invalid decimal amounts (like

RE: Stupid telephone regex question

2004-08-03 Thread Lofback, Chris
Why restrict yourself?Allow ther user to mix-and-match phone formats and then reformat as needed: CFSET Phone = 123.456.7890 CFIF REFind(^([0-9]{3}[-\. ]?|\([0-9]{3}\) ?)[0-9]{3}[-\. ]?[0-9]{4}$,Trim(Phone)) CFSET Temp = REReplace(Phone,[^0-9],,ALL) CFSET Formatted = ( Left(Temp,3) )

RE: increase session time

2004-07-21 Thread Lofback, Chris
Check the CF Admin session timeout.It controls the upper limit for session timeouts defined by the CFAPPLICATION tag.You will need to set it higher if you want longer session timeouts.I believe the default is 20 minutes. Chris -Original Message- From: Robert Orlini [mailto:[EMAIL

RE: I have a new email address!

2004-07-12 Thread Lofback, Chris
Evidently this guy has got an automated response for those using his old email address--like the one he used when subscribing to CF-Talk, maybe?I suspect the list will continue to get this (offensive) message over and over...Can we this address be disabled or blocked? Chris -Original

RE: PL/SQL stumper

2004-05-27 Thread Lofback, Chris
= '123-45-6789' GROUP BY d.provider ORDER BY MAX(m.date_submitted) DESC ) WHERE ROWNUM = 7 ORDER BY provider DON'T use rownum in your inner query! -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: woensdag 26 mei 2004 21:13 To: CF-Talk Subject: RE: PL/SQL

RE: PL/SQL stumper

2004-05-27 Thread Lofback, Chris
It looks like this is as close as I can get but it still doesn't work quite right.When I dump the records used by this query and sort them in date order, I have a value that is second in the list that does not make the final top 7...I don't understand why but I'll keep chopping at it. Thanks all,

RE: PL/SQL stumper

2004-05-27 Thread Lofback, Chris
the first 7 of this SELECT. If you have several providers with the same date, they may not come in the same order in the inner select as in the sorted table. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: donderdag 27 mei 2004 15:51 To: CF-Talk Subject: RE: PL/SQL

PL/SQL stumper

2004-05-26 Thread Lofback, Chris
I have a table like the following.With just CFML (v5) and plain Oracle PL/SQL--ie, no temp tables or stored procedures--is there a way to get, say, the 7 most recent distinct providers?I've tried every which way, even using QofQ with MAXROWS=7, but that only returned the first 7 distinct providers

RE: PL/SQL stumper

2004-05-26 Thread Lofback, Chris
I thought the same thing at first, but you cannot sort on a field that is not selected when using DISTINCT.And adding the field throws off the records selected because DISTINCT looks at the entire row, not just the one column... Thanks, Chris -Original Message- From: Dave Carabetta

RE: PL/SQL stumper

2004-05-26 Thread Lofback, Chris
This throws an error: ORA-00937: not a single-group group function But it gives me some ideas to work with. Thanks, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 12:20 PM To: CF-Talk Subject: Re: PL/SQL stumper Lofback

RE: PL/SQL stumper

2004-05-26 Thread Lofback, Chris
this clearly--but does that make sense? Thanks again, Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 1:25 PM To: CF-Talk Subject: Re: PL/SQL stumper Lofback, Chris wrote: This throws an error: ORA-00937: not a single-group group

RE: PL/SQL stumper

2004-05-26 Thread Lofback, Chris
Which Oracle version are you using? Oracle8i And I am working on providing a better explanation of the query results.Stay tuned... Thanks, Chris Lofback Web Administrator Ceridian Benefits Services 3201 34th Street S. St. Petersburg, FL 33711 727-395-8881 [Todays Threads] [This Message]

RE: PL/SQL stumper

2004-05-26 Thread Lofback, Chris
All right, I guess I'll need to provide actual database info to figure this out.Here's part of Jochem's suggestion, with mods to fit the actual schema (and to fix a grouping error): SELECT d.provider, MAX(m.date_submitted) AS lastDate, rownum AS rn FROM fsa_detail d, fsa_master m WHERE

RE: Don't mean to be picky

2004-05-21 Thread Lofback, Chris
A widely adapted methodology. adapted = great typo/pun! Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: JavaScript RegEx bug in NS6?

2004-05-18 Thread Lofback, Chris
There are only 4 people still using it, so forget it. Yes, it may seem like that, but not according to our logs!We still get thousands of requests from NS6 users each month. Anyway, I'm nit-picky about these things and prefer that my code have as few version issues as possible.My job is to make

SOT: JavaScript RegEx bug in NS6?

2004-05-17 Thread Lofback, Chris
I think I've found a bug in the _javascript_ RegEx implementation in Netscape 6 (for Windows, anyway).Below is a RegEx pattern for a non-IP email address.The first alert shows zero, which is a match beginning with the first character, but the second alert shows '-1', indicating no match.The only

RE: JavaScript RegEx bug in NS6?

2004-05-17 Thread Lofback, Chris
Thanks for the feedback on Mozilla--good to know.I'd heard that NN6 was buggy but my goal is to support users who have NN6 if at all possible rather than ask them to upgrade. Chris -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004

RE: Email Problem

2004-05-06 Thread Lofback, Chris
Works great for me--CFMX 6.1 on Win2K/IIS5, Exchange 2K, Outlook 2K. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Email Problem

2004-05-06 Thread Lofback, Chris
for read receipts.Did it work? /cfmail Chris -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:10 PM To: CF-Talk Subject: RE: Email Problem Need help, send code. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED

RE: Email Problem

2004-05-06 Thread Lofback, Chris
I didn't see the mailto: tags in the sample on the blog.Are they the problem?I didn't use them and my code worked... Chris -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:13 PM To: CF-Talk Subject: RE: Email Problem CFMAIL TO=

RE: Email Problem

2004-05-06 Thread Lofback, Chris
Were you prompted for a return receipt or by chance do you have return receipts automatically generated? There was no prompt.We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Chris [Todays Threads] [This Message] [Subscription]

RE: Email Problem

2004-05-06 Thread Lofback, Chris
I tried with and without the mailto tags and I still do not receive the receipts. Mario -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:45 PM To: CF-Talk Subject: RE: Email Problem I didn't see the mailto: tags in the sample

RE: Email Problem

2004-05-06 Thread Lofback, Chris
. Andy -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:16 PM To: CF-Talk Subject: RE: Email Problem I copied the code from Andrew Tyrone's blog and used my own email addresses: cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Read

BlueDragon in production?

2004-04-21 Thread Lofback, Chris
I am looking at BlueDragon and would like to know who is using it for their production apps.Can you offer a brief evaluation?Stable?Fast?Any incompatibilites other than the unsupported tags mentioned in the docs?We are currently using CF5/Win2K/IIS/Oracle with client variables in a load-balanced

RE: BlueDragon in production?

2004-04-21 Thread Lofback, Chris
Oops.Forgot to mention we use CF5 Enterprise (for the Oracle Native drivers). Chris -Original Message- From: Lofback, Chris Sent: Wednesday, April 21, 2004 9:52 AM To: '[EMAIL PROTECTED]' Subject: BlueDragon in production? I am looking at BlueDragon and would like to know who

RE: BlueDragon in production?

2004-04-21 Thread Lofback, Chris
We are using CFMX Enterprise for some internal apps and the Oracle drivers work without a hitch. So do you use BlueDragon for any of your production apps?If so, how do you like it? Chris -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004

RE: JS help - checkboxes

2004-04-09 Thread Lofback, Chris
Would it make more sense to use radio buttons, which only allow one selection? Chris -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 8:52 AM To: CF-Talk Subject: JS help - checkboxes I have a little script that throws up an alert when more

RE: JS help - checkboxes

2004-04-09 Thread Lofback, Chris
o: CF-Talk Subject: RE: JS help - checkboxes Thanks Chris... was easy and works great Randy... thanks also for your suggestion on the checkbox approach -Original Message----- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 9:10 AM To: CF-Talk Subject: RE: JS help -

Java bootcamp for CF Developers?

2004-04-09 Thread Lofback, Chris
I'm looking for a training class that can turn an experienced CF developer (me) into a competent Java developer.Ideally, I'd like something that will include the web development side of Java, like JSP, J2EE, servlets, beans, etc.Can anyone recommend something in the Tampa Bay, FL area?Or within a

UTC/TimeZone/Daylight Savings Time problem

2004-04-06 Thread Lofback, Chris
We are in the Eastern US Timezone (GMT-5).After the DST adjustment this weekend, some CF5 code that relies on UTC adjustments began failing, showing a one hour difference.We checked our servers (Win2K, Apache 1.3) and the time, date, time zone and DST checkboxes were all correct.We dumped the CF

RE: Oracle9, CF5 and Merant drivers

2004-03-16 Thread Lofback, Chris
One other thought.Is there any reason why you are not using the Oracle ODBC driver that comes with the Oracle client?We've seen the occasional odd error using the Merant driver and prefer to use the Oracle driver whenever possible. Chris -Original Message- From: Matt Robertson

RE: Query Result to a comma list

2004-03-09 Thread Lofback, Chris
ValueList(query.column) Chris -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:21 AM To: CF-Talk Subject: Query Result to a comma list How do you convert a query result column to a comma delimited list without building it with a loop?

RE: select boxes and javascript

2004-03-02 Thread Lofback, Chris
You probably want to use the onChange event for the select list itself, something like this (untested code) : SCRIPT LANGUAGE=_javascript_ function doSwitchDIV(oSelList) { var val = oSelList.options[oSelList.selectedIndex].value; if (val == 'forsale') switchDiv('ez'); if (val == 'forrent')

RE: select boxes and javascript

2004-03-02 Thread Lofback, Chris
happened, no errors either. Am I missing something (apart from _javascript_ knowledge!). Stuart -- Original Message -- From: Lofback, Chris [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 2 Mar 2004 11:21:03 -0500 You probably want to use the onChange

RE: Number of files in a directory

2004-03-02 Thread Lofback, Chris
In CF5, The FILTER parameter is for a wildcard file extension, like *.cfm, and only a single extension can be used.I don't think this has changed in CFMX. Chris -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 3:50 PM To: CF-Talk Subject:

RE: SQL question

2004-02-23 Thread Lofback, Chris
Query of Query? Chris Lofback Web Administrator Ceridian Benefits Services 3201 34th Street S. St. Petersburg, FL 33711 727-395-8881 -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 2:08 PM To: CF-Talk Subject: SOT: SQL question

JRun admin password?

2004-02-19 Thread Lofback, Chris
I know I've seen info on recovering CF admin passwords, but does anyone know how to recover a lost JRun 3 admin password on Unix? Thanks, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

CFML/ASP equivalents

2004-02-17 Thread Lofback, Chris
Does anyone know of a resource that shows the ASP equivalents for CFML?Like what is the ASP equivalent for CFPARAM?A chart would be great.I've Googled it but haven't found anything. Thanks, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: CFML/ASP equivalents

2004-02-17 Thread Lofback, Chris
, 2004 11:16 AM To: CF-Talk Subject: RE: CFML/ASP equivalents In asp it would just be setting a declaring a var Eample: Dim myString As String I have not really seen any site or book with the chart you are seeking. Pick up a cheap ASP 3 book. Shawn Regan -Original Message- From: Lofback

RE: CFML/ASP equivalents

2004-02-17 Thread Lofback, Chris
Me too.I did find bits and pieces here and there but nothing comprehensive.It seems like someone would have this somewhere but I sure couldn't find it.That's why I asked... And what's a wiki anyway? Chris -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED] Sent: Tuesday,

RE: Favorite CF Variable Tricks and Techniques

2004-02-13 Thread Lofback, Chris
Well, this may be too common to actually be a trick but I'll give it a shot.Sometimes I want a template/fuse to accept input from a form and other times from a query string.To handle both situations, I set the variable default value like this: CFPARAM NAME=URL.FooBar DEFAULT= CFPARAM

Domain Cookie expiration?

2004-01-12 Thread Lofback, Chris
All-- We have a load-balanced CF5 app using client variables on a pair of Win2K/Apache 1.3.x web servers.We need the session to expire when the user closes their browser and are manually resetting the CFID/CFTOKEN session cookies.But when we enable the SETDOMAINCOOKIE option in the CFAPPLICATION

Decoding WDDX in ASP?

2004-01-02 Thread Lofback, Chris
Can anyone point me at some ASP code that will decode a WDDX packet containg a CF record set into an ADO record set?Basically, from an ASP box I need to retrieve a WDDX packet from a remote CF5 server and extract the query. Thanks, Chris [Todays Threads] [This Message] [Subscription] [Fast

RE: Decoding WDDX in ASP?

2004-01-02 Thread Lofback, Chris
Thanks, I looked briefly before asking the list but I'll look it over again a little closer. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 2:30 PM To: CF-Talk Subject: RE: Decoding WDDX in ASP? Have you tried www.openwddx.org - I believe

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Lofback, Chris
Another consideration is that you cannot use CF query caching on a query that uses CFQUERYPARAM tags.(At least with CF5 and earlier.) Chris -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of

Clearing Trusted Cache in CF 5

2003-11-21 Thread Lofback, Chris
Does disabling and then reenabling the Trusted Cache option in CF 5 clear the template cache?If not, how can I make CF refresh the entire cache?Does it require a restart? Thanks, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Clearing Trusted Cache in CF 5

2003-11-21 Thread Lofback, Chris
://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: Lofback, Chris [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 21

RE: Clearing Trusted Cache in CF 5

2003-11-21 Thread Lofback, Chris
Of course.But back to my original question: how can I force a refresh of this cache? Chris -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 11:10 AM To: CF-Talk Subject: RE: Clearing Trusted Cache in CF 5 On a production server with frequent

RE: CFCONTENT/CFHEADER woes

2003-11-13 Thread Lofback, Chris
I've always used this style: CFHEADER NAME=Content-Disposition VALUE=inline; filename=foo.txt CFCONTENT TYPE=application/unknown FILE=c:\foo.txt Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:00 PM To: CF-Talk Subject:

RE: randRange(); just how random is it?

2003-11-10 Thread Lofback, Chris
That would be Randomize(number). Chris -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Saturday, November 08, 2003 6:45 PM To: CF-Talk Subject: RE: randRange(); just how random is it? There should be a way to re-seed the random number generator. -Gel

RE: Killing a session Variable

2003-10-22 Thread Lofback, Chris
Off the top of my head, wouldn't it be... StructDelete(session,TestVariable, TRUE) Chris -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 12:36 PM To: CF-Talk Subject: Killing a session Variable CF 5.0 Actually the goal is to kill a

CF5: Oracle recordset via StoredProc and QofQ questions

2003-10-20 Thread Lofback, Chris
All-- Two questions for CF5, Win2K and IIS5. 1)Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure?Is it slow?Unstable/flaky? 2)Can QofQ handle a recordset that large? Thanks, Chris

RE: CF5: Oracle recordset via StoredProc and QofQ questions

2003-10-20 Thread Lofback, Chris
StoredProc and QofQ questions Lofback, Chris wrote: 1)Are there any limitations/issues when retrieving large (say 250,000 rows of 10 varchar2(50) columns) recordsets from Oracle 8 using a stored procedure?Is it slow?Unstable/flaky? 250,000 * 10 * 50 = 125 MB minimum It needs to be stored in RAM

RE: CF5: Oracle recordset via StoredProc and QofQ questions

2003-10-20 Thread Lofback, Chris
time, if the user cancels a request this thread stays active.Non patient users will cause havoc here. Doug -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:24 PM To: CF-Talk Subject: RE: CF5: Oracle recordset via StoredProc and QofQ

CFMX 6.1 Tag Updates for CF Studio 4.5?

2003-10-10 Thread Lofback, Chris
All-- I'm stuck with CFStudio 4.5.2 and need the tag updates for CFMX 6.1.I tried the download from MACR but it doesn't appear to be correct.For ex, there's no CFFUNCTION in the tags.Does anyone have a link they could share? Thanks, Chris [Todays Threads] [This Message] [Subscription]

RE: Session Variables Or Client Variables (Pros Cons - Poll)

2003-10-03 Thread Lofback, Chris
In CF5, client variables are the only option when clustering/load-balancing. -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 4:30 PM To: CF-Talk Subject: Session Variables Or Client Variables (Pros Cons - Poll) Personally i am not a big fan

RE: Date Comparison using JavaScript

2003-09-29 Thread Lofback, Chris
Do you mean to compare date strings rather than date objects?I have a JS library I wrote that will do this, but it requires v4 browser or better.Is that OK? Chris -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:20 AM To: CF-Talk

Queries timeout in CFMX 6.1

2003-08-27 Thread Lofback, Chris
Platform: CFMX6.1/Win2K/IIS5 All-- Just installed CFMX 6.1 to run alongside an existing CF5 on a standalone server. The install looks OK--no errors, the CF Admin works fine and CFML statements (ie, CFOUTPUT#DateFormat(Now())#/CFOUTPUT) execute properly. But when I try to use CFQUERY, the

RE: DateDiff question

2003-08-20 Thread Lofback, Chris
Here's an excerpt direct from ColdFusion Studio's help pages ;) Thanks. Well, that's what I get for relying on the popup help and the O'Reilly function reference... When datepart is Weekday (w), DateDiff returns the number of weeks between the two dates. If date1 falls on a Monday,

DateDiff question

2003-08-19 Thread Lofback, Chris
Platform: CF5/Win2K/IIS5 I'm seeing wierd results from DateDiff when using 'ww' (weeks) as the date part. Can anyone explain these results? CFSET d1 = 08/3/2003 CFSET d2 = 08/10/2003 CFOUTPUT P#DateDiff('ww',d1,d2)# !--- Result: 1 --- /CFOUTPUT CFSET d1 = 08/4/2003 CFSET d2 =

RE: Listing Number of Results

2003-07-28 Thread Lofback, Chris
Does the country appear in a field? If so, you could use something like this: CFSET US_Count = ListValueCountNoCase(ValueList(qryMyQuery.CountryField),US) CFSET INDIA_Count = ListValueCountNoCase(ValueList(qryMyQuery.CountryField),INDIA) ...etc... Chris -Original Message- From: Les

RE: Array Delimiter Problems

2003-07-24 Thread Lofback, Chris
As a helpful tip, I prefer to use the non-typable bell character as a list delimiter. I put this in my app_globals.cfm (if using FB) or application.cfm: CFSET DELIM = Chr(7) Then use DELIM in all list functions, like this: CFOUTPUT#ListGetAt(whatsnew[k],2,DELIM)#/CFOUTPUT Using a character

RE: Usability

2003-07-11 Thread Lofback, Chris
I think Nielsen's greatest value is in identifying real web user behavior, i.e., how users really interract with a web site/application. It's up to us to decide how to design to accommodate that behavior. And I meant to recommend the info on UseIt.com--specifically the AlertBox columns--not

RE: Usability

2003-07-10 Thread Lofback, Chris
If you haven't already, be sure to see Jakob Nielsen's UseIt.com site. He's a former Sun UI engineer who writes specifically about web usability. Great stuff, IMHO. http://useit.com Chris ~| Archives:

RE: cftransaction quick question

2003-07-09 Thread Lofback, Chris
My thinking is that if the single query fails, there wouldn't be any need for a rollback how does that sound? Sounds good to me. AFIK, a query either succeeds or fails--there's no such thing as partial success in a SQL statement. So if the query fails, there's no change in the DB that

RE: cftransaction quick question

2003-07-09 Thread Lofback, Chris
- then no need for a rollback / update etc BUT for an SP you do require at least a commit or rollback. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 14:04 To: CF-Talk Subject: RE: cftransaction quick question My thinking is that if the single

RE: cftransaction quick question

2003-07-09 Thread Lofback, Chris
- No need for cftransaction on a single SQL query True, but I would always use a CFCATCH to trap any errors. - cftansaction is good practice for a single stored procedure call in case the stored procedure is doing multiple SQL queries I don't know if you read my previous post, but I don't

RE: cftransaction quick question

2003-07-09 Thread Lofback, Chris
at least a commit or rollback. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 14:04 To: CF-Talk Subject: RE: cftransaction quick question My thinking is that if the single query fails, there wouldn't be any need

RE: Is there a way to test to see if a data source exists?

2003-06-27 Thread Lofback, Chris
These are CF 5 solutions. Try the undocumented CFIF CF_IsColdFusionDataSource(MyDSN) or if you prefer a supported option you could try something like this: CFSET DSN = Foo CFSET DSNType = ODBC CFTRY !--- Query should always fail and go to CFCATCH --- CFQUERY NAME=Test

RE: Is Flash really THAT good?

2003-06-23 Thread Lofback, Chris
Look at Yahoo, eBay, Amazon and Google. I'd guess they are among the most heavily used sites and they rely on standard light/white background, dark/black text, blue underlined links and (for the most part) standard form elements. Minor differences, but they don't stray far from the

RE: Javascript error catching

2003-06-23 Thread Lofback, Chris
In the past, I've sent this info back to a CF template which could then process it in any way needed. Here is the JS code I included with my JS library. Watch out for the big line wrap on the query_string assignment line! ===START=== var errCount = 0; function errHandler(msg,url,line) {

RE: Is Flash really THAT good?

2003-06-20 Thread Lofback, Chris
However, with a thread like this, it makes me think that you are like the others who bitch about flash yet haven't seen any flash movies worth while. Here are a few flash sites that I consider to be worth your viewing. http://www.2advanced.com/flashindex.htm http://www.egomedia.com

RE: Is Flash really THAT good?

2003-06-20 Thread Lofback, Chris
Yeah, but this list is made up of developers and techies, not [EMAIL PROTECTED] Yes, developers and techies who talk about using Flash and other technologies in the real world to deliver real apps for real users. The list also includes many professionals who need to understand the needs of

RE: Is Flash really THAT good?

2003-06-20 Thread Lofback, Chris
As for non-standard navigation, what make flash navigation non-standard in compared to HTML. What is standard navigation anyhow? Standard navigation doesn't exist. It's just a concept. I don't agree. Blue, underlined text is nearly universally understood as a clickable link, and the vast

RE: Is Flash really THAT good?

2003-06-20 Thread Lofback, Chris
Blue, underlined text is hardly navigation. That's just a common identifier for a link, which in HTML is an action, not necessarily navigation. A link can do a number of things like execute a javascript function or dhtml. Google, since you mention how standard it is, does not use this

ColdFusion and Crystal Reports

2003-06-18 Thread Lofback, Chris
I've never used Crystal from CF, so I'm forwarding the following question from a colleague: I want to use cold fusion to call a Crystal Reports template with a WHERE clause and display the report in PDF. If 500 users are requesting, who handles the requests? ColdFusion or do I need to purchase

SOT: ASP equivalent to CF server variables?

2003-06-17 Thread Lofback, Chris
Well, I'm beating my brains out trying to find this on MSDN, but I'll bet this group knows... I need an ASP equivalent to CF's built-in server variables, like OS, OS Version, HTTP server, etc. How can I get that in ASP classic?

RE: ASP equivalent to CF server variables?

2003-06-17 Thread Lofback, Chris
item /td/tr) next % table border=0 trtdbScript engine : /td td%= scriptengine() %/td td%= scriptenginemajorversion() %:/td td%=scriptengineminorversion() %/td td%= scriptenginebuildversion() %/td/tr/table /body/html -Original Message- From: Lofback, Chris [mailto:[EMAIL

RE: Setting session variables from javascript

2003-06-10 Thread Lofback, Chris
If you mean having JS in the browser read and set session variables directly, you can't, because JS is client-side and CF session variables are server-side. The only thing you can do is pass variables back and forth via page loads (or getting tricky with hidden frame/GIF pipes) and CFOUTPUTing

Trusted cache?

2003-06-05 Thread Lofback, Chris
The docs are pretty thin on the Trusted cache option in CF5 Admin but I found a Tech Note in MM saying it should be anabled on Production Servers. Is this standard practice out there and, other than remembering to refresh when updating templates, are there any gotchas to be aware of? Thanks,

RE: CFLOOP, almost there

2003-06-04 Thread Lofback, Chris
Something like this? CFSET CRLF = Chr(13) Chr(10) CFLOOP LIST=#emailtext# DELIMITERS=#CRLF# INDEX=TheLine CFSET EmailItem = ListContains(TheLine,@, ) CFIF EmailItem CFSET EmailAddress = ListGetAt(TheLine, EmailItem , ) !--- Do whatever you want

RE: CFLOOP, almost there

2003-06-04 Thread Lofback, Chris
Hmm. Aren't those spaces between the names and email address? If they're tabs, try this: CFSET CRLF = Chr(13) Chr(10) CFSET DELIM = Chr(9) CFLOOP LIST=#emailtext# DELIMITERS=#CRLF# INDEX=TheLine CFSET EmailItem = ListContains(TheLine,@,DELIM) CFIF EmailItem

WebDAV exploit?

2003-03-18 Thread Lofback, Chris
Anybody had a problem with CF5 after applying the patch that corrects the Microsoft WebDAV buffer overflow vulnerability for Win2K/IIS5? We're looking at patching several CF5 boxes and heard that some folks had problems. Here's the WebDAV link (watch the wrap!):

Getting server uptime in NT/Win2K?

2003-03-13 Thread Lofback, Chris
Using CF4.5/5, does anyone know of a way to get NT/Win2K server uptime and status info, kind of like what 'uptime' offers on Unix? I'm building a CF monitoring system and I want to retrieve this info from some CF/Win boxes. Ideally, I need something that does not need to be installed. Is

Client variable performance question

2003-03-06 Thread Lofback, Chris
We are converting a session-variable-heavy app to using client variables in a clustered environment using CF5 and a native driver connection to an Oracle DB. To reduce calls to the DB, I was hoping to just make one call to get all the client variables and then copy them into the request scope,

RE: Client variable performance question

2003-03-06 Thread Lofback, Chris
scope helps anything. Chris Norloff -- Original Message -- From: Lofback, Chris [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 6 Mar 2003 12:20:57 -0500 We are converting a session-variable-heavy app to using client variables

RE: Clustered Session Vars

2003-02-26 Thread Lofback, Chris
Except in the situations where you have too much data for a client var to handle but most things you should be ok. Is there a size limit when using a DSN for client variables? I couldn't find that in the docs. What is the limit? Chris Lofback Web Administrator Ceridian Benefits Services

RE: Checking all form fields

2003-02-05 Thread Lofback, Chris
Yes, you can use the form.fieldnames list and loop through it, something like this: CFLOOP LIST=#Form.FieldNames# INDEX=Field BRCFOUTPUTForm.#Field# = #Form[Field]#/CFOUTPUT /CFLOOP Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com

  1   2   >