problems with sql statement

Results 1 to 3 of 3

Thread: problems with sql statement

  1. #1
    yls Guest

    Default problems with sql statement

    insert into maid (MaidPictureLocation) values (&#039uploadeduploadeduploadedMaid1.jpg&#039 ) where maidreferenceno = &#0390999&#039 <BR>Microsoft JET Database Engine error &#039 80040e14&#039 <BR><BR>Missing semicolon (;) at end of SQL statement. <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: problems with sql statement

    Your SQL syntax is wrong. You don&#039t use a WHERE clause witn an INSERT. Did you mean to do an UPDATE instead of an INSERT???<BR><BR>Mayhap you need some tutorial help with SQL? If so, try this page:<BR><BR><BR><BR>It&#039s the best one-html-page helpl for SQL you will find.<BR><BR>

  3. #3
    yls Guest

    Default RE: problems with sql statement

    WOW... a teacher is a teacher... even knows what a student wants to do... yup, i wanted to do a update but hmmm.. go and do an insert... thanks for the sql tutorial.. will go and take look<BR><BR>your ever-learning student

Posting Permissions

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