January 14, 2003 at 3:31 am
Hello,
I am trying to create a look up table for a table. I want to have two columns in the lookup. One index and other a collection of elements selected from different columns of the tables. Is this possible. If so, how could it be done.
Any help would be highly appreciated.
Sindhu
January 14, 2003 at 4:18 am
First just about any data related concept is capable of being expressed in SQL. However, what is your goal, what are you expecting the data in the table to look and what are you expecting the collection table to look like as a result of the main tables data. This will help us better understand what you are trying to accomplish.
January 15, 2003 at 3:40 am
Hello,
I am trying to develop search functionality in my application using ColdFusion and SQL. I have a database with eleven tables somes of them have 3000 to 6000 records. I created views for each table to bring the relevent records together for each table and am trying to create a multiple word search functionality.
Towards this, I want to create a task to parse through each table and searchable columns to pick individual words and record id to create a new table of searchable words. By doing this, I could avoid the lag in my application currently I experience.(I believe).
I would highly appreciate your valuable advice.
Thanks,
Sindhu
Edited by - SindhuR on 01/15/2003 03:42:24 AM
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply