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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by codefighta
-
sesstion problem
Hello DaButcher, I have changed my php.ini file from session.name = PHPSESSID to session.name = SID (and restarted IIS) But the problem still occurs. Any other ideas? thanks cf- codefighta
- Post #5
- Forum: PHP
-
Problems with BETWEEN clause
To give you the full picture: I am working in PHP using PEAR::DB to access FoxPro (.dbf) files on another server (the application I am writing actually is based on mySql, but I need data from other sources from time to time). The errors are generated by the odbc wrapper in PEAR::DB. Thanks for...- codefighta
- Post #6
- Forum: Microsoft: FoxPro
-
Problems with BETWEEN clause
Hi Stella740pl! Thanks for your quick response! It Works!! Looking at the data dictionary of the app whose tables I am trying to access the types are as follows: date = DPDT type = CINT serialnum = CSTR I am absolutly not familiar with FoxPro and don't know if these are actually FoxPro field...- codefighta
- Post #4
- Forum: Microsoft: FoxPro
-
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...- codefighta
- Thread
- Replies: 9
- Forum: Microsoft: FoxPro
-
sesstion problem
DaButcher, thanks for the hint! The code I listed is 3rd party code and I am not 100% sure what is going on there, but would it make sense that the "SID" in if( !defined( "SID" ) ) is checking whether there is a PHP session ID (SID) is defined or not? In my php.ini file I have this ; Name of...- codefighta
- Post #3
- Forum: PHP
-
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...- codefighta
- Thread
- Replies: 4
- Forum: PHP
-
How can I do this without nested/sub queries?
Thanks rgbean!! That works like a charm! cf- codefighta
- Post #3
- Forum: Microsoft: FoxPro
-
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...- codefighta
- Thread
- Replies: 2
- Forum: Microsoft: FoxPro
-
How can I do this without nested/sub queries?
Thanks swampBoogie! When I went back and tried your solution I discovered that I am pulling data from a FoxPro table for this particular query. Everything else in my project is mySql and I just forgot this. Sorry I am getting the following error: [error_message_prefix] => [mode] => 1...- codefighta
- Post #4
- Forum: MySQL
-
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...- codefighta
- Thread
- Replies: 4
- Forum: MySQL
