Re: [PHP] Issues with long SQL inserts

2002-04-01 Thread Chris Snyder
Jason Wong wrote: > On Monday 01 April 2002 07:22, Chris Snyder wrote: > > > >>I altered the add.php script to print the query to screen instead of >>sending it to MySQL to try this. It still acted the same, regardless of >>whether it was sending it to the MySQL server or printing it. In fact

Re: [PHP] Issues with long SQL inserts

2002-04-01 Thread Chris Snyder
Jason Wong wrote: > On Monday 01 April 2002 07:22, Chris Snyder wrote: > > > >>I altered the add.php script to print the query to screen instead of >>sending it to MySQL to try this. It still acted the same, regardless of >>whether it was sending it to the MySQL server or printing it. In fact

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Jason Wong
On Monday 01 April 2002 07:22, Chris Snyder wrote: > I altered the add.php script to print the query to screen instead of > sending it to MySQL to try this. It still acted the same, regardless of > whether it was sending it to the MySQL server or printing it. In fact, > it even had the same re

RE: [PHP] Issues with long SQL inserts

2002-03-31 Thread Cal Evans
AIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Issues with long SQL inserts Cal Evans wrote: >Sorry, I've reached the end of my tech-support flow-chart. You might want >to try 2 things: > >1: Fire up the MySQL client of choice and do the insert manually. If it >works the

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
Cal Evans wrote: >Sorry, I've reached the end of my tech-support flow-chart. You might want >to try 2 things: > >1: Fire up the MySQL client of choice and do the insert manually. If it >works there. If it does then at least you've isolated the problem to PHP or >your script. If not then you'v

RE: [PHP] Issues with long SQL inserts

2002-03-31 Thread Cal Evans
[EMAIL PROTECTED] Subject: Re: [PHP] Issues with long SQL inserts Cal Evans wrote: >I'm not up on the exact spec on MySQL but if it has an 'unlimited' text type >then it is a rarity among SQL engines. M$SQL's limit is (used to be?) 8MB >in a single text field. > &g

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
Cal Evans wrote: >I'm not up on the exact spec on MySQL but if it has an 'unlimited' text type >then it is a rarity among SQL engines. M$SQL's limit is (used to be?) 8MB >in a single text field. > >FoxPro/dBase had an unlimited text field but that's not so must a SQL engine >as a file format. >

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
gt;To: [EMAIL PROTECTED] >Subject: [PHP] Issues with long SQL inserts > > >Server is running PHP 4.1.2, APC 1.1.0pl1, MySQL 3.23.47, Apache 1.3.23 >on a built-from-scratch Linux system with kernel 2.4.17, glibc 2.2.5, >and gcc 3.0.4. > >I'm using a fairly simple script to

RE: [PHP] Issues with long SQL inserts

2002-03-31 Thread Cal Evans
ginal Message- From: Chris Snyder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 4:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Issues with long SQL inserts Cal Evans wrote: >Have you tried shaving the article off a couple of chrs before the last one >

Re: [PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
ith 40 meg free, and around 450 meg of swap - shouldn't be a problem. >-Original Message- >From: Chris Snyder [mailto:[EMAIL PROTECTED]] >Sent: Sunday, March 31, 2002 3:43 PM >To: [EMAIL PROTECTED] >Subject: [PHP] Issues with long SQL inserts > > >Server is r

RE: [PHP] Issues with long SQL inserts

2002-03-31 Thread Cal Evans
Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Snyder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 3:43 PM To: [EMAIL PROTECTED] Subject: [PHP] Issues with long SQL inserts Server is running PHP 4.1.2, APC 1.1.0pl1, MySQL 3.23.47, Apache 1.3.23 on

[PHP] Issues with long SQL inserts

2002-03-31 Thread Chris Snyder
Server is running PHP 4.1.2, APC 1.1.0pl1, MySQL 3.23.47, Apache 1.3.23 on a built-from-scratch Linux system with kernel 2.4.17, glibc 2.2.5, and gcc 3.0.4. I'm using a fairly simple script to take input from a form, and add it to a database. The database has the following structure: ID - med