RE: [KCFusion] IsNumeric function and hex values?

2003-03-19 Thread Chris Stallo
; > -Original Message- > From: Chris Stallo [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 19, 2003 9:25 AM > To: [EMAIL PROTECTED] > Subject: [KCFusion] IsNumeric function and hex > values? > > > I've got problem with the IsNumeric function in > Col

[KCFusion] IsNumeric function and hex values?

2003-03-19 Thread Chris Stallo
I've got problem with the IsNumeric function in ColdFusion. I've got a page set up with a form on it. On the page this form calls I am doing validation to make sure the entered value is numeric by using the IsNumeric function - IsNumeric(form.variable) If I pass in a value like 74d6, it passes

Re: [KCFusion] Simple Query Question

2003-03-13 Thread Chris Stallo
You could add a boolean variable and then use it to check to see if it's the first time through, if it is don't use the OR, otherwise add the OR before you add the next variable. Might be able to use the IN clause as well instead of hte OR. select * from table where field1='value1'

RE: [KCFusion] messed up indexes in sql server

2002-11-30 Thread Chris Stallo
as the syntax appeared, but that command > without any other attributes > will reindex the entire db? I've also never seen the > runtime index > declaration syntax you suggested, so I'll play with > that. I'll let you know > if I get anywhere with it. > > -Origin

Re: [KCFusion] messed up indexes in sql server

2002-11-30 Thread Chris Stallo
Have you tried doing a reindex of the entire database? DBCC REINDEX I think. I realize this takes quite a while, but we do this periodically to keep things straightened up. What we've seen in the past when dealing with SQL Server is the stored procs are using the correct indexes on the develomen

Re: [KCFusion] actual space (off topic btw)

2002-10-18 Thread Chris Stallo
Here's a link to the MSKB article. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q65963 For all standard data types, NULL values stored by Microsoft SQL Server do not take up any additional storage space. The only associated overhead for a column containing a NULL value is a single byte

Re: [KCFusion] deletes on database?

2002-09-12 Thread Chris Stallo
Adaryl, Here's my $.02 Chapter 32 (Working With Stored Procedures), page 1057, in the book Web Application Construction Kit Fourth Edition (Ben Forta and Nate Weiss), there is a pretty good description about why performance may be enhanced by using stored procedures: "Depending on the situation

Re: [KCFusion] One user not getting cookies

2002-08-27 Thread Chris Stallo
You might have her try clearing her cache, delete her temp Internet files and cookies, etc? We've had to do that before to reset the way it stored the cookies. For some reason or other they got currupted. Chris --- Keith Purtell <[EMAIL PROTECTED]> wrote: > Our company intranet uses a cookie-ba

Re: [KCFusion] SQL brain teaser

2002-07-19 Thread Chris Stallo
n before the table names? > Is that something DBMS specific? > A. > - Original Message - > From: "Chris Stallo" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, July 19, 2002 7:44 AM > Subject: Re: [KCFusion] SQL brain teaser > > >

Re: [KCFusion] SQL brain teaser

2002-07-19 Thread Chris Stallo
I set up two tables. #tmp_cat contains a cat_number and category description. #tmp_question contains a cat_number and the question. cat_number is the relationship between the two. The thing that helps is the TOP command in SQL. It returns the TOP N rows back. select category, c

[KCFusion] Finding country based off of e-mail address

2002-04-10 Thread Chris Stallo
Does anyone know if there is a way to determine based off of a person's e-mail address what country that e-mail address originated from? I've got the list of the ISO country names and thought about checking to see if the address ends in like .br for Brazil or .ar for Argentina, etc, but I wasn't

[KCFusion] Sending Email via CF problems

2002-01-14 Thread Chris Stallo
We have been sending e-mail through ColdFusion for quite a while now. Today it just stopped working. After talking with the people in charge of the Exchange Server they said that our server was set up with 'open relay' and this was shut off over the weekend. The message we are getting in the l

RE: [KCFusion]KCColdFusionUsers:UpcomingmeetingonTuesdaythe9th

2001-10-05 Thread Chris Stallo
Unsubcribe Robin [EMAIL PROTECTED] --- Nathan Haley <[EMAIL PROTECTED]> wrote: > What the hell? > > -Original Message- > From: ROBIN KRAUSE [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 05, 2001 3:39 PM > To: [EMAIL PROTECTED] > Subject: Re: > [KCFusion]KCColdFusionUsers:Upcomi

[KCFusion] Can

2000-07-20 Thread Chris Stallo
Hello all. We've taken over some ColdFusion code that was written by someone else. Some of the files open just fine and we can change them and everything works ok. However...other files open ok, but they look like this: Allaire Cold Fusion Template Header Size: New Versionž%Õ[ŠÿQ.ºÆ... Ðhqؤ