72 Topics

Member Avatar for
Member Avatar for subhashish12

hello i need solution for to create a insert/select/delete/update stored procedure in mysql and how to call them from php currently i am using xampp 1.6.6 version of software thank you

Member Avatar for Adnan_10
0
3K
Member Avatar for iqlas

I have two tables tbl_lang and tbl_unicode as described below: tbl_lang lang_id lang_name lang_code 1 Français fr 2 العربية ar 3 Deutsche ge tbl_unicode ent_id ent_name fr ar ge 1 lbl_username Nom d'utilisateur اسم المستخدم Benutzername 2 lbl_password mot de passe كلمه السر Passwort While displaying in the Datagridview, i …

Member Avatar for AndrisP
0
2K
Member Avatar for Florea

Hy there! I have prestashop 1.4.4.1 and i want to export database clients in CSV through Mysql. I want all the fields possible. Is possible to export their passwords also?I mean MD5. Can you please help me? Best regards, Florea Uwe

Member Avatar for cereal
0
967
Member Avatar for Kenneth_4

Dear All May you kindly help me. I have a windows login form in VB.net. I have a users table in MySQL. How can i use the users table in to login changes made to any table in MySql database. I only have 1 mysql databse user that i use …

Member Avatar for rproffitt
0
564
Member Avatar for bufospro

Hi, I am new in pl/sql programming and I need your help. I would like to make a procedure. To be more specific, I have tables like the folowing TABLE1 ================================================ |COL1 | COL2 | COL3 | COL4 | COL5 | COL6 |COL7| =============================================== |600 | 140 | 2 | …

0
150
Member Avatar for Maideen

Hi. I am Sorry that I don't know how to ask question for my Scenario. Thats why I just used "How to update qty into table2 from table1? " This is the scenario of one of my customer Table-1 Subscription Master(News Paper) - Received Subscription CustCode Name Copies date Agent …

Member Avatar for simplypixie
0
208
Member Avatar for nevek

Hi I have a stored procedure with a cursor which check if a field is filled in after a certain deadline. DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `controleDeadlines`() BEGIN #declaratie variabelen die nodig zijn declare cId int; declare cDeadline text; declare cUitgevoerd date; declare cOpmerking text; declare cStatus text; declare DONE …

Member Avatar for nevek
0
282
Member Avatar for Maideen

Hi I do not know how to sum the one of the column in #table temp table It is my SP SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_Customer_Due_Until_Now] @Code nvarchar(30) AS BEGIN SET NOCOUNT ON; select code as Code, Name as Name, sum(Nett) SINETT into #tableSI …

Member Avatar for ExpertMind
0
2K
Member Avatar for morfious90

I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare …

Member Avatar for pclfw
0
414
Member Avatar for Maideen

Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo pivot (Sum(gross) for [yearno] in ([2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]) )pivotTable pls advice Maideen

Member Avatar for isozworld
0
276
Member Avatar for spowel4

I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change …

Member Avatar for askme_1
0
554
Member Avatar for Maideen

Hi I have database in structure like below Newspaper State1 state2 state3 state4 ABC 1000 5684 5687 246 DEF 879 2547 2578 2357 But I need to the structure like below How can i change this Newspaper State copies ABC State1 1000 ABC State2 5684 ABC State3 5687 ABC State4 …

Member Avatar for kgariando
0
303
Member Avatar for Himanshu Chawla

** Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it is giving error . #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL …

Member Avatar for AleMonteiro
0
332
Member Avatar for Maideen

Hi I did the stored procedure in mssql 2012. working fine in server. I have an issue that I need the output of my SP into HTML Report Format in aspx.page with Sub and Grand Total I no need GridView Pls advice Maideen My SP SET ANSI_NULLS ON GO SET …

Member Avatar for gudegjawa
0
276
Member Avatar for Maideen

Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to …

Member Avatar for hericles
0
1K
Member Avatar for darijan.mekic

