Re: Error in url parameter

2008-06-04 Thread Katrina Chapman
Noy sure if you're having the same issue I was having the other day but I ran into a case Issue. You're passing the variable as Form_id in the URL but calling it as FORM_ID in your query. Try making them match. Both FORM_ID or both Form_id. I know this shouldn't matter but it fixed a similar

Re: do not increase counter is returns 0

2008-06-03 Thread Katrina Chapman
I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice.  This is a community and not a place for you to show how much more you know than the next guy. I really don't think this response is appropriate

Re: do not increase counter is returns 0 Apology to List

2008-06-03 Thread Katrina Chapman
promise to do the same. ;-) Thanks, Brian On Tue, Jun 3, 2008 at 2:17 PM, Katrina Chapman [EMAIL PROTECTED] wrote: I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice. This is a community

Wierd Query or Output Error

2008-06-02 Thread Katrina Chapman
It's been a very long time since I've done any real CF coding.  Almost 8 years to be exact.  But this is something that a 5 year old with a CFWACK book could do. I'm trying to populate a select box with a list of the karate schools in my database so that people can determine which school they

Re: Wierd Query or Output Error

2008-06-02 Thread Katrina Chapman
It is TinyInt.  How do I fix it?  Change the datatype? Thank you, Katrina If people knew how hard I worked to gain my mastery, it wouldn't seem so wonderful after all. --Michelangelo - Original Message From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent:

Re: Wierd Query or Output Error

2008-06-02 Thread Katrina Chapman
Dave you're awesome.  I knew there was a reason I learned CF instead of one of those other similar type languages.  Thank you, Katrina If people knew how hard I worked to gain my mastery, it wouldn't seem so wonderful after all. --Michelangelo - Original Message From: Dave Watts

Re: Wierd Query or Output Error

2008-06-02 Thread Katrina Chapman
Guess I should pay more attention to the list then. Thank you, Katrina If people knew how hard I worked to gain my mastery, it wouldn't seem so wonderful after all. --Michelangelo - Original Message From: Dave Watts [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday,

OT Why the sky is blue (was RE: CFQUERYPARAM dbname attribute)

2002-02-26 Thread Katrina Chapman
Acutally that's not why. This is why. Here is something interesting to think about: When you look at the sky at night, it is black, with the stars and the moon forming points of light o n that black background. So why is it that, during the day, the sky does no t remain black with the sun

RE: OT Why the sky is blue (was RE: CFQUERYPARAM dbname attribute)

2002-02-26 Thread Katrina Chapman
Sorry but that show annoys me. So I can't help you with this one. --K -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 9:43 AM To: CF-Talk Subject: RE: OT Why the sky is blue (was RE: CFQUERYPARAM dbname attribute) OK, but how does Gamara

RE: iif usage

2001-01-25 Thread Katrina Chapman
I think you have 2 too many #'s in there. You can also try #iif(isDefined("Attributes.display"),DE(RTrim("#Chr(35)##attributes.name#_qu ery.# attributes.display##Chr(35)#")),DE(""))# Chr(35) = # Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://w

RE: Continuous Clock - plus date with no DHTML

2001-01-25 Thread Katrina Chapman
You need to call it. Something like. head script language="JavaScript"!-- // set clock variables var blink=false var monthArray = new Array('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec ') var dn="AM" var myclock = '' function showTime(){ "removed to save bandwidth"

RE: Dynamic variable construction and it's use

2001-01-25 Thread Katrina Chapman
Actually if you look at the set statement he does need the #'s. He wouldn't need them if it was contstructed like this. cfset countvar= session.application_view_list[i].name "_red" The way that he has it written, with the var inside of "'s he does need the #'s. As far as getting the value of

SQL Server Index

2001-01-25 Thread Katrina Chapman
lags. I wanted to create an index on that field to speed up the search, but since it is a text field and longer than 900 bytes SQL won't let me index it. Does anyone know how I can speed up the search? Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com

RE: Page execution time too long?

2001-01-24 Thread Katrina Chapman
Merry Meet Matthew, If CF doesn't scale then how do you explain the best example of an extremely large, heavily trafficed site out there, Autobytel? Perhaps the problem isn't software but hardware. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com

RE: Page execution time too long?

2001-01-24 Thread Katrina Chapman
That's exaclty what happened. --K -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 12:06 AM To: CF-Talk Subject: Re: Page execution time too long? That's the impression I got. The CF-based site ran like a champ - their fulfillment

Query help

2001-01-23 Thread Katrina Chapman
) each record comes out of. Can this be done? If so how? Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com

FW: Regex prob (Re-Post)

