Change _ to a +

[OuTCasT]

I got a system where a user chooses his/her course and then goes to a checkout page where the course items are in the shopping cart on the page.

Now the user needs certain criteria to be registered for the course like studentName, studentID, courseName & courseType.

anyways now when the user has entered all his information after picking his course, it first goes to a page where i load the specific criteria needed to register into session state and then it does a automatic redirect to the bank, i do this becuase no information returns when it has been processed by the bank, so if the transaction is successful it goes back to the session state page where the information is waiting there in hidden labels. ready to get posted to the student registration.

the format of the course name is Access+2003+Series, now once its come back from the bank and all the format i retrieve from session state is Access_2003_Series, now when it posts the student is not registered because it has to be posted with either the + sign or a blank space.

IS there some way on the page that i can remove the _ and change it with the + sign ????

i think it has something to do with REGULAR EXPRESSIONs.

[ck9663]

can it be handled by your client-side application? i'm assuming you're talking a web-based application here and you received the data as string. can you create a client-side function/proc to replace the string you need (ie VBSCRIPT, JAVASCRIPT, etc)? if you can not and you have to pass this entire string into a stored proc and you need this string manipulation in T-SQL, there's a replace function in sql 2005, don't have time yet to test if it's in sql2K, sorry ;)

http://msdn2.microsoft.com/en-us/library/ms186862.aspx


-- CK

[OuTCasT]

can it be handled by your client-side application? i'm assuming you're talking a web-based application here and you received the data as string. can you create a client-side function/proc to replace the string you need (ie VBSCRIPT, JAVASCRIPT, etc)? if you can not and you have to pass this entire string into a stored proc and you need this string manipulation in T-SQL, there's a replace function in sql 2005, don't have time yet to test if it's in sql2K, sorry ;)

http://msdn2.microsoft.com/en-us/library/ms186862.aspx


-- CK

It is web based.
the info gets posted to that page where eventually i land on after the transaction has been successful....there i call it from session state and place it into a label on screen.
i need someway to change the _ to a + sign in order to post that data for the next step.

i tried to write a <script> so that it wld search for the _ on page load and change it too a +.

<script type="text/javascript" language="javascript">
    function Replace(str)
    {
           return str.replace(/\_/g, "+");
    }
    </script>

but that doesnt work.

[ck9663]

if you're going to handle this in front-end, it's becoming a scripting problem, not sql-server.

do you need the _ be repalce to + before it goes to db? coz if inside the db and before you store in in the table you can use the replace function

-- CK

[OuTCasT]

if you're going to handle this in front-end, it's becoming a scripting problem, not sql-server.

do you need the _ be repalce to + before it goes to db? coz if inside the db and before you store in in the table you can use the replace function

-- CK

i worked it out hehe,

the problem was on the checkout page....the querystring was already being changed from + to _ so i revered that ...

function QueryString(param){
            var loca = document.location.href;
            if(loca.indexOf('?'   param   '=')>-1 || loca.indexOf('&'   param   '=')>-1){
                var qString = loca.split('?');
                var keyVal = qString[1].split('&');
                for(var i=0;i<keyVal.length;i  ){
                    if(keyVal[i].indexOf(param   '=')==0){
                        var val = keyVal[i].split('=');
                        return val[1];
                    }
                }
                return false;
            }else{
                return false;
            }
        }
 
        function Trim(str){
           return str.replace(/[\(\)\.\-\s,]/g, "");
        }
        function Trim2(str){
           return str.replace(/[\(\)\R\-\s,]/g, "");
        }
 
       function Replace(str){
           return str.replace(/\_/g, "+");
        }
       function Replace2(str){
           return str.replace(/\%26/g, "and");
        }
 
        function moneyFormat(input) {
           var dollars = Math.floor(input);
           var tmp = new String(input);
 
           for ( var decimalAt = 0; decimalAt < tmp.length; decimalAt   ) {
              if ( tmp.charAt(decimalAt)=="." )
                 break;
           }
 
           var cents  = ""   Math.round(input * 100);
           cents = cents.substring(cents.length-2, cents.length)
                   dollars  = ((tmp.charAt(decimalAt 2)=="9")&&(cents==""))? 1 : 0;
 
           if ( cents == "0" )
              cents = "00";
 
           return(dollars   "."   cents);
        }
 
 
    </script>