Source language: Translate to:

Formatting Field

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Formatting Field

Postby HackinHoodLogicsTm » Fri Nov 25, 2016 3:56 am

Hi Neobookers.

Please is there a way i could format my database field with ******* to display as password characters because the field contains Password for my users.

I mean this in the Grid Display. For the Textbox it's simple to change that but in the Grid display i don't know how.

I would be glad and appreciate any responds.

Thank you.
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: Formatting Field

Postby Gaev » Fri Nov 25, 2016 8:10 am

HackinHoodLogicsTm:
is there a way i could format my database field with ******* to display as password characters
this in the Grid Display. For the Textbox it's simple to change that but in the Grid display i don't know how.

Why even show the field (column) in the grid if every row-cell in this column is going to show as **** ? ... Hide the field from being displayed in the Grid by using dbpSetColumnOrder (omit the field in question) or dbpSetFieldProperties (set "Visible=No")
User avatar
Gaev
 
Posts: 3718
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Re: Formatting Field

Postby stu » Tue Nov 29, 2016 6:24 am

If your passwords were stored the way they should be getting stored then it shouldn't be a problem to display that string at all. Not like that's a good idea either, just saying.
User avatar
stu
 
Posts: 318
Joined: Wed Aug 07, 2013 11:37 am

Re: Formatting Field

Postby HackinHoodLogicsTm » Thu Dec 01, 2016 3:14 am

Sorry for the Delay.

Thank you guyz...

I already did that (Hiding the column)

but i taught there was a way to display the string as Password characters (*******)

Thanks
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: Formatting Field

Postby Gaev » Thu Dec 01, 2016 6:25 am

HackinHoodLogicsTm:

i taught there was a way to display the string as Password characters (*******)

LOL ... if you really want to "simulate" this ...

1) Create a dummy field (e.g. FakePassword)

2) Populate it each time a record is created or updated ... use the "subroutine" option in dbpOpenTable to force the value of this FakePassword field to be as many stars as the length of the "real password string"

3) Display the column for FakePassword
User avatar
Gaev
 
Posts: 3718
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada

Re: Formatting Field

Postby dpayer » Thu Dec 01, 2016 1:26 pm

HackinHoodLogicsTm wrote:I already did that (Hiding the column)
but i taught there was a way to display the string as Password characters (*******)
Thanks


Hiding something with ****** is a method built into browsers so typed letters can't be seen. Databases store data. You decide how to show the data.

Having said this, there may be a more secure way to keep password information in a database. When a person submits a password at registration, you can use a hash program to create a one way hash (representation) of the password entry. This hash cannot be reverse engineers to get the original password.

When you have someone enter their credentials at login, hash that entry and COMPARE it to the hash you have in your database. If the two match, allow access. This way, you don't store ACTUAL passwords in your database. You store symbols of the password and you compare the generated symbol (hash) of the entered password to that of the stored one.

Much more secure. Here is a NB function that can be used to hash passwords viewtopic.php?t=19229
David Payer
Des Moines, Iowa
USA
User avatar
dpayer
 
Posts: 1380
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest