database problem

Hi

I'm having trouble with the DBsave.

I created a table, put the name in DBSave, but if i try the frontend I get the following:

Parse error: syntax error, unexpected ':', expecting ',' or ';' in /home/mondzorgzuidplas.nl/public_html/administrator/components/com_chronoforms/form_actions/db_save/db_save.php(62) : eval()'d code on line 11

Fatal error: Call to a member function bind() on a non-object in /home/mondzorgzuidplas.nl/public_html/administrator/components/com_chronoforms/form_actions/db_save/db_save.php on line 85

If I cancel DBsave everything is alright again, but no records showing anymore.

And if I get this working how can I export the records in excell?

Thanks

Hi jannie,

You probably have a colon ':', dash '-' or some other special character in one of your input names. Dashes give ChronoForms and MySQL problems. Please rename the input using only [a-z], [A-Z], [0-9] or underscore '_'. No dashes, spaces or other special characters.

Bob

HiBob,

I think this was the problem because now it works fine. Thanks.

Now I only want to know how to export the records in excell.

Jannie

Hi Jannie,

If you get my custom CSV Extport [GH] action from here you can export to CSV which will usually open OK in Excel.

Bob

Hi Bob,

Thanks for the tip, I'm going to try that one.

Do you know if it's possible to place two fields next to eachother (at the frontend)

Like this

Date of bill one (textbox) Nummer of the bank account (textbox)
Date of bill two (textbox) Nummer of the bank account (textbox)

Now the four things are under eachother
Date of bill one (textbox)
Nummer of the bank account (textbox)
Date of bill two (textbox)
Nummer of the bank account (textbox)

Hi jannie ,

If you are using CFv4 then you can use a Custom Element to group inputs together like this. Or you can hand-code all the Form HTML using tables if you prefer.

Bob

Hi Bob,

Sorry, but I don't understand how to do that. Is there any information about this somewhere?

Hi Jannie,

Hmm . . . this is pretty basic HTML. What do you need help with?

Bob