Search DaniWeb - stored-procedure

Integrating OpenAI Web Search API in LangGraph 18 Hours Ago by usmanmalik57 … such as databases, APIs, and the Internet. To simplify this procedure, OpenAI has introduced a [Web Search API](https://platform.openai… and generates a response using an LLM. The response is stored in the state graph's `ai_msg` attribute. Finally, we define… Re: Stored Procedure 14 Years Ago by abelLazm Stored procedure is a set of SQL statements with an assigned name that's stored in the database in compiled form so that it… Re: Stored procedure or inline querystring? 16 Years Ago by dickersonka Stored procedure would be faster, it is able to take advantage of … of the sql from the web server side. Also a stored procedure is much more maintainable than code, you don't want… stored procedure 14 Years Ago by xxmp I have made this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS find_max; CREATE PROCEDURE find_max (IN type INT,OUT maxx INT) BEGIN SELECT max(…; // DELIMITER; and i want to have this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS add_card; CREATE PROCEDURE add_card (var_member_id INT,var_card_number VARCHAR(16),var_code… Stored Procedure 12 Years Ago by jward50 Hi I am trying to create a stored procedure to list node titles with either a Y or a … coresponding record in another table, I am very new to stored procedures and am not sure how I get the data…, I am not even sure if this stored procedure makes any sense any help appreciated. CREATE PROCEDURE test () BEGIN if exists (select b… Re: stored procedure 14 Years Ago by smantscheff Convert your first procedure to a function which returns the desired value and call it from your 2nd procedure. Apart from that this looks like nonsense to me. What for do you need a stored procedure which does nothing than insert a row into a table? Re: stored procedure 14 Years Ago by smantscheff Study this: [url]http://dev.mysql.com/doc/refman/5.1/en/stored-procedure-syntax.html[/url] Re: stored procedure 14 Years Ago by sunwebsite If you want get the [cart_id + 1], after you inserted your value in your stored procedure better you write [B]SELECT LAST_INSERT_ID() + 1;[/B] Stored procedure 15 Years Ago by jay_412 hey guys,, im newbie to stored procedure,,im using the localhost server now,I would like to ask if where to put the stored procedure in my phpmyadmin?Is it from information schema?or in the tables? Re: Stored procedure 15 Years Ago by jay_412 yeah,, i want to make stored procedure,do you mean that I will code a stored procedure inside the table? Re: Stored procedure 15 Years Ago by darkagn You don't need to "put" your stored procedure somewhere, you create one by executing a [icode]CREATE PROCEDURE[/icode] statement. As cwarn23 mentioned, you will need a database with tables etc for your procedure to be able to do anything. Re: Stored procedure 15 Years Ago by jay_412 thank guys for your help,,but i have now my database and table..so how do i call it (the stored procedure) if there were no stored procedure put,,Will I put it in any platform like notepad? Re: Stored procedure 15 Years Ago by jay_412 actually I understand the tutorial but im still confuse to where do I put this stored procedure?i know how to make stored procedure but where platform should I put it? Stored Procedure 14 Years Ago by gulbano Hey all, Can anybody tell me what is a stored procedure an what is the difference between a stored procedure and trigger? Thanks In Advance Re: Stored Procedure 12 Years Ago by adam_k when you are executing the stored procedure, you declare the variables or directly assign values to input … if it returns errors. If you are only executing your stored procedure from inside an app, try to execute it in the… Stored Procedure 12 Years Ago by sukriti1116 hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@… the error coming is.... Msg 8114, Level 16, State 5, Procedure check_returns, Line 0 Error converting data type varchar to datetime… Re: Stored Procedure 12 Years Ago by sukriti1116 hiii, i am executing the following stored procedure but having errors... create procedure check_returns @salesman varchar(10),@RCV10 int,@RCV09 int,@RCV15 int,@… the error coming is.... Msg 8114, Level 16, State 5, Procedure check_returns, Line 0 Error converting data type varchar to datetime… Re: Stored procedure 15 Years Ago by cwarn23 …,,This thing drives me crazy..I tried to put this stored procedure on the phpmyadmin on the information schema/Routines but it… one long line like the following: [CODE=php]mysql_query('CREATE PROCEDURE productpricing() BEGIN SELECT Avg(columnname) AS priceaverage FROM tablename; END… Re: Stored procedure 15 Years Ago by jay_412 … one long line like the following: [CODE=php]mysql_query('CREATE PROCEDURE productpricing() BEGIN SELECT Avg(columnname) AS priceaverage FROM tablename; END… be on one.[/QUOTE] is it ok to put the stored procedure in the mysql_query()? i thought it will be put on… Re: Stored procedure 15 Years Ago by jay_412 its ok darkagn,,im just confuse,,This thing drives me crazy..I tried to put this stored procedure on the phpmyadmin on the information schema/Routines but it cause error. Re: Stored procedure 15 Years Ago by cwarn23 [QUOTE=jay_412;983307]is it ok to put the stored procedure in the mysql_query()? i thought it will be put on the phpmyadmin,,execpt for the Call productpricing[/QUOTE] I think it can be done both ways as they both do basically the same thing except phpmyadmin uses mutiple lines. Re: Stored procedure 15 Years Ago by jay_412 i will use stored procedure at all Stored Procedure 15 Years Ago by dougancil I've only written one stored procedure in the past and I'm being tasked again to … the bulk insert part. Here's the code: [code]create procedure ImportFiles @FilePath varchar(1000) = 'c:\Transfer\' , @ArchivePath varchar(1000) = 'c… Stored Procedure 14 Years Ago by fadi-ft … my first post i am building a website mostly uses Stored Procedure, but now i am facing a problem such that i… the .vb page this is my SQL SP: [ICODE]ALTER PROCEDURE dbo.plnCs @plan int, @level int AS SELECT p.CNo… Re: Stored Procedure 12 Years Ago by adam_k Does the error appear when executing the stored procedure or when creating it? Also try LastMitch's advise to use `select convert(datetime, @ENTRYDATE,100)` instead of the `exec check_returns....` and let us know if the conversion succeeded. Re: Stored Procedure 14 Years Ago by jbisono look i can give you a loop for that right now, but let me ask you this, why if you want to retrieve all the record where the level goes from 1 to 8, why dont you say and your stored procedure "where level between 1 and 8" and that case you make just one request to the server and get all the record you need. Stored procedure 14 Years Ago by lttleastig He guys when i execute this stored procedure by right clicking on it and press execute then entering … Stored procedure situation 13 Years Ago by sngapoonage … then have to loop though each row and call my stored procedure, passing in the user's id and the 'FilterId' from… each row of the 'Books' table and call my orginal stored procedure on that row. I then need some way to select… only the rows that returned a 1 from my original stored procedure and that would be the result set. Thanks for your… 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 I… 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 …only the first two photos are returned. Stored procedure [CODE] ALTER PROCEDURE dbo.test AS declare @galID int Declare…c Deallocate c RETURN [/CODE] result of executing the stored procedure [ICODE] photo_id photo_name ----------- -------------------------- 244 208500_1850052766985_1110 247 …