Iniciar sesiónCerrar
Correo:
Contraseña:
Entrar
Recordar sesión en este navegador
Iniciar sesiónIniciar sesiónCrear cuentaCrear cuenta
LWP » Preguntas/Respuestas » Preguntas por Contestar » » Contestar

RESPONDER UNA PREGUNTA

Volver
Agregar una pregunta
Buscar
Si para responder la pregunta, crees necesario enviar un archivo adjunto, puedes hacerlo a traves del correo [email protected]

    Pregunta:  67057 - PROBLEMAS CON TNG_MULTIPLEINSERT
Autor:  Alejandro Baez Perez
tengo problemas con este multipleinsert a ver si alguien me puede ayudar: deseo ingresar esos datos que estan en las columnas a la tabla cert_capa_trab me tira error

Error:
Un error ocurrió mientras se insertaban los registros.

Developer Details:
tNG_multipleInsert error.
An error occurred while inserting the records. (MINS_ERROR)

Aca esta el codigo:

<?php require_once('Connections/connGventas.php'); ?>
<?php

require_once('includes/common/KT_common.php');

require_once('includes/tng/tNG.inc.php');

require_once('includes/nxt/KT_back.php');

$tNGs = new tNG_dispatcher("");

$conn_connGventas = new KT_connection($connGventas, $database_connGventas);

// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("nombre", true, "text", "", "", "", "");
$formValidation->addField("id_cab", true, "text", "", "", "", "");
$formValidation->addField("rut", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);

$ins_cert_capa_trab = new tNG_multipleInsert($conn_connGventas);
$tNGs->addTransaction($ins_cert_capa_trab);
// Register triggers
$ins_cert_capa_trab->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_cert_capa_trab->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_cert_capa_trab->registerTrigger("END", "Trigger_Default_Redirect", 99, "includes/nxt/back.php");
// Add columns
$ins_cert_capa_trab->setTable("cert_capa_trab");
$ins_cert_capa_trab->addColumn("id_trab", "NUMERIC_TYPE", "POST", "id_trab");
$ins_cert_capa_trab->addColumn("nombre", "STRING_TYPE", "POST", "nombre");
$ins_cert_capa_trab->addColumn("rut", "STRING_TYPE", "POST", "rut");
$ins_cert_capa_trab->addColumn("cert_capa_tipo_id_tipo", "NUMERIC_TYPE", "POST", "cert_capa_tipo_id_tipo");
$ins_cert_capa_trab->addColumn("id_cab", "NUMERIC_TYPE", "POST", "id_cab");
$ins_cert_capa_trab->setPrimaryKey("id_trab", "NUMERIC_TYPE");
$ins_cert_capa_trab->setPrimaryKey("cert_capa_tipo_id_tipo", "NUMERIC_TYPE");

// Make an update transaction instance
$upd_cert_capa_trab = new tNG_multipleUpdate($conn_connGventas);
$tNGs->addTransaction($upd_cert_capa_trab);
// Register triggers
$upd_cert_capa_trab->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Update1");
$upd_cert_capa_trab->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$upd_cert_capa_trab->registerTrigger("END", "Trigger_Default_Redirect", 99, "includes/nxt/back.php");

$upd_cert_capa_trab->setTable("cert_capa_trab");
$upd_cert_capa_trab->addColumn("nombre", "STRING_TYPE", "POST", "nombre");
$upd_cert_capa_trab->addColumn("rut", "STRING_TYPE", "POST", "rut");
$upd_cert_capa_trab->addColumn("cert_capa_tipo_id_tipo", "NUMERIC_TYPE", "POST", "cert_capa_tipo_id_tipo");
$upd_cert_capa_trab->addColumn("id_cab", "NUMERIC_TYPE", "POST", "id_cab");
$upd_cert_capa_trab->setPrimaryKey("id_trab", "NUMERIC_TYPE", "GET", "id_trab");

// Make an instance of the transaction object
$del_cert_capa_trab = new tNG_multipleDelete($conn_connGventas);
$tNGs->addTransaction($del_cert_capa_trab);
// Register triggers
$del_cert_capa_trab->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Delete1");
$del_cert_capa_trab->registerTrigger("END", "Trigger_Default_Redirect", 99, "includes/nxt/back.php");
// Add columns
$del_cert_capa_trab->setTable("cert_capa_trab");
$del_cert_capa_trab->setPrimaryKey("id_trab", "NUMERIC_TYPE", "GET", "id_trab");

// Execute all the registered transactions
$tNGs->executeTransactions();

// Get the transaction recordset
$rscert_capa_trab = $tNGs->getRecordset("cert_capa_trab");
$row_rscert_capa_trab = mysql_fetch_assoc($rscert_capa_trab);
$totalRows_rscert_capa_trab = mysql_num_rows($rscert_capa_trab);

$restrict = new tNG_RestrictAccess($conn_connGventas, "");

$restrict->addLevel("0");
$restrict->addLevel("1");
$restrict->addLevel("2");

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>GVentas</title>
<link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
<script src="includes/common/js/base.js" type="text/javascript"></script>
<script src="includes/common/js/utility.js" type="text/javascript"></script>
<script src="includes/skins/style.js" type="text/javascript"></script>
<?php echo $tNGs->displayValidationRules();?>
<script src="includes/nxt/scripts/form.js" type="text/javascript"></script>
<script src="includes/nxt/scripts/form.js.php" type="text/javascript"></script>
<script type="text/javascript">
$NXT_FORM_SETTINGS = {
duplicate_buttons: false,
show_as_grid: true,
merge_down_value: true
}
</script>
</head>