2001-01-20 Thread Katrina Chapman
I sent this a week ago and didn't really get a response. So I'm posting again in the hopes that my question will be answered this time. TIA, --K -Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 4:49 PM To: cf-talk Subject: Regex prob

RE: Sessions

2001-01-19 Thread Katrina Chapman
://127.0.0.1/CFDOCS/Developing_Web_Applications_with_ColdFusion/05_Using _the_Application_Framework/dwa05_04.htm The second paragraph explains it better. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Michael Ross [mailto:[EMAIL

RE: Questio\n

2001-01-19 Thread Katrina Chapman
Merry Meet Kevin, cfset variable1 = "stuff" cfset variable2 = "variable1" cfoutput#variable1# - #evaluate(variable2)# - #variable2#/cfoutput Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Kevin Sc

RE: data in columns

2001-01-19 Thread Katrina Chapman
should work for you. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 3:48 PM To: CF-Talk Subject: data in columns Hello, I'm still a newbie with this o

RE: data in columns

2001-01-19 Thread Katrina Chapman
Silly thing, but if cbi is equal to "CBI" then IT'S NOT NULL. Period end of story. You don't need to add the and there. Slows you down. --K -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 6:09 PM To: CF-Talk Subject: RE:

RE: SQL help needed - Apples but not Oranges...

2001-01-19 Thread Katrina Chapman
%' AND Products.name NOT LIKE '%Oranges%' Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 7:51 PM To: CF-Talk Subject: SQL help needed - Apples but not Oranges... I'm

RE: Date problem

2001-01-17 Thread Katrina Chapman
Since you're using European dates I would suggest breaking up the date field. IE: !-- form page -- input type="text" name="dayofmonth"input type="text" name="month"input type="text" name="year" !-- end form page -- !-- submit page -- cfset final_date = month "/" dayofmonth

RE: passing variables between pages

2001-01-17 Thread Katrina Chapman
Have you given thought to using Session variables? --K -Original Message- From: Brent Goldman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 1:17 AM To: CF-Talk Subject: passing variables between pages Hi, I am currently writing an online resource scheduling

RE: Session age?

2001-01-17 Thread Katrina Chapman
Merry Meet Jon, The way that I understand session variables to work you can't tell when the var was originally set on the users machine because that time stamp is reset everytime they access a new page. If it wasn't updated with the current time then the user would timeout even if they weren't

RE: Varaible Names with -

