🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.golive.dynamic.content
Article #106

Re: Is it possible to do a full text match with joined tables.

#106
From: Jeremy_M._Cox
Date: Thu, 29 Jul 2004 19:42
5 lines
1693 bytes
Wow Jerry. Just wow. My head is spinning. I am gonna try to break down what you said. But in the mean time. Here is the function of the search.

A student would go to the current_classes page and search by instructor name to see what fall classes the instructor is teaching. Or maybe they just want to search for the classes by class name or catalog number to see what classes are being offered. And finally maybe they want to search for classes in a program of study for example Advertising. All this could be done if I use the search column by column but I don't get the advantages of full text search. If someone types in first and last name of an instructor it would return no results. Or if they type in class name and catalog number likewise.

I hope this makes sense. I just want to search this one table. Unfortunately it has joins and I must suffer for using relational capabilities. How often are tables not using joins. Seems like it would have these capabilities. Buy who am I? Thanks a lot, Jerry.
Technical Details
Message-ID: <3bb53f82.3@webx.la2eafNXanI>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-out.ntli.net!newsrout1.ntli.net!news-in.ntli.net!ntli.net!newsfeed01.sul.t-online.de!t-online.de!webx
References: <3bb53f82.-1@webx.la2eafNXanI>

Show Full Headers
Complete Article Headers
X-Google-Thread: 11ffd2,5be81bf8a12d8df7
X-Google-Attributes: gid11ffd2,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Jeremy_M._Cox@adobeforums.com
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-out.ntli.net!newsrout1.ntli.net!news-in.ntli.net!ntli.net!newsfeed01.sul.t-online.de!t-online.de!webx
Newsgroups: adobe.golive.dynamic.content
Subject: Re: Is it possible to do a full text match with joined tables.
Message-ID: <3bb53f82.3@webx.la2eafNXanI>
Date: Thu, 29 Jul 2004 12:42:59 -0700
References: <3bb53f82.-1@webx.la2eafNXanI>
Lines: 18
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit