ak1dnar 1,584
Recognized Expert Top Contributor
There is a Error getting while i am entering records using this jsp file. - <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
-
<%@ include file="../Connections/conn.jsp" %>
-
<%
-
// *** Edit Operations: declare variables
-
-
// set the form action variable
-
String MM_editAction = request.getRequestURI();
-
if (request.getQueryString() != null && request.getQueryString().length() > 0) {
-
String queryString = request.getQueryString();
-
String tempStr = "";
-
for (int i=0; i < queryString.length(); i++) {
-
if (queryString.charAt(i) == '<') tempStr = tempStr + "<";
-
else if (queryString.charAt(i) == '>') tempStr = tempStr + ">";
-
else if (queryString.charAt(i) == '"') tempStr = tempStr + """;
-
else tempStr = tempStr + queryString.charAt(i);
-
}
-
MM_editAction += "?" + tempStr;
-
}
-
-
// connection information
-
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;
-
-
// redirect information
-
String MM_editRedirectUrl = null;
-
-
// query string to execute
-
StringBuffer MM_editQuery = null;
-
-
// boolean to abort record edit
-
boolean MM_abortEdit = false;
-
-
// table information
-
String MM_editTable = null, MM_editColumn = null, MM_recordId = null;
-
-
// form field information
-
String[] MM_fields = null, MM_columns = null;
-
%>
-
<%
-
// *** Insert Record: set variables
-
-
if (request.getParameter("MM_insert") != null && request.getParameter("MM_insert").toString().equals("test_form")) {
-
-
MM_editDriver = MM_conn_DRIVER;
-
MM_editConnection = MM_conn_STRING;
-
MM_editUserName = MM_conn_USERNAME;
-
MM_editPassword = MM_conn_PASSWORD;
-
MM_editTable = "saberlegal_db.projects";
-
MM_editRedirectUrl = "index.jsp";
-
String MM_fieldsStr = "name|value";
-
String MM_columnsStr = "p_name|',none,''";
-
-
// create the MM_fields and MM_columns arrays
-
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|");
-
MM_fields = new String[tokens.countTokens()];
-
for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken();
-
-
tokens = new java.util.StringTokenizer(MM_columnsStr,"|");
-
MM_columns = new String[tokens.countTokens()];
-
for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken();
-
-
// set the form values
-
for (int i=0; i+1 < MM_fields.length; i+=2) {
-
MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):"");
-
}
-
-
// append the query string to the redirect URL
-
if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) {
-
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString();
-
}
-
}
-
%>
-
<%
-
// *** Insert Record: construct a sql insert statement and execute it
-
-
if (request.getParameter("MM_insert") != null) {
-
-
// create the insert sql statement
-
StringBuffer MM_tableValues = new StringBuffer(), MM_dbValues = new StringBuffer();
-
for (int i=0; i+1 < MM_fields.length; i+=2) {
-
String formVal = MM_fields[i+1];
-
String elem;
-
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],",");
-
String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
-
String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
-
String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
-
if (formVal.length() == 0) {
-
formVal = emptyVal;
-
} else {
-
if (altVal.length() != 0) {
-
formVal = altVal;
-
} else if (delim.compareTo("'") == 0) { // escape quotes
-
StringBuffer escQuotes = new StringBuffer(formVal);
-
for (int j=0; j < escQuotes.length(); j++)
-
if (escQuotes.charAt(j) == '\'') escQuotes.insert(j++,'\'');
-
formVal = "'" + escQuotes + "'";
-
} else {
-
formVal = delim + formVal + delim;
-
}
-
}
-
MM_tableValues.append((i!=0)?",":"").append(MM_columns[i]);
-
MM_dbValues.append((i!=0)?",":"").append(formVal);
-
}
-
MM_editQuery = new StringBuffer("insert into " + MM_editTable);
-
MM_editQuery.append(" (").append(MM_tableValues.toString()).append(") values (");
-
MM_editQuery.append(MM_dbValues.toString()).append(")");
-
-
if (!MM_abortEdit) {
-
// finish the sql and execute it
-
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
-
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);
-
PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString());
-
MM_editStatement.executeUpdate();
-
MM_connection.close();
-
-
// redirect with URL parameters
-
if (MM_editRedirectUrl.length() != 0) {
-
response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl));
-
return;
-
}
-
}
-
}
-
%>
-
<!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>Untitled Document</title>
-
</head>
-
-
<body><form action="<%=MM_editAction%>" method="POST" name="test_form">
-
<input name="name" type="text" />
-
<input name="send" type="submit" />
-
<input type="hidden" name="MM_insert" value="test_form">
-
</form>
-
</body>
-
</html>
-
- CREATE TABLE `projects` (
-
`p_id` int(11) NOT NULL auto_increment,
-
`p_name` varchar(50) NOT NULL,
-
`p_desc` varchar(10000) NOT NULL,
-
`p_status` int(1) default '1',
-
`p_start` datetime NOT NULL,
-
`p_end` datetime NOT NULL,
-
PRIMARY KEY (`p_id`)
-
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;
Error is getting here - HTTP Status 500 -
-
-
--------------------------------------------------------------------------------
-
-
type Exception report
-
-
message
-
-
description The server encountered an internal error () that prevented it from fulfilling this request.
-
-
exception
-
-
javax.servlet.ServletException: java.sql.SQLException: Field 'p_desc' doesn't have a default value
-
-
root cause
-
-
java.sql.SQLException: Field 'p_desc' doesn't have a default value
-
-
note The full stack traces of the exception and its root causes are available in the Sun Java System Application Server Platform Edition 9.0_01 logs.
-
-
-
--------------------------------------------------------------------------------
-
-
Sun Java System Application Server Platform Edition 9.0_01
My Connection string is in a Different file.
Please help me to find out this error.
0 2152 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: davidshook |
last post by:
I am a begginer with not too much time on my hand. I do some html
pages with Dreamweaver and with some minor Flash actionscript and I
have a minor ability (with the help of lots of tutorials) to do some
PHP.
I love Dreamweaver MX since it realy simplifies the visual part of the
process of making a page and also help with code typos since it
generates alot of the basic code automatically (for example, I don't
have to know how to write a...
|
by: Thomas Bartkus |
last post by:
The meaning of REPLACE INTO is clear to me.
IF the new record presents new key values, then it is inserted as a new
record.
IF the new record has key values that match a pre-existing record, then
the key violation is ignored and the new record *replaces* the pre-existing
record.
But what about INSERT IGNORE?
Is this a synonym for REPLACE INTO - i.e. it does precisely the same thing?
|
by: Philip Boonzaaier |
last post by:
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums must be UPDATED, if not, they
must be INSERTED.
Logically then, I would like to SELECT * FROM <TABLE>
WHERE ....<Values entered here>, and then IF FOUND
UPDATE <TABLE> SET .... <Values entered here> ELSE
INSERT INTO <TABLE> VALUES <Values...
|
by: Bri |
last post by:
Greetings,
I'm having a very strange problem in an AC97 MDB with ODBC Linked tables
to SQL Server 7. The table has an Identity field and a Timestamp field.
The problem is that when a new record is entered, either from a form or
from the table view of the table, when the record gets saved it
immediately displays #DELETED# in all of the fields. However, if I close
the form or table view and reopen the record has in fact been inserted.
The...
|
by: Shapper |
last post by:
Hello,
I have created 3 functions to insert, update and delete an Access
database record. The Insert and the Delete code are working fine.
The update is not. I checked and my database has all the necessary
records in it when testing it. I get the error "No value given for one
or more required parameters." when I try to update the database.
Can you tell me what am I doing wrong?
| |
by: unwantedspam |
last post by:
Hi All,
Thank you in advance. I am trying to insert into two tables but I am
getting the following error: "You cannot add or change a record because
a related record is required in table..." I am not sure why this is
happening since I am using transactions. Below is the code I am using.
Dim con as OleDbConnection
Dim cmd as OleDbCommand
Dim tran as OleDbTranscation
|
by: rn5a |
last post by:
During registration, users are supposed to enter the following
details: First Name, Last Name, EMail, UserName, Password, Confirm
Password, Address, City, State, Country, Zip & Phone Number. I am
using MS-Access 2000 database table for this app. Note that the
datatype of all the fields mentioned above are Text. Apart from the
above columns, there's another column in the DB table named
'RegDateTime' whose datatype is Date/Time which is...
|
by: guessvic |
last post by:
Hello everyone,
Does anyone know why after using the insert record function that Dreamweaver provides for ASP JavaScript page, then you CANNOT pass the value in the text field inside the form to another page??
Please help.
Vic.
|
by: jmartmem |
last post by:
Greetings,
I have an ASP page that contains a form (form_login) with a Log In User server behavior. I used Dreamweaver CS3 to design the page. What I want to do upon a user's log in is to populate a date stamp in a field (LastLogin) within the user authentication table.
I know how to use hidden fields to write a date stamp to a field on an Update Record or Insert Record form, but I'm not sure how to accomplish the same in this scenario...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |