J
Jeff
I have FP 2003 with an Access 2003 db behind it. In FP, I have built a
database results query and Im trying to use the SQL from a crosstab query
that I built in the db. The crosstab query functions correctly in Access,
but when I publish the asp page to my web server, I dont get any results.
Not even the outline of the table.
There are no problems with my web server, FP extensions, permissions, etc.
I have approximately half dozen other SQL queries reaching into my db and
producing correct ASP results.
The SQL string is
TRANSFORM Sum(Query.Time) AS SumOfTime
SELECT Query.Team_Name, Query.Date
FROM Query
GROUP BY Query.Team_Name, Query.Date
PIVOT Query.Penalty_Name;
where Query is the base query upon which my crosstab query works against.
database results query and Im trying to use the SQL from a crosstab query
that I built in the db. The crosstab query functions correctly in Access,
but when I publish the asp page to my web server, I dont get any results.
Not even the outline of the table.
There are no problems with my web server, FP extensions, permissions, etc.
I have approximately half dozen other SQL queries reaching into my db and
producing correct ASP results.
The SQL string is
TRANSFORM Sum(Query.Time) AS SumOfTime
SELECT Query.Team_Name, Query.Date
FROM Query
GROUP BY Query.Team_Name, Query.Date
PIVOT Query.Penalty_Name;
where Query is the base query upon which my crosstab query works against.