'First' is not a recognized function name

[barathymathialagan]

Hi

This is my sql code in asp

sSql1 = "SELECT First(clid) AS clid, clLoanNo FROM client whERE (((clRegion)='" & region &"') AND ((class)='Active' )) GROUP BY clLoanNo ORDER BY clLoanNo"
I got the following error.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]'First' is not a recognized function name.

Any one can help me?

Thanks
Barathy

 

[medic]

barathymathialagan,
AFAIK, no database has built-in function named First. What exactly do you want to do here?

Medic

 

[Shaggs]

try
select top 1 fieldname
etc.

 

[sindhufire]

jump to the first row (if there ARE more than one records exists) and then execute the SQL statement
may be the following will help you.

sSql1 = "SELECT clid, clLoanNo FROM client whERE (((clRegion)='" & region &"') AND ((class)='Active' )) GROUP BY clLoanNo ORDER BY clLoanNo"

objRS.MoveFirst
objComm.ActiveConnection = strConnection
objComm.CommandText = sSql1
objComm.CommandType = adCmdText
objComm.Execute

... other code