Skip to Content.
Sympa Menu

en - Re: [sympa-users] Re: Increasing SQL query length

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Peter Farmer <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-users] Re: Increasing SQL query length
  • Date: Tue, 24 Oct 2006 16:41:02 +0800

Adam,

The HTML standards define the default maxlength for a text input field to be
'unlimited'. Sympa certainly doesnt specify a maxlength parameter in the
template markup. If you can type the whole query into the input field then
it isnt the browser imposing a limit - it must be something on the server
side. You should check by looking at the value stored in the mailinglists
config file after updating it from the web interface - is the query string
stored there in full ? If so it isnt the web interface.

If it is , have you tried entering the query directly into the lists config
file manually (dont forget to rebuild the binary of the config with the
'sympa.pl --reload_list_config' command) to see if that bypasses the
truncation problem ?

If it isnt, it may be a problem with the way the sql query processed inside
sympa - perhaps the sql query line buffer isnt long enough - just
guessing ....


Regards
Peter Farmer

On Tuesday 24 October 2006 6:25 am, Adam Bernstein wrote:
> Hey, sorry to nag, but is there any help here? Merci bien.
>
> ab
>
> Adam Bernstein wrote:
> > I'm full of questions lately. We've got someone trying to use SQL
> > inclusion for a list, and they have a very long SQL query (1088
> > characters) that is getting cut off in the input field on the data
> > sources page. Since the edit_list_request page is generated so
> > dynamically, I can't figure out where that length would be set. I see
> > there's a 'length' key in the hash that defines the sql_query
> > parameter, but as it's currently set to 50, that's obviously not the
> > right place. I'm not sure what that is.
> >
> > Is the field length easy to change?
> >
> > Thanks as always!
> > ab



Archive powered by MHonArc 2.6.19+.

Top of Page