sir,

i'm writing an application with the following code

mySQL = "SELECT start_date AS Date,"_
& "SUM(Ceil(round(duration/60,2))) AS Minutes "_
& "FROM account "_
& "WHERE (duration is not null) "_
& "GROUP BY start_date "
Dim objrs
Set objRS = Server.CreateObject("ADODB.Recordset")

objRS.Open mySQL, myConn, , , adCmdTable


however it gives the error
"error in FROM clause
plz help
thanx

Dear Amrit,

1) Please make sure that the table account exists.

2) Date is a keyword. You cannot use that as the alias for a column / expression. Either use some other aliase such as myDate or use [Date].

3) I think account is also a keyword. I am not sure. Please put it in square brackets ([account]) and try.

Hi there,

Do a response.write of your sql statement to see if it is contructed without any issues. And try running that directly in your DB and see if that produces the same error or runs successully.

adCmdTable - Have the provider generate an SQL query and return all rows from the specified table

adCmdText = Evaluate as a textual definition

Try adCmdText there. Take a look at this page Recordset.Open method

Cheers!

_________________________
- Vijay G
Strive for Perfection