[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.

[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

[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

[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 .

[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... }

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

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

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

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

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

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

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

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:

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

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

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

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

[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

[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

[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

[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

[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

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);

[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

[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

[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);

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

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

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

[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

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

[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

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

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 =

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

[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

[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

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

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

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

[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