Error when passing text with apostorphies

[Bill]

I have a string (holding a book title) that contains an apostrophe.
This is generating an error when I try to pass it through sql into a
table of orders.
I retrieve it from the form with

title=request.form("title")
I'm trying to pass it through with: '"&rs("title")&"'

This isn't working. I tried taking out the ' ' but that didn't help,
nor did elmiminating the " " help eather. Can someone suggest what
might be the problem?

Thanks,

Bill

[Ray at]

This is the FAQ of FAQs.
http://www.aspfaq.com/2035

Ray at work

"Bill" <bi***********@gospellight.com> wrote in message
news:8d**************************@posting.google.c om...

I have a string (holding a book title) that contains an apostrophe.
This is generating an error when I try to pass it through sql into a
table of orders.
I retrieve it from the form with

title=request.form("title")
I'm trying to pass it through with: '"&rs("title")&"'

This isn't working. I tried taking out the ' ' but that didn't help,
nor did elmiminating the " " help eather. Can someone suggest what
might be the problem?

Thanks,

Bill

[Foo Man Chew]

Why don't you use a join, instead of nesting recordsets that way?

"Bill" <bi***********@gospellight.com> wrote in message
news:8d**************************@posting.google.c om...

I have a string (holding a book title) that contains an apostrophe.
This is generating an error when I try to pass it through sql into a
table of orders.
I retrieve it from the form with

title=request.form("title")
I'm trying to pass it through with: '"&rs("title")&"'

This isn't working. I tried taking out the ' ' but that didn't help,
nor did elmiminating the " " help eather. Can someone suggest what
might be the problem?

Thanks,

Bill