ASP.......................

ASP.......................

Από {ctcp}

loipon exo ftiaksei ena prama san forum ...
olla doulevoun kanonika to provlima mou einai .. oti otan kapios kanei insert stin database ..
den mporo na ta emfaniso sosta ...
paradigma ....

[geia
ti
kaneis]

afti tin frasei tin emfanizei se mia grami ... diladi etsi [geia ti kaneis] opos katalavenete ean einai megalo to keimeno den vgazeis akri...
afto pou 8elo einai na ta emfaniso sosta diladi na ta emfanisei

geia

ti

kaneis

thanks ..

  1. 7/8/2003

    Παράδειγμα κώδικα:
    sQDescription = server.htmlencode(sQDescription)
    sQDescription = replace(sQDescription, chr(13), "<br>")

  1. 8/8/2003

    Alex... den se katalava ... gia kanta ligo pio liana ...
    an to afiso etsi
    <%=(Recordset1.Fields.Item("12").Value)%>

    xoris na valo tipota .. ta vgazei se mia sira ... ti na pros8eso ..
    gia na ta vgazei me <br> ????

  1. 8/8/2003

    post εδω όλο το κώδικα του αρχείου.

  1. 8/8/2003

    <%@LANGUAGE="JAVASCRIPT"%>
    <!--#include file="../Connections/kataxoriseis.asp" -->
    <%
    // *** 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_kataxoriseis_STRING;
    var MM_editTable = "dominion";
    var MM_editRedirectUrl = "forum.asp";
    var MM_fieldsStr = "textfield|value|textarea|value|select|value";
    var MM_columnsStr = "Nick|',none,''|8ema|',none,''|klidei|',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 Recordset1__MMColParam = "1";
    if (String(Request.QueryString("simos")) != "undefined" &&
    String(Request.QueryString("simos")) != "") {
    Recordset1__MMColParam = String(Request.QueryString("simos"));
    }
    %>
    <%
    var Recordset1 = Server.CreateObject("ADODB.Recordset");
    Recordset1.ActiveConnection = MM_kataxoriseis_STRING;
    Recordset1.Source = "SELECT * FROM dominion WHERE klidei LIKE '%"+ Recordset1__MMColParam.replace(/'/g, "''") + "%' ORDER BY Wra DESC";
    Recordset1.CursorType = 0;
    Recordset1.CursorLocation = 2;
    Recordset1.LockType = 1;
    Recordset1.Open();
    var Recordset1_numRows = 0;
    %>
    <%
    var Repeat1__numRows = -1;
    var Repeat1__index = 0;
    Recordset1_numRows += Repeat1__numRows;
    %>
    <%
    // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

    // set the record count
    var Recordset1_total = Recordset1.RecordCount;

    // set the number of rows displayed on this page
    if (Recordset1_numRows < 0) { // if repeat region set to all records
    Recordset1_numRows = Recordset1_total;
    } else if (Recordset1_numRows == 0) { // if no repeat regions
    Recordset1_numRows = 1;
    }

    // set the first and last displayed record
    var Recordset1_first = 1;
    var Recordset1_last = Recordset1_first + Recordset1_numRows - 1;

    // if we have the correct record count, check the other stats
    if (Recordset1_total != -1) {
    Recordset1_numRows = Math.min(Recordset1_numRows, Recordset1_total);
    Recordset1_first = Math.min(Recordset1_first, Recordset1_total);
    Recordset1_last = Math.min(Recordset1_last, Recordset1_total);
    }
    %>
    <%
    // *** Recordset Stats: if we don't know the record count, manually count them

    if (Recordset1_total == -1) {

    // count the total records by iterating through the recordset
    for (Recordset1_total=0; !Recordset1.EOF; Recordset1.MoveNext()) {
    Recordset1_total++;
    }

    // reset the cursor to the beginning
    if (Recordset1.CursorType > 0) {
    if (!Recordset1.BOF) Recordset1.MoveFirst();
    } else {
    Recordset1.Requery();
    }

    // set the number of rows displayed on this page
    if (Recordset1_numRows < 0 || Recordset1_numRows > Recordset1_total) {
    Recordset1_numRows = Recordset1_total;
    }

    // set the first and last displayed record
    Recordset1_last = Math.min(Recordset1_first + Recordset1_numRows - 1, Recordset1_total);
    Recordset1_first = Math.min(Recordset1_first, Recordset1_total);
    }
    %>
    <% var MM_paramName = ""; %>
    <%
    // *** Move To Record and Go To Record: declare variables

    var MM_rs = Recordset1;
    var MM_rsCount = Recordset1_total;
    var MM_size = Recordset1_numRows;
    var MM_uniqueCol = "";
    MM_paramName = "";
    var MM_offset = 0;
    var MM_atTotal = false;
    var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined");
    %>
    <%
    // *** Move To Record: handle 'index' or 'offset' parameter

    if (!MM_paramIsDefined && MM_rsCount != 0) {

    // use index parameter if defined, otherwise use offset parameter
    r = String(Request("index"));
    if (r == "undefined") r = String(Request("offset"));
    if (r && r != "undefined") MM_offset = parseInt(r);

    // if we have a record count, check if we are past the end of the recordset
    if (MM_rsCount != -1) {
    if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last
    if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
    MM_offset = MM_rsCount - (MM_rsCount % MM_size);
    } else {
    MM_offset = MM_rsCount - MM_size;
    }
    }
    }

    // move the cursor to the selected record
    for (var i=0; !MM_rs.EOF && (i < MM_offset || MM_offset == -1); i++) {
    MM_rs.MoveNext();
    }
    if (MM_rs.EOF) MM_offset = i; // set MM_offset to the last possible record
    }
    %>
    <%
    // *** Move To Record: if we dont know the record count, check the display range

    if (MM_rsCount == -1) {

    // walk to the end of the display range for this page
    for (var i=MM_offset; !MM_rs.EOF && (MM_size < 0 || i < MM_offset + MM_size); i++) {
    MM_rs.MoveNext();
    }

    // if we walked off the end of the recordset, set MM_rsCount and MM_size
    if (MM_rs.EOF) {
    MM_rsCount = i;
    if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
    }

    // if we walked off the end, set the offset based on page size
    if (MM_rs.EOF && !MM_paramIsDefined) {
    if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
    MM_offset = MM_rsCount - (MM_rsCount % MM_size);
    } else {
    MM_offset = MM_rsCount - MM_size;
    }
    }

    // reset the cursor to the beginning
    if (MM_rs.CursorType > 0) {
    if (!MM_rs.BOF) MM_rs.MoveFirst();
    } else {
    MM_rs.Requery();
    }

    // move the cursor to the selected record
    for (var i=0; !MM_rs.EOF && i < MM_offset; i++) {
    MM_rs.MoveNext();
    }
    }
    %>
    <%
    // *** Move To Record: update recordset stats

    // set the first and last displayed record
    Recordset1_first = MM_offset + 1;
    Recordset1_last = MM_offset + MM_size;
    if (MM_rsCount != -1) {
    Recordset1_first = Math.min(Recordset1_first, MM_rsCount);
    Recordset1_last = Math.min(Recordset1_last, MM_rsCount);
    }

    // set the boolean used by hide region to check if we are on the last record
    MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount);
    %>
    <%
    // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

    // create the list of parameters which should not be maintained
    var MM_removeList = "&index=";
    if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
    var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone="";

    // add the URL parameters to the MM_keepURL string
    for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
    var nextItem = "&" + items.item().toLowerCase() + "=";
    if (MM_removeList.indexOf(nextItem) == -1) {
    MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
    }
    }

    // add the Form variables to the MM_keepForm string
    for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
    var nextItem = "&" + items.item().toLowerCase() + "=";
    if (MM_removeList.indexOf(nextItem) == -1) {
    MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
    }
    }

    // create the Form + URL string and remove the intial '&' from each of the strings
    MM_keepBoth = MM_keepURL + MM_keepForm;
    if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
    if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
    if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
    %>
    <%
    // *** Move To Record: set the strings for the first, last, next, and previous links

    var MM_moveFirst="",MM_moveLast="",MM_moveNext="",MM_movePrev="";
    var MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves
    var MM_moveParam = "index";

    // if the page has a repeated region, remove 'offset' from the maintained parameters
    if (MM_size > 1) {
    MM_moveParam = "offset";
    if (MM_keepMove.length > 0) {
    params = MM_keepMove.split("&");
    MM_keepMove = "";
    for (var i=0; i < params.length; i++) {
    var nextItem = params[i].substring(0,params[i].indexOf("="));
    if (nextItem.toLowerCase() != MM_moveParam) {
    MM_keepMove += "&" + params[i];
    }
    }
    if (MM_keepMove.length > 0) MM_keepMove = MM_keepMove.substring(1);
    }
    }

    // set the strings for the move to links
    if (MM_keepMove.length > 0) MM_keepMove += "&";
    var urlStr = Request.ServerVariables("URL") + "?" + MM_keepMove + MM_moveParam + "=";
    MM_moveFirst = urlStr + "0";
    MM_moveLast = urlStr + "-1";
    MM_moveNext = urlStr + (MM_offset + MM_size);
    MM_movePrev = urlStr + Math.max(MM_offset - MM_size,0);
    %>
    <body bgcolor="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
    <table width="82%" border="0" align="center">
    <tr>
    <td width="19%" height="214" align="default">&nbsp;</td>
    <td align="default" width="31%">&nbsp;</td>
    <td align="default"> <form name="form1" method="POST" action="<%=MM_editAction%>">
    <p align="left"> <font color="#FFFFFF"><strong>NICK<br>
    </strong></font>
    <input type="text" name="textfield">
    <br>
    <font color="#FFFFFF"><strong>TARGET</strong><br>
    <textarea name="textarea" cols="40" rows="7"></textarea>
    <br>
    <select name="select">
    <option>Dominion</option>
    </select>
    <br>
    <input type="submit" name="Submit" value="Insert">
    </font> </p>
    <input type="hidden" name="MM_insert" value="form1">
    </form>

    </td>
    </tr>
    <% while ((Repeat1__numRows-- != 0) && (!Recordset1.EOF)) { %>
    <tr align="left" valign="top">

    <td><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><%=(Recordset1.Fields.Item("Nick").Value)%></font></td>
    <td><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><%=(Recordset1.Fields.Item("Wra").Value)%><br>
    <%=(Recordset1.Fields.Item("12").Value)%></font> <font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><br>
    </font></td>
    <td><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">&nbsp;</font>

    <table width="100%" border="1">
    <tr>
    <td><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><%=(Recordset1.Fields.Item("8ema").Value)%></font></td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td colspan="3" align="default"> <hr> </td>
    </tr>
    <%
    Repeat1__index++;
    Recordset1.MoveNext();
    }
    %>
    </table>
    <br>
    <%
    Recordset1.Close();
    %>

  1. 4/10/2003

    Auto pou eipe o Alex einai,

    1. Eisageis sthn vash mia metavlhth me keimeno pou exei sumplhrwsei o xrisths sthn forma sou.

    2. h entolh var = replace(sQDescription, chr(13), "<br>") tha antikatasthsei kathe "Enter"(chr(13)) tou xristh me <br>

    3. Kane insert nea metavlith var




   Πίσω στην προηγούμενη σελίδα