Posted At : Apr 04, 2015 12:46 PM | Posted By : Ed Tabara
Related Categories: ColdFusion

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: at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic( at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken( at net.sourceforge.jtds.jdbc.TdsCore.nextToken( at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults( at net.sourceforge.jtds.jdbc.JtdsStatement.processResults( at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL( at net.sourc...

Comments Comments (2) | | 16645 Views | 19% / 11% Popularity

Posted At : Jan 12, 2011 13:42 PM | Posted By : Ed Tabara
Related Categories: ColdFusion, SQL

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

Comments Comments (2) | | 8561 Views | 10% / 11% Popularity

Posted At : Dec 11, 2010 21:06 PM | Posted By : Ed Tabara
Related Categories: Deals

Best Budget Option: Kodak EasyShare C195- $79 Best Mid-Range Point-and-Shoot: Sony CyberShot WX5- $279.99 Best Point-and-Shoot, Period: Canon PowerShot S95- $389 Best Digital SLR for Beginners: Nikon D3100- $635.03 Best Splurge for Serious Photographers: Sony Alpha A55- $949.99 ...

Comments Comments (0) | | 6106 Views | 7% / 0% Popularity

Posted At : Dec 05, 2010 14:22 PM | Posted By : Ed Tabara
Related Categories: SEO

I am not a permanent visitor of blogs about SEO, but time to time i do check on this and this weekend i came across a post from April that states that Google now use site speed in their search ranking algorithms. So what does this mean? Nothing if you not care about how well your site ranks in google search results and a lot if you do. Well, it seems like it doesn't influence TOO much the results right now (if any), but they started to use it, so things will change. While site speed is a new signal, it doesn't carry as much weight as the relevance of a page. Currently, fewer than 1% of search queries are affected by the site speed signal in our implementation and the signal for site speed only applies for visitors searching in English on at this point. We launched this change a few weeks back after rigorous testing. If you haven't seen much change to your site rankings, then this site speed change possibly did not impact your site. We encourage you to start looking at...

Comments Comments (0) | | 7022 Views | 8% / 0% Popularity

Posted At : Jul 14, 2010 18:30 PM | Posted By : Ed Tabara
Related Categories: ColdFusion

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 restart the server itself. I tried anything that came in my mind at that moment, but NOTHING helped. Then i tried to reinstall this Update. (yes, without to taking down the previous try). Weird, but that error went away. And i was able to get into ColdFusion Administrator without problems. But started to get other errors when trying to load a site on the server: "The tag handler query does not have a setter for the attribute ormOptions specified in the Tag Library Descriptor" and it was pointi...

Comments Comments (18) | | 13402 Views | 16% / 100% Popularity

Posted At : Apr 09, 2010 17:24 PM | Posted By : Ed Tabara
Related Categories: SQL

Retrieving information from a history table for a given point in time is a common data task. For example, using a table that contains all historical prices, what where the prices of all products as they were 30 days ago? There are a number of ways to different methods to obtain this information from the audit table. had a nice article in March comparing 5 ways of Retrieving Data from an Audit Table: Using a subquery to determine which record for each product is the correct one for 30 days ago. The subquery selects the maximum DateEntered that is less than 30 days for each product and is refered as subquery(max). Using a subquery to determine which record for each product is the correct one for 30 days ago. The subquery selects the top 1 DateEntered that is less than 30 days, ordering by DateEntered descending and is refered as subquery(top). Using cross apply. The Products table is cross applied against the most recent record of PriceHistori...

Comments Comments (0) | | 2885 Views | 3% / 0% Popularity

Posted At : Mar 25, 2010 22:49 PM | Posted By : Ed Tabara
Related Categories: ColdFusion

I have absolutely no idea why this happened, but today i started to get errors in 2 scripts that previously was working fine. First one started to return a java.lang.NullPointerException error on cfqueryparam cfsqltype="CF_SQL_INTEGER" and the second something like conversion failed error for same type of cfqueryparam cfsqltype="CF_SQL_INTEGER". As soon as i removed the CFSQLPARAM's and used direct just variables there all started to work again. Did anyone have similar issues in the past and if so what was the solution? ...

Comments Comments (4) | | 3796 Views | 4% / 22% Popularity