You're welcome. ... View more

Please post the code that is not working so the forum users can review it.  It is difficult to see what is going wrong with your code without seeing the code. ... View more

In the CF administrator go to Server Settings > Mappings page.  There should be a mapping for /CFIDE listed. You might also check the Server Settings > Settings page.  On this page check the value for 'Default ScriptSrc Directory'. See: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3638e6-7ffc.html You may also need see where Apache maps requests for '/CFIDE' to in order to locate the directory in the file system. ... View more

Wouldn't the content also be found if  a CFM page which incorporates the include file is indexed? ... View more

If I understand your problem correctly sometimes your Solr search results contain a file which is intended for use as an include rather than a stand alone web page.  If this is the case then the solution would seem to be to structure your content such that include files are not contained within the directories indexed by Solr. ... View more

You *might* be able to locate a JDBC driver which can be configured to automatically trim the trailing spaces from CHAR data type columns. This is possible with some ODBC drivers, I'm not sure if JDBC drivers support a similar option. ... View more

This blog post may be helpful. http://www.coldfusionmuse.com/index.cfm/2010/12/31/Access.on.64bit.ColdFusion ... View more

You may might be able to use the full-text search features of MS SQL 2005 in your SQL queries.  ColdFusion 8 includes the Verity search engine.  You might investigate this feature. References: SQL Server "Full-Text Search Queries" (MSDN) http://msdn.microsoft.com/en-us/library/ms142583%28v=SQL.90%29.aspx "Searching for Words or Phrases Close to Another Word or Phrase (Proximity Term)" (MSDN) http://msdn.microsoft.com/en-US/library/ms142568%28v=SQL.90%29.aspx ColdFusion 8 / Verity "Building a Search Interface" http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=indexSearch_01.html#1164916 "Using Verity Search Expressions" http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=indexSearch02_1.html#1160419 ... View more

You might use the getHeaderOnly option to limit the size of results in your query. Sort those results, get the UID values for the messages you are interested in. Then create a second CFPOP connection using UID attribute to only get the ten messages you want. ... View more

I suspect that you will need to escape the column name "date" which is a reserved word as . Add square braces around the keyword. Keywords and how to escape them are contained in the "Escaping reserved keywords" section of the Query of Queries documentation. ... View more

CFPOP creates a query object result.  You could try using Query of Queries to query that result to get the order you desire. References: "Using Query of Queries" http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7bb8.html ... View more

An alternate solution would be to use dummy data in your development enviroment and not grant developers access to production data. ... View more

The technique you are asking about is usually called "fuzzy search" or "fuzzy lookup".  There are two ways you might approach this problem. 1. Use the Solr search engine bundled with CF (which supports fuzzy search) and the CFSEARCH tag.  Note that you should not use the Verity search engine, since feature will be removed in the next version of CF. 2. If you are querying a database you might use the fuzzy search capabilities, if any, supported by your database product. Questions: 1. What kinds data source(s) are you trying to search: a database, flat file, LDAP, other? 2. If querying a database, what product and version are you using? 3. What version of ColdFusion are you using (version number and edition)? References: "Solr search examples" http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WS82937B1B-240F-4850-B376-5FD9F911E5E5.html "CFSEARCH" http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d02.html "ColdFusion X Writeup" (discusses removal of Verity from future CF releases) http://www.coldfusionjedi.com/index.cfm/2011/3/3/ColdFusion-X-Writeup ... View more

Have you reviewed the CF documentation? http://help.adobe.com/en_US/ColdFusion/9.0/Installing/WSc3ff6d0ea77859461172e0811cdec18a15-7ffb.html ... View more

You might try adding a column to your query based on the order the camp ids appear in the list. To items to consider: 1. This code is not tested. 2. You should validate that your session.camp_list variable contains only integers, else you are vulnerable to a SQL injection attack. 3. This code assume that your list does not contain any duplicate values. <CFQUERY name="GetCamp" DATASOURCE="#datasource#">     SELECT camp_uid,camp_title,camp_text,camp_image_type,         CASE                <!--- loop over list and create an order value for each camp, this assumes that list does not contain any duplicates --->         <cfloop from="1" to="#ListLen(session.camp_list)#" index="listIdx">             WHEN camp_uid = #ListGetAt(session.camp_list ,listIdx)#                 THEN #listIdx#         </cfloop>         END AS camp_order     FROM campaigns     WHERE camp_uid IN ( <cfqueryparam value="#session.camp_list#" cfsqltype="CF_SQL_INTEGER" list="true"> )     ORDER BY camp_order; </CFQUERY> Assume that your session.camp_list variable contains "23,17,5" the query qenerated should look like: SELECT camp_uid,camp_title,camp_text,camp_image_type,     CASE         WHEN camp_uid = 23             THEN 1         WHEN camp_uid = 17             THEN 2         WHEN camp_uid = 5             THEN 3        END AS camp_order FROM campaigns WHERE camp_uid IN ( 23,17,5 ) ORDER BY camp_order; Message was edited by: JR \"Bob\" Dobbs. ... View more

Things to check in IIS.  Note that IIS handles default documents, CF admin does not. 1. Is default documents feature enabled in IIS? http://technet.microsoft.com/en-us/library/cc754807%28WS.10%29.aspx 2. Is there a web.config file that may be overriding the default documents configured in IIS? http://blogs.iis.net/bills/archive/2008/03/22/how-to-add-a-default-document-with-iis7-web-config.aspx 3. Is index.cfm listed first in the default documents config?  If not another document may be being served instead. ... View more

Can you clarify what you mean by "establish a different Windows identity"?  Usually passing identity to a web site or service means adding something to the request's HTTP headers.  This could be a cookie in the case of .NET forms authentication or the "Authorization" header in the case of basic authentication. The SOAP web service invocation code you posted does use basic authentication, according to the CF docs "ColdFusion inserts the user name/password string in the authorization request header as a base64 binary encoded string, with a colon separating the user name and password. This method of passing the user name/password is compatible with the HTTP basic authentication mechanism used by web servers." http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec13a13-7fe0.html If you need to mimic the SOAP techinque you should have basic authentication enabled for your REST service endpoints. If your authentication method is different then CF developers will need to add the appropriate HTTP headers to their service calls.  Note that calling a REST service from CF would probably be accomplished using the CFHTTP tag if the service is designed to be consumed by the CF server. ... View more

Is the authentication of the REST service URL handled by basic HTTP authentication where a username and password are passed in the HTTP header of the GET request? ... View more

I would describe the steps that fixed your problem here in the forum in so it can help someone else with a similar problem. ... View more

The drivers bundled with CF are JDBC drivers.  Using these is generally preferable to the ODBC socktet driver.  The CF documentation states, about using ODBC: "Adobe does not recommend this driver type unless your application requires DBMS-specific features." Instructions for creating a database connection (JDBC) to SQL Server can be found in the CF documentation.  Your step 1 is not required when using JDBC. References: "About JDBC" http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7ffd.html "Connecting to Microsoft SQL Server" http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe5.html ... View more

Not exactly, COALESCE returns the first non-null item in the list. I would refer to your database documentation. ... View more

I would try removing the COALESCE and looking at how the results differ, that should help you visualize what COALESCE is doing. I encourage you to do some research and testing so that when you need to troubleshoot the query later you'll understand what each part of the SQL statement is doing. ... View more

I suspect that CF is generating HTML script tags with src values that point to a directory that is not on your dev2 site.  CF generally expects to find its JavaScript files and other resources in the /CFIDE directory subtree.  I suspect you will need to map the physical directory where the CFAJAX component are, probably in /CFIDE on your root web site, to a virtual directory on your dev2 domain site. ... View more

ACS LLC, Below is a sample query that may work for you. It uses a full join, as previously suggested in this thread. I also suggest that you research full joins and any other keywords in the query you are not familiar with. SELECT COALESCE(IMP.imp_date, LEAD.lead_date) AS report_date , COALESCE(IMP.imp_counter,0) AS imp_counter , COALESCE(LEAD.lead_count,0) AS lead_count FROM ( SELECT imp_date , imp_counter FROM impressions WHERE imp_date BETWEEN '9/1/2011' AND '09/07/2011' ) AS IMP FULL OUTER JOIN ( SELECT lead_date , COUNT(*) AS lead_count FROM leads WHERE lead_date BETWEEN '9/1/2011' AND '09/07/2011' GROUP BY lead_date ) AS LEAD ON ( IMP.imp_date = LEAD.lead_date ) ORDER BY report_date; ... View more

So based on your sample result set I need to assume that not every record will have a row in the IMPRESSIONS table.. You wish to get a resultset containing 3 columns: 1. An uid from IMPRESSIONS (or LEADS if there is no match in the IMPRESSIONS table). 2. A date from IMPRESSIONS (or LEADS if there is no match in the IMPRESSIONS table). 3. The count of records in the LEADS table that math the uid and date. Is this correct?  It contradicts the assumptions I stated on Sept 9 where I assumed that all records in the results would have a record in the IMPRESSIONS table, to quote "You wish to include every row in the impressions table that matches the date range criteria." ... View more

Knowing the data types for each column and the database server (vendor and version) would be useful. ... View more