Questions tagged as 'query'

Tagged questions
1
answer

Subquery SQL DB2

I am trying to make a subquery (in a particular column) within the base query. The code is as follows. select z.po_id, max(SELECT etcdc.ship_evnt_tms from COVINFOS.SHIPMENT_EVENT etcdc where etcdc.SHIP_EVNT_CD = '9P' and etcdc.ship_id=scdc.sh...
asked by 17.04.2018 / 21:48
1
answer

Problems to bring content with Query in Wordpress

I'm having a problem with this site web on the side of ALL COURSES. I am wanting to bring in the list all the courses that I am uploading in a Post Type called course, for that I assigned some taxonomies (Edgecam, Radan, Apahacam) where I tell...
asked by 23.04.2018 / 14:50
0
answers

Display MySQL records in a DataGridView

I have a database that stores records from a parent MDI Form, all right there. The problem arises when I require that the records of the BD, are shown in a DataGridView that I have inside a child MDI. I have corroborated different sources:...
asked by 22.04.2018 / 01:58
1
answer

XQuery: How can I return multiple values in formatted return? I do not understand why he returns it to me concatenated

Recently I'm learning XQuery, I've tried the following exercise:    We want to show for each student of the institute (institut.xml) its   name and the subjects that it studies, besides the total of subjects,   ordered by the number of subjec...
asked by 12.04.2018 / 00:08
1
answer

Use an SQL Query as the source of a Model in the Entity Framework

Good morning! I comment, I'm having the need to add a Model in EF, but with the peculiarity that you use a Query SQL as a source of information instead of a table. I tried to do it by the normal ways in the following way [Table("[dbo]....
asked by 09.04.2018 / 14:39
3
answers

I can not insert data in my table

I am learning to insert users in my database, but the data I insert does not appear in the usuarios table, what is the problem? This is my code: <?php if (isset($_POST['submit'])) { $username = $_POST['username']; $password...
asked by 14.04.2018 / 12:56
0
answers

Error creating a user in Oracle

I'm trying to create a user in Oracle and I get the error    can not specify temporary tablespace as default tablespace This is what I am trying to do: create user testuser identified by "test" default tablespace temp temporary tablespa...
asked by 12.04.2018 / 16:05
0
answers

Bring Post with query wordpress

I'm having a problem with this website on ALL's side COURSES. I am wanting to bring in the list all the courses that I am uploading in a Post Type called course, for that I assigned some taxonomies (Edgecam, Radan, Apahacam) where I tell which...
asked by 25.04.2018 / 20:50
0
answers

Access, calculated field. (Tell)

My database has two tables, one attribute of one of them is "Total number of video games", while the other stores the name of the video games. I was wondering, how, through a calculated field (Without needing a query) I could count the number...
asked by 02.05.2018 / 19:21
1
answer

when entering code fill in automatic description

What kind of friends do I have a php from which registers the products in a table but in another table I have loaded the data of the products as they are barcode and name that in the from when entering the barcode it automatically extracts the n...
asked by 02.04.2018 / 00:33