Search results for query: *

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

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

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

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

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.

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)#'...