Hi all!
I've a little big problem with the way in which ms access handles apostrophes. I try to explain : I've a web form that's filled with some user's data (i.e. : company name, address, and so on).
I handle this form, obviously, with a php script which provides to insert these data in a ms access 2000 table (via an ODBC connection).
Now, the problem is the following : let's suppose for a moment that the variable associated with an editbox of the web form is $my_var , and that a generic user filling this editbox inserts the value " aa ' bb ". The apostrophe will be expanded (by php or access, I don't know) in the excape sequence \', obtaining "aa\'bb".
I try to use this value to fill the database table, and so I have this query :
insert into table_name(<fields>) values ('$my_var', ...othervars...);
And I obtain an error . I've also tried to substitute the '$myvar ' in the SQL INSERT with the "$myvar" , but the error remains.
May anybody help me?
Thanks to all!!!
