[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread DIGINEXT
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread DIGINEXT
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread DIGINEXT
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2

[PHP-DB] Re: can OCIBindByName bind an in/out placeholder of plsql

2002-10-31 Thread Fabien JOSEPH
I discovered recently that it was impossible to bind an output placeholder plsql (an input work only). Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3 Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3 Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2

[PHP-DB] Re: Newbie-Question: What's that @?

2002-10-31 Thread rolf vreijdenberger
there is no difference between the two! quote: @mysql_query($query) and @mysql_query($query)? haha but seriously, the @ supresses error messages from php, so these will not be outputted. No information on why or how, the query in this case, it failed. you can do this on a per function basis with

[PHP-DB] Add column to a table

2002-10-31 Thread Shaun Thornburgh
Hi, Please could someone tell me what the syntax is to add a column to a table? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Walter, Marcel
For mysql: Alter table tablename add column column-name columntype; Regards, Marcel -Original Message- From: Shaun Thornburgh [mailto:shaun;mania.plus.com] Sent: 31 October 2002 13:39 To: [EMAIL PROTECTED] Subject: [PHP-DB] Add column to a table Hi, Please could someone tell me what

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Aaron Wolski
ALTER TABLE TableName ADD COLUMN columnParametersHere E.g: ALTER TABLE UserTable ADD COLUMN userName varchar(255); Aaron -Original Message- From: Shaun Thornburgh [mailto:shaun;mania.plus.com] Sent: Thursday, October 31, 2002 7:39 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Add

[PHP-DB] need help with SHOW Colums

2002-10-31 Thread David Rice
mysql_select_db(filterseveuk); $query = ( SHOW COLUMNS FROM user ); $result =  mysql_query ( $query ) or die( mysql_error () ); while ( $row = mysql_fetch_array ($result) ){ $x = 0 ; echo $row[$x] ; $x++ ; } I would like to replace the table name user with

[PHP-DB] cookie trouble

2002-10-31 Thread Seabird
Hi everyone, I'm having some trouble configuring a cookie (first time doing this): I have a login-script and this sets a session cookie. What I really want is to pass a cookie so that returning-people don't have to log in every time, but I'm not sure how to do what part is passing on the cookie

Re: [PHP-DB] need help with SHOW Colums

2002-10-31 Thread 1LT John W. Holmes
So show us the code that you tried with. This code doesn't do us any good because it's not causing the error. ---John Holmes... - Original Message - From: David Rice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 11:31 AM Subject: [PHP-DB] need help with SHOW

[PHP-DB] IIS question

2002-10-31 Thread Ryan Jameson (USA)
offtopic You guys are so smart! Can anyone tell me why IIS gives a 404 error on any file with a .dat extension? Thanks.. /offtopic Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] IIS question

2002-10-31 Thread Ryan Jameson (USA)
Mystery solved: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q309508; IIS Lockdown did it... to fix go to windir\System32\Inetsrv\Urlscan\urlscan.ini and remove the .dat line or other necessary extension. -Original Message- From: Ryan Jameson (USA) Sent: Thursday, October

[PHP-DB] mail()

2002-10-31 Thread Edward Peloke
I know this is off topic to the db list but.. I am attempting to use the mail function. I have set the smtp in the php.ini file to my smtp server but when I run the script, I get the error Warning: Failed to Connect in c:\program files\apache group\apache\htdocs\lg\nuser2.php on line 50 where

Re: [PHP-DB] mail()

2002-10-31 Thread Jeffrey_N_Dyke
did you restart apache? epeloke@echoma n.com (Edward

Re: [PHP-DB] mail()

2002-10-31 Thread Marco Tabini
Did you restart the server? Are you sure you modified the right php.ini? On Thu, 2002-10-31 at 14:53, Edward Peloke wrote: I know this is off topic to the db list but.. I am attempting to use the mail function. I have set the smtp in the php.ini file to my smtp server but when I run the

[PHP-DB] OCISaveLob, OCILoadLob, OCISaveFile?

2002-10-31 Thread Jean Tardy
Hello, Who know haw to use those functions:OCISaveLob, OCILoadLob, OCISaveFile? Where can I find documentation and sample about this general purpose: 'lob object manipulation with oracle Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: MAIL()

2002-10-31 Thread Tony72284
If your sending it from your Server/Computer and then to another server/www . YOu probally don't have permissions to send the mail.

RE: [PHP-DB] mail()

2002-10-31 Thread Edward Peloke
yep and I still get the same error...I modified the ini file in my windows directory..I assume that is the right one. Eddie -Original Message- From: Marco Tabini [mailto:marcot;tabini.ca] Sent: Thursday, October 31, 2002 2:24 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re:

RE: [PHP-DB] mail()

2002-10-31 Thread Edward Peloke
this may be dumb but I for the smtp setting, I simply put in what every is under smtp when I open up the info in outlook...do I need to put it in quotes or anything? -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke;Keane.com] Sent: Thursday, October 31, 2002 2:31 PM To:

