User Profile

Collapse

Profile Sidebar

Collapse
resmi318
resmi318
Last Activity: Feb 20 '08, 03:47 PM
Joined: Jun 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • resmi318
    replied to Query in teradata taking long time
    in Oracle
    I needed some tables in Oracle which I exported as flatfile and created in teradata. I dont have any issue here.
    Now the problem is in running queries on the teradata machine.It is taking long time create table and even update statements.

    Thanks
    Resmi318...
    See more | Go to post

      Leave a comment:

    • resmi318
      replied to Query in teradata taking long time
      in Oracle
      Thanks for your reply. But I am using two different machines. Terdata and Oracle servers are different. I am ftping the oracle scripts to teradata machine and converting the same

      Thanks
      Resmi318...
      See more | Go to post

        Leave a comment:

      • resmi318
        started a topic Query in teradata taking long time
        in Oracle

        Query in teradata taking long time

        I am running a query similar to given below.

        CREATE TABLE ABC_08
        AS
        (SELECT x.col1,
        trim(x.col2),
        x.col3,
        x.col4,
        x.col5
        FROM Table1 x
        LEFT OUTER JOIN
        Table2 c
        on x.col1 = c.col1
        WHERE (col4 NOT LIKE '%DC'
        AND x.col3 in (SELECT col3 FROM Table3)
        AND trim(x.col2) in (SELECT col2 from Table4)
        ...
        See more | Go to post
        • resmi318
          replied to Download an image to local machine
          in Coldfusion
          Thankyou acoder. With getTempDirector y() I am able to get temp directory and download as an image file. Only problem is I am not able to download as excel. When I download as excel it is giving binary format not image.

          Resmi...
          See more | Go to post

            Leave a comment:

          • resmi318
            replied to Download an image to local machine
            in Coldfusion
            Hi,

            I found it is problem with path. Image is getting stored in default path and when I try to retrieve it is searching in current directory. I am not able to specify the default path. It is appending it to the URL

            Resmi...
            See more | Go to post

              Leave a comment:

            • resmi318
              replied to Download an image to local machine
              in Coldfusion
              Hi,

              I am not able to retrieve that image.
              Empty image is displayed

              Resmi...
              See more | Go to post

                Leave a comment:

              • resmi318
                replied to Download an image to local machine
                in Coldfusion
                Hi,

                I tried giving the whole path. Still when it retrieve the image is empty.
                But image is present in the location.

                new.jpg was a mistake and is corrected.
                Thanks
                Resmi...
                See more | Go to post

                  Leave a comment:

                • resmi318
                  replied to Download an image to local machine
                  in Coldfusion
                  Hi,

                  I tried to save the image by using the following code

                  <cffile
                  action="WRITE"
                  file="mychart.j pg"
                  output="#myChar t#">

                  I set name attribute of cfchart to myChart.
                  Then I tried to view image by <img src="new.jpg"> but it is not displayed.
                  I checked whether image is present in the location and it was present....
                  See more | Go to post

                    Leave a comment:

                  • resmi318
                    replied to Download an image to local machine
                    in Coldfusion
                    It expires immediately. Once I save it to local machine and open it. It displays image expired.

                    Thanks
                    Resmi...
                    See more | Go to post

                      Leave a comment:

                    • resmi318
                      started a topic Download an image to local machine
                      in Coldfusion

                      Download an image to local machine

                      Hi,

                      I want to download a chart which I created using cfchart to excel and save it to local machine. The problem I am experiencing is when I save it in local machine,image is getting expired. The code I used to download to excel is

                      [CODE=cfm]<cfif IsDefined("Exce llink")>
                      <cfheader name="Content-Disposition" value="filename =chart.xls">
                      <cfcontent type="applicati on/msexcel">...
                      See more | Go to post
                      Last edited by acoder; Jan 22 '08, 09:40 AM. Reason: Added code tags
                      • resmi318
                        started a topic Unable to retrieve records from php
                        in PHP

                        Unable to retrieve records from php

                        Hi,

                        I am using a teradata query (a big one) to get some weekly records.The query works for 40 weeks. But when it exceed to 41 it is not working.The query is working in Terdata sql assistant for 41 weeks also but when I execute it from php it is not working.
                        Can anyone tell me what could be the problem?

                        Thanks
                        resmi318
                        See more | Go to post
                        • resmi318
                          started a topic Download to excel
                          in Coldfusion

                          Download to excel

                          Hi,

                          I need to download some data into an excel. I am using the following code but it is not working.
                          [CODE=cfm]<cfif Form.ExcelLink is "on" >
                          <cfset TabChar = Chr(9)>
                          <cfset NewLine = Chr(13) & Chr(10)>
                          <cfcontent type="applicati on/msexcel" >
                          <cfheader name="Content-Disposition value="filename =Result.xls">...
                          See more | Go to post
                          • resmi318
                            replied to Coldfusion script to draw graph
                            in Coldfusion
                            Hi,

                            I used cfchart and cfchartseries to draw the graph and I got it. Thanks everybody for helping.

                            Now I need to get an excel sheet with data of the query when the user clicks on the graph. How can I do that? I found out how to get data in excel sheet but how to get it when user click on the graph? Please advice me?

                            Thanks
                            Resmi318...
                            See more | Go to post

                              Leave a comment:

                            • resmi318
                              replied to Coldfusion script to draw graph
                              in Coldfusion
                              Cold fusion version I am using is 7.
                              Operating system is unix.
                              Thanks...
                              See more | Go to post

                                Leave a comment:

                              • resmi318
                                replied to Coldfusion script to draw graph
                                in Coldfusion
                                Hi,
                                Values will be like this

                                Week_type Net
                                25/05/2007 100
                                01/06/2007 150
                                08/06/2007 80
                                15/06/2007 120

                                These values will be present as two columns in the table.
                                i need to draw graph with these.

                                Thanks...
                                See more | Go to post

                                  Leave a comment:

                                • resmi318
                                  replied to Coldfusion script to draw graph
                                  in Coldfusion
                                  Hi,

                                  I dont have any code. A table is pesent. By querying that table I will get the x and y values to draw the graph. It should be a two dimensional line graph. The script should query the table and plot graph....
                                  See more | Go to post

                                    Leave a comment:

                                  • resmi318
                                    started a topic Coldfusion script to draw graph
                                    in Coldfusion

                                    Coldfusion script to draw graph

                                    Hi,

                                    I am new to coldfusion. I need to query a table to get some datas and then draw a graph using that. Can anyone help me?

                                    Thanks
                                    Resmi318
                                    See more | Go to post
                                    • resmi318
                                      replied to PHP Script to block a page
                                      in PHP
                                      Hi,

                                      Thanks eragon for the script....
                                      See more | Go to post

                                        Leave a comment:

                                      • resmi318
                                        replied to Unable to use GD library
                                        in PHP
                                        [QUOTE=resmi318]Hi,

                                        Yes I saw the way you have mentioned under ext dir.

                                        Resmi318[/QUOTE
                                        Hi,

                                        In the php.ini file in the extension directory, path specified is /opt/apache/dev/php-4.3.7/lib/php/extensions.
                                        but when I checked , "extensions " folder was not found.
                                        Is that an error in installing php. Should php be reinstalled.

                                        Thanks
                                        Resmi318
                                        See more | Go to post

                                          Leave a comment:

                                        • resmi318
                                          replied to Unable to use GD library
                                          in PHP
                                          Hi,

                                          Yes I saw the way you have mentioned under ext dir.

                                          Resmi318...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...