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 Chriss Miller 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: *

  • Users: codefighta
  • Content: Threads
  • Order by date
  1. codefighta

    Problems with BETWEEN clause

    Hello, The sql query (see below) containing a BETWEEN clause does not work. See errors below: SELECT sum(cost), desc, num, sum(qty), serialnum FROM itsim204.dbf WHERE type=6 AND (date BETWEEN '02/01/2004' AND '02/29/2004') AND serialnum='23651A' GROUP by num [message] => DB Error: invalid...
  2. codefighta

    sesstion problem

    Hi, From time to time (no noticable pattern) I get this warning message on a page of my php app: Notice: session_start(): ps_files_cleanup_dir: opendir(C:\WINDOWS\TEMP\) failed: Invalid argument (22) in c:\inetpub\wwwroot\intranet\fccm\include\patUser.php on line 465 The line of code this...
  3. codefighta

    How can I do this without nested/sub queries?

    Hello, I am using ODBC (with PEAR : DB) to connect to foxpro tables (.dbf) from my PHP app and have this in my a table ITEM QTY DATE --------------------- 1234 2 1/23/2004 1234 3 1/26/2004 1234 1 2/12/2004 1234 5 6/18/2004 4321 8 3/21/2004 4321 2 4/11/2004 and would...
  4. codefighta

    How can I do this without nested/sub queries?

    In the db I have this: ITEM QTY DATE --------------------- 1234 2 2004-01-23 1234 3 2004-01-26 1234 1 2004-02-12 1234 5 2004-06-18 4321 8 2004-03-21 4321 2 2004-04-11 How can I get the result below without using sub queries (pre mySQL 4.1)? ITEM JAN FEB MAR APR MAY...

Part and Inventory Search

Back
Top