RE: [PHP-DB] [Resolved] Unable to connect to MSSQL with PHP through a firewall

2004-01-31 Thread Ricky Boone
ently I was wrong, but perhaps the documentation needs to be reworded to reflect that the Client Tools is the only way to get these functions to work properly. Thanks for the help. :) -- Ricky Boone <[EMAIL PROTECTED]> Planetfurry.com -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] Unable to connect to MSSQL with PHP through a firewall

2004-01-29 Thread Ricky Boone
t; I'm unfamiliar with this kind of connection string. This is how I connect: $sqlConnect = mssql_connect($sqlHost, $sqlUser, $sqlPass) or die("Could not connect to database: ".mssql_get_last_message()); > Give the sql login the necessary rights to do what the appli

[PHP-DB] Unable to connect to MSSQL with PHP through a firewall

2004-01-29 Thread Ricky Boone
r the configurations for both servers and they look fine, checked several sites and lists for advice and couldn't find anything that would work. Any ideas as to what I should be looking for? -- Ricky Boone <[EMAIL PROTECTED]> Planetfurry.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] session problem

2002-08-10 Thread Ricky
Hello everybody I'd like to make a page in which the results shown can be bookmarked by pressing a button. Actually first it checks if the session is open already ... Then it should check if the result (that comes from a query to a MySQL table) has been registered already, finally it registers

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql

2001-10-29 Thread Ricky Theil
the table -Original Message----- From: Ricky Theil [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:26 AM To: '[EMAIL PROTECTED]'; Robby Whiteside; [EMAIL PROTECTED] Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My Sql If your first field is an auto in

RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql

2001-10-29 Thread Ricky Theil
If your first field is an auto insert field, then you have to do it like this: insert into tablename (column2,column3,column4,column5) values (value2,value3,value4,value5) The auto incremented field will be automatically be filled in with the next available value. Ricky -Original Message

RE: [PHP-DB] Subject: RE:Please Confirm!! Yes I want to Optin RE: php-db@lists.php.net

2001-10-05 Thread Ricky Theil
Obviously someone pretty smart. -Original Message- From: Sterling [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 2:47 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Subject: RE:Please Confirm!! Yes I want to Optin RE: [EMAIL PROTECTED] Importance: High You [EMAIL PROTECTED],

[PHP-DB] Other ODBC driver besides an openlink one?

2001-10-04 Thread Ricky Theil
tions, but I'm having a few problems installing oracle on Linux. Thanks Ricky

RE: [PHP-DB] what's the current URL

2001-10-03 Thread Ricky Theil
I apologize... I'm wrong... $PHP_SELF is only the name of the current script... -Original Message- From: Ricky Theil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:35 PM To: 'Sheridan Saint-Michel'; Francisco Carvalho; [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP-DB] what's the current URL

2001-10-03 Thread Ricky Theil
$PHP_SELF returns the full URL of the current script. i.e. $PHP_SELF http://domain.com/script.php -Original Message- From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:30 PM To: Francisco Carvalho; [EMAIL PROTECTED] Subject: Re: [PHP-DB] what's the

RE: [PHP-DB] what's the current URL

2001-10-03 Thread Ricky Theil
Use the phpinfo(); function to show you all the environment variables. i.e. the current file URL w/o the query string on it is $PHP_SELF Ricky -Original Message- From: Francisco Carvalho [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:51 PM To: '[EMAIL PROT

RE: [PHP-DB] Performance boosting

2001-10-03 Thread Ricky Theil
nfo. It's because I display a ton of stuff before the query is performed. If there's not enough stuff before the query is executed, it doesn't show anything. If there's too much, it shows up to a certain point. Ricky -Original Message- From: Luditus [mailto:[EMAIL PROTECT

RE: [PHP-DB] Bug in new PHP Version?

2001-10-03 Thread Ricky Theil
Looks like you've got the answer to your question, right there use mysql_select_db() and mysql_query() instead. I use 4.06 and have never used the mysql_db_query function. -Original Message- From: Luditus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 2:13 AM To: [EMA

RE: [PHP-DB] Cybercash? or Who?

2001-10-03 Thread Ricky Theil
I just recently started using Cardservice International for all my precessing. The only drawback was that I had to purchase an API wrapper, but it is a PHP wrapper. It was $95. It's extremely fast, and easy to use. Documentation isn't the best, but their support is aweso

RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry

2001-09-26 Thread Ricky Theil
I have no problem updating integer and float fields when putting them in '' if you update an integer with a blank value, it makes the value in the db =0. always on unix and mysql, though. Ricky -Original Message- From: Brian Paulson [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: [PHP-DB] mssql functions on unix

2001-09-26 Thread Ricky Theil
ething I'm missing?? Here's the configure I ran: ./configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.19 --with-sybase --enable-track-vars -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:48 AM To: Ricky The

[PHP-DB] mssql functions on unix

2001-09-26 Thread Ricky Theil
tions when compiling php. Any help is appreciated :) Thanks, Ricky

[PHP-DB] PHP 4.05 & Oracle 8

2001-09-19 Thread Ricky Theil
I need to set up PHP to work on a Windows 2000 machine with IIS 5, PHP 4.05 and Oracle 8.0.5 installed. I was having problems with the connection and kept getting all kinds of errors about the TNSNAMES file, but now I'm getting this error. Warning: _oci_open_server: ORA-12699: Native service in