2. ASPRunnerPro General questions
  3. 3.1a seems to be broke using logins
This topic is locked

3.1a seems to be broke using logins

 		12/29/2004 08:58:20
ASPRunnerPro General questions
author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=988&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' /> Sergey,

I have become completely depend on your software for doing quick web database applications, my customer's love the look and feel of the applications that it creates, not to mention the time it saves me.
I am sending you this e-mail for your input and help. Something that works in 3.0 is broken in 3.1a. and I would like to stay on schedule to have my projects completed by End of the Year.
I will include a zip file with the Project file and the templates that were created by AspRunner 3.1a and the sql script for the tables I am using. (less one view for employee lookup)
The application I am creating is a Official Check Log for a Bank. It will get it's input form head tellers from different branches. I have tried to set up a login page where it validates the login from a table that has the user Name, User ID, and Password. The UserId will be an INT number that will be used to link the Check Log data to the owner of the record. The Owner of the record can only view and edit their own records. An Admin user should be able to see all records.
Here is the list of problems that I am having.

  1. IN 3.1a when I generate a project, it gives an error that the Images Directory does not exist under the include directory. (I fix this by copying the images directory under the include directory and it seems to work there after, I just can't seem to find in the template why this is happening.
  2. The first time I generated the project, no mater what I entered in as a User Name, and Password, it would come back with an invalid user logon. I re-generated the project, and it seems to work. I am still scratching my head on this one.
  3. When I go to add a record:
  4. The Owner ID does not auto populate from the UserID from the UserFile.
  5. When you fill in the blanks, and save the record you get the SQL error below. The owner ID is listed twice in the save script and generates the error.
    I have two more projects that I wish to use ASP Runner to complete that will both involve having users only view and edit their own records.
    I hope you are having a wonderful holiday, and don't want to disturb it, but I really need your help here. Please let me know what can be done.
    With most regard,
    Michael Smith

    MKS Computing
Sergey Kornilov admin 12/29/2004

Michael,
first of all I would recommend to download and install the latest

ASPRunnerPro update to make sure you are not dealing with bugs that

were fixed lately:

http://www.asprunner.com/files/asprunnerpro31a.exe

I guess this fix missing Images directory issue.
To auto-populate OwnerID just remove this field from the ADD page. You

seeing this field twice because ASPRunnerPro makes an attempt to add

this field to the SQL query automatically.
Sergey Kornilov admin 12/30/2004

Michael,
as far as I understand you use char[...] fields to store usernames and passwords which is incorrect. char[...] fields in SQL Server are always filled up with spaces to match field size.
This means you have to type admin name exactly how it appears in the database preserving extra spaces at the end.
Changing field type to varchar[20] will solve this issue permanently.
PS. Previous version trimmed spaces around username and password which is incorrect.
S
 		StuR 1/5/2005

Sergey,
As you know I had some Login problems. It seems as if its related to the actual string used as a the Username. If I used a capital letter in the string it didn't work. Change it to lower-case and it works. Also, I can't fully confirm, and this is wacky, but if I used a "z" in a string then it didn't work either.
Regards,
Stu