Insert statement problem

[puT3]

i want to insert new record from asp file into database, i insert the data for example,product name(Cream Puff), price(1.00), quantity(100pcs) but then when i open my database it display "undefined' for all the field.

[puT3]

From the earlier question, i have another error which is it mentioned that there are multiple same data in the table because it a primary key...Sorry i do not remember exactly the error but it soething like that when im inserting new record...I usign asp(javascript) and access

[puT3]

The error for question 2,The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

the sql i use

sql2="INSERT INTO Login (Username,UserPassword) VALUES ('"+user_Name+"','"+pass_Word+"')";
Conn.Execute(sql2);
 
sql="INSERT INTO Customer(Customer_ICNumber,Cust_Name,Cust_Address,Cust_PrimaryNumber,Cust_SecondaryNumber,Cust_Company,Cust_CompanyType,Username)VALUES ('"+cust_ICNumber+"','"+cust_Name+"','"+cust_Address+"','"+cust_Primary+"','"+cust_secondary+"','"+cust_Company+"','"+cust_CompanyType+"','"+user_Name+"')";
Conn.Execute(sql);
 

[jhardman]

Try your query outside of ASP first. Try it in a query analyzer and see what it results.

Jared

[puT3]

Sorry but how to analyze inser statement in access...

[jhardman]

I don't use access anymore, but I have Access 2007 on my work computer. I got to a query analyzer by opening access and selecting a table, then I clicked "query tools" and it tried to get me to enter data via a graphical user interface, but I won by clicking "view" -> "SQL view". This provided a large textbox where I could enter the text of the query and a button marked "run". Hope this helps.

Jared

[puT3]

alright...i will try it...i'll let you know...

[gcube]

That error message is telling you that at least one of the fields you are trying to enter data for is required to have a unique value and that the value submitted is already in another record.

Open Access and open the table in design view. If there is a field that has an icon that looks like a yellow key at the left of the line, then that field must be unique. Also, select each field (one at a time) and look at the field properties at the bottom of the field list - if any field has "yes" for "indexed" then that field must also be unique.

There is one other thing you should check. If there are any fields in the table that you are not trying to record values for, be sure that the field properties for all of them either have "no" for "required" and have "yes" for "allow zero length" or have a default value assigned.

This should identify the field or fields causing the error.