Form Validation Forum :: check unique key from Recordset asp

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
Edward Gilbert
05-07-2007 05:36:11 GMT +2

Hi,

you have me this custom trigger for a php page but now I would like to use it in an asp page could you please look at it and tell me how it should be written.  thank you

$query = sprintf('SELECT project_name FROM projects WHERE project_user_id = %d AND project_name = "%s"', $userId, $tNG->getColumnValue("project_name"));
$rsCheck = $tNG->connection->Execute($query) or die($tNG->connection->ErrorMsg());
if($rsCheck && $rsCheck->RecordCount() > 0) {
    return new tNG_error('Duplicate record!', array(), array());
}
Back | Reply | Quote | Top
Ionut MOICIANU
05-07-2007 18:04:04 GMT +2

Hi Edward,

Please check the Custom Triggers repository page. It should help giving you the needed information on how the code looks for both PHP and ASP.

regards,
Ionut
Reply | Quote | Top
benjamin wende
12-08-2007 21:52:31 GMT +2

Hello


If you want a unique key, use the DB Table Feature Unique key.

bennos

Jobbörse, Stellenmarkt - -  - Ausbildung  - Bewerbung -  Praktikum
Reply | Quote | Top
Messages 1 to 2 from 2
MX Form Validation 3.7.1
© Adobe Systems Romania. All rights reserved.