ED]
Sent: Wednesday, April 14, 2004 7:29 PM
To: [EMAIL PROTECTED]
Subject: Re: two auto-inc fields possible ?
nope i don't think it's possible
BUT you can use the concat feature to get the result:
select concat('NEW-',running_id), concat('DEP-',running_id')
so lo
cool so i create a unique field say ticket_number , then when inserting
concat it to look like NEW-20040414-01 or NEW-01 u reckon ?
> -Original Message-
> From: Terence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 14, 2004 7:29 PM
> To: [EMAIL PROTECTED]
> Subject: R
nope i don't think it's possible
BUT you can use the concat feature to get the result:
select concat('NEW-',running_id), concat('DEP-',running_id')
so long as your running numbers are the same...we use this for our helpdesk
system too :)
good luck.
- Original Message -
From: "electrote