Thanks! That did the trick.
On Aug 19, 2:52 pm, Randall Randall <[EMAIL PROTECTED]>
wrote:
> On Aug 19, 2007, at 1:41 PM, Raphael Lullis wrote:
>
>
>
> > Hi, all.
>
> > I'm trying to build a query using the LIKE operator. I'm using
> > PostgreSQL 8.1, web.py, python2.4, all in windows.
>
> > If I do something like this:
>
> > web.query("SELECT * FROM foo WHERE bar LIKE 'test%'")
>
> > I get an exception in line 338 from db.py
>
> > out = cur.execute(sql_query.s, sql_query.v)
> > IndexError: tuple index out of range
>
> I don't know this for certain, but possibly the problem
> is the stray '%'. If you use '%%' instead and it clears
> up, then that was the problem. ('%%' is the string
> substitution for a literal '%', where otherwise '%' begins
> a substitution point).
>
> --
> Randall Randall <[EMAIL PROTECTED]>
> "Hey, Mr. Record Man, your system can't compete;
> It's the new artist model: File Transfer Complete..."
> - MC Lars, "Download This Song"
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
