Good day,
I'm testing MT on a new site, howerver some counts don't return the right values.
As per the design of the site, unfortunately some URLS are getting very lengtly, enough to exceed the 255 characters limit imposed with MsAccess on a regular "Text" field.
If I change the definition of the field to "memo" for instance, it can no longer be "grouped".
When using a "memo" field, a Select based on the table, will return only the first 255 characters.
Creating a query in MsAccess, and using that query as the source for the Select in VBScript, ALL the characters are returned, even if exceeding 255 characters in length. At first glance, grouping can be done using that method, or at least it doesn't return errors as of now.
I would like to know if this is a unique situation or if someone has encountered a scenario like that in the past ?
I'd be interested to know if a similar approach can be used with MsSql.
I'm almost certain that this can't be applied to MySQL, since MySQL doesn't have storer procedures, at least not to my knowledge.
Initial test performed on an Access 97 database, with MDAC 2.6.
Regards.