Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marconi8
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-13 : 04:23:39
|
| i dont think that my thread is not actual in this forum, because in this forum i can also meet threads where talking is about mssql and asp, if i am wrong please delete this my thread....PHP people if any of us is struggling with php string = dynamic sql, then it is my little storyif you want to call mssql stored procedure from php with params which are interpreted by mssql server like nvarchar (dynamic sql) then use double qutoas like this------------------------------------@W_STAT - it is generated WHERE statement@O_STAT - it is generated ORDER statement------------------------------------$SQL=" DECLARE @T_C INT EXECUTE @T_C=P_SHOW_LIMITED_OBIAVLENIA @CUR_POS=".$obiavlenia_cur_pos.", @SAG=".$HTTP_SESSION_VARS['obj_opt']['OBJ_SAG'].", @W_STAT="."\"".$generated."\"".", @O_STAT="."\"".$search_order.$o_STATEMENT."\" SELECT @T_C AS T_C "; $rs=$mssql_connection->EXECUTE($SQL);i dont think that this my post is something very very new for you ( php people ), i only this write if any will have this little problemfor example with this little problem i was struggled nearly all day, and i feel little shame....php people , don't lose your work day one f....ed quotas missing reason ! |
|
|
|
|
|
using mssql from PHP