Recent content by Yiyi

Because the remote host might not trusted host, even running on different OS, so I have to use telnet. And I have done that with expect. Thanks for your valuable advice!

Hi NavinB Thanks for reply. However, remote host might not be the trusted host with localhost each other, evn not on the same OS. That's the problem. Your help is appreciated!

Would somebody tell me how to telnet another box wihtin shell script? Thank you.

I used following script: telnet <IPAddress> <<! <username> <password> ! And I got &quot;Connection closed by foreign host.&quot; Can anyone explain me why? Appreciate for your help

Thank you very much, guys! I used Terry's idea, and it works great! FYI, I am using informix, and they don't support INSTR.

Sorry, let me clarify this question more clearly, for example, I have two tables: table A and B, table A has a column (name: Book) with value formate like &quot;string1/string2/string3&quot; . Then I need to do some join to get some data from table B: select something from A,B when...

Sorry , it is : how do I know how many '/' in the string?

Thanks! th3856. But looks like INSTR doesn't work. I can not excute the SQL statement with INSTR? ANy suggestion? Thanks! By the way, how do I know how '/' in the string. Is there any these function?

I have question about the substring in sql, need help urgent! how to parse a string with format &quot;string1/string2/string3&quot; base on /, so that I can use in where clause like: select ..... from... where field1=string1 field2=string2 field3=string3 Has sql have these function...

Can you do this even if you choose Oracle as your datasource and let's say I choose tables A, B for my report but I need one data from table D wich doesn't have much of a relation with the other two can you give me an example on how I will do it.

Well actually they are the same version Crystal 7 I have it right know in 3 computers, I think it's in a dll U????.DLL but I don't know wich one. What I did was just copy all the dll files from windows\crystal directory to the computer where they are missing and it work. <br><br>I did it on one...

I have just&nbsp;&nbsp;finished a report in one computer where I use Fetch and Stored to pass some data between my main and subreport. But when I took the program to another computer that installation of Crystal doesn't have the Fetch*.* or Stored procedures, does anyone know what DLL is missing...

Hi I am brand new to Crystal Reports (few days) and have a problem. I need a number in my main report wich I get from another database, the only way I have found right know to get this is thru a subreport but know that I have the value there how can I access the number in my main report so I can...