-
Trying to get the record number from AspDbIndex (reply)
the following code use teh AspdbIndex ->
<%
Set X= Server.CreateObject("ASP.DB"
X.dbUnit = "999"
X.dbMode = "Grid"
X.dbDSN = "DSN=NWIND"
X.dbMagicCell = "(;,[]#|~/+{})EmployeeID,,#AspdbIndex# - #0#"
X.dbSQL = "SELECT EmployeeID,LastName,FirstName FROM Employees"
X.ASPdb
%>
------------
Allan at 8/10/01 12:45:58 PM
Hello,
I saw in your other messages a way to put images in for editing and deleting records. While using the code I found that I can't use AsoDbIndex. Is this because of a coding erro on my part?
<%
Set x = Server.CreateObject("ASPdb.Pro"
x.dbDSN="joeandal"
X.dbUnit = 800
X.dbSQL = "SELECT 1 as Record, County, State FROM homes"
X.dbEditParams = "(;,)TableName=homes, BookMarkFlds=ID, RecordScope=Single"
x.dbNavigationItem = "top,prev,next,bottom,reload,update"
' original code from aspdb forum
'X.dbMagicCell = "(*[]#|~/)Edit**<a href=''#Me#?aspDBBut_800=aspdbEditUpdate:: #AspdbIndex#&aspDBUnit=_800&aspDBClick_800=update& aspdbEBM_800=' & Server.URLEncode('County=' & '#(0)#''><img src=''../images/updateicon.gif'' width=''18'' height=''16'' border=''0''></a>,<a href=''#Me#?aspDBBut_800=aspdbEditDelete:: #AspdbIndex#&aspDBUnit=_800&aspDBClick_800=delete& aspdbEBM_800=' & Server.URLEncode('County=' & '#(0)#''><img src=''../images/deleteicon.gif'' width=''20'' height=''16'' border=''0''></a>"
'can't get record number on the line below using aspDbIndex
MC = "Record,,<a href=""#Me#?aspDBBut_800=aspdbGoForm::#Asp dbIndex#"">STEP1</a>   "
MC = MC & "<a href=""#Me#?aspDBBut_800=aspdbEditUpdate:: #AspdbIndex#&aspDBUnit=_800&aspDBClick_800=update& aspdbEBM_800=" & Server.URLEncode("County=" & "#(0)#"">STEP2</a>"
X.dbMagicCell = MC
x.ASPdbPro
%>
Thanks
Allan
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
|
|