poon

I always think microsoft excel is a great tool for works. how do you think of it?

i use excel to plan,to log,to calculate,to process data...

and excel can complete jobs excellently.

and if shortcuts are used , jobs can be done double excellent!!

the following are some shortcuts i often used, hope they can help ;-)

1.Move to the previous sheet in the workbook : CTRL+PAGE UP
Select the current and next sheet.
2.Move to the previous sheet in the workbook : CTRL+PAGE UP
3. to access the menu: press / or alt keys.

how to make your subversion (svn) support the svn:// protocol access.

platform : windows xp

1. boot your svn server on the server-side.

1.1 if you install your svn by  a windows  installer *.msi or *.exe install program,

those programs can always config the svn for your os system. such as add the environment variables

to the SYSTEM PATH.

1.2 if you choose a *.zip to setup your svn server , then you should add the path to the  environment variable manually.

suppose you install the svn in c:\subversion ,

head

the first command i introduce here is head,later i will show others ,such as tail,wc,cat,vi,join and so on.

head means 'first' , so if you want to get the first part of your data file , you can use

head command.

such as :

head abc.dat

the result returns:

--------------------------------

some may be confuse on the relationship of subversion and apache

when they first wade in subversion-the great version control tools.

now i try to make it clear.

1.if someone use file:// or svn:// protocol to access svn,

they don't need apache,just install svn,take svnserve in your svn package

as a server.

2.if you want your repository to be accessed via http:// or https:// protocol,

then you need apache.

svn client:

get the hex code of character using ue

keyword: ue,hex,transform

    ____   _____ ______________     ____    ____  ______
   / _  | / ___// ____/  _/  _/    / _  |  / __ \/_  __/
  / /_| | \__ \/ /    / / / /     / /_| | / /_/ / / /  
 / /__| | __/ / /___ / / / /     / /__| |/ / / / / /
/_/   |_/____/\____/___/___/    /_/   |_/_/ |_| /_/

"Oldskool" or "Amiga" style

TO use  a short path of windows command prompt

you like command windows?

sometimes you will change your work directories frequently,

so it often come out with a great long path before the prompt,

like : C:\Documents and Settings\Administrator>

and you want the long path "C:\Documents and Settings\Administrator>" to be hidden?

just want >cmd on the command window?

so just type :

prompt $G

then "C:\Documents and Settings\Administrator>"  will disappear and only a '>' left.

is that cool?

appendix:

db2 sql develop error--value is to long

keyword:db2,err,value,insert

*

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command. 

During SQL processing it returned:
SQL0433N  Value "hongkong paris trading company guangzhou representative office" is too long. 
SQLSTATE=22001

*

when you encounter this problem,

 you may check the table definition to see

if some field is too short to accept a long string.

when you put your site on your host like hostmonster,

your must specify your database location and user name & password.

how should these be filled ?

suppose your mysql database name called db_drupal,

your database password is db_user,

your database password is db_pass,

then those should be:

database name: db_duser

database pass:db_pass

database location:localhost

the drupal system will generate a config string which saved in the sites/all/default/settings.php

like:

the microsoft access 2003: Nz() function

usage : FOR EXAMPLE:

Nz(var1,0)

then if var1 is null, it return 0,if var1 is not null,

it return var1 's value.

as we can see , it's very easy to use.

but recently i used it in my access query ,

when i invoked that query in the brio report ,

and found that there is not any reponse ,

in other words, the query could not be quoted by brio.

when is substitute the Nz() function by IIf(),

and the query can be successfully invoked !

INSTALL DB2 UDB ENTERPRISE (ESE) STEP BY STEP

KEYWORD:DB2 ,SERVER,SETUP,HOWTO