Title: Message
Another error
after migrating to MX
From the following
code I get an error: Invalid object name 'ae_dt1'.
select Distinct(field2) from ae_dt1 where
field8='PUBLIC'order by field2 desc
If I so the
same query in SQL Query analizer it works. Is there some atiquated CF4.0
co
Title: Message
I have a database
full of emails, unfortunately some of them are bad emails (ex: [EMAIL PROTECTED] no.com).
I have a script
that is mailling out to the entire database, when I was using CF4.0 it would
just throw the bad emails into the undeliverable folder. However when I
run
, 2003 11:27 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Client variables
yes, it is a SCOPE!
what version of cf did you upgrade from?
-Original Message-
From: Chris Holdman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:21 AM
To: '[EMAIL PROTECTED]'
S
Well I am not sure if this is a problem or not but one of my field names is
'request'and everything works weel on most of the pages of the
application except for when I am querying the 'request' field. Is 'request'
and reserved word in SQL or ColdFusion?
Christopher V. Holdman
Webmaster - Cit
Title: Message
I am finally
moving to MX and a script error is showing up
I am geeting a new
error that I have not seen...
The
requested scope CLIENT has not been enabled.
Before CLIENT variables can
be used, the CLIENT state management system mus
Title: Message
I have a query
output I am trying to group into an outline form. Below is the outline
formatt I am trying to achieve. Under III. I have several rows that have
'NEW' in them and want to expand just that portion of the outline. The
problem I get is that every row returning 'N
This worked out and I got another response to try
reFind and that worked too.
Thanks for the information.
Chris
--- Kory Bakken <[EMAIL PROTECTED]> wrote:
> Did you try LSIsNumeric? I don't know if this would
> filter out HEX, but its worth a try...
>
> Kory Bakken
>
s a number
and there is no character data in it. For this
situation I can't use the input to do the validations.
Thanks in advance,
Chris
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desk
]
Subject: Re: [KCFusion] Simple Query Question
Try IN ( ' #PreserveSingleQuotes(hlist)# ' )
-Ben Price
Chris Holdman writes:
> I am having a problem with the
>
> Statementfor some reason it is converting the ' to " when I insert
> it in my IN ( '
ave any ' around the numeric
values, but if the data type is varchar / char then you will have to have '
around the string.
varchar/char
select * from table
where field1='value1' AND field2 IN ( 'a','b','c')
select * from table
where fi
require you to split it up
select * from table
where field1='value1' AND field2 IN ( ' #hlist# ' )
Chris Holdman
<[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]&
field2='#index#'
)
Chris
--- Chris Holdman <[EMAIL PROTECTED]> wrote:
> I have a form with a multiple select box that I am
> want to build a query
> from, but am having problems. I set up an index
> loop with an OR statement,
> but I have obviously set it up wron
will have a page break between them. of course, I'm sure
it's only ie, but better than nothing.
-Original Message-From: Chris Holdman
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 11, 2003 3:03
PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion]
Pr
Title: Message
I have a directory listing
pulling from a database and sorting by departments. Everything work great
online, but some people are wanting to print it out...when they do sometimes the
page break for printing occurs in the middle of a department listing and the
second page does
ter - City of
Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED]
-Original Message-From: Ramsey Abu-Absi
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19,
2003 12:35 PMTo: [EMAIL PROTECTED]Subject: RE:
[KCFusion] ColdFusion and JSP pagesHi Chris,I
think the p
Title: Message
I have
a form where I am using cfform. I would like to also include my own
_javascript_ to use for validation, but it is not working. What am I doing
wrong?