Recent content by Leakyradiator

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.