Dropping values when form is submitted

[jiba]

I have the dadabik running fine on my home machine. When I tried to move everything to a remote host I lost some functionality namely the ability to pass my values from the search form to the sql query. I have the debug on and when you look at the sql that is generated it is missing the actual values I selected. I also tried the insert, it inserts a record because of the autoincrement but all the fields are empty again. Edits are the same way. Any ideas on how I can trouble shoot this. Is there anything that you have to do differently to run dadabik on a linux box vs XP? Here is a sample:

Your SQL query (for debugging purpose): select * from `customer` where `custid` = '8'

Edit the record

cust_id: 8

name: Sun Micro

webdress: www.sun.com

email: sun@sun.com

status: paid



**After submitting I get this

Your SQL query (for debugging purpose): update `customer` set `custid` = '', `name` = '', `webdress` = '', `email` = '', `status` = '' where = ''

Error during query execution.
update `customer` set `custid` = '', `name` = '', `webdress` = '', `email` = '', `status` = '' where = ''
MySQL server said: You have an error in your SQL syntax near '= ''' at line 1

Everything is gone? Any suggestions?

Any help would be appreciated!

 

[Eugenio]

jiba wrote:
>
> I have the dadabik running fine on my home machine. When I
> tried to move everything to a remote host I lost some
> functionality namely the ability to pass my values from the
> search form to the sql query. I have the debug on and when
> you look at the sql that is generated it is missing the
> actual values I selected. I also tried the insert, it
> inserts a record because of the autoincrement but all the
> fields are empty again. Edits are the same way. Any ideas
> on how I can trouble shoot this. Is there anything that you
> have to do differently to run dadabik on a linux box vs XP?

[....]

> Your SQL query (for debugging purpose): update `customer` set
> `custid` = '', `name` = '', `webdress` = '', `email` = '',
> `status` = '' where = ''
>
> Error during query execution.
> update `customer` set `custid` = '', `name` = '', `webdress`
> = '', `email` = '', `status` = '' where = ''
> MySQL server said: You have an error in your SQL syntax near
> '= ''' at line 1
>
> Everything is gone? Any suggestions?

Do you still have the problem? Which version of MySQL are you using?

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)