Hello everyone,
I am using ASPRunnerPro 6.1 in a windows server enviornment retrieving data from SQL DB.
In ASPRunner I retrieve a field of data that is alpha numeric and is an address such as "1207 Norwood Dr.". When I retrieve the data I want to display "1200 Norwood Dr." for the field.
I am not changing the data in the DB, just how it is displayed in ASPRunner. Now this is only one example of an address, in reality, the ASP page will retrieve hundreds of lines of data but just in the address field I want it to change the data for all addresses.
I think I know where to put the code to manipulate the data but I just need from more expierenced users confirmation or suggestions. My thought was to go to the editor page and on the field right click and go to "Properties" and in the "View As" select "Custom" and enter the VB code here.
Am I on the right track? How would you do this task differntly?
Thank you in advance for responding..
Sincerely,
Joe