Error in sql script

[system]

120×120 10.4 KB

Approach: I want to use a date inside the sql() function Solution: sql(‘DataStore’, 'DELETE FROM table WHERE date_col = [$start_date] '); Problem with that: is actually multi-fold. First is the parameter substitution. In all strings DataServices does see, it will check for either [] or {} combinations. Each text inside these brackets will be put into the expression parser and replaced by its value. So the string ‘1+1=[1+1]’ will result in the string ‘1+1=2’. And with {} extra quotes will be p…

---

Werner Daehn (BOB member since 2004-12-17)