2001-01-17 Thread Katrina Chapman
Merry Meet Troy, Have you tried aliasing the column name. IE: SELECT `column-name` as column_name FROM foo WHERE bar = 'bar' That usually works for me. Just make sure that you use ` (on the same key as the tilde) and not ' (single quote). Blessed Be, --Katrina -Original Message-

RE: HotMail in CF

2001-01-17 Thread Katrina Chapman
I don't see any reason why you wouldn't be able to build the same functionality as HotMail. --K -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 6:29 PM To: CF-Talk Subject: HotMail in CF Feedback please . . .! BEFORE I start on this

RE: Conditional loops

2001-01-17 Thread Katrina Chapman
Why bother with all the intricate ifs and loops? cfif IsDefined("queryname") cfoutput query="queryname" #foo# - #bar#br /cfoutput cfelse cfloop list="#list#" index="ii" #ii#br /cfloop /cfif Or cfif IsDefined("queryname")

RE: CF and FrontPage

2001-01-17 Thread Katrina Chapman
Merry Meet Matthieu, I'm not sure that installing FrontPage will mess up your server settings. Just make sure that once you write CF code to a template you DO NOT open that template with FP. It will stomp all over your CF code. I'd suggest DreamWeaver. That way you don't have to worry about

RE: rewrite filesize?

2001-01-17 Thread Katrina Chapman
Merry Meet Emmet, Use the "#File.FileSize#" attribute after the second upload to get the final size. Blessed Be, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January

RE: Sessions

2001-01-17 Thread Katrina Chapman
MM Michael, Can we see the application.cfm code? And/Or a link to the offending page. BB, --K -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 8:53 PM To: CF-Talk Subject: Re: Sessions opps I am sorry to everyone. It was pointed to

RE: iif with 3 expressions?

2001-01-15 Thread Katrina Chapman
Except for one problem this code is perfect. Don't use ParameterExists(). Use IsDefined("") instead. --K -Original Message- From: Adrian J. Moreno [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 6:40 PM To: CF-Talk Subject: Re: iif with 3 expressions? If I understand your

RE: Very frustrating form problem.

2001-01-13 Thread Katrina Chapman
Can we see the actual form... tag? I seem to remember problems sometimes arriseing out of that not being properly formatted. TIA, --K -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 11:56 PM To: CF-Talk Subject: Re: Very frustrating form

RE: need help..

2001-01-12 Thread Katrina Chapman
The particular regex (regular expression) provided will remove all non digits in the text field. If you want to replace anything that's not a digit or a letter at the begining of the field you need cfset temp = REReplaceNoCase(text, "[^a-z1-9]", "", "ONE") --K -Original Message- From:

Regex prob

2001-01-12 Thread Katrina Chapman
* COMPANY=A+America+Signs%2C+Inc%2E" But I get the full thing. Can anyone out there help me figure out what I'm doing wrong? Thank you, --Katrina Chapman http://www.katrinachapman.com http://www.cfchick.com ~~

RE: iif with 3 expressions?

2001-01-12 Thread Katrina Chapman
cfswitch? --K -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 9:39 PM To: CF-Talk Subject: iif with 3 expressions? I may be stretching, but I was wondering if there is a way to use IIF() to choose between 3 different expressions? What I have

RE: Database problems

2000-08-11 Thread Katrina Chapman
Can we see some code? You may be nesting your tags incorrectly. --K -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 5:00 AM To: CF-Talk Subject: Database problems I have a strange problem with inserts in an Access table. I can't seem to

RE: Forms in Email Question

2000-08-09 Thread Katrina Chapman
lto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 4:46 PM To: [EMAIL PROTECTED] Subject: RE: Forms in Email Question Why do you say people might not like it? What don't they like about it? From: "Katrina Chapman" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED

RE: Forms in Email Question

2000-08-09 Thread Katrina Chapman
They send you HTML formatted email messages. More importantly you can do this with the cfmail tag. Be forwarned however, if you're thinking of sending messages out in this format some people might not like it. You should give the option of non-html formatted. --K -Original Message-

RE: Multiple value Select

2000-08-08 Thread Katrina Chapman
There is your problem. ListFind looks for the element, specified second, in the list, specified first. So what you're doing is searching for a list within a list. You'll probably never find it. What you're doing is this cfset List1 = "3,5,8,9,4,2,1,6" cfset List2 = "1,2,3"

RE: Formatting Data

2000-08-07 Thread Katrina Chapman
You might be. Can we see the template in action? --K -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 10:45 AM To: [EMAIL PROTECTED] Subject: RE: Formatting Data Tha didn't change anything. Am I having a problem because it is in a

RE: Studio replacing characters

2000-08-07 Thread Katrina Chapman
That's the point Kevin. It shouldn't but it is. --K -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 12:55 PM To: [EMAIL PROTECTED] Subject: Re: Studio replacing characters option value="3" cfif getproduct.status is3 SELECTED /cfif

Hello?

2000-08-04 Thread Katrina Chapman
Is there anyone out there? --K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL

RE: Creating A List

2000-08-04 Thread Katrina Chapman
Are you trying to do this? list = simg1,limg1,simg2,limg2... Or list= simg1,simg2,limg1,limg2... --K -Original Message- From: Jeffrey V. Lemire [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 2:06 PM To: CFTALK Subject: Creating A List Hello Folks! I was wondering if

RE: Nested CFOUTPUTs

2000-08-04 Thread Katrina Chapman
From the docs. "You cannot nest CFOUTPUT tags." http://127.0.0.1/CFDOCS/CFML_Language_Reference/2_ColdFusion_Tags/lr2_060.ht m You cannot have a query driven output tag inside another output tag. What you can do though is instead of having CFOUTPUT#label.title#/CFOUTPUT you can just close your

RE: URL - UN - ENCODE - does this exist as function??

2000-08-04 Thread Katrina Chapman
From the docs "This function enables you to pass arbitrary strings within a URL, because ColdFusion automatically decodes all URL parameters that are passed to the template." http://127.0.0.1/CFDOCS/CFML_Language_Reference/3_ColdFusion_Functions/lr3_2 31.htm My question is this then. What do

RE: Going right past the login screen

2000-08-04 Thread Katrina Chapman
How are you passing the username and password through all the pages? Can we see the code for cf_login? --K -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 3:31 PM To: '[EMAIL PROTECTED]' Subject: RE: Going right past the login screen

RE: Help with database updating page

2000-08-04 Thread Katrina Chapman
This isn't easy but... you can append the productid to each form field name then when you update just get the id of the row to update off the end of the form field name. IE Product 1 input type="text" name="name1" Product 2 input type="text" name="name2" Then on the update page do a ReReplace

RE: Creating A List

2000-08-04 Thread Katrina Chapman
-Original Message- From: Katrina Chapman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 5:45 PM To: [EMAIL PROTECTED] Subject: RE: Creating A List Are you trying to do this? list = simg1,limg1,simg2,limg2... Or list= simg1,simg2,limg1,limg2... --K -Original Message