We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Re: violation error

    Jul 03, 2008 09:42 AM|Mike Peters|LINK

     No.  But i've narrowed the problem dowm a bit.  When I run the query with fixed values. it is ok.  But as soon as I put in a text field and try to pass the data as a variable the violation error occurs.

     Here's a cut down version of the query that doesn't work:

    $query = "INSERT INTO del_info(del_lname, del_fname,) VALUES ('$del_lname', 'smith')";
     

    $del_lname refers to the text field del_lname

    As you've probably guessed I've only recently stated working with php.

     

    thx

    Mike