Fill listbox from the database with several conditions

I want to populate Listbox from the database with two conditions
I have 3 tables project, subproject and contracts
I want to display all contracts in each subproject
There is a relationship between subprojects and projects. Several projects can have the same subprojects.
So I want to fill the list box with all contracts in each subproject under one project

I can already fill the list box with this code:
g.fill.EX_listbox (listbox3, "select * from subprojects, contacts where subprojects.sub_id = contacts.sub_id and sub_id =", "contract_title", "contract_id", convert.ToInt32 (listbox2.SelectedValue));

I can already fill the list box with this code:
g.fill.EX_listbox (listbox3, "select * from subprojects, contacts where subprojects.sub_id = contacts.sub_id and sub_id =", "contract_title", "contract_id", convert.ToInt32 (listbox2.SelectedValue));

I would like to add a project ID as a condition, but it does not seem to work

office 365 – Upload files to the SharePoint library and reference an Excel file to fill in column values

I am brand new in SharePoint. I've been tasked with developing a SharePoint site that makes it easier to find documents and improve their organization than is currently the case on our network drives. I am now trying to set up a specification library.

there are:

  • specifications
  • Standard Specifications Exceptions
  • Exceptions that do not conform to the standard specification

The non-standard exceptions are also divided into four regions where the same exception file name can have different contents.

Originally, I planned to upload everything to a library and use different views to display the information. After reading another question here, it sounds like a separate library is the better approach for each question.

In the end I will probably have about 3K +/- documents to upload. They will be a mix of PDF, XML, DOC and DWG. Each file has a unique name. Some of the file formats are:

NSP 001A820.XML
NSP 100F08M.xml
OPSS 0202.pdf
OPSS 0304.pdf
SSP 101F23.xml
SSP 102S05.xml
MTOD 0101.0700.dwg
MTOD 0202.0400.dwg
OPSD 0100.0100.dwg
OPSD 0100.0110.dwg
SSD 0002.0001.dwg
SSD 0005.0002.dwg

Currently, each of the types defined by the first 3-4 characters is in its own directory. In addition, each directory has an Excel file that contains an index. These are all similar, but column names, number, and position can vary slightly from index to index.

An example index would look like this:

Enter image description here

From this table, I know that SSD 0002.0001.dwg has the title:

Standard structural drawings overlaying the structure

And that his status is:


While I can pull 100 files at once and manually go to the library and enter the column information for each file, this is quite time consuming.

Is there a way to upload the files and retrieve the appropriate column information from the index file?

Is there a better way to do this? So far, I've created a hyperlink formula in each index that points to the file on the network drive.

No idea what is labeled as "this", so support for this question would be very welcome.

Python – Transform an array into a matrix whose elements fill the top triangle of the matrix in Tensorflow

I want to transform an array into a matrix that fills the top triangle of the matrix in one of the following ways

Array to the matrix

in the tf.contrib.distributions.fill_triangularThe triangular matrix elements including the diagonal elements are filled in a clockwise spiral. I tried to follow a series of commands, but it did not work.

ones = tf.ones_like (dummy_expected_output) #size the output matrix
mask_a = tf.matrix_band_part (ones, 0, -1) # Upper triangular matrix of 0s and 1s
mask_b = tf.matrix_band_part (ones, 0, 0) # Diagonal matrix of 0s and 1s
mask = tf.subtract (mask_a, mask_b) # mask of the upper triangle over the diagonal
null = tf.constant (0, dtype = tf.float32)
non_zero = tf.not_equal (ones, zero) #Conversion of the mask to a boolean matrix

Indices = tf.cast (tf.where (nonzero), dtype = tf.int64) # Extract the indices of the upper Trainagle elements

zeros = tf.zeros_like (dummy_expected_output) #size the output matrix
out = tf.add (zeros, tf.sparse_to_dense (indices, tf.cast (tf.shape (zeros), dtype = tf.int64), tf.reshape (x,[-1]), default_value = 0))

This leads to an error. "Error converting the object type to Tensor. Content: [None], Consider converting items to a supported type". I tried to do the casting, but it did not work. Can someone help me please?

GUI Design – How do I use input fields that automatically get a value when I fill in the form?

Imagine we have a warehouse management system. It contains a form in which the user can place an order. The order has some features like:

  • date
  • supplier
  • User who ordered it
  • total price
  • VAT in percent
  • To pay tax in cash

On the right side of the form is a section (actually another form) where you can add products to the order.
The user fills in the order properties (see bullet points above) and adds products to the order.

The total price of the order should only be the sum of the prices of all products added to this order. Therefore, the value can be updated with the correct total price when the list of added products changes. At the same time, this field must be editable because the user may need to be able to change the total price regardless of the actual total price of the products.
The same applies to the tax rate and Tax in money Fields. They must automatically be filled with the correct value based on the default conditions, so that the user can enter fewer fields and leave them with their automatically filled values.

