Re: Functions

From: Steven Burn (somewhere_at_in-time.invalid)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 22:09:49 -0000

Whats on line 38? 

--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"Paul Smith" <pws@twelve.me.uk> wrote in message
news:420691f2$0$7933$ed2619ec@ptn-nntp-reader01.plus.net...
> Why does the first function work without a problem, but the second one
does
> not?
>
> I cannot for the life of me see the difference!!!!!
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Function GetTeamID(PlayerNo)
> Set RSF = Server.CreateObject("ADODB.RecordSet")
> RSF.Open "Select * from tPlayers Where PlayerID = " & PlayerNo, DB
>  GetTeamID = RSF("TeamID")
> RSF.Close
> Set RSF = nothing
> End Function
>
>
> Function GetPlayerName(PlayerNo)
> Set RSF = Server.CreateObject("ADODB.RecordSet")
> RSF.Open "Select * from tPlayers Where PlayerID = " & PlayerNo, DB
> '------------------ Line 38
>  GetPlayerName = RSF("PlayerFirstName") & " " & RSF("PlayerSecondName") &
> " -- " & RSF("TeamName")
> RSF.Close
> Set RSF = nothing
> End Function
>
> Error:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> /CricketersDarts/db.asp, line 38
>
>
>
>