> I especially worry about this line:
>"Also no Microsoft haters please, I just don't have the time."
C'mon. You are straight from the belly of the beast.
You've already proven that you can deal with it.
And for a small development/support shop, they LOVE
M$ trash, because it ensures ongoing support $. So
let them pay you for a while. And do a slow education
on how much more money they can make, supplying the
same apps via a Linux/PostgreSQL platform.
Can you do the asp page he is describing?
It is now the 10th. You should have it done by Sunday,
and in his email 1st thing Monday. Immediately call with
a follow up.
Keep it simple. This sounds like 20 lines of code, if that.
Initialize ado object.
Issue simple sql select, like:
select count(product_id), sum(qty), sum(dollar_amt)
from north_wind_table_whatever
group by product_id
order by sum(qty) desc;
loop through the 1st 10, spitting them out.
If you feel fancy, add final totals, but keep
in mind that is NOT what he asked for, comment
the code to that effect.
Make sure you close the object.
Note: I've done NO ADO coding, so all this is
total bullshit, but I think it's how it should
work.
Comment well, but don't comment things like
'Open ADO object
ado.open(sdsdsd).
Redundant comments are annoying.
Comment based on business rules, ie: why the
code is here, and what results are expected.
Make sure you check for errors. Missing error
checking is the kiss of death, and a sure sign
of a novice worthless coder.
All the other questions are easily researched if you
don't already know.