-1

I'm trying concatenate 2 unicode string but I get an error.

Code:

@app.route('/', methods = ['GET','POST'])
def index():
    form = forms.MyForm()
    rtv = []
    text = u''
    if request.method == 'POST':
        lat = form.latitude.data
        lng = form.longitude.data
        rds = form.radio.data
        sql = text("select place, tweet_id, tweet_text from tweets where ST_DistanceSphere(geom, ST_MakePoint(" + lng + ","+ lat +")) <= "+ rds +" * 1609.344 * 0.62137;")
        result = db.engine.execute(sql)
        for row in result:
            text = text+row[2] #row[2] is a unicode string
            rtv.append([row[0],row[1],row[2]])
        print text
    return render_template('base.html', form = form, rtv = rtv, text = text)
J. Raji
  • 101
  • 2
  • 12

1 Answers1

1

You define text = u'' before statement sql = text("..."). So the exception is 'unicode' object is not callable.

stamaimer
  • 5,169
  • 4
  • 26
  • 48