Recent content by snr

Thanks. But it is giving me syntax error at @FS, 'OpenTextFile', @FileID OUT, @FileName, 2, True Please help

Thanks for your reply I checked that , and I observed that if there is data in table 1 from step1 , then it executes step 1 and creates the error file. If it doesn't have data , then it doesn't create the log file. In first case it writes that the task completed succesfully but doesn't do...

Hi, I have a stored procedure where I am executing a dts package : SET @cmdString ='dtsrun /S WEBSRV /E /N Load_textFile ' EXEC master..xp_cmdshell @cmdString,no_output In this DTS package 1) Truncate existing Table 2) Load the text file in the table. The problem is , when executed...

Thanks for the reply. I want to schedule the job , and I don't want vb or any other exe to run on the server. What I wnt to do is ----- 1) Open text file 2) pull out data from various tables by more than 1 queries in loop. 3) write the data to file. 4) close the file I can not divide the...

Hi, I want to create a text file with a complicated format, so it will be very difficult by DTS. Can I open or create file from a stored procedure ? If yes , how ? Please help. Thanks

Hi, I am trying to execute a stored procedure through VB application. If I run the stored procedure through Query Analyser , it takes around 1 min to complete. As I was getting this error, I tried writing con.ConnectionTimeout = 0 con.CommandTimeout = 0 But still its giving...

Hi, I am trying to execute a stored procedure through VB application. If I run the stored procedure through Query Analyser , it takes around 1 min to complete. As I was getting this error, I tried writing con.ConnectionTimeout = 0 con.CommandTimeout = 0 But still its giving...

Thanks a lot Alt255 ! It worked !!!!!!!!!

Hi, I have set HTML Editor as frontpage. But when I open IE6.0 , it gives me disabled EDIT option on toolbar. I don't know what the problem is.... may be registry ... Can anybody tell me what may be the problem , and how to solve that ? Thanks

Thanks link9 ...........It worked !

Using javascript on clientside how to retrieve the value in a text box ? For example , <asp:textbox id =&quot;box1&quot; /> box1 has value &quot;ABC&quot; I want to get this &quot;ABC&quot; using javascript on clientside function. Thanks

Hi , I want to use javascript for some simple client side validations, like if there are 2 textboexes, and if I write in second textbox, & first textbox is null , I want to give alert that first textbox value is null and the focus should be transfered to first textbox. For this I need to...

Hi , I want to use javascript for some simple client side validations, like if there are 2 textboexes, and if I write in second textbox, & first textbox is null , I want to give alert that first textbox value is null and the focus should be transfered to first textbox. For this I need to...

I am populating msflexgrid by a database query ... I tried printing it by following code Printer.Orientation = vbPRORLandscape Picture1.Picture = grid_datasheet.Picture sScale = Printer.ScaleHeight * (grid_datasheet.Rows / 50) Printer.CurrentX = 100 Printer.Font = &quot;Arial&quot...

Try using server.execute(&quot;page.asp&quot;)