學生無法網頁查詢某學期成績
今天註冊組反應,有些學生的學期成績無法網頁查詢,查驗 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) ,不知是什麼時候改的,而網頁查詢部份怎麼沒有順便更改
迴響
我只是愛你的有趣博客
我想說，你真的幫助我理解的主題 ????????????? | ??
學生無法網頁查詢某學期成績 | 豬窩
Have you ever thought about creating an ebook or
guest authoring on other sites? I have a blog based
on the same information you discuss and would really like to have you share some stories/information. I
know my audience would appreciate your work. If you are even remotely interested, feel free to send me an e mail.
學生無法網頁查詢某學期成績 | 豬窩
Excellent beat ! I wish to apprentice at the same time as you
amend your website, how can i subscribe for a weblog web site?
The account helped me a acceptable deal. I had been tiny bit familiar of this your broadcast provided shiny transparent idea
學生無法網頁查詢某學期成績 | 豬窩
I have been exploring for a bit for any high-quality articles
or weblog posts on this sort of space . Exploring in Yahoo I eventually stumbled upon this web site.
Studying this information So i am satisfied to express that I've an incredibly just right uncanny feeling
I came upon just what I needed. I such a lot unquestionably will make sure
to don?t overlook this web site and provides it a look regularly.
學生無法網頁查詢某學期成績 | 豬窩
It's fantastic that you are getting thoughts from this
paragraph as well as from our argument made here.