table test
-----
+-------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| id_1 | char(3) | | | |
|
| id_2 | int(10) unsigned | | | 0 |
|
+-------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
* i want to select max number from table and auto increment it.
* type is integer- first time the table will be empty.when i query (
select max(id_2) from table test) it display the
error bellow.
* type is char- query (select max(id_1 from table test) it can but it stop
at number 9.
runtime error:-
_____________________________________________________
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[MERANT][ODBC MySql driver]Invalid character value. Error in column 1.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (1:1) to (1:42).
Date/Time: Wed Aug 8 15:13:03 2001
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 192.168.0.5
__________________________________________________________
>From: "Chris Bolt" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: RE: integer&char problem
>Date: Wed, 8 Aug 2001 00:15:59 -0600
>
> > i have a problem in query. My field type is integer.
> > The table is empty and i want to select max number from the
> > field but it display error message.Then i try to change the type
> > to char ,it's can but,
> > the max is until 9 only.is there anyone can help me.
>
>What query? What table? What error message? We can't help you if you don't
>give us enough information.
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php