SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member delhipro's Avatar
    Join Date
    Jul 2004
    Location
    India
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    inserting data through ASP Page

    I am trying to insert the data through SQL Query (more than 255 Characters) in a MEMO field of an MS Access Database. But I am getting following error

    Microsoft JET Database Engine error '80040e14'

    Syntax error (missing operator) in query expression ''I

    If I reduce the data below 255 Characters the query works perfectly.

    Can anybody help me on this.

  2. #2
    Original Gangster silver trophy Thing's Avatar
    Join Date
    Oct 2000
    Location
    Philadelphia, PA
    Posts
    4,708
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Let's see your query.

  3. #3
    SitePoint Member delhipro's Avatar
    Join Date
    Jul 2004
    Location
    India
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    description=Request.Form("description")

    strsql = "insert into query(cid, description, company, name, email, phone, address, turnover, employees, sites, products, tdate, country)" & _

    "values('" & cid & "','" & description & "','" & company & "','" & name & "','" & email & "','" & phone & "','" & address & "','" & turnover & "','" & employees & "','" & sites & "','" & products & "','" & tdate & "','" & country & "')"

    I am getting error on description field.

  4. #4
    SitePoint Addict sinapra's Avatar
    Join Date
    Sep 2004
    Location
    secunderabad
    Posts
    272
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there any special characters getting inserted into description, say " or '. You need to supress them. You can limit the size to 255 or use text datatype.
    Regards

    Its Great to work and Be Merry!!!!!!!!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •