Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query on personal view

Status
Not open for further replies.

1000kisoen

IS-IT--Management
Aug 12, 2004
37
NL
hi,
I am creating a search page
the query is like this
SELECT Call.CallID, Call.CallTypeID, Call.IntakeDate, Call.CustomerName, Call.SystemID, Call.ShortDescription, Q_LastLogstatus.CallStatusID, Q_LastLogstatus.CallStatus, CallStatus.CallGroupStatus, Support.SupportTeamID FROM ((Call INNER JOIN Q_LastLogstatus ON Call.CallID = Q_LastLogstatus.CallID) INNER JOIN CallStatus ON Q_LastLogstatus.CallStatusID = CallStatus.CallStatusID) INNER JOIN Support ON Call.IntakeBy = Support.SupportID WHERE support.supportlogin = 'varuser'

name = varuser -- value = me --run time value = request("svusername")

so I want to query of my own record but is not working
(like a personal overview)

am i doying something wrong?
working with MX

please advise
thx kisoen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top