vba – Cascading combo boxes – Dependent box is empty

I have a table called POHeader that lists the vendor's order numbers and vendor number, as well as other data points for each order.

Sometimes we take a specific order from all of our delivery rules, and I've created an access form to save those exceptions. There are currently two combo boxes on the form, one for the order number and one for the supplier number. I want the Supplier Number combo box to filter only for suppliers that match the order number selected by the user (order numbers may not be unique in some cases).

Here's the VBA I wrote for the AfterUpdate event in the Order ID combo box:

Private Sub PONumber_AfterUpdate ()
Me.VendorNumber.RowSource = "SELECT tblPOHeader.VendorNumber" & _
"FROM tblPOHeader" & _
"WHERE tblPOHeader.PONumber = & # 39;" & Me.PONumber & "& # 39;" & _
"ORDER BY tblPOHeader.VendorNumber"

End Sub

My problem is that the vendor number combo box will remain blank once a purchase order number has been selected. What have I done wrong?

Private Sub PONumber_AfterUpdate ()
Me.VendorNumber.RowSource = "SELECT tblPOHeader.VendorNumber" & _
"FROM tblPOHeader" & _
"WHERE tblPOHeader.PONumber = & # 39;" & Me.PONumber & "& # 39;" & _
"ORDER BY tblPOHeader.VendorNumber"

End Sub

Logic – Is the assumption (the set is not empty) really needed for my proof?

To let $ A $ be a set. I want to prove that the amount is infinite. I used the evidence by contradiction. At first I noticed that the crowd is not empty and then I assumed that the amount is finite and then I get a contradiction.

My question is: is the assumption The set is not empty Is really needed for my proof or you can omit this step.

ajax – custom table + empty values ​​in form_state

In a custom form, I created a table item:

  // Table results.
  $form('table') = (
    '#type' => 'table',
    '#header' => $header,
    '#rows' => $rows,
    '#attributes' => ('id' => 'table-results'),
    '#empty' => t('No results.'),
    '#prefix' => '
', '#suffix' => '
' );

This table is updated when I click on a specific button.

I have to get the output HTML of this table in another function. When I use a dpm ($ form_state-> getValue (& # 39; table & # 39;)); I get an empty array. However, the other values ​​(other fields) can be accessed in $ form_state.

// My second function
public function secondfunction(array $form, FormStateInterface $form_state) {
  dpm($form_state->getValue('table')); // -> empty value...
  dpm($form_state->getValue('textfield')); // I get a value

What do I change in my code to solve this problem?

kubernetes – Forbidden to empty users "" cubic

That's the command

kubectl --namespace=somenamespace   exec -it test sh
Error from server (Forbidden): pods "test" is forbidden: User "" cannot create resource 

There's my kube config

      apiVersion: client.authentication.k8s.io/v1alpha1
      - name: AWS_PROFILE
        value: "test" # refers to aws profile test located in ~/.aws/config,
      command: aws-iam-authenticator
      - "token"
      - "-i"
      - "qa"

aws config is

(profile test)
role_arn = arn:aws:iam::66776776:role/AssumeRoleReadOnly
source_profile = sso
region = us-east-1

I do not understand why the user is empty "" and I have received a forbidden error

Eliminate all empty cells by merging vertically: Google Sheets

I work with a table that contains a number of "sections", eg. For example, if the "URL" column in A1 is set to "google.com/search" and left blank while a number of things related to this URL are executed in another column columns (Suppose we extract all

Tags and list them). Since all of this applies to the same URL, it does not need to be repeated, leaving the URL column blank until A7, when the URL changes to "google.com/about".

I wanted to merge those cells with the cell containing the URL instead of leaving them empty, but I've noticed that I've repeated the same thing a few times:

  • Find a cell with text
  • Drag to the next cell with text
  • Merge vertically
  • To repeat.

That's why I've decided to create a macro. For reference, this is my very first experience with Google Apps Script. So I probably could have made it a lot easier (please tell me if yes!), But I'm glad it took so long because I learned so much.

Anyway, here is my code. You simply select an area and the above procedure applies to all columns.

Disclaimer: The entire code is my own, except for the columnToLetter Function that I stole From the answer of AdamL borrowed on this question

function mergeAtText() {
  var spreadsheet = SpreadsheetApp.getActive();
  var range = spreadsheet.getActiveRange().getA1Notation();
  var toMerge = ();

  var toCheck = ();
  var axis = range.split(":");

  var cols = ();
  var rows = ()
  for (var i=0;i 0){
      temp = (column - 1) % 26;
      letter = String.fromCharCode(temp + 65) + letter;
      column = (column - temp - 1) / 26;
    return letter;

  cols = cols.sort();
  var colList = ();
  for (var i=getColNum(cols(0));i

All comments on code quality, conciseness, etc. are welcome.

mariadb – REGEXP_REPLACE matches, but is not replaced by an empty string

If you have specified a table with a column named files_name, you want to reconcile everything with regex and replace it with nothing after reconciliation.

I have this code, but it matches everything, but it always changes to 0.

UPDATE files SET files_name = REGEXP_REPLACE (files_name, 'S(0-9)?(0-9)?(0-9)E(0-9)?(0-9)K.*', '') WHERE type = 5;

An online regex tester states that my regex is correct and matches as intended, regardless of what I entered in the second '' it never replaces the match.

I use Mariadb 10.3.17

php – abstract gettting array value or null if empty

It is customary that I need NULL If an array key / index is not set, I've considered deconstructing it isset(...) ? ... : ...; into a function like:

function valueOrNull($array,$key){
    return isset($array($key)) 
            ? $array($key) : NULL;

Then I would call it that:

$somePerson->id = valueOrNull($data, 'id');

An alternative

$somePerson->id = @$data('id') or NULL;

I like this way of doing it, but I'm doubtful about it @,

Then $somePerson->id would NULLin the case of a $_POST Prompt to create a new person while the ID is specified as int when loading from the database.

Is this a good idea? Am I too lazy? I just hate to type $array('key')The two-time typing is so annoying.

And what about the naming? valueOrNull? Is that a clear name? Is it too detailed?

Alternatively, this bad practice is to suppress that Undefined Index mistake with the @?

Is there a cleaner way than the ternary?