[PHP-DB] áéíóúÁÉÍÓÚñÑ

2003-01-15 Thread Bernain, Fernando G.
How can I query this characters 'áéíóúÁÉÍÓÚñÑ' from a MSSQL DB with PHP??? Actually I obtain this: ' '¡¢£µÖà餥'!!! Thanks Fernando Bernain Senior A Business Process Outsourcing KPMG Argentina Tel: 54 11 4316 5754 Fax: 54 11 4316 5734 [EMAIL PROTECTED] Email Disclaimer The information

RE: [PHP-DB] Special characters

2003-01-06 Thread Bernain, Fernando G.
5734 [EMAIL PROTECTED] -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 2:30 PM To: Bernain, Fernando G.; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Special characters Fernando, try to store you data in unicode (utf8) for example. You ico

[PHP-DB] Special characters

2003-01-06 Thread Bernain, Fernando G.
I'm working with MSSQL7.0 Apache 1.3.19 and PHP4.2.3 When I select a table with this kind of characters: ó The output is ¢... I have the same problem with the others vocals (á-é-í-ú) What can I do??? Forgot the spanish??? Fernando Bernain Senior A Business Process Outsourcing KPMG Argentin

RE: [PHP-DB] displaying a MySQL date in a different format

2003-01-06 Thread Bernain, Fernando G.
I dont know if its the "best" solution, but I made a function that "cut" the date: function sqldate($fecha) { $dia=substr($fecha,0,2); $mes=substr($fecha,3,2); $anio=substr($fecha,6,4); $fechasql=$anio."/".$mes."/".$dia; return $fe

RE: [PHP-DB] Users on line

2003-01-06 Thread Bernain, Fernando G.
03, 2003 7:10 PM To: Bernain, Fernando G.; 'Peter Beckman'; Hutchins, Richard Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Users on line Hi My bank uses two processes. If a user is inactive for more than about 5 minutes it forces you to log in again. This is done server side and just d

RE: [PHP-DB] Users on line

2003-01-03 Thread Bernain, Fernando G.
riginal Message- From: Peter Beckman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 4:49 PM To: Hutchins, Richard Cc: Bernain, Fernando G.; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Users on line I agree; it'd be nice if there was some sort of code that'd be execute

[PHP-DB] Users on line

2003-01-03 Thread Bernain, Fernando G.
I'm working in an app that requires to know who are "on line". When the user login the app, I use session in order to storage de name and login. Its posible to do this??? Thanks! Fernando Bernain Senior A Business Process Outsourcing KPMG Argentina Tel: 54 11 4316 5754 Fax: 54 11 4316 5734 [EMA

RE: [PHP-DB] How to Make a Pop Up Window and show there a mysql table for help input data?

2003-01-02 Thread Bernain, Fernando G.
Es posible, tuve que hacer algo similar pero no me alcanzó solo con PHP, tuve que combinar con JScript... Te sirve?? Fernando Bernain Senior A Business Process Outsourcing KPMG Argentina Tel: 54 11 4316 5754 Fax: 54 11 4316 5734 [EMAIL PROTECTED] -Original Message- From: José Luis [ma

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Bernain, Fernando G.
s to be an easy way to do this. Now my sql server is saying this: Connection is busy with results for another hstmt, SQL state S1000 . it looks like I'll have to take my chances with select max() <>< Ryan -Original Message- From: Bernain, Fernando G. [mailto:[EMAIL PR

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Bernain, Fernando G.
;>< Ryan -Original Message----- From: Bernain, Fernando G. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:09 AM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: NewB: Return New Record ID... This is from de books online (MSSQL). @@IDENTITY (T-S

RE: [PHP-DB] Re: NewB: Return New Record ID...

2002-12-26 Thread Bernain, Fernando G.
This is from de books online (MSSQL). @@IDENTITY (T-SQL) Returns the last-inserted identity value. Syntax @@IDENTITY Return Types numeric Remarks After an INSERT, SELECT INTO, or bulk copy statement completes, @@IDENTITY contains the last identity value generated by the statement. If the state

RE: [PHP-DB] Questions regarding primary keys, updates, and autoincrement

2002-12-23 Thread Bernain, Fernando G.
Michael, why do you need to link de manufacturer table with de product table? I think that you have to clarify the design of your db and your business rules first... for instance, if you have to reuse the IDs (the barcode and de manufa cturer ID), then you will create new tables in order to preserv

[PHP-DB] Crystal Report -> PHP4 / Report Generator

2002-12-11 Thread Bernain, Fernando G.
I'm working in a migration of an application from MSSQL7-VB6.0-Crystal Reports to MSSQL7-winApache-PHP4. I'm having problems with the reporting, because I cant find an "user friendly" solution for the creation of reports with PHP (I need something similar in functionality and look and fell to the