Hi,
I've created a form which allows me to register a new user. I've also used this form to load the user data. All with the record loader & multi record loader tutorials from this website.
Now when I load the list of users, I can click on them and the form (which is used to create a new user) is loaded with the data. So far so good. But when I try to launch the form to create a new user (so, without any parameters), the form gives me an error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM `jos_chronoforms_data_sv_lid` AS `JosChronoformsDataSvLid` WHERE
Anyone knows what I need to do?
I've created a form which allows me to register a new user. I've also used this form to load the user data. All with the record loader & multi record loader tutorials from this website.
Now when I load the list of users, I can click on them and the form (which is used to create a new user) is loaded with the data. So far so good. But when I try to launch the form to create a new user (so, without any parameters), the form gives me an error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM `jos_chronoforms_data_sv_lid` AS `JosChronoformsDataSvLid` WHERE
Anyone knows what I need to do?
Hi janfestjens,
There's an odd ChronoForms bug if the WHERE box is empty :-( Try just putting 1 into it.
Bob
There's an odd ChronoForms bug if the WHERE box is empty :-( Try just putting 1 into it.
Bob
Hi,
I've tried putting the number "1" in the where part. But then it fills the form with my first record instead of being empty. So, improvement, but not the expected result🙂
It is in the "db record loader" event that you meant?
I've tried putting the number "1" in the where part. But then it fills the form with my first record instead of being empty. So, improvement, but not the expected result🙂
It is in the "db record loader" event that you meant?
Still not able. Keep getting the error because when I put a "1" in the WHERE clause, it will always show the data of this record. While I want the form to be empty when you're not logged in or use a url without parameter.
Any idea's?
Any idea's?
This topic is locked and no more replies can be posted.
