Blog
Developers
Careers
Support
Contact
Gossamer Threads
Solutions
Results
About
Mailing Lists
Resource Centre
Forum
Tools
Home
Who's Online
Tags
Favourites
Login
Forum Search
(
Advanced Search
)
This forum
This category
All forums
for
Home
:
Products
:
Gossamer Links
:
Discussions
:
0 not shown in field
Previous Thread
Next Thread
Print Thread
View Threaded
Nov 29, 2001, 5:41 PM
SvenL
Novice
(31 posts)
Nov 29, 2001, 5:41 PM
Post #1 of 2
Views: 1288
Shortcut
0 not shown in field
Hi,
if I write 03719 in a ZIP field, only 3719 will be shown on the output site. How can I change it?
Nov 29, 2001, 11:23 PM
dearnet
Enthusiast
(907 posts)
Nov 29, 2001, 11:23 PM
Post #2 of 2
Views: 1227
Shortcut
Re: [SvenL] 0 not shown in field
In reply to
Hello!
Change the property or "Attributes" of the field to ZEROFILL.
And further the property should be int(5) for the Zipcode always having five digits, in your case.
If you give int(10) in any field then then five more Zeros will be added automatically by MySQL.
Change it through PhpMyadmin or MySQLMan.
Last
edited
by:
rajani
: Nov 29, 2001, 11:28 PM
Previous Thread
Next Thread
Print Thread
View Threaded