On Thursday 25 July 2002 13:34, Monty wrote:
Is there a way to re-set the internal counter that automatically increments
auto_increment fields? While testing an app, I added a lot of test
records that I've deleted, so, I'd like to reset the counter back to the
beginning now.
Yes, it's
Do you know which page it's on? I've searched the MySQL online help for 40
minutes and can't find anything, which is why I asked here.
From: [EMAIL PROTECTED] (Jason Wong)
Organization: Gremlins Associates
Reply-To: [EMAIL PROTECTED]
Newsgroups: php.db
Date: Thu, 25 Jul 2002 14:41:49 +0800
On Thursday 25 July 2002 15:03, Monty wrote:
Do you know which page it's on? I've searched the MySQL online help for 40
minutes and can't find anything,
Sorry I wouldn't know.
which is why I asked here.
But really you should be asking on the MySQL list, hopefully that's where the
MySQL
I am using mysql.
Is it possible to count the number of words in a text column?
Or is this a job for php(The info will be going into php anyway)?
I can use $word = explode(' ',$row['text']);
then use count($word ).
I just ask because mysql *may* be able to do it.
--
JJ Harrison
[EMAIL
Say I have a Table (MySQL) with the field PhoneNumber that is UNIQUE.
Now I want to import a file into the Table that may have some of the same
phone numbers. Is there a way to do this, without the duplicate values
stopping the import, and just skip them instead?
Thanks,
Scott
___
Hi,
Im using PHP 4.0 and MySQL and I have a PHP procedure on one site that
need to connect to a MySql database outside this domain, I need to
append records in a database on a different domain. How can I do this?
I will apreciate if anyone give me some help or a simple example how
to do
instead up supplying 'localhost' in your mysql_connect() function just use
the full name of the server i.e mysql_connect(www.domain.com $user,
$pass) you must ensure the port is open through the firewall, if
applicable, and that you have a user set up with that can access it from
another
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...
Hi,
Im using PHP 4.0 and MySQL and I have a PHP procedure on one site that
need to connect to a MySql database outside this domain, I need to
append records in a database on a different domain. How can I do this?
I will apreciate
$result = mssql_query($query) or die(mssql_get_last_message());
Adam Voigt
[EMAIL PROTECTED]
On Wed, 2002-07-24 at 19:48, Salve Tinkerworth wrote:
Does anyone have any good tips for error handling? I've tried different
methods to retrieve good error information from mssql_query but nothing
has anyone had any expierence with the datetime field coming back from
MSSQL as someting along the lines of February 3, 2036 6:36AM. This happens
to me no matter the time in the database. PHP inserts it correctly, but
the select has a problem. I am using php4.1.2 and SqlServer 7.0.
Or is
Could you give an example of what you are sending in as the date value
in an Insert/Update?
Adam Voigt
[EMAIL PROTECTED]
On Thu, 2002-07-25 at 08:45, [EMAIL PROTECTED] wrote:
has anyone had any expierence with the datetime field coming back from
MSSQL as someting along the lines of February
Hi,
there exists a workaround in php for this problem. Just put in your php.ini:
mssql.datetimeconvert = 0
or in your script:
ini_set('mssql.datetimeconvert' , 0);
this causes date values in this format: -MM-DD HH24:MI:SS
if it doesen't work correctly, the upgrade to php4.2.1
bye,
[EMAIL
Mark,
ODBC is not inherently slower - it depends if the driver is built as an
abstraction to the native layer or if it bypasses the native layer. In
addition, a properly written ODBC driver will actually enforce
additional functionality on the back-end database, to further isolate
you from
I suggest putting the column name in quotes.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Virtuoso Universal Server
-Original Message-
From: Nuttzy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17,
Nicolas,
I believe the _pconnect functions all close connections if you close the
script - they are most useful when you have multiple connections in a
single page.
Also, are you using the CGI version of PHP? Pconnects are not
persistent with this version.
Best regards,
Andrew Hill
Director
If it's got an ODBC driver then you are all set - maybe port the ODBC
driver to *nix using iODBC? www.iodbc.org
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Virtuoso Universal Server
-Original Message-
Hello,
On 07/25/2002 02:34 PM, Andrew Hill wrote:
Pierre,
Why not use ODBC functions everywhere?
I already told you before. ODBC is very weak API for real database
abstraction. To make it worse, PHP ODBC API is buggy and not as complete
as it could be.
As the maintainer of PHP ODBC
Hello,
On 07/25/2002 02:34 PM, Andrew Hill wrote:
Mark,
ODBC is not inherently slower - it depends if the driver is built as an
abstraction to the native layer or if it bypasses the native layer. In
addition, a properly written ODBC driver will actually enforce
additional functionality
Manual,
Certainly - please help us pinpoint any issues.
Dan Kalowsky has done some great work in resolving lingering ODBC issues
in PHP, and I help in my way with testing and iODBC support.
I respect the work you have done with Metabase, but it's a fallacy to
suggest that ODBC is weak - some
Hello folks,
Apologies for the cross-post, but I wanted to announce the publication
of a new HOWTO on compiling ODBC support into PHP and Apache with the
iODBC Driver Manager:
It's available at the www.iodbc.org site in the left hand column.
You may view the document directly at:
CLASSIFICATION: UNCLASSIFIED
Do you have any examples of uploading via post and downloading via visiting
a download page for this?
Eric Jones (Contractor)
FDIC Web Enabler
E-mail: [EMAIL PROTECTED]
Office - 520-533-6628
Cell - 520-980-2136
Email Pager - [EMAIL PROTECTED]
Direct Private Fax -
How would I produce a triple DES or 3DES password?
I was using:
$passwd = crypt($passw);
but it is only DES.
Larentium
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi there,
I've got a Form I'm building, and would like the drop down boxes to contain
the values for one of the fields of type enum (not from the actual records
in the DB, but the definition of the enum field in MySQL)
For example: A field called userlevel with enum types admin and
visitor.
I
It seems that on occasion I am loosing this abililty until I do a restart.
My users will be plugging along until all of the sudden queries based on
POSTed data fail due to invalid ' stuff. The EXACT same queries then work
after restarting IIS. Has anyone else had a problem with magic quotes?
In setting up a member table in MySQL, I'm not sure if I should include all
fields in the table or only the most common fields, leaving things like
address fields to be placed in another table being that members aren't
required to provide mailing address info and these fields may be mostly
blank
Hi Eric
Do you have any examples of uploading via post
Yes
and downloading via visiting
a download page for this?
No, sorry.
The Upload is not difficult. There is an example in the PHP manual at
php.net. The more interesting question is which datatype you want to
use for the uploaded
first, get a user account on that DB outside your domain.
then when making the connections, just use that on the mysql_connection ()
function...
should be no different that using LOCALHOST... the trick is the user
account with the appropriate (and should be limited) rights...
M. Couto wrote:
This is the statement before:
$sql1=INSERT INTO Campaigns
(Campaign,JobID,Client,SoldBy,SalesAssociate,Sales,PM,TestDate,LiveDate,EndD
ate,IVR,[Int],PRF)
VALUES('.$$Camp_entity.','$JobID','$Client','$SoldBy','$SalesAssociate','$
AE','$PM',$TestDate,$LiveDate,$EndDate,'$IVR','$Int','$PRF');
The
Oh yeah, I should mention that anytime I echo the the SQL statement before
it runs and copy it into QA; it parses and runs without any error.
Andrew Hill [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Salve,
Not sure if the MDAC version is necessarily the culprit - it's
29 matches
Mail list logo