In my code i need to preceed every amount value with a currency sign selected by a user. The drop down contains a list of currency values like USD(US Dollars), EUR(Euro), INR(Indian Rupee) etc.
When we review the data entered by the users, the currency value should be preceeded with currency sign selected by the user in above drop down list. For Example
: If a user select USD(US Dollars) from the list then a Rate in another column as 10000. The view should look like USD 10000. I pull data to my form using Record Sets so how can is use LEFT(String, length) with a record set to trim first 3 characters of values selected by a user from drop down list. Please advise.
Expand|Select|Wrap|Line Numbers
- <td nowrap><div align="left">Currency Used For Pricing:</div></td>
- <td nowrap class="highlight"> <div align="left"><%=Rs1("currency_type")%></div></td>
- </tr>
Expand|Select|Wrap|Line Numbers
- <tr>
- <td><div align="left">Current Year Rate:</div></td>
- <td class="highlight"> <div align="left">$<%=Rs1("RATE1")%></div></td>
- </tr>
Regards,
Chandhseke