i have developed a flash/.asp/access ordering system and all works great, i have recently come acrosss a really bizarre behavior in regards to character entry in a field.
there is a text component field in flash that accepts user address information.
there have been no problems with taking that value and dumping it into the database until a user used the “#” character in their address ie( #101 mount mary rd.). when that character is added to the field my entire capture process breaks down and none of the fields from there down will be processed.
i believe that this is a database issue but am not sure since i have tried several tests including changing the databse filed type form memo to text.
the values are capture ala: passedvar = mytextfield.text
is the “#” character being encoded and undecipherable? i dont get it any ideas please pass them on
