Jonand's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
New Members
Active Posts:
12 (0.02 per day)
Joined:
26-September 12
Profile Views:
504
Last Active:
User is offline Apr 30 2013 08:11 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   Jonand has not set their status

Posts I've Made

  1. In Topic: odbc blob insert problem c++

    Posted 10 Oct 2012

    View PostSkydiver, on 08 October 2012 - 07:44 AM, said:

    We know that you have two SQL statements. You already said that previously. You didn't answer our questions in the previous posts about which variable is holding which statement.

    Let me try rephrasing the question: Where is INSERT INTO "+ table_name +" VALUES ('insert',EMPTY_BLOB())") stored? Is it it szSqlStat or in szSqlStat2?



    My bad ,i misunderstand your question.
     INSERT INTO "+ table_name +" VALUES ('insert',EMPTY_BLOB()) 
    
    it is stored in szSqlStat2 .

    Thanks.
  2. In Topic: odbc blob insert problem c++

    Posted 8 Oct 2012

    hello ,

    Thank for your reply ,i'm trying to use SQLBindingParameter for binding an blob ,my table has only two columns ,an varchar type and an BLOB type .I believe that the problem is from my bindingparam function but cant figure it out .
    I haven't worked with blob type before so it is abstract to me. The date is stored in an char array ,pData.The two statements that i use are :

    UPDATE "+ table_name +" SET "+ column_name +" = ? WHERE filename ='insert'")
    INSERT INTO "+ table_name +" VALUES ('insert',EMPTY_BLOB())")
    
    


    the insert for inserting an empty blob ,and the update to update the inserted blob with the data.
    Is this not correct ?

    Thaks ,looking forward for your rely's.
  3. In Topic: odbc blob insert problem c++

    Posted 4 Oct 2012

    View PostAphex19, on 04 October 2012 - 02:32 AM, said:

    Which functions aren't returning what you expect and what do you expect them to return? Try to trace the problem(s) to the most specific place(s) you can.


    Hello,

    The functions are returning as they should return .There is not problem there ,only that the blob data is not inserted in the table. I believe the statements are ok ,so i am thinking it could be an logic error or something, and i missed .

    Thanks for your reply.
  4. In Topic: Finding the max and min

    Posted 1 Oct 2012

    Hello ,


    I would recommend you to use an sorting method.Your grades will be stored in an array ,and on that array you could use ,lets say bubble sort. So if you sort the array ascendent the the first element of the array will be the minimum and the last the max .I suspect that u use grades from 1 to 10 ,and is a person has lets say 10 5 7 6 as grades after an bubble sort your array would look like {5 6 7 10} so the minimum would be 5 and maximum 10 .

    Here is an exemple of bubble sort implementation :
    
    void bubble(int a[],int n)  
      {  
            int i,j,t;  
             for(i=n-2;i>=0;i--)  
             {  
                for(j=0;j<=i;j++)  
      
                      {  
                        if(a[j]>a[j+1])  
                                        {  
                                          t=a[j];  
                                         a[j]=a[j+1];  
                                         a[j+1]=t;  
                                        }  
                       }  
             
      
               }//end for 1.  
      
      }//end function.  
    
    
  5. In Topic: ODBC API SQLExecDirect return code problem

    Posted 1 Oct 2012

    Basacly my app will use only two statements an update that look like :
    "UPDATE "+ sw1 +" SET apkdata = ? WHERE filename ='img001'"
    
    

    and an insert statement :
    INSERT INTO table_name VALUES (memberlist,?,memberlist)
    


    This form of insert statement is quite abstract to me .
    This insert should be applied on the next table :
    CREATE TABLE t_testblob (
      filename VARCHAR2(30) DEFAULT NULL NULL,
      apkdata  BLOB         NULL
    )
    


    I have suspected that the problem could be from my statements ,so if you could help me i would be really gratefull.

    Thanks.

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Click here to e-mail me

Friends

Jonand hasn't added any friends yet.

Comments

Jonand has no profile comments yet. Why not say hello?