[PHP-DB] ODBC problems in PHP 4.2

2002-04-24 Thread Ryan Jameson (USA)
If this is easy for anyone could someone verify that: odbc_fetch_row($rs,0); ...does not reset the result set in version 4.2? From what I can tell it doesn't work at all. I want to be certain that we cannot upgrade to 4.2. If someone has another way to reset an ODBC result set I'd love to

RE: [PHP-DB] Re: WELCOME to php-db@lists.php.net

2002-04-24 Thread Ryan Jameson (USA)
Interesting challenge. I tend to write TSQL more these days so this may not work on MySQL but the subquery approach should give you an idea of the method. I just typed this up so it may not even work! :-) select min(stopped) as Stopped,Started, (Started-min(stopped)) as Duration from

RE: [PHP-DB] Variables

2002-04-25 Thread Ryan Jameson (USA)
I think what you don't know is this: $varName = c1; $$varName = 3; that just set $c1 to equal 3. Does that help? -Original Message- From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Variables HI-- * I

RE: [PHP-DB] Variables

2002-04-25 Thread Ryan Jameson (USA)
In an attempt to be less vague I think you want to change your line: $c . $count+1 = $artist[$count]; to be: $varName = $c.($count+1); $$varName = $artist[$count]; Got it now? --- I think what you don't know is this: $varName = c1; $$varName = 3; that just set $c1 to

RE: [PHP-DB] upgrade to 4.2, now odbc cursor problem

2002-04-29 Thread Ryan Jameson (USA)
Hi Joop, The ODBC guys know about this and several other issues with 4.2. Did you download the binary distribution or did you compile your own? One possibility concerning my issue is the options that were compiled into the binary distribution. It might be best to stay at 4.1.2 for now. I'm

[PHP-DB] FW: [PHP-DEV] odbc problems in 4.2

2002-04-29 Thread Ryan Jameson (USA)
Joop... Here's some more info: -Original Message- From: Andreas Karajannis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:16 PM To: Dan Kalowsky Cc: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: Re: [PHP-DEV] odbc problems in 4.2 Dan Kalowsky wrote: Hi Ryan, Okay did

RE: [PHP-DB] ODBC problem in 4.2.0

2002-04-29 Thread Ryan Jameson (USA)
I'd recommend finding a hosting service that would be more careful about making upgrades. There seems to be some problems with ODBC in 4.2 and I have yet to hear of a work around, especially not one you can implement if you don't handle your own server. I feel your pain man! Fortunately for

RE: [PHP-DB] ODBC problem in 4.2.0

2002-04-29 Thread Ryan Jameson (USA)
this occurs. This is, however, just an opinion. -Original Message- From: Ryan Jameson (USA) Sent: Monday, April 29, 2002 8:14 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] ODBC problem in 4.2.0 I'd recommend finding a hosting service that would be more careful about making upgrades

RE: [PHP-DB] ODBC problem in 4.2.0

2002-04-30 Thread Ryan Jameson (USA)
mmercial hosting service be willing and able to step back if a problem like this occurs. This is, however, just an opinion. -Original Message- From: Ryan Jameson (USA) Sent: Monday, April 29, 2002 8:14 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] ODBC problem in 4.2.0 I'd recommend

RE: [PHP-DB] Re: Using functions in SELECT statements

2002-05-02 Thread Ryan Jameson (USA)
Is this in SQL server? It seems we don't have enough of the code to be able to tell the problem. The query has to be put in a string and SearchBox has to exist, and this all has to be run from a query function, and well, if you actually show your php code it would help quite a bit. :-)

RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)
the ansi syntax for delete is delete from table where ??? You don't tell it what to delete since it will always delete whole rows. So just remove o.* . If you are in need of setting a field to blank you'll have to use an update, not a delete. Ryan -Original Message- From: andy

RE: [PHP-DB] indexing

2002-05-03 Thread Ryan Jameson (USA)
I could be wrong but I seem to remember that Primary keys are indexed automatically. Regardless, smallints and dates really are pretty easy to index. So go for it! Strings introduce a bit of overhead, but I've never heard anyone, nor would I, recommend holding back on indexing because you have

RE: [PHP-DB] sql querry problem

2002-05-03 Thread Ryan Jameson (USA)
That too... :-) You'll have to do two deletes, if your referential integrity is set up you'll have to delete the children before you can delete the parent as well. Thanks Szii.. I missed that part. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

RE: [PHP-DB] new user php/mysql problem

2002-05-06 Thread Ryan Jameson (USA)
It may be an issue with the connect from host for that user. That's the only thing I can come up with. Is your web server the same machine as your MySQL server? Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:47 AM To: [EMAIL

