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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: WhiteHatMarine
- Content: Threads
- Order by date
-
SX-200 ICP fowarding during voicemail when pressing 0
Hello, I am told this function was working then seemed to stop. User calls in and gets VM Press 0 routes to Ext 201 and receives, "currently on the phone message" If I dial direct to ext 201 internally or externally, no problem. From Call Rerouting Table - 19: Station Dial 0 routing...- WhiteHatMarine
- Thread
- Replies: 1
- Forum: Mitel Networks solutions
-
Query help
I have a tricky query I cannot seem to come up with a good solution for. The first query functions. Second needs works. I would like to make this a single query, need help with that. The WHERE statement in Query2, not sure how to handle this as well. Query2 should be the result set. Code...- WhiteHatMarine
- Thread
- Replies: 18
- Forum: Microsoft: FoxPro
-
missing comma error with IIF and LIKE
cannot seem to isolate this one...if I change the LIKE to = it works. Error: Missing comma SELECT aa.wono ,IIf(aa.item LIKE '7*' ,'Homeopathic','not homo') AS TEST FROM (((ppwohd10 aa INNER JOIN (icitem10 bb LEFT JOIN tblProductTypes dd ON bb.itmclss = dd.ItemCode) ON aa.item = bb.item)...- WhiteHatMarine
- Thread
- Replies: 17
- Forum: Microsoft: FoxPro
