All Tags » query (RSS)

Browse by Tags

  • How to use Filter out decimal using a query in access

    I have a column in MS access that contains whole numbers and decimals. How do I filter out the rows that cotain decimals and just keep the entries with just whole numbers. RawData 1 2.5 5 6.5 1.3 7 I want the query output to show: 1 5 7
    Posted to Oracle (Forum) by software on 06-17-2010
  • Sum a count a of multple columns

    How do I sum the count of the following queries? Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: Select count(*) from Race_Results where `2` = "55 R" Select count(*) from Race_Results where `3` = "55 R" Select count(*) from Race_Results where `4` = "55 R"...
    Posted to Oracle (Forum) by software on 06-16-2010
  • Sub Query in Select Statement

    In my illustration you'll see I have a table and the expect query results. In order to accomplish this in not one query, as opposed to writing two or three queries to get the expect result, I expect I probably need to utilize the MIN and MAX functions and write a sub query in the select statement...
    Posted to Btrieve (Forum) by software on 06-11-2010
  • T-sql 2005 Procedure

    How do i create a parameter in SQL that takes an unknown amount of values to use in a procedure. Then how would set up a loop thru go thru each value in the array?? ie.. A Procedure would have a parameter that would take a value like this one 543,345,345,6789, There are 4 values here but it could be...
    Posted to Btrieve (Forum) by software on 06-11-2010
  • PHP MYSQL complicated query help

    Hello Experts Sorry but I am rubbish at phrasing questions. I have two tables, deliveries and pre_delivery. The table deliveries already existed as part of a script that I never wrote and the pre_delivery table is new as part of an addon. pre_delivery.pd_status can hold 1 of 3 status's, Sent + date...
    Posted to Oracle (Forum) by software on 06-11-2010
  • Update query / general script problem

    Hi, i have this script below, and it is very on and off. Sometimes it works but then i change a line of code and it stops. I can't for the life of me see whats going wrong, if anything? It redirects but doesn't redirect like it should and fails to perform the update query. Any help? Thanks Alex...
    Posted to Oracle (Forum) by software on 06-10-2010
  • Update query / general script problem

    Hi, i have this script below, and it is very on and off. Sometimes it works but then i change a line of code and it stops. I can't for the life of me see whats going wrong, if anything? It redirects but doesn't redirect like it should and fails to perform the update query. Any help? Thanks Alex...
    Posted to Oracle (Forum) by software on 06-10-2010
  • Sort Query after SQL

    Is it possible to sort a query after I have made an SQL query? If I submit this query: SELECT data FROM table And I have five items in the database: a,b,c,d,e and then I have list like this "e,c,b,d,a" and I want to sort the query according to the list without using SQL. So when I ouput the...
    Posted to ColdFusion (Forum) by software on 06-04-2010
  • LDAP Query - get OU names with ldap query

    Hi experts!!! I'am building intranet app based on LDAP database. With exchange experts help I made page that query LDAP, so I have user names, mail, tel. no. . . . I need to query LDAP for OU names. Is it possible? here is the code posted by WMIF that I used for Intranet app. to get user names. strUser...
    Posted to ASP (Forum) by software on 06-02-2010
  • LDAP Query - ignore disabled users?

    How can I modify the following query to ignore disabled users in Active Directory? name="PhoneList" start="#Portal.LDAPOUStart#" attributes="cn,sn,givenname,department,telephoneNumber,mobile" sort="cn ASC" filter="(&(objectclass=user)(telephoneNumber=...
    Posted to ColdFusion (Forum) by software on 06-02-2010
Page 1 of 91 (904 items) 1 2 3 4 5 Next > ... Last ยป