how to load data from a csv file to databse.
Can anybody help me in giving the code
Shashank
onlyshanks28
Last Activity: Feb 11 '09, 05:28 AM
Joined: Oct 8 '08
Location:
-
how to load data from a csv file to databse
-
thats correct
but
we do have to take into cosideration the year when the current date is
31-dec-2008..
the above 3 queries that i have given will do that perfectly... -
for it we have to use three query subsequently
1) select name,date from days_to_remembe r where month(date)=mon th(curdate()) AND date(date)>=dat e(curdate()) order by date asc;
-----it will give upcomng bdays of same months---
2) select name,date from days_to_remembe r where month(date)>mon th(curdate()) order by date asc;
-----it will give upcomng bdays of next...Leave a comment:
-
Problem with it is:
If Current date is 31 december 08
then it will not display birthday in the moth if january 09
Also dob can never be more than currdate( )
MY dob is 28-08-1986(suppose) it cant be greater than currdate( )...Leave a comment:
-
upcoming birthdays query
Hi
I have a database birthday containing name and DOB,
I want to find the query which can display 3 latest birth day.
I tried
select name,date from birthday where month(dob)>=mon th(curdate()) limit 3;
But the problem here is that on 31-December-2008 it will not display the birthdays on January.
Shashank -
No I have not saved it anywhere I have just attached it in the mail....Leave a comment:
-
Hi try the following(do read the last paart on the post)
[code=java]
Connection myconn;
String DbDriver = "org.gjt.mm.mys ql.Driver";
String DbConStr = "jdbc:mysql ://localhost:3306/xyz";
String DbUser ="root";
String DbPwd ="abcdef";
try {
Class.forName(D bDriver);
myconn = DriverManager.g etConnection(Db ConStr,...Leave a comment:
-
save changes in a shared workbook
Hi,
I made an excel sheet and enabled the "shared workbook" option.
now when i open it and save the changes that I have made it is showing an error message :
"File is locked"
Please help me out
Shashank -
thanks for response
I got it.It can be done just by writing
element.checked ='checked';
after append
as follows the complete code:
[CODE=javascript]function fun1()
{
var element = document.create Element('input' )
element.type='c heckbox';
body.appendChil d(element);
element.checked ='checked';
}[/CODE]Leave a comment:
-
To clarify further:
I dont want the user to save the file(.doc) anywhere else when he is opening.I just want him to view it and further I want that if he makes any changes then they should be reflected to the sources where the file is pressent.
For this I want to remove the Save option that comes when a download window opens up
If I make some changes in OS(windows) setting then this will happen in all...Leave a comment:
-
Force Opening a .doc file in the browser
Hi,
I want to open a .doc file in web browser(firefox and IE).
I have given a link but when I click on it,it gives 3 options
Open,Save,,Canc el.
I want either to remove the Save button or to open the file directly.
Please help me out.
Shashank -
createElement not working in IE
Hi,
I wrote a javascript code as follows
[CODE=javascript]function fun1()
{
var element = document.create Element('input' );
element.type='c heckbox';
element.checked ='checked';
body.appendChil d(element);
}[/CODE]
this code is working fine in Firefox but in IE the checkbox is creating but it is unchecked.
... -
Force Opening a .doc file
Hi,
I want to open a .doc file in html browser.
I have given a link but when I click on it,it gives 3 options
Open,Save,,Canc el.
I want either to remove the Save button or to open the file directly.
Please help me out.
Shashank
No activity results to display
Leave a comment: