ms office – AppleScript can not retrieve a date as a string

Be warned, I'm a novice in AppleScript and most programmers in general. The main purpose of the script I've been working on is reading information from Excel files and saving it to a FileMaker Pro database. So far, everything works fine except when trying to determine the value of cells with dates. Since the data in the Excel file for the database in which they are to be inserted is already formatted correctly (MM / DD / YY), I would simply like to read them and write them as strings.

The problem occurs here, where AppleScript outputs the values ​​as dates in the format (day of the week, month DD, YYYY at 00:00), even though I tried to read them as strings. Below is a shortened version of the script that shows where the problem occurs.

    tell application "Finder"
    activate application "Microsoft Excel"
    open the first file in folder "Macintosh HD⁩:⁨Users:⁨theUser⁩:Documents⁩:⁨attachments test"
    tell application "Microsoft Excel"
        tell active sheet
            tell used range
                set rowCount to count of rows

                repeat with i from 2 to rowCount

                    set colA to "A" & i & ":A" & i
                    set theDate to get value of range colA as string

                    set rowB to "B" & i & ":B" & i
                    set theTime to get value of range rowB as real

                    set colC to "C" & i & ":C" & i
                    set serialNo to get value of range colC as integer

                    set colD to "D" & i & ":D" & i
                    set pH to get value of range colD as real

                    set colE to "E" & i & ":E" & i
                    set theVolume to get value of range colE as real


                    display dialog "The serial number of row " & i & " is: " & serialNo & " and the pH value is: " & pH & " and the volume is: " & theVolume & " and the date is: " & theDate & " and the time is: " & theTime



                end repeat

            end tell
        end tell
    end tell
end tell

I also tried to solve the problem with a different method by setting a variable for each day, month, and year. However, another problem has been identified where the month is not recognized as a purple word (whatever that means) and instead is blue (again). Nowhere can I find such terms. The screenshot below shows three different methods that I have tried to retrieve from the date in the format (day of the week, month DD, YYYY at 00:00), so that they can be manually reorganized.

Blue is a good color, but I wanted purple
My only guess for the initial problem is that & # 39; as string & # 39; does not work if it is placed after the other parts of the line, but I have no idea why month refuses cooperation. Every guide would be very grateful!

oracle – Can sqlplus retrieve multiple lines at once?

Every day we have the task of saving the results of a query into a CSV file – as the standard edition of sqlplus Execute a query.

The number of records is many millions (do not ask) and the job takes more than two hours.

While trying to improve timing, I wrote a C program (using Oracle ofetch() call), but the performance has not changed … It did not help to increase the size of the Session Data Unit (SDU) (to 1 GB on the client – not sure where the server would hold it).

I then did some research and found that ofen()Collecting multiple lines at once can improve performance significantly – and change my C program to use it instead.

When retrieving 4K lines at once, the timings dropped to 21 minutes – a factor of 10-fold reduction – and provided a lot of fun.

Before we take the trouble to install my new executable on production servers, maybe we should have the stock sqlplus can also do the same multi-line retrieval – if the appropriate command-line options exist?

It can? We use Oracle-11, although if this feature is available in client version 12, we could update the client-side version …

Java – Retrieve and display data from Firebase in an EditText and edit content and save again

I want to retrieve data from Firebase and display it in an EditText and allow the user to make changes to it if necessary

This is an Android note app that Firebase uses as a database

I want to retrieve data from Firebase and display it in an EditText and allow the user to make changes to it if necessary.


public class HomeActivity extends AppCompatActivity {

    private Toolbar mToolbar;
    private FloatingActionButton mFABCreate;

    private FirebaseAuth mFirebaseAuth;
    private RecyclerView mRecyclerView;
    private DatabaseReference mDatabaseReference;

