RE: Strange and Bizarre

Do you have Google Toolbar's Autofill enabled? That thing likes to make text boxes yellow if it recognizes the fields as something it could autofill. :P -- James Ang Sr. Software Developer MedSeek, Inc. [EMAIL PROTECTED]   -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED

RE: Why can't COM just work in CFMX?

knew back then that CFMX's webservices tier is based on Apache Axis. :) ;) Summary: CFMX + COM == BAD Idea. --- James Ang Sr. Software Developer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Matt [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 12

RE: Message: HTTP/1.1 200 OK Server: Microsoft-IIS/5.0...

CFLOCATION. The length is variable because it depends on the length the CFLOCATION URL. :) This is a KNOWN problem. Not sure when it will ever get fix. ;) --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Stan

RE: Help SQL Sever CFSTOREDPROC Issue.

Check the ColdFusion DSN definition (in the CF Admin) that you use to call the sp. Make sure that the user specified in the DSN definition has sufficient permissions to perform the DTS. --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED

RE: Nested Query Loop Bug/Issue

This issue has been around since v4.x. :P The workaround mentioned is *the* workaround. Confirmed bug or not? Not sure. Most developers just use the workaround. :D --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message

RE: I want to get rid of my evaluate too

Table CFLOOP query=Dynamic TR CFLOOP list=#Session.DisplayCols# index=LIndex TD#Dynamic[LIndex][Dynamic.CurrentRow]#/TD /CFLOOP /TR /CFLOOP /TABLE --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Boardwine

RE: Verity issues

to SQL. ;) CF-Verity Query Language Reference (for v5 and below?): http://livedocs.macromedia.com/cf50docs/Developing_ColdFusion_Applicatio ns/indexSearch7.jsp#1096786 Good luck! --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED

RE: Very odd behavior with data sources. please help if you can

working Access DSN's name, and getting an error, it may be because the file was not properly released. I am not sure. :P --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Ruggiero, Kevin D [mailto:[EMAIL

RE: SQL

This will round everything UP to the nearest 50,000 mark: (Ceiling(price/5) * 5) You can add extra string manipulations to produce the text that you want. I am no MS Acess expert, but the above functions should be available. :P --- James Ang Sr. Developer

RE: SQL

If price is an integer you should use: (Ceiling(price/5.0) * 5) To enforce floating point operation. :) --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent

RE: Using variables in a Switch case?

. --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:46 PM To: CF-Talk Subject: Using variables in a Switch case? CF 5 doesn't like this: cfset nID = 3 cfset nTest1

RE: Using variables in a Switch case?

cfcase though. ;) Care to comment, Mr. Sean Corfield? :P I know some hardcore programmers are probably groaning now. ;) --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED

RE: SQL stumper

OR better yet, SELECT personID, dob FROMpersons WHERE (Month(dob) = 7) AND (Day(dob) BETWEEN 21 AND 28) No more yucky cast/converts and other string ops. :) --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED

RE: SQL stumper

--- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:58 AM To: CF-Talk Subject: RE: SQL stumper To all generously considering this problem

RE: CF error...Cannot convert 10000000000 to integer

stores/converts all overflowed integers to FLOAT in arithmetic expressions, and you lose precision. In short, you have an integer overflow. :P --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: charlie griefer

RE: CF error...Cannot convert 10000000000 to integer

2^32 is about 4.2 billion. :) BUT, ColdFusion does not use unsigned integers, it uses signed integers. Hence, you cut the magnitude in half (2 billion). --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From

RE: SQL stumper SOLVED!

2000, a dob of 02/29/2000 would yield 02/28/2003. :) --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 11:42 AM To: CF-Talk Subject: RE: SQL

RE: CF error...Cannot convert 10000000000 to integer

--- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 1:15 PM To: CF-Talk Subject: Re: CF error...Cannot convert 100 to integer Maybe this could be an excuse to invest

RE: MX thinks URL Params are structures

. :) James Ang Programmer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Miller, Kevin [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:32 AM To: CF-Talk Subject: RE: MX thinks URL Params are structures Does the URL encode function

RE: easy path question

however you like. :) James Ang Programmer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:45 AM To: CF-Talk Subject: RE: easy path question That's a nasty

RE: StoredProc Error Num 3

Query Analyzer is that you can use PRINT statements in your stored proc (which may or may not be deadly in a CFSTOREDPROC call) to help you debug better. :) James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Owens, Howard [mailto

RE: StoredProc Error Num 3

James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 2:27 PM To: CF-Talk Subject: RE: StoredProc Error Num 3 Well, I'm getting no where fast

RE: HTTP header info showing up on CFM pages...(problem with cflocation)

just too lazy to go too deep into the whole thing. I have done it once on CFTALK. You can search the archives. :P James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003

RE: StoredProc Error

type (64 bit integer). ColdFusion's integers are 32bit. If all you do is output the value, you should be fine. Any arithmetic operation on the bigint value will cause the value to be treated as a float, and you immediately lose precision. Good luck! James Ang Programmer

RE: StoreProc Driver question

Whoops. My bad. :P Replace: #IsDate(request.start_date)# With: #YesNoFormat(NOT IsDate(request.start_date))# Do the same thing for the end_date too. I was too hasty with my post. Again, my apologies. :) James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED

RE: [OT?]: CFHTTPing to a Dominoe server

... Yu. James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 1:18 PM To: CF-Talk Subject: [OT?]: CFHTTPing to a Dominoe server SOLVED

RE: StoreProc Driver question

to MS SQL Server's timestamp datatype. CF_SQL_DATE and CF_SQL_TIME do not work with the provided MS SQL drivers that came with ColdFusion server. Yeah. It was pretty fun trying to figure this bug out the first time I found it many many moons ago... James Ang Programmer

RE: javascript popup window

the object handle for the new window. Window.focus() should have bring the window to the fore though. Not sure if this helps any. James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent

RE: Setting the focus to form select box item.

form.mySelect.focus(); The OPTION object does not have a focus() method in NS JS 1.3 spec. James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 1:20 PM

RE: Help with this Struct question, please

[] is a bad idea and can cause hard to debug problems. James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Howard Owens [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 3:40 PM To: CF-Talk Subject: Help with this Struct

RE: CFHTMLHEAD and appearance of HTTP header code in page

of the value in content-length. :P Maybe that's why Mozilla is so slow And now, maybe Macromedia will fix this bug since it is easily reproducible. James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Gyrus [mailto:[EMAIL

RE: does StructNew() destroy old structure completely?

the request ends. I think Allaire/MACR used to call them SmartHeaps. Pretty funny name. ;) James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:16 AM To: CF

RE: does StructNew() destroy old structure completely?

Thanks for the reference Dave! :) James Ang Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 9:55 AM To: CF-Talk Subject: RE: does StructNew() destroy old

RE: Mail Server Problem

need to restart the ColdFusion Application service to reliably flush the pcode cache. James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Wanda Hubbard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 11:01 AM

RE: What does this mean?

via cfprocparam and cfqueryparam. Basically any date/time types other than cf_sql_timestamp will crap out. James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27

RE: CVS

Safe. The other popular source code control software out there that costs lots and lots of $$$ is PVCS. I think Merant owns PVCS now. James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED

RE: SQL Question: Selecting and grouping by date

, Day(datetimefield) as DD, Count(1) AS RecordCountForThatDay FROMyourtable GROUP BYYY, MM, DD ORDER BYYY, MM, DD Hope this helps. James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Brook Davies

RE: SQL Question: Selecting and grouping by date

Month(datetimefield) instead of Month() Buggy example, but you get the idea. ;) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: James Ang Sent: Tuesday, July 30, 2002 4:13 PM To: '[EMAIL PROTECTED]' Subject: RE: SQL

RE: SQL Question: Selecting and grouping by date

(datetimefield) ORDER BYYY, MM, DD I tend to stay away from Convert() for this problem, but if you prefer the string manipulation route, you should look into: Select convert(varchar(8), datetimefield, 1) as adatefield From yourtable Order by adatefield James Ang Senior

RE: SQL Question: Selecting and grouping by date

the execution plan is compiled and executed on MS SQL Server side (and not at the ODBC layer). James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 4:39 PM

RE: CFPROCPARAM behavior change with MX+Oracle?

it. :) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 10:23 AM To: CF-Talk Subject: Re: CFPROCPARAM behavior change with MX+Oracle? Yeah, lots change with Oracle between 5 and MX

RE: RE: Application Slow Down was RE: Absolutely necessary to cflock session variables

, uhm, Keith? Please don't feel offended. Experience + Knowledge = Wisdom. What you have is probably plenty of experience, but not enough of knowledge. Yeah. It is a Friday. I feel dangerous and lazy. :P Back to work... =) James Ang Senior Programmer MedSeek, Inc

RE: Coldfusion WishList

) and arrays in MS T-SQL, I will probably NOT code that much in CFML. :P Heck, I can dream, can't I? :) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 9:48 AM

RE: RE: Application Slow Down was RE: Absolutely necessary to cflock session variables

underused, and yes, difficult to understand, CFLOCK. I am just very surprised that our resident jedimaster did not jump on this argument. :P James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Keith [mailto:[EMAIL PROTECTED

RE: RE: Application Slow Down was RE: Absolutely necessary to cflock session variables

James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Keith [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:45 PM To: CF-Talk Subject: Re: RE: Application Slow Down was RE: Absolutely necessary to cflock session variables

RE: RE: Application Slow Down was RE: Absolutely necessary to cflock session variables

My bad. Sorry. I will keep this discussion off list now. I hope I get the point across to the folks here that CFLOCK is a necessity rather than an option. James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Cravens, Billy

RE: dynamic variable name

option. :) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 3:59 PM To: CF-Talk Subject: dynamic variable name My brain is fried. How do I do

RE: FW: RE: Quotation Hell

a good feeling that CF5/MX actually translated the encoded characters to unicode characters. :P No empirical data to prove it though. :P Alright. That's my take on this issue. :) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message

RE: TimeStamp on RDS???

I have seen this in the past too. Typically, the timestamps of files reported by RDS is based on the assumption that the cf server is on GMT time. This behavior is absent with CFStudio 5 on XP, and CFServer 5 on W2K Server. James Ang Senior Programmer MedSeek, Inc

RE: cflock with timeout=0

throwonerror=no/cfhttp xmp#CFHTTP.Header#/xmp hr cfoutput#CFHTTP.FileContent#/cfoutput /cfif /cflock /body /html ]] I don't have a CF5 playbox to crash to verify if this is true for CF5. :P James Ang Senior Programmer

RE: cflock with timeout=0

Hey, maybe my test case was bad. :) The http call to itself can be a bad thing. :) I will churn on it some more later. :) Thanks for the empirical data! :) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Rob Baxter

RE: Emergency: Authorize. net woos

in the butt. James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:32 PM To: CF-Talk Subject: Re: Emergency: Authorize. net woos Just to cover the bases, you are using

Re: REReplace and RegExp

hope. :) For the code to work in CFAS 4.5.x, you will need to convert the UDF to Custom Tags. Good luck. :) Back to *real* work. (This list is too much fun.) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] - Original Message - From: Troy Simpson [EMAIL PROTECTED] To: CF

RE: REReplace and RegExp

a portion of the Apache parser. Good luck! :) James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:07 AM To: CF-Talk Subject: RE: REReplace and RegExp

RE: REReplace and RegExp

Try this: REReplaceNoCase(agents, (/?)agent([[:space:]]*|[[:space:]]+[^]*), \1a\2, ALL) I have tested this code on CFAS 5 on WinXP. James Ang Senior Programmer MedSeek, Inc. -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:15 PM To: CF

