Welcome #Session.Name#

NG&G WebLink allows you to view your current service calls.  Please choose from the list below.

by Corporate:

select * from params where ParamID = 'ODBCsource' select * from users where UserName='#session.user#' and Password='#session.password#'  
 

by Location:

SELECT * FROM params where ParamID = 'ODBCsource' select distinct StoreName from orders where CorpID= '#Session.CorpID#' order by StoreName
 
 

by Corporate PO #:

SELECT * FROM params where ParamID = 'ODBCsource' select distinct PONmbr from orders where CorpID='#Session.CorpID#' order by PONmbr

 
 

by NG&G work order #:

SELECT * FROM params where ParamID = 'ODBCsource' select distinct OrderNmbr from orders where CorpID='#Session.CorpID#' order by OrderNmbr

 
 

 

 

 

 

SELECT * FROM params where ParamID = 'ODBCsource' select o.*, p.*, s.* from orders o, problem p, status s where o.ProblemCode=p.ProblemCode and o.StatusCode=s.StatusCode and PONmbr='#form.inputpurchase#' #StoreName#
#DistrictKey#
#StorePhone#
 

#Address1#
#Address2#
#City#, #State#