sequel problem

I noticed,, since the code is recycled, that there were "int" and "Cint" wrapping the "request":

Code:

---

            chapter        = request("chapter")
            title    = request("title")
            subtitle      = request("subtitle")

---

I might as well send the code as attachment. I think it's a numerical problem which I can't figure:

What is the question?

why do I get an empty field?

Code:

---

Select title, chapter FROM scarletandthebeast WHERE chapter = ''

---

I might have to do with the field being treated as a number in the coding. It might be necessary to remove the function. I won't have the time to look at it right now. But am I right?

If chapter is not a text datatype - such as CHAR() or VARCHAR() - but is instead a numeric - such as INT then

Select title, chapter FROM scarletandthebeast WHERE chapter = 0

would be appropriate.

btw - it might be pronounced SEQUEL, but it is written as SQL ;)