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];

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

2005-05-24 Thread Ryan Jameson \(USA\)
Okay, ?PHP odbc_connect(myDSN,,); ? 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

[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

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

2005-05-23 Thread Ryan Jameson \(USA\)
odbc_connect on IIS 6.0 is not acting the same as it is on IIS 5. I'm pretty sure it's a configuration problem, I just can't find it. :-\ Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 12:38 PM To: php-db@lists.php.net Cc: Ryan Jameson

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

2005-05-23 Thread Ryan Jameson \(USA\)
@lists.php.net Cc: Ryan Jameson (USA) Subject: RE: [PHP-DB] Integrated Authentication on IIS 6.0 Ahh.. ok.. I was mostly doing DSNless connections. You might want to look into the setup for your ODBC source called Datasource in your example below. That might be what's actually passing the authentication

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

2005-05-23 Thread Ryan Jameson \(USA\)
-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 DSNless connections. You might want to look

RE: [PHP-DB] Multiselect List

2005-05-18 Thread Ryan Jameson \(USA\)
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. select name=?=$yourarrayname? and for the option use as value the keys from the array.Where

[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\)
: 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 = myVarName; $$var = Some Val; echo $myVarName; //outputs Some Val [snip] Example

RE: [PHP-DB] Variable Variable Array

2005-03-10 Thread Ryan Jameson \(USA\)
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 practice. Sure, php allows it but I think you should try to avoid

RE: [PHP-DB] Mysql_fetch_array

2004-09-30 Thread Ryan Jameson \(USA\)
It means that the supplied argument is not a valid MySQL result resource so.. Line 17 of your script mailsender2.php is trying to manipulate a variable that isn't actually a mysql result. In some previous line you should have set the result resource variable equal to something else, on that line

[PHP-DB] Ldap query problem

2004-07-15 Thread Ryan Jameson
My LDAP queries seem to have a problem with parenthesis, does anyone know how to fix this? Example... Criteria cn=Ryan Jameson* works fine returning user with cn=Ryan Jameson (MyDomain) But... Criteria cn=Ryan Jameson (MyDomain) returns nothing. :-\ Ryan -- PHP Database Mailing List (http

RE: [PHP-DB] Ldap query problem

2004-07-15 Thread Ryan Jameson \(USA\)
I found it! The parenthesis need to be escaped, which I had tried, but silly PHP went and escaped my escapes... :-\ So the criteria on the query needed to be cn=Ryan Jameson \(MyDomain\) ... I was entering the criteria via a form which PHP conveniently turned into cn=Ryan Jameson \\(MyDomain

[PHP-DB] Passthru Strangeness

2004-05-20 Thread Ryan Jameson (USA)
Hi All, My win32 server is not in safe_mode but I can only use passthru for simple commands like dir and type but when I try to do say a ping it simply returns no output but no error either. Anyone have an idea what's going on? I have used it for ping in the past. Ultimately I plan to use it to

RE: [PHP-DB] Re: mail() function and AOL users

2004-05-19 Thread Ryan Jameson (USA)
I'm quite sure it's not a problem with the mail function. It's probably the reverse dns configuration on your SMTP/sendmail server. AOL Verizon have been two real sticklers for that. If you know the IP address that your server is sending the email from you can use this:

RE: [PHP-DB] Need some HELP

2004-05-10 Thread Ryan Jameson (USA)
It looks like register_globals is off. You'll have to access the variables in the post array on your second page: print INPUT TYPE='hidden' NAME='User_name' VALUE='$_POST['UserName']'; and so on... Try that first. Ryan -Original Message- From: Adam Farid [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Mail() - Preposterous Accusation

2004-04-08 Thread Ryan Jameson (USA)
-2004, Ryan Jameson (USA) wrote: I know this isn't technically DB related but this is the list that I use. I'd just like to know if anyone else thinks the below statement is accurate. If it is, why hasn't the mail function been modified in the more recent builds? I've been using PHP since

[PHP-DB] Mail() - Preposterous Accusation

2004-04-07 Thread Ryan Jameson (USA)
I know this isn't technically DB related but this is the list that I use. I'd just like to know if anyone else thinks the below statement is accurate. If it is, why hasn't the mail function been modified in the more recent builds? I've been using PHP since it was invented never had a problem with

RE: [PHP-DB] MySql query

2004-03-17 Thread Ryan Jameson (USA)
One reason that my queries will look like what you described is that later I append more conditions. The where 1 allows me to tack them all on with AND or OR instead of having to put the where on later and decide things like if I need to put AND or OR or WHERE or whatever... The WHERE 1 keeps it

RE: [PHP-DB] Query to Array to Echo Problem

2004-02-24 Thread Ryan Jameson (USA)
One thing may be that you need to do a fetch to increment the result row odbc_fetch_row($result);. Though that doesn't explain your column names being in the array unless that's what's in the table. Ryan -Original Message- From: Karen Resplendo [mailto:[EMAIL PROTECTED] Sent: Tuesday,

[PHP-DB] PHP Command Line

2004-01-29 Thread Ryan Jameson (USA)
Anyone know how to pass a query string to a php script when you call it on the command line? Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] PHP Command Line

2004-01-29 Thread Ryan Jameson (USA)
And it is referenced as $argv[arg number] ... I think. To be sure, here is the link to that info: http://www.php.net/manual/en/features.commandline.php - Paul -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 4:34 PM To: PHP-DB Subject: [PHP

[PHP-DB] MS SQL Server Question

2004-01-27 Thread Ryan Jameson (USA)
This doesn't have anything to do with PHP, but it does have to do with MS SQL server and I know we've got a buncha smart folks on this list. I'm sure you'll forgive the slightly OT post. I have a stored procedure that I want to protect from external rollback calls. Basically, it logs calls to

RE: [PHP-DB] Results with ledger stripes?

2004-01-26 Thread Ryan Jameson (USA)
$bg1 = #dd; $bg2 = #ff; While ... $bg3 = $bg2; $bg2 = $bg1; $bg1 = $bg3; echo tr bgcolor='$bg1' Makes sense? Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 25, 2004 6:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Results

RE: [PHP-DB] Images stored in a db - how to get them?

2004-01-26 Thread Ryan Jameson (USA)
about once a quarter this question comes up and the answer is always the same. Don't store them in the database, just store filenames and store the files in the filesystem. That way you just generate a link and treat it like any other image. Then when you query the database you would create img

RE: [PHP-DB] PHP Processing

2004-01-05 Thread Ryan Jameson (USA)
I believe the PHP parser will completely process that page whether you click stop or not. In my experience it's always been all or nothing as long as you don't hit an error half way through which I'd imagine could cause a problem. Ryan -Original Message- From: Peter Westergaard

RE: [PHP-DB] PHP Processing

2004-01-05 Thread Ryan Jameson (USA)
It appears that execution does stop if there is any output to the browser. I usually do all of my query work before sending output to the browser which would explain why I haven't seen it fail to complete. I think this is what happens: mysql_db_query(blaaa); These three should happen

RE: [PHP-DB] mysql + php

2003-12-08 Thread Ryan Jameson (USA)
James, (B (BThe consensus of developers here seems to have been not to store binary objects in the (Bdatabase. Rather store them in the file system and simply store reference records in (Bthe database. It is much easier this way. If doing it differently is not an option (Bfor you

RE: [PHP-DB] Splitting a CSV file

2003-11-25 Thread Ryan Jameson (USA)
I've never seen where the file size causes a problem that wasn't one of the file size settings either in the upload form or php.ini. I'd focus on figuring out why it's failing on the large files before trying to split it. No errors at all? Just a blank screen? Are you uploading the file through a

RE: [PHP-DB] send email

2003-11-25 Thread Ryan Jameson (USA)
You may want to loop through the form results and create the message body dynamically based on the info from the form as well. PHP's mail function is the easiest of any scripting language I've used. www.php.net/mail -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Oracle to Sybase PHP question

2003-11-25 Thread Ryan Jameson (USA)
I haven't done it in a while but Oracle can write to Sybase directly using a linked server connection. PHP should not be necessary in this case. Though PHP is the best scripting language out. :-) Ryan -Original Message- From: Jon Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November

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 Ryan Jameson (USA

[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)
/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 should

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]

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

[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

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

[PHP-DB] RE: Problem with 4.3.2

2003-06-16 Thread Ryan Jameson (USA)
, 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() problem? Jake LandEZ Ryan Jameson

[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 operating system

[PHP-DB] ODBC Timout for MS SQL Driver

2003-03-03 Thread Ryan Jameson (USA)
if it is going to. 30 seconds is too long. Ryan Ryan Jameson Software Development Services Manager International Bible Society W (719) 867-2692 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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: Ryan Jameson (USA) Sent: Monday, March 03

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] What

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 Sorry

[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 Jameson

RE: [PHP-DB] file and https

2003-02-21 Thread Ryan Jameson (USA)
. :-) 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 script? If I can pull xml

[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 Ryan

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: [INTERSOLV

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 A HREF= .$row['UrlColumnName'].; 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

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 A HREF= .$row['UrlColumnName'].Something/a; -Original Message- From: Ryan Jameson (USA) Sent: Monday, February 17, 2003 12:16 PM To: [EMAIL PROTECTED] Subject

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

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] 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 27,

[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 (719

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 (USA) Sent: Tuesday

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

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

[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

RE: [PHP-DB] PHP 4.3 problem

2003-01-07 Thread Ryan Jameson (USA)
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 using the same extensions

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

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]]

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: [PHP-DB] Re: NewB

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

2002-12-26 Thread Ryan Jameson (USA)
. 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: Return New Record ID... You

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

2002-12-26 Thread Ryan Jameson (USA)
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()!!! PD: If you dont

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

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

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:58

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

2002-12-16 Thread Ryan Jameson (USA)
- 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't anyone ever tell you Win-blows sucks

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

2002-12-16 Thread Ryan Jameson (USA)
. :-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 happy that we are industry

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 some

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:29:25 -0700 Ok, you've come to the right

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

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

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] 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)
Anyone know how to disable CTRL-ENTER in outlook? Anyway... the what I was saying: function wait10SecondsAndThenGoToADifferentPage(){ setTimeout(window.location.href = 'pageYouWantThemOnWhenDone.php';,1); } Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
/center ? } ? ? require(template_2.inc); ? -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 variables I think you want: if (isset($variable)){} Ryan -Original

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

RE: [PHP-DB] MySQL Array

2002-12-05 Thread Ryan Jameson (USA)
while ($ar = mysql_fetch_array($rs)) echo trtd. $ar['field1']./tdtd.$ar['field2']./td/tr; 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

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] 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

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

[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

[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

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

2002-11-19 Thread Ryan Jameson (USA)
input type=checkbox name=checkbox1 value=scoobydoo 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

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

2002-11-19 Thread Ryan Jameson (USA)
that the '[]' can screw up any JavaScript code that refers to the checkbox 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

[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

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:

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

RE: [PHP-DB] Column Defualts

2002-10-29 Thread Ryan Jameson (USA)
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 AM To: php-db Subject: RE: [PHP

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

RE: [PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread Ryan Jameson (USA)
in a timely fashion. You can believe it... or not. /OFFTOPIC 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

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] 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 table

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] Getting valie

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] 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 above

  1   2   >