NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Alberto on March 16, 2009, 12:07:07 PM

Title: Drop update problem
Post by: Alberto on March 16, 2009, 12:07:07 PM

Hi,
In a form I have a drop cstring(2) (varchar(1) at mssql) with two options: + and -
When I select the - option the field saves ok and I can see in the profiler:

UPDATE dbo.CR_DAT SET BLOOD_RH = @P1 WHERE ID = @P2

When I choose the + option the field is saved blank and the update is not send to the Ms sql server.

The validate options are set to NO in the template.

Any Idea?

Thanks
Alberto

Title: Re: Drop update problem
Post by: kevin plummer on March 16, 2009, 02:15:05 PM

Maybe the + is not HTML safe. Try a and b. If that works try to wrap the + in one of Bruce's HTML functions (I have not used them but seen them in his examples Base64 and escape something). The accounting app has them in the EIP example embeds.

Title: Re: Drop update problem
Post by: Bruce on March 16, 2009, 10:10:49 PM

I've attached a small update to an example which you can try.
In this example the "Alias" form has an additional drop-down.
This seems to work ok, so I don't think it's an encoding problem.
Perhaps you can compare this to your app to see what you've done differently?
Notice that the "value" of each drop-down item is in quotes.

Cheers
Bruce




[attachment deleted by admin]

Title: Re: Drop update problem
Post by: Alberto on March 17, 2009, 01:52:14 AM

Weird, my drop down is exactly the same as yours and I´ve tried with another form (another table) in my app and it works too.
I´m lost, dont know how to debug it.
Any other idea?

Thanks
Alberto

Title: Re: Drop update problem
Post by: Bruce on March 18, 2009, 07:09:27 AM

not really - I guess it's your turn to make an example of it not working.

Cheers
Bruce