>It appears section is a reserved word. Your WHERE clause should work if you
>use: WHERE [section] = #i#
>
>On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk wrote:
Thanks. I didn't think to check for reserved words. That was the problem.
~~
It appears section is a reserved word. Your WHERE clause should work if you
use: WHERE [section] = #i#
On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk wrote:
>
>
> SELECT *
> FROM questions
> WHERE section = #i#
>
>
>
~|
Want
Looks like section is reserved in QoQ. Try
SELECT *
FROM questions
WHERE [section] = #i#
From: "Kris Sisk"
Sent: Thursday, April 29, 2010 3:34 PM
To: "cf-talk"
Subject: What's wrong with this QoQ?
This is driving
>>So image name conflict won't be a problem.
I see, then checking in the query is your solution.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 2:12 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> >>I don't want to rename the files and include them,
> I want to avoid adding the files to the directory completely.
>
> I see, but what if t
>>I don't want to rename the files and include them,
I want to avoid adding the files to the directory completely.
I see, but what if two users want to enter two different images having
the same file name?
--
___
REUSE CODE! Use custom tags;
See http://www.c
o everyone else for your responses, as well!
Rick
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 1:26 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> Yes you are, you added code to what I put in my last
sing something?
>
>
>
> > -----Original Message-
> > From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 16, 2008 12:43 PM
> > To: CF-Talk
> > Subject: Re: What's wrong with this query?
> >
> > You want to insert valu
#x27;#photolist.name#')
values (,
)
Am I still missing something?
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 12:43 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> You want to insert values into
7;, '94219')' at line
> 10
>
> Does my syntax match your referenced code? And the referenced code doesn't
> include a reference to the values to be inserted, so maybe the "values"
> clause
> is in the wrong position?
>
>
>
> > -Orig
photos where pho'
at line 1
> -Original Message-
> From: Richard Dillman [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 12:05 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> Wouldnt you put an IF at the begining of the stat
[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 12:06 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> >>So how do I modify the query, which now looks like this...
>
> This is it, a unique index will detect the error, but it will not solve it.
> Che
Thanks for the explanation and code, Claude!
> -Original Message-
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 12:03 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> >>Can you be a little more explic
> Sent: Friday, May 16, 2008 12:02 PM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> Your attempt though does not match the syntax used in the link I provided.
> It is failing because of the SQL after your WHERE EXISTS. Also your SELECT
> should be pulling o
>>So how do I modify the query, which now looks like this...
This is it, a unique index will detect the error, but it will not solve it.
Checking if the file already exists will not solve the problem either.
So better make sure the file name is unique first and eliminate the
possibility of a pro
Wouldnt you put an IF at the begining of the statement?
IF NOT EXISTS (SELECT PHOTO_FILENAME
FROM HMLS_PHOTOS
WHERE PHOTO_FILENAME = )
INSERT INTO HMLS_PHOTOS
(PHOTO_FILENAME,
PHOTO_MLS_NUMBER)
VALUES (,
)
--
--
ry..." error in the CF app log.
> -Original Message-
> From: Wim Lemmens [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:41 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
>
>
> insert into hmls_photos
>
>>Can you be a little more explicit about how you do that, Claude?
I've never used CreateUUID before.
I rename the file when it is uploaded. Ie:
Then I analyse the true file type:
The file uploaded does not contain a valid image...
T
#photolist.name#
> values (,
> )
>
>
>
> > -Original Message-
> > From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 16, 2008 11:33 AM
> > To: CF-Talk
> > Subject: Re: What's wrong with this query?
> >
> > Looks l
e="#photolist.name#">,
> value="#listfirst(photolist.name, '_')#">)
>
>
>
>> -Original Message-
>> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
>> Sent: Friday, May 16, 2008 11:33 AM
>> To: CF-Talk
>&
[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:33 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> Looks like the process for MySQL is very similar to the Oracle one I posted
> a link to earlier and someone else wrote an example of.
>
> http://fo
insert into hmls_photos
(photo_filename, photo_mls_number)
values (,
)
Duplicate entry: #photolist.name#
That should do the trick!
Wim.
~~~
value
>
>
>
>
>
> > -Original Message-
> > From: Dave Watts [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 16, 2008 11:19 AM
> > To: CF-Talk
> > Subject: RE: What's wrong with this query?
> >
> > > Not being so well-versed
nal Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:19 AM
> To: CF-Talk
> Subject: RE: What's wrong with this query?
>
> > Not being so well-versed in indexing (just starting using
> > those in MySQL 5), I don't understan
; Sent: Friday, May 16, 2008 11:10 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> >>I don't remember ever running a query like this one, so I'm
> not sure it's even a valid approach.
>
> My approach is to rename every file using C
ique index? Does it cause MySQL 5
>> to screen inserts for duplicates and reject them?
>>
>> ???
>>
>> Rick
>>
>> > -----Original Message-
>> > From: Didgiman [mailto:[EMAIL PROTECTED]
>> > Sent: Friday, May 16, 2008 11:04 AM
>> > To: CF-Talk
mysql has an extremely useful extension to standard sql: ON DUPLICATE
KEY UPDATE ...
check out mysql ref manual for details - it sounds like what you may
want to use...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Rick Faircloth wrote:
> Tried that at the same time I put the "where clau
I'm not that familiar with MySQL, but by definition (on Oracle at least) a
unique index will reject any query that tries to insert a duplicate value and
throws an error. You can catch that error in your application.
Wim.
~|
Ad
; Is that function a part of creating a unique index? Does it cause MySQL 5
> to screen inserts for duplicates and reject them?
>
> ???
>
> Rick
>
> > -Original Message-
> > From: Didgiman [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 16, 2008 11:04 AM
Sorry for not stating the db... it's MySQL 5.
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:08 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> Rick, I do not know what database you are u
> Not being so well-versed in indexing (just starting using
> those in MySQL 5), I don't understand how having a unique
> index on the photo_filename column will prevent an insert of
> a duplicate value.
>
> Is that function a part of creating a unique index? Does it
> cause MySQL 5 to screen
s for duplicates and reject them?
???
Rick
> -Original Message-
> From: Didgiman [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:04 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> You could always create a unique index on the photo_filenam
otolist.name# not in
(select photo_filename from hmls_photos)
values (,
)
> -Original Message-
> From: Kris Jones [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 11:01 AM
> To: CF-Talk
> Subject: Re: What&#x
>>I don't remember ever running a query like this one, so I'm
not sure it's even a valid approach.
My approach is to rename every file using CreateUUID
() function.
to make sure there is no duplicate problem.
--
___
REUSE CODE! Use custom tags;
See http://ww
t query.
>
>
>
> > -Original Message-
> > From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 16, 2008 10:58 AM
> > To: CF-Talk
> > Subject: Re: What's wrong with this query?
> >
> > When I have done this, I used a NOT EXISTS
an
remember) a subquery inside an insert query.
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 10:58 AM
> To: CF-Talk
> Subject: Re: What's wrong with this query?
>
> When I have done this, I used a NOT EXISTS,
You could always create a unique index on the photo_filename column.
Wim.
On Fri, May 16, 2008 at 4:57 PM, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> When I have done this, I used a NOT EXISTS, so something like this random
> example I just pulled from Google:
>
> http://archives.postgresql.org/pg
I think you'd need hash-marks (string delimiters) around
photolist.name in the where clause, right?
where '#photolist.name#' not in (select photo_filename from htmls_photos)
-KJ
> I don't remember ever running a query like this one, so I'm
> not sure it's even a valid approach.
>
> Bu
When I have done this, I used a NOT EXISTS, so something like this random
example I just pulled from Google:
http://archives.postgresql.org/pgsql-general/2003-06/msg01683.php
On Fri, May 16, 2008 at 9:40 AM, Rick Faircloth <[EMAIL PROTECTED]>
wrote:
> I don't remember ever running a query like t
Take a look at your "selected" option in the CFSELECT. See CFDOC clip below:
One or more option values to preselect in the selection
list. To specify multiple values,
use a comma-delimited list. This attribute applies only if
selection list items are generated
Les,
There is nothing wrong with it as far as I can see. I just put it on a test
page and it worked fine on my development and production servers. Do you get
the little flash movie that says it is loading or anything at all? Is this
wrapped in some other tags like cfformitem or anything? Can you em
Found the problem. I copied code from Sarge's blog and there was a typo on
of the memory settings.
Thanks for all of your help.
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 5:58 PM
To: CF-Talk
Subject: RE: What's wrong
PROTECTED]
Sent: Wednesday, March 15, 2006 11:19 AM
To: CF-Talk
Subject: RE: What's wrong with this jvm.config file?
Thanks. Still can't get it to fire up... where should I look for errors?
Also, can the jvm.config file have returns from a text editor? or should i
turn line wraps off?
o: CF-Talk
Subject: RE: What's wrong with this jvm.config file?
Whoops... forgot the co-king Pete Freitag
http://www.petefreitag.com/articles/gctuning/
-Mark
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 10:44 AM
To: CF-Talk
S
Whoops... forgot the co-king Pete Freitag
http://www.petefreitag.com/articles/gctuning/
-Mark
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 10:44 AM
To: CF-Talk
Subject: RE: What's wrong with this jvm.config file?
Th
chart which I find quite useful (though I don't know how
accurate it is)
http://www.folgmann.de/en/j2ee/gc.html
-Mark
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 9:02 AM
To: CF-Talk
Subject: RE: What's wrong with this jvm.c
Thanks Steve!
-Original Message-
From: Steve Brownlee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 10:21 AM
To: CF-Talk
Subject: RE: What's wrong with this jvm.config file?
Some good starting links:
http://java.sun.com/j2se/1.5.0/docs/guide/vm/gc-ergonomics.html
15, 2006 10:02 AM
> To: CF-Talk
> Subject: RE: What's wrong with this jvm.config file?
>
> Ok. Thanks. One last thing... Where might I find some of
> these GC options
> online?
>
> ~Che
>
> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTE
Ok. Thanks. One last thing... Where might I find some of these GC options
online?
~Che
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 9:50 AM
To: CF-Talk
Subject: RE: What's wrong with this jvm.config file?
Che,
If you have s
ilnonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 8:35 AM
To: CF-Talk
Subject: RE: What's wrong with this jvm.config file?
Thanks Mark. I am not using the admin to edit this file. I was hand editing
it. Any recommendations as to which GC to use? I know there are a few. I
-Talk
Subject: RE: What's wrong with this jvm.config file?
Che,
You've specified 2 Garbage collectors.
When you make changes to this file and you want to switch GC params, don't
use the CF Admin to do it. It will automatically insert the extraparams in
there. Get ri
Che,
You've specified 2 Garbage collectors.
When you make changes to this file and you want to switch GC params, don't
use the CF Admin to do it. It will automatically insert the extraparams in
there. Get rid of the switch:
-XX:UseParNewGC and restart.
I have a blog about this issue at:
http:/
Thanks for the tip, Deanna...I'll give it a try.
Rick
> -Original Message-
> From: Deanna Schneider [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 10, 2006 8:00 AM
> To: CF-Talk
> Subject: Re: What's wrong with this?
>
>
> I don't know mysq
That worked, too Deanna...thanks.
Rick
> -Original Message-
> From: Deanna Schneider [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 10, 2006 8:00 AM
> To: CF-Talk
> Subject: Re: What's wrong with this?
>
>
> I don't know mysql, but in Oracle, the
If your db server's time is correct, just use DateTime=now(). Now() is
built in with MySQL. If you'd like to test it do: select now() from
tableName.
--Ferg
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231905
Ar
are putting
the default timestamp in)
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Friday, February 10, 2006 8:00 AM
To: CF-Talk
Subject: Re: What's wrong with this?
I don't
I don't know mysql, but in Oracle, the default option is only relevant when
a field is created, not updated.
Also, I would try using the native function:
DateTime = CURRENT_TIMESTAMP
when you do the update. Unless your time on your CF server is set
differently than the time on the mysql server, th
It definitely SHOULD be if its default has been set.
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 11:12 PM
To: CF-Talk
Subject: RE: What's wrong with
age-
> From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 09, 2006 10:48 PM
> To: CF-Talk
> Subject: RE: What's wrong with this?
>
>
> DateTime is a datatype in Access and reserved in Access... Don't
> know about
> MySQL (it's prob
TE query.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Good luck!
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 9:18 PM
To: CF-Talk
Subj
er
?
Rick
> -Original Message-
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 09, 2006 9:03 PM
> To: CF-Talk
> Subject: Re: What's wrong with this?
>
>
> I never have worked with MySQL but I know with other databases I
> would
I never have worked with MySQL but I know with other databases I would strip
off the CreateODBCDateTime() and it works fine. Does MySQL not have a
function for the system date/time? I usually make that the default value
for any timestamps and then if updating to it I just set to the function.
On
Something I have done in the past that may work for you. It would be somewhere
between your current method and the full writing out of static pages method.
In my admin, when a new dynamic page is inputted and published, I write a file
with a line like this.
That file would contain a few line
Sent: Thursday, October 20, 2005 8:17 AM
To: CF-Talk
Subject: RE: WHAT'S WRONG WITH THIS QUERY?
I was always under the impression that you couldn't join tables in
anything other than a SELECT query.
-Original Message-
From: Nomad [mailto:[EMAIL PROTECTED]
Sent: Wednesday, Octobe
.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: 20 October 2005 14:17
To: CF-Talk
Subject: RE: WHAT'S WRONG WITH THIS QUERY?
I was always under the impression that you couldn't join tables in anything
other than a SELECT query.
-Original Message-
From: Nom
I think the syntax is along the lines of
UPDATEtblA
SET tblA.something = tblB.something
FROM tblB
WHERE (tblA.something = tblB.something)
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: 20 October 2005 14:17
To: CF-Talk
Subject: RE: WHAT'S
I was always under the impression that you couldn't join tables in anything
other than a SELECT query.
-Original Message-
From: Nomad [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 6:04 PM
To: CF-Talk
Subject: WHAT'S WRONG WITH THIS QUERY?
Hello,
This query works fine wit
I don't belive multi-table UPDATE statements are a standard SQL
feature. I'm kind of surprised that Access supports them. Subqueries
(subselects), on the other hand, are a standard feature.
cheers,
barneyb
On 10/19/05, Nomad <[EMAIL PROTECTED]> wrote:
> Thanks Barney,
> This one works.
>
> But
Thanks Barney,
This one works.
But wonder why the other one doesn't. Thought it would be good to know.
Ben
- Original Message -
From: "Barney Boisvert" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, October 20, 2005 12:22 PM
Subject: Re: WHAT'S WR
Did you try this (or something like it)?
update newproduct set
details = (select details from oldproduct where dealerpartno =
newproduct.dealerpartno)
cheers,
barneyb
On 10/19/05, Nomad <[EMAIL PROTECTED]> wrote:
> Hello,
>
> This query works fine with Access.
>
> With SQL server it creates an e
[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
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:
You're not wanting to replace " with ´ do you? In the code,
are your quotes the literal " symbol or are they the HTML code " ?
If it's the former, do replace(origtext, chr(34),squote,"ALL")
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-Orig
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
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?
..
..
origtext conta
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.
~
Don't you need to evaluate the values of dqoute and sqoute within the
Replace statement else it will search for " within the
Text and not the actual " symbol.
-Original Message-
From: jgeorges [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 12:29 PM
To: CF-Talk
Subject: What'
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
~~~
Hopefully I didn't miss anything, but it looks like you are trying to accomplish the following (in comments):if (Len(qDates.ID1) AND Len(qDates.ID2) AND Len(qDates.ID4)) // if 1, 2, and 4 contain a value (other than blank) variable.status = 1;else if (Len(qDates.ID1) AND Len(qDates.ID2) AND NOT
Difficult to know. Can you give us the business rules you are trying toaccomplish here?Kind Regards - Mike BruntWebapper Services LLCWeb Site http://www.webapper.comBlog http://www.webapper.netWebapper -Original Message-From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]Sent: Saturday, Septem
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's wrong with this...> Why does this a
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...
>
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
>
>
>
_
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
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
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 this?
> Can anyone tell me what's wrong
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?
Rick,
Are you getting any errors? It looks like you have a 2 dimension array
.but you are setting it to a 3 dimension.
Try
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Rick Faircloth" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, September 21, 2002
That works!
Thanks,
Jamie
On Tue, 12 Mar 2002 13:03:55 -0700, in cf-talk you wrote:
>You have to do your VAR statements before anything else.
>
>Try it this way:
>
>function pad(str, length, padChar) {
> var strLen = len(trim(str));
> var difference = length - strLen;
>
> str = trim(str);
> if
You have to do your VAR statements before anything else.
Try it this way:
function pad(str, length, padChar) {
var strLen = len(trim(str));
var difference = length - strLen;
str = trim(str);
if (strLen GT length) {
Shawn Grover
-Original Message-
From: Jamie Jackson [
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
TO_CHAR(SUG_SUGGESTIONS.STATUS_DATE, 'DD-MON-YY') <=
#variables.comparisondate#
Changed to
TO_CHAR(SUG_SUGGESTIONS.STATUS_DATE, 'DD-MMM-YY') <=
#variables.comparisondate#
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183
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,
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
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
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
[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
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
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't see what's wrong with this script. I
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 wrong with this script?
>
>
100 matches
Mail list logo
