It's in french, but it's not so important :)   ...

Got 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 when there was 684 INSERTs in that query and each having 4 parameters, that making 2736 parameters being inserted. It seems like there is a particular limit of 2100 parameters that can be passed in. Good to know....

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

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 perspective. In other words it took about 28 minutes to run that task for 1 day data. So, the smart thing to do in such situation is: let each tool do what it can do best. In other words i had to make MSSQL Server do the import instead of ColdFusion. The steps was as follow: Created DTSXes for each of the import format Created a Stored Procedure that would execute the right DTSX for the right CSV with data In the ColdFusion script change the code that read and insert te records with just a call...

This 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 following function that cover at least USA and Canada (the 2 i needed):...

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

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