Re: 4 Digit ID with Leading Zeros

Ave, I'm looking into the ZEROFILL option now. Didn't know about it before but it looks promising and probably is my solution. I'll get back. Thanks a ton! On 12/15/05 10:24 AM, "Jim Moseby" <JMoseby@nrbindustries.com> wrote: >> >> What I would have preferred to have is make both the ID in >> mySQL table and >> the filename have the leading zeros. But I'm not sure if >> that's possible. > > > Then, take the suggestion of another respondent to this topic, and have a > look at MySQL's "ZEROFILL" option. I'm not sure if you can use it with an > auto-increment field, but that's my best guess. > > JM Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: rahul@informed-sources.com http://www.informed-sources.com