On Wed, 30 Jun 1999, Vince Vielhaber wrote:
> > I was looking for a function to return the number of tuples an update
> > returned, but couldn't find anything for libpq++. Any ideas?
>
> Added to my list of stuff to do. As to what else you can do, submit
> patches? :)
> > There is no PgDatabase::exec
> Yep. Guess that should be data.Exec(...
Not sure there is an Exec either :)
I've been making a pile of changes to the PgDatabase class. (Actually I
derived it). One such change is a function to quote a string you're going
to use in SQL. I'm not sure if this belongs in the PgDatabase class, but
if you think so, I'll add it before I submit the tuple count patches.
This allows me to do something like:
String updatesql(form("UPDATE users SET lastrequest='now' WHERE
loginid=%s",dbh->quote(_username).chars()));
cout << dbh->ExecTuplesOk(updatesql);
That is actually the call I needed the update count to ensure it worked...
Here is the routine:
// routine to quote any \ or ' chars in the passed string
// this isn't too efficient, but how much data are we really quoting?
String TDatabase::quote(const char *dirty) { // start with a single quote String clean("'");
const char *strptr=dirty; // escape the string if it contains any ' or \ chars while (*strptr) { if ((*strptr=='\'')
||(*strptr=='\\')) clean+='\\'; clean+=*(strptr++); } // end with a quote clean+="'";
return clean;
}
-Michael
