Method length limit?

[jda]

Hi Ruslan,

I use this method to search all fields in my db (all VText):

"CONCAT(IFNULL(authors,''),' ',IFNULL(title,''),' 
',IFNULL(editors,''),' ',IFNULL(journal,''),' ',IFNULL(volume,''),' 
',IFNULL(pages,''),' ',IFNULL(thedate,''),' ',IFNULL(publisher,''),' 
', IFNULL(location,''),' ',IFNULL(url,''),' ',IFNULL(title2,''),' 
',IFNULL(user1,''),' ',IFNULL(user2,''),' ',IFNULL(user3,''),' 
',IFNULL(user4,''),' ',IFNULL(abstract,''),' ',IFNULL(keywords,''),' 
',IFNULL(notes,'')" )

I added 12 new fields (all VarChar), which are NULLABLE, INDEXED, and 
INDEXEDBYWORDS

I extended the method to include the new fields

"CONCAT(IFNULL(authors,''),' ',IFNULL(title,''),' 
',IFNULL(editors,''),' ',IFNULL(journal,''),' ',IFNULL(volume,''),' 
',IFNULL(pages,''),' ',IFNULL(thedate,''),' ',IFNULL(publisher,''),' 
', IFNULL(location,''),' ',IFNULL(url,''),' ',IFNULL(title2,''),' 
',IFNULL(user1,''),' ',IFNULL(user2,''),' ',IFNULL(user3,''),' 
',IFNULL(user4,''),' ',IFNULL(abstract,''),' ',IFNULL(keywords,''),' 
',IFNULL(notes,''),' ',IFNULL(user5,''),' ',IFNULL(user6,''),' 
',IFNULL(user7,''),' ',IFNULL(user8,''),' ',IFNULL(user9,''),' 
',IFNULL(user10,''),' ',IFNULL(user11,''),' ',IFNULL(user12,''),' 
',IFNULL(user13,''),' ',IFNULL(user14,''),' ',IFNULL(user15,''),' 
',IFNULL(user16,'')" )


If I open the db in ViSQL I see that the method returns

NULL

even when there are fields with data in them.

Is there a limit to the length of methods? Is this new method too long?

Jon