http://blog.1SmartSolution.com/1SmartSolution Blog1SmartSolution BlogWhat the heck is going on?I am doing ColdFusion development for 17 years and this is the first time it take me SO long to find a full-time remote position. Over 15 of this years i've worked for US based companies from Europe and it never was a very big problem to find the next position. Yes, there was pauses of course between long-term relationships with companies and i was working per project, but never too long. And this was from Europe where we had a big time difference and i had to work US working hours (imagine all
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=348&What-the-heck-is-going-on
Fri, 10 Mar 2017 15:54:00 -0400I am doing ColdFusion development for 17 years and this is the first time it take me SO long to find a full-time remote position. Over 15 of this years i've worked for US based companies from Europe aTurning Up the HeatAdobe shared a IDC whitepaper that reveals how Adobe ColdFusion has evolved over the years: Turning Up the Heat on
API Development with ColdFusion 2016
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=347&Turning-Up-the-Heat
Wed, 16 Nov 2016 09:55:00 -0400Adobe shared a IDC whitepaper that reveals how Adobe ColdFusion has evolved over the years: Turning Up the Heat on
API Development with ColdFusion 2016There is already an object named cf_client_data in the database. Any help?Recently started to get this error for a site that runs on Railo. It's happening only a couple times per day. The "usually helpful" Google was not so this time. So, thought maybe there is someone else that experienced such an issue before and may help?
Details: There is already an object named 'cf_client_data' in the database.
Error: CREATE TABLE dbo.cf_client_data (expires varchar(64) NOT NULL, cfid varchar(64) NOT NULL, name varchar(255) NOT NULL, data clob NOT NULL)
Stack Trace:
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=346&There-is-already-an-object-named-cfclientdata-in-the-database-Any-help
Sat, 04 Apr 2015 12:46:00 -0400Recently started to get this error for a site that runs on Railo. It's happening only a couple times per day. The "usually helpful" Google was not so this time. So, thought maybe there is someone elseTeam CF AdvanceGot an interesting email today that may be of interest to CF Community, so pasting it here:
In an effort to assist the ColdFusion community, Adobe, and the larger open source world, a few leaders in the ColdFusion arena have stepped forward to form an open source software development group known as 'Team CF Advance'. The primary purpose of this development group will be to advance ColdFusion applications as an open source solution through development and improvement of open source software
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=344&Team-CF-Advance
Thu, 03 Oct 2013 16:13:00 -0400Got an interesting email today that may be of interest to CF Community, so pasting it here:
In an effort to assist the ColdFusion community, Adobe, and the larger open source world, a few leadersColdFusion 10 Is Ready For You. Are You Ready For It?If so, go get it at http://www.adobe.com/go/coldfusion
And here is the Buying Gide
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=339&ColdFusion-10-Is-Ready-For-You-Are-You-Ready-For-It
Tue, 15 May 2012 14:08:00 -0400If so, go get it at http://www.adobe.com/go/coldfusion
And here is the Buying GidePresenting cfPulseThe idea is simple. I guess most of us will agree that coldfusionbloggers is a defacto instance that tells us how much movement there is in ColdFusion Community for a particular day by the number of posts that are agregated. Yes, not all there are 100% relevant but still this is an estimate. At least the best i could think of.
So, starting on 03-07-2011 i started time to time to ping cfbloggers and calculate the number of posts for each day. The numbers may not be fully accurate taking in mind
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=338&Presenting-cfPulse
Mon, 30 Apr 2012 17:25:00 -0400The idea is simple. I guess most of us will agree that coldfusionbloggers is a defacto instance that tells us how much movement there is in ColdFusion Community for a particular day by the number of pDeveloper AvailableIf you need an Intermediate ColdFusion Developer and you are in Canada or Telecommute is OK then i may have the right person for you.
Just contact me and i will provide his email address.
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=334&Developer-Available
Tue, 28 Feb 2012 16:01:00 -0400If you need an Intermediate ColdFusion Developer and you are in Canada or Telecommute is OK then i may have the right person for you.
Just contact me and i will provide his email address.Zeus is with one leg on EarthYeap, that's right ColdFusion 10 (Zeus) is in Public Beta.
So go get it on http://labs.adobe.com/technologies/coldfusion10/
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=333&Zeus-is-with-one-leg-on-Earth
Sat, 18 Feb 2012 11:09:00 -0400Yeap, that's right ColdFusion 10 (Zeus) is in Public Beta.
So go get it on http://labs.adobe.com/technologies/coldfusion10/coolest coldfusion job ad i've seen so farIt's in french, but it's not so important :)
 
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=330&coolest-coldfusion-job-ad-ive-seen-so-far
Tue, 24 Jan 2012 16:56:00 -0400It's in french, but it's not so important :)
When Much Is TOO MUCHGot today an interesting error message:
[Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.
When checking the code, i found out that in the lie where the error happened i have a query with an INSERT in loop. Why make say 10 queries with INSERTs while you can have 1 query with 10 INSERTs? But it seems like i got in a situation wh
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=325&When-Much-Is-TOO-MUCH
Mon, 18 Apr 2011 11:18:00 -0400Got today an interesting error message:
[Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parametOk. It's Up And Running.Lately was working on an interesting project - aggregation of Daily Deals sites.
So if you are looking for hot deals in your region, is not needed anymore to search through a big set of resources.
It's still a work in progress, but there are already about 1700 current deals in 3 countries from almost 70 web sites.
Enjoy!
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=324&Ok-Its-Up-And-Running
Fri, 11 Feb 2011 20:23:00 -0400Lately was working on an interesting project - aggregation of Daily Deals sites.
So if you are looking for hot deals in your region, is not needed anymore to search through a big set of resources.
IColdFusion. MSSQL. CSV Import. Performance.Had an interesting task last days. To make a script that would access a couple of links, get from each one zip file, extract CSVs from them and then import the recors to a MSSQL Database.
So with just a few ColdFusion tags like CFSET, CFHTTP, CFZIP, CFLOOP, CFDIRECTORY and CFQUERY it's a piece of cake to make it work. BUT, (yeah yeah again a BUT hehe) because the CSVs had a lot of records and it had to be done repeatedly for many of them, it came to be a serious issue from performance perspecti
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=322&ColdFusion-MSSQL-CSV-Import-Performance
Wed, 12 Jan 2011 13:42:00 -0400Had an interesting task last days. To make a script that would access a couple of links, get from each one zip file, extract CSVs from them and then import the recors to a MSSQL Database.
So with jusFind Country/State For Given Latitude/LongitudeThis weekend i've got a situation where having lat/long for a city had to find the country/state where it is located. It turned to be a not so complicated task. After a quick googling i found this site that has a lot of interesting info including a list of web services. And one of them provided exactly what i needed .
A sample call would look like this:http://ws.geonames.org/countrySubdivision?lat=47.03&lng=10.2
And the result:ATAustria07Tyrol0770.0
And few minutes later i've got the followi
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=315&Find-CountryState-For-Given-LatitudeLongitude
Mon, 29 Nov 2010 13:29:00 -0400This weekend i've got a situation where having lat/long for a city had to find the country/state where it is located. It turned to be a not so complicated task. After a quick googling i found this sitGetting Latitude/Longitude with Google Maps APIHaving an address is really easy to find out it's LAT/LONG.
First, if you don't have one, you will need to get an API Key here .
Then all you have to do is an CFHTTP call like the following:
http://maps.google.com/maps/geo?q=#yourAddress#&output=xml&oe=utf8\&sensor=true_or_false&key=#yourKey#
Note that the OUTPUT parameter can be also JSON.
And one more note. When processing the result be sure to check the kml.Response.Status.code node that has to be 200.
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=311&Getting-LatitudeLongitude-with-Google-Maps-API
Mon, 15 Nov 2010 14:55:00 -0400Having an address is really easy to find out it's LAT/LONG.
First, if you don't have one, you will need to get an API Key here .
Then all you have to do is an CFHTTP call like the following:
httpMicrosoft meets AdobeIt seems like there was a "secret" meeting between Microsoft and Adobe.
Talks probably mostly was about "Apple's story", but a possible buy of Adobe by Microsoft was in talk too.
Read more on The New York Times blog and on Yahoo News.
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=307&Microsoft-meets-Adobe
Fri, 08 Oct 2010 17:04:00 -0400It seems like there was a "secret" meeting between Microsoft and Adobe.
Talks probably mostly was about "Apple's story", but a possible buy of Adobe by Microsoft was in talk too.
Read more on The Amazon MWS - SubmitFeedThere are many ways SubmitFeed method can be used. Bellow is how i used it for price update:
<cfset signStr2 = "Action=SubmitFeed&FeedType=_POST_PRODUCT_PRICING_DATA_">
<cfsavecontent variable="prodXML">
<AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="amzn-envelope.xsd">
<Header>
<DocumentVersion>1.01</DocumentVersion>
<MerchantIdentifier>#this.merchantID#</MerchantIdentifier
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=302&Amazon-MWS--SubmitFeed
Tue, 31 Aug 2010 12:02:00 -0400There are many ways SubmitFeed method can be used. Bellow is how i used it for price update:
<cfset signStr2 = "Action=SubmitFeed&FeedType=_POST_PRODUCT_PRICING_DATA_">
<cfsavecontent variabOn Amazon MWS Signatures - AdditionIn my previous post about Amazon MWS folrot to mention that before URL generation the following strig should be created:
Where Actionis set to the needed method and is followed by any other required parameters as being FeedTypefor SubmitFeedmethod.
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=300&On-Amazon-MWS-Signatures--Addition
Wed, 25 Aug 2010 22:34:00 -0400In my previous post about Amazon MWS folrot to mention that before URL generation the following strig should be created:
Where Actionis set to the needed method and is followed by any other required On Amazon MWS SignaturesThere seem to be interest in Amazon MWS and because mostly their customer service is awe-full as well as the documentation, it's a real challenge when it comes to implement it.
First things you are going to need when dealing with MWS is signature generation. Bellow are the functions i use for it:
The original version of GenerateSignedAmazonURLi found somewhere time ago when working
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=299&On-Amazon-MWS-Signatures
Wed, 25 Aug 2010 18:50:00 -0400There seem to be interest in Amazon MWS and because mostly their customer service is awe-full as well as the documentation, it's a real challenge when it comes to implement it.
First things you are gOn Amazon MWSIf you are trying to work with Amazon MWS and are getting errors about SignatureDoesNotMatchand The request signature we calculated does not match the signature you provided. Check your AWS Secret Access Key and signing method. Consult the service documentation for details., check if in the query string you are trying to sign, the AWSAccessKeyIdparameter goes before ACTION!
I had some headache with it lately, so hope this post will help someone else.
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=297&On-Amazon-MWS
Wed, 28 Jul 2010 16:56:00 -0400If you are trying to work with Amazon MWS and are getting errors about SignatureDoesNotMatchand The request signature we calculated does not match the signature you provided. Check your AWS Secret AccIs it ME or ColdFusion 9.0 Update 1?No idea if it happened only to me, but installation for ColdFusion 9 Update 1 was the worst from any ColdFusion related installations i did in over 10 years.
First, right after i installed it, i started to get "The DataSource service is not available" errors when trying to load ColdFusion Admin and if trying to open one of the sites, was getting errors about related Datasource not existing. I tried starting/stopping/restarting services. I tried to check the size of "neo-*.xml" files. I tried to
http://blog.1SmartSolution.com//index.cfm?action=posts.entry&id=295&Is-it-ME-or-ColdFusion-90-Update-1
Wed, 14 Jul 2010 18:30:00 -0400No idea if it happened only to me, but installation for ColdFusion 9 Update 1 was the worst from any ColdFusion related installations i did in over 10 years.
First, right after i installed it, i star