Code Comments
Programming Forum and web based access to our favorite programming groups.One of my projects recently encountered a glitch. Its php4 and mysql3.2 on linux through apache. The app collects a list of parts and formats a printed worksheet. The users enter a ref number for each part which the php prefixes with a 'group' identifier (A). The whole part ref (A1,A2,A3...) is stored with the rest of the job in the lines table. The display routines pull the lines in from the db and sort by left($ref,2) so the A10 comes after the A1. For a short period, the new entries were coming back unsorted. This was in a period of unusually high server usage (1-2hrs) from elsewhere in the network. Could the database write's have been affected by the server load ? The raw data looks ok. Could a user have sneaked in some control chars ? Validation is v.poor (!). New entries now are fine, the corrupted entries remain unsortable. cheers
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
Powered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.