Adobe Community: Message List - Advanced Techniques

cfprint and UPS labels

forums_noreply@adobe.com — Sat, 08 Nov 2014 14:21:34 GMT

I am trying to use CFPRINT to print UPS labels to a network printer. The starting labels (png files) are great and I can print them locally to the zebra printer and they work wonderfully. The barcodes produced by CFPRINT however are of such poor quality that the barcode scanner cannot read them. My research shows that jpedal resizes the images to 72 dpi which is just not crisp enough for a scanner. I read about using a jpedal setting: org.jpedal.upscale=2 but I have no clue as to where you would utilize this.

Any suggestions using on how to fix this using Coldfusion. Any suggestions using php or asp.net (other technologies we support internally)??

Re: AJAX-Powered Related Select Boxes -

forums_noreply@adobe.com — Sat, 01 Nov 2014 12:09:38 GMT

Why use the attributes value="Transact" display="Transact" when you're not binding to a query? Leave them out.

You should also be thinking about using an alternative to Coldfusion's UI tags. They are generally outdated. Look into jQuery for example.

AJAX-Powered Related Select Boxes -

forums_noreply@adobe.com — Wed, 22 Oct 2014 13:53:42 GMT

Hi folks...I'm being driven crazy by this seemingly simple task.

I have 4 selectboxes, each AJAX-driven, grabbing items from a database, and then populating the next box in turn. Once a submit button is clicked next to the set of dropdowns, the information in the boxes are sent to a processing script where session variables are set and returned.

They all preload by default. They all properly load the next dropdown as you'd expect.

The problem is, I've found that if none of the boxes are touched and the default values are left, an error occurs when the submit button is clicked, and after dismissing the error popup, the 4th box becomes empty. This only happens if the 4th (last) dropdown is left to its default value. Once any other value other than the default one is selected, everything works as expected.

The error:

Bind failed for select box Transact, value and/or display attributes must be specified on the cfselect tag when binding to a query.

The form:

<tr>

</td>

</tr>

<tr>

</cfif>

</td>

</tr>

<tr>

</cfif>

</td>

</tr>

<tr>

</cfif>

</td>

</tr>

It seems like for whatever reason, the script has a problem with the default value loaded for that last box. I've checked the database, nothing strange about the values loaded by default at all. Any ideas guys??

Thanks in advance!

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Wed, 22 Oct 2014 10:15:47 GMT

I would strive to keep the web service as simple and as universal as possible. That often means passing and returning simple types.

This is especially relevant because Coldfusion is weakly typed. What it calls 'any' or 'xml' type may be interpreted quite differently by other platforms. That is what my suggestion has been all about.

You should either accept what Coldfusion's GetSOAPResponse(webservice) is giving you or you should craft the SOAP response you want, as I did in my suggestion, and return it as a string.

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Wed, 22 Oct 2014 09:38:19 GMT

It is possible I can get this fault output from GetSOAPResponse(webservice) because I just want to pass from CFC main fault code and main response, I don't want to pass complete soap xml.

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 20:13:25 GMT

thanks BKBK, it's working.

I was calling like this:

ws = CreateObject("webservice","http://localhost/CFTest/MainLogin.cfc?wsdl", {refreshWSDL=true});

ws.service_login_authentication("1111","1111");

req = GetSOAPResponse(ws);

writeoutput(req);

</cfscript>

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 19:52:45 GMT

But my component is not produces this fault code:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<<faultcode>1000</faultcode>

<faultstring>INVALID LOGIN</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

What is your ColdFusion Version as i have checked in ColdFusion 11 developer edition and ColdFusion 8 enterprise which is on window 2003 server.

Could you please check my below component, did i am doing something wrong.

    <cffunction name="service_login_authentication" access="remote" output="true" returntype="any" hint="Returns login">
     <cfargument name="login" type="string" required="yes">
        <cfargument name="password" type="string" required="yes">
<cfset var isLoginValid = False>
        <cftry>
          <cfif #arguments.login# eq "1111" and #arguments.password# eq "1111">
              <cfset isLoginValid = True>
            </cfif>

             <cfif isLoginValid>
                    <cfsavecontent variable="soapRes"><?xml version="1.0" encoding="UTF-8"?>
                       <kps_response>
                           <message>OK</message>
                           <token>354dfdffsdf</token>
                        </kps_response>
                     </cfsavecontent>
                <cfelse>
                    <cfthrow type="MyException" message="INVALID LOGIN" errorcode="1000" />
                </cfif>

                  <cfcatch type="MyException">
                     <cfsavecontent variable="soapRes">
                            <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                            <soapenv:Body>
                                  <soapenv:Fault>
                                     <<cfoutput><faultcode>#cfcatch.errorCode#</faultcode>
                                               <faultstring>#cfcatch.message#</faultstring></cfoutput>
                                  </soapenv:Fault>
                               </soapenv:Body>
                            </soapenv:Envelope>
                       </cfsavecontent>

                </cfcatch>



            </cftry>
      <cfreturn soapRes >
    </cffunction>

