Re: [phpesp-general] problems with signup.php

[Matthew G. <gr...@mu...>]

No management interface integration is done.  Any improvements are
welcome.
On Thu, 2005-07-21 at 09:37 -0700, Harry Mangalam wrote:
> Thanks!!  It does work with auto single-quoted when I reference it as a 
> standalone web page.  I can see where it can be set to create either 
> embed-able html or a standalone web page, (and it generates a standalone web 
> page in either case, but it's not clear how it should be referenced from 
> another page to embed it, or whether it can be added to a survey 
> automatically from the management interface.  Sine it's a new feature, am I 
> to assume that it hasn't been made available via the management interface?
> 
> If so, I guess I'll start to dive into php.
> 
> hjm
> 
> 
> On Wednesday 20 July 2005 10:46 am, Jim Brown wrote:
> > * Harry Mangalam <hj...@ta...> [2005-07-20 11:29]:
> > > I tried to use the undocumented signup.php script that allows respondents
> > > to make their own logins, but was unable to make it work.  After
> > > correcting the missing paren, it further complained about the 'auto'
> > > designation  in the realm field.
> > >
> > > The insert statement was:
> > >
> > > INSERT INTO respondent (username,password,email,fname,lname,realm) VALUES
> > > ('tacg',PASSWORD('baba'),'hj...@ta...','Harry ','Mangalam',auto)
> > >
> > > and the response was:
> > >
> > > Request failed, please choose a different username.[ 1054: Unknown column
> > > 'auto' in 'field list' ]
> > >
> > > At this point I don't know what the problem is.  'auto' appears to be the
> > > right group, altho it might need to be quoted (?) in some way?
> > >
> > > Any hints?  With this feature, it'll be just about perfect!
> > >
> > > --
> > > Cheers, Harry
> > > Harry J Mangalam - 949 856 2847 (vox; email for fax) - hj...@ta...
> > >             <<plain text preferred>>
> >
> > IIRC, auto is a reserved keyword, so MySQL may be barfing on that.
> >
> > Quoting 'auto' does work.  Should give you what you want.
> >
> > I don't use respondents however, so my knowledge ends here.
> >
> > Best Regards,
> > Jim B.
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> > from IBM. Find simple to follow Roadmaps, straightforward articles,
> > informative Webcasts and more! Get everything you need to get up to
> > speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> > _______________________________________________
> > phpESP-general mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)