RE: [PHP-DB] ODBC Remote

2002-05-06 Thread Ryan Jameson (USA)
Try copying your .mdb to a new file and opening that one. I've seen this before. It really has nothing to do with PHP, it's a microsoft issue. Ryan -Original Message- From: Juan Angel Ringhetti [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 2:08 PM To: [EMAIL PROTECTED]

RE: [PHP-DB] tables/columns with spaces

2002-05-10 Thread Ryan Jameson (USA)
[] is the correct notation for both tables and columns. I don't ever recommend using spaces in anything, file names, tablenames, or anything else that will bite you later. But that is the correct syntax, so there may be another problem. Maybe BUSINESS AREA is numeric? Ryan -Original

RE: [PHP-DB] Ordering question .....

2002-05-10 Thread Ryan Jameson (USA)
/t is a tab, however tabs won't show up in HTML, you'll have to use something like: nbsp;nbsp;nbsp;nbsp;nbsp; Ryan -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:03 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Ordering question .

RE: [PHP-DB] Ordering question .....

2002-05-10 Thread Ryan Jameson (USA)
BTW... if you're going for an outline effect, you may want to look into ul or ol (unordered and ordered lists) lifirst/ li lisecond/ li lithird/ li / ul Ryan -Original Message- From: Ryan Jameson (USA) Sent: Friday, May 10, 2002 10:15 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB

RE: [PHP-DB] stmt should return user-id only once. difficult select statement.

2002-05-10 Thread Ryan Jameson (USA)
This may only be preference but you've mixed join syntaxes here, it would be easier to read if you stuck with just one. Anyway, I think what you'll want is to max the whole expression. So, keep the group by, but use max (if(u.country='gm',25,0) + if(u.age='4',25,0) +

RE: [PHP-DB] stmt should return user-id only once. difficult select statement.

2002-05-10 Thread Ryan Jameson (USA)
That's only when they have a different language_id... the group by needs to have just user_id if you want to guarantee one user_id. GROUP BY u.user_id, l.language_id -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:07 PM To: [EMAIL PROTECTED]

RE: [PHP-DB] stmt should return user-id only once. difficult select statement.

2002-05-10 Thread Ryan Jameson (USA)
I may be confused as to what you're looking for, however I can tell you that the group by is done after the result set is created, hence the where clause is processed. So, if you search for where u.country = 'hr' then you will only ever get 'hr' in the country field after the group by is

RE: [PHP-DB] MSSQL DateTime field formatting?

2002-05-14 Thread Ryan Jameson (USA)
This is how I do it: date(m/d/Y,strtotime(odbc_result($rs,ts))) where $rs is the result set and ts is the name of the field containing the datetime. Ryan -Original Message- From: Benjamin Walling [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 2:59 PM To: [EMAIL PROTECTED]

RE: [PHP-DB] radio buttons

2002-05-15 Thread Ryan Jameson (USA)
We need more of your code, as far as I can tell the variables $verify, and $first_reject don't exist and since they don't it doesn't matter which button is selected the value is blank. Radio buttons are a little odd... in this case depending on which is selected it will either assign $verify

RE: [PHP-DB] php_close( ) not working on PHP+FreeTDS+UnixODBC+MSSQL7

2002-05-15 Thread Ryan Jameson (USA)
Are you using odbc_free_result before odbc_close? The documentation doesn't do it justice. For SQL server it seems to be the only way to release the connection. Ryan -Original Message- From: Andrew Rall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:40 AM To: [EMAIL

[PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the database using PHP ODBC I don't get the whole thing. Anyone have any ideas? Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
I got it: In php.ini there is a setting for ODBC called odbc.defaultlrl, if you change it to 0 it will hand over everything. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Text Field in SQL Server When

RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
BTW: 0 wasn't the right answer, but I get by with 10. :-) -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Text Field in SQL Server I got it: In php.ini there is a setting for ODBC called

RE: [PHP-DB] Text Field in SQL Server

2002-05-15 Thread Ryan Jameson (USA)
So I can retrieve it in 4k pieces? That's cool. Thanks! Ryan -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 4:37 PM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Text Field in SQL Server You can actually control

RE: [PHP-DB] Reset ODBC Results

2002-05-21 Thread Ryan Jameson (USA)
If you are using PHP 4.2 it does not work. I'm stuck at 4.1.2 because of this. You may want to downgrade. Ryan -Original Message- From: Anthony [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 7:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Reset ODBC Results I am in desperate

[PHP-DB] Outlook Out Of Office

2002-05-29 Thread Ryan Jameson (USA)
i know this List isn't for this, but I'm about to go on vacation and I don't want to AutoReply everytime someone posts to this list. Does anyone know how I can set Out Of Office to skip sending a reply when the mail was sent to [EMAIL PROTECTED] ? I looked at the rules and all of the actions

RE: [PHP-DB] timer

2002-06-11 Thread Ryan Jameson (USA)
Just set one variable $var1=time(); before you call mysql_query and then subtract it from time(); after the query. That will be the number of seconds. If you need better precision you can use milliseconds too: $t1 = getmicrotime(); $result_query = mysql_query($query_prism); echo hrExecution

RE: [PHP-DB] timer

2002-06-11 Thread Ryan Jameson (USA)
oopsss... I should put the getmicrotime() function... sorry, here it is: function getmicrotime(){ list($usec, $sec) = explode( ,microtime()); return ((float)$usec + (float)$sec); } -Original Message- From: Ryan Jameson (USA) Sent: Tuesday, June 11, 2002 11:22 AM

RE: [PHP-DB] Connecting to MS Access

2002-06-12 Thread Ryan Jameson (USA)
I've duplicated your problem. I know I've had this working before, I'll let you know if I can figure it out. :-) Ryan -Original Message- From: Bill Hudspeth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:22 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connecting to MS

RE: [PHP-DB] Connecting to MS Access

2002-06-12 Thread Ryan Jameson (USA)
It is the error message you get when you haven't selected the database file for your DSN. Go to your DSN, click configure, and click the SELECT button on the dsn. :-) Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, June 12, 2002 1:09 PM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread Ryan Jameson (USA)
I had a similar issue where I wanted timestamps to be relative to the user. I didn't find any better way then to create some profile data that contained their timezone and allow them to save that data. Then anytime I displayed a timestamp I added the timezone shift to the stamp. It would be

RE: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread Ryan Jameson (USA)
BTW... are you saying that you plan to move the MySQL server around to different time zones? Why would you do that? -Original Message- From: Ryan Jameson (USA) Sent: Thursday, June 13, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL timestamp field in different time zone

RE: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread Ryan Jameson (USA)
to move the MySQL server around to different time zones? Why would you do that? -Original Message- From: Ryan Jameson (USA) Sent: Thursday, June 13, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL timestamp field in different time zone I had a similar issue where I wanted

RE: [PHP-DB] Problem with arrays

2002-06-14 Thread Ryan Jameson (USA)
You'll have to loop through the result using mysql_fetch_array and put that returned array in each index of your new array. So it would look like this: for ($i=0;$row=mysql_fetch_array($RESULT);$i++) $newArray[$i] = $row; Then $newArray should look like what you want. :-) Ryan

RE: [PHP-DB] sql query problem

2002-06-14 Thread Ryan Jameson (USA)
The problem is they are parts of different rows. In a relational database rows only know about other rows through relationships. You have either: 1. Designed your database incorrectly. or 2. Are a genius with a unique concept that I do not grasp. Ryan -Original Message- From:

RE: [PHP-DB] Populating multi-select list from mysql

2002-06-21 Thread Ryan Jameson (USA)
You're logic seems to make sense. The output (page source) you are getting would help. :-) Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:06 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating

RE: [PHP-DB] BBS program

2002-06-21 Thread Ryan Jameson (USA)
BBS = Backyard Bible Study? -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 11:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] BBS program I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? Thank you

RE: [PHP-DB] Last ID from database?

2002-06-26 Thread Ryan Jameson (USA)
-Original Message- From: Ryan Jameson (USA) Sent: Wednesday, June 26, 2002 1:59 PM To: 'Chris Payne' Subject: RE: [PHP-DB] Last ID from database? It depends on if you just inserted it, if you did: mysql_insert_id if not, you'll need to do a query for SELECT max(ID) as lastID from

RE: [PHP-DB] MySQL Update failing...

2002-06-27 Thread Ryan Jameson (USA)
I didn't get your attachements. Maybe paste them in a row into the email? -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 10:07 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL Update failing... In need of some help. I

FW: [PHP-DB] blob versus file

2002-07-01 Thread Ryan Jameson (USA)
I agree, it's definitely simpler and quicker to just store them in the file system and save the file path in the database. Ryan -Original Message- From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 6:21 AM To: andy Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]

[PHP-DB] Line breaks from a database!

2002-07-02 Thread Ryan Jameson (USA)
Hi guys, maybe I'm missing something silly but when I retrieve a string from my SQL server with '\n' in it, they are displayed literally instead of as line breaks. StripSlashes only turns them into 'n'. Any ideas? Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] Line breaks from a database!

2002-07-02 Thread Ryan Jameson (USA)
strip($string){ $string = str_replace(\\n,\n, $string); return $string; } believe it or not, this works when stripSlashes does not. Anyone know why? Ryan Ryan Jameson (USA) [EMAIL PROTECTED] said: Hi guys, maybe I'm missing something silly but when I retrieve a string from my SQL server

RE: [PHP-DB] Date comparison problem

2002-07-10 Thread Ryan Jameson (USA)
This is how I do it: date(m/d/Y,strtotime(odbc_result($rs,ts))) where $rs is the result set and ts is the name of the field containing the datetime. Ryan -Original Message- From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:21 AM To: [EMAIL

RE: [PHP-DB] Calculating inside query?

2002-07-10 Thread Ryan Jameson (USA)
i assume you're using MySQL because of the Limit clause, but what error are you receiving? -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Calculating inside query? Hi there, I would like to find

RE: [PHP-DB] Calculating inside query?

2002-07-10 Thread Ryan Jameson (USA)
do both of the fields contain values and are they both numeric? It sure seems strange to me. I actually created a test and it worked fine, just copied your query. Ryan -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:48 AM To: [EMAIL PROTECTED]

RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??

2002-07-10 Thread Ryan Jameson (USA)
desc is a key word. :-\ -Original Message- From: Michael Zornek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Mysql syntax error - phpMyAdmin ?? I was using phpMyAdmin to do an export from one machine to another and on import

RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??

2002-07-10 Thread Ryan Jameson (USA)
Try [desc] -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, July 10, 2002 10:51 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Mysql syntax error - phpMyAdmin ?? desc is a key word. :-\ -Original Message- From: Michael Zornek [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??

2002-07-10 Thread Ryan Jameson (USA)
Sorry, [desc] won't work either. :-( -Original Message- From: Chip Atkinson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:54 AM To: Michael Zornek Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ?? I can't say for sure, but perhaps desc is

RE: [PHP-DB] phpMyAdmin for Windows?

2002-07-11 Thread Ryan Jameson (USA)
phpMyAdmin uses PHP and PHP is available for windows. So if I understand your question, the answer is yes, there is something LIKE phpMyAdmin for Windows. It is not a windows application though. Ryan -Original Message- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday,

[PHP-DB] MS Sql Server xp_sqlagent_proxy_account

2002-07-12 Thread Ryan Jameson (USA)
exec master.dbo.xp_sqlagent_proxy_account N'GET' Anyone ever had the above give you Access is denied. When you run it as 'sa' ??? Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MS Sql Server xp_sqlagent_proxy_account

2002-07-12 Thread Ryan Jameson (USA)
Figured it out. The SQL Service account was a domain account and did not have administrator privilege on the server it ran on. Strangely enough the procedure needs some kind of special local permissions. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Friday, July 12, 2002 9

RE: [PHP-DB] ID numbers not sorting Properly

2002-07-12 Thread Ryan Jameson (USA)
I'm amazed at how many seasoned developers think that doing a select with no order by clause will always return the records in the order they went into the database. That is an absolute no-no. The problem is, it usually will, but try restoring a backup or bulk loading and see what happens.

RE: [PHP-DB] convert mysql table to Excell or Access file

2002-07-12 Thread Ryan Jameson (USA)
There is an ODBC driver for MySQL that will allow you to link to it and you can do whatever you want from there. :-) Ryan -Original Message- From: Alex Shi [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 4:36 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] convert mysql table to

[PHP-DB] Bypass Trigger on a Query?

2002-07-16 Thread Ryan Jameson (USA)
Anyone know if there is a way to bypass the update trigger on a table for one query, without having to remove the trigger all together? Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Bypass Trigger on a Query?

2002-07-16 Thread Ryan Jameson (USA)
it's MS SQL btw... :-) -Original Message- From: Ryan Jameson (USA) Sent: Tuesday, July 16, 2002 4:07 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Bypass Trigger on a Query? Anyone know if there is a way to bypass the update trigger on a table for one query, without having to remove

RE: [PHP-DB] select distinct with all columns

2002-08-12 Thread Ryan Jameson (USA)
SELECT DISTINCT type,* FROM equipement WHERE class = microphones; Ryan -Original Message- From: russ arbuthnot [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] select distinct with all columns I have a mysql table named

RE: [PHP-DB] select distinct with all columns

2002-08-12 Thread Ryan Jameson (USA)
or not be the correct function to use depending on what your need is. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday, August 12, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] select distinct with all columns SELECT DISTINCT type,* FROM equipement WHERE class

[PHP-DB] PHP Extensions in Win32

2002-08-14 Thread Ryan Jameson (USA)
I'm using php_ldap.dll (PHP 4.2.2 on WIN2k/IIS) and had a strange thing happen today. The server suddenly stopped answering requests with an error Invalid Credentials. When I went to the server there were several pop-up windows visible all of which saying cannot load module php_ldap.dll file

RE: [PHP-DB] authenticating methods...

2002-08-19 Thread Ryan Jameson (USA)
I have php on win2k with sql server and IIS, I use Active Directory for all my authentications, and integrated authentication for database access. I think it works great! My users don't even have to enter a username and password, it is all based on what they logged into their system as. I did

[PHP-DB] RE: PHP, using System account

2002-08-20 Thread Ryan Jameson (USA)
for this until the versions for OSX and versions of IE for Mac are very inconsistent bug ridden. Ryan -Original Message- From: aiQa [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 11:58 PM To: Ryan Jameson (USA) Subject: PHP, using System account Hi, Our company also uses

RE: [PHP-DB] Date Subtraction

2002-08-21 Thread Ryan Jameson (USA)
What's more you can do some neat stuff with manipulating the timestamp to create very quick and accurate calendars. For instance for an application I had to build I had need of highlighting weeks on a calendar to change colors every two weeks, but any given day needed to know which color it

RE: [PHP-DB] how to hide source code??

2002-08-29 Thread Ryan Jameson (USA)
Wouldn't that make php unable to read it as well? Then it is useless as well. Ryan -Original Message- From: Adam Williams [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 1:00 PM To: Smita Manohar Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] how to hide source code?? set you

RE: [PHP-DB] how to hide source code??

2002-08-29 Thread Ryan Jameson (USA)
- From: Adam Williams [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 1:06 PM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] how to hide source code?? oh yeah duh me, set it 701 Adam On Thu, 29 Aug 2002, Ryan Jameson (USA) wrote: Wouldn't

RE: [PHP-DB] how to hide source code??

2002-08-29 Thread Ryan Jameson (USA)
16:05, Adam Williams escreveu: oh yeah duh me, set it 701 Adam On Thu, 29 Aug 2002, Ryan Jameson (USA) wrote: Wouldn't that make php unable to read it as well? Then it is useless as well. Oh, please, setting x bit will permit what ? PHP has to READ the file

[PHP-DB] Kudos

2002-08-30 Thread Ryan Jameson (USA)
I know we'd all agree, but for everyone who has taken it for granted, like I have, I just wanted to mention what a privilege it is that PHP exists. I've recently been involved on a .NET project and with every buggy, broken, and just plain bad module I come across I wish more that I could just

RE: [PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Ryan Jameson (USA)
A bit of a strange way would be to always pop the window and at that point have the PHP decide what to put in there. If there is not offer you want to include you could simply thank them, or you could even produce an inline window.close(); javascript call. The only problem with that is that

RE: [PHP-DB] LDAP?

2002-09-12 Thread Ryan Jameson (USA)
LDAP is a database IMHO... :-) Ryan -Original Message- From: Tony Earnshaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 9:37 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] LDAP? Hi list! Seen a lot of SQL stuff floating by, but my present, consuming interest is Openldap.

[PHP-DB] file timout

2002-09-18 Thread Ryan Jameson (USA)
Does anyone know a good way to have the file function timeout quickly if it cannot find the file requested? I've tried set_time_limit (5) but for some reason it still sits for about 30 seconds before failing. Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] Multiple Referral Levels

2002-09-25 Thread Ryan Jameson (USA)
For performance sake I'd recommend having a table configured just like your first example minus referer as well as a seperate table that is: (table references) id referer int level Anytime you add a new user you climb the chain until you hit the top of the chain, for each user you pop in an

RE: [PHP-DB] Need help urgent!!

2002-09-26 Thread Ryan Jameson (USA)
Do you mean passing vars between forms, between functions, or between includes? Ryan -Original Message- From: Thomas omega Henning [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 10:49 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help urgent!! I'm using PHP4.2.2 Win

RE: [PHP-DB] Valid IP

2002-09-26 Thread Ryan Jameson (USA)
Try this: function padIP($ip){ $ar = explode(.,$ip); $ip = ; $xt = ; for ($i = 0; $icount($ar); $i++){ $ip .= $xt.substr(($ar[$i]+1000),1); $xt = .; } return $ip; } -Original Message- From: Wilmar Perez [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26,

[PHP-DB] error_reporting()

2002-09-30 Thread Ryan Jameson (USA)
I do the following ?PHP error_reporting(E_ALL); echo error_reporting(); ? 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 (USA) Subject: RE

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 deprecated

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

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 phpinfo

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

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

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

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

[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

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

  1   2   >