Search results for query: *

Hi, could someone please advice how I can use VBScript to redirect to another link if the original link is invalid? Here's my issue: <a href="detect_link.asp">GO LINK</a> at "detect_link.asp", I need to have script to detect if the URL is accessible (https://some.secured.site.com/) if the...

Hi, Could someone please help me with a perl script to search & replace a text string such that: $org_str = "C:/root/sub/text/somefile.txt" to become: "C:/root/sub/somefile.html" Basically: "/text/*.txt" will become "/*.html" Much appreciated for your help.

Hello, has anyone had problem with accessing .htaccess protected folder on Windows Vista's IE7 browser? A client reported he didn't get a popup screen asking for Username/Pwd when trying to access an .htaccess protected directory on a website, hence didn't get access to that part of the site...

Hello, Can someone please help me with this problem? Below is my sample code: DECLARE @dynVar1 varchar(2) DECLARE @dynVar2 varchar(2) DECLARE @dynVar3 varchar(2) DECLARE @runSQL varchar(500) DECLARE @myVariable varchar(50) SET @runSQL = ('SELECT @dynVar1=SomeField2, @dynVar2=SomeField2...

Hello, Can someone please tell me what'd be the correct syntax in using: DECLARE @sqlStr varchar, @familyName varchar SET @sqlStr = ('SELECT @familyName=LastName FROM someTable WHERE id=3') EXEC(@sqlStr) When running this, I get error: "Must declare the variable '@familyName'" (even though...

Hello, Can someone please help me with the following script? SELECT DISTINCT RegNumber FROM tblPools WHERE (NOT (RegNumber IS NULL)) FOR EACH RegNumber SELECT poolNumber, COUNT(DISTINCT players) AS numPlayers FROM R_#RegNumber# GROUP BY poolNumber HAVING (poolNumber IN (SELECT...

Hello, At the end of the day, I usually turn off my computer (Win2K Pro) at work. Is there a way to schedule it to boot itself up in the morning? And how can I also do this in WinXP? (I know this is not XP forum) :) Thanks much for your help.

Hello, My pc has been running on Win2K Pro since new, and it has all kind of programs/softwares installed on. I've recently added a new HD, and installed XP Pro on this new drive. And here are my questions: (1) This pc is on a domain. During XP installation, I joined it to the same domain...

Hello, How can I use regular expression to search and replace all text in between the '<script language="javascript">' and '</script>' tags? Here's what I have: function doReplace(myS) { var regExp = /(<script)\/?[^>]+(</script>)/gi; myS = myS.replace(regExp,""); return myS; }...

Hello, Can someone please help me with this question? Here's a sample of the data: clientId orderDate orderQuantity 1 6/15/2004 2000 1 6/14/2004 1500 2 6/16/2004 350 2 6/8/2004 1200 2 6/7/2004 1000 3 6/16/2004 500 3 6/15/2004 1500 4 6/16/2004 1300 4 6/13/2004 500 4...

Hello, I got a syntax error for this query: SELECT custOrder, lastName, firstName FROM custTable WHERE (NOT (lastName IS NULL)) AND custRegion IN (SELECT CASE centerCode WHEN 'A' THEN ('NC','MN','OP') ELSE ('BC','HE','QP','DC') END) ORDER BY lastName The error is at "('NC','MN','OP')" and...

Hi, someone help please: I have 3 tables: "Jan_2004", "Feb_2004", "Mar_2004" They all have similar fields: 'orderId', 'OrderCode', 'Department', 'Language', 'PartOfWorld' And 2 other tables: "OrderLookup" : 'OrderCode', 'Dept' "LangLookup" : 'Language', 'Country' What I want to...

Hello, I need your expert help in creating a db for a Poll Ranking application. The idea is, a school wants to conduct a poll at the end of a schoolyear. There are 20 teachers and 100 classes in total. Each teacher is required to rank these 100 classes. At the end, the poll yields the rank...

Hello, I'm wondering if anyone has ever installed/used VeriSign's Trial SSL cert? I requested & got approved for one. To install, VeriSign request to have a &quot;Test CA Root&quot; installed on each browser that I'll be using in the test. My questions are: - Can I remove this root if I...

Hello, I have about 10 websites running on my IIS on Win2K server. Currently, they're all configured with virtual IP, ie. IP Address = {All Unassigned} This web server has an IP address of its own, say 111.111.111.120. And I have a few other IPs that I currently own & can use, say...

Hello, Can anyone advice if it's possible to insert a record (name + address) into a table where it would search the table first for duplicate 'name' or 'address'? I normally run 2 procedures in which first procedure searching for duplicate. If it's empty, then call 2nd procedure to do the...

Hello, Is it possible at all to retrieve filenames in a folder without using Server.CreateObject(&quot;Scripting.FileSystemObject&quot;)? Any help would be much appreciated. Allan

Hi all, I currently have an NT server that's already had MSSql 2000 installed on. I'd like to install MySql 4 on this same box. Can MSSql 2000 & MySql coexist on the same NT server? And is it a good idea to start with? Are there special settings that I should be aware of? Thanks much.