From: | "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za> |
---|---|
To: | "'Dave Page '" <dpage(at)vale-housing(dot)co(dot)uk>, "''pgsql-interfaces(at)postgresql(dot)org' '" <pgsql-interfaces(at)postgreSQL(dot)org> |
Cc: | "''Tim(dot)Teulings(at)materna(dot)de' '" <Tim(dot)Teulings(at)materna(dot)de> |
Subject: | RE: [INTERFACES] Postgres (NT), ODBC and DBTools |
Date: | 1999-11-03 19:26:20 |
Message-ID: | 1BF7C7482189D211B03F00805F8527F748C202@S-NATH-EXCH2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hi, Dave,
You actually can bind variables, but I've only ever seen it done with stored
procs. You may also be able to do it if you prepare the statement.
However, for a straight throw-away query, it seems a little odd.
How does PG handle this anyway?
MikeA
-----Original Message-----
From: Dave Page
To: 'pgsql-interfaces(at)postgresql(dot)org'
Cc: 'Tim(dot)Teulings(at)materna(dot)de'
Sent: 99/11/03 05:21
Subject: RE: [INTERFACES] Postgres (NT), ODBC and DBTools
> -----Original Message-----
> From: Teulings, Tim [mailto:Tim(dot)Teulings(at)materna(dot)de]
> Sent: 03 November 1999 14:34
> To: 'pgsql-interfaces(at)postgresql(dot)org'
> Subject: AW: [INTERFACES] Postgres (NT), ODBC and DBTools
<Snip>
>
> After looking at it again, I'm not sure if it is a problem with the
> colon. The "?" in the statement looks supicious (itis near the
> 'where'
> stated in the error message). AFAIK ODBC does allow binding of
> variables
> (bind variable, bound expresion) and DBTools uses this. Is the "?"
> legal
> at this point (it references the value bound to a variable) or is it
> a
> error?
>
> Perhaps it is a problem with the ODBC driver settings?
I am sure that the ? is the problem. I've never heard of binding
variables
with ODBC, but then I'm not an ODBC expert - I tend to let ADO/DAO deal
with
that side of things!
Perhaps Byron or someone else can provide a definate answer?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
************
From | Date | Subject | |
---|---|---|---|
Next Message | Ken J. Wright | 1999-11-03 19:54:23 | RE: [INTERFACES] Postgres (NT), ODBC and DBTools |
Previous Message | Sean W. Ellis | 1999-11-03 18:30:57 | ODBC from Windows single quotation |