Skip to main content
Known Participant
January 28, 2007
Question

VENDORERRORCODE 3092

  • January 28, 2007
  • 2 replies
  • 727 views
I dont know why I m getting this error. The query works fine on my localhost and when i paste the query in access database. It is a simple insert statement which goes like this:
insert into tblCards(typeID,CardName,Price,Image,listorder,descrip,size) values(#form.typeID#,'#form.cardName#','#form.Price#','#serverfile#',#form.listorder#,'#form.descrip#','#form.size#')

The query output looks like this:
insert into tblCards(typeID,CardName,Price,Image,listorder,descrip,size) values(6,'Maggie Fire','200','maggie_fire.jpg',8,'Add new card by picking appropriate Category and Type for card.','6 X 7')

As I said works great on my localhost but gives me error Syntax error in INSERT INTO statement. VENDORERRORCODE 3092 once uploaded. Doesnt seems like I m using a reserved word.

Thank you
    This topic has been closed for replies.

    2 replies

    Participating Frequently
    January 28, 2007
    I'd take another look at the datatypes in your table... all of the articles I've found on the 'net with that error seem to deal with mismatched datatypes.

    http://www.easycfm.com/forums/viewmessages.cfm?Forum=30&Topic=4603

    Hope that helps..
    Participant
    February 5, 2007
    I am getting this same problem and i don't understand the information from the link you gave, can you please help me. I have the issue with the update insert and its works fine on my localhost and then online it doesn't giving me that same error can i please get some help
    Participating Frequently
    January 28, 2007
    What happens when you try to run the query directly in Access?
    DDhillonAuthor
    Known Participant
    January 28, 2007
    quote:

    Originally posted by: joeDangelo
    What happens when you try to run the query directly in Access?


    It works fine.