Of course it is contradictory: first, the fields should be filled with a calculated value while the user is busy on the form. On the other hand, the user must be able to easily change the value without the problem of overwriting the user value each time the form recalculates and fills in the automatic fields.

I thought of a comp button or something, but that does not seem to be very clean. The goal is to make the form as smart as possible and to get the user typing, thinking and calculating as little as possible.

Plotting – Fill only parts of a ListLinePlot

I have a set of {x, y} data that shows a reading over time on the y-axis. I'd like to highlight some time periods on my ListLinePlot by only filling the graph on specific Y-ranges (eg 10-20 and 55-96) on the axis.

I tried the methods described here: ListLinePlot Partial Filling

data1 = movavgjoined; data1[[;; 9]]= Zero; data1[[21 ;;]]= Zero;
ListLinePlot[{movavgjoined, data1}, Filling -> {2 -> Axis}]

The output, however, is just the original graphic.

8 – Fill in a field in the form of age with a user name and one with a user ID

Can anyone tell me why this works

Function justatest_form_alter (& $ form, $ form_state, $ form_id) {

global $ user;
if ($ form_id == & nbsp; node_test_form & # 39;) {
$ form['field_owner']['widget'][0]['value']['#default_value']    = & # 39; test & # 39 ;;
return $ form;

but it does not

Function justatest_form_alter (& $ form, $ form_state, $ form_id) {

global $ user;
if ($ form_id == & nbsp; node_test_form & # 39;) {
$ form['field_owner']['widget'][0]['value']['#default_value']    = $ user-> uid;
return $ form;

I would also like to know how to get the current username. If anyone can help, it would be very grateful.

Plotting – ListPointPlot3D Fill in between two lists

I am trying to connect pairs of corresponding points from two lists in a ListPointPlot3D (similar to here, but in 3D). Fill-> {1 -> {2}} It does not work for me, so I assume that the problem must be how to pass the two lists on.

Sigma = DiagonalMatrix[{0.001, 0.001, 0.000001}];
sp = 5;
means1 = flattening / @
Transpose[{Table[RandomReal[{0, 1}, 2]{Sp}], Table[0.8, {sp}]}];
dist1 = mixture distribution[Table[1, {sp}],
table[j, {j, sp}]}]];
means2 = flattening / @
Transpose[{Table[RandomReal[{0, 1}, 2]{Sp}], Table[0.2, {sp}]}];
dist2 = MixtureDistribution[Table[1, {sp}],
table[j, {j, sp}]}]];
n = 50;
data1 = RandomVariate[dist1, n];
data2 = RandomVariate[dist2, n];
ListPointPlot3D[{data1, data2}, PlotRange -> {{0, 1}, {0, 1}, {0, 1}},
  Filling -> {1 -> {2}}]

Oracle – "fire" a trigger to fill up columns that are NOT NULL?

Currently working out of my SQL book. The question is: Create a trigger based on the ENROLLMENT table. The trigger should be triggered before an INSERT statement. The trigger populates all columns that are NOT NULL and columns with foreign key constraints.



--loop to get all our columns whose hook is not NULL

WO created_from || Creation date || enroll_date || final_grade || modified_by || modified_date || section_id || student_id is NOT NULL)

--loop for CHECK constraints from the ENROLLMENT table

INSERT (9.9, 3030 -JAN-99,, 9, 9 9,, 09 09-SEP-99 #, & # 39; 9 & # 39 ;, & # 39; 01-JAN-00 & # 39;);




Line 9 displays an error

Error (9.5): PLS-00103: The "CHECK" icon was displayed when one of the following conditions was expected: (- + case mod not resume non-zero) The current current is present. Date tube

We have an ENROLLMENT table with restrictions on non-NULL columns and ENR-SECT_FK and ENR_STU_FK restrictions as foreign key constraints.

Not sure where I am wrong … I will read the chapter again, but any help would be very grateful!

Ease of Use – When does it make sense to expand a button to fill the parent container and use a full key?

I always find it pretty easy to determine when to apply the stretched button, which can expand its width and fill its parent container. However, doing so for desktop computers is a challenge as we use a lot more storage space and are relatively more difficult to achieve a balanced visual hierarchy.

I reviewed some design systems, but I did not quite understand what the "appropriate scenario" is to apply such a keyboard style. I would like to know if there are any basic or recommended best practice guidelines. Research materials would be a plus!

I'm trying to fill in some gaps on my WordPress development journey?

I have problems with certain concepts related to WordPress and its development. If someone could explain something to me, that would be great!

I understand PHP classes and understand how to create and use custom WordPress types. Are CPT objects of a class, i. H. Is there a "post" object and custom post types are just objects of the class?

The reason I'm asking is: If I create a new custom post type and use functions like "get_the_author ()" for my custom post type, the functions will work, although I did not necessarily define the author when setting up the CPT.

I assume that this is from the post object and the author is a property set by a composer when creating a post type. but here is my understanding a little.

If someone is kind enough to help me connect a few points, I would be grateful.

Thank you in advance.