|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 2nd, 2004, 05:52 AM
|
|||
|
|||
|
SQL syntax error
I have created a form with several textareas. I am then saving the contents of the textareas in an Access database. I have discovered a problem - and I need some help please...
If I enter the character ', withing the text area, and submit I am getting a syntax error in my sql statement.... How do I allow for such characters in a text area without causing a syntax error... Thanks
|
|
#2
February 2nd, 2004, 09:43 AM
|
|||
|
|||
|
If that field is your primary field or any field you might search against then I don't believe that you can use a ' in the field. In both SQL Server and Access a ' is used as part of the SQL statement and is reserved for that purpose. The only place I have been abale to use it is in field that are not part of the cirteria or join statements (ever). For example desciption, comments, etc
S-
|
|
#3
February 2nd, 2004, 09:44 AM
|
|||
|
|||
|
If that field is your primary field or any field you might search against then I don't believe that you can use a ' in the field. In both SQL Server and Access a ' is used as part of the SQL statement and is reserved for that purpose. The only place I have been abale to use it is in field that are not part of the cirteria or join statements (ever). For example desciption, comments, etc
S-
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > SQL syntax error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
