[PHP-DB] error_reporting()

2002-09-30 Thread Ryan Jameson (USA)
I do the following and it says 2047 and still reports no errors. What overrides my setting? Thanks... <>< Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] error_reporting()

2002-09-30 Thread Ryan Jameson (USA)
That looks like it's the problem. I expected the directive to override the setting, but it must work the other way around. :-\ Thanks! <>< Ryan -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:30 PM To: Ryan Jameson

RE: [PHP-DB] Register Globals Question

2002-09-30 Thread Ryan Jameson (USA)
Thank you sir. <>< Ryan -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 4:38 PM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Register Globals Question Whoever told you that was wrong. It will not be d

[PHP-DB] Register Globals Question

2002-09-30 Thread Ryan Jameson (USA)
I was recently told this: "register_globals is a deprecated function due to security problems. It will NOT be available in the next version of PHP. As a result, the recommended way to access is with $_REQUEST["HTTP_USER_AGENT"] instead." This is a joke right? I've got thousands of lines of c

RE: [PHP-DB] variable names

2002-10-01 Thread Ryan Jameson (USA)
Sounds like register_globals is off in php.ini . :-) <>< Ryan -Original Message- From: Brendan Flynn [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:45 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] variable names Hello, I have installed PHP4 with Apache support - the phpin

RE: [PHP-DB] how to disable PHPSESSID from posting in URL

2002-10-01 Thread Ryan Jameson (USA)
From: http://www.php.net/manual/en/function.ini-set.php I believe below says that you cannot change it a run time. :-\ session.use_trans_sid --- "1" PHP_INI_SYSTEM|PHP_INI_PERDIR Strangely enough http://www.php.net/manual/en/ref.session.php says the default is "0" where the abov

RE: [PHP-DB] Retrieve auto_increment value after an insert with ODBC

2002-10-02 Thread Ryan Jameson (USA)
You can select max(aifield) immediately after the insert. :-) <>< Ryan -Original Message- From: Stéphane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Retrieve auto_increment value after an insert with ODBC Hi, I use php

RE: [PHP-DB] Getting valie between two fields? (mysql)

2002-10-16 Thread Ryan Jameson (USA)
select number from table where number < 30 order by number desc limit 1 <>< Ryan -Original Message- From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 11:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Getting valie between two fields? (mysql) I have a tab

RE: [PHP-DB] Getting valie between two fields? (mysql)

2002-10-16 Thread Ryan Jameson (USA)
Ooopss 2 answers is better than none. :-) ... James, can I have a free database too? Just kidding... it's cool you offered. <>< Ryan -Original Message----- From: Ryan Jameson (USA) Sent: Wednesday, October 16, 2002 11:19 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB]

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Ryan Jameson (USA)
Since your goal is to encrypt the card number in the database you'll naturally need a way to decrypt it as well. At that point it seems your concern is that your database will be compromised. That can be avoided easily by creating a single private key and using your own algorithm to encrypt base

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Ryan Jameson (USA)
a timely fashion. You can believe it... or not. I LOVE PHP!!! <>< Ryan -Original Message- From: 1LT John W. Holmes [mailto:holmes072000@;charter.net] Sent: Wednesday, October 23, 2002 2:33 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: Re: [PHP-DB] Credit Card Info &am

RE: [PHP-DB] Number Conversion

2002-10-18 Thread Ryan Jameson (USA)
http://www.php.net/manual/en/function.number-format.php number_format($number); <>< Ryan -Original Message- From: Manoj Japher [mailto:manojjapher@;rediffmail.com] Sent: Thursday, October 17, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Number Conversion hi, I would like

RE: [PHP-DB] catalog system

2002-10-21 Thread Ryan Jameson (USA)
I'll build you one, $70/hr US. :-) <>< Ryan -Original Message- From: Sparks [mailto:alex@;paychoice.com] Sent: Monday, October 21, 2002 7:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] catalog system Greetings, I'm looking for a cataloging system. I've found some but they all deal with

