Is there an issue with stored procedure and mySQL v5.0.18 ?
We are programming an application that need stored procedures and
triggers and our programmer can't make them work, is it a know issue or
our programmer missed something?
Regards,
Marty 3 1969
Marty,
How are you accessing the database?
Using DBD::mysql seems to have some issues that several people are
trying to find an answer to.
Check in your programming environment for a flag like
CLIENT_MULTI_ST ATEMENTS. I seems that it needs to be set to allow
stored procedures to return multiple items.
I have not other answers, just still trying to get an answer for
dbd::mysql.
Lloyd
--
lbutler
------------------------------------------------------------------------
lbutler's Profile: http://techiegroups.com/member.php?userid=48
View this thread: http://www.techiegroups.com/showthread.php?t=100067
"Marty" <xm******@hotma il.com> wrote in message
news:6acAf.1358 64$OU5.33619@cl grps13... Is there an issue with stored procedure and mySQL v5.0.18 ?
We are programming an application that need stored procedures and triggers and our programmer can't make them work, is it a know issue or our programmer missed something?
I don't know of any issue with stored procedures. I assume they've been
tested pretty thoroughly in My SQL 5.0 beta. Have you searched the MySQL
bug site? http://bugs.mysql.com/
Are you sure you are using MySQL 5.0 for the server?
Perhaps if you give some more details on what specifically he is trying to
do with stored procedures, what is the actual code he is trying to execute,
and what happens that makes you think it is not working? Any error
messages, for example, would be informative.
It's difficult to comment on newsgroup postings such as yours above.
Regards,
Bill K.
Stored procedures work fine here, on both Linux and Win32. There is
huge forum about Stored Procedures on the mysql.com web site: http://forums.mysql.com/
Cheers.
Steve.
Marty wrote: Is there an issue with stored procedure and mySQL v5.0.18 ?
We are programming an application that need stored procedures and triggers and our programmer can't make them work, is it a know issue or our programmer missed something?
Regards, Marty This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Chrisbarbers |
last post by:
--part1_108.256bef7d.2c5af59f_boundary
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
=A0
I have purchased a package that uses ASP and SQL, my webhost provides MYSQL=20
and I have loaded my access database and all seems to be working fine.=20
|
by: slash |
last post by:
Hi ,
Im new to MySql and i have no idea how to convert a sql server user
defined function to MySql. Can any one help me..
CREATE FUNCTION ChildCategories (@categoryId int, @taxId int,
@dummyTaxId int)
RETURNS @retTable TABLE (path varchar(2048),
parent_id int,
category_id int,
|
by: Ben |
last post by:
Dear MySQL experts,
I have a website that is using MS SQL Server 2000 with ASP scripting. I want
to switch over to MySQL, but I'm just sticking my toes in the water at the
moment to see if it makes sense.
One of my favorites things about MS SQL is being able to use the Enterprise
Manager as a GUI in constructing VIEWS that I later turn into stored
procedures. EM makes it super simple to link tables and create a query. It
basically...
|
by: Tony |
last post by:
Can someone a little more clever than I (which means just about anyone
on this list) tell me what the implications/benefits are of this are
please?
http://developers.slashdot.org/developers/03/12/19/1628241.shtml?tid=108&tid=126&tid=137&tid=156&tid=198
Cheers
T.
|
by: Sai Hertz And Control Systems |
last post by:
Dear all,
Their was a huge rore about MySQL recently for something in java functions
now theirs one more
http://www.mysql.com/doc/en/News-5.0.x.html
Does this concern anyone.
What I think is PostgreSQL would have less USP's (Uniqe Selling Points
| |
by: bshumsky06 |
last post by:
Hi,
I am trying to create stored procedures in MySQL. Does anyone have a
suggestion on a good IDE to use. I have been working with the MySQL
Query Browser but it generates errors very often and is shut down by
Windows. When I make changes to my procedure, it doesn't seem to
always change what is being executed. Furthermore, sometimes the
procedure just disappears from my database. I am starting to think
that the stored procedure...
|
by: Radhakrishnans |
last post by:
hai friends
i am new to java and mysql.i have created stored procedures in mysql.Now i want to call that stored procedures in java.All works fine.but it show the following error.
unreported exception java.lang.InstantiationException; must be caught or declared to be thrown
Class.forName ("com.mysql.jdbc.Driver").newInstance();
I need code sample along with connection string.please....
My codings here
CallableStatement proc =...
|
by: eholz1 |
last post by:
Hello PHP group,
Could someone help me out? I have PHP 5.2, Apache 2.0, and MySQL 5.0
running on Linux (Redhat Fedora Core 6).
All that works fine. I would like to be able to "call" a stored
procedure from a PHP program, and
run a stored procedure. I have yet to figure out the proper way to do
this. My stored procedures work fine from the mysql command line
using syntax: "call sp_min_record (101);"
|
by: sathyashrayan |
last post by:
Dear group,
A mysql wrapper class, which just uses the CRUD operations for large scale
php development.
Is the same advisable for the mysql stored procedure? Following is a link I
got from
search http://www.phpclasses.org/browse/package/1615.html. All it does is do
the ADD/EDIT/DELETE/View
in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |