 |
สอบถาม error :: Parse error: syntax error, unexpected T_LNUMBER in ... ทั้งๆที่ SQL ที่ทำก็ถูกแล้ว แนะนำด้วยนะคะ |
|
 |
|
|
 |
 |
|
อ.กระสัง บุรีรัมย์ นี่บ้านเกิดผมเลยน่ะเนีย
ลองเอา Code มาแปะให้ดูหน่อยครับ
|
 |
 |
 |
 |
Date :
2012-03-15 15:01:49 |
By :
webmaster |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (PHP)
<?php
class BbAjax extends Controller {
function BbAjax()
{
parent::Controller();
$this->load->helper('form');
$this->load->helper('file');
$this->load->library('session');
$this->load->helper('url');
}
function _remap($method)
{
$userId = $this->session->userdata('userId');
if(!$userId&&$method != 'login'){
$this->logout();
}else{
$this->$method();
}
}
function index()
{
//echo 'Hello World!';
$this->load->library('user_agent');
$this->load->helper('form');
if ($this->agent->is_browser()){
$agent = $this->agent->browser().' '.$this->agent->version();
}
elseif ($this->agent->is_robot()){
$agent = $this->agent->robot();
}
elseif ($this->agent->is_mobile()){
$agent = $this->agent->mobile();
}
else{
$agent = 'Unidentified User Agent';
}
//echo $agent;
//echo $this->agent->platform(); // Platform info (Windows, Linux, Mac, etc.)
$lang = array(
'thai'=> 'Thai',
'english'=> 'English'
);
$ret = array(
'success'=> 'true',
'heading'=> 'Login'
);
$result = array(
'ret' => json_encode($ret),
'dropdown' => form_dropdown('lang', $lang, 'thai', 'id = "lang"')
);
$this->load->view('bb/header', $result);
$this->load->view('bb/login', $result);
$this->load->view('bb/footer', $result);
}
function login(){
//echo 'XXXXX';
$user_id = $this->input->get_post('user', TRUE);
$password = $this->input->get_post('pass', TRUE);
$lang = $this->input->get_post('lang', TRUE);
$stmt = ' select u.user_code as userCode, u.user_name as userName, t.team_code as teamCode, t.team_name as teamName'.
' from sc_user u, sc_team t'.
' where u.user_code = ?'.
' and u.user_pwd = ?'.
' and u.user_active = ?'.
' and u.prof_code = "checker"'.
' and u.team_code = t.team_code';
$user_query = $this->db->query($stmt, array($user_id, $password, 'Y'));
$login_success = $user_query->row();
if($login_success == NULL){
$ret = array(
'success'=> 'false',
'heading'=> 'Login',
'message'=>'Invalid user name or password.'
);
echo json_encode($ret);
//$this->load->view('loginBlack', $result);
}else{
$ret = array(
'success'=> 'true',
'heading'=> 'Login',
'message'=> 'Login Success',
'userId'=> $user_id,
'team' => $login_success->teamName,
'userLang'=> 'en'
);
$userSession_data = array(
'userId' => $user_id,
'lang' => $lang,
'team' => $login_success->teamName,
'teamCode' => $login_success->teamCode,
'logged_in' => TRUE
);
$this->session->set_userdata($userSession_data);
echo json_encode($ret);
}
}
function menuPage(){
$userId = $this->session->userdata('userId');
$team = $this->session->userdata('team');
$result = array(
'success'=> 'true',
'heading'=> 'Login',
'message'=> 'Login Success',
'userId'=> $userId,
'team' => $team,
'userLang'=> 'en'
);
$this->load->view('bb/header', $result);
$this->load->view('bb/menu',$result);
$this->load->view('bb/footer', $result);
}
function viewCID(){
$pageLink = $this->input->get_post('pageLink', TRUE);
$userId = $this->session->userdata('userId');
$team = $this->session->userdata('team');
$result = array(
//'listCID' => $this->table->generate(),
'page' => $pageLink,
'userId' => $userId,
'team' => $team
);
$this->load->view('bb/header', $result);
$this->load->view('bb/viewCID', $result);
$this->load->view('bb/footer', $result);
}
function getListCID(){
$pageLink = $this->input->get_post('pageLink', TRUE);
$userId = $this->session->userdata('userId');
$teamCode = $this->session->userdata('teamCode');
if($pageLink == 'touchPoint'){
$stquery = ' select c1.case_id as case_id, c1.case_no as case_no, c1.case_cust_name as case_cust_name,
c3.cust_name as cust_name, c2.job_branch as job_branch, c2.cust_code as cust_code'.
' from cvs_case c1, cvs_job c2, ms_customer c3'.
' where c1.team_code = ?'.
' and c1.checker_code = ?'.
' and isnull(c1.case_touch_point,"N") <> ?'.
' and case_status = "3"'.
' and c1.case_no = c2.job_id'.
' and c2.job_branch = c3.cust_code';
$caseID_query = $this->db->query($stquery,array($teamCode,$userId,'Y'));
}else{
$stquery = ' select c1.case_id as case_id, c1.case_no as case_no, c1.case_cust_name as case_cust_name,
c3.cust_name as cust_name, c2.job_branch as job_branch, c2.cust_code as cust_code'.
' from cvs_case c1, cvs_job c2, ms_customer c3'.
' where c1.team_code = ?'.
' and c1.checker_code = ?'.
' and c1.case_status = "3"'.
' and c1.case_no = c2.job_id'.
' and c2.job_branch = c3.cust_code';
$caseID_query = $this->db->query($stquery,array($teamCode,$userId));
}
$this->load->library('table');
$tmpl = array ( 'table_open' => '<table width="100%" border="0" cellpadding="0" cellspacing="1" style="text-align:center;overflow-y:hidden;">' );
$this->table->set_template($tmpl);
$this->table->set_heading('');
$count = 0 ;
foreach ($caseID_query->result() as $row){
$names = iconv('TIS-620','UTF-8',$row->case_cust_name);
$custName = iconv('TIS-620','UTF-8',$row->cust_name);
if($count % 2 == 0){
++ $count ;
$this->table->add_row("<center><tr bgcolor=#FFFFFF><td width='50'>$count</td><td width='100'>".$custName."</td><td width='150'>".$names."</td><td width='150'>".
'<a onclick="javascript:overlayFunction.show();" href="index.php?c=bbAjax&m='.$pageLink.'&caseID='.$row->case_id.'&caseNo='.$row->case_no.'&jobBranch='.$row->job_branch.'&custCode='.$row->cust_code.'">'.$row->case_no.'</a>'."</td></tr></center>");
}else{
++ $count ;
$this->table->add_row("<center><tr bgcolor=#99CCFF><td width='50'>$count</td><td width='100'>".$custName."</td><td width='150'>".$names."</td><td width='150'>".
'<a onclick="javascript:overlayFunction.show();" href="index.php?c=bbAjax&m='.$pageLink.'&caseID='.$row->case_id.'&caseNo='.$row->case_no.'&jobBranch='.$row->job_branch.'&custCode='.$row->cust_code.'">'.$row->case_no.'</a>'."</td></tr></center>");
}
}
echo $this->table->generate();
}
function caseInq(){
$caseID = $this->input->get_post('caseID', TRUE);
$caseNo = $this->input->get_post('caseNo', TRUE);
$userId = $this->session->userdata('userId');
$team = $this->session->userdata('team');
$stquery = ' select *,'.
' convert(varchar, job_assign_dat, 103) as jobAssign,'.
' convert(varchar, job_cre_dat, 103) as jobCreDat,'.
' (select u.user_name from sc_user u where u.user_code = job_cre) as jobCre,'.
' convert(varchar, job_assigned_dat, 103) as jobAssigned,'.
' isnull( job_penalty,0) as jobCarPenalty,'.
' isnull(job_track,0)as Track,'.
' convert(varchar, job_pay_last_dat , 103) as lastDat,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_car_finance),1) as jobCarFinance,'.
'CONVERT(VARCHAR,CONVERT(MONEY,job_car_period_amt),1) as jobCarPeriodAmt,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_price_hold),1) as jobPriceHold,'.
' (select l.cust_name + c.cust_name'.
' FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch, '.
'(select case_addr_l1 '.
'from cvs_case c1,cvs_job c2 '.
'where case_cust_id = ? '.
'and c1.case_no = c2.job_id '.
'and c1.case_ref_l2 like 0 '.
'and c1.case_place_type like 'HD' ) as l1 '.
' from cvs_case c1,cvs_job c2'.
' where case_id = ?'.
'and c1.case_no = c2.job_id';
$stqueryNote = ' select substring(note_desc,1,20) as note_desc_link,note_desc,note_id'.
' from app_note'.
' where note_ref_id = ?'.
' and note_ref like "cvs_case_3_%"'.
' order by note_cre';
$query = $this->db->query($stquery, array($caseID)) ;
$queryNote = $this->db->query($stqueryNote, array($caseID)) ;
$result = array(
//'rows'=> $query->row()
'caseID' => $caseID,
'caseNo' => $caseNo,
'userId' => $userId,
'team' => $team,
'rows' => $query->row(),
'notes' => $queryNote->result()
);
$this->load->view('bb/header', $result);
$this->load->view('bb/caseInq', $result);
$this->load->view('bb/footer', $result);
}
?>
query อยู่บรรทัดที่ 197 - 220
คะ รบกวนพี่ด้วยนะคะ
|
 |
 |
 |
 |
Date :
2012-03-15 15:16:48 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (PHP)
'(select case_addr_l1 '.
'from cvs_case c1,cvs_job c2 '.
'where case_cust_id = ? '.
'and c1.case_no = c2.job_id '.
'and c1.case_ref_l2 like 0 '.
'and c1.case_place_type like 'HD' ) as l1 '. // ต้องเป็น "HD" หรือ \'HD\'
|
 |
 |
 |
 |
Date :
2012-03-15 15:52:37 |
By :
randOmizE |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ไม่ได้ทั้ง 2 แบบคะ error อยู่ดี
ช่วยแนะนำหน่อยนะคะ พยามยามแล้วไม่ได้จริงๆ
|
 |
 |
 |
 |
Date :
2012-03-15 15:55:28 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ลองเปลีย่น quote แรกเป็นฟันหนูดูสิครับ มันติดแค่ syntax , " ' พวกนี้นะครับลองไล่ดู
|
 |
 |
 |
 |
Date :
2012-03-16 08:22:19 |
By :
Dragons_first |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (PHP)
$stquery = " select *,".
" convert(varchar, job_assign_dat, 103) as jobAssign,".
" convert(varchar, job_cre_dat, 103) as jobCreDat,".
" (select u.user_name from sc_user u where u.user_code = job_cre) as jobCre,".
" convert(varchar, job_assigned_dat, 103) as jobAssigned,".
" isnull( job_penalty,0) as jobCarPenalty,".
" isnull(job_track,0)as Track,".
" convert(varchar, job_pay_last_dat , 103) as lastDat,".
" CONVERT(VARCHAR,CONVERT(MONEY,job_car_finance),1) as jobCarFinance,".
"CONVERT(VARCHAR,CONVERT(MONEY,job_car_period_amt),1) as jobCarPeriodAmt,".
" CONVERT(VARCHAR,CONVERT(MONEY,job_price_hold),1) as jobPriceHold,".
" (select l.cust_name + c.cust_name".
" FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch, ".
"(select case_addr_l1 ".
" from cvs_case c1,cvs_job c2 ".
" where case_cust_id = ? ".
" and c1.case_no = c2.job_id ".
" and c1.case_ref_l2 like 0 ".
" and c1.case_place_type like ".'O'." ) as l1 ".
" from cvs_case c1,cvs_job c2".
" where case_id = ?".
"and c1.case_no = c2.job_id";
ลองเปลี่ยนตามคำแนะนำแล้ว ก็ยังไม่ได้คะ
แต่ error เปลี่ยนเป็นแบบนี้คะ

ช่วยแนะนำหน่อยนะค่ะ ไล่ดูแล้ว ไม่เข้าใจจริงๆคะ
|
 |
 |
 |
 |
Date :
2012-03-16 08:35:14 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
จะแก้ยังไงดีคะ ลองแก้ทุกวิธีที่รู้แล้ว ก็ยังคงผิด :(
ใครพอจะแนะนำได้บ้างคะ...
|
 |
 |
 |
 |
Date :
2012-03-16 09:52:59 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Code (PHP)
function caseInq(){
$caseID = $this->input->get_post('caseID', TRUE);
$caseNo = $this->input->get_post('caseNo', TRUE);
$custId = $this->input->get_post('custId', TRUE);
$userId = $this->session->userdata('userId');
$team = $this->session->userdata('team');
$stquery = ' select *,'.
' convert(varchar, job_assign_dat, 103) as jobAssign,'.
' convert(varchar, job_cre_dat, 103) as jobCreDat,'.
' (select u.user_name from sc_user u where u.user_code = job_cre) as jobCre,'.
' convert(varchar, job_assigned_dat, 103) as jobAssigned,'.
' isnull( job_penalty,0) as jobCarPenalty,'.
' isnull(job_track,0)as Track,'.
' convert(varchar, job_pay_last_dat , 103) as lastDat,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_car_finance),1) as jobCarFinance,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_car_period_amt),1) as jobCarPeriodAmt,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_price_hold),1) as jobPriceHold,'.
' (select l.cust_name +" - "+ c.cust_name'.
' FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch,'.
'(select case_addr_l1 '.
' from cvs_case c1,cvs_job c2 '.
' where c1.case_cust_id like "1747123"'.
' and c1.case_no = c2.job_id '.
' and c1.case_ref_l2 like 0 '.
' and c1.case_place_type like "O" ) as l1, '.
' case c2.job_sign_contract '.
' when "1" then "หมายเก็บ" '.
' else "หมายยึด" '.
' end as jobSignContract '.
สามารถรันได้แล้ว แต่เราจะแทนค่าอย่างไรถึงจะถูกคะ
echo ค่าออกมาแล้วค่าส่งถูก แต่จะแทนค่าอย่างไรคะ แนะนำด้วยค่ะ ตัวแปร $custId ค่ะ
|
 |
 |
 |
 |
Date :
2012-03-16 14:04:54 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ยังไงดีอะ ใครพอทราบมั้งคับ อยากทราบเหมือนกัน
|
 |
 |
 |
 |
Date :
2012-03-16 15:28:27 |
By :
หนึ่ง |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
มาตอบช้าไปนิดครับ
' and c1.case_ref_12 like \'0\' '.
' and c1.case_place_type like \'HD\' ) as l1 '.
หรือ
" and c1.case_ref_12 like '0' ".
" and c1.case_place_type like 'HD' ) as l1 ".
แนะนำให้ใช้ double qoute ครับ " "
|
 |
 |
 |
 |
Date :
2012-03-17 00:32:09 |
By :
sakuraei |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ค่อยๆแก้ไปทีละเหราะน่ะครับ
20.' (select concat( l.cust_name , " - " , c.cust_name) '.
21.' FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch,'.
22.'(select case_addr_l1 '.
23.' from cvs_case c1,cvs_job c2 '.
24.' where c1.case_cust_id like "$custId" '.
แต่ที่แน่ๆ ถ้ามี clients มากกว่าสองเครื่องที่รันระบบนี้อยู่ละก็ อาจเกิด dead lock ครับ
หรือ ถ้ามีซอฟท์แวร์สำหรับวิเคราะห์ network traffic คงจะเห็นกราฟพุ่งปรี๊ดล่ะครับ
|
 |
 |
 |
 |
Date :
2012-03-17 00:52:35 |
By :
sakuraei |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
$stquery = ' select *,'.
' convert(varchar, job_assign_dat, 103) as jobAssign,'.
' convert(varchar, job_cre_dat, 103) as jobCreDat,'.
' (select u.user_name from sc_user u where u.user_code = job_cre) as jobCre,'.
' convert(varchar, job_assigned_dat, 103) as jobAssigned,'.
' isnull( job_penalty,0) as jobCarPenalty,'.
' isnull(job_track,0) as Track,'.
' convert(varchar, job_pay_last_dat , 103) as lastDat,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_car_finance),1) as jobCarFinance,'.
'CONVERT(VARCHAR,CONVERT(MONEY,job_car_period_amt),1) as jobCarPeriodAmt,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_price_hold),1) as jobPriceHold,'.
' (select l.cust_name + c.cust_name'.
' FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch, '.
'(select case_addr_l1 '.
'from cvs_case c1,cvs_job c2 '.
'where case_cust_id = \'?\' '.
'and c1.case_no = c2.job_id '.
'and c1.case_ref_l2 like \'0\' '.
'and c1.case_place_type like \'HD\' ) as l1 '.
' from cvs_case c1,cvs_job c2'.
' where case_id = \'?\''.
'and c1.case_no = c2.job_id';
|
 |
 |
 |
 |
Date :
2012-03-17 01:43:49 |
By :
ikikkok |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
พี่ sakuraei คะ พอลองแทนค่าแบบที่พี่ๆบอก มันไม่ error นะค่ะ แต่มันก็ไม่แสดงผลอะไรอะคะ
ตัวแปร $custId มีค่านะค่ะ คือ echo ออกมาได้มีค่าถูกต้องคะ แต่มาแทนค่าแล้วไม่ได้อะคะ
หรือต้องแทนค่าอย่างไรคะ ขอคำแนะนำด้วยนะค่ะ
Code (PHP)
function caseInq(){
$caseID = $this->input->get_post('caseID', TRUE);
$caseNo = $this->input->get_post('caseNo', TRUE);
$custId = $this->input->get_post('custId', TRUE);
$userId = $this->session->userdata('userId');
$team = $this->session->userdata('team');
$stquery = ' select *,'.
' convert(varchar, job_assign_dat, 103) as jobAssign,'.
' convert(varchar, job_cre_dat, 103) as jobCreDat,'.
' (select u.user_name from sc_user u where u.user_code = job_cre) as jobCre,'.
' convert(varchar, job_assigned_dat, 103) as jobAssigned,'.
' isnull( job_penalty,0) as jobCarPenalty,'.
' isnull(job_track,0)as Track,'.
' convert(varchar, job_pay_last_dat , 103) as lastDat,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_car_finance),1) as jobCarFinance,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_car_period_amt),1) as jobCarPeriodAmt,'.
' CONVERT(VARCHAR,CONVERT(MONEY,job_price_hold),1) as jobPriceHold,'.
' (select l.cust_name +" - "+ c.cust_name'.
' FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch,'.
'(select case_addr_l1 '.
' from cvs_case c1,cvs_job c2 '.
' where c1.case_cust_id = "$custId" '.
' and c1.case_no = c2.job_id '.
' and c1.case_ref_l2 like \'0\' '.
' and c1.case_place_type like \'O\') as l1, '.
' case c2.job_sign_contract '.
' when "1" then "หมายเก็บ" '.
' else "หมายยึด" '.
' end as jobSignContract '.
" from cvs_case c1,cvs_job c2".
" where case_id = ?".
"and c1.case_no = c2.job_id";
พี่ PlaKriM ค่ะ แทนค่าแบบของพี่ แล้วมัน error อะค่ะพี่
Incorrect syntax near '' อะคะพี่
ขอคำแนะนำจากพี่ๆด้วยนะคะ
|
 |
 |
 |
 |
Date :
2012-03-17 08:47:22 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
เกิด error แบบนี้คืออะไรหรอค่ะ ใครทราบบ้าง เกิดจากตัวแปร \'$custId\' แนะนำด้วยคะ
{"success":"false","heading":"A Database Error Occurred","message":"
Error Number: <\/p>
Incorrect syntax near '1747123\\'.<\/p>
0 FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch,(select case_addr_l1 \tfrom cvs_case c1,cvs_job c2 \twhere c1.case_cust_id like \\'1747123\\' \tand c1.case_no = c2.job_id \tand c1.case_ref_l2 like \\'0\\' \tand c1.case_place_type like \\'O\\') as l1, case c2.job_sign_contract when '1' then '\u0e2b\u0e21\u0e32\u0e22\u0e40\u0e01\u0e47\u0e1a' else '\u0e2b\u0e21\u0e32\u0e22\u0e22\u0e36\u0e14' end as jobSignContract from cvs_case c1,cvs_job c2 where case_id = 'KN1203003261'and c1.case_no = c2.job_id<\/p>"}
Code (PHP)
function caseInq(){
$caseID = $this->input->get_post('caseID', TRUE);
$caseNo = $this->input->get_post('caseNo', TRUE);
$custId = $this->input->get_post('custId', TRUE);
$userId = $this->session->userdata('userId');
$team = $this->session->userdata('team');
$stquery = " select *,".
" convert(varchar, job_assign_dat, 103) as jobAssign,".
" convert(varchar, job_cre_dat, 103) as jobCreDat,".
" (select u.user_name from sc_user u where u.user_code = job_cre) as jobCre,".
" convert(varchar, job_assigned_dat, 103) as jobAssigned,".
" isnull( job_penalty,0) as jobCarPenalty,".
" isnull(job_track,0)as Track,".
" convert(varchar, job_pay_last_dat , 103) as lastDat,".
" CONVERT(VARCHAR,CONVERT(MONEY,job_car_finance),1) as jobCarFinance,".
" CONVERT(VARCHAR,CONVERT(MONEY,job_car_period_amt),1) as jobCarPeriodAmt,".
" CONVERT(VARCHAR,CONVERT(MONEY,job_price_hold),1) as jobPriceHold,".
" (select l.cust_name +" - "+ c.cust_name".
" FROM ms_customer c left join ms_customer l on c.cust_parent = l.cust_code where c.cust_code = job_branch) as jobBranch,".
"(select case_addr_l1 ".
" from cvs_case c1,cvs_job c2 ".
" where c1.case_cust_id like \'$custId\' ".
" and c1.case_no = c2.job_id ".
" and c1.case_ref_l2 like \'0\' ".
" and c1.case_place_type like \'O\') as l1, ".
" case c2.job_sign_contract ".
" when '1' then 'หมายเก็บ' ".
" else 'หมายยึด' ".
" end as jobSignContract ".
" from cvs_case c1,cvs_job c2".
" where case_id = ?".
"and c1.case_no = c2.job_id";
|
 |
 |
 |
 |
Date :
2012-03-17 10:48:29 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
พี่ๆค่ะ นู่ทำได้แล้วคะ ขอบคุณทุกคำแนะนำ
ขอบคุณจิงๆค่ะ ^^
i love thaicreate :)
|
 |
 |
 |
 |
Date :
2012-03-17 11:09:58 |
By :
Baitong_ch |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|