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

    DB Connection string

    U have to add: "Provider=SQLOLEDB;" in your string.
  2. smnetto

    SQL Server Job Run Duration

    I forgot, u only need to create function 1 time. So to see the duration use the script create table #tmp_jobs...... to the end OK. Sergio - DBA SQL
  3. smnetto

    SQL Server Job Run Duration

    OK, so u will need to create a user function to get it: CREATE function fn_hex_to_char ( @x varbinary(100), -- binary hex value @l int -- number of bytes ) returns varchar(200) as begin declare @i varbinary(10) declare @digits char(16) set @digits = '0123456789ABCDEF' declare @s...
  4. smnetto

    SQL Server Job Run Duration

    Wow, now i understand (u only want duration for jobs in execution) - OK - Try this: job_state: 0 Returns only those jobs that are not idle or suspended. 1 Executing. 2 Waiting for thread. 3 Between retries. 4 Idle. 5 Suspended. 7 Performing completion actions. So we need status=1...
  5. smnetto

    SQL Server Job Run Duration

    You can get information about jobs (last run date, duration,...) using a query like this: use msdb select * from sysjobs a join sysjobservers b on a.job_id=b.job_id where a.enabled=1 order by last_run_date,last_run_time desc Sergio - DBA SQL
  6. smnetto

    Retreive PK/AK (UNIQUE constraint) fields

    U can get the pk in a table using: sp_pkeys tablename Sergio
  7. smnetto

    Invalid date

    --Supose that @dt is your field in dts: declare @dt varchar(10) set @dt='02/32/2006' --So use a query in DTS like this: select case when isdate(@dt)=1 then @dt else null end Hope this help you. Sergio - DBA SQL
  8. smnetto

    update all rows where id isin comma delimted string

    Common guys, is easier by this way: update table ... set value=@value where id is in (replace(@ids,char(39),'')) hope i help u... Sergio MCP SQL Server
  9. smnetto

    Input type file readonly?

    How to prevent users from typing the filename into the text box of an input type file tag, allowing only the browse button to select the file? Any ideas?
  10. smnetto

    INPUT TYPE FILE READONLY ?

    Hi fengshui_1998, No, i want to know how to disable the textbox of this control, to prevent users from type a invalid filename, or a file that not exists. thanks anyway.
  11. smnetto

    INPUT TYPE FILE READONLY ?

    How to prevent users from typing the filename into the text box of an input type file tag, allowing only the browse button to select the file? Any ideas?
  12. smnetto

    creating empty table using SELECT...INTO

    ...For example, i have a table (tb_users) with a cd_user column. I know that every user has a cd_user code greater than 0, so i can replicate my structure with this transact-sql: select * into tb_users2 from tb_users where cd_user=0 The tb_users 2 will be created with no records. Sergio M. Netto.
  13. smnetto

    I have an iframe called 'a' where I

    Hi, use first the name of the frame, then document, form, object and value. In this case: a.document.b.c.value='xxx'; Sergio.
  14. smnetto

    Problems sending values from child windows to parent windows

    Yes, it happens with some objects. You may use the showModalDialog method passing the form as a argument, example: Parent Window: <html> <head> <SCRIPT Language=&quot;Javascript&quot;> <!-- function myopen(){ var z=showModalDialog('popup.htm' , document.form1 ...
  15. smnetto

    Importing SQL tables from one database to another

    Hi, the SQL Import/Export Data Module (DTS) Data Transformation Services do this very well. Its included in SQL Server. Sergio M. Netto.
  16. smnetto

    manipulating prompt() and alert boxes ?

    Hi, there's no way to do that. You may use the open method to create your own window: open(URL, windowName, windowFeatures) See: http://developer.netscape.com/docs/manuals/communicator/jsref/win1.htm#1152528
  17. smnetto

    Beer on me for help!! Using an image as input for a list on a form

    Hi, INPUT TYPE=IMAGE is the same as INPUT TYPE=SUBMIT, so the page is submited to the same url. Try to use <IMG src=&quot;HdrIconGO.gif&quot; NAME=&quot;point&quot; onClick=&quot;location=document.c809.c748.options[document.c809.c748.selectedIndex].value&quot;> Sergio.
  18. smnetto

    working with session variables

    You can use this: <html> <body> <% session(&quot;xy&quot;)=3 session(&quot;name&quot;)=&quot;john&quot; %> <script language=javascript> var n=<%=session(&quot;xy&quot;)%>; var z='<%=session(&quot;name&quot;)%>'; alert('number='+n+' name='+z); </script> </body> </html> Sergio M. Netto
  19. smnetto

    How to get the maxlength value of a text box

    <form name=form1> <input type=text value=&quot;&quot; name=tb1 maxlenght=30> </form> <script language=javascript> alert(document.form1.tb1.maxlenght); </script> Sergio M. Netto.
  20. smnetto

    href + onlick

    Hi, i think this is what you want: <a href=&quot;javascript:document.location='developRequest.asp?step=5&taskcode='+getTask.taskCode.value;&quot;>Develop request</a> Sergio M. Netto.

Part and Inventory Search

Back
Top