So I think you're encoding it as an Authorization Header?  

In that case, you can extract this from

set Auth = %request.GetCgiEnv("HTTP_AUTHORIZATION")

then process this however you need to (for example if you have something like "Basic 123908109abc", this will unpack it and decode the Base64)

 set AuthType = $P(Auth," ",1)
  set AuthString = $P(Auth," ",2)
    set DecodeAuthString = $SYSTEM.Encryption.Base64Decode(AuthString)
    set userid = $p(DecodeAuthString,":",1)
    set token  = $p(DecodeAuthString,":",2)

If you're iterating that would typically be done with a CURSOR.  Each fetch cycle would pop the new state of the variables in, in line with each row (make sure you check for SQLCODE while doing this, to determine if there is a row to fetch).

More documentation on this is at

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

EDIT:

Mixed my dynamic SQL methods there.  You would use rset.%Next to do this iteration in %SQL.Statement, but the general theory still holds

http://localhost:57773/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_dynsql#G...

HI Minu


GBLOCKCOPY is used to create a smaller database, after some data is removed and leaves sparse space in the database.  If your database is full, then copying it will not save space.  Before anything else, you should check the size of your globals and remove any data that you do not need.  GBLOCKCOPY should then reclaim some space for you

Hi Kishan

A method is attached to a specific instance of an Object class.  A Classmethod can be called without having to instantiate the object.

So, we could have a Method on a Person object to update address

do person.UpdateAddress("New address")

Whereas, for a ClassMethod, we could define a Classmethod to give us as object instance to then work on

set person = ##class(User.Person).CreatePerson("FirstName","LastName",Age)

 

Hope that helps?

Hi Confused

If you're a Trak customer, your best option is to raise a TRC to have the appropriate Support team assist.  However, IE11 isn't a fully supported platform for Layout Editor, though it will work.  You will need the Microsoft DHTML Editing Component at a minimum, this can be obtained from

https://www.microsoft.com/en-gb/download/details.aspx?id=8956

Hope this helps

Chris