NetTalk Central

Author Topic: Drop update problem  (Read 3649 times)

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Drop update problem
« 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

-----------
Regards
Alberto

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Drop update problem
« Reply #1 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.

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Drop update problem
« Reply #2 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]

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Re: Drop update problem
« Reply #3 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
-----------
Regards
Alberto

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Drop update problem
« Reply #4 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