[PHP-DB] MSSQL Error with MSSQL 2000
When we run an insert query in MS SQL Server we get the following error Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. On the following website we found this had to do something with the NTEXT-type. http://www.bmc.com/products/distdata/sqlprogfaq.html#error_odbc Now how should we store a memo-field on MSSQL using php_mssql dll? -- http://hace.dyndns.org/ Everything I say is my own opinion and not necessarily that of my employer. -- 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] is it a Many-to-Many relationship ???
Ok, pardon: Table1: ID,weight,m_weight,height,m_height Table2: ID,measure_name This is the question: I've to build a query that gives me with a single select, two rows of the table2. If you can, please give me some hints about this problem: store data with relatives measure units, and a way to make format conversions: for example convert lire to euro, or gr. to kg. I'm thinking to store in table2 the conversion values. ciao __ Abbonati a Yahoo! ADSL con Atlanet! Naviga su Internet ad alta velocità, e senza limiti di tempo! Per saperne di più vai alla pagina http://adsl.yahoo.it -- 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] Pass var from JavaScript to PHP
Good day to all! Consider the following code: FORM ... INPUT type=Text name=criteria size=50 BR INPUT type=Button name=Find value=Find /FORM I want to get the text that the user writes into the text field into a php variable to use it in the same page. I want to use this text as a criteria to search for an entry in my mySQL DB using a LIKE statement in the select. Does anyone knows how to do it? Thanx inadvance.
[PHP-DB] Problem with include()
Can anyone spot why I get the error Warning: Failed opening 'd:/www/htdocs/ski-info-online/poll.php?id=KnChooseBoots' for inclusion (include_path='') in d:\WWW\htdocs/ski-info-online/skiKnSkiBoots.php on line 113 Here is the calling line: ?php include($DOCUMENT_ROOT . /ski-info-online/poll.php?id=KnChooseBoots); ? If I call poll.php?id=KnChooseBoots from the browser it works (exactly the same path). If I drop the argument it works (i.e. php include($DOCUMENT_ROOT . /ski-info-online/poll.php); ). So what the blazes is happening? The manual reads: /* Works. */ include (http://someserver/file.php?varone=1vartwo=2;); and... require($DOCUMENT_ROOT . /header.html); which are the techniques I think I have used. Thanks for any help -torrent -- 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] Re: Pass var from JavaScript to PHP
err...what javascript the form is HTML? Try... form name=NAME method=get OR post action=?php echo $PHP_SELF? Then in your page have a php tag that checks for the presence of $Find (in your case), e.g. if ($Find) { sql = (SELECT * FROM table WHERE $criteria = value); then the rest... } -torrent George Lioumis [EMAIL PROTECTED] wrote in message 009401c16c3d$e529a0c0$[EMAIL PROTECTED]">news:009401c16c3d$e529a0c0$[EMAIL PROTECTED]... Good day to all! Consider the following code: FORM ... INPUT type=Text name=criteria size=50 BR INPUT type=Button name=Find value=Find /FORM I want to get the text that the user writes into the text field into a php variable to use it in the same page. I want to use this text as a criteria to search for an entry in my mySQL DB using a LIKE statement in the select. Does anyone knows how to do it? Thanx inadvance. -- 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] Re: Pass var from JavaScript to PHP
I'll try it right away!! Thanx a lot.- Original Message - From: TorrentUK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 2:56 PM Subject: [PHP-DB] Re: Pass var from JavaScript to PHP err...what javascript the form is HTML? Try... form name=NAME method=get OR post action=?php echo $PHP_SELF? Then in your page have a php tag that checks for the presence of $Find (in your case), e.g. if ($Find) { sql = (SELECT * FROM table WHERE $criteria = value); then the rest... } -torrent George Lioumis [EMAIL PROTECTED] wrote in message 009401c16c3d$e529a0c0$[EMAIL PROTECTED]">news:009401c16c3d$e529a0c0$[EMAIL PROTECTED]... Good day to all! Consider the following code: FORM ... INPUT type=Text name=criteria size=50 BR INPUT type=Button name=Find value=Find /FORM I want to get the text that the user writes into the text field into a php variable to use it in the same page. I want to use this text as a criteria to search for an entry in my mySQL DB using a LIKE statement in the select. Does anyone knows how to do it? Thanx inadvance. -- 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 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] Problem with include()
Could it be windows doesn't like the '/' in the path. OK on a webpage, but not directly into the filesystem? Peter -Original Message- From: TorrentUK [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 12:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with include() Can anyone spot why I get the error Warning: Failed opening 'd:/www/htdocs/ski-info-online/poll.php?id=KnChooseBoots' for inclusion (include_path='') in d:\WWW\htdocs/ski-info-online/skiKnSkiBoots.php on line 113 Here is the calling line: ?php include($DOCUMENT_ROOT . /ski-info-online/poll.php?id=KnChooseBoots); ? If I call poll.php?id=KnChooseBoots from the browser it works (exactly the same path). If I drop the argument it works (i.e. php include($DOCUMENT_ROOT . /ski-info-online/poll.php); ). So what the blazes is happening? The manual reads: /* Works. */ include (http://someserver/file.php?varone=1vartwo=2;); and... require($DOCUMENT_ROOT . /header.html); which are the techniques I think I have used. Thanks for any help -torrent -- 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 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] Problem with include()
Hi Peter, I'll be surprised if that's it as I am running this through an Apache server which insists on the \ being / Also all references to my images are / and they work fine. In fact, I think I mentioned, it calls the poll.php if I drop the argument part (?id=KnChooseBoots). It's all very strange. Thanks for the response. I might just give your suggestion just to be sure. Rgds -torrent Peter Lovatt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Could it be windows doesn't like the '/' in the path. OK on a webpage, but not directly into the filesystem? Peter -Original Message- From: TorrentUK [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 12:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with include() Can anyone spot why I get the error Warning: Failed opening 'd:/www/htdocs/ski-info-online/poll.php?id=KnChooseBoots' for inclusion (include_path='') in d:\WWW\htdocs/ski-info-online/skiKnSkiBoots.php on line 113 Here is the calling line: ?php include($DOCUMENT_ROOT . /ski-info-online/poll.php?id=KnChooseBoots); ? If I call poll.php?id=KnChooseBoots from the browser it works (exactly the same path). If I drop the argument it works (i.e. php include($DOCUMENT_ROOT . /ski-info-online/poll.php); ). So what the blazes is happening? The manual reads: /* Works. */ include (http://someserver/file.php?varone=1vartwo=2;); and... require($DOCUMENT_ROOT . /header.html); which are the techniques I think I have used. Thanks for any help -torrent -- 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 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] Problem with include()
That sounds the likely answer to me too - you don't generally try to send a parameter to something you're including. if you're just trying to go to that page after executing some code, do a print Location:yadayadayada...?id=KnChooseBoots -Original Message- From: Bruno Gimenes Pereti [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 13:41 To: PHP-DB Subject: Re: [PHP-DB] Problem with include() Does include accept parameter? I have never tried. I think php will try to find a file called poll.php?id=KnChooseBoots not a file called poll and give argument for it. Also why do you need to put the parameter if the variable id is already set? Bruno. - Original Message - From: TorrentUK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 11:24 AM Subject: Re: [PHP-DB] Problem with include() Hi Peter, I'll be surprised if that's it as I am running this through an Apache server which insists on the \ being / Also all references to my images are / and they work fine. In fact, I think I mentioned, it calls the poll.php if I drop the argument part (?id=KnChooseBoots). It's all very strange. Thanks for the response. I might just give your suggestion just to be sure. Rgds -torrent Peter Lovatt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Could it be windows doesn't like the '/' in the path. OK on a webpage, but not directly into the filesystem? Peter -Original Message- From: TorrentUK [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 12:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with include() Can anyone spot why I get the error Warning: Failed opening 'd:/www/htdocs/ski-info-online/poll.php?id=KnChooseBoots' for inclusion (include_path='') in d:\WWW\htdocs/ski-info-online/skiKnSkiBoots.php on line 113 Here is the calling line: ?php include($DOCUMENT_ROOT . /ski-info-online/poll.php?id=KnChooseBoots); ? If I call poll.php?id=KnChooseBoots from the browser it works (exactly the same path). If I drop the argument it works (i.e. php include($DOCUMENT_ROOT . /ski-info-online/poll.php); ). So what the blazes is happening? The manual reads: /* Works. */ include (http://someserver/file.php?varone=1vartwo=2;); and... require($DOCUMENT_ROOT . /header.html); which are the techniques I think I have used. Thanks for any help -torrent -- 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 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 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- 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] Date Calculation
Since you mentioned MYSQL, I'm assuming you have some sort of database query in mind. For instance, finding dates in a date field in a table in which 14 days from that field date is significant. For instance, the following locates records whose records contain date fields less than 14 days from today: SELECT * FROM mytable WHERE mydate DATE_ADD(now(), INTERVAL 14 DAY); -Original Message- From: Ben S. [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 11:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date Calculation How do you get the date that is 14 days from today's date? I can get that date with mysql monitor but PHP. I am using PHP4 and MySQL. I have tried many things but nothing works. Does anyone give me a help? Thank you. Ben -- 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 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] MSSQL Error with MSSQL 2000
Hi, DB-Library based drivers don't fully support SQLServer 2000. If you are on Windows, use ODBC with the native driver or download the OpenLink Single or Multi-Tier driver. If you are on Linux, you can use the OpenLink Multi-Tier driver for SQLServer. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Hace [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 7:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL Error with MSSQL 2000 When we run an insert query in MS SQL Server we get the following error Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. On the following website we found this had to do something with the NTEXT-type. http://www.bmc.com/products/distdata/sqlprogfaq.html#error_odbc Now how should we store a memo-field on MSSQL using php_mssql dll? -- http://hace.dyndns.org/ Everything I say is my own opinion and not necessarily that of my employer. -- 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 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] Problem with include()
According to the php manual it can pass args and values. The value I pass in through the $id then determines what poll is presented to the visitor (poll.php opens a file called $id.txt, which contains the poll's title, values, etc). So I set the id variable depending on where the poll script is invoked (i.e. what will the visitor be voting for at this point). I'm confused. I going to have to think of a work-around (sometimes known as a kludge :) ) Thanks -torrent Bruno Gimenes Pereti [EMAIL PROTECTED] wrote in message 008a01c16c48$d3ba94b0$[EMAIL PROTECTED]">news:008a01c16c48$d3ba94b0$[EMAIL PROTECTED]... Does include accept parameter? I have never tried. I think php will try to find a file called poll.php?id=KnChooseBoots not a file called poll and give argument for it. Also why do you need to put the parameter if the variable id is already set? Bruno. - Original Message - From: TorrentUK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 11:24 AM Subject: Re: [PHP-DB] Problem with include() Hi Peter, I'll be surprised if that's it as I am running this through an Apache server which insists on the \ being / Also all references to my images are / and they work fine. In fact, I think I mentioned, it calls the poll.php if I drop the argument part (?id=KnChooseBoots). It's all very strange. Thanks for the response. I might just give your suggestion just to be sure. Rgds -torrent Peter Lovatt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Could it be windows doesn't like the '/' in the path. OK on a webpage, but not directly into the filesystem? Peter -Original Message- From: TorrentUK [mailto:[EMAIL PROTECTED]] Sent: 13 November 2001 12:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with include() Can anyone spot why I get the error Warning: Failed opening 'd:/www/htdocs/ski-info-online/poll.php?id=KnChooseBoots' for inclusion (include_path='') in d:\WWW\htdocs/ski-info-online/skiKnSkiBoots.php on line 113 Here is the calling line: ?php include($DOCUMENT_ROOT . /ski-info-online/poll.php?id=KnChooseBoots); ? If I call poll.php?id=KnChooseBoots from the browser it works (exactly the same path). If I drop the argument it works (i.e. php include($DOCUMENT_ROOT . /ski-info-online/poll.php); ). So what the blazes is happening? The manual reads: /* Works. */ include (http://someserver/file.php?varone=1vartwo=2;); and... require($DOCUMENT_ROOT . /header.html); which are the techniques I think I have used. Thanks for any help -torrent -- 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 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 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] Problem with include()
Try this way: in your php script: $foo = something; include(path/file.php); print $bar; in your file.php (included): globals $foo; $bar = $foo. working; I think this example will help... Bruno. - Original Message - From: TorrentUK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 1:16 PM Subject: Re: [PHP-DB] Problem with include() According to the php manual it can pass args and values. The value I pass in through the $id then determines what poll is presented to the visitor (poll.php opens a file called $id.txt, which contains the poll's title, values, etc). So I set the id variable depending on where the poll script is invoked (i.e. what will the visitor be voting for at this point). I'm confused. I going to have to think of a work-around (sometimes known as a kludge :) ) Thanks -torrent -- 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] Problem with include()
On Tuesday 13 November 2001 23:16, TorrentUK wrote: According to the php manual it can pass args and values. I think this is only true *if* you're including a remote file, ie through HTTP. The value I pass in through the $id then determines what poll is presented to the visitor (poll.php opens a file called $id.txt, which contains the poll's title, values, etc). So I set the id variable depending on where the poll script is invoked (i.e. what will the visitor be voting for at this point). I'm confused. I going to have to think of a work-around (sometimes known as a kludge :) ) I mentioned, it calls the poll.php if I drop the argument part (?id=KnChooseBoots). It's all very strange. That's because the'argument' part (which you can't use when including local files) contains a question mark '?' which confuses Windows filesystem as it stands for a single wildcard character. hth -- Jason Wong Gremlins Associates www.gremlins.com.hk -- 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] Problem with include()
Bruno, I just come on to post a message saying I got it workingexactly the way you mention. Problem I had was I adhered too closely to an example in the manual :) Thanks for your help. -torrent Bruno Gimenes Pereti [EMAIL PROTECTED] wrote in message 00c201c16c5b$1028fd30$[EMAIL PROTECTED]">news:00c201c16c5b$1028fd30$[EMAIL PROTECTED]... Try this way: in your php script: $foo = something; include(path/file.php); print $bar; in your file.php (included): globals $foo; $bar = $foo. working; I think this example will help... Bruno. - Original Message - From: TorrentUK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 1:16 PM Subject: Re: [PHP-DB] Problem with include() According to the php manual it can pass args and values. The value I pass in through the $id then determines what poll is presented to the visitor (poll.php opens a file called $id.txt, which contains the poll's title, values, etc). So I set the id variable depending on where the poll script is invoked (i.e. what will the visitor be voting for at this point). I'm confused. I going to have to think of a work-around (sometimes known as a kludge :) ) Thanks -torrent -- 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: Re: [PHP-DB] Problem with include()
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 able to download the script source for execution from there, so it makes sense to pass parameters. Which HTTP fortunately supports. Unfortunately, local file systems do not necessarily support passing parameters to files being openend for read access. Wich wouldn\'t make sense, because it\'s just being read, not executed. It will tough be executed _after_ being read... As a part of the current runtime environment, sharing the same variable namespace, and stuff. -- 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] Multiple paragraphs; The trick?
Assuming you're using text fields, just include paragraph breaks normally (\n\n) within the field entry. If you're outputting with HTML, you'll definitely need to replace those with p tags, but if you're simply e-mailing the contents plain text, or outputting in some other fashion, it should be straightforward to keep the the formatting intact. Adding a separate table just for the paragraphs seems like more work than necessary, but would certainly work as well. Jelle Ferwerda wrote: HI all, Just a week or so ago I started testing PHP and MySQL databases. Testing is over. I have figured out the basic controls etc. and it is time for the construction of the database and the PhP scripts to get the site up and running. The general layout of the database and its tables is more or less clear to me, except for one important point, for which I would like some advise.. How do you generate multiple paragraphs as output, if they do not have specific characteristics. Say: I am building a database about a sensor, and this page covers like 2 pages of A4 text. Obviously I'd like to make more then one paragraph and add some layoutimagery between paragraphs. How do you put it in a database? (Say: Like this message: The sender is me, the subject is multiple paragraphs, so you should be able to select the message. How do you get the formatting in different paragraphs, since it is not with a specific title, intro paragraph, main text and footer text). Any number of paragraphs and images is possible, so I cannot just create a field for each paragraph. Do you put all text as one entry in one field, with HTML to format the paragraphs? I think it would work, but it doens't seem like it is THE solution.. Or should I add a table in which you put the paragraphs, which you select through your main database, and then sort by paragraph number? Like: Table sensors [Sensor][compagny][country]..[sensor_ID] Table Contents [Sensor_No][Para_No][Content] The answer is probably obvious to you, but for a newbie like me... My database-design book is unfortunatey not made for building databases for the web, and do not explain this sort of structures. Unfortunately: SQL queries fail miserably in my brain.. Probably need a mental upgrade here.. Hope you can help! Thanks, Jelle. -- ___ ____ _ Chris Hobbs / \ \/ / | | |/ ___\| __ \ Head Geek| (___ \ \ / /| | | | (___ | | | | WebMaster \___ \ \ \/ / | | | |\___ \| | | | PostMaster) | \ / | |__| |) | |__| | \/\/\/ \/|_/ http://www.silvervalley.k12.ca.us [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]
[PHP-DB] MS Access Error
Hello, I'm just beginning experimenting with MS Access and PHP. I found all the tutorials online that explain how to create a DSN for my existing Access database, and went through the procedure fine. The DSN I chose is prototype and the database does not have a username or password. I then created a very simple script: HTML HEAD TITLEAccess connection/TITLE BODY ?php #Open a connection to an access database $connection = odbc_connect(prototype,,); if ($connection){ echo Connection establishedbr\n; } else { echo Connection NOT establishedbr\n; } ? When running this file, I get the following output: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in D:\www\Lalli\php\access.php on line 7 Connection NOT established The server is running MS WinNT 4.0 SP6, with PHP 4.0. Can anyone help me out? Thank you, Paul Lalli -- 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] help: running a stored proc on mssql 2000
Hi, I am trying to run the SP 'sp_password' on mssql, using this command: $sql=exec sp_password 'NULL','master','davet'); Is that the correct way ??? But when I run my script I get a error with this statement.. saying Incorrect syntax near ')' $sql_result=mssql_query($sql,$connection); Can't figure the problem. Any idea's. Also, how do I check the returned status ? (linux, using freetds connecting to ms-sql.) Thanks DT -- 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] OCI8
Anyone can help with php and OCI8, to get the connection with Oracle? I am running Oracle 9.0 and the error message is ORA-12705 (invalid or unknown NLS parameter in /usr/local/apache/htdocs/xyz.php on line 5). I am running PHP 4.0.6, Apache 1.3.22 on Suse linux 7.1 Thanks in advance -- 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] Re: MS Access Error
Check the file permissions on the .mdb file. Make sure it is readable by everyone. Bye, John Paul Lalli [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello, I'm just beginning experimenting with MS Access and PHP. I found all the tutorials online that explain how to create a DSN for my existing Access database, and went through the procedure fine. The DSN I chose is prototype and the database does not have a username or password. I then created a very simple script: HTML HEAD TITLEAccess connection/TITLE BODY ?php #Open a connection to an access database $connection = odbc_connect(prototype,,); if ($connection){ echo Connection establishedbr\n; } else { echo Connection NOT establishedbr\n; } ? When running this file, I get the following output: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in D:\www\Lalli\php\access.php on line 7 Connection NOT established The server is running MS WinNT 4.0 SP6, with PHP 4.0. Can anyone help me out? Thank you, Paul Lalli -- 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] Quotes Db
Hi there. I have a small php app connected to sqlServer db. The app is used as a code library for various programming languages. My problem is this, I would like to be able to insert the code for a function (the actual code) into the db. However, I keep running into the quote problem when inserting. In Asp for example, commenting is done by uing a ' . When I try to insert some asp code into the db via my php app,it throws errors. Somebody had mentioned that using addslashes() and sripslashes () functions would do the trick. Is there a better way to do this or are these two functions the best to use? Also, how do I keep the formatting of a function to stay the same while inputting and retrieving? Your time is greatly appreciated! Thx Joe -- 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] help: running a stored proc on mssql 2000
I am trying to run the SP 'sp_password' on mssql, using this command: $sql=exec sp_password 'NULL','master','davet'); Is that the correct way ??? But when I run my script I get a error with this statement.. saying Incorrect syntax near ')' $sql_result=mssql_query($sql,$connection); Can't figure the problem. Any idea's. Also, how do I check the returned status ? (linux, using freetds connecting to ms-sql.) DT, Are there matching parentheses in the code? =dn -- 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] file upload, again
hi there, I've searched the lists and forums for a couple of days now but nope... when I upload a file all is well, it get stored in the tmp directory, the filename and path get stored in the mysql database, however, it won't copy to the desired directory unless I give everyone write permissions to that directory. offcourse I don't like this. How do I tell php to use my username and password when copying the file from the tmp dir to the desired dir? Do I really have to make an ftp connection first? or is there a more simple way? How do you upload all those pictures to the webserver? thanks Leo Kuiper www.koelwebdesign.nl -- 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] Access with PHP on Linux?
Hi there everyone, I have had abit of an emergency, I have a website for a client based on ASP and ACCESS 2000, but the current server is giving us problems so I want to move over to my own server. The problem is my server is a Linux server - is ACCESS 2000 possible? My server has support for PHP, ASP, MySQL, etc .. and it says that PHP is able to interface with ACCESS - but how to hell do you do that? I haven't got a clue - could anyone please help me as it is dead easy using a DSN-LESS connection on the current server, but I don't know where to start here. My server runs the latest Red Hat Linux Apache system, with ASP (Don't remember which version I only know it's not Chilishoft - sorry :-( Latest PHP, MySQL, FP2000 Ext... CGI and so on. I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Thank you for your help it's very much appreciated. Regards Chris Payne www.planetoxygene.com
[PHP-DB] Top 5 list of the visited pages [PHP-DB]
I need a script that produces a top 5 list of the visited pages at my website.. $result = mysql_query( SELECT artikel, count(*) from artikel_vist group by artikel ORDER BY artikel DESC LIMIT 5 , $link); $num_rows = mysql_num_rows($result); while ($raekke = mysql_fetch_array($result)) { extract($raekke); $nr = $nr+1; echo BRB$nr./B Artikel: $artikel antal: $num_rows ; } Tabelname: artikel_vist Column: 1) nr 2) artikel 3) ip 4) time Kind regards Christian http://www.venstre-odense.dk/
Re: [PHP-DB] file upload, again
The web server user needs to have access to that directory. On NT, there are 2 of these users. On *nix, there is one. Giving these users access to write to that directory is not a huge risk. koelwebdesign wrote: hi there, I've searched the lists and forums for a couple of days now but nope... when I upload a file all is well, it get stored in the tmp directory, the filename and path get stored in the mysql database, however, it won't copy to the desired directory unless I give everyone write permissions to that directory. offcourse I don't like this. How do I tell php to use my username and password when copying the file from the tmp dir to the desired dir? Do I really have to make an ftp connection first? or is there a more simple way? How do you upload all those pictures to the webserver? thanks Leo Kuiper www.koelwebdesign.nl -- 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] file upload, again
thanks, I think that's where I can find the solution, it's a unix and maybe php is not the correct user? So maybe php is: user nobody and user nobody does not have the right to write to my directory. I think I can't change the php.ini file (it gets used for a lot of sites) so I probably have to make an ftp connection and upload the file from there. am I right? Leo Kuiper www.koelwebdesign.nl - Original Message - From: Grant Johnson [EMAIL PROTECTED] To: koelwebdesign [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 9:43 PM Subject: Re: [PHP-DB] file upload, again The web server user needs to have access to that directory. On NT, there are 2 of these users. On *nix, there is one. Giving these users access to write to that directory is not a huge risk. koelwebdesign wrote: hi there, I've searched the lists and forums for a couple of days now but nope... when I upload a file all is well, it get stored in the tmp directory, the filename and path get stored in the mysql database, however, it won't copy to the desired directory unless I give everyone write permissions to that directory. offcourse I don't like this. How do I tell php to use my username and password when copying the file from the tmp dir to the desired dir? Do I really have to make an ftp connection first? or is there a more simple way? How do you upload all those pictures to the webserver? thanks Leo Kuiper www.koelwebdesign.nl -- 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 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] file upload, again
or can I copy a file doing something like: copy file to http://user:[EMAIL PROTECTED]/blah? well, I think you need a path instead of a webadress Leo Kuiper www.koelwebdesign.nl - Original Message - From: Grant Johnson [EMAIL PROTECTED] To: koelwebdesign [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 9:43 PM Subject: Re: [PHP-DB] file upload, again The web server user needs to have access to that directory. On NT, there are 2 of these users. On *nix, there is one. Giving these users access to write to that directory is not a huge risk. koelwebdesign wrote: hi there, I've searched the lists and forums for a couple of days now but nope... when I upload a file all is well, it get stored in the tmp directory, the filename and path get stored in the mysql database, however, it won't copy to the desired directory unless I give everyone write permissions to that directory. offcourse I don't like this. How do I tell php to use my username and password when copying the file from the tmp dir to the desired dir? Do I really have to make an ftp connection first? or is there a more simple way? How do you upload all those pictures to the webserver? thanks Leo Kuiper www.koelwebdesign.nl -- 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 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] No Caching (Reloading Fresh Content)
How can I ensure that a specific page is never cached and ALWAYS gets processed every time it is viewed? Sometimes a viewer can hit his/her browser's Back button (such a hateful button), and get a cached version of a dynamic page. I want this page's PHP code to be executed even if the visitor uses their Back button to get to the page. Any thoughts on how to do this? - Jonathan -- 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] No Caching (Reloading Fresh Content)
How can I ensure that a specific page is never cached and ALWAYS gets processed every time it is viewed? Sometimes a viewer can hit his/her browser's Back button (such a hateful button), and get a cached version of a dynamic page. I want this page's PHP code to be executed even if the visitor uses their Back button to get to the page. Any thoughts on how to do this? Check out the discussion on the following page: http://www.web-caching.com/forums/Forum1/HTML/000133.html Chris
[PHP-DB] test
hello? -- 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] MySQL too many connection problems
Hi folks-- I'm working on an installation of phpshop 0.6x and have started getting too many connections to the database errors whenever I work with it for any length of time. I have a heavily database-driven and busy site calling on three databases. Having heard that mysql_pconnect is better to use than mysql_connect, I thought maybe my other scripts using the latter were causing the problem so I moved the busiest pages from mysql_connect to mysql_pconnect. No go. The problem only occurs when I'm using phpshop and affects the entire site, not just the phpshop pages. Sometimes loading my (non-phpshop) home page restarts things, sometimes I have to go in and reboot mysqld. I have customized the phpshop code but I haven't done any customization to the way phpshop connects to the database. Ideas? Many thanks, Lynn -- 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] MySQL too many connection problems
There is a setting when you launch MySQL to tell it how many connections it will accept. Read the following to get a better idea on this: http://www.mysql.com/doc/T/o/Too_many_connections.html The default number of connections to MySQL is 100, but can be set much higher if necessary. You need to set the configuration option max_connections=xxx (with xxx being the number of connections you'd like to try), probably in your my.cnf file. Check out: http://www.mysql.com/doc/O/p/Option_files.html Using persistent connections is a good idea if you don't have a TON of Apache processes running. If you do, then you're going to be opening at least that many connections which will only make your problems worse. Hope that gets you pointed in the right direction. Joshua Hoover Hi folks-- I'm working on an installation of phpshop 0.6x and have started getting too many connections to the database errors whenever I work with it for any length of time. I have a heavily database-driven and busy site calling on three databases. Having heard that mysql_pconnect is better to use than mysql_connect, I thought maybe my other scripts using the latter were causing the problem so I moved the busiest pages from mysql_connect to mysql_pconnect. No go. -- 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] No Caching (Reloading Fresh Content)
I read a bit of it, but it's still giving me trouble. I have the following short, test, PHP script: ? Header(Cache-control: private, no-cache); Header(Expires: Mon, 26 Jul 1997 05:00:00 GMT); # Past date Header(Pragma: no-cache); $link = mysql_connect(localhost,root,password); $R = mysql_db_query(database,SELECT uid FROM users LIMIT 200); $N = mysql_num_rows($R); ? FORM ACTION='?=$PHP_SELF;?' METHOD='POST' Number of Users: ? print $N . - $Step; ? INPUT TYPE='Hidden' NAME='Step' VALUE='? print $Step+1; ?' INPUT TYPE='Submit' /FORM Now, I load that script up, which displays Number of Users: and a submit button. I click on the submit button, and then again on the next page and I basically see: Number of Users: 200 - 3 and a submit button. Now, keeping the browser window open in the background, I go and edit the script, changing LIMIT 200 to LIMIT 100 so that it will return just 100 users. I save and then go back to my browser and click the Back button, but now I get an IE message saying that it cannot automatically resubmit the posted information. What I want is to have it re-query the database with this new LIMIT 100 query and return Number of Users: 100 - 2 So at this point I have either the option of forcing the user to see the IE page and have them reload it, which works, or by allowing caching to go on. Any more thoughts? - Jonathan Chris Boget [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... How can I ensure that a specific page is never cached and ALWAYS gets processed every time it is viewed? Sometimes a viewer can hit his/her browser's Back button (such a hateful button), and get a cached version of a dynamic page. I want this page's PHP code to be executed even if the visitor uses their Back button to get to the page. Any thoughts on how to do this? Check out the discussion on the following page: http://www.web-caching.com/forums/Forum1/HTML/000133.html Chris -- 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] Access with PHP on Linux?
At 13.11.2001 23:23, Chris Payne wrote: Hi there everyone, I have had abit of an emergency, I have a website for a client based on ASP and ACCESS 2000, but the current server is giving us problems so I want to move over to my own server. The problem is my server is a Linux server - is ACCESS 2000 possible? My server has support for PHP, ASP, MySQL, etc .. and it says that PHP is able to interface with ACCESS - but how to hell do you do that? I haven't got a clue - could anyone please help me as it is dead easy using a DSN-LESS connection on the current server, but I don't know where to start here. My server runs the latest Red Hat Linux Apache system, with ASP (Don't remember which version I only know it's not Chilishoft - sorry :-( Latest PHP, MySQL, FP2000 Ext... CGI and so on. I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Install ODBC, that would let you interface with degenerate database formats as access et al. Your best solution however would be to ditch Access and go a decent database solution, one that doesn't tend to break under load (and doesn't impose strange limitations on itself with regards to throughput). (on a totally different not, I'd ditch FP extensions aswell, as they've proved to be a bit of a nightmare on the security front in the past, don't know how they're doing at the moment, but anything that tries to imitate something undocumented is a no-no in my production environments). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- 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] Validation of multiple variables using single include file
I use PHP with MySQL on Linux box. I have some 70 odd forms in one of my application, each with varying number of parameters. Is it possible to have a single function declared using JavaScript that can accept multiple variables as parameters for validation check, before the form is submitted. What would be the syntax ? ie at the end of the form I can just write onClick=validate(parameterA, parameterB, parameterC) Thanx in advance. CK Raju -- 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] phpdb error, need help
Hi, I have been using the phpdb wrapper on http://phpdb.linuxbox.com for about a year now, and have used it to great extent. But now as I have built a new http server for my company I seem to be getting an error with it and the URL for the wrapper is not resolving so tech help there won't work and there is no email address for the author listed. The error is this [Quote] Warning: Undefined variable: boolDBSelected in D:\Inetpub\hells_horses\database\phpDB-mysql.lib on line 110 [/Quote] You can view this in action here http://207.216.247.148/hells_horses/database/codex/roster.php To view what it should be doing go here http://chh.darkness-is.com/database/codex/roster.php I have put the phpdb.inc and the phpdb-mysql.lib in to a zip file and it can be downloaded here http://chh.darkness-is.com/files/phpdb.zip below is the code that I use to use this in a php page. [Quote] ?php include(phpDB.inc); $db = new phpDB(); $db-connect(localhost, guest, guest, CHH); ? The only major changes to how I have the server setup is the fact I am using PHP 4.0.6 and MySQL 3.23.44 the rest of the server information is as follows. [Quote] 2xPII Xeon 450 w/2MB cache MSI 6135 Revision 1 2x512 ECC Registered Corsair PC100 RAM 2xQuantim 18.9GB SCSI-3 7200 RPM HDD 1x12GB Fujitsu EIDE 7200 RPM HDD Windows 2000 Server w/SP2 and all the Windows Updates [/Quote] Clay Culver [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] phpdb error, need help
Clay, Looks like a small tweak in php.ini will do the trick for you. You can change the error_reporting below to something like error_reporting = E_ALL ~(E_NOTICE | E_USER_NOTICE); The problem seems to be caused since the developers of the phpdb wrapper relies on the fact that a variable will be initialised automatically by PHP - heck, I often do that myself in simple vars, not arrays ect ofcourse. Try it and report back if it works or if you need further assistance Lars B. Jensen, CEO and Founder LJWeb GmbH www.ljweb.com -Original Message- From: Clay Culver [mailto:[EMAIL PROTECTED]] Sent: 14. november 2001 12:21 To: PHP DB List Subject: [PHP-DB] phpdb error, need help Hi, I have been using the phpdb wrapper on http://phpdb.linuxbox.com for about a year now, and have used it to great extent. But now as I have built a new http server for my company I seem to be getting an error with it and the URL for the wrapper is not resolving so tech help there won't work and there is no email address for the author listed. The error is this [Quote] Warning: Undefined variable: boolDBSelected in D:\Inetpub\hells_horses\database\phpDB-mysql.lib on line 110 [/Quote] You can view this in action here http://207.216.247.148/hells_horses/database/codex/roster.php To view what it should be doing go here http://chh.darkness-is.com/database/codex/roster.php I have put the phpdb.inc and the phpdb-mysql.lib in to a zip file and it can be downloaded here http://chh.darkness-is.com/files/phpdb.zip below is the code that I use to use this in a php page. [Quote] ?php include(phpDB.inc); $db = new phpDB(); $db-connect(localhost, guest, guest, CHH); ? The only major changes to how I have the server setup is the fact I am using PHP 4.0.6 and MySQL 3.23.44 the rest of the server information is as follows. [Quote] 2xPII Xeon 450 w/2MB cache MSI 6135 Revision 1 2x512 ECC Registered Corsair PC100 RAM 2xQuantim 18.9GB SCSI-3 7200 RPM HDD 1x12GB Fujitsu EIDE 7200 RPM HDD Windows 2000 Server w/SP2 and all the Windows Updates [/Quote] Clay Culver [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] -- 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] Access with PHP on Linux?
Hi Andreas, At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: At 13.11.2001 23:23, Chris Payne wrote: Hi there everyone, [snip] I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Install ODBC, that would let you interface with degenerate database formats as access et al. When you say install ODBC, I assume you mean on the Linux box. Could you give me a pointer as to the best way to achieve this ? [snip -- Andreas D Landmark / noXtension Regards Steve -- - Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- 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] MySQL too many connection problems
Many thanks, I'll let you know how it works out. Best, Lynn -- Lynn Siprelle, Siprelle Associates: Web Publishing Chief Assoc. Josephine b. 9/9/97 * New Assoc. Louisa b. 4/25/01 Business: lynn@siprelle com | Personal: [EMAIL PROTECTED] The New Homemaker: http://www.newhomemaker.com/ -- 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] [PHP-PostgreSQL] table field name case senstive problem
Hi everyone: I found the problem when retrieve data from table or field which are mix-case. I means table or field name like accommdationType. contain lower and upper case character. For example: Query select compID from table after pg_exec() -- select compid from table Thus, I got error message said no attribute **compid***. the field or table become lower case. Is anyone know how to prevent pg_exec case conversion. I guess may put some special character around the field name. Thank for any help Vincent Ma -- 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]