Empty Input field in VC SQL iview

[derekvincent]

Hello all,

I am using the VC to create a small iView to pull data from a MS-SQL DB. I have the iView built and things work for the most part. The issue I am having is I get the following error if any input field is left blank "Portal request failed (No value was assigned to parameter(@LastName))"

I have the stored procedure setup so that I if a null is passed in for any of the values it set the value to a '%'.

I am wonder if it is possible to either:

a) pass blank values

b) test if a value is blank before the submit and

change the value to a '%'.

Cheers,

D.

[Former Member · Accepted solution]

Dear D,

You can use dynamic expressions to pass the value '%' if the input field is blank. Check out the conditional expressions that you can use in the dynamic expression window.

Thanks in advance,

Deep

[derekvincent · Accepted solution]

Deep, I was looking at the dynamic expressions I had found that if(isnull(@@), '%', @@) would be perfect but I guess I could not find where to place it... I was trying to place it on the fields on the form view I could not find something (other then the validation dynmaic expression) and that simply seemed to raise an error pop-up... Is their somewhere else to place it??

Cheers,

D.

[Former Member · Accepted solution]

Dear D,

Try to put your expression in computation field of the Dynamic expression editor.

Thanks in advance,

Deep.

[derekvincent · Accepted solution]

I had tried that but it seem to to the computaion on the inital display or update of the view and not while a event "submit" is triggered....

D.

[derekvincent · Accepted solution]

I may take that back... I think the issuse was with a validation rule... the only thing I do not like about is that it defaults the '%' on the inital display...

D.