Search DaniWeb - stored_proc

Question Answering with YouTube Videos Using RAG in LangChain 1 Week Ago by usmanmalik57 In previous articles, I explained how to use natural language to interact with [PDF documents](https://www.daniweb.com/programming/computer-science/tutorials/541732/paris-olympics-ticket-information-chatbot-with-memory-using-langchain) and [SQL databases](https://www.daniweb.com/programming/computer-science/tutorials/541771/using-natural-language-… Re: Online subission forms not sending emails of submitted info 2 Weeks Ago by david.tigner More problems. I incorporated the coding Biiim provided. Before any changes, after submission, would display the correct (yellow) screen. After code changed, not only will still not send email but screen turns blank white. URL provider, IONOS, told me that the Host is smtp.ionos.com and the Username and password are for an email address associated … Re: Online subission forms not sending emails of submitted info 1 Week Ago by Biiim Hi David, > More problems. I incorporated the coding Biiim provided. Before any changes, after submission, would display the correct (yellow) screen. After code changed, not only will still not send email but screen turns blank white. URL provider, IONOS, told me that the Host is smtp.ionos.com and the Username and password are for an email… PDF Image Table Extractor Web App with Google Gemini Pro and Streamlit 2 Months Ago by usmanmalik57 In my previous article, I explained [how to convert PDF image to CSV using Multimodal Google Gemini Pro](https://www.daniweb.com/programming/computer-science/tutorials/541365/converting-pdf-image-to-csv-using-multimodal-google-gemini-pro). To do so, I wrote a Python script that passes text command to [Google Gemino Pro](https://blog.google/… Claude 3 Opus Vs. Google Gemini Vs. GPT-4 for Zero-Shot Text Classification 1 Month Ago by usmanmalik57 On March 4, 2024, [Anthropic](https://www.anthropic.com/) launched the [Claude 3 family of large language models](https://www.anthropic.com/news/claude-3-family). Anthropic claimed that its Claude 3 Opus model outperforms GPT-4 on various benchmarks. Intrigued by Anthropic's claim, I performed a simple test to compare the performances of Claude … Stored Proc Not Running On ButtonClick 13 Years Ago by dwayned Hi, I am having problems inserting data into a table using a stored procedure. When I click the button to insert the data nothing happens at all. I added a [B]server.transfer[/B] after the insert to see if it was falling over before the end of the query/insert. My code behind the button to insert the data is as follows... [CODE] … Stored Proc 11 Years Ago by iwishimgoodasu I created a stored Proc: Create PRocedure InsertTBL_Supplier ( @SupplierNumber nvarchar(50), @SupplierName nvarchar(50), @Address nvarchar(50), @ContactNumber nvarchar(50), @ContactPerson nvarchar(50) ) AS BEGIN INSERT INTO TBL_Supplier (SupplierNumber, SupplierName , Address,… Stored Procedure Group Invoice records and update accordingly 13 Years Ago by Richard.Randle Hi , I am a Newbie using SQL server and vb.net in VS2010. I am re-writing an exisitng application which is written in an old programming language. I have a table with invoice records waiting to be assigned an invioce number and invoice date. I have two ways of uupdating these records , the first way is the user manually selects which … stored proc in crystal report 12 Years Ago by srm2010 I am getting data from sql 2008 using stored proc in crystal report in vs2008.But when I try to add stored proc in wizard for crystalreport it gives me error.it shows oledb activex designer error. Re: stored proc in crystal report 12 Years Ago by thines01 Does it do that for every stored proc? Does it do that for other pre-defined queries? prblm while converting sql server stored proc to oracle stored proc 15 Years Ago by avtar.sohi Hi all, I m converting stored proc from sql server to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then inserted some data into it by select query over some db table. -- then i have another temp table -- then some recored gets inserted into second temp table by help of first… Re: prblm while converting sql server stored proc to oracle stored proc 15 Years Ago by avtar.sohi Hi all, I m converting stored proc from sql server to oracle. My application call these procedure and got datatable in case of sql server but now client want my applicaiton with oracle, so i m shifting my sql server db to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then … passing and retrieving data from stored proc 9 Years Ago by coder91 Hi, I have a stored procedure that I have to send one parameter to. I then have to use the same stored procedure to display results, I'm not sure how to do this. Basically the system should allow the user to select an item, push a button (which is when I have to send the username to the stored proc, at the same time I have to retrieve data from … Re: prblm while converting sql server stored proc to oracle stored proc 15 Years Ago by avtar.sohi [QUOTE=peter_budo;603452]And what is your question? PS: Just found you made double post, They been moved together.[/QUOTE] my question was how to write that stored proc in oracle? Re: passing and retrieving data from stored proc 9 Years Ago by JorgeM >at the same time I have to retrieve data from this stored proc and display it You need to be more specific regarding how you want to display the results. yssirhc's example shows display the results possibly to a gridview. Maybe you want to build the HTML and display in a placeholder? The code for displaying the results depends on the data … ASP.net/Stored Proc & Login Verification 18 Years Ago by Wendydb22 Here is my [b]Stored Procedure [/b] stored in SQl DB. [code] CREATE PROCEDURE qparmVerifyLogin @First_Name varchar(30), @Last_Name varchar(30), @SSN varchar(9) AS Select First_Name, Last_Name, SSN, ADDRESS1, CITY, STATE, POSTAL, DEPTID, EMPLID FROM PERSONAL_DATA_TBL WHERE First_Name = @First_Name AND Last_Name = @Last_Name AND SSN … Binding Gridview to Stored Proc via LinqToSql 13 Years Ago by MichaelWClark I am trying to bind my gridview to a stored procedure via Linq to SQL but keep getting 'Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.' I know I am supposed to convert the stored Proc .ToList, but this method is not available to me and throws an error (BC30456: 'toList' is not a member of 'Integer').… Re: stored procedure seems to only return last row of result set 12 Years Ago by BitBlt It is because you are assigning a scalar variable as output. If you want to get the whole set, just change your stored proc as follows: [CODE]alter PROCEDURE [dbo].[NISUS_GetEDIDocTypes] @pEntityType int, @pEntityID char(10) AS BEGIN SET NOCOUNT ON; SELECT EDXDOCTYPE FROM [dbo].[EDI_EntityDocCrossref] WHERE (EDXENTITYTYPE = @… stored procedure in c# 14 Years Ago by nitinG123 please quick reply! i have a problem that when a record is in the database table then it returns the [B]monthlyBalance[/B] float value otherwise return 0.0 float value. I am using stored proc for this.please help [B]C# Code[/B] [code] conn.Open(); SqlCommand cmd = new SqlCommand("monthlyFees", conn); cmd… Re: Combination of Stored Procedure and Text Command Type 10 Years Ago by Lethugs I already called a store proc in sql select Statement and as far as I know we include a CommandType.StoredProcedure for it to return a value. how will I add this stored proc in single select statement which now has text as commandType? I tried this codes but nothing works Select Barcode, sp_Get_count From Products and Select Barcode, Exec… Re: Combination of Stored Procedure and Text Command Type 10 Years Ago by Lethugs thanks for the idea however i haven't tried to do the first step, can you please show me example code returning the value of the stored proc then including it in single select statement and make it as a single query. the second option I think would be not ideal since my query will be very long thanks again Re: c# return value from stored procedure 5 Years Ago by RabidDog5150 I have a feeling the problem is in the Stored Proc and not your code. Might be useful to share that Re: Stored procedure situation 12 Years Ago by sngapoonage [QUOTE=BitBlt;1567072]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.[/QUOTE] Haha yeah, boy did I not make that clear. See the value '123' in the value column of Filter_P that is a user id… Re: Stored procedure expects an parameter which was not specified 12 Years Ago by Lusiphur Essentially you're asking it to send a variable that for all intents and purposes does not exist. One option is to try what flexibleres suggested and set a default value so that it is going to send at least NULL to the stored proc. If you want to get more complicated you can set some basic error handling in your page-side script that checks for a … Re: Stored procedure Errors! >< 13 Years Ago by shoestring You are passing in '' as a the @sortfield so the sql that is created in the stored proc has wrong order clause : "ORDER BY [dbo].[PropertyGroup]." The stored proc should check that @sortfield is something sensible before adding the order by. Re: Stored procedure situation 12 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 14 Years Ago by jay_412 its alright,,but one thing would be the disadvantage,,when you make a long stored proc,,it increases the lines of your code Re: stored procedure headbreak:( 12 Years Ago by BitBlt You are not explaining your problem clearly. I can see several problems with your stored procedure code, but until I know what you expect your result to be I can't really suggest anything. I ran your stored proc, and it seemed to properly add unique leave dates for each employee I tested. Is this not correct? Re: Stored Procedure Error 10 Years Ago by pritaeas Do you get this when you run the stored proc in phpMyAdmin (or another client), or when you run it from PHP? Based on [this thread on SO](http://stackoverflow.com/questions/1200193/cant-return-a-result-set-in-the-given-context). Re: Stored Procedure Question 15 Years Ago by LizR Can you post the stored proc contents, and the delphi query