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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. mwlyoung

    Load distribution list from outlook

    Hi all How do I load the names of all my distribution lists from MS Outlook 2000. I'm using Delphi 6 Professional. Also once I've loaded the names of the distribution lists, how do I load all contacts within a specific distribution list? Thanks Louis
  2. mwlyoung

    How to pass variable value to xp_sendmail

    Hi there I want to pass a variable value to the xp_sendmail procedure such as the following: EXEC xp_sendmail @recipients = @email, @query = 'SELECT * from myTable inner join anotherTable on myTable.myColumn = anotherTable.anotherColumn', @subject = 'Report', @message = 'This is a...
  3. mwlyoung

    DBGridEH cannot select over multiple pages with shift

    Does anyone out there know how to use the DBGridEH control? The problem I'm having is that the grid can shift select on one page, but as soon as you scroll down to the next page with shift held in and want to make another selection then, then your selection from the previous page is not...
  4. mwlyoung

    count(*) and group by causes errror

    Just one last question. What does the code look like for the view vw_Count? Sorry if I'm pestering, but I'm quite a newbie at SQL. Thanks
  5. mwlyoung

    count(*) and group by causes errror

    Just a question about this though. What is in the view vw_Count in the last line your joining the view, but on which column? Thanks Louis
  6. mwlyoung

    count(*) and group by causes errror

    But I don't actually want to group the table by all the fields, otherwise it's useless if I want to add totals by member and by company. How will I do that?
  7. mwlyoung

    count(*) and group by causes errror

    Whenever I execute the following query:select member_id, company.company_code, company.credit_limit system, member_id, first_name, last_name, members.credit_limit, members.email, date_sent, count(*) from Company, Members left outer join Reminders on members.email =...

Part and Inventory Search

Back
Top