David Litot
|
| Posted: 08/19/2002, 2:37 PM |
|
I'm trying to use JSP and MSQ SQL Server using Jdbc:Odbc. I'm getting 2 types of problems:
- the VARCHAR columns cannot be used in joins unless I change for like
- I found no way to input dates, i'm getting a parsing exception
any hint ?
|
|
|
 |
Sanddy
|
| Posted: 08/19/2002, 10:33 PM |
|
I haven't worked a lot with JSP, so I might be wrong!
But I do have a tip, when you create a Connection in CCS (i.e. if you are using CCS) then you can set the Data Base type over there, always remember to select MS SQL Server there, so that CCS can generate the relevant code specific to your data base server.
|
|
|
|
David Litot
|
| Posted: 08/20/2002, 12:59 AM |
|
THanks for your help. I found a solution to sort the text problem. I downloaded the SQL Server JDBC Driver from MS and it works fine. On top it also supports Unicode datatypes.
For the date problem I solved by setting the format to Short Date and no settings for the DB Format (this to be done for every date field on a form)
|
|
|
|
|
