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 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: platp
  • Order by date
  1. platp

    query

    Sorry I was not clear TABLE ALPHA aplha_id team1 team2 -------- ------ ----- 1 100 106 2 109 111 3 100 0 TABLE TEAM teamid teamname ------ -------- 100 ars 106 mtc 109 juv 200 aja I want a query that retrieves only...
  2. platp

    query

    hello, I have a noob question I have a table called Alpha aplha_id team1 team2 and a table called Team teamid teamname I cannot get the correct query in order to retrieve all the data from table Alpha where team1 to exist in table Team and team2 to exist in table Team OR TO be 0...
  3. platp

    mailmessage date

    Well silly me!! I changed the regional settings to yyyy/mm/dd and when I have dw_1.SetItem(ll_row, "date_registered", datetime(msg.DateReceived)) it gives me the following error Microsoft OLE DB Provider for SQL Server Invalid character value for cast specification. when I have...
  4. platp

    mailmessage date

    Hi, I writing an app that takes mails, parses them and put them in a db. I am using PB 10.2 , MS sql server 2000 and connect using OLE DB. Among others I have this piece of code mailMessage msg . . messagebox('date',msg.DateReceived) . dw_1.SetItem(ll_row, "date_registered"...

Part and Inventory Search

Back
Top