Question
InDesign CS6 Plug-in development problem
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,lo ngtext |
| 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.
AdChoices