Search results for query: *

Thank you everybody who responded. It looks like my problem is solved. Ron--

Thanks for your assistance. The answers to everybodies questions: The number 99 is under dispaly capacity. The switch is a G3 SI The processor is a TN790 V12 The release is G3V6.1.03.0.223.5 Ron--

We have a G3 V6 system. Does anybody know how I can increase the quantity of VDN's allowed in our system? Our capacity shows a maximum of 99, we need more. Ron--

Thanks to everybody, I have solved the problem with some of the feedback from Tek-Tips. Ron--

You are right, it is a varchar field. Sorry for my error. Ron--

I have a database with address, number and street fields. The address field has to contain the full address. The number field needs to contain just the street number. The street field needs to contain the street. The address field already contains the complete address. I need to select the...

For this project, all I need to do is keep one row and delste the rest. It doesn't matter which ones get deleted or which one gets kept. There is a primary key automatically assigned with the insert. If I can figure out a way I will keep the lowest number in the series and delete the rest. Ron--

This greatly deepens the amount of information you have to understand. The initial code that creates the problem is: insert into dbo.AccountZoneTbl0 (AccountNumber, S_ActNbr, System_no, MAS_ZoneID, o_mas_zoneid, fmt, [Description], GroupID, zone_to_restore, DateTimeStamp, RestoreDelay...

I am working on a conversion and I have run into a problem concerning duplicate rows. I ultimately have to insert the data in the table where the conversion is being done into another table. In the new table three fields make up the primary key. Due to various factors the in the conversion...

Thanks to both bborissov and mrdenny. I appreciate your assistance. I got what I needed. Ron--

I need to run a select distinct from query analyzer to update a table. Below is my attempt that did not work. Any ideas? Thanks, Ron-- insert into dbo.AccountZoneTbl0 (acct_cancelcode, AccountNumber, S_ActNbr, System_no, MAS_ZoneID, o_mas_zoneid, fmt, [Description], GroupID...

John, I added the parentheses and the code ran without error. However, I don't see any change to the text. Michael is right, the code I am trying to chnge is similar to 1A234. I want it to be 11234 after running the code. There may be more than one letter in the text such as 1ca234. In...

Earthandfire & John, I changed the code to: DECLARE @asc tinyint SET @asc = 1 WHILE @asc <= 26 BEGIN UPDATE dbo.AccountMainTbl0 SET ID_no = Replace(ID_no, ASCii(@asc + 64), Cast(@asc AS varchar(2)) SET @asc = @asc + 1 END I then got the following error...

John, I pasted the following in Query Analyzer and tried to execute it: DECLARE @asc tinyint SET @asc = 1 WHILE @asc <= 26 BEGIN UPDATE dbo.AccountMainTbl0 SET ID_no = Replace(ID_no, ASC(@asc + 64), Cast(@asc AS varchar(2)) SET @asc = @asc + 1 END I got...

I have a situation where I have account numbers that contain letters. I need to change the letters to numbers creating an int value. I have several thousand account numbers to change and several different letters to convert. I would like to convert an "A" to 1, "B" to 2, "C" to 3, etc. Any...

I have an interesting situation. We are currently undergoing a conversion from one automation system to another. The new system uses SQL 2000, the old system is a DOS btreive system. We are able to export our btreive data to an Access database then to SQL. However, we have to make several...

Does anybody know if it is possible to install a remote IP phone that will connect to an old v6 G3? Thanks, Ron--

I'm having trouble getting a new network module to work correctly with an older Cisco 2621 router manufactured in 2002. The part number I expected on the card we ordered was NM-4E but I note it is NM-4E= instead. Can anyone confirm if the NM-4E= is compatible with the older Cisco 2600 series...

I have been running an internet server with my own DNS for some time. I have never messed with reverse lookup zones. We are having a problem sending emil to some addresses such any aol address. The error messge we get is a problem with reverse lookup. I have tried several thins to get the...

Zemp: The code in the .asp file that creates the connection is: 'Create the connection Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "MonitoringAmerica" 'Define the SQL statement strSQL = "SELECT * FROM [Active Co's]" 'Create recordset and retrieve values using...