Search results for query: *

@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...

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...

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...

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

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 |...

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]

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 |...

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).

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

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?

@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

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...

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

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...

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...

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

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...

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...

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...

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