Form Validation Forum :: re: Check unique record from RS

Hi,

I followed your instructions from my last post and was able to put togather this custom trigger.  However it does not work.   could you please look at it and let me know what the problem is.  thank you.

query = "SELECT project_name FROM projects WHERE project_user_id = %d AND project_name = "%s"', Session("kt_login_id"), tNG.getColumnValue("project_name"))
rsCheck = tNG.connection.Execute(query) or die(tNG.connection.ErrorMsg())
if(rsCheck && rsCheck->RecordCount() > 0)
    return new tNG_error('Name already exists!', array(), array())

Set Trigger_Custom = nothing

I am not that good at converting PHP to ASP so if you could please help me I would appreciate it.

Hello,

Try with the attached file which is a modified version of the file you attached.

Regards,
Razvan RACASANU

Hi,

I have tried everything to try to get this script to work.   All I need is to be able to compair a form field called "project_name" to a mysql database query result of a column also named "project_name".   I have played arround with this script for hours and the closet I can get to a working script is what I am attaching now.   I keep getting this error running this script after I hit the submit button.   Wrong_number_of_arguments_or_invalid_property_assignment:_'result.RecordCount',

Please look at what I have and tell me if you can help me.  

thank you

PS

the page you sent me did nothing. all duplicate records were still submitted as if the trigger wasn't even on the page.

Hi,

If you only need to search for the project_name value within the database and don't need a second condition (like project_user_id = session("kt_login_id")) then you don't need a custom trigger, but you will simply use the "Check Unique Key" trigger. This should work fine.

Regards,
Ionut