Is there a max length for a individual query parameter?
Here's the situation. We're taking several bits of info,
concatenating them, blowfishing the result and 'url encode query'
that. The result is a web safe string of characters from 34 to 62
characters (so far in testing on 700+ instances). The result is
stored in an indexed Alpha 80 field. The purpose is for Query
Parameter based authentication.
When the above strings are used as query params, if the string is
shorter than 40 characters when Active4D queries the database it
returns the appropriate record. If the string is longer than 39
characters, the result is zero records found. If the same string (cut
and paste to assure it's the same string) is used via the 4D Query
Editor, the record is found.
Is there any reason for the cut off of the 40th character onward?
Dumping attributes, writing this attribute to output buffer/console/
session, etc, all show the full 40+ characters.
Query([Table];[Table]Field=Substring($attributes{"UID"};1;39)+"@")
locates the appropriate record.
4D Server 2004.4
Active4D 4.0.0
Mac OS X 10.4.6
--
Bart Alcorn
National Service Center
800-500-6421 x 2360
AIM/iChat: balcornnsc
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
