XModPro

HTML to SQL

jeffwest1 jeffwest1 posted Nov 27, 2019
Active Nov 27 · Viewed 2055 times

So this is the code that is populating my text box for the current user on the page

<div class="xmp-form-row">
<Label CssClass="xmp-form-label NormalBold" For="pod_user">
Updated By
</Label>
<TextBox Id="pod_user" DataField="pod_user" Nullable="false" DataType="string" Visible="true" Value='[[User:DisplayName]]' ReadOnly="true">
</TextBox>
</div>

this is the code that is pushing the data to the stored procedure.

<SubmitCommand CommandText="EXEC property_update @property_id, @short_name, @long_name, @address_line_1, @address_line_2, @address_line_3, @address_line_4, @postcode, @telephone, @notes, @latitude, @longitude, @Deleted, @pod_user, @pod_datum " ConnectionString="[[ConnectionString:netcondb]]" />

the stored proc has UpdatedBy as the second to last value coming in, this in turn is included in an update statement to update the columns of the database table with the user name.

I can see the user name in the textbox on the form, but dammed if I know why this is the only filed that does not go through.

No errors on the dnn side, and when i run Sp manually it populates without an issue.

Could do with some advice

3 Replies

Loading replies...