You are using a simple cfloop from to, instead of a cfquery or a cfloop
query.
Because of this, when you call #stockTable.stockTitle#, it defaults to the
first line of the query.
Either change your loop to a cfloop query=stockTable
Or change your data call to #stockTable.stockTitle[R]#
William
? 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
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
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.
Jenny
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: 24 April 2011 00:26
To: cf-talk
Subject: Re: Problem Using QueryNew
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
On Sat, Apr 23, 2011 at 4:58 PM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk 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
-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
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
jenn...@fasttrackonline.co.uk wrote:
Hi Maureen,
I found it is possible to create indexed views and add them to a fulltext
[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
jenn...@fasttrackonline.co.uk wrote
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
jenn...@fasttrackonline.co.uk wrote:
I'm still on SQL 2000.
Sadly it can't be done in SQL 2008 either:
The view cannot include
: 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 need for search criteria. Or do a select with a join
that returns
-
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/11
07:36:00
: 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 need for search criteria. Or do a select with a join
that returns
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
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
...@wanax.com]
Sent: 24 April 2011 02:18
To: cf-talk
Subject: Re: Problem Using QueryNew
Change all your ntext to nvarchar(MAX), if you can.
And run an UPDATE to free up space after the conversion, too ;)
ALTER TABLE myTable
ALTER COLUMN myNText nvarchar(MAX);
UPDATE myTable
SET myNText
]
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
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 r...@michaels.me.uk wrote:
If you are using SQL Server 2000, to avoid
...@wanax.com]
Sent: 24 April 2011 02:18
To: cf-talk
Subject: Re: Problem Using QueryNew
Change all your ntext to nvarchar(MAX), if you can.
And run an UPDATE to free up space after the conversion, too ;)
ALTER TABLE myTable
ALTER COLUMN myNText nvarchar(MAX);
UPDATE myTable
SET myNText
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
20 matches
Mail list logo