my program doing select this:
(define latest-withdrawal-date (for/list ([(date-wdrl) (in-query odc "select max(student_withdrawal_date) student_enrollement student_id = ? " my_student_id)))) instead of getting date though, #<procedure:date-wdrl>.
so how can date display rather being obscured?
use query-value scalar result.
from documentation:
(query-value connection stmt arg ...) → any/c executes sql query, must produce 1 row of 1 column, , returns single value result. examples: > (query-value pgc "select timestamp 'epoch'") (sql-timestamp 1970 1 1 0 0 0 0 #f) > (query-value pgc "select d the_numbers n = $1" 3) "a crowd"
Comments
Post a Comment