Ciao a tutti,
Come mai pur inserendo un testo in un db correlato dal comando "a capo", in fase di visualizzazione non segue il comando...
Mi spiego meglio...
Io dal form inserisco il testo:
Prova invio di un testo
nel database tramite un form
ma quando lo richiamo dal database mi scrive:
Prova invio di un testo nel database tramite un form
In poche parole non mi considera il comando di "a Capo" (invio)
Come mai?
Il codice del form dal quale inserisco il testo è:
codice:
<%
// *** Edit Operations: declare variables
// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
MM_editAction += "?" + Request.QueryString;
}
// boolean to abort record edit
var MM_abortEdit = false;
// query string to execute
var MM_editQuery = "";
%>
<%
// *** Insert Record: set variables
if (String(Request("MM_insert")) == "form1") {
var MM_editConnection = MM_connessione_STRING;
var MM_editTable = "contenuto_pagine";
var MM_editRedirectUrl = "";
var MM_fieldsStr = "textarea|value";
var MM_columnsStr = "Testo|',none,''";
// create the MM_fields and MM_columns arrays
var MM_fields = MM_fieldsStr.split("|");
var MM_columns = MM_columnsStr.split("|");
// set the form values
for (var i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = String(Request.Form(MM_fields[i]));
}
// append the query string to the redirect URL
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
}
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it
if (String(Request("MM_insert")) != "undefined") {
// create the sql insert statement
var MM_tableValues = "", MM_dbValues = "";
for (var i=0; i+1 < MM_fields.length; i+=2) {
var formVal = MM_fields[i+1];
var MM_typesArray = MM_columns[i+1].split(",");
var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
if (formVal == "" || formVal == "undefined") {
formVal = emptyVal;
} else {
if (altVal != "") {
formVal = altVal;
} else if (delim == "'") { // escape quotes
formVal = "'" + formVal.replace(/'/g,"''") + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i];
MM_dbValues += ((i != 0) ? "," : "") + formVal;
}
MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")";
if (!MM_abortEdit) {
// execute the insert
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();
if (MM_editRedirectUrl) {
Response.Redirect(MM_editRedirectUrl);
}
}
}
%>
<%
var Testo = Server.CreateObject("ADODB.Recordset");
Testo.ActiveConnection = MM_connessione_STRING;
Testo.Source = "SELECT * FROM contenuto_pagine";
Testo.CursorType = 0;
Testo.CursorLocation = 2;
Testo.LockType = 1;
Testo.Open();
var Testo_numRows = 0;
%>
<html>
<head>
<title>Documento senza titolo</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="POST" action="<%=MM_editAction%>">
<textarea name="textarea"></textarea>
<input type="submit" name="Submit" value="Invia">
<input type="hidden" name="MM_insert" value="form1">
</form>
</body>
</html>
<%
Testo.Close();
%>
E poi richiamo il testo con questo codice:
codice:
<%=(pagina.Fields.Item("Testo").Value)%>
Dove sbaglio?
Come devo fare?
Grazie a tutti ciao