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 Mike Lewis 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. ishaybas

    Two Way SSL - How to?

    Hi Gurus, I have a requirement at my company to connect to an external web service using xml over http, with Two Way SSL authentication and encryption. I know how to use LWP to create POSTs to HTTPS web services, but the Two Way SSL part, I dont even know where to begin. I have my private and...
  2. ishaybas

    Can a Function/SP be aware whether its results be joined with a table?

    Hy Ryan, Actually populating the proxy table is not the main difficulty, however the solution you proposed for that task is certainly impressive. The main difficulty is that some queries call the dealer table with no relation to any accounts, and expect a distinct list of dealers in return...
  3. ishaybas

    Can a Function/SP be aware whether its results be joined with a table?

    Yep, that part is easy. Trouble is my restriction is on limiting the queries and reports using those tables, and that the dealers table must remain in a condition to return just a list of dealers and their current addresses, regardless of accounts, and with no duplicates ..
  4. ishaybas

    Can a Function/SP be aware whether its results be joined with a table?

    Certainly, please assume the following: 1. accounts table: columns: account_number, creation_date, dealer_code 2. dealers table: columns: dealer_code, address there are many queries using these tables. some just query the accounts, some just the dealers, and some join them using the...
  5. ishaybas

    Can a Function/SP be aware whether its results be joined with a table?

    Hi, Is there any way for a function or a stored procedure to be aware of whether its results will be joined with another table in the calling query? For example, assume one query calls: Select * from MyFunction while another query does: Select * from MyFunction LEFT JOIN MyTable on ... I...

Part and Inventory Search

Back
Top