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. 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 { 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.
This will work fine as written i think) Tidyverse pipes take the left side and shove it as the first argument to the next function. The question mark is a placeholder in your sql statement that is given a real value when the statement is executed 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?
OPEN
