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

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

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

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

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

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\\) wh

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

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: http://www.dnsstuff.com/

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 ""; and so on... Try that first. <>< Ryan -Original Message- From: Adam Farid [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 12:37 PM To: [EMAIL PROTECTED] S

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

2004-04-08 Thread Ryan Jameson (USA)
Accusation At 00:01 08-04-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

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

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

RE: [PHP-DB] PHP Command Line

2004-01-29 Thread Ryan Jameson (USA)
2 %3 %4 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-D

[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

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

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 ta

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 " 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 with ledger

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

RE: [PHP-DB] mysql + php

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

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, Novemb

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

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 b

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

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

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

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

[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] 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] 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:/

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

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

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

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

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 (

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

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

[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] 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] 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] 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] 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] 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)
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)
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] 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] 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] 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] 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)
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:

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

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

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 

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

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

  1   2   >