Heya
I've got a table of invoices, which have dates and customer_id's. What I need to get is the number of occurances for this customer for a 12-month range window. For example, if there's an invoice for october for a certain customer - i want to count how many other invoices appear are for this customer in the 12 months from that invoice date. Similarly, if there's an invoice in november, that should show the number of occurences...
uninvitedm
Last Activity: Aug 22 '07, 08:52 AM
Joined: May 24 '07
Location:
-
PL/SQL -- 12-month range window count
-
Thanks, sure. I've tried
Just returns '0' each time, and obviously displays both columns together.. was thinking along those linesCode:nvl (column1||column2, 'NB') column1
Also tried combining the two values using a DECODE so if both columns are null, show 'NB' for column1 -- but the following code
doesn not work.. has the error 'invalid number'Code:DECODE (column1||column2, 0, 'NB', column1) column1
... -
PL/SQL - changing one column's value depending another column's value
I have a table which I'm extracting data from with a SELECT statement(and outputing as a text file), there's some changes I want to make to the extracted data before it is output (not the actual data on the table).
There's column1 and column2.
column1 has some null values. I want these values to be a certain value 'NB' if they are null AND if column2 is null as well! If there is a value in column2, then these can stay null.... -
jsp -- not enough session space
Hiya..
I have a jsp page to upload some files..
The session is used to store a Map ( session.setAttr ibute("filemap" , filemap ) ). This map contains all the files to be uploaded. I have a file-input type, onChange the file here is added to the map. The map is stored in the session and when the page is reloaded, all files in the map can be displayed. Then the user clicks upload, and all the files are uploaded... -
https -- connection probs
I had the following code to connect to a site on a server. It worked fine, now the server is using https, which causes the error
javax.net.ssl.S SLHandshakeExce ption: java.security.c ert.Certificate Exception: Couldn't find trusted certificate
...Code:java.util.Properties propSy = System.getProperties(); propSy.put("java.protocol.handler.pkgs","com.sun.net.ssl.internal.www.protocol"); -
uninvitedm started a topic JSP - uploading multiple files 'post' not working off server (works fine on localhostin JavaJSP - uploading multiple files 'post' not working off server (works fine on localhost
I'm making a JSP page where (ideally) you select files to upload, each selected file is added to a listbox. The form is submit, (along with some other parameters), and the files are uploaded. They arent uploaded (written) tradionally to a server, I just need the file's input stream to pass to a method elsewhere (which will upload to a database).
The page has a file-input type to locate files to upload. Once a file is selected (onChange()),...
No activity results to display
Leave a comment: