ASP SCRIPT

[RobA]

Hi,

I am trying to create a recordset !

aSQLstr = "SELECT Score FROM iaVals WHERE iauID= 'UID' AND QLID= 'A'"
Set aScrRst = objConn.Execute (aSQLstr)
Howerver UID is a number and am getting
Error converting data type varchar to numeric.

I am sure this can't be so difficult but I have been searching for ages for
the correct way to write this but without success.

 

[Thomas A. Rowe]

Try:

aSQLstr = "SELECT Score FROM iaVals WHERE QLID= 'A' AND iauID= " & UID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[RobA]

Cheers much appreciated.

Try:

aSQLstr = "SELECT Score FROM iaVals WHERE QLID= 'A' AND iauID= " & UID

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================