Javascript Frame works

Today I got a e-mail asking about Javascript frame works.  I am no expert but from my little fooling around I like JQuery..

Here you can read what a few other persons have to say.

• Specky Boy lists their top 10 (not in order) and the his audience seems to give JQeury the edige.
  
• Sixrevisions they also list their top 10 (not in order) but the comments are again worth reading.

This is one promotion I really endorse

“jQuery is a fast, concise, JavaScript Library that simplifies how you traverse HTML documents, handle events, perform animations, and add Ajax interactions to your web pages. jQuery is designed to change the way that you write JavaScript”.

As usual it boils doing to what you are doing, your style and what best suits you project

Windows Batch File

I needed  the get the date for batch file on Windows in this format yyyy-mm-dd e.g. 2009-03-20 so I did a little research on the internet.

The result is I found this snippet at tech-recipes.com

FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B

FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B

FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B

FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B

SET mydate=%yyyy%-%mm%-%dd%

There are some nuisances so for more discussion on the top visit  tech-recipes.

Google ADs Heat Map

Interesting information on Ad placements

The following links are useful

Google Links

• General Placements
  
• Forum Placements
  
• Blog Placements
  

Others

• Heat Map Revisited at Vaughns
  
• Eye Tools View

Useful Marketing Sites

Useful Internet Marketing Information Sites

Signing up for their newsletters are worth it

• Read Write Web
• Ad Age
• Silicon Alley
• I Media Connection
• E-Marketer

Others

• Biz Report
• SiteProNews

YouTube: You Created the Content, Now Sell the Ads

Google, Looking to Monetize Video Site, Is Letting Content Producers Sell Advertising on Their Branded Channels

 

Google has struggled to find the best way to monetize YouTube. The latest idea: Let content creators sell ads.

Professional content producers -- those who come equipped with their own ad-sales teams -- are now able to sell advertising on their YouTube channels. That includes the click-to-expand overlays that run across the bottoms of YouTube videos and display units on the page that hosts the video player. The revenue is split between the content creator and YouTube, just as it would be if YouTube sold the ads.

Javascript event handling

http://mislav.caboo.se/js/handling-events-on-elements/

feed://feeds.feedburner.com/mislav/js

feed://www.advancescripts.com/rss/786.html

http://cssglobe.com/post/1539/css-dos-and-donts-part-1-css-selecting

http://cssglobe.com/post/1539/css-dos-and-donts-part-1-css-selecting

http://mislav.caboo.se/js/

Mysql TIps

Multiple inserts

http://www.petefreitag.com/item/379.cfm

Insert Delayed

http://www.petefreitag.com/item/430.cfm

Optimisation tips

http://www.petefreitag.com/item/613.cfm

More tips

http://www.petefreitag.com/item/455.cfm - Cheat sheets

http://www.petefreitag.com/item/505.cfm - Apache Security

Copyright Issues

Every now and then someone is going to steal your content. What are you going to do?

Here are some useful links into the problem 

http://lorelle.wordpress.com/2006/04/10/what-do-you-do-when-someone-steals-your-content/

http://lorelle.wordpress.com/2006/04/11/finding-stolen-content-and-copyright-infringements/

http://www.cs.cmu.edu/~dst/Terrorism/form-letter.html

http://diveintomark.org/archives/2003/05/01/my_first_ceaseanddesist_letter

http://www.webtechniques.com/archives/2001/05/legal/

http://www.webmastertechniques.com/Insight/cease.html

SSL on Apache2

Here is guide and information on setting up SSL on Apache 2. The articles are very informative.

http://www.securityfocus.com/infocus/1818
http://www.securityfocus.com/infocus/1820
http://www.securityfocus.com/infocus/1823

No to Google Ad Manager?

A few days ago, Google launched an Ad Manager for free. This came a few days after the deal to acquire DoubleClick, the largest display Ad Network on the Web.

Here are my reasons for not liking this move.

1. Google already has Adwords, Adsense(we love), Analytics, Base and Gmail( you now have to have a Gmail account)
2. With all of the above, Google already knows enough about you.
3. With the Ad Manager with its reporting capacity Google will now know your CPM rates and how other ads perform on your site, does Google need to know your CPM rates.

Will this infomation drive down your revenue or up?

There was an interesting post on the Open X blog.
http://blog.openx.org/03/why-should-ad-serving-be-open/

n.b. This Blogging Platform is also owned by Google

Google Adsense Terms and Conditions updated

Google has updated its terms and conditions.

New Products and Services
1. Changes are coming to products and services Google officers. Here is an interesting line, "anticipating, for example, that future products may be priced, paid, or managed differently than current ones."

2. Publishers will have up the 3 months, i.e. by May 25, 2008 to agree to the new terms and conditions.

Privacy

3. Publishers will have to be transparent. Publishers will have to post and abide by a privacy policy. So if you do not have a privacy policy on your site, you need to post one.

You need to notify your users/visitors that data is being collected with the use of cookies and or web beacons to facilitate the ad serving process.

There are many other changes so it is time get reading.

Simple but Effective - US $10 million a year

Here is a guy that has proved that simple is often very effective. His simply designed site, graphically that is, earns close to US $10 million, mostly if not all from Google Adsense

