Search DaniWeb - stored

Integrating OpenAI Web Search API in LangGraph 18 Hours Ago by usmanmalik57 … and generates a response using an LLM. The response is stored in the state graph's `ai_msg` attribute. Finally, we define… Differential Directory, indexing method 3 Weeks Ago by xrjf … disk record where the full key and its data are stored. For instance, if the first key inserted is "John… Re: 💻 What’s the First App You Install on a Fresh Windows Machine? 1 Week Ago by Reverend Jim …. With OneDrive active, anything that goes into My Documents gets stored on C. Not only that, but those files get copied… Re: 💻 What’s the First App You Install on a Fresh Windows Machine? 1 Week Ago by Reverend Jim …. Microsoft is slightly brain dead. Locations for shell folders are stored in the registry. You'd think they'd all be… Re: Differential Directory, indexing method 3 Weeks Ago by rproffitt DiDi appears to be some China based UBER service but then again I can't find a question or much else to discuss here. Re: Differential Directory, indexing method 3 Weeks Ago by xrjf About DiDi DiDi (Differential Directory) was originally developed as part of my thesis project in the early 1990s. The name bears no relation to the more recent Chinese ride-sharing company. At the time, DiDi was a novel approach within its academic context, but a change in legislation unfortunately led to the closure of the school and the … Re: Differential Directory, indexing method 3 Weeks Ago by xrjf For example, as Donald Knuth points out in The Art of Computer Programming, the theoretical lower bound for comparison-based sorting algorithms is K × log₂(N). I developed a very simple method that matches this performance. However, DiDi goes far beyond: its performance is proportional to K × (maximum key length), regardless of the number of … Re: Differential Directory, indexing method 3 Weeks Ago by xrjf As an illustration, consider the theoretical lower bound for comparison-based sorting, as stated by Donald Knuth in The Art of Computer Programming: K × log₂(N). I developed a simple method that matches this limit. For example, to sort the list {2, 5, 7, 1, 4, 3, 8, 6}: Sort pairs: (2, 5) → [1] (1, 7) → [2] (3, 4) → [3] (6, 8) → [4] Merge… Re: Differential Directory, indexing method 3 Weeks Ago by xrjf "Just to clarify a previous mistake: the efficiency should be K × N × log₂(N), not K × log₂(N) as I initially wrote." Re: Differential Directory, indexing method 2 Weeks Ago by xrjf I've just made an update because some records weren't being added properly. The issue was that the form didn't take into account that the register field (in the call to DiDi) is passed by reference. Re: Differential Directory, indexing method 1 Week Ago by xrjf Just a quick update for anyone interested: I have revisited and significantly improved the code, aiming for a more professional structure and better performance. The updated version avoids freezing the UI during long operations and follows more robust programming practices. If you’d like to see DiDi in action, there is also a video … Re: Question/Answering over SQL Data Using LangGraph Framework 1 Month Ago by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. Re: Stored Procedure 14 Years Ago by abelLazm … set of SQL statements with an assigned name that's stored in the database in compiled form so that it can… Re: stored procedure problem 10 Years Ago by jj.dcruz Stored procedures will give you a small performance boost, but mostly … are difficult or impossible to do with a simple query. Stored procedures are great for simplifying access to data for many… Re: Stored procedure or inline querystring? 16 Years Ago by dickersonka Stored procedure would be faster, it is able to take advantage … of the sql from the web server side. Also a stored procedure is much more maintainable than code, you don't… Re: Stored Procedures - Good or Bad? 15 Years Ago by sknake Stored procedures have their advantages and disadvantages like every other technology. … like a maintenance task that is best suited as a stored procedure. You will need to set up an SQL Task… Stored Routines: Word Filtering Inside the Database 11 Years Ago by Bob Hensley …bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide…. Without this we have no real way of playing with stored routines! CREATE DATABASE bhdctut_reserved_words; USE bhdctut_reserved_words; CREATE TABLE reserved_words ( … Stored procedure situation 13 Years Ago by sngapoonage … to loop though each row and call my stored procedure, passing in the user's id and… do it better and faster with a nested stored procedure (if thats possible). So what I …of the 'Books' table and call my orginal stored procedure on that row. I then need some… rows that returned a 1 from my original stored procedure and that would be the result set.… Stored procedure with Dynamic columns? 17 Years Ago by Softmaker …because articles does not have the same fields stored in one static article-table. In tblArticle all… standard information about each article is stored. In tblArticleAttribute all different kind on information for… an article is stored, defines by the templateDefinition table. Expample: Template … Stored Procedure Help Needed. 17 Years Ago by Bern …. Trying to get my head round using stored procedures to manipulate data in a database at…data from my database. I have a simple stored procedure as follows: [ICODE]ALTER PROCEDURE dbo.RBTestSP1…) Dim myCommand As New SqlCommand("Name of stored procedure", myConnection) myCommand.CommandType = CommandType.StoredProcedure… Re: stored procedure in c# 14 Years Ago by JerryShaw …DataGridView[/U] ***hi ... how to create the stored procedure?, and how to call the stored procedure in c# ?.... *** [U]Answer: …and MSDN tutorials on how to create a stored procedure. Calling a stored procedure is done by its name. See … thread. The SqlCommand instance contains the name of the stored procedure to be executed. It is also set to… Stored Procedures in MySQL does not retrieve more than one row 14 Years Ago by Moderns …I get nothing! Please see the simple code below for stored procedure which I add it to phpmyadmin direct: DELIMITER ;;… retrieve more than one value in OUT parameter using stored procedure? using normal query is working okey with me… but unable to do that with stored procedure. Mysql version is 5++, PHP 5 Please advise… Re: Stored procedure situation 13 Years Ago by sngapoonage … only left outer join (creaing views) instead of using nested stored procedure. If you could post structure of your table, then… mention the Filter_p table. It's used by my main stored procedure but won't be needed outside of it Stored Procedure not returning all values 13 Years Ago by barriegrant1 … c Deallocate c RETURN [/CODE] result of executing the stored procedure [ICODE] photo_id photo_name ----------- -------------------------- 244 208500_1850052766985_1110 247 ….DataBind(); //bind items to the listview } [/CODE] The stored procedure is executing but not all items are binding to… Re: Stored procedure situation 13 Years Ago by urtrivedi I think you can do 1/0 using only left outer join (creaing views) instead of using nested stored procedure. If you could post structure of your table, then I could help you to create view for it. Re: Stored procedure situation 13 Years Ago by BitBlt Wow. As far as I can see, there's nothing to tie a user to a filter or a book. You'd better post your stored proc...otherwise we're going to think that your app does some kind of magic to get your result. Re: Stored procedure situation 13 Years Ago by sngapoonage … a filter or a book. You'd better post your stored proc...otherwise we're going to think that your app… Re: Stored procedure situation 13 Years Ago by urtrivedi … create view (remove only where part below), no need of stored procedure [code] select a.id, a.title, a.desc, a… Re: Stored Procedure and Table Problem 10 Years Ago by djjeavons …are currently following. In terms of what is a stored procedure, it is simply a prepared SQL statement … WHERE ID = @IDParameter`. Or you could create a stored procedure such as: CREATE PROCEDURE GetContactByID @ID int AS …sufficient. There is also a potential performance gain with stored procedures as they can be cached, but from … Stored Procedures in Oracle 19 Years Ago by C. Raghuraja … returned the recordset and using. Is it possible to use Stored Procedure and get recordset?. Where SQL Server returns as recordset… any other easy method to use Stored Procedurs. For Saving purpose I was converted into Stored Procedure. Now it is saving fast…