<body>
<table width="70%" border="0" align="center" cellpadding="1" cellspacing="1">
<tr>
<td> 
<?php
echo $tNGs->getErrorMsg();
?>
<div class="KT_tng">
<h1>
<?php
// Show IF Conditional region1
if (@$_GET['nombre'] == "") {
?>
<?php echo NXT_getResource("Insert_FH"); ?>
<?php
// else Conditional region1
} else { ?>
<?php echo NXT_getResource("Update_FH"); ?>
<?php }
// endif Conditional region1
?>
Trabajador </h1>
<div class="KT_tngform">
<form method="post" id="form1" action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>">
<?php $cnt1 = 0; ?>
<?php do { ?>
<?php $cnt1++; ?>
<?php
// Show IF Conditional region1
if (@$totalRows_rscert_capa_trab > 1) {
?>
<h2><?php echo NXT_getResource("Record_FH"); ?> <?php echo $cnt1; ?></h2>
<?php }
// endif Conditional region1
?>
<table cellpadding="2" cellspacing="0" class="KT_tngtable">
<tr>
<td class="KT_th"><label for="nombre_<?php echo $cnt1; ?>">Nombre:</label></td>
<td><input type="text" name="nombre_<?php echo $cnt1; ?>" id="nombre_<?php echo $cnt1; ?>" value="<?php echo KT_escapeAttribute($row_rscert_capa_trab['nombre']); ?>" size="32" maxlength="50" />
<?php echo $tNGs->displayFieldHint("nombre");?> <?php echo $tNGs->displayFieldError("cert_capa_trab", "nombre", $cnt1); ?></td>
</tr>
<tr>
<td class="KT_th"><label for="rut_<?php echo $cnt1; ?>">Rut:</label></td>
<td><input type="text" name="rut_<?php echo $cnt1; ?>" id="rut_<?php echo $cnt1; ?>" value="<?php echo KT_escapeAttribute($row_rscert_capa_trab['rut']); ?>" size="32" maxlength="255" />
<?php echo $tNGs->displayFieldHint("rut");?> <?php echo $tNGs->displayFieldError("cert_capa_trab", "rut", $cnt1); ?></td>
</tr>

<tr>
<td class="KT_th"><label for="cert_capa_tipo_id_tipo_<?php echo $cnt1; ?>">Tipo:</label></td>
<td><input type="text" name="cert_capa_tipo_id_tipo_<?php echo $cnt1; ?>" id="cert_capa_tipo_id_tipo_<?php echo $cnt1; ?>" value="<?php echo KT_escapeAttribute($row_rscert_capa_trab['cert_capa_tipo_id_tipo']); ?>" size="32" maxlength="100" />
<?php echo $tNGs->displayFieldHint("cert_capa_tipo_id_tipo");?> <?php echo $tNGs->displayFieldError("cert_capa_trab", "cert_capa_tipo_id_tipo", $cnt1); ?></td>
</tr>
<tr>
<td class="KT_th"><label for="id_cab_<?php echo $cnt1; ?>">Cabecera:</label></td>
<td><input type="text" name="id_cab_<?php echo $cnt1; ?>" id="id_cab_<?php echo $cnt1; ?>" value="<?php echo KT_escapeAttribute($row_rscert_capa_trab['id_cab']); ?>" size="32" maxlength="20" />
<?php echo $tNGs->displayFieldHint("id_cab");?> <?php echo $tNGs->displayFieldError("cert_capa_trab", "id_cab", $cnt1); ?></td>
</tr>
</table>
<input type="hidden" name="kt_pk_cert_capa_trab<?php echo $cnt1; ?>" class="id_field" value="<?php echo KT_escapeAttribute($row_rscert_capa_trab['kt_pk_cert_capa_trab']); ?>" />
<?php } while ($row_rscert_capa_trab = mysql_fetch_assoc($rscert_capa_trab)); ?>
<div class="KT_bottombuttons">
<div>
<?php
// Show IF Conditional region1
if (@$_GET['nombre'] == "") {
?>
<input type="submit" name="KT_Insert1" id="KT_Insert1" value="<?php echo NXT_getResource("Insert_FB"); ?>" />
<?php
// else Conditional region1
} else { ?>
<input type="submit" name="KT_Update1" value="<?php echo NXT_getResource("Update_FB"); ?>" />
<input type="submit" name="KT_Delete1" value="<?php echo NXT_getResource("Delete_FB"); ?>" onclick="return confirm('<?php echo NXT_getResource("Are you sure?"); ?>');" />
<?php }
// endif Conditional region1
?>
<input type="button" name="KT_Cancel1" value="<?php echo NXT_getResource("Cancel_FB"); ?>" onclick="return UNI_navigateCancel(event, 'includes/nxt/back.php')" />
</div>
</div>
</form>
</div>
<br class="clearfixplain" />
</div>
<p> </p></td>
</tr>
</table>
</body>
</html>


Nombre
Apellidos
Correo
Comentarios