Yeah, I was pretty sure too, but thought maybe things had changed
since MS SQL 2000. In any case, in SQL 2000, it fails with:
text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator.
Is this still the case with MS SQL 2005?
Cheers,
Kris
> I'm
05, 2006 11:43 AM
To: CF-Talk
Subject: Re: CF SQL question
Kris,
Inequality <> works just fine for MS SQL Server TSQL for versions 2000
and
2005.
Teddy
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-
Kris,
Inequality <> works just fine for MS SQL Server TSQL for versions 2000 and
2005.
Teddy
On 10/5/06, Kris Jones <[EMAIL PROTECTED]> wrote:
>
> I don't think you can do equality (inequality) comparisons on a text
> field in TSQL or ANSI SQL. You can do LIKE comparisons.
>
> > I found what was
I don't think you can do equality (inequality) comparisons on a text
field in TSQL or ANSI SQL. You can do LIKE comparisons.
> I found what was causing the problem and maybe someone can explain why -
> -the field was originally set as a text field... I changed it to nvarchar
> and the error went a
Should be
where members.speakers != ""
The exclamation point inverts the equals.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 7:56 AM
To: CF-Talk
Subject: CF SQL question
I hope this is an easy one. using SQL Server 2000.. Have a q
I'm guessing as it's a SQL error and has a where clause then it is in the SQL !
Also for the length test in CF, I would go for len(tim(variableName)
(whether you put 'GT 0' after this test is the subject of another
recent thread ;-) )
On 10/5/06, Kris Jones <[EMAIL PROTECTED]> wrote:
> Tim,
>
>
Tim,
the problem is, that you use double quotes instead of single quotes...
Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: h
You need to use single quotes '' to delimit strings.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 9:11 AM
To: CF-Talk
Subject: RE: CF SQL question
I'm testing for empty fields in the sql query - - -
I've tried
data type
change
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 9:08 AM
To: CF-Talk
Subject: RE: CF SQL question
> I hope this is an easy one. using SQL Server 2000.. Have a
> query trying to test for empty fields. tried the following
>
Empty string
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 9:02 AM
To: CF-Talk
Subject: RE: CF SQL question
Are you truly testing for an empty string, or are you trying to test for
NULL?
> -Original Message-
> Fro
sage-
From: Kris Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 9:05 AM
To: CF-Talk
Subject: Re: CF SQL question
Tim,
I'm not entirely clear on where you're testing for empty fields,
whether it is in the SQL in your query, or whether you are checking
the field af
Tim you can try 'IS NOT NULL' which tests for completely empty field
values in a table if this is what you are trying to test?
On 10/5/06, Tim Laureska <[EMAIL PROTECTED]> wrote:
> I hope this is an easy one. using SQL Server 2000.. Have a query trying to
> test for empty fields. tried the follow
> I hope this is an easy one. using SQL Server 2000.. Have a
> query trying to test for empty fields. tried the following
> and other variations but no luck:
>
> where members.speakers IS NOT ""
>
> Get this error:
>
> [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot use
> empty object
Tim,
I'm not entirely clear on where you're testing for empty fields,
whether it is in the SQL in your query, or whether you are checking
the field after the query has returned. So here's my 2 cents:
If it's inside the SQL, you can't compare the field name to an empty
string with IS NOT, you must
Tim Laureska wrote:
> I hope this is an easy one. using SQL Server 2000.. Have a query trying to
> test for empty fields. tried the following and other variations but no luck:
>
>
>
> where members.speakers IS NOT ""
>
>
WHERE members.speakers <> ''
Also you might need to add in a "AND
Try:
Where members.speakers IS NOT NULL
AND members.speakers <> ''
___
Dave Konopka
Systems Programmer
Wharton Computing and Information Technology
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 8:56 AM
Empty Field and NULL are different.
If you want the NULL FIELDS then :
where members.speakers IS NULL
If you want empty Fields:
where LEN(members.speakers) = 0
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 8:56 AM
To: CF-Talk
Are you truly testing for an empty string, or are you trying to test for
NULL?
> -Original Message-
> From: Tim Laureska [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 05, 2006 8:56 AM
> To: CF-Talk
> Subject: CF SQL question
>
> I hope this is an easy one. using SQL Server 2000.. H
Thanks. Duh. I knew it had to be easier than I was making it.
I got it working with an inner join on a subquery, but did not think
it was the easiest solution.
Thanks,
Jerry Johnson
On 7/18/05, James Holmes <[EMAIL PROTECTED]> wrote:
> I think this would work in Oracle at least and probably in a
I think this would work in Oracle at least and probably in a lot of
other DMBS (probably not MySQL) - note this is untested.
SELECT *
FROM MyTable T
WHERE SEQUENCENUMBER = (
Select MAX (SEQUENCENUMBER)
FROM MyTable
WHERE ITEMID = T.ITEMID
)
On 7/18/05, Jerry Johnson <[EMAIL PROTECTED]> w
20 matches
Mail list logo
