I have other commands with a %s placeholder in the middle, and a like statement, and those work no issue And as mentioned, they worked no problem when i was using sqlite, but since switching they don't If anything else is needed just let me know, and thanks in advance for any help. But, i cannot add any parameters that actually work A simple list based on one of the fields in my report that just asks the user to select from a. How to use placeholders in postgresql
In sql systems other than postgres, such as mysql for instance, prepared statements can use question marks as a placeholder for data in prepared statements I am not sure how to create placeholders in postgres. I'm looping and with each loop i manipulate data and then save it to different csv file Now i'm trying to do the same with sqlite I have many tables but for sake of simplicity, lets say i have 3 tables placeholder := "VALUES (" for i, c := range columns { if i == 0 { *query += c placeholder += "?" } else { *query += ", "+c placeholder += ", ?" } } placeholder += ")" *query += ") " + placeholder } // convert []string to []interface{} func string2interface(s []string) []interface{} { i := make([]interface{}, len(s)) for k, v := range s {
They're known as query parameters As others have said, they're a way to prevent sql injection, but also they make your code much more readable in any case, so if you're putting sql into any programming language, use parameters. Why are the names john/jane doe used as placeholder names instead of any other name? 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 table.
OPEN
