Recent content by JohnPham

Thank DNG, However, I think this is the old style of vbscript or old compiler. I try to migrate the application from window 2000 server to window 2003 server. There a lot script in VB script using like below: <%if CiMatchedRecordCount eq 0%> do somthing <%endif%> We don't have any problem...

Hi All, I have error when run this vbscript in window server 2003. Does anyone know why? Microsoft VBScript compilation error '800a03f9' Expected 'Then' /testing/query.asp, line 19 if CiMatchedRecordCount eq 0 Thank you, John

Thanks Mark-- I will check your suggestion tonight and let you know the result. By the way, this is the server that I installed at home for my learning purpose. As your suggestion, I need to check DNS. What do I need to look into DNS?. Thank you, John

Hi all, I have problem with internet IE problem after install windows server 2003 sp1. The internet really slow when I browse to any web site (take 2-3 minutes to go to any web site). I uninstalled the sp1 and the internet perfomance back up normal and fast. I am not sure what I need to...

Hi All, A friend of mine have a system with windows ME in Japanese version. He brought in here in US and wants to convert to English version. Is there any possible want to do it. He ask me to install the wireless device for him so he is able to hook up in with internet. I don't read the...

Hi All, Anyone has run the exe file use vbscript in server side? I try this but it doesn't work, please advise.. temp = Request.ServerVariables("appl_physical_path") set testExe = server.CreateObject("wscript.shell") testExe.Run "%ComSpec% /c " & temp & " Myprogram.exe" I also try this...

Hi All, I just try escape(initPIN) and it seems to work fine with me. Thanks everyone for help. John

Thanks everyone for input. I will try all the possible cases suggestion above. Thank you, John

Hi, Anyone please help me with this: I try to pass this query string through URL but seem not work for me. If my initial string is: initPIN = &quot;12345#678&quot; when I pass through URL like this: <script language=&quot;javascript&quot;> function Openweb(initFlg){ Myweb =...

Hi Chris, I did try that as well but it shows the error message as '@lastname must be declared' even though I have declared it. John

Thanks James. It works. Thank you very much for this. It helps me a lot. I have tried this whole day yesterday but could not come to any clue for it to work. Big thanks to James. John

Thanks SQLBill. That the reason why I try it does not comes back as the result I need. Thank you for your info. John

Thanks James. This should work with variable @allvalue is just have one value. What if @allvalue have more than one value and dynamic pass from somewhere. That why I have to use 'IN' in the statment. For example: @allvalue = 'Basketball','FootBall','Tennis' Thank you. John

Hi All, Would any one help me with this? Here is the portion of my stores procedure. declare @something varchar(2000) declare @lastname varchar(10) declare @myvalue varchar(10) declare @allvalue varchar(40) set @myvalue = '''john''' set @allvalue = '''Basketball''' Set @something = 'SELECT '...

Sunil/Craig Thank you very much. This help a lot. John