Recent content by OccasionalCoder

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

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

Running 7MX with SQL Server 2000 database

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

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

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

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

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

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

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.

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

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

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

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

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