Daemach
Daemach
+1 - we have clients asking for this now.
It seems like this was brought up and fixed in the past, but I don't remember how, and I can't find the original post... The way around this is to...
I fear that I accidentally attached the file from which I had removed the offending data using the document inspector. https://app.screencast.com/ymcIgDAPSi9N1 Please try this one. [CB8188710A3B4338BE83A4D2FE9F65DF_broken.xlsx](https://github.com/cfsimplicity/spreadsheet-cfml/files/14313310/CB8188710A3B4338BE83A4D2FE9F65DF_broken.xlsx)
Couldn't find the requested file /dist/QMarkdown.umd.min.js in @quasar/quasar-ui-qmarkdown.
CTE worked, thankfully ``` var cte = qb.newQuery() .from("mars_out_hold_sum hs") .join("mars_in_security s", 'hs.security_id', 's.security_id') .where('hs.as_of_date', date) .andwhere('change_shares','',0) .andWhere('user_id', event.getValue('user_id')) .andWhere('batch_name', event.getValue('batch_name')) .andWhere('account_id','',"cash") .when(!isNull(rc.project_name),(q)=>{ q.andWhere('project_name', event.getValue('project_name')) }) .selectRaw("CASE WHEN min(change_shares) <...
FWIW, this is how I get around it now: ``` var aid = qb.newQuery() .from("accounts") .where("portfolioCode", {value: q.portfolioCode,cfsqltype="CF_SQL_VARCHAR"}) .updateOrinsert({ apxPortfolioID: q.PortfolioID, portfolioCode: q.portfolioCode, taxID: q.TaxNumber, bTaxable: (q.TaxStatus == "Taxable"), name:...
It seems like one could still return a qb result object, though it would require adding the key/value to that object. That being said, you're more familiar with what's going...
Something like this may solve this problem. Not sure which dbs support this kind of thing though: https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql
BTW, I envision .into working like .value() or .values(), taking a table name and and options struct.
Sure - here are a couple of spots in the file I currently have open. https://www.screencast.com/t/LYlwr1JQ On Thu, Jul 29, 2021 at 8:29 AM Eric Peterson ***@***.***> wrote: > Can...