Arya Quskhan Shah

Greenhorn
+ Follow
since May 06, 2006
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Arya Quskhan Shah

Hi Mike..
You know Mike,actually there is no problem with SQL command,but I don't know when 4 days ago I try one by one by input each step including giving value to orderNumber there are no problem. So i found out that one of big problem are in getParameter. when i re-type servlet code. It can works well...very well .
Gosh..its strange situation for me.So the case is close.
Thanks for your help Mark. Its valuable for me a lot.
Anyway do you have a code for servlet which can update database by using executeUpdate() ?? because when i use above code..it cant work..So i open new case for you Mark hehe...

--Arya---
17 years ago
Anyway...I already check it with the SQL editor..it's OK nothing problem.
When i execute your SQL code its error. So it's differ with the one.
already try with preparedStatement..I wish it can help.But i got same result.
Is there any chance to solve this Mark..

Regards,
17 years ago
Hi all,
This is the first message,I need your help please.
I develope servlet which retrieve data from mobile and process it through httpconnection then compare it with database.
I have the problem in servlet while trying to executeQuery from SQL.
Here is the full code of servlet :


The problem is while trying to execute SQL there are always throw to the "else stage" even if the orderNumber which key-in correct as same in the database. Thats mean ResultSet cannot execute query of SQL.
How to execute query SQL with the correct ways???
Anyone...please advice me how to solve this servlet problem..
Thanks you for immediately response.
[ May 07, 2006: Message edited by: Bear Bibeault ]
17 years ago
Well i already try as you said..n it didnt work. There is strill error n cannot execute the SQL.
On network monitor display as follow :

request ---> GET/Final/status?orderNumber=2004012 HTTP/1.1
response---> HTTP/1.1 500 Internal Server Error

So I change the command as " SELECT status,datePO,shipdate FROM order WHERE ordernumber='2004012'". (with space on shipdate-FROM and order-WHERE)
On network monitor display as follow:
request ---> GET/Final/status?orderNumber=2004012 HTTP/1.1
response---> HTTP/1.1 200 OK

It looks like fine right. But when it goes to the code


there is always throw to the 'else ' and forward to statusfailed.jsp whatever it value of orderNumber.
So i suggest resultSet rs cannot execute the SQL code.

here is the code for status.jsp and statusfailed.jsp
status.jsp


statusfailed.jsp


Please your immediately response everyone..
Thanks a lot

Regards,
Arya
17 years ago
Hi Mark,
Thanks for your advice..I'll check and try it immediately.
Hopefully it can work as good as you said.
Anyway..thanks a lot..

Regards,
Arya
17 years ago
Helloo,
I am new user here.I have develope some client/server by using midlet and servlet. The midlet run well but I have the problem with servlet.
While I run the midlet from Ktoolbar, it display HTML code with messge Error 500 that SQL error.
So i suggest there are some problem in execution SQL servlet.
Please advice anyone to solve this problem...

Here are the code of servlet :


[ May 06, 2006: Message edited by: Mark Spritzler ]
17 years ago