RE: [PHP-DB] Column Defualts

2002-10-29 Thread Ryan Jameson (USA)
No, I believe all databases have an isnull bit flag to go with any column stored. So whether you set it or not the bit is being used. <>< Ryan -Original Message- From: Gerard Samuel [mailto:gsam@;trini0.org] Sent: Tuesday, October 29, 2002 9:47 AM To: php-db Subject: [PHP-DB] Column Defu

RE: [PHP-DB] Column Defualts

2002-10-29 Thread Ryan Jameson (USA)
orithms to be more efficient when jumping to the next row is always the same distance and forces records to be stored sequentially. I'd trade disk space for performance any day... <>< Ryan -Original Message----- From: Ryan Jameson (USA) Sent: Tuesday, October 29, 2002 10:30 A

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

2002-10-30 Thread Ryan Jameson (USA)
Well the only difference I see is the ? ... hehe... but if you are refering to the @ symbol then you are correct ... ignore errors... :-) <>< Ryan -Original Message- From: Marcus Fleige [mailto:marcus.fleige@;gmx.de] Sent: Wednesday, October 30, 2002 5:05 PM To: PHP-Mailinglist Subject:

[PHP-DB] IIS question

2002-10-31 Thread Ryan Jameson (USA)
You guys are so smart! Can anyone tell me why IIS gives a 404 error on any file with a .dat extension? Thanks.. <>< 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, Oct

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ryan Jameson (USA)
if this is checked the value "scoobydoo" will be put into the array with index "checkbox1" which array is dependant on which method your form uses. :-) If it is not checked then there is no entry. in PHP with register_globals on the variable $checkbox1 will equal "scoobydoo" and not be set if

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ryan Jameson (USA)
heckbox object... HTH Rich -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 08:53 To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] HTML Forms question... OK. If I am using the POST method and the checkbox 

[PHP-DB] Access Violation in ISAPI version

2002-11-20 Thread Ryan Jameson (USA)
Has anyone else had problems with the error "PHP has encountered an Access Violation at 098029AE" ... It's talked about at: http://bugs.php.net/bug.php?id=15333 The most frustrating thing is our ISP went above the call of duty to install PHP for me, and now his response is... well read for yo

[PHP-DB] php_mcrypt

2002-11-21 Thread Ryan Jameson (USA)
Has anyone gotten php_mcrypt working with the latest version of php on win32? <>< Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] PDFlib

2002-11-25 Thread Ryan Jameson (USA)
Is this for real? I never knew this either. I almost always send emails to the list by replying to old ones and changing the subject for new threads. I will remember this in the future if I create a thread. I don't imagine Nikos and I are the only two who did not know this. Though I'm sure the

RE: [PHP-DB] Max execution time

2002-12-02 Thread Ryan Jameson (USA)
I'd use this: set_time_limit (3600); <>< Ryan -Original Message- From: Radovan Radic [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 8:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Max execution time Hi all (I post questions although i dont get answers, but i am trying. I m

RE: [PHP-DB] MySQL Array

2002-12-05 Thread Ryan Jameson (USA)
while ($ar = mysql_fetch_array($rs)) echo "". $ar['field1']."".$ar['field2'].""; Make sense? -Original Message- From: Art Chevalier [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:44 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL Array Hello, I am pulling one colum

RE: [PHP-DB] NewB: Return New Record ID...

2002-12-05 Thread Ryan Jameson (USA)
mysql_insert_id if your using mysql ... most other ones you'll have to select max(id) from table after your insert. <>< Ryan -Original Message- From: Doug Coning [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] NewB: Return New

RE: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Ryan Jameson (USA)
javascript seems to be a more likely candidate for this. The function you'd use is: -Original Message- From: dufronte [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 7:36 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Delay Confirmation Hi, I'm still new in PHP..., I have

RE: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Ryan Jameson (USA)
<<<<>>>> Anyway... the what I was saying: function wait10SecondsAndThenGoToADifferentPage(){ setTimeout("window.location.href = 'pageYouWantThemOnWhenDone.php';",1); } <>< Ryan -Original Message- From: Ryan Jameson (USA

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
I think you want: if (isset($variable)){} <>< Ryan -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] passing variables Hello all, I have a login/register screen for my php/mysql db. When t

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
Confirm E-mail: Username: Password: -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] passing vari

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
I missed the part where he was using an image. Without a value property, I don't see how it could pass anything at all A note on my recent post, to emulate register_globals do this: if (!empty($_SERVER)) extract($_SERVER); if (!empty($_GET)) { extract($_GET); } else if (!empty($HTTP_GET

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
Ryan -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 10:51 AM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] passing variables --- "Ryan Jameson (USA)" <[EMAIL PROTECTED]> wrote: > I missed the part where he was usin

RE: [PHP-DB] read a file from local harddisk

2002-12-10 Thread Ryan Jameson (USA)
I won't even ask why... but if you started a webserver on your local machine the file() function does allow you to use http .. so file("http://mymachine/myfile.txt";); that's one way. The other way is to upload the file using HTTP. Neither of these ways are very secure. <>< Ryan -Original

RE: [PHP-DB] email form

2002-12-10 Thread Ryan Jameson (USA)
Try the mail function, you can get creative and use html as well. It's documented: http://www.php.net/manual/en/function.mail.php <>< Ryan -Original Message- From: Ryan Holowaychuk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 4:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB]

RE: [PHP-DB] Crystal Report -> PHP4 / Report Generator

2002-12-11 Thread Ryan Jameson (USA)
If you're still using MSSQL7, I'd recommend installing Crystal Enterprise on the winApache machine. There's no reason that you need to give up Crystal to change to PHP. If you're looking for a freeware solution, good luck. Let me know if you find anything good. I looked to replace crystal about

RE: [PHP-DB] services in php/mysql

2002-12-11 Thread Ryan Jameson (USA)
i've done this in a couple ways... If you are running linux you can set up a cron job to run regularly. You can also configure a remote machine to fire the job by using a command line browser like wget. A lot depends on what's available to you. <>< Ryan -Original Message- From: Edward P

RE: [PHP-DB] Remote Oracle database questions...

2002-12-11 Thread Ryan Jameson (USA)
One thing I can help with is TNSNAME. It was very confusing for me at first, it's kind of like an alias on steroids... It is a necessary part of connecting to an Oracle server. TNSNAMES are declared in a file called... go figure... tnsnames. Even good Oracle DBAs run into confusion because the t

RE: [PHP-DB] A help on relational databases using php

2002-12-12 Thread Ryan Jameson (USA)
Ok, you've come to the right place, so what exactly is the question? <>< Ryan -Original Message- From: Phanivas Vemuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 1:26 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] A help on relational databases using php hi all, i need som

FW: [PHP-DB] A help on relational databases using php

2002-12-12 Thread Ryan Jameson (USA)
the question. I wiill explain it more clearly as it is verry importnat for me to solve it. Phani. >From: "Ryan Jameson (USA)" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: RE: [PHP-DB] A help on relational databases using php >Date: Thu, 12 Dec 2002 13

RE: [PHP-DB] Oracle/PHP question...

2002-12-16 Thread Ryan Jameson (USA)
If your webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. <>< Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:

RE: [PHP-DB] Oracle/PHP question...

2002-12-16 Thread Ryan Jameson (USA)
<>< Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:08 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... Thanks, but my web server is HP-UX. Didn'

RE: [PHP-DB] Oracle/PHP question...

2002-12-16 Thread Ryan Jameson (USA)
r two. :-D <>< Ryan -Original Message----- From: Ryan Jameson (USA) Sent: Monday, December 16, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... :-) ... Windows is the best at running the C# .NET applications I have to build to :make everyone hap

