RE: [PHP-DB] Database access using ODBC

2001-06-28 Thread Andrew Hill
Colum, What does the ODBC trace show right after connection, and any subsequent calls? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Miles

[PHP-DB] MySQL Error???

2001-06-28 Thread Brian Grayless
Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any suggestions??? Thanks,

[PHP-DB] static or dynamic printer-friendly webpages?

2001-06-28 Thread sgibbs
Question for all you php experts out there: My organization's website is based on mysql/php backend - 95% of the webpages are generated dynamically using templates and database records. We have been asked to create printer-friendly versions of these pages. Now for your opinion/advice:

[PHP-DB] Using regexps to clean up html files

2001-06-28 Thread olinux o
hi all, I have a very large project where I have to insert information from a large number of HTML files. They are pulled from a public web database so they are somewhat consistent in format. However not all fields are present in each. So what I have decided to do is. Write a script that parses

Re: [PHP-DB] Storing Code in a db?

2001-06-28 Thread Andreas D. Landmark
At 27.06.2001 14:06, you wrote: Hey there, Is it possible to store code like a function, for example, in a mysql database and pull it into a php dynamicallly so you can use the function if needed? Not in a way that would be effective, the only way I could see it work is if you use a script to

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Steve
Couldn't you useSELECT DISTINCT for this? http://www.mysql.com/doc/S/E/SELECT.html - Original Message - From: Joseph Koenig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 8:54 AM Subject: [PHP-DB] Modify Query, or sift through results? I've got a

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

2001-06-28 Thread Mindblender
Do you know if the Oracle client can beinstalled via the command line? I don't have access to the box itself, only telnet access. Jeff Brian S. Dunworth [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jeff, As far as I know, you cannot get *only* the Oracle

[PHP-DB] delay script

2001-06-28 Thread Jennifer Arcino Demeterio
hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =) -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Storing Code in a db?

2001-06-28 Thread Christopher Ostmo
Mark @ 10base-t pressed the little lettered thingies in this order... Hey there, Is it possible to store code like a function, for example, in a mysql database and pull it into a php dynamicallly so you can use the function if needed? Yes, it is possible, but you need to run the code

RE: [PHP-DB] MySQL Error???

2001-06-28 Thread Beau Lebens
sounds like your field definition is something like int(2) or something, it needs to be bigger so that it can handle higher numbers for the unique primary key :) // -Original Message- // From: Brian Grayless [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 28 June 2001 12:24 AM // To: PHP

[PHP-DB] PHP Oracle Stored Functions

2001-06-28 Thread Laurence Veale
Hi, Anyone have information on calling a stored function? Is it similar to a stored procedure? How to you access a return, thorugh OCIBindByName? Regards, Laurence Veale ext 6172 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] managing variant data

2001-06-28 Thread Felix Meulenkamp
Guten Tag Herr Scott, Montag, 25. Juni 2001, 11:21:42, schrieben sie: JS Hi again, another conundrum. JS What is the best way to deal with the following situation? JS You have a group of common properties including a property that indicates a JS second group of common properties. For

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Dobromir Velev
Hi, This error occurs when your auto_increment index field is of type TINYINT. This field type can accept values form -128 to 127 so you cannot add records with index value greater than 127. I recommend you change it to INT(11) UNSIGNED which can accept values from 0 to 4294967295. If you expect

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Dobromir Velev
Hi, you could use the FIND_IN_SET(str,strlist) function which returns a value 1 to N if the string str is in the list strlist consisting of N substrings. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. If you want to find all the

[PHP-DB] Passing XML

2001-06-28 Thread Niel Zeeman
Hi there Is there anyway of passing a xml document to a php page as raw data. What I want to do is eg. send a page a xml document and recieve a response ( in xml ) from that page. I could eg get the result using fopen( 'http://url.com/xml.php' , 'r' ) but how do i send it any data without

Re: [PHP-DB] FW: strange numbers in link

2001-06-28 Thread Jason k Larson
Shawna, Feel free to change this value, it doesn't appear to bear any significance and is probably a typo. Jason k Larson [EMAIL PROTECTED] wrote in message BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1... Our website uses mysql/php. I

Re: [PHP-DB] How do I keep the values of objects when refreshing page?

2001-06-28 Thread Jason k Larson
Please be more specific. Hector M Banda [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all, My page is getting the values and the submits itself displaying the information but the original selection is gone showing the objects with no info. Thanks,

RE: [PHP-DB] MySQL Error???

2001-06-28 Thread Christian Sandfeld
Brian, Sounds to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'.

Re: [PHP-DB] flash

2001-06-28 Thread Jason k Larson
You might also check out libswf. http://www.php.net/manual/en/ref.swf.php -- 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] static or dynamic printer-friendly webpages?

2001-06-28 Thread olinux
hmmm, let me think about this. unless you are crazy you will choose your to stay dynamic. Can you imagine keeping track of new records... let's click the PF version so I can print this... What the hell! Shawna I can't print this damn thing. This link doesn't work. blah blah... It only gets worse

[PHP-DB] delay script

2001-06-28 Thread Jennifer Arcino Demeterio
hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on logout button, it will show a page which will say logging out then after 5 seconds it will redirect to the login page. thanks =)

RE: [PHP-DB] Adobc error

2001-06-28 Thread Christian Sandfeld
It means that the registro.php script can't find the required file adodb.inc.php. Check the path of the requite statement on line 7 of registro.php (looking at the error msg. it could be the '.:' before the '/usr...' causing the problem). /Christian -Original Message- From: Wilmar Pérez

RE: [PHP-DB] Adobc error

2001-06-28 Thread Beau Lebens
Wilmar, it means that a file which is included via the require() function cannot be found. usually this is because they are doing something like require( $ROOT . /the/file/they/want.php); and you haven't set $ROOT properly, or something like that. basically, search registro.php for require and

[PHP-DB] mysql errors .... or php errors ????

2001-06-28 Thread Steve Brett
i know this may not be stricktly php but ... soemtimes when i return queries from mysql to php i get errors like 'invalid index test assumed 'test' in test.php at line 13' can't remember the exact syntax but that's the general idea. if i quote the var when i reference it the error goes

RE: [PHP-DB] Adobc error

2001-06-28 Thread Steve Brett
you need to find adodb.inc.php and then check that the path in the include statement on line 7 in adodb.inc.php is pointing at the correct path. Steve -Original Message- From: Wilmar Pérez [mailto:[EMAIL PROTECTED]] Sent: 27 June 2001 23:48 To: PHP List Subject: [PHP-DB] Adobc

Re: [PHP-DB] delay script

2001-06-28 Thread Jason k Larson
You may find that the HTML meta tag can help you there. -- 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] delay script

2001-06-28 Thread Jason k Larson
sorry so brief earlier .. anyway this is a working sample meta http-equiv=refresh content=5;url=http://www.php.net; -- 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] static or dynamic printer-friendly webpages?

2001-06-28 Thread Jason k Larson
I would recommend staying as dynamic as possible. To answer your question, yes, another simple template (one designed to be friendly to printers) would easily work to do what you need. PDF is an interesting option but a lot of work and the clients/customers would need to ensure having the

Re: [PHP-DB] mysql errors .... or php errors ????

2001-06-28 Thread Jason k Larson
Another thought came to mind. These errors could be the result of verbose error reporting by PHP. php.ini or a script could be setting error reporting high enough to display these errors, however it's extremely poor PHP coding syntax to not correctly quote everything (except constants, of

Re: [PHP-DB] static or dynamic printer-friendly webpages?

2001-06-28 Thread Markus Fischer
I use a method combining both; I first write a so-called 'print.php' which has the ability to write a outputted page to a disk cache on the disk. So pages are only generated the first time they're accessed; on second and further requests they're serverd directly from the cache (disk in my case).

Re: [PHP-DB] Adobc error

2001-06-28 Thread Markus Fischer
Seems you're missing the file 'adodb.inc.php' in any of your include paths, namely '.' and '/usr/share/php'. Either extend the include_path directive in php.ini to make sure adodb.inc.php is in the include path or copy the fileto an appropriate directory. HTH, Markus On Wed, Jun 27, 2001 at

Re: [PHP-DB] Storing Code in a db?

2001-06-28 Thread Leo de Kleijn
It's possible. Store the function as a text field, retrieve it and use eval($fieldvalue); Hey there, Is it possible to store code like a function, for example, in a mysql database and pull it into a php dynamicallly so you can use the function if needed? Mark Leo -- PHP Database

[PHP-DB] Dbase function problem AGAIN !!!

2001-06-28 Thread Bartek Pawlik
Why noone answer ? Hi My problem is I have dbf file, I get one record, one of the record's filed is binary (32 b its). The function dbase_get_record cut Least Sagnificant Bit from this file , I of course I get wrong value. Can anyone help me? Is there sth wrong with function? Thax in advance

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Andreas D. Landmark
At 27.06.2001 17:24, Brian Grayless wrote: Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add

Re: [PHP-DB] static or dynamic printer-friendly webpages?

2001-06-28 Thread Andreas D. Landmark
At 27.06.2001 23:13, [EMAIL PROTECTED] wrote: Question for all you php experts out there: My organization's website is based on mysql/php backend - 95% of the webpages are generated dynamically using templates and database records. We have been asked to create printer-friendly versions of these

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Jason Stechschulte
On Wed, Jun 27, 2001 at 08:54:04AM -0500, Joseph Koenig wrote: I've got a script that searches a db every night and sends out e-mail if it finds something a person would be interested in, based on criteria they gave us. The problem is that I have one field that stores regions of the country

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread biorn
Most likely, your id (index, auto-increment field, whatever it is) data type is tinyint which only goes to 127. Brian Grayless [EMAIL PROTECTED] said: Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 I wrote a great bookmark management program that works

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Saul Diaz Carrillo
Hi You create a unique index (i think primary) an try to enter a key that is already in the table. greetings saul - Original Message - From: Brian Grayless [EMAIL PROTECTED] To: PHP DB list (E-mail) [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 12:24 PM Subject: [PHP-DB] MySQL

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Paul Burney
on 6/27/01 9:24 AM, Brian Grayless at [EMAIL PROTECTED] wrote: 1062: Duplicate entry '127' for key 1 I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Jason Stechschulte
On Wed, Jun 27, 2001 at 10:24:13AM -0600, Brian Grayless wrote: Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 The error means you are attempting to put a second record in with the value of 127. I wrote a great bookmark management program that works fine, but

[PHP-DB] mssql_xxx() and characters

2001-06-28 Thread Karl Henrik Peterson
I tried different solutions and it has led me to suspect a something-or-another in mssql_query() function. However, the problem could originate from mssql_connect() or mssql_select_db() as well since there is no way I can verify otherwise, unless I start debugging. And debugging is exactly what's

[PHP-DB] Which state and country?

2001-06-28 Thread Lisa Elita
Hi all, How can we know from which state and country a hit came? Regards, Lisa Elita -- 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] Executing several PHP scripts simultaneously??

2001-06-28 Thread Lisa Elita
How can we execute several PHP scripts simultaneously inside a single PHP script? For example, let's say master.php has 10 tasks in different PHP scripts: 1.php, 2.php, ..., 10.php. Each task is independent (the input of each task is not determined by other tasks) so we can do the tasks in any

RE: [PHP-DB] MySQL Error???

2001-06-28 Thread Mark Roedel
-Original Message- From: Brian Grayless [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 11:24 AM To: PHP DB list (E-mail) Subject: [PHP-DB] MySQL Error??? Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 I wrote a great bookmark

[PHP-DB] php_sybase_ct.dll and libct.dll

2001-06-28 Thread Karl Henrik Peterson
Hi! After enabling Sybase extensions, PHP complains about not being able to find the extension dll php_sybase_ct.dll. Yet, paths and stuff are all correct and the file is exactly where PHP is looking for it. After restarting web server service PHP starts to complain about libct.dll as well,

[PHP-DB] Sybase extensions for MSSQL??

2001-06-28 Thread Karl Henrik Peterson
Greetings, Would Sybase extensions for php work for MSSQL7? They say mssql_xxx is an alias for sybase_xxx. (I desperately need to get smth. working) Karl. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] delay script

2001-06-28 Thread Attila Strauss
http://www.php.net/sleep hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =) -- PHP Database Mailing

Re: [PHP-DB] delay script

2001-06-28 Thread Markus Fischer
On Thu, Jun 28, 2001 at 11:09:47AM +0800, Jennifer Arcino Demeterio wrote : hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on logout button, it will show a page which will say logging out then after 5 seconds it will redirect to the login

Re: [PHP-DB] delay script

2001-06-28 Thread Dobromir Velev
Hi, You can do this without using a php script why don't you use META HTTP-EQUIV="refresh" CONTENT="N;URL=http://www.foo.com/foo.html" where "N" represents a discrete time interval in seconds. Dobromir Velev -Original Message- From: Jennifer Arcino Demeterio [EMAIL PROTECTED] To:

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Joseph Koenig
Ah ha..now it looks like we're on to something. I had to modify it a bit, but it worked...for the most part. I had to make it rlike North[;|$]. But here's the next problem...I have a region 'Midwest' and 'Upper Midwest'. When I do this search for Midwest, I get the 'Upper Midwest' results also.