</cfcomponent>

If my component is okay then may be possible some setting in ColdFusion administrator. i have checked in SoapUI as well via getSoapResponse method.

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 19:49:52 GMT

Your code might be invoking a cached, hence old, version of the WSDL. Do something like the following to make sure the current WSDL is invoked:

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 19:33:45 GMT

I am using same component which you given:

<cftry>

</cfif>

<kps_response>

<token>354dfdffsdf</token>

</kps_response>

</cfsavecontent>

</cfif>

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<<cfoutput><faultcode>#cfcatch.errorCode#</faultcode>

<faultstring>#cfcatch.message#</faultstring></cfoutput>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

</cfsavecontent>

</cfcatch>

</cftry>

</cffunction>

</cfcomponent>

I did not change anything. if you have another component can you post here so I can check if I am doing something wrong may be.

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 19:33:53 GMT

HaroonTyagi wrote:

I am saying that your last suggestion I have checked but not working.

But the output should be as below:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

                            <soapenv:Body>

                                  <soapenv:Fault>

                                     <<faultcode>1000</faultcode>

                                               <faultstring>INVALID LOGIN</faultstring>

                                  </soapenv:Fault>

                               </soapenv:Body>

</soapenv:Envelope>

This is exactly the result that my suggestion produces. I have just checked it myself.

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 19:08:35 GMT

The component you are using as web service is probably different from mine.

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 18:34:50 GMT

I am saying that your last suggestion I have checked but not working.

From your last suggestion the output of fault is :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<ns1:service_soap_loginResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://wsdl.research">

<service_soap_loginReturn xsi:type="xsd:string">

<![CDATA[<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<<faultcode>1000</faultcode>

<faultstring>INVALID LOGIN</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>]]>

</service_soap_loginReturn>

</ns1:service_soap_loginResponse>

</soapenv:Body>

</soapenv:Envelope>

But the output should be as below:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<<faultcode>1000</faultcode>

<faultstring>INVALID LOGIN</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 17:27:25 GMT

HaroonTyagi wrote:

I already check this.

...

...

Any ideas?

I don't understand what you mean. Are you asking a new question? Did my last suggestion work or not?

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 15:05:24 GMT

Many Thanks BKBK!!

I already check this. When calling GetSOAPResponse it just take the whole cfsavecontent string inside response like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<ns1:service_soap_loginResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://wsdl.research">

<service_soap_loginReturn xsi:type="xsd:string">

<![CDATA[<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<<faultcode>1000</faultcode>

<faultstring>INVALID LOGIN</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>]]>

</service_soap_loginReturn>

</ns1:service_soap_loginResponse>

</soapenv:Body>

</soapenv:Envelope>

Any ideas?

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 14:36:30 GMT

My suggestion just followed your example, presuming it works and expecting you to fill in the details. If I had to do it myself, I would:

- make the code more universal by using <cfsavecontent> in place of <cfxml> and returning string type.

- set the output attribute to false.

Something like this:

<cftry>

</cfif>

<cfsavecontent variable="soapRes"><?xml version="1.0" encoding="UTF-8"?>

<kps_response>

<token>354dfdffsdf</token>

</kps_response>

</cfsavecontent>

</cfif>

<cfsavecontent variable="soapRes">

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<<cfoutput><faultcode>#cfcatch.errorCode#</faultcode>

<faultstring>#cfcatch.message#</faultstring></cfoutput>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope

</cfsavecontent>

</cfcatch>

</cftry>

</cffunction>

</cfcomponent>

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Tue, 21 Oct 2014 10:46:54 GMT

Thanks BKBK

I have tested in this way but in this case its generating fault code inside a response like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<ns1:service_soap_loginResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://DefaultNamespace">

<service_soap_loginReturn xsi:type="ns2:Document" xmlns:ns2="http://xml.apache.org/xml-soap">

<kps_response>

<faultstring>Invalid</faultstring>

<kps_response>

