Re: Displaying data to 2 decimal points

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Guy Hocking (guy_at_ANTIbradflack.SPAMcom)
Date: 03/07/04 

Date: Sun, 7 Mar 2004 19:13:13 -0000

Hi there,

Apologies for that.....

I have downloaded the script docs, and it is very useful, ta.....
But i was wondering how i would incorporate this into my SELECT statement?

See entire code below -
*******
  <%
    Dim strConnect, DataConnection

      Set DataConnection = Server.CreateObject("ADODB.Connection")
      strConnect = "DRIVER={SQL
Server};SERVER=server;UID=user;PWD=password;DATABASE=database"
      DataConnection.Open strConnect
 %>
<%
    Dim RS
     Set RS = DataConnection.Execute("SELECT col2, currencycol FROM view
           WHERE col1='" & Session("listbox") & "'")
                do until RS.EOF

<a href= "page.asp?col1=<% =RS("col2")%>"><% =RS("col2")%></a>

<% =RS("currencycol")%>

<% RS.MoveNext
Loop %>
*******

How/where can i format the "currencycol" ???

Thanks again 

--
G
www.bradflack.com
Please remove ANTI and SPAM from my
email address before sending me an email.
"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:#$sGBpGBEHA.624@TK2MSFTNGP10.phx.gbl...
> Guy Hocking wrote:
> > Hi,
> >
> > Thanks for the response -
> >
> > Any examples of the functions in my scenario?
> >
> Given that you have not provided any details about your scenario (where
are
> you having a problem? Connecting to the database? Retrieving data in a
> recordset? Reading the data from the fields in the recordset?), I can't
> offer any examples beyond what is shown in the online documentation.
Perhaps
> that is what you need ... ? Here is a link:
>
>  http://tinyurl.com/7rk6
>
> Just look up the functions in there once you have downloaded and installed
> it. A Google search or a search of www.aspfaq.com could also provide you
> with some examples of their use.
>
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Relevant Pages

  • Re: Displaying data to 2 decimal points
    ... Reading the data from the fields in the recordset?), ... A Google search or a search of www.aspfaq.com could also provide you ... This email account is my spam trap so I ...
    (microsoft.public.sqlserver.setup)
  • Re: ADP report based on stored procedure.
    ... sylvain aei ca (fill the blanks, no spam please) ... set it dynamically in the OnOpen event of the report: ... that is based on a ado recordset. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: where to insert nospam ?
    ... They can't get your email address from a Google search. ... It is a coincidence that there is a lot of spam about ... Eugene ... > How do the spammers get an email address from a Google search? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Delete my email address ---- PLEASE
    ... I would need to communicate with you some other ... Try a Google search on your email address. ... notices; bounced spam. ...
    (microsoft.public.security.virus)
  • Re: OE 6 - Can a visited website access ones email address?
    ... > from a Google search, looking for the Gowerton Caravan Club site. ... Got a spam email ... > after receiving the spam, ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)