What's wrong with this?

2002-09-21 Thread Rick Faircloth
Can anyone tell me why this code isn't working? I've got code on the same page that's doing the exact same thing, but with different queries and arrays, and no errors are occuring... Select UtilityCompanyID, UCName from UtilityCompanies order by UCName Rick __

What's wrong with this?

2002-09-21 Thread Rick Faircloth
Can anyone tell me what's wrong with this code? I've got other code on the page doing the exact same thing, but with different queries and arrays and no errors are occuring. Select UtilityCompanyID, UCName from UtilityCompanies order by UCName Here's th

What's wrong with this...

2003-09-27 Thread Cutter (CF-Talk)
Why does this always evaluate to 1?is not "")> (qDates.ID4 is "")> is "")> This is driving me nuts. I can never seem to get the IF...AND to work right. What am I missing here?Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: What's wrong with this?

2002-09-21 Thread Paul Giesenhagen
gt; Sent: Saturday, September 21, 2002 8:57 PM Subject: What's wrong with this? > Can anyone tell me why this code isn't working? > I've got code on the same page that's doing the exact same thing, > but with different queries and arrays, and no errors are occuring... &g

Re: What's wrong with this?

2002-09-21 Thread Brook
What error are you getting? What version of CF? I think the Current Row variable changed slightly in CFMX, maybe some one can confirm? It may start at 0 or 1 I'm not sure. If 0, that may cause an error At 09:57 PM 21/09/02 -0400, you wrote: >Can anyone tell me why this code isn't working?

Re: What's wrong with this?

2002-09-21 Thread Paul Giesenhagen
Oops sorry didn't see your error message ... :( Paul Giesenhagen QuillDesign - Original Message - From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, September 21, 2002 9:02 PM Subject: What's wrong with

RE: What's wrong with this?

