RE: Strange Text Field

2004-08-19 Thread Terry Riley
Stuart Could this be something as simple as the fact that you have a field with a space in its name ('Contact Email'), which is sometimes called as 'Contact Email' and sometimes as 'Contact_Email'? I'm not even sure if a blank space is actually allowed in field names Cheers Terry Riley

Re: Strange Text Field

2004-08-18 Thread Rhino
- Original Message - From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 3:49 PM Subject: Strange Text Field Hoping I can figure this out. Using MySQl 4.0.20-Standard. I have a table (tried this both myISAM and Innodb) with 12 fields,

RE: Strange Text Field

2004-08-18 Thread Victor Pendleton
What is the application you are using to insert and retrieve the blob data? Is the data actually being inserted? -Original Message- From: Stuart Felenstein To: [EMAIL PROTECTED] Sent: 8/18/04 2:49 PM Subject: Strange Text Field Hoping I can figure this out. Using MySQl 4.0.20-Standard.

Re: Strange Text Field

2004-08-18 Thread Stuart Felenstein
I understand about supplying the code and will. I'm actually rebuilding it again. Language is Php and Adodb and not to get to estoteric, I'm using a RAD called Impakt which fits into Dreamweaver. Anyway, while I can supply the code, the weirdness is that it won't work in one table but will in

RE: Strange Text Field

2004-08-18 Thread Stuart Felenstein
In the table that fails, and the one that works, I'm using some products from a company called Interakt. I mentioned this in my last reply, however didn't mention one part. With this suite of tools , I can replace a text area with a mini html / cms tool. Basic formatting etc. Now in the 2nd

RE: Strange Text Field

2004-08-18 Thread Victor Pendleton
Felenstein To: Victor Pendleton; '[EMAIL PROTECTED] ' Sent: 8/18/04 3:14 PM Subject: RE: Strange Text Field In the table that fails, and the one that works, I'm using some products from a company called Interakt. I mentioned this in my last reply, however didn't mention one part. With this suite

RE: Strange Text Field

2004-08-18 Thread Stuart Felenstein
Okay, still not working in this one table so here is all my info: I've also attached the table dump. Thank you , Stuart Error Code from attempted transaction: - Transaction failed! Your SQL: insert into LFWBank

RE: Strange Text Field

2004-08-18 Thread Stuart Felenstein
- From: Stuart Felenstein To: Victor Pendleton; '[EMAIL PROTECTED] ' Sent: 8/18/04 3:14 PM Subject: RE: Strange Text Field In the table that fails, and the one that works, I'm using some products from a company called Interakt. I mentioned this in my last reply, however didn't mention

Re: Strange Text Field

2004-08-18 Thread Stuart Felenstein
--- Rhino [EMAIL PROTECTED] wrote: Sorry I didn't answer this one before. No it does not. I typed 6 letters and it kicked it back. And that was using just a regular text area Stuart Does your program store the data correctly if you just put regular text in the form field, rather than

Re: Strange Text Field

2004-08-18 Thread Dan Nelson
In the last episode (Aug 18), Stuart Felenstein said: Okay, still not working in this one table so here is all my info: I've also attached the table dump. Thank you , Stuart Error Code from attempted transaction: - Transaction failed!

Re: Strange Text Field

2004-08-18 Thread Stuart Felenstein
Dan, Don't hate me for saying this but you are the MAN! Yep, it was Contact Email. Oops ! It works great now Thank you all! Stuart --- Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Aug 18), Stuart Felenstein said: Okay, still not working in this one table so here is all my