HI, I'm also getting this kind of error.
This will show when I do the edit function
http://screencast.com/t/hGSbe1vt
and this when performing the delete
Error: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near
On 2014-02-25 17:37, nowebdevmy...@gmail.com wrote:
HI, I'm also getting this kind of error.
This will show when I do the edit function
http://screencast.com/t/hGSbe1vt
and this when performing the delete
Error: You have an error in your SQL syntax; check the manual that corresponds to
your
On Mon, Dec 9, 2013 at 12:41 AM, Jai jaiprakashsingh...@gmail.com wrote:
sql = insert into `category` (url, catagory,price) VAlUES
('%s', '%s', '%s')%(link1,x,y)
Is that VALUES or VAlUES or VAIUES? It probably should be VALUES.
--
On Wed, Dec 11, 2013 at 3:23 AM, Dan Stromberg drsali...@gmail.com wrote:
On Mon, Dec 9, 2013 at 12:41 AM, Jai jaiprakashsingh...@gmail.com wrote:
sql = insert into `category` (url, catagory,price) VAlUES
('%s', '%s', '%s')%(link1,x,y)
Is that VALUES or VAlUES or VAIUES? It
from BeautifulSoup import BeautifulSoup
import re, urllib2, MySQLdb
#MySQLdb.escape_string( )
import sys
import unicodedata
if __name__==__main__:
#link = raw_input(Enter the url link: )
db = MySQLdb.connect(localhost,root,, ebay)
cursor=db.cursor()
link =
On Mon, Dec 09, 2013 at 12:41:57AM -0800, Jai wrote:
sql = insert into `category` (url, catagory,price) VAlUES ('%s',
'%s', '%s')%(link1,x,y)
sql = unicodedata.normalize('NFKD', sql).encode('ascii','ignore')
cursor.execute(sql)
ProgrammingError: (1064, You have an
On Mon, Dec 9, 2013 at 7:41 PM, Jai jaiprakashsingh...@gmail.com wrote:
for x , y in zip(lst_content, lst_price):
sql = insert into `category` (url, catagory,price) VAlUES ('%s',
'%s', '%s')%(link1,x,y)
#print sql
sql = unicodedata.normalize('NFKD',
On 09/12/2013 09:32, Daniel Watkins wrote:
On Mon, Dec 09, 2013 at 12:41:57AM -0800, Jai wrote:
sql = insert into `category` (url, catagory,price) VAlUES ('%s', '%s',
'%s')%(link1,x,y)
sql = unicodedata.normalize('NFKD', sql).encode('ascii','ignore')
cursor.execute(sql)