[PHP-WIN] RE: php with mssql

2002-11-13 Thread Carlos Andre Marques Moreira
Hi, that's very strange. I use mssql_connect and i can execute all statements: Select, Insert, Update, Delete, Stored Procedures with or without parameters. Wouldn't it be a SQL Syntax error? BTW, my configurationg is W2K + IIS 5.0 + PHP 4.2.2 + MS SQL Server 7.0 Carlos André Marques Moreira SE

[PHP-WIN] RE: Isapi Module

2002-11-06 Thread Carlos Andre Marques Moreira
I tryed to use it, but i'm getting PHP has encountered an Access Violation at When this happen i 'have to stop IIS and restart it. Carlos André Marques Moreira SENAI-CE / CETAE [EMAIL PROTECTED] -Original Message- From: erythros [mailto:erythros@;erythros.d2g.com] Sent: quarta-feira, 6

[PHP-WIN] Problem with W2K + IIS 5.0 + PHP 4.2.2 running as module (isapi)

2002-10-21 Thread Carlos Andre Marques Moreira
Hi, I'm getting the message : PHP has encountered an Access Violation at 012929AE Does anyone know what this could be? Is this a known issue? Previously i as running php 3.0.15 as CGI and never had this problem. Carlos André Marques Moreira SENAI-CE / CETAE [EMAIL PROTECTED]

[PHP-WIN] RE: mssql unable to load dynamic library error

2002-10-16 Thread Carlos Andre Marques Moreira
Hi Alex, is the PHP on the same server as MS SQL Server? If no you should install the ms sql server client tools on php server. Check on php.ini if the extension_dir directive is set properly Copy the file PHP_PATH\dlls\ntwdblib.dll to winnt\system32 Carlos André Marques Moreira SENAI-CE / CET

[PHP-WIN] RE: PHP/SQL search engine help (newbie)

2002-01-07 Thread Carlos Andre Marques Moreira
Hi, AFAIK PHP don't access MS Access directly so you should access your database via ODBC. Here are some ODBC Functions: int odbc_connect(string dsn, string user, string password, int [cursor_type]) -> Connect to ODBC, cursor_type is optional int odbc_exec(int conn_id, string query_string) -> Exe

[PHP-WIN] RE: MSSQL 7.0 and PHP

2001-10-24 Thread Carlos Andre Marques Moreira
I've seen this problem here before. Some guys posted this is a problem in the mssql.dll, don't know if this has been fixed. I had this problem here before, and i "fixed" it changing data type to TEXT Carlos André -Original Message- From: Franco Breciano [mailto:[EMAIL PROTECTED]] Sent: q

[PHP-WIN] RE: variables in URL

2001-10-17 Thread Carlos Andre Marques Moreira
main.php?var1=value1&var2=value2&var3=value3&...&varn=valuen if any value would contain spaces, caracters such as á,é,Ã,ç you should use urlencode($value) LINK or LINK "; ?> Carlos André Marques Moreira Bolsista CNPq / RHAE SENAI / CETAE [EMAIL PROTECTED] 2001 Ano Internacional do Voluntá

[PHP-WIN] strange problem configuring two sites in IIS

2001-09-04 Thread Carlos Andre Marques Moreira
Hi, I've been runing php3.0.15 + w2k +iis 5.0 + mssql 7.0 for some time without problem. Today i tried to setup a second site on IIS, and now i'm having some problems running php files. When i access the site it executes the php file, but if i try to access it again i receive a error (http 500) Pr

[PHP-WIN] RE: php and Dreamweaver (How To)

2001-07-10 Thread Carlos Andre Marques Moreira
Hi, You can put php code using the HTML Editor of dreamweaver. It is just a simple text editor (like notepad). Just put your code there, and dreamweaver won't mess it. Build your page with dreamweaver and then add your code using the HTML editor. Dreamweaver makes it easy to build a HTML page, i

[PHP-WIN] RE: Is this possible? --> Correction

2001-07-05 Thread Carlos Andre Marques Moreira
s a mistake) // Here are the links > link 1 > link 2 -Original Message----- From: Carlos Andre Marques Moreira Sent: quinta-feira, 5 de julho de 2001 12:03 To: 'Michel Laine'; [EMAIL PROTECTED] Subject: RE: Is this possible? 1: To execute php code when a A HREF link is c

[PHP-WIN] RE: Is this possible?

2001-07-05 Thread Carlos Andre Marques Moreira
1: To execute php code when a A HREF link is clicked. One way to do this is: // This will check what link was clicked // Here are the links > link 1 > link 2 Carlos André Marques Moreira [EMAIL PROTECTED] Bolsista CNPq / RHAE SENAI-CE/CETAE 2001 Ano Internacional do Voluntário -Or

RE: [PHP-WIN] mssql_connect

2001-05-16 Thread Carlos Andre Marques Moreira
Hi, now i have the following configuration: server1.domain.com -> winnt + apache + php4.0.4 server2.domain.com -> winnt + ms sql server 7.0 server3.domain.com -> windows 2000 + iis 5 + php3.0.15 + ms sql server 7.0 server4.domain.com -> win98 + omnihttpd2.08 + php4.0.4 I have a file teste.php tha

RE: [PHP-WIN] mssql_connect

2001-05-14 Thread Carlos Andre Marques Moreira
TECTED] Bolsista CNPq / RHAE SENAI-CE/CETAE 2001 Ano Internacional do Voluntário -Original Message- From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 14 de maio de 2001 16:46 To: Carlos Andre Marques Moreira; '[EMAIL PROTECTED]' Subject: RE: [PHP-WIN] ms

[PHP-WIN] mssql_connect

2001-05-14 Thread Carlos Andre Marques Moreira
Hi all, I have the following configuration: winnt + apache + php4.0.4 called let's say server1.domain.com and one with winnt + MS SQL Server 7.0 called server2.domain.com and a third machine with win200 + iis + php3.0.15 + MS SQL Server 7.0 called server3.domain.com on server3 the SQL Server is ca

[PHP-WIN] RE: [PHP] Nulls in database

2001-02-01 Thread Carlos Andre Marques Moreira
Actually you should use is null, or is not null (if you want to retrieve the rows that don't have null values), either uppercase or lowercase. Your query should be something like that: SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion Date] FROM common WHERE [Start Con