Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Re: Re: Trouble updating value of variable for a placeholder

by peppiv (Curate)
on Jun 14, 2002 at 18:43 UTC ( #174687=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: Trouble updating value of variable for a placeholder
in thread Trouble updating value of variable for a placeholder

stajich Thanks for the help. I've tried printing $limit. It returns '0' when I first call the sub, which is what I want. LIMIT 0,10 returns rows 1-10. The second time I call it it returns 10, which is also what I want. LIMIT 10,10 returns rows 11-20. But for some reason it bugs out.

Still getting the error:

You have an error in your SQL syntax near ''10',10' at line 1 at /usr/local/etc/httpd/cgi-bin/return.pl line 590.

Which is where LIMIT is used.

Aarrggggh!

peppiv


Comment on Re: Re: Re: Trouble updating value of variable for a placeholder

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://174687]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2015-07-30 02:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls