Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Leakyradiator
  • Order by date
  1. Leakyradiator

    Problems with nested loops

    ...(I haven't even tried working with the subcategories yet). <cfquery name="link1" datasource="#db#" username="#un#" password="#pw#"> select * from links </cfquery> <cfloop query = "link1"> <cfquery name="org1" datasource="#db#" username="#un#" password="#pw#"> select * from org where...
  2. Leakyradiator

    passing uncheck checkboxes

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

    list question

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

    list question

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

    checkboxes/loop question

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

    getting data out of a non-normalized database

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

    getting data out of a non-normalized database

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

    working with lists & loops

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

    working with lists & loops

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

    working with lists & loops

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

    working with lists & loops

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

    looping through two lists

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

    using dynamic check boxes

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

    spidering behind passwords

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

    Newbie: how to query multiple tables

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

    Newbie: how to query multiple tables

    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.?
  17. Leakyradiator

    Newbie: how to query multiple tables

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

    querying date in a range of dates

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

    querying date in a range of dates

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

    crawling behind a password

    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.

Part and Inventory Search

Back
Top