Validate a Encoded Field

E

exulu

New Member
Hi, I'm newer in progress but i have a big trouble, I have progress 9.1e Installed. So I made a web application in C# .NET.

In my database I have just one user created, because I validate it in another table only if the user logged is valid.

But when I tried to connect to the dabase I used the Odbc with this user and all is Ok. The problem is when i try to validate the user logged, because I used the next query:

"select count(*) from pub.myuser a where a.user_id = " + Vuser + " and a.pass = " + vpass.

then the field a.pass is enconded by progress and with this query execute in C# .NET is not working.

Are there another way to validate this user ?

Please I need your help.

Tks
 
Progress KB:

<<
ID: P65004
Goals: Is there an equivalent of the ENCODE function in SQL-92
Fixes: No. There is no such equivalent function in Progress SQL-92.
>>
 
Thanks for you post.

So, If someone have a Idea to release this validate, are welcome your ideas.

I don't know how to do, but I ask to you if exist any form to do a procedure in progress that connect to the database with the unique user and validate the user logged and this procedure get back a value indicating if the user is valid.

This procedure in progress will be execute by another procedure in .net and this one read the value returned by the procedure in progress.

so, if someone can help me, I'll apreciate your help.

thank you.
 
You must log in or register to reply here.
Back
Top