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

  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

    ...begin tran @transname Set @strQuery = 'update #temp_age set ' + @colnm + ' = convert(varchar,(' + cast(@interval as varchar) + ' * ' + cast(@a as varchar)+ ')) where rec_type = ''title'' ' EXEC(@strQuery) /*update #temp_age set @colnm =...
  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

    ...Say that I write a stored procedures that adds a transaction to your account statement. This procedure needs to update several tables: * the account-statements table. * the current-balances table. * if the transaction is in the past, I must also update historic balances. * the table that...
  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