</service_soap_loginReturn>

</ns1:service_soap_loginResponse>

</soapenv:Body>

</soapenv:Envelope>

I want that Fault code should be inside Soap:Fault like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<faultstring>INVALID_PASSWORD</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

Any ideas?

Re: How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Mon, 20 Oct 2014 18:45:39 GMT

A suggestion:

<cftry>

</cfif>

<kps_response>

<token>354dfdffsdf</token>

</kps_response>

</cfxml>

</cfif>

<kps_response>

<cfoutput><faultcode>#cfcatch.errorCode#</faultcode>

<faultstring>#cfcatch.message#</faultstring></cfoutput>

</kps_response>

</cfxml>

</cfcatch>

</cftry>

How to handle Coldfusion SOAP Web Service Errors

forums_noreply@adobe.com — Sun, 19 Oct 2014 10:39:49 GMT

Hi,

I have just created simple wsdl example:

My Component:

          <cfif #arguments.login# eq "abcdef" and #arguments.password# eq "123456">
                  <cfxml variable="soapRes">
                        <kps_response>
                            <message>OK</message>
                            <token>354dfdffsdf</token>
                         </kps_response>

                    </cfxml>
             <cfelse>
                     <cfthrow type="MyException" message="INVALID LOGIN" errorcode="1000" />
         </cfif>

      <cfreturn soapRes >
    </cffunction>

</cfcomponent>

Its generating wsdl and no problem with response but when generating any error like username and password does not match then it's generating fault code like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<faultcode>soapenv:Server.userException</faultcode>

<faultstring>coldfusion.xml.rpc.CFCInvocationException: [coldfusion.runtime.CustomException : INVALID LOGIN. ]</faultstring>

<ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">HOST_NAME</ns1:hostname>

</detail>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

But I want customize Fault Code like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>

<soapenv:Fault>

<faultstring>INVALID LOGIN</faultstring>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

Fault Code and Fault String should be customize and I don't want detail tag completely. In old ColdFusion version like ColdFusion 8 displaying detail tag with <ns1:stackTrace xmlns:ns1="http://xml.apache.org/axis/"> coldfusion.xml.rpc.CFCInvocationException: and so on.

Any suggestions on how to create customize faultcode and faultstring is very helpful.

Thanks!!

Cfspreadsheet

forums_noreply@adobe.com — Sun, 19 Oct 2014 01:18:26 GMT

Hi, I have a question regarding cfspreadsheet....So I'm using cfspreadshseet to create excel spreadsheets for reporting purposes. My page allows a user to select whatever columns from the database to include in the report. So here is an example:

The spreadsheet could look like this:

First Name-------------Last Name-------------Organization-------------Address-------------City-------------State----- --------Zip-------------Concern

Joe Smith Sample 12 main denver co 80513 concerns go here

My question is this, if Joe has more than 1 concern I get multiple rows with joe's info...is there a way I can loop the concerns and only have 1 row for joe?

Thanks,

Steve

Re: Why is cfajax.js not initially loading in mobile platform/version?

forums_noreply@adobe.com — Mon, 13 Oct 2014 12:50:51 GMT

I gave that very line of code a try, and all it seems to do is make the page load hang. The dev console shows it in the queue to load or being loaded, but that's about it.

Re: Why is cfajax.js not initially loading in mobile platform/version?

forums_noreply@adobe.com — Sun, 12 Oct 2014 13:15:23 GMT

A suggestion:

<head>

</head>

Why is cfajax.js not initially loading in mobile platform/version?

forums_noreply@adobe.com — Wed, 08 Oct 2014 13:23:50 GMT

I am on a team developing and supporting a CF10 web application that is used on both desktop and mobile (iPad) platforms. I have a form with 2 CFSELECTs which are bound to CFCs.

There are views for both the desktop and mobile version. They are virtually identical *except* for the mobile form fields are in <div> tags instead of an HTML table. They both use the same CFSELECT code:

<cfoutput>
 <cfselect name="region" selected="#rc.region#" bind="cfc:applications.theApp.model.services.myApp.getRegions('#rc.DSN#',{district})" bindOnLoad="true">
 </cfselect>
</cfoutput>

The desktop version works as expected, the region options change based on the 'district' select box option,but the mobile version will not work on initial page load.

Using Chrome to emulate the mobile version, I noticed in the console that cfajax.js does not load the first time the page is accessed. The CFSELECT form fields shows no options.

But, if I F5 refresh the page, cfajax.js does load. The CFSELECTs appear to show no options *until* I click on them, and even then they don't quite behave correctly.

