Alpap
DTDrizzle Team
•Created by Cory on 5/8/2023 in #help
how to use placeholders for Prepared Insert statements?
this worked for me
db.insert(users)
.values({
email: sql.placeholder('email'),
name: sql.placeholder('name'),
emailVerified: sql.placeholder('emailVerified'),
image: sql.placeholder('image'),
})
.prepare('insert_users')4 replies
DTDrizzle Team
•Created by Myrseth on 7/15/2023 in #help
Placeholders in inserting: db.insert().values(placeholder('example'))
ok found the answer this worked for me
db.insert(users)
.values({
email: sql.placeholder('email'),
name: sql.placeholder('name'),
emailVerified: sql.placeholder('emailVerified'),
image: sql.placeholder('image'),
active: sql.placeholder('active'),
roles: sql.placeholder('roles'),
company: sql.placeholder('company')
})
.onConflictDoNothing()
.prepare('insert_users')5 replies
DTDrizzle Team
•Created by Myrseth on 7/15/2023 in #help
Placeholders in inserting: db.insert().values(placeholder('example'))
same issue here i would love to hear the answer to this issue
5 replies