Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet invalid cursor state
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Tarunkanti Kar
invalid cursor state
2 Answer(s)      6 years and 3 months ago
Posted in : JSP-Servlet



Advertisement
View Answers

October 16, 2008 at 12:51 PM


hai frnd.
u look at your query and ur while loop code...
dont u feel a typing mismatch?
u r selecting VCHNAME,VCHUNAME,VCHUPWD
but in while loop u r trying to access strUsername=res1.getString("VCHNAME");
here the spelling mistake makes the error

thanks and regards
prashu
prashobvee@gmail.com


October 16, 2008 at 1:04 PM


Hi friend,


I check it the Problem in mismatching of fields in query.

Qry="select VCHNAME,VCHUNAME,VCHUPWD from APARNA.TBL_LIMS_ADMINUSERMASTER where VCHUNAME='"+strUserid.trim()+"' and VCHUPWD='"+strPassword.trim() +"'";


and in While loop

while(res1.next());
{
System.out.println("Inside while");
strUserid1=res1.getString("VCHNAME");
System.out.println("Inside while112");
System.out.println(strUserid1);
strPassword1=res1.getString("VCHUPWD");
System.out.println("Inside while2");
strUsername=res1.getString("VCHNAME");
System.out.println(strUserid1);
}

Do some changes :

strUsername=res1.getString("VCHNAME");

replace "VCHNAME" with "VCHUNAME"


For more information on jdbc visit to :

http://www.roseindia.net/jdbc/

Thanks


Related Tutorials/Questions & Answers:
invalid cursor state - JSP-Servlet
] Invalid cursor state   Hi friend, Please give Database...invalid cursor state  Dear sir here my query is executing properly but i can't able to get the value of strUserid1 in while loop.when I am running
invalid cursor state - JSP-Servlet
invalid cursor state  what is Invalid cursor state in java and how to solve this my code is below   hai frnd. u look at your query and ur while loop code... dont u feel a typing mismatch? u r selecting
Advertisements
invalid configuration
invalid configuration  hello I create hibernate.cfg.xml file Like...#noconfig for more info. **ERROR***org.hibernate.MappingException: invalid...(CreateStudent.java:13) Caused by: org.hibernate.MappingException: invalid
cursor location
cursor location   hi,please how to change cursor location by java code ,i use this code but not change the location JTextArea a=new JtextArea(); if(resultText.equalsIgnoreCase("class")){ a.append("a { \n }"); PointerInfo
hibernate session invalid in jpa
hibernate session invalid in jpa  hibernate session invalid in jpa
invalid class exception
invalid class exception  Wondering why invalid class exception occurs
How to set the cursor to wait?
How to set the cursor to wait?  How to set the cursor to wait
The cursor in scrollable resultset
The cursor in scrollable resultset   How to move the cursor in scrollable resultset
cursor by java code
cursor by java code  hi, please how change cursor location automatically in java code
chown error invalid user
chown error invalid user  I'm getting the following error on buliding the app in XCode. Can anyone explain me why this error occurred?   Error chown: MYDOMAIN\domain users: Invalid argument Command /usr/sbin/chown
State in flex
State in flex  Hi.... just tell me about What is state? what.... Thanks in advance  Ans: State: The State class defines a view state... view states; a base view state with minimal information, and a rich view state
Cursor hiding in jQuery
Cursor hiding in jQuery  Hello sir I want to hide the mouse cursor in entire web page. I heard from one of my friend that it is possible using.... Use the following code given below to hide cursor : $('body').css('cursor
java code for cursor
java code for cursor   hi,please how to change cursor location by java code ,iam use this code but not change the location JTextArea a=new JtextArea(); if(resultText.equalsIgnoreCase("class")){ a.append("a { \n }"); PointerInfo
MySQL Cursor
MySQL Cursor       Here we are going to describe about the MySQL cursor and how to declare, open, fetch and close it. Cursor can be created inside the stored procedures, functions
Invalid console appender in JBoss console
Invalid console appender in JBoss console  "ERROR: invalid console appender config detected, console stream is looping" The above is the error i am getting while starting the server after deploying the ear file into the jboss. I
Changing the Cursor in Java
Changing the Cursor in Java     ... cursor in java. Changing the cursor means showing cursor in many different ... the cursor goes upon it, cursor shape changes to hand shape. If you move the mouse
change cursor on my website - WebSevices
change cursor on my website  i want to change cursor on website. i am..., Code to help in solving the problem : Test function cursor_wait() { document.body.style.cursor = 'wait'; } function cursor_clear
runtime error:Invalid column name
runtime error:Invalid column name  Hello, Can anyone please help me on this query? Programatically it is showing run time error. But in sql query...; } } Console Output: Getting Results! java.sql.SQLException: Invalid column name
Show different types of Cursor
Show different types of Cursor   ... of the cursor. Using SWT we can change the style of cursor, by using the class Cursor of package org.eclipse.swt.graphics. To show the hand cursor, we have
current application cursor - Java Beginners
in which application has the cursor pointer presently). Second
How to get system current cursor type
How to get system current cursor type  In Windows how can i get the current mouse/keyboard cursor type like 'text cursor' from my java application
Help to maintain state of checkbox
Help to maintain state of checkbox  hi, all I want to maintain the state of checkboxes across pages. What happens is when i check one checkbox and then go to say 2nd page then check one checkbox there and when i return
Flex Cursor Manager Example
CursorManager in Flex:- CurserManager provide the full control of the cursor in your flex application. The most important work of the cursor manager.... If the user don't want to use the system cursor then cursor manager
Button hover state
Button hover state  hi........ How do I manually trigger a buttons hover state in flex? please tell me about it.. Thanks   Ans: button.setStyle('skin', button.getStyle('upSkin')); I think it will useful for you
Java window state event
Java window state event  Two java windows, one on top of another... Window at the back is deactivated when the other is on the top. Can iconify when there is only one window using win+d key. In windows, press win+d, window
maintain previoous state on a Jsp
maintain previoous state on a Jsp  i am work on an app where combo box is define in each row of table in a jsp. when i select the specfic color from... the detail of the same id, previous state of colors can be show in a jsp which i have
File Upload in struts2 - Invalid field value for field
File Upload in struts2 - Invalid field value for field   Hi I am... : Invalid field value for field "upload". My webContents->Web-Inf->lib...) { this.uploadFileName = uploadFileName; } } As i click submit .. i get Invalid field
Moving Cursor within ResultSet
.style1 { text-align: center; } .style2 { background-color: #FFFFCC; } Moving Cursor Within ResultSet There are many methods are given to move within result set. They makes easy to read data within result set. An example
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
error http status-500 invalid path was requested
error http status-500 invalid path was requested  I am using netbeans 6.8 + struts 1.3 + glassfish v3.I am not able to open add.jspx which contains add form.please help. index.jsp [code] <%@page contentType
 

 

 

DMCA.com