Search results for query: *

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...

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...

Thank you Mjia. That is exactly what I needed. I called it Active X because when I am in the DTS wizard I have the option of choosing Copy Column, active-x, etc. Copy Column did not do it but choosing Active-x allowed me to type exactly what you suggested. Thank you again :)

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...

Thank you both for helping. That was exactly what I needed. I ended up using : SET @DateOfPurchase=(SELECT TOP 1 DateOfPurchase FROM Purchases WHERE CustomerID=75 ORDER BY DateOfPurchase DESC) From Donutman. Thank you again.

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...

I agree with Esquared. DTS is probably your best bet. With it you can import from a csv on a scheduled basis, on a one time basis, or you can even call the DTS package you create from a stored procedure. I have found DTS very useful. In one case I use DTS to FTP to a Telecenter site (They...

Thank you sleipnir214 for taking the time to help me out:-) This is very instructional and gives me a better idea of what can be accomplished. In my case I have 3 variables each with at least 4 possible values from which to choose a result. To me it appears that it will take less code to keep...

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...

Thank you Esquared, Sorry I did not get it the first time. Regards, Chip

Thank you Esquared, However, the description I provided was not complete, I was already getting those results with: SELECT P.prodName, P.ProductDesc, S.* FROM Product P INNER JOIN Supplier S ON P.SupplierID1=S.SupplierID or P.SupplierID2=S.SupplierID I appologize. I forgot...

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...

Just found a description and an answer for my problem at http://www.mssqlserver.com/faq/access-deleted.asp Regards, Chip

Thank you cmmrfrds. The table has a primary key. However, it is of type bigint. I read somewhere on the list today about Access having troubles with bigint values. I will change the bigint to int tomorrow and I will also check to make sure there is an unique index. Since I did not set up an...

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...