rs.update problem

Results 1 to 2 of 2

Thread: rs.update problem

  1. #1
    Join Date
    Dec 1969

    Default rs.update problem

    I have a web-based admin page that updates an Access97 db. The page has mostly text area fields for changing current content for any product item. My problem is that I am using a pulldown menu to determine the item&#039s position number within the site. I have succesfully got the menu to display the item&#039s current show position along with the list of all other possible positions in the same pulldown. The problem is that when I try to change that item&#039s position number by selecting any number other than it&#039s current position, upon clicking the update button and executing the SQL update procedure, I get an error message that tells me the item&#039s position number cannot be a zero length. Here&#039s the exact error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] Field &#039TblPrducts.ShowSlot&#039 cannot be a zero-length string. <BR>/cgi-bin/admin/MGRUADO.ASP, line 24<BR><BR>line 24 is the RS.UPDATE command.<BR><BR><BR>Any help would be great!<BR><BR>By the way, the list of all possible positions is populated from a seperate table in the db called TblPosition which is simply a listing of all the position numbers from 1000-5000.<BR><BR>Thanks!<BR>ScottB

  2. #2
    Philip Ventrella Guest

    Default RE: rs.update problem

    The problem could be caused by a few things, but what&#039s happening is that the sql statement is trying to put a blank into your database in one of the fields. The best bet is to do a &#039response.write yoursqlstatement&#039 to see what is trying to be written to your database. You&#039ll probably find out that there&#039s a problem with one of your variables, and its not passing a value.<BR><BR>Let me know if this helps (The response.write for sql statement has helped me located a majority of my problems!)

Posting Permissions

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