[PHP-DB] MSSQL not working NT4/IIS4/MSSQL6.5

2001-01-17 Thread Robert
I installed IIS, MySQL and php on my Win 2000 machine, set the variables in php.ini. When i do a phpinfo(); it returns that MSSQL is active I then installed php on the company NT Server with IIS and MSSQL. When I do a phpinfo(); MSSQL is nowhere to be seen I copied my php.ini from the

[PHP-DB] Help with loop

2001-01-25 Thread Robert
Why does this spit out the same part over and over until it times out? I have 2 tables in the same database 1: bruindba ---Parts database specific_p Part Number manufactur ---Manufacturer package ---Package in 2: ecomm

Re: [PHP-DB] Help with loop

2001-01-25 Thread Robert
y #302 Englewood, CO 80111, USA http://www.adacorp.com # -Original Message- From: Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 12:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Help with loop

[PHP-DB] insert into mysql

2001-01-25 Thread Robert
//--- Add part -- if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp'),$db"; if(! @mysql_db_query("$sql")){echo("Unable to add part.");mysql_close($db);exit();} } Why does this not work?

Re: [PHP-DB] insert into mysql

2001-01-25 Thread Robert
They are both set as text they store numbers and letters from this link ( it's my local development machine ) http://tech2000/rfq.php?spp=MC68020RC12Epkg=PGAmfc=MOTact=ADDsid=583607b a7b565b6d699da58d7c7fe9ab - Original Message - From: "Darryl Friesen" [EMAIL PROTECTED] T

[PHP-DB] insert into mysql

2001-01-25 Thread Robert
Warning: Supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\rfq.php on line 16 Unable to add part //--- Add part -- if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES $sql.="('$sid','$spp')"; if(!

[PHP-DB] insert in mysql

2001-01-25 Thread Robert
ignore that last one :) I goofed... Still not working right though if($act=="ADD"){ $sql="INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; if(! mysql_query('$sql')){echo("Unable to add part.");mysql_close($db);exit();} } just gives me "Unable to add part"

[PHP-DB] insert in mysql

2001-01-25 Thread Robert
This link is passed to the shopping cart type script where I want to put the spp and the sid into the database. http://tech2000/rfq.php?spp=MC68020RC12Tpkg=PGAmfc=MOTact=ADDsid=583607ba7b565b6d699da58d7c7fe9ab script language='php' // Connect to Database

[PHP-DB] Insert into MySQL

2001-01-26 Thread Robert
Man, do I feel dumb. My wwwuser didn't have the right privledges to add or remove from the database. Works fine now. Thanks for all the suggestions.

[PHP-DB] SQL Newbie Database search question

2001-01-31 Thread Robert
I have a database with several fields... I only want certain fields to show in my results Some of the searched fields have the same value example: searched field is specific_p specific_p comment qty 68030 9845 0 68030 9844 100 68030

Re: [PHP-DB] Returning a formated dat

2001-02-02 Thread Robert
try: $date=substr("$dat", 0,2)."/".substr("$dat",2,2)."/".substr("$dat",-4); - Original Message - From: "Ben Cairns" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 3:13 AM Subject: [PHP-DB] Returning a formated dat I have a date stored in a MySQL field in a

[PHP-DB] newbie help required re oracle

2001-04-29 Thread Robert
Ok I have looked at the faq and cant find the answer, all I seem to find is the question, everywhere and no help for stupid people like me. I want to use my Oracle db from php and apache. I understand I have to compile php4 with oracle selected as an option. I have failed to do this, and need

[PHP-DB] Insert select Blob field from MySQL

2006-04-14 Thread Robert
Does anyone have an example of how to insert and select a blob field in a MySQL 4.1 database ? -- Thanks, Robert L. Campbell 510 Rook Rd.,West Point, TX 78963 Office: 979-242-3083 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] What is the most efficient way to store SELECT results

2007-10-08 Thread Robert
I want to store the results of a SELECT query in order to be able to page through those results and allow the user to select one, see it in more details and then return to the original list of results. What's the usual technique for doing this? -- PHP Database Mailing List

Re: [PHP-DB] alphabetical order

