How do you retrieve multiple data in sqlite database using select * ... where ?1 in vector variable?

[LeafWarrior]

Hi guys. I've been trying to retrieve multiple data from sqlite database based on user selection. The javascript is fine but I'm not very familiar with rust. Obviously, my syntax is not correct.

Any help would be much appreciated.

How do you use "in" with sqlite rust? How should I bind my vector variable?

`async fn get_customer(state: tauri::State<'_, AppState>, cid : Vec) -> Result<(), String> {
let db = &state.db;

let cust: Vec<Person> = sqlx::query_as::<_, Person>("SELECT * FROM customer where cid in ?1")
    .bind(cid)
    .fetch(db)
    .try_collect()
    .await
    .map_err(|e| format!("Failed to get customer {}", e))?;

Ok(cust)

}
`

[evanwmart]

Same as #12567 ? 🤔

[LeafWarrior]

Yes, sorry