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 SkipVought 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: *

  1. LakshmiKiran

    Store Procedure Nubie

    SQL Server Stored Procedures Optimization Tips Here are twelve helpful tips for ensuring that you've constructed your SQL Server stored procedures to perform in the most efficient manner possible. 1. Use stored procedures instead of heavy-duty queries. This can reduce network traffic, as...
  2. LakshmiKiran

    update record using loop not working

    Hi, Since dynamically column names should get updated try using a dynamic query..something as below whcih works fine.. Create table #TEMP_AGE ( REC_TYPE varchar(50), trans_age int, col1 varchar(50), col2 varchar(50), col3 varchar(50), col4 varchar(50), col5 varchar(50), col6...
  3. LakshmiKiran

    Convert varchar to float in a single query statement

    Hello, Having should be used after the Group By clause. Something like this.. SELECT m.PONo, m.SubconCode FROM POMaster m, PODetails d, GoodsReceipt g WHERE m.PONo=d.PONo and d.PONo=g.PONo and d.ItemNo=g.ItemNo GROUP BY m.PONo,m.SubconCode,d.QtyOrder HAVING SUM(g.QtyRecv) >...
  4. LakshmiKiran

    Generation of HTML files

    Hi, I need to generate HTML files and mail to various users as attachments. This HTML file would typically consists of the task details for each employee and project. Each HTML file might be upto 1-2 MB depending on the data. And there maybe thousands of mails to be generated. Could anyone...
  5. LakshmiKiran

    disable forward button once come to home page

    check this link.. http://www.htmlgoodies.com/tutors/nobackbutton.html
  6. LakshmiKiran

    a proc to update a selected single field

    Hi, Or Probably you can use casting also instead of setting the Quoted_Identifier Off. Like set @sqltext = 'update tbl_claimdata set ' + cast(@colname as varchar) + ' = ' + cast(@colvalue as varchar) + ' where referencenumber = 2'
  7. LakshmiKiran

    Are parameters optional in JS ?

    Yes. They are set to null. You can chekc that by checking if the variable = null (a==null)..
  8. LakshmiKiran

    new window disable fullscreen mode

    Hi, You can disable the F11 code this way.. <SCRIPT LANGUAGE=javascript> <!-- document.onkeydown = function () { if (122 == event.keyCode) { event.keyCode = 0; return false; } } Regards, Kiran
  9. LakshmiKiran

    form button fun

    Hi, Give the javascript function you wish to call in the form action and ur problem is solved. Like this.. <form name=&quot;test1&quot; method=&quot;POST&quot; action=&quot;javascript:FocusMe()&quot; >
  10. LakshmiKiran

    Can't Query a dinosaur Database with ASP

    Hi, If you do the casting it seems to work fine. Check this... select * from test where cast(budget as money) > 10
  11. LakshmiKiran

    Javascript Form Validation

    Hi, For validating numbers you can use this javascript function.. <script LANGUAGE=&quot;javascript&quot;> function OnlyNumeric(intAllowDecimal) { var KeyAscii = window.event.keyCode; if (intAllowDecimal==1 && KeyAscii == 46) { return; } else { if ( KeyAscii < 48 || KeyAscii > 57 )...
  12. LakshmiKiran

    .focus()

    Focus works fine even if it's a drop down. For eg.. <HTML> <HEAD> <META NAME=&quot;GENERATOR&quot; Content=&quot;Microsoft Visual Studio 6.0&quot;> <TITLE></TITLE> <SCRIPT LANGUAGE=javascript> <!-- function FocusMe() { document.test1.select1.focus(); } --> </SCRIPT> </HEAD> <BODY> <form...
  13. LakshmiKiran

    Parameter Passing in ASP

    Hi, The post method does not work with enctype=&quot;multipart/form-data&quot; . Use a get method if the data is not too large. Or Refer this link for more details http://forums.devshed.com/t94309/s.html
  14. LakshmiKiran

    Hi, How can i modify the datatyp

    Hi, This is how you do.. alter table tablename alter column student_id varchar(8) But you cannot set it to lesser length than already present.
  15. LakshmiKiran

    Check Empty textarea

    I checked this. This does not work for textareas. Press Enter without typing any text and the system accepts.
  16. LakshmiKiran

    Check Empty textarea

    How do I check whether a textarea is empty? If the user does not enter any data but presses the enter key, then the form.textarea.value is not empty. How to keep a check on this?
  17. LakshmiKiran

    Nested Transaction in SQL Server 2000

    Hope this article helps.. SQL 2K allows nested transactions. For e.g. BEGIN TRAN 1 do something BEGIN TRAN 2 do something COMMIT TRAN 2 do something COMMIT TRAN 1 It says that all transactions become permanenet only when the outermost transaction is committed. In the above example till...
  18. LakshmiKiran

    JS z-index change - obect expected

    Hi, You have not closed the function bracket...Check that..
  19. LakshmiKiran

    Tree View Control in ASP

    Can anyone help me out in using the existing treeview(activex control) control in asp? How do I add nodes? Thanks & Regards, LakshmiKiran
  20. LakshmiKiran

    help me with search function in javascript

    Use indexOf instead of search. var str=&quot;abcdef(gh&quot;; alert(str.indexOf(&quot;(&quot;)); This works fine..

Part and Inventory Search

Back
Top