Re: [PHP-DB] Interbase Problem

What OS is running in the InterBase machine? Are you running IB Classic or SuperServer? I haven't seen this error but have read about it a few times, in those cases the machine was running Windows NT and IB SS. -Jorge Niel Zeeman [EMAIL PROTECTED] escribió en el mensaje 9h76jh$ik6$[EMAIL

[PHP-DB] sql problem

SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; What does @A: mean? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] PHP Bug with InterBase

The following bug report was posted to an InterBase newsgroup: --- Anyone who are using PHP + Interbase should be aware of this bugs especially when trying to retrieve IB decimal/float data type from a stored procedure(s). I have reproduced this error that seems as a bug on PHP when

Re: [PHP-DB] sql problem

Fai [EMAIL PROTECTED] wrote in message 9h90l2$1op$[EMAIL PROTECTED]">news:9h90l2$1op$[EMAIL PROTECTED]... SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; What does @A: mean? Thank you very much! They're writing the sum to an SQL variable. --

[PHP-DB] Oracle Client to connect to remote DB

I read a post on faqt.com that said that I could connect to a remote Oracle DB if I had the Oracle client installed. Does anyone know where I can get a copy of only the client for Linux? I don't want to install the whole Oracle package, I use MySQL on the server, but have a client that is

Re: [PHP-DB] Is MySQL in 4.0.6?

on 6/25/01 3:46 PM, Adam Lundrigan at [EMAIL PROTECTED] wrote: Is MySQL included in the 406kb version of PHP 4.0.6? When I try to connect to MySQL (after adding localhost paswords to php.ini) using this version it says: Warning: Can't connect to MySQL server on 'localhost' (10061) in

[PHP-DB] db2 (or any unified ODBC db), php, stored procedures, and OUT parameters

I am trying to return an OUT or INOUT parameter from a stored procedure call to PHP via the Unified ODBC functions. I've RTFM and I don't see anything on this. I've tried to pass a variable to an INOUT parameter via the parameters array in odbc_execute. Is there any trick or hack to work

Re: [PHP-DB] Is MySQL in 4.0.6?

At 8:16 PM -0230 6/25/01, Adam Lundrigan wrote: Is MySQL included in the 406kb version of PHP 4.0.6? When I try to connect to MySQL (after adding localhost paswords to php.ini) using this version it says: Warning: Can't connect to MySQL server on 'localhost' (10061) in mysql_local_test.php on

Re: [PHP-DB] Query in a function

How about declaring some of the variables as global variables. regards seriousj wrote: Hello I have a query that I have placed in a function that is in a file that I include in the page to be displayed. It doesn't work. I know that the code works because when I place the code in the page

Re: [PHP-DB] Interbase Problem

Hi We are running Firebird 0.94 SS on RedHat 7.1 Compaq Server Hope this rings a bell?? Niel Jorge Alvarez [EMAIL PROTECTED] wrote in message 9h90ja$1a8$[EMAIL PROTECTED]">news:9h90ja$1a8$[EMAIL PROTECTED]... What OS is running in the InterBase machine? Are you running IB Classic or

RE: [PHP-DB] sql problem

@a is here an internal 'session' variable used in sql databases (atleast mysql). simple usage : select @a:=1; - 1 select @b:=10; - 10 select @a + @b; - 11 These variables are used to hold temporary numbers and characters, so the interaction between the script language and the database can be

Re: [PHP-DB] upload problem ...

He! Don't use the function 'copy', but 'move_uploaded_file'. Ready... Daniel Kieviet Xsarus Internetdiensten Holland [EMAIL PROTECTED] - Original Message - From: Andre P. [EMAIL PROTECTED] To: Steve Brett [EMAIL PROTECTED] Cc: php-db@lists. php. net (E-mail) [EMAIL PROTECTED] Sent:

Re: [PHP-DB] Database access using ODBC

Thanks for the reply. When it didn't work, I downloaded and installed the mdac 2.6 and the up to date jet service pack. Still no joy. $DBConn is coming back as integer 1 so that seems ok. I have tested the DSN using MSQuery and it is connecting ok. I have also turned tracing on for the dsn and

Re: [PHP-DB] sql problem

A quick glance suggests to me that it is a nonstandard proprietary extension to SQL that provides a way to set a kind of a variable and use it in a subsequent nonstandard proprietary SQL-looking statement that is awfully procedural. You'll probably want to either consult the documentation for

