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
Cal Evans wrote: >Have you tried shaving the article off a couple of chrs before the last one >and seeing if the insert works? Also, what is the size limit on a MySQL TEXT >field? > >http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLO >B > >May give a hint. > I tried shav

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
Cal Evans wrote: >Have you tried shaving the article off a couple of chrs before the last one >and seeing if the insert works? Also, what is the size limit on a MySQL TEXT >field? > >http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLO >B > Thanks for the quick response.

RE: [PHP] Issues with long SQL inserts

2002-03-31 Thread Cal Evans
Have you tried shaving the article off a couple of chrs before the last one and seeing if the insert works? Also, what is the size limit on a MySQL TEXT field? http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLO B May give a hint. =C= * * Cal Evans * Journeyman Programm