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 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 a

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 fail

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 th

RE: Strange Text Field

2004-08-18 Thread Stuart Felenstein
ct. Stuart > > -Original Message- > 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 produ

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 (JobReferenceCode,VendorID,LocationCi

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 par

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 tab

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 a

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 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 1