Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Unique database field inserted, but page is blank

Unique database field inserted, but page is blank

Thread began 6/17/2011 10:34 am by Blikbrein | Last modified 7/11/2011 8:09 am by Jason Byrnes | 1901 views | 7 replies |

6/17/2011 10:34 am | #1 Blikbrein

Unique database field inserted, but page is blank

I'm trying to add validation that searches whether a e-mail already exists when user is registering. When adding added code similar to the wizard's output, I end up with a blank page. I stripped down the server validations behaviour to only include the unique db field validation. I read that the Key value should be 0 from another post, but the SA wizard adds session variable values. Attached screenshot of wizard and page.

Attached Files

registration_requester.php.zip

6/17/2011 10:54 am | #2 Jason ByrnesWebAssist

i think line 14:

php:

$WAFV_Errors .= WAValidateUnique("nrcahub",$nrcahub,$database_nrcahub,"Requesters","RequesterID","int","".((isset($_SESSION["RequesterID"]))?$_SESSION["RequesterID"]:"0")  ."","RequesterID","int","((isset($_POST[\"formEmail\"]))?$_POST[\"formEmail\"]:\"\")",true,1);

should be:

php:

$WAFV_Errors .= WAValidateUnique("nrcahub",$nrcahub,$database_nrcahub,"Requesters","RequesterID","int","".((isset($_SESSION["RequesterID"]))?$_SESSION["RequesterID"]:"0")  ."","RequesterID","int","".((isset($_POST["formEmail"]))?$_POST["formEmail"]:"")."",true,1);

6/17/2011 9:15 pm | #3 Blikbrein

Thanks for the help. Why is the '/' inserted into the code when I use validation toolkit? Is it a bug?

I'm still getting the blank page dispite changing the code. The email field in my db is indexed as unique and without the validation inserted I get the duplicate value error when posting the form with a already existing email inserted.

6/20/2011 8:18 am | #4 Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

7/06/2011 6:01 am | #5 Rune Brynestad

I have exactly the same issue. Have you found a solution?

Regards
Rune

7/06/2011 1:01 pm | #6 Jason ByrnesWebAssist

7/09/2011 8:21 pm | #7 arteydiseno381654

Hello, I am also presenting the same problem

7/11/2011 8:09 am | #8 Jason ByrnesWebAssist

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.