Hi all,
I have used a substring function inside my stored procedre as
set @dummy1=substri ng(@dummyid,2);
but when i print and check the value of @dummy1 as
select @dummy1;
i am getting null value for this local variable. i don know how to proceed.....
is it the problem related to substring function....... ? Or in my procedure ...?
here is the entire...
ponvijaya
Last Activity: Jan 12 '08, 06:26 AM
Joined: May 9 '07
Location:
-
substring function inside stored procedure is not working
-
Passing results from applet to html page
Hi All,
In My project, i am loading an applet in a HTML page using applet tag.
And I am passing parameters to applet while loading the applet.
In this project , this applet will do processing based on parameters and then finally i need to return back the result from applet to the browser window.
Is it possible to do so....? IF so plz suggest how to achieve it..
Thanks in... -
Passing results from applet to html page
Hi All,
In My project, i am loading an applet in a HTML page using applet tag.
And I am passing parameters to applet while loading the applet.
In this project , this applet will do processing based on parameters and then finally i need to return back the result from applet to the browser window.
Is it possible to do so....? IF so plz suggest how to achieve it..
Thanks in... -
Download of file through javascript anonymously without knowledge of user
Hi All,
I have one requirement...
Its like a search engine design.
I will have a text box to type in the search text and a search button on clicking which the search action should take place.
I need to download a text file from the server to the user machine on clicking the search button and i have to do some manipulation by reading the contents of that downloaded text file ... But download... -
file download from server to client
Hi all,
In my jsp page, I have one requirement.
I have a button named Download. If I click this a file from server should be downloaded to the client whoever accessing that jsp page and clicking that button.
According to the requirement, the file should not be downloaded through the http header.
It should be copied to a static folder (Say for eg c:\temp )in all client machines whoever clicking... -
Problem in response.sendRedirect()
Hi all,
I have one requirement in my project. I need to download a file from the server tot the client machine. And after downloading it , it should be redirected to another jsp file.
The code for download write inside a servlet is as follows
public class DownloadServlet extends HttpServlet
{
public void doGet(HttpServl etRequest request, HttpServletResp onse response) throws IOException,... -
I am sure that i am closing connection, statement and resultset object in all my JSPs and servlets inside Finally block.
What else can be done..?... -
[QUOTE=JosAH]
As u told, i will make the datasource as class variable.
Initially datasource ds is set to null.
i just want to know how the code
[code=java]
if (ds != null)
ds = (DataSource) envCtx.lookup(" mine");
[/code]
will get executed because ds is null for the first time. I am telling this as per my understanding....Leave a comment:
-
ponvijaya started a topic how to overcome TooManyConnections error and to return connecitons to Poolin Javahow to overcome TooManyConnections error and to return connecitons to Pool
Hi all,
My project is done in Tomcat 5.0 with Mysql 5 as backend.
Through tomcat admin console i have configured datasource named "mine" with all the attributes needed to connect to MySql like url, username,passwo rd, Max connections etc.
I have written a function named getConn() in one plain java file named ConClass for fetching connection from datasource.
The ConClass code is... -
About import command
Hi all,
We are using import command as
import java.io.*, import java.util.* etc in the program.
Consider i am having a class A.
Is there any difference related to Memory consumptions for class A while writing import command as
import java.util.HashM ap ; rather than
import java.util.*;
in the case import java.util.HashM ap i am... -
Hi i have used this format function
date_format(str _to_date(startt ime,'%h:%i %p'),'%T')
which gave me the required result.
Thanks a lot for your valuable help. Thank you once again....Leave a comment:
-
Hi,
Thanks for your suggestion. I have already seen the link provided by you. But could get idea which funtion and forma to use..
I am using Mysql version 5.1.
Can u tell me the exact function format to get my required result. I need to generate the report based on ascendin order of time.
Since my time field is of varchar type, i am getting the display is String order not in the actual time...Leave a comment:
-
Need help how to do Time format in MySql
hi all,
I have time stored in my table field as hh:mm am or pm (eg 04:15 PM , 02:30 AM). The field is of type varchar.
I need to convert it as a MySql time format.
Can any body help me...Please .. Its urgent -
how to do Backup of MySql records to .csv file through java code
I want to take back up of records in My MySql Database
I want to convert the records into csv file and store in a location.
If needed I want to import it to the same database..
I need to know how to export MySql selected records into a csv file through java code.
Can anybody help me by giving java code for exporting MySql Records to an external csv file.
I tried executing... -
how to do Backup of MySql records to .csv file through java code
I want to take back up of records in My MySql Database
I want to convert the records into csv file and store in a location.
If needed I want to import it to the same database..
I need to know how to export MySql selected records into a csv file through java code.
Can anybody help me by giving java code for exporting MySql Records to an external csv file.
I tried executing... -
Thanks Pradeep.. Its working .. Thank u once again...Leave a comment:
-
Need Date conversion function in Mysql
Hi all,
i have date format as dd/mm/yy in my table field. I need to convert it into MySql Format YYYY-MM-DD .
For example i need to convert the date 09/05/07 to 2007-05-09.
Can a any body suggest me the solution..
Its very urgent -
Need Date conversion function in Mysql
Hi all,
i have date format as dd/mm/yy in my table field. I need to convert it into MySql Format YYYY-MM-DD .
For example i need to convert the date 09/05/07 to 2007-05-09.
Can a any body suggest me the solution..
Its very urgent
No activity results to display
Leave a comment: