Search DaniWeb - routines

Stored Routines: Word Filtering Inside the Database 10 Years Ago by Bob Hensley …functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back …have no real way of playing with stored routines! CREATE DATABASE bhdctut_reserved_words; USE bhdctut_reserved_words; CREATE … function makes much more sense. **Stored Routines Tip:** *If you remember anything about procedures… a few very useful Binary Sort routines 12 Years Ago by Morten Brendefu … help regarding many things. Proper implementation of really fast routines for sorting data however is not common. I am… like what I have written. Coincidence may make the routines look like something previously developed by other people. This…, then please make a remark. If you like these routines, then please make a remark. That make me smile … Execute an sql script with routines in jdbc..? 15 Years Ago by prabhurangan … was very much useful to me. However i have my routines(ie. stored procedures and functions) also with the backup.sql… also, Please help me how to handle the condition with routines within the sql script. Regards, Prabhu Comparing Sorting Routines 18 Years Ago by vegaseat … done it before, and have compared a number of sorting routines. The sorting is done on the same random-integer arrays… simple comparison hands down. There are clever combinations of sorting routines that are faster, like the snippet by Narue shown in… Swiffer the Bathroom! Do Your Routines! Flylady Has Joined Twitter! 15 Years Ago by slfisher … automated reminders every day, ranging from morning routines to daily and weekly chores to bedtime routines -- perfect for Twitter. Where, one day… jwSMTP c++ email routines, worked with it? 18 Years Ago by Joncamp Has anybody use the jwSMTP c++ email routines, or do you know of a better freeware email c++ app? Javascript: Passing Forms into Sub-routines 15 Years Ago by DavidB …, etc.)? Is there a limit to how deep into sub-routines a form element can be passed? Access denied executing routines 15 Years Ago by clusher … go. When I uploaded the files and started testing the routines in a reserved area for members, it started giving the… Difference between library routines and class library? 13 Years Ago by ravindranath4u What is the difference between library routines and class library? Re: Interrupt Service Routines 17 Years Ago by mathematician … writing to two different ports, and, correspondingly, two interrupt service routines. A single driver with a single isr would, it seems… Re: Gym routines 12 Years Ago by sergent Gym routines?? This is programming forum :) I wish I could eat a lot of junkfood but my mom makes "healthy" food I really hate. And I am planning to start weight-lifting this summer to get in the high-school team. But the whole year, only physical activities I had was in school's wellness class. Re: Sub-routines 11 Years Ago by tinstaafl If you create a Public Module, any routines or variables declared as public, inside the module, can be accessed from anywhere in your project. Re: Stored Routines: Word Filtering Inside the Database 7 Years Ago by batuzai04123 This is great thanks for the guide!!!! Re: Execute an sql script with routines in jdbc..? 15 Years Ago by Ezzaral It's all right here: [url]http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html[/url] Re: Comparing Sorting Routines 18 Years Ago by bumsfeld I always wondered how qsort was correctly implimented. Re: Comparing Sorting Routines 8 Years Ago by vegaseat If you cannot use "windows.h", you can go with "sys/time.h". Here is an example looking at insertion sort only ... // // main.c // insertion_sort // // insertionSort101.c // time the insertion sort of an array of random integers #include <sys/time.h> #include <stdio.h> #… Re: Access denied executing routines 15 Years Ago by dickersonka The problem is your "public" user most likely does not have permissions to call the insert stored procedures. A lot of times, you may have a separate user for searching or selecting data, than inserting data. Re: Access denied executing routines 15 Years Ago by clusher [QUOTE=dickersonka;680930]The problem is your "public" user most likely does not have permissions to call the insert stored procedures. [/QUOTE] But these are two separate problems. When I call the procedure in the example I do it with a registered and full privileged user (airfapt_clusher), that's why I'm not getting the problem.… Re: Access denied executing routines 15 Years Ago by dickersonka So what problem are you getting now? Re: Access denied executing routines 15 Years Ago by clusher Like I said, when I try to execute a routine (a procedure or function) the error message: Error 1370 : execute command denied to user 'airfapt_clusher'@'localhost' for routine 'airfapt_airfa.inserir_noticia' appears. This happens with the user "airfapt_clusher", which has all privileges in the database. I searched, I googled, I read… Re: Access denied executing routines 15 Years Ago by dickersonka i don't think that user has permissions on it still [code] grant all on airfapt_airfa.* to "airfapt_clusher"@"localhost" identified by "password"; [/code] substitute password with your password Re: Access denied executing routines 15 Years Ago by clusher I'm hosting the site on a shared and payed server, and the administrators use CPanel. I created both the database and the users on CPanel, and I gave GRANT ALL on both 'airfapt_clusher' and 'airfapt_publico'. Just to make sure I went to phpMyAdmin and tried to run a few statements as 'airfapt' user (the login the administrators gave me). I … Re: Access denied executing routines 15 Years Ago by dickersonka on the second grant, use identified by password and also at the end of it, add with grant option after done, use [code] flush privileges; [/code] Re: Javascript: Passing Forms into Sub-routines 15 Years Ago by langsor I don't know what limit might be placed on such a thing ... but I built ([I]can't find my example at the moment[/I]) a little function that creates a new javascript include element in the page header, effectively loading javascript on the fly ([I]I used it for proof of concept loading php values as javascript without ajax[/I])... Try using the … Re: Access denied executing routines 14 Years Ago by webhostuk Hello, I had exactly same problem to work on for a client ..I managed to fix it. Cpanel does not allows user to give execute permission.. the issue can only be fixed by your webhost company having root access. Ask them to go to root phpmyadmin>>your database>> privilages>> under that they will find table with local host ,your … calling public (shared) sub outside usercontrol 14 Years Ago by Phoenix127 … usercontrols: - ucStream which holds the properties and routines of the Stream class They are presented as the…-direction) - ucComponent which holds the properties and routines of the Component class They are presented as the…form subroutine can handle multple usercontrols simultaniously. Some routines of the InpMartix are also Public, so … Tutorial: Handling Dates and Time in Delphi 16 Years Ago by Duoas …API [B]SystemTimeToFileTime[/B] and [B]FileTimeToSystemTime[/B] routines. As usual, Delphi abstracts away pointers for you.…, etc.[/U][/B][/COLOR] Delphi provides various routines to manipulate specific pieces of information in a TDateTime… [B]StrToTime[/B], and [B]StrToDateTime[/B] routines for simplicity. However, they require that you first … creating the text file that a form sends to email 18 Years Ago by ctkr …numbers in [ ]. The following code returns a list of the routines checked in addition to a : (colon) for every routine …]:[394]:[395]:[396]:[398]:[400]:[401]:[402]:[405]:[407] ------------------------------------ Additional Routines or Comments: [visitor_comments] ------------------------------------ The form submited on [%HTTP_REFERER] IP … Please help with the assembly code 17 Years Ago by perpetual_dream …call XMIT_RS232 ;echo character back goto Loop ;Serial routines SER_INIT BSF STATUS, RP0 ;select bank 1 BCF …DECFSZ Delay_Count , f GOTO Bit_Wait RETURN ;Delay routines Long_Delay call Delay255 call Delay255 call Delay255 call Delay255… Can't start the program ..error 16 Years Ago by jamess_jack24 … // return true if list has no elements // routines to put/get items on/off list in order…= newelement; } // return true if list has no elements // routines to put/get items on/off list in order (sorted… newelement; } // return true if list has no elements // routines to put/get items on/off list in order (sorted…