學生無法網頁查詢某學期成績
今天註冊組反應,有些學生的學期成績無法網頁查詢,查驗 syear_index.asp 的程序是跑 SP_SYEAR 這支預存程序,測試不能顯示的學生帳號,顯示的錯誤訊息是資料過長,經查該學生的所有科目成績,發現該學生在 BSEME_SCORE 的 SCORE_P 欄位的資料有 *58.0 的記錄,以位元組來講是 5 位元組,可是在 SP_SYEAR 的 #T 的 SCORE1,SCORE2,SCORE3 的 CHAR(4) 都只有 4 位元組,當然會錯誤,反正是網頁查詢,為了方便就直接將 4 位元組改成 CHAR(5) 的 5 位元組就 OK .
只是有個疑問,查了一開始宜佳的資料表手冊,BSEME_SCORE 的 SCORE_P 的欄位是 CHAR(3) ,可是查現 HSDB 資料庫的 BSEME_SCORE 的 SCORE_P 是 CHAR(5) ,不知是什麼時候改的,而網頁查詢部份怎麼沒有順便更改
迴響
學生無法網頁查詢某學期成績 | 豬窩
Inspiring story there. What occurred after? Good luck!
學生無法網頁查詢某學期成績 | 豬窩
If some one desires expert view concerning blogging and site-building then i suggest
him/her to pay a quick visit this blog, Keep
up the fastidious work.
學生無法網頁查詢某學期成績 | 豬窩
If you would like to improve your familiarity only keep visiting this web
site and be updated with the latest gossip posted here.
學生無法網頁查詢某學期成績 | 豬窩
I really love your blog.. Very nice colors & theme.
Did you build this site yourself? Please reply back as I'm looking to create my
own website and want to find out where you got this from or what the
theme is named. Appreciate it!
學生無法網頁查詢某學期成績 | 豬窩
Hi, I think your blog might be having browser compatibility
issues. When I look at your website in Firefox, it looks fine but when opening
in Internet Explorer, it has some overlapping. I just
wanted to give you a quick heads up! Other then that, terrific
blog!