- Messages
- 75
- Reaction score
- 0
- Points
- 26
Hi.. question lng guys.. Newbie lng sa mysql.
may stored procedure na kasi akong ganito pag build ng statement
SET @sql=CONCAT("select ", _Columns,",RecordID,FileCount,FileName,FilePath,Comment,UpdateDate,FileType,CreateDate,fn_getAudioFilename2(JobID,",v_ProjectID,") as AudioFileName FROM ",_tableName , " ", _filter,v_Sort );
SET @sql=CONCAT("select JobID,MRNumber,LastName,FirstName,DOB,DOS,Dictator,WT,Status,Priority,Dictation_Date,Concat(MRNumber,',',JobID,',',FirstName,',',LastName) AS RecordTittle,RecordID,FileCount,FileName,
FilePath,Comment,UpdateDate,FileType,CreateDate,COALESCE(Nullif(B.AudioFileName,''),'NOAUDIO') as AudioFileName FROM " ,_tableName,
" A,(select PrimaryJobID,AudioFileName,ProjectID,mp3flag from tbl_audiofiles) B ", _filter ," and substring_index(A.jobID,'-',1) = B.PrimaryJobID and ProjectID=47 and mp3flag=1 " , v_Sort);
Tanong ko lng dito kung working po ba ung mga joing inside Sp ni mysql??
working naman but once na nag karoon na ko ng Joining ayaw na nya gumana .. Gamit ko po ngaun mysql workbench 5.2.44CE
may stored procedure na kasi akong ganito pag build ng statement
SET @sql=CONCAT("select ", _Columns,",RecordID,FileCount,FileName,FilePath,Comment,UpdateDate,FileType,CreateDate,fn_getAudioFilename2(JobID,",v_ProjectID,") as AudioFileName FROM ",_tableName , " ", _filter,v_Sort );
SET @sql=CONCAT("select JobID,MRNumber,LastName,FirstName,DOB,DOS,Dictator,WT,Status,Priority,Dictation_Date,Concat(MRNumber,',',JobID,',',FirstName,',',LastName) AS RecordTittle,RecordID,FileCount,FileName,
FilePath,Comment,UpdateDate,FileType,CreateDate,COALESCE(Nullif(B.AudioFileName,''),'NOAUDIO') as AudioFileName FROM " ,_tableName,
" A,(select PrimaryJobID,AudioFileName,ProjectID,mp3flag from tbl_audiofiles) B ", _filter ," and substring_index(A.jobID,'-',1) = B.PrimaryJobID and ProjectID=47 and mp3flag=1 " , v_Sort);
Tanong ko lng dito kung working po ba ung mga joing inside Sp ni mysql??
working naman but once na nag karoon na ko ng Joining ayaw na nya gumana .. Gamit ko po ngaun mysql workbench 5.2.44CE