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 Wanet Telecoms Ltd 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: chipCHE
  • Content: Threads
  • Order by date
  1. chipCHE

    Lock down site to site VPN

    Greetings, I just created a VPN from my Cisco Pix 515E to a Netscreen in a datacenter someone else manages. The VPN is working fine; however, I would like to limit the traffic between sites to rdp. My Question is: What access-list do i make these entrys in. I have tried the access-list that is...
  2. chipCHE

    Cisco Pix VPN lockdown

    Greetings, I just created a VPN from my Cisco Pix 515E to a Netscreen in a datacenter someone else manages. The VPN is working fine; however, I would like to limit the traffic between sites to rdp. My Question is: What access-list do i make these entrys in. I have tried the access-list that is...
  3. chipCHE

    SQL DTS Active X

    Hello, I have a DTS that copies the colums from one table to another. What I would like to do is simply multiply the value in one colum in the source table by 100 and place that value in the destination using active X while not changing the source data. My problem is that I do not have a clue...
  4. chipCHE

    set variable from querry

    I have the following Querry which works: Declare @DateofPurchase as datetime SELECT TOP 1 DateofPurchase FROM Purchases WHERE customerID = 75 ORDER BY DateofPurchase DESC I would like to set @DateofPurchase = DateofPurchase from the above querry which returns only one row, but cannot figure...
  5. chipCHE

    Convertinf IF -elseif-else to Switch-Case

    Just wondering if it is possible to convert the following If else statement to a Switch case statement: <? if (($Var1 == "XXX") and ($var2 == "24") and (var3 == "36")) { $MyAnswer = "AAA"; } elseif (($Var1 == "YYY") and ($var2 == "24") and (var3 == "36")) { $MyAnswer = "BBB"; } elseif...
  6. chipCHE

    2 table join and query help

    Hello All, I have two tables as follows (simplified for discussion): Table 1 is named "Product" with the Fields: "ProdName", "ProdDesc", "SupplierID1", "supplierID2" Table 2 is named "Supplier" with the Fields: "SupplierID", "CompanyName", "ContactFirstName", "phoneNumber" I would like to...
  7. chipCHE

    ODBC to SLQ 2000 linked table yields '#Deleted'

    Hello All. I am trying to use Access2000 as a front end to a MS SQL 2000 database. I have 3 tables in the database I am using. In two of the tables I can view all rows but in one of the tables I only see #Deleted in each column except when I sort and then I only am able to see the first row that...

Part and Inventory Search

Back
Top