set a mysql user variable per row? -


the following sql statement sets user variable @id i'm using in trailing subquery. problem @id variable gets set first items.id in result set - not "per row" - result subquery same every row in main select. know if there's way reset @id variable each row??

    select          items.id         ,items.title         ,@id := items.id         ,(             select                 group_concat(x.y)                             (                     select                         group_concat(ledger.stockcode) y                                             ledger                                             @id = ledger.itemid                     group                          ledger.stockcode                     having                         sum(ledger.stockqty) > 0                 ) x             ) extras             items             items.id = 196

try query 

select      a.id     ,a.title     ,b.y extras     items inner join     (select        group_concat(ledger.stockcode) y            ledger             ledger.itemid = 196     group        ledger.stockcode     having        sum(ledger.stockqty) > 0) b on     a.id = 196 , a.id = b.itemid

Comments

  1. Blog279993 March 2020 at 09:22

    According to Stanford Medical, It's really the ONLY reason this country's women live 10 years more and weigh an average of 42 lbs less than we do.

    (And actually, it is not related to genetics or some secret-exercise and really, EVERYTHING around "how" they eat.)

    P.S, I said "HOW", and not "what"...

    Click this link to uncover if this easy test can help you find out your real weight loss possibilities

    ReplyDelete
  2. Anonymous1 February 2022 at 13:48

    Casino site is the perfect venue for serious gambler
    Casino site is the perfect venue for serious gambler We are the perfect venue for serious gambler gambler. We are the perfect venue for serious gambler. luckyclub.live We are the

    ReplyDelete

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more