I have the solution, had to add a begin/end inside the repeat to protect
my original done var and declare another inside the loop.
I'm glad we had this little talk =P
l8r
DELIMITER $$
DROP FUNCTION IF EXISTS `firescope`.`reportWhereClause`$$
CREATE [EMAIL PROTECTED] FUNCTION `reportWhereClause`(R
OK, I know WHY it is returning null, just not WHAT to do about it.
In the inside sql, there is not always a result. So, done becomes 1 and
the repeat exits.
How can I keep from this happening? How could I make another 'done' like
variable that would not get also set to 1 if the inner sql doesn't
Below I have a function with a cursor. I have tested the cursor sql
manually and it is fine, I have put the variables into the sql inside
the cursor loop and it returns data too, BUT, executing this function
returns null even though I know the correct info is available. Am I
missing something obvio
generally no as join conditions do not guarantee
1)the column to be inserted is unique
2)the column is updatable
//Create a View based on 2 tables joined on location+id
CREATE VIEW locations_view AS
SELECT d.department_id, d.department_name, l.location_id, l.city
FROM departments d, location
I have a VIEW that is defined over two base tables. One table is subtype
of another table and it's the VIEW that connects them. Now when I want to
insert into a subtable I have to insert through the VIEW. However I am
getting an error message when I try to insert into a VIEW. I found the
solution t
We have a web server that am using solely as a mysql replication server
right now, so it's not really being used that much. I'd like to use it as a
backup web server as well, but I don't want to mess with the replication
that I've got going on. I believe I've heard that you can install MySQL
I was running the 'perror' command from the bash command line of a Linux
system.
That explains it. This is a Windows server, not Linux.
A column of type text will allow a maximum of 65'535 characters being
stored, but this could be less when a multibyte character set is used.
Not using a mu
Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5
using a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam.
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
SELECT id, host_id, uri_id, profile
FROM activity_profiles
Try show global status like 'com_select';
Donna
"Jim Lyons"
<[EMAIL PROTECTED]
.com
