Search results for query: *

I have four tables in my database: Org, Cat, Subcat and Links Links is a linking table that contains the primary keys of Org, Cat, and Subcat for each record. I'm trying to present each org. with all its categories, and present each subcategory for each category. Here's the code I've been...

I am passing info on checked boxes using the following code: <cfoutput query="getsubcat"> <input type="checkbox" name="selectsubcategory" value=#subcat_id#" <Cfif listfind(subcatlist,subcat_id)> checked</cfif>> #subcat_id# #subcategory#<br> </cfoutput> It determines which items are...

I wasn't invoking template A in template B. But I want to use the list across multiple templates. Can this be done in the session scope? Or is there a better way to pass lists between templates? Thanks

If I create a list on template A, is it available on template B? If not, how do I pass a list between templates? Thanks

I have query results: 231 232 233 234 235 236 237 238 239 and a list: 233 237 239 I need to put the results of the query into a form with a checkbox in front of each. If the query number equals the list number, I need to have the box checked. I've tried using the query with a loop on the...

A sample might be: [PK] [FK] Org_id Cat_id Name Address 1 102 Allen Center 134 N Street 2 134 Allen Center 134 N Street 3 135 Allen Center 134 N Street 4 145 Allen Center 134 N Street 5 102...

I have a database that is not normalized. It consists of categories and organizations. In some cases, where an organization is in several categories, all the organization information is repeated for each category, in some instances as often as 8 times. The categories come from a categories...

Your code changed each item in the category list to the 555[list#]999 that I was looking for. What it didn't do, was delete the 3 digit category number if that number was the first 3 digits of the 6 digit number appearing later in the list. I greatly appreciate your input, though, because it did...

This might make more sense: I have two lists: List 1 List 2 147 147117 101 145114 102 134109 145 134 135 I want to step through list 1. If the first 3 digits of any item in list 2 equal the item in list 1, I want to add 555 to the beginning of the item in...

I greatly appreciate the help. Here's what I ended up with: (this is Your old list was 147,101,102,145,134,135,147117,145114,134109. Your new list is "555147999,555101999,555102999,555145999,555134999,555135999,555135999,555135999,555135999" As you can see, the 6 digit numbers just repeat...

I have a list with the following items in it: 147,101,102,145,134,135,147117,134109 Here's what I want to do: if the first 3 numbers of the 6 digit items equals any of the three digit numbers, (they always will,) I want to prepend to the 6 digit number a 3 digit number (arbitrarily, 555) and...

As the result of using a couple of forms, I end up with the following lists being passed to the action page: category list 147 101 102 103 145 and subcategory list 147117 145114 the first three digits of the subcategory are the same as the category in which they reside, i.e., subcategory...

I want to present about 15 checkboxes on a form. Each checkbox's name/value comes from a database. When the form is filled in, and the appropriate checkboxes checked, it is then submitted. On the action page, how do I determine which checkboxes are checked and get their name/value and insert...

I know of at least one content management system (using Cold Fusion) that allows search engines to spider their site content, even though it's behind passwords. Does anyone know how this is done? Thanks

The problem is, though, that one car company may supply parts for 1957 through 1960 Fords, while another may supply parts for 1959 through 1964 Fords. The dates can be different for each company.

Thanks Karl. Wouldn't putting the year in the CarModel table require me to have an entry for each year, i.e., 1920 Ford, 1921 Ford, 1922 Ford, etc.?

I'm trying to set up a resource database for car restorers. I now have tables: Car_make, Car_model, Car_begin_year, Car_end_year, Company. Some of the companies handle parts for (for example) 1967 to 1981 Camaros. Other's might have 1965 to 1980 Camaros. I want my website visitor to be able to...

Thanks for the input. I probably wasn't entirely clear in my question. I intend to put the beginning date in it's own field and the ending date in it's own field in the database. What I don't understand is how you search for a date range.

I'm building a database of classic car parts dealers. A typical entry would read "Joe's Classic Car Parts" and "Ford Parts from 1903 to 1972" I want to be able to return this record if someone does a search on "Ford Parts 1957" How do I set up the date range of 1903 to 1972 in the database so...

The only thing I can guess at is that they identify robots in some fashion and, once identified, they establish a session for it. That would take the login out of the equation.