Shibboleth Developers

[giacomo tenaglia <>]

On Tue, Jan 15, 2008 at 12:41:26PM -0500, Scott Cantor wrote:
> Well, the problem is that I thought you couldn't just bind a variable
> directly for a long string type. You have to feed the data in a loop. That's
> what didn't work for me. If it's possible to actually just bind the string
> directly, I might not have tried that for some reason.

> > The problems arise because the datatypes
> > (and consequently the ParameterType argument of SQLBindParam) differ
> > from db to db, expecially those related to big text fields and to
> > timestamps/dates. But maybe it's not too difficult to generalize it or
> > to make it ODBC driver-dependant..
> 
> ODBC has a generic way to do this, but I'm pretty sure it's the SQLPutData
> loop.
> 
> My feeling is that *if* the straight insert works, it's better to use it. So
> I believe the complex way should be conditionally compiled or turned on only
> for databases that demand it.

Ok.

Anyway I'm working at it in order to get the ODBC Store working with
Oracle, then I'll send it to the list. It's the first time I'm using the
ODBC API so I'm not sure of what's considered "best practice" in dealing
with these issues, and I was not able to find any meaningful
documentation with examples.

giacomo

-- 
giacomo tenaglia
Technical Student at CERN IT/DES-SIS
CNR Biblioteca d'Area di Bologna - http://biblio.bo.cnr.it
Phone +41 76 5003376 - 
sip: