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 Chriss Miller 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: *

  1. OccasionalCoder

    verity problem

    I have a site using Verity Search. The entire site is database driven. The search returns seem a little flaky: There's a "what's new" page and when I do a search on some of the text on the what's new page, it returns the correct page. However, there are several terms on the what's new page...
  2. OccasionalCoder

    app design question

    Any ideas as to how to set up a system where a user could set up form-based questionnaires on the fly, and also set up a appropriate sql to process those forms? i.e., the forms could all be different, and require different sql and different tables. Thanks
  3. OccasionalCoder

    what does this error message mean?

    Running 7MX with SQL Server 2000 database
  4. OccasionalCoder

    what does this error message mean?

    I get this error message pointing to a where line in a query: java.lang.OutOfMemoryError unable to create new native thread What does this mean? Thanks
  5. OccasionalCoder

    displaying percentages

    This is probably pretty basic stuff, but as a return from a query I get a list of numbers like 0.7967. How do I display this as a 79.6%? Thanks
  6. OccasionalCoder

    Newbee problem with Verity

    I must be totally confused on this... page_title comes from the query, and in the index tag title="page_title" and in the search title="page_title" Doesn't this value come from the query? Thanks
  7. OccasionalCoder

    Newbee problem with Verity

    This is the first time I've tried setting up the Verity Search Engine. Here's my code for indexing: ------------------ <cfquery name="content" datasource="#db#" username="#un#" password="#pw#"> select content_id, page_title, content from content </cfquery> <cflock name="consortiumres"...
  8. OccasionalCoder

    anyone familiar with threeSelectsRelated?

    When using ThreeSelectsRelated, how do I get the dropdowns to disappear when there's no data to fill them? I'm using dropdowns for Agency, Division, Unit. But not all agencies have a Division, and not all divisions have a unit. As it stands, if there's no division, the unit from the previous...
  9. OccasionalCoder

    general question

    Where would you go to learn about how to design and structure Cold Fusion applications to make them more efficient/logical, etc. I've basically taught myself Cold Fusion through books. They all show the same method as to how to build an application, but that method seems do differ greatly from...
  10. OccasionalCoder

    problem with includes...this doesn't make sense

    But the header.cfm include worked ok in the add_fellows.cfm file. It doesn't work in the mainmenu.cfm file which is one level above the add_fellows.file. Thanks again.
  11. OccasionalCoder

    problem with includes...this doesn't make sense

    I have the following directory structure: Consortium (folder) index.cfm (file) header.cfm (file) admin (folder) Mainmenu.cfm (file) agency (folder) content (folder) fellows (folder Add_fellows.cfm (file) images (folder) In the add_fellows.cfm file...
  12. OccasionalCoder

    problems with dates etc

    I've got it to work ok....thanks very much for the help, Ecar
  13. OccasionalCoder

    problems with dates etc

    Thanks, Ecar, for the help. This is really peculiar, though. Using your code above, when the link that passes the date is clicked, the data presented is off by two years, i.e. I clicked on 1998 and I get the data for 1996. It works this way for every date I have listed. 2000 gives you data...
  14. OccasionalCoder

    problems with dates etc

    I'm getting really confused on this...It's probably pretty simple, but I've been looking at it a long time. Here's my table: Last_name First_name Start_year End_year Twostart_year Twoend_year Mertz Fred 05/10/1989 05/11/1990 Norton Ed...
  15. OccasionalCoder

    problems with dates etc

    I've simplified the query to: <cfquery name="get_pastfellows" datasource="#db#" username="#un#" password="#pw#"> select * from copyfellows where end_year is not null and start_year = <cfqueryparam value="#url.year#" cfsqltype="CF_SQL_DATE"> order by last_name </cfquery> But I get no data...
  16. OccasionalCoder

    problems with dates etc

    I've got a table with first_name, Last_name, Start_year, End_year, TwoStart_year, TwoEnd_year. I am passing through the url a 4 digit number representing the year. The url.year can be either a start_year, or a twostart_year. I tried: <cfquery name="get_pastfellows" datasource="#db#"...
  17. OccasionalCoder

    help with update

    I have given up on this...I have convinced my client to use SQL server instead of Access. Originally they didn't want to pay the couple extra bucks a month in hosting fees for SQL Server...sheesh! I've gotten it to work ok in SQL Server. I want to thank everyone who has taken the time to help...
  18. OccasionalCoder

    help with update

    Using the same code I showed in the original posting, except that I eliminated the <cfif> statements. If Access will accept empty fields but not nulls, then I don't need the <cfif> statements. I tried to submit empty fields (and fields with the mm/yyyy date into the database, and still get the...
  19. OccasionalCoder

    help with update

    Its and Access database with all the date/time fields = date/time - Short Date - Not Required. The information I'm trying to put into the database is mm/yyyy Thanks again.
  20. OccasionalCoder

    help with update

    I get a datatype mismatch error when I use the following update code: <cfquery datasource="#db#" username="#un#" password="#pw#"> update copyfellows set first_name='#trim(form.first_name)#', mi='#trim(form.mi)#', last_name='#trim(form.last_name)#', suffix='#trim(form.suffix)#'...

Part and Inventory Search

Back
Top