Run Plugin and Sql plugin passing params

[Christopher Dlugolinski]

I have been following this example and have it working.

https://bobswift.atlassian.net/wiki/display/RUN/How+to+do+SQL+database+operations+on+lists+of+data

the problem is with the edit button and the passing of the parameter.

it {url-encode} the string i am passing but on the receiving end when edit is pushed I am getting the weird characters in the edit string???

what i pass in is: http://perforce.link2.com

what i get in text field is: <a href="http://perforce.link2.com" class="external-link" rel="nofollow">http://perforce.link2.com</a>

Is there a way to not have to {url-encode} or get the string passed? it may have spaces which seem to kill the passing of anything else to follow.

I have tried to {url-decode} as follows and even inside a {run}{run} macro (both with no luck):

{hide:$hideEdit}
h3. Edit
{run:id=edit|hideColumnHeadings=true|keepRequestParameters=true|replace=
g1::Edit:group,
id:::hidden,
first::first,
last::last,
extension::extension:integer-select:1200:1299
|titleRun=Change}
{sql:dataSource=testDS|p1=$first|p2=$last}
update example
set first = + '{url-decode}' + ? + '{url-decode}' + , last = ?, extension = $extension
where id = $id
{sql}
{extract-link:redirect=true}
$page_url?run_selection=run
{extract-link}
{run}
{hide}

Any help would be appreciated

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Let's move this discussion to an issue. It is a difficult example to go through.