User Profile

Collapse

Profile Sidebar

Collapse
prileep
prileep
Last Activity: Jun 2 '10, 12:43 PM
Joined: Jan 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • prileep
    started a topic Integrating JASPER Reports to J2EE
    in Java

    Integrating JASPER Reports to J2EE

    Hi,

    I am trying to invoke JASPER Reports designed using iReport 3.7.0.

    JasperPrint jasperPrint = JasperFillManag er.fillReport(j asperReport, param, conn);

    I am getting following error,
    root cause

    javax.servlet.S ervletException : org/apache/commons/collections/ReferenceMap

    org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:858)
    org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:791)...
    See more | Go to post

  • prileep
    replied to If statments in MSSQL
    If u just want to know how to use IF state ment in SQL Server,

    Format one:
    IF <condition> <then code to be executed when condition true>
    Format two:
    IF <condition>
    BEGIN
    <then code to be executed when condition true>
    END
    ELSE
    BEGIN
    < else code to be executed when condition is false>
    ...
    See more | Go to post

    Leave a comment:


  • I have used "Option explicit" in my form and it is not giving me any compile time error.
    And I have put a break point on assigning query to the variable strSQL.And i am getting the string "Update Users set Password='trust me' where UserID=1". I copied the value from immediate window and executed in MS Access and i found it working fine. But when executing from VB,through ADODB.connectio n object it is giving me error as i...
    See more | Go to post

    Leave a comment:


  • I have establed connection with DB using current code itself. Even istarted accessing Database and executing querries. But the error is coming when i execute this particular Update statement only generates run time error....
    See more | Go to post

    Leave a comment:


  • What may be the reason for Error(VB & MS Access)

    Hi,

    Code:
    Dim cn As ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim strSQL As String
    
    Set cn = New ADODB.Connection
    With cn
        .Provider = "Microsoft.Jet.OLEDB.4.0"
        .Open "\\Computer1\Project\SampleDB.mdb"
    End With
    strSQL = "Update Users set Password='" & txtNewPwd.Text & "' where UserID=" & UserID
    cn.Execute
    ...
    See more | Go to post
    Last edited by Killer42; Mar 2 '07, 08:06 AM. Reason: Added CODE tags

  • Whether use or misuse the technology depends on individual. But just understanding it is always a sake.
    May be uyou are correct. Anyway can u tell me is it possible ?...
    See more | Go to post

    Leave a comment:


  • How do I program to get Key Pressed using Windows API

    Hi,

    If i enable and display a Form in my application i will get the events like
    form_keydown() , form_keypressed ().

    But here the form willl not be activated, even it will not be visible but the application will be running in background. But i should get trigggered when each key is pressed.
    Means when the user press any key it should be triggered in my program.

    For this requirement which API...
    See more | Go to post

  • Which implementation will give faster result (Table design to Joins)

    I have two tables Users and UserLogin. Here i will use two methods of table design. and which query will return me the result more fast.
    The table size will be large that it may contain records in lakhs.

    Method 1:
    Tables:
    Users ( UserID varchar(20) primary key, PassWord varchar(20))
    UsersLogin(User ID varchar(20),Log inDate DateTime)
    Query:
    Select Users.UserID,Us ersLogin.LoginD ate
    from Users
    ...
    See more | Go to post

  • Which will give me better performance (Table design for Joins)

    I have two tables Users and UserLogin. Here i will use two methods of table design. and which query will return me the result more fast.
    The table size will be large that it may contain records in lakhs.

    Method 1:
    Tables:
    Users ( UserID varchar(20) primary key, PassWord varchar(20))
    UsersLogin(User ID varchar(20),Log inDate DateTime)
    Query:
    Select Users.UserID,Us ersLogin.LoginD ate
    from Users
    ...
    See more | Go to post

  • prileep
    started a topic Accessing Oracle DB with C Program

    Accessing Oracle DB with C Program

    OS: Windows 2000 Professional
    DataBase:Oracle 9i

    If i want to access the data base through C Program.
    How do i configure the system to do so?
    Can anyone get get me specific website link which will explain more detailed about this?

    with reguards,
    prileep
    See more | Go to post

  • prileep
    started a topic Creating Composite key

    Creating Composite key

    I have a table "Transactio n" with the following struct

    Transaction
    TransactionID int primary key,
    CustomerID int,
    TranTime DateTime
    ----------------------------------------------------------------
    How can i set a composite key between CustomerID and TranTime
    See more | Go to post

  • prileep
    started a topic Using Timer
    in Java

    Using Timer

    Give me a simple program which will
    execute set of code after eveery 1 second
    See more | Go to post

  • prileep
    replied to Duplicate returns on querying two tables
    please send the table names with column names and requirement and fully written query...
    See more | Go to post

    Leave a comment:


  • prileep
    replied to Random numbers between number range in Java
    in Java
    I got the soltion from custom method.
    Thanks for giving the better solution.
    See more | Go to post

    Leave a comment:


  • prileep
    replied to Random numbers between number range in Java
    in Java
    More specific

    Ok i got the result with ur solnution. But i wanted to know whether i can set a random object to return value between a specified lower limit and upper limit so that i need not to worry about the complexity of calculations
    See more | Go to post

    Leave a comment:


  • prileep
    started a topic Random numbers between number range in Java
    in Java

    Random numbers between number range in Java

    if i use java.util.Rando m i can create random numbers.

    But how do i can define a Random object that its methods like
    nextInt() should return between two specified numbers(Eg: i want to create random numbers between 100 and 200)
    See more | Go to post

  • prileep
    started a topic Upgrading MySQL 4.1 to 5.0

    Upgrading MySQL 4.1 to 5.0

    I want to create procedures,trig gers and functions in MySQL,but i am using Version 4.1.14. So if i upgrade it to Version 5.0 can i create these objects which will function as SQL Server 2000-Transact SQL
    Is it backward compatible to version 4.1.14 so that it should not affect existing database.
    See more | Go to post

  • prileep
    replied to finding Datetime difference in seconds
    I am really thankful to u with the solution u given for this. I could achieve this by some other twisted method. But your solution helped me to calculate in subqueries itself,because iwanted to calculate in subquery.
    See more | Go to post

    Leave a comment:


  • prileep
    replied to SQL Command
    SELECT distinct provider FROM table_name
    See more | Go to post

    Leave a comment:


  • prileep
    started a topic finding Datetime difference in seconds

    finding Datetime difference in seconds

    Hi,
    I want to find the the exact difference between two dates in seconds through MySQL query.
    Version: 4.1
    Platform: Linux
    Source code:
    >select datediff('2007-01-09 10:24:46','2007-01-09 10:23:46')
    The datediff() function has only two datetime parameters and returns the difference in days.Instead if i want the value to be returned in seconds,what is the possible way??
    See more | Go to post
No activity results to display
Show More
Working...