Wednesday, May 30, 2007

How Long Does Kidney Faliure Take In Cats

MOD URL rewriting and rewriting

To maintain compatibility with the url of the search engine's "content" must be static and speakers ...

well, this is not usually a problem, but eclude the ability to record the entire contents on a database, losing all the advantages of this technique. (Transaction and backup ...)

http://urlrewriter.net/

with this you should (I have not got to try) to maintain compatibility with search engines and allow to decouple completely from the file system ...

Unrar File Bin And Cue

extracting data from nested SQL

Problem:
Extract from a table the rows corresponding to the maximum value of a field of the table group denoted by a field.


Eg.
Table:

Id - Group - Val
id1 id2
2 G1 G1 1
id3
G1 0 G2 0
ID4 ID5 ID6
G3 3 G3 2
Desiderata:

Id - Group - Val
id1 2 G1 G2 0
ID4 ID5
G3 3


Solution with nested query:

SELECT Id, Group, Val

FROM table WHERE
tabella.Val
IN (SELECT MAX (Val) AS Expr1 FROM table AS
aliasTabella
WHERE (tabella.Id = aliasTabella.Id) GROUP BY
Group)) ;