|
|
Joined: Feb 2009
Posts: 53
journeyman
|
journeyman
Joined: Feb 2009
Posts: 53 |
Problem:
Define CUSTOMFIELD as postalcode or telefonnumber input: 06224 output: 6224
|
|
|
|
Joined: Feb 2009
Posts: 53
journeyman
|
journeyman
Joined: Feb 2009
Posts: 53 |
is it possible to change?
Thank Stephan
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
|
|
|
|
Joined: Jun 2006
Posts: 16,302 Likes: 116
|
Joined: Jun 2006
Posts: 16,302 Likes: 116 |
I donno, I'd say it should be a threads "feature" if users really want to prefix data with a 0... lol
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It should be yeah. Will need to do some tests to see why it's chomping off the leading 0, in it shouldn't be.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Found the issue. When the queries are being formatted, we only quote non-integer fields for the query. That ends up chopping off the leading 0 when added to MySQL. So, I've changed the do_placeholder_query() function so it will also quote an integer field if it begins with a 0 so that will preserve the data as it was entered.
|
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
0 members (),
441
guests, and
174
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|