[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
InstantDB: integer or char() error
- To: idb instant db <instantDB@enhydra.org>
- Subject: InstantDB: integer or char() error
- From: Jens Panse <jens.panse@EasternGraphics.com>
- Date: Mon, 12 Feb 2001 14:23:38 +0100
- Reply-To: instantDB@enhydra.org
- Sender: owner-instantDB@enhydra.org
We have to handle different kinds of article numbers (string/char), that
may consist of numbers starting with 0.
But using the following statement (simplified) always leads to trouble.
"SELECT '00002' FROM test" and you will receive "2" not "00002"
This seems to be of the same kind as "SELECT lower("00002") FROM test
AWT-EventQueue-0 java.sql.SQLException: LOWER requires a single
string parameter
java.sql.SQLException: LOWER requires a single string parameter
The string "00002" is never interpreted as a string (or char), how can
one force it to be a string ?
Jens Panse
--
-[ ]-/\-( )---------------------------------------EasternGraphics-------
Jens Panse
http://www.EasternGraphics.com
phone: 03677 678267
private: jens.panse@gmx.de
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|
- Prev by Date: InstantDB: Foreign key problems...
- Next by Date: Re: InstantDB: integer or char() error
- Prev by thread: InstantDB: Foreign key problems...
- Next by thread: Re: InstantDB: integer or char() error
- Index(es):
