Search results for query: *

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.

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...

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 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...

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...

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

Can Anyone help me find a syntax error in this statement? strSQL = "Insert into SIGNIN (FIRSTNAME, LASTNAME, USERNAME, USERPASSWORD, EMAILID) values ( "& txt_fName &","& txt_lName &","& txt_UserName &","& txt_Password &","& txt_Email &")"

hello, I'd like to know how to use a VBScript variable's value as part of the Message body in the email. For eg. <% Dim Var Dim Mail Var = Request.Form(&quot;txt_Var&quot;) -- create all the mail objects. set Mail = server.CreateObject(&quot;CDONTS.NewMail&quot;) Mail.body = Var --...

Hi, I'm getting the following error: Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: 'ADODB' /Malavika/PFEfiles/SIGN_IN_ASP_files/Insert.asp, line 24 This happens when I try to execute a pure back-end ASP file. The line in my code that this error points to is: set cnn =...