OTRS mailing lists
Sign In Sign Up
Manage this list Sign In Sign Up

Keyboard Shortcuts

Thread View

  • j: Next unread message
  • k: Previous unread message
  • j a: Jump to all threads
  • j l: Jump to MailingList overview
newer
Anzeigen aller Arbeitesschritte...

Validierung FreeTestFeld (an welche List schicken)

older
Zuordnung von Replys / Follow-Ups

Ukohfink

15 Jan 2007 15 Jan '07
1:27 p.m.

Hallo, ich will ein FreeTextFeld gegen den Inhalt einer externen Datenbank validieren. Folgender Code funktioniert aber nicht: # -- # CustomerMessageNew.dtl - provides HTML form for customer message # Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/ # -- # $Id: CustomerTicketMessage.dtl,v 1.5 2006/10/12 10:16:00 martin Exp $ # -- # This software comes with ABSOLUTELY NO WARRANTY. For details, see # the enclosed file COPYING for license information (GPL). If you # did not receive this file, see http://www.gnu.org/licenses/gpl.txt. # -- <!-- start form --> <script language="JavaScript" type="text/javascript"> <!-- function findserial($seriennr) { <?php $db = mysql_connect("localhost", "user", "password"); $sqlab = "select seriennr, ipadress, hostname, betreutbis form plus700"; $sqlab .= " where seriennr like '$seriennr' "; $res = mysql_db_query("otrsPlus700", $sqlab); $num = mysql_num_rows($res); echo "$num" if ($num==0) return False; for ($i=0; $i<$num; $i++) { $sn = mysql_result($res, $i, "seriennr"); echo "$sn" document.compose.TicketFreeText1.value = $sn; } mysql_close($db); return True; ?> } function submit_compose() { if (document.compose.Subject.value == "") { alert('$JSText{"A message should have a subject!"}'); document.compose.Subject.focus(); return false; } else if (document.compose.Body.value == "") { alert('$JSText{"A message should have a body!"}'); document.compose.Body.focus(); return false; } else { if findserial(document.compose.TicketFreeText1.value) return true; else return false; } } //--> </script> <table border="0" width="100%" cellspacing="0" cellpadding="3" cols="1"> <tr> <td class="mainhead"> $Env{"Box0"}$Text{"new ticket"}$Env{"Box1"} </td> </tr> <tr> <td class="mainbody"> <br> <table border="0" width="680" align="center" cellspacing="0" cellpadding="4"> <tr> <td colspan="2" class="contenthead">$Text{"Options"}</td> </tr> <tr> <td class="contentbody">

<input type="hidden" name="Subaction" value="StoreNew"> <table border="0"> <tr> <td width="15%" class="contentkey">$Text{"To"}:</td> <td width="85%" class="contentvalue">$Data{"ToStrg"}</td> </tr> <tr> <td class="contentkey">$Text{"Subject"}:</td> <td class="contentvalue"><font color="red" size="-2">$Text{"$Data{"Subject invalid"}"}</font></td> </tr> <tr> <td class="contentkey">$Text{"Text"}:</td> <td class="contentvalue">