Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kazai
  • Order by date
  1. kazai

    How does one trap the duplicate key error for SQL server?

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

    Cannot Insert into the accesss DB!!!! PLS. HELP!!!!

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

    Cannot Insert into the accesss DB!!!! PLS. HELP!!!!

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

    Cannot Insert into the accesss DB!!!! PLS. HELP!!!!

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

    Cannot Insert into the accesss DB!!!! PLS. HELP!!!!

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

    Record set returning less number of values?--URGENT HELP!!!

    lol!! I'm sure :-)
  7. kazai

    Record set returning less number of values?--URGENT HELP!!!

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

    Insert statement in ASP

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

    Record set returning less number of values?--URGENT HELP!!!

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

    Record set returning less number of values?--URGENT HELP!!!

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

    SQL Return error on ASP

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

    Auto Generated Primary Key in MSAccess

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

    AddDate function in VbScript

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

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

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

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

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

    Help in Syntax Error in Insert Statement :-(

    Hello Todd, Well , actually the problem was that Request.Form was not working, so i used Request.Querystring instead, and Now its working just fine!!! Is'nt that Strange?? Anyway, Thankyou so much for all your help!! Radhika.
  17. kazai

    Help in Syntax Error in Insert Statement :-(

    Hi Todd, This works just fine...But the same thing with variables does'nt work. And it's not like the variables have blank values,I checked that out too...they all have valid values. Thanks, Radhika.
  18. kazai

    Help in Syntax Error in Insert Statement :-(

    Hello Todd, Well, Itried cnn.Execute as well, but to no avail. Could tere be something wrong with the database itself??
  19. kazai

    Help in Syntax Error in Insert Statement :-(

    Here you Go Todd, I appreciate the help..thank you very much. Line 1 starts from <HTML>. <HTML> <BODY> <FORM> <%@ Language=VBScript %> <% Dim Str1 Dim Str2 Dim txt_UserName Dim txt_Password Dim txt_fName Dim txt_lName Dim txt_Email Dim hdn_InsCheck...
  20. kazai

    Help in Syntax Error in Insert Statement :-(

    I'm geeting it on the line that assigns the string.

Part and Inventory Search

Back
Top