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...

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...

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...

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

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...

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...

There's a content management system for online magazines, done in cold fusion and the programmers claim that search engines can crawl their articles, even though they're behind a password. Does anybody know how this is done? Thanks

Hi: I'm interested in setting up a page where I can delete multiple items by clicking on a check box for each item I want deleted....like Yahoo email does to clear out emails. Thanks in advance for you assistance. Satch Reed

Hi: I've just recently upgraded to CF MX and am using Dreamweaver MX to build my pages. It seems to me that either Cold Fusion server or Dreamweaver is changing my code! In Dreamweaver I will press F12 to view in a browser, and sometimes I get codes showing up on the page that are not there...

Hi: I have a database with duplicate records. Apparently, &quot;overwrite existing date&quot; was not selected when using DTS, so all the data exists twice (including primary keys). I tried to delete the items using Enterprise manager, and it wouldn't let me do it. I don't know how to delete a...

Hi: I have an event calendar. Each Event has a StartDate and an EndDate. I want to set up a scheduled event so that the record will be deleted 1 day after the End Date. I'm not sure how to write instructions to do this. (and I don't want to wipe out my database trying to figure it out!). Any...

Hi: I have an online magazine. As each article is inserted into the database, an issue date is assigned. When the month changes, the new months articles are automatically presented. Here's my problem. I have three possible status conditions for each article: the current issue, articles that I...

I am using two forms to collect data. On the first form I collect name, address, etc. information. The action page for the first form inserts the data and uses a cflocation to send to 2nd form. On the second form I want the user to be able to add as many categories as he wants into the database...

I am building a database of classic car parts and service providers. Some of these providers will only handle cars within a certain range of dates. For example, they sell gaskets for Fords, but only those made from 1948 to 1953. If a user enters 1950 in his search, I want these items to come up...

Is there any rule of thumb for working through where clauses to prevent cartesian products? I seem to struggle a lot with this one...(particularly when joining more than two tables) Thanks in Advance