FormatNumber Trim function

Results 1 to 2 of 2

Thread: FormatNumber Trim function

  1. #1
    Rolly Guest

    Default FormatNumber Trim function

    To all,<BR><BR>I would like to break down <BR>&#060;% = rs(i)%&#062;<BR><BR>so I can set each field individual using the <BR><BR>FormatNumber(Trim(abs(lat1)),1)<BR><BR>Som e fields are text others are numbers<BR><BR>FormatNumber(Trim(abs(rs(1)),3) function.<BR>the above gives me errors.<BR><BR>Any idea how ?<BR><BR>Thanks for a reply.<BR><BR>&#060;table border=0&#062;<BR>&#060;% Do Until rs.EOF %&#062;<BR>&#060;tr&#062;<BR>&#060;% for i = 0 to howmanyfields %&#062;<BR>&#060;TD&#062;&#060;valign="top"&#062;& #060;% = rs(i)%&#062;<BR>&#060;/td&#062;<BR>&#060;% next %&#062;<BR>&#060;/tr&#062;<BR>&#060;% rs.movenext<BR>loop<BR>rs.close<BR>set rs=nothing<BR>conntemp.close<BR>set conntemp=nothing%&#062;<BR>&#060;/table&#062;<BR><BR>

  2. #2
    Mukesh Sachdev Guest

    Default RE: FormatNumber Trim function

    You can also access each field of the recordset using field name<BR>e.g : rs is the recordset<BR><BR>rs("&#060;field name&#062;")-&#062; gives you the value of the field.

Posting Permissions

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