2001-03-07 Thread Robert Gormley
SELECT * FROM films ORDER BY filmname ASC; Robert At 09:57 AM 8/03/2001 +0200, karakedi wrote: hi there, i ve created a database. there are two rows in it, one is "id" and the other consists of "film names". i ve managed to list and print them out sorting by id

[PHP-DB] SAP R3

2001-03-23 Thread Robert Sedlacek
Hi does anyone has Information about using a SAP R3 Database with PHP4? thx Robert -- C o d i t o , e r g o s u m ! I code, therefore I am! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] Apache, PHP, MySQL

2001-04-27 Thread Robert Staph
a valid on-topic result from the search engines on both sites). the php-mysql rpm is the same version as php installed on the machine. I was playing around with a box with 7.1 and the package (php-mysql-4.0.4pl1-9.i386.rpm) installed just fine on that machine. Any ideas? Robert Staph, W3RCS

[PHP-DB] Performance of Stored Procedures ?

2001-05-14 Thread Robert Boehrs
complex queries? Any comments welcome Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Url link

2001-05-14 Thread Robert Staph
Anyone know how to get the connecting client's ip address using php? I need to log this information to a db for security reasons Thanks Robert Staph, W3RCS The Center for Advanced Technologies - Original Message - From: Roel Mulder [EMAIL PROTECTED] To: Mark McCray [EMAIL PROTECTED

[PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Robert Hennig
this script: Warning: Describe fails (E [SQLSTATE=37 000 SQLCODE=-410]) in /v/u/robert/public_html/datenbank.php on line 8 (line 8 is the line $ergebnis = ifx_query(select ident_nr from personal, $conn_id);) What wents wrong? Robert -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Robert Hennig
, on both it works. Thanks Robert Paul Gardiner [EMAIL PROTECTED] schrieb im Newsbeitrag 001201c0e2ca$730d0c40$0200a8c0@PDG">news:001201c0e2ca$730d0c40$0200a8c0@PDG... Hi Robert, Your test code is correct although you could do with an ifx_close($conn_id); at the end. Have you tried runn

[PHP-DB] Oracle password funtion?

2001-07-02 Thread Robert Boehrs
Hi, i was wondering if there's a funktion within oracle for md5 encryption of a string, like there is in mysql (password()). Best Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

RE: [PHP-DB] Distributed Tables vs. fewer Monster Tables

2001-07-07 Thread Robert Klinkenberg
and MessageID. This said, I mostly work with either Oracle or MS-SQL so mysql can still cause problems. ( I always was a bit shy of using mysql as it didn't support a lot of functions that IMOH should be in a real db, like transactions and Ref integrity, but that seems to have changed nowadays) Robert

RE: [PHP-DB] data consistency

2001-07-13 Thread Robert Klinkenberg
MySQL supports transactions so you can submit multiple SQL statements and commit them all at once. example of statement (from www.mysql.com) BEGIN; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; COMMIT; Robert Klinkenberg

RE: [PHP-DB] Re: Making a new row in HTML tables

2001-07-25 Thread Robert Klinkenberg
of blank fields. Robert Klinkenberg -Oorspronkelijk bericht- Van: Ian Grant [SMTP:[EMAIL PROTECTED]] Verzonden:Wednesday, July 25, 2001 6:28 PM Aan: [EMAIL PROTECTED] Onderwerp:[PHP-DB] Re: Making a new row in HTML tables Yeah, but if I had 31, I'd want 6x5 and then 1

[PHP-DB] Application dev w/ PHP MySql

2001-07-30 Thread Robert Barish
Hello I am having to learn php and mysql, at the sametime and with a time constraint. So I am hoping I can have a lending hand from all the coding gurus out there. Let my give you a little back ground. I the owner of an ISP tech support outsourcing company and am trying to develop a call

[PHP-DB] Anyone used Pearson Corilations in PHP

2001-08-13 Thread Robert Trembath
based on that image data for each row of image data. Anyone done this before? Anything similar? Any comment are appreciated. Thanks, Robert - --- Robert Trembath [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] Re: delete user but keep the article

2001-08-15 Thread Robert Hennig
deleting this user and which edits the tables so that the user entry is another one. Robert Rsalomo [EMAIL PROTECTED] schrieb im Newsbeitrag 039c01c1256b$93d54300$0700a8c0@tiger">news:039c01c1256b$93d54300$0700a8c0@tiger... hi, i have a news article database that input by users, for

RE: [PHP-DB] Averaging Numbers

2001-08-15 Thread Robert Klinkenberg
You could also do a select sum(counter) from or, if the db supports it, select avg(...) from ... Saves you the trouble of counting. Robert Klinkenberg Van: Andre P. [SMTP:[EMAIL PROTECTED]] Verzonden:Wednesday, August 15, 2001 6:48 PM Aan: [EMAIL PROTECTED] CC: PHP-DB Onderwerp

RE: [PHP-DB] delete user but keep the article

2001-08-15 Thread Robert Klinkenberg
of actually deleting the user Robert Klinkenberg -Oorspronkelijk bericht- Van: RSalomo [SMTP:[EMAIL PROTECTED]] Verzonden:Wednesday, August 15, 2001 11:21 AM Aan: [EMAIL PROTECTED] Onderwerp:[PHP-DB] delete user but keep the article hi, i have a news article database that input

[PHP-DB] Oracle 8 on Linux on Sparc

2001-08-21 Thread Robert Schultz
, Linux was necessary. Any ideas anyone? -- Robert Schultz - [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Can I UPDATE 2 tables with 1 SQL statement?

2001-08-29 Thread Robert Klinkenberg
but this might lead to concurrency problems Robert Klinkenberg -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] SQL problem

2001-08-30 Thread Robert Vukovic
Table was created with this CREATE TABLE `descriptions` ( `id_property` bigint(20) NOT NULL default '0', `short_desc` varchar(255) default NULL, `long_desc` text, KEY `id_property`(`id_property`), PRIMARY KEY (`id_property`), UNIQUE KEY `id_property_2`(`id_property`) ) TYPE=MyISAM

RE: [PHP-DB] SQL problem

2001-08-30 Thread Robert Vukovic
Table was created with this CREATE TABLE `descriptions` ( `id_property` bigint(20) NOT NULL default '0', `short_desc` varchar(255) default NULL, `long_desc` text, KEY `id_property`(`id_property`), PRIMARY KEY (`id_property`), UNIQUE KEY `id_property_2`(`id_property`) )

RE: [PHP-DB] SQL problem

2001-09-01 Thread Robert Vukovic
2001. 10:04 To: Robert Vukovic; [EMAIL PROTECTED] Subject: Re: [PHP-DB] SQL problem Hi, Are there any error messages? Just a guess - may be this will work Select $tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM $tbl_virtual left join $tbl_descriptions on $tbl_virtual.id_property

[PHP-DB] Parsing of db results by PHP

2001-09-09 Thread Robert Gormley
on rendering... With the above example, the raw code is just spat to the browser, and doesn't hit the interpreter. Any ideas? Regards, Robert Robert Gormley [EMAIL PROTECTED] http://seabreeze.asn.au/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Parsing of db results by PHP

2001-09-10 Thread Robert Gormley
the Miscellaneous Functions chapter (XXXVIII). -Original Message- From: Robert Gormley [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 09, 2001 1:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Parsing of db results by PHP Hi all, I have a MySQL db which contains table test, field test... one

[PHP-DB] Replace into

2001-09-14 Thread Robert Lindgren
Hi! In mySql you can do: replace into tbl_name values(value_1, value_2) does it work for Oracle aswell? Can anybody provide me with a link to a GOOD Oracle syntax reference. Oracle needs serious help with their documentation...:-( Regards /Robert -- PHP Database Mailing List (http

[PHP-DB] Persistent Links and Temporary Tables

2001-09-14 Thread Robert Gormley
... also, how does this affect concurrency of temp table creation? Robert Robert Gormley [EMAIL PROTECTED] http://seabreeze.asn.au/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] Problem with session function: URL Parameter

2001-09-26 Thread Robert Gruber
I would use the session functions with URL parameter but PHP can't transmit the SID to the link-URL. This methods work: 1. ?php session_id(); session_name(); session_register(username); session_write_close(); ? a href=admin/admin.phtml??=SID?next/a Result:

Re: [PHP-DB] Problem with session function: URL Parameter

2001-09-26 Thread Robert Gruber
Jason Wong [EMAIL PROTECTED] schrieb im Newsbeitrag 001401c1469c$7c788440$[EMAIL PROTECTED]">news:001401c1469c$7c788440$[EMAIL PROTECTED]... -Original Message- From: Robert Gruber [mailto:[EMAIL PROTECTED]] Sent: 26 September 2001 22:19 To: [EMAIL PROTECTED] Subject:

Re: [PHP-DB] Sorting a 2 dimension array

2001-10-05 Thread Robert Gormley
Is ksort() what you're looking for? Sorts an array by key, maintaining key to data correlations. Robert At 05:31 PM 5/10/2001 +0930, John Clarke wrote: I would like to sort a 2 dimensional array based on the value of one of the keys of each element. I have an array returned from a msql query

[PHP-DB] TREE in a database

2001-10-29 Thread Robert Vukovic
Is there an easy way to implement tree structure in a database. Something like file systems do for files. Hints, links, anything. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

RE: [PHP-DB] sending bulk emails

2001-11-02 Thread Robert Klinkenberg
) don't like. Robert Klinkenberg -Oorspronkelijk bericht- Van: Rick Emery [mailto:[EMAIL PROTECTED]] Verzonden: Friday, November 02, 2001 2:26 PM Aan: PHP DB list Onderwerp: RE: [PHP-DB] sending bulk emails Opswe've just armed a potential spammer... -- PHP Database Mailing List

RE: [PHP-DB] sending bulk emails

2001-11-03 Thread Robert Klinkenberg
Always nice to know when something is not too serious :-). -Oorspronkelijk bericht- Van: Rick Emery [mailto:[EMAIL PROTECTED]] Verzonden: Friday, November 02, 2001 5:05 PM Aan: PHP DB list Onderwerp: RE: [PHP-DB] sending bulk emails my comment was humor. we've already explored and

RE: [PHP-DB] TREE in a database

2001-11-04 Thread Robert Vukovic
Thanks, that is exactly what I needed and it doesn't look so complicated. -Original Message- From: John Lim [mailto:[EMAIL PROTECTED]] Sent: 31. oktobar 2001. 16:44 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] TREE in a database Actually relational databases are set-based. The

Re: Re: [PHP-DB] Problem with include()

2001-11-13 Thread Robert Böhm
The manual reads include (\http://someserver/file.php?varone=1vartwo=2\;); and... require($DOCUMENT_ROOT . \/header.html\); As you can see the upper one among the above line refers to opening a remote file for inclusion via http. If it the server is somewhat properly configured you will not be

[PHP-DB] RE: [PHP-WIN] Can I rotate a gif with PHP

2001-11-02 Thread Robert Trembath
is written in PHP and I cannot find anything that references rotating an image in the PHP docs. There is some reference to rotating images in a pdf with PHP, but nothing else. Anyone have any ideas? -- Robert Trembath Internet Technology Manager e|[EMAIL PROTECTED

[PHP-DB] question

2001-12-12 Thread Robert Weeks
they will print out but they wont show up in the ?=$address1? tags. I tried setting the varibles to global and that still doesn't seem to work. I know I'm missing something really simple and basic here. If someone could give me a push in the right direction I'd appreciate it. Thanks, Robert -- PHP Database

Re: [PHP-DB] question

2001-12-12 Thread Robert Weeks
Yup, I knew it was something really simple. I should never touch a computer before the coffee is brewed ;-) Thanks! Robert On Wednesday, December 12, 2001, at 11:09 AM, Steve Cayford wrote: Do you want $$fname = $val here? Taking the string in $fname as the name of a variable to which

[PHP-DB] Hashes

2001-12-21 Thread Robert Weeks
was trying to do it like this but echo $item returned Array: ?php #query db and get a result snipped $item = $row[item]; $item = array('Mens Ring' = m_r, 'Mens Charm' = m_c, 'Womens Ring' = w_r,'Womens Charm' = w_c); echo $item; ? Any help would be appreciated. thnx, robert

Re: [PHP-DB] Hashes

2001-12-21 Thread Robert Weeks
)){ if ($key == $item){ $item_text = $val; } } echo $item_text; Thanks again, Robert - Original Message - From: Matthew Loff [EMAIL PROTECTED] To: 'Robert Weeks' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, December 21, 2001 4:26 PM Subject: RE: [PHP-DB] Hashes Robert

Re: [PHP-DB] Username

2002-02-05 Thread Robert Weeks
://www.devshed.com/Server_Side/PHP/TimeIsMoney/TimeIsMoney1/page1.html Robert On 2/5/02 9:50 AM, Jennifer Downey [EMAIL PROTECTED] wrote: All I want is to get the username into the database. As soon as test.php shows in browser, the Username, submit button and box ar e there but also it prints

Re: [PHP-DB] File Uploading... Two problems...

2002-02-05 Thread Robert Weeks
Instead of using chmod 777 (ick!) you should change the ownership of the file to be owned by the web server user which is usually nobody you can do this with the chown command from the command line. Robert Directory structure home web recruiter --- folder where the scripts reside

Re: [PHP-DB] Username

2002-02-05 Thread Robert Weeks
field, then your insert statement tries to insert NULL into that field. You need to change this: $query = INSERT INTO users (uid, name) VALUES(NULL, $name); To this: $query = INSERT INTO users (name) VALUES ($name); Robert On 2/5/02 10:46 AM, Jennifer Downey [EMAIL PROTECTED] wrote: I am

Re: [PHP-DB] File Uploading... Two problems...

2002-02-05 Thread Robert Weeks
Yeah, My chown reference was to chowning the folder that the files are uploaded to, not the indv. files. Robert - Original Message - From: JD Daniels [EMAIL PROTECTED] To: Todd Williamsen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 05, 2002 12:21 PM Subject: RE: [PHP-DB

[PHP-DB] Viewing Session Varibles

2002-02-07 Thread Robert Weeks
, Robert Weeks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Viewing Session Varibles

2002-02-07 Thread Robert Weeks
appreciated. Thanks, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP IDE

2002-02-23 Thread robert janeczek
After spending two frustrating hours tracking down a bug yesterday - only to discover it was a misplaced quote mark. I've had it. I am looking for suggestions out there for a good IDE for PHP development, preferably one that doesn't cost an arm and a leg. I tried PHP4EE studio, but it

Re: [PHP-DB] mysql and file upload problems

2002-03-09 Thread Robert Weeks
Why don't you just do the sql insert *after* the file upload function?: Pseudocode: if( NOT file upload attack, wrong file type, etc.){ //copy the file to the permanaent location //call function to insert file details into the database } else{ //echo error to user

Re: [PHP-DB] MySQL and apostrophes, interesting problem. 42082

2002-03-10 Thread Robert Weeks
See the manual at php.net: addslashes() stripslashes() I've found it easier to just turn on magic-quotes in the php.ini file This is all covered at php.net Robert - Original Message - From: Nick Patsaros [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

[PHP-DB] Newbie and having to convert from idc/htx format

2002-04-26 Thread Robert Webb
+execute sp_corporate_wide_database_search '%name%', '%classification%' +End +if typesearch = 'company' +begin +execute sp_main_company_search '%name%', '%classification%' +end I am on a tight schedule with this. Otherwise I would be only digging into any manual I could find first. Thanks, Robert

Re: [PHP-DB] how to format the output of the text info that user uploaded?

2002-08-19 Thread Robert Parker
On Sunday 18 August 2002 04:22 pm, you wrote: I have a field in a form which allows user to upload thier biographys.Once they upload a bunch of texts,the script I wrote automatically show it on a webpage, however, the contents are all scrambled toghther without line break and formatting..

FW: [PHP-DB] php-db-unsubscribe@lists.php.net

2002-09-10 Thread Robert DelGarbino
-Original Message- From: rdelgar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 9:07 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [EMAIL PROTECTED] [EMAIL PROTECTED] Sincerely, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] DEALING WITH RETRIEVING AND WRITING DATE VALUE FROM/TO TABLE

2002-10-09 Thread Robert Leahong
I need to know how to retrieve a date field from a database table using MYSQL_DB_QUERY to create recordset. As well as writing a Date Variable to a table using MYSQL_QUERY . YOURS Truly, Robert Leahong. [EMAIL PROTECTED

[PHP-DB] Fw: Dows anyone know why this was bounced?

2002-10-31 Thread Robert Twitty
Does anyone know why all mail that I send to any aspect of the php-db list is bounced when it is sent from the address below? -- bob - Original Message - From: Robert Twitty [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 31, 2002 9:39 PM Subject: Returned mail: see

[PHP-DB] ODBTP, a possible solution for MS-SQL and other databases

2002-11-01 Thread Robert Twitty
, Robert, ODBTP Creator, .2, ODB_DEFAULT ); SetEmployeeNotes( $qry2, $Id, I've added my 2 cents worth to PHP. ); $Id = AddEmployee( $qry1, 311322343454685, Johnson, Mary, Supervisor, 10, Supervises folks ); SetEmployeeNotes( $qry2, $Id, She can read greek: - ? Dr

Re: [PHP-DB] Re: ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Robert Twitty
Thanks for the tip. I will take this issue to the PHP-DEV list. -- bob - Original Message - From: l0t3k [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 02, 2002 2:31 AM Subject: [PHP-DB] Re: ODBTP, a possible solution for MS-SQL and other databases Robert

[PHP-DB] Is MySQL available from my host.

2003-01-03 Thread Robert Wagner
I recently signed up with a low-cost web server, in order to do some web-page accessed database work. The server has PHP Version 4.0.6 and phpinfo() yields (in part): PHP Version 4.0.6 System SunOS src 5.7 Generic_106541-12 sun4u sparc SUNW,UltraSPARC-IIi-cEngine Build Date Feb

[PHP-DB] Re: Is MySQL available from my host.

2003-01-03 Thread Robert Wagner
Robert Wagner [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I recently signed up with a low-cost web server, in order to do some web-page accessed database work. The server has PHP Version 4.0.6 and phpinfo() yields (in part): PHP Versi

Re: [PHP-DB] Re: Is MySQL available from my host.

2003-01-03 Thread Robert Wagner
Richard: Thanks for your rapid reply. What their tech support is saying is Sorry, we do not offer a database server. Based on the results of the phpinfo output, is that possible? Thanks again, Robert -- Richard Hutchins [EMAIL PROTECTED] wrote in message

Re: [PHP-DB] Re: Is MySQL available from my host.

2003-01-06 Thread Robert Wagner
? Thanks to you, Richard and others for past and future help. Robert Matthew Moldvan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED].. . Exactly what I was going to say ... go to www.download.com and search for PHP Triad, which is PHP, Apache, and MySQL al

[PHP-DB] Problem w/ generating png on Linux with more than 250 objects ona single graphic

2003-01-15 Thread Robert Trembath
values My configuration is: Red Hat 7.3 with all current updates for that release apache 1.3 and PHP 4.1.2 Any ideas on how to get this to work properly? Thanks in advance for your help and advise! Robert Trembath CSE e| [EMAIL PROTECTED] Bacterial BarCodes, Inc. Houston, TX -- PHP Database

[PHP-DB] Links to samples from Problem w/ generating png on Linux

2003-01-15 Thread Robert Trembath
The images were stripped on my post but here's an external link to the images I refer to: Sample1 : http://linux.diversilab.com/sample1.gif Sample2 : http://linux.diversilab.com/sample2.gif Thanks, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Path string problem

2003-01-16 Thread Robert Wagner
(File path is wrong!);} I've tried many variations on Somepathname (with both forward and backward slashes), but they all fail. Is there a way out of this mess? TIA for any help on this. Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: SapDB

2003-02-19 Thread Robert Sundström
... :-) - Robert Sundström, Mimer SQL Development Upright Database Technology AB, http://www.mimer.com Validate your SQL statements/procedures at http://developer.mimer.com/parser -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql database ****.sql thru a php script

2003-03-23 Thread Robert Race
I have a large sql file that I would like to load into mysql database from a remote client. Is there a way through a php script to do this? I have tried $query = contents of database.sql ; (where the contents of the sql file was pasted into the query) then $results = mysql_db_query(database,

[PHP-DB] PHP 4.2.1 and Oracle9i

2003-05-31 Thread Robert Varner
Can anyone tell me whether PHP 4.x will continue to operate with Oracle9i using the PHP OCI calls? I understand that PHP may have to be recompiled again for Oracle9i. [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Query takes to much time

2003-06-04 Thread Robert Twitty
What database are you using? Also, are all the fields involved in the joins and whare clause properly indexed? Depending on the database you are using, it is possible to determine if the indexed fields are being used. -- bob On Tue, 3 Jun 2003, André Sannerholt wrote: Hi everybody, now I

[PHP-DB] Anyone know what Error 502 Bad Gateway means?

2003-04-12 Thread Robert Johnson
Hi all. I'm getting this error using Dreamweaver MX, php and mysql on a IIS server over my intranet. I can't figure out what it means... it happens when I try to connect to a table using php. TIA, Robert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Count database-values

2003-06-10 Thread Robert Wanadoo
with SUM but with the following code it doesn't work: $squery = SELECT SUM(bedrag) AS Total FROM finance WHERE posneg = 'af'; any suggestions how to do? I want to store it in a variabele ($total) so I can echo it. (E.g.: $total = 93.63 in this case) Thanx in advance, Robert van der Mast

Re: [PHP-DB] how to update field without using UPDATE query? youare kidding?

2003-06-10 Thread Robert Twitty
In order o update fields without using a UPDATE statement you have to use a cursor. In general, this is how ADO (the technology used by ASP) performs its updates in the manner you outlined below. There are no extensions bundled with PHP of which I am aware that allow you to update data via a

[PHP-DB] sqlconnect garbage while connecting with db2

2003-06-17 Thread Robert Bedell
Hi, I don't read this often so please reply to my email: [EMAIL PROTECTED] I'm using PHP 4.3.1 with DB2 8.1 on RedHat 8.0. I compiled against DB2 fine, with no problems. I connect using db2 with no problems - the 'test' database is perfectly catalogued. However when I try to run the below page

[PHP-DB] Re: sqlconnect garbage while connecting with db2

2003-06-17 Thread Robert Bedell
Ok, I put in the environment variables LIBPATH=/home/db2/sqllib/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/db2/sqllib/lib VWSPATH=/home/db2/sqllib VWS_LOGGING=/home/db2/sqllib/logging VWS_TEMPLATES=/home/db2/sqllib/templates DB2INSTANCE=db2 (basically, I ran the ~db/sqllib/db2profile command

[PHP-DB] updateable cursors in db2 via odbc_exec call?

2003-06-17 Thread Robert Bedell
I've noticed that the odbc_exec call appears to call SELECT statements as updateable in db2. Is there then a way to update each row of the response (an updateable cursor)? Any thoughts would be appreciated. thanks Rob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Re: MySQL Extention in PHP5.0.0b2-dev

2003-07-07 Thread Robert Schmelzer
Hi! Check, if the libMySQL.dll is in a directory, where it can be loaded. For example, add the c:\php5\dlls directory to your path variable. This is because, php_mysql.dll loads the libMySQL.dll. greetings Robert Adam Lundrigan [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED

Re: [PHP-DB] PHP/ODBC/Apache/Netware/Foxpro Problem

2003-07-14 Thread Robert Twitty
What is the setting of the ODBC connect string parameter SOURCEDB? Does the PC running Apache have permission to access the path specified by SOURCEDB? -- bob On Mon, 14 Jul 2003, YT Lee wrote: I have a Windows XP PC configured as follow: 1. Apache 2.0.46 2. PHP 4.3.2 3. Microsoft Visual

Re: [PHP-DB] Access 95 ODBC Annoyance

2003-07-17 Thread Robert Twitty
If the other application opens the database exclusively, then you will not be able to open it, even for read only. The only solution to modify the sharing option used by the other application. Another problem you may encounter is that the ODBC driver for Access is not thread safe. -- bob On

Re: [PHP-DB] ODBC Database

2003-08-11 Thread Robert Twitty
Unless I am mistaken, but isn't there an ODBC driver available for MySQL called MyODBC? -- bob On Sun, 10 Aug 2003, Gerard Samuel wrote: Larry E.Ullman wrote: Im looking at venturing into working with PHP's ODBC extention. Does anyone have any recommendations as to a Database, that is

Re: [PHP-DB] PHP MSSQL

2003-08-11 Thread Robert Twitty
This is true if Shaun was using MySQL, but he is using MSSQL. MSSQL allowas you to declare char and varchar fields with lengths up to 8000 characters. Unfortunately the extension bundled with PHP cannot read beyond the first 255 characters. This is primarily due to the fact that the extension

Re: [PHP-DB] Re: PHP MSSQL

2003-08-14 Thread Robert Twitty
I believe this is only applicable to fields of type text. It may have no effect on varchar(255) fields. The purpose of this statement is to limit the amount of memory allocated by the driver for text data. If it is not specified, the driver will try to allocate 2GB of memory. The extension sets

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-18 Thread Robert Twitty
What platform are you using? Since it appears that the script is crashing, you are probably on Linux or some other UNIX flavor. If this is the case, the TDS protocol setting may not be correct. What type of date are you retrieving with this stored procedure? -- bob On Sun, 17 Aug 2003,

Re: [PHP-DB] Mcrosoft SQL Server and for xml auto queries

2003-08-19 Thread Robert Twitty
The win32 version of the mssql extension does not support the FOR XML clause because it sends the results using ntext, which is the new UNICODE text type introduced in SQL Server 7.0. The mssql extension was built with DB-Library, which cannot read ntext fields. DB-Library is obsolete, and

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-20 Thread Robert Twitty
is running on Linux. I am trying to retrieve simple data such as text and numbers. I am not sure what the TDS protocol setting should be. What are the typical settings and how can I check it? Would appreciate any tips for debugging. Thanks. - Original Message - From: Robert Twitty

Re: [PHP-DB] MSSQL2000 and PHP

2003-09-02 Thread Robert Twitty
Yes You cannot read varchar(255) data fields. You cannot easily read ntext and nvarchar (UNICODE) fields. No direct support for stored procedures. -- bob On Mon, 1 Sep 2003, Arnaud L wrote: Hi, We have migrate our SQL server to MSSQL2000. Since this migration, we can't connect to MSSQL

Re: [PHP-DB] Re: PHP connection to remote Access database on NT

2003-09-12 Thread Robert Twitty
You cannot use FreeTDS to connect to an Access database. You also cannot use odbc on Linux either. The only way to connect to an Access database from Linux is with something like EasySoft's ODBC-ODBC bridge or ODBTP. -- bob On Thu, 11 Sep 2003, nabil wrote: Yes , and I done myself to mssql

Re: [PHP-DB] HELP-PHP install

2003-10-01 Thread Robert Hennig
Jason Wong wrote: On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote: cd /apache/apache-xxx ./configure --prefix=/www cd /php/php-xxx ./configure --with-mysql --with-apache=/apache/apache-xxx --enable-track-vars make make install cd /apache/apache-xxx ./configure

Re: [PHP-DB] ODBC to MSSQL on FreeBSD for PHP

2003-10-09 Thread Robert Twitty
You should use the mssql extension for this purpose. Another alternative is odbtp. -- bob On Thu, 9 Oct 2003, rick rice wrote: What do I need and where can I get it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database

RE: [PHP-DB] ODBC

2003-10-15 Thread Robert Twitty
Take a look at ODBTP, which is located at http://odbtp.sourceforge.net. ODBTP allows you to remotely connect to Win32-based ODBC from any machine, including Linux/UNIX. -- bob On Wed, 15 Oct 2003, Ricardo C. Fernandez de C. wrote: Hi, The sad part is that there is 0 documentation about how to

Re: [PHP-DB] ODBTP - ODBC - FOXPRO.

2003-10-17 Thread Robert Twitty
Setting SourceDB=c:\telefonia\; instead of SourceDB=c:\telefonia\CDTCTL01.DBF; solved the problem. -- bob Warning: [S1000][1][Microsoft][ODBC Visual FoxPro Driver]Fox Error 1 [IM006][0][Microsoft][Administrador de controladores ODBC] Error de SQLSetConnectAttr del controlador in

  1   2   3   >