Why doesn't cfajax.js load on the initial page access?

Any help or suggestions would be greatly appreciated!

Issue with .net integration

forums_noreply@adobe.com — Wed, 08 Oct 2014 02:59:03 GMT

We installed a new CF11 server on a win2008 with iis7. the .Net ver is v2.0.50727
We have this code :

<cfobject

type="dotnet"

class="System.DirectoryServices.DirectoryEntry"

assembly="#dllPath#"

name="site">

to allow us to contact to the IIS directory to later create a Virtual Directory on it.
On the prev CF9/2008/iis7 /.net v2.0.50727 this worked great.

ON the new server I get this error :
Ensure that the DotNet agent is running and you have provided the correct host and port information-DotNet Side does not seem to be running.

We made several checks to make sure that the .NET integration with CF works - and it does, We used a simple example of a "math dll" from the wed and it worked with out any issue.
But when we try to communicate with the .Net assembly we get the error.

ANY suggestions will be highly appreciated

Thanks

Re: Is it possible to create and then search a collection from within a coldfusion ap?

forums_noreply@adobe.com — Fri, 03 Oct 2014 18:53:04 GMT

Yes, that appears to be possible. You'd query the database for the list of PDFs, then loop through the query results and use CFINDEX to index individual documents into your search collection.

-Carl V.

Is it possible to create and then search a collection from within a coldfusion ap?

forums_noreply@adobe.com — Fri, 03 Oct 2014 17:56:54 GMT

Is possible to search a database to limit the number of pdf's to search -- then use the output from the search to create a collection index it and then keyword search the new collection all within one coldfusion ap?

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Wed, 01 Oct 2014 15:34:13 GMT

jackhuang wrote:

This is unrelated but in the pages where user have input I put:

<cfset bad_chars="&,<,>,"",Æ,Á,Â,À,Å,Ã,Ä,Ç,Ð,É,Ê,È,Ë,Í,Î,Ì,Ï,Ñ,Ó,Ô,Ò,Ø,Õ,Ö,Þ,Ú,Û,Ù,Ü,Ý,á,â,æ,à,å ,ã,ä,ç,éê,è,ð,ë,í,î,ì,ï,ñ,ó,ô,ò,ø,õ,ö,ß,þ,ú,û,ù,ü,ý,ÿ,¡,£,¤,¥,¦,§,¨,©,ª,«,¬,,®,¯,°,±,²,³, ´,µ,¶,·,¸,¹,º,»,¼,½,¾,¿,×,÷,¢">

<cfset good_chars="&,<,>,",Æ,Á,Â,À,Å,Ã,&Au ml;,Ç,Ð,É,Ê,È,Ë,Í,Î,Ì,Ï,&Nti l de;,Ó,Ô,Ò,Ø,Õ,Ö,Þ,Ú,Û,Ù, & Uuml;,Ý,á,â,æ,à,å,ã,ä,ç,&eacute ; ,ê,è,ð,ë,í,î,ì,ï,ñ,ó,ô , ò,ø,õ,ö,ß,þ,ú,û,ù,ü,&yacut e ;,ÿ,¡,£,¤,¥,¦,§,¨,©,ª,«,¬ , ,®,¯,°,±,²,³,´µ,¶,·,¸,&s u p1;,º,»,¼,½,¾,¿,×,÷,¢">

<cfset form.company = replacelist(form.company, bad_chars, good_chars)>

<cfset form.address = replacelist(form.address, bad_chars, good_chars)>

<cfset form.city = replacelist(form.city, bad_chars, good_chars)>....etc.

to prevent bad inputs. Is this the right/best way to do this as far as performance is concerned?

In my opinion, what you have to get right is the encoding. Use Unicode.

You may be unable to edit this code in an editor that cannot display the characters in the bad_chars string. Use the characters' unicode value to make your code universal. Something like this

</cfloop>

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Wed, 01 Oct 2014 15:27:52 GMT

jackhuang,

Take a look at the CF Backport project, which provides some CF10/11 functions for CF9 (and in some cases, CF8). It includes a backport of EncodeForHTML().

-Carl V.

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Wed, 01 Oct 2014 12:22:41 GMT

Hi Jackhuang,

It appears Carl has answered your original question. So, please kindly mark the correct answer. It will help others in their search for answers to similar questions. Thank you.

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Wed, 01 Oct 2014 02:11:12 GMT

I am using MySql.

