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

    Quantity of VDN's

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

    Quantity of VDN's

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

    Quantity of VDN's

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

    Text select question

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

    Text select question

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

    Text select question

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

    Delete Rows

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

    Delete Rows

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

    Delete Rows

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

    Query Analyzer Select Distinct

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

    Query Analyzer Select Distinct

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

    Text to number

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

    Text to number

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

    Text to number

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

    Text to number

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

    Transact SQL complex conversion problem

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

    IP Phone on old V6 G3

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

    Cisco 2621 and NM-4E vs NM-4E=

    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...
    • rwies
    • Thread
    • Replies: 2
    • Forum: Cisco
  19. rwies

    Reverse DNS Windows 2000 Server

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

    ADODB.Recordset error '800a0bb9'

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

Part and Inventory Search

Back
Top