Search results for query: *

How do I send "CTL-B" in expect command

I try to setup a script which will include over 10 sql command. For each sql command, it will run in the backend. e.g. nohup sqlplus uid/pid @fdfdfdfdf & I will like to echo the Process ID. Can anyone tell me how???

Dale Watson Do you have any other suggustion for converting the date without the leading BLANK Thanks Regards Tony

How do I Change DATE Column to TEXT Column? I have a date column with value "02/04/2001". Using workbooks.saveas function to save worksheet as csv, it become "2/4/2001" Best regards

Bryanbayfield, It works fine. THANKS AGAIN I just wander if it will speedup the process if I apply autofilter. Tony

Bryanbayfield, It works fine, but I have an addition request. How do I put a condition in the filling instruction ? For any column C which begin with "BUY" or "SELL", copy Column C value to Column D Thanks in advance

When I run the following instruction, I got the error "Autofilter method of Range class failed" Selection.AutoFill Destination:=Range("G10:G" & lastrowx), Type:=xlFillDefault Range("G10:G35").Select Columns("L:L").Select Selection.Delete...

What I want to do is to duplicate a column E with the same value of column D starting row 10 till the end of the sheet Best regards TC2000

How do I fill up the cell for colume E from row 10 till the end of the sheet? Range("E10").Select Selection.AutoFill Destination:=Range("E10:E100"), Type:=xlFillDefault Best regards

It works, but what is the different btw <cfoutput> and <cfloop>. Any idea why we can't use <cfoutput> inside the <cfmail> tag???? Anyway thanks....

WHAT'S WRONG WITH THE FOLLOWING SOURCE ?? <CFQUERY NAME=&quot;GetQTask&quot; DATASOURCE=&quot;eKong&quot;> Select * from QTask where wStatus ='P' </CFQUERY> <cfmail query=&quot;GetQTask&quot; FROM=&quot;tonychan@algoltec.com&quot; TO=&quot;#GetQTask.EMail#&quot...

Need help I have to create a module which allow the user to input record into the table. How do I show him the last 5 records he's recently input Thanks in advance

Need help I have to create a module which allow the user to input record into the table. How do I show him the last 5 records he's recently insert Thanks in advance

Need help I have to create a module which allow the user to input record into the table. How do I show him the last 5 records he's recently input Thanks in advance

I try to encrypte application.cfm, but it won't work. Can anyone tell me why???? Thanks

tleish Thanks a lot

tleish , It is working now. Thank..... But I have a question ? When are we going to use &quot; #HTMLEDITFormat()# &quot; When I use #HTMLEDITFormat()# I got the WDDX format, but without it, I only got the data without WDDX format structure....

tleish, This is my tv.cfm source : <CFQUERY NAME='q' DATASOURCE='ihkinv'> select CompanyID, MasterInKey, MAWB, HAWB from MasterIn where HAWB <> ' ' </CFQUERY> <cfwddx ACTION='cfml2wddx' input=#q# > Thanks

My source : <cfhttp url='http://www.oecfreight.com/tv.cfm' method='get' resolveurl='no'></cfhttp> <cfoutput>#HTMLEDITFormat(CFHTTP.FileContent)#</cfoutput> <cfwddx action=&quot;WDDX2CFML&quot; input=&quot;#HTMLEDITFormat(CFHTTP.FileContent)#&quot; output=&quot;newq&quot; > and got the...

Hi there, Could anyone tell me how to check the SQL Server to see if there is any deadlocks and how to delete the blocking process? Should I issue the kill command? Thanks Keith