Re: Call Net.Data Function from Javascript

Peter,

JavaScript runs on the client, while Net.Data runs on the server, so you
really can't have a JavaScript function call a Net.Data function.  You
could run the Net.Data function first to get the value, then put the value
in something that JavaScript can get at (like a hidden field in a form).

Mike E.





                                                                                
                                                  
                      "Peter Vidal"                                             
                                                  
                      <Peter_Vidal@pall        To:       web400@xxxxxxxxxxxx    
                                                  
                      .com>                    cc:                              
                                                  
                      Sent by:                 Subject:  [WEB400] Call Net.Data 
Function from Javascript                          
                      web400-bounces@mi                                         
                                                  
                      drange.com                                                
                                                  
                                                                                
                                                  
                                                                                
                                                  
                      11/18/2003 01:21                                          
                                                  
                      PM                                                        
                                                  
                      Please respond to                                         
                                                  
                      Web Enabling the                                          
                                                  
                      AS400 / iSeries                                           
                                                  
                                                                                
                                                  
                                                                                
                                                  




Hi guys!

This should be very simple.  I want to call a DTW_SQL function from
Javascript.
How I do it?  It is not working like this...

NET.DATA CODE
%{ --------------------------------------------------------------------- %}
%{ Function: CHKEMPSTS                                                   %}
%{ Purpose : Check the employee status                                   %}
%{ --------------------------------------------------------------------- %}
%FUNCTION(DTW_SQL) CHKEMPSTS() {
SELECT EMPSTS FROM PLIB.EMPTA WHERE ENVCOD = '$(ENVCD)' and BADGE
= '$(emp)'
%Message {
100: "@DTW_ASSIGN(empsts,"*")":continue
%}
%REPORT {
%ROW {
@DTW_ASSIGN(empsts,$(V1))
%}
%}
%}

JAVASCRIPT CODE
function chkempsts() {
@CHKEMPSTS()
var empsts = "&empsts";
alert(empsts);
if (empsts != "") {
    alert("Employee is not in the facilities");
return;
}

Your help is highly appreciated...
Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com

"A good player makes himself look good; a great player makes the team look
good."
Author unknown


_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.