Hi guys, i've come to a small problem and was hoping someone could help.

in access i have a feld called STORY which is a MEMO field.

all the updates work fine and i can update/modify this field no problem,
untill i start using working with ",! etc in.

these symbols are obviously messing with my code as the update page submits,
i can't have news storys with no " or , in them, so if anyone knows of a way
round this problem please let me know

thanks

Jamie

Jamie Fryatt wrote:[color=blue]
> Hi guys, i've come to a small problem and was hoping someone could
> help.
>
> in access i have a feld called STORY which is a MEMO field.
>
> all the updates work fine and i can update/modify this field no
> problem, untill i start using working with ",! etc in.
>
> these symbols are obviously messing with my code as the update page
> submits, i can't have news storys with no " or , in them, so if
> anyone knows of a way round this problem please let me know
>
> thanks
>
> Jamie[/color]

Three words: "saved parameter query"

http://www.google.com/groups?hl=en&l...TNGP12.phx.gbl

http://www.google.com/groups?hl=en&l...r%3D%26hl%3Den

http://tinyurl.com/jyy0

http://www.google.com/groups?hl=en&l...%3D10%26sa%3DN

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

For easier syntax than using a SQL INSERT statement you could use ADO's
AddNew such as in the following:
Database Add
http://www.asp101.com/samples/db_add.asp

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!