webmaicon
Posts: 9
|
| Posted: 05/06/2009, 6:06 PM |
|
Friends, help meeeeeeee
I everytime use "Stored Procedure"(sql server) in "Grid". Never error or problem, because codecharge generates the parameter in "visual query builder" automatic. 
Now, working using "Stored Procedure" from Mysql 5. And the "visual query builder" not generates automatic. why not generates automatic? 
How me configuration this parameter in "visual query builder" from procedure:
obs.: "id_noticia" is sended for url, "titulo" this "label" in my "grid". 
DELIMITER |
CREATE DEFINER = 'jornalsg'@'%' PROCEDURE `usps_noticia_detalhar`
(
IN `id_noticia` int,
OUT `titulo` varchar(200)
)
BEGIN
SELECT
tn.titulo
FROM
t_noticia tn, t_usuario tu
WHERE
tn.id_usuario = tu.id_usuario and
tn.id_status = 1 and
tn.id_noticia = id_noticia
into titulo;
END|
DELIMITER ;
Sorry, my english. 
thanks....very, very!
using: PHP5 , Mysql 5, code charge 3.: -O
_________________
I am from Brasil and write inglês more ou less.
1. Programming language: php and asp;
2. Database: mysql, oracle and sql server, or any database with instructions sql;
3. erwin, fireworks, flash, flex, code charge, javascript, xml, wap. |
