Re: Functions
From: Paul Smith (pws_at_twelve.me.uk)
Date: 02/06/05
- Next message: Tomas Eklund: "Re: Internationalizing a web site"
- Previous message: Steven Burn: "Re: Functions"
- In reply to: Steven Burn: "Re: Functions"
- Next in thread: Tomas Eklund: "Re: Functions"
- Reply: Tomas Eklund: "Re: Functions"
- Reply: Steven Burn: "Re: Functions"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 6 Feb 2005 23:10:10 -0000
Line 38 is the line above,, text wrapping caused the break:
RSF.Open "Select * from tPlayers Where PlayerID = " & PlayerNo, DB
"Steven Burn" <somewhere@in-time.invalid> wrote in message
news:eOX6$iJDFHA.2676@TK2MSFTNGP12.phx.gbl...
> 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
>>
>>
>>
>>
>
>
- Next message: Tomas Eklund: "Re: Internationalizing a web site"
- Previous message: Steven Burn: "Re: Functions"
- In reply to: Steven Burn: "Re: Functions"
- Next in thread: Tomas Eklund: "Re: Functions"
- Reply: Tomas Eklund: "Re: Functions"
- Reply: Steven Burn: "Re: Functions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
