Guys I've made a nuBuilder backoffice, followed the tutorials. All good.
Detected some problems with the dropdows since i cant add ' to the queries cause it escapes those characters. Anyways I solved that inserting directly into the DB.
Problem is when i try to add something via a form to a database it just doesnt add. Returns me to the form screen and produces no output. Is there anyway i can check the queries being made or is this an easy to solve problem?
Btw the table has an INNER JOIN with another table but again, it used to work, i dunno what happened.
Thank you for any help
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Help Im in despair
-
- Site Admin
- Posts: 2782
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 2 times
Re: Help Im in despair
painatal,
See if any of these posts answer your problem..
http://forums.nubuilder.cloud/search.php? ... +%2Bsave++
For your first problem, this might help..
http://forums.nubuilder.cloud/search.php? ... ic++escape
Steven
See if any of these posts answer your problem..
http://forums.nubuilder.cloud/search.php? ... +%2Bsave++
For your first problem, this might help..
http://forums.nubuilder.cloud/search.php? ... ic++escape
Steven
-
- Posts: 12
- Joined: Fri Mar 01, 2013 2:57 am
Re: Help Im in despair
That solves the first problem, as for the second problem i've searched for most of those posts none helped.
I actually solved the problem by removing the foreign key, and i had a discrepancy between the field names on the table and the ID's I was using on the lookup. Hope this saves someone the time it took me.
Also as a suggestion to this forum I'd advice not requiring all the posts to be accepted. It would bring a lot more discussion to this forum.
Anyway thank you for the help.
I actually solved the problem by removing the foreign key, and i had a discrepancy between the field names on the table and the ID's I was using on the lookup. Hope this saves someone the time it took me.
Also as a suggestion to this forum I'd advice not requiring all the posts to be accepted. It would bring a lot more discussion to this forum.
Anyway thank you for the help.
-
- Posts: 12
- Joined: Fri Mar 01, 2013 2:57 am
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
-
- Posts: 12
- Joined: Fri Mar 01, 2013 2:57 am
Re: Help Im in despair
Hey, I didn't know nuBuilder had that kind of log. Anyways I solved it.
My foreign key was not the primary key but an index of the other table. I changed it to the primary key. Its a better db design and it works just the same.
EDIT: Had to remove the foreign key in the end.
SOLVED
My foreign key was not the primary key but an index of the other table. I changed it to the primary key. Its a better db design and it works just the same.
EDIT: Had to remove the foreign key in the end.
SOLVED