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!

  • Congratulations TouchToneTommy 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?

    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
  4. 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
  5. 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"...
  6. 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...
  7. 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...
  8. 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...
  9. 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#"...
  10. 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)#'...
  11. OccasionalCoder

    trouble with nested query loops

    Hi: Here's the code I'm using: -------- <cfquery name="get_agency" datasource="#db#" username="#un#" password="#pw#"> select * from agency where agency_id = #url.agency_id# </cfquery> <cfoutput query="get_agency"> <h1>#agency_id# #agency_name#</h1> <cfset thisagency = #get_agency.agency_id#>...
  12. OccasionalCoder

    reserved characters

    I want to pull some info from a database. The content of one of the fields in that database is "abbreviations" and it determines what information is to be presented on my page. As an example, I have identified the page using <cfset page = "AFR"> I want to use that variable in my where...
  13. OccasionalCoder

    problem with UPDATE

    Hi: I used the following to do an update on my database: <cfquery name="update_data" datasource="#db#" username="#un#" password="#pw#"> update fellows set first_name='#form.first_name#', mi='#form.mi#', last_name='#form.last_name#', nee='#form.nee#', photo='#form.photo#'...
  14. OccasionalCoder

    problem with dynamic radio boxes

    Here's the code I use to select the checked radio box when I pull the form info from a simple database: <cfif get_data.status eq "current"> Current: <input type="radio" name="status" value="current" checked> Past: <input type="radio" name="status" value="past"> <cfelse><br> Current: <input...
  15. OccasionalCoder

    data mismatch with Access

    Using cold fusion to insert data into an access table. When the date fields have dates in them, it works ok. When the date fields are blank, I get a data mismatch error. There are instances when the date field has to be empty. How do I adjust for this.

Part and Inventory Search

Back
Top