2002-09-21 Thread Rick Faircloth
hanks for your help. Rick -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 9:54 PM To: CF-Talk Subject: Re: What's wrong with this? Oops sorry didn't see your error message ... :( Paul Giesenhagen QuillDesign - O

RE: What's wrong with this?

2002-09-21 Thread Rick Faircloth
Thanks for the reply, Brook. You'll see from my reply to Paul that the array just needed to be 2-dimensional... Rick -Original Message- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 10:13 PM To: CF-Talk Subject: Re: What's wrong with this? What

Re: What's wrong with this?

2002-09-21 Thread Dina Hess
You've created a 3-dimensional array and you're populating a 2-dimensional array... > > > Select UtilityCompanyID, UCName > from UtilityCompanies > order by UCName > > > GetUC.UtilityCompanyID[CurrentRow]> > > > > > Rick > > > _

RE: What's wrong with this?

2002-09-21 Thread Rick Faircloth
Thanks, Dina! Rick -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 10:09 PM To: CF-Talk Subject: Re: What's wrong with this? You've created a 3-dimensional array and you're populating a 2-dimensional array... >

What's wrong with this script?

2000-09-25 Thread Michael Gagnon
Hi! I can't see what's wrong with this script. I use the same thing on another page and it works fine. It gives me the same answers on each row (the answers for the 1st row). #ID# #txt# Here's the

What's wrong with this query?

2001-02-16 Thread Terri Stocke
Okay, I give up. Can someone take a peek at this query and tell me what's wrong? I keep getting an Oracle error, "Invalid column name". If I take the line out "AND TO_CHAR(SUG_SUGGESTIONS.STATUS_DATE, 'DD-MON-YY') <= #variables.comparisondate#" I have no problems. Oh, curse these date problems!

Re: What's wrong with this...

2003-09-27 Thread Jim McAtee
Apparently id1, id2, and id4 always have something in them.Try explaining what you want in English.- Original Message - From: "Cutter (CF-Talk)" <[EMAIL PROTECTED]>To: "CF-Talk" <[EMAIL PROTECTED]>Sent: Saturday, September 27, 2003 10:20 PMSubject: What

RE: What's wrong with this...

2003-09-27 Thread Mike Brunt
, September 27, 2003 9:20 PMTo: CF-TalkSubject: What's wrong with this...Why does this always evaluate to 1?is not "")>(qDates.ID4 is "")>is "")>This is driving me nuts. I can never seem to get the IF...AND to workright. What am I missing here?Cutter  _[ Tod

Re: What's wrong with this...

2003-09-28 Thread Calvin Ward
ating the code bit and testing it seperately to see if you get the results out of that logic you expect?- Calvin  - Original Message -   From: Cutter (CF-Talk)   To: CF-Talk   Sent: Sunday, September 28, 2003 12:20 AM  Subject: What's wrong with this...  Why does this always evaluate to 1?

What's wrong with this code?

2005-05-12 Thread jgeorges
. . origtext contains double quotes (") which the REPLACE function does not convert. TIA, Sam ___ ~| Logware (www.logware.us): a new and convenient web-based tim

What's wrong with this simple UDF?

2002-03-12 Thread Jamie Jackson
function pad(str, length, padChar) { str = trim(str); var strLen = len(str);//<--##This is the error line## var difference = length - strLen; if (strLen GT length) { newStr = str; } else { newStr = str & repeatstring(padChar, difference); } return newstr; } Here's the error I'

RE: What's wrong with this script?

2000-09-25 Thread Chapman, Katrina
You need to remove the languages. Try This #ID# #txt# > -Original Message- > From: Michael Gagnon [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 25, 2000 5:07 PM > To: CF-Talk > Subject: What's wr

Re: What's wrong with this script?

2000-09-25 Thread Mark Adams
You don't need #languages.Abrev# just #Abrev# -Mark :o) - Original Message - From: Michael Gagnon <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, September 25, 2000 5:07 PM Subject: What's wrong with this script? > Hi! > > I can'

Re: What's wrong with this script?

2000-09-25 Thread Michael Gagnon
Comercialización 3 Sous-traitant Subcontractor Thanks! - Original Message - From: "Chapman, Katrina" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 25, 2000 9:16 PM Subject: RE: What's wrong with this script? > You ne

RE: What's wrong with this script?

2000-09-26 Thread Chapman, Katrina
[EMAIL PROTECTED]] > Sent: Monday, September 25, 2000 5:29 PM > To: CF-Talk > Subject: Re: What's wrong with this script? > > > Same results. I get the following: > > (ID Français English Español) > 1 Producteur Producer Productor > 2 Producteur Producer Productor

Re: What's wrong with this script?

2000-09-27 Thread Michael Gagnon
Yup! Tried that to. - Original Message - From: "Chapman, Katrina" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 26, 2000 2:35 PM Subject: RE: What's wrong with this script? > MM Michael, > > Okay then h

RE: What's wrong with this script?

2000-09-27 Thread Dan Haley
it enough to define it, I just know trial and error will usually come up with a work-around! Dan -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 8:08 AM To: CF-Talk Subject: Re: What's wrong with this script? Yup! Tried th

Re: What's wrong with this query?

2001-02-16 Thread Ryan
Doesn't #variables.comparisondate# need to be quoted? I think it might be trying to find a field called 16-Feb-01. Ryan At 14:26 2/16/01 -, you wrote: >Okay, I give up. Can someone take a peek at this query and tell me what's >wrong? I keep getting an Oracle error, "Invalid column name". >I

RE: What's wrong with this query?

2001-02-16 Thread John Stanley
Dont you need quotes around the comparison date ? And is "MON" a valid month argument ? SELECT SUG_SUGGESTIONS.SUGGESTION_ID, SUG_SUGGESTIONS.SUGGESTION_NAME, SUG_SUGGESTIONS.STATUS_CODE, SUG_SUGGESTIONS.STATUS_DATE, SUG_SUGGESTIONS.PRIMARY_SUGGESTOR_USERID,

RE: What's wrong with this query?

2001-02-16 Thread Peter J. MacDonald
02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 09:27 To: CF-Talk Subject: What's wrong with this query?

Re: What's wrong with this query?

2001-02-16 Thread Terri Stocke
Ryan, You da man. Thanks! ;) Terri Original Message Follows From: Ryan <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: What's wrong with this query? Date: Fri, 16 Feb 2001 08:38:08 -0600 Doesn't #variables.comparisond

Re: What's wrong with this code?

2005-05-12 Thread Stephen Moretti
jgeorges wrote: >. > > > >. > >origtext contains double quotes (") which the REPLACE function does not >convert. > > You don't need the #'s around the replace, but thats not really a problem So what is or isn't happening that you are expecting to happen? Stephen ~~~

RE: What's wrong with this code?

2005-05-12 Thread Adkins, Randy
CF-Talk Subject: What's wrong with this code? .. .. origtext contains double quotes (") which the REPLACE function does not convert. TIA, Sam ___ ~| Logwar

Re: What's wrong with this code?

2005-05-12 Thread Scott Weikert
jgeorges wrote: >. > > > > > > > >. > > > >origtext contains double quotes (") which the REPLACE function does not >convert. > > > Do you WANT the double quotes to vanish with the replace or not? If so do so that the double quotes are part of the variable itself. ~

RE: What's wrong with this code?

2005-05-12 Thread Adrian Lynch
Your code is doing this: so it looks for the string """. Not as you seem to want, the double quote. Try: Ade -Original Message- From: jgeorges [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 17:29 To: CF-Talk Subject: What's wrong with this code? ..

RE: What's wrong with this code?

2005-05-12 Thread jgeorges
When the text is submitted from a form with an INPUT statement (text box) the following code works: When the text is submitted from a form with a TEXTAREA statement the following code works: Note, I am trying to eliminate double quotes. 'squote' is actually the acute symbol. I

RE: What's wrong with this code?

2005-05-12 Thread Burns, John D
Laboratories, Inc. | Web Developer -Original Message- From: jgeorges [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 12:29 PM To: CF-Talk Subject: What's wrong with this code? .. .. origtext contains double quotes (") which the RE

Re: What's wrong with this code?

2005-05-12 Thread Douglas Knudsen
why do you need to remove them in the first place? Take a look at JSStringFormat() for display layer and use cfqueryparm for DB layer. DK On 5/12/05, jgeorges <[EMAIL PROTECTED]> wrote: > > When the text is submitted from a form with an INPUT statement (text box) > the following code works:

RE: What's wrong with this simple UDF?

2002-03-12 Thread Shawn Grover
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 12:27 PM To: CF-Talk Subject: What's wrong with this simple UDF? function pad(str, length, padChar) { str = trim(str); var strLen = len(str);//<--##This is the error line## var difference = length - strLen; if (strLen G

Re: What's wrong with this simple UDF?

2002-03-12 Thread Jamie Jackson
> str = trim(str); > if (strLen GT length) { > > >Shawn Grover > >-Original Message- >From: Jamie Jackson [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, March 12, 2002 12:27 PM >To: CF-Talk >Subject: What's wrong with this simple UDF? > > &

RE: What's wrong with this code? Resolved, sortta

2005-05-12 Thread jgeorges
[EMAIL PROTECTED] To: cf-talk@houseoffusion.com Date: Thu, 12 May 2005 12:54:47 -0400 (EDT) Subject: RE: What's wrong with this code? When the text is submitted from a form with an INPUT statement (text box) the following code works: When the text is submitted from a form with