Logo 
Search:

Asp.net Answers

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds
  Question Asked By: Bertha Ferguson   on Dec 09 In Asp.net Category.

  
Question Answered By: Gustavo Costa   on Dec 09


<%@ Language=VBScript %>

<%
Response.expires = 0

Set conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
Set comm = Server.CreateObject("ADODB.Command")
'conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" &
Server.MapPath(dbPath)
'conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & dbPath
'conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

conn.open"driver={Microsoft Access Driver
(*.mdb)};dbq=F:\dabs\grid\cs\dabs.mdb"

rs.open "stock", conn, 2, 2


if not rs.eof then rs.movefirst
do until rs.eof
%>

<div align="center">
<table border="1" width="600">
<tr>
<td width="200"><%= FormatCurrency(rs("Ex Vat")) %></td>
</tr>
</table>
</div>


<%
rs.movenext
loop
%>

<% rs.close() %>


formats it to dollars - dunno about any other currencies ????
as found at
mk:@MSITStore:c:\MSDN98\98VSa\1033\vbscript.chm::/htm/vsfctFormatCurrency.ht
m

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How can I prevent data trancation? Or get search suggestion and latest updates.


Tagged: