hello there im in with stored procedures im having this problem....

CREATE PROCEDURE principal AS
SELECT seccion, titulo, texto, imagen, identificador, fecha
FROM smaDB_PP_secciones
WHERE identificador = 'principal' ORDER BY ID DESC

it does not return me anything.....
WHY.......
thanks for your help



Visit my home page
www.cancuncoral.com

Personally, I wouldn't use "principal" as the WHERE clause <i>and</i> the SP name.

P.S.&gt; the site URL is dead?!

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>

Hi Jaime

Totally agree with Chris about your naming convention.

<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle> Do you have a column called 'ID' in the smaDB_PP_secciones table?
<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle> Is the spelling of 'principal' in the identificador field correct?

Lee Diggins - DMXzone Manager

Sharing Knowledge Saves Valuable Time!!!