Where is the knob for setting the max length for query fields returned to a results field?
I created an ASP with frontpage connecting to an access database that contains a memo field. When I connect directly to the table, the entire memo field is returned to the results field. But when I retrieve long text strings including the memo field from a query built into the access database, they get chopped off to a length in the 200 - 300 range (fixed, but haven't counted).
I've looked and looked for a Frontpage control over the field length. I can't see anything in the global.asa or the .asp file. I've tinkered with the field types set in the .asp file like the s-columntypes="202,203" (202 is for a text field and 203 is for memo field), but changing the 202 to a 203 for the query doesn't change the result field length.
I created an ASP with frontpage connecting to an access database that contains a memo field. When I connect directly to the table, the entire memo field is returned to the results field. But when I retrieve long text strings including the memo field from a query built into the access database, they get chopped off to a length in the 200 - 300 range (fixed, but haven't counted).
I've looked and looked for a Frontpage control over the field length. I can't see anything in the global.asa or the .asp file. I've tinkered with the field types set in the .asp file like the s-columntypes="202,203" (202 is for a text field and 203 is for memo field), but changing the 202 to a 203 for the query doesn't change the result field length.