Re: [Jason] Pulling select fields from records
I am creating a website for a property management company. Each property has a LOT of fields. Using the CMS, I have a script that creates the main navigation on the fly by reading the entries to my main navigation table. At one point, I want it to jump into the properties table and just grab the 'title' and record number fields of each of the properties so that I can construct a link to each of them in a drop down menu off the main menu. In this example, it doesn't make sense to have to read in the entire properties table just to grab two fields.
As you said, I'll probably just go ahead and write this using regular sql.
WebCamp One, LLC
Websites That Work