Re: Re[2]: [PHP4BETA] Stored Procedures and ODBC

On 27 Oct 99, at 22:17, Frank R. Gross wrote: Does this help at all? From the odbcjet.hlp file (usually in windows\system: When the Microsoft Access driver is used, procedures can be invoked from the driver by using the SQLExecDirect or SQLPrepare function with the following syntax: {CALL procedure-name [(parameter[,parameter]...)]}. Note that expressions are not supported as parameters to a called procedure. If a procedure name includes a dash, the name must be delimited with backquotes (`). A parameterized query can be called using the previous statement. > SL> Surely you just put together the sql text that calls the procedure and then > SL> execute it as any other sql query? > > SL> Sam > > Hi Sam, > the main benefit of "stored procedures" is that the query string > itself is contained in the db and not in the html/php file. So, if the > structure of the db changes you don't have to update the query string > in the php file. You simply call the stored procedure within the > database. That's the way it works with ASP. > > But how can one execute these "complex stored procedures" using > php...? > <snip> > Regards, > Frank. > > > > -- > PHP 4 Beta > > > > -- > PHP 4 Beta > -------------------------------------------------- Avrum Goodblatt goodblat@sprynet.com (415) 9451368 http://home.sprynet.com/~goodblat