Personal_Worker

i have a problem in my asp program..i doing the duplicate id checking (id is my primary key) in my program, but after i entered the id and the data, the program always said that the ID is exist although in real, it is not exist....I find the way to solve the problem for whole day, but until now, i can not know what is wrong in may checking..this is my code for checking 'check for error<% if err.number <> 0 if err.number = -2147467259 then %> <script> window.alert("customer ID already exist!!\nPlease enter another ID\nThanks")</SCRIPT><% else response.write "Unknown error ["& err.number & "]" & err.Description end if response.end end if %> i hope for the answer, thanks before :)But For Your Information..my program can work in the another computer which is using older microsoft access (as i thought), is that any relation between my problem and the access version??This is my code on how i insert the new record... set conn=CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open server.mappath("mr.mdb")conn.execute "INSERT INTO [customer] ([Customer_ID],[Customer_Name],[Customer_Address],[Email_Address],[Contact_Number],[Fax_Number],[Contact_Person])VALUES("&id&",'"&name&"','"&address&"','"&email&"','"&cont_num&"','"&fax&"','"&cont_person&"')" conn.close Thanks....

it's work!! it's work!!Thanks

sorry friend, cannot work...:)any other option??thanks

friends..is it possible i do the printing job in PHP?the user only need to press one button, and then it will print out whatever display in the monitor...thanks for the answer....

thanks friendbut one thing i need to ask you..is that we can implement the php code into the javascript block?for example..<script LANGUAGE = "javascript"><?PHP //.....PHP code here..(open database or something like that)?></SCRIPT>I tried it already...but it didnt work...thanks before..

friends...is it possible to create pop up windows to prompt the user by using PHP?if impossible, is that another way to make it possible to create pop up windows in the PHP application? Thanks before...

oo..is like that...thanks for the explanation....

friends..i got a problem..how can i implement the php function on the ONCLICK for the button....lets say i got this function<?function message(){ echo "This is message";}?>then on the button declaration...<INPUT TYPE = button NAME = "btn" VALUE = "Click Me" ONCLICK = ?????> how to fill the question mark if i want to invoke the message function when the user click on that button....i already try this...ONCLICK = "<? message() ?>" but it didnt work...thanks for the answer....

just to the point, friends... let say that i have a form attribute textbox, and a submit button....and then i enter something into the textbox, for example, i typed in "W3Schools Forum"...then after i press the submit button, the browser should display...."W3Schools Forum is an educational forum"na, the problem is here...when i refresh the page, the "W3Shools Forum is an educational forum" still exist in the page....my question is .... how can i remove the "W3Shools Forum is an educational forum" statement in the browser after i refreseh the page.....?thanks before....

ohh is it??thanks for the explanation.....:)it's ok...since i'm still very new here....

My old account is gone? this is the new one, my old account user name also Personal_Worker, and i use the same email address to register....it is proved that my old account is really gone, is it??i am wondering why it was disappear?