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 ...
Wednesday, May 30, 2007
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)) ;
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)) ;
Subscribe to:
Posts (Atom)