Thanks Bobby, I did indeed miss that!
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: 24 April 2011 03:38
To: cf-talk
Subject: RE: Problem Using QueryNew
Be sure to enable the blob/clob option(s) on the CF datasource if you go
with those datatypes.
That
being
>>> deprecated, so it's a good move at any rate.
> Thanks for the warning on this.
>
> Jenny
>
>
>
> -Original Message-
> From: Jason Fisher [mailto:ja...@wanax.com]
> Sent: 24 April 2011 02:18
> To: cf-talk
> Subject: Re: Problem Using
She's already using ntext. She is trying to figure a way to search
two different ntext fields in two different related tables returned by
the same query using FREETEXTTABLE
On Sat, Apr 23, 2011 at 7:28 PM, Russ Michaels wrote:
>
> If you are using SQL Server 2000, to avoid truncation you can us
]
Sent: Saturday, April 23, 2011 10:29 PM
To: cf-talk
Subject: Re: Problem Using QueryNew
If you are using SQL Server 2000, to avoid truncation you can use TEXT or
nText fields instead. These are BLOBS and are not contained by the max row
length. The combined max row size for all other fields is 8060
gt; deprecated, so it's a good move at any rate.
> Thanks for the warning on this.
>
> Jenny
>
>
>
> -Original Message-
> From: Jason Fisher [mailto:ja...@wanax.com]
> Sent: 24 April 2011 02:18
> To: cf-talk
> Subject: Re: Problem Using QueryNew
>
&
If you are using SQL Server 2000, to avoid truncation you can use TEXT or
nText fields instead. These are BLOBS and are not contained by the max row
length. The combined max row size for all other fields is 8060, anything
above this will be truncated.
Since SQL Server 2005 these were depreciated i
Varchar(max) was added to mssql 2005 2000 has a limit of Varchar(8060)
Sent from my iPhone
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
l.80%29.aspx
>
> -Original Message-
> From: Maureen [mailto:mamamaur...@gmail.com]
> Sent: 24 April 2011 00:26
> To: cf-talk
> Subject: Re: Problem Using QueryNew
>
>
>
> Seems to me it would a lot more efficient to make a view in your
> database that only
al Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: 24 April 2011 01:28
To: cf-talk
Subject: Re: Problem Using QueryNew
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.894 / Virus Database: 271.1.1/3592 - Release Date: 04/23/1
ureen [mailto:mamamaur...@gmail.com]
> Sent: 24 April 2011 00:26
> To: cf-talk
> Subject: Re: Problem Using QueryNew
>
>
>
> Seems to me it would a lot more efficient to make a view in your
> database that only returns the two fields you want to search on plus
> any fi
Darn. That bites. Maybe a different searching mechanism if the
simple query doesn't work.
Or a temp table.
On Sat, Apr 23, 2011 at 5:45 PM, Jenny Gavin-Wear
wrote:
>
> I'm still on SQL 2000.
>
> Sadly it can't be done in SQL 2008 either:
>
> "The view cannot include text, ntext, or image colu
e-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: 24 April 2011 01:33
To: cf-talk
Subject: Re: Problem Using QueryNew
Are you still running SQL Server 2000, and if not, is that still the
case for the version of SQL you are running?
On Sat, Apr 23, 2011 at 5:29 PM, Jenny Gavin-Wear
wrote:
>
&g
Are you still running SQL Server 2000, and if not, is that still the
case for the version of SQL you are running?
On Sat, Apr 23, 2011 at 5:29 PM, Jenny Gavin-Wear
wrote:
>
> Hi Maureen,
>
> I found it is possible to create indexed views and add them to a fulltext
> catalog, however, among a lo
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: 24 April 2011 00:26
To: cf-talk
Subject: Re: Problem Using QueryNew
Seems to me it would a lot more efficient to make a view in your
database that only returns the two fields you want to search on plus
any fields you
On Sat, Apr 23, 2011 at 4:58 PM, Jenny Gavin-Wear
wrote:
> As I understand it FREETEXTTABLE can only search on one table at a time?
>
> I can't use a database view in the fulltext catalogue? If I can it answers
> all my problems.
>
I've never used FREETEXTTABLE on a view, but I don't see why it
I think what you want is an inner join. An inner join gives you ONLY
the records in the Product Table that have matching ids in the Product
Options table.
An outer join will give you all the records in the Product Table but
only those in Product Options that with matching ids.
So if your tables
table at a time?
I can't use a database view in the fulltext catalogue? If I can it answers
all my problems.
Jenny
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: 24 April 2011 00:26
To: cf-talk
Subject: Re: Problem Using QueryNew
Seems to me it would
Seems to me it would a lot more efficient to make a view in your
database that only returns the two fields you want to search on plus
any fields you need for search criteria. Or do a select with a join
that returns the fields. Once you do that, they are already in a
query, so you wouldn't need t
ime? Am I going about this the right way?
Jenny
-Original Message-
From: William Seiter [mailto:will...@seiter.com]
Sent: 23 April 2011 17:51
To: cf-talk
Subject: RE: Problem Using QueryNew
You are using a simple cfloop from to, instead of a cfquery or a cfloop
query.
Because of this, when you c
uot;#stockTable.stockTitle[R]#"
William
-Original Message-
From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk]
Sent: Saturday, April 23, 2011 9:45 AM
To: cf-talk
Subject: Problem Using QueryNew
My first time using created queries, I can't understand why this
My first time using created queries, I can't understand why this is putting
the same value on every row.
#stock.stockTitle#
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11
07:36:00
21 matches
Mail list logo
