ผมใช้ and ORDER BY CONVERT (a.REG_FNAME USING tis620) ASC ไม่ได้อะครับ มัน error ครับ
Warning: oci_execute() [function.oci-execute]: ORA-00936: missing expression in C:\AppServ\www\rtcnstpay\user\checkdoccument.php on line 307
Warning: oci_fetch_array() [function.oci-fetch-array]: ORA-24374: define not done before fetch or execute and fetch in C:\AppServ\www\rtcnstpay\user\checkdoccument.php on line 309
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563'and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY CONVERT (a.REG_FNAME USING tis620) ASC
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563'and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY CONVERT (a.REG_FNAME USING tis620) ASC
Cause: A required part of a clause or expression has beenomitted.
For example, a SELECT statement may have beenentered without a list of columns
or expressions or withan incomplete expression. This message is also issued incases
where a reserved word is misused, as in SELECTTABLE.
Action: Check the statement syntax and specify the missingcomponent.
The ORA-00936 happens most frequently:
1 - When you forget list of thecolumn names in your SELECT statement.
2. When you omit the FROM clause of theSQL statement.
ดูว่า "ปี" ติดกับ and หรือไม่
ORA-24374: define not done before fetch or execute and fetch
Cause: The application did not define output variables for data
being fetched before issuing a fetch call or invoking a fetch
by specifying a non-zero row count in an execute call.
Action: Issue OCI define calls for the columns to be fetched.
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563' and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY CONVERT (a.REG_FNAME USING tis620) ASC
Warning: oci_execute() [function.oci-execute]: ORA-00907: missing right parenthesis in C:\AppServ\www\rtcnstpay\user\checkdoccument.php on line 323
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563' and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY a.REG_FNAME ASC
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563' and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY a.REG_FNAME ASC
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563' and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY CONVERT(a.REG_FNAME, 'TH8TISASCII') ASC
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563'and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY CONVERT(a.REG_FNAME, 'TH8TISASCII') ASC
select * FROM MIA_STUDENT_REGISTER a,MIA_SCHOOL b,MIA_STUDENT_TEST c WHERE a.REG_SCHOOL_ID=b.SCHOOL_ID and a.REG_PID=c.REG_PID and a.AT_YEAR='2563' and a.REG_SCHOOL_ID like '%021104005%' and a.REG_SEX like '%M%' ORDER BY NLSSORT(a.REG_FNAME, 'NLS_SORT = THAI_M')
Load balance : Server 04
