sql - How does one get a scalar for printing in Racket -


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