User Profile

Collapse

Profile Sidebar

Collapse
nuhbye
nuhbye
Last Activity: Mar 1 '11, 05:23 PM
Joined: Jul 5 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • nuhbye
    started a topic How to declare CURSORS with variable file names?

    How to declare CURSORS with variable file names?

    How to declare a cursor where the name of the file to be user will be known at the run time?

    DECLARE userlist CURSOR for SELECT * from XXX JOIN tab1 ON XXX.a = tab1.a;


    XXX need to be variable.
    See more | Go to post

  • nuhbye
    started a topic How to transfer a table content to a Outfile.

    How to transfer a table content to a Outfile.

    I am trying to transfer output of a query to some file whose name will be available only at the run time.
    My CODE looks something like this, this code is a part of stored procedure.

    Code:
    set FILENAME = uid + (select phone_no from table2 where user_ID = uid);
    
    select startstop from table1 INTO OUTFILE FILENAME;

    My code works fine if i use specific file names like...
    See more | Go to post

  • nuhbye
    started a topic Receiving file from remote source?

    Receiving file from remote source?

    The deign goes like this..

    I have a Mysql database on a linux system. It will receive a file from a remote location through GPRS and that file is to be processed and will then be loaded in the database.
    So, I want to know how to achieve this?
    How can we forward the file received to the database?
    How can Mysql can get to process this data?
    Do we have any support for doing this from Mysql?
    what to read...
    See more | Go to post

  • thanx... i checked it..
    it is working exactly the way i wanted...
    See more | Go to post

    Leave a comment:


  • displaying a image in a picture box with scrolling option?

    I want to display a bitmap in its original size using a picturebox and scrollbar, but i couldn't find any option to clip a bitmap and display it in the picturebox, i am searching for one like we have for images drawimage which we can use to display a part of the image.
    Do we have something same for bitmap as well?
    Or any other alternative?
    See more | Go to post

  • how to display a clipped bitmap in a picture box to provide scroll feature in c#?

    i am using c# ..
    and i want to diplay a bitmap with the actual size. for this i need a scrollbar and if could clip the bitmap, i can display the bitmap. But how to clip a bitmap?
    We have an option through drawimage option to clip a image and display. But i could't find one for bitmap.
    See more | Go to post
No activity results to display
Show More
Working...