[PHP-DB] Re: how to question...

2002-04-05 Thread Michael Virnstein
quite simple, look here: http://www.php.net/manual/en/function.readdir.php "Jas" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok here is what I would like to accomplish, I am sure someone has done > something like this but I need an example to go from

[PHP-DB] Re: insert syntax

2002-04-11 Thread Michael Virnstein
you can only insert into one table at a time. if these statements depend on another and your db is able to generate transactions, then you can insert into your tables one by one and then commit the transaction on success or rollback it in the end, if a insert fails. if you're db isn't able to gene

[PHP-DB] Re: MAX for a column

2002-04-16 Thread Michael Virnstein
If you want the max if HUF, KM, EURO, KUNA you should do $sqlquery = "SELECT MAX(HUF) as HUF,MAX(KM) as KM, MAX(EURO) as EURO, MAX(KUNA) as KUNA from $table limit 1"; "Ron Allen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am trying to determine how

[PHP-DB] Calling Oracle Functions

2002-04-30 Thread Michael Virnstein
Hi, i have the following problem: (database Oracle 8.1.7) we got a package ACCESSLIST with a function GETRIGHTS. this function returns a cursor. So what i want now is calling this function and walk through the returned cursor: this is what i have so far, but it brings me some errors: $query = "B

[PHP-DB] Re: Calling Oracle Functions

2002-04-30 Thread Michael Virnstein
nyone knows if i can access the oracle function through php or do i need a procedur with an out parameter as wrapper for php? Regards Michael "Michael Virnstein" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > i h

[PHP-DB] Re: Calling Oracle Functions

2002-04-30 Thread Michael Virnstein
nyone knows if i can access the oracle function through php or do i need a procedur with an out parameter as wrapper for php? Regards Michael "Michael Virnstein" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > i h

[PHP-DB] passing php array to an Oracle function

2002-05-17 Thread Michael Virnstein
Hope there's any Oracle Guru around. :) Oracle 8.1.7: Asuming that I have the following object type: Create or Replace Type Test_Table_type as object (PK number(10,0), name varchar2(100)); and that I have the following package: Create Package Test_Pkg Is Type test_array_type is varray(10

[PHP-DB] Re: Operations on a string?

2002-05-17 Thread Michael Virnstein
MessagePlease change your email settings to plain text, not html. I'd suggest using PCRE (http://www.php.net/manual/en/ref.pcre.php). Regards Michael "Chris Payne" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 01c1fe01$0f020ea0$f7fea8c0@chris">news:01c1fe01$0f020ea0$f7fea8c0@chris... Hi th

[PHP-DB] Re: passing php array to an Oracle function

2002-05-17 Thread Michael Virnstein
begin"; and then i loop through my php array, extending the $query string which sets elements for my_array in the sql. when i execute this, it works properly. Regards Michael "Michael Virnstein" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[E

[PHP-DB] Re: Can't use iso8859-2 with PHP+Oracle

2002-05-22 Thread Michael Virnstein
the character set of the database is perhaps ascii7bit. change it to ascii8bit or to your ISO characterset, using "alter database" command. Ascii8 is the most flexible and should be used if you want to support more than one language. Could be found here: http://technet.oracle.com/doc/oracle8i_816/

[PHP-DB] Re: Can't use iso8859-2 with PHP+Oracle

2002-05-22 Thread Michael Virnstein
> The database nls_characterset and nls_nchar_characterset are also > EE8ISO8859P2. Oops, overwrote this...hmm...don't really know then. > EE8ISO8859P2 hmm...not WE8ISO8859P2? but don't know exactly. for german it is GERMAN_GERMANY.WE8ISO8859P1 Regards Michael "Mi

[PHP-DB] Re: php+oracle+win2000

2002-05-23 Thread Michael Virnstein
did have the same problem. but it worked after i installed a database locally. The Oracle Installers are quite a pain in the ass. Could be possible that there is something missing if you only install the client. but i'm not sure what. Michael "Mauricio" <[EMAIL PROTECTED]> schrieb im Newsbeitrag

[PHP-DB] Re: Working with dates

2002-05-23 Thread Michael Virnstein
www.php.net/mktime "Manuel" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Can anybody help me with this? > > How do you take a known date and add three month to it? > > Example: > > $effdate= "1/15/2002" > > > > - > Do

[PHP-DB] Re: sessions

2002-05-23 Thread Michael Virnstein
make sure that there is no character anywhere before session_start(). this also includes whitspaces. so check you're files, if there are whitspaces before the . of course you also cannot send any other characters or html to the browser before session_start is called. A workaround could be done usi

[PHP-DB] Re: Retrieving a date from Oracle. Please help!

2002-05-23 Thread Michael Virnstein
you can look here: http://technet.oracle.com/doc/oracle8i_816/server.816/a76966/ch2.htm Michael "Maxim" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi all! > The problem is I can't get expected datetime value from SELECT query on > Oracle table that