Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 6th, 2004, 11:29 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks for your help.
it work properly.
if you never mind can I ask that
How can move the combobox value to next page ? or
How can use this combobox between form tag ?

I use combobox.asp file between the form tag ie

<html>
<head>
  <script src="ComboBox.js" type="text/javascript">
  </script>
</head>
<body>
<form method=post action="http://dcilweb/combobox2.asp" id=empno name=empno>

  <script type="text/javascript">
  dm=new ComboBox("dm")
  dm.add(
  <%

     MyConnectionString = "" // connection string

    MySQLStatement = "SELECT employees.empno, employees.name " & _
        "FROM employees ORDER BY employees.name"

        .............

      Response.Write(vbTab & "new ComboBoxItem('" & _
            MyRecordset.Fields("name").Value & "', '" & _
            MyRecordset.Fields("empno").Value & "')")

      MyRecordset.MoveNext()

       ................. // combobox.asp coding

%>
)
</script>

</form>
</body>
</html>

it give error message that
"internet explorer can not open the internet site http://dcilweb/combobox.asp operation aborted "

when I remove form tag ie <form method=post action="http://dcilweb/combobox2.asp" id=empno name=empno>
then it work properly.

In one page I want to use multiple combobox and user
select value and records will display next page ?

regards.

Mateen


 
Old June 7th, 2004, 02:23 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

To be honest, I have no idea. Isn't there a help or FAQ page on the WebFX site that explains how to pass data from page to page?

If you can't get it to work, you could use a hidden field for the control's value. When the drop down looses focus, copy the value of the selected item to a hidden form field, and submit that.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee attendance form with DataGridView Dot_Net_Dev C# 3 June 8th, 2011 02:25 AM
Select the top 3 record of each employee phungleon Access 1 June 16th, 2007 01:16 AM
Fill select box and select recordset value markd Classic ASP Databases 1 February 20th, 2006 06:41 PM
When I hit save button the selected employee clear shoakat Classic ASP Databases 6 September 16th, 2004 01:41 AM
Spelling BruceFraser BOOK: Professional Crystal Reports for VS.NET 0 August 25th, 2003 12:26 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.