[PHP-DB] Dbase function problem

- Original Message - From: Bartek Pawlik To: [EMAIL PROTECTED] Sent: Monday, June 25, 2001 7:08 AM Subject: Dbase function Hi My problem is I have dbf file, I get one record, one of the record's filed is binary (32 bits). The function dbase_get_record cut Least Sagnificant Bit

Re: [PHP-DB] SELECT with ibase_prepare/ibase_execute possible?

Hi Yes it is possible I'm using it currentlyon some of my major qry's You'd prepare the qry and the instead of using the ibase_query just use the ibase_execute in the same way Niel Arne Borkowski (borko.net) [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi, I can use

Re: [PHP-DB] managing variant data

I would create another table called extras that include all possible extra choices. This table has a SpeciesID field to assign it to a species. A third table called details could have OfficerID and ExtrasID and ExtrasValue fields. That way you could have as many or as few extras as you want.

RE: [PHP-DB] Is MySQL in 4.0.6?

-Original Message- From: Adam Lundrigan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 5:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Is MySQL in 4.0.6? Is MySQL included in the 406kb version of PHP 4.0.6? When I try to connect to MySQL (after adding localhost

[PHP-DB] Truncated text fields stored into SQLServer

We are having a problems storing long text strings sent with HTML forms into sqlserver through ODBC (mssql native support doesn't work for us). We've defined tables with 16 bit text fields but the strings always become truncated at 4Kb or so when we store it. Thanks in advance: Raúl. -- PHP

[PHP-DB] php/mysql horizontal listing query

hello knowledgeable people of the php-db list, i have a question for you regarding PHP using MySQL. my problem is this: I need a section of a record label site with a releases section listed horizontally but here's the twist: after every 4 releases, I want the releases to move to the next

Re: [PHP-DB] Database access using ODBC

Colum, Did you try it, stripping out all of your error testing code, just doing a simple query, such as a Select * from tablename? You could also try searching the archives of the list for these two names: Andrew Hill, who works for OpenLink, a company which builds ODBC drivers. and Manuel

RE: [PHP-DB] Oracle and PHP

TathitSA, You'll need to have the Oracle networking software (Net8) installed on your Web server. Then, compile PHP with the Oracle directive turned on. These are just general concepts, but if this is incomprehensible, then please ask more questions before proceeding. For more details, see the

RE: [PHP-DB] Oracle Client to connect to remote DB

Jeff, When you run the graphical Oracle Installer program (require X-Windows), you can choose a custom installation and specify what you want to install. I don't know if you can get just the client for Linux, but the server software includes the client software. You can demo the software from

RE: [PHP-DB] Oracle Client to connect to remote DB

Jeff, As far as I know, you cannot get *only* the Oracle client for Linux. When I called Oracle Worldwide Support and asked for one, they sent me the whole Oracle 8i installation package for Linux. No problem, though -- when you start the install on your Linux machine, you can choose to

[PHP-DB] Extracting data from html files into csv

hi all, I have a huge project coming up today where I need to extract a large number of entries from a directory. What I would like to do is use a site ripper [to download each properties HTML file to a local directory on my pc] and then run some sort of extraction on the file to create an

RE: [PHP-DB] Cookies

this doesnt work :echo $HTTP_COOKIE_VARS[nameCookie] code to set cookie: setcookie(newsLogin,$value,time()+ 3348000); if i ask from the same page I get the values I need but not from a different page... You are asking the wrong variable name. If you set a cookie variable named newsLogin,

[PHP-DB] making queries

This is just a quick question. I'd like to no if it's possiable to make a normal link supply infromation to a page of PHP very much like a form and if so how? Thankyou for any help at all Andrew Aitken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

[PHP-DB] stdin

Hi, what is the following? php://stdin Thanx, Vipin. _ Buy Lagaan Yaadein music for 30% less. Avail this special offer at http://shopping.rediff.com/shopping/music/offerrediffmailer.htm -- PHP Database Mailing List

RE: [PHP-DB] session_end()

Okay, but what I want to do is use session_end(). session_destroy() destroys the session, while session_end() actually writes the sesstion and ends it :-). this is achievecd when the script is done, but you have to exit your browser. Thanks for the help, I think I'll just serialize() it.