A Unique Developer

AWS RDS (MySQL) error you *might* want to use the less safe log_bin_trust_function_creators variable) for function creation.

Recently moving one of our client to AWS Cloud for project built on RAILO and MYSQL. Maninly two issue face during MYSQL migration. 

  1. Default timezone for MySql is UTC and there is not way to change per RDS instance.
  2. Error occured while creating function with message "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)"
Calling LinkedIn API from RAILO with CFHTTP generate error

Since couple of weeks working with various social API integration in RAILO and most of the API I was calling using CFHTTP tag. While creating API for LinkedIn I start getting error since LinkedIn wasn't able to resolve URL that I was sending. From error message it turn out that RAILO encode full URL instead of only query paramters. Below is code for LinkedIn API to get people search where URL itself contains special characters like ), : etc. which are encoded while passing it through CFHTTP.

ColdFusion vs Railo behavior difference scope assignment.
By Pritesh

While working with one of the project I have notice different behaviour between ColdFusion and RAILO while using any scope as variable. I do not advise to use any CFML keywords/function name/scope name to use as variables although it doesn't complaining about it but as a human we do mistakes and we learn. Normally I have notice that people are using "url" as variable to store API url etc. But if you are working on website or project which support multiple platform then you may find behaviour difference.

Tags: ColdFusin, Railo
Transferring Mura comments to Disqus

I had hard time to adding captcha to my mura blog, actually I do not want to make much changes due to lack of time so I just keep comment box open to all without any captcha but required approval before publish thinking only good people live on earth :). And from next day my mail box flood with comment required for approval. Ofcourse none them was genuine comments so I was clearing comments instead of doing some productive work. To avoid this headache thought to move comment on Disqus so there will less spamming issue. There is great plugin made by Steve for inserting Disqus comments and really easy to install as well. So my blog now has disqus comment box but I really do not want loose my old genuine comments entered by readers. 

The fault returned when invoking .Net webservice through ColdFusion.
By Pritesh

Recently working with remote webservice call build on .Net platform and calling from ColdFusion and it return following error
The fault returned when invoking the web service operation is:

org.apache.axis2.AxisFault: BarCodeParam cannot be null!!


For bloging I have use open .Net webservice to generate barcode for given string. As generateBarCode function taking two argument and first one is complex type which obviously  need to pass as structure as per ColdFusion specification. 

Tags: Coldfusion X, Webservice, Error