"Mr. Frind built the Plenty of Fish Web site in 2003 as nothing more than an exercise to help teach himself a new programming language, ASP.NET. The site first became popular among English-speaking Canadians. Popularity among online daters in many United States cities followed more recently, and with minimal spending on advertising the site. According to data from comScore Media Metrix for November 2007, Plenty of Fish had 1.4 million unique visitors in the United States. In December, Mr. Frind said, the site served up 1.2 billion page views, and page views have soared 20 percent since Dec. 26." - From the NY Times article.

NY Times Article

Wall Street Article

Monetise RSS Feeds

Useful Blogs

http://www.doshdosh.com/monetize-rss-feed-advertising/
http://www.scottgatz.com/blog/2005/11/17/monetizing-your-rss-feed/
http://www.demc.com/marketing/article_167.shtml

Networks

http://www.feedburner.com/
http://www.text-link-ads.com/
http://www.pheedo.com/
http://publisher.yahoo.com/
http://kanoodle.com/
http://www.mediafed.com/rss_reader.html
http://www.adgenta.com/
http://www.thankyoupages.com/publishers/rss.mpl
http://www.bidvertiser.com

www.emarketer.com
http://www.masternewmedia.org/podcast_directory/
http://www.masternewmedia.org/rss

Google is dealing with Accidental Clicks

Google is moving to reduce accidental clicks.

This post post explains it well http://blogoscoped.com/archive/2007-11-13-n42.html but you can read it at Google Adsense Blog. This could mean decrease in revenue for some. Despite that I think it is a fair change as it gives the advertisers better value for their money. I am not sure why it was not like this from before.

Happy advertisers are likely to keep on advertising. This quote from the the article sums it up. It says, "By reducing accidental clicks, we hope to increase advertiser campaign value and satisfaction, encouraging additional spend and facilitating higher monetization for all publishers."

I insert data in to multiple tables in MySql

I saw this question on Techjamaica forum and noted it. Interesting question and interesting answer.

Basically here is the question. Can I insert data in to multiple tables in MySQL using one insert SQL statement?

Seems like the answer is no

Can I you insert data multiple times into the same table with one statement too.

INSERT INTO employees VALUES
(DEFAULT,'Hicks','Freddy','crew'),
(DEFAULT,'Harris','Joel','crew'),
(DEFAULT,'Davis','Julie','manager');

Examples taken from:
http://www.tizag.com/sqlTutorial/sqlinsert.php
http://www.desilva.biz/mysql/insert.html

color schemes

Color
------------
http://www.colorsontheweb.com/colorschemes.asp?search=&category=Corporate
http://www.colorschemer.com/
http://www.articleinsider.com/article/229290
http://www.colorschemer.com/galleria_info.php
http://colorschemer.com/schemes/?start=331
http://www.webwhirlers.com/colors/colorschemes.asp
http://dianev.com/web-design-help/web_design_basics/color.html
http://dianev.com/web-design-help/web_design_basics/website_color_schemes.html
http://www.smashingmagazine.com/category/color/

examples
----------------
http://www.aviva.com/
http://www.norwichunion.com/

http://mobile.ups.com
pda.sky.com
bbc.co.uk/mobile
mobile.wunderground.com
pdaportal.com
pdahomepage.com
http://www.purelymobile.co.uk/

• Google (http://www.google.com/m/products)
• Yahoo Messenger (http://mm.yahoo.com)
• News.com (http://m.news.com)
• CNET Mobile (http://m.cnet.com)
• Weather.com (http://palm.xhtml.weather.com/xhtml/)
• Digg (http://mobits.com/digg/)
• Reuters (http://mobile.reuters.com/)
• New York Times (http://mobile.nytimes.com/)
• Business Week (http://pda.businessweek.com/index.html)
• Dictionary.com (http://dictionary.com/wml/)
• StreetIQ podcasts (http://m.streetiq.com/)
• Amazon.com (http://www.amazon.com/gp/aw/h.html)
• Flickr (http://m.flickr.com/)
• GameGeeks (http://www.geek.com/gaming/portable/)

http://blogs.techrepublic.com.com/hiner/?p=487?tag=1-1-11-0-0

http://www.mobidish.com/
Adshandy.com
http://www.enpocket.com/


http://realplayer.com/blog/?pageid=broadBandHomePage&pageregion=footer&src=realhome_bb_0_3_1_0_0_1_0&pcode=rn&opage=realhome_bb
http://archives.neohapsis.com/archives/fulldisclosure/2008-03/0157.html
http://www.download.com/8301-2007_4-9890945-12.html

Mysql Group By

More on Group By, Having, in your SELECT queries
http://www.databasejournal.com/features/mysql/article.php/3469351
http://rpbouman.blogspot.com/2007/05/debunking-group-by-myths.html

http://www.mysql.com/news-and-events/newsletter/2003-06/a0000000190.html

MYSQL Documentation
http://dev.mysql.com/doc/refman/4.1/en/select.html
last comment very useful
http://dev.mysql.com/doc/refman/4.1/en/group-by-modifiers.html
OPtimisations
http://dev.mysql.com/doc/refman/4.1/en/select-speed.html
http://dev.mysql.com/doc/refman/4.1/en/where-optimizations.html
http://dev.mysql.com/doc/refman/4.1/en/query-cache-in-select.html

String manipulation

proper case strings
http://www.php.net/manual/en/function.strtoupper.php#68340
http://www.sitepoint.com/blogs/2005/03/15/title-case-in-php/

Google Gadgets

http://www.google.com/apis/gadgets/basic.html
http://www.google.com/apis/gadgets/remote-content.html#Fetch_JSON
http://www.google.com/apis/gadgets/reference.html#Userprefs_Ref