Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. infinitizon

    Get the combinations of words

    @jpadie: Thanks, but after much work I was able to resolve it with a small function like so: function fn_combine ($items, $perms = array ()){ if (empty ($items)){ echo join(" ", $perms); } else { for ($i = count ($items)-1; $i >=0; --$i){ $newitems = $item...
  2. infinitizon

    Get the combinations of words

    I have an array like this $myArray = array('a', 'b', 'c'); I want to get all combinations like so a b c a c b b a c b c a c a b c b a Notice it is only a combination of the individual elements in the array (no individuals or doubles). Any ideas please ____________________ A Pessimist...
  3. infinitizon

    Get data in a child parent relationship

    Alright, thanks guys. This is what I was looking for CREATE OR REPLACE FORCE VIEW "V_WB_15_PRD_LV" ("PRD_ID", "P_ID", "PRD_DSC") AS SELECT UPPER(SUBSTR(mdl_dsc,1,3)) AS prd_id, NULL p_id, mdl_dsc AS prd_dsc FROM (SELECT DISTINCT(mdl_dsc) AS mdl_dsc FROM t_wb_15_prd) UNION ALL...
  4. infinitizon

    Get data in a child parent relationship

    Well, the id could be any thing (e.g the first 3 letters of the label) as long as there is a relationship between the id and the parent_id (p_id) that states that this is a child of that
  5. infinitizon

    Get data in a child parent relationship

    Hi all, I currently have a table with data in this format: prd_id | prd_dsc | mdl_dsc ---------------------------------------------------------- 001 | Regular Portfolio | Equities 001-CF-000001 | Fixed Income Fund | Funds 0002 |...
  6. infinitizon

    Get delegate from a table of delegates

    I had always known the query was a simple one just could not figure it out in the past 5 days. All I needed to do was to use the keyword TOP 1 in order to limit the query to the first non-delegated user Sorry for wasting your precious time. [wink]
  7. infinitizon

    Get delegate from a table of delegates

    Hi guys, I have a table named 'tbl_slo_approver_users' that looks like this id | type | sequence | delegate_level | user_name | email | delegated 1 | SLO | 1 | 0 | aaa | aaa@gmail.com | 0 2 | SLO | 2 | 0 |...
  8. infinitizon

    Make a prompt show up on users desktops as controlled by server

    I am running a domain. The DC is Win server 2003; the users have different versions of OS ranging from Win XP to WIN 7. Also, I want the link at login (i.e as soon as you logon to the domain).
  9. infinitizon

    Thumbnail an Image, DO NOT SAVE, load in browser temporarily, discard when page closes

    Thanks @jpadie: Got the jist and it worked well.
  10. infinitizon

    Make a prompt show up on users desktops as controlled by server

    Hello guys, I want all my users to get a prompt (with a click-able website link in it) as soon as they switch on their systems. How can I get this done?
  11. infinitizon

    Thumbnail an Image, DO NOT SAVE, load in browser temporarily, discard when page closes

    @jpadie: Thanks. However, my major challenge is really how to thumbnail on the fly (as soon as the page loads) without saving the thumbnail in any folder on my site...maybe as you have said..."cache it
  12. infinitizon

    Thumbnail an Image, DO NOT SAVE, load in browser temporarily, discard when page closes

    Ok, I know this looks somewhat awkward. However, it is a thought that came to me and I've been thinking of its possibilities and implementation. I have about 40 images stored in my images folder. I want three(3) random thumbnail of the images to be generated each time a page loads. I don't want...
  13. infinitizon

    Create Excel file on the file and send as an Email Attachment

    Can you imagine...I just forgot the mail.Dispose() line after sending the mail.... Silly me!!! Thanks @Rhys666: but I may not be as much as a pro to know all that...If you can give me a link (or some code) that will help though, I'd be grateful Thanks all, It was me afterall
  14. infinitizon

    Create Excel file on the file and send as an Email Attachment

    Ok guys, I have been able to streamline the error, I discover it is the mail process that locks the file that was created. When I commented out the block (in the btn_getRpt_Click sub): If sendMailToUser(email, loc) Then ShowAlertMessage("You request has been processed and an email...
  15. infinitizon

    Create Excel file on the file and send as an Email Attachment

    Thanks guys, I eventually went through the considerations and decided to follow on on it. I was able to modify my code thus Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.Odbc Imports System.Configuration Imports System.Net.Mail Imports Class1 Imports...
  16. infinitizon

    Create Excel file on the file and send as an Email Attachment

    I'm sorry for the first line in the post...It should have been "Hello guys"[wink]
  17. infinitizon

    Create Excel file on the file and send as an Email Attachment

    Hell guys, The closer I get to the completion of this project, the more complex it seems to get. Please help me look at this code Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.Odbc Imports System.Configuration Imports System.Net.Mail Imports Class1...
  18. infinitizon

    Select only the important records

    Well, thanks guys, I think imex's solution works fine. I think you can truely select the first row since ROW_NUMBER() OVER(PARTITION BY apply_date ORDER BY end_time DESC) as RowNum will give each distinct apply date a row number. I however ORDER BY timestamp since I have a timestamp column...
  19. infinitizon

    Select only the important records

    Hi all, I have a database (of overtime applications) that looks like this apply_date | start_time | end_time | overtime_rsn | 1st lvl Sup 2012-11-14 | 13:00:00.000 | 18:00:00.000 | Very good reason | Rejected...
  20. infinitizon

    make an accept button like the outlook accept button

    Ok Friend, Thanks for all the support so far. You have done a whole lot in pointing me in some direction. Really appreciate it.

Part and Inventory Search

Back
Top