Perhaps you can create a function to serialize the array into text and dump it into a blob in the DB, and have another field(s) with the data you want to search on.. Then unserialize the array when you take it out.
-----Original Message----- From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2:43 PM To: '[EMAIL PROTECTED]' Subject: Structure as a field this is an obvious 'newbie' question, so please bare with me. i'm parsing a lot of data from file, and a good deal of this data is in the form of nested C structs. within any given struct, you might have an array of 256 floats, or an array of 256 structs, with 256 floats, etc, etc. i'd like to have one entry in the field column which can be accessed by name and index. i.e. fieldnameX(1), fieldnameX(2), etc. where the index is the floating point value, a character string, or whatever in an array within a struct. how do i go about doing this, if it's at all possible? (it would seem odd if i had to create n number of fields for each value in an array. especially arrays of large sizes) i'm not looking for the C/C++ or Perl to SQL mechanism, i just haven't found the syntax to create a field of that type in SQL, which is my first, and obvious starting point. thanks, christian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php