sequel problem

[gilgalbiblewhee]

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

            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:

[Hack]

What is the question?

[gilgalbiblewhee]

why do I get an empty field?

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?

[szlamany]

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