tauri-apps / tauri-apps/plugins-workspace

Question: How to create a select statement with null values as parameters

Open
#2,411 0 comments 0 reactions 0 assignees View on GitHub
plugin: sql type: question
Dominant language
Rust
Stars
1.8k
Forks
602
Avg merge
4d 14h
Merged PRs (30d)
9

Description

Hi there,

I've got a question regarding select statements from javascript with an sqlite database, where I can have null values as parameter.
```
await database.select('SELECT * FROM table WHERE something = $1', [null]);
```
This is not working. How can this be done?
In Sqlite the operator should be `IS NULL`

Thank you

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.