MySQL Forums
Forum List  »  Connector/ODBC

No Recordset is returned
Posted by: NOT_FOUND NULL !
Date: June 12, 2020 03:31AM

I am using MySQL ODBC connector 8.19 with Classic asp
Following is the table structure
CREATE TABLE Data_temp

(

ROWGUID varchar(36) default (UUID()) NOT NULL ,
col_desc varchar(10) NOT NULL ,

History varchar (4000)
,
PRIMARY KEY Data_temp_P_KEY(ROWGUID)

) ;
Using Adodb command run query following query
Select * from Data_temp WHERE col_desc=?
and parameter is supplied by parameter.
The result is returned in adodb recordset as
set recordset=command.execute method
recordset is not retruned if History column has data more than 1024 characters

If Same query is run by giving specific column list
as ,
Select col_desc,Rowguid from Data_temp WHERE col_desc=? i.e. column list do not contain that large data column then recordset is returned
and
Select col_desc,Rowguid,substring(history,1,1024) from Data_temp WHERE col_desc=? also works.
What could be the reason?

Is there any limit on returning the column data?

One more observation instead of using parameterised query if query is run directly with value in query itself
Select * from Data_temp WHERE Col_Desc='aa' without parameter then recordset is returned

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
No Recordset is returned
June 12, 2020 03:31AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.