The CF server version is 9 so there is no EncodeForHTML. I have user who use some characters, I don't know what but could have been a Chinese punctuation mark. It some how include the > sign after a CFINPUT field and took the next <CFINPUT TYPE as part of the value. So when I display the field which now has ><CFINPUT TYPE at the end. It really messes up the page and puts a input box right after the field.

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Tue, 30 Sep 2014 22:40:11 GMT

Database indexes may not help with wildcard searches - they really only work in equals or not equals statements. What database are you using? The last several versions of SQL Server support creating full-text indexes on database tables, and then allow you to use the full-text index to quickly search for words within a varchar or nvarchar column (somewhat similar to a LIKE wildcard statement, but performs better).

"Bad inputs" is rather subjective, depending on context. It looks like you are trying to replace extended ascii characters with their HTML entity counterparts. There are already functions in ColdFusion that can do this for you. For ColdFusion 10+, look at EncodeForHTML().

-Carl V.

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Tue, 30 Sep 2014 19:07:12 GMT

Thank you Carl. These are very helpful. Should I be indexing productname to make it "faster"?

This is unrelated but in the pages where user have input I put:

		<cfset bad_chars="&,<,>,"",Æ,Á,Â,À,Å,Ã,Ä,Ç,Ð,É,Ê,È,Ë,Í,Î,Ì,Ï,Ñ,Ó,Ô,Ò,Ø,Õ,Ö,Þ,Ú,Û,Ù,Ü,Ý,á,â,æ,à,å ,ã,ä,ç,éê,è,ð,ë,í,î,ì,ï,ñ,ó,ô,ò,ø,õ,ö,ß,þ,ú,û,ù,ü,ý,ÿ,¡,£,¤,¥,¦,§,¨,©,ª,«,¬,,®,¯,°,±,²,³, ´,µ,¶,·,¸,¹,º,»,¼,½,¾,¿,×,÷,¢">
		<cfset good_chars="&,<,>,",Æ,Á,Â,À,Å,Ã,&Au ml;,Ç,Ð,É,Ê,È,Ë,Í,Î,Ì,Ï,&Ntil de;,Ó,Ô,Ò,Ø,Õ,Ö,Þ,Ú,Û,Ù,& Uuml;,Ý,á,â,æ,à,å,ã,ä,ç,é ,ê,è,ð,ë,í,î,ì,ï,ñ,ó,ô, ò,ø,õ,ö,ß,þ,ú,û,ù,ü,&yacute ;,ÿ,¡,£,¤,¥,¦,§,¨,©,ª,«,¬, ,®,¯,°,±,²,³,´µ,¶,·,¸,&su p1;,º,»,¼,½,¾,¿,×,÷,¢">

		<cfset form.company = replacelist(form.company, bad_chars, good_chars)>
		<cfset form.address = replacelist(form.address, bad_chars, good_chars)>
		<cfset form.city = replacelist(form.city, bad_chars, good_chars)>....etc.

to prevent bad inputs. Is this the right/best way to do this as far as performance is concerned?

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Tue, 30 Sep 2014 15:25:07 GMT

You don't need the createObject(), since you are calling the component via AJAX (and not actually using the component on the actual page).

As far as performance, that has more to do with the general speed of your site and especially the code within your CFC. What database platform are you using? How well is it performing? Is the table you are querying properly indexed? Is the database running on the same server as ColdFusion, and does the server have adequate resources to perform (memory, processor speed/cores, etc.)? The performance of <CFINPUT> versus jQuery, Bootstrap, or other autocompletes will likely be pretty similar to each other - it's mostly about how fast the data is transmitted and received from the server-side code via AJAX.

A couple other thoughts. I notice you are using the LIKE operator in your query to do a wildcard search. This is likely necessary for your query, but keep in mind that LIKE will always be slower than an equals comparison.

Also, instead of looping over the query results, take advantage of built-in functions to accomplish the same thing. So you could replace the entire loop with this:

-Carl V.

Re: Problem using HSBCHashGenerator CFX

forums_noreply@adobe.com — Tue, 30 Sep 2014 12:59:03 GMT

Just a little update:

If I put cpitools.jar into /opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes

And then add /opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes into the ColdFusion Class Path, the error changes to this:

A ClassCastingException occured. The CFX custom tag CFX_com.clearcommerce.CpiTools.security.HashGenerator needs to implement com.allaire.cfx.CustomTag interface. Ensure that you add this to your custom class.

If I understand this correctly, I can no longer use a generic Java class in CF10 - it HAS to be one that has some ColdFusion specific stubs added.

