[PHP-DB] Calling DB2's stored Procedures from PHP

2001-03-21 Thread Jens Kisters
is it possible to call stored procedures on an DB2 Database (assuming you have the DB2-Support up running)? -- Gre aus dem schnen Kleve Jens Kisters rosomm et partner Agentur fr neue Medien GmbH Dienstleistungszentrum am Weien Tor - Eingang B Gocher Landstrasse 2 47551 Kleve / Bedburg-Hau

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Mick Lloyd
Mark I've had similar problems in the past. It's my understanding that you can't pass arrays between scripts, except when using sessions. They seem to transfer in, for example: include("script.php"); require("script.php"); but not in: a href='script.php?var=$var'Pass/a but I would love to

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Rouvas Stathis
I don't think that serialize/unserialize was meant to be used that way. I would try WDDX which is specifically designed for the web. -Stathis. Mick Lloyd wrote: Mark I've had similar problems in the past. It's my understanding that you can't pass arrays between scripts, except when using

Re: [PHP-DB] Sessions and MySQL

2001-03-21 Thread Mark Robinson
Hello Rob, Tuesday, 20 March 2001, you wrote: RW I am trying to implement session support with mysql. I am using RW session.set_save_handler but don't really have a great set of functions does RW anyone have some good ones? Try http://www.phpbuilder.com/columns/ying2602.php3 Mark --

Re: [PHP-DB] PHP, ADO/ODBC and MS Access 97 Queries

2001-03-21 Thread Denis Eltsov
1. In ODBC Data Source Administrator create System DSN to your DB 2. In PHP use $x=odbc_connect("your system DSN","",""); $r=odbc_exec($x,"select * from some_table"); echo(odbc_result($r,1)); http://www.zend.com/manual Best regards Denis Eltsov ""Christie, Darren"" [EMAIL PROTECTED] wrote in

Re: [PHP-DB] PHP, ADO/ODBC and MS Access 97 Queries

2001-03-21 Thread Mark Robinson
Hello Darren, Monday, 19 March 2001, you wrote: CD Can anyone give me any pointers on how I can execute queries in MS Access97 CD from PHP and get the results back using either ADO or ODBC? CD Thanks in advance CD Darren Try http://www.phpbuilder.com/columns/siddarth2228.php3 Mark

Re: [PHP-DB] Yet more strings

2001-03-21 Thread Johannes Janson
Hi, I'm not quite sure but try to play a bit with the '".$row[...]."' part. that looks too much. leave out the "" and/or the period. good luck Johannes ""Mick Lloyd"" [EMAIL PROTECTED] schrieb im Newsbeitrag

Re: [PHP-DB] Yet more strings

2001-03-21 Thread Gary Huntress
When I have exact string matches fail where I don't expect them, and using a LIKE fixes it, the very first thing I check for is embedded whitespace in the data. "foo " and "foo" and " foo " are not the same. If this is the case then IMHO the best solution is to fix the data in the database, but

RE: [PHP-DB] Yet more strings

2001-03-21 Thread Steve Brett
i've had similar problems with mysql. postgres seems happy with having quotes around data pulled back as associative arrays like $data = $result["userid"]; and from using mysql it sometimes likes it that way and sometimes without. the syntax for the string is right as long as the string

Re: [PHP-DB] Transmitting Arrays

2001-03-21 Thread Joe Brown
hmm... looks like you're trying to use seralize(var_name); with out assigning a value to a holder variable. $holder=seralize($var_name); will probably get you further along. also, try: $var_name=unseralize($holder); for the return trip. same goes for urlencode/decode; though you can do two

[PHP-DB] dbm support broken? Please help!

2001-03-21 Thread AK47
I'm trying to build php 4.0.4pl1 with dbm support on my RedHat Linux 6.2 box. I need it to be able to work with apache 1.3.14 mod_auth_dbm. Each time I run: ./configure \ --with-zlib=shared \ --with-xml=shared \ --with-gd=shared \ --with-interbase=shared \ --with-db \

[PHP-DB] CodeCharge IDE (OT)

2001-03-21 Thread Adv. Systems Design
I accidentally entered php.org instead of php.net the other day when I was looking for the php man pages and came across the CodeCharge IDE...I know no tool can foresee all possible situations and therefore cannot be a panacea (or even useful), but I was wondering if there are any users of this

Re: [PHP-DB] Yet more strings

2001-03-21 Thread Mick Lloyd
Gary Thanks for the advice. I had checked the string length to make sure there were no "hidden" spaces (which there aren't in the specific field I am selecting) and have now tried trim() but to no avail. Still fiddling with it! Regards Mick Lloyd [EMAIL PROTECTED] Tel: +44 (0)1684 560224

[PHP-DB] Select where date is in period

2001-03-21 Thread boclair
The database has a table of equipments with date fields for date_online and date_offline. The requirement is to find which equipments were available on a date specified by the user, this being a variable created by the user. My attempts at scripting for the condition where the date_online =

[PHP-DB] SSI

2001-03-21 Thread Pankaj Ahuja
Is it possible to have SSIs in PHP ?? I want to do something like !--#include virtual="side-nav.php3" -- Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] PHP Include

2001-03-21 Thread Beau Lebens
if you include() some php in another script, then variables which exist in the file including the other will be inherited exactly the same as if you had copy-pasted the code, rather than "including" it At 03:22 PM 3/22/01 +0800, Shahmat Dahlan wrote: If I were to break my codes into pieces and