[plt-scheme] SrPersist and bind-parameter

SQL itself does not. ODBC, ADO and other mechanisms do.

Alex

> -----Original Message-----
> From: ifconfig [mailto:ifconfignslookup at hotmail.com]
> Sent: Thursday, February 19, 2004 12:23 PM
> To: Alex Peake; plt-scheme at list.cs.brown.edu
> Subject: Re: [plt-scheme] SrPersist and bind-parameter
> 
> 
> I didn't know SQL supported that ? sign :)
> ifconfig
> BAGOS
> http://bagos.sourceforge.net
> 
> 
> ----- Original Message ----- 
> From: "Alex Peake" <alex.peake at comac.com>
> To: "ifconfig" <ifconfignslookup at hotmail.com>;
> <plt-scheme at list.cs.brown.edu>
> Sent: Thursday, February 19, 2004 9:40 PM
> Subject: RE: [plt-scheme] SrPersist and bind-parameter
> 
> 
> >   For list-related administrative tasks:
> >   http://list.cs.brown.edu/mailman/listinfo/plt-scheme
> >
> > This is a variable parameter. This is done so you can compile the query
> once, and rebind the
> > variable to different values (usually in a loop). This is typical stuff
> with databases (and so
> > ODBC).
> >
> > And of course this is the part causing the difficulty.
> >
> > Alex
> >
> > > -----Original Message-----
> > > From: ifconfig [mailto:ifconfignslookup at hotmail.com]
> > > Sent: Thursday, February 19, 2004 11:29 AM
> > > To: Alex Peake; plt-scheme at list.cs.brown.edu
> > > Subject: Re: [plt-scheme] SrPersist and bind-parameter
> > >
> > >
> > > Why the "AND rel = ?"?
> > >
> > > ifconfig
> > > BAGOS
> > > http://bagos.sourceforge.net
> > >
> > >
> > > ----- Original Message -----
> > > From: "Alex Peake" <alex.peake at comac.com>
> > > To: <plt-scheme at list.cs.brown.edu>
> > > Sent: Thursday, February 19, 2004 2:12 AM
> > > Subject: [plt-scheme] SrPersist and bind-parameter
> > >
> > >
> > > >   For list-related administrative tasks:
> > > >   http://list.cs.brown.edu/mailman/listinfo/plt-scheme
> > > >
> > > > Could someone please help with this?
> > > >
> > > > (define table-select
> > > >   (string-append
> > > >     "SELECT rel, attr, domain, domlength, domprec, nullable,
> PKCOLSEQNUM
> > > AS pkpos, fkpos, fktable,
> > > > fkattr "
> > > >     " FROM Gen_Schema, syspkconstraints PK"
> > > >     " WHERE Gen_Schema.rel = PK.Name (+)"
> > > >     " AND Gen_Schema.attr = PK.ColName (+)"
> > > >     " AND rel = ?"))
> > > >
> > > > (define tname-buffer (make-buffer '(sql-c-char 18)))
> > > > (define tname-indicator (make-indicator))
> > > > (write-buffer! tname-buffer "INVENTORY")
> > > > (prepare hstmt table-select)
> > > > (bind-parameter hstmt 1 'sql-param-input 'sql-varchar 18 tname-buffer
> > > tname-indicator)
> > > > (sql-execute hstmt)
> > > >
> > > > returns no rows, even though a check of tname-buffer reveals
> "INVENTORY".
> > > The database gets a NULL
> > > > binding - the parameter is empty.
> > > >
> > > >
> > > > and yet with:     " AND rel = 'INVENTORY'"))
> > > >
> > > > I get all the appropriate rows.
> > > >
> > > > I obviously have the process wrong, but cannot find what.
> > > >
> > > > Alex
> > > >
> > > >
> >
> >