Patricio M. Rueda wrote:
>Can some one shine the light on this problem.
>
>When I use the " AS clause" in my SELECT statement and then try to
>print
>the table rows by using the "ORDER BY tot" statement
>(new column "TOT" name), I get the following error:
>
>DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]
>Too few parameters.
The "too few parameters" error message is familiar indeed. I got it when
I mistyped a column name.
This is the query:
> my $sQuery = "SELECT MachineID, AgentID, instanceKey, AgentID +
>instanceKey AS TOT
> FROM dbo_CD_ROM_DATA
> ORDER BY TOT DESC;";
I think it might have something to do with the "+", that maybe this
makes access assume a wrong parameter type for the columns involved. Or
add parens around the "sum", before the "AS".
HTH,
Bart.
