formfields.com Forum Index formfields.com
FORMfields Forums
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

how to display text values and save as number

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    formfields.com Forum Index -> FG 2.0 - Suggestions/Comments
View previous topic :: View next topic  
Author Message
MartinM



Joined: 30 Jun 2006
Posts: 2

PostPosted: Fri Jun 30, 2006 11:41 am    Post subject: how to display text values and save as number Reply with quote

hi

i got a table in which i have a field "AirlineID" This ID isa numerical value. But now i want to have a form that displays the value as a Text

Air Switzerland = 1
American Blue = 2

How can i do that with my formfields?

Thanks for help

Martin
Back to top
View user's profile Send private message
formfields



Joined: 01 Aug 2005
Posts: 465

PostPosted: Fri Jul 07, 2006 9:53 pm    Post subject: Reply with quote

The easiest way is to reload your form into FORMgen and change the field. This will require wiping out your existing data. If this is a problem, you can use manually edit your form and use a TextField definition (please see the tutorials) and then use PHPMyAdmin to change the target database table attribute to a VARCHAR(x).
Back to top
View user's profile Send private message
MartinM



Joined: 30 Jun 2006
Posts: 2

PostPosted: Mon Jul 10, 2006 10:41 am    Post subject: Reply with quote

thx. found the way. there was anothe person in this forum asking the same for a car database.

cheers
Martin
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    formfields.com Forum Index -> FG 2.0 - Suggestions/Comments All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group