Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

catndx & relndx

Quote Reply
catndx & relndx
"catndx & relndx"
Has someone a clue what this means in sql?

I want to do the following:

1. Extra-Table "AccessList":
AccessID | URL | Description

2. Extra-Table "Access"
AccessID | LinkID

I fill up 1. with something like:

1 | http://lala1 | Access to area 1
2 | http://lala2 | Access to area 2

Then i need in the same way i could choose alternate cats to my category
a pull-down with the values of Table AccessList to add & delete.

When adding it adds in "Access"

1 | LinkID

With this i could write a query like: take LinkID, get all AccessIDs, then get all URLs for these AccessIDs and print them out.

On paper everything is fine, to do the tables, too, but what the hell are catndx & relndx stand for? index? relativ?
So i will now try to study the routines for alternate category and hope wisdom would be with me ...

Robert






Quote Reply
Re: catndx & relndx In reply to
Ok, seems this is something named indexing for faster search things.
So lets drop it for later :-)
Now on perling ...

Robert