That sounds like a right royal PITA! I don't want to be messing around changing other people's .jar files and getting my hands dirty with Java. There MUST be a way around this, surely?!

OK - the answer is not to use CFX at all!

Just instantiate a JavaObject and call its method:

Problem using HSBCHashGenerator CFX

forums_noreply@adobe.com — Tue, 30 Sep 2014 12:50:23 GMT

Upgrading from MX7 to 10.

Got a .jar file "cpitools.jar" which I've put into /opt/coldfusion10/jre/lib

If I do a jar -tf on it, I get:

com/clearcommerce/CpiTools/security/Encrypter.class

com/clearcommerce/CpiTools/security/HashGenerator.class

com/clearcommerce/CpiTools/security/SecCrypto.class

META-INF/MANIFEST.MF

I've registered it in the CFIDE:

TagName: CFX_HSBCHashGenerator

ClassName: com.clearcommerce.CpiTools.security.HashGenerator

BUT when I try to call it...

<CFX_HSBCHashGenerator SharedSecret="#ss#" HashElement="#datainput#">

I get the error message: The CFX custom tag CFX_com.clearcommerce.CpiTools.security.HashGenerator was not found in the custom tag database. You must add custom tags to the database before using them. If you have added your tag to the database, check the spelling of the tag within your template to ensure that it matches the database entry.

-----

So when it says "you must add custom tags to the database" - it's referring to the registration of the Java CFX, right?

So I've done that. so I check the spelling of the tag - looks OK to me (and it is unchanged since the functional MX7 code).

Obviously the mapping is working to some extent - CF was clever enough to realise that when I say <CFX_HSBCHashGenerator...., I am referring to something with "com.clearcommerce.CpiTools.security.HashGenerator".

So what's my blindingly obvious in retrospect error?!

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Mon, 29 Sep 2014 21:20:45 GMT

Also I removed the line:

and it still works. Do I really need that line? I am new to this object oriented programming. Do I have to create the object every time the function is called?

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Mon, 29 Sep 2014 21:17:35 GMT

Thank you Carl. The second one worked! Now I have to figure out how to change the ugly blue color hovering over the list....

I found that the list is pretty slow. I also check the jQuery http://jqueryui.com/autocomplete/#remote but found it extremely slow also. Maybe it's the site. On top of that I do not know I can implement the above using code given there.

I was looking at the twitter typahead at typeahead.js – examples which look very promising and fast. But again I don't know how to implement it together with the Coldfusion function that I have created above.

Re: Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Mon, 29 Sep 2014 16:45:30 GMT

jackhuang,

If you are a new user, I'd suggest you not go down the <CFFORM> and <CFINPUT> path. It is fraught with peril! All of the ColdFusion UI stuff (including <CFFORM> and <CFINPUT>) are built on outdated javascript libraries and do not implement all of the capabilities of those libraries.

Rather, I suggest you learn a community-supported JavaScript library such as jQuery. It provides fantastic AJAX support and has all the UI features you need, either as part of the core library, the related jQuery UI library, or the myriad of free plug-ins written by 3rd parties. There are other libraries that offer similar functionality too: ExtJS (the CF UI stuff is mostly based on a really old version of ExtJS), Dojo, and several others.

Many experienced developers have consciously moved away from using the built-in ColdFusion UI features due to compatibility issues and functional limitations. Thus, you will be much less likely to get useful assistance with problems you encounter using those features. On the other hand, the community-supported JavaScript libraries have a huge user base (both within and outside the ColdFusion community), and you will undoubtedly be able to get assistance with issues you may encounter.

All of that said, after reviewing the docs, it looks like you need to change

<cfinput type="text" autosuggest="suggest.getProducts({cfautosuggestvalue})" name="string">

<cfinput type="text" autosuggest="cfc:suggestcfc.getProducts({cfautosuggestvalue})" name="string">

or possibly

<cfinput type="text" autosuggest="cfc:components.suggestcfc.getProducts({cfautosuggestvalue})" name="string">

Good luck,

-Carl

Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Mon, 29 Sep 2014 04:37:16 GMT

I am new to using cfcomponent and autosuggest. I followed the sample given in the Adobe Help Adobe ColdFusion 9 * Using Ajax User Interface Components and Features

However, I am not getting the autosuggest to work at all. This is what I did:

1. I created a Suggestcfc.cfc under a subdirectory called "components"

The Suggestcfc.cfc is as follows:

SELECT DISTINCT productname FROM products

WHERE productname LIKE <cfqueryparam value="#suggestvalue#%" cfsqltype="cf_sql_varchar">

</cfquery>

</cfloop>

</cffunction>

</cffunction>

</cfcomponent>

2. I have a test.cfm as:

<head>

</head>

<body>

</cfform>

</body>

</html>

So when I run the test.cfm it only showed a box and when I started typing, nothing is being suggested (retrieve from the products table). What am I doing wrong here? Any help is appreciated. Thanks in advance.

Re: The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

forums_noreply@adobe.com — Sun, 21 Sep 2014 11:14:10 GMT

To debug, you could attempt to dump the result-set with cfoutput, as follows:

#queryName[column][currentRow]#

</cfloop>

<br>

</cfoutput>

Otherwise, could you show us your code? Many more eyes may spot something you overlook.

The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

forums_noreply@adobe.com — Fri, 19 Sep 2014 19:43:24 GMT

I've done this a thousand times. I have a stored proc that returns data. I give the resultset a name. I output it with cfoutput query =queryname. Now it's failing for every column in the query. But if I do a cfdump with the queryname as a var, I get the data -- with the exact column names in my cfoutput.

CF9, SQL Server.

Re: Error using CFWebsocket tag in ColdFusion 10

forums_noreply@adobe.com — Wed, 17 Sep 2014 16:29:43 GMT

I also received this same issue. Have you resolved it yet?

Re: How can you determine from within CF if cookies are enabled in the browser you are using?

forums_noreply@adobe.com — Sun, 14 Sep 2014 11:36:53 GMT

Enable session management in your Application file, with setClientCookies set to true. Then you can tell whether the client has cookies enabled by looking at the values in the cookie scope, by doing something like

</cfif>

If you are on ColdFusion 10 or 11 you should read up on the related subject of session fixation.

You might wish to avoid re-inventing the wheel. If so, you could just emulate or copy Ben Nadel's cookie test.

How can you determine from within CF if cookies are enabled in the browser you are using?

forums_noreply@adobe.com — Sat, 13 Sep 2014 22:06:09 GMT

I need to know if the user has cookies enabled when he logs into my website so I can tell him/her to enable them. If they are not enabled, the SessionID will be lost and session vars will not work.

Re: consuming webservice with input type of enum

forums_noreply@adobe.com — Fri, 29 Aug 2014 15:28:54 GMT

Try setting wsversion = 1.

<cfscript> args = { refreshWSDL=true, wsversion=1 }; ws = createObject("webservice", "http://mysite/test.asmx?wsdl", args); result = ws.getAccountLinksByUser("test@somewhere.com", "All"); writeDump(result); </cfscript>

Issue using .net web service from ColdFusion - Stack Overflow

Re: Connecting to Exchange

forums_noreply@adobe.com — Thu, 28 Aug 2014 04:33:12 GMT

This is a 'me too' post.

I'm having the same kind of problem described in the original post.

I got cfexchangeconnection working between ColdFusion 10 on my PC and the exchange 2010 server. This involved importing the server's certificate & etc.

When the working code was transferred to a server running ColdFusion 9, (and yes I did remember to also import the certificate to the server )

I find that the connection no longer works. I get:

Unable to connect to the Exchange server using HTTP/HTTPS protocol.
HTTP response code : 302

Just to get that far, I had to remove the serverversion attribute which was added with CF10 and not supported in CF9

I also tried changing the parameters thusly:(changes in Bold)

<cfexchangeconnection

action="open"

username="#config.username#"

password="#config.pwd#"

connection="mailpickupconn"

server="mail.mydomain.com"

mailboxname="My Account"

protocol="https"

formBasedAuthentication="true"

formBasedAuthenticationURL="https://mail.mydomain.com/owa/auth/owaauth.dll" />

The attributes in BOLD were added from a recommendation I found on another forum, but to no avail....

Is there a cfexchangeconnection solution for the combination of CF9 / Exchange 2010 (&& 2013) / HTTPS ?

TIA and Cheers,

Re: Clearing Session and/or App variables with Log-out Page?

forums_noreply@adobe.com — Wed, 20 Aug 2014 10:32:00 GMT

It in unnecessary to delete session keys to invalidate them. With proper coding they should be invalidated once the session times out.

Sessiontimeout values are usually around half an hour and applicationtimeout values are usually of the order of 1 day. Also, one way to relate session to login is to use the loginStorage attribute. If you have no need for client management, switch it off.

