T
tony wong
i make use of showmodaldialog to pass a value to an asp page (cancell2.asp)
window.showModalDialog("cancell2.asp",,"dialogHeight: 140px; dialogWidth:
350px; dialogTop: px; dialogLeft: px; edge: Raised; center: Yes; help: No;
resizable: No; status: No;");
cancell2.asp is an asp page to null the field in SQL table.
how can i put the value to this line (objCommand.CommandText....). Thanks a
lot.
<%
Option Explicit
Dim strConnect
%>
<!-- #include file="datastore.asp" -->
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common
Files\System\ado\msado15.dll" -->
<%
Dim CancellsmsID, objRS, objCommand
Set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = strConnect
objCommand.CommandText = "update dbo.table_out set Schedule_Time = null
where fax_id =window.dialogArguments;"
objCommand.CommandType = adCmdText
Set objRS = objCommand.Execute
Set objRS = Nothing
%>
window.showModalDialog("cancell2.asp",,"dialogHeight: 140px; dialogWidth:
350px; dialogTop: px; dialogLeft: px; edge: Raised; center: Yes; help: No;
resizable: No; status: No;");
cancell2.asp is an asp page to null the field in SQL table.
how can i put the value to this line (objCommand.CommandText....). Thanks a
lot.
<%
Option Explicit
Dim strConnect
%>
<!-- #include file="datastore.asp" -->
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common
Files\System\ado\msado15.dll" -->
<%
Dim CancellsmsID, objRS, objCommand
Set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = strConnect
objCommand.CommandText = "update dbo.table_out set Schedule_Time = null
where fax_id =window.dialogArguments;"
objCommand.CommandType = adCmdText
Set objRS = objCommand.Execute
Set objRS = Nothing
%>