จากการเช็ครายชื่อผู้ป่วยพบว่ามี บางเคส ไม่มี An , hn หรือชื่อคนใข้เลย แต่มันไม่ขึ้นเป็นจำนวนให้ ไม่ทราบว่าตัวนี้เป็ฯปัญหาด้วยไหม ตามรูปต้องลบตรงไหนครับ
แล้วบางครั้ง เวลาเรียนข้อมูลคนไข้ในบางทีก็ขึ้น Error แบบนี้
EurekaLog 5.1.11
Application:
-------------------------------------------------------
1.1 Start Date : Wed, 20 Dec 2006 15:32:29 +0700
1.2 Name/Description: HOSMy.exe
1.3 Version Number : 2.49.12.17
1.4 Parameters :
1.5 Compilation Date: Sun, 17 Dec 2006 14:45:58 +0700
Exception:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2.1 Date : Wed, 20 Dec 2006 15:56:53 +0700
2.2 Address: 00569DA0
2.3 Module : HOSMy.exe
2.4 Type : EOleException
2.5 Message: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ipt.pttype = '23' ( ipt.an in ('490022002','490022011','490022012','49' at line 1.
Active Controls:
----------------------------------
3.1 Form Class : VNCMDI_Window
3.2 Form Text : LibVNCServer
3.3 Control Class: TdxDBGrid
3.4 Control Text :
Computer:
---------------------------------------------------------------------
4.1 Name : HOSINFO
4.2 User : Administrator
4.3 Total Memory : 247 Mb
4.4 Free Memory : 65 Mb
4.5 Total Disk : 18.64 Gb
4.6 Free Disk : 4.24 Gb
4.7 System Up Time: 54 minutes, 23 seconds
4.8 Processor : Intel(R) Celeron(R) M processor 1.50GHz
4.9 Display Mode : 1280 x 800, 16 bit
Operating System:
------------------------------------
5.1 Type : Microsoft Windows XP
5.2 Build # : 2600
5.3 Update : Service Pack 2
5.4 Language: Thai
Network:
---------------------------------------------------------------------
6.1 IP Address: 000.000.000.000 - 192.168.001.234 - 000.000.000.000
6.2 Submask : 000.000.000.000 - 255.255.255.000 - 000.000.000.000
6.3 Gateway : 000.000.000.000 - 192.168.001.001 - 000.000.000.000
6.4 DNS 1 : 000.000.000.000 - 192.168.001.001 - 000.000.000.000
6.5 DNS 2 : 000.000.000.000 - 000.000.000.000 - 000.000.000.000
6.6 DHCP : ON - OFF - ON
Other Information:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7.1 : Hospital Code = 10694 [โรงพยาบาล ชัยนาท]
Database Type = MySQL
Database Protocol = mysql-4.1
Last 3 SQL Statement
.
No 1 = select ipt.*,concat(spclty.name,' - ',w.name) as sname,iptadm.bedno,iptadm.bedtype,roomno.name as roomname,iptadm.roomno,iptdiag.icd10,concat(iptdiag.icd10,' - ',i1.name) as icdname,concat(patient.pname,patient.fname,' ',patient.lname) as pname,aa.income as income,ptt.pcode as rtcode,ptt.name as rtname from ipt left outer join spclty on spclty.spclty=ipt.spclty left outer join iptadm on iptadm.an=ipt.an left outer join patient on patient.hn=ipt.hn left outer join roomno on roomno.roomno=iptadm.roomno left outer join iptdiag on iptdiag.an=ipt.an and iptdiag.diagtype='1' left outer join icd101 i1 on i1.code=substring(iptdiag.icd10,1,3) left outer join an_stat aa on aa.an=ipt.an left outer join ward w on w.ward = ipt.ward left outer join pttype ptt on ptt.pttype=ipt.pttype where and ipt.pttype = '23' ( ipt.an in ('490022002','490022011','490022012','490022015','490022026','490022031','490022032') or ipt.an in ('490021855','490021862','490021864','490021886','490021891','490021914','490021919','490021927','490021928','490021934','490021935','490021946','490021953','490021955','490021965','490021970','490021973','490021993')) and ( ipt.dchdate > '2006-12-20' or ipt.dchstts is null ) order by ipt.regdate,ipt.regtime
.
No 2 = select count(ward) as cc from ward where ward='10'
.
No 3 = select an from ipt where ipt.ward = '10' and regdate<'2006-12-20'
.
Server variable
หัวข้อ: fedora code 6 ทำพิษหรือว่า คอนฟิก Server ไม่ดี (อ่าน 10993 ครั้ง)