    String mPost_Key;
    String mKey;
    String mTitle;
    String mNote;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_home);

        mFirebaseAuth  = FirebaseAuth.getInstance();
        FirebaseUser lFirebaseUser = mFirebaseAuth.getCurrentUser();
        assert lFirebaseUser  != null;
        String uid = lFirebaseUser.getUid();
        mDatabaseReference = FirebaseDatabase.getInstance().getReference().child("AllData").child(uid);
        mDatabaseReference.keepSynced(true);



        mRecyclerView = findViewById(R.id.recycler);

        LinearLayoutManager lLinearLayoutManager = new LinearLayoutManager(this);
        lLinearLayoutManager.setStackFromEnd(true);
        lLinearLayoutManager.setReverseLayout(true); 
        mRecyclerView.setHasFixedSize(true);
        mRecyclerView.setLayoutManager(lLinearLayoutManager);


        mToolbar = findViewById(R.id.toolbar);
        mToolbar.setTitle("Quick Note");

        FloatingActionButton fab = findViewById(R.id.Add_Data);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                finish();
                startActivity(new Intent(HomeActivity.this, AddActivity.class));
            }
        });
    }

    @Override
    protected void onStart() {
        super.onStart();

        FirebaseRecyclerAdapter lAdapter = new FirebaseRecyclerAdapter(
                Items.class,
                R.layout.show_note,
                RecyclerViewAdapter.class,
                mDatabaseReference) {
            @Override
            protected void populateViewHolder(RecyclerViewAdapter recyclerViewAdapter, final Items items, final int i) {
                recyclerViewAdapter.setTitle(items.getTitle());
                recyclerViewAdapter.setNote(items.getNote());
                recyclerViewAdapter.setDate(items.getDate());

                recyclerViewAdapter.mView.setOnClickListener(new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        mPost_Key = getRef(i).getKey();
                        mTitle = items.getTitle();
                        mNote = items.getNote();

                        editData();
                    }
                });

            }
        };
        mRecyclerView.setAdapter(lAdapter);
    }


    private void editData(){
        startActivity(new Intent(getApplicationContext(), EditActivity.class));
    }


    public static class RecyclerViewAdapter extends RecyclerView.ViewHolder{
        View mView;
        public RecyclerViewAdapter(@NonNull View itemView) {
            super(itemView);
            mView = itemView;
        }
        public void setTitle (String title){
            TextView lTitle = mView.findViewById(R.id.showTitle);
            lTitle.setText(title);
        }

        public void setNote (String note){
            TextView lNote = mView.findViewById(R.id.showNote);
            lNote.setText(note);
        }

        public void setDate (String date){
            TextView lDate = mView.findViewById(R.id.showDate);
            lDate.setText(date);
        }
    }

}



public class EditActivity extends AppCompatActivity {
    private FirebaseAuth mAuth;
    private DatabaseReference mDatabaseReference;
    private FirebaseDatabase mFirebaseDatabase;
    RecyclerView mRecyclerView;

    String mPost_Key;
    String mTitle, mNote;
    String lTitleFire;
    String lNoteFire;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_edit);
        Toolbar toolbar = findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);
        final EditText lTitle = findViewById(R.id.YourTitleEdit);
        final TextView lNote = findViewById(R.id.Your_Note_Add);
        mAuth = FirebaseAuth.getInstance();
        mFirebaseDatabase = FirebaseDatabase.getInstance();
        mDatabaseReference = mFirebaseDatabase.getReference(mAuth.getUid());
        mDatabaseReference.addValueEventListener(new ValueEventListener() {
            @Override
            public void onDataChange(@NonNull DataSnapshot dataSnapshot) {
                Items lGetValues  = dataSnapshot.getValue(Items.class);
                assert lGetValues != null;
                lTitle.setText(lGetValues.getTitle());
                lNote.setText(lGetValues.getNote());
            }

            @Override
            public void onCancelled(@NonNull DatabaseError databaseError) {
                Toast.makeText(getApplicationContext(), "Getting value failed", Toast.LENGTH_LONG).show();

            }
        });

    }

}



public class Items {
    String title;
    String note;
    String date;
    String id;

    public Items() {
    }

    public Items(String title, String note, String date, String id) {
        this.title = title;
        this.note = note;
        this.date = date;
        this.id = id;
    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note;
    }

    public String getDate() {
        return date;
    }

    public void setDate(String date) {
        this.date = date;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }
}    

Fire Base data:

All data

nakrU3ArQNShLzyn9U8X9fAFNeL2

-LopLNpUFmepM8gvCmHS

Date:

I would:

Note:

Title:

My goal is to set the values ​​obtained by Firebase and display them in "EditActivity".

Javascript – retrieve a value from a form

IM tries to test if my code is properly set up to access the text value of a form. I'm just trying to access the text value and then use Console.log to confirm that it's happening.

Here is my code (


        

When I start it in the Dev tools in Chrome, nothing happens. No error and console does not log the value I entered in the form.

product – Magento 1.9 Mysql Query to retrieve data

I'm stuck in some way to get data from Magento 1.9.
The solution I needed is MySQL query so I can collect all the data in a table.

The values ​​in the table that I needed from the different table are
Product ID, name, article number, description, price, image name, image path, meta title, meta description.
I do not know much encoding, so definitely needed MySQL query.
I'm looking forward to a solution from experienced developers. cheers

Is it possible in Unity to retrieve game objects from an unopened scene?

Excuse my English mistakes, I did my best to make myself understood.

On Unity 2017.1 + C #.

I'm trying to do UnitTest to check for possible errors in the scenes.
and if I want to get the gameObjects from the two different scenes,
I can only get the scene that is currently open in the editor.

How can you solve this problem?
Or is this impossible in the Unity mechanism?

Two seconds I have:

I have two seconds

Hierarchy of Scene 1:

Scene1 hierarchy

Scene2 hierarchy:

Scene2 hierarchy

Code:

Code:

Result: Retrieve only the information of the open scene

Result: Retrieve only the information of the open scene