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 Mike Lewis 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: *

  1. DwayneL

    ARC serve 11 job holding on win2003

    did a log on the tape engine Client Set DebugLevel: 1 09/13 06:02:32 [0394] Loading Changer.dll: Date[Jul 21 2004] Time[18:59:10] 09/13 06:02:32 [07f8] DB: Database Library not ready. 09/13 06:02:32 [07f8] DB:: SetDummyEntryPoints:: Executing SetDummyEntryPoints. error = 1 09/13 06:02:32...
  2. DwayneL

    ARC serve 11 job holding on win2003

    Hello I have Arcserve 11.1 running with the updates on a win 2003 macine with sp1. It works fine backing up win 2000 files. When I go to packup files from another win 2003 machine the job always get hung up. I have the right secuirty information entered in. I can access the data by going...
  3. DwayneL

    RAID 5 has redirected drive

    Hello, i have the job of fixing my old bosses mess! I am running RAID 5 on a data server. One drive of ID4 says its redirected to drive ID 0. The drive bays in the chasis are as listed from the top empty drive drive drive drive The RAID 5 is listed in the order of ID3, ID1, ID2 I assume...
  4. DwayneL

    Redirected Drive in Raid 5

    Hello, i have the job of fixing my old bosses mess! I am running RAID 5 on a data server. One drive of ID4 says its redirected to drive ID 0. The drive bays in the chasis are as listed from the top empty drive drive drive drive The RAID 5 is listed in the order of ID3, ID1, ID2 I assume...
  5. DwayneL

    Excel Forumla - two colums/need average

    Thanks guys I went ahead and used KenWright's soultion. Thanks for being so quick, I hardly use excel anymore so that saved me a lot of time.
  6. DwayneL

    Excel Forumla - two colums/need average

    Hello there I need to find that average for data that is related to a column of data. For example column A column B 1 45 1 23 3 5 2 43 4 12 2 32 I need to find the average of column...
  7. DwayneL

    Query speed, too many joins, need help getting reponse time down

    Hello there I have three tables: table 1: interviewer -> used to store the name of interviewwr Feilds: interviewerID int autonumber FullName text table 2: show_interviewers -> used to keep track of interviers for shows since there can more then on interviewer Feilds: showID int...
  8. DwayneL

    Changing the primary key

    MeanGreen and Kusch, thanks a bunch
  9. DwayneL

    Changing the primary key

    sorry forgot to mention that the text stays the same, its a constant.
  10. DwayneL

    Changing the primary key

    I need to run a update query to change the information in a field that will have text appened with a number increments. Example first record would be: text_01 secound record woulbe be: text_02 last record would be: text_03 So far I have this: Update text Set text_id = "text_" +...
  11. DwayneL

    LEFT OUTER JOIN PROBLEM?

    Hello there, I'm in need of some help with a left join. Here are my tables. One category can have many images and one images may belong to may categories. category ( name varchar(50) NOT NULL UNIQUE, catID int(4) AUTO_INCREMENT PRIMARY KEY ); image_category ( fk_imageID...
  12. DwayneL

    HELP with a Left Join, maybe I need a double Join??

    Hello there, I'm in need of some help with a left join. Here are my tables. One category can have many images and one images may belong to may categories. category ( name varchar(50) NOT NULL UNIQUE, catID int(4) AUTO_INCREMENT PRIMARY KEY ); image_category ( fk_imageID int(8) NOT...
  13. DwayneL

    Cursor Error , Skipping over Fetch status

    I Always think postive values are succesful, Thank you I will give that I go,
  14. DwayneL

    Cursor Error , Skipping over Fetch status

    My problem is that when i get the cursor open there is error because it skips over the fetch status. I now that there is reservation in the table with the number 1. It goes to the else of my fetchstatus else. some sample database code is: this is one record 1 - custID as int 5 -...
  15. DwayneL

    DLL for Collection object in VB 6.0

    Hello there I need to find the DLL for the collection object thats in VB 6.0 because in VB script they don't have one. I'm already using the Collection in my COM code. Is this even possible? If it is could you please tell the name of it and where to get it. Thanks and Regards DwayneL
  16. DwayneL

    Changeing varchar to int

    Thanks for all the help, I thought you had to set to keep the new value on : Cast(@var As Int), Convert(Int, @var) I never knew it actually changed the variable type, i was under the impression that it returned a value. Once again, Thanks. I get more out of...
  17. DwayneL

    Adding a number to a string

    thank you, Its not about style points, it about getting it working!
  18. DwayneL

    Changeing varchar to int

    Hello there, I have been trying to use cast and convert but with no luck. Is there any way to change a varchar to an int like "OOO1" and change that to 1 with out getting a null value?
  19. DwayneL

    Adding a number to a string

    ok then i need to do something like this AAAA + 1 = AAAB AAAB + 1 = AAAC AAAZ + 1 = AABA AABA + 1 = AABB AAZZ + 1 = ABAA BGDZ + 1 = BGEA FZZZ + 1 = GAAA
  20. DwayneL

    Adding a number to a string

    sorry, its my fault for not being more specfic. I need AAAA to be AAAB.

Part and Inventory Search

Back
Top