PHP code to call nested procedure of MSSQL

  • État: Closed
  • Prix: ₹5000
  • Propositions reçues: 8

Résumé de concours

We need solution for getting result from nested procedure calls using PHP . Lets say you have "procedure 1" which has @Param1 , @Param2 as input and it returns some rows . Now you have "procedure 2" , which accepts @Param1, @Param2 & @Param3 . Based on some logic this procedure 2 calls procedure 1 with @Param1 & @Param2 and returns its result . Now issue e face is that php code executes procedure 2 successfully but with empty result set . You need to solve this .

Compétences recommandées

Meilleures propositions de ce concours

Afficher plus de propositions

Tableau de clarification publique

  • xfxstudios
    xfxstudios
    • il y a 1 an

    #8

    • il y a 1 an
  • xfxstudios
    xfxstudios
    • il y a 1 an

    #6 . thanks

    • il y a 1 an
  • xfxstudios
    xfxstudios
    • il y a 1 an

    See entry #4 , I believe is what you need. regards

    • il y a 1 an
    1. collonmade
      Titulaire du concours
      • il y a 1 an

      Its not calling procedure . We want php code calls nested procedure and till get the result .

      • il y a 1 an
  • eyalfinkelshtein
    eyalfinkelshtein
    • il y a 1 an

    Hi, what should #param3 do int the seconed procedure?

    • il y a 1 an
    1. collonmade
      Titulaire du concours
      • il y a 1 an

      Its just for example . We only need if u call parocedure inside another procedure and return its result than PHP code should sense result . Currently we are getting blank result so .

      • il y a 1 an
  • xfxstudios
    xfxstudios
    • il y a 1 an

    Please send me the related files to solve your problem, we are experts in php, mysql MSSQL among others. regards

    • il y a 1 an
    1. collonmade
      Titulaire du concours
      • il y a 1 an

      As we told u can create 2 procedures . 1 procedure returns some rows . another procedure calls this procedure and returns its result . so if u call second procedure using php code it should return results from first procedure . if this works than only its solved .

      • il y a 1 an
    2. xfxstudios
      xfxstudios
      • il y a 1 an

      Send me the current code information you have and the SQL files to proceed with the job.

      • il y a 1 an
  • nicolastsue
    nicolastsue
    • il y a 1 an

    Hi, i wrote it, as you requested, please see Entry #3 . i made an example, that add #param3 to the latest function result, as example. test the code, and let me know, how it goes with you

    • il y a 1 an
  • monmohon
    monmohon
    • il y a 1 an

    hi! can you please upload your script mysql and php in dropbox. so, that i can work out. hope i'll provide you best solution.
    Seriously, i'm very expert in MySQL Procedure
    Thank you

    • il y a 1 an
    1. collonmade
      Titulaire du concours
      • il y a 1 an

      ok sure . But what I say u can create any procedure . Than createsecond procedure and call first one and return its result .If it works than its done

      • il y a 1 an
    2. monmohon
      monmohon
      • il y a 1 an

      ok..... i'll update tomorrow

      • il y a 1 an

Montrer plus de commentaires

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !