Recent content by kazai

hi, I wanted to know how one can trap the duplicate key error for SQL server? I have an insert statement, which throws up an error for duplicate insertions...how do I trap that error and display my own appropriate message....PLS. HELP!!!!! IT's VERY VERY URGENT!!!!!!!! thanks, Radhika.

Any help guyz??? else, I am doomed.....

I have checked the permissions for the user , and the 'everyone' user has been given the write permission... and I do use the obj.Execute(sSQL) statement. ?????!!!!!!! :(( Thanks, -Radhika.

The Insert statement that I printed out was: INSERT INTO ResourceUseBegin073101 ( FirstName, LastName, Address1, Address2, City, State, Zip, PhoneHome, PhoneWork, Title, Organization, ItemsOnLoan01, ItemsOnLoan02, ItemsOnLoan03, ItemsOnLoan04, ItemsOnLoan05, NoOfStudents, NoOfTeachers...

I have an insert statement, which works perfect when I run it on Access. But when I try to run the same thro' ASP, it gives me an error saying: Error: Operation must use an updateable query. Well, all the security settings have been set to read/write access to the everyone user, and the table...

lol!! I'm sure :-)

Sure, Thankyou Todd. (BTW, how many coffee mugs have you collected? :)...it's ok, I don't expect an answer to that:) )

I have an insert statement which is perfect..I run it on Access, and it gives me the correct o/p.(ie, it inserts.) I saw the string on the browser, and copy-pasted it onto Access, and it works. But if I do a conn.Execute(strSQL), it gives me an error saying "Query must be an updatable...

I've fixed that problem, Thankyou Todd :)...there was a pbm. in the logic....I now have a different question: I have an insert statement which is perfect..I run it on Access, and it gives me the correct o/p.(ie, it inserts.) I saw the string on the browser, and copy-pasted it onto Access, and it...

I have a select statement that returns 5 records, when i run it on access, but when i run the same on the browser(in a loop), using recordset object, it gives me 3 rows. I checked the statement, and it is exactly the same as the one i use for the access DB. Any inputs on this, as to why it could...

I don't know if this would help, but you could try putting in brackets after Set and bfore Where clause. Hope this helps :) Radhika.

While accessing MS Access table through ASP, I insert a row through a form page, using ASP. But the primary key is an auto number, called id. How do I incorporate this value in my Insert statement...do I need to incorporate it, or will it suffice if i just insert the values for the other...

The scenario is: Dim Borrow_date Borrow_date = Request.Form("txt_BorrowDate") // Borrow_date actually contains a date(in string form, though i have declared it as dim only) // I now need to add 15 days to this, using the DateAdd function in VBSript. I say...

Sometimes, Request.Form does not work. All the values of the form are passed as part of the query string to the next page, but when i do a request.form on the next page, and display it's value, it returns blank. But instead when i use request.querystring, it works...Can you tell me How?? Thanks...

Can one use Requst.QueryString, if the method of the form is POST?