DT
Drizzle Teameatmoose

OrderBy with dynamic queries dont work

....orderBy(sql`${products.xyz} ${order}`)
....orderBy(sql`${products.xyz} ${order}`)
error: syntax error at or near "$2"
error: syntax error at or near "$2"
order is 'asc' / 'desc'
A
AlcaponeYou•349d ago
Andrew already answered, but in case anyone else has similar issues: Any sql template value that you don't want quotes, ie sql keywords, should be wrapped in sql.raw
Want results from more Discord servers?
Add your server
More Posts
Is there a way to limit update to just 1 document?I know there will be multiple documents matching this where query, but I only want to update 1 of thHow to get InferModel to work with Relation model?Is there a way to get the infer type for a relation model? eg: type User = InferModel<typeof users,MySQL column type: "Generated"?Does drizzle support defining generated columns? https://planetscale.com/courses/mysql-for-developeAnyone else having a weird issue with drizzle-kit push:mysql?I spun up a new project using Planetscale and I got a bizarre __vtschema error (see: https://github.