-
how to change values of a column
The following code divide the UnitPrice column by 27 - watch out for the delimiter conflict
<%
Set X= Server.CreateObject("ASP.DB"
X.dbUnit = "999"
X.dbMode = "Grid"
X.dbValidatorParams = "/ASPDB/Jars/"
X.dbDSN = "DSN=NWIND"
X.dbMagicCell = "(;,[]!|~/+{})UnitPrice,,<<!UnitPrice! / 27 ::##0.##>>"
X.dbSQL = "SELECT ProductID,ProductName,UnitPrice FROM Products"
X.ASPdb
%>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|