RE: OT- Program to compare two pages of code for differences

2000-08-25 Thread Sean German
Larry, Check out Component Software Diff (CSDiff). It can compare two files as well as all the files in two folders. Available from download.com HTH Sean G -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 5:52 PM To: [EMAIL

RE: Airport Code Database

2000-08-17 Thread Sean German
Howdy, An alternate source, just for giggles: http://flyaow.com/citycode.htm Sean G. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 12:12 PM To: Cf-Talk Subject: Airport Code Database I have an application that requires that I

RE: Airport Code Database

2000-08-17 Thread Sean German
Oh, btw http://flyaow.com/citycode.htm is an international list, alphabetical by city name and 3 letter code. HTH, Sean G. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 12:12 PM To: Cf-Talk Subject: Airport Code Database I

cluster cats confusing client sessions?

2000-08-17 Thread Sean German
Howdy, Over the past couple days I've had several instances of members of my site seeing account information of other members. I have a members-only service to which visitors log in with a user name and password. I keep track of the visitors identity and membership status with client

RE: Comma/Number Problem

2000-08-10 Thread Sean German
This is something I've picked up from this list. cleanNumber = rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") HTH,, Sean G. -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 3:24 PM To: [EMAIL PROTECTED] Subject: Comma/Number Problem Hi, I

RE: Comma/Number Problem

2000-08-10 Thread Sean German
K, Fair enough. The expression removes all characters that aren't a digit or decimal point(0-9 or .). rereplace(vartocleanup, "[^0-9\.]+", "", "ALL") Whether you prefer that or Don's newstring=replace(oldstring,",","","ALL") depends on the source of the numbers. If you have some legacy

RE: Parsing URLs on IIS 4

2000-07-25 Thread Sean German
There are post-SP5 fixes other than SP6 that can have this affect. (What is an MS SP but a collection of fixes released since the last SP?) I know the Ogle utility has this affect, as well as the (iirc) malformed HTTP request header fix. My impression that the use of slash-delimited query

RE: CFIF and CFELSE

2000-07-13 Thread Sean German
Howdy, CF won't let you seperate cfform and /cfform so both opening and closing tags need to be in the same branch of the cfif logic. For example, cfif CONDITION cfform action=true_action method= /cfform cfelse cfform action=false_action method= /cfform /cfif

cahcing results of a stored procedure

2000-06-29 Thread Sean German
Howdy, Is there a method of caching the result set of a cfstoredproc cfprocresult analogous to CFQUERY CACHEDWITHIN="#SomeTimeSpan#"? TIA Sean G. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit

RE: CFFILE Accept

2000-06-17 Thread Sean German
Howdy, I don't think you can stop CFFILE, but you can manage the page after the cffile action. CFIF cffile.ClientFileExt EQ 'jpg' or cffile.ClientFileExt EQ 'gif' CFELSE CFFILE ACTION="DELETE" FILE="#photo.name#" /CFIF HTH, Sean -Original Message- From: Double Down,

RE: Is there a typical cause for this error message?

2000-06-01 Thread Sean German
Yes, A typical cause is the data being inserted too long. Check the length of the column in the database and your data validation. HTH Sean -Original Message- From: Steve Weiner [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 10:43 AM To: '[EMAIL PROTECTED]' Subject: Is

returning autoID after insert [sql] [tip]

2000-05-25 Thread Sean German
-Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 3:21 AM To: [EMAIL PROTECTED] Subject: Re: Avoiding using the MAX function In SQL server, you can do this: CREATE TRIGGER GetMax_ID ON mytable FOR INSERT AS SELECT mytable_ID FROM INSERTED

RE: returning autoID after insert [sql] [tip]

2000-05-25 Thread Sean German
for the changes? (Well, maybe that's just me.) /tip -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 9:47 AM To: '[EMAIL PROTECTED]' Subject: returning autoID after insert [sql] [tip

RE: CFCONTENT and SP6A

2000-05-23 Thread Sean German
Riddle me this Mr Watts, My server seems to have gone from parsing URLs from the left to parsing from the right. (NT4 SP5 IIS4 CF 4.0.1) While neither SP6 nor 6a has been applied, I have applied post-SP5 hot fixes. And what's an MS SP but the same ole hot fixes in a new package? So do we

RE: in consideration of large arrays?

2000-05-23 Thread Sean German
Nevermind :) FOund what I was looking for. Sean -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Monday, May 22, 2000 8:45 PM To: '[EMAIL PROTECTED]' Subject: in consideration of large arrays? Howdy fusioneers, I know theoretically the size of an array

in consideration of large arrays?

2000-05-22 Thread Sean German
Howdy fusioneers, I know theoretically the size of an array is limited by the available memory, but what other considerations need to be made when working with large arrays? I have a template that works with an array of about 6000 elements. No matter for how long I set the time out, the dern

RE: IIS set up passing variables in the path_info?

2000-05-11 Thread Sean German
Thanks Paul, Looks like we're working along the same lines, except we're adding .htm to the variable to get indexed by search engines that don't spider .cfm pages. So I link to page.cfm/variable.htm My trouble is my development box takes this url and knows to pull up page.cfm, while my

IIS set up passing variables in the path_info?

2000-05-10 Thread Sean German
Howdy, I've set up my site to pass variables like so, http://www.mycompany.com/page.cfm/variable.htm Then at the top of page.cfm I have a little ditty to look for htm in the cgi.path_info and fish out the variable. This is working on my test servers, but not in production, where I get an ugly

Integrity constraint violation on session table?

2000-04-13 Thread Sean German
Howdy, CF 4.0.1 on NT 4 SP5, MS SQL7 SP2 in back. Storing client variables in a database, I started getting the following error in the application.log about a month ago: "Error","TID=496","04/12/00","16:01:31","206.33.238.2","Mozilla/4.7 (Macintosh; I; PPC)","ODBC Error Code = 23000

RE: getting fields of a table(sql)

2000-04-07 Thread Sean German
Joe, SELECT syscolumns.name FROMsyscolumns INNER JOIN sysobjects ON sysobjects.id = syscolumns.id WHERE sysobjects.name = "Your_Table_Name" HTH, Sean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 07, 2000 5:05 PM To:

RE: Captupturing Form Elements

2000-04-06 Thread Sean German
Is there an analogous solution to looping through the fields of a query? -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 10:51 AM To: [EMAIL PROTECTED] Subject: Re: Captupturing Form Elements You can loop over all the fieldnames

RE: 237 checkboxes

2000-03-29 Thread Sean German
H. You could give each checkbox the same name (ex/ yes_no) with incrimental values (1,2,3,...237). The result is a single variable, form.yes_no, to define. The plus side is the result is a list you can just search for the yeses (boxes that were checked). The minus side is the result is a