Jerome's Blog

Tuesday, May 21, 2013

Tanki Online

http://tankionline.com/battle-en26.html#

Sunday, May 19, 2013

Custom Function in Excel to get the url of the cell

i am working on small excel project to get the url

i copy the links from the webpage straight into excel
well the url or hyperlink its there but the problem is...
i need to insert them into mysql database and...
there are 10,000 records.

i am still using office 2007 don't whether the function is available in the newer versions..

so here are the steps for ppl using excel 2007..........

open a macro enabled workbook or save it later as .xlsm

Alt + F11 open the visual basic editor

insert a new module

paste the following code (highlighted in yellow)

Function GETURL(HyperlinkCell As Range)

GETURL = HyperlinkCell.Hyperlinks(1).Address

End Function

save and close the editor

now go back to the sheet view

Saturday, May 18, 2013

yii wallpaper

Tuesday, May 7, 2013

Open Cart Installation

Monday, May 6, 2013

online free 3D games

Friday, May 3, 2013

mySQL mulitple table update

UPDATE config, tmp_config
SET
config.new1 = tmp_config.new1,
config.new2 = tmp_config.new2
WHERE tmp_config.tmp_id = config.id

UPDATE account, vtiger_accountshipads
SET account.acc_shipping_address=vtiger_accountshipads.ship_street, account.acc_shipping_po_box=vtiger_accountshipads.ship_pobox, account.acc_shipping_city=vtiger_accountshipads.ship_city , account.acc_shipping_state=vtiger_accountshipads.ship_state, account.acc_shipping_postal_code=vtiger_accountshipads.ship_code , account.acc_shipping_country=vtiger_accountshipads.ship_country
WHERE vtiger_accountshipads.id=account.acc_id

Thursday, May 2, 2013

Richard Stallman Talks About Ubuntu

Richard Stallman Talks About Ubuntu & its privacy invasing (according to EFF and FSF) Features. In order to access the video (watch or download) usining free software. Please read the article on Muktware.click here