RE: [PHP-DB] Now not selecting enough

2002-12-18 Thread Ryan Jameson (USA)
Your echo needs to be in the while loop... <>< Ryan -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:00 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Now not selecting enough I am using the following script which I have used with minor v

RE: [PHP-DB] FW: Oracle connectivity question...

2002-12-18 Thread Ryan Jameson (USA)
Yeah, on the server you should be able to type tnsping and your tnsname to make sure it is configured correctly. <>< Ryan -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:05 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: R

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
for MS SQL and Oracle does anyone know a more reliable way to do this than select max(ID) immediately after the insert? It seems silly that I'd have to take my chances that another has been inserted in between. <>< Ryan -Original Message- From: J.Veenhuijsen [mailto:[EMAIL PROTECTED]] S

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
This doesn't work as expected through ODBC... it does not seem to return any value... <>< Ryan -Original Message- From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:09 AM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: RE: [PH

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
S1000 . it looks like I'll have to take my chances with select max() <>< Ryan -Original Message- From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:43 AM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: NewB: R

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Ryan Jameson (USA)
. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:54 AM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: NewB: Return New Record ID... It's not a bad idea to encapsulate de querys (selects, updates, inserts,...) in SPs... Good luck with the select max()!

RE: [PHP-DB] postgresql vs mysql

2002-12-26 Thread Ryan Jameson (USA)
There's a substantiated rumor that says postgres is faster for complex queries. <>< Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for wh

RE: [PHP-DB] What's wrong with my update query select works, but update doesn't?

2002-12-26 Thread Ryan Jameson (USA)
Well, it seems to me that if these two happen within the same scope level (same function, same class) which I cannot verify based on what you gave us, the $fgNumber should not be empty. Therefore I'd bet there's some code in between that reinitializes $fgNumber or the update is in a function tha

RE: [PHP-DB] Please help - Managing relational tables using PHP

2003-01-02 Thread Ryan Jameson (USA)
You need to realize that phpMyAdmin is a database manangement tool, not a database. So I'll answer your questions based on the mySQL database ... 1. MySQL 3.23.43b introduced a table type of InnoDB which is the first to allow foreign key constraints. http://www.mysql.com/doc/en/SEC448.html ...

[PHP-DB] PHP 4.3 problem

2003-01-07 Thread Ryan Jameson (USA)
using the same extensions path as the previous version I get: Content-type: text/html X-Powered-By: PHP/4.3.0 PHP Warning: Unknown(): Unable to load dynamic library 'C:\Program Files\PHP\extensions\php_ldap.dll' - The specified module could not be found. in Unknown on line 0 when using PHP 4.

RE: [PHP-DB] PHP 4.3 problem

2003-01-07 Thread Ryan Jameson (USA)
xcept for the ldap calls). Anyway, I hunted the archives and no answer, has anyone had any luck moving to 4.3 on IIS? <>< Ryan -Original Message----- From: Ryan Jameson (USA) Sent: Tuesday, January 07, 2003 5:34 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP 4.3 problem

RE: [PHP-DB] PHP 4.3 problem

2003-01-08 Thread Ryan Jameson (USA)
Well, I figured it out. New files in the dlls directory and not in the path. The error message sent me on a wild goose chase. :-\ Sorry... -Original Message- From: Ryan Jameson (USA) Sent: Tuesday, January 07, 2003 6:02 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP 4.3 problem

RE: [PHP-DB] If select query doesn't net any results

