Recordset Query

Results 1 to 2 of 2

Thread: Recordset Query

  1. #1
    Join Date
    Dec 1969

    Default Recordset Query

    Hi I was just wondering, is there any way i can manipulate the value of the recordset ( ie.multiply the value by 2 ) and then output this value.<BR>The recordset that i have created returns one value - i want to multiply this "rate" value by 2 to get the total this possible.<BR><BR>&#060;%<BR> <BR> sqlrate = "SELECT Rate FROM Rate WHERE Space_ID = &#039;"&space&"&#039;" <BR> Set rate = objConn.Execute(sqlrate)<BR> Response.Write("Rate:€")<BR> Do While Not rate.eof<BR> Response.Write rate("Rate")<BR> rate.movenext<BR> Loop<BR> Response.Write("an hour")<BR><BR>any ideas??<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset Query

    it&#039;s quite possible<BR><BR>sqlrate = "SELECT (Rate * 2) Nrate FROM Rate WHERE Space_ID = &#039;"&space&"&#039;" <BR>Set rate = objConn.Execute(sqlrate)<BR>Response.Write("Rate: ")<BR>Do While Not rate.eof<BR>Response.Write rate("Nrate ")<BR>rate.movenext<BR>Loop<BR>Response.Write( "an hour")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts