PQparamSendQuery, PQparamSendQueryPrepared - Executes an asynchronous paramertized query using the
Contents
Copyright
Copyright (c) 2011 eSilo, LLC. All rights reserved.
This is free software; see the source for copying conditions. There is NO warranty; not even for
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Description
The PQparamSendQuery() and PQparamSendQueryPrepared() functions execute an asynchronous paramertized
query using the parameters in a PGparam. The only difference between these functions is that
PQparamSendQuery() expects a parameterized command string while PQparamSendQueryPrepared() expects a
stmtName previously prepared via PQprepare().
Both functions take a param argument, which must contain the same number of parameters as either the
command string or previously prepared stmtName. Internally, the param is transformed into parallel
arrays that are supplied to a PQsendQueryParams() or PQsendQueryPrepared() call.
The resultFormat argument indicates if text or binary results are desired; a value of zero or one
respectively. PQgetf supports both text and binary result formats, with the exclusion of arrays and
composites which only support binary.
After successfully calling PQparamSendQuery() or PQparamSendQueryPrepared(), call libpq´s PQgetResult()
one or more times to obtain the results.
Examples
UsingPQparamSendQuery
The example uses PQparamSendQuery() to execute a query using a PGparam.
PGparam*param=PQparamCreate(conn);if(!PQputf(param,"%text%int4","ACTIVE",CAT_CAR)){fprintf(stderr,"PQputf:%s\n",PQgeterror());}else{intsuccess=PQparamSendQuery(conn,param,"SELECT*FROMtWHEREstatus=$1ANDcategory=$2",1);if(!success)fprintf(stderr,"PQparamSendQuery:%s\n",PQgeterror());elseget_and_print_results(conn);/*callsPQgetResult()*/}PQparamClear(param);UsingPQparamSendQueryPreparedPQparamSendQueryPrepared() is behaves identically to PQparamSendQuery(), except
PQparamSendQueryPrepared() requires that a statement has been previously prepared via PQprepare(). Also,
a stmtName is supplied rather than a parameterized command string.
Name
PQparamSendQuery, PQparamSendQueryPrepared - Executes an asynchronous paramertized query using the
parameters in a PGparam.
Reporting Bugs
Report bugs to <libpqtypes@esilo.com>.
Return Value
On success, a non-zero value is returned. On error, zero is returned and PQgeterror(3) will contain an
error message.
See Also
PQparamCreate(3), PQgeterror(3), PQparamExec(3), PQparamExecPrepared(3) libpqtypes 2011 PQparamSendQuery(3)
Synopsis
#include<libpqtypes.h>intPQparamSendQuery(PGconn*conn,PGparam*param,constchar*command,intresultFormat);intPQparamSendQueryPrepared(PGconn*conn,PGparam*param,constchar*stmtName,intresultFormat);
