User Profile

Collapse

Profile Sidebar

Collapse
nischalinn
nischalinn
Last Activity: Jul 29 '20, 07:43 AM
Joined: Mar 11 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nischalinn
    started a topic C# function to execute the stored procedure having multiple outputs
    in C Sharp

    C# function to execute the stored procedure having multiple outputs

    how can I write a function which can execute stored procedure with any number of inputs and multiple output parameters.

    I want to write a sql helper class for this.
    my stored procedure,
    Code:
    CREATE PROCEDURE GetOrderDetails
@OrderID int,
@OrderLbl varchar(3),
@OrderName nvarchar(40) OUTPUT,
@UnitPrice money OUTPUT,
AS
	SELECT @OrderName = OrderName, 
	@UnitPrice = UnitPrice,
    ...
    See more | Go to post
    • nischalinn
      started a topic do looping from N to 1
      in Python

      do looping from N to 1

      Suppose I've some user-defined lists:
      Say,

      [1,2,3,5,6,8]
      [1,2,3,4,5,6,7,8 ,9,10]

      Suppose I've to split the list using user defined number, say N =3 for the first list.
      Then the output will be:

      for N = 3 [1,2,3]
      for N-1 = 2 [5,6]
      for N -2 = 1 [8]

      say N =4 for the second list.
      Then the output will be:

      for N = 4 [1,2,3,4]
      for...
      See more | Go to post
      • nischalinn
        started a topic replace space between strings: notepad ++
        in APIs

        replace space between strings: notepad ++

        Suppose I've text file where:

        aaa bbb
        sss iii uuu
        lds iie riowq urew

        How can I replace empty space between the strings using notepad ++ such the output would be like this:
        aaabbb
        sssiiiuuu
        ldsiieriowqurew

        Thanks!
        See more | Go to post
        • nischalinn
          replied to Update multiple rows of a column by same value in Oracle
          in Oracle
          Hello sumanta5877,
          can you please provide which field value you want to update?
          Please provide some details about your requirement and table structure.

          Thanks!
          See more | Go to post

            Leave a comment:

          • nischalinn
            replied to ImportError: cannot import the class
            in Python
            @dwblas:

            Thanks for your help. I've read the post. I've created a new class called "main" and have instantiate all the classes there.

            Thank You!!!
            See more | Go to post

              Leave a comment:

            • nischalinn
              started a topic ImportError: cannot import the class
              in Python

              ImportError: cannot import the class

              I can not figure out what mistake I've done with my code. The error indicates that the class can not be imported. But I am not getting into it.

              Please help me with this.

              My code:
              Code:
              ######## userClass.py ##################
from classTriangle import classTriangle

class userClass():
    
    def __init__(self):
        self.getList = []
        self.maxList = 3
              ...
              See more | Go to post
              • nischalinn
                started a topic modules to read data from rtf files
                in Python

                modules to read data from rtf files

                Currently I am working in the Linux environment (Linux server) without internet access and also limited root privileges.

                I've to read data from different "*.rtf" documents and write the whole data in a single text file.

                Are there any modules to read text from multiple rtf files and then write that data to single text(.txt) file?

                Thank You!!!
                See more | Go to post
                • nischalinn
                  started a topic relation b/n floating point number representation in bit words
                  in Career

                  relation b/n floating point number representation in bit words

                  I have faced this question in many written interview question, but cant find any accurate solution.
                  My question is:

                  Accuracy of the floating point numbers representable in two 16-bit words of a computer is approximately ...........?

                  How can I solve this problem?
                  See more | Go to post
                  • nischalinn
                    started a topic calling VBA script from Python
                    in Python

                    calling VBA script from Python

                    I need to run a VBA script from python.
                    My VBA script just count the number of columns and number of rows in an excel sheet.
                    I need to execute that VBA script from inside python. Is it possible?
                    How can I do it?
                    Thank You!
                    See more | Go to post
                    • nischalinn
                      replied to converting vertically grouped data to horzontal form in a file
                      in Linux
                      Thanks Luuk for the reply.

                      I'll try this and if there will be any confusion I'll knock again.

                      Thank You!!!
                      See more | Go to post

                        Leave a comment:

                      • nischalinn
                        started a topic converting vertically grouped data to horzontal form in a file
                        in Linux

                        converting vertically grouped data to horzontal form in a file

                        I've a set of data which is grouped vertically and I want that data set in horizontal form. The data is in a file. I think I've to use shell script to do the task.
                        But I do not have clear idea how to do this task.
                        ###### DATA IN FILE ######
                        Name: client1
                        Id: client101
                        Address: addrs1
                        Shopping Category: regular
                        Items in Cart: 2

                        ###### REQUIRED RESULT FORMAT ######
                        Name Id Address...
                        See more | Go to post
                        • nischalinn
                          started a topic develop automated folder structure
                          in Python

                          develop automated folder structure

                          I want to desing a automated folder structure script, when given the name of the root folder, the children folders along with the root folder are created automatically.

                          The folder structure should be like this:

                          ParentFolder
                          --> 1. Child1 ==> GrandChild1, GrandChild2, GrandChild3
                          --> 2. Child2
                          --> 3. Child3

                          Only the name of the ParentFolder will be given by the user...
                          See more | Go to post
                          • nischalinn
                            replied to search and replace with variable value
                            in Python
                            Thanks for the reply guys!!!
                            See more | Go to post

                              Leave a comment:

                            • nischalinn
                              replied to search and replace in a text file and save the changes
                              in Python
                              @BVDET Thank you for the prompt reply.
                              Please can you tell me why I've to do so? In the tutorials, it is said that when you open a file in "r+" mode, the file is accessed in read as well as write mode.
                              But in my case, why it is not happening?
                              Please can you clarify me.

                              Thank You!
                              See more | Go to post

                                Leave a comment:

                              • nischalinn
                                started a topic search and replace in a text file and save the changes
                                in Python

                                search and replace in a text file and save the changes

                                I am trying to search for a pattern in a text file and replace with another string.
                                I've opened the file in "r+" mode and used re.sub for replacement text.

                                The python output window is showing the desired result, but when I open the text file there is no change. The string that is to be replaced is not replaced in the text file.

                                Why is it so?
                                Code:
                                # !/usr/bin/python

import os,re
                                ...
                                See more | Go to post
                                • nischalinn
                                  started a topic search and replace with variable value
                                  in Python

                                  search and replace with variable value

                                  I've to search for a pattern and replace with input variable.
                                  Suppose the strings are:

                                  tempSearch : = '111-452-05'
                                  tempSearch:= '111-452-10'
                                  tempSearch:='11 1-459-15'
                                  tempSearch: ='111-452-20'
                                  tempSearch:='11 1-452-25'

                                  search for the whole pattern starting from the "temp" to the end "'". I've to replace the value that is occuring after the first appearance of &q...
                                  See more | Go to post
                                  No activity results to display
                                  Show More
                                  Working...