Hence, for example,

<cfapplication name="appraiseri"

applicationtimeout="#CreateTimeSpan(1,0,0,0)#"

clientmanagement="no"

sessionmanagement="Yes"

sessiontimeout="#CreateTimeSpan(0,0,30,0)#"

SetClientCookies="Yes"

loginStorage="session">

I am assuming that, for login and logout pages, you will - ignoring the details - have something like

Login:

</cflogin>

Logout:

Clearing Session and/or App variables with Log-out Page?

forums_noreply@adobe.com — Sun, 17 Aug 2014 19:21:54 GMT

Greetings

I have 3 distinct user types for my app- admins, appraisers and clients.

All have their own directories and each directory has it's own Application.cfm:

1) <cfapplication name="appraiseri"

applicationtimeout="#CreateTimeSpan(0,2,0,0)#"

clientmanagement="Yes"

sessionmanagement="Yes"

sessiontimeout="#CreateTimeSpan(0,2,0,0)#"

SetClientCookies="Yes">

2) <cfapplication name="appraiserview" ......

3) <cfapplication name="clientview" .......

Each have their own login which simply uses their ID in the DB as the session variable.

login_do.cfm:

1) Appraisers: <CFIF auth_direct_appraiser.RecordCount NEQ 0 >

2) Admins: <cfset Session.user_id =auth_direct.staff_ID> ......

3) Clients: <cfset Session.processor_user_id =auth_direct_processor.processor_ID>

I have had a session persisting for a week now- I have no idea how to get rid of it, and if one simply hits the "login" submit button with no UN or PW, it runs a query on a client (the same one) ?

My logout page is not working at all- if the code were correct, it would clear any session variable? I have not really set an app variable (except timeout) so no need to clear that?

Here is the code:

</CFIF>

</CFLOOP>

</CFLOCK>

alert("You have been logged out from the XXXXX Intranet")

location.href='login.cfm';

</SCRIPT>

Any help would be appreciated- this is leaving a huge security gap in the app right now.

Thanks

Re: In CF 9 can I create a custom page URLs, similar to Wordpress?

forums_noreply@adobe.com — Mon, 11 Aug 2014 20:46:50 GMT

I assumed the Wordpress functionality you are looking for is that of a Content Management System. Hence Mura and FarCry.

Re: In CF 9 can I create a custom page URLs, similar to Wordpress?

forums_noreply@adobe.com — Mon, 11 Aug 2014 20:31:40 GMT

Mura or FarCry will enable me to rewrite a URL

Re: Problem with Application Scope

forums_noreply@adobe.com — Mon, 11 Aug 2014 01:12:12 GMT

I'm assuming everything is being set in ApplicationStart... so why not simply call ApplicationStart on refresh... why do the stop?

Adobe Community: Message List - Advanced Techniques

cfprint and UPS labels

Re: AJAX-Powered Related Select Boxes -

AJAX-Powered Related Select Boxes -

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

Re: How to handle Coldfusion SOAP Web Service Errors

How to handle Coldfusion SOAP Web Service Errors

Cfspreadsheet

Re: Why is cfajax.js not *initially* loading in mobile platform/version?

Re: Why is cfajax.js not *initially* loading in mobile platform/version?

Why is cfajax.js not *initially* loading in mobile platform/version?

Issue with .net integration

Re: Is it possible to create and then search a collection from within a coldfusion ap?

Is it possible to create and then search a collection from within a coldfusion ap?

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem using HSBCHashGenerator CFX

Problem using HSBCHashGenerator CFX

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Re: Problem with cfinput autosuggest and cfcomponent

Problem with cfinput autosuggest and cfcomponent

Re: The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

Re: Error using CFWebsocket tag in ColdFusion 10

Re: How can you determine from within CF if cookies are enabled in the browser you are using?

How can you determine from within CF if cookies are enabled in the browser you are using?

Re: consuming webservice with input type of enum

Re: Connecting to Exchange

Unable to connect to the Exchange server using HTTP/HTTPS protocol.

Re: Clearing Session and/or App variables with Log-out Page?

Clearing Session and/or App variables with Log-out Page?

Re: In CF 9 can I create a custom page URLs, similar to Wordpress?

Re: In CF 9 can I create a custom page URLs, similar to Wordpress?

Re: Problem with Application Scope

Re: Why is cfajax.js not initially loading in mobile platform/version?

Re: Why is cfajax.js not initially loading in mobile platform/version?

Why is cfajax.js not initially loading in mobile platform/version?