Install unrar in Centos

Code:

wget http://dag.wieers.com/packages/unrar/unrar-3.6.2-1.el4.rf.i386.rpm


and to extract a file user you type

unrar e -kb rarfile.rar

Install unrar in Centos

Code:

wget http://dag.wieers.com/packages/unrar/unrar-3.6.2-1.el4.rf.i386.rpm


and to extract a file user you type

unrar e -kb rarfile.rar

postgreSQL: Multiple schemas in one database

How to query a table from other schema than "pulic" schema?

If a database contains more than one named schemas, you can query use schema_name.table_name to query the content of the table.

select * from myschema.mytable;

create table myschema.mytable(

......

);

You alswaysa can simplify this by changing the search path.

SHOW search_path;

will show the current search path. The follwoing command will add the schema myachema into the search_path. so next time you do not need to use myschema.mytable to query data.

SET search_path TO myschema,public;

postgreSQL: Multiple schemas in one database

How to query a table from other schema than "pulic" schema?

If a database contains more than one named schemas, you can query use schema_name.table_name to query the content of the table.

select * from myschema.mytable;

create table myschema.mytable(

......

);

You alswaysa can simplify this by changing the search path.

SHOW search_path;

will show the current search path. The follwoing command will add the schema myachema into the search_path. so next time you do not need to use myschema.mytable to query data.

SET search_path TO myschema,public;

How to use drupal variable in sql query in view

The drupal website path is http://domain/v1/v2/v3

and the varials in the path is arg(0)=v1, arg(1)=v2 and arg(2)=v3

So in your sql command in view, you can use like this:

$argument= arg(1);

$view--> build_info['query']="select * from table_name where name='$argument'";

Note:

1. there is no need to add schema name in front of the table name even the schema is not public

2. give alias name to each table and field

SELECT feature.feature_id AS feature_id,
    feature.uniquename as feature_uniquename
      FROM feature feature
      LEFT JOIN featureloc fl ON feature.feature_id = fl.feature_id
      LEFT JOIN feature srcf ON fl.srcfeature_id = srcf.feature_id
      WHERE srcf.name = '$argument'"

How to use drupal variable in sql query in view

The drupal website path is http://domain/v1/v2/v3

and the varials in the path is arg(0)=v1, arg(1)=v2 and arg(2)=v3

So in your sql command in view, you can use like this:

$argument= arg(1);

$view--> build_info['query']="select * from table_name where name='$argument'";

Note:

1. there is no need to add schema name in front of the table name even the schema is not public

2. give alias name to each table and field

SELECT feature.feature_id AS feature_id,
    feature.uniquename as feature_uniquename
      FROM feature feature
      LEFT JOIN featureloc fl ON feature.feature_id = fl.feature_id
      LEFT JOIN feature srcf ON fl.srcfeature_id = srcf.feature_id
      WHERE srcf.name = '$argument'"

Chado and postgreSQL: ERROR: function create_point(integer, integer) does not exist

I have two chado databases installed locally. One is individually installed the other one is installed insideTripal.

While I am running queries with the Chado database which is installed inside Tripal, it gives me some error message sometimes,

ERROR:  function create_point(integer, integer) does not exist

To solve this problem I have to create the functions by myself. it seems that the funsctin were not preloaded into the Chado schema insides tripal.

Query I issued on this database:

SELECT feature.uniquename FROM chado.feature LEFT JOIN chado.featureloc fl ON (chado.feature.feature_id = fl.feature_id)LEFT JOIN chado.feature srcf ON (fl.srcfeature_id = srcf.feature_id) WHERE srcf.name = 'IncAC_plasmid_SH163';

 

links: http://generic-model-organism-system-database.450254.n5.nabble.com/Error-at-the-time-of-chado-database-import-on-frange-featuregoup-foreign-keys-td460184.html

Chado and postgreSQL: ERROR: function create_point(integer, integer) does not exist

I have two chado databases installed locally. One is individually installed the other one is installed insideTripal.

While I am running queries with the Chado database which is installed inside Tripal, it gives me some error message sometimes,

ERROR:  function create_point(integer, integer) does not exist

To solve this problem I have to create the functions by myself. it seems that the funsctin were not preloaded into the Chado schema insides tripal.

Query I issued on this database:

SELECT feature.uniquename FROM chado.feature LEFT JOIN chado.featureloc fl ON (chado.feature.feature_id = fl.feature_id)LEFT JOIN chado.feature srcf ON (fl.srcfeature_id = srcf.feature_id) WHERE srcf.name = 'IncAC_plasmid_SH163';

 

links: http://generic-model-organism-system-database.450254.n5.nabble.com/Error-at-the-time-of-chado-database-import-on-frange-featuregoup-foreign-keys-td460184.html

Implementing Custom Query for Drupal View

http://drupal.org/node/409808

Implementing Custom Query for Drupal View

http://drupal.org/node/409808

Slow deleting behavior in Windows Xp

I have windows up machine at work. Everything runs fine except I noticed it is hard for me to delete files from the hard disk no matter how big the file.  Sometimes, the operating system is paused waiting for the delete task to complete. I have checked the hard disk problem and defrag the hard disk. But they are not helping.

After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!

Slow deleting behavior in Windows Xp

I have windows up machine at work. Everything runs fine except I noticed it is hard for me to delete files from the hard disk no matter how big the file.  Sometimes, the operating system is paused waiting for the delete task to complete. I have checked the hard disk problem and defrag the hard disk. But they are not helping.

After searching online, I found one solution: "disable the 1394 Net Adapter". At beginning, I do not believe it will help. But it works!

Clear Firfox Address Bar History

To definitely clear your firefox address bar histories, you can follow these steps:

1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.

Does this work for you?

Clear Firfox Address Bar History

To definitely clear your firefox address bar histories, you can follow these steps:

1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.

Does this work for you?