Hello,
I have a download form with radio button (input name is TimeFrame) to select time frame before downloading to csv format.
I have CSV Export v2 GH action.
I have TimeFrame in a database stored Spring, Summer, Fall value.
On Where clause in a download form, I have TimeFrame={TimeFrame}
When I select Spring and click submit to download, I received the error below
Unknown column 'Spring' in 'where clause' SQL=SELECT * FROM `xxxxx_chronoforms_data_xxxxx` WHERE TimeFrame = Spring ;
Did I miss something on the setting?
Thank you,
Nilubon
I have a download form with radio button (input name is TimeFrame) to select time frame before downloading to csv format.
I have CSV Export v2 GH action.
I have TimeFrame in a database stored Spring, Summer, Fall value.
On Where clause in a download form, I have TimeFrame={TimeFrame}
When I select Spring and click submit to download, I received the error below
Unknown column 'Spring' in 'where clause' SQL=SELECT * FROM `xxxxx_chronoforms_data_xxxxx` WHERE TimeFrame = Spring ;
Did I miss something on the setting?
Thank you,
Nilubon
Hi Nilubon,
Yes, you need quotes: WHERE `TimeFrame` 'Spring' so please try
Bob
Yes, you need quotes: WHERE `TimeFrame` 'Spring' so please try
`TimeFrame` = '{TimeFrame}'
- the backticks `` aren't essential, but make the use clearer; the quotes '' are essential.
Bob
This topic is locked and no more replies can be posted.