Forums

database problem

jannie 14 Nov, 2011
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
GreyHead 14 Nov, 2011
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
jannie 16 Nov, 2011
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
GreyHead 16 Nov, 2011
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
jannie 18 Nov, 2011
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)
GreyHead 24 Nov, 2011
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
jannie 24 Nov, 2011
Hi Bob,

Sorry, but I don't understand how to do that. Is there any information about this somewhere?
GreyHead 24 Nov, 2011
Hi Jannie,

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

Bob
This topic is locked and no more replies can be posted.