baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from Sander on 5/29 2008, 10:19 +00:00
    WWW: fliegen.snowpage.de

    Re: "Get" command and field values with spaces


      use backslash \ instead of slash /

      while in do action 1 backslash is ok, in perl you need 2 backslashes

      get "volunteer~=1 & committee==committee\\ name", "database";

      claus answer is ok, but you can't use range and sort in this example

    Your reply:

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

    Post a new message


 All messages from this thread: To the list 
    Message from baseportaluser on 5/26 2008, 03:00 +00:00

    "Get" command and field values with spaces


      Can someone show me how to use the get command to search and count fields with specified values that may include spaces? I have tried the following which doesn't work, but should give you an idea of what I am trying to do.

      <perl>
      $tot=0;
      get "volunteer~=1 & committee==committee/ name", "database";
      $tot=$_amount;
      </perl>

      Any help will be much appreciated.

     Post a reply
    Message from Claus on 5/28 2008, 20:18 +01:00

    Re: "Get" command and field values with spaces


      Hi,

      try it in this way:


      <perl>
      $tot=0;
      get ["volunteer", "~=", "1", "&", "committee", "==", "Tom Dooley",], "database";
      $tot=$_amount;
      </perl>

      hth

      Claus

     Post a reply
    Message from Sander on 5/29 2008, 10:19 +00:00
    WWW: fliegen.snowpage.de

    Re: "Get" command and field values with spaces


      use backslash \ instead of slash /

      while in do action 1 backslash is ok, in perl you need 2 backslashes

      get "volunteer~=1 & committee==committee\\ name", "database";

      claus answer is ok, but you can't use range and sort in this example

     Post a reply

    Message from baseportaluser on 6/19 2008, 17:31 +00:00

    Re: "Get" command and field values with spaces


      Thank you both for your help!
     Post a reply
     
 Newest 150 Threads: To the input form 
To the input form | Older messages > | Oldest messages >>

Back to the homepage

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



powered in 0.03s by baseportal.com
Get your own Web Database - for FREE!