Re: JSON translated into SQL by python

2013-11-23 Thread Peter Otten
Aaron G. wrote: > I am new to programming python for JSON to SQL and I was wondering why > this does not work. All the values for entering the DB are correct. The > EnterpriseValue data is not entering the database. > #collect data from JSON source at Yahoo > url = ["db", "http://y.ahoo.it/wlB89"

Re: JSON translated into SQL by python

2013-11-23 Thread Jussi Piitulainen
Aaron G. writes: > I am new to programming python for JSON to SQL and I was wondering > why this does not work. All the values for entering the DB are > correct. The EnterpriseValue data is not entering the database. > > #collect data from JSON source at Yahoo > url = ["db", "http://y.ahoo.it/wl

Re: JSON translated into SQL by python

2013-11-22 Thread Chris Angelico
On Sat, Nov 23, 2013 at 4:54 PM, Aaron G. wrote: > query = "INSERT INTO TABLE temp2 (enterprise) VALUES("+ str(curObservation) > +");" You just put the contents of curObservation into the query, as SQL code. Is that really what you wanted to do? Most likely, you should be using a parameterized q

JSON translated into SQL by python

2013-11-22 Thread Aaron G.
I am new to programming python for JSON to SQL and I was wondering why this does not work. All the values for entering the DB are correct. The EnterpriseValue data is not entering the database. #collect data from JSON source at Yahoo url = ["db", "http://y.ahoo.it/wlB89";] #check all sites che