Posted by oi on 09/29/05 16:51

Hi Shawn

Yes the data was going in properly

It was the quotes issue as you mentioned...

Thanks for your help

Mark


"Shawn Wilson" <shawnw_nospam_@_nospam_dvigroup.net> wrote in message
news:y0S_e.8432$Wl6.2338@fe05.news.easynews.com...
> "oi" <o@fhfdjh.df> wrote in message
> news:1127993456.ed032b186235bd5d92aceed97880bf70@teranews...
>> Hi yall
>>
>> I have the following problem
>>
>> A user inputs something like
>>
>> Mark's Birthday
>>
>> into the database through a form. This works OK
>>
>> However, when the data is re-presented in a form, everything after the
>> apostrophe is cut off...
>>
>> How can I get all of the data back into the form?
>>
>> TIA
>>
>
> Need to know a couple things...
>
> 1. Confirm that the entire piece of data is making it to the DB. Is the
> database really holding [Mark's Birthday]? Does 'this works OK' really
> mean it worked or that you just didn't get any errors?
>
> 2. Assuming the whole thing made it to the DB, then view the source of
> your HTML when the form is rendered with missing characters. Do you see
> this: <input type='text' name='name' value='Mark's Birthday'> ?
>
> If that's all it is, then your issue is the single quotes. Change your
> [value=] property to use double quotes. If you're drawing this via PHP
> code then you can do this: value=\"$var\" so the quotes don't trip you
> up. You'll end up with value="Mark's Birthday" which will work fine.
>
> I see that happen most often, so we'll start there.
>
>
> --
> Shawn Wilson
>

[Back to original message]