ciao a tutti
ho una pagina di un ecommerce che non funziona a dovere.
quando vado ad inserire la descrizione e i dettagli ho la necessità di scrivere mooolto testo. appena invio il form però mi da errore e non inserisce nulla mentre se il testo è poco inserisce correttamente.
un'altra cosa strana è che firefox mi prende più testo di quanto non faccia ie
esempio se nei dettagli ci sono 1000 caratteri è successo che ff li prenda e ie no. con 5000 caratteri nessun dei due
io utilizzo un database access e i campi in questione sono memo
ho provato ad aumentare i valori scritti in rosso ed in effetti la capacità è aumentata ma ha sempre un limita abbastanza basso
e il codice è questo:
pagina col form
codice:<% validateForm "admin_addproductexec.asp" %> <SCRIPT language=JavaScript> function expandingWindow(website) { var windowprops='width=1,height=1,scrollbars=yes,status=no,resizable=yes,location=no' var heightspeed = 30; var widthspeed = 30; var leftdist = 10; var topdist = 10; var lunghezza = 500; var altezza = 500; if(lunghezza == 0){ lunghezza = window.screen.availWidth; } if(altezza == 0){ altezza = window.screen.availHeight; } if (window.resizeTo&&navigator.userAgent.indexOf("Opera")==-1) { var winwidth = lunghezza; var winheight = altezza; var sizer = window.open("","","left=" + leftdist + ",top=" + topdist +","+ windowprops); for (sizeheight = 1; sizeheight < winheight; sizeheight += heightspeed) sizer.resizeTo("1", sizeheight); for (sizewidth = 1; sizewidth < winwidth; sizewidth += widthspeed) sizer.resizeTo(sizewidth, sizeheight); sizer.location = website; } else window.open(website,'mywindow'); } // --></SCRIPT> <% on error resume next dim mySQL, conntemp, rstemp %> <style type="text/css"> <!-- .Stile1 { font-size: 16px; font-weight: bold; } --> </style> Aggiungi Prodotto <form method="post" name="addProd"> <% validateError %> <table width="957" border="0"> <tr> <th width="122"><div align="left">Codice #</div></th> <td width="735"> <%textbox "sku", "", 16, "textbox"%> </td> </tr> <tr> <th width="122"><div align="left">Descrizione</div></th> <td width="735"> <%validate "description", "required"%> <%textbox "description", "", 50, "textarea"%> </td> </tr> <tr> <th width="122"><div align="left">Dettagli</div></th> <td width="735"> <%validate "details", "required"%> <%textbox "details", "", 50, "textarea"%> </td> </tr> <tr> <th width="122"><div align="left">Prezzo*</div></th> <td width="735"><%response.write pCurrencySign%> <%validate "price", "number"%> <%textbox "price", "0.00", 10, "textbox"%> </td> </tr> <tr> <th width="122"><div align="left">Prezzo Listino**</div></th> <td width="735"><%response.write pCurrencySign%> <%validate "listPrice", "number"%> <%textbox "listPrice", "0.00", 10, "textbox"%> </td> </tr> <tr> <th width="122"><div align="left">BtoB price</div></th> <td width="735"><%response.write pCurrencySign%> <%validate "bToBPrice", "number"%> <%textbox "bToBPrice", "0.00", 10, "textbox"%> </td> </tr> <tr> <th width="122"> <div align="left">Immagine </div></th> <td width="735"> <input type="text" name="imageUrl" value="no-foto.png"> inserire il nome del file compresa l'estensione (ex.: foto.jpg) <span style="font-weight: bold">no-foto.png</span> per non inserire nessuna foto</td> </tr> <tr> <th width="122"><div align="left">Fornitore</div></th> <td width="735"> <% call openDB() mySQL="SELECT * FROM suppliers" set rstemp=conntemp.execute(mySQL) if err.number <> 0 then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("Error in Tiny Admin addproductform: "&Err.Description) end if if rstemp.eof then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("No categories defined") end if %> <select name="idSupplier"> <% do until rstemp.eof pIdSupplier = rstemp("idSupplier") pSupplierName = rstemp("supplierName")%> <option value='<%response.write pIdSupplier%>' selected="selected"><%response.write pSupplierName%></option> <% rstemp.movenext loop %></select> </td> </tr> <tr> <th width="122"><div align="left">Categoria</div></th> <td width="735"> <% ' get leaf categories from db mySQL="SELECT * FROM categories WHERE idcategory>1 AND idcategory NOT IN (SELECT A.idcategory from categories A, categories B WHERE A.idcategory=B.idparentcategory)" set rstemp=conntemp.execute(mySQL) if err.number <> 0 then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("Error addproductform: "&Err.Description) end if if rstemp.eof then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("No defined categories in the store") end if %> <select name="idcategory"> <% do until rstemp.eof pIdCategory = rstemp("idCategory") pCategoryDesc = rstemp("categoryDesc")%> <option value='<%response.write pidCategory%>'><%response.write pCategoryDesc%></option> <% rstemp.movenext loop %> </select> </td> </tr> <tr> <th width="122"><div align="left">Attivo</div></th> <td width="735"> Yes <input type="checkbox" name="active" value="-1" checked > </td> </tr> <tr> <th width="122"><div align="left">Hot Deal</div></th> <td width="735"> Yes <input type="checkbox" name="hotDeal" value="-1" > </td> </tr> <tr> <th width="122"><div align="left">Lista nascosto</div></th> <td width="735"> Yes <input type="checkbox" name="listhidden" value="-1" > </td> </tr> <tr> <th width="122"><div align="left">Dimensioni</div></th> <td width="735"> <%validate "weight", "intNumber"%> <%textbox "weight", "0", 6, "textbox"%> </td> </tr> <tr> <th width="122"><div align="left">Disponibilità</div></th> <td width="735"> <%validate "stock", "intNumber"%> <%textbox "stock", "1", 6, "textbox"%> </td> </tr> <tr> <th width="122" height="25"><div align="left">Opzione A </div></th> <td width="735" height="25">Assignments: <% mySQL="SELECT * FROM optionsGroups" set rstemp=conntemp.execute(mySQL) if Err.number <> 0 then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("Error: "&Err.Description) end if if rstemp.eof then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("No defined optionals for products") end if %> <select name="idOptionGroupA"> <% dim arrOpc(30,2) f=0 do until rstemp.eof pidOptionGroup = rstemp("idOptionGroup") poptionGroupDesc = rstemp("optionGroupDesc") arrOpc(f,0) = pidOptionGroup arrOpc(f,1) = poptionGroupDesc f = f+1 %> <option value='<%response.write pidOptionGroup%>'><%response.write poptionGroupDesc%></option> <% rstemp.movenext loop %> </select> </td> </tr> <tr> <th width="122"><div align="left">Opzione B </div></th> <td width="735"> Assignments: <select name="idOptionGroupB"> <%for g=0 to f-1%> <option value='<%response.write arrOpc(g,0)%>'><%response.write arrOpc(g,1)%></option> <%next%> </select> </td> </tr> <tr> <th width="122"><div align="left"></div></th> <td width="735"></td> </tr> <tr> <th colspan="2"> <div align="left"> <input type="submit" name="Submit" value="Aggiungi"> </div></th> </tr> </table> </form> <p class="Stile1">Carica un'immagine sul server </p> </p> </p> * Prezzo effettivo che si vuole far pagare **Prezzo maggiorato per applicare uno sconto; il sistema calcolerà ("Prezzo Listino" - Prezzo) stampando "Risparmi n €"</p>
e questa è la pagina che esegue l'inserimento
graziecodice:<% on error resume next dim mySQL, conntemp, rstemp ' form parameters pSku = getUserInput(request.querystring("sku"),16) pdescription = getUserInput(request.querystring("description"),5000 ) pdetails = getUserInput(request.querystring("details"),5000 ) pidCategory = getUserInput(request.querystring("idCategory"),4) pprice = getUserInput(request.querystring("price"),16) plistPrice = getUserInput(request.querystring("listPrice"),16) pBToBPrice = getUserInput(request.querystring("bToBPrice"),16) pimageUrl = getUserInput(request.querystring("imageUrl"),50) pIdSupplier = getUserInput(request.querystring("idSupplier"),4) pactive = getUserInput(request.querystring("active"),4) plisthidden = getUserInput(request.querystring("listhidden"),4) photDeal = getUserInput(request.querystring("hotDeal"),4) pweight = getUserInput(request.querystring("weight"),12) pStock = getUserInput(request.querystring("stock"),20) pidOptionGroupA = getUserInput(request.querystring("idOptionGroupA"),3) pidOptionGroupB = getUserInput(request.querystring("idOptionGroupB"),3) if plisthidden<>"-1" then plisthidden="0" end if if photDeal<>"-1" then photDeal="0" end if if pactive<>"-1" then pactive="0" end if call openDb() ' insert product in to db mySQL="INSERT INTO products (sku, description, details, idCategory, price, listPrice, imageUrl, listhidden, weight, stock, active, idSupplier, idOptionGroupA, idOptionGroupB, hotDeal, bToBPrice) VALUES ('" &psku& "','" &pdescription& "','" & pdetails& "'," &pidCategory& "," &pprice& "," &plistPrice& ",'" &pimageUrl& "'," &plisthidden& "," &pweight& "," &pStock& "," &pactive& "," &pIdSupplier& "," &pidOptionGroupA& "," &pidOptionGroupB& "," &photDeal& "," &pBToBPrice& ")" set rstemp=conntemp.execute(mySQL) if err.number <> 0 then response.redirect "admin_supporterror.asp?error="& Server.Urlencode("Error en tiny admin addproductexec: "&Err.Description) end if %> Prodotto Aggiunto </p>
Rispondi quotando
