redsa

I think that you should store your date in the date field in your table and then when you get that field you you format it with the functions: day(), month() and year() ex: select concat(day(your_date), '-', month(your_date),'-', year(your_date)) from your_table;

I have a website and I got PR 6 after 2 years of hard work! But in these days I've noticed it goes down again to 5! whyyyyyyy? :-(

We also use a modified version of openwebspider for 8Lights! :lol: [quote=marker;115842]try openwebspider : [URL]http://www.openwebspider.org[/URL] it's free and open source! Script is in PHP[/quote]

And what about outcoming links? I've a website that have about 20 outcoming links per page! And in these days my PR goes down from 6 to 5 :-( Could be for this reason?

Really coool! Thanks

Are you sure that your query get a timeout? I often execute sql-queries that take more than 10minutes maybe you have a timeout in your PHP page if so: take a look at the function: set_time_limit here: [URL]http://it2.php.net/set_time_limit[/URL]

You can't do it via ASP! I think that you could only print your document to a PDF or to a RTF and set the orientation to landscape

You could write a query like this: [quote]SELECT id, MAX(mydate) AS MaxDate FROM ( SELECT id, initialDate AS mydate FROM cert UNION SELECT id, recertDate1 AS mydate FROM cert UNION SELECT id, recertDate2 AS mydate FROM cert ) DERIVEDTBL[/quote]

Yes, simply doing a query like this: SELECT A + B FROM table WHERE C='etc' example: SELECT 'abc' + 'def' AS sqlConcat