RE: REReplace and RegExp

retVal; } James Ang Senior Programmer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: James Ang Sent: Monday, April 22, 2002 2:45 PM To: CF-Talk Subject: RE: REReplace and RegExp Try this: REReplaceNoCase(agents, (/?)agent([[:space:]]*|[[:space:]]+[^]*), \1a\2, ALL) I have tested

cfset a.b = c -- COM error 0x80070005. Access is denied.

fine in ASP VBScript. CFAS is 5.0 Enterprise (eval/single-user) running on Windows 2000 Server. So, what gives? :) Preliminary/Cursory search of cfcomet did not yield anything useful. Hope to hear something from you gurus here. :) James Ang [EMAIL PROTECTED

RE: PreserveSingleQuotes() - CF 5 Bug?

the execution of a function which in your case is Trim(). Keep your calls to PreserveSingleQuotes() to the format: PreserveSingleQuotes(a) or PreserveSingleQuotes(a.b.c.d) I wonder if this is fixed in NEO Oh well. Got a project deadline to meet... :) Good luck! James Ang MedSeek, Inc

RE: PreserveSingleQuotes() - CF 5 Bug?

in CF 5 for performance reason. I know from memory that PreserveSingleQuotes(a[b]) (i.e. with general addressing) does not work in CF 4.5.x. It has been a while since I last coded for CF 4.5.x servers ;) Good luck! James Ang MedSeek, Inc. -Original Message- From: VAN VLIET, SCOTT E

RE: About to call Macromedia Tech Support on this one...

load, and available bandwidth). Just a wild guess. :) James Ang -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 12:21 PM To: CF-Talk Subject: About to call Macromedia Tech Support on this one... The following is an error we see in our

RE: Invalid parser construct eror

Angel, 5 is not a valid number. 0.5 is. You should use this: #Val(Val(SumTotals.RegTotal) + Val(SumTotals.OTTotal))# Instead of the inefficient and SLOW (corrected below): #Evaluate('#SumTotals.RegTotal# + #Val(SumTotals.OTTotal)#')# James. -Original Message- From: Angel Stewart

RE: Capture Output from CFINCLUDE?

this, then, so be it. I want to know. :) I hope this clears things up. :) Thanks. James Ang [EMAIL PROTECTED] -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 11:09 AM To: CF-Talk Subject: RE: Capture Output from CFINCLUDE? Are you sure? I

Capture Output from CFINCLUDE?

module. So, all suggestions are welcomed. :) If it is not possible, please let me know too! :) Thanks. James Ang [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER

RE: Capture Output from CFINCLUDE?

-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: James Ang [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

RE: A few quick regular expression questions

1. Yes. [aaa] is the same as [a] 2. Are you sure? I just tested it within CF Studio 4.5.2, and it works as intended. I am not sure if this list's softare or Outlook messed up, but your test string has a white space in it. 3. '^cat' means the first 3 characters in the test string must be 'cat'.

RE: Regular expression help

Use the UDF: capFirstTitle() http://www.cflib.org/udf.cfm?ID=116 For your purpose, CF RegExp won't do it as well as what Ed Hodder implemented with his UDF. But, FYI, REFind() and REFindNoCase() can return subexpressions. Example: Variables.sttREFind = REFind([[:graph:]]+, Variables.strName,

RE: cfcatch and can't catch

. ;) Lesson to Learn: There can be only ONE CFCATCH type=Any for a CFTRY. James Ang Senior Programmer MedSeek http://www.MedSeek.com/ -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 1:28 PM To: CF-Talk Subject: RE: cfcatch

RE: cfcatch and can't catch

), but will not generate the second. The user does not actually see the CF DB error if the exception is caught and handled properly. Hope this helps. (Of course, I can be very far off base here) James Ang Senior Programmer MedSeek http://www.MedSeek.com/ -Original Message- From: Dave