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!

  • Congratulations strongm 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

    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...
  2. 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 |...
  3. 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 |...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. infinitizon

    Getting sum at second level grouping

    Hi guys, I'm at a fix currently, I have a database that looks like this No_ Document No_ Job desc Job Category COGS Amount GP JCE26506 PSIV39095 MATERIALS USED Field Service 741360.66 448354.46 706993.80 JCE26506 PSIV39095 LABOUR Field Service...
  9. infinitizon

    Install PEAR on Wampserver 2.2e

    Hello all, I downloaded and install the latest version of wampserver on windows 7, 32-bits and after much tutorials, I realised the need for PEAR. Several tutorials said a PEAR directory was supposed to be bundled along with the wampserver installation; unfortunately that was not so. There is...
  10. infinitizon

    set session time limit on sql server 2008 user session

    Hi all, I have an application (Microsoft Dynamics Nav 09) used in my organisation that sits on SQL Server 2008. Users connect to remotely from their systems and can sometimes stay idle for hours consuming user license on the app(I have to be checking from time to time to bounce idle user)...
  11. infinitizon

    Generate random password

    Hi all, I want to generate random passwords for users on my site and send it to their mail. Rather than re-invent the wheel, I came across this one with a google search <?php //http://www.laughing-buddha.net/php/password/ function generatePassword ($length = 8) { // start with a...
  12. infinitizon

    Passing the summary total into a database table automatically

    Hi all, I dont know if this is possible but I have created a WIP report (WIP report is a kind of report that tells you about your works that you have not finished - Work In Progress) and it is working fine. The challenge is this the GM is now asking that he want an automated process that runs...
  13. infinitizon

    Table-Valued function return values

    Hi all, I have a table-valued function that is supposed to return all records in a table thus: [code] CREATE FUNCTION TransItems (@interval INT) RETURNS @testTable TABLE ( No_ varchar (50) null, [Document No_] varchar (50) null, [Status]varchar (50) null, [Person Responsible] varchar (50)...
  14. infinitizon

    Grouping by week and manipulating headers

    thread767-438413 Hi all, I have a report (created from Crystal reports in VS2008) with a date field and then amounts thus: Creation Date | Total Cost | 0-7 days | 8-30 days | >30 days 11-Jun-2012 | 70,314.51 | 0.00 | 70,314.51 | 0.00 11-Jun-2012 |...
  15. infinitizon

    Combining records from a table with another based on another table

    Ok, I understand the title may not speak exactly what I want to achieve and this may also not be the right forum for it. If my guess above is right, please help me redirect as appropriate. Well, here's an issue I've been trying to work around on MySql (No problem if you are better with MSSQL. I...
  16. infinitizon

    make an accept button like the outlook accept button

    Hi everyone, I need all the help I can get. I'm working on an overtime application form for staffs in my company. In other to accomplish this, the applicant for overtime fills a form and submits. A mail is fired to his supervisor indicating an application is made (the mail contains a link). He...
  17. infinitizon

    Could someone help me with this que

    Could someone help me with this query, it doesn't seem to be performing as expected. SELECT (CASE SUM(DATEDIFF(SECOND,start_time,end_time)) WHEN NULL THEN 0 ELSE SUM(DATEDIFF(SECOND,start_time,end_time)) END)[totalMthSecs] FROM OvertimeApplication WHERE DATEPART(MONTH,apply_date)=5 AND...
  18. infinitizon

    Update a table, get the value updated, insert the value in another table and display the value

    Hi all, I was working with an interesting subject that took me two days to complete. However, I'm not certain of the cost of the query so I thought to post it as a question. Here it is. First, I have a function that gets the alphabeths in a string CREATE FUNCTION [dbo].[GetAlphabeths](@DATA...
  19. infinitizon

    Selecting and combining records from a table with another

    Hi all, I've been working on a seemingly simple stuff for a while but always meeting a road block. Here it is: Table - [Customer Ledger Entry table]: Cust No | Document No | ----------------------- TD101 | PSIV30122 | ----------------------- TDA202 | PSV002202 | -----------------------...
  20. infinitizon

    Schedule a job on a website

    I really need a huge help. If you have ever used an sms portal before (I particularly like the one at smslive247.com and routesms.com; you may need to register first). The idea is that users should be able to say "ok I want to send a message on 12/May/2012 by 3:00pm" by entering the necessary...

Part and Inventory Search

Back
Top