Stack Overflow
Stack Overflow

Questions tagged [routines]

103 questions
1
vote
1 answer

Procedure that for looks for an id in different table and inserts it if there is no entry for that id

I need to write a procedure in mysql that runs every night and performs the following:- For each 'id' from 'associate' table find if there is an entry in 'status table' for a particular 'department' . If there is an entry then move on to next 'id'…
user3368855
  • 51
  • 4
1
vote
1 answer

phpMyAdmin routines not showing

I have created a database and routines with MySQL Workbench. After I exported the SQL create script, I imported it into the phpMyAdmin, successfully executing 1065 queries, on my localhost XAMPP installation and it works perfectly, routines and all.…
Luís Ferreira
  • 2,458
  • 3
  • 19
  • 27
1
vote
2 answers

MySQL stored login procedure [return tables]

I'm trying to create a simple login for an ASP.net web application where I use MySQL as database and ODBC as a connector. Now I would like to prevent SQL injections by calling MySQL routines instead of application-side SQL. Traditionally, I can run…
Neurodefekt
  • 899
  • 2
  • 10
  • 18
1
vote
1 answer

sql routine to export separate txt files

I have an sql query which is a pricelist that I normally run 18 different times for 18 different clients. I have a @varchar as as declaration and I change the customerID. This then exports a txt flat-file file so then I can convert to Excel and send…
Makdaddy
  • 39
  • 1
  • 1
  • 6
1
vote
1 answer

Logic for Subject Routine maker (PHP)

I am developing a php application to manage routine for subjects and teacher timing for my college. However I cannot get the idea (The Logic) behind the proper time management. The classes are 50 to 100 minutes long and starting from 7 am to 2:30…
monk
  • 4,727
  • 13
  • 45
  • 67
1
vote
4 answers

How to use mock object mimicing a daily routine program?

My program has a daily routine, similar to an alarm clock event. Say, when it's 2pm(The time is the system time in my pc), do something for me. What I want to do is to speed up the testing period(I don't really want to wait 4 days looking at the…
Lily
  • 5,872
  • 19
  • 56
  • 75
0
votes
2 answers

An efficient and sensible Package Specification(ADS) structure in Ada

An abstract data type(ADT) is defined in a package. There must be some operations defined, be able to handle objects of ADT. I think that there is no rule telling us in which order routines of a ADT must be sorted. For example, should be first all…
stardust
  • 343
  • 3
  • 17
0
votes
2 answers

Grails creating routines

Let's say, i have a specific information in the database that needs to be sent for a specific user by email in a specific time of the day. a) How can i create a routine in Grails, which is basically an action that is always running - without being…
recoInrelax
  • 697
  • 2
  • 16
  • 33
0
votes
0 answers

'error:03000086:digital envelope routines::initialization error'

I have created an Nextjs app, when I try to host my app in vercel it shows this error. Error: error:0308010C:digital envelope routines::unsupported at new Hash (node:internal/crypto/hash:67:19) at Object.createHash (node:crypto:130:10) …
Tamil Venthan
  • 1
0
votes
0 answers

OpenSSL Error messages: error:14094438:SSL routines:ssl3_read_bytes:tlsv1

I have face that error when added website on hosting service (infinityfree). Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages: error:14094438:SSL routines:ssl3_read_bytes:tlsv1 alert internal error in…
Hesham
  • 1
  • 2
0
votes
0 answers

Twitchio Pubsub and Routines confusion

I'm trying to create a script that reads each channel point redemption in twitch, alongside a function that runs randomly. Reading through the docs I noticed there is something called Routines, but I have no idea how to implement this. Asynchronous…
tatty fish pickle
  • 1
  • 1
0
votes
1 answer

How do we use Routine Group in MySQL workbench?

Since I can't find a way to add a routine to a diagram, I don't know how to use Routine Group tool.
JatSing
  • 4,857
  • 16
  • 55
  • 65
0
votes
1 answer

How to insert into ARRAY column in BQ stored Proc

I am trying to create BQ routine which takes ARRAY as parameter and insert into table . filename can be NULL too . CREATE OR REPLACE PROCEDURE `##.history`( Job_ID STRING, filename ARRAY , Status STRING ) BEGIN EXECUTE IMMEDIATE…
Mudgal
  • 35
  • 4
0
votes
2 answers

Can we have multiple channels having multiple go routines in golang

Can we have multiple go routines listening to multiple channels facing issuing in printing all the problems. I am not able to print all the numbers how can I improved this piece of code If possible can anyone provide some example as I am…
Mesc
  • 21
  • 1
  • 9
0
votes
0 answers

Duplicates in GoRoutines even though they are called with different querystrings

I am trying to make a GO application that is able to ping multiple adresses at the same time. I have followed multiple tutorials and codeparts and now I have been stuck on this part for some time. I have tried using channels however that did not…
Christiaan
  • 9
  • 1
1 2 3
4
5 6 7