Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > memo -field-urgent

Reply
Thread Tools

memo -field-urgent

 
 
monika
Guest
Posts: n/a
 
      09-17-2003
hi ..
i am using memo field in a field which has to take long data. when i do the
insert its now givng me error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression ''HE NEVER thought he would make it to 80. And there he was
last night, surrounded by 1,000 relatives, friends and colleagues on his
80th birthday, and still relatively healthy and active. As Senior Minister
Lee Kuan Yew said: It is not given to many to be'.
/myweb2/submit.asp, line 47

here is my query:
QUERY1 = "INSERT INTO student_content
(student_id,story_id,status_student,story_original ,story_status_date,story_w
ord_count) VALUES
("&session("loggedID")&","&session("selectStoryID" )&",'"&Request.form("Submi
t")&"','"&strStoryContent&"','"¤tDate&"',"&request .form("wordsCount")&")"

can anyone suggest me whats wrong??
tahnks


 
Reply With Quote
 
 
 
 
Ray at home
Guest
Posts: n/a
 
      09-17-2003
Are you handling apostrophes? It doesn't appear that you are, since you're
dumping right from your form collection into your SQL query. See here.
http://www.aspfaq.com/2035

Also, you should put spaces between your &'s when concatenating.

Ray at home


"monika" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi ..
> i am using memo field in a field which has to take long data. when i do

the
> insert its now givng me error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)

in
> query expression ''HE NEVER thought he would make it to 80. And there he

was
> last night, surrounded by 1,000 relatives, friends and colleagues on his
> 80th birthday, and still relatively healthy and active. As Senior Minister
> Lee Kuan Yew said: It is not given to many to be'.
> /myweb2/submit.asp, line 47
>
> here is my query:
> QUERY1 = "INSERT INTO student_content
>

(student_id,story_id,status_student,story_original ,story_status_date,story_w
> ord_count) VALUES
>

("&session("loggedID")&","&session("selectStoryID" )&",'"&Request.form("Submi
> t")&"','"&strStoryContent&"','"¤tDate&"',"&request .form("wordsCount")&")"
>
> can anyone suggest me whats wrong??
> tahnks
>
>



 
Reply With Quote
 
 
 
 
monika dang
Guest
Posts: n/a
 
      09-17-2003
yes ..u r rite ..i was using apostrophe and used replace and it worked
good then thanks



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
Aaron Bertrand [MVP]
Guest
Posts: n/a
 
      09-17-2003
Response.Write(QUERY1)
Response.End





"monika" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi ..
> i am using memo field in a field which has to take long data. when i do

the
> insert its now givng me error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)

in
> query expression ''HE NEVER thought he would make it to 80. And there he

was
> last night, surrounded by 1,000 relatives, friends and colleagues on his
> 80th birthday, and still relatively healthy and active. As Senior Minister
> Lee Kuan Yew said: It is not given to many to be'.
> /myweb2/submit.asp, line 47
>
> here is my query:
> QUERY1 = "INSERT INTO student_content
>

(student_id,story_id,status_student,story_original ,story_status_date,story_w
> ord_count) VALUES
>

("&session("loggedID")&","&session("selectStoryID" )&",'"&Request.form("Submi
> t")&"','"&strStoryContent&"','"¤tDate&"',"&request .form("wordsCount")&")"
>
> can anyone suggest me whats wrong??
> tahnks
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Access Memo field from ASP.NET =?Utf-8?B?TWF0dA==?= ASP .Net 6 04-11-2005 01:22 PM
Re: OFF-T Did I miss the memo. HeartBreak Kid Hornetİ Version 1 Computer Support 0 01-24-2005 09:06 PM
Display Memo Text Gmansky ASP .Net 2 06-28-2004 03:12 AM
Free Online VHDL MEMO Amontec, Laurent Gauch VHDL 0 05-24-2004 10:38 AM
SUN Java memo Developwebsites Java 3 11-13-2003 09:51 AM



Advertisments