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 TouchToneTommy 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: mstelmac
  • Content: Threads
  • Order by date
  1. mstelmac

    Incrementing problem (I'm missing something here)

    hello everyone, I have the following code that works flawlessly except doe not count higher that 10. When it reaches 10 it just keeps repeating 10. I am using the code to assign unique numbers and store them in a database field. $sw_version = "3.1.1"; $asset_name = "ShipName"...
  2. mstelmac

    Populate variable with piece of string?

    Hello everyone. Can anyone tell me the best way to populate a variable with a piece of a string. I need to capture all of the text after the last under score. my $string = "3.0.0_SWNAME_48" I'm really just trying to populate a variable with the number 48. Problem is 48 could really be 480...
  3. mstelmac

    Basic variable question - Thanks in advance.

    Hello everyone. I am having one heck of a time doing something very simple in perl. I am trying to set a variable (named $test) to this value: "email.address1\@yahoo.com", "email.address2\@yahoo.com" Then I am using the variable as part of this SMTP call: $smtp->to($test); Here is my code...
  4. mstelmac

    Sorting a string

    CR developer version 10 Clearquest version 2003.06.15 MS SQL Server 2000 Hello everyone, I have a report format that prints a list of change request records. Unfortunately all data is pushed into CR as strings. Can anyone help me sort the CR field? My current output looks like this: CR115...
  5. mstelmac

    Records repeat 1 time in details section

    This is not going to be easy to explain but here goes. For some reason if the records in my details section runs over 1 page into say 2 or 3 pages the records repeat 1 time. This is weird. I already have the ID of the record in the details section set to suppress if duplicated. The only...
  6. mstelmac

    Substitution question

    Hello everyone. I have been reading about string substitution but do not understand how to find my pattern. My pattern only exists in quotes like this: $variable = "The Dog Can Run"<tab>"The Dog Can Swim"<carriage return> I need to remove any new line, tab, carriage return, basically any...
  7. mstelmac

    Simple sort question

    Hello everyone, does anyone know the easiest way to sort (ascending) a variable that contains the values: c001 c002 c004 c003 The values are delimited by whatever is needed, currently it is by space. Im learning that in VB script I can not just push them into an Array and use a "sort" command...
  8. mstelmac

    Perl/ClearQuest Multiple record issue with 2 tables

    First off, thanks for looking, and if you feel this should be in another area please let me know, thanks. I have two tables(DB's) Shown below. These are within ClearQuest V. 2003.06....... I would like to place a perl hook into the field Labeled Table2_Text on Table2. What I want to happen is...
  9. mstelmac

    JList question

    Hello everyone. Can anyone give me a hint on how to underline the values in a Jlist? I was thinking of writing a renderer (if it's possible) but wanted to see if anyone had a better idea. v/r, Matt
  10. mstelmac

    Wrap cell contents in quotes

    Hello everyone. I hope everyone is enjoying the holiday season and not stuck in work like myself. I have an excel sheet in which I want to wrap the contents of every cell in quotes. Example: 12345 Defect Severe Matt Johnson Would look like this: "12345" "Defect" "Severe" "Matt Johnson"...
  11. mstelmac

    CR10 field data not displaying

    Hello everyone. I just upgraded to CR10 from CR8.5 and two of my fields are not displaying on any of my formats. Both fields are just short strings.....nothing fancy. I did a verify database but that did not help. I also removed them and re-added them. Does anyone have a suggestion...
  12. mstelmac

    unknown query engine error

    Hello everyone, I am using CR10 and when I go to "verify database" I get the error: unknown query engine error I have no idea what is going on here and non of the crystal patches seem to help. I am using crystal reports from with Rational Clearquest. Does anyone have any idea? thanks, Matt
  13. mstelmac

    CR10 Verify Database question

    Hello everyone. I have just installed CR version 10 and noticed that when I do a "verify database" it requires that I provide OLE DB connection information. When I was running version 8 it never asked me for that. Is there anyway to turn this off, or is it just a one time thing?
  14. mstelmac

    Simple substitution question

    Hell everyone. I am trying to parse a text file and remove all newline characters(\n) that are located within quotes. My data looks like this: "id12345"<tab>"Fix code in sections:\n 1.2.7\n 1.2.8" \n "id12346"<tab>"Fix code in sections:\n 1.2..5.4\n 1.2.3.2" \n "id12347"<tab>"Fix code in...
  15. mstelmac

    DOS command in PERL script

    Hello everyone, I am trying to kick off a DOS command from within my PERL script. I'm sure this is easy for you guys but it is killing me. I'm extremely new to PERL and more experienced with UNIX than dos. Can anyone suggest a solution, I think back slashes or ticks are in the worng place...
  16. mstelmac

    Perl script with a HTML MIME attachment

    Hello everyone. I'm a very novice perl programmer that is trying to generate an automatic email that attaches a file and sends it to a constant recipient. Because of the version of perl that I am forced to use (CQPERL) I cannot make use of the wonderful perl modules like MIME::Lite. I am...
  17. mstelmac

    Surpress Blank Lines ??

    CR8.5 WINDOWS XP Hey guys is there anyway to surpress blank lines when printing out a record with a field in it that contains a long description? Some of the records in the database have fields with data that span 3 lines and some that span 10. My goal was to create a report that saved as...
  18. mstelmac

    Convert integer (1) to a character (X) .... please help

    Hello everyone. My database stores check boxes as either a 1 (checked) or a 0 (unchecked, default). I want my report to replace the 1 with an X. If the value is a 0 then I do not want an X to appear. I was thinking it might be possible by using the select expert???? Can anyone lend a hand...
  19. mstelmac

    Service pack for CR8?

    Hi guys I am running CR 8.0.1.8 and I wanted to know if there is any service packs available beyond what I have. I went to the CR Buisness Objects site but was unable to get support. I guess they only keep patches and service packs back to 8.5. thanks, mstelmac
  20. mstelmac

    Field data output in wrong place...Please help

    Hi guys I really need your help. I have a report template that is placing the field data in the wrong place. Some of the fields are not displaying at all and some are puting data in the wrong field. For instance the last name is where the first name should be. All of my fields are placed in...

Part and Inventory Search

Back
Top