Questions tagged [multiple-results]

57 questions
270
votes
16 answers

How to assign from a function which returns more than one value?

Still trying to get into the R logic... what is the "best" way to unpack (on LHS) the results from a function returning multiple values? I can't do this apparently: R> functionReturningTwoValues <- function() { return(c(1, 2)) } R>…
mariotomo
  • 9,438
  • 8
  • 47
  • 66
28
votes
1 answer

How can I ignore first results from a function in Lua?

Lua functions can return multiple results : a, b, c = unpack({'one', 'two', 'three'}) If I'm not interested in the third return value, I can choose to ignore it when calling the function : a, b = unpack({'one', 'two', 'three'}) Is there a similar…
Thibault Falise
  • 5,795
  • 2
  • 29
  • 32
10
votes
2 answers

Mysql Trigger Loop for query result with many rows

hi i have a database with many tables and foreign keys like this CREATE TABLE IF NOT EXISTS `articulos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(63) NOT NULL, `contenido` text NOT NULL, `normas_id` int(11) NOT NULL, PRIMARY…
elin3t
  • 1,881
  • 1
  • 24
  • 29
4
votes
1 answer

NHibernate handling mutliple resultsets from a sp call

I'm using a stored procedure to handle search on my site, it includes full text searching, relevance and paging. I also wanted it to return the total number of results that would have been returned, had paging not being there. So I've now got my SP…
Michael Baldry
  • 792
  • 5
  • 19
3
votes
3 answers

SQL Server procedure design to get results and results count in a single call

I have a requirement where I need to pull the top 100 of the data result set and also the count of the records of the total data which satisfy my filtering condition. Thanks, Manoj.
Manoj
  • 61
  • 6
3
votes
2 answers

C# Mysql multiple queries

Im trying to build up a little status-tool. I need to get results of multiple queries (about 4-5). The general connection-setup and 'how-to-read-data' is already done but I cant figure out how the another query executed. Everything I found while…
C4d
  • 3,183
  • 4
  • 29
  • 50
3
votes
1 answer

Lua: Functions with Multiple Returns

For some reason, I'm having issues wrapping my head around the appropriate way to use parameters in a function, and later call for that function and return the correct parameters. If I wanted to use a function to find out the type of shape used. …
Pwrcdr87
  • 935
  • 3
  • 16
  • 36
2
votes
0 answers

power automate return multiple response to virtual agent

I have a power automate flow that is triggered from a chatbot flow (as part of virtual power agent). The data being generated from power automate output is more than 256KB in size. So, my requirement is to split is data into 2 parts and return them…
2
votes
2 answers

How to return 2 values and rounding them? Excel VBA

I am working on a code that should calculate simple foundations, and in order to do that I have to return 2 values with my function -preferably in two different columns. Function FundacaoSimples(b, l, carga) As Variant tensao = Sheets("Tabelas e…
luidkid
  • 23
  • 3
2
votes
2 answers

Multiple results for one field in a joined SQL query

I'm not sure if this is possible from with a SQL query, but I'll give it a go. I'm developing a SharePoint web part in C# that connects to a SQL database and runs a query, then databinds that result set to a gridview. It's working fine, but I have a…
Geo Ego
  • 1,315
  • 7
  • 27
  • 53
1
vote
2 answers

Return Multiple Results in Linq2Sql without a stored procedure?

i would like to return two record sets from a simple database table with one Linq2Sql query. I know how to do it if this was using Linq2Sql calling a stored procedure, but I don't want to use a stored procedure. Is it possible to do it? I've found…
Pure.Krome
  • 84,693
  • 113
  • 396
  • 647
1
vote
1 answer

Coding a multiple responses question using RSTUDIO

Let's say we have this question Why are you not happy? and we have 5 answers (1, 2, 3, 4, 5) s = data.frame(subjects = 1:12, Why_are_you_not_happy = c(1,2,4,5,1,2,4,3,2,1,3,4)) in the previous example every subject picked only one option. but…
Anas116
  • 797
  • 2
  • 9
1
vote
0 answers

APIs are not running in iterations after running a multiple request api

/api/stores triggers an array of different data in postman: #pre-request script var managers= pm.globals.get("managers"); var ref= pm.globals.get("ref"); if(!managers && !ref){ managers=[0,1]; ref=["QA0","QA1"]; } var…
1
vote
1 answer

MySQL lookup based on round(1 + rand() * x) produces NULL and multiple results

I'm trying to select first names from a lookup table at random in MySQL to build a test dataset. I have a table with 200 first names, genders and a row id going from 1 to 200. Something like this: id firstname gender 1 Aaron m 2 Adam…
zoltansn
  • 67
  • 1
  • 12
1
vote
2 answers

if nested condition is met, calculate results not showing results C++

I want the program to display annual raise for years 1,2,3. User enters year user enters annualSalary, then if conditions are true the calculations are below. But when I run it is not showing the calculation for any given year I input. Why? I…
Shruder
  • 5
  • 9
1
2 3 4