Forum OpenACS Q&A: Re: URGENT: db_list problem

Collapse
2: Re: URGENT: db_list problem (response to 1)
Posted by Dan Wickstrom on 02/11/03 06:06 AM
Use an tcl var for the offset.  The pg driver is converting the bind vars to quoted strings, while pg expects an integer for the offset value.  The type mismatch is causing your error.
Collapse
3: Re: URGENT: db_list problem (response to 2)
Posted by Jerome M on 02/11/03 07:51 AM
what do u mean user $ofst instead of :ofst? but is causing an error...

Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  parser: parse error at or near "$"

SQL:
    select msisdn, sms_message, date(date_inserted) as date_i
    from rn1071
    order by date_inserted desc
    limit 30 offset $ofst

TIA

Collapse
4: Re: URGENT: db_list problem (response to 3)
Posted by Tilmann Singer on 02/11/03 08:27 AM
You propably surrounded your query string with { }. Variables won't get substituted in this, only when the string is surrounded by " ".