0 down vote favorite I have a table: CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`id`) Now i want to create a stored procedure that will insert new column into this table with the next id (which is …

Member Avatar for parijatziw
0
321
Member Avatar for Maideen

Hi. problem in where insert data into table. Using vwd 2012 and Mssql 2012. Insert command is working fine in first record. If add another record, it shows "Procedure or Function has too many argument" I have tried may way, I could not solve. Pls help me. Below is my …

Member Avatar for cxzei
0
288
Member Avatar for nel gomez

Good day, Just want to ask some help, Please! I always encounter "Cannot find Table 0" when i call Stored Procedure in DB2 using VB .Net with Ole DBConnection Provider. Here is my code: Private Sub cmdPost_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPost.Click rsSearch = clsDAOMngr.getConfigParam(2) For …

Member Avatar for Begginnerdev
0
575
Member Avatar for arkulin

I am trying to create stored procedure which will insert one row in the first table and identity of inserted row in other two tables. For some reason I am receiving error "Procedure or function expects parameter '@id', which was not supplied.". My code is as follows: ALTER PROCEDURE InsertProf …

Member Avatar for arkulin
0
379
Member Avatar for Maideen

Error occured: Procedure .. has too many argument specified I have an issue that when i Update the record there is error "Error occured: Procedure .. has too many argument specified". It is my Store procedure SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[web_usp_empData_Update] @id bigint, @Code …

Member Avatar for harsh9
0
266
Member Avatar for Lethugs

Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement? I have a stored procedure that compute available items, it quite a bit long select statement, now i need to call this statement in another select statement which is in text command type, how will …

Member Avatar for ryanjayson
0
459
Member Avatar for MEHMET TURAN

This SP is working well. But when recordcount in dbo.PTSGELEN is over 1000000 approx. it comes timeout error. ALTER PROCEDURE [dbo].[PTS2Tabloya] @KOLETIK nvarchar(40), @SIL tinyint , @EKLENEN int OUT AS BEGIN SET NOCOUNT ON; set @EKLENEN = 0 IF @SIL=0 AND LEN(@KOLETIK)=20 begin INSERT INTO dbo.URUNGIR (GTIN,SN,XD,BN,CLABEL,SLABEL) SELECT GTIN,SN,XD,BN,CLABEL,SLABEL FROM …

Member Avatar for BitBlt
0
177
Member Avatar for logicslab

Dear friends, I am using Wordpress 3.6 . I need to integrate an alert system(to send email notification) to users when a preference value (Reach price of onion 40 $/kg). Is stored procedure can do any thing with it? Please advise how it is feasible. Thanks, Anes

Member Avatar for pritaeas
0
167
Member Avatar for weeraa

I faced to a huge problem when i coding some stored procedure. How to combine some string to sql string in stored procedure??? This is what i did upto now. @WhereCondition = ' WHERE id = 102 ' DECLARE recoredSet CURSOR FOR SELECT SUM(Amount) as AmountSum FROM sale + @WhereCondition …

Member Avatar for C#Jaap
0
222
Member Avatar for riahc3

I currently have $tableName="thenameofthetable"; $someid=$_GET["someidthruget"]; $result = mysql_query("SELECT name,age FROM ". $tableName. " WHERE idp=". $someid); Which looks really insecure. How can I do it using a stored procedure which I think will make it a lot more secure? Thanks

Member Avatar for riahc3
0
634
Member Avatar for baruchM

I have tested out my procedure on my home machine. It woks pretty well I know there is output from the sql. Now I want to try it out on the host. It gives no output. Here is my php code $bob="call seeker($profound)"; if (mysqli_multi_query($conn,$bob)) { echo "<hr>"; echo "<table><th>Section</th><th>Author</th><th>Title</th>"; …

Member Avatar for pritaeas
0
271
Member Avatar for VIPER5646

Hi all I'm trying to write a Procedure to subtract days from a data but Ignoring weekends. This is what I have so far but I have a Syntax error Unexpected END, Expecting `;` I have put a ; after the last END but still get the same error. DELIMITER …

Member Avatar for IIM
0
194
Member Avatar for bazzer14

I would like to know about the following code, could anyone tell me, please? .text:004027A0 sub_4027A0 proc near ; CODE XREF: sub_401010+118-p .text:004027A0 .text:004027A0 var_404 = byte ptr -404h .text:004027A0 .text:004027A0 sub esp, 404h .text:004027A6 lea eax, [esp+404h+var_404] .text:004027A9 push 1 .text:004027AB push eax .text:004027AC call sub_401CC0 .text:004027B1 add esp, …

Member Avatar for bazzer14
0
374
Member Avatar for blenkhn

I don't quite understand how to make a Procedure as most of my processing takes place in my scripts. I have a set of 3 Queries that are almost identical that I would like to combine them to return a result set. The queries are: SELECT Date, Location, Sum(SubTotal) FROM …

Member Avatar for adam_k
0
285
Member Avatar for cucolino

Hi. So, just switched to RAD XE3 to use Metropolis UI feature, and therefore started to completely rearrange and redesign my app to make it a little nicer, only this time I've chosen FireMonkey Metropolis App, since it has some good components, such as TSwitch (slide switch). Everything seems to …

Member Avatar for cucolino
0
453

The End.