2003-01-09 Thread Ryan Jameson (USA)
if (mysql_num_rows($result) < 1) { //do stuff } This is only this easy with mySQL... :-) <>< Ryan -Original Message- From: Michael Cortes [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 11:07 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] If select query doesn't net any results

[PHP-DB] ldap_search in 4.3

2003-01-14 Thread Ryan Jameson (USA)
Weirdness I just started using PHP 4.3 and something strange is happening with my ldap_search calls. It isn't working like it used to. Anyone have any ideas? When I revert to 4.2.3 it works fine. <>< Ryan Ryan Jameson Software Development Services Manager International Bible Society W (7

RE: [PHP-DB] ldap_search in 4.3

2003-01-14 Thread Ryan Jameson (USA)
Well, I discovered that the php_ldap extension released with 4.2.3 works fine with php 4.3 ... so I'm mostly upgraded. :-) however, I'd still like to have the new extension work. Let me know if anyone finds anything. <>< Ryan -Original Message- From: Ryan Jameson (

RE: [PHP-DB] elseif

2003-01-27 Thread Ryan Jameson (USA)
You should probably replace $name == "" with strlen($name) < 1. Also, you should probably used $error .= instead of $error = so that you can list all the errors instead of just the last one. <>< Ryan -Original Message- From: Addison Ellis [mailto:[EMAIL PROTECTED]] Sent: Monday, January

RE: [PHP-DB] Simple PHP Script

2003-02-13 Thread Ryan Jameson (USA)
It's the good ole' register_globals feature... You'll need to either turn register_globals on in your php.ini file or access the variables from their respective arrays ($_SERVER,$_GET,$_POST)... since your form method is post it will be: $_POST['vname']. Make sense? If you put this at the top

RE: [PHP-DB] mysql +php

2003-02-17 Thread Ryan Jameson (USA)
while ($row= mysql_fetch_array($result)) //retrieve a row and store in echo ""; That's how I'd do it. <>< Ryan -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 8:16 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql +php Hi I was wonder if any k

RE: [PHP-DB] mysql +php

2003-02-17 Thread Ryan Jameson (USA)
BTW... you'll need something in the anchor: while ($row= mysql_fetch_array($result)) //retrieve a row and store in echo "Something"; -Original Message----- From: Ryan Jameson (USA) Sent: Monday, February 17, 2003 12:16 PM To: [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP-DB] ping

2003-02-17 Thread Ryan Jameson (USA)
see: http://www.php.net/manual/en/ref.exec.php -Original Message- From: bo [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 12:29 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ping Hi, This is not exactly fall in the category of php and mysql, but hopefully that you can shed a lig

[PHP-DB] Sybase timouts

2003-02-20 Thread Ryan Jameson (USA)
SQL error: [INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): user api layer: internal Client Library error: Read from the server has timed out., SQL state S1T00 in SQLConnect in Anyone had this problem? I cannot find anywhere that will allow me to change the timeout. <>< Ryan Ry

RE: [PHP-DB] Sybase timouts

2003-02-20 Thread Ryan Jameson (USA)
Figured it out. it requires a default logon id on the connection tab on the odbc connection. Who knows why... <>< Ryan -Original Message----- From: Ryan Jameson (USA) Sent: Thursday, February 20, 2003 12:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Sybase timouts SQL error: [

[PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
Has anyone found a way to import data through ssl into a php script? If I can pull xml formatted data through a secure socket it will save some major headaches with a problem I need to solve. $url = file("https://www.mydomain.com";); Would be ideal, but it does not work <>< Ryan Ryan James

RE: [PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
e protocol. :-) <>< Ryan -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 8:05 AM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: Re: [PHP-DB] file and https > Has anyone found a way to import data through > ssl into a php

RE: [PHP-DB] RE: PHP4 on Windows & using MSSQL

2003-02-26 Thread Ryan Jameson (USA)
I use this combination very successfully. I stick with ODBC for the SQL access though. <>< Ryan -Original Message- From: Oliver Cronk [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 3:23 AM To: Kevin Gordon Cc: PHP Mail Subject: [PHP-DB] RE: PHP4 on Windows & using MSSQL So

RE: [PHP-DB] What wrong in this SQL

2003-02-27 Thread Ryan Jameson (USA)
I don't believe you can delete from two tables simultaneously in this fashion, it's probably the ,articles that's the error. <>< Ryan -Original Message- From: Alawi shekh albaity [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 11:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Wh

[PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
Does anyone know a reliable way to set an ODBC connection to timeout after a very short time? I've tried set_time_limit but when the query is running PHP does not drop out, I've also tried odbc_setoption on the connection before executing. Basically, I want it to just fail quicker if it is going

RE: [PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
Ok I tried this another way but using the ms sql functions along with: ini_set("mssql.timeout",2); ini_set("mssql.connect_timeout",2); ... no change, it still takes about 7-8 seconds to decide it couldn't connect. <>< Ryan -----Original Message- From

[PHP-DB] Problem with 4.3.2

2003-06-12 Thread Ryan Jameson (USA)
When I change over to 4.3.2 I get this message from phpinfo(); The operating system cannot run %1. ... any ideas? Thanks... <>< Ryan Ryan Jameson Software Development Services Manager International Bible Society -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http:/

[PHP-DB] RE: Problem with 4.3.2

2003-06-12 Thread Ryan Jameson (USA)
More info... I only get that message in ISAPI mode. :-\ <>< Ryan -Original Message----- From: Ryan Jameson (USA) Sent: Thursday, June 12, 2003 11:10 AM To: [EMAIL PROTECTED] Subject: Problem with 4.3.2 When I change over to 4.3.2 I get this message from phpinfo(); The operati

[PHP-DB] RE: Problem with 4.3.2

2003-06-16 Thread Ryan Jameson (USA)
ECTED] Sent: Friday, June 13, 2003 12:14 PM To: Ryan Jameson (USA) Subject: Re: Problem with 4.3.2 Interesting. They say the ISAPI module isn't production quality yet... we use it, though, w/o problems. We're running IIS on Win2000 and php 4.3.2. Does it work besides the phpinfo()

[PHP-DB] Can't go higher than PHP 4.3.0

2003-06-26 Thread Ryan Jameson (USA)
I'm trying to update to the latest version but I can't get anything newer than 4.3.0 to run in ISAPI mode. Any ideas? Thanks.. <>< Ryan Ryan Jameson Software Development Services Manager International Bible Society W (719) 867-2692 -- PHP Database Mailing List (http://www.php.net/) To unsubsc

RE: [PHP-DB] latest version of php only cgi?

2003-06-26 Thread Ryan Jameson (USA)
It seems to be capable of being installed as ISAPI but I haven't had any luck yet. I have heard of people who have though. So... ??? <>< Ryan -Original Message- From: Doug Finch [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 2:12 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] latest

RE: [PHP-DB] Very confused with query

2003-07-07 Thread Ryan Jameson (USA)
distinct always applies to the entire record set, so if you return 2 fields the two fields together will be distinct. In this case it looks like you want to get rid of distinct and put: group by transaction_user_id at the end. Since you already have MAX(transaction_date), it will work as long a

RE: [PHP-DB] Urgent help needed

2003-10-21 Thread Ryan Jameson (USA)
Or you could hire John or me to do it for you. :-) Just kidding. I used the delimiting solution all over the place it is pretty simple. <>< Ryan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 4:42 PM To: Chris Payne Cc: [EMAIL PROTECTED]

[PHP-DB] No tuples available

2003-11-13 Thread Ryan Jameson (USA)
Is there a way to tell PHP to not show just this warning? Maybe there should be another warning level just for this warning, call it "trivial and pointless". :-) Warning: odbc_fetch_row(): No tuples available at this result index in I don't even know what it means. I get it all the time when I'm

RE: [PHP-DB] No tuples available

2003-11-13 Thread Ryan Jameson (USA)
r.com/mail/php-windows/2000111/0024.php -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 5:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] No tuples available Is there a way to tell PHP to not show just this warning? Maybe there shou

RE: [PHP-DB] No tuples available

2003-11-17 Thread Ryan Jameson (USA)
Great recommendation. The @ should work great. Thanks. <>< Ryan -Original Message- From: David T-G [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 8:03 PM To: PHP DB list Cc: Ryan Jameson (USA) Subject: Re: [PHP-DB] No tuples available Ryan -- ...and then Rya

[PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
Hi Folks, I've been using "variable variables" for years with PHP. $var = "myVarName"; $$var = "Some Val"; echo $myVarName; //outputs "Some Val" ... Today I am trying to assign an Associative Array value to a "variable variable". For some reason it doesn't take. Does anyone know why? Example

RE: [PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
land [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 12:19 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Variable Variable Array Ryan Jameson (USA) wrote: > Hi Folks, > > I've been using "variable variables" for years with PHP. > > $var = "myVarNa

RE: [PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
0, 2005 1:53 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Variable Variable Array Evert|Rooftop Solutions wrote: > Ryan Jameson (USA) wrote: > >> I've been using "variable variables" for years with PHP. >> > I'm not really sure this is really good pract

[PHP-DB] Multiselect List

2005-05-18 Thread Ryan Jameson \(USA\)
Hey Guys, I'm populating a multiselect list with countries from my database. PHP seems to require the name contain array brackets, ie. myName[]. The problem I'm having is referring to the select list via javascript when the name contains the brackets. Anyone know how? Thanks. <>< Ryan -- PHP Dat

RE: [PHP-DB] Multiselect List

2005-05-18 Thread Ryan Jameson \(USA\)
_ From: Dimiter Ivanoff [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 12:25 PM To: Ryan Jameson (USA) Subject: Re: [PHP-DB] Multiselect List Place the countries in array. Name the select with your array name. and for the use as value the keys from the array.Where your ke

[PHP-DB] Integrated Authentication on IIS 6.0

2005-05-23 Thread Ryan Jameson \(USA\)
Hi, I have an intranet application that I wrote in PHP that has worked great for a long time. It uses integrated authentication in IIS. I'm trying to migrate to IIS 6 and things are mostly working. The problem I have is that my ODBC_CONNECT calls are not resulting in: "Login failed for user '(null

RE: [PHP-DB] Integrated Authentication on IIS 6.0

2005-05-23 Thread Ryan Jameson \(USA\)
o:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 12:38 PM To: php-db@lists.php.net Cc: Ryan Jameson (USA) Subject: Re: [PHP-DB] Integrated Authentication on IIS 6.0 Maybe I'm not understanding the situation properly, because I can't see why you would have had it working under IIS5 if your

RE: [PHP-DB] Integrated Authentication on IIS 6.0

2005-05-23 Thread Ryan Jameson \(USA\)
with "With Windows NT authentication using the network login ID." selected. This works on IIS 5. <>< Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:00 PM To: php-db@lists.php.net Cc: Ryan Jameson (USA) Sub

RE: [PHP-DB] Integrated Authentication on IIS 6.0

2005-05-23 Thread Ryan Jameson \(USA\)
asn't much response. <>< Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:00 PM To: php-db@lists.php.net Cc: Ryan Jameson (USA) Subject: RE: [PHP-DB] Integrated Authentication on IIS 6.0 Ahh.. ok.. I was mostly doing

RE: [PHP-DB] Re: Integrated Authentication on IIS 6.0

2005-05-24 Thread Ryan Jameson \(USA\)
Okay, Does that help? <>< Ryan -Original Message- From: JeRRy [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 1:33 AM To: php-db@lists.php.net Subject: [PHP-DB] Re: Integrated Authentication on IIS 6.0 Hi,I have an intranet application that I wrote in PHP that has worked

RE: [PHP-DB] Re: [PHP] RE: the opposite of a join?

2007-10-03 Thread Ryan Jameson \(USA\)
You can also do an outer join and look for NULLS in the key (which means "no match"). In some cases it may be more efficient. <>< Ryan -Original Message- From: James Ausmus [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 10:00 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; ph

<    1   2