ERROR: query failed: select x.id as id, x.category, x.subcategory, x.item from form_CAMOS as x join forms as y on (x.id = y.form_id) where y.encounter = and x.pid = 4 and x.activity = 1
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 x.pid = 4 and x.activity = 1’ at line 1
OK, I found part of the problem, you have to have an active encounter before attempting to print the 4-panel RX, that prevents the MySQL query error, but it gets even stranger from there. trying to print a 4-panel RX after selecting an active encounter results in a page that looks like this:
–
Select CAMOS Entries for printing
exam:by dx:health checkup
Update User Information
First Name:
Last Name: Administrator
Title:
Street Address:
City:
State:
Zip:
Phone:
Fax:
DEA:
–
Not sure where CAMOS is pulling this from, & no PDF to print is generated either.
I’ll keep looking at it but any fresh input/ideas would be much appreciated! TIA
You are correct, you have to be in an encounter to avoid that problem. I did not realize when I put this together that it was possible to get there outside of an encounter, but I guess I was wrong.
This process is based on a modification to rx_print.php in CAMOS which allows the form’s four panel prescription printing to access data from the prescription table. I think the second problem you are having may be due to me not uploading the update of rx_print.php. I’ll check on this.
The part about updating user information probably does not need to be there. It just seemed that entering this information completely in the Administration section was not as straightforward as it could be, so I put this in to make it easier for me.
To try it out now, create prescriptions with the CAMOS form, leave the form, and click on the ‘rx’ link. Then check the checkboxes for the prescriptions you want to print and you should see them.
The prescriptions generated are not pdf, they are html with css formatting. I use it every day without any problem. I just need to make sure that that the cvs files are updated. Sorry.