close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Security Assist not showing pages

Thread began 3/24/2010 3:37 am by mike401680 | Last modified 4/15/2010 5:42 pm by Eric Mittman | 1219 views | 9 replies |

mike401680

Security Assist not showing pages

When I set up pages in page manager to be viewed by security level, My pages do not view, the login will navigate to the right page on login accept but the page is totally blank the same goes for every page set to this security level, If I do not set a security level then the pages view ok, this obviously is not what I require as it is not secure. When I replace the non viewing pages with a blank page that has the security code pasted from the pages that will not view, this shows the page correctly on the security level set.

Sign in to reply to this post

Eric Mittman

Normally in php when you get a blank page it is because there is an error occurring on the page somewhere and the error reporting is turned off. To see what the error is on these pages add this code to the top of them:

php:
<?php 

error_reporting
(E_ALL); 
ini_set('display_errors','on'); 
?>



This should let you know why the page is not showing, please post back with the result you get from this and include a copy of the page that is giving you this error and a copy of a blank page that you applied the rule to that is working. I will check on this to see what the problem might be.

Sign in to reply to this post

mike401680

cheers eric but now encryption isn't working

thanks Eric i've found out what the problem was, there was two Security Assist folders one in root and one in admin and both where being called.

I now have a problem with encryption and sha1. the register page will put an encrypted password in the database field (this is also user level managed) but the login doesn't acknowledge the pasword, I have repeatidly created login pages using the sample video files in tutorials/support but for the life of me I can't get the password to redirect to another page it keeps failing.

Mike

Sign in to reply to this post

Eric Mittman

Could you post back with a copy of your register and login page. I will take a look and let you know what I think.

One problem that occurs when using encryption for the password is that on the login page you need to also encrypt the value that the user is entering for the password so that the compare works out correctly.

Another issue that I have seen is that the password column is not defined as a varchar of large enough size. It should have a size of at least 40 to allow for the full length of the sha1 hash.

Sign in to reply to this post

mike401680

SHA1 problems

Hi Eric please see the attached login file. I have checked my database and I have it set up to VarChar 40 already. The registration page manges to put a SHA1 code into the database but I cant get the login to check my input against it.

Also on another note, I've seen my search results do not clear when I go back into the results page when I would expect to see all my data rather than just the results from a previous search i.e data grid page, I have checked the forum and it appears Web Assist automatically saves the result, how do I get rid of this, I want the search result to automattically clear when you navigate out of the search results page.

Mike

Attached Files
Archive.zip
Sign in to reply to this post

Eric Mittman

When you are testing this are you entering a password or are you using the auto login portion? The standard login seems to be setup correctly to me, but the auto login authenticate user server behavior seems incorrect. It looks like you are referencing the username session variable and the posted password. You should instead reference $_COOKIE["AutoLoginUN"] for the username and $_COOKIE["AutoLoginPWD"] for the password.

Other than this I do not see a problem with the current setup. If you continue to have trouble with this please post back with a copy of your db. I do not need to have any records, the structure will do.

As for saving the search query this is done on the DataAssist created results page. On this page you will see a section of code like this:

php:
//save the query in a session variable

  if (1 == 1) {
    $_SESSION["WADbSearch1_1items_Results"]=$WADbSearch1->whereClause;
  }



You session variable name will differ from this example. You can just comment out the line within the if statement with two slashes like this:

php:
//save the query in a session variable

  if (1 == 1) {
    //$_SESSION["WADbSearch1_1items_Results"]=$WADbSearch1->whereClause;
  }



This will make it so the results are not held in a session variable.

Sign in to reply to this post

mike401680

Search and SHA1 Password

Thanks Eric, i've worked out what i've done wrong, I see the permissions for the opening page to 3 but set the login lave to 0 so it wouldn't show.

Thank you also for the search results, it works a treat, just one thing, I'm not sure how to filter my results, say I have to records New England and England when I search on a dropdown menu and select England it will show both New England and England. When I search on the dropdown for New England the results I get is New England which is correct, how do I filter out so only the result that matches exctly the drop down is shown.

Regards Mike

Sign in to reply to this post

Eric Mittman

If your search term is coming from a select menu then you should update the DataAssist Search server behavior for this particular search element and for the comparison set to to = or exact match rather than includes.

Sign in to reply to this post

mike401680

duplicate records in search drop down

I have a dropdown menu lists that are dynamically getting data from a datbase table, the dropdowns show duplicate record names, e.g if there are 10 cars all called Astra, then i get a list of 10 "Astra" what i want is 1 Astra and when you select it it shows all 10 in the results page. How do i get around this!

Mike

Sign in to reply to this post

Eric Mittman

If you would like to consolidate the records you are seeing in the list you should do a group by. When you add a group by clause to your rs it will ensure that the values that are returned are grouped by the column you reference. Here is a link to more info on this SQL statement:

sql_groupby.asp

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...