[PHP-DB] Re: cookie trouble

2002-10-31 Thread Seabird
I got this fixed, but how do I reverse a md5 encryption? this way I can log people in again. Jacco -- http://seabird.jmtech.ca Attitude is Everything! But Remember, Attitudes are Contagious! Is Yours worth Catching Seabird [EMAIL PROTECTED] wrote in message

RE: [PHP-DB] Re: cookie trouble

2002-10-31 Thread Aaron Wolski
You cannot reverse the encryption of an md5 hash. Nor should you want to. You don't want to know their password which is why you encrypt it. When you seyup an account you convert the password to an md5 has(I assume you have done so). When they log back in.. You convert the password to an md5

Re: [PHP-DB] Re: cookie trouble

2002-10-31 Thread Mark Nenadov
On October 31, 2002 02:48 pm, Seabird wrote: I got this fixed, but how do I reverse a md5 encryption? this way I can log people in again. Jacco You can't reverse md5. All you need to do is compare an md5'ed copy of what the user entered to what you have in your database (or wherever

RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?

2002-10-31 Thread phplists
The query should look similar to this: SELECT table1.col as [column_a], table2.col as [column_b] FROM table1 LEFT JOIN (or LEFT OUTER JOIN) table2 ON table2.some_key_col = table1.some_key_col ... for all required keysWHERE search condition -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Multiple table select, but still returning row if no record exists in second table?

2002-10-31 Thread phplists
The query should look similar to this: SELECT table1.col as [column_a], table2.col as [column_b] FROMtable1 LEFT JOIN (or LEFT OUTER JOIN) table2 ON table2.some_key_col = table1.some_key_col ... for all required keys WHERE search condition -- PHP Database Mailing List

[PHP-DB] Restarting Mysql

2002-10-31 Thread Michael Conway
I'm debugging a script that locks tables as part of an INSERT script (using Linux 7.1). Mysql frequently locks out the tables involved when there is an error (never gets to UNLOCK command. I have been rebooting until now. Using % mysqladmin shutdown works. safe_mysqld doesn't. Any suggestions

Re: [PHP-DB] need help with SHOW Colums

2002-10-31 Thread rolf vreijdenberger
$table=user; $query = SHOW COLUMNS FROM $user ; $result = mysql_query ( $query ) or die( mysql_error () ); while ( $row = mysql_fetch_array ($result) ){ $x = 0 ;// i don't know what you're trying to do here, but it's wrong!! It keeps resetting$x to zero and does nothing with the

RE: [PHP-DB] string

2002-10-31 Thread Beau Lebens
you can do this as a part of your db query check the string functions available for your rdbms. mysql would use something like; SELECT SUBSTRING(monthname(blah), 0, 3) AS monthAbbrev FROM tablename from memory HTH beau // -Original Message- // From: John Coder

RE: [PHP-DB] string

2002-10-31 Thread John W. Holmes
DATE_FORMAT(your_column,'%b') or SUBSTRING() ---John Holmes... -Original Message- From: John Coder [mailto:jcoder;insightbb.com] Sent: Thursday, October 31, 2002 8:47 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] string I want to list months found in db by the first three letters as

RE: [PHP-DB] string

2002-10-31 Thread John Coder
Didn't even think of looking for a mysql function to accomplish this. Thanks. On Thu, 2002-10-31 at 20:52, Beau Lebens wrote: you can do this as a part of your db query check the string functions available for your rdbms. mysql would use something like; SELECT

[PHP-DB] Fw: Dows anyone know why this was bounced?

2002-10-31 Thread Robert Twitty
Does anyone know why all mail that I send to any aspect of the php-db list is bounced when it is sent from the address below? -- bob - Original Message - From: Robert Twitty [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 9:39 PM Subject: Returned mail: see

[PHP-DB] Am I doing This Right?

2002-10-31 Thread Tony72284
?php function war3_replays_submit() { if ( isset($replay_file) ) { $htmlHead = ; pgHead('Shadow Legion :: Warcraft III Replays', $htmlHead); // Get Current DB Entrys $rDB = mysql_query(select * from war3_replays where 1); // Select

Re: [PHP-DB] Restarting Mysql

2002-10-31 Thread Jason Wong
On Friday 01 November 2002 09:04, Michael Conway wrote: I'm debugging a script that locks tables as part of an INSERT script (using Linux 7.1). Mysql frequently locks out the tables involved when there is an error (never gets to UNLOCK command. I have been rebooting until now. Using %

Re: [PHP-DB] Am I doing This Right?

2002-10-31 Thread Jason Wong
On Friday 01 November 2002 15:05, [EMAIL PROTECTED] wrote: ?php function war3_replays_submit() { if ( isset($replay_file) ) { Doing what right? Where/what is the problem? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design