Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.006 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'string.': 0.05; 'subject:code': 0.07; '(mysql,': 0.09; 'keys,': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'subject:Help': 0.11; 'python': 0.11; 'columns': 0.16; 'message-id:@4ax.com': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'subject:PLEASE': 0.16; 'trying': 0.19; 'fit': 0.20; 'url:home': 0.24; 'primary': 0.26; 'values': 0.27; 'header:X -Complaints-To:1': 0.27; 'van': 0.27; 'tried': 0.27; "doesn't": 0.30; 'work.': 0.31; 'relational': 0.31; 'writes:': 0.31; 'file': 0.32; 'lists': 0.32; 'subject:with': 0.35; 'convert': 0.35; 'add': 0.35; 'consist': 0.36; 'charset:us-ascii': 0.36; 'list': 0.37; 'received:76': 0.38; 'nov': 0.38; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'days': 0.60; 'flat': 0.60; 'simple': 0.61; 'field': 0.63; 'skip:n 10': 0.64; 'subject:this': 0.83; 'database:': 0.84; 'treating': 0.84; '2013': 0.98 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: Help me with this code PLEASE Date: Tue, 05 Nov 2013 19:32:22 -0500 Organization: IISS Elusive Unicorn References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-76-249-25-254.dsl.klmzmi.sbcglobal.net X-Newsreader: Forte Agent 6.00/32.1186 X-No-Archive: YES X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 28 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1383697954 news.xs4all.nl 15943 [2001:888:2000:d::a6]:36102 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:58539 On Tue, 05 Nov 2013 18:15:57 -0400, Piet van Oostrum declaimed the following: >Nick the Gr33k writes: > >> >> IAM STRUGGLING WITH IT 2 DAYS NOW AND I CANNOT GET IT TO WORK. >> >> ALL I WANT IT TO DO IS JUST >> >> 1. RETRIEVE 3 COLUMNS THAT CONSIST OF 3 LONG STRINGS >> 2. CONVERT LONG STRINGS TO LISTS >> 3. ADD SOME CURRENT VALUES TO THOSE LISTS >> 4. CONVERT FROM LISTS TO LONG STRINGS SO I CAN STORE SUCCESSFULLY LIST >> PYTHON DATATYPE TO MYSQL SCALAR STRING. >> >> EVERYHTIGN I TRIED FAILED. > >Then why don't you use the simple solution: use a relational database to store the data? He /is/ using a relational database (MySQL, please, no complaints)... He just doesn't understand what it means to be a relational database: normalization, primary keys, joins, etc. -- so he is treating the database like a flat file and trying to fit into one field multi-valued data. -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/