| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov> |
| Cc: | jkherr(at)centurytel(dot)net, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: psql dates in Access |
| Date: | 2003-03-23 21:01:35 |
| Message-ID: | 2038.1048453295@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
"Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov> writes:
> When I manually enter the desired dates into the query before saving,=20
> then<BR>> running, it works. When I try any of the above ways to referen=
> ce a=20
> date<BR>> from a form, the query results are always empty.<BR>><BR>&g=
> t;=20
[please turn off MIME encoding in list mail...]
It seems likely to me that the query arriving at the backend is not what
you think it is. I'd suggest turning on query logging (see
postgresql.conf) so that you can see what's really being issued. IIRC,
there are also logging provisions in the ODBC driver, which would give
you an additional view of what's happening.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A Mohan | 2003-03-24 11:26:00 | Storing Binary Data |
| Previous Message | Fred Parkinson | 2003-03-23 20:50:16 | Re: psql dates in Access |