GlennBSI (Visitor): Yes, that is a good suggestion. That is what I was intending to do. I am not sure how to implement this; however, I will try it.
Thanks for your input/idea!
Carl
Right now I am, from the client-side, calling an asp with a window.open(). The asp called acquires data from SQL Server 7.0 via stored procedure and then changes data on the client document via window.opener.xxxxxxxx.value = whatever.
This technique results in a brief opening of a window and...
This example uses a trigger that handles multi-row or single row updates and calls a stored procedure that inserts rows into another table:
/****** Object: Trigger dbo.TriggerInsert_IOM Script Date: 2/9/2001 1:24:13 PM ******/
CREATE TRIGGER [TriggerInsert_IOM] ON [OT_OR_Order]
FOR INSERT...
To do what you are specifying, you are definitely going to have to hand code. You might want to consider stop using WYSIWYG editors now so that you can master the many languages involved. DHTML stands for Dynamic Hypertext Markup Language. DHTML is not a single creature. It is comprised of...
Have a javascript function that acquires the clicked element value (window.event.srcElement) and then trigger an asp by submitting a form that does nothing but take the querystring or field name value and it then resets the session variable.
From the client side in JavaScript you have to submit a form that executes the server side session variable changes.
I just did this in an intranet application. I had two frames. From the top frame the user selected some options and that, on the client side, generated the submission of a from...
Setup a session variable and reference it:
Session("Session_whatever") = "whatever"
To fetch in the other frame:
dim x_parm
x_parm = Session("Session_whatever")
that's all
Make sure you are actually declaring a session variable.
You do NOT have to put it in global.asa.
Your code should be similar to this:
Session("Session_Parm01") = "whatever"
Then to fetch it in another asp:
dim x_parm01
x_parm01 = Session("Session_Parm01")
The...
Use either request.querystring("thefieldpassedasaparm")
or request.form("the html field name")
or request("the field name") (does both above)
or use session variables
This is easy to do. The best way to do it is to use event-bubbling - adding an onclick event that calls a javascript function - add the onclick at the BODY tag level. Then, use window.event.srcElement.id to determine the html element that generated the event. Be sure to use the id tag on your...
I have used three ways:
1) via passed parms - Request.QueryString
2) via Form in hidden fields - Request.Form
3) Using session variables.
Acquiring the data is easiest using the form and querystring techniques; however, sometimes you want to be able to talk to other modules without...
Get an ISP to host your website. Then, build your website. Then, when you get to an interview, have them go to your website. Talk is cheap, when you can show them what you have done, that sells!
Within a trigger I need to identify a user via his NT User id but there is no system variable that provides this and instead provide the SQL Server logon.
Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.