freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Wasson, Tim" <WassonT AT kochind.com>
- To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
- Subject: RE: Results from stored procedure
- Date: Fri, 12 Jan 2001 08:18:07 -0600
Use EXEC, not CALL to hit a stored proc:
like this snippit that I've been doing:
$query = "EXEC DeleteCMSProgram @argProgram='" . $values['LOADPROGRAM'] .
"', @argType='" . $values['TYPE'] . "'";
$junk = mssql_query($query, $sqlcon);
Tim Wasson
> -----Original Message-----
> From: Flavio Jose Fonseca de Souza [SMTP:Flavio AT tc.df.gov.br]
> Sent: Friday,January 12,2001 6:52 AM
> To: TDS Development Group
> Subject: [freetds] Results from stored procedure
>
> I'm using Apache 3.14,PHP 4.01 and FreeTDS (snapshot) in a Linux system to
> access a SQL Server Database 6.5. Now I need to get the results of a
> Stored
> Procedure call, any sugestions?
>
> I tried the statement 'mssql_query("Call
> storedprocedurename(?,?,?)",$db);",
> where the ? are parameters, but it didn't work.
>
> Thanks,
> Flávio
>
>
> ---
> You are currently subscribed to freetds as: [WassonT AT kochind.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
-
Results from stored procedure,
Flavio Jose Fonseca de Souza, 01/12/2001
- <Possible follow-up(s)>
- RE: Results from stored procedure, Wasson, Tim, 01/12/2001
Archive powered by MHonArc 2.6.24.