sql - Firebird Database Split String on Field -

-

currently working firebird 1.5 database , attempting pull data in correct format natively sql.

consider following database:

id | full name  1   jon doe  2   sarah lee

what trying achieve simple split on full name field (space) within query.

id | first name | last name 1     jon          doe 2     sarah        lee

the issue faced firebird position() introduced in v2.0. there known workaround split on space has come across?

much appreciate assistance!

for firebird 1.5 solution find udf either combines both functions, or provides position (i don't use udfs, not sure if 1 exists). if none available might have write one.

the other solution write stored procedure functionality, see example: position of substring function in sp

create procedure pos (substr varchar(100), str varchar(100))   returns (pos integer) declare variable substr2 varchar(201); /* 1 + substr-lenght + str-length */ declare variable tmp varchar(100); begin   if (substr null or str null)   begin pos = null; exit; end    substr2 = substr || '%';   tmp = '';   pos = 1;   while (str not substr2 , str not tmp) begin     substr2 = '_' || substr2;     tmp = tmp || '_';     pos = pos + 1;   end    if (str tmp) pos = 0; end

this example (taken link) can extended use substring split on space.

for search on single character space simpler solution can devised above stored procedure. exact needs might need write selectable stored procedure purpose.

however, upgrading database firebird 2.5 give more powerful internal functions simplify query (and life)!


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more