| Subject | Re: Multiple select inside procedures and PHP??? |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2005-05-02T08:02:55Z |
Hei John!
use
EXECUTE PROCEDURE SEL_PROC_V_PRESENTASJON ('$useKategori')
with executable procedures returning maximum one row and
SELECT ... FROM SEL_PROC_V_PRESENTASJON ('$useKategori')
with selectable procedures containing SUSPEND and returning 0..many
rows (i.e. use the procedure almost as if it was a table or view).
HTH,
Set
> >$FirmaQuery2 = "EXECUTE PROCEDURE SEL_PROC_V_PRESENTASJONWell, I know nothing about PHP, but in general I think you (should)
> >('$useKategori')";
> >
> >$Result = odbc_do($Connection, $FirmaQuery2); /***** Gives 1 row
> >random ****/
use
EXECUTE PROCEDURE SEL_PROC_V_PRESENTASJON ('$useKategori')
with executable procedures returning maximum one row and
SELECT ... FROM SEL_PROC_V_PRESENTASJON ('$useKategori')
with selectable procedures containing SUSPEND and returning 0..many
rows (i.e. use the procedure almost as if it was a table or view).
HTH,
Set