Home | Forums | Contact | Search | Syndication

[login] [create account]   Thursday, November 21, 2024

slxdeveloper.com   Home   Search   Contact us   About slxdeveloper   Syndication  Community   Forums (NEW!)   Newsletter Archive  Members   Your Profile   Submit Article  General   Administration (6)   OLE DB Provider   Miscellaneous (2)  Architect   VBScript (9)   ActiveX Controls (6)   How To's (14)   .NET Extensions (3)  External   OLE DB Provider (12)   SLAPI (SlgxApi.dll)   SalesLogix COM (1)  Web   ASP/ASP.NET (2)   Web Services   Web Client  Downloads   Samples (17)   Documentation (7)   Utilities (18)  Resources   SalesLogix (3)   Programming (1) 11/21/2024 6:50:48 PM slxdeveloper.com Now Live!   View User Profile    User Profile - Rich Eaton   Rich Eaton Beagle Consulting sertraline purchase buy sertraline uk fiogf49gjkf0d Log in to send this member a message!    Rich Eaton's Contributions Rich Eaton has contributed 1 comments and 0 articles.   Select to view: Comments  Articles  Comment: Question to All/Author fiogf49gjkf0d Just wondering how to modify this so that we add conditions to the query w/o it trying to add the condition as a column. Trying to simplify the grid so it pulls info based on currentUserId. strUserId = Application.BasicFunctions.CurrentUserID strSQL = "SELECT A1.LASTNAME, A1.FIRSTNAME, A1.ACCOUNT FROM CONTACT A1 LEFT JOIN ACTIVITY A2 ON (A1.CONTACTID=A2.CONTACTID) WHERE (A2.TYPE=262146) AND (A2.USERID= strUserId)" and using the strSQL as the SQL.TEXT portion Thanks for the help Author: Rich Eaton - 3/27/2003

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.  This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software. code of conduct |

page cache (param): 11/21/2024 7:33:25 PM