baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from Christoph Bergmann on 11/28 2003, 18:51 +01:00
    EMail: info@baseportal.com

    Re: Columns displayed


      By default the max. fields in table view is 5, but you can set it to any number you like with

      listfields=#10

      would show up 10 fields. Or you write the fields one by one:

      listfields=Lastname,Forename...etc.


      The code you've posted looks fine, but use "listfields" instead of "Listfields" (NO capital L):



        if($Password ne "" && $Password eq $password_in)
        {
        
          do_all "db=Wyspas_database sort=Lastname listfields=Lastname,Forename,Gift_Aid,notes,Status,Address_1,Address_2,Address_3,County,Postcode,Phone,Mobile,Fax,Email", "name_in", "password_in";

        } else etc ....


      shoudl work... If not, pls give a link to your page...

    Your reply:

    Name: EMail: WWW:
    Subject:
    Text:
    Timezone:

    Post a new message


 All messages from this thread: To the list 
    Message from Roy on 11/28 2003, 12:12 +00:00
    EMail: roy@wyspas.info

    Columns displayed


      No matter what I do I cannot get more than 5 columns to display. Is there any way I can increase this number?
     Post a reply

    Message from kerry on 11/28 2003, 14:18 +00:00
    EMail: kerry.home@att.net

    Re: Columns displayed


      roy
      maybe they will display
      that many in detail view only
      try it.. go to page...settings and scroll down to view type
     Post a reply

    Message from Roy on 11/28 2003, 14:59 +00:00
    EMail: roy@wyspas.info

    Re: Columns displayed


      I'm already in table view. I think the answer lies somewhere in the Perl script but I can't solve it.

      I currently have

        if($Password ne "" && $Password eq $password_in)
        {
        
          do_all "db=Wyspas_database sort=Lastname Listfields=Lastname,Forename,Gift_Aid,notes,Status,Address_1,Address_2,Address_3,County,Postcode,Phone,Mobile,Fax,Email", "name_in", "password_in";

        } else etc ....

      Which I'm sure worked the first time I tried it but I accidentally overwrote the script and now it doesn't work :(
        
     Post a reply

    Message from kerry on 11/28 2003, 16:21 +00:00
    EMail: kerry.home@att.net

    Re: Columns displayed


      if it was over writen maybe theres some kind of a log file in your computer for it
      or if you did this while online there may be a off line page or file. temp file
      or if you have windows xp. maybe you can try the system restore option.
      start menu...help and support...look for the SYSTEM RESTORE TAB..restore to a earlyer pount or date you think you can find it. if it fails you can allways go back to the beginning and cancel your last restore point to reset it. caution..i only think this may work. if it dont you just wont find it and then cancel last system restore
        

     Post a reply

    Message from Christoph Bergmann on 11/28 2003, 18:51 +01:00
    EMail: info@baseportal.com

    Re: Columns displayed


      By default the max. fields in table view is 5, but you can set it to any number you like with

      listfields=#10

      would show up 10 fields. Or you write the fields one by one:

      listfields=Lastname,Forename...etc.


      The code you've posted looks fine, but use "listfields" instead of "Listfields" (NO capital L):



        if($Password ne "" && $Password eq $password_in)
        {
        
          do_all "db=Wyspas_database sort=Lastname listfields=Lastname,Forename,Gift_Aid,notes,Status,Address_1,Address_2,Address_3,County,Postcode,Phone,Mobile,Fax,Email", "name_in", "password_in";

        } else etc ....


      shoudl work... If not, pls give a link to your page...

     Post a reply


    Message from kerry on 11/28 2003, 21:58 +00:00
    EMail: kerry.home@att.net

    Re: Columns displayed


      AAHA
      thats it chris
      i ben looking for a way to arrange the fields the way i want

      so doing this

      would show up 10 fields. Or you write the fields one by one:
      listfields=Lastname,Forename...etc.


      will do this
      field1
      field2
      field3

      unsted of this

      fiwld1 field2 field3

      right???
     Post a reply

    Message from Christoph Bergmann on 11/29 2003, 18:48 +01:00
    EMail: info@baseportal.com

    Re: Columns displayed


      No. What you control with "listfields" is, which fields and in which order they should appear in the output...

      If the normal arrangement of your fields is i.g. "Field1", "Field2", "Field3" you can rearrange the output with

      listfields=Field2,Field3,Field1

      If you want a completely free design for your output, use "loop". Pls read the documentation about it:

      http://baseportal.com/doku/index.html#a34
     Post a reply

    Message from roy on 12/10 2003, 13:01 +00:00
    EMail: roy@wyspas.info

    Re: Columns displayed


      Thanks Christopher. I've been away and only just seen your response. I'll give this a try immediately.
     Post a reply

    Message from roy on 12/10 2003, 13:09 +00:00
    EMail: roy@wyspas.info

    Re: Columns displayed


      It works!!

      But then, you knew it would :)

      Thanks
     Post a reply

    Message from Roy on 4/21 2004, 21:53 +00:00
    EMail: roy_taylor@ntlworld.com

    What's wrong with this.


      I had a database that worked fine but then accidentally overwrote the page (html) file. I've tried to regenerate the code as follows:

      <perl>
      if($name_in ne "")
      {
      get "Name==!$name_in", "users";
      if($Password ne "" && $Password eq $password_in)
        {
          do_all "db=Wyspas_database sort=Lastname listfields=Lastname,Forename,Status,Gift_Aid,Address_1,Address_2,City,County,Post Code,Phone,Mobile,EMail,Comments", "name_in", "password_in";
        } else
        {
          out="Access denied! Invalid user name or password. Please remember that all user names and passwords are case sensitive. Please try again ";
        $name_in="";
        }

      }

      if ($name_in eq "")
      {
      out <<EOF;

      <h2>Sign in</h2>Please sign in:
      <form action="/cgi-bin/baseportal.pl?htx=$htx" method="post" enctype="multipart/form-data">
      <input type=hidden name="htx=" value="$htx">
      <table>
      <tr><td>Name:</td><td><input type="text" name="name_in="></td></tr>
      <tr><td>Password:</td><td><input type="password" name="password_in="></td></tr>
      <tr><td></td><td><input type=submit value="Sign in"></td></tr>
      </table>
      </form>
      EOF

      }
      </perl>

      Unfortunately I keep getting the following error message which I'm afraid means nothing at all to me.

      [ Error: Perl error in :
      Can't modify non-lvalue subroutine call in scalar assignment at (eval 124) line 10, at EOF ]

      Each time I run it the eval number changes. Can anyone please tell me what I've done wrong?

      Thanks

      Roy

     Post a reply
     
 Messages from 3000 to 3150: To the input form 
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



baseportal.com