|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Regarding Memo datatype in Access
hi all..
this is really urgent and i cant seem to figure this out. I have his text area, once the user hits the save button, it tranfers the data to a memo datatype field in the database. ok here's the thing...every time I copy paste something, this thing throws up a wierd error..: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '('text here.... I initially though it would ahve been becuase of the number of characters, but that was not the case. When i type things in and save , e'thing works fine.I'm totally confused..anybody got an idea? thanks in advance... sid |
|
#2
|
|||
|
|||
|
ok here's a thing i discovered.It gives me an error with any text with an apostrophe mark ' .
how do i go about fixing it? thanks a lot ![]() |
|
#3
|
|||
|
|||
|
You need to use the Replace() function
Here read this... http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=137 Hope this helps! Sincerely Vlince |
|
#4
|
|||
|
|||
|
it worked..
thanks a lot..it worked!!!
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Regarding Memo datatype in Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|