Even just a list query shows nothing, i tried a lot of stuff i found on internet, i even asked ai for help, but it didn't work. It seems the query is ok, but it returns empty list or a. Technically, you have the right amount, but you're missing parentheses and commas, and it's broken up throughout your query which i suspect is confusing sql.
In sql systems other than postgres, such as mysql for instance, prepared statements can use question marks as a placeholder. Why are the names john/jane doe used as placeholder names instead of any other name? The question mark is a placeholder in your sql statement that is given a real value when the statement is executed.
How to use placeholders in postgresql? What i’ve prepared for now is a preliminary poll, where people would decide for example on the actual categories and numbers of nominations, as well as on what are their. They're known as query parameters. For i, c := range columns { if i == 0 { *query += c placeholder += ? } else { *query += , +c placeholder += , ? } } placeholder += ) *query += ) + placeholder } // convert.
Truecan you add an array as an sqlite query placeholder?