CF7 added category support to Verity. Check the docs for more info.
(Not to blow you off, but it makes sense to start there.)
On 12/8/06, Jamie Jackson <[EMAIL PROTECTED]> wrote:
> Say I've got a bunch of PDF documents, and each PDF can fit into one
> or more categories. When i
Say I've got a bunch of PDF documents, and each PDF can fit into one
or more categories. When indexing them with Verity, is there a way to
associate the PDFs with categories?
Bottom line is I need to be able to group the PDFs by category in the
search results:
Your search found the foll
With a slight alteration of your database, you can easily accomodate
multiple levels of categories like so:
table structure:
cat_id (auto number field)
cat_name (name, self-explanatory)
cat_childof ("child" of the cat_id field, see example below)
DATA
1 Picture F
y/sub-categories
Hi guys,
For a shopping cart app I created last year, I had one level of categories
eg. category/product
Now, I wish to expand on that and include 1 more level eg.
category/subcategory/product
A particular subcategory may apply to more than one category eg. winter
2006/accessories, s
Hi guys,
For a shopping cart app I created last year, I had one level of
categories eg. category/product
Now, I wish to expand on that and include 1 more level eg.
category/subcategory/product
A particular subcategory may apply to more than one category eg. winter
2006/accessories, spring 2006
http://www.sys-con.com/story/?storyid=48660&DE=1
On Sun, 20 Mar 2005 08:32:50 -0500, Calvin Ward <[EMAIL PROTECTED]> wrote:
> Has anyone used the new Categories feature of MX 7's Verity?
>
> The documentation seems to really skip over how it's used other than her
Has anyone used the new Categories feature of MX 7's Verity?
The documentation seems to really skip over how it's used other than here's
how to enable it in the tag.
- Calvin
~|
Logware (www.logware
To: CF-Talk
Subject: Re: categories, subcategories and sub-subcategories in a database
Hmmm, now what are you going to do when you change your mind about
where something should be categorizied and want to move it? Or when
you want to add more categories, or rearrange the categories, or
Hmmm, now what are you going to do when you change your mind about
where something should be categorizied and want to move it? Or when
you want to add more categories, or rearrange the categories, or shift
a script from one category to another category (or list them in
multiple categories!)?
I
--Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 24, 2004 5:29 PM
To: CF-Talk
Subject: Re: categories, subcategories and sub-subcategories in a database
if you're taking that route.. instead of mids and lefts, why not put
those values into a li
t;
> (Form Validation, Browser Detection)
>
> SUB2
> sub2ID
> sub2Name
>
> (Checkboxes, Textboxes)
>
> An admin screen would pull the categories out and would build the
> scriptCategory number
> example 002 001 001 001 (_javascript_, Form Validation, Checkboxes
n)
SUB2
sub2ID
sub2Name
(Checkboxes, Textboxes)
An admin screen would pull the categories out and would build the
scriptCategory number
example 002 001 001 001 (_javascript_, Form Validation, Checkboxes, Item)
So a search for this (or any) script would be
SELECT
FROM
WHERE
#LEFT(scriptCategory,
OK. Officially stumped!
I want to make all the categories in a/the forum visible only to
registered users, so that guests that wander along only get to see an
empty form/message telling them to go register.
Now I've done this and it was all working ages ago, but I suspect the
clien
on CF5 or CFMX, it's really quite
simple.
Cheers,
barneyb
> -Original Message-
> From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 10:43 AM
> To: CF-Talk
> Subject: RE: SQL: hierarchical view of parent child categories
>
> Thank
: CF-Talk
Subject: Re: SQL: hierarchical view of parent child categories
here's a good discussion of the topic:
http://www.sitepoint.com/article/hierarchical-data-database/1
also google for Joe Celko --he has lots of information on the topic --
may have to do a bit of reading to dig it out
a
> particular
> category from the table and you want to show them where this category
> is in relation to it's parent(s) categories you have to jump through
> a lot of
> cfif's. The ideal solution is to have a view that determines all of
> these
> r
icular
category from the table and you want to show them where this category
is in relation to it's parent(s) categories you have to jump through a lot of
cfif's. The ideal solution is to have a view that determines all of these
relationships and you just run a query on that view by passi
Since you asked...
>> How do you get all the parent categories for a given subcategory?
SELECT *
FROM tblCategories
WHERE treepath = Left(@thisTreePath, Len(treepath))
AND LEN(treepath) < Len(@thisTreePath)
>> Moving a category with subcategories must be a bitch too...
--
> Just for clarification the categories don't need a
> delimeter because it's broken into fixed-width
> character groupings. So in Ken's original example,
> the grouping with is 5 characters.
> So as you can see, there's no need for wildcard
> queri
Isaac,
Just for clarification the categories don't need a delimeter because it's
broken into fixed-width character groupings. So in Ken's original example,
the grouping with is 5 characters. This means that if your using a 255
character field to store this info, then you co
able which uses indexed integers.
In retrospect I think I made a couple errors in the example of the trigger I
mentioned in my previous post ... I was after all drawing from memory.
Isaac
www.turnkey.to
954-776-0046
> Ken,
> I agree, this is a great way to handle categories. I used
> t
Ken,
I agree, this is a great way to handle categories. I used this method a
long time ago on a app I created with CF2 and it worked really well. I've
always been surprised that this method doesn't get used more.
Do you know of anywhere that has a standard set of queries/stored proc
Try this:
WHERE Left(CategoryName, 1) = '#url.Letter#'
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
- Original Message -
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001
know, here is the code I wrote.
This will give you letters from A to Z along the top that would display the
appropriate categories.
This is very simple code, however I thought it might just help someone.
-Gel
SELECT DISTINCT .Classification
FROM
Where Left
--
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:49 PM
To: CF-Talk
Subject: Re: Selecting All Categories that start with A..
SELECT
DISTINCT Left(FieldName,1) as Ltr
FROM YourTable
> I am assuming that I can use a function such as Left() in SQL? I
CategoryName] field.
HTH
Craig Fisher
Macromedia Certified Instructor
Macromedia Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
801-791-8251
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 10:37 AM
To: CF-Talk
Subject: Sele
001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that start with A..
Hey all,
I got a database that has like 120 categories.
The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.
SO I'm trying to use SQL in the query, with a
t; Subject: Selecting All Categories that start with A..
>
>
> Hey all,
>
> I got a database that has like 120 categories.
>
> The client wants A-Z along the top, and when A is clicked, only those
> categories that start with A will show.
>
> SO I'm trying to use
why not use the LIKE function in SQL:
LIKE 'A*' or is it LIKE 'A%'
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that start with A..
Hey all,
I got
Use the SQL LIKE Statement
SELECT x1, x2...
FROM table
WHERE lastname LIKE '#url.letter#%'
HTH,
Duane
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 12:37 PM
To: CF-Talk
Subject: Selecting All Categories that st
SELECT
DISTINCT Left(FieldName,1) as Ltr
FROM YourTable
> I am assuming that I can use a function such as Left() in SQL? Is there
> anything like that?
> How would I do something like this otherwise?
>
> -Gel
>
~~
Your ad could be here. M
In your query use:
WHERE Name Like 'A%'
The percent sign is the wildcard in SQL.
C. Hatton Humphrey
> -Original Message-
> From: Angel Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 12:37 PM
> To: CF-Talk
> Subject: Selecting All Cat
ecting All Categories that start with A..
Hey all,
I got a database that has like 120 categories.
The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.
SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when
What is the architecture of the DB like? are those categories individual
tables? or rows with IDs?
>From: "Angel Stewart" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Selecting All Categories that start with
Hey all,
I got a database that has like 120 categories.
The client wants A-Z along the top, and when A is clicked, only those
categories that start with A will show.
SO I'm trying to use SQL in the query, with a URL variable called Letter
passed when the user clicks the letter nav bar.
> Let me verify what I see in your SQL. All your categories live in the same
> table, pcategory. You give that table 3 different 'aliases' though?
I think is a self join. I do this so I can give a list of every thing and
where they fall in the category structure.
> Also it
; From: Jeff Green [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 4:30 PM
> To: CF-Talk
> Subject: RE: Maybe OT: Infinite categories/subcategories
>
>
> Thanks for responding Art!
>
> Let me verify what I see in your SQL. All your categories live in the same
>
Thanks for responding Art!
Let me verify what I see in your SQL. All your categories live in the same
table, pcategory. You give that table 3 different 'aliases' though?
Also it seems as though you know ahead of time that all your products are 3
categories deep?
This brings
You are doing the same with your database schema that I am. The one thing
that will make it dead dog slow is the query
scenario.
You will want to do a join in your query and then do an output using a group
by. Here is a example of what I'm doing.
Art
SELECT
t1.cat_id AS cat_id, t1.cat_name
My goal is to make my app (store whatever) have the ability to have infinite
categories/subcategories. I'm aware that there may not be a great need to
go 10 subcategories deep, but if I make my app only go 2 deep and someone
wants 3 deep well you get the idea :)
I have done
I'm building an image library application and need to lay my hands on a
ready-made directory to categorise the images that we're storing.
Does anyone know where such an animal can be found? A database would be
ideal, but I could always populate one via a template, if the source format
made it eas
Here's the solution for the problem. It was just a matter of the URL in
the HTTP call. Thanks Fred Sanders:
http://w.moreover.com/categories/category_list.wddx"
METHOD="GET" PORT="80"
RESOLVEURL="false">
Dave
==
listing. They claim you
can do it, but the page that gives the directions comes up blank.
Thanks,
Dave
- Original Message -
From: "Benjamin S. Rogers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 10, 2000 10:06 AM
Subject:
#Source# -
#DateFormat(Harvest_Time, " d ")#
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 10, 2000 9:40 AM
To: CF-Talk
Subject: Moreover.com Categories List via
I've got the code to get the individual new headline feeds. It works great.
What I want is the code to grab the list of categories, so my users can
build a profile of feeds they want right from the moreover.com list.
Dave
- Original Message -
From: "Simon Horwith" &l
er 10, 2000 9:40 AM
To: CF-Talk
Subject: Moreover.com Categories List via WDDX
Good Morning,
Is anyone out there grabbing the list of categories from Moreover.com using
WDDX? I have been grabbing individual headlines using it, but their example
page of using CF for grabbing the categories is blank
Good Morning,
Is anyone out there grabbing the list of categories from Moreover.com using
WDDX? I have been grabbing individual headlines using it, but their example
page of using CF for grabbing the categories is blank. If you are doing
this (grabbing the complete category list via WDDX
gt;To: [EMAIL PROTECTED]
>Subject: Categories/ Sub Cats, etc.
>
>
>This maybe an easy question, but your help is appreciated and welcomed.
>
>Does anyone have any code/db recommendation on setting up a
>category and
>subcategory
. Sammut -- Four Eyes Productions -- think | plan |
create [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 10, 2000 11:52 AM
To: [EMAIL PROTECTED]
Subject: Categories/ Sub Cats, etc.
This maybe an easy question, but your help is appreciated and welcomed.
Does anyone have any code/db recommendation
This maybe an easy question, but your help is appreciated and welcomed.
Does anyone have any code/db recommendation on setting up a category and
subcategory system (like yahoo)?
Thank you,
Michael
--
Archives: http://
Thanks to Chris and Dick... extremely helpful comments!
-Mensaje original-
De: Chris Montgomery <[EMAIL PROTECTED]>
Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Fecha: viernes 14 de julio de 2000 7:53
Asunto: RE: Categories tree
>Francisco,
>
>There is an articl
Francisco
If the depth of the tree is not changing all the time (the categories
are relatively static) and you have a reasonable depth (say 5-10
levels) you can use another approach:
do one massive SQL query which returns the entire tree expanded to all
levels
iterate over the query
everytime we click on a category) will make more sense. Hmmm
-Mensaje original-
De: Chris Montgomery <[EMAIL PROTECTED]>
Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Fecha: viernes 14 de julio de 2000 7:53
Asunto: RE: Categories tree
>Francisco,
>
>There is an ar
ller
210-490-3249/888-745-7603Fax 210-490-4692
Find a Job in San Antoniohttp://www.sajobnet.com
>-Original Message-
>From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, July 13, 2000 1:06 PM
>To: [EMAIL PROTECTED]
>Subject: Categories tr
Ftree does but without using an applet do it. I=B4ve got a =
set of categories and subcategories. Unfortunately the depth of the tree =
is not fixed so basically we can add categories under a certain category =
forever.
I=B4m not aware of any single piece of CF code that uses recursive =
principles
On Wed, 19 Apr 2000 "cftalk" <[EMAIL PROTECTED]> writes:
> I want to send a couple of users E-Mails.
> (users are stored in a DB)
Ouch! Get them out!
-David (who will thankfully be off-line for the next 3 days)
YOU'RE PAYING TOO M
Hi, in dependency of 4 checkboxes I want to send a couple of users E-Mails.
(users are stored in a DB)
It is part of a newsletterservice. The Mail-Text is just about the same for
each category.
When I realize the query with a plain cfif wheather the checkbox is checked
I can ask certainly if a use
ginal Message -
From: Seth Petry-Johnson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 10, 2000 2:25 AM
Subject: Products in multiple categories
> List,
>
> I'm working on an e-commerce site where the client has requested that a
> product s
List,
I'm working on an e-commerce site where the client has requested that a
product should be able to exist in multiple categories. In other words,
certain products should be displayed when a user takes a number of different
drill down paths.
They want to do this at the product level r
59 matches
Mail list logo
