RE: Strange ODBC issue

2004-05-20 Thread Won Lee
At 16:57 5/20/2004 -0400, you wrote: > > From: Won Lee [mailto:[EMAIL PROTECTED] > > > > What type of DB? > >He answered that in his post > > > >I am using CFQUERY on a text ODBC datasource. > > > What data type is it in the DB? > >It's text, so there are no "data types" Ahh,  you are correct.  I

RE: Strange ODBC issue

2004-05-20 Thread Philip Arnold
> From: Won Lee [mailto:[EMAIL PROTECTED] > > What type of DB? He answered that in his post > >I am using CFQUERY on a text ODBC datasource. > What data type is it in the DB? It's text, so there are no "data types" [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [Us

RE: Strange ODBC issue

2004-05-20 Thread Philip Arnold
> From: stas > > I am using CFQUERY on a text ODBC datasource. One of the > fields is zip code. When a zip contains a dash, as in > 12345-1234, the field is returned as an empty string. What > could be going on? You have to remember a couple of things about the text ODBC driver (it is very sim

Re: Strange ODBC issue

2004-05-20 Thread Won Lee
At 15:46 5/20/2004 -0400, you wrote: >I am using CFQUERY on a text ODBC datasource. One of the fields is zip code. >When a zip contains a dash, as in 12345-1234, the field is returned as an >empty string. What could be going on? What type of DB? What data type is it in the DB? [Todays Threads]

Strange ODBC issue

2004-05-20 Thread stas
I am using CFQUERY on a text ODBC datasource. One of the fields is zip code. When a zip contains a dash, as in 12345-1234, the field is returned as an empty string. What could be going on? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]