Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Session Variable in a Command Object

New Here ,
May 22, 2007 May 22, 2007
Hi all,
How would I insert a session variable in place of Request.Form variable in the following code:

<%

Set Command1 = Server.CreateObject ("ADODB.Command")
Command1.ActiveConnection = MM_skilledovertime_STRING
Command1.CommandText = "DELETE FROM Employeedata WHERE last5=?"
Command1.Parameters.Append Command1.CreateParameter("MMColparam", 200, 1, 9, MM_IIF(request.form("last5"), request.form("last5"), Command1__MMColparam & ""))
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
Instead of "(request.form("last5"), "
it would be a (session("last5")

Thanks,
Lenny
TOPICS
Server side applications
278
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
May 22, 2007 May 22, 2007
LATEST
I think you've answered your own question really :)

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004



Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines