XModPro

SQL error in feed - fields recognized as keywords

Rune Kildahl Bentsen Rune Kildahl Bentsen asked Aug 21, 2014
Active Aug 24 · Viewed 2333 times
<p>I've been looking at a few Feed issues on the board, but I think this one is unique.</p><p>When naming fields in a table, it seems some words will break the Feed generation, while a normal template doesn't care.</p><p>As an example, try naming a field "By". This is a reserved word in SQL, but it actually means "City" in danish. This field can work in forms and templates, but not in a Feed. I'm really not sure why, but I find it a bit annoying that I have to change my field names to avoid reserved SQL names just because I'd like to use the table in a feed. Does a fix exist? :)</p><p>Kind Regards<br>Rune</p>

1 Answer

Loading answers...