code problem for inserting to mysql.

[Davidii111]

Why isnt this code working ?? http://www.dscs.se/vb-code.txt
It is adding the values to the database xx2 but not xx1 why?. Can anyone see anything it would be very helpful.

 

[Hack]

Did you put a break on the code and "walk" through it to see what is actually taking place?

 

[Tom]

I see a potential problem but im not sure why your not receiving an error because of it. In your first Insert statement you are stating that there are 8 field values to be inserted but I only see 7 values actually being passed to it; no BillId value.

 

[Davidii111]

Yes it was the missing field in the sql string! now it is working. thank you so much!