Translate Perl Script to T-SQL -

-

ok - need perl guru on one. co-worker provided me code perl application support , how encodes values before writes data oracle. don't ask me why did encoding (appears special characters). values being written clob in oracle. need equivalent decode use in ssis package in sql server.

basically reading data oracle database using ssis package , need decode values. "+" sign between words easy replace statement (not sure best way, seems work far).

this 1 beyond skill set, because perl script skills limited (yes have done reading, not turning out easy thought since don't know perl well). interested in decoding string not encoding.

btw hint this, know %29 equals ")" sign. looks using regex, not versed in using either (i know need learn it).

sub decodevalue($)     {         $varref = shift;          ${$varref} =~  tr/+/ /;         ${$varref} =~ s/%([a-fa-f0-9]{2})/pack("c",hex($1))/eg;         ${$varref} =~ tr/\cm//;         ${$varref} =~ s/"/\"/g;         return;     }   sub encodevalue($)     {         $varref = shift;          # ${$varref} =~  tr/ /+/;         ${$varref} =~  s/"/\"/g;         ${$varref} =~  s/'/\'/g;         ${$varref} =~  s/(\w)/sprintf( "%%%x", ord($1) )/eg;         return;     }

the encodevalue subroutine simple url-encoding algorithm, additional steps convert single , double quotes equivalent html entities. need write transact-sql code decode steps in reverse order, first thing must done replace %7f-type sequences equivalent characters

you should @ url decode in t-sql code that. supports full utf-8 character set. remove else if @byte1value blocks support 7-bit ascii if wish, work fine stands

the remaining conversions of single , double-quotes , spaces can undone using replace calls, trust don't need with. original decodevalue subroutine restores double-quotes , spaces, leaving single-quotes ', don't know whether want replicate behaviour


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more