This query is using 4 tables (incident, facility, incident_status , and incident_status _update). I have attached a picture of the results. The results consists of a Ticket Number, a status (string), and a concatenated date and time column.
What I am trying to do is MAX on the Date_Time field for each group of Ticket_Number. I have referenced the columns that should be showing after a successfull MAX has taken place on the attachment...
damicomj
Last Activity: Dec 18 '13, 02:42 PM
Joined: Sep 23 '10
Location:
-
How do I MAX a query within a query?
-
How do I write a query expression with MAX?
Below is the SQL statement.
I am trying to group by the TICKET_NO and grab the MAX of the MAX_DATE field (which is the STATUS_DATE AND STATUS_TIME combined)
When I run the query, it keeps returning: "You tried to execute a query that does not include the specified expression 'CREATE_DATE' as part of an aggregate function."
Any help is much appreciated.
...Code:SELECT tblIncident.TICKET_NO,
-
ADezzi and NeoPa,
My apologies for not being able to clarify the problem. ADezzi's solution has solved the problem for now, until I have the access to fully test. If it wasn't for both of your hard work, I would be stuck in never-never-land.
Thanks again! -
ADezii, I got an error on line 1: User-defined type not definedLeave a comment:
-
I am trying to get the right-click menu to pop-up when the mouse is right-clicked inside of any textbox (like it normally does). The problem is, I am disabling (or hiding, I am unsure) all of the toolbars for non-admin users. Per my research, I understand that if all of the toolbars are disabled, this also disables the right click menu.
That is why I added this line of code back in to re-enable the right click menus, which was unsuccessful....Leave a comment:
-
How do I disable toolbars but allow copy/paste right click?
I am trying to disable the menus for non-admin users. I have done this successfully but the copy/paste functions (by right-clicking in a textbox) do not work. I have tried enabling the Menu Bar, but this still isn't working.
Traditional Control + C and Control + V work fine. It is the right-clicking the doesn't come up.
...Code:If adminRights = True Or userii = "mjdamico" Then 'Set Admin rules
-
How to find the pattern in a barcode?
I have three barcodes, and I am trying to find the pattern in them and am having trouble. Here are the barcode numbers:
59466115489429
82819484293616
52761742512483
It looks like they are 'Interleaved 2 of 5' barcodes and I have calculated the check digits to be 3, 9 and 5, respectively.
Does anyone know how to find out what method was used to create these barcode numbers? -
How come my RSS feed doesn't always load?
I am having trouble with my RSS script. It loads correctly in Safari, it is displayed as text in Chrome, it doesn't load in Internet Explorer, and it load every 3 or 4 refreshes in Firefox... it is very strange. Here is my code, it loads the data from a sql database. You can see the live page here: http://www.eventvt.com/rss.php
...Code:<?php mysql_connect(DB_HOST, DB_USER, DB_PASS) or die(mysql_error());
-
Thank you, Jking. I have read that the title attribute doesn't help with SEO, but I will take your comment into consideration.Leave a comment:
-
How can I index (SEO) a shortened HREF link?
Here is my predicament. I have a website the display the title of an event. Each event title is cut after a certain amount of characters and an ellipsis (...) is displayed. Google sees these links as "Vermont Maple..." and "Wine Blind Tas..." instead of "Vermont Maple Festival" and "Tastings at the Trapp Family Lodge Wine Cellar", respectively. Does anyone have any suggestions so that I can fit the event... -
What is the proper link syntax of javascript in PHP?
I am trying to create a new link in a javascript function which is in a PHP file. The portion of code that works correctly is:
I tried creating a link...Code:<span class=\"title_txt\"> ‣<a href=\"javascript:openPosting(" . $eventdata[$day]["id"][$j] . ")\">" . $eventdata[$day]["title"][$j] . "</a></span><br>"; -
I ended up using queries insead. this thread can be closed.Leave a comment:
-
How do I bind a textbox after a query?
I have one listbox and two textboxes. The listbox successfully populates with rows from a table. When the listbox is clicked, two values from that row are inserted into the textboxes.
When one of the textboxes is edited, those values are not saved back into the table, obviously. After the listbox is clicked, I want to be able to bind the textboxes to the table. I am not sure how to do this.
Below is my code to populate... -
Thank you both for your time.Leave a comment:
-
How do I get functions to work with Tab Control?
Everything is working fine on my form without the tab control. I added the tab control to cut down on screen space. Ever since I added the tab control, there is one page in which the command buttons do nothing. There are about 5 command buttons that, when clicked, do not perform their specified action. I will list two of them for a examples.
This command button is on a tab located on pgAttachments:
...Code:Private
-
Fancy! Thank you.Leave a comment:
-
Okay, I defined the array inside of the If statement like you said, and I think I am all set now.
details[cntr]=new Array(5);
thank youLeave a comment:
-
Okay, as an example, let's say cntr = 1.
The code in the If statement will get executed because cntr > 0. cntr++ will increment itself to 2.
is giving me the error. I don't see what is wrong with this line because I was using the same code outside of the If statement. Sorry if this is annoying, I am trying to talk...Code:details[2][5]= "<TD><b>" + PAsubtotal + "</b></TD></TR>";
Leave a comment:
-
I am a bit confused. I add one to cntr in the if statement, which should bring the matrix to the next line. I just this to fill in the other columns, but it didn't help. Can you provide a suggestion for me?
...Code:details[cntr][0]= "<TR><TD> </TD>"; details[cntr][1]= "<TD> </TD>"; details[cntr][2]= "<TD> </TD>"; details[cntr][3]=
Leave a comment:
-
Thank you for your reply. I want to grab the value of the select list. There is no error message. If I put this code below the variable delcaration:
alert(regionema il);
it returns "[object]"
Let me know if you need more information.Leave a comment:
No activity results to display
Leave a comment: