0 Replies Latest reply on Nov 4, 2013 7:13 PM by Drimy_t

    InDesign CS6 Plug-in development problem

    Drimy_t

      Hello,

       

      IDE:Visual Studio 2010

      Platform:Windows7-32

      Version:Indesign CS6

      Database:MySql-5.0.67-win32

      ODBC:ODBC-5.1

       

      The source code:

       

       

      URI uri("odbc://New/?table=jo_user#user_id,username,reset_key,activation,register_time,login_ count");//int,varchar,tinytext,tinyint,datetime,longtext

       

       

      SDKODBCWrapper odbc;

       

       


      if (ISDKODBCWrapper::ODBCNormal == odbc.Query(uri))

      {

             int32 ColumnNum = odbc.GetNumberOfColumns();

       

             for(int32 cNum=0; cNum<ColumnNum; cNum++)

              {

                  ISDKODBCWrapper::ItemType retType = odbc.GetMthColumnInfo(cNum, std::string(""));

                  if (retType == ISDKODBCWrapper::kIntegerType)

                  {

                      CAlert::InformationAlert("kIntegerType");

                  }

                  else if (retType == ISDKODBCWrapper::kDoubleType)

                  {

                      CAlert::InformationAlert("kDoubleType");

                  }

                  else if (retType == ISDKODBCWrapper::kStringType)

                  {

                      CAlert::InformationAlert("kStringType");

                  }

                  else if (retType == ISDKODBCWrapper::kTimeStampType)

                  {

                      CAlert::InformationAlert("kTimeStampType");

                  }

                  else

                  {

                      CAlert::InformationAlert("Others or NULL");

                  }

              }

      else

      {

          CAlert::InformationAlert("Link ODBC error");

      }

       

      I have already successfully connect to the database,but why I can only get kIntegerType and kTimeStampType?

      why varchar tinytext tinyint longtext are show kIntegerType?

       

      someone please guide me...

      Thank you very much.

       

      消息编辑者为:IIASCII