PHP code to call nested procedure of MSSQL

Status: Closed
Prêmio: ₹5000
Inscrições Recebidas: 8

Síntese do concurso

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 .

Habilidades Recomendadas

Lance um Concurso Como Este

Painel de Comentários

xfxstudios
- 6 anos atrás
#8
- 6 anos atrás
xfxstudios
- 6 anos atrás
#6 . thanks
- 6 anos atrás
xfxstudios
- 6 anos atrás
See entry #4 , I believe is what you need. regards
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  Its not calling procedure . We want php code calls nested procedure and till get the result .
  - 6 anos atrás
eyalfinkelshtein
- 6 anos atrás
Hi, what should #param3 do int the seconed procedure?
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  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 .
  - 6 anos atrás
xfxstudios
- 6 anos atrás
Please send me the related files to solve your problem, we are experts in php, mysql MSSQL among others. regards
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  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 .
  - 6 anos atrás
2. xfxstudios
  - 6 anos atrás
  Send me the current code information you have and the SQL files to proceed with the job.
  - 6 anos atrás
nicolastsue
- 6 anos atrás
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
- 6 anos atrás
monmohon
- 6 anos atrás
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
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  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
  - 6 anos atrás
2. monmohon
  - 6 anos atrás
  ok..... i'll update tomorrow
  - 6 anos atrás