Search results for query: *

Hi All, How can i write a single sql statement where i check if record exists then just update else insert. I have seen some where that it is possible but I am unable to search the solution on web or this forum. Thanks in advance for any help. Manoj

Hello All, I have an access database and had made some forms in it.Accidentally one of the forms got deleted but the vba code or class object still exists for that form. This is causing some errors in loading of the main form. As the deleted form was one of the forms being called thru a vent...

Hello All, I want to load a tab delimited data file using sql loader. But in that file there are many cols(fields) which i don't want to load, how can i specify that in the ctrl file? Also within some fields they have '|' as the separator and I want to load the first set of characters. say...

Thanks marsd. I knew about the -v feature and was using it till i hit the limitation of command line args length. So that's when i thought mebbe i can use an array. But now that you confirmed it is not possible I had to use couple of args one time and that I moved some code to run another awk...

Hi All, I have let's say an array fil_array = elem1 elem2 .. so what i want is invoke a awk script passing this array from shell script to the awk code. How can i do and then later access in the awk code. Thanks in advance Manoj

Hello All, I have a data file and I want to reposition some of the data in a line at different position on the same line. e.g. 552404: MF 23456 XXXXX to 552404: MF 23456 XXXXX How can i do that. Thanks in advance Manoj

Hi Jamisar, It still quite is not working, I tried your logic and used the following lines of code { if (mark >1) print ; } /Priority:/ {print $2} #/satisfied?/ , /^$/ {print} /^Business/{ mark = 1; next; } /^Objectives/{ if(!mark) next; mark = 2; next; } /^How...

Hello Friends, I have a file whose contents I have to read and is iven below: ============================== Request Number: 000248 Priority: Medium Request Area: Accounting Brief Description: Add the account number/s to the automatic product verification emails. Please enter a short...

Hi Guys, Thank you very much for your suggestions. My first thought was to use a jsp page to show the applet and as mrcincloes suggested get the login id as parameter inside the applet,but I was hesitant to change the html file to a jsp file type. But then I was also thinking how can i use...

Hi, Thank you very much for the help you have given me. I was looking to use Unix Scripting, but Perl solution will work too. Well the main thing is I got the idea how to do it using any kind of script. It was interesting to see how people would approach to solve a problem. I have seen in my...

Hi Guys, I have a servlet which captures the login id and shows a page with several links. One of the links is to a swing based applet app, which when starts shows a form where we have to type the login id. Since we are capturing the login id already I wanted to stuff the login id and then...

Hi Folks, We have a swing based applet application. In this applet we have several forms with buttons to move to next screen. Now when we are on the beginning form and click on Next button using mouse quickly several times it moves to that many screens ahead even though there are checks that...

Hello All, The file used to previously look like this: 203500 abcd abcd 203510 x x x x 203525 zzzz 203510 x x x x 203525 zzzz After some programming changes from some other system,it became like this: 203500 abcd abcd 203510 x x x x 203510 yyyyyyy 203525 zzzz 203500 abcd abcd 203510 x...

Hi guys, Thank you very much for your replies. Somebody asked me to clarify how the out put should look like original: 203510 x x x x 203510 yyyyyyy 203525 zzzz 203510 x x x x 203510 yyyyyyy 203525 zzzz Output after one of you people's logic: 203510 x x x x 203525 zzzz 203510 x x x x...

Dickie, The order of lines is important. I just want the duplicate lines to disappear without changing the order of lines. Thanks very much for your help Manoj

How can i remove duplicate lines in a file, ther lines look like this 203510 x x x x 203510 yyyyyyy 203525 zzzz 203510 x x x x 203510 yyyyyyy 203525 zzzz I don't want the second 203510 line. Thanks Manoj

Hi All, We hava a java swing app and we were able to cut and paste from external applications like word,notepad etc in JRE1.2 and now in JRE1.4 but unfortunately we have JRE 1.3 installed, where this functionality is turned off. We want to find a solution where we don't have to depend on JRE...