Can't edit '---' in DB.

[Former Member]

Hello,

I am using http post to post document to DataExchangeInterface. Everythink works good except:

If (for example) MIDDLE_NAME or EMAIL_ADDRESS of the user doesn't have specified name it is displayed on the iGrid '-'. When I tried to change it through http post, but I can't. It is still '-'.

If user have specified MIDDLE NAME or EMAIL_ADDRESS I can change/update it.

Regards,

Mateusz.

[jcgood25 · Accepted solution]

This is coming from NULLS in the DB, so get them to be a blank string instead of a null and you should be OK.

I typically would use CASE in my SQL statement for this something like:

(CASE WHEN MIDDLE_NAME is null THEN '' ELSE MIDDLE_NAME END) AS MIDDLE_NAME

Regards,

Jeremy

[Former Member · Accepted solution]

Thnx, I see your point, but I can live with displayed '---'.

My point is that I am not able to modify values when they are NULL. transaction is executed OK, but still I see '--' instead of inputed new value.

I hope that this time I wrote enough clear to understand me

[jcgood25 · Accepted solution]

The iGrid will display TimeUnavailable for null dates, NA for null numbers, and --- for null strings.

I don't understand how the http post inside a TRX is related to the iGrid display.

[Former Member · Accepted solution]

Without knowing the details, my guess would be that you (usually) cannot update/modify a record that doesn't exist and that is what the transaction is trying to do. You would have to do an insert.

Please give us some more details about what you are trying to do.

Regards,

Christian

[Former Member · Accepted solution]

I build somethink like this:

DISPLAY PART:

SQL QUERY -> iGrid displayed with users (columns: fname, lname, email, password...)

On the WEB PAGE I create form when I read values from iGrid (into text fields) where I can change it, for example Name, email etc. When I press UPDATE button I am passing values to transaction with http post.

HTTP POST posts document to the DataExchangeInterface in order to change/update users name, email...

When I update iGrid I see changes except fields that had '---'. I am not able to change it in above described way.

Edited by: Mateusz Tarkowski on Jan 29, 2009 4:19 PM

[Former Member · Accepted solution]

It sounds like your problem is on the DataExchangeInterface side.

Regards,

Christian

[jcgood25 · Accepted solution]

If you can SELECT query to feed the iGrid display, why do you not do your UPDATE queries in Command mode templates and then use the iCommand applet to execute the SQL?

What is the underlying requirement for http post and DataExchangeInterface?