-
Edit drop list problems
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
session("myCriteria"=Request.QueryString("criteria"
will keep that all the time.
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & session("myCriteria" & "' ORDER BY SURNAME"
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
Thanks.
As a result of trying this I appear to have found a bug. Try opening an edit page from a page with a link such as:
../Editpage.asp?param="test Param"
The Cancel button will not appear.
if you have the startup property
mydb.dbstartup="EditAdd" set. Try it
Bob Cummings
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
Thanks.
As a result of trying this I appear to have found a bug. Try opening an edit page from a page with a link such as:
../Editpage.asp?param="test Param"
The Cancel button will not appear.
if you have the startup property
mydb.dbstartup="EditAdd" set. Try it
Bob Cummings
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
EditAdd is to allow user only to "Add" right from the beginning. User cannot see any display of data. Does it make sense ?
------------
Bob Cummings at 9/13/01 8:24:22 AM
Thanks.
As a result of trying this I appear to have found a bug. Try opening an edit page from a page with a link such as:
../Editpage.asp?param="test Param"
The Cancel button will not appear.
if you have the startup property
mydb.dbstartup="EditAdd" set. Try it
Bob Cummings
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
Frank
That may be so but the Cancel (which can, of course be changed to `View' button allows users who want to, Edit/Delete records when first opening the Edit page - by displaying the grid with the pencil/scissors icons.
If I don't pass the page parameters but use session variables instead, I get the effect I require. I just wondered why passing the param stopped the bitmap appearing.
Bob
------------
Frank Kwong at 9/13/01 10:43:57 AM
EditAdd is to allow user only to "Add" right from the beginning. User cannot see any display of data. Does it make sense ?
------------
Bob Cummings at 9/13/01 8:24:22 AM
Thanks.
As a result of trying this I appear to have found a bug. Try opening an edit page from a page with a link such as:
../Editpage.asp?param="test Param"
The Cancel button will not appear.
if you have the startup property
mydb.dbstartup="EditAdd" set. Try it
Bob Cummings
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
I cannot dup th eproblem. I use X.dbStartup="EditAdd" and has no problem as teh Cancel button is still there .The following code is what I use. Modify it to break it -
<%
Set X= Server.CreateObject("ASP.db"
X.dbUnit = "3"
X.dbDSN = "DSN=NWIND"
X.dbSQL = "SELECT EmployeeID,LastName,FirstName,Title,City,Region,Co untry," &_
"HireDate,Left(HireDate,8) as Hired FROM Employees ORDER BY LastName"
X.dbMode = "Grid"
X.dbGridInc = "5"
X.dbDBType = "SQL"
X.dbOptions = "NavGotoFldIndex=1"
X.dbExportFlds = "LastName,HireDate,Hired"
X.dbNameMap = "(;|)Hired|Hired||Left(HireDate,8)" ' necessary for sorting to work
X.dbGridTableTag = "Border=1 cellspacing=1 cellpadding=1"
X.dbFormTableTag = "Border=1 cellspacing=1 cellpadding=1"
X.dbEditFlds = "(;,[])LastName, FirstName, Title, City, Region, Country, HireDate"
X.dbEditParams = "(;,)TableName=Employees,BookMarkFlds=0,EditVa lidateName=PreventDel()," &_
"UpdateIcon=True,DeleteIcon=True,EditIconsLayo ut=Left"
X.dbStartup="EditAdd"
X.dbImageDir = "/d/aspdb/images/"
X.dbNavigationItem = "Top,Prev,Next,Bottom,Reload,Filter"
X.dbNavigationIcon = "std"
X.ASPdb
%>
------------
Bob Cummings at 9/14/01 9:15:45 AM
Frank
That may be so but the Cancel (which can, of course be changed to `View' button allows users who want to, Edit/Delete records when first opening the Edit page - by displaying the grid with the pencil/scissors icons.
If I don't pass the page parameters but use session variables instead, I get the effect I require. I just wondered why passing the param stopped the bitmap appearing.
Bob
------------
Frank Kwong at 9/13/01 10:43:57 AM
EditAdd is to allow user only to "Add" right from the beginning. User cannot see any display of data. Does it make sense ?
------------
Bob Cummings at 9/13/01 8:24:22 AM
Thanks.
As a result of trying this I appear to have found a bug. Try opening an edit page from a page with a link such as:
../Editpage.asp?param="test Param"
The Cancel button will not appear.
if you have the startup property
mydb.dbstartup="EditAdd" set. Try it
Bob Cummings
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
Frank
Rename the code you sent me to a page called "AspdbTest2"
Create a new page using the following and call it "AspdbTest1":
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<p><a href="aspdbTest2.asp?Test1="This is test 1"">Open Test Page</a></p>
</body>
</html>
Double click the link and the CANCEL button will not appear!
Bob
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
this message have no code... I switched to another server, please send me the entire code to test.
------------
Bob Cummings at 9/17/01 6:02:12 AM
Frank
Rename the code you sent me to a page called "AspdbTest2"
Create a new page using the following and call it "AspdbTest1":
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<p><a href="aspdbTest2.asp?Test1="This is test 1"">Open Test Page</a></p>
</body>
</html>
Double click the link and the CANCEL button will not appear!
Bob
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
Frank
Here is the complete code:
Save this as aspdbtest1.asp:
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<p><a href="aspdbTest2.asp?Test1="This is test 1"">Open Test Page</a></p>
</body>
</html>
Save text below as Aspdbtest2.asp:
<%
Set X= Server.CreateObject("ASP.db"
X.dbUnit = "3"
X.dbDSN = "DSN=NWIND"
X.dbSQL = "SELECT EmployeeID,LastName,FirstName,Title,City,Region,Co untry," &_
"HireDate,Left(HireDate,8) as Hired FROM Employees ORDER BY LastName"
X.dbMode = "Grid"
X.dbGridInc = "5"
X.dbDBType = "SQL"
X.dbOptions = "NavGotoFldIndex=1"
X.dbExportFlds = "LastName,HireDate,Hired"
X.dbNameMap = "(;|)Hired|Hired||Left(HireDate,8)" ' necessary for sorting to work
X.dbGridTableTag = "Border=1 cellspacing=1 cellpadding=1"
X.dbFormTableTag = "Border=1 cellspacing=1 cellpadding=1"
X.dbEditFlds = "(;,[])LastName, FirstName, Title, City, Region, Country, HireDate"
X.dbEditParams = "(;,)TableName=Employees,BookMarkFlds=0,EditVa lidateName=PreventDel()," &_
"UpdateIcon=True,DeleteIcon=True,EditIconsLayo ut=Left"
X.dbStartup="EditAdd"
X.dbImageDir = "/d/aspdb/images/"
X.dbNavigationItem = "Top,Prev,Next,Bottom,Reload,Filter"
X.dbNavigationIcon = "std"
X.ASPdb
%>
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
-
Edit drop list problems (reply)
I saw the problem and corrected that. I'llleave the cancel button on as it can be always turned to off by the 'none'. send me your id file and I'll send you the proper test copy. It'll be released after some testing....
------------
Bob Cummings at 9/18/01 6:42:40 AM
Frank
Here is the complete code:
Save this as aspdbtest1.asp:
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<p><a href="aspdbTest2.asp?Test1="This is test 1"">Open Test Page</a></p>
</body>
</html>
Save text below as Aspdbtest2.asp:
<%
Set X= Server.CreateObject("ASP.db"
X.dbUnit = "3"
X.dbDSN = "DSN=NWIND"
X.dbSQL = "SELECT EmployeeID,LastName,FirstName,Title,City,Region,Co untry," &_
"HireDate,Left(HireDate,8) as Hired FROM Employees ORDER BY LastName"
X.dbMode = "Grid"
X.dbGridInc = "5"
X.dbDBType = "SQL"
X.dbOptions = "NavGotoFldIndex=1"
X.dbExportFlds = "LastName,HireDate,Hired"
X.dbNameMap = "(;|)Hired|Hired||Left(HireDate,8)" ' necessary for sorting to work
X.dbGridTableTag = "Border=1 cellspacing=1 cellpadding=1"
X.dbFormTableTag = "Border=1 cellspacing=1 cellpadding=1"
X.dbEditFlds = "(;,[])LastName, FirstName, Title, City, Region, Country, HireDate"
X.dbEditParams = "(;,)TableName=Employees,BookMarkFlds=0,EditVa lidateName=PreventDel()," &_
"UpdateIcon=True,DeleteIcon=True,EditIconsLayo ut=Left"
X.dbStartup="EditAdd"
X.dbImageDir = "/d/aspdb/images/"
X.dbNavigationItem = "Top,Prev,Next,Bottom,Reload,Filter"
X.dbNavigationIcon = "std"
X.ASPdb
%>
------------
Bob Cummings at 9/11/01 6:59:11 AM
Hi
I am creating an app where the user adds/edits to a table. After clicking ADDNEW the edit screen has the following drop down box to select students:
Mydb.dbEditDropflds="(;|)E_Rulcode||||SELECT RULCODE, Surname + N' ' + forename + N' ' + [Desc] + N' ' + Instcode FROM vwEMSStudents WHERE OWNORG= '" & criteria & "' ORDER BY SURNAME"
criteria is a variable passed to the page from the previous page:
<%criteria=Request.QueryString("criteria"%>
When the AddNew button is clicked, how can I maintain the value in `criteria' so that the drop list will use it?
Thanks
Bob Cummings
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
|
|