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 p
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')";
T
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:
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 fi
Is there a recommended MDAC version for PHP when accessing SQL Server 2000?
Right now the following statement successfully inserts data but always
results with the die message:
$result = mssql_query($sql1) or die('inserting campaign failed');
--
PHP Database Mailing List (http://www.php.net/)
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 f
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?
Salv
At 14:40 -0700 7/25/02, Mark Middleton wrote:
>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
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
"visit
> How would I produce a triple DES or 3DES password?
> I was using:
> $passwd = crypt($passw);
> but it is only DES.
$passwd = crypt( crypt( crypt( $passw )));
?
hehehe
Sorry, just had to throw that out there. :p
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
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
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 - 866
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:
http://www.io
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 functiona
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 sup
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-
Fr
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 of
Pierre,
Why not use ODBC functions everywhere?
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server
-Original Message-
From: Pierre-Alain Joye [mailto:[EMAIL PROTECTED]]
Sent: Monday,
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, 2
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 func
Martin,
I did not see your last email, but if you are having problems with
unixodbc you may wish to try iODBC - http://www.iodbc.org
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server
-Or
Whenenver I get a DB error with MSSQL just about every other mssql_query
statement begins producing warnings until I restart IIS. Once I restart IIS
everything runs fine again. Has anyone else had this problem?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
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
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 Februa
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 anyo
$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
>
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 apr
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 domai
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 this?
Try inserting like this:
INSERT IGNORE INTO tbl_name
"Scott Immerman" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
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
___ www.S
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 PROTEC
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
34 matches
Mail list logo