Forum OpenACS Q&A: Response to openacs with PG7.1

Collapse
Posted by Brian Mann on
I was doing it to me, too, the page would load just fine, but it would always cause that error. Upgrading to 3.2.5 seems to have fixed it. The code that caused it was:
set db1 [ns_db gethandle]
set selection [ns_db select $db1 "select * from calendar where sysdate() <= end_date order by start_date"]

while {[ns_db getrow $db1 $selection]} {

   set title [ns_set get $selection title]
   set calendar_id [ns_set get $selection calendar_id]
   set approved_p [ns_set get $selection approved_p]
   if {$approved_p != "f"} {
       ns_puts "<li><a href="calendar/item.tcl?calendar_id=$calendar_id">$title</a>"
   }
}
ns_puts "</ul>"
#ns_puts [calendar_small_month -day_number_template "<a href="threads-one-day.tcl?[export_url_vars topic_id topic]&julian_dat
e=$julian_date"><font size=-1>$day_number</font></a>"]
#ns_puts "[calendar_small_month -day_bgcolor "#00FFFF"]"