Parameterized SQL statement: Difference between revisions

Line 907:
=={{header|Racket}}==
{{works with|PostgreSQL}}
{{libheader|sql db-lib}}
<lang racket>
#lang racket
(require sql db)
 
(define pgc
Line 919:
#:port 5432
#:password "s3>r37P455"))
 
(define update-player
(parameterize ((current-sql-dialect 'postgresql))
(update players
SET name = #:set [name ?,] [score = ?,] [active = ? ]
#:where [jerseyNum ?])))
 
(apply query
pgc
"UPDATE players update-player
SET name = ?, score = ?, active = ?
WHERE jerseyNum = ?"
'("Smith, Steve" 42 #t 99))
 
Anonymous user