Hi All,
I have a java code that retrievies values from a table in a oracle database.
There are more than 100 columns and 100000 records for the table in the database and i am able to retrieve 88 records for 5 mins which doesnt suit the requirement.
I need to retrieve 300 records per minute is there any alternative available so that i can optimize the query or use any java methods to retrieve the values...
ananth
Last Activity: Nov 27 '07, 08:52 AM
Joined: Nov 8 '06
Location:
-
Optimising the retrievial time from Oracle database
-
Retrieving column name for the Error Code.
Hi All,
I am getting an SQL Error Inserted Value to LARGE FOR COLUMN .I know the cause for this error
Is there any specific error handling method where in i can find for which column the error occurs using an sql query,procedure or functions
Ex:I have a table named emp which contains 150 columns.When i use insert query to insert values.I get an error message INSERTED VALUE TO LARGE FOR COLUMNS.
... -
Retrieving values from a table using a condition
Hi All,
I have column in a table named X that contains returns the value 2 based on column value i need to retrieve a columns from tables Y and Z. that should have only 2 values in the columns that are used.
That is (If the column in the table returns 2 then the number of records that is to be returned from the columns in the table Y an Z should also be 2)
I tried using COUNT,ROWNUM but that is not giving me... -
ananth replied to JavaScript to check whether textbox contains only integer or numeric/number valuesin JavascriptHI ,
The code above using NAN will not work properly try this.
[CODE=javascript]function checkNum(x)
{
var s_len=x.value.l ength ;
var s_charcode = 0;
for (var s_i=0;s_i<s_len ;s_i++)
{
s_charcode = x.value.charCod eAt(s_i);
if(!((s_charcod e>=48 && s_charcode<=57) ))
{
alert("Only Numeric Values Allowed");
... -
Converting Double to String
Hi All,
I need to convert a Double value to String.The requirement is as follows
Double do=123456789012 3456.12;
String str=Double.toSt ring(do);
when i execute it i am getting the values in exponential format.
which is like: 1.2345678901234 56E15
But i need the values to be converted exactly into String.I cannot use BigDecimals due to the requirements.
The code... -
Hi pbmods,
Thanks for your reply ,but do you have any sample code on how to implement it.Any sample code or website links would be of more helpful to me....Leave a comment:
-
Check if field value is modified
Hi All,
I have a text field in my HTML page which has a value stored in it.
I need a java script code to allow the user to save if the content of the text field is edited.ie User should be prompted with a message on clicking the button
Displaying the "Content of the field is Edited".
Please help me in this regard as it will be help ful for my project completion?
Thanks... -
Getting a CAB location using Activex control
Hi All,
I have a active-x control that checks the registry for whether a file has been installed or not if it is not installed then it will get a content using a property file which has the location of the file.
The Active-x control should get the content and run the exe file and then it should then call the other active-x control that will reference the file that has been currently installed and perform certain operation.Both... -
Getting Registry Values
Hi All,
I need to access the registry and check whether a particular value exists in the registry.If the value exist then continue else i should run a setup file that installs and creates a registry value.Please tell me how this can be done as it will be helpful for my project completion.
Thanks in Advance!!! -
Calling Web Service with authentication
Hi All,
I have a web service created in Notes Database and i am calling the web service in Visual studio.Net application by adding a web reference.
I need to have authentication mechanism before calling the methods within the web service.I used the NetworkCredenti als Property for authenticating but the user name and password is not authenticating. I am able to access the web service methods directly the authentication... -
Hi Mr.elmemo,
I first of all thank you for the website that you forwarded me.It was great help to me thank you.Mr.elmemo can the user name and password authentication check using ldap authentication mechanism done on a domino server.
The requirement what i need is as follows.
The username and password information will be available in the domino server. The names and password are given in the html...Leave a comment:
-
Hi elmemo,
Thanks for your reply but i need this to be done without a .net framework.The requirement is i need a HTML page which contains two text box one is user name and the other is the password and a button named login on clicking the login button the asp should validate the ldap authentication mechanism that looks for the user name and password in the domino server and create a session if it validates else return a error...Leave a comment:
-
LDAP authentication for Domino using ASP
Hi All,
I am new to ASP.I don't even know how to start i have a project where in i have to create a ASP code that does a LDAP authentication for a Domino sever.The requirement is user will give a User Name and Password and then the ASP code should validate with the server on validating it should create a session else it should prompt an error message.
How can i proceed and is there any codes or links that can help me out!!!!... -
Convert Word Document to HTML file
Hi All,
Do anyone know how to get a word document in a rich text field and convert them into a HTML page programatically .The requirement is that there shouldnt be any third party tool involved.All these has to be done in visual basic on a form load or in a button click.
Kindly help me in this regard.Thanks In Advance -
Help Needed in Visual basic coding
Hi All,
I have written a code that finds default mail client and then i am using a function to open a mail client and populating it with values.The code works fine when i give some minimum value for the BODY field of the mail.But when i pass String Values with large amount of data the code is not working out.What is this problem due to?I have attached the code below
...Code:Option Explicit Private Declare Function ShellExecute
-
Hello Sir,
Is there a way of sending mail using the client's default mail client?
I am looking for a none email client specific solution that does not involve
specifying parameters such as mail servers etc.
Can this be done using Visual Basic???...Leave a comment:
-
Finding Default Mail client
Hello,
Is there a way of sending mail using the client's default mail client?
Can this be done using Visual Basic???
please help me in this
Thanks in Advance!!! -
How to find Default mail Client
Hi,
I have a task where in i have to find a default mail client of the windows and to send a mail using it.
The work flow that i need is as stated below.
In windows operating system when we Right click an Folder we have a option
SEND TO Mail Recipient. I need the same functionality in Visual basic.
The application should find the default Mail recipient of my Windows and to send mail... -
How to Send an Email
Hi,
I have an Active x control that contains a Button.On the Button Click the control should send an mail to the specified address mentioned in the command click.
How can this be done i tried the following code .
...Code:Function SendMail(EM_TO, Em_CC, EM_BCC, EM_Subject, EM_Body, EM_Attachment As String, Display As Boolean) Dim objOA As Outlook.Application Dim objMI As Outlook.MailItem Dim obgAtt -
Hi Willakawill
Thanks for your information but i have already done that and i am able to get all the Installed softwares available on my pc but the thing is i need to get a particular software how can this be done...Leave a comment:
No activity results to display
Leave a comment: