sarathd kumar

Greenhorn
+ Follow
since Jul 31, 2014
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
1
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by sarathd kumar

Hi...

My PopUp Window does not working When i am click any link it will only open empty pop up window it does not carry the page information.

This is my JSP page..


<script language="javascript">
function win(add,w,h)
{
window.open(add,"","width="+w+",height="+h+",location=0,directories=0,menubar=0,toolbar=0,status=0,scrollbars=1,resizable=1,top=5,left=5");
window.location.reload();
}
</script>


<ul>
<li><a href="#" class="MenuBarItemSubmenu">Account Master</a>
<ul>
<li><a href="#" value="./Masters/accountMaster/accountmasternewmodify.jsp" onclick="win(this.value,600,450)">New</a></li>
<li><a href="#" value="./Masters/accountMaster/accountmasternewmodify.jsp" onclick="win(this.value,600,500)">Modify</a></li>
<li><a href="#" value="./Masters/accountMaster/accountmasterdelete.jsp" onclick="win(this.value,600,500)">Delete</a></li>
<li><a href="#" value="./Masters/accountMaster/accountmasterview.jsp" onclick="win(this.value,600,500)">View</a></li>
</ul>

Thanks...
Thanks For Your Valuable Reply Mr.Dave

I Find What is the Problem on it is

Is it Single space near by the transactionid so that it does not updated.
Hi...

When I am trying to Update my Database Table It could not be updated..

Update Query is:

UPDATE stock_sales SET balance='0.0',payment='90.0',due='2014-09-08' where transactionid=' SD263'

When i run this query Previous Values Does not Change.

But,MySQL Says Like,

(0 row(s)affected)
(0 ms taken)

Any One Help me Please...

Thanks to All..
Hi...
I need to change php code to jsp help me please....

Php code:


$line = $db->queryUniqueObject("SELECT * FROM supplier_details WHERE supplier_name='".$_POST['stock_name1']."'");
$address=$line->supplier_address;
$contact1=$line->supplier_contact1;
$contact2=$line->supplier_contact2;


$arr = array ("address"=>"$address","contact1"=>"$contact1","contact2"=>"$contact2");
echo json_encode($arr);


And My Jsp I am doing so far...

<%
Connection con = lm.Database.getConnection();
Statement st = con.createStatement();
String stock_name1=request.getParameter("stock_name1");
System.out.println("stock_name1-=="+stock_name1);
ResultSet rs = st.executeQuery("SELECT * FROM supplier_details WHERE supplier_name='"+stock_name1+ "'");
// ResultSet rs = st.executeQuery("SELECT name FROM supplier_details where name like '"+name+"%'");
if (! rs.next())
{
out.println("<h4>Sorry! Record Not Found!</h4>");
out.println("<p/> <a href='javascript:history.back()'>Back</a>");
return;
}
%>
<%
String address=rs.getString("supplier_address");
System.out.println("address-=="+address);
String contact1=rs.getString("supplier_contact1");
String contact2=rs.getString("supplier_contact2");
%>

Thanks For Advance...
9 years ago
JSP
hi...

i am working on library project we already set each student only take 2 books after he take a book it it show you are reaching your limit kindly return your book

so that i using this query but i can't get it

EX: when i issue a book it save on issue table like this so that i am using this kind of logic,

insert into issues(mid,isbn,bname,subject,bdate,rdate,status,bid )
values('1','100','java','java','2014-08-14','2014-08-14','s','0') where
SELECT * FROM issues GROUP BY mid HAVING ( COUNT(mid) <= '2' )

Please Help me....
Very Thank You....

It Working...

Mr.Dieter Quickfend
9 years ago
hi all...

i need when subtract the two date it show how many days will subtract

EX:

2014-08-08 - 2014-08-06 = 2


Thanks....
9 years ago
hi All... i am working on library task i need someone delay to return book i want add fine for how many extra day he will take to return a book

this is i am working so far..

select
( cast(CURDATE() as date) - cast(rdate as date) ) * 3 as fine
from issues
where
rdate > CURDATE()

thanks for advance...
yes it insert only null value
how can i get the values from on it
thanks
9 years ago
JSP
hi..
i'm doing library management project this module is return book.



i need to save the which book are return and update the status like this...



But i get error like this..

Query===com.mysql.jdbc.ServerPreparedStatement[2] - insert into returns values (null,null,null,0,null,0)
Query===com.mysql.jdbc.ServerPreparedStatement[3] - delete from issues where isbn = null
Query===com.mysql.jdbc.ServerPreparedStatement[4] - update books set status='a' where isbn = null

please help me...and thanks
9 years ago
JSP