DBI, Placeholders, and a nested query : r/perl – Reddit

August 21, 2023

DBI, Placeholders, and a nested query Edit: Solution found and described below. Hello all, I’m attempting to insert/update into an MSSQL database. The source of the data is another database. Sometimes the source database has new records, and other times there are existing records. So I’m attempting to do this:

https://www.reddit.com/r/perl/comments/yk9it9/dbi_placeholders_and_a_nested_query/

DBI, Placeholders, and a nested query : r/perl – Reddit <body> <h1> Array ( [0] => sbi, placeholders, and a nested query : r/perl – reddit [1] => xbi, placeholders, and a nested query : r/perl – reddit [2] => cbi, placeholders, and a nested query : r/perl – reddit [3] => fbi, placeholders, and a nested query : r/perl – reddit [4] => rbi, placeholders, and a nested query : r/perl – reddit [5] => ebi, placeholders, and a nested query : r/perl – reddit [6] => dvi, placeholders, and a nested query : r/perl – reddit [7] => dni, placeholders, and a nested query : r/perl – reddit [8] => dhi, placeholders, and a nested query : r/perl – reddit [9] => dgi, placeholders, and a nested query : r/perl – reddit [10] => dbu, placeholders, and a nested query : r/perl – reddit [11] => dbj, placeholders, and a nested query : r/perl – reddit [12] => dbk, placeholders, and a nested query : r/perl – reddit [13] => dbo, placeholders, and a nested query : r/perl – reddit [14] => db9, placeholders, and a nested query : r/perl – reddit [15] => db8, placeholders, and a nested query : r/perl – reddit [16] => dbim placeholders, and a nested query : r/perl – reddit [17] => dbik placeholders, and a nested query : r/perl – reddit [18] => dbil placeholders, and a nested query : r/perl – reddit [19] => dbi. placeholders, and a nested query : r/perl – reddit [20] => dbi placeholders, and a nested query : r/perl – reddit [21] => dbi, olaceholders, and a nested query : r/perl – reddit [22] => dbi, llaceholders, and a nested query : r/perl – reddit [23] => dbi, -laceholders, and a nested query : r/perl – reddit [24] => dbi, 0laceholders, and a nested query : r/perl – reddit [25] => dbi, pkaceholders, and a nested query : r/perl – reddit [26] => dbi, ppaceholders, and a nested query : r/perl – reddit [27] => dbi, poaceholders, and a nested query : r/perl – reddit [28] => dbi, plzceholders, and a nested query : r/perl – reddit [29] => dbi, plsceholders, and a nested query : r/perl – reddit [30] => dbi, plwceholders, and a nested query : r/perl – reddit [31] => dbi, plqceholders, and a nested query : r/perl – reddit [32] => dbi, plaxeholders, and a nested query : r/perl – reddit [33] => dbi, plaveholders, and a nested query : r/perl – reddit [34] => dbi, plafeholders, and a nested query : r/perl – reddit [35] => dbi, pladeholders, and a nested query : r/perl – reddit [36] => dbi, placwholders, and a nested query : r/perl – reddit [37] => dbi, placsholders, and a nested query : r/perl – reddit [38] => dbi, placdholders, and a nested query : r/perl – reddit [39] => dbi, placrholders, and a nested query : r/perl – reddit [40] => dbi, plac4holders, and a nested query : r/perl – reddit [41] => dbi, plac3holders, and a nested query : r/perl – reddit [42] => dbi, placegolders, and a nested query : r/perl – reddit [43] => dbi, placebolders, and a nested query : r/perl – reddit [44] => dbi, placenolders, and a nested query : r/perl – reddit [45] => dbi, placejolders, and a nested query : r/perl – reddit [46] => dbi, placeuolders, and a nested query : r/perl – reddit [47] => dbi, placeyolders, and a nested query : r/perl – reddit [48] => dbi, placehilders, and a nested query : r/perl – reddit [49] => dbi, placehklders, and a nested query : r/perl – reddit [50] => dbi, placehllders, and a nested query : r/perl – reddit [51] => dbi, placehplders, and a nested query : r/perl – reddit [52] => dbi, placeh0lders, and a nested query : r/perl – reddit [53] => dbi, placeh9lders, and a nested query : r/perl – reddit [54] => dbi, placehokders, and a nested query : r/perl – reddit [55] => dbi, placehopders, and a nested query : r/perl – reddit [56] => dbi, placehooders, and a nested query : r/perl – reddit [57] => dbi, placeholsers, and a nested query : r/perl – reddit [58] => dbi, placeholxers, and a nested query : r/perl – reddit [59] => dbi, placeholcers, and a nested query : r/perl – reddit [60] => dbi, placeholfers, and a nested query : r/perl – reddit [61] => dbi, placeholrers, and a nested query : r/perl – reddit [62] => dbi, placeholeers, and a nested query : r/perl – reddit [63] => dbi, placeholdwrs, and a nested query : r/perl – reddit [64] => dbi, placeholdsrs, and a nested query : r/perl – reddit [65] => dbi, placeholddrs, and a nested query : r/perl – reddit [66] => dbi, placeholdrrs, and a nested query : r/perl – reddit [67] => dbi, placehold4rs, and a nested query : r/perl – reddit [68] => dbi, placehold3rs, and a nested query : r/perl – reddit [69] => dbi, placeholdees, and a nested query : r/perl – reddit [70] => dbi, placeholdeds, and a nested query : r/perl – reddit [71] => dbi, placeholdefs, and a nested query : r/perl – reddit [72] => dbi, placeholdets, and a nested query : r/perl – reddit [73] => dbi, placeholde5s, and a nested query : r/perl – reddit [74] => dbi, placeholde4s, and a nested query : r/perl – reddit [75] => dbi, placeholdera, and a nested query : r/perl – reddit [76] => dbi, placeholderz, and a nested query : r/perl – reddit [77] => dbi, placeholderx, and a nested query : r/perl – reddit [78] => dbi, placeholderd, and a nested query : r/perl – reddit [79] => dbi, placeholdere, and a nested query : r/perl – reddit [80] => dbi, placeholderw, and a nested query : r/perl – reddit [81] => dbi, placeholdersm and a nested query : r/perl – reddit [82] => dbi, placeholdersk and a nested query : r/perl – reddit [83] => dbi, placeholdersl and a nested query : r/perl – reddit [84] => dbi, placeholders. and a nested query : r/perl – reddit [85] => dbi, placeholders and a nested query : r/perl – reddit [86] => dbi, placeholders, znd a nested query : r/perl – reddit [87] => dbi, placeholders, snd a nested query : r/perl – reddit [88] => dbi, placeholders, wnd a nested query : r/perl – reddit [89] => dbi, placeholders, qnd a nested query : r/perl – reddit [90] => dbi, placeholders, abd a nested query : r/perl – reddit [91] => dbi, placeholders, amd a nested query : r/perl – reddit [92] => dbi, placeholders, ajd a nested query : r/perl – reddit [93] => dbi, placeholders, ahd a nested query : r/perl – reddit [94] => dbi, placeholders, ans a nested query : r/perl – reddit [95] => dbi, placeholders, anx a nested query : r/perl – reddit [96] => dbi, placeholders, anc a nested query : r/perl – reddit [97] => dbi, placeholders, anf a nested query : r/perl – reddit [98] => dbi, placeholders, anr a nested query : r/perl – reddit [99] => dbi, placeholders, ane a nested query : r/perl – reddit [100] => dbi, placeholders, and z nested query : r/perl – reddit [101] => dbi, placeholders, and s nested query : r/perl – reddit [102] => dbi, placeholders, and w nested query : r/perl – reddit [103] => dbi, placeholders, and q nested query : r/perl – reddit [104] => dbi, placeholders, and a bested query : r/perl – reddit [105] => dbi, placeholders, and a mested query : r/perl – reddit [106] => dbi, placeholders, and a jested query : r/perl – reddit [107] => dbi, placeholders, and a hested query : r/perl – reddit [108] => dbi, placeholders, and a nwsted query : r/perl – reddit [109] => dbi, placeholders, and a nssted query : r/perl – reddit [110] => dbi, placeholders, and a ndsted query : r/perl – reddit [111] => dbi, placeholders, and a nrsted query : r/perl – reddit [112] => dbi, placeholders, and a n4sted query : r/perl – reddit [113] => dbi, placeholders, and a n3sted query : r/perl – reddit [114] => dbi, placeholders, and a neated query : r/perl – reddit [115] => dbi, placeholders, and a nezted query : r/perl – reddit [116] => dbi, placeholders, and a nexted query : r/perl – reddit [117] => dbi, placeholders, and a nedted query : r/perl – reddit [118] => dbi, placeholders, and a neeted query : r/perl – reddit [119] => dbi, placeholders, and a newted query : r/perl – reddit [120] => dbi, placeholders, and a nesred query : r/perl – reddit [121] => dbi, placeholders, and a nesfed query : r/perl – reddit [122] => dbi, placeholders, and a nesged query : r/perl – reddit [123] => dbi, placeholders, and a nesyed query : r/perl – reddit [124] => dbi, placeholders, and a nes6ed query : r/perl – reddit [125] => dbi, placeholders, and a nes5ed query : r/perl – reddit [126] => dbi, placeholders, and a nestwd query : r/perl – reddit [127] => dbi, placeholders, and a nestsd query : r/perl – reddit [128] => dbi, placeholders, and a nestdd query : r/perl – reddit [129] => dbi, placeholders, and a nestrd query : r/perl – reddit [130] => dbi, placeholders, and a nest4d query : r/perl – reddit [131] => dbi, placeholders, and a nest3d query : r/perl – reddit [132] => dbi, placeholders, and a nestes query : r/perl – reddit [133] => dbi, placeholders, and a nestex query : r/perl – reddit [134] => dbi, placeholders, and a nestec query : r/perl – reddit [135] => dbi, placeholders, and a nestef query : r/perl – reddit [136] => dbi, placeholders, and a nester query : r/perl – reddit [137] => dbi, placeholders, and a nestee query : r/perl – reddit [138] => dbi, placeholders, and a nested 1uery : r/perl – reddit [139] => dbi, placeholders, and a nested 2uery : r/perl – reddit [140] => dbi, placeholders, and a nested wuery : r/perl – reddit [141] => dbi, placeholders, and a nested auery : r/perl – reddit [142] => dbi, placeholders, and a nested qyery : r/perl – reddit [143] => dbi, placeholders, and a nested qhery : r/perl – reddit [144] => dbi, placeholders, and a nested qjery : r/perl – reddit [145] => dbi, placeholders, and a nested qiery : r/perl – reddit [146] => dbi, placeholders, and a nested q8ery : r/perl – reddit [147] => dbi, placeholders, and a nested q7ery : r/perl – reddit [148] => dbi, placeholders, and a nested quwry : r/perl – reddit [149] => dbi, placeholders, and a nested qusry : r/perl – reddit [150] => dbi, placeholders, and a nested qudry : r/perl – reddit [151] => dbi, placeholders, and a nested qurry : r/perl – reddit [152] => dbi, placeholders, and a nested qu4ry : r/perl – reddit [153] => dbi, placeholders, and a nested qu3ry : r/perl – reddit [154] => dbi, placeholders, and a nested queey : r/perl – reddit [155] => dbi, placeholders, and a nested quedy : r/perl – reddit [156] => dbi, placeholders, and a nested quefy : r/perl – reddit [157] => dbi, placeholders, and a nested quety : r/perl – reddit [158] => dbi, placeholders, and a nested que5y : r/perl – reddit [159] => dbi, placeholders, and a nested que4y : r/perl – reddit [160] => dbi, placeholders, and a nested quert : r/perl – reddit [161] => dbi, placeholders, and a nested querg : r/perl – reddit [162] => dbi, placeholders, and a nested querh : r/perl – reddit [163] => dbi, placeholders, and a nested queru : r/perl – reddit [164] => dbi, placeholders, and a nested quer7 : r/perl – reddit [165] => dbi, placeholders, and a nested quer6 : r/perl – reddit [166] => dbi, placeholders, and a nested query : e/perl – reddit [167] => dbi, placeholders, and a nested query : d/perl – reddit [168] => dbi, placeholders, and a nested query : f/perl – reddit [169] => dbi, placeholders, and a nested query : t/perl – reddit [170] => dbi, placeholders, and a nested query : 5/perl – reddit [171] => dbi, placeholders, and a nested query : 4/perl – reddit [172] => dbi, placeholders, and a nested query : r/oerl – reddit [173] => dbi, placeholders, and a nested query : r/lerl – reddit [174] => dbi, placeholders, and a nested query : r/-erl – reddit [175] => dbi, placeholders, and a nested query : r/0erl – reddit [176] => dbi, placeholders, and a nested query : r/pwrl – reddit [177] => dbi, placeholders, and a nested query : r/psrl – reddit [178] => dbi, placeholders, and a nested query : r/pdrl – reddit [179] => dbi, placeholders, and a nested query : r/prrl – reddit [180] => dbi, placeholders, and a nested query : r/p4rl – reddit [181] => dbi, placeholders, and a nested query : r/p3rl – reddit [182] => dbi, placeholders, and a nested query : r/peel – reddit [183] => dbi, placeholders, and a nested query : r/pedl – reddit [184] => dbi, placeholders, and a nested query : r/pefl – reddit [185] => dbi, placeholders, and a nested query : r/petl – reddit [186] => dbi, placeholders, and a nested query : r/pe5l – reddit [187] => dbi, placeholders, and a nested query : r/pe4l – reddit [188] => dbi, placeholders, and a nested query : r/perk – reddit [189] => dbi, placeholders, and a nested query : r/perp – reddit [190] => dbi, placeholders, and a nested query : r/pero – reddit [191] => dbi, placeholders, and a nested query : r/perl ᰫ reddit [192] => dbi, placeholders, and a nested query : r/perl &#u211; reddit [193] => dbi, placeholders, and a nested query : r/perl &#i211; reddit [194] => dbi, placeholders, and a nested query : r/perl ⏻ reddit [195] => dbi, placeholders, and a nested query : r/perl ᾯ reddit [196] => dbi, placeholders, and a nested query : r/perl &#8q11; reddit [197] => dbi, placeholders, and a nested query : r/perl &#8w11; reddit [198] => dbi, placeholders, and a nested query : r/perl ⁷ reddit [199] => dbi, placeholders, and a nested query : r/perl ” reddit [200] => dbi, placeholders, and a nested query : r/perl &#82q1; reddit [201] => dbi, placeholders, and a nested query : r/perl — reddit [202] => dbi, placeholders, and a nested query : r/perl &#821q; reddit [203] => dbi, placeholders, and a nested query : r/perl – eeddit [204] => dbi, placeholders, and a nested query : r/perl – deddit [205] => dbi, placeholders, and a nested query : r/perl – feddit [206] => dbi, placeholders, and a nested query : r/perl – teddit [207] => dbi, placeholders, and a nested query : r/perl – 5eddit [208] => dbi, placeholders, and a nested query : r/perl – 4eddit [209] => dbi, placeholders, and a nested query : r/perl – rwddit [210] => dbi, placeholders, and a nested query : r/perl – rsddit [211] => dbi, placeholders, and a nested query : r/perl – rdddit [212] => dbi, placeholders, and a nested query : r/perl – rrddit [213] => dbi, placeholders, and a nested query : r/perl – r4ddit [214] => dbi, placeholders, and a nested query : r/perl – r3ddit [215] => dbi, placeholders, and a nested query : r/perl – resdit [216] => dbi, placeholders, and a nested query : r/perl – rexdit [217] => dbi, placeholders, and a nested query : r/perl – recdit [218] => dbi, placeholders, and a nested query : r/perl – refdit [219] => dbi, placeholders, and a nested query : r/perl – rerdit [220] => dbi, placeholders, and a nested query : r/perl – reedit [221] => dbi, placeholders, and a nested query : r/perl – redsit [222] => dbi, placeholders, and a nested query : r/perl – redxit [223] => dbi, placeholders, and a nested query : r/perl – redcit [224] => dbi, placeholders, and a nested query : r/perl – redfit [225] => dbi, placeholders, and a nested query : r/perl – redrit [226] => dbi, placeholders, and a nested query : r/perl – redeit [227] => dbi, placeholders, and a nested query : r/perl – reddut [228] => dbi, placeholders, and a nested query : r/perl – reddjt [229] => dbi, placeholders, and a nested query : r/perl – reddkt [230] => dbi, placeholders, and a nested query : r/perl – reddot [231] => dbi, placeholders, and a nested query : r/perl – redd9t [232] => dbi, placeholders, and a nested query : r/perl – redd8t [233] => dbi, placeholders, and a nested query : r/perl – reddir [234] => dbi, placeholders, and a nested query : r/perl – reddif [235] => dbi, placeholders, and a nested query : r/perl – reddig [236] => dbi, placeholders, and a nested query : r/perl – reddiy [237] => dbi, placeholders, and a nested query : r/perl – reddi6 [238] => dbi, placeholders, and a nested